TDB 335.21041 - 2021/04/16TDB335.21041

47 files changed, 15 insertions, 6 deletions

diff --git a/revision_data.h.in.cmake b/revision_data.h.in.cmake
index 057dfa7ab0e..a539e984489 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.21031_2021_03_15.sql"
+ #define _FULL_DATABASE             "TDB_full_world_335.21041_2021_04_16.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 939cdcaaf15..843bc05a772 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -1983,7 +1983,8 @@ INSERT INTO `updates` VALUES
 ('2020_12_31_00_auth.sql','05C9C105D55C6588CDA0D75AE3B135B7E6B54C06','ARCHIVED','2020-12-31 12:58:21',0),
 ('2021_01_15_00_auth.sql','604B8B799F031C1074314D4D8081797CC8B22FE2','ARCHIVED','2021-01-15 08:29:32',0),
 ('2021_02_15_00_auth.sql','652C38A140C0B2C7E898A2F7A7AC799CA2440315','ARCHIVED','2021-02-15 12:37:46',0),
-('2021_03_15_00_auth.sql','571D2FD6A62F066CC789C73A4ECDD613C6FF5F10','ARCHIVED','2021-03-15 17:31:39',0);
+('2021_03_15_00_auth.sql','571D2FD6A62F066CC789C73A4ECDD613C6FF5F10','ARCHIVED','2021-03-15 17:31:39',0),
+('2021_04_16_00_auth.sql','737670762C2AE4E04BFC2C2B0B6F3C71DCDF6C44','ARCHIVED','2021-04-16 21:23:03',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2089,4 +2090,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 2021-03-15 17:31:41
+-- Dump completed on 2021-04-16 21:23:04
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 03aaa7e3f56..78495d11744 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -2659,7 +2659,8 @@ INSERT INTO `updates` VALUES
 ('2020_12_15_00_characters.sql','650EE26F85517977FBDEB42CCB97CEFA6462502E','ARCHIVED','2020-12-15 22:47:26',0),
 ('2021_01_15_00_characters.sql','4D3A4C71ACD4CB04B014C300E1D0B33C0699DBE7','ARCHIVED','2021-01-15 08:29:32',0),
 ('2021_02_15_00_characters.sql','53D94CFC60329E7BD036B77D4B298785AF57AD79','ARCHIVED','2021-02-15 12:37:46',0),
-('2021_03_15_00_characters.sql','D6274D688A3E2A4F727B565481D99A49E9C642D4','ARCHIVED','2021-03-15 17:31:39',0);
+('2021_03_15_00_characters.sql','D6274D688A3E2A4F727B565481D99A49E9C642D4','ARCHIVED','2021-03-15 17:31:39',0),
+('2021_04_16_00_characters.sql','0EBBF50CE3EB1197973E403C2F1D60881BB497FD','ARCHIVED','2021-04-16 21:23:03',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2830,4 +2831,4 @@ UNLOCK TABLES;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2021-03-15 17:31:41
+-- Dump completed on 2021-04-16 21:23:04
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index 153694c5be8..6a4ffa97503 100644
--- a/sql/base/dev/world_database.sql
+++ b/sql/base/dev/world_database.sql
@@ -4044,4 +4044,4 @@ CREATE TABLE `waypoints` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2021-03-15 17:31:41
+-- Dump completed on 2021-04-16 21:23:05
diff --git a/sql/updates/auth/3.3.5/2021_03_15_00_auth.sql b/sql/old/3.3.5a/auth/21031_2021_04_16/2021_03_15_00_auth.sql
index 7c68d568449..7c68d568449 100644
--- a/sql/updates/auth/3.3.5/2021_03_15_00_auth.sql
+++ b/sql/old/3.3.5a/auth/21031_2021_04_16/2021_03_15_00_auth.sql
diff --git a/sql/updates/characters/3.3.5/2021_03_15_00_characters.sql b/sql/old/3.3.5a/characters/21031_2021_04_16/2021_03_15_00_characters.sql
index 4785b9a4004..4785b9a4004 100644
--- a/sql/updates/characters/3.3.5/2021_03_15_00_characters.sql
+++ b/sql/old/3.3.5a/characters/21031_2021_04_16/2021_03_15_00_characters.sql
diff --git a/sql/updates/world/3.3.5/2021_03_15_02_world.sql b/sql/old/3.3.5a/world/21031_2021_04_16/2021_03_15_02_world.sql
index 48d3a4927fc..48d3a4927fc 100644
--- a/sql/updates/world/3.3.5/2021_03_15_02_world.sql
+++ b/sql/old/3.3.5a/world/21031_2021_04_16/2021_03_15_02_world.sql
diff --git a/sql/updates/world/3.3.5/2021_03_17_00_world_335.sql b/sql/old/3.3.5a/world/21031_2021_04_16/2021_03_17_00_world_335.sql
index 7a48448f94b..7a48448f94b 100644
--- a/sql/updates/world/3.3.5/2021_03_17_00_world_335.sql
+++ b/sql/old/3.3.5a/world/21031_2021_04_16/2021_03_17_00_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_03_17_01_world_335.sql b/sql/old/3.3.5a/world/21031_2021_04_16/2021_03_17_01_world_335.sql
index 98aeb6e1f3a..98aeb6e1f3a 100644
--- a/sql/updates/world/3.3.5/2021_03_17_01_world_335.sql
+++ b/sql/old/3.3.5a/world/21031_2021_04_16/2021_03_17_01_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_03_17_02_world.sql b/sql/old/3.3.5a/world/21031_2021_04_16/2021_03_17_02_world.sql
index 9d551624e24..9d551624e24 100644
--- a/sql/updates/world/3.3.5/2021_03_17_02_world.sql
+++ b/sql/old/3.3.5a/world/21031_2021_04_16/2021_03_17_02_world.sql
diff --git a/sql/updates/world/3.3.5/2021_03_17_03_world.sql b/sql/old/3.3.5a/world/21031_2021_04_16/2021_03_17_03_world.sql
index c703fb8af0b..c703fb8af0b 100644
--- a/sql/updates/world/3.3.5/2021_03_17_03_world.sql
+++ b/sql/old/3.3.5a/world/21031_2021_04_16/2021_03_17_03_world.sql
diff --git a/sql/updates/world/3.3.5/2021_03_17_04_world.sql b/sql/old/3.3.5a/world/21031_2021_04_16/2021_03_17_04_world.sql
index 5c416d1aa76..5c416d1aa76 100644
--- a/sql/updates/world/3.3.5/2021_03_17_04_world.sql
+++ b/sql/old/3.3.5a/world/21031_2021_04_16/2021_03_17_04_world.sql
diff --git a/sql/updates/world/3.3.5/2021_03_17_05_world_335.sql b/sql/old/3.3.5a/world/21031_2021_04_16/2021_03_17_05_world_335.sql
index 2671e19d264..2671e19d264 100644
--- a/sql/updates/world/3.3.5/2021_03_17_05_world_335.sql
+++ b/sql/old/3.3.5a/world/21031_2021_04_16/2021_03_17_05_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_03_19_00_world_335.sql b/sql/old/3.3.5a/world/21031_2021_04_16/2021_03_19_00_world_335.sql
index 117a35b3975..117a35b3975 100644
--- a/sql/updates/world/3.3.5/2021_03_19_00_world_335.sql
+++ b/sql/old/3.3.5a/world/21031_2021_04_16/2021_03_19_00_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_03_19_01_world_335.sql b/sql/old/3.3.5a/world/21031_2021_04_16/2021_03_19_01_world_335.sql
index 8acace4945c..8acace4945c 100644
--- a/sql/updates/world/3.3.5/2021_03_19_01_world_335.sql
+++ b/sql/old/3.3.5a/world/21031_2021_04_16/2021_03_19_01_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_03_19_02_world_335.sql b/sql/old/3.3.5a/world/21031_2021_04_16/2021_03_19_02_world_335.sql
index 4a9628b4199..4a9628b4199 100644
--- a/sql/updates/world/3.3.5/2021_03_19_02_world_335.sql
+++ b/sql/old/3.3.5a/world/21031_2021_04_16/2021_03_19_02_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_03_19_03_world_335.sql b/sql/old/3.3.5a/world/21031_2021_04_16/2021_03_19_03_world_335.sql
index 0989eacc286..0989eacc286 100644
--- a/sql/updates/world/3.3.5/2021_03_19_03_world_335.sql
+++ b/sql/old/3.3.5a/world/21031_2021_04_16/2021_03_19_03_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_03_19_04_world_335.sql b/sql/old/3.3.5a/world/21031_2021_04_16/2021_03_19_04_world_335.sql
index 600caad4b58..600caad4b58 100644
--- a/sql/updates/world/3.3.5/2021_03_19_04_world_335.sql
+++ b/sql/old/3.3.5a/world/21031_2021_04_16/2021_03_19_04_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_03_19_05_world_335.sql b/sql/old/3.3.5a/world/21031_2021_04_16/2021_03_19_05_world_335.sql
index 7f2f567d419..7f2f567d419 100644
--- a/sql/updates/world/3.3.5/2021_03_19_05_world_335.sql
+++ b/sql/old/3.3.5a/world/21031_2021_04_16/2021_03_19_05_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_03_19_06_world.sql b/sql/old/3.3.5a/world/21031_2021_04_16/2021_03_19_06_world.sql
index 64eb7c8a24f..64eb7c8a24f 100644
--- a/sql/updates/world/3.3.5/2021_03_19_06_world.sql
+++ b/sql/old/3.3.5a/world/21031_2021_04_16/2021_03_19_06_world.sql
diff --git a/sql/updates/world/3.3.5/2021_03_20_00_world.sql b/sql/old/3.3.5a/world/21031_2021_04_16/2021_03_20_00_world.sql
index 064b2adba20..064b2adba20 100644
--- a/sql/updates/world/3.3.5/2021_03_20_00_world.sql
+++ b/sql/old/3.3.5a/world/21031_2021_04_16/2021_03_20_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_03_20_01_world_335.sql b/sql/old/3.3.5a/world/21031_2021_04_16/2021_03_20_01_world_335.sql
index 8f135b6f695..8f135b6f695 100644
--- a/sql/updates/world/3.3.5/2021_03_20_01_world_335.sql
+++ b/sql/old/3.3.5a/world/21031_2021_04_16/2021_03_20_01_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_03_22_00_world.sql b/sql/old/3.3.5a/world/21031_2021_04_16/2021_03_22_00_world.sql
index 12286882fb4..12286882fb4 100644
--- a/sql/updates/world/3.3.5/2021_03_22_00_world.sql
+++ b/sql/old/3.3.5a/world/21031_2021_04_16/2021_03_22_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_03_22_01_world_335.sql b/sql/old/3.3.5a/world/21031_2021_04_16/2021_03_22_01_world_335.sql
index 06258b6df48..06258b6df48 100644
--- a/sql/updates/world/3.3.5/2021_03_22_01_world_335.sql
+++ b/sql/old/3.3.5a/world/21031_2021_04_16/2021_03_22_01_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_03_23_00_world_335.sql b/sql/old/3.3.5a/world/21031_2021_04_16/2021_03_23_00_world_335.sql
index 6e2abc9b325..6e2abc9b325 100644
--- a/sql/updates/world/3.3.5/2021_03_23_00_world_335.sql
+++ b/sql/old/3.3.5a/world/21031_2021_04_16/2021_03_23_00_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_03_23_01_world.sql b/sql/old/3.3.5a/world/21031_2021_04_16/2021_03_23_01_world.sql
index 338ed5c958d..338ed5c958d 100644
--- a/sql/updates/world/3.3.5/2021_03_23_01_world.sql
+++ b/sql/old/3.3.5a/world/21031_2021_04_16/2021_03_23_01_world.sql
diff --git a/sql/updates/world/3.3.5/2021_04_02_00_world_335.sql b/sql/old/3.3.5a/world/21031_2021_04_16/2021_04_02_00_world_335.sql
index 1eacd65eeaf..1eacd65eeaf 100644
--- a/sql/updates/world/3.3.5/2021_04_02_00_world_335.sql
+++ b/sql/old/3.3.5a/world/21031_2021_04_16/2021_04_02_00_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_04_02_01_world_335.sql b/sql/old/3.3.5a/world/21031_2021_04_16/2021_04_02_01_world_335.sql
index 40c14c06b70..40c14c06b70 100644
--- a/sql/updates/world/3.3.5/2021_04_02_01_world_335.sql
+++ b/sql/old/3.3.5a/world/21031_2021_04_16/2021_04_02_01_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_04_02_02_world_335.sql b/sql/old/3.3.5a/world/21031_2021_04_16/2021_04_02_02_world_335.sql
index e1b32ac7190..e1b32ac7190 100644
--- a/sql/updates/world/3.3.5/2021_04_02_02_world_335.sql
+++ b/sql/old/3.3.5a/world/21031_2021_04_16/2021_04_02_02_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_04_02_03_world_335.sql b/sql/old/3.3.5a/world/21031_2021_04_16/2021_04_02_03_world_335.sql
index 90e38fdb857..90e38fdb857 100644
--- a/sql/updates/world/3.3.5/2021_04_02_03_world_335.sql
+++ b/sql/old/3.3.5a/world/21031_2021_04_16/2021_04_02_03_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_04_02_04_world_335.sql b/sql/old/3.3.5a/world/21031_2021_04_16/2021_04_02_04_world_335.sql
index 389f808e583..389f808e583 100644
--- a/sql/updates/world/3.3.5/2021_04_02_04_world_335.sql
+++ b/sql/old/3.3.5a/world/21031_2021_04_16/2021_04_02_04_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_04_02_05_world_335.sql b/sql/old/3.3.5a/world/21031_2021_04_16/2021_04_02_05_world_335.sql
index 552d5c9d7b0..552d5c9d7b0 100644
--- a/sql/updates/world/3.3.5/2021_04_02_05_world_335.sql
+++ b/sql/old/3.3.5a/world/21031_2021_04_16/2021_04_02_05_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_04_02_06_world.sql b/sql/old/3.3.5a/world/21031_2021_04_16/2021_04_02_06_world.sql
index 2a9c8d7ad36..2a9c8d7ad36 100644
--- a/sql/updates/world/3.3.5/2021_04_02_06_world.sql
+++ b/sql/old/3.3.5a/world/21031_2021_04_16/2021_04_02_06_world.sql
diff --git a/sql/updates/world/3.3.5/2021_04_03_00_world.sql b/sql/old/3.3.5a/world/21031_2021_04_16/2021_04_03_00_world.sql
index 68ba0c10a95..68ba0c10a95 100644
--- a/sql/updates/world/3.3.5/2021_04_03_00_world.sql
+++ b/sql/old/3.3.5a/world/21031_2021_04_16/2021_04_03_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_04_09_00_world.sql b/sql/old/3.3.5a/world/21031_2021_04_16/2021_04_09_00_world.sql
index d67315eefbf..d67315eefbf 100644
--- a/sql/updates/world/3.3.5/2021_04_09_00_world.sql
+++ b/sql/old/3.3.5a/world/21031_2021_04_16/2021_04_09_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_04_09_01_world.sql b/sql/old/3.3.5a/world/21031_2021_04_16/2021_04_09_01_world.sql
index 896265acb7b..896265acb7b 100644
--- a/sql/updates/world/3.3.5/2021_04_09_01_world.sql
+++ b/sql/old/3.3.5a/world/21031_2021_04_16/2021_04_09_01_world.sql
diff --git a/sql/updates/world/3.3.5/2021_04_09_02_world.sql b/sql/old/3.3.5a/world/21031_2021_04_16/2021_04_09_02_world.sql
index 8d2c3f419f6..8d2c3f419f6 100644
--- a/sql/updates/world/3.3.5/2021_04_09_02_world.sql
+++ b/sql/old/3.3.5a/world/21031_2021_04_16/2021_04_09_02_world.sql
diff --git a/sql/updates/world/3.3.5/2021_04_13_00_world.sql b/sql/old/3.3.5a/world/21031_2021_04_16/2021_04_13_00_world.sql
index 3be0b0db8f8..3be0b0db8f8 100644
--- a/sql/updates/world/3.3.5/2021_04_13_00_world.sql
+++ b/sql/old/3.3.5a/world/21031_2021_04_16/2021_04_13_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_04_13_01_world.sql b/sql/old/3.3.5a/world/21031_2021_04_16/2021_04_13_01_world.sql
index cdcbd1004da..cdcbd1004da 100644
--- a/sql/updates/world/3.3.5/2021_04_13_01_world.sql
+++ b/sql/old/3.3.5a/world/21031_2021_04_16/2021_04_13_01_world.sql
diff --git a/sql/updates/world/3.3.5/2021_04_13_02_world_335.sql b/sql/old/3.3.5a/world/21031_2021_04_16/2021_04_13_02_world_335.sql
index fe4d3038bf4..fe4d3038bf4 100644
--- a/sql/updates/world/3.3.5/2021_04_13_02_world_335.sql
+++ b/sql/old/3.3.5a/world/21031_2021_04_16/2021_04_13_02_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_04_13_03_world_335.sql b/sql/old/3.3.5a/world/21031_2021_04_16/2021_04_13_03_world_335.sql
index 15b33bf99df..15b33bf99df 100644
--- a/sql/updates/world/3.3.5/2021_04_13_03_world_335.sql
+++ b/sql/old/3.3.5a/world/21031_2021_04_16/2021_04_13_03_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_04_13_04_world_335.sql b/sql/old/3.3.5a/world/21031_2021_04_16/2021_04_13_04_world_335.sql
index 67d93ed6c57..67d93ed6c57 100644
--- a/sql/updates/world/3.3.5/2021_04_13_04_world_335.sql
+++ b/sql/old/3.3.5a/world/21031_2021_04_16/2021_04_13_04_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_04_13_05_world.sql b/sql/old/3.3.5a/world/21031_2021_04_16/2021_04_13_05_world.sql
index a61651de5d5..a61651de5d5 100644
--- a/sql/updates/world/3.3.5/2021_04_13_05_world.sql
+++ b/sql/old/3.3.5a/world/21031_2021_04_16/2021_04_13_05_world.sql
diff --git a/sql/updates/world/3.3.5/2021_04_13_06_world.sql b/sql/old/3.3.5a/world/21031_2021_04_16/2021_04_13_06_world.sql
index 6e8a27be033..6e8a27be033 100644
--- a/sql/updates/world/3.3.5/2021_04_13_06_world.sql
+++ b/sql/old/3.3.5a/world/21031_2021_04_16/2021_04_13_06_world.sql
diff --git a/sql/updates/auth/3.3.5/2021_04_16_00_auth.sql b/sql/updates/auth/3.3.5/2021_04_16_00_auth.sql
new file mode 100644
index 00000000000..aca5815f15b
--- /dev/null
+++ b/sql/updates/auth/3.3.5/2021_04_16_00_auth.sql
@@ -0,0 +1,2 @@
+-- TDB 335.21041 auth
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/characters/3.3.5/2021_04_16_00_characters.sql b/sql/updates/characters/3.3.5/2021_04_16_00_characters.sql
new file mode 100644
index 00000000000..90b2469af87
--- /dev/null
+++ b/sql/updates/characters/3.3.5/2021_04_16_00_characters.sql
@@ -0,0 +1,2 @@
+-- TDB 335.21041 characters
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/world/3.3.5/2021_04_16_00_world.sql b/sql/updates/world/3.3.5/2021_04_16_00_world.sql
new file mode 100644
index 00000000000..c62bf3f63d4
--- /dev/null
+++ b/sql/updates/world/3.3.5/2021_04_16_00_world.sql
@@ -0,0 +1,3 @@
+-- TDB 335.21041 world
+UPDATE `version` SET `db_version`='TDB 335.21041', `cache_id`=21041 LIMIT 1;
+UPDATE `updates` SET `state`='ARCHIVED';