diff options
| author | Brian <runningnak3d@gmail.com> | 2010-07-22 13:41:19 -0600 |
|---|---|---|
| committer | Brian <runningnak3d@gmail.com> | 2010-07-22 13:41:19 -0600 |
| commit | c8662c888b7b809189c3aedd2f4a7c0403f6456e (patch) | |
| tree | 25488e75eafdc96921682f9351d90f730f4e8a20 /sql | |
| parent | 903a3cbe76e570cabbc592db83bbbead97905631 (diff) | |
* 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
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/characters_database.sql | 3 | ||||
| -rw-r--r-- | sql/updates/8986_characters_worldstates.sql | 3 |
2 files changed, 5 insertions, 1 deletions
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'); |