From 64dc4dbf9cb954f5359ba1fe932fb77042112464 Mon Sep 17 00:00:00 2001
From: lemongrass3110 <lemongrass3110@54d463be-8e91-2dee-dedb-b68131a5f0ec>
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/upgrade_svn17178.sql')

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-70-g09d2

