Spawn increase.

[MrsMir]

Ok since my server is only new it only has Euro features up to now. I've added a EuroCave NPC but the spawns are poor.
I'll i'm getting in search is 1.4 results which is telling me to go to m2server > Envir > mir200 which I done have.
I'm pretty sure its done via SQL now? but im still unsure the tables in mongen. :dunce:
I want to increase spawns until I add new caves etc.
Thanks.

 

[IceMan]

its done in sql table mongen change the fd count to how many u want to spawn

 

[MrsMir]

Is there not an easyer way to increase all mob spawns instead of changing each number 1 at a time? It'll take forever lol.

 

[Zen2]

No there isnt.

 

[ρяєα¢нєя]

You could use an SQL statement to change a few at a time, would make it easier.

SQL Statement:

UPDATE tbl_mongen SET fld_count = (fld_count + <Number>) WHERE fld_mapname = '<Mapname>' AND FLD_NAME NOT LIKE '%<BossName>%'

Replace the below legends:
<Number> = The extra number of mobs you want spawning.
<Mapname> = The map you want to edit the spawns on.

If you want to change the spawns to the whole server take out the "Where" clause. However i would not recommend this as it may over crowd some areas, i'd do it on a map by map basis.

p

 

[NewHope]

You can copy a line out of the SQL database in a text document, then make changes, add more lines, etc. Then just copy and paste it back into the Mongen sql table, so much quicker to do spawns that way.
You just have to use the basic framework thats been copied and pasted from SQL.

 

[Skyline]

Export to excel, and do it that way, then import excel? does that work?

 

[JealY]

Export to .txt and use Ctrl + F - Find and replace. Then import it.

Easiest way I could think of... I'd personally do it via SQL.

EDIT - Infact no, that's stupid, as it would replace every one of those numbers. I did it once because I wanted to change all the NULL's in a txt document to 0 - Probably wont work in this instance.

Use SQL.

 

[GOMEEE]

Do it in excel... heaps load easier

 

[MrsMir]

Ok so I export the WHOLE of the mongen table? Edit it to my liking then import it back in? Just asking so I dont go screw something up.
Better safe then sorry!

 

[noisound]

its well easy doing it thru sql lol..

 

[MrsMir]

I'm totally baffled now... :S Peoples telling me to do it in SQL, Excel & text document. :'(

 

[PackardBell]

I'm totally baffled now... :S Peoples telling me to do it in SQL, Excel & text document. :'(

In SQL Manager go to mir2 tables then
Tools -> SQL Query Analyzer

type this:

UPDATE TBL_MONGEN SET FLD_COUNT = 10

and execute or press F5

" = 10 " u change with the amount of monsters you want

 

[noisound]

just do it in SQL lol , alot simpler mate

 

[12345678]

Do it in SQL lol, takes time but every server has to do it :P

p.s have fun lol

 

[ρяєα¢нєя]

Updated the Query so that you can up the spawns without increasing the spawns of the boss mob:

SQL Statement:

UPDATE tbl_mongen SET fld_count = (fld_count + <Number>) WHERE fld_mapname = '<Mapname>' AND FLD_NAME NOT LIKE '%<BossName>%'

p