From c8662c888b7b809189c3aedd2f4a7c0403f6456e Mon Sep 17 00:00:00 2001
From: Brian <runningnak3d@gmail.com>
Date: Thu, 22 Jul 2010 13:41:19 -0600
Subject: * Implemented DB cleaning on startup * Must be enabled in conf AND
 set in worldstates for what you want to clean *
 CLEANING_FLAG_ACHIEVEMENT_PROGRESS  = 0x1, * CLEANING_FLAG_SKILLS            
    = 0x2, * CLEANING_FLAG_SPELLS                = 0x4, *
 CLEANING_FLAG_TALENTS               = 0x8 * Set to 0xF to clean all 4 * Patch
 by hunuza

--HG--
branch : trunk
---
 sql/base/characters_database.sql            | 3 ++-
 sql/updates/8986_characters_worldstates.sql | 3 +++
 2 files changed, 5 insertions(+), 1 deletion(-)
 create mode 100644 sql/updates/8986_characters_worldstates.sql

(limited to 'sql')

diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 4dc67ef97a1..16ed16de332 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -1976,7 +1976,8 @@ LOCK TABLES `worldstates` WRITE;
 INSERT INTO `worldstates` (`entry`,`value`, `comment`) VALUES 
 (20001, 0, 'NextArenaPointDistributionTime'),
 (20002, 0, 'NextWeeklyQuestResetTime'),
-(20003, 0, 'NextBGRandomDailyResetTime');
+(20003, 0, 'NextBGRandomDailyResetTime'),
+(20004, 0, 'cleaning_flags');
 /*!40000 ALTER TABLE `worldstates` ENABLE KEYS */;
 UNLOCK TABLES;
 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
diff --git a/sql/updates/8986_characters_worldstates.sql b/sql/updates/8986_characters_worldstates.sql
new file mode 100644
index 00000000000..78234428a37
--- /dev/null
+++ b/sql/updates/8986_characters_worldstates.sql
@@ -0,0 +1,3 @@
+
+DELETE FROM `worldstates` WHERE `entry`=20004;
+INSERT INTO `worldstates` (`entry`,`value`,`comment`) VALUES (20004,0, 'cleaning_flags');
-- 
cgit v1.2.3