diff options
| author | ariel- <ariel-@users.noreply.github.com> | 2017-02-20 13:26:36 -0300 |
|---|---|---|
| committer | ariel- <ariel-@users.noreply.github.com> | 2017-02-20 13:27:20 -0300 |
| commit | e9d527b70f84d28c7ed0a2d6d0270aa89230c472 (patch) | |
| tree | 1ba02d8ec8c628aa8bfb5692c48c0264e3dd005f | |
| parent | 50973e9d6fbf7537ae8d90535b9dfa25e5ce69f6 (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)"
| -rw-r--r-- | sql/updates/world/3.3.5/2017_02_20_02_world_335.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_02_20_02_world_335.sql b/sql/updates/world/3.3.5/2017_02_20_02_world_335.sql new file mode 100644 index 00000000000..68fe1b2cad4 --- /dev/null +++ b/sql/updates/world/3.3.5/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 |