Looking4Group / L4G_Core

Looking4Group Core
http://looking4group.eu
GNU General Public License v2.0
37 stars 73 forks source link

Shattered Necklase - Drop-item that gives quest never dropped (Uldaman) #3817

Closed Valerate closed 7 years ago

Valerate commented 7 years ago

Hi

I tried to get every quest ready for when I was doing Uldaman, and this was the only one I couldn't get. I farmed mobs outside for a couple of hours (they drop a load of silk aswell which was nice) but I never got one.

Issue: The "Shattered Necklace" drop-quest from Uldaman never dropped Where: Outside/inside Uldaman dungeon in Badlands.

http://db.vanillagaming.org/?item=7666#dropped-by http://www.wowhead.com/quest=2198/the-shattered-necklace You didnt have the item in the Hellfire wiki either

I read that they removed it in Wotlk, but I assumed it should still exsist on a tbc server?

AnonXS commented 7 years ago

http://db.hellfire-tbc.com/?item=7666

From looking at this it seems to be inserted with -100 which doesnt work for quest giving items.


DELETE FROM `creature_loot_template` WHERE `item` IN (7666);
INSERT INTO `creature_loot_template` VALUES (4856, 7666, 4.7, 0, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (4852, 7666, 3.9, 0, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (4851, 7666, 2.3, 0, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (4846, 7666, 1.5, 0, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (4845, 7666, 1.4, 0, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (4844, 7666, 1.2, 0, 1, 1, 0, 0, 0);
AnonXS commented 7 years ago

https://github.com/Looking4Group/L4G_Core/pull/3843/commits/356a8d9b4b9395156bf1218012c40a7d3012650a