[Solved] Query Increase Number of Monsters

[srothanglong]

Hello experts.
I want to ask for a query that increases monster spawn rate but not monster count. My server is loading 48k monsters so I don't want to increase it. Because exceeding 50k servers will error Pet. Now I want to ask a query to increase the spawn on kill.
(Appears immediately after killing but does not increase the number of monsters).
I found out from Google but the queries all increase the monster count. It makes my Database error because Excute too many times returns 0 resolved objects.
Thank you very much.

[Judgelemental]

Originally Posted by srothanglong

Hello experts.
I want to ask for a query that increases monster spawn rate but not monster count. My server is loading 48k monsters so I don't want to increase it. Because exceeding 50k servers will error Pet. Now I want to ask a query to increase the spawn on kill.
(Appears immediately after killing but does not increase the number of monsters).
I found out from Google but the queries all increase the monster count. It makes my Database error because Excute too many times returns 0 resolved objects.
Thank you very much.

Hello!
I achieved something like this a long time ago, however I am not sure about the exact query.
One thing is for sure, though. To achieve your desired results you must look at Tab_RefNest, respectively dwDelayTimeMin and dwDelayTimeMax.
I've got 0 on dwDelayTimeMin and 1 on dwDelayTimeMax.

Not sure if this is the best approach so keep that in mind.

PHP Code:

USE SRO_VT_SHARD

declare   [MENTION=287308]Min[/MENTION]Lv int = 1
declare   [MENTION=301174]maXl[/MENTION]v int = 110
declare   [MENTION=332061]reSpawn[/MENTION]TimeMin int = 0 
declare   [MENTION=332061]reSpawn[/MENTION]TimeMax int = 1 

begin
       --select D.*
       update D set dwDelayTimeMin =   [MENTION=332061]reSpawn[/MENTION]TimeMin, dwDelayTimeMax =   [MENTION=332061]reSpawn[/MENTION]TimeMax
       from _RefObjCommon as A
       inner join _RefObjChar as B on A.Link = B.ID and A.CodeName128 like 'MOB%' and A.Rarity = 0 and B.Lvl between   [MENTION=287308]Min[/MENTION]Lv and   [MENTION=301174]maXl[/MENTION]v
       inner join Tab_RefTactics as C on C.dwObjID = A.ID
       inner join Tab_RefNest as D on D.dwTacticsID = C.dwTacticsID and D.dwDelayTimeMin >= 0
end 


I am not sure if this is the right query so please be careful.

Edit: EPVP ruined the query by adding [MENTION] ...............

[Judgelemental]

I'll upload it in a .txt format and attach it.
If anybody sees something wrong here, feel free to change the query.

[srothanglong]

Originally Posted by Judgelemental

I'll upload it in a .txt format and attach it.
If anybody sees something wrong here, feel free to change the query.

Have you checked it yet?

[Judgelemental]

Originally Posted by srothanglong

Have you checked it yet?

It works for me. I used it a year ago but I tweaked it a little bit.

[lidzy]

Originally Posted by Judgelemental

Hello!
I achieved something like this a long time ago, however I am not sure about the exact query.
One thing is for sure, though. To achieve your desired results you must look at Tab_RefNest, respectively dwDelayTimeMin and dwDelayTimeMax.
I've got 0 on dwDelayTimeMin and 1 on dwDelayTimeMax.

Not sure if this is the best approach so keep that in mind.

PHP Code:

USE SRO_VT_SHARD

declare   [MENTION=287308]Min[/MENTION]Lv int = 1
declare   [MENTION=301174]maXl[/MENTION]v int = 110
declare   [MENTION=332061]reSpawn[/MENTION]TimeMin int = 0 
declare   [MENTION=332061]reSpawn[/MENTION]TimeMax int = 1 

begin
       --select D.*
       update D set dwDelayTimeMin =   [MENTION=332061]reSpawn[/MENTION]TimeMin, dwDelayTimeMax =   [MENTION=332061]reSpawn[/MENTION]TimeMax
       from _RefObjCommon as A
       inner join _RefObjChar as B on A.Link = B.ID and A.CodeName128 like 'MOB%' and A.Rarity = 0 and B.Lvl between   [MENTION=287308]Min[/MENTION]Lv and   [MENTION=301174]maXl[/MENTION]v
       inner join Tab_RefTactics as C on C.dwObjID = A.ID
       inner join Tab_RefNest as D on D.dwTacticsID = C.dwTacticsID and D.dwDelayTimeMin >= 0
end 


I am not sure if this is the right query so please be careful.

Edit: EPVP ruined the query by adding [MENTION] ...............

suggest to use this query it works perfectly

[srothanglong]

Originally Posted by lidzy

suggest to use this query it works perfectly

Thank you! Have you checked it already?

[lidzy]

Originally Posted by srothanglong

Thank you! Have you checked it already?

yes but you have to be carefully take a backup before change anything
and depend on how many GS will working on so you can increase/decrease monsters easly

[srothanglong]

Originally Posted by lidzy

yes but you have to be carefully take a backup before change anything
and depend on how many GS will working on so you can increase/decrease monsters easly

Is not! I don't need to increase the number of spawned monsters. I just need to increase its appearance.

[lidzy]

Originally Posted by srothanglong

Is not! I don't need to increase the number of spawned monsters. I just need to increase its appearance.

you can set it from this query also
this query increase/decrease

[qhuongli]

SET TRN.dwMaxTotalCount *