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

[arabcart]

i tested it
thanks for try
but Uniques not appear
and more problems
so no one Use it

[ahmed_ahmed9889]

yeah i use it and got like u problem :D

[mido1112005]

Update

First post

[arabcart]

Update

First post

in Holy Water Temple NO Uniques

[sladlejrhfpq]

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

Update
Fix unique spawn

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


Original table in attachments

Thank you, solved the bug, but, the B1 Camp 8 Camp 11 Camp 15 uniques are not appearing. I think neither B3, could you make a fix for this too? thanks :)

[nikluetke]

There is also a problem with forgotten world. The doors wont open because only 3 mobs are summoned.

[ModGift]

There is also a problem with forgotten world. The doors wont open because only 3 mobs are summoned.

This is not a solution: (

[sladlejrhfpq]

Fix for Tomb of Quinshi uniques.

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 

[arabcart]

Fix for Tomb of Quinshi uniques.

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 

that's for Jangan Cave or For Holy Water Temple ?
please if not Holy Water can you make query for it ?

[undostres]

Good job ).

[ModGift]

Fix for Tomb of Quinshi uniques.

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 

We need Forgetten World Mobs

[Dragonzee]

FGW mobs, rest uniques still not apper

[sladlejrhfpq]

We need Forgetten World Mobs

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

[nikluetke]

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

tell me where i can find the dwTacticsID belonging to the region/monster and i will fix it. would be a great help

[Kemo]

u can Find in dbo._RefNest .