1. -- http://www.wowhead.com/quest=27388/heroes-of-darrowshire
  3. -- http://www.wowhead.com/item=13202
  4. 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
  5. ('11063', '0', '0', '1', '62', '0', '100', '0', '3864', '0', '0', '0', '56', '13202', '1', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', 'On Gossip Select - Give item Extended annals of Darrowshire');
  7. -- add creature smartAI
  8. UPDATE `world`.`creature_template` SET `AIName`='SmartAI' WHERE `entry`='11063';
  10. -- main gossip option
  11. 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
  12. ('3864', '0', '0', 'Carlin, do you have the extended annals of Darrowshire?', '0', '1', '1', '3865', '0', '0', '0', '', '0');
  14. -- secondary gossip option menu
  15. INSERT INTO `world`.`gossip_menu` (`entry`, `text_id`) VALUES ('3865', '0');
  17. -- Gossip option should only appears on quest
  18. INSERT INTO `world`.`conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  19. ('15', '3864', '0', '0', '0', '9', '0', '27388', '0', '0', '0', '0', '0', '0', '0');