[REQUEST] i need Query

07/15/2012 04:01 SunSoon#1

Hey.. i am searching for query to make less mob spawn :S

07/15/2012 11:36 TheDarkness-[GM]Free#2

Use this Query to reduce mobs numbers in Refnest
Code:

PHP Code:


			


USE [SRO_VT_SHARD]

GO

update Tab_RefNest Set dwMaxTotalCount = 4 where dwMaxTotalCount >= 5 and dwMaxTotalCount <= 10

update Tab_RefNest Set dwMaxTotalCount = 4 where dwMaxTotalCount >= 10 and dwMaxTotalCount <= 15

update Tab_RefNest Set dwMaxTotalCount = 4 where dwMaxTotalCount >= 15

Set the values as you want