Swiftsong_Lorekeeper
08-28-2010, 01:45 PM
I'm trying to figure out how to reset the sleeper spawn back to normal (where she has not been awoken) but have had no luck. I followed cavedude's instructions:
update spawn_conditions set value = 1 where id = 1 and zone = 'sleeper';
update spawn_conditions set value = 0 where id = 2 and zone = 'sleeper';
delete from quest_globals where name = 'kerafyrm';
update spawn2 set timeleft = 0 where zone = 'sleeper';
In my database all of the variables were already set to the correct values with the exception of the spawn2 row. I do not have any row in my database in spawn2 for zone sleeper. Do I need to create a new one and input the information? Also in spawn2 there is no "timeleft" column. I'm confused on the last step. If I have taken the correct steps, is there a certain command in game that I need to use to reset the spawn? I have tried to #dbspawn her inside the dome and then #repop but she just disappears and the ancients repop.
update spawn_conditions set value = 1 where id = 1 and zone = 'sleeper';
update spawn_conditions set value = 0 where id = 2 and zone = 'sleeper';
delete from quest_globals where name = 'kerafyrm';
update spawn2 set timeleft = 0 where zone = 'sleeper';
In my database all of the variables were already set to the correct values with the exception of the spawn2 row. I do not have any row in my database in spawn2 for zone sleeper. Do I need to create a new one and input the information? Also in spawn2 there is no "timeleft" column. I'm confused on the last step. If I have taken the correct steps, is there a certain command in game that I need to use to reset the spawn? I have tried to #dbspawn her inside the dome and then #repop but she just disappears and the ancients repop.