summaryrefslogtreecommitdiff
path: root/sql-files/upgrades
diff options
context:
space:
mode:
authorlemongrass3110 <lemongrass3110@54d463be-8e91-2dee-dedb-b68131a5f0ec>2013-03-06 21:38:39 +0000
committerStreusel <advance_me@hotmail.de>2013-03-06 22:08:16 -0800
commit64dc4dbf9cb954f5359ba1fe932fb77042112464 (patch)
treeb4b50de53562ad6a13dcb9bfbee962d573e617c5 /sql-files/upgrades
parent7bafb75f42dd00364da646477cadbaf75652a4e2 (diff)
downloadhercules-64dc4dbf9cb954f5359ba1fe932fb77042112464.tar.gz
hercules-64dc4dbf9cb954f5359ba1fe932fb77042112464.tar.bz2
hercules-64dc4dbf9cb954f5359ba1fe932fb77042112464.tar.xz
hercules-64dc4dbf9cb954f5359ba1fe932fb77042112464.zip
Updated dewata to match the official scripts.
This commit includes a optional SQL upgrade file, that will reset all the dewata quests and the related variables, that your users have done. Thanks to Euphy for helping me and additionally thanks to Flaid for taking his time to test our conversion. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17178 54d463be-8e91-2dee-dedb-b68131a5f0ec
Diffstat (limited to 'sql-files/upgrades')
-rw-r--r--sql-files/upgrades/upgrade_svn17178.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/sql-files/upgrades/upgrade_svn17178.sql b/sql-files/upgrades/upgrade_svn17178.sql
new file mode 100644
index 000000000..02c4c1475
--- /dev/null
+++ b/sql-files/upgrades/upgrade_svn17178.sql
@@ -0,0 +1,7 @@
+-- This script resets all quests that were done by your users before this revision
+-- Author: Euphy
+DELETE FROM `quest` WHERE `quest_id` > 5034 AND `quest_id` < 5055;
+DELETE FROM `quest` WHERE `quest_id` > 9154 AND `quest_id` < 9166;
+DELETE FROM `global_reg_value` WHERE `str` = 'dewata_gatti';
+DELETE FROM `global_reg_value` WHERE `str` = 'dewata_legend';
+DELETE FROM `global_reg_value` WHERE `str` = 'dewata_oldman';