A query for changing the respawn time on npcs

[chronic7]

I need a query so I can easily change the respawn time on a lot of different trash mobs in older pre-bc instances.

The query just needs to change # of the respawn time and thats it.
+Rep For the help

[Juicyz]

Go into the DB and change it then restart server or use ADE (ascent database editor) it will help change the times to what ever you like

[Lich King]

Ya, just use ADE and choose the NPC that you want to change the respawn time of, and then change it and click update

[chronic7]

Well I was planning on doing a LOT of npcs..

a query would be much faster to edit.

[Lich King]

Well, to make an sql for the respawn time change, you would need to tell us all of the npc info, or which npcs they are so we don't screw up the info. But, if you tell me the NPCs you want to change the respawn time of, I can make an sql for you

[chronic7]

I just need the one line
You can put like XXXX for the place where I would put the id of the npc.

I know how to copy and paste

[Juicyz]

what would u like the spawn time to be???maybe ill do it

[Lich King]

Ok, I got it here you go

UPDATE `creature_proto` SET `respawntime` = 'Respawn time here' WHERE `entry` = entry id here LIMIT 1;

[Lich King]

Chronic you there? I posted an answer

[chronic7]

Thanks man, +rep!

[Lich King]

No problem, always glad to help