diff options
| -rw-r--r-- | sql/updates/world/2012_01_04_11_world_gossip_menu.sql | 223 |
1 files changed, 223 insertions, 0 deletions
diff --git a/sql/updates/world/2012_01_04_11_world_gossip_menu.sql b/sql/updates/world/2012_01_04_11_world_gossip_menu.sql new file mode 100644 index 00000000000..4356f9c7a0a --- /dev/null +++ b/sql/updates/world/2012_01_04_11_world_gossip_menu.sql @@ -0,0 +1,223 @@ +-- 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); |