Bat Handler Camille Gossip & Flight Fix

[eyerobot]

Her conditions were set so that her gossip only showed when a quest was taken, But quest 11229 has no objectives, So it skipped showing the gossip text. I reset it to condition quest complete 28, and her gossip option 0 now shows properly. Conditions for quest 11170 test at sea were missing, So I added them to make her gossip show up at the correct time.

-- 23816 Bat Handler Camille

DELETE FROM `smart_scripts` WHERE (`entryorguid`=23816 AND `source_type`=0);
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 
(23816, 0, 0, 2, 62, 0, 100, 0, 8894, 0, 0, 0, 85, 43074, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "Bat Handler Camille - On Gossip Option 0 Selected - Invoker Cast 'Taxi to the Windrunner'"),
(23816, 0, 1, 2, 62, 0, 100, 0, 8894, 1, 0, 0, 85, 43136, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "Bat Handler Camille - On Gossip Option 1 Selected - Invoker Cast 'Test at Sea Taxi'"),
(23816, 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, "Bat Handler Camille - On Gossip Option 1 Selected - Close Gossip");

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=8894;
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=8894 AND `SourceEntry`=0 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=28 AND `ConditionTarget`=0 AND `ConditionValue1`=11229 AND `ConditionValue2`=0 AND `ConditionValue3`=0;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES (15, 8894, 0, 0, 0, 28, 0, 11229, 0, 0, 0, 0, 0, '', 'Bathandler Camille - Show gossip option only if player has taken quest 11229');
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=8894 AND `SourceEntry`=1 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=9 AND `ConditionTarget`=0 AND `ConditionValue1`=11170 AND `ConditionValue2`=0 AND `ConditionValue3`=0;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES (15, 8894, 1, 0, 0, 9, 0, 11170, 0, 0, 0, 0, 0, '', 'Bathandler Camille - Show gossip option only if player has taken quest 11170');



DELETE FROM `gossip_menu_option` WHERE `menu_id`=8894 AND `id`=0;
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`, `OptionbroadCastTextId`, `BoxBroadcastTextId`) VALUES (8894, 0, 0, 'I need to fly to the Windrunner Official business!', 1, 1, 0, 0, 0, 0, '', NULL, NULL);
DELETE FROM `gossip_menu_option` WHERE `menu_id`=8894 AND `id`=1;
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`, `OptionbroadCastTextId`, `BoxBroadcastTextId`) VALUES (8894, 1, 0, 'I need a riding bat to intercept the Alliance reinforcements.', 1, 1, 0, 0, 0, 0, '', 22832, NULL);

 

[ExO]

Executed now, thanks!