Increase inactive monster spawn count?

[srothanglong]

I'm having trouble increasing the number of monsters in the castle CHINA,TQ,Oasis_Kingdom

I tried this Query:

 Spoiler

USE SRO_VT_SHARD
update Tab_RefNest
set dwMaxTotalCount = '4',dwDelayTimeMin = '1',dwDelayTimeMax = '1' where dwTacticsID in (select dwTacticsID from Tab_RefTactics
where dwObjID in ( select id from _RefObjCommon
where CodeName128 like 'MOB_CH%' and Rarity = 0 )) and dwDelayTimeMin < 600 AND dwDelayTimeMin != 0 AND dwMaxTotalCount != 1

and this

 Spoiler

DECLARE @ FLOAT = 0.75 /*_#2 = 200%, 1 = 100%, 0.5 = 50%*/

UPDATE TRN
SET TRN.dwMaxTotalCount *= @
FROM Tab_RefNest TRN
JOIN Tab_RefTactics TRT ON TRN.dwTacticsID = TRT.dwTacticsID
JOIN _RefObjCommon ROC ON TRT.dwObjID = ROC.ID
WHERE ROC.CodeName128 LIKE 'MOB%'
AND ROC.Rarity = 0
AND dwDelayTimeMin < 600
AND dwDelayTimeMin != 0
AND dwMaxTotalCount != 1

also no viable results. Please help me to solve this problem. Sorry my english is bad. Thanks.

[OKeks]

I do not think it will work like that. For later mob areas with "higher" spawns, they used maybe more spawn spots, with less mobs and faster respawn. If you want to do the same with the original mobs, you have to add more nest entries for the same mob.

Some example:



For some older mobs I found different hive entries as well.

Maybe you can try the following procedure:
- use an original DB without nest, tactics, hive etc. modifications
- close all areas beside of one e.g. CHINA (reduce objects)
- select one mob, go to a defined location and check the spawns
- from char X/Y and tactics find the next entries around your char
- copy them into txt or excel, modify these entries to half spawn and half amount of mobs
- make a copy of all entries and add new nest IDs x-time
- modify the original DB nest entries to match your excel table
- copy the new entries into nest x-time for double, triple etc. amount of mobs
- check the same spot again

If this is working, you can get another clean nest table and use your 1st query. Maybe use the numbers of any "MOB_SD_" to avoid issues. Then use "SELECT" to copy them into excel, adjust nest IDs and copy them back into nest to create more spawn locations.

Please also remind that JM used some "trick" to increase the numbers of mobs. All mobs Lv101+ are quite large, compared to any low level mob. With larger mobs the screen seems to be "filled" with more mobs. Also Lv101+ mobs are faster and follow you better than low level mobs.

[srothanglong]

Originally Posted by OKeks

I do not think it will work like that. For later mob areas with "higher" spawns, they used maybe more spawn spots, with less mobs and faster respawn. If you want to do the same with the original mobs, you have to add more nest entries for the same mob.

Some example:



For some older mobs I found different hive entries as well.

Maybe you can try the following procedure:
- use an original DB without nest, tactics, hive etc. modifications
- close all areas beside of one e.g. CHINA (reduce objects)
- select one mob, go to a defined location and check the spawns
- from char X/Y and tactics find the next entries around your char
- copy them into txt or excel, modify these entries to half spawn and half amount of mobs
- make a copy of all entries and add new nest IDs x-time
- modify the original DB nest entries to match your excel table
- copy the new entries into nest x-time for double, triple etc. amount of mobs
- check the same spot again

If this is working, you can get another clean nest table and use your 1st query. Maybe use the numbers of any "MOB_SD_" to avoid issues. Then use "SELECT" to copy them into excel, adjust nest IDs and copy them back into nest to create more spawn locations.

Please also remind that JM used some "trick" to increase the numbers of mobs. All mobs Lv101+ are quite large, compared to any low level mob. With larger mobs the screen seems to be "filled" with more mobs. Also Lv101+ mobs are faster and follow you better than low level mobs.

Give me your Discord

[JellyBitz]

I would recommend making some research before adding or removing spawn points.. xSROMap can be pretty good tool for it.

Quick steps:

1. This is a query you can execute to generate an script for xSROMap:
   
   PHP Code:

   USE SRO_VT_SHARD
SELECT CONCAT('> Circle:',roc.CodeName128,'<br>','X:',trn.fLocalPosX,',Y:',trn.fLocalPosZ,',Z:',trn.fLocalPosY,',Region:',trn.nRegionDBID,'<br>','Radius:',ROUND(trn.nRadius*0.1,0)) as 'xSROMap script' FROM Tab_RefNest AS trn
INNER JOIN Tab_RefTactics AS trt ON trn.dwTacticsID = trt.dwTacticsID
INNER JOIN _RefObjCommon AS roc ON trt.dwObjID = roc.ID
WHERE roc.CodeName128 LIKE 'MOB_%' 

2. Having the file script generated, replace a <br> for breaklines and remove double quote symbols. You'll end up having a script like attachment.
3. Go to , open Script Editor, paste all that text over there and click Import.
   
   Note: Be carefull, it may take a while loading all spawn points, I highly recommend add filters to your query adjusting to your necessities)

The attachment is just a sample, it's very likely not the same spawn spots neither spawn radius as original.

[OKeks]

Originally Posted by srothanglong

Give me your Discord

Maybe better ask your questions here. If you receive help on discord nobody else will get the answers and the chat is not achieved for long-term usage.