Another fix quest flags, Implement support weekly quests cooldowns(Original patch by GriffonHeart), also code cleanups.

--HG--
branch : trunk

3 files changed, 30 insertions, 0 deletions

diff --git a/sql/characters.sql b/sql/characters.sql
index a57adbf0744..c6dafbe533d 100644
--- a/sql/characters.sql
+++ b/sql/characters.sql
@@ -914,6 +914,27 @@ LOCK TABLES `character_queststatus_daily` WRITE;
 UNLOCK TABLES;
 
 --
+-- Table structure for table `character_queststatus_weekly`
+--
+
+DROP TABLE IF EXISTS `character_queststatus_weekly`;
+CREATE TABLE `character_queststatus_weekly` (
+  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
+  `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
+  PRIMARY KEY  (`guid`,`quest`),
+  KEY `idx_guid` (`guid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
+
+--
+-- Dumping data for table `character_queststatus_weekly`
+--
+
+LOCK TABLES `character_queststatus_weekly` WRITE;
+/*!40000 ALTER TABLE `character_queststatus_weekly` DISABLE KEYS */;
+/*!40000 ALTER TABLE `character_queststatus_weekly` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
 -- Table structure for table `character_reputation`
 --
 
@@ -1915,6 +1936,7 @@ DROP TABLE IF EXISTS `worldstates`;
 CREATE TABLE `worldstates` (
   `entry` mediumint(11) UNSIGNED NOT NULL DEFAULT '0',
   `value` bigint(40) UNSIGNED NOT NULL DEFAULT '0',
+  `NextWeeklyQuestResetTime` bigint(40) unsigned NOT NULL default '0',
   `comment` text NOT NULL,
   PRIMARY KEY  (`entry`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Variable Saves';
diff --git a/sql/updates/7914_characters_character_queststatus_weekly.sql b/sql/updates/7914_characters_character_queststatus_weekly.sql
new file mode 100644
index 00000000000..1bced542b9f
--- /dev/null
+++ b/sql/updates/7914_characters_character_queststatus_weekly.sql
@@ -0,0 +1,7 @@
+DROP TABLE IF EXISTS `character_queststatus_weekly`;
+CREATE TABLE `character_queststatus_weekly` (
+  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
+  `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
+  PRIMARY KEY  (`guid`,`quest`),
+  KEY `idx_guid` (`guid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
diff --git a/sql/updates/7914_characters_worldstates.sql b/sql/updates/7914_characters_worldstates.sql
new file mode 100644
index 00000000000..5b150518e87
--- /dev/null
+++ b/sql/updates/7914_characters_worldstates.sql
@@ -0,0 +1 @@
+ALTER TABLE `worldstates` ADD COLUMN `NextWeeklyQuestResetTime` bigint(40) unsigned NOT NULL default '0' AFTER `value`;