DB/Gossip: Added POI and Gossip data for Scalesworn Guardian

1 files changed, 113 insertions, 0 deletions

diff --git a/sql/updates/world/master/2023_03_08_02_world.sql b/sql/updates/world/master/2023_03_08_02_world.sql
new file mode 100644
index 00000000000..7acddc44e5a
--- /dev/null
+++ b/sql/updates/world/master/2023_03_08_02_world.sql
@@ -0,0 +1,113 @@
+SET @NPCTEXTID := 590052;
+
+DELETE FROM `points_of_interest` WHERE `ID` IN (7398, 7045, 7281, 7044, 7289, 7290, 7291, 7285, 7287, 7286, 7293, 7292, 7288, 7284, 7283, 7282, 7399, 7318, 7317, 7314, 7316, 7315, 7312, 7313, 7043, 7042, 7039, 7280, 7041, 7383, 7279, 7040);
+INSERT INTO `points_of_interest` (`ID`, `PositionX`, `PositionY`, `PositionZ`, `Icon`, `Flags`, `Importance`, `Name`, `WMOGroupID`, `VerifiedBuild`) VALUES
+(7398, 276.33099365234375, -854.89501953125, 822.58697509765625, 7, 99, 0, 'Item Upgrades', 67337, 48317),
+(7045, 99.73699951171875, -1280.47998046875, 909.49700927734375, 7, 99, 0, 'Valdrakken Transmogrifier', 67337, 48317),
+(7281, 188.7480010986328125, -590.614990234375, 817.344970703125, 7, 99, 0, 'Dragonriding Trainers', 0, 48317),
+(7044, -116.6719970703125, -883.2239990234375, 804.6190185546875, 7, 99, 0, 'Valdrakken Stable Master', 66918, 48317),
+(7289, 4.446529865264892578, -660.74200439453125, 773.6619873046875, 7, 99, 0, 'Valdrakken Tailoring', 66918, 48317),
+(7290, 53.74670028686523437, -612.43597412109375, 773.6619873046875, 7, 99, 0, 'Valdrakken Leatherworking & Skinning', 66918, 48317),
+(7291, 161.774993896484375, -765.6939697265625, 820.3699951171875, 7, 99, 0, 'Valdrakken Mining', 66918, 48317),
+(7285, 56.24679946899414062, -789.7080078125, 795.93902587890625, 7, 99, 0, 'Valdrakken Jewelcrafting', 67808, 48317),
+(7287, -62.6021995544433593, -761.1409912109375, 791.73797607421875, 7, 99, 0, 'Valdrakken Inscription', 66918, 48317),
+(7286, -17.4706993103027343, -748.55902099609375, 793.208984375, 7, 99, 0, 'Valdrakken Herbalism', 66918, 48317),
+(7293, -74.6863021850585937, -833.95599365234375, 791.531005859375, 7, 99, 0, 'Valdrakken Fishing', 65497, 48317),
+(7292, 176.496002197265625, -811.79901123046875, 819.01800537109375, 7, 99, 0, 'Valdrakken Engineering', 65497, 48317),
+(7288, 53.5027008056640625, -647.56097412109375, 773.66302490234375, 7, 99, 0, 'Valdrakken Enchanting', 66918, 48317),
+(7284, 201.0529937744140625, -874.822021484375, 843.27801513671875, 7, 99, 0, 'Valdrakken Cooking', 66918, 48317),
+(7283, 192.623992919921875, -736.25201416015625, 824.8909912109375, 7, 99, 0, 'Valdrakken Blacksmithing', 66749, 48317),
+(7282, -45.9306983947753906, -726.67999267578125, 791.73699951171875, 7, 99, 0, 'Valdrakken Alchemy', 0, 48317),
+(7399, 249.6670074462890625, -820.39300537109375, 822.5889892578125, 7, 99, 0, 'Gladiator\'s Refuge', 67337, 48317),
+(7318, -8.94303035736083984, -676.6820068359375, 802.60400390625, 7, 99, 0, 'Valdrakken Trade Market', 0, 48317),
+(7317, 88.16809844970703125, -392.19000244140625, 779.66497802734375, 7, 99, 0, 'Little Scales Daycare', 0, 48317),
+(7314, 469.572998046875, -1038.1600341796875, 892.46697998046875, 7, 99, 0, 'Red District', 0, 48317),
+(7316, 46.58050155639648437, -1207.739990234375, 887.0460205078125, 7, 99, 0, 'Green District', 0, 48317),
+(7315, 218.1060028076171875, -1344.719970703125, 951.91497802734375, 7, 99, 0, 'Bronze District', 0, 48317),
+(7312, 330.60198974609375, -700.572998046875, 833.99700927734375, 7, 99, 0, 'Blue District', 0, 48317),
+(7313, 179.7350006103515625, -766.1510009765625, 820.33502197265625, 7, 99, 0, 'Black District', 0, 48317),
+(7043, 278.00299072265625, -1055.699951171875, 870.6309814453125, 7, 99, 0, 'The Seat of the Aspects Portal Room', 67771, 48317),
+(7042, 186.73199462890625, -889.66400146484375, 842.906982421875, 7, 99, 0, 'The Roasted Ram', 66918, 48317),
+(7039, 105.194000244140625, -1050.969970703125, 838.57000732421875, 7, 99, 0, 'Valdrakken Bank', 67430, 48317),
+(7280, 71.3975982666015625, -824.9849853515625, 843.0880126953125, 7, 99, 0, 'Valdrakken Auction House', 67878, 48317),
+(7041, -7.87715005874633789, -846.42999267578125, 838.07098388671875, 7, 99, 0, 'Valdrakken Flight Master', 66804, 48317),
+(7383, 55.3722991943359375, -714.15899658203125, 796.2860107421875, 7, 99, 0, 'Crafting Orders', 0, 48317),
+(7279, 84.25319671630859375, -349.89898681640625, 780.67498779296875, 7, 99, 0, 'Battle Pet Trainer', 67337, 48317),
+(7040, 159.4680023193359375, -637.4329833984375, 775.9169921875, 7, 99, 0, 'The Victorious Visage', 67337, 48317);
+
+DELETE FROM `npc_text` WHERE `ID` BETWEEN @NPCTEXTID+0 AND @NPCTEXTID+10;
+INSERT INTO `npc_text` (`ID`, `Probability0`, `Probability1`, `Probability2`, `Probability3`, `Probability4`, `Probability5`, `Probability6`, `Probability7`, `BroadcastTextId0`, `BroadcastTextId1`, `BroadcastTextId2`, `BroadcastTextId3`, `BroadcastTextId4`, `BroadcastTextId5`, `BroadcastTextId6`, `BroadcastTextId7`, `VerifiedBuild`) VALUES
+(@NPCTEXTID+0, 1, 0, 0, 0, 0, 0, 0, 0, 232137, 0, 0, 0, 0, 0, 0, 0, 48317), -- 184168 (Scalesworn Guardian)
+(@NPCTEXTID+1, 1, 0, 0, 0, 0, 0, 0, 0, 232146, 0, 0, 0, 0, 0, 0, 0, 48317), -- 184168 (Scalesworn Guardian)
+(@NPCTEXTID+2, 1, 0, 0, 0, 0, 0, 0, 0, 232145, 0, 0, 0, 0, 0, 0, 0, 48317), -- 184168 (Scalesworn Guardian)
+(@NPCTEXTID+3, 1, 0, 0, 0, 0, 0, 0, 0, 232147, 0, 0, 0, 0, 0, 0, 0, 48317), -- 184168 (Scalesworn Guardian)
+(@NPCTEXTID+4, 1, 0, 0, 0, 0, 0, 0, 0, 232148, 0, 0, 0, 0, 0, 0, 0, 48317), -- 184168 (Scalesworn Guardian)
+(@NPCTEXTID+5, 1, 0, 0, 0, 0, 0, 0, 0, 232143, 0, 0, 0, 0, 0, 0, 0, 48317), -- 184168 (Scalesworn Guardian)
+(@NPCTEXTID+6, 1, 0, 0, 0, 0, 0, 0, 0, 231612, 0, 0, 0, 0, 0, 0, 0, 48317), -- 184168 (Scalesworn Guardian)
+(@NPCTEXTID+7, 1, 0, 0, 0, 0, 0, 0, 0, 232130, 0, 0, 0, 0, 0, 0, 0, 48317), -- 184168 (Scalesworn Guardian)
+(@NPCTEXTID+8, 1, 0, 0, 0, 0, 0, 0, 0, 231616, 0, 0, 0, 0, 0, 0, 0, 48317), -- 184168 (Scalesworn Guardian)
+(@NPCTEXTID+9, 1, 0, 0, 0, 0, 0, 0, 0, 217778, 0, 0, 0, 0, 0, 0, 0, 48317), -- 184168 (Scalesworn Guardian)
+(@NPCTEXTID+10, 1, 0, 0, 0, 0, 0, 0, 0, 232136, 0, 0, 0, 0, 0, 0, 0, 48317); -- 184168 (Scalesworn Guardian)
+
+DELETE FROM `gossip_menu` WHERE (`MenuID`=29977 AND `TextID`=@NPCTEXTID+0) OR (`MenuID`=29978 AND `TextID`=@NPCTEXTID+1) OR (`MenuID`=29979 AND `TextID`=@NPCTEXTID+2) OR (`MenuID`=29980 AND `TextID`=@NPCTEXTID+3) OR (`MenuID`=29981 AND `TextID`=@NPCTEXTID+4) OR (`MenuID`=29982 AND `TextID`=@NPCTEXTID+5) OR (`MenuID`=29891 AND `TextID`=@NPCTEXTID+6) OR (`MenuID`=29986 AND `TextID`=@NPCTEXTID+7) OR (`MenuID`=29894 AND `TextID`=@NPCTEXTID+8) OR (`MenuID`=27947 AND `TextID`=@NPCTEXTID+9) OR (`MenuID`=29976 AND `TextID`=@NPCTEXTID+10);
+INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES
+(29977, @NPCTEXTID+0, 48317), -- 184168 (Scalesworn Guardian)
+(29978, @NPCTEXTID+1, 48317), -- 184168 (Scalesworn Guardian)
+(29979, @NPCTEXTID+2, 48317), -- 184168 (Scalesworn Guardian)
+(29980, @NPCTEXTID+3, 48317), -- 184168 (Scalesworn Guardian)
+(29981, @NPCTEXTID+4, 48317), -- 184168 (Scalesworn Guardian)
+(29982, @NPCTEXTID+5, 48317), -- 184168 (Scalesworn Guardian)
+(29891, @NPCTEXTID+6, 48317), -- 184168 (Scalesworn Guardian)
+(29986, @NPCTEXTID+7, 48317), -- 184168 (Scalesworn Guardian)
+(29894, @NPCTEXTID+8, 48317), -- 184168 (Scalesworn Guardian)
+(27947, @NPCTEXTID+9, 48317), -- 184168 (Scalesworn Guardian)
+(29976, @NPCTEXTID+10, 48317); -- 184168 (Scalesworn Guardian)
+
+DELETE FROM `gossip_menu` WHERE (`MenuID`=29897 AND `TextID`=918) OR (`MenuID`=29893 AND `TextID`=3861);
+INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES
+(29897, 918, 48317), -- 184168 (Scalesworn Guardian)
+(29893, 3861, 48317); -- 184168 (Scalesworn Guardian)
+
+DELETE FROM `gossip_menu_option` WHERE (`MenuID`=29897 AND `OptionID` IN (3,1,4,10,2,8,7,9,11,0,6,12,5)) OR (`MenuID`=29893 AND `OptionID` IN (0,1,2)) OR (`MenuID`=27947 AND `OptionID` IN (6,14,0,1,12,5,11,2,8,10,4,9,3,7,13)) OR (`MenuID`=29977 AND `OptionID` IN (3,4,1,2,0)) OR (`MenuID`=29986 AND `OptionID` IN (0,2,4,1,3));
+INSERT INTO `gossip_menu_option` (`GossipOptionID`, `MenuID`, `OptionID`, `OptionNpc`, `OptionText`, `OptionBroadcastTextId`, `Language`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `SpellID`, `Flags`, `OverrideIconID`, `GossipNpcOptionID`, `VerifiedBuild`) VALUES
+(107230, 29897, 3, 0, 'Enchanting', 3006, 0, 29891, 7288, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317), -- OptionBroadcastTextID: 3006 - 3463 - 4862 - 5121 - 5363 - 5892 - 6621 - 6709 - 6779 - 6948 - 7027 - 7103 - 15257 - 19234 - 45755 - 52063
+(107215, 29893, 0, 0, 'Auction House', 5316, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317), -- OptionBroadcastTextID: 5316 - 5423 - 5515 - 5913 - 6369 - 15208 - 32174 - 44627
+(54812, 27947, 6, 0, 'Inn', 5513, 0, 29891, 7042, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317), -- OptionBroadcastTextID: 5513 - 5911 - 6396 - 6633 - 6910 - 15224 - 19202 - 32166 - 44629 - 200258
+(107232, 29897, 1, 0, 'Blacksmithing', 2942, 0, 29891, 7283, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317), -- OptionBroadcastTextID: 2942 - 3461 - 4860 - 5117 - 5890 - 6619 - 6707 - 6777 - 6946 - 7025 - 15255 - 19249 - 45754 - 51346
+(107229, 29897, 4, 0, 'Engineering', 2943, 0, 29891, 7292, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317), -- OptionBroadcastTextID: 2943 - 4976 - 5123 - 5893 - 6622 - 6780 - 6949 - 7028 - 15259 - 32143 - 45756 - 51347
+(107223, 29897, 10, 0, 'Mining', 2944, 0, 29891, 7291, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317), -- OptionBroadcastTextID: 2944 - 3468 - 4868 - 5138 - 5898 - 6627 - 6714 - 6785 - 6954 - 7033 - 15271 - 32147 - 45769 - 51348 - 78976 - 167854
+(107765, 27947, 14, 0, 'Item Upgrades', 0, 0, 29891, 7398, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317),
+(107231, 29897, 2, 0, 'Cooking', 2945, 0, 29891, 7284, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317), -- OptionBroadcastTextID: 2945 - 3462 - 4861 - 5119 - 5356 - 5891 - 6620 - 6708 - 6778 - 6947 - 7026 - 7100 - 16029 - 19233 - 45432 - 45763
+(107208, 27947, 0, 0, 'Auction House', 5316, 0, 29891, 7280, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317), -- OptionBroadcastTextID: 5316 - 5423 - 5515 - 5913 - 6369 - 15208 - 32174 - 44627
+(54815, 27947, 1, 0, 'Bank', 3426, 0, 29891, 7039, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317), -- OptionBroadcastTextID: 3426 - 5908 - 6631 - 6907 - 6987 - 15214 - 19201 - 32167 - 44628 - 78584 - 200249
+(107321, 29977, 3, 0, 'Green', 173217, 0, 29981, 7316, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317),
+(107214, 29893, 1, 0, 'Bank', 3426, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317), -- OptionBroadcastTextID: 3426 - 5908 - 6631 - 6907 - 6987 - 15214 - 19201 - 32167 - 44628 - 78584 - 200249
+(107347, 29986, 0, 0, 'The Seat of the Aspects', 0, 0, 29976, 7043, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317),
+(107345, 29986, 2, 0, 'Little Scales Whelp Daycare', 0, 0, 29891, 7317, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317),
+(54809, 27947, 12, 0, 'Stable Master', 8508, 0, 29891, 7044, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317), -- OptionBroadcastTextID: 8508 - 8511 - 8518 - 8524 - 8525 - 8529 - 8534 - 8536 - 8539 - 8542 - 15228 - 19208 - 45383 - 200263
+(54813, 27947, 5, 0, 'Flight Master', 2863, 0, 29891, 7041, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317), -- OptionBroadcastTextID: 2863 - 4889 - 6632 - 19203 - 45379 - 200256
+(107225, 29897, 8, 0, 'Jewelcrafting', 15267, 0, 29891, 7285, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317), -- OptionBroadcastTextID: 15267 - 18338 - 19235 - 44647 - 45758
+(107320, 29977, 4, 0, 'Red', 173221, 0, 29982, 7314, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317),
+(107226, 29897, 7, 0, 'Inscription', 31542, 0, 29891, 7287, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317), -- OptionBroadcastTextID: 31542 - 32146 - 45757 - 48811
+(107224, 29897, 9, 0, 'Leatherworking', 2947, 0, 29891, 7290, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317), -- OptionBroadcastTextID: 2947 - 3467 - 4866 - 5133 - 5371 - 5897 - 6626 - 6713 - 6784 - 6953 - 7032 - 7115 - 15269 - 19236 - 45759 - 52071
+(107766, 29986, 4, 0, 'Gladiator\'s Refuge', 0, 0, 29891, 7399, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317),
+(107346, 29986, 1, 0, 'Dragonflight Enclaves', 0, 0, 29977, 0, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317),
+(107323, 29977, 1, 0, 'Blue', 173218, 0, 29979, 7312, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317),
+(107460, 27947, 11, 0, 'Rostrum of Transformation', 0, 0, 29891, 7281, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317),
+(107222, 29897, 11, 0, 'Skinning', 2948, 0, 29891, 7290, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317), -- OptionBroadcastTextID: 2948 - 3471 - 4869 - 5140 - 5376 - 5899 - 6628 - 6716 - 6786 - 6955 - 7034 - 7118 - 15273 - 19237 - 45770 - 52076 - 106243
+(54814, 27947, 2, 0, 'Barber', 31340, 0, 29891, 7040, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317), -- OptionBroadcastTextID: 31340 - 45376
+(107322, 29977, 2, 0, 'Bronze', 0, 0, 29980, 7315, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317),
+(54810, 27947, 8, 0, 'Other Continents', 5914, 0, 29894, 7043, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317), -- OptionBroadcastTextID: 5914 - 47507 - 129194 - 129224 - 129235 - 129362 - 129389
+(54808, 27947, 10, 0, 'Profession Trainer', 2869, 0, 29897, 0, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317), -- OptionBroadcastTextID: 2869 - 3430 - 4896 - 5112 - 5352 - 5916 - 6635 - 6912 - 7022 - 7095 - 15250 - 19210 - 45382
+(107602, 27947, 4, 0, 'Crafting Orders', 0, 0, 29891, 7383, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317),
+(107344, 29986, 3, 0, 'Trade Market', 0, 0, 29891, 7318, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317),
+(107233, 29897, 0, 0, 'Alchemy', 2952, 0, 29891, 7282, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317), -- OptionBroadcastTextID: 2952 - 3460 - 4859 - 5114 - 5354 - 5362 - 5889 - 6618 - 6706 - 6776 - 6945 - 7024 - 7097 - 15252 - 19232 - 45753 - 52058
+(107227, 29897, 6, 0, 'Herbalism', 2950, 0, 29891, 7286, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317), -- OptionBroadcastTextID: 2950 - 3466 - 4865 - 5129 - 5130 - 5370 - 5896 - 6625 - 6712 - 6783 - 6952 - 7031 - 7112 - 15265 - 32145 - 45434 - 45768
+(54811, 27947, 9, 0, 'Points of Interest', 32180, 0, 29986, 0, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317), -- OptionBroadcastTextID: 32180 - 159628
+(107221, 29897, 12, 0, 'Tailoring', 2951, 0, 29891, 7289, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317), -- OptionBroadcastTextID: 2951 - 3469 - 4871 - 5144 - 5380 - 5900 - 6629 - 6717 - 6787 - 6956 - 7035 - 7121 - 15275 - 32148 - 45760 - 52077
+(107324, 29977, 0, 0, 'Black', 0, 0, 29978, 7313, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317),
+(107213, 29893, 2, 0, 'Inn', 5513, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317), -- OptionBroadcastTextID: 5513 - 5911 - 6396 - 6633 - 6910 - 15224 - 19202 - 32166 - 44629 - 200258
+(107207, 27947, 3, 0, 'Battle Pet Trainer', 67342, 0, 29891, 7279, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317),
+(107228, 29897, 5, 0, 'Fishing', 3005, 0, 29891, 7293, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317), -- OptionBroadcastTextID: 3005 - 3465 - 4864 - 5127 - 5368 - 5895 - 6624 - 6711 - 6782 - 6951 - 7030 - 7109 - 15263 - 32144 - 45436 - 45767 - 99684 - 173226
+(107216, 27947, 7, 0, 'Mailbox', 4895, 0, 29893, 0, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317), -- OptionBroadcastTextID: 4895 - 5093 - 5336 - 5514 - 5912 - 6397 - 15226 - 19204 - 45381 - 200260
+(54807, 27947, 13, 0, 'Transmogrifier', 160055, 0, 29891, 7045, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 48317);