aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorKinzcool <kinzzcool@hotmail.com>2015-07-01 17:57:09 -0400
committerKinzcool <kinzzcool@hotmail.com>2015-07-01 17:57:09 -0400
commit4bbbd9540a25845edb0d424199bab196b5e6bea1 (patch)
tree39aa0b8c6c76390a70e5e513131cb4a777ce32e5 /sql/updates
parent97b693343586be8ec01178b6b0a02f52bee4d723 (diff)
Core/Quests: Calculate the RewardMoney value with QuestMoneyReward.dbc and defined an unknown field
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/world/2015_07_00_01_world.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/updates/world/2015_07_00_01_world.sql b/sql/updates/world/2015_07_00_01_world.sql
new file mode 100644
index 00000000000..d865df952dc
--- /dev/null
+++ b/sql/updates/world/2015_07_00_01_world.sql
@@ -0,0 +1,3 @@
+ALTER TABLE `quest_template` CHANGE `Float13` `RewardMoneyMultiplier` FLOAT NOT NULL DEFAULT '1';
+
+UPDATE `quest_template` SET `RewardMoney`=0 WHERE `RewardMoney`>0; -- non-static data