From 025ffe11d19949aa5505aec18f272dcced8ef97a Mon Sep 17 00:00:00 2001 From: ariel- Date: Mon, 20 Feb 2017 13:26:36 -0300 Subject: DB/Loot: remove some incorrect drops of three quest reward items - Items reward of the Hakkari Urn, it must always contain the 3 items (previous had a very little chance of being less than 3) - Hakkari Urn is the reward from "Secret of the Circle (3447)" (cherrypicked from e9d527b70f84d28c7ed0a2d6d0270aa89230c472) --- .../world/master/2019_07_24_05_world_2017_02_20_02_world_335.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/updates/world/master/2019_07_24_05_world_2017_02_20_02_world_335.sql (limited to 'sql/updates') diff --git a/sql/updates/world/master/2019_07_24_05_world_2017_02_20_02_world_335.sql b/sql/updates/world/master/2019_07_24_05_world_2017_02_20_02_world_335.sql new file mode 100644 index 00000000000..68fe1b2cad4 --- /dev/null +++ b/sql/updates/world/master/2019_07_24_05_world_2017_02_20_02_world_335.sql @@ -0,0 +1,6 @@ +DELETE FROM `creature_loot_template` WHERE `Item` IN (10780, 10781, 10782); +DELETE FROM `item_loot_template` WHERE `Item` IN (10780, 10781, 10782); +INSERT INTO `item_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`) VALUES +(10773, 10780, 0, 100, 0, 1, 0, 1, 1), -- Mark of Hakkar +(10773, 10781, 0, 100, 0, 1, 1, 1, 1), -- Hakkari Breastplate +(10773, 10782, 0, 100, 0, 1, 2, 1, 1); -- Hakkari Shroud -- cgit v1.2.3