diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2018_02_17_01_world_335.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_02_17_01_world_335.sql b/sql/updates/world/3.3.5/2018_02_17_01_world_335.sql new file mode 100644 index 00000000000..97fc90e52b9 --- /dev/null +++ b/sql/updates/world/3.3.5/2018_02_17_01_world_335.sql @@ -0,0 +1,15 @@ +-- +-- Remove unique items from reference table 24066 +DELETE FROM `reference_loot_template` WHERE `Entry`=24066 AND `Item` IN (886, 1077, 2013, 2227, 2233, 2566, 3204, 3569, 6315); +-- Add former items from reference table 24066 to their proper NPCs +DELETE FROM `creature_loot_template` WHERE `Item` IN (886, 1077, 2013, 2227, 2233, 2566, 3204, 3569, 6315); +INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Chance`, `GroupId`, `Comment`) VALUES +(210, 886, 0.1, 0, "Bone Chewer - Black Metal Shortsword"), +(910, 1077, 0.1, 0, "Defias Enchanter - Defias Mage Ring"), +(787, 2013, 0.1, 0, "Skeletal Healer - Cryptbone Staff"), +(892, 2227, 0.1, 0, "Splinter Fist Taskmaster - Heavy Ogre War Axe"), +(533, 2233, 0.1, 0, "Nightbane Shadow Weaver - Shadow Weaver Leggings"), +(397, 2566, 1.5, 0, "Morganth - Sacrificial Robes"), +(2372, 3204, 0.1, 0, "Mudsnout Gnoll - Deepwood Bracers"), +(4517, 3569, 1.5, 0, "Death's Head Priest - Vicar's Robe"), +(6523, 6315, 0.1, 0, "Dark Iron Rifleman - Steelarrow Crossbow"); |