I Need to make faster respawns on my server

[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.