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!

[Flare83]

did'nt know if you had ran across this or not CD so ~

Afterlife Awakens Kerafrym

[So_1337]

Run through the script, it's all there =)

The only thing that might not be is the shout from whichever of the four warders is pulled if the other three are dead. But that wouldn't take too much scripting, and may even be in already. Too lazy to check at the moment.

[hayward6]

The shout is there from what I remember... I'll run it again tonight to be sure. They shouted something about how foolish we are and that we don't know what we're doing... something like that.

[Flare83]

I know =) i was mainly looking at what lady vox / naggy shouting etc the sleeper's tomb part is on the money fer sure.

But since i'm running an old ax_classic database i dunno :P

[cavedude]

The misc shouts from outside Skyshrine/Sleepers aren't in yet, but only because I haven't gotten around to getting them in. I also need to fix up Kerafyrm's pathing in Skyshrine. Unless Angelox added the event, it won't be in his DB. It's in the PEQ CVS, and the newest server pack update also contains it. http://projecteq.net/downloads

[Flare83]

Originally Posted by cavedude

The misc shouts from outside Skyshrine/Sleepers aren't in yet, but only because I haven't gotten around to getting them in. I also need to fix up Kerafyrm's pathing in Skyshrine. Unless Angelox added the event, it won't be in his DB. It's in the PEQ CVS, and the newest server pack update also contains it. http://projecteq.net/downloads

Thanks CD, i just ran across the webpage and thought you might be interested in it. =)

[palyer]

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

This no longer seems to work with the updated database. There is no longer a 'timeleft' column in the spawn2 table. After having done the first three queries, Sleeper's Tomb is still spawning as the Kerafyrm's Lair version. Any help would be appreciated, thanks.

[palyer]

cavedude still around?