TDB 335.21071 - 2021/07/15TDB335.21071

43 files changed, 14 insertions, 5 deletions

diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index b13104f9192..e2b97df7aaf 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -1987,7 +1987,8 @@ INSERT INTO `updates` VALUES
 ('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_06_15_00_auth.sql','DAFFA7699D3BF0A15AE72321AFC9F7D22F33B65C','ARCHIVED','2021-06-15 11:53:33',0),
-('2021_06_20_00_auth.sql','7CA418D570DC1444C19AAD18F4A50FF187642310','ARCHIVED','2021-06-20 17:29:17',0);
+('2021_06_20_00_auth.sql','7CA418D570DC1444C19AAD18F4A50FF187642310','ARCHIVED','2021-06-20 17:29:17',0),
+('2021_07_15_00_auth.sql','C8B29D477A5A6704775517EF8203871BFE3D4906','ARCHIVED','2021-07-15 07:32:48',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2126,4 +2127,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-06-20 20:56:14
+-- Dump completed on 2021-07-15  7:32:51
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 6c1e72a35ce..1dbed596dcf 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -2662,7 +2662,8 @@ INSERT INTO `updates` VALUES
 ('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_06_15_00_characters.sql','4432846E2B0769C01E2B333EEDD90ABA44BF2BC1','ARCHIVED','2021-06-15 11:53:33',0);
+('2021_06_15_00_characters.sql','4432846E2B0769C01E2B333EEDD90ABA44BF2BC1','ARCHIVED','2021-06-15 11:53:33',0),
+('2021_07_15_00_characters.sql','2ACFF71253DEA0F059476AEA52A55196E6D5DCFE','ARCHIVED','2021-07-15 07:32:48',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2833,4 +2834,4 @@ UNLOCK TABLES;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2021-06-15 11:53:35
+-- Dump completed on 2021-07-15  7:32:51
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index 32bb8110514..6df70474aad 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-06-15 11:53:36
+-- Dump completed on 2021-07-15  7:32:51
diff --git a/sql/updates/auth/3.3.5/2021_06_15_00_auth.sql b/sql/old/3.3.5a/auth/21061_2021_07_15/2021_06_15_00_auth.sql
index 3986a5535e0..3986a5535e0 100644
--- a/sql/updates/auth/3.3.5/2021_06_15_00_auth.sql
+++ b/sql/old/3.3.5a/auth/21061_2021_07_15/2021_06_15_00_auth.sql
diff --git a/sql/updates/auth/3.3.5/2021_06_20_00_auth.sql b/sql/old/3.3.5a/auth/21061_2021_07_15/2021_06_20_00_auth.sql
index 4b8209a2123..4b8209a2123 100644
--- a/sql/updates/auth/3.3.5/2021_06_20_00_auth.sql
+++ b/sql/old/3.3.5a/auth/21061_2021_07_15/2021_06_20_00_auth.sql
diff --git a/sql/updates/characters/3.3.5/2021_06_15_00_characters.sql b/sql/old/3.3.5a/characters/21061_2021_07_15/2021_06_15_00_characters.sql
index 03488f00892..03488f00892 100644
--- a/sql/updates/characters/3.3.5/2021_06_15_00_characters.sql
+++ b/sql/old/3.3.5a/characters/21061_2021_07_15/2021_06_15_00_characters.sql
diff --git a/sql/updates/world/3.3.5/2021_06_15_00_world.sql b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_15_00_world.sql
index ce88a02af57..ce88a02af57 100644
--- a/sql/updates/world/3.3.5/2021_06_15_00_world.sql
+++ b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_15_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_06_17_00_world.sql b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_17_00_world.sql
index 4ba2dc64718..4ba2dc64718 100644
--- a/sql/updates/world/3.3.5/2021_06_17_00_world.sql
+++ b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_17_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_06_20_00_world.sql b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_20_00_world.sql
index 2912520ccd1..2912520ccd1 100644
--- a/sql/updates/world/3.3.5/2021_06_20_00_world.sql
+++ b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_20_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_06_22_00_world.sql b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_22_00_world.sql
index 8da8efd5090..8da8efd5090 100644
--- a/sql/updates/world/3.3.5/2021_06_22_00_world.sql
+++ b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_22_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_06_22_01_world_335.sql b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_22_01_world_335.sql
index 4eecde4f066..4eecde4f066 100644
--- a/sql/updates/world/3.3.5/2021_06_22_01_world_335.sql
+++ b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_22_01_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_06_22_02_world_335.sql b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_22_02_world_335.sql
index 0ed8ed632b3..0ed8ed632b3 100644
--- a/sql/updates/world/3.3.5/2021_06_22_02_world_335.sql
+++ b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_22_02_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_06_22_03_world_335.sql b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_22_03_world_335.sql
index 6e271ad6b86..6e271ad6b86 100644
--- a/sql/updates/world/3.3.5/2021_06_22_03_world_335.sql
+++ b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_22_03_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_06_22_04_world_335.sql b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_22_04_world_335.sql
index fdb00c6dcd2..fdb00c6dcd2 100644
--- a/sql/updates/world/3.3.5/2021_06_22_04_world_335.sql
+++ b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_22_04_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_06_22_05_world.sql b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_22_05_world.sql
index 8b87bc38f81..8b87bc38f81 100644
--- a/sql/updates/world/3.3.5/2021_06_22_05_world.sql
+++ b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_22_05_world.sql
diff --git a/sql/updates/world/3.3.5/2021_06_23_00_world.sql b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_23_00_world.sql
index 3e6e2b16732..3e6e2b16732 100644
--- a/sql/updates/world/3.3.5/2021_06_23_00_world.sql
+++ b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_23_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_06_24_00_world.sql b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_24_00_world.sql
index d66d53ac866..d66d53ac866 100644
--- a/sql/updates/world/3.3.5/2021_06_24_00_world.sql
+++ b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_24_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_06_24_01_world.sql b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_24_01_world.sql
index f757570e87c..f757570e87c 100644
--- a/sql/updates/world/3.3.5/2021_06_24_01_world.sql
+++ b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_24_01_world.sql
diff --git a/sql/updates/world/3.3.5/2021_06_24_02_world.sql b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_24_02_world.sql
index 1b8e3e2cc87..1b8e3e2cc87 100644
--- a/sql/updates/world/3.3.5/2021_06_24_02_world.sql
+++ b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_24_02_world.sql
diff --git a/sql/updates/world/3.3.5/2021_06_24_03_world.sql b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_24_03_world.sql
index feee7f3ae3b..feee7f3ae3b 100644
--- a/sql/updates/world/3.3.5/2021_06_24_03_world.sql
+++ b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_24_03_world.sql
diff --git a/sql/updates/world/3.3.5/2021_06_24_04_world.sql b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_24_04_world.sql
index 481c2105acb..481c2105acb 100644
--- a/sql/updates/world/3.3.5/2021_06_24_04_world.sql
+++ b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_24_04_world.sql
diff --git a/sql/updates/world/3.3.5/2021_06_24_05_world.sql b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_24_05_world.sql
index 5db5e4d9c6c..5db5e4d9c6c 100644
--- a/sql/updates/world/3.3.5/2021_06_24_05_world.sql
+++ b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_24_05_world.sql
diff --git a/sql/updates/world/3.3.5/2021_06_27_00_world_335.sql b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_27_00_world_335.sql
index afc5a1a65c1..afc5a1a65c1 100644
--- a/sql/updates/world/3.3.5/2021_06_27_00_world_335.sql
+++ b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_27_00_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_06_27_01_world.sql b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_27_01_world.sql
index 34a5bfeee8e..34a5bfeee8e 100644
--- a/sql/updates/world/3.3.5/2021_06_27_01_world.sql
+++ b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_27_01_world.sql
diff --git a/sql/updates/world/3.3.5/2021_06_27_02_world_335.sql b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_27_02_world_335.sql
index 03afd104137..03afd104137 100644
--- a/sql/updates/world/3.3.5/2021_06_27_02_world_335.sql
+++ b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_27_02_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_06_27_03_world_335.sql b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_27_03_world_335.sql
index fc896826cee..fc896826cee 100644
--- a/sql/updates/world/3.3.5/2021_06_27_03_world_335.sql
+++ b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_27_03_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_06_27_04_world.sql b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_27_04_world.sql
index f81f567185f..f81f567185f 100644
--- a/sql/updates/world/3.3.5/2021_06_27_04_world.sql
+++ b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_27_04_world.sql
diff --git a/sql/updates/world/3.3.5/2021_06_27_05_world.sql b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_27_05_world.sql
index e52c33269f0..e52c33269f0 100644
--- a/sql/updates/world/3.3.5/2021_06_27_05_world.sql
+++ b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_27_05_world.sql
diff --git a/sql/updates/world/3.3.5/2021_06_29_00_world_335.sql b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_29_00_world_335.sql
index 8324ebda0ed..8324ebda0ed 100644
--- a/sql/updates/world/3.3.5/2021_06_29_00_world_335.sql
+++ b/sql/old/3.3.5a/world/21061_2021_07_15/2021_06_29_00_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_07_03_00_world.sql b/sql/old/3.3.5a/world/21061_2021_07_15/2021_07_03_00_world.sql
index 1386e06c9d3..1386e06c9d3 100644
--- a/sql/updates/world/3.3.5/2021_07_03_00_world.sql
+++ b/sql/old/3.3.5a/world/21061_2021_07_15/2021_07_03_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_07_03_01_world.sql b/sql/old/3.3.5a/world/21061_2021_07_15/2021_07_03_01_world.sql
index 2dffb233367..2dffb233367 100644
--- a/sql/updates/world/3.3.5/2021_07_03_01_world.sql
+++ b/sql/old/3.3.5a/world/21061_2021_07_15/2021_07_03_01_world.sql
diff --git a/sql/updates/world/3.3.5/2021_07_04_00_world.sql b/sql/old/3.3.5a/world/21061_2021_07_15/2021_07_04_00_world.sql
index 7b5d938ab03..7b5d938ab03 100644
--- a/sql/updates/world/3.3.5/2021_07_04_00_world.sql
+++ b/sql/old/3.3.5a/world/21061_2021_07_15/2021_07_04_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_07_06_00_world_335.sql b/sql/old/3.3.5a/world/21061_2021_07_15/2021_07_06_00_world_335.sql
index 90d23192fcd..90d23192fcd 100644
--- a/sql/updates/world/3.3.5/2021_07_06_00_world_335.sql
+++ b/sql/old/3.3.5a/world/21061_2021_07_15/2021_07_06_00_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_07_06_01_world_335.sql b/sql/old/3.3.5a/world/21061_2021_07_15/2021_07_06_01_world_335.sql
index 350fe0a0000..350fe0a0000 100644
--- a/sql/updates/world/3.3.5/2021_07_06_01_world_335.sql
+++ b/sql/old/3.3.5a/world/21061_2021_07_15/2021_07_06_01_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_07_06_02_world.sql b/sql/old/3.3.5a/world/21061_2021_07_15/2021_07_06_02_world.sql
index a48817726c6..a48817726c6 100644
--- a/sql/updates/world/3.3.5/2021_07_06_02_world.sql
+++ b/sql/old/3.3.5a/world/21061_2021_07_15/2021_07_06_02_world.sql
diff --git a/sql/updates/world/3.3.5/2021_07_06_03_world.sql b/sql/old/3.3.5a/world/21061_2021_07_15/2021_07_06_03_world.sql
index 9ca6e268617..9ca6e268617 100644
--- a/sql/updates/world/3.3.5/2021_07_06_03_world.sql
+++ b/sql/old/3.3.5a/world/21061_2021_07_15/2021_07_06_03_world.sql
diff --git a/sql/updates/world/3.3.5/2021_07_07_00_world_335.sql b/sql/old/3.3.5a/world/21061_2021_07_15/2021_07_07_00_world_335.sql
index 4cf91f45496..4cf91f45496 100644
--- a/sql/updates/world/3.3.5/2021_07_07_00_world_335.sql
+++ b/sql/old/3.3.5a/world/21061_2021_07_15/2021_07_07_00_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_07_07_01_world_335.sql b/sql/old/3.3.5a/world/21061_2021_07_15/2021_07_07_01_world_335.sql
index 32a9752bac4..32a9752bac4 100644
--- a/sql/updates/world/3.3.5/2021_07_07_01_world_335.sql
+++ b/sql/old/3.3.5a/world/21061_2021_07_15/2021_07_07_01_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_07_11_00_world.sql b/sql/old/3.3.5a/world/21061_2021_07_15/2021_07_11_00_world.sql
index 8553fbedea7..8553fbedea7 100644
--- a/sql/updates/world/3.3.5/2021_07_11_00_world.sql
+++ b/sql/old/3.3.5a/world/21061_2021_07_15/2021_07_11_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_07_13_00_world.sql b/sql/old/3.3.5a/world/21061_2021_07_15/2021_07_13_00_world.sql
index 61db1b0f644..61db1b0f644 100644
--- a/sql/updates/world/3.3.5/2021_07_13_00_world.sql
+++ b/sql/old/3.3.5a/world/21061_2021_07_15/2021_07_13_00_world.sql
diff --git a/sql/updates/auth/3.3.5/2021_07_15_00_auth.sql b/sql/updates/auth/3.3.5/2021_07_15_00_auth.sql
new file mode 100644
index 00000000000..7b8b20b47a2
--- /dev/null
+++ b/sql/updates/auth/3.3.5/2021_07_15_00_auth.sql
@@ -0,0 +1,2 @@
+-- TDB 335.21071 auth
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/characters/3.3.5/2021_07_15_00_characters.sql b/sql/updates/characters/3.3.5/2021_07_15_00_characters.sql
new file mode 100644
index 00000000000..97589672ab0
--- /dev/null
+++ b/sql/updates/characters/3.3.5/2021_07_15_00_characters.sql
@@ -0,0 +1,2 @@
+-- TDB 335.21071 characters
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/world/3.3.5/2021_07_15_00_world.sql b/sql/updates/world/3.3.5/2021_07_15_00_world.sql
new file mode 100644
index 00000000000..b84cd9e4694
--- /dev/null
+++ b/sql/updates/world/3.3.5/2021_07_15_00_world.sql
@@ -0,0 +1,3 @@
+-- TDB 335.21071 world
+UPDATE `version` SET `db_version`='TDB 335.21071', `cache_id`=21071 LIMIT 1;
+UPDATE `updates` SET `state`='ARCHIVED';