From 1bbc8592d95978a4c681fa6177c7c457189ef485 Mon Sep 17 00:00:00 2001 From: Meji Date: Sat, 13 Aug 2022 20:17:58 +0200 Subject: Core/Gossips: Added support for FriendshipFactionID (#28192) --- sql/updates/world/master/2022_08_13_00_world.sql | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) create mode 100644 sql/updates/world/master/2022_08_13_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2022_08_13_00_world.sql b/sql/updates/world/master/2022_08_13_00_world.sql new file mode 100644 index 00000000000..40db4990405 --- /dev/null +++ b/sql/updates/world/master/2022_08_13_00_world.sql @@ -0,0 +1,19 @@ +DROP TABLE IF EXISTS `gossip_menu_addon`; +CREATE TABLE `gossip_menu_addon` ( + `MenuID` INT UNSIGNED NOT NULL DEFAULT 0, + `FriendshipFactionID` INT NOT NULL DEFAULT 0, + `VerifiedBuild` INT NOT NULL DEFAULT 0, + PRIMARY KEY (`MenuID`) +) ENGINE=INNODB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; + +DELETE FROM `gossip_menu_addon` WHERE `MenuID` IN (13332, 13338, 13470, 13475, 13486, 13574, 13593, 13594, 13595); +INSERT INTO `gossip_menu_addon` (`MenuID`, `FriendshipFactionID`, `VerifiedBuild`) VALUES +(13332, 1283, 44908), -- 57298 (Farmer Fung) +(13338, 1279, 44908), -- 57402 (Haohan Mudclaw) +(13470, 1281, 44908), -- 58706 (Gina Mudclaw) +(13475, 1281, 44908), -- 58706 (Gina Mudclaw) +(13486, 1275, 44908), -- 58647 (Ella) +(13574, 1282, 44908), -- 58705 (Fish Fellreed) +(13593, 1280, 44908), -- 58761 (Tina Mudclaw) +(13594, 1277, 44908), -- 58709 (Chee Chee) +(13595, 1276, 44908); -- 58707 (Old Hillpaw) -- cgit v1.2.3