diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2017_11_08_20_world_335.sql | 51 |
1 files changed, 51 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_11_08_20_world_335.sql b/sql/updates/world/3.3.5/2017_11_08_20_world_335.sql new file mode 100644 index 00000000000..3a3c501fc7d --- /dev/null +++ b/sql/updates/world/3.3.5/2017_11_08_20_world_335.sql @@ -0,0 +1,51 @@ +-- +DELETE FROM `item_loot_template` WHERE `entry`=6307; +INSERT INTO `item_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(6307, 6304, 0, 10, 0, 1, 1, 1, 1, "Damp Diary Page (Day 4)"), +(6307, 6305, 0, 5, 0, 1, 1, 1, 1, "Damp Diary Page (Day 87)"), +(6307, 6306, 0, 2.5, 0, 1, 1, 1, 1, "Damp Diary Page (Day 512)"), +(6307, 3013, 0, 5, 0, 1, 1, 1, 1, "Scroll of Protection I"), +(6307, 1478, 0, 5, 0, 1, 1, 1, 1, "Scroll of Protection II"), +(6307, 1180, 0, 5, 0, 1, 1, 1, 1, "Scroll of Stamina I"), +(6307, 1711, 0, 5, 0, 1, 1, 1, 1, "Scroll of Stamina II"), +(6307, 1181, 0, 5, 0, 1, 1, 1, 1, "Scroll of Spirit I"), +(6307, 1712, 0, 5, 0, 1, 1, 1, 1, "Scroll of Spirit II"), +(6307, 954, 0, 5, 0, 1, 1, 1, 1, "Scroll of Strength I"), +(6307, 2289, 0, 5, 0, 1, 1, 1, 1, "Scroll of Strength II"), +(6307, 3012, 0, 5, 0, 1, 1, 1, 1, "Scroll of Agility I"), +(6307, 1477, 0, 5, 0, 1, 1, 1, 1, "Scroll of Agility II"), +(6307, 955, 0, 5, 0, 1, 1, 1, 1, "Scroll of Intellect I"), +(6307, 2290, 0, 5, 0, 1, 1, 1, 1, "Scroll of Intellect II"), +(6307, 3608, 0, 0.6818, 0, 1, 1, 1, 1, "Plans: Mighty Iron Hammer"), +(6307, 3612, 0, 0.6818, 0, 1, 1, 1, 1, "Plans: Green Iron Gauntlets"), +(6307, 3611, 0, 0.6818, 0, 1, 1, 1, 1, "Plans: Green Iron Boots"), +(6307, 6390, 0, 0.6818, 0, 1, 1, 1, 1, "Pattern: Stylish Blue Shirt"), +(6307, 2601, 0, 0.6818, 0, 1, 1, 1, 1, "Pattern: Gray Woolen Robe"), +(6307, 6211, 0, 0.6818, 0, 1, 1, 1, 1, "Recipe: Elixir of Ogre's Strength"), +(6307, 2555, 0, 0.6818, 0, 1, 1, 1, 1, "Recipe: Swiftness Potion"), +(6307, 4348, 0, 0.6818, 0, 1, 1, 1, 1, "Pattern: Phoenix Gloves"), +(6307, 7092, 0, 0.6818, 0, 1, 1, 1, 1, "Pattern: Hands of Darkness"), +(6307, 4292, 0, 0.6818, 0, 1, 1, 1, 1, "Pattern: Green Woolen Bag"), +(6307, 2409, 0, 0.6818, 0, 1, 1, 1, 1, "Pattern: Dark Leather Tunic"), +(6307, 3393, 0, 0.6818, 0, 1, 1, 1, 1, "Recipe: Minor Magic Resistance Potion"), +(6307, 2881, 0, 0.6818, 0, 1, 1, 1, 1, "Plans: Runed Copper Breastplate"), +(6307, 7091, 0, 0.6818, 0, 1, 1, 1, 1, "Pattern: Truefaith Gloves"), +(6307, 4350, 0, 0.6818, 0, 1, 1, 1, 1, "Pattern: Spider Silk Slippers"), +(6307, 7364, 0, 0.6818, 0, 1, 1, 1, 1, "Pattern: Heavy Earthen Gloves"), +(6307, 2408, 0, 0.6818, 0, 1, 1, 1, 1, "Pattern: Fine Leather Gloves"), +(6307, 11098, 0, 0.6818, 0, 1, 1, 1, 1, "Formula: Enchant Cloak - Lesser Shadow Resistance"), +(6307, 3394, 0, 0.6818, 0, 1, 1, 1, 1, "Recipe: Potion of Curing"), +(6307, 5578, 0, 0.6818, 0, 1, 1, 1, 1, "Plans: Silvered Bronze Breastplate"), +(6307, 4346, 0, 0.6818, 0, 1, 1, 1, 1, "Pattern: Heavy Woolen Cloak"), +(6307, 11038, 0, 0.6818, 0, 1, 1, 1, 1, "Formula: Enchant 2H Weapon - Lesser Spirit"), +(6307, 4409, 0, 0.6818, 0, 1, 1, 1, 1, "Schematic: Small Seaforium Charge"), +(6307, 2553, 0, 0.6818, 0, 1, 1, 1, 1, "Recipe: Elixir of Minor Agility"), +(6307, 4293, 0, 0.6818, 0, 1, 1, 1, 1, "Pattern: Hillman's Leather Vest"), +(6307, 11081, 0, 0.6818, 0, 1, 1, 1, 1, "Formula: Enchant Shield - Lesser Protection"), +(6307, 6347, 0, 0.6818, 0, 1, 1, 1, 1, "Formula: Enchant Bracer - Minor Strength"), +(6307, 4345, 0, 0.6818, 0, 1, 1, 1, 1, "Pattern: Red Woolen Boots"), +(6307, 6344, 0, 0.6818, 0, 1, 1, 1, 1, "Formula: Enchant Bracer - Minor Spirit"), +(6307, 6391, 0, 0.6818, 0, 1, 1, 1, 1, "Pattern: Stylish Green Shirt"), +(6307, 4349, 0, 0.6818, 0, 1, 1, 1, 1, "Pattern: Phoenix Pants"), +(6307, 4294, 0, 0.6818, 0, 1, 1, 1, 1, "Pattern: Hillman's Belt"), +(6307, 6716, 0, 0.6818, 0, 1, 1, 1, 1, "Schematic: EZ-Thro Dynamite"); |