[HELP] query less Spawn Mobs Without make Spawn Unique Bugged

[paltalkadel]

i need the query of less spawn mobs but without to make my unique spawn bugged
i had it before
but i lost it cuz i left :P sro for awhile
so anyone got this query

[MentaL]

[arabianfox]

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 

and if unique spawn bugged use this to fix it again:[Just in case]

Fix unique spawn ( Tiger girl - Uruchi - Isy - Lord Yarkan )
*************************************************************
USE [SRO_VT_SHARD]
GO
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = 1  where dwdelaytimemax = '21600' ;


Fix Qin-Shi Tomb uniques
***************************
USE SRO_VT_SHARD
--B1
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32100 --B1 Unique
--B2
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32200 --Camp 8 Unique
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32300 --Camp 11 Unique
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32400 --Camp 11 Unique
--B3
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32500
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32600
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32700
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32800 

[paltalkadel]

Osama FTW :P

[antoha]

how about 101-110 fgw does it reduces the mobs there too?

[Caipi]

Declare @x int = 2; --> Spawnamount/2

UPDATE Tab_RefNest 
SET dwMaxTotalCount = CASE
                        WHEN ROUND(CONVERT(FLOAT,dwMaxTotalCount)/CONVERT(FLOAT,@x),0) < 1 THEN 1 
                        ELSE ROUND(CONVERT(FLOAT,dwMaxTotalCount)/CONVERT(FLOAT,@x),0)
                        END 

Always > 0 <-- :)

[paltalkadel]

Declare @x int = 2; --> Spawnamount/2

UPDATE Tab_RefNest 
SET dwMaxTotalCount = CASE
                        WHEN ROUND(CONVERT(FLOAT,dwMaxTotalCount)/CONVERT(FLOAT,@x),0) < 1 THEN 1 
                        ELSE ROUND(CONVERT(FLOAT,dwMaxTotalCount)/CONVERT(FLOAT,@x),0)
                        END 

Always > 0 <-- :)

Msg 139, Level 15, State 1, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Line 5
Must declare the scalar variable "@x".

[Caipi]

Well probably you're using SQL'05 cause it worked pretty well in SQL'08

Then simply:

Declare @x int; 
SET @x = 2 --> Spawnamount/2

UPDATE Tab_RefNest 
SET dwMaxTotalCount = CASE
                        WHEN ROUND(CONVERT(FLOAT,dwMaxTotalCount)/CONVERT(FLOAT,@x),0) < 1 THEN 1 
                        ELSE ROUND(CONVERT(FLOAT,dwMaxTotalCount)/CONVERT(FLOAT,@x),0)
                        END