diff options
| author | lemongrass3110 <lemongrass3110@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2013-03-06 21:38:39 +0000 |
|---|---|---|
| committer | Streusel <advance_me@hotmail.de> | 2013-03-06 22:08:16 -0800 |
| commit | 64dc4dbf9cb954f5359ba1fe932fb77042112464 (patch) | |
| tree | b4b50de53562ad6a13dcb9bfbee962d573e617c5 /sql-files/upgrades/upgrade_svn17178.sql | |
| parent | 7bafb75f42dd00364da646477cadbaf75652a4e2 (diff) | |
| download | hercules-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/upgrade_svn17178.sql')
| -rw-r--r-- | sql-files/upgrades/upgrade_svn17178.sql | 7 |
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'; |