Quest Heroes of Old (2702)

/*Quest Heroes of Old (2702) - Fix by Stil */

DELETE FROM `conditions` WHERE `SourceGroup`='840';
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
('14','840','1391','0','0','8','0','2784','0','0','0','0','0','','Show gossip text if player has quest 2801 or 2784 completed'),
('14','840','1391','0','1','8','0','2801','0','0','0','0','0','','Show gossip text if player has quest 2801 or 2784 completed'),
('15','840','0','0','0','9','0','2784','0','0','0','0','0','','Show gossip option if player has quest 2784 but not complete'),
('15','840','1','0','0','9','0','2801','0','0','0','0','0','','Show gossip option if player has quest 2801 but not complete'),
('15','840','2','0','0','28','0','2702','0','0','0','0','0','','Show gossip option if player has quest 2702 completed');

DELETE FROM `gossip_menu_option` WHERE `menu_id`='840';
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
('840','0','0','Please continue, Hero...','1','1','880','0','0','0',''),
('840','1','0','Please continue, Hero...','1','1','880','0','0','0',''),
('840','2','0','Hero, I have urgent business with Corporal Splithoof.','1','3','0','0','0','0','');

DELETE FROM `smart_scripts` WHERE `entryorguid`='7750';
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
('7750','0','0','0','19','0','100','0','2701','0','0','0','41','1','0','0','0','0','0','1','0','0','0','0','0','0','0','Corporal Thund Splithoof - On Quest Accept - Forced Despawn'),
('7750','0','1','2','19','0','100','0','2701','0','0','0','70','0','0','0','0','0','0','14','44733','141980','0','0','0','0','0','Corporal Thund Splithoof - On Quest Accept - Respawn Spectral Lockbox (GO)'),
('7750','0','2','0','61','0','100','0','0','0','0','0','70','0','0','0','0','0','0','14','44732','141981','0','0','0','0','0','Corporal Thund Splithoof - On Quest Accept - Respawn Spectral Lockbox Particles (GO)');

DELETE FROM `smart_scripts` WHERE `entryorguid`='7572';
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
('7572','0','0','1','62','0','100','0','881','0','0','0','26','2784','0','0','0','0','0','7','0','0','0','0','0','0','0','Fallen Hero of the Horde - On Gossip Option 0 Selected - Quest Credit \'Fall From Grace\''),
('7572','0','1','2','61','0','100','0','0','0','0','0','26','2801','0','0','0','0','0','7','0','0','0','0','0','0','0','Fallen Hero of the Horde - On Gossip Option 0 Selected - Quest Credit \'A Tale of Sorrow\''),
('7572','0','2','0','61','0','100','0','0','0','0','0','72','0','0','0','0','0','0','7','0','0','0','0','0','0','0','Fallen Hero of the Horde - On Gossip Option 0 Selected - Close Gossip'),
('7572','0','3','4','62','0','100','0','840','2','0','0','11','11024','0','0','0','0','0','1','0','0','0','0','0','0','0','Fallen Hero of the Horde - On Gossip Option 2 Selected - Cast \'Call of Thund\''),
('7572','0','4','0','61','0','100','0','0','0','0','0','72','0','0','0','0','0','0','7','0','0','0','0','0','0','0','Fallen Hero of the Horde - On Gossip Option 2 Selected - Close Gossip');

DELETE FROM `creature_questender` WHERE `quest`='2701';
DELETE FROM `gameobject_questender` WHERE quest='2701';
INSERT INTO `gameobject_questender` (`id`,`quest`) VALUE ('141980','2701');