diff options
| -rw-r--r-- | sql/updates/world/master/2017_03_04_18_world_2016_10_01_04_world.sql | 57 |
1 files changed, 57 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_03_04_18_world_2016_10_01_04_world.sql b/sql/updates/world/master/2017_03_04_18_world_2016_10_01_04_world.sql new file mode 100644 index 00000000000..690bd9b7294 --- /dev/null +++ b/sql/updates/world/master/2017_03_04_18_world_2016_10_01_04_world.sql @@ -0,0 +1,57 @@ +-- +DELETE FROM `item_loot_template` WHERE `Entry`=6307 AND `Item` IN (4363, 4377, 4382); +UPDATE `item_loot_template` SET `Chance`=2.5 WHERE `Entry`=6307 AND `Item` IN (6305, 6306); + +DELETE FROM `gameobject_loot_template` WHERE `Entry`=2032; +INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(2032, 1477, 0, 2.5, 0, 1, 0, 1, 1, "Scroll of Agility II"), +(2032, 1711, 0, 4.2, 0, 1, 0, 1, 1, "Scroll of Stamina II"), +(2032, 2289, 0, 2.7, 0, 1, 0, 1, 1, "Scroll of Strength II"), +(2032, 2290, 0, 4.4, 0, 1, 0, 1, 1, "Scroll of Intellect II"), +(2032, 3608, 0, 0.02, 0, 1, 0, 1, 1, "Plans: Mighty Iron Hammer"), +(2032, 4098, 0, 25, 0, 1, 1, 1, 1, "Carefully Folded Note"), +(2032, 4100, 0, 25, 0, 1, 1, 1, 1, "Crumpled Note"), +(2032, 4101, 0, 25, 0, 1, 1, 1, 1, "Ripped Note"), +(2032, 4102, 0, 25, 0, 1, 1, 1, 1, "Torn Note"), +(2032, 4298, 0, 0.02, 0, 1, 0, 1, 1, "Pattern: Guardian Belt"), +(2032, 4299, 0, 0.02, 0, 1, 0, 1, 1, "Pattern: Guardian Armor"), +(2032, 4350, 0, 0.02, 0, 1, 0, 1, 1, "Pattern: Spider Silk Slippers"), +(2032, 4351, 0, 0.02, 0, 1, 0, 1, 1, "Pattern: Shadow Hood"), +(2032, 4352, 0, 0.02, 0, 1, 0, 1, 1, "Pattern: Boots of the Enchanter"), +(2032, 4412, 0, 0.02, 0, 1, 0, 1, 1, "Schematic: Moonsight Rifle"), +(2032, 4414, 0, 0.02, 0, 1, 0, 1, 1, "Schematic: Portable Bronze Mortar"), +(2032, 4416, 0, 0.02, 0, 1, 0, 1, 1, "Schematic: Goblin Land Mine"), +(2032, 4417, 0, 0.02, 0, 1, 0, 1, 1, "Schematic: Large Seaforium Charge"), +(2032, 5543, 0, 0.02, 0, 1, 0, 1, 1, "Plans: Iridescent Hammer"), +(2032, 5774, 0, 0.02, 0, 1, 0, 1, 1, "Pattern: Green Silk Pack"), +(2032, 6045, 0, 0.02, 0, 1, 0, 1, 1, "Plans: Iron Counterweight"), +(2032, 6454, 0, 0.02, 0, 1, 0, 1, 1, "Manual: Strong Anti-Venom"), +(2032, 7085, 0, 0.02, 0, 1, 0, 1, 1, "Pattern: Azure Shoulders"), +(2032, 7090, 0, 0.02, 0, 1, 0, 1, 1, "Pattern: Green Silk Armor"), +(2032, 7360, 0, 0.02, 0, 1, 0, 1, 1, "Pattern: Dark Leather Gloves"), +(2032, 7363, 0, 0.02, 0, 1, 0, 1, 1, "Pattern: Pilferer's Gloves"), +(2032, 7364, 0, 0.02, 0, 1, 0, 1, 1, "Pattern: Heavy Earthen Gloves"), +(2032, 7449, 0, 0.02, 0, 1, 0, 1, 1, "Pattern: Dusky Leather Leggings"), +(2032, 7450, 0, 0.02, 0, 1, 0, 1, 1, "Pattern: Green Whelp Armor"), +(2032, 7975, 0, 0.1, 0, 1, 0, 1, 1, "Plans: Heavy Mithril Pants"), +(2032, 7992, 0, 0.0508056, 0, 1, 0, 1, 1, "Plans: Blue Glittering Axe"), +(2032, 8029, 0, 0.0508056, 0, 1, 0, 1, 1, "Plans: Wicked Mithril Blade"), +(2032, 8385, 0, 0.0508056, 0, 1, 0, 1, 1, "Pattern: Turtle Scale Gloves"), +(2032, 8386, 0, 0.0580636, 0, 1, 0, 1, 1, "Pattern: Big Voodoo Robe"), +(2032, 8387, 0, 0.0725795, 0, 1, 0, 1, 1, "Pattern: Big Voodoo Mask"), +(2032, 9293, 0, 0.0435477, 0, 1, 0, 1, 1, "Recipe: Magic Resistance Potion"), +(2032, 10300, 0, 0.1, 0, 1, 0, 1, 1, "Pattern: Red Mageweave Vest"), +(2032, 10301, 0, 0.1, 0, 1, 0, 1, 1, "Pattern: White Bandit Mask"), +(2032, 10302, 0, 0.0653215, 0, 1, 0, 1, 1, "Pattern: Red Mageweave Pants"), +(2032, 10312, 0, 0.0290318, 0, 1, 0, 1, 1, "Pattern: Red Mageweave Gloves"), +(2032, 10424, 0, 0.02, 0, 1, 0, 1, 1, "Plans: Silvered Bronze Leggings"), +(2032, 10601, 0, 0.02, 0, 1, 0, 1, 1, "Schematic: Bright-Eye Goggles"), +(2032, 10603, 0, 0.0362897, 0, 1, 0, 1, 1, "Schematic: Catseye Ultra Goggles"), +(2032, 10604, 0, 0.0653215, 0, 1, 0, 1, 1, "Schematic: Mithril Heavy-bore Rifle"), +(2032, 10606, 0, 0.1, 0, 1, 0, 1, 1, "Schematic: Parachute Cloak"), +(2032, 11098, 0, 0.02, 0, 1, 0, 1, 1, "Formula: Enchant Cloak - Lesser Shadow Resistance"), +(2032, 11164, 0, 0.02, 0, 1, 0, 1, 1, "Formula: Enchant Weapon - Lesser Beastslayer"), +(2032, 11165, 0, 0.02, 0, 1, 0, 1, 1, "Formula: Enchant Weapon - Lesser Elemental Slayer"), +(2032, 11167, 0, 0.02, 0, 1, 0, 1, 1, "Formula: Enchant Boots - Lesser Spirit"), +(2032, 11202, 0, 0.0290318, 0, 1, 0, 1, 1, "Formula: Enchant Shield - Stamina"), +(2032, 11204, 0, 0.1, 0, 1, 0, 1, 1, "Formula: Enchant Bracer - Greater Spirit"); |