SET @ENTRY:= 27359;

UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;
UPDATE `creature_template` SET `gossip_menu_id`=@ENTRY WHERE  `entry`=@ENTRY;
UPDATE `creature_template` SET `npcflag`=1 WHERE  `entry`=@ENTRY;

DELETE FROM `npc_text` WHERE `ID`=@ENTRY;
INSERT INTO `npc_text` (`ID`, `text0_0`, `text0_1`, `lang0`, `prob0`, `em0_0`, `em0_1`, `em0_2`, `em0_3`, `em0_4`, `em0_5`, `text1_0`, `text1_1`, `lang1`, `prob1`, `em1_0`, `em1_1`, `em1_2`, `em1_3`, `em1_4`, `em1_5`, `text2_0`, `text2_1`, `lang2`, `prob2`, `em2_0`, `em2_1`, `em2_2`, `em2_3`, `em2_4`, `em2_5`, `text3_0`, `text3_1`, `lang3`, `prob3`, `em3_0`, `em3_1`, `em3_2`, `em3_3`, `em3_4`, `em3_5`, `text4_0`, `text4_1`, `lang4`, `prob4`, `em4_0`, `em4_1`, `em4_2`, `em4_3`, `em4_4`, `em4_5`, `text5_0`, `text5_1`, `lang5`, `prob5`, `em5_0`, `em5_1`, `em5_2`, `em5_3`, `em5_4`, `em5_5`, `text6_0`, `text6_1`, `lang6`, `prob6`, `em6_0`, `em6_1`, `em6_2`, `em6_3`, `em6_4`, `em6_5`, `text7_0`, `text7_1`, `lang7`, `prob7`, `em7_0`, `em7_1`, `em7_2`, `em7_3`, `em7_4`, `em7_5`, `WDBVerified`) VALUES
(@ENTRY, 'Im am trapped here..Please help me', NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 1);

DELETE FROM `gossip_menu_option` WHERE `menu_id`=@ENTRY;
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`) VALUES
(@ENTRY, 0, 0, 'Please help me to get out of here!', 1, 1, 0, 0, 0, 0, NULL);

DELETE FROM `gossip_menu` WHERE `entry`=@ENTRY;
INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES
(@ENTRY, @ENTRY);

DELETE FROM `smart_scripts` WHERE  `entryorguid`=@ENTRY;
INSERT INTO `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
(@ENTRY, 0, 0, 0, 62, 0, 100, 0, @ENTRY, 0, 0, 0, 33, 27359, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'on gossip select - give credit'),
(@ENTRY, 0, 1, 0, 62, 0, 100, 0, @ENTRY, 0, 0, 0, 41, 1000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'on gossip select - force despawn');

DELETE FROM `conditions` WHERE `SourceGroup`=@ENTRY;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`,  `SourceGroup`,  `SourceEntry`,  `SourceId`,  `ElseGroup`,  `ConditionTypeOrReference`,  `ConditionTarget`,  `ConditionValue1`,  `ConditionValue2`,  `ConditionValue3`,  `NegativeCondition`,  `ErrorTextId`,  `ScriptName`,  `Comment`) VALUES
(15, @ENTRY, 0, 0, 0, 9, 0, 12253, 0, 0, 0, 0, '', 'show gossip if player has quest');