The Sleeper`

[hayward6]

On my server last night two of us went to Sleepers Tomb and woke Kerafyrm. I was pleasantly surprised at how well it all worked with pathing and all, and I have a question... Is that the end of her on my server now? Do I need to do anything to make her able to spawn again, or is it just a matter of time. I haven't gone through all the spawn deatils yet, but I don't want it to be a one time deal.

Thank you,

[So_1337]

This would be more properly fielded by Cavedude, as that script is his baby =)

Open your database and check the spawn_condition table. Make sure that the 'value' field for the Warders row is set to 1, and that the value field for the Ancients row is set to 0. That should reset it.

'sleeper', 1, 1, 2, 'Warders'
'sleeper', 2, 0, 2, 'Ancients'

[hayward6]

Perfect! thank you very much

[cavedude]

I'm glad you enjoyed it. Keep in mind it isn't totally done, I still have to work on the pathing in Skyshrine a bit, as well as some of the other misc shouts, but for the most part it's functional. Here are all the queries you need to totally reset the event (there is also a global that needs to be deleted)

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';

[hayward6]

Excellant! thanks a lot

[Richardo]

CD is the man!