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.
|
Threaded Mode
