I have changed the spawn time for some NPCs on the leveling road i have done. I've used the below to change one NPC and it doesnt seem to work
Code:
UPDATE `creature` SET `spawntimesecs` = 'Respawn time here' WHERE `id` = entry id here ;
I have checked on HeidiSQL > world > creature and it shows the spawntimesecs as 30, which i changed it to
However when i jump on WoW, go to the NPC .npc info it shows Spawn Time : Full:30s Remain:0s
but when i kill the NPC it changes to it shows Spawn Time : Full:0s Remain:5m 25s
I have cleared my cache and restarted authserver and worldserver, restarted the server which they are running on. have i done something wrong?
the 2 entries which i put in are
Code:
UPDATE `creature` SET `spawntimesecs` = '30' WHERE `id` = '4512' ;
and
Code:
UPDATE `creature` SET `spawntimesecs` = '30' WHERE `id` = 4512 ;
without quotations on the ID