diff options
| author | xinef1 <w.szyszko2@gmail.com> | 2017-02-13 20:42:06 +0100 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2019-07-21 21:06:54 +0200 |
| commit | 89f728cd5b6ae3041fdae3c853ac4b0ac5f0a848 (patch) | |
| tree | 10a4c1d3322df49c0e2d1f87cae1c7bf801d38e2 /sql/updates | |
| parent | c860522ecf358b20afb3b3266de0555606a77888 (diff) | |
Core/Misc: Fixed player corpse looting, added player corpse loot and some more (#19122)
* Fixed corpse looting in wintergrasp
Added corpse loot for wintergrasp quests and To the Looter Go the Spoils (1166) achievement
Don't generate money for loot if no loot mode is available
Simplified few things
(cherrypicked from 2412886ef69d305df1bd6e6422ca3134c0ab1449)
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/world/master/2019_07_18_05_world_2017_02_13_00_world.sql | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/sql/updates/world/master/2019_07_18_05_world_2017_02_13_00_world.sql b/sql/updates/world/master/2019_07_18_05_world_2017_02_13_00_world.sql new file mode 100644 index 00000000000..ae479f50a47 --- /dev/null +++ b/sql/updates/world/master/2019_07_18_05_world_2017_02_13_00_world.sql @@ -0,0 +1,24 @@ + +-- To the Looter Go the Spoils (1166) +DELETE FROM `creature_loot_template` WHERE `entry`=1 AND `item`=18228; +INSERT INTO `creature_loot_template` VALUES (1, 18228, 0, 1, 0, 1, 0, 1, 1, ''); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=1 AND `SourceGroup`=1 AND `SourceEntry` IN(18228); +INSERT INTO `conditions` VALUES (1, 1, 18228, 0, 0, 22, 0, 30, 0, 0, 0, 0, 0, '', 'Requires map Alterac Valley'); + +-- Add Player Loot for WG quests +DELETE FROM `creature_loot_template` WHERE `entry`=1 AND `item` IN(43314, 43322, 43323, 43324, 44808, 44809); +INSERT INTO `creature_loot_template` VALUES(1, 43314, 0, 100, 1, 1, 0, 5, 5, ''), +(1, 43322, 0, 100, 1, 1, 0, 5, 5, ''), +(1, 43323, 0, 100, 1, 1, 0, 5, 5, ''), +(1, 43324, 0, 100, 1, 1, 0, 5, 5, ''), +(1, 44808, 0, 100, 1, 1, 0, 5, 5, ''), +(1, 44809, 0, 100, 1, 1, 0, 5, 5, ''); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=1 AND `SourceGroup`=1 AND `SourceEntry` IN(43314, 43322, 43323, 43324, 44808, 44809); +INSERT INTO `conditions` VALUES (1, 1, 44808, 0, 0, 23, 0, 4585, 0, 0, 0, 0, 0, '', 'Requires Glacial Falls area'), +(1, 1, 43322, 0, 0, 23, 0, 4585, 0, 0, 0, 0, 0, '', 'Requires Glacial Falls area'), +(1, 1, 43314, 0, 0, 23, 0, 4584, 0, 0, 0, 0, 0, '', 'Requires Cauldron of Flames area'), +(1, 1, 43323, 0, 0, 23, 0, 4587, 0, 0, 0, 0, 0, '', 'Requires Forest of Shadows area'), +(1, 1, 43324, 0, 0, 23, 0, 4590, 0, 0, 0, 0, 0, '', 'Requires Steppe of Life area'), +(1, 1, 44809, 0, 0, 23, 0, 4590, 0, 0, 0, 0, 0, '', 'Requires Steppe of Life area'); |