summaryrefslogtreecommitdiff
path: root/sql-files/upgrades/2013-11-15--19-57.sql
diff options
context:
space:
mode:
authorshennetsind <ind@henn.et>2013-11-15 18:02:59 -0200
committershennetsind <ind@henn.et>2013-11-15 18:02:59 -0200
commit40262e063a7d503104667a4135c564d996bc49c6 (patch)
tree904a7f504b5550b23fa6835e088a41da7ebd8d64 /sql-files/upgrades/2013-11-15--19-57.sql
parente249264cb8370c2d3143197308e0d0dca69a71a9 (diff)
downloadhercules-40262e063a7d503104667a4135c564d996bc49c6.tar.gz
hercules-40262e063a7d503104667a4135c564d996bc49c6.tar.bz2
hercules-40262e063a7d503104667a4135c564d996bc49c6.tar.xz
hercules-40262e063a7d503104667a4135c564d996bc49c6.zip
Updated `account_data` upgrade files
to avoid issues as demonstrated by report 7824 http://hercules.ws/board/tracker/issue-7824-exp-and-drop-rates-in-lat/ Special Thanks to Yommy! Signed-off-by: shennetsind <ind@henn.et>
Diffstat (limited to 'sql-files/upgrades/2013-11-15--19-57.sql')
-rw-r--r--sql-files/upgrades/2013-11-15--19-57.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql-files/upgrades/2013-11-15--19-57.sql b/sql-files/upgrades/2013-11-15--19-57.sql
new file mode 100644
index 000000000..0644c47c9
--- /dev/null
+++ b/sql-files/upgrades/2013-11-15--19-57.sql
@@ -0,0 +1,5 @@
+#1384545461
+UPDATE `account_data` SET `base_exp` = '100' WHERE `base_exp` = '0';
+UPDATE `account_data` SET `base_drop` = '100' WHERE `base_drop` = '0';
+UPDATE `account_data` SET `base_death` = '100' WHERE `base_death` = '0';
+INSERT INTO `sql_updates` (`timestamp`) VALUES (1384545461); \ No newline at end of file