Going through and thought some people might be interested in this, so dropping it here.
Drelzna has loot tables that appear to be mostly be classic EQ. That's fine and all, but that means she drops an item that is now quest only in Live and an item that had a special NPC made for it (Stiletto of the Bloodclaw-- Widowmistress). Since we already have the JBoot quest in, I went through and changed my database entry to reflect that she no longer drops the bloodclaw or the JBoots.
I didn't remove them from the loot table, for those of you worried about removing entries from your database, I simply gave them both a 0% chance to drop. I figured that would make things easier later down the road.
Also, I added the Torn Parchment for the JBoot quest to her loot table.
Code:
UPDATE lootdrop_entries SET chance=0 WHERE lootdrop_id=4205 AND item_id=2300;
UPDATE lootdrop_entries SET chance=0 WHERE lootdrop_id=4205 AND item_id=7312;
UPDATE lootdrop_entries SET chance=15 WHERE lootdrop_id=4205 AND item_id=7308;
UPDATE lootdrop_entries SET chance=30 WHERE lootdrop_id=4205 AND item_id=5310;
UPDATE lootdrop_entries SET chance=30 WHERE lootdrop_id=4205 AND item_id=4211;
UPDATE lootdrop_entries SET chance=25 WHERE lootdrop_id=4205 AND item_id=10302;
INSERT INTO lootdrop_entries VALUES (4207, 18942, 1, 0, 20);
UPDATE lootdrop_entries SET chance=80 WHERE lootdrop_id=4207 AND item_id=13422;
As always--- comments and feedback are appreciated. I kind of pulled the chances of all of the loot dropping out of thin air. Have only done a little bit of testing to make sure that my changes worked, so my chances may be too high or too low. Let me know what you think.
-Sarepean
Drelzna Loot
Linear Mode
