[CODE]-- Gossip Menu insert from sniff
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 from sniff
UPDATE creature_template SET gossip_menu_id=9550 WHERE entry=27495;
– Creature Gossip_menu_option Update from sniff
DELETE FROM gossip_menu_option WHERE menu_id IN (9550,9555) 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
(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, ‘’);[/sql]
[/CODE]