diff options
| author | Teppic1 <Teppic1@users.noreply.github.com> | 2018-02-17 21:13:23 +0100 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2018-02-17 21:13:23 +0100 |
| commit | b71b3c66724e18fe8a19e01cae2582678a459dc1 (patch) | |
| tree | ffcce4ddd459ab2a942e0f052ef6d77fb0a6870e | |
| parent | d38031715d3f9494bbc07f45f768f2151c9d9cf0 (diff) | |
DB/Loot: Reference template 24066 corrections
Closes #21409
| -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"); |