[CODE]-- Gossip Menu insert from sniff
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);
– Creature Gossip_menu_id Update from sniff
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;
– Creature Gossip_menu_option Update from sniff
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
(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, ‘’);[/sql]
[/CODE]