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

[shanxi]

Holy jeebies thats snappy! I would ask how to set that all up to run automatically but that'd be too bold ;) It wont take very long to enter that in by hand but I was just able to finally log into my server with mobs and the first thing i saw was a PoD that looked WRONG! lol. Thanks for the fix!

[Dvinn]

I would ask how to set that all up to run automatically but that'd be too bold ;)

Quite a subtle hint there ;). Here's how you can set it up nice and easy...

- Highlight the text in the "Code:" section of the post. Hit Ctrl-C (or whatever your browser or OS uses to copy text).

- Crack open Notepad (or some other text editor if you're not on a Windows machine).

- Paste the text into your text editor (Ctrl-V if you're using Windows and Notepad).

- Save it into your mysql\bin folder as "podfixes.sql" or something similar.

- Run mysql.exe

- Tell mysql which database to use (i.e. "use eq;")

- In mysql, type "source podfixes.sql;" and hit [ENTER].

- Rejoice as your Priests of Discord are fixed :)

[mrea]

Didn't even notice this really but thanks Dvinn :)

[Dvinn]

Glad people don't hate it :).

Here's a little something else, though not something EQLive-like. This'll make your PoDs able to walk from his spawn spot should the need arise (i.e. to chase pesky players :P).


UPDATE npc_types SET walkspeed=0.67 WHERE name="Priest_of_Discord";
UPDATE npc_types SET runspeed=1.25 WHERE name="Priest_of_Discord";



If you decide you don't like that, this'll undo it:


UPDATE npc_types SET walkspeed=0 WHERE name="Priest_of_Discord";
UPDATE npc_types SET runspeed=0 WHERE name="Priest_of_Discord";

[shanxi]

omg wow that was nifty. I zapped that in there in like .02 seconds. I beleive that little lesson right there will help me a lot in the future =P

Feed a man a fish and he eats for a day; Teach a man to fish and he eats for a lifetime.

[Toony]

Sorry for necroing but, is this still a valid means of resetting the Priest of Discord's back to their old look on a new PEQ db?