|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc. |
|
|
|
02-27-2008, 04:19 AM
|
Dragon
|
|
Join Date: May 2006
Location: Cincinnati, OH
Posts: 689
|
|
Sleeper's Tomb Warders:
This post will help you to replace the Ancients in Sleeper's Tomb with the Warders, taking it back to a pre-awakening state.
I use the most current PEQ database with a few customizations, this being one of them. I did it by creating fresh NPCIDs for the 4 warders and fresh spell entries. The loot tables, however, were already in place, and just needed their drop rates adjusted. As PEQ's database is updated, the npc_spells and npc_spells_entries may become outdated, as I don't expect them to commit this. Please check any database you attempt to insert this into, and ensure that the IDs for the npc_spells and npc_spells_entries queries are changed to be current.
I won't claim it to be perfect, but figured I'd share it, and to see if there's any interest.
Anyway, code to put them in:
Code:
INSERT INTO npc_types VALUES(128090,'#Nanzata_the_Warder','',70,49,1,30,352000,2,6,6,20,246,0,130,0,600,19528,355,701,'SERFTQMCNIDf',75,0,0,0,0,1,0,0,0,0,1.9,200,200,200,200,200,1,1,0,2326,0,0,-25,0,474,474,474,474,474,474,474,1,0,1,0,1);
INSERT INTO npc_types VALUES(128091,'#Ventani_the_Warder','',70,49,1,30,352000,2,1,1,20,246,0,131,0,601,19528,355,785,'SEFTQMCNIDf',75,0,0,0,0,1,0,0,0,0,1.9,200,200,200,200,200,1,1,0,2326,0,0,-30,0,474,474,474,474,474,474,474,1,0,1,0,1);
INSERT INTO npc_types VALUES(128092,'#Tukaaraak_the_Warder','',70,49,1,30,352000,2,3,3,20,246,0,129,0,602,19528,365,763,'SERTQMCNIDf',75,0,0,0,0,1,0,0,0,0,1.9,200,200,200,200,200,1,1,0,2326,0,0,-30,0,474,474,474,474,474,474,474,1,0,1,0,1);
INSERT INTO npc_types VALUES(128093,'#Hraashna_the_Warder','',70,49,1,30,377000,2,5,5,20,264,0,154,0,603,19528,465,925,'SERTQMCNIDf',75,0,0,0,0,1,0,0,0,0,1.9,200,200,200,200,200,1,1,0,2326,0,0,-30,0,474,474,474,474,474,474,474,1,0,1,0,1);
UPDATE spawnentry SET npcID = 128090 WHERE spawngroupID = 15532;
UPDATE spawnentry SET npcID = 128091 WHERE spawngroupID = 15533;
UPDATE spawnentry SET npcID = 128092 WHERE spawngroupID = 15534;
UPDATE spawnentry SET npcID = 128093 WHERE spawngroupID = 15535;
UPDATE loottable_entries SET probability = 100 WHERE lootdrop_id = 303;
UPDATE loottable_entries SET multiplier = 6 WHERE lootdrop_id = 303;
UPDATE loottable_entries SET probability = 100 WHERE lootdrop_id = 304;
UPDATE loottable_entries SET multiplier = 6 WHERE lootdrop_id = 304;
UPDATE loottable_entries SET probability = 100 WHERE lootdrop_id = 303;
UPDATE loottable_entries SET multiplier = 6 WHERE lootdrop_id = 303;
UPDATE loottable_entries SET probability = 100 WHERE lootdrop_id = 302;
UPDATE loottable_entries SET multiplier = 6 WHERE lootdrop_id = 302;
UPDATE loottable_entries SET probability = 100 WHERE lootdrop_id = 356;
UPDATE loottable_entries SET multiplier = 6 WHERE lootdrop_id = 356;
INSERT INTO npc_spells VALUES (600,'Nanzata the Warder',0,-1,3);
INSERT INTO npc_spells_entries VALUES(3280,600,862,1,1,255,-1,-1,1);
INSERT INTO npc_spells VALUES (601,'Ventani the Warder',0,-1,3);
INSERT INTO npc_spells_entries VALUES(3281,601,845,1,1,255,-1,-1,1);
INSERT INTO npc_spells_entries VALUES(3282,601,840,1,1,255,-1,-1,1);
INSERT INTO npc_spells VALUES (602,'Tukaaraak the Warder',0,-1,3);
INSERT INTO npc_spells_entries VALUES(3283,602,840,1,1,255,-1,-1,1);
INSERT INTO npc_spells VALUES (603,'Hraashna the Warder',0,-1,3);
INSERT INTO npc_spells_entries VALUES(3284,603,838,256,1,255,-1,-1,1);
INSERT INTO npc_spells_entries VALUES(3285,603,2306,8,1,255,-1,-1,1);
And code to take them back out:
Code:
DELETE FROM npc_types WHERE id = 128090;
DELETE FROM npc_types WHERE id = 128091;
DELETE FROM npc_types WHERE id = 128092;
DELETE FROM npc_types WHERE id = 128093;
UPDATE spawnentry SET npcID = 128041 WHERE spawngroupID = 15532;
UPDATE spawnentry SET npcID = 128042 WHERE spawngroupID = 15533;
UPDATE spawnentry SET npcID = 128043 WHERE spawngroupID = 15534;
UPDATE spawnentry SET npcID = 128044 WHERE spawngroupID = 15535;
DELETE FROM npc_spells WHERE id = 600;
DELETE FROM npc_spells WHERE id = 601;
DELETE FROM npc_spells WHERE id = 602;
DELETE FROM npc_spells WHERE id = 603;
DELETE FROM npc_spells_entries WHERE id = 3280;
DELETE FROM npc_spells_entries WHERE id = 3282;
DELETE FROM npc_spells_entries WHERE id = 3283;
DELETE FROM npc_spells_entries WHERE id = 3284;
DELETE FROM npc_spells_entries WHERE id = 3285;
I was kind of lazy and didn't fix their loot tables entirely. They drop 6 items each time, but it's split between 4 primal and 2 of their unique items. The tables were currently in the database with one big conglomerated table, and I left it as such.
My intention in putting them back in was to help support froglok23's work in scripting Kerafyrm's rampage.
I'm open to feedback, and welcome any comments. Thanks, and hopefully someone else gets a kick out of this.
|
|
|
|
|
|
|
02-28-2008, 03:22 AM
|
|
The PEQ Dude
|
|
Join Date: Apr 2003
Location: -
Posts: 1,988
|
|
Actually, one of my todos for quite some time has been getting the Sleeper event working properly. I keep putting it off because to do it right will be a big pain (all of the Skyshrine stuff and such), and I didn't know how many people would be interested in it, really.
But, since there does seem to be an interest, I may start on this. Hell, compared to potimeb this will be cake! I'll merge in the Warders, but they shouldn't replace the Ancients, rather new spawnpoints should be created and the Warders and Ancients will be put on opposite spawn_conditions, that will only switch over once. Likewise, Kerafyrm can be on the same spawn condition. If Warders are up, spawn Sleeping Kerafyrm, Ancients, spawn nothing. That makes it nice and neat, and a single query/command can reset the whole event if need be. The actual spawning stuff is basic that can be done in 5 minutes. It's getting infomation about the aftermath that isn't rumor and then scripting it that will be the pain. I once had a great site that seemed very legit, with SSs and everything but I can't seem to find it, atm :(
|
|
|
|
02-28-2008, 03:50 AM
|
|
The PEQ Dude
|
|
Join Date: Apr 2003
Location: -
Posts: 1,988
|
|
Got the loot sorted out, and the spawn_conditions in. It'll be in the next CVS dump.
|
02-28-2008, 04:03 AM
|
Dragon
|
|
Join Date: May 2006
Location: Cincinnati, OH
Posts: 689
|
|
Well shoot, okay I'm thrilled to have it included, then. I wasn't around for the time you guys were building Velious, I assumed this had all been included and then later pulled out once the warders were farmed out and the Sleeper was awoken.
I'm going to see about working on the other parts of the zone that aren't working as well, like the Master of the Guard encounter. The golems there just all sit tight while you beat him down, which isn't the way it should be.
This is gonna be so neat to have everyone checking this out Thanks! I've been skipping around a lot lately, glad to see you can keep up =P
|
02-28-2008, 04:17 AM
|
|
The PEQ Dude
|
|
Join Date: Apr 2003
Location: -
Posts: 1,988
|
|
Yeah, most of the zone doesn't work properly. There are several mobs missing and the like. It would be cool to get it all up and running. If we wanted to go all out, we could put the whole zone on spawn_conditions, so that we can preserve both the pre_awaken state and also post. Sleeper's is in the state it is now because the zone was built using a post-Kerafyrm capture. Sadly, we have no decent captures from when he was up, but that shouldn't be too big of a deal, I think.
|
02-28-2008, 04:49 AM
|
Dragon
|
|
Join Date: May 2006
Location: Cincinnati, OH
Posts: 689
|
|
Naw, it really shouldn't be. I have a good friend who plays on my server and woke the Sleeper on Zeb, he should be able to point out any major differences. I'll pump him for info when I can, heh.
|
04-02-2008, 11:51 AM
|
Dragon
|
|
Join Date: May 2006
Location: Cincinnati, OH
Posts: 689
|
|
I noticed today that Hraashna and Tukaraak are actually spawning at the same point. I think you got their spawn groups a little mixed up when you put everything in.
I can't view the spawn points in the PEQ PHP viewer, as I'm only signed in as a guest. However, Hrashna should stay where he is, and Tukaraak should be at the spawn group that is near -1073, -2800, -992.
Let me know if there's more information needed. Thank you.
|
04-10-2008, 01:55 AM
|
Hill Giant
|
|
Join Date: Sep 2005
Posts: 114
|
|
with SoF kerafyrm is back in EQ, so Maybe we could finally get some good reads on him before sony removes him again?
|
04-10-2008, 08:35 AM
|
Dragon
|
|
Join Date: May 2006
Location: Cincinnati, OH
Posts: 689
|
|
I don't follow Live; you mean they've put him back to sleep in ST? I saw something awhile ago, I thought, but it was just some shroud/instance run or something that had him in it. What do you mean, exactly?
|
04-10-2008, 08:46 AM
|
|
The PEQ Dude
|
|
Join Date: Apr 2003
Location: -
Posts: 1,988
|
|
No, it's a new version of him, in a new zone so it won't help us much, sadly :(
|
04-10-2008, 09:08 AM
|
Dragon
|
|
Join Date: May 2006
Location: Cincinnati, OH
Posts: 689
|
|
Did you get a chance to check this out, Cave?
|
04-10-2008, 11:11 AM
|
Hill Giant
|
|
Join Date: Sep 2005
Posts: 114
|
|
the original kerafyrm *the sleeper* on live in the day was never suppose to be killed, if someone could compare him now to what we *think* before then it may be possible to come up with a decent solution for the sleeper. Even if it is a sleeper who hits PC's for an upwards of 50k a hit or something.
We all know the original reason he was removed was because of guild abuse which led to him being killed and live servers crashing upon his death.
|
04-20-2008, 11:32 PM
|
Fire Beetle
|
|
Join Date: Apr 2008
Location: California, USA
Posts: 27
|
|
Any update on this? I tried and the columns don't match. I'd love to add warder's back in.
|
04-21-2008, 09:09 AM
|
Dragon
|
|
Join Date: May 2006
Location: Cincinnati, OH
Posts: 689
|
|
If you're using the PEQ database, Cavedude already pulled them in, so there's no need for the code above. It's currently set so that the warders are up, so anyone running the PEQ database is now running a pre-awakening Sleeper's Tomb.
|
04-25-2008, 03:44 AM
|
Fire Beetle
|
|
Join Date: Apr 2008
Location: California, USA
Posts: 27
|
|
I guess I probably need a CVS database...I got the zipped version I needed to source into mysql and have no warders. In fact, I'm confused and don't recognize the "end" of the zone...there is no big room where the warders were.
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 07:59 AM.
|
|
|
|
|
|
|
|
|
|
|
|
|