diff options
| author | treeston <treeston.mmoc@gmail.com> | 2016-08-24 17:21:35 +0200 |
|---|---|---|
| committer | joschiwald <joschiwald.trinity@gmail.com> | 2017-02-18 15:49:07 +0100 |
| commit | bf5988733bf63a2bdf489b95dc49629ba8a1c0e6 (patch) | |
| tree | 683a904d1e4293220cc64312fda82fd8a999fdc1 | |
| parent | 75701f14c3b51bd6d1d2e90b0abf0ef7386026b5 (diff) | |
DB/Quest: Revert 376d281 and 63c77d2, move changes to reputation_reward_rate instead.
(cherry picked from commit 1ccdad6eb33adcb4848fc6fed36dc181e74b8682)
| -rw-r--r-- | sql/updates/world/master/2017_02_18_17_world_2016_08_24_07_world.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_02_18_17_world_2016_08_24_07_world.sql b/sql/updates/world/master/2017_02_18_17_world_2016_08_24_07_world.sql new file mode 100644 index 00000000000..7eae175ce51 --- /dev/null +++ b/sql/updates/world/master/2017_02_18_17_world_2016_08_24_07_world.sql @@ -0,0 +1,6 @@ +-- move sons of hodir reputation changes to reputation_reward_rate table +-- also add multipliers to Argent Crusade, Alliance Vanguard, Horde Expedition, Kirin Tor, Knights of the Ebon Blade and Wyrmrest Accord as per 3.3.0 retail patch notes +-- UPDATE `quest_template` SET `RewardFactionOverride1`=0 WHERE `RewardFactionID1`=1119; +-- UPDATE `quest_template` SET `RewardFactionOverride1`=2200000 WHERE `id` IN (12915,12924); +INSERT INTO `reputation_reward_rate` (`faction`) VALUES (1106),(1037),(1052),(1091),(1090),(1098) ON DUPLICATE KEY UPDATE `faction`=`faction`; +UPDATE `reputation_reward_rate` SET `quest_rate`=1.3,`quest_daily_rate`=1.3,`quest_weekly_rate`=1.3,`quest_monthly_rate`=1.3,`quest_repeatable_rate`=1.3 WHERE `faction` IN (1106,1037,1052,1091,1090,1098); |