-- Gossip Menu insert
DELETE FROM `gossip_menu` WHERE `entry`=7303 AND `text_id`=8662;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7303,8662);
DELETE FROM `gossip_menu` WHERE `entry`=7380 AND `text_id`=8835;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7380,8835);
DELETE FROM `gossip_menu` WHERE `entry`=7424 AND `text_id`=8973;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7424,8973);
DELETE FROM `gossip_menu` WHERE `entry`=7423 AND `text_id`=8972;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7423,8972);
DELETE FROM `gossip_menu` WHERE `entry`=7425 AND `text_id`=8974;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7425,8974);
DELETE FROM `gossip_menu` WHERE `entry`=11910 AND `text_id`=16726;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (11910,16726);
DELETE FROM `gossip_menu` WHERE `entry`=5729 AND `text_id`=6896;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (5729,6896);
DELETE FROM `gossip_menu` WHERE `entry`=5728 AND `text_id`=6897;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (5728,6897);
DELETE FROM `gossip_menu` WHERE `entry`=5727 AND `text_id`=6898;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (5727,6898);
DELETE FROM `gossip_menu` WHERE `entry`=5726 AND `text_id`=6899;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (5726,6899);
DELETE FROM `gossip_menu` WHERE `entry`=5725 AND `text_id`=6900;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (5725,6900);
DELETE FROM `gossip_menu` WHERE `entry`=5724 AND `text_id`=6901;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (5724,6901);
DELETE FROM `gossip_menu` WHERE `entry`=5723 AND `text_id`=6902;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (5723,6902);
DELETE FROM `gossip_menu` WHERE `entry`=5737 AND `text_id`=6911;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (5737,6911);
DELETE FROM `gossip_menu` WHERE `entry`=7084 AND `text_id`=8336;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7084,8336);
DELETE FROM `gossip_menu` WHERE `entry`=5748 AND `text_id`=6927;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (5748,6927);
DELETE FROM `gossip_menu` WHERE `entry`=5756 AND `text_id`=6940;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (5756,6940);
DELETE FROM `gossip_menu` WHERE `entry`=5743 AND `text_id`=6919;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (5743,6919);
DELETE FROM `gossip_menu` WHERE `entry`=5747 AND `text_id`=6925;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (5747,6925);
DELETE FROM `gossip_menu` WHERE `entry`=5755 AND `text_id`=6939;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (5755,6939);
DELETE FROM `gossip_menu` WHERE `entry`=10026 AND `text_id`=13902;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (10026,13902);
DELETE FROM `gossip_menu` WHERE `entry`=9750 AND `text_id`=13375;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (9750,13375);
DELETE FROM `gossip_menu` WHERE `entry`=7522 AND `text_id`=9122;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (7522,9122);
DELETE FROM `gossip_menu` WHERE `entry`=9162 AND `text_id`=12756;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (9162,12756);
DELETE FROM `gossip_menu` WHERE `entry`=9162 AND `text_id`=12417;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (9162,12417);
DELETE FROM `gossip_menu` WHERE `entry`=9164 AND `text_id`=12422;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (9164,12422);
DELETE FROM `gossip_menu` WHERE `entry`=9166 AND `text_id`=12424;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (9166,12424);
DELETE FROM `gossip_menu` WHERE `entry`=9167 AND `text_id`=12426;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (9167,12426);
DELETE FROM `gossip_menu` WHERE `entry`=9144 AND `text_id`=12373;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (9144,12373);
DELETE FROM `gossip_menu` WHERE `entry`=9164 AND `text_id`=12422;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (9164,12422);
DELETE FROM `gossip_menu` WHERE `entry`=9166 AND `text_id`=12424;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (9166,12424);
DELETE FROM `gossip_menu` WHERE `entry`=21230 AND `text_id`=1237;
DELETE FROM `gossip_menu` WHERE `entry`=687 AND `text_id`=1237;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (687,1237);
DELETE FROM `gossip_menu` WHERE `entry`=689 AND `text_id`=1239;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (689,1239);
DELETE FROM `gossip_menu` WHERE `entry`=690 AND `text_id`=1240;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (690,1240);
DELETE FROM `gossip_menu` WHERE `entry`=701 AND `text_id`=1253;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (701,1253);
DELETE FROM `gossip_menu` WHERE `entry`=703 AND `text_id`=1255;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (703,1255);
DELETE FROM `gossip_menu` WHERE `entry`=10990 AND `text_id`=15282;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (10990,15282);
DELETE FROM `gossip_menu` WHERE `entry`=10929 AND `text_id`=15188;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (10929,15188);
DELETE FROM `gossip_menu` WHERE `entry`=10945 AND `text_id`=15209;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (10945,15209);
DELETE FROM `gossip_menu` WHERE `entry`=10946 AND `text_id`=15210;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (10946,15210);
DELETE FROM `gossip_menu` WHERE `entry`=10947 AND `text_id`=15211;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (10947,15211);
DELETE FROM `gossip_menu` WHERE `entry`=9554 AND `text_id`=12869;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (9554,12869);
DELETE FROM `gossip_menu` WHERE `entry`=10400 AND `text_id`=14455;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (10400,14455);
DELETE FROM `gossip_menu` WHERE `entry`=10340 AND `text_id`=14408;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (10340,14408);
DELETE FROM `gossip_menu` WHERE `entry`=10440 AND `text_id`=14476;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (10440,14476);
DELETE FROM `gossip_menu` WHERE `entry`=9550 AND `text_id`=12865;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (9550,12865);
DELETE FROM `gossip_menu` WHERE `entry`=9555 AND `text_id`=12868;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (9555,12868);
DELETE FROM `gossip_menu` WHERE `entry`=9557 AND `text_id`=12871;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (9557,12871);

-- Creature Gossip_menu_id Update
UPDATE `creature_template` SET `gossip_menu_id`=7303 WHERE `entry`=16554;
UPDATE `creature_template` SET `gossip_menu_id`=5729 WHERE `entry`=14358;
UPDATE `creature_template` SET `gossip_menu_id`=5737 WHERE `entry`=14369;
UPDATE `creature_template` SET `gossip_menu_id`=7084 WHERE `entry`=16032;
UPDATE `creature_template` SET `gossip_menu_id`=5748 WHERE `entry`=14383;
UPDATE `creature_template` SET `gossip_menu_id`=5756 WHERE `entry`=14382;
UPDATE `creature_template` SET `gossip_menu_id`=5747 WHERE `entry`=14368;
UPDATE `creature_template` SET `gossip_menu_id`=5755 WHERE `entry`=14381;
UPDATE `creature_template` SET `gossip_menu_id`=10026 WHERE `entry`=31085;
UPDATE `creature_template` SET `gossip_menu_id`=9740 WHERE `entry`=28082;
UPDATE `creature_template` SET `gossip_menu_id`=9741 WHERE `entry`=28138;
UPDATE `creature_template` SET `gossip_menu_id`=9162 WHERE `entry`=25459;
UPDATE `creature_template` SET `gossip_menu_id`=9164 WHERE `entry`=25475;
UPDATE `creature_template` SET `gossip_menu_id`=9166 WHERE `entry`=25476;
UPDATE `creature_template` SET `gossip_menu_id`=9167 WHERE `entry`=25503;
UPDATE `creature_template` SET `gossip_menu_id`=9144 WHERE `entry`=25237;
UPDATE `creature_template` SET `gossip_menu_id`=9164 WHERE `entry`=25475;
UPDATE `creature_template` SET `gossip_menu_id`=9166 WHERE `entry`=25476;
UPDATE `creature_template` SET `gossip_menu_id`=10990 WHERE `entry`=37671;
UPDATE `creature_template` SET `gossip_menu_id`=10929 WHERE `entry`=37715;
UPDATE `creature_template` SET `gossip_menu_id`=9549 WHERE `entry`=27810;
UPDATE `creature_template` SET `gossip_menu_id`=10948 WHERE `entry`=37887;
UPDATE `creature_template` SET `gossip_menu_id`=10948 WHERE `entry`=38041;
UPDATE `creature_template` SET `gossip_menu_id`=10948 WHERE `entry`=38040;
UPDATE `creature_template` SET `gossip_menu_id`=10948 WHERE `entry`=38039;
UPDATE `creature_template` SET `gossip_menu_id`=10470 WHERE `entry`=33382;
UPDATE `creature_template` SET `gossip_menu_id`=10400 WHERE `entry`=33972;
UPDATE `creature_template` SET `gossip_menu_id`=10340 WHERE `entry`=33447;
UPDATE `creature_template` SET `gossip_menu_id`=9550 WHERE `entry`=27495;

UPDATE `creature_template` SET `gossip_menu_id`=687 WHERE `gossip_menu_id`=21230;

-- Creature Gossip_menu_option Update
DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (7368) AND `id` IN (1,2);
DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (7370,5729,5728,5727,5726,5725,5724,5723,7522,9162) AND `id` IN (0);
DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (9550,9555) AND `id` IN (0);
DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (10340) AND `id` IN (1);
DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (10976,10929,10945,10946) AND `id` IN (0);
INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`,`action_menu_id`,`action_poi_id`,`action_script_id`,`box_coded`,`box_money`,`box_text`) VALUES
(7368,1,0, 'Acteon, where is the best area to hunt for moongraze stags?',1,1,7423,0,0,0,0, ''),
(7368,2,0, 'Acteon, where is the best place to hunt moongraze bucks?',1,1,7424,0,0,0,0, ''),
(7370,0,0, 'Where can I find more infected nightstalker runts, Exarch?',1,1,7425,0,0,0,0, ''),
(5729,0,0, 'What happened here, spirit?',1,1,5728,0,0,0,0, ''),
(5728,0,0, 'I know very little of the Highborne and nothing of the Shen''dralar.',1,1,5727,0,0,0,0, ''),
(5727,0,0, 'Continue, please.',1,1,5726,0,0,0,0, ''),
(5726,0,0, 'Fascinating. Continue, please.',1,1,5725,0,0,0,0, ''),
(5725,0,0, 'I''m going to have to kill something, aren''t I?',1,1,5724,0,0,0,0, ''),
(5724,0,0, 'We live in a world of endless tragedy.',1,1,5723,0,0,0,0, ''),
(5723,0,0, 'A very sad tale. Thank you, spirit.',1,1,0,0,0,0,0, ''),
(7522,0,3, 'Teach me the ways of the spirits.',5,16,0,0,0,0,0, ''),
(9162,0,0, 'Send me to Garrosh''s Landing, Yanni.',1,1,0,0,0,0,0, ''),
(10976,0,0, 'I need another disguise.',1,1,0,0,0,0,0, ''),
(10929,0,0, 'I have a rocket here with your mark on it, Snivel.',1,1,10945,0,0,0,0, ''),
(10945,0,0, 'There''s a chemical inside the rocket. What is it?',1,1,10946,0,0,0,0, ''),
(10946,0,0, 'Where were they delivered?',1,1,10947,0,0,0,0, ''),
(9550,0,0, 'Why would I want to ride a shredder?',1,1,9555,0,0,0,0, ''),
(9555,0,0, 'Where can I get a Refurbished Shredder Key?',1,1,9557,0,0,0,0, ''),
(10340,1,0, 'How do the Argent Crusade riders fight?',1,1,10440,0,0,0,0, '');

DELETE FROM `npc_text` WHERE `ID` IN (16540,8336,16726) AND `WDBVerified`=-1;
INSERT INTO `npc_text` (`ID`,`text0_0`,`WDBVerified`) VALUES
(16540, '[PH]', -1),
(8336, '[PH]', -1),
(16726, '[PH]', -1);
