VSRO - Instance Uniques - No Uniques in HWT/QinShi

[evolex3689]

Hey guys,

I've recently reduced the number of mobs spawning on my gameserver and now I've noticed that there are no unique monsters in holy water temple and jangan cave.
I'm taking a guess and say it has to do with the query I used to reduce the monsters on the gameserver.

Query:

USE SRO_VT_SHARD
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;

If I'd just restore my refnest-table then I'd be having the problems of too much monsters on one gameserver again, so my question:

Is there a way/query to fix those uniques again?
I can't find and fix the uniques manually due to missing descriptions in the refnest-table.

[​Exo]

 Tab_RefNest.dwMaxTotalCount [INT]

So I assume these entries had value 1 and since it's an integer 1/2 = 0.

Check the Nest entry of specific mobs based on their CodeName using this query.

PHP Code:

SELECT Nest.* 
FROM   Tab_RefNest Nest 
       JOIN TAB_RefTactics Tact 
         ON Nest.dwTacticsID = Tact.dwTacticsID 
       JOIN _RefObjCommon Com 
         ON dwObjID = Com.ID 
WHERE  Com.CodeName128 LIKE '%MOB_CODE%' 


[evolex3689]

Originally Posted by ​Exo

 Tab_RefNest.dwMaxTotalCount [INT]

So I assume these entries had value 1 and since it's an integer 1/2 = 0.

Check the Nest entry of specific mobs based on their CodeName using this query.

PHP Code:

SELECT Nest.* 
FROM   Tab_RefNest Nest 
       JOIN TAB_RefTactics Tact 
         ON Nest.dwTacticsID = Tact.dwTacticsID 
       JOIN _RefObjCommon Com 
         ON dwObjID = Com.ID 
WHERE  Com.CodeName128 LIKE '%MOB_CODE%' 


Yeah, that has been the case. Exactly what I was looking for. Thank you mate.

[blapanda]

Just make sure that Medusa has a 0 value as a spawn amount, since the event schedule module does spawn her on fixed periods. Otherwise, you will have 2 medusa bitchfighting each other at the same time.

Same for the wing-guards (north, south, west, east) and the key-mob at the middle afterwards. They have to stay as "0" as well.