You can't update all the rows, otherwise you'd double spawn the NPC's in town and even the uniques.
let me give you
Code:
Update Tab_RefNest set dwMaxTotalCount = dwMaxTotalCount*3
where nRegionDBID in (select wRegionID from _RefRegion where ContinentName = 'Oasis_Kingdom') and dwMaxTotalCount > 3
So basically this should update the mobs max total count spawn by 3 based on the region you provide. Didn't really test this but it should work, based on how the tables work.
Oasis_Kingdom = Oasis_Kingdom is Hotan (ALL OF IT)
You can get the region name from _RefRegionBindAssocServer
CHINA = Jangan
TQ = Qin-Shi Tomb (Jangan Cave)
West_China = Downhang
Oasis_Kingdom = Hotan
Thief Village = Thief town
Roc = Roc Mountain
Eu = Constantinople
Am = Asia Minor (Captain Ivy)
Ca = Central Asia (Samarkand)
[Only registered and activated users can see links. Click Here To Register...]
set dwMaxTotalCount = dwMaxTotalCount*3
dwMaxTotalCount = the current spawn rate
*3 = the number it's multiplied by
The update query shouldn't update the lines which have spawn count less than 3, so it should skip the npc's and uniques
Just an advice, it's pretty useless to change the monsters spawn rate in the low level areas, because once the players level up they will be useless.