The sleeper
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. |
I know this is an extremely delayed response, but here is how you repop sleeper on your server:
Go into your spawn_condition_values section of your server and look for "sleeper" using the find feature (Ctrl-F). If sleeper has been awakened, then one of the "sleeper" entries should have a 0 for a value. Change that 0 to a 1, save, and restart your server. |
Here is an easier way to do it. Save this as a SQL file and execute it. This will respawn The Final Arbitrator, the four warders, and reset Kerafyrm to a "sleeper" state.
update spawn_conditions set value = 1 where id = 1 and zone = 'sleeper'; update spawn_conditions set value = 0 where id = 2 and zone = 'sleeper'; update spawn_condition_values set value = 1 where id = 1 and zone = 'sleeper'; update spawn_condition_values set value = 0 where id = 2 and zone = 'sleeper'; delete from respawn_times where id = '25250'; delete from respawn_times where id = '58546'; delete from respawn_times where id = '58547'; delete from respawn_times where id = '58548'; delete from respawn_times where id = '58549'; delete from quest_globals where name = 'kerafyrm'; |
All times are GMT -4. The time now is 10:49 AM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.