[CODE]-- Gossip Menu insert from sniff
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);
– Creature Gossip_menu_id Update from sniff
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;
– Creature Gossip_menu_option Update from sniff
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);
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, ‘’);
– Gossip fix
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);
UPDATE creature_template SET gossip_menu_id=687 WHERE gossip_menu_id=21230;[/sql]
[/CODE]