TDB 335.21061 - 2021/06/15TDB335.21061

48 files changed, 15 insertions, 6 deletions

diff --git a/revision_data.h.in.cmake b/revision_data.h.in.cmake
index 53835b82429..627e43a2ac0 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.21051_2021_05_14.sql"
+ #define _FULL_DATABASE             "TDB_full_world_335.21061_2021_06_15.sql"
  #define VER_COMPANYNAME_STR        "TrinityCore Developers"
  #define VER_LEGALCOPYRIGHT_STR     "(c)2008-@rev_year@ TrinityCore"
  #define VER_FILEVERSION            0,0,0
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index f28e5ac087e..4b08598a29c 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -1985,7 +1985,8 @@ INSERT INTO `updates` VALUES
 ('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_04_16_00_auth.sql','737670762C2AE4E04BFC2C2B0B6F3C71DCDF6C44','ARCHIVED','2021-04-16 21:23:03',0),
-('2021_05_14_00_auth.sql','B89998D90CCFEB2480838D417AC9661372A6B959','ARCHIVED','2021-05-14 12:20:33',0);
+('2021_05_14_00_auth.sql','B89998D90CCFEB2480838D417AC9661372A6B959','ARCHIVED','2021-05-14 12:20:33',0),
+('2021_06_15_00_auth.sql','DAFFA7699D3BF0A15AE72321AFC9F7D22F33B65C','ARCHIVED','2021-06-15 11:53:33',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2091,4 +2092,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-05-14 12:20:36
+-- Dump completed on 2021-06-15 11:53:35
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 78393753b58..6c1e72a35ce 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -2661,7 +2661,8 @@ INSERT INTO `updates` VALUES
 ('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_04_16_00_characters.sql','0EBBF50CE3EB1197973E403C2F1D60881BB497FD','ARCHIVED','2021-04-16 21:23:03',0),
-('2021_05_14_00_characters.sql','9834A657E1E1F650E9A7E4E793BAB3E2AFF65293','ARCHIVED','2021-05-14 12:20:33',0);
+('2021_05_14_00_characters.sql','9834A657E1E1F650E9A7E4E793BAB3E2AFF65293','ARCHIVED','2021-05-14 12:20:33',0),
+('2021_06_15_00_characters.sql','4432846E2B0769C01E2B333EEDD90ABA44BF2BC1','ARCHIVED','2021-06-15 11:53:33',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2832,4 +2833,4 @@ UNLOCK TABLES;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2021-05-14 12:20:36
+-- Dump completed on 2021-06-15 11:53:35
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index 267aa14c743..32bb8110514 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-05-14 12:20:37
+-- Dump completed on 2021-06-15 11:53:36
diff --git a/sql/updates/auth/3.3.5/2021_05_14_00_auth.sql b/sql/old/3.3.5a/auth/21051_2021_06_15/2021_05_14_00_auth.sql
index 5026d72fec5..5026d72fec5 100644
--- a/sql/updates/auth/3.3.5/2021_05_14_00_auth.sql
+++ b/sql/old/3.3.5a/auth/21051_2021_06_15/2021_05_14_00_auth.sql
diff --git a/sql/updates/characters/3.3.5/2021_05_14_00_characters.sql b/sql/old/3.3.5a/characters/21051_2021_06_15/2021_05_14_00_characters.sql
index 5ff61a23b90..5ff61a23b90 100644
--- a/sql/updates/characters/3.3.5/2021_05_14_00_characters.sql
+++ b/sql/old/3.3.5a/characters/21051_2021_06_15/2021_05_14_00_characters.sql
diff --git a/sql/updates/world/3.3.5/2021_05_14_00_world.sql b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_14_00_world.sql
index 8c277055e62..8c277055e62 100644
--- a/sql/updates/world/3.3.5/2021_05_14_00_world.sql
+++ b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_14_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_05_17_00_world_335.sql b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_17_00_world_335.sql
index 24eafc27323..24eafc27323 100644
--- a/sql/updates/world/3.3.5/2021_05_17_00_world_335.sql
+++ b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_17_00_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_05_17_01_world_335.sql b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_17_01_world_335.sql
index 2a520b6e9d9..2a520b6e9d9 100644
--- a/sql/updates/world/3.3.5/2021_05_17_01_world_335.sql
+++ b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_17_01_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_05_17_02_world.sql b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_17_02_world.sql
index 1c498322ab5..1c498322ab5 100644
--- a/sql/updates/world/3.3.5/2021_05_17_02_world.sql
+++ b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_17_02_world.sql
diff --git a/sql/updates/world/3.3.5/2021_05_17_03_world.sql b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_17_03_world.sql
index 043a5907549..043a5907549 100644
--- a/sql/updates/world/3.3.5/2021_05_17_03_world.sql
+++ b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_17_03_world.sql
diff --git a/sql/updates/world/3.3.5/2021_05_18_00_world.sql b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_18_00_world.sql
index bcfb66251f0..bcfb66251f0 100644
--- a/sql/updates/world/3.3.5/2021_05_18_00_world.sql
+++ b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_18_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_05_18_01_world_335.sql b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_18_01_world_335.sql
index c36949e90bb..c36949e90bb 100644
--- a/sql/updates/world/3.3.5/2021_05_18_01_world_335.sql
+++ b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_18_01_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_05_18_02_world.sql b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_18_02_world.sql
index 8901e25bfea..8901e25bfea 100644
--- a/sql/updates/world/3.3.5/2021_05_18_02_world.sql
+++ b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_18_02_world.sql
diff --git a/sql/updates/world/3.3.5/2021_05_18_03_world_335.sql b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_18_03_world_335.sql
index 2f75babd821..2f75babd821 100644
--- a/sql/updates/world/3.3.5/2021_05_18_03_world_335.sql
+++ b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_18_03_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_05_18_04_world_335.sql b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_18_04_world_335.sql
index 6ddfec07e00..6ddfec07e00 100644
--- a/sql/updates/world/3.3.5/2021_05_18_04_world_335.sql
+++ b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_18_04_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_05_18_05_world_335.sql b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_18_05_world_335.sql
index 7ed709dcd48..7ed709dcd48 100644
--- a/sql/updates/world/3.3.5/2021_05_18_05_world_335.sql
+++ b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_18_05_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_05_20_00_world_335.sql b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_20_00_world_335.sql
index 52111bdc05e..52111bdc05e 100644
--- a/sql/updates/world/3.3.5/2021_05_20_00_world_335.sql
+++ b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_20_00_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_05_20_01_world.sql b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_20_01_world.sql
index 17c76a3a4ad..17c76a3a4ad 100644
--- a/sql/updates/world/3.3.5/2021_05_20_01_world.sql
+++ b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_20_01_world.sql
diff --git a/sql/updates/world/3.3.5/2021_05_20_02_world.sql b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_20_02_world.sql
index a557ce5ace2..a557ce5ace2 100644
--- a/sql/updates/world/3.3.5/2021_05_20_02_world.sql
+++ b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_20_02_world.sql
diff --git a/sql/updates/world/3.3.5/2021_05_20_03_world.sql b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_20_03_world.sql
index 27162e283cc..27162e283cc 100644
--- a/sql/updates/world/3.3.5/2021_05_20_03_world.sql
+++ b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_20_03_world.sql
diff --git a/sql/updates/world/3.3.5/2021_05_21_00_world.sql b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_21_00_world.sql
index f82fe5da583..f82fe5da583 100644
--- a/sql/updates/world/3.3.5/2021_05_21_00_world.sql
+++ b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_21_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_05_22_00_world.sql b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_22_00_world.sql
index 1f9caff72af..1f9caff72af 100644
--- a/sql/updates/world/3.3.5/2021_05_22_00_world.sql
+++ b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_22_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_05_22_01_world.sql b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_22_01_world.sql
index b032ec51b24..b032ec51b24 100644
--- a/sql/updates/world/3.3.5/2021_05_22_01_world.sql
+++ b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_22_01_world.sql
diff --git a/sql/updates/world/3.3.5/2021_05_23_00_world.sql b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_23_00_world.sql
index 8c073382ffd..8c073382ffd 100644
--- a/sql/updates/world/3.3.5/2021_05_23_00_world.sql
+++ b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_23_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_05_23_01_world.sql b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_23_01_world.sql
index 940504d968c..940504d968c 100644
--- a/sql/updates/world/3.3.5/2021_05_23_01_world.sql
+++ b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_23_01_world.sql
diff --git a/sql/updates/world/3.3.5/2021_05_23_02_world_335.sql b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_23_02_world_335.sql
index cc63519f98e..cc63519f98e 100644
--- a/sql/updates/world/3.3.5/2021_05_23_02_world_335.sql
+++ b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_23_02_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_05_23_03_world_335.sql b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_23_03_world_335.sql
index 93e45ead2ed..93e45ead2ed 100644
--- a/sql/updates/world/3.3.5/2021_05_23_03_world_335.sql
+++ b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_23_03_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_05_27_00_world.sql b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_27_00_world.sql
index 9fbbc36609e..9fbbc36609e 100644
--- a/sql/updates/world/3.3.5/2021_05_27_00_world.sql
+++ b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_27_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_05_28_00_world.sql b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_28_00_world.sql
index c5ba1a19794..c5ba1a19794 100644
--- a/sql/updates/world/3.3.5/2021_05_28_00_world.sql
+++ b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_28_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_05_28_01_world.sql b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_28_01_world.sql
index 4796a7d257f..4796a7d257f 100644
--- a/sql/updates/world/3.3.5/2021_05_28_01_world.sql
+++ b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_28_01_world.sql
diff --git a/sql/updates/world/3.3.5/2021_05_28_02_world_335.sql b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_28_02_world_335.sql
index 49e77124f16..49e77124f16 100644
--- a/sql/updates/world/3.3.5/2021_05_28_02_world_335.sql
+++ b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_28_02_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_05_28_03_world_335.sql b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_28_03_world_335.sql
index 642bde431c9..642bde431c9 100644
--- a/sql/updates/world/3.3.5/2021_05_28_03_world_335.sql
+++ b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_28_03_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_05_28_04_world_335.sql b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_28_04_world_335.sql
index b93be7bcd0b..b93be7bcd0b 100644
--- a/sql/updates/world/3.3.5/2021_05_28_04_world_335.sql
+++ b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_28_04_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_05_29_00_world.sql b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_29_00_world.sql
index da72c4f4a7a..da72c4f4a7a 100644
--- a/sql/updates/world/3.3.5/2021_05_29_00_world.sql
+++ b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_29_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_05_29_01_world.sql b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_29_01_world.sql
index 3c55ca99677..3c55ca99677 100644
--- a/sql/updates/world/3.3.5/2021_05_29_01_world.sql
+++ b/sql/old/3.3.5a/world/21051_2021_06_15/2021_05_29_01_world.sql
diff --git a/sql/updates/world/3.3.5/2021_06_08_00_world.sql b/sql/old/3.3.5a/world/21051_2021_06_15/2021_06_08_00_world.sql
index 7bde0dbd767..7bde0dbd767 100644
--- a/sql/updates/world/3.3.5/2021_06_08_00_world.sql
+++ b/sql/old/3.3.5a/world/21051_2021_06_15/2021_06_08_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_06_09_00_world.sql b/sql/old/3.3.5a/world/21051_2021_06_15/2021_06_09_00_world.sql
index 0afeb670929..0afeb670929 100644
--- a/sql/updates/world/3.3.5/2021_06_09_00_world.sql
+++ b/sql/old/3.3.5a/world/21051_2021_06_15/2021_06_09_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_06_09_01_world.sql b/sql/old/3.3.5a/world/21051_2021_06_15/2021_06_09_01_world.sql
index edf2be34167..edf2be34167 100644
--- a/sql/updates/world/3.3.5/2021_06_09_01_world.sql
+++ b/sql/old/3.3.5a/world/21051_2021_06_15/2021_06_09_01_world.sql
diff --git a/sql/updates/world/3.3.5/2021_06_09_02_world_335.sql b/sql/old/3.3.5a/world/21051_2021_06_15/2021_06_09_02_world_335.sql
index 57e0a005d22..57e0a005d22 100644
--- a/sql/updates/world/3.3.5/2021_06_09_02_world_335.sql
+++ b/sql/old/3.3.5a/world/21051_2021_06_15/2021_06_09_02_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_06_09_03_world_335.sql b/sql/old/3.3.5a/world/21051_2021_06_15/2021_06_09_03_world_335.sql
index 9f37e2c8b87..9f37e2c8b87 100644
--- a/sql/updates/world/3.3.5/2021_06_09_03_world_335.sql
+++ b/sql/old/3.3.5a/world/21051_2021_06_15/2021_06_09_03_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_06_09_04_world_335.sql b/sql/old/3.3.5a/world/21051_2021_06_15/2021_06_09_04_world_335.sql
index 7c4ca2e4467..7c4ca2e4467 100644
--- a/sql/updates/world/3.3.5/2021_06_09_04_world_335.sql
+++ b/sql/old/3.3.5a/world/21051_2021_06_15/2021_06_09_04_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_06_10_00_world.sql b/sql/old/3.3.5a/world/21051_2021_06_15/2021_06_10_00_world.sql
index 9cccfee7509..9cccfee7509 100644
--- a/sql/updates/world/3.3.5/2021_06_10_00_world.sql
+++ b/sql/old/3.3.5a/world/21051_2021_06_15/2021_06_10_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_06_10_01_world.sql b/sql/old/3.3.5a/world/21051_2021_06_15/2021_06_10_01_world.sql
index 0d7860a4533..0d7860a4533 100644
--- a/sql/updates/world/3.3.5/2021_06_10_01_world.sql
+++ b/sql/old/3.3.5a/world/21051_2021_06_15/2021_06_10_01_world.sql
diff --git a/sql/updates/world/3.3.5/2021_06_11_00_world.sql b/sql/old/3.3.5a/world/21051_2021_06_15/2021_06_11_00_world.sql
index d0654123263..d0654123263 100644
--- a/sql/updates/world/3.3.5/2021_06_11_00_world.sql
+++ b/sql/old/3.3.5a/world/21051_2021_06_15/2021_06_11_00_world.sql
diff --git a/sql/updates/auth/3.3.5/2021_06_15_00_auth.sql b/sql/updates/auth/3.3.5/2021_06_15_00_auth.sql
new file mode 100644
index 00000000000..3986a5535e0
--- /dev/null
+++ b/sql/updates/auth/3.3.5/2021_06_15_00_auth.sql
@@ -0,0 +1,2 @@
+-- TDB 335.21061 auth
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/characters/3.3.5/2021_06_15_00_characters.sql b/sql/updates/characters/3.3.5/2021_06_15_00_characters.sql
new file mode 100644
index 00000000000..03488f00892
--- /dev/null
+++ b/sql/updates/characters/3.3.5/2021_06_15_00_characters.sql
@@ -0,0 +1,2 @@
+-- TDB 335.21061 characters
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/world/3.3.5/2021_06_15_00_world.sql b/sql/updates/world/3.3.5/2021_06_15_00_world.sql
new file mode 100644
index 00000000000..ce88a02af57
--- /dev/null
+++ b/sql/updates/world/3.3.5/2021_06_15_00_world.sql
@@ -0,0 +1,3 @@
+-- TDB 335.21061 world
+UPDATE `version` SET `db_version`='TDB 335.21061', `cache_id`=21061 LIMIT 1;
+UPDATE `updates` SET `state`='ARCHIVED';