1. -- add main gossip menu
  2. DELETE FROM `world`.`gossip_menu` WHERE `entry`='46245'; -- should be empty anyways
  3. INSERT INTO `world`.`gossip_menu` (`entry`, `text_id`) VALUES ('46245', '0');
  5. -- add gossip option
  6. DELETE FROM `world`.`gossip_menu_option` WHERE `entry`='menu_id'; -- should be empty anyways
  7. INSERT INTO `world`.`gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `OptionBroadcastTextID`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`, `BoxBroadcastTextID`) VALUES
  8. ('46245', '0', '0', 'Load me into that cannon, boy!', '0', '1', '1', '0', '0', '0', '0', '', '0');
  10. -- add goosip condition
  11. INSERT INTO `world`.`conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  12. ('15', '46245', '0', '0', '0', '9', '0', '27600', '0', '0', '0', '0', '0', '0', '0');
  14. -- add smartAI
  15. UPDATE `world`.`creature_template` SET `gossip_menu_id`='46245', `AIName`='SmartAI' WHERE `entry`='46245';
  16. DELETE FROM `world`.`smart_scripts` WHERE `entryorguid`='46245';
  17. INSERT INTO `world`.`smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  18. ('46245', '0', '0', '0', '62', '0', '100', '0', '46245', '0', '0', '0', '62', '0', '0', '0', '0', '0', '0', '7', '0', '0', '0', '-9991.34', '-4556.68', '17.14', '0.45', 'On Gossip Select - Teleport to destiny');