diff options
| -rw-r--r-- | sql/updates/world/2015_07_19_12_world.sql | 218 |
1 files changed, 218 insertions, 0 deletions
diff --git a/sql/updates/world/2015_07_19_12_world.sql b/sql/updates/world/2015_07_19_12_world.sql new file mode 100644 index 00000000000..ec7d3d78d82 --- /dev/null +++ b/sql/updates/world/2015_07_19_12_world.sql @@ -0,0 +1,218 @@ +DELETE FROM `gameobject_loot_template` WHERE `entry` IN (1698, 34868, 40268, 40321, 40325, 43114, 44457, 44459, 45539, 49421, 49426, 49428, 51296, 51297, 51298, 51299, 51300, 51301, 51302, 51303, 51305, 51306, 51307, 51308, 51309, 51480, 51481, 51482, 51489, 51491, 51492, 51499, 51500, 51501, 51502, 51503, 51505, 51506, 51507, 51508, 51509, 51510, 51511, 51512, 51513, 51514, 51515, 52208, 52185, 54125, 56290); +DELETE FROM `gameobject_loot_template` WHERE `entry` IN (34868, 51296, 51297, 51299, 51300, 51301, 51303, 51305, 51306, 51307, 51308, 51309, 51500, 51501, 51502, 51503, 51505, 51507, 51508, 51509, 51510, 51511, 51512, 51513, 51514, 51515); + +INSERT INTO `gameobject_loot_template` ( `Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES + +-- garrison mine cart (no trash loot) (might need quantity tweak) +(54125, 120945, 0, 85, 0, 1, 0, 1, 3, 'Primal spirit'), +(54125, 109118, 0, 47, 0, 1, 0, 1, 4, 'Blackrock ore'), +(54125, 109119, 0, 47, 0, 1, 0, 1, 4, 'True iron ore'), +(54125, 118897, 0, 45, 0, 1, 0, 1, 1, 'miner coffee'), +(54125, 118903, 0, 45, 0, 1, 0, 1, 1, 'Preserved mining pick'), + +-- Rich Ghost iron deposit +(40268, 72092, 0, 100, 0, 1, 0, 1, 8, 'Ghost iron ore'), +(40268, 76135, 0, 0.6, 0, 1, 0, 1, 1, 'Green gems'), +(40268, 76133, 0, 0.6, 0, 1, 0, 1, 1, 'Green gems'), +(40268, 76136, 0, 0.6, 0, 1, 0, 1, 1, 'Green gems'), +(40268, 76134, 0, 0.6, 0, 1, 0, 1, 1, 'Green gems'), +(40268, 76130, 0, 0.6, 0, 1, 0, 1, 1, 'Green gems'), +(40268, 76137, 0, 0.6, 0, 1, 0, 1, 1, 'Green gems'), +(40268, 76138, 0, 0.3, 0, 1, 0, 1, 1, 'Blue gems'), +(40268, 76131, 0, 0.3, 0, 1, 0, 1, 1, 'Blue gems'), +(40268, 76139, 0, 0.3, 0, 1, 0, 1, 1, 'Blue gems'), +(40268, 76140, 0, 0.3, 0, 1, 0, 1, 1, 'Blue gems'), +(40268, 76141, 0, 0.3, 0, 1, 0, 1, 1, 'Blue gems'), +(40268, 76142, 0, 0.3, 0, 1, 0, 1, 1, 'Blue gems'), + +-- Frostweed (missing the item to learn herborism 700 : 111350) +(52208, 109124, 0, 100, 0, 1, 0, 1, 8, 'Frostweed'), +(52208, 120945, 0, 10, 0, 1, 0, 1, 3, 'Primal spirit'), +(52208, 116053, 0, 35, 0, 1, 0, 1, 3, 'Draenic seed'), + +-- True iron deposit (missing the item to learn mining 700 : 111349) +(52185, 109119, 0, 100, 0, 1, 0, 1, 8, 'True iron ore'), +(52185, 120945, 0, 15, 0, 1, 0, 1, 3, 'Primal spirit'), + +-- Green tea leaf +(40321, 72234, 0, 100, 0, 1, 0, 1, 8, 'Green tea leaves'), +(40321, 89640, 0, 10, 0, 1, 0, 2, 3, 'Life spirit'), +(40321, 89641, 0, 8, 0, 1, 0, 1, 1, 'Water spirit'), +(40321, 72238, 0, 1.1, 0, 1, 0, 1, 2, 'Golden Lotus'), + +-- Sha-touched herb +(44457, 89639, 0, 33, 0, 1, 1, 1, 7, 'Desecrated herb'), +(44457, 72234, 0, 33, 0, 1, 1, 1, 9, 'Green tea leaves'), +(44457, 79010, 0, 17, 0, 1, 1, 1, 9, 'snow lily'), +(44457, 79011, 0, 17, 0, 1, 1, 1, 9, 'Fools cap'), + +-- Adamantite ore (Might need to adjust amount) +(51302, 23425, 0, 100, 0, 1, 0, 1, 4, 'Adamantite ore'), +(51302, 23427, 0, 30, 0, 1, 0, 1, 3, 'Eternium ore'), +(51302, 22573, 0, 30, 0, 1, 0, 1, 5, 'mote of earth'), +(51302, 35229, 0, 40, 1, 1, 0, 1, 2, 'Nether residue'), +(51302, 21929, 0, 0.7, 0, 1, 1, 1, 1, 'Green gems'), +(51302, 23117, 0, 0.7, 0, 1, 1, 1, 1, 'Green gems'), +(51302, 23077, 0, 0.7, 0, 1, 0, 1, 1, 'Green gems'), +(51302, 23079, 0, 0.7, 0, 1, 0, 1, 1, 'Green gems'), +(51302, 23112, 0, 0.7, 0, 1, 0, 1, 1, 'Green gems'), +(51302, 23107, 0, 0.7, 0, 1, 0, 1, 1, 'Green gems'), +(51302, 23440, 0, 0.3, 0, 1, 0, 1, 1, 'Blue gems'), +(51302, 23439, 0, 0.3, 0, 1, 0, 1, 1, 'Blue gems'), +(51302, 23436, 0, 0.3, 0, 1, 0, 1, 1, 'Blue gems'), +(51302, 23441, 0, 0.3, 0, 1, 0, 1, 1, 'Blue gems'), +(51302, 23438, 0, 0.3, 0, 1, 0, 1, 1, 'Blue gems'), +(51302, 23437, 0, 0.3, 0, 1, 0, 1, 1, 'Blue gems'), + +-- Herborism General +(1698, 3355, 0, 100, 0, 1, 0, 1, 8, 'Wild Steelbloom'), +(51481, 3355, 0, 100, 0, 1, 0, 1, 8, 'Wild Steelbloom'), +(51482, 3356, 0, 100, 0, 1, 0, 1, 8, 'Kingsblood'), +(51480, 3369, 0, 100, 0, 1, 0, 1, 8, 'Grave Moss'), +(51491, 8839, 0, 100, 0, 1, 0, 1, 8, 'Blindweed'), +(51489, 8831, 0, 100, 0, 1, 0, 1, 8, 'Purple Lotus'), +(51492, 8845, 0, 100, 0, 1, 0, 1, 6, 'Ghost Mushroom'), + +-- Dreaming glory +(51499, 22786, 0, 100, 0, 1, 0, 1, 8, 'Dreaming glory'), +(51499, 22575, 0, 15, 0, 1, 0, 1, 3, 'mote of life'), +(51499, 22794, 0, 3, 0, 1, 0, 1, 4, 'Fel lotus'), +(51499, 35229, 0, 40, 1, 1, 0, 1, 1, 'Nether residue'), + +-- Nightmare vine +(51506, 22792, 0, 100, 0, 1, 0, 1, 8, 'Nightmare vine'), +(51506, 22794, 0, 3, 0, 1, 0, 1, 4, 'Fel lotus'), +(51506, 35229, 0, 40, 1, 1, 0, 1, 1, 'Nether residue'), + +-- Golden Lotus +(49428, 72238, 0, 100, 0, 1, 0, 1, 4, 'Golden Lotus'), +(49428, 89640, 0, 10, 0, 1, 0, 2, 3, 'Life spirit'), +(49428, 89641, 0, 6, 0, 1, 0, 1, 1, 'Water spirit'), + +-- Fools cap +(49426, 79011, 0, 100, 0, 1, 0, 1, 4, 'Fool cap'), +(49426, 89640, 0, 10, 0, 1, 0, 2, 3, 'Life spirit'), +(49426, 89641, 0, 8, 0, 1, 0, 1, 1, 'Water spirit'), +(49426, 72238, 0, 1.8, 0, 1, 0, 1, 2, 'Golden Lotus'), + +-- Silkweed +(40325, 72235, 0, 100, 0, 1, 0, 1, 4, 'silkweed'), +(40325, 89640, 0, 10, 0, 1, 0, 2, 3, 'Life spirit'), +(40325, 89641, 0, 8, 0, 1, 0, 1, 1, 'Water spirit'), +(40325, 72238, 0, 1.1, 0, 1, 0, 1, 2, 'Golden Lotus'), + +-- Quest or World item +(56290, 118268, 0, 99, 0, 1, 1, 1, 1, 'Fuzzy Pear'), +(56290, 118274, 0, 1, 0, 1, 1, 1, 1, 'Fuzzy Pear'), +(43114, 90006, 0, 100, 0, 1, 0, 4, 4, 'Bag of Wu Kao Supplies'), +(43114, 86534, 0, 100, 0, 1, 0, 10, 10, 'Bag of Wu Kao Supplies'), +(43114, 86536, 0, 100, 0, 1, 0, 6, 6, 'Bag of Wu Kao Supplies'), +(45539, 93022, 0, 100, 1, 1, 0, 1, 4, 'Animatable Stone'), +(45539, 91823, 0, 100, 1, 1, 0, 1, 1, 'Animatable Stone'), + +(34868, 36901, 0, 60, 0, 1, 1, 2, 6, 'Frozen Herb'), +(34868, 36904, 0, 20, 0, 1, 1, 2, 6, 'Frozen Herb'), +(34868, 36907, 0, 20, 0, 1, 1, 2, 6, 'Frozen Herb'), +(51300, 3858, 0, 100, 0, 1, 0, 2, 4, 'Mithril Deposit'), +(51300, 3864, 0, 5, 0, 1, 1, 1, 1, 'Mithril Deposit'), +(51300, 7909, 0, 5, 0, 1, 1, 1, 1, 'Mithril Deposit'), +(51300, 7910, 0, 5, 0, 1, 1, 1, 1, 'Mithril Deposit'), +(51300, 7912, 0, 80, 0, 1, 0, 1, 8, 'Mithril Deposit'), +(51300, 9262, 0, 5, 0, 1, 1, 1, 1, 'Mithril Deposit'), +(51299, 3864, 0, 5, 0, 1, 1, 1, 1, 'Truesilver Deposit'), +(51299, 7909, 0, 5, 0, 1, 1, 1, 1, 'Truesilver Deposit'), +(51299, 7910, 0, 5, 0, 1, 1, 1, 1, 'Truesilver Deposit'), +(51299, 7911, 0, 100, 0, 1, 0, 2, 4, 'Truesilver Deposit'), +(51296, 1705, 0, 5, 0, 1, 1, 1, 1, 'Gold Vein'), +(51296, 2776, 0, 100, 0, 1, 0, 2, 4, 'Gold Vein'), +(51296, 3864, 0, 5, 0, 1, 1, 1, 1, 'Gold Vein'), +(51296, 7909, 0, 5, 0, 1, 1, 1, 1, 'Gold Vein'), +(51297, 1529, 0, 5, 0, 1, 1, 1, 1, 'Iron Deposit'), +(51297, 1705, 0, 5, 0, 1, 1, 1, 1, 'Iron Deposit'), +(51297, 2772, 0, 100, 0, 1, 0, 2, 4, 'Iron Deposit'), +(51297, 2838, 0, 100, 0, 1, 0, 1, 5, 'Iron Deposit'), +(51297, 3864, 0, 5, 0, 1, 1, 1, 1, 'Iron Deposit'), +(51297, 7909, 0, 5, 0, 1, 1, 1, 1, 'Iron Deposit'), +(51500, 22575, 0, 15, 0, 1, 0, 1, 2, 'Felweed'), +(51500, 22785, 0, 100, 0, 1, 0, 1, 3, 'Felweed'), +(51500, 22794, 0, 2, 0, 1, 0, 1, 1, 'Felweed'), +(51500, 24401, 0, 10, 0, 1, 0, 1, 3, 'Felweed'), +(51502, 22575, 0, 15, 0, 1, 0, 1, 3, 'Ragveil'), +(51502, 22787, 0, 100, 0, 1, 0, 1, 3, 'Ragveil'), +(51502, 22794, 0, 2, 0, 1, 0, 1, 1, 'Ragveil'), +(51502, 24401, 0, 10, 0, 1, 0, 1, 3, 'Ragveil'), +(51501, 22575, 0, 15, 0, 1, 0, 1, 3, 'Terocone'), +(51501, 22789, 0, 100, 0, 1, 0, 1, 3, 'Terocone'), +(51501, 22794, 0, 3, 0, 1, 0, 1, 1, 'Terocone'), +(51501, 35229, 0, 25, 1, 1, 0, 1, 1, 'Terocone'), +(51503, 22790, 0, 100, 0, 1, 0, 1, 3, 'Ancient Lichen'), +(51503, 22794, 0, 2, 0, 1, 0, 1, 1, 'Ancient Lichen'), +(51503, 35229, 0, 25, 1, 1, 0, 1, 1, 'Ancient Lichen'), +(51505, 22576, 0, 15, 0, 1, 0, 1, 3, 'Netherbloom'), +(51505, 22791, 0, 100, 0, 1, 0, 1, 3, 'Netherbloom'), +(51505, 22794, 0, 3, 0, 1, 0, 1, 1, 'Netherbloom'), +(51505, 35229, 0, 25, 1, 1, 0, 1, 1, 'Netherbloom'), +(51303, 1, 12904, 5, 0, 1, 0, 1, 1, 'Rich Adamantite Deposit'), +(51303, 2, 12902, 1, 0, 1, 0, 1, 1, 'Rich Adamantite Deposit'), +(51303, 22573, 0, 10, 0, 1, 0, 4, 8, 'Rich Adamantite Deposit'), +(51303, 23425, 0, 100, 0, 1, 0, 5, 7, 'Rich Adamantite Deposit'), +(51303, 23427, 0, 10, 0, 1, 0, 2, 3, 'Rich Adamantite Deposit'), +(51301, 1, 12901, 5, 0, 1, 0, 1, 1, 'Fel iron Deposit'), +(51301, 22573, 0, 10, 0, 1, 0, 1, 2, 'Fel iron Deposit'), +(51301, 22574, 0, 10, 0, 1, 0, 1, 2, 'Fel iron Deposit'), +(51301, 23424, 0, 100, 0, 1, 0, 2, 4, 'Fel iron Deposit'), +(51301, 23427, 0, 5, 0, 1, 0, 1, 2, 'Fel iron Deposit'), +(51305, 1, 12901, 5, 0, 1, 0, 1, 1, 'Khorium Deposit'), +(51305, 2, 12902, 1, 0, 1, 0, 1, 1, 'Khorium Deposit'), +(51305, 22573, 0, 35, 0, 1, 0, 2, 5, 'Khorium Deposit'), +(51305, 22574, 0, 10, 0, 1, 0, 2, 5, 'Khorium Deposit'), +(51305, 23426, 0, 100, 0, 1, 0, 2, 4, 'Khorium Deposit'), +(51305, 23427, 0, 10, 0, 1, 0, 1, 3, 'Khorium Deposit'), +(51514, 52329, 0, 25, 0, 1, 0, 1, 4, 'Cinderbloom'), +(51514, 52983, 0, 100, 0, 1, 0, 2, 4, 'Cinderbloom'), +(51514, 63122, 0, 10, 0, 1, 0, 1, 1, 'Cinderbloom'), +(51515, 52329, 0, 25, 0, 1, 0, 1, 4, 'Azshara''s Veil'), +(51515, 52985, 0, 100, 0, 1, 0, 2, 4, 'Azshara''s Veil'), +(51515, 63122, 0, 10, 0, 1, 0, 1, 1, 'Azshara''s Veil'), +(51507, 36901, 0, 100, 0, 1, 0, 1, 3, 'Goldclover'), +(51507, 36908, 0, 5, 0, 1, 0, 1, 1, 'Goldclover'), +(51507, 37704, 0, 20, 0, 1, 0, 1, 3, 'Goldclover'), +(51507, 37921, 0, 35, 0, 1, 0, 1, 3, 'Goldclover'), +(51306, 1, 12905, 5, 0, 1, 0, 1, 1, 'Cobalt Deposit'), +(51306, 36909, 0, 100, 0, 1, 0, 2, 4, 'Cobalt Deposit'), +(51306, 37701, 0, 30, 0, 1, 0, 1, 2, 'Cobalt Deposit'), +(51306, 37705, 0, 30, 0, 1, 0, 1, 2, 'Cobalt Deposit'), +(51307, 1, 12905, 5, 0, 1, 0, 1, 1, 'Rich Cobalt Deposit'), +(51307, 2, 12906, 5, 0, 1, 0, 1, 1, 'Rich Cobalt Deposit'), +(51307, 36909, 0, 100, 0, 1, 0, 4, 8, 'Rich Cobalt Deposit'), +(51307, 37701, 0, 30, 0, 1, 0, 1, 2, 'Rich Cobalt Deposit'), +(51307, 37705, 0, 30, 0, 1, 0, 1, 2, 'Rich Cobalt Deposit'), +(51509, 36904, 0, 100, 0, 1, 0, 1, 3, 'Tiger Lily'), +(51509, 36908, 0, 5, 0, 1, 0, 1, 1, 'Tiger Lily'), +(51509, 37704, 0, 20, 0, 1, 0, 1, 3, 'Tiger Lily'), +(51509, 37921, 0, 35, 0, 1, 0, 1, 3, 'Tiger Lily'), +(51510, 36908, 0, 5, 0, 1, 0, 1, 1, 'Firethorn'), +(51510, 37704, 0, 25, 0, 1, 0, 1, 3, 'Firethorn'), +(51510, 39970, 0, 100, 0, 1, 1, 2, 3, 'Firethorn'), +(51308, 1, 12905, 5, 0, 1, 0, 1, 1, 'Saronite Deposit'), +(51308, 36912, 0, 100, 0, 1, 0, 2, 4, 'Saronite Deposit'), +(51308, 37701, 0, 40, 0, 1, 0, 1, 2, 'Saronite Deposit'), +(51308, 37703, 0, 40, 0, 1, 0, 1, 2, 'Saronite Deposit'), +(51309, 1, 12905, 5, 0, 1, 0, 1, 1, 'Rich Saronite Deposit'), +(51309, 2, 12906, 5, 0, 1, 0, 1, 1, 'Rich Saronite Deposit'), +(51309, 36912, 0, 100, 0, 1, 0, 5, 7, 'Rich Saronite Deposit'), +(51309, 37701, 0, 40, 0, 1, 0, 1, 8, 'Rich Saronite Deposit'), +(51309, 37703, 0, 40, 0, 1, 0, 1, 8, 'Rich Saronite Deposit'), +(51508, 36907, 0, 100, 0, 1, 0, 1, 3, 'Talandra''s Rose'), +(51508, 36908, 0, 5, 0, 1, 0, 1, 1, 'Talandra''s Rose'), +(51508, 37704, 0, 20, 0, 1, 0, 1, 3, 'Talandra''s Rose'), +(51508, 37921, 0, 35, 0, 1, 0, 1, 3, 'Talandra''s Rose'), +(51512, 36906, 0, 100, 0, 1, 0, 1, 3, 'Icethorn'), +(51512, 36908, 0, 5, 0, 1, 0, 1, 3, 'Icethorn'), +(51512, 37704, 0, 25, 0, 1, 0, 1, 3, 'Icethorn'), +(51511, 36903, 0, 100, 0, 1, 0, 1, 3, 'Adder''s Tongue'), +(51511, 36908, 0, 5, 0, 1, 0, 1, 1, 'Adder''s Tongue'), +(51511, 37704, 0, 25, 0, 1, 0, 1, 3, 'Adder''s Tongue'), +(51513, 36905, 0, 100, 0, 1, 0, 1, 3, 'Lichbloom'), +(51513, 36908, 0, 5, 0, 1, 0, 1, 1, 'Lichbloom'), +(51513, 37704, 0, 25, 0, 1, 0, 1, 3, 'Lichbloom'); |