repopping fear

[Aradorn]

say ive killed all the fietid fiends in fear how do i repop them. the #repop command wont, cause they are on the week or what ever timer eq is on for a planar repop. ive completely closed out my server and restarted that didnt work. is there a command that will reset it like when eq would patch and it resets the dragon/plane spawns?

[killhand]

Hello , im not at home and cant check it right now but if im not wrong you can connect to your mysql database and run this query:

UPDATE INTO npctypes SET timeleft=0

then do a #repop in your EQ client.

[Aradorn]

where do i enter this in mysql

[mrea]

Open up the command prompt and navigate to the bin directory of your MySQL installation, usually C:\mysql\bin on a Windows system.

Now, type in mysql -u root [your database name]. Obviously fill in your database name and when typing DO NOT INCLUDE THE BRACKETS. Then, type in UPDATE INTO npctypes SET timeleft=0

[Aradorn]

i typed this

C:\mysql\bin
mysql -u root
use eq;
UPDATE INTO npctypes SET timeleft=0;

i get a syntax error when i do the update part

[mystic414]

that's because npc_types isn't the right table. It's one of the spawn-related tables, but i don't remember which off-hand. It may be spawn2, so you could try that instead.

[mystic414]

It is spawn2. So your code is:

UPDATE spawn2 SET timeleft=0;And that will reset spawn timers for the entire server, not just Fear, if that makes a difference for you.

[Aradorn]

makes no diff to me thanks