[Fix] Small query for 1 game server with all regions

[mido1112005]

USE [SRO_VT_SHARD]
GO
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = dwmaxtotalcount/2 

Update
Fix unique spawn ( Tiger girl - Uruchi - Isy - Lord Yarkan )

USE [SRO_VT_SHARD]
GO
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = 1  where dwdelaytimemax = '21600' ; 

use this query after old query to fix unique spawn

Fix Qin-Shi Tomb uniques by sladlejrhfpq

USE SRO_VT_SHARD_INIT
--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 

Update by sladlejrhfpq

Restore your TAB_RefNest table, and try this:

USE SRO_VT_SHARD_INIT
UPDATE Tab_RefNest SET dwmaxtotalcount=dwmaxtotalcount/2 
WHERE dwTacticsID NOT BETWEEN 41000 AND 43860 
AND dwTacticsID NOT BETWEEN 32100 AND 32800
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount=1  
WHERE dwdelaytimemax=21600;  ; 

Forgotten World should work, i didnt test it.

Original table in attachments

[MentaL]

[Kemo]

are u Sure about this Query.So 1 machine can't handle all areas if u open all areas u will got crash on GameServer and the mobs will disappeared .

[mido1112005]

this query reduce the number of monsters
so 1 gameserver can handle all areas

[saxz]

and if i want to back to normal?
what query i will use?

[seryi]

*2 maybe :)

[Jamesro]

Simply replace the "/" by "*" ...

[saxz]

yeah replace i know
but what number(it not 2 )
tested already

[seryi]

if value is 1, it will remain 1 after this query as long column is set to int.

[saxz]

so lol
what's the number
i tried 1
but it didnt back to normal

[mido1112005]

so lol
what's the number
i tried 1
but it didnt back to normal

original table in attachments 1st post

[ahmed_ahmed9889]

thx its work

but anyone got problem with this fix?

[Larkon]

if u did /2 than u do *2 lol

[NoNStop]

if u did /2 than u do *2 lol

not really, if the value is 1 already, /2 won't affect it, so *2 will double it, it should be UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = dwmaxtotalcount * 2 where dwmaxtotalcount > 1

[ModGift]

Some unique not appeard and fgw don't work.

[ahmed_ahmed9889]

Some unique not appeard and fgw don't work.

ur sure???

after i open game

not found any unique like lord tiger girl

:(

that shit

any one can fix that to make all maps work at 1 gameserver?!!!