View Single Post
  #3  
Old 08-20-2012, 06:45 PM
Tabasco's Avatar
Tabasco
Discordant
 
Join Date: Sep 2009
Posts: 270
Default

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

Code:
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
Code:
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.
Reply With Quote