diff options
| author | treeston <treeston.mmoc@gmail.com> | 2016-08-24 17:21:35 +0200 |
|---|---|---|
| committer | treeston <treeston.mmoc@gmail.com> | 2016-08-24 17:21:35 +0200 |
| commit | 1ccdad6eb33adcb4848fc6fed36dc181e74b8682 (patch) | |
| tree | 6a2ab0237aebcc2e404ef18f19f826137fa3a049 | |
| parent | 3bc9214391888394671dd4e84809ba40259e85f7 (diff) | |
DB/Quest: Revert 376d281 and 63c77d2, move changes to reputation_reward_rate instead.
| -rw-r--r-- | sql/updates/world/3.3.5/2016_08_24_07_world.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2016_08_24_07_world.sql b/sql/updates/world/3.3.5/2016_08_24_07_world.sql new file mode 100644 index 00000000000..2c1c2941dc2 --- /dev/null +++ b/sql/updates/world/3.3.5/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); |