diff options
| author | ariel- <ariel-@users.noreply.github.com> | 2017-02-20 13:26:36 -0300 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2019-08-17 20:04:14 +0200 |
| commit | 025ffe11d19949aa5505aec18f272dcced8ef97a (patch) | |
| tree | dd68ea186569e68e581d8b20e32415a701eae7c2 | |
| parent | ae0a429e522136f397f03737ba5bbd44426f5780 (diff) | |
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)
| -rw-r--r-- | sql/updates/world/master/2019_07_24_05_world_2017_02_20_02_world_335.sql | 6 |
1 files changed, 6 insertions, 0 deletions
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 |