How to change spawn rates ?

[everlastnmn]

Can anyone inform me how to change spawn rates, such as setting TOV to a 3 hr respawn for example ?

[nilbog]

If you wanted to change the spawn time for *everything* in tov, it would be as simple as an sql query :

update spawn2 set respawntime = 10800 where zone like templeveeshan

respawntime is calculated in seconds

[djeryv]

this may help you...for smaller servers...

Click Here (http://www.projecteq.net/phpBB2/viewtopic.php?t=4678&highlight=)

-Djeryv

[everlastnmn]

And where would you update this code to ? Is there a way to do this through HeidiSQL ?

[trevius]

It is really easy to change them using GeorgeS' NPC Loot Editor. Check his section of the forums for more info.

[Dunmord]

And where would you update this code to ? Is there a way to do this through HeidiSQL ?

Its really simple.
If you are using windows and you did the step-by-step install of MySQL using the guide provided on the wiki, just go to...
1. Start->Menu->(You should see something related to MySQL)MySQL->MySQL Server 5.1(in my case)->MySQL command line client (click on this).

2. A black-command-line window appears asking for your password. You just need to type in the password you gave when doing the MySQL installation.

After that, and if you typed the correct password, you are inside the database manager.

type: use peq; (this is only if you chose the PEQ database) or use ax_classic;(only if you chose Angelox database).

now you can type the UPDATE.... that was posted earlier.