From 8efeb202a500bda46283127f66fb85f6b91f9e76 Mon Sep 17 00:00:00 2001 From: Shauren Date: Thu, 7 Sep 2023 01:10:07 +0200 Subject: Core: Update to 10.1.7 --- sql/updates/auth/master/2023_09_07_00_auth.sql | 8 ++++++++ sql/updates/hotfixes/master/2023_09_07_00_hotfixes.sql | 10 ++++++++++ 2 files changed, 18 insertions(+) create mode 100644 sql/updates/auth/master/2023_09_07_00_auth.sql create mode 100644 sql/updates/hotfixes/master/2023_09_07_00_hotfixes.sql (limited to 'sql/updates') diff --git a/sql/updates/auth/master/2023_09_07_00_auth.sql b/sql/updates/auth/master/2023_09_07_00_auth.sql new file mode 100644 index 00000000000..508be5a7ec7 --- /dev/null +++ b/sql/updates/auth/master/2023_09_07_00_auth.sql @@ -0,0 +1,8 @@ +DELETE FROM `build_info` WHERE `build` IN (51187,51237); +INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES +(51187,10,1,7,NULL,NULL,'74E2055D3965269447B5CB1B31FC71C6',NULL,NULL,NULL), +(51237,10,1,7,NULL,NULL,'C8660A21B766646FBD67F481CFCF55C3',NULL,NULL,NULL); + +UPDATE `realmlist` SET `gamebuild`=51237 WHERE `gamebuild`=51130; + +ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '51237'; diff --git a/sql/updates/hotfixes/master/2023_09_07_00_hotfixes.sql b/sql/updates/hotfixes/master/2023_09_07_00_hotfixes.sql new file mode 100644 index 00000000000..61dbd08eb22 --- /dev/null +++ b/sql/updates/hotfixes/master/2023_09_07_00_hotfixes.sql @@ -0,0 +1,10 @@ +ALTER TABLE `chr_classes` MODIFY `RolesMask` tinyint UNSIGNED NOT NULL DEFAULT 0 AFTER `ClassColorB`; + +ALTER TABLE `chr_customization_element` ADD `ParticleColorID` int NOT NULL DEFAULT 0 AFTER `AnimKitID`; + +ALTER TABLE `creature_model_data` ADD `WalkSpeed` float NOT NULL DEFAULT 0 AFTER `FileDataID`; +ALTER TABLE `creature_model_data` ADD `RunSpeed` float NOT NULL DEFAULT 0 AFTER `WalkSpeed`; + +ALTER TABLE `taxi_nodes` MODIFY `Flags` int NOT NULL DEFAULT 0 AFTER `CharacterBitNumber`; + +ALTER TABLE `taxi_path_node` MODIFY `Flags` int NOT NULL DEFAULT 0 AFTER `ContinentID`; -- cgit v1.2.3