Increase inactive monster spawn count?

08/04/2021 21:51 srothanglong#1
I'm having trouble increasing the number of monsters in the castle CHINA,TQ,Oasis_Kingdom

I tried this Query:

and this


also no viable results. Please help me to solve this problem. Sorry my english is bad. Thanks. :rtfm:
08/04/2021 23:30 OKeks#2
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:
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]

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.

[Only registered and activated users can see links. Click Here To Register...]
08/05/2021 08:18 srothanglong#3
Quote:
Originally Posted by OKeks View Post
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:
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]

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.

[Only registered and activated users can see links. Click Here To Register...]
Give me your Discord
08/06/2021 08:19 JellyBitz#4
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 [Only registered and activated users can see links. Click Here To Register...], 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.
08/06/2021 16:58 OKeks#5
Quote:
Originally Posted by srothanglong View Post
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.