From d3c4216de8e1dcb9f62d2fcc1b9b72852e5409c9 Mon Sep 17 00:00:00 2001 From: Shauren Date: Wed, 1 Jun 2022 23:13:29 +0200 Subject: Core/PacketIO: Updated packet structures to 9.2.5 --- sql/updates/characters/master/2022_06_01_00_characters.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 sql/updates/characters/master/2022_06_01_00_characters.sql (limited to 'sql/updates') diff --git a/sql/updates/characters/master/2022_06_01_00_characters.sql b/sql/updates/characters/master/2022_06_01_00_characters.sql new file mode 100644 index 00000000000..4da2051ad0c --- /dev/null +++ b/sql/updates/characters/master/2022_06_01_00_characters.sql @@ -0,0 +1,12 @@ +ALTER TABLE `gm_complaint` + ADD `reportType` int NOT NULL DEFAULT '0' AFTER `complaintType`, + ADD `reportMajorCategory` int NOT NULL DEFAULT '0' AFTER `reportType`, + ADD `reportMinorCategoryFlags` int NOT NULL DEFAULT '0' AFTER `reportMajorCategory`; + +UPDATE `gm_complaint` SET `reportType`=0,`reportMajorCategory`=0,`reportMinorCategoryFlags`=0x1 WHERE `complaintType`=2; +UPDATE `gm_complaint` SET `reportType`=1,`reportMajorCategory`=3,`reportMinorCategoryFlags`=0x800 WHERE `complaintType`=4; +UPDATE `gm_complaint` SET `reportType`=1,`reportMajorCategory`=2,`reportMinorCategoryFlags`=0x40 WHERE `complaintType`=15; +UPDATE `gm_complaint` SET `reportType`=1,`reportMajorCategory`=3,`reportMinorCategoryFlags`=0x1000 WHERE `complaintType`=23; +UPDATE `gm_complaint` SET `reportType`=0,`reportMajorCategory`=0,`reportMinorCategoryFlags`=0x4 WHERE `complaintType`=24; + +ALTER TABLE `gm_complaint` DROP `complaintType`; -- cgit v1.2.3