Priest of Discord fixes for PEQ Kunark DB

[Dvinn]

I've been using the PEQ_Kunark_RC1 database. I was getting tired of looking at all the Priests of Discord standing around in chain helmets and not wielding their staves most of the time. I decided to make some adjustments which I decided to share here for anyone else who might be interested.

These MySQL queries will get rid of the chain helm look, make the PoDs always spawn with both the staff and the robe (Do they do this on Live? I don't even remember anymore, but as I recall they always seemed to be holding the staff in-hand at the very least), and remove some stuff that's orphaned by these changes (after these changes, all of the PoDs use the same loot table).

Enjoy or don't as you see fit.

#
# Priest of Discord Fixes
# Intended for use with the PEQ_Kunark_RC1 Database
#
# Provided by Fabled Dvinn (fableddvinn@yahoo.com)
#


# Remove the now-obsolete PoD loot information

DELETE FROM lootdrop WHERE id=16869;
DELETE FROM lootdrop WHERE id=16873;
DELETE FROM lootdrop WHERE id=16877;
DELETE FROM lootdrop WHERE id=16881;
DELETE FROM lootdrop WHERE id=16885;
DELETE FROM lootdrop WHERE id=16889;
DELETE FROM lootdrop WHERE id=16893;
DELETE FROM lootdrop WHERE id=16897;
DELETE FROM lootdrop WHERE id=16901;
DELETE FROM lootdrop WHERE id=16905;
DELETE FROM lootdrop WHERE id=16909;
DELETE FROM lootdrop WHERE id=16913;
DELETE FROM lootdrop WHERE id=16917;
DELETE FROM lootdrop WHERE id=16921;
DELETE FROM lootdrop WHERE id=16925;
DELETE FROM lootdrop_entries WHERE lootdrop_id=16869;
DELETE FROM lootdrop_entries WHERE lootdrop_id=16873;
DELETE FROM lootdrop_entries WHERE lootdrop_id=16877;
DELETE FROM lootdrop_entries WHERE lootdrop_id=16881;
DELETE FROM lootdrop_entries WHERE lootdrop_id=16885;
DELETE FROM lootdrop_entries WHERE lootdrop_id=16889;
DELETE FROM lootdrop_entries WHERE lootdrop_id=16893;
DELETE FROM lootdrop_entries WHERE lootdrop_id=16897;
DELETE FROM lootdrop_entries WHERE lootdrop_id=16901;
DELETE FROM lootdrop_entries WHERE lootdrop_id=16905;
DELETE FROM lootdrop_entries WHERE lootdrop_id=16909;
DELETE FROM lootdrop_entries WHERE lootdrop_id=16913;
DELETE FROM lootdrop_entries WHERE lootdrop_id=16917;
DELETE FROM lootdrop_entries WHERE lootdrop_id=16921;
DELETE FROM lootdrop_entries WHERE lootdrop_id=16925;
DELETE FROM loottable WHERE name="Priest_of_Discord";
DELETE FROM loottable_entries WHERE loottable_id=4218;
DELETE FROM loottable_entries WHERE loottable_id=4219;
DELETE FROM loottable_entries WHERE loottable_id=4220;
DELETE FROM loottable_entries WHERE loottable_id=4221;
DELETE FROM loottable_entries WHERE loottable_id=4222;
DELETE FROM loottable_entries WHERE loottable_id=4223;
DELETE FROM loottable_entries WHERE loottable_id=4224;
DELETE FROM loottable_entries WHERE loottable_id=4225;
DELETE FROM loottable_entries WHERE loottable_id=4226;
DELETE FROM loottable_entries WHERE loottable_id=4227;
DELETE FROM loottable_entries WHERE loottable_id=4228;
DELETE FROM loottable_entries WHERE loottable_id=4229;
DELETE FROM loottable_entries WHERE loottable_id=4230;
DELETE FROM loottable_entries WHERE loottable_id=4231;
DELETE FROM loottable_entries WHERE loottable_id=4232;

# Provide the new PoD loot information

INSERT INTO lootdrop (id, name) VALUES("16869", "4218_Priest_Of_Discord_Wear");
INSERT INTO lootdrop (id, name) VALUES("16873", "4218_Priest_Of_Discord_Misc");
INSERT INTO lootdrop_entries (lootdrop_id, item_id, item_charges, equip_item, chance) VALUES("16869", "10175", "1", "1", "100");
INSERT INTO lootdrop_entries (lootdrop_id, item_id, item_charges, equip_item, chance) VALUES("16873", "11028", "1", "1", "100");
INSERT INTO loottable (id, name, mincash, maxcash, avgcoin) VALUES("4218", "Priest_Of_Discord", "1960", "12976", "0");
INSERT INTO loottable_entries (loottable_id, lootdrop_id, multiplier, probability) VALUES("4218", "16869", "1", "100");
INSERT INTO loottable_entries (loottable_id, lootdrop_id, multiplier, probability) VALUES("4218", "16873", "1", "100");

# Switch all PoDs over to this single new loot set-up

UPDATE npc_types SET loottable_id=4218 WHERE name="Priest_of_Discord";

# Remove the chain helm look

UPDATE npc_types SET helmtexture=0 WHERE name="Priest_of_Discord";