EQEmulator Forums - The Sleeper`

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - The Sleeper` (https://www.eqemulator.org/forums/showthread.php?t=25904)

hayward6

08-08-2008 02:45 PM

The Sleeper`

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

08-08-2008 03:07 PM

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.

Code:

'sleeper', 1, 1, 2, 'Warders'

'sleeper', 2, 0, 2, 'Ancients'

hayward6

08-08-2008 03:24 PM

Perfect! thank you very much

cavedude

08-08-2008 10:50 PM

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)

Code:

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

08-09-2008 11:31 AM

Excellant! thanks a lot

Richardo

08-09-2008 08:54 PM

CD is the man! :)

Flare83

08-19-2008 09:56 AM

for cavedude

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

Afterlife Awakens Kerafrym

So_1337

08-19-2008 10:01 AM

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

08-19-2008 10:16 AM

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

08-19-2008 10:41 AM

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

08-19-2008 11:13 AM

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

08-19-2008 11:16 AM

Quote:

Originally Posted by cavedude (Post 154486)

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

palyer

10-03-2010 04:45 PM

Code:

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

10-25-2010 01:08 AM

cavedude still around?

All times are GMT -4. The time now is 08:53 PM.