From 64dc4dbf9cb954f5359ba1fe932fb77042112464 Mon Sep 17 00:00:00 2001 From: lemongrass3110 Date: Wed, 6 Mar 2013 21:38:39 +0000 Subject: 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 --- sql-files/upgrades/upgrade_svn17178.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 sql-files/upgrades/upgrade_svn17178.sql (limited to 'sql-files/upgrades') 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'; -- cgit v1.2.3-60-g2f50