diff options
| -rw-r--r-- | sql/updates/world/6.x/2016_07_31_03_world.sql | 53 |
1 files changed, 53 insertions, 0 deletions
diff --git a/sql/updates/world/6.x/2016_07_31_03_world.sql b/sql/updates/world/6.x/2016_07_31_03_world.sql new file mode 100644 index 00000000000..d7304bed63d --- /dev/null +++ b/sql/updates/world/6.x/2016_07_31_03_world.sql @@ -0,0 +1,53 @@ +-- Food Crate +DELETE FROM `gameobject_loot_template` WHERE `Entry` IN (2573, 2594, 2595, 2596, 2597, 2599, 9937, 9943, 9946, 9952); +INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(2573, 422, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Dwarven Mild'), +(2573, 3770, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Mutton Chop'), +(2573, 4538, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Snapvine Watermelon'), +(2573, 4542, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Moist Cornbread'), +(2573, 4593, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Bristle Whisker Catfish'), +(2594, 422, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Dwarven Mild'), +(2594, 3770, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Mutton Chop'), +(2594, 4538, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Snapvine Watermelon'), +(2594, 4542, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Moist Cornbread'), +(2594, 4593, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Bristle Whisker Catfish'), +(2595, 422, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Dwarven Mild'), +(2595, 3770, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Mutton Chop'), +(2595, 4538, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Snapvine Watermelon'), +(2595, 4542, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Moist Cornbread'), +(2595, 4593, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Bristle Whisker Catfish'), +(2596, 422, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Dwarven Mild'), +(2596, 3770, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Mutton Chop'), +(2596, 4538, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Snapvine Watermelon'), +(2596, 4542, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Moist Cornbread'), +(2596, 4593, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Bristle Whisker Catfish'), +(2597, 422, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Dwarven Mild'), +(2597, 3770, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Mutton Chop'), +(2597, 4538, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Snapvine Watermelon'), +(2597, 4542, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Moist Cornbread'), +(2597, 4593, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Bristle Whisker Catfish'), +(2599, 422, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Dwarven Mild'), +(2599, 3770, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Mutton Chop'), +(2599, 4538, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Snapvine Watermelon'), +(2599, 4542, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Moist Cornbread'), +(2599, 4593, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Bristle Whisker Catfish'), +(9937, 1707, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Stormwind Brie'), +(9937, 3771, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Wild Hog Shank'), +(9937, 4539, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Goldenbark Apple'), +(9937, 4544, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Mulgore Spice Bread'), +(9937, 8364, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Mithril Head Trout'), +(9943, 1707, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Stormwind Brie'), +(9943, 3771, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Wild Hog Shank'), +(9943, 4539, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Goldenbark Apple'), +(9943, 4544, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Mulgore Spice Bread'), +(9943, 8364, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Mithril Head Trout'), +(9946, 1707, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Stormwind Brie'), +(9946, 3771, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Wild Hog Shank'), +(9946, 4539, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Goldenbark Apple'), +(9946, 4544, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Mulgore Spice Bread'), +(9946, 8364, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Mithril Head Trout'), +(9952, 1707, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Stormwind Brie'), +(9952, 3771, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Wild Hog Shank'), +(9952, 4539, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Goldenbark Apple'), +(9952, 4544, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Mulgore Spice Bread'), +(9952, 8364, 0, 75, 0, 1, 0, 2, 4, 'Food Crate contains Mithril Head Trout'); |