From af25942aeca6fb1a1656756b064f7c5208b715d2 Mon Sep 17 00:00:00 2001 From: Shauren Date: Tue, 25 Oct 2016 19:13:32 +0200 Subject: Core/PacketIO: Updated packets to 7.1.0.22900 --- sql/updates/auth/master/2016_10_25_00_auth.sql | 3 +++ sql/updates/characters/master/2016_10_25_00_characters.sql | 9 +++++++++ sql/updates/world/master/2016_10_25_00_world.sql | 1 + 3 files changed, 13 insertions(+) create mode 100644 sql/updates/auth/master/2016_10_25_00_auth.sql create mode 100644 sql/updates/characters/master/2016_10_25_00_characters.sql create mode 100644 sql/updates/world/master/2016_10_25_00_world.sql (limited to 'sql/updates') diff --git a/sql/updates/auth/master/2016_10_25_00_auth.sql b/sql/updates/auth/master/2016_10_25_00_auth.sql new file mode 100644 index 00000000000..b9e0e5abd3a --- /dev/null +++ b/sql/updates/auth/master/2016_10_25_00_auth.sql @@ -0,0 +1,3 @@ +UPDATE `realmlist` SET `gamebuild`=22900 WHERE `gamebuild`=22810; + +ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '22900'; diff --git a/sql/updates/characters/master/2016_10_25_00_characters.sql b/sql/updates/characters/master/2016_10_25_00_characters.sql new file mode 100644 index 00000000000..3396c3e0a4b --- /dev/null +++ b/sql/updates/characters/master/2016_10_25_00_characters.sql @@ -0,0 +1,9 @@ +ALTER TABLE `character_cuf_profiles` + CHANGE `unk146` `topPoint` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Frame top alignment' AFTER `boolOptions`, + CHANGE `unk147` `bottomPoint` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Frame bottom alignment' AFTER `topPoint`, + CHANGE `unk148` `leftPoint` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Frame left alignment' AFTER `bottomPoint`, + CHANGE `unk150` `topOffset` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Frame position offset from top' AFTER `leftPoint`, + CHANGE `unk152` `bottomOffset` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Frame position offset from bottom' AFTER `topOffset`, + CHANGE `unk154` `leftOffset` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Frame position offset from left' AFTER `bottomOffset`; + +UPDATE `character_cuf_profiles` SET `boolOptions`=((`boolOptions`&0x1800000)<<2)|(`boolOptions`&0x67FFFFF); diff --git a/sql/updates/world/master/2016_10_25_00_world.sql b/sql/updates/world/master/2016_10_25_00_world.sql new file mode 100644 index 00000000000..305da7b6c88 --- /dev/null +++ b/sql/updates/world/master/2016_10_25_00_world.sql @@ -0,0 +1 @@ +ALTER TABLE `quest_objectives` ADD `Flags2` int(10) unsigned NOT NULL DEFAULT '0' AFTER `Flags`; -- cgit v1.2.3