Editing Spawn Times Help Please

[Surface01]

I'm running the Curent PEQ database and use Navicate for my DB editing but for the life of me I cant find anything regarding spawn times. Ideally I would like to be able to change a whole zone at once but mob by mob would be ok to. Any help is greatly appriciated.

[ChaosSlayer]

yeah i been wonderign same thign as well.
I found a very old tutorial going all way to 2005 but it seem no longer work with recent versions of emulator

look here - if you get this working let me know =)

http://eqemulator.net/forums/showthread.php?t=18171


here is also recent thread about same thing, which also produced no result.
http://www.eqemulator.net/forums/showthread.php?t=22698&page=1&pp=15

[Darkonig]

Respawn time is found in the table spawn2. This table specifies one or more instances of a spawngroupid. Change the column respawntime to be the number of seconds before respawning for this instance of the spawngroup.

examples:
Update spawn2 set respawntime = 300 where id = 2800
would set the respawn time for the instance 2800 to be 5 minutes

Update spawn2 set respawntime = 300 where zone like 'tox'
would set respawn time for all spawngroups in the zone with name tox to 5 minutes

[ChaosSlayer]

i prabobly misunderstood the original poster - i was thnking about making things like specific time of day only spawns

[Surface01]

Thanks for the awesome help.

I have gotten better at MYSQL (7)!!

I used

UPDATE `spawn2` SET `respawntime`=1400 WHERE `zone`=zoneshortname;

That seemed to do it as a quick fix for everything. I'll go back and fine tune things as I need to.




Check out my new server sometime.

Surface 24/7 Custom Quests PEQ DB 2xEXP and great fun!

[techguy84]

Gratz there Surface. Glad to see your figuring it out and then posting your findings back on here. I am thinking about working a section devoted to some simple MySQL commands in my guide. Once I learn a little that is, but it doesnt seem hard to pick up, just tedious simplistic things.