Mobs Spawn Help

08/11/2018 17:57 loader8#1

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

08/11/2018 20:47 #HB#2

Good spawn? :thinking:

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

08/11/2018 21:04 hoangphan7#3

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

08/13/2018 02:45 loader8#4

Quote:
Originally Posted by #HB
Good spawn? :thinking:

Anyways... I created you query to multiple the monsters spawn.
Spoiler
Code:
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.

Quote:

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

08/13/2018 12:33 hoangphan7#5

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%')

)

08/13/2018 17:43 loader8#6

Quote:

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?

08/20/2018 14:22 Farewell_#7

Quote:

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?" :p