TrinityCore/TrinityCore — Issue #4564: Missing Stormwind Gossip
Author: malcrom
Created: 2011-12-31 22:17:14+00:00
State: open
Labels: Database-Miscellaneous

```SQL

-- Gossip Menu insert from sniff
DELETE FROM `gossip_menu` WHERE `entry`=341 AND `text_id`=820;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (341,820);
DELETE FROM `gossip_menu` WHERE `entry`=1041 AND `text_id`=1123;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (1041,1123);
DELETE FROM `gossip_menu` WHERE `entry`=643 AND `text_id`=1203;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (643,1203);
DELETE FROM `gossip_menu` WHERE `entry`=645 AND `text_id`=1206;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (645,1206);
DELETE FROM `gossip_menu` WHERE `entry`=648 AND `text_id`=1208;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (648,1208);
DELETE FROM `gossip_menu` WHERE `entry`=657 AND `text_id`=1221;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (657,1221);
DELETE FROM `gossip_menu` WHERE `entry`=660 AND `text_id`=1226;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (660,1226);
DELETE FROM `gossip_menu` WHERE `entry`=682 AND `text_id`=1232;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (682,1232);
DELETE FROM `gossip_menu` WHERE `entry`=683 AND `text_id`=1233;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (683,1233);
DELETE FROM `gossip_menu` WHERE `entry`=692 AND `text_id`=1242;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (692,1242);
DELETE FROM `gossip_menu` WHERE `entry`=693 AND `text_id`=1243;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (693,1243);
DELETE FROM `gossip_menu` WHERE `entry`=698 AND `text_id`=1249;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (698,1249);
DELETE FROM `gossip_menu` WHERE `entry`=705 AND `text_id`=1257;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (705,1257);
DELETE FROM `gossip_menu` WHERE `entry`=706 AND `text_id`=1258;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (706,1258);
DELETE FROM `gossip_menu` WHERE `entry`=10392 AND `text_id`=1259;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (10392,1259);
DELETE FROM `gossip_menu` WHERE `entry`=708 AND `text_id`=1260;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (708,1260);
DELETE FROM `gossip_menu` WHERE `entry`=2943 AND `text_id`=3657;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (2943,3657);
DELETE FROM `gossip_menu` WHERE `entry`=4469 AND `text_id`=3977;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (4469,3977);
DELETE FROM `gossip_menu` WHERE `entry`=4470 AND `text_id`=3977;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (4470,3977);
DELETE FROM `gossip_menu` WHERE `entry`=4471 AND `text_id`=3977;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (4471,3977);
DELETE FROM `gossip_menu` WHERE `entry`=4466 AND `text_id`=4434;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (4466,4434);
DELETE FROM `gossip_menu` WHERE `entry`=4467 AND `text_id`=4434;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (4467,4434);
DELETE FROM `gossip_menu` WHERE `entry`=4468 AND `text_id`=4434;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (4468,4434);
DELETE FROM `gossip_menu` WHERE `entry`=12537 AND `text_id`=4437;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (12537,4437);
DELETE FROM `gossip_menu` WHERE `entry`=4508 AND `text_id`=4783;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (4508,4783);
DELETE FROM `gossip_menu` WHERE `entry`=4502 AND `text_id`=4837;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (4502,4837);
DELETE FROM `gossip_menu` WHERE `entry`=5061 AND `text_id`=4837;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (5061,4837);
DELETE FROM `gossip_menu` WHERE `entry`=4472 AND `text_id`=5000;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (4472,5000);
DELETE FROM `gossip_menu` WHERE `entry`=4473 AND `text_id`=5000;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (4473,5000);
DELETE FROM `gossip_menu` WHERE `entry`=4474 AND `text_id`=5000;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (4474,5000);
DELETE FROM `gossip_menu` WHERE `entry`=4201 AND `text_id`=5016;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (4201,5016);
DELETE FROM `gossip_menu` WHERE `entry`=4112 AND `text_id`=5019;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (4112,5019);
DELETE FROM `gossip_menu` WHERE `entry`=4139 AND `text_id`=5124;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (4139,5124);
DELETE FROM `gossip_menu` WHERE `entry`=4146 AND `text_id`=5147;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (4146,5147);
DELETE FROM `gossip_menu` WHERE `entry`=4161 AND `text_id`=5207;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (4161,5207);
DELETE FROM `gossip_menu` WHERE `entry`=4173 AND `text_id`=5260;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (4173,5260);
DELETE FROM `gossip_menu` WHERE `entry`=4203 AND `text_id`=5320;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (4203,5320);
DELETE FROM `gossip_menu` WHERE `entry`=4262 AND `text_id`=5416;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (4262,5416);
DELETE FROM `gossip_menu` WHERE `entry`=4344 AND `text_id`=5519;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (4344,5519);
DELETE FROM `gossip_menu` WHERE `entry`=4353 AND `text_id`=5561;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (4353,5561);
DELETE FROM `gossip_menu` WHERE `entry`=4482 AND `text_id`=5721;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (4482,5721);
DELETE FROM `gossip_menu` WHERE `entry`=4475 AND `text_id`=5721;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (4475,5721);
DELETE FROM `gossip_menu` WHERE `entry`=4481 AND `text_id`=5721;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (4481,5721);
DELETE FROM `gossip_menu` WHERE `entry`=4504 AND `text_id`=5722;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (4504,5722);
DELETE FROM `gossip_menu` WHERE `entry`=4505 AND `text_id`=5722;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (4505,5722);
DELETE FROM `gossip_menu` WHERE `entry`=4503 AND `text_id`=5722;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (4503,5722);
DELETE FROM `gossip_menu` WHERE `entry`=4941 AND `text_id`=5994;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (4941,5994);
DELETE FROM `gossip_menu` WHERE `entry`=5641 AND `text_id`=6755;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (5641,6755);
DELETE FROM `gossip_menu` WHERE `entry`=5849 AND `text_id`=7011;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (5849,7011);
DELETE FROM `gossip_menu` WHERE `entry`=8110 AND `text_id`=10040;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (8110,10040);
DELETE FROM `gossip_menu` WHERE `entry`=8631 AND `text_id`=10821;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (8631,10821);

-- Creature Gossip_menu_id Update from sniff
UPDATE `creature_template` SET `gossip_menu_id`=341 WHERE `entry`=3628;
UPDATE `creature_template` SET `gossip_menu_id`=581 WHERE `entry`=5511;
UPDATE `creature_template` SET `gossip_menu_id`=645 WHERE `entry`=5493;
UPDATE `creature_template` SET `gossip_menu_id`=648 WHERE `entry`=1292;
UPDATE `creature_template` SET `gossip_menu_id`=657 WHERE `entry`=2327;
UPDATE `creature_template` SET `gossip_menu_id`=660 WHERE `entry`=5513;
UPDATE `creature_template` SET `gossip_menu_id`=681 WHERE `entry`=1312;
UPDATE `creature_template` SET `gossip_menu_id`=681 WHERE `entry`=1315;
UPDATE `creature_template` SET `gossip_menu_id`=681 WHERE `entry`=1314;
UPDATE `creature_template` SET `gossip_menu_id`=681 WHERE `entry`=1307;
UPDATE `creature_template` SET `gossip_menu_id`=681 WHERE `entry`=1313;
UPDATE `creature_template` SET `gossip_menu_id`=681 WHERE `entry`=1309;
UPDATE `creature_template` SET `gossip_menu_id`=681 WHERE `entry`=1310;
UPDATE `creature_template` SET `gossip_menu_id`=682 WHERE `entry`=1304;
UPDATE `creature_template` SET `gossip_menu_id`=683 WHERE `entry`=5503;
UPDATE `creature_template` SET `gossip_menu_id`=684 WHERE `entry`=1347;
UPDATE `creature_template` SET `gossip_menu_id`=685 WHERE `entry`=5494;
UPDATE `creature_template` SET `gossip_menu_id`=687 WHERE `entry`=1298;
UPDATE `creature_template` SET `gossip_menu_id`=688 WHERE `entry`=1319;
UPDATE `creature_template` SET `gossip_menu_id`=688 WHERE `entry`=1323;
UPDATE `creature_template` SET `gossip_menu_id`=688 WHERE `entry`=1333;
UPDATE `creature_template` SET `gossip_menu_id`=689 WHERE `entry`=1341;
UPDATE `creature_template` SET `gossip_menu_id`=689 WHERE `entry`=1339;
UPDATE `creature_template` SET `gossip_menu_id`=690 WHERE `entry`=1324;
UPDATE `creature_template` SET `gossip_menu_id`=691 WHERE `entry`=1350;
UPDATE `creature_template` SET `gossip_menu_id`=691 WHERE `entry`=1349;
UPDATE `creature_template` SET `gossip_menu_id`=692 WHERE `entry`=1351;
UPDATE `creature_template` SET `gossip_menu_id`=693 WHERE `entry`=5510;
UPDATE `creature_template` SET `gossip_menu_id`=693 WHERE `entry`=5512;
UPDATE `creature_template` SET `gossip_menu_id`=693 WHERE `entry`=5509;
UPDATE `creature_template` SET `gossip_menu_id`=693 WHERE `entry`=5514;
UPDATE `creature_template` SET `gossip_menu_id`=698 WHERE `entry`=5519;
UPDATE `creature_template` SET `gossip_menu_id`=701 WHERE `entry`=1305;
UPDATE `creature_template` SET `gossip_menu_id`=703 WHERE `entry`=1303;
UPDATE `creature_template` SET `gossip_menu_id`=703 WHERE `entry`=1302;
UPDATE `creature_template` SET `gossip_menu_id`=705 WHERE `entry`=1326;
UPDATE `creature_template` SET `gossip_menu_id`=706 WHERE `entry`=1325;
UPDATE `creature_template` SET `gossip_menu_id`=708 WHERE `entry`=4974;
UPDATE `creature_template` SET `gossip_menu_id`=1041 WHERE `entry`=7232;
UPDATE `creature_template` SET `gossip_menu_id`=2745 WHERE `entry`=957;
UPDATE `creature_template` SET `gossip_menu_id`=2943 WHERE `entry`=10782;
UPDATE `creature_template` SET `gossip_menu_id`=4112 WHERE `entry`=5500;
UPDATE `creature_template` SET `gossip_menu_id`=4139 WHERE `entry`=11026;
UPDATE `creature_template` SET `gossip_menu_id`=4146 WHERE `entry`=5518;
UPDATE `creature_template` SET `gossip_menu_id`=4161 WHERE `entry`=1317;
UPDATE `creature_template` SET `gossip_menu_id`=4173 WHERE `entry`=11096;
UPDATE `creature_template` SET `gossip_menu_id`=4201 WHERE `entry`=5499;
UPDATE `creature_template` SET `gossip_menu_id`=4203 WHERE `entry`=5564;
UPDATE `creature_template` SET `gossip_menu_id`=4262 WHERE `entry`=1300;
UPDATE `creature_template` SET `gossip_menu_id`=4344 WHERE `entry`=5567;
UPDATE `creature_template` SET `gossip_menu_id`=4353 WHERE `entry`=1346;
UPDATE `creature_template` SET `gossip_menu_id`=4466 WHERE `entry`=376;
UPDATE `creature_template` SET `gossip_menu_id`=4467 WHERE `entry`=5489;
UPDATE `creature_template` SET `gossip_menu_id`=4468 WHERE `entry`=5484;
UPDATE `creature_template` SET `gossip_menu_id`=4469 WHERE `entry`=5491;
UPDATE `creature_template` SET `gossip_menu_id`=4470 WHERE `entry`=5492;
UPDATE `creature_template` SET `gossip_menu_id`=4471 WHERE `entry`=928;
UPDATE `creature_template` SET `gossip_menu_id`=4472 WHERE `entry`=5517;
UPDATE `creature_template` SET `gossip_menu_id`=4473 WHERE `entry`=5516;
UPDATE `creature_template` SET `gossip_menu_id`=4474 WHERE `entry`=5515;
UPDATE `creature_template` SET `gossip_menu_id`=4475 WHERE `entry`=914;
UPDATE `creature_template` SET `gossip_menu_id`=4481 WHERE `entry`=5480;
UPDATE `creature_template` SET `gossip_menu_id`=4482 WHERE `entry`=5479;
UPDATE `creature_template` SET `gossip_menu_id`=4502 WHERE `entry`=918;
UPDATE `creature_template` SET `gossip_menu_id`=4503 WHERE `entry`=461;
UPDATE `creature_template` SET `gossip_menu_id`=4504 WHERE `entry`=5496;
UPDATE `creature_template` SET `gossip_menu_id`=4505 WHERE `entry`=5495;
UPDATE `creature_template` SET `gossip_menu_id`=4508 WHERE `entry`=5504;
UPDATE `creature_template` SET `gossip_menu_id`=4783 WHERE `entry`=2879;
UPDATE `creature_template` SET `gossip_menu_id`=4941 WHERE `entry`=332;
UPDATE `creature_template` SET `gossip_menu_id`=5061 WHERE `entry`=13283;
UPDATE `creature_template` SET `gossip_menu_id`=5641 WHERE `entry`=6122;
UPDATE `creature_template` SET `gossip_menu_id`=5849 WHERE `entry`=14450;
UPDATE `creature_template` SET `gossip_menu_id`=8110 WHERE `entry`=20407;
UPDATE `creature_template` SET `gossip_menu_id`=8631 WHERE `entry`=23050;
UPDATE `creature_template` SET `gossip_menu_id`=9729 WHERE `entry`=28650;
UPDATE `creature_template` SET `gossip_menu_id`=9823 WHERE `entry`=29725;
UPDATE `creature_template` SET `gossip_menu_id`=10392 WHERE `entry`=5193;
UPDATE `creature_template` SET `gossip_menu_id`=10606 WHERE `entry`=34998;
UPDATE `creature_template` SET `gossip_menu_id`=10606 WHERE `entry`=34997;

-- Creature Gossip_menu_option Update from sniff
DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (341,581,645,648,657,660,682,683,684,687,688,689,690,692,693,698,701,702,703,705,706,4146,4161,4201,4203,4353,9823) AND `id` IN (0);
DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (9823) AND `id` IN (4);
INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`,`action_menu_id`,`action_poi_id`,`box_coded`,`box_money`,`box_text`) VALUES
(341,0,5, 'Make this inn your home.',8,65536,0,0,0,0, ''),
(581,0,3, 'Train me.',5,16,0,0,0,0, ''),
(645,0,3, 'Train me.',5,16,0,0,0,0, ''),
(648,0,3, 'Train me.',5,16,0,0,0,0, ''),
(657,0,3, 'Train me.',5,16,0,0,0,0, ''),
(660,0,3, 'Train me.',5,16,0,0,0,0, ''),
(682,0,1, 'I want to browse your goods.',3,128,0,0,0,0, ''),
(683,0,1, 'I want to browse your goods.',3,128,0,0,0,0, ''),
(684,0,1, 'I want to browse your goods.',3,128,0,0,0,0, ''),
(687,0,1, 'I want to browse your goods.',3,128,0,0,0,0, ''),
(688,0,1, 'I want to browse your goods.',3,128,0,0,0,0, ''),
(689,0,1, 'I want to browse your goods.',3,128,0,0,0,0, ''),
(690,0,1, 'I want to browse your goods.',3,128,0,0,0,0, ''),
(692,0,1, 'I want to browse your goods.',3,128,0,0,0,0, ''),
(693,0,1, 'I want to browse your goods.',3,128,0,0,0,0, ''),
(698,0,1, 'I want to browse your goods.',3,128,0,0,0,0, ''),
(701,0,1, 'I want to browse your goods.',3,128,0,0,0,0, ''),
(702,0,1, 'I want to browse your goods.',3,128,0,0,0,0, ''),
(703,0,1, 'I want to browse your goods.',3,128,0,0,0,0, ''),
(705,0,1, 'I want to browse your goods.',3,128,0,0,0,0, ''),
(706,0,1, 'I want to browse your goods.',3,128,0,0,0,0, ''),
(4146,0,3, 'Train me.',5,16,0,0,0,0, ''),
(4161,0,3, 'Train me.',5,16,0,0,0,0, ''),
(4201,0,3, 'Train me.',5,16,0,0,0,0, ''),
(4203,0,3, 'Train me.',5,16,0,0,0,0, ''),
(4353,0,3, 'Train me.',5,16,0,0,0,0, ''),
(9823,0,0, 'I''ve lost my key to Scholomance.',1,1,0,0,0,0, ''),
(9823,4,0, 'I''ve lost my Shadowforge Key.',1,1,0,0,0,0, '');

-- Insert npc_text from sniff
DELETE FROM `npc_text` WHERE `ID` IN (1123);
INSERT INTO `npc_text` (`ID`,`prob0`,`text0_0`,`text0_1`,`lang0`,`em0_0`,`em0_1`,`em0_2`,`em0_3`,`em0_4`,`em0_5`,`prob1`,`text1_0`,`text1_1`,`lang1`,`em1_0`,`em1_1`,`em1_2`,`em1_3`,`em1_4`,`em1_5`,`prob2`,`text2_0`,`text2_1`,`lang2`,`em2_0`,`em2_1`,`em2_2`,`em2_3`,`em2_4`,`em2_5`,`prob3`,`text3_0`,`text3_1`,`lang3`,`em3_0`,`em3_1`,`em3_2`,`em3_3`,`em3_4`,`em3_5`,`prob4`,`text4_0`,`text4_1`,`lang4`,`em4_0`,`em4_1`,`em4_2`,`em4_3`,`em4_4`,`em4_5`,`prob5`,`text5_0`,`text5_1`,`lang5`,`em5_0`,`em5_1`,`em5_2`,`em5_3`,`em5_4`,`em5_5`,`prob6`,`text6_0`,`text6_1`,`lang6`,`em6_0`,`em6_1`,`em6_2`,`em6_3`,`em6_4`,`em6_5`,`prob7`,`text7_0`,`text7_1`,`lang7`,`em7_0`,`em7_1`,`em7_2`,`em7_3`,`em7_4`,`em7_5`,`WDBVerified`) VALUES
(1123,100,'Can''t ye see I''m busy? This had better be good.','',7,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,1);
```