24539 "Silvermoon" Harry -- 11464 Gambling Debt

[eyerobot]

This fixes Harry's script . And sets conditions so his gossip only shows up if your on the quest. And fixes his alternate gossip menu

-- 24539 "Silvermoon" Harry
-- 11464 Gambling Debt

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=9010 AND `SourceEntry`=0 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=9 AND `ConditionTarget`=0 AND `ConditionValue1`=11464 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, 9010, 0, 0, 0, 9, 0, 11464, 0, 0, 0, 0, 0, '', 'Silvermoon Harry - Show gossip option only if player has taken quest 11464');

DELETE FROM `gossip_menu_option` WHERE `menu_id`=9011 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 (9011, 0, 0, 'Pay up, Harry!', 1, 1, 0, 0, 0, 0, '', 23813, NULL);
DELETE FROM `gossip_menu_option` WHERE `menu_id`=9011 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 (9011, 1, 1, 'Do you sell any of this stuff?', 3, 128, 0, 0, 0, 0, '', 25731, NULL);


DELETE FROM `smart_scripts` WHERE (`entryorguid`=2453900 AND `source_type`=9);
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 
(2453900, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Silvermoon Hary (script 0) - Action 0 - Say line 1"),
(2453900, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 56, 34115, 1, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "Silvermoon Hary (script 0) - Action 1 - add questitem to player"),
(2453900, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 2, 1888, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Silvermoon Hary (script 0) - Action 2 - Change faction to friendly"),
(2453900, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 24, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Silvermoon Hary (script 0) - Action 3 - Evade (to stop attack)"),
(2453900, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Silvermoon Hary (script 0) - Action 4 - Set home position"),
(2453900, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Silvermoon Hary (script 0) - Action 5 - Set event phase 1"),
(2453900, 9, 6, 0, 0, 0, 100, 0, 0, 0, 0, 0, 41, 10000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Silvermoon Hary (script 0) - Action 6 - Despawn Self");

 

[ExO]

Executed to the newest Emucoach repack, VIP.

Thanks!