Core/PacketIO: Updated to 11.0.0

3 files changed, 23 insertions, 1 deletions

diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 54948e86426..ac36c3a6462 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -2312,6 +2312,7 @@ CREATE TABLE `groups` (
   `raidDifficulty` tinyint unsigned NOT NULL DEFAULT '14',
   `legacyRaidDifficulty` tinyint unsigned NOT NULL DEFAULT '3',
   `masterLooterGuid` bigint unsigned NOT NULL,
+  `pingRestriction` tinying NOT NULL,
   PRIMARY KEY (`guid`),
   KEY `leaderGuid` (`leaderGuid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Groups';
@@ -3741,7 +3742,8 @@ INSERT INTO `updates` VALUES
 ('2024_04_09_00_characters.sql','07AC79B4E489B1CD073852EC57D12939C2A1D4B1','ARCHIVED','2024-04-09 12:54:11',0),
 ('2024_04_12_00_characters.sql','043E023F998DA77170C9D2D0162CAA340290B215','ARCHIVED','2024-04-12 00:23:51',0),
 ('2024_04_28_00_characters.sql','F80F476704BE535B5DCB0BCEBDD56024FCFBBAA2','ARCHIVED','2024-04-28 19:26:58',0),
-('2024_05_11_00_characters.sql','A65765D87C1BA181561A6517040DC1A3A8103B71','ARCHIVED','2024-05-11 03:06:52',0);
+('2024_05_11_00_characters.sql','A65765D87C1BA181561A6517040DC1A3A8103B71','ARCHIVED','2024-05-11 03:06:52',0),
+('2024_07_31_00_characters.sql','F7E7AE0B8077CB9A1EA0AE4F49693BB05A742AC3','RELEASED','2024-07-31 16:18:36',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
diff --git a/sql/updates/characters/master/2024_07_31_00_characters.sql b/sql/updates/characters/master/2024_07_31_00_characters.sql
new file mode 100644
index 00000000000..1411b4697dc
--- /dev/null
+++ b/sql/updates/characters/master/2024_07_31_00_characters.sql
@@ -0,0 +1,5 @@
+ALTER TABLE `groups` ADD `pingRestriction` tinyint AFTER `masterLooterGuid`;
+
+UPDATE `groups` SET `pingRestriction`=0;
+
+ALTER TABLE `groups` MODIFY `pingRestriction` tinyint NOT NULL;
diff --git a/sql/updates/world/master/2024_07_31_00_world.sql b/sql/updates/world/master/2024_07_31_00_world.sql
new file mode 100644
index 00000000000..6d7c72832de
--- /dev/null
+++ b/sql/updates/world/master/2024_07_31_00_world.sql
@@ -0,0 +1,15 @@
+ALTER TABLE `gossip_menu_addon` ADD `LfgDungeonsID` int NOT NULL DEFAULT '0' AFTER `FriendshipFactionID`;
+
+DROP TABLE IF EXISTS `quest_treasure_pickers`;
+CREATE TABLE `quest_treasure_pickers` (
+  `QuestID` int unsigned NOT NULL,
+  `TreasurePickerID` int NOT NULL,
+  `OrderIndex` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`QuestID`,`TreasurePickerID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+
+INSERT INTO `quest_treasure_pickers` SELECT `ID`, `TreasurePickerID`, 0 FROM `quest_template` WHERE `TreasurePickerID` <> 0;
+
+ALTER TABLE `quest_template`
+  ADD `ResetByScheduler` tinyint NOT NULL DEFAULT '0' AFTER `QuestCompletionLog`,
+  DROP `TreasurePickerID`;