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

[ModGift]

i dont have time, because of exams, i will try to fix it when i will be free

ohh we r waiting :)

[arabcart]

unique in thief temple not appear :(

[nikluetke]

u can Find in dbo._RefNest .

yes ofc, i mean, how do i now, what region belongs to what area? For example, if i want delete the monster around jg or so, which entrys do i have to change?

[asuradoll]

Thank you very much for post it!!

[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 
OR dwTacticsID NOT BETWEEN 32100 AND 32800
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount=1  
WHERE dwdelaytimemax=21600; 

Forgotten World should work, i didnt test it.

[Dragonzee]

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 
OR dwTacticsID NOT BETWEEN 32100 AND 32800
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount=1  
WHERE dwdelaytimemax=21600; 

Forgotten World should work, i didnt test it.

so in this query .. jangan,pharoh,fgw work ?

not work

[arabcart]

First Thanks All For Idea
all can go to this Topic and All Will Work Fine
[Release]Finally All Area at 1 Machine
All Areas Work Fine
All Unique Normal
Holy Water Temple Work Fine
every thing is ok :D

[Dragonzee]

First Thanks All For Idea
all can go to this Topic and All Will Work Fine
[Release]Finally All Area at 1 Machine
All Areas Work Fine
All Unique Normal
Holy Water Temple Work Fine
every thing is ok :D

Forgotten World not work fine

Envy and 3 main areas mobs not apper ...

[arabcart]

Forgotten World not work fine

Envy and 3 main areas mobs not apper ...

so you can show topic now
i add Pic's from FW to make sure

[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 
OR dwTacticsID NOT BETWEEN 32100 AND 32800
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount=1  
WHERE dwdelaytimemax=21600; 

Forgotten World should work, i didnt test it.

This is not correct, change that "OR" to "AND", like 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; 

[xianzhefeng]

thx it's work
thanks

[Dragonzee]

so there any soloution for Holywater,Red,Black Egger caves?

[ByMaSTeRr]

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

mobs very at

[h3adsh0ts]

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


Original table in attachments

UPDATE Tab_RefNest SET dwMaxTotalCount = dwMaxTotalCount * .50 WHERE dwMaxTotalCount > 1

Wouldn't that be a lot easier? And you wouldn't have to worry about the uniques not working then?

[sladlejrhfpq]

UPDATE Tab_RefNest SET dwMaxTotalCount = dwMaxTotalCount * .50 WHERE dwMaxTotalCount > 1

Wouldn't that be a lot easier? And you wouldn't have to worry about the uniques not working then?

what about the forgotten world?