Mobs Spawn Help

[loader8]

who have good query to set Good spawn and respawn in servver cap 110 with 1 GS
or table refnest

[#HB]

Good spawn?

Anyways... I created you query to multiple the monsters spawn.

 Spoiler

USE [SRO_VT_SHARD] -- HB
-- Configuration Beginning
declare      [MENTION=1629512]multiple[/MENTION]Value int = 2 -- Multiple value: 2 = 2x usual spawn | 5 = 5x usual spawn
-- Configuration Ending

UPDATE Tab_RefNest set dwMaxTotalCount = dwMaxTotalCount *      [MENTION=1629512]multiple[/MENTION]Value where dwTacticsID in (select dwTacticsID from Tab_RefTactics where dwObjID in (select ID from _RefObjCommon where CodeName128 like 'MOB_%' and Rarity !=  3 and Rarity != 8)) -- UPDATE while preventing edit on NPCs/Uniques

Note for the copypasting: Replace "MENTION" with "@" and delete "/MENTION", its because of EPVP mentioning system.

[hoangphan7]

Step1: Enter the game with Gm account.
Step2: Command /worldstatus
Step3: See how many mob/npc spawn in bot-right windows
If it < 30 or 35k else do nothing :v
Step4: Increase mob+++
Step5: Go to Step1

Hint: Increase mob spawn in important (popular) place! Skip some place low level (Jangan, West China, Europe, Asia Mirror, CA.. etc) and some mob don't important

[loader8]

Originally Posted by #HB

Good spawn?

Anyways... I created you query to multiple the monsters spawn.

 Spoiler

USE [SRO_VT_SHARD] -- HB
-- Configuration Beginning
declare      [MENTION=1629512]multiple[/MENTION]Value int = 2 -- Multiple value: 2 = 2x usual spawn | 5 = 5x usual spawn
-- Configuration Ending

UPDATE Tab_RefNest set dwMaxTotalCount = dwMaxTotalCount *      [MENTION=1629512]multiple[/MENTION]Value where dwTacticsID in (select dwTacticsID from Tab_RefTactics where dwObjID in (select ID from _RefObjCommon where CodeName128 like 'MOB_%' and Rarity !=  3 and Rarity != 8)) -- UPDATE while preventing edit on NPCs/Uniques

Note for the copypasting: Replace "MENTION" with "@" and delete "/MENTION", its because of EPVP mentioning system.

Originally Posted by hoangphan7

Step1: Enter the game with Gm account.
Step2: Command /worldstatus
Step3: See how many mob/npc spawn in bot-right windows
If it < 30 or 35k else do nothing :v
Step4: Increase mob+++
Step5: Go to Step1

Hint: Increase mob spawn in important (popular) place! Skip some place low level (Jangan, West China, Europe, Asia Mirror, CA.. etc) and some mob don't important

have a query where i can change the spawn per region or per mob

[hoangphan7]

PHP Code:

update Tab_RefNest
set dwmaxtotalcount = 0 -- put number which you want to change
where dwTacticsID in (select dwTacticsID from Tab_RefTactics 
where dwObjID in (select id from _RefObjCommon where CodeName128 like 'MOB_DH%')
) 


[loader8]

Originally Posted by hoangphan7

PHP Code:

update Tab_RefNest
set dwmaxtotalcount = 0 -- put number which you want to change
where dwTacticsID in (select dwTacticsID from Tab_RefTactics 
where dwObjID in (select id from _RefObjCommon where CodeName128 like 'MOB_DH%')
) 


this affect uniques spawn?

[Farewell_]

Originally Posted by loader8

this affect uniques spawn?

As you see, that query increase a specified monsters spawn rate, so no...

Good luck and i hope next question will not be that "Why monsters, pets keep disappearing?"