TDB 335.24081 - 2024/08/17TDB335.24081

38 files changed, 21 insertions, 12 deletions

diff --git a/revision_data.h.in.cmake b/revision_data.h.in.cmake
index 690821477eb..761a7211723 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.24041_2024_04_10.sql"
+ #define _FULL_DATABASE             "TDB_full_world_335.24081_2024_08_17.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 9ef521b397d..be6e5a881ea 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -1,8 +1,8 @@
--- MySQL dump 10.13  Distrib 8.0.36, for Linux (x86_64)
+-- MySQL dump 10.13  Distrib 8.0.39, for Linux (x86_64)
 --
 -- Host: localhost    Database: auth
 -- ------------------------------------------------------
--- Server version	8.0.36-0ubuntu0.22.04.1
+-- Server version	8.0.39-0ubuntu0.22.04.1
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -2024,7 +2024,8 @@ INSERT INTO `updates` VALUES
 ('2024_01_06_02_auth.sql','B14F889C198A4F640A968BAB8A4C262AC61634C7','ARCHIVED','2024-01-06 12:43:47',0),
 ('2024_01_06_03_auth.sql','693BFD4326314659BAD9A2C70D9526FF4625B393','ARCHIVED','2024-01-06 12:55:07',0),
 ('2024_01_21_00_auth.sql','B45B95D7B608D6ACF1BCBA656718C7DEED8CFF00','ARCHIVED','2024-01-21 11:38:22',0),
-('2024_04_10_00_auth.sql','CE8BD4D6DF6DE85DBF892507B1B18B746FE4A71D','ARCHIVED','2024-04-10 16:07:02',0);
+('2024_04_10_00_auth.sql','CE8BD4D6DF6DE85DBF892507B1B18B746FE4A71D','ARCHIVED','2024-04-10 16:07:02',0),
+('2024_08_17_00_auth.sql','B6D7D00D5573958EE84321B029D869C52793F924','ARCHIVED','2024-08-17 22:26:12',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2163,4 +2164,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 2024-04-10 16:07:05
+-- Dump completed on 2024-08-17 22:26:14
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 2afda643690..5612d8f3b89 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -1,8 +1,8 @@
--- MySQL dump 10.13  Distrib 8.0.36, for Linux (x86_64)
+-- MySQL dump 10.13  Distrib 8.0.39, for Linux (x86_64)
 --
 -- Host: localhost    Database: characters
 -- ------------------------------------------------------
--- Server version	8.0.36-0ubuntu0.22.04.1
+-- Server version	8.0.39-0ubuntu0.22.04.1
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -2685,7 +2685,8 @@ INSERT INTO `updates` VALUES
 ('2023_09_10_00_characters.sql','5DE09CA31B5168CF3622CB462816B6C598893D96','ARCHIVED','2023-09-10 12:23:34',0),
 ('2024_01_21_00_characters.sql','4D27D8DAC9F78795DB6938B54F32502EF8D8AAE6','ARCHIVED','2024-01-21 11:38:22',0),
 ('2024_02_05_00_characters.sql','1777CBCA822AD85777DA4A390DF7AAF41AF68EBD','ARCHIVED','2024-02-05 12:17:19',0),
-('2024_04_10_00_characters.sql','E0D6E19ACE6759332402FA27C23B0F7745C49742','ARCHIVED','2024-04-10 16:07:02',0);
+('2024_04_10_00_characters.sql','E0D6E19ACE6759332402FA27C23B0F7745C49742','ARCHIVED','2024-04-10 16:07:02',0),
+('2024_08_17_00_characters.sql','08705FBCB8504E8B1009FDAF955F56D734FAD782','ARCHIVED','2024-08-17 22:26:12',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2856,4 +2857,4 @@ UNLOCK TABLES;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2024-04-10 16:07:06
+-- Dump completed on 2024-08-17 22:26:14
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index 6e35b453074..6c2b3747ac6 100644
--- a/sql/base/dev/world_database.sql
+++ b/sql/base/dev/world_database.sql
@@ -1,8 +1,8 @@
--- MySQL dump 10.13  Distrib 8.0.36, for Linux (x86_64)
+-- MySQL dump 10.13  Distrib 8.0.39, for Linux (x86_64)
 --
 -- Host: localhost    Database: world
 -- ------------------------------------------------------
--- Server version	8.0.36-0ubuntu0.22.04.1
+-- Server version	8.0.39-0ubuntu0.22.04.1
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -4067,4 +4067,4 @@ CREATE TABLE `waypoints` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2024-04-10 16:07:07
+-- Dump completed on 2024-08-17 22:26:15
diff --git a/sql/updates/auth/3.3.5/2024_04_10_00_auth.sql b/sql/old/3.3.5a/auth/24041_2024_08_17/2024_04_10_00_auth.sql
index 3ffe551d79f..3ffe551d79f 100644
--- a/sql/updates/auth/3.3.5/2024_04_10_00_auth.sql
+++ b/sql/old/3.3.5a/auth/24041_2024_08_17/2024_04_10_00_auth.sql
diff --git a/sql/updates/characters/3.3.5/2024_04_10_00_characters.sql b/sql/old/3.3.5a/characters/24041_2024_08_17/2024_04_10_00_characters.sql
index 48ed854e7c1..48ed854e7c1 100644
--- a/sql/updates/characters/3.3.5/2024_04_10_00_characters.sql
+++ b/sql/old/3.3.5a/characters/24041_2024_08_17/2024_04_10_00_characters.sql
diff --git a/sql/updates/world/3.3.5/2024_04_10_00_world.sql b/sql/old/3.3.5a/world/24041_2024_08_17/2024_04_10_00_world.sql
index d451ba10be4..d451ba10be4 100644
--- a/sql/updates/world/3.3.5/2024_04_10_00_world.sql
+++ b/sql/old/3.3.5a/world/24041_2024_08_17/2024_04_10_00_world.sql
diff --git a/sql/updates/world/3.3.5/2024_04_15_00_world.sql b/sql/old/3.3.5a/world/24041_2024_08_17/2024_04_15_00_world.sql
index 8d43eb679fd..8d43eb679fd 100644
--- a/sql/updates/world/3.3.5/2024_04_15_00_world.sql
+++ b/sql/old/3.3.5a/world/24041_2024_08_17/2024_04_15_00_world.sql
diff --git a/sql/updates/world/3.3.5/2024_04_21_00_world.sql b/sql/old/3.3.5a/world/24041_2024_08_17/2024_04_21_00_world.sql
index 7066927a4d1..7066927a4d1 100644
--- a/sql/updates/world/3.3.5/2024_04_21_00_world.sql
+++ b/sql/old/3.3.5a/world/24041_2024_08_17/2024_04_21_00_world.sql
diff --git a/sql/updates/world/3.3.5/2024_05_12_00_world.sql b/sql/old/3.3.5a/world/24041_2024_08_17/2024_05_12_00_world.sql
index 1ff4c106689..1ff4c106689 100644
--- a/sql/updates/world/3.3.5/2024_05_12_00_world.sql
+++ b/sql/old/3.3.5a/world/24041_2024_08_17/2024_05_12_00_world.sql
diff --git a/sql/updates/world/3.3.5/2024_05_12_01_world.sql b/sql/old/3.3.5a/world/24041_2024_08_17/2024_05_12_01_world.sql
index 1381fbe16c7..1381fbe16c7 100644
--- a/sql/updates/world/3.3.5/2024_05_12_01_world.sql
+++ b/sql/old/3.3.5a/world/24041_2024_08_17/2024_05_12_01_world.sql
diff --git a/sql/updates/world/3.3.5/2024_05_12_02_world.sql b/sql/old/3.3.5a/world/24041_2024_08_17/2024_05_12_02_world.sql
index 116d76d3ff1..116d76d3ff1 100644
--- a/sql/updates/world/3.3.5/2024_05_12_02_world.sql
+++ b/sql/old/3.3.5a/world/24041_2024_08_17/2024_05_12_02_world.sql
diff --git a/sql/updates/world/3.3.5/2024_05_17_00_world.sql b/sql/old/3.3.5a/world/24041_2024_08_17/2024_05_17_00_world.sql
index 2cf26a1ed9f..2cf26a1ed9f 100644
--- a/sql/updates/world/3.3.5/2024_05_17_00_world.sql
+++ b/sql/old/3.3.5a/world/24041_2024_08_17/2024_05_17_00_world.sql
diff --git a/sql/updates/world/3.3.5/2024_05_26_00_world.sql b/sql/old/3.3.5a/world/24041_2024_08_17/2024_05_26_00_world.sql
index 0f52cae9e2f..0f52cae9e2f 100644
--- a/sql/updates/world/3.3.5/2024_05_26_00_world.sql
+++ b/sql/old/3.3.5a/world/24041_2024_08_17/2024_05_26_00_world.sql
diff --git a/sql/updates/world/3.3.5/2024_05_26_01_world.sql b/sql/old/3.3.5a/world/24041_2024_08_17/2024_05_26_01_world.sql
index d661f9ff9be..d661f9ff9be 100644
--- a/sql/updates/world/3.3.5/2024_05_26_01_world.sql
+++ b/sql/old/3.3.5a/world/24041_2024_08_17/2024_05_26_01_world.sql
diff --git a/sql/updates/world/3.3.5/2024_05_26_02_world.sql b/sql/old/3.3.5a/world/24041_2024_08_17/2024_05_26_02_world.sql
index 22842888e30..22842888e30 100644
--- a/sql/updates/world/3.3.5/2024_05_26_02_world.sql
+++ b/sql/old/3.3.5a/world/24041_2024_08_17/2024_05_26_02_world.sql
diff --git a/sql/updates/world/3.3.5/2024_05_26_03_world.sql b/sql/old/3.3.5a/world/24041_2024_08_17/2024_05_26_03_world.sql
index 74152c39756..74152c39756 100644
--- a/sql/updates/world/3.3.5/2024_05_26_03_world.sql
+++ b/sql/old/3.3.5a/world/24041_2024_08_17/2024_05_26_03_world.sql
diff --git a/sql/updates/world/3.3.5/2024_05_26_04_world.sql b/sql/old/3.3.5a/world/24041_2024_08_17/2024_05_26_04_world.sql
index 129784fb036..129784fb036 100644
--- a/sql/updates/world/3.3.5/2024_05_26_04_world.sql
+++ b/sql/old/3.3.5a/world/24041_2024_08_17/2024_05_26_04_world.sql
diff --git a/sql/updates/world/3.3.5/2024_05_31_00_world.sql b/sql/old/3.3.5a/world/24041_2024_08_17/2024_05_31_00_world.sql
index db55621a779..db55621a779 100644
--- a/sql/updates/world/3.3.5/2024_05_31_00_world.sql
+++ b/sql/old/3.3.5a/world/24041_2024_08_17/2024_05_31_00_world.sql
diff --git a/sql/updates/world/3.3.5/2024_05_31_01_world.sql b/sql/old/3.3.5a/world/24041_2024_08_17/2024_05_31_01_world.sql
index 5d380e047ad..5d380e047ad 100644
--- a/sql/updates/world/3.3.5/2024_05_31_01_world.sql
+++ b/sql/old/3.3.5a/world/24041_2024_08_17/2024_05_31_01_world.sql
diff --git a/sql/updates/world/3.3.5/2024_06_01_00_world.sql b/sql/old/3.3.5a/world/24041_2024_08_17/2024_06_01_00_world.sql
index 535161d205e..535161d205e 100644
--- a/sql/updates/world/3.3.5/2024_06_01_00_world.sql
+++ b/sql/old/3.3.5a/world/24041_2024_08_17/2024_06_01_00_world.sql
diff --git a/sql/updates/world/3.3.5/2024_06_01_01_world.sql b/sql/old/3.3.5a/world/24041_2024_08_17/2024_06_01_01_world.sql
index 183d1f444c9..183d1f444c9 100644
--- a/sql/updates/world/3.3.5/2024_06_01_01_world.sql
+++ b/sql/old/3.3.5a/world/24041_2024_08_17/2024_06_01_01_world.sql
diff --git a/sql/updates/world/3.3.5/2024_06_03_00_world.sql b/sql/old/3.3.5a/world/24041_2024_08_17/2024_06_03_00_world.sql
index 864a066519a..864a066519a 100644
--- a/sql/updates/world/3.3.5/2024_06_03_00_world.sql
+++ b/sql/old/3.3.5a/world/24041_2024_08_17/2024_06_03_00_world.sql
diff --git a/sql/updates/world/3.3.5/2024_06_20_00_world.sql b/sql/old/3.3.5a/world/24041_2024_08_17/2024_06_20_00_world.sql
index df1432887e4..df1432887e4 100644
--- a/sql/updates/world/3.3.5/2024_06_20_00_world.sql
+++ b/sql/old/3.3.5a/world/24041_2024_08_17/2024_06_20_00_world.sql
diff --git a/sql/updates/world/3.3.5/2024_06_27_00_world.sql b/sql/old/3.3.5a/world/24041_2024_08_17/2024_06_27_00_world.sql
index 712e9a98f78..712e9a98f78 100644
--- a/sql/updates/world/3.3.5/2024_06_27_00_world.sql
+++ b/sql/old/3.3.5a/world/24041_2024_08_17/2024_06_27_00_world.sql
diff --git a/sql/updates/world/3.3.5/2024_06_27_01_world.sql b/sql/old/3.3.5a/world/24041_2024_08_17/2024_06_27_01_world.sql
index 0653afc6a3a..0653afc6a3a 100644
--- a/sql/updates/world/3.3.5/2024_06_27_01_world.sql
+++ b/sql/old/3.3.5a/world/24041_2024_08_17/2024_06_27_01_world.sql
diff --git a/sql/updates/world/3.3.5/2024_06_27_02_world.sql b/sql/old/3.3.5a/world/24041_2024_08_17/2024_06_27_02_world.sql
index df2c01f0db0..df2c01f0db0 100644
--- a/sql/updates/world/3.3.5/2024_06_27_02_world.sql
+++ b/sql/old/3.3.5a/world/24041_2024_08_17/2024_06_27_02_world.sql
diff --git a/sql/updates/world/3.3.5/2024_07_13_00_world.sql b/sql/old/3.3.5a/world/24041_2024_08_17/2024_07_13_00_world.sql
index 080d22fa3d2..080d22fa3d2 100644
--- a/sql/updates/world/3.3.5/2024_07_13_00_world.sql
+++ b/sql/old/3.3.5a/world/24041_2024_08_17/2024_07_13_00_world.sql
diff --git a/sql/updates/world/3.3.5/2024_07_13_01_world.sql b/sql/old/3.3.5a/world/24041_2024_08_17/2024_07_13_01_world.sql
index fe183cd4bd5..fe183cd4bd5 100644
--- a/sql/updates/world/3.3.5/2024_07_13_01_world.sql
+++ b/sql/old/3.3.5a/world/24041_2024_08_17/2024_07_13_01_world.sql
diff --git a/sql/updates/world/3.3.5/2024_07_15_00_world.sql b/sql/old/3.3.5a/world/24041_2024_08_17/2024_07_15_00_world.sql
index 395589214ff..395589214ff 100644
--- a/sql/updates/world/3.3.5/2024_07_15_00_world.sql
+++ b/sql/old/3.3.5a/world/24041_2024_08_17/2024_07_15_00_world.sql
diff --git a/sql/updates/world/3.3.5/2024_07_15_01_world.sql b/sql/old/3.3.5a/world/24041_2024_08_17/2024_07_15_01_world.sql
index 88b49889230..88b49889230 100644
--- a/sql/updates/world/3.3.5/2024_07_15_01_world.sql
+++ b/sql/old/3.3.5a/world/24041_2024_08_17/2024_07_15_01_world.sql
diff --git a/sql/updates/world/3.3.5/2024_07_22_00_world.sql b/sql/old/3.3.5a/world/24041_2024_08_17/2024_07_22_00_world.sql
index b47cc2ad513..b47cc2ad513 100644
--- a/sql/updates/world/3.3.5/2024_07_22_00_world.sql
+++ b/sql/old/3.3.5a/world/24041_2024_08_17/2024_07_22_00_world.sql
diff --git a/sql/updates/world/3.3.5/2024_07_28_00_world.sql b/sql/old/3.3.5a/world/24041_2024_08_17/2024_07_28_00_world.sql
index 220cef782c1..220cef782c1 100644
--- a/sql/updates/world/3.3.5/2024_07_28_00_world.sql
+++ b/sql/old/3.3.5a/world/24041_2024_08_17/2024_07_28_00_world.sql
diff --git a/sql/updates/world/3.3.5/2024_08_03_00_world.sql b/sql/old/3.3.5a/world/24041_2024_08_17/2024_08_03_00_world.sql
index 025b6926e29..025b6926e29 100644
--- a/sql/updates/world/3.3.5/2024_08_03_00_world.sql
+++ b/sql/old/3.3.5a/world/24041_2024_08_17/2024_08_03_00_world.sql
diff --git a/sql/updates/world/3.3.5/2024_08_11_00_world.sql b/sql/old/3.3.5a/world/24041_2024_08_17/2024_08_11_00_world.sql
index 76621281ef4..76621281ef4 100644
--- a/sql/updates/world/3.3.5/2024_08_11_00_world.sql
+++ b/sql/old/3.3.5a/world/24041_2024_08_17/2024_08_11_00_world.sql
diff --git a/sql/updates/auth/3.3.5/2024_08_17_00_auth.sql b/sql/updates/auth/3.3.5/2024_08_17_00_auth.sql
new file mode 100644
index 00000000000..3f3bd0e6e07
--- /dev/null
+++ b/sql/updates/auth/3.3.5/2024_08_17_00_auth.sql
@@ -0,0 +1,2 @@
+-- TDB 335.24081 auth
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/characters/3.3.5/2024_08_17_00_characters.sql b/sql/updates/characters/3.3.5/2024_08_17_00_characters.sql
new file mode 100644
index 00000000000..7be526855b4
--- /dev/null
+++ b/sql/updates/characters/3.3.5/2024_08_17_00_characters.sql
@@ -0,0 +1,2 @@
+-- TDB 335.24081 characters
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/world/3.3.5/2024_08_17_00_world.sql b/sql/updates/world/3.3.5/2024_08_17_00_world.sql
new file mode 100644
index 00000000000..e12e7cf1eac
--- /dev/null
+++ b/sql/updates/world/3.3.5/2024_08_17_00_world.sql
@@ -0,0 +1,3 @@
+-- TDB 335.24081 world
+UPDATE `version` SET `db_version`='TDB 335.24081', `cache_id`=24081 LIMIT 1;
+UPDATE `updates` SET `state`='ARCHIVED';