TDB 335.20082 - 2020/08/22TDB335.20082

38 files changed, 18 insertions, 9 deletions

diff --git a/revision_data.h.in.cmake b/revision_data.h.in.cmake
index eb442771506..eeab615271c 100644
--- a/revision_data.h.in.cmake
+++ b/revision_data.h.in.cmake
@@ -9,7 +9,7 @@
  #define _SOURCE_DIRECTORY          R"(@CMAKE_SOURCE_DIR@)"
  #define _BUILD_DIRECTORY           R"(@BUILDDIR@)"
  #define _MYSQL_EXECUTABLE          R"(@MYSQL_EXECUTABLE@)"
- #define _FULL_DATABASE             "TDB_full_world_335.20081_2020_08_15.sql"
+ #define _FULL_DATABASE             "TDB_full_world_335.20082_2020_08_22.sql"
  #define VER_COMPANYNAME_STR        "TrinityCore Developers"
  #define VER_LEGALCOPYRIGHT_STR     "(c)2008-2019 TrinityCore"
  #define VER_FILEVERSION            0,0,0
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index eb289e66100..62dd06db112 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -1972,7 +1972,8 @@ INSERT INTO `updates` VALUES
 ('2020_08_03_00_auth.sql','492CA77C0FAEEEF3E0492121B3A92689373ECFA3','ARCHIVED','2020-08-03 00:00:00',0),
 ('2020_08_03_01_auth.sql','EC1063396CA20A2303D83238470D41EF4439EC72','ARCHIVED','2020-08-03 00:00:01',0),
 ('2020_08_11_00_auth.sql','14C99177E43003D83A4D6F2227722F15FC15A1D0','ARCHIVED','2020-08-11 00:00:00',0),
-('2020_08_15_00_auth.sql','A49F4A776E1583B1FF63DFE99BC0E0DD97A74674','ARCHIVED','2020-08-15 09:34:44',0);
+('2020_08_15_00_auth.sql','A49F4A776E1583B1FF63DFE99BC0E0DD97A74674','ARCHIVED','2020-08-15 09:34:44',0),
+('2020_08_22_00_auth.sql','060A87FCC8F836A96D9D55BEDC32CBAD05008B4C','ARCHIVED','2020-08-22 16:27:26',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2078,4 +2079,4 @@ SET character_set_client = @saved_cs_client;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2020-08-15  9:34:48
+-- Dump completed on 2020-08-22 16:27:28
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 9afa7ba84ab..0278c79f789 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -2648,7 +2648,8 @@ INSERT INTO `updates` VALUES
 ('2020_05_15_00_characters.sql','F1C2FECAA4EB623560914E7758E0BB8364CA135A','ARCHIVED','2020-05-15 08:55:56',0),
 ('2020_06_15_00_characters.sql','99C4F85580421E928003380D8F992C4EF5E627DF','ARCHIVED','2020-06-15 07:48:08',0),
 ('2020_07_15_00_characters.sql','D87627DC6E4D222F68A1F56F0B3B986EF9A590EF','ARCHIVED','2020-07-15 10:35:41',0),
-('2020_08_15_00_characters.sql','70979D488ACD23DEB8E45D31C3ADC690A1B81F79','ARCHIVED','2020-08-15 09:34:44',0);
+('2020_08_15_00_characters.sql','70979D488ACD23DEB8E45D31C3ADC690A1B81F79','ARCHIVED','2020-08-15 09:34:44',0),
+('2020_08_22_00_characters.sql','78251072C9281D98BC4EAC523DA0858C9F8425D9','ARCHIVED','2020-08-22 16:27:27',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2819,4 +2820,4 @@ UNLOCK TABLES;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2020-08-15  9:34:48
+-- Dump completed on 2020-08-22 16:27:28
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index 8040b256142..41db59aff37 100644
--- a/sql/base/dev/world_database.sql
+++ b/sql/base/dev/world_database.sql
@@ -3842,14 +3842,14 @@ DROP TABLE IF EXISTS `warden_checks`;
 CREATE TABLE `warden_checks` (
   `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
   `type` tinyint(3) unsigned DEFAULT NULL,
-  `str` varchar(20) DEFAULT NULL,
+  `str` varchar(170) DEFAULT NULL,
   `address` int(10) unsigned DEFAULT NULL,
   `length` tinyint(3) unsigned DEFAULT NULL,
   `comment` varchar(50) DEFAULT NULL,
   `data` binary(24) DEFAULT NULL,
-  `result` varbinary(12) DEFAULT NULL,
+  `result` varbinary(24) DEFAULT NULL,
   PRIMARY KEY (`id`)
-) ENGINE=MyISAM AUTO_INCREMENT=787 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM AUTO_INCREMENT=791 DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3948,4 +3948,4 @@ CREATE TABLE `waypoints` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2020-08-15  9:34:48
+-- Dump completed on 2020-08-22 16:27:28
diff --git a/sql/updates/auth/3.3.5/2020_08_15_00_auth.sql b/sql/old/3.3.5a/auth/20081_2020_08_22/2020_08_15_00_auth.sql
index 9a33bcc953f..9a33bcc953f 100644
--- a/sql/updates/auth/3.3.5/2020_08_15_00_auth.sql
+++ b/sql/old/3.3.5a/auth/20081_2020_08_22/2020_08_15_00_auth.sql
diff --git a/sql/updates/characters/3.3.5/2020_08_15_00_characters.sql b/sql/old/3.3.5a/characters/20081_2020_08_22/2020_08_15_00_characters.sql
index 156854247e1..156854247e1 100644
--- a/sql/updates/characters/3.3.5/2020_08_15_00_characters.sql
+++ b/sql/old/3.3.5a/characters/20081_2020_08_22/2020_08_15_00_characters.sql
diff --git a/sql/updates/world/3.3.5/2020_08_15_06_world.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_15_06_world.sql
index 139364a07b5..139364a07b5 100644
--- a/sql/updates/world/3.3.5/2020_08_15_06_world.sql
+++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_15_06_world.sql
diff --git a/sql/updates/world/3.3.5/2020_08_16_00_world.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_16_00_world.sql
index 3718ba29005..3718ba29005 100644
--- a/sql/updates/world/3.3.5/2020_08_16_00_world.sql
+++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_16_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_08_16_01_world_335.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_16_01_world_335.sql
index 9602d21c286..9602d21c286 100644
--- a/sql/updates/world/3.3.5/2020_08_16_01_world_335.sql
+++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_16_01_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_08_16_02_world.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_16_02_world.sql
index f49bf28b1f7..f49bf28b1f7 100644
--- a/sql/updates/world/3.3.5/2020_08_16_02_world.sql
+++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_16_02_world.sql
diff --git a/sql/updates/world/3.3.5/2020_08_16_03_world.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_16_03_world.sql
index d058a7b51f8..d058a7b51f8 100644
--- a/sql/updates/world/3.3.5/2020_08_16_03_world.sql
+++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_16_03_world.sql
diff --git a/sql/updates/world/3.3.5/2020_08_16_04_world_335.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_16_04_world_335.sql
index cb8260b37ff..cb8260b37ff 100644
--- a/sql/updates/world/3.3.5/2020_08_16_04_world_335.sql
+++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_16_04_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_08_16_05_world.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_16_05_world.sql
index 91b5f5e6a30..91b5f5e6a30 100644
--- a/sql/updates/world/3.3.5/2020_08_16_05_world.sql
+++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_16_05_world.sql
diff --git a/sql/updates/world/3.3.5/2020_08_16_06_world_335.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_16_06_world_335.sql
index a381ec7702b..a381ec7702b 100644
--- a/sql/updates/world/3.3.5/2020_08_16_06_world_335.sql
+++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_16_06_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_08_16_07_world.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_16_07_world.sql
index 040f8963412..040f8963412 100644
--- a/sql/updates/world/3.3.5/2020_08_16_07_world.sql
+++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_16_07_world.sql
diff --git a/sql/updates/world/3.3.5/2020_08_17_00_world.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_17_00_world.sql
index 901c5742eac..901c5742eac 100644
--- a/sql/updates/world/3.3.5/2020_08_17_00_world.sql
+++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_17_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_08_17_01_world.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_17_01_world.sql
index 27672b109f5..27672b109f5 100644
--- a/sql/updates/world/3.3.5/2020_08_17_01_world.sql
+++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_17_01_world.sql
diff --git a/sql/updates/world/3.3.5/2020_08_17_02_world.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_17_02_world.sql
index b850fd391e2..b850fd391e2 100644
--- a/sql/updates/world/3.3.5/2020_08_17_02_world.sql
+++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_17_02_world.sql
diff --git a/sql/updates/world/3.3.5/2020_08_18_00_world_335.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_18_00_world_335.sql
index b8187b1706e..b8187b1706e 100644
--- a/sql/updates/world/3.3.5/2020_08_18_00_world_335.sql
+++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_18_00_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_08_18_01_world_335.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_18_01_world_335.sql
index 99b353b3121..99b353b3121 100644
--- a/sql/updates/world/3.3.5/2020_08_18_01_world_335.sql
+++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_18_01_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_08_18_02_world_335.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_18_02_world_335.sql
index 1734140c64c..1734140c64c 100644
--- a/sql/updates/world/3.3.5/2020_08_18_02_world_335.sql
+++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_18_02_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_08_18_03_world.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_18_03_world.sql
index 96a20f57938..96a20f57938 100644
--- a/sql/updates/world/3.3.5/2020_08_18_03_world.sql
+++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_18_03_world.sql
diff --git a/sql/updates/world/3.3.5/2020_08_18_04_world.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_18_04_world.sql
index b64aa312288..b64aa312288 100644
--- a/sql/updates/world/3.3.5/2020_08_18_04_world.sql
+++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_18_04_world.sql
diff --git a/sql/updates/world/3.3.5/2020_08_18_05_world.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_18_05_world.sql
index d4aeeb104df..d4aeeb104df 100644
--- a/sql/updates/world/3.3.5/2020_08_18_05_world.sql
+++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_18_05_world.sql
diff --git a/sql/updates/world/3.3.5/2020_08_18_06_world.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_18_06_world.sql
index e1c80df1475..e1c80df1475 100644
--- a/sql/updates/world/3.3.5/2020_08_18_06_world.sql
+++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_18_06_world.sql
diff --git a/sql/updates/world/3.3.5/2020_08_20_00_world.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_20_00_world.sql
index e599ed191d1..e599ed191d1 100644
--- a/sql/updates/world/3.3.5/2020_08_20_00_world.sql
+++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_20_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_08_20_01_world.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_20_01_world.sql
index e4d1a60b44f..e4d1a60b44f 100644
--- a/sql/updates/world/3.3.5/2020_08_20_01_world.sql
+++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_20_01_world.sql
diff --git a/sql/updates/world/3.3.5/2020_08_21_00_world.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_21_00_world.sql
index fbe7598a97b..fbe7598a97b 100644
--- a/sql/updates/world/3.3.5/2020_08_21_00_world.sql
+++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_21_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_08_21_01_world.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_21_01_world.sql
index 217e6b5ce46..217e6b5ce46 100644
--- a/sql/updates/world/3.3.5/2020_08_21_01_world.sql
+++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_21_01_world.sql
diff --git a/sql/updates/world/3.3.5/2020_08_21_02_world_335.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_21_02_world_335.sql
index 0950d59a4f5..0950d59a4f5 100644
--- a/sql/updates/world/3.3.5/2020_08_21_02_world_335.sql
+++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_21_02_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_08_21_03_world_335.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_21_03_world_335.sql
index 3b68f6745fe..3b68f6745fe 100644
--- a/sql/updates/world/3.3.5/2020_08_21_03_world_335.sql
+++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_21_03_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_08_21_04_world.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_21_04_world.sql
index 029a6ac41c6..029a6ac41c6 100644
--- a/sql/updates/world/3.3.5/2020_08_21_04_world.sql
+++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_21_04_world.sql
diff --git a/sql/updates/world/3.3.5/2020_08_21_05_world_335.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_21_05_world_335.sql
index 1a20316476b..1a20316476b 100644
--- a/sql/updates/world/3.3.5/2020_08_21_05_world_335.sql
+++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_21_05_world_335.sql
diff --git a/sql/updates/world/3.3.5/2020_08_22_00_world.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_22_00_world.sql
index 6b32776d0d7..6b32776d0d7 100644
--- a/sql/updates/world/3.3.5/2020_08_22_00_world.sql
+++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_22_00_world.sql
diff --git a/sql/updates/world/3.3.5/2020_08_22_01_world.sql b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_22_01_world.sql
index 12e1482b84d..12e1482b84d 100644
--- a/sql/updates/world/3.3.5/2020_08_22_01_world.sql
+++ b/sql/old/3.3.5a/world/20081_2020_08_22/2020_08_22_01_world.sql
diff --git a/sql/updates/auth/3.3.5/2020_08_22_00_auth.sql b/sql/updates/auth/3.3.5/2020_08_22_00_auth.sql
new file mode 100644
index 00000000000..bd3423adffd
--- /dev/null
+++ b/sql/updates/auth/3.3.5/2020_08_22_00_auth.sql
@@ -0,0 +1,2 @@
+-- TDB 335.20082 auth
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/characters/3.3.5/2020_08_22_00_characters.sql b/sql/updates/characters/3.3.5/2020_08_22_00_characters.sql
new file mode 100644
index 00000000000..f5d9494240b
--- /dev/null
+++ b/sql/updates/characters/3.3.5/2020_08_22_00_characters.sql
@@ -0,0 +1,2 @@
+-- TDB 335.20082 characters
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/world/3.3.5/2020_08_22_02_world.sql b/sql/updates/world/3.3.5/2020_08_22_02_world.sql
new file mode 100644
index 00000000000..88b0ab9a224
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_08_22_02_world.sql
@@ -0,0 +1,3 @@
+-- TDB 335.20082 world
+UPDATE `version` SET `db_version`='TDB 335.20082', `cache_id`=20082 LIMIT 1;
+UPDATE `updates` SET `state`='ARCHIVED';