diff options
| author | Shauren <shauren.trinity@gmail.com> | 2016-10-25 19:13:32 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2016-10-25 19:29:27 +0200 |
| commit | af25942aeca6fb1a1656756b064f7c5208b715d2 (patch) | |
| tree | d641bc51185e564ef16feed889297ff0272ca545 /sql/updates | |
| parent | 40baf3e94ffc2bf4cae91bb540f5f303a3daa368 (diff) | |
Core/PacketIO: Updated packets to 7.1.0.22900
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/auth/master/2016_10_25_00_auth.sql | 3 | ||||
| -rw-r--r-- | sql/updates/characters/master/2016_10_25_00_characters.sql | 9 | ||||
| -rw-r--r-- | sql/updates/world/master/2016_10_25_00_world.sql | 1 |
3 files changed, 13 insertions, 0 deletions
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`; |