diff options
| author | Dr-J <daniel.jarrott0@gmail.com> | 2014-10-27 14:05:10 +0000 |
|---|---|---|
| committer | Dr-J <daniel.jarrott0@gmail.com> | 2014-10-27 14:05:10 +0000 |
| commit | aac03a86f4375702d4b7ba77df9885d73b0d1508 (patch) | |
| tree | c357884f488eb76d64999152811f63cb389680ad | |
| parent | 4c93ac74da81eeb5af27320777b64d347050f8e2 (diff) | |
DB/Item: Northrend Mystery Gem Pouch (3.3.5)
* This is probably only valid for 3.3.5 as item is marked as no longer available in game and last comment on wowhead is from 4.1.0 saying item is now worthless, was added in 3.2
* Remove northrend rare gems for emblem of heroism from Lhara and replace with this item
| -rw-r--r-- | sql/updates/world/2014_10_27_01_world_335.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/world/2014_10_27_01_world_335.sql b/sql/updates/world/2014_10_27_01_world_335.sql new file mode 100644 index 00000000000..443603fca24 --- /dev/null +++ b/sql/updates/world/2014_10_27_01_world_335.sql @@ -0,0 +1,13 @@ +-- Link reference loot to item (using one of the reference loot template ids from icy prism as same 6 loot items +DELETE FROM `item_loot_template` WHERE `Entry`=46812; +INSERT INTO `item_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(46812, 1, 45010, 100, 0, 1, 0, 1, 1, NULL), +(46812, 2, 45010, 50, 0, 1, 0, 1, 1, NULL); + +-- Add Northrend Mystery Gem Pouch to Lhara +DELETE FROM `npc_vendor` WHERE `entry`=14846 AND `item`=46812; +INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES +(14846, 0, 46812, 1, 43200, 0, 0); + +-- Delete NR Rare nr gems for Emblem of Heroism from Lhara +DELETE FROM `npc_vendor` WHERE `entry`=14846 AND `item` IN(36927,36918,36933,36921,36924,36930); |