aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTDB Release <tdb-release@build.bot>2022-02-16 21:54:52 +0000
committerTDB Release <tdb-release@build.bot>2022-02-16 21:54:52 +0000
commitcb8b06e836f2e4fa988caf564fdfa5c735419bfb (patch)
treeaa4e336d02b437ee8847ba12754b69949a16be00
parent7861c764f4c78da5ab017c8cea5ffc5e84570f4a (diff)
TDB 335.22021 - 2022/02/16TDB335.22021
-rw-r--r--revision_data.h.in.cmake2
-rw-r--r--sql/base/auth_database.sql17
-rw-r--r--sql/base/characters_database.sql5
-rw-r--r--sql/base/dev/world_database.sql14
-rw-r--r--sql/old/3.3.5a/auth/22011_2022_02_16/2022_01_15_00_auth.sql (renamed from sql/updates/auth/3.3.5/2022_01_15_00_auth.sql)0
-rw-r--r--sql/old/3.3.5a/characters/22011_2022_02_16/2022_01_15_00_characters.sql (renamed from sql/updates/characters/3.3.5/2022_01_15_00_characters.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_01_15_00_world.sql (renamed from sql/updates/world/3.3.5/2022_01_15_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_01_20_00_world.sql (renamed from sql/updates/world/3.3.5/2022_01_20_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_01_20_01_world.sql (renamed from sql/updates/world/3.3.5/2022_01_20_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_01_20_02_world.sql (renamed from sql/updates/world/3.3.5/2022_01_20_02_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_00_world.sql (renamed from sql/updates/world/3.3.5/2022_01_22_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_01_world.sql (renamed from sql/updates/world/3.3.5/2022_01_22_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_02_world.sql (renamed from sql/updates/world/3.3.5/2022_01_22_02_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_03_world.sql (renamed from sql/updates/world/3.3.5/2022_01_22_03_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_04_world.sql (renamed from sql/updates/world/3.3.5/2022_01_22_04_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_05_world.sql (renamed from sql/updates/world/3.3.5/2022_01_22_05_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_06_world.sql (renamed from sql/updates/world/3.3.5/2022_01_22_06_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_07_world.sql (renamed from sql/updates/world/3.3.5/2022_01_22_07_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_08_world.sql (renamed from sql/updates/world/3.3.5/2022_01_22_08_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_09_world.sql (renamed from sql/updates/world/3.3.5/2022_01_22_09_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_10_world.sql (renamed from sql/updates/world/3.3.5/2022_01_22_10_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_11_world.sql (renamed from sql/updates/world/3.3.5/2022_01_22_11_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_12_world.sql (renamed from sql/updates/world/3.3.5/2022_01_22_12_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_13_world.sql (renamed from sql/updates/world/3.3.5/2022_01_22_13_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_14_world.sql (renamed from sql/updates/world/3.3.5/2022_01_22_14_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_15_world.sql (renamed from sql/updates/world/3.3.5/2022_01_22_15_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_16_world.sql (renamed from sql/updates/world/3.3.5/2022_01_22_16_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_17_world.sql (renamed from sql/updates/world/3.3.5/2022_01_22_17_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_01_27_00_world.sql (renamed from sql/updates/world/3.3.5/2022_01_27_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_01_27_01_world.sql (renamed from sql/updates/world/3.3.5/2022_01_27_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_01_28_00_world.sql (renamed from sql/updates/world/3.3.5/2022_01_28_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_01_28_01_world.sql (renamed from sql/updates/world/3.3.5/2022_01_28_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_02_01_00_world.sql (renamed from sql/updates/world/3.3.5/2022_02_01_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_02_01_01_world.sql (renamed from sql/updates/world/3.3.5/2022_02_01_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_02_01_02_world.sql (renamed from sql/updates/world/3.3.5/2022_02_01_02_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_02_04_00_world.sql (renamed from sql/updates/world/3.3.5/2022_02_04_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_02_07_00_world.sql (renamed from sql/updates/world/3.3.5/2022_02_07_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_02_07_01_world.sql (renamed from sql/updates/world/3.3.5/2022_02_07_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_02_07_02_world.sql (renamed from sql/updates/world/3.3.5/2022_02_07_02_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_02_09_00_world_335.sql (renamed from sql/updates/world/3.3.5/2022_02_09_00_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_02_09_01_world.sql (renamed from sql/updates/world/3.3.5/2022_02_09_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_02_09_02_world.sql (renamed from sql/updates/world/3.3.5/2022_02_09_02_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_02_09_03_world.sql (renamed from sql/updates/world/3.3.5/2022_02_09_03_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_02_09_04_world.sql (renamed from sql/updates/world/3.3.5/2022_02_09_04_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_00_world.sql (renamed from sql/updates/world/3.3.5/2022_02_13_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_01_world.sql (renamed from sql/updates/world/3.3.5/2022_02_13_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_02_world.sql (renamed from sql/updates/world/3.3.5/2022_02_13_02_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_03_world_335.sql (renamed from sql/updates/world/3.3.5/2022_02_13_03_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_04_world_335.sql (renamed from sql/updates/world/3.3.5/2022_02_13_04_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_05_world.sql (renamed from sql/updates/world/3.3.5/2022_02_13_05_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_06_world.sql (renamed from sql/updates/world/3.3.5/2022_02_13_06_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_07_world.sql (renamed from sql/updates/world/3.3.5/2022_02_13_07_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_02_14_00_world.sql (renamed from sql/updates/world/3.3.5/2022_02_14_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_02_16_00_world.sql (renamed from sql/updates/world/3.3.5/2022_02_16_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_02_16_01_world.sql (renamed from sql/updates/world/3.3.5/2022_02_16_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/22011_2022_02_16/2022_02_16_02_world_335.sql (renamed from sql/updates/world/3.3.5/2022_02_16_02_world_335.sql)0
-rw-r--r--sql/updates/auth/3.3.5/2022_02_16_00_auth.sql2
-rw-r--r--sql/updates/characters/3.3.5/2022_02_16_00_characters.sql2
-rw-r--r--sql/updates/world/3.3.5/2022_02_16_03_world.sql3
59 files changed, 27 insertions, 18 deletions
diff --git a/revision_data.h.in.cmake b/revision_data.h.in.cmake
index e2233ece2da..c0ce7009a23 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.22011_2022_01_15.sql"
+ #define _FULL_DATABASE "TDB_full_world_335.22021_2022_02_16.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 9c59ebd7291..5ab0f5d41c3 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -176,12 +176,12 @@ CREATE TABLE `build_info` (
`majorVersion` int DEFAULT NULL,
`minorVersion` int DEFAULT NULL,
`bugfixVersion` int DEFAULT NULL,
- `hotfixVersion` char(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
- `winAuthSeed` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
- `win64AuthSeed` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
- `mac64AuthSeed` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
- `winChecksumSeed` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
- `macChecksumSeed` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `hotfixVersion` char(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `winAuthSeed` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `win64AuthSeed` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `mac64AuthSeed` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `winChecksumSeed` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `macChecksumSeed` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`build`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -1998,7 +1998,8 @@ INSERT INTO `updates` VALUES
('2021_11_15_00_auth.sql','82D88B06301130C7149E21A991364F62279E219B','ARCHIVED','2021-11-15 16:22:37',0),
('2021_12_16_00_auth.sql','A0765C5337833E827B029A5E29F8B7601C81F89E','ARCHIVED','2021-12-16 21:17:10',0),
('2022_01_01_00_auth.sql','CDC8349AA1135258D66F351141C0D9AD4EE7EB14','ARCHIVED','2022-01-01 19:35:19',0),
-('2022_01_15_00_auth.sql','A2123CEC10327ECA4C92A8B2212AEE25B43C457B','ARCHIVED','2022-01-15 18:05:55',0);
+('2022_01_15_00_auth.sql','A2123CEC10327ECA4C92A8B2212AEE25B43C457B','ARCHIVED','2022-01-15 18:05:55',0),
+('2022_02_16_00_auth.sql','CFB54EB37319916B1B80E29F5572D12A7D9A33F5','ARCHIVED','2022-02-16 21:52:01',0);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
@@ -2137,4 +2138,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 2022-01-15 18:05:58
+-- Dump completed on 2022-02-16 21:52:04
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 5a3b41b5b25..d37088cbf06 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -2671,7 +2671,8 @@ INSERT INTO `updates` VALUES
('2021_10_15_00_characters.sql','174355CFEA8FADA50B731F54E028561AFCF46AA6','ARCHIVED','2021-10-15 08:43:41',0),
('2021_11_15_00_characters.sql','4C911C08E2E7A22E9A2FFC0AAC05481574D8048E','ARCHIVED','2021-11-15 16:22:37',0),
('2021_12_16_00_characters.sql','C250DF213B43FC2186520C3901C0A1FBF522BBDF','ARCHIVED','2021-12-16 21:17:10',0),
-('2022_01_15_00_characters.sql','351DEB60A6BB87FD9ED5D097E15ADBC32424C58A','ARCHIVED','2022-01-15 18:05:55',0);
+('2022_01_15_00_characters.sql','351DEB60A6BB87FD9ED5D097E15ADBC32424C58A','ARCHIVED','2022-01-15 18:05:55',0),
+('2022_02_16_00_characters.sql','3086FE1DB569830190013FE0129F9CF072C12D6A','ARCHIVED','2022-02-16 21:52:01',0);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
@@ -2842,4 +2843,4 @@ UNLOCK TABLES;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2022-01-15 18:05:59
+-- Dump completed on 2022-02-16 21:52:04
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index 2b7e24268a1..b51d070b22a 100644
--- a/sql/base/dev/world_database.sql
+++ b/sql/base/dev/world_database.sql
@@ -248,7 +248,7 @@ CREATE TABLE `broadcast_text` (
`SoundEntriesID` mediumint unsigned NOT NULL DEFAULT '0',
`EmotesID` mediumint unsigned NOT NULL DEFAULT '0',
`Flags` mediumint unsigned NOT NULL DEFAULT '0',
- `VerifiedBuild` smallint DEFAULT '0',
+ `VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -1161,7 +1161,7 @@ CREATE TABLE `game_tele` (
`map` smallint unsigned NOT NULL DEFAULT '0',
`name` varchar(100) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
-) ENGINE=MyISAM AUTO_INCREMENT=1433 DEFAULT CHARSET=utf8mb3 COMMENT='Tele Command';
+) ENGINE=MyISAM AUTO_INCREMENT=1517 DEFAULT CHARSET=utf8mb3 COMMENT='Tele Command';
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -2091,7 +2091,7 @@ CREATE TABLE `page_text` (
`ID` mediumint unsigned NOT NULL DEFAULT '0',
`Text` longtext NOT NULL,
`NextPageID` mediumint unsigned NOT NULL DEFAULT '0',
- `VerifiedBuild` smallint DEFAULT '0',
+ `VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='Item System';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -2539,7 +2539,7 @@ CREATE TABLE `quest_details` (
`EmoteDelay2` int unsigned NOT NULL DEFAULT '0',
`EmoteDelay3` int unsigned NOT NULL DEFAULT '0',
`EmoteDelay4` int unsigned NOT NULL DEFAULT '0',
- `VerifiedBuild` smallint NOT NULL DEFAULT '0',
+ `VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -2611,7 +2611,7 @@ CREATE TABLE `quest_offer_reward` (
`EmoteDelay3` int unsigned NOT NULL DEFAULT '0',
`EmoteDelay4` int unsigned NOT NULL DEFAULT '0',
`RewardText` text,
- `VerifiedBuild` smallint NOT NULL DEFAULT '0',
+ `VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -2716,7 +2716,7 @@ CREATE TABLE `quest_request_items` (
`EmoteOnComplete` smallint unsigned NOT NULL DEFAULT '0',
`EmoteOnIncomplete` smallint unsigned NOT NULL DEFAULT '0',
`CompletionText` text,
- `VerifiedBuild` smallint NOT NULL DEFAULT '0',
+ `VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -4061,4 +4061,4 @@ CREATE TABLE `waypoints` (
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2022-01-15 18:06:00
+-- Dump completed on 2022-02-16 21:52:05
diff --git a/sql/updates/auth/3.3.5/2022_01_15_00_auth.sql b/sql/old/3.3.5a/auth/22011_2022_02_16/2022_01_15_00_auth.sql
index 8bff20717e3..8bff20717e3 100644
--- a/sql/updates/auth/3.3.5/2022_01_15_00_auth.sql
+++ b/sql/old/3.3.5a/auth/22011_2022_02_16/2022_01_15_00_auth.sql
diff --git a/sql/updates/characters/3.3.5/2022_01_15_00_characters.sql b/sql/old/3.3.5a/characters/22011_2022_02_16/2022_01_15_00_characters.sql
index b2177772ff9..b2177772ff9 100644
--- a/sql/updates/characters/3.3.5/2022_01_15_00_characters.sql
+++ b/sql/old/3.3.5a/characters/22011_2022_02_16/2022_01_15_00_characters.sql
diff --git a/sql/updates/world/3.3.5/2022_01_15_00_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_15_00_world.sql
index e3136864532..e3136864532 100644
--- a/sql/updates/world/3.3.5/2022_01_15_00_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_15_00_world.sql
diff --git a/sql/updates/world/3.3.5/2022_01_20_00_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_20_00_world.sql
index 713c712c00f..713c712c00f 100644
--- a/sql/updates/world/3.3.5/2022_01_20_00_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_20_00_world.sql
diff --git a/sql/updates/world/3.3.5/2022_01_20_01_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_20_01_world.sql
index 4a89d6e560b..4a89d6e560b 100644
--- a/sql/updates/world/3.3.5/2022_01_20_01_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_20_01_world.sql
diff --git a/sql/updates/world/3.3.5/2022_01_20_02_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_20_02_world.sql
index ad281306bd2..ad281306bd2 100644
--- a/sql/updates/world/3.3.5/2022_01_20_02_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_20_02_world.sql
diff --git a/sql/updates/world/3.3.5/2022_01_22_00_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_00_world.sql
index 3210693f075..3210693f075 100644
--- a/sql/updates/world/3.3.5/2022_01_22_00_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_00_world.sql
diff --git a/sql/updates/world/3.3.5/2022_01_22_01_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_01_world.sql
index f8d147109b9..f8d147109b9 100644
--- a/sql/updates/world/3.3.5/2022_01_22_01_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_01_world.sql
diff --git a/sql/updates/world/3.3.5/2022_01_22_02_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_02_world.sql
index 7da02c90af8..7da02c90af8 100644
--- a/sql/updates/world/3.3.5/2022_01_22_02_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_02_world.sql
diff --git a/sql/updates/world/3.3.5/2022_01_22_03_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_03_world.sql
index 0ac0a87c749..0ac0a87c749 100644
--- a/sql/updates/world/3.3.5/2022_01_22_03_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_03_world.sql
diff --git a/sql/updates/world/3.3.5/2022_01_22_04_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_04_world.sql
index 22b2b8caceb..22b2b8caceb 100644
--- a/sql/updates/world/3.3.5/2022_01_22_04_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_04_world.sql
diff --git a/sql/updates/world/3.3.5/2022_01_22_05_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_05_world.sql
index 433262a75cb..433262a75cb 100644
--- a/sql/updates/world/3.3.5/2022_01_22_05_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_05_world.sql
diff --git a/sql/updates/world/3.3.5/2022_01_22_06_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_06_world.sql
index 9ac13403b1f..9ac13403b1f 100644
--- a/sql/updates/world/3.3.5/2022_01_22_06_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_06_world.sql
diff --git a/sql/updates/world/3.3.5/2022_01_22_07_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_07_world.sql
index df971683f62..df971683f62 100644
--- a/sql/updates/world/3.3.5/2022_01_22_07_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_07_world.sql
diff --git a/sql/updates/world/3.3.5/2022_01_22_08_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_08_world.sql
index 85f46bd5fc3..85f46bd5fc3 100644
--- a/sql/updates/world/3.3.5/2022_01_22_08_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_08_world.sql
diff --git a/sql/updates/world/3.3.5/2022_01_22_09_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_09_world.sql
index 2226055c4eb..2226055c4eb 100644
--- a/sql/updates/world/3.3.5/2022_01_22_09_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_09_world.sql
diff --git a/sql/updates/world/3.3.5/2022_01_22_10_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_10_world.sql
index b336213a81a..b336213a81a 100644
--- a/sql/updates/world/3.3.5/2022_01_22_10_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_10_world.sql
diff --git a/sql/updates/world/3.3.5/2022_01_22_11_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_11_world.sql
index 37717c06e00..37717c06e00 100644
--- a/sql/updates/world/3.3.5/2022_01_22_11_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_11_world.sql
diff --git a/sql/updates/world/3.3.5/2022_01_22_12_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_12_world.sql
index af20a251b01..af20a251b01 100644
--- a/sql/updates/world/3.3.5/2022_01_22_12_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_12_world.sql
diff --git a/sql/updates/world/3.3.5/2022_01_22_13_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_13_world.sql
index e0a8f25408b..e0a8f25408b 100644
--- a/sql/updates/world/3.3.5/2022_01_22_13_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_13_world.sql
diff --git a/sql/updates/world/3.3.5/2022_01_22_14_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_14_world.sql
index faba9f82e26..faba9f82e26 100644
--- a/sql/updates/world/3.3.5/2022_01_22_14_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_14_world.sql
diff --git a/sql/updates/world/3.3.5/2022_01_22_15_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_15_world.sql
index 7b8df2978a2..7b8df2978a2 100644
--- a/sql/updates/world/3.3.5/2022_01_22_15_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_15_world.sql
diff --git a/sql/updates/world/3.3.5/2022_01_22_16_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_16_world.sql
index 03c92f08535..03c92f08535 100644
--- a/sql/updates/world/3.3.5/2022_01_22_16_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_16_world.sql
diff --git a/sql/updates/world/3.3.5/2022_01_22_17_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_17_world.sql
index 0818a2c5653..0818a2c5653 100644
--- a/sql/updates/world/3.3.5/2022_01_22_17_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_17_world.sql
diff --git a/sql/updates/world/3.3.5/2022_01_27_00_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_27_00_world.sql
index e75a500850a..e75a500850a 100644
--- a/sql/updates/world/3.3.5/2022_01_27_00_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_27_00_world.sql
diff --git a/sql/updates/world/3.3.5/2022_01_27_01_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_27_01_world.sql
index f259b26ef46..f259b26ef46 100644
--- a/sql/updates/world/3.3.5/2022_01_27_01_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_27_01_world.sql
diff --git a/sql/updates/world/3.3.5/2022_01_28_00_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_28_00_world.sql
index 0f27c8b6db4..0f27c8b6db4 100644
--- a/sql/updates/world/3.3.5/2022_01_28_00_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_28_00_world.sql
diff --git a/sql/updates/world/3.3.5/2022_01_28_01_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_28_01_world.sql
index 9d06b273937..9d06b273937 100644
--- a/sql/updates/world/3.3.5/2022_01_28_01_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_28_01_world.sql
diff --git a/sql/updates/world/3.3.5/2022_02_01_00_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_01_00_world.sql
index aa8e6b53f6f..aa8e6b53f6f 100644
--- a/sql/updates/world/3.3.5/2022_02_01_00_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_01_00_world.sql
diff --git a/sql/updates/world/3.3.5/2022_02_01_01_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_01_01_world.sql
index 124a74b5a1b..124a74b5a1b 100644
--- a/sql/updates/world/3.3.5/2022_02_01_01_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_01_01_world.sql
diff --git a/sql/updates/world/3.3.5/2022_02_01_02_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_01_02_world.sql
index 596872decc2..596872decc2 100644
--- a/sql/updates/world/3.3.5/2022_02_01_02_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_01_02_world.sql
diff --git a/sql/updates/world/3.3.5/2022_02_04_00_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_04_00_world.sql
index 1cb5625b9d4..1cb5625b9d4 100644
--- a/sql/updates/world/3.3.5/2022_02_04_00_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_04_00_world.sql
diff --git a/sql/updates/world/3.3.5/2022_02_07_00_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_07_00_world.sql
index 3a2468c72ea..3a2468c72ea 100644
--- a/sql/updates/world/3.3.5/2022_02_07_00_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_07_00_world.sql
diff --git a/sql/updates/world/3.3.5/2022_02_07_01_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_07_01_world.sql
index 6ec01b0970a..6ec01b0970a 100644
--- a/sql/updates/world/3.3.5/2022_02_07_01_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_07_01_world.sql
diff --git a/sql/updates/world/3.3.5/2022_02_07_02_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_07_02_world.sql
index 7203ab5a15a..7203ab5a15a 100644
--- a/sql/updates/world/3.3.5/2022_02_07_02_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_07_02_world.sql
diff --git a/sql/updates/world/3.3.5/2022_02_09_00_world_335.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_09_00_world_335.sql
index 38a2fcfc675..38a2fcfc675 100644
--- a/sql/updates/world/3.3.5/2022_02_09_00_world_335.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_09_00_world_335.sql
diff --git a/sql/updates/world/3.3.5/2022_02_09_01_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_09_01_world.sql
index 4311fe2f28f..4311fe2f28f 100644
--- a/sql/updates/world/3.3.5/2022_02_09_01_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_09_01_world.sql
diff --git a/sql/updates/world/3.3.5/2022_02_09_02_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_09_02_world.sql
index 81f7637513f..81f7637513f 100644
--- a/sql/updates/world/3.3.5/2022_02_09_02_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_09_02_world.sql
diff --git a/sql/updates/world/3.3.5/2022_02_09_03_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_09_03_world.sql
index a4527c87588..a4527c87588 100644
--- a/sql/updates/world/3.3.5/2022_02_09_03_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_09_03_world.sql
diff --git a/sql/updates/world/3.3.5/2022_02_09_04_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_09_04_world.sql
index 23270828415..23270828415 100644
--- a/sql/updates/world/3.3.5/2022_02_09_04_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_09_04_world.sql
diff --git a/sql/updates/world/3.3.5/2022_02_13_00_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_00_world.sql
index 5b7f385a9db..5b7f385a9db 100644
--- a/sql/updates/world/3.3.5/2022_02_13_00_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_00_world.sql
diff --git a/sql/updates/world/3.3.5/2022_02_13_01_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_01_world.sql
index 5e8eba143db..5e8eba143db 100644
--- a/sql/updates/world/3.3.5/2022_02_13_01_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_01_world.sql
diff --git a/sql/updates/world/3.3.5/2022_02_13_02_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_02_world.sql
index 452eb014602..452eb014602 100644
--- a/sql/updates/world/3.3.5/2022_02_13_02_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_02_world.sql
diff --git a/sql/updates/world/3.3.5/2022_02_13_03_world_335.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_03_world_335.sql
index 4bd057618ed..4bd057618ed 100644
--- a/sql/updates/world/3.3.5/2022_02_13_03_world_335.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_03_world_335.sql
diff --git a/sql/updates/world/3.3.5/2022_02_13_04_world_335.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_04_world_335.sql
index b94ed933d5b..b94ed933d5b 100644
--- a/sql/updates/world/3.3.5/2022_02_13_04_world_335.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_04_world_335.sql
diff --git a/sql/updates/world/3.3.5/2022_02_13_05_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_05_world.sql
index 0a477f5130b..0a477f5130b 100644
--- a/sql/updates/world/3.3.5/2022_02_13_05_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_05_world.sql
diff --git a/sql/updates/world/3.3.5/2022_02_13_06_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_06_world.sql
index eb2bdbefbb9..eb2bdbefbb9 100644
--- a/sql/updates/world/3.3.5/2022_02_13_06_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_06_world.sql
diff --git a/sql/updates/world/3.3.5/2022_02_13_07_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_07_world.sql
index 5b2226ab117..5b2226ab117 100644
--- a/sql/updates/world/3.3.5/2022_02_13_07_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_07_world.sql
diff --git a/sql/updates/world/3.3.5/2022_02_14_00_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_14_00_world.sql
index 1316f6f5b7b..1316f6f5b7b 100644
--- a/sql/updates/world/3.3.5/2022_02_14_00_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_14_00_world.sql
diff --git a/sql/updates/world/3.3.5/2022_02_16_00_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_16_00_world.sql
index eb4333a71c9..eb4333a71c9 100644
--- a/sql/updates/world/3.3.5/2022_02_16_00_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_16_00_world.sql
diff --git a/sql/updates/world/3.3.5/2022_02_16_01_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_16_01_world.sql
index 46050344013..46050344013 100644
--- a/sql/updates/world/3.3.5/2022_02_16_01_world.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_16_01_world.sql
diff --git a/sql/updates/world/3.3.5/2022_02_16_02_world_335.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_16_02_world_335.sql
index 7b5e1586000..7b5e1586000 100644
--- a/sql/updates/world/3.3.5/2022_02_16_02_world_335.sql
+++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_16_02_world_335.sql
diff --git a/sql/updates/auth/3.3.5/2022_02_16_00_auth.sql b/sql/updates/auth/3.3.5/2022_02_16_00_auth.sql
new file mode 100644
index 00000000000..40685cc583a
--- /dev/null
+++ b/sql/updates/auth/3.3.5/2022_02_16_00_auth.sql
@@ -0,0 +1,2 @@
+-- TDB 335.22021 auth
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/characters/3.3.5/2022_02_16_00_characters.sql b/sql/updates/characters/3.3.5/2022_02_16_00_characters.sql
new file mode 100644
index 00000000000..c50d58c6500
--- /dev/null
+++ b/sql/updates/characters/3.3.5/2022_02_16_00_characters.sql
@@ -0,0 +1,2 @@
+-- TDB 335.22021 characters
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/world/3.3.5/2022_02_16_03_world.sql b/sql/updates/world/3.3.5/2022_02_16_03_world.sql
new file mode 100644
index 00000000000..e21707dbfe4
--- /dev/null
+++ b/sql/updates/world/3.3.5/2022_02_16_03_world.sql
@@ -0,0 +1,3 @@
+-- TDB 335.22021 world
+UPDATE `version` SET `db_version`='TDB 335.22021', `cache_id`=22021 LIMIT 1;
+UPDATE `updates` SET `state`='ARCHIVED';