diff options
| author | treeston <treeston.mmoc@gmail.com> | 2016-08-24 14:50:36 +0200 |
|---|---|---|
| committer | treeston <treeston.mmoc@gmail.com> | 2016-08-24 14:50:36 +0200 |
| commit | 376d281fff74c476b411460d969d490c15a86836 (patch) | |
| tree | 8ba70dc0d254e77ee6491cfb79ea7046fceab2cb | |
| parent | 83c032c2a8cd688183c29ca5caffc26817d11a03 (diff) | |
DB/Quest: Adjust Sons of Hodir reputation values to 3.3 retail. I have no idea how we missed that all this time.
| -rw-r--r-- | sql/updates/world/3.3.5/2016_08_24_04_world.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2016_08_24_04_world.sql b/sql/updates/world/3.3.5/2016_08_24_04_world.sql new file mode 100644 index 00000000000..5076e7f521d --- /dev/null +++ b/sql/updates/world/3.3.5/2016_08_24_04_world.sql @@ -0,0 +1,7 @@ +-- fix sons of hodir reputation amounts to correspond to 3.3.5 retail +UPDATE `quest_template` SET `RewardFactionOverride1`=65000 WHERE `id` IN (13559,13108,13003); -- Hodir's Tribute awards 650 rep per turn-in; Whatever it Takes! and Thrusing Hodir's Spear also award 650 rep +UPDATE `quest_template` SET `RewardFactionOverride1`=2860000 WHERE `id` IN (12915,12924); -- Mending Fences and A Spark of Hope award 28600 rep +UPDATE `quest_template` SET `RewardFactionOverride1`=32500 WHERE `id` IN (12924,13011,12975,12985,13001); -- Forging an Alliance, Jormuttar is Soo Fat..., In Memoriam, Forging a Head, Raising Hodir's Spear reward 325 rep each +UPDATE `quest_template` SET `RewardFactionOverride1`=45500 WHERE `id` IN (12981,12977,13010,13420,13421,13006,12994,13046); -- Hot and Cold, Blowing Hodir's Horn, 'Krolmir, Hammer of Storms', Everfrost, Remember Everfrost!, Polishing the Helm, Spy Hunter, Feeding Arngrim each award 455 reputation +UPDATE `quest_template` SET `RewardFactionOverride1`=32500 WHERE `id` = 12987; -- Mounting Hodir's Helm awards 325 rep +UPDATE `quest_template` SET `RewardFactionOverride1`=97 WHERE `id` = 12976; -- A Monument to the Fallen awards 97 rep |