I Need to make faster respawns on my server

[dew1960]

Searched 'spawn time' & 'respawn time' but I either get too many results or not enough. I am trying to find the Database field or variable for respawn timers.

I would like to globally decrease respawn times to make mobs spawn faster. Is there a varialbe or ruleset I can edit for that or maybe a sql query I can run to globally reduce respawn times?

Thanks for the help if you know the answer. Mostly, you folks are awesome!

[Maze_EQ]

UPDATE spawn2 SET respawntime = X

replace x with any number and that will be your spawn time(in seconds)

UPDATE spawn2 SET respawntime = '*.5'

That will cut all respawns in half.

UPDATE spawn2 SET respawntime = * .5 WHERE respawntime >= X

That will half any spawntime greater, or equal to X, it's all in seconds.

[Tabasco]

The table you're looking for is spawn2, fields are respawntime and variance. Values are in seconds.


UPDATE spawn2 SET respawntime = respawntime/2, variance = variance/2 WHERE respawntime > 1200


That would cut spawn times in half globally unless they are less than 20 minutes. For most purposes you probably don't want a spawn time to fall under 10 minutes.

In that past I've ran simple queries to cap spawn times, like

UPDATE spawn2 SET respawntime = 14400, variance = 2400 WHERE respawntime > 14400

This would effectively set a max spawn time of 4 hours.

Of course, using pop lyrics in your sig makes me want to suggest DROP TABLE spawn2.

[dew1960]

Awesome! Thank you very much. :)

LOL, what would dropping that table do?

[Tabasco]

That would remove the spawn2 table, rendering your server about as functional as if you actually tried to run this:


UPDATE spawn2 SET respawntime = '*.5'

[Maze_EQ]

Guess my syntax was incorrect, my apologies.

[Mariomario]

The only thing I can do is just laugh at this thread...well done.

Within GeorgeS NPC editor you can adjust spawn timers based on zone as well. Just go into Grid_SpawnGroup_Tools and then Spawngroup Editor. It can search for NPCs based on ID or zone, or by using the ALL function with a particular zone shortname.

For editing your ENTIRE server just do like Tabasco suggested. You really dont want respawn times to fall under 10 mins. Just remember the respawntime variable is expressed in seconds.

For my server as an example I wanted everything with over 1 day spawn to have a 3 hour timer, so I used:

UPDATE spawn2 SET respawntime = 10800 WHERE respawntime > 86400;

Everything with between 1 hour and 1 day to have a 1 hour spawntimer:

UPDATE spawn2 SET respawntime = 3600 WHERE respawntime <= 86400 AND respawntime > 3600;

Again you can manipulate those to your liking.

[Tabasco]

Don't forget variance. On some of the longer spawns it can be significant.

[Caryatis2]

UPDATE spawn2 SET respawntime = 10800 WHERE respawntime > 86400;

Everything with between 1 hour and 1 day to have a 1 hour spawntimer:

UPDATE spawn2 SET respawntime = 3600 WHERE respawntime < 86400 AND respawntime > 3600;

Hopefully you didnt do it in that order, otherwise everything ends up being 1 hour.

[Maze_EQ]

You're right, I did forget to add in variance in the query, again, my apologies.

[Mariomario]

No I hadn't. I was just giving them as examples.

Yeah I did forget to add in variance. It does effect the longer spawns in a way that you get that random over under feeling, rather than just knowing exactly how long until it respawns. But on a server where the population isnt really steep and over "camping" a mob doesn't really exist I didn't feel much need for it personally.

[Caryatis2]

I believe Tabasco's point was that if you were expecting all spawn times to end up at an hour(for example), if you didn't also adjust the variance(since its set in a stock DB) you would find some mobs taking way longer to respawn.

[Tabasco]

Edit: That's twice today that I've gotten side-tracked mid post. That's exactly what I was getting at, thanks.

-------------
If you don't want variance set it to 0 across the board. My point is that if you just modify respawntime you'll have shortened spawn times with potentially excessive variance.

For perspective, the variance on Nagafen is around 5 hours.

[Portal63]

Going to thread necro this with an observation that may be incorrect, but seems plausible.

If you want to change the repop time of NPCs, make sure you don't reduce the spawn times of any spawn with a value of 999999. These appear to be event spawned NPCs (time, fire, earth, etc.).

I don't think it will hurt anything to spawn them, but if you then triggered the event that normally spawns them, you'd probably have duplicate spawns running about.