DB/Quest: fix quest "One Shot. One Kill."

Thanks tkrokli for the initial research.

1 files changed, 44 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2016_10_05_12_world_335.sql b/sql/updates/world/3.3.5/2016_10_05_12_world_335.sql
new file mode 100644
index 00000000000..6b2cd2799a3
--- /dev/null
+++ b/sql/updates/world/3.3.5/2016_10_05_12_world_335.sql
@@ -0,0 +1,44 @@
+--
+UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry` IN (11711, 1171100, 1171101);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (11711, 1171100, 1171101) AND `source_type` IN (0, 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
+(11711, 0, 0, 0, 0, 0, 100, 0, 0, 0, 2300, 3900, 11, 6660, 64, 0, 0, 0, 0, 19, 11713, 0, 0, 0, 0, 0, 0, "Sentinel Aynasha - In Combat - Cast Shoot"),
+(11711, 0, 1, 2, 19, 0, 100, 0, 5713, 0, 0, 0, 64, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "Sentinel Aynasha - On Quest 'One Shot. One Kill.' accepted - Store Targetlist"),
+(11711, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 80, 1171100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Sentinel Aynasha - On Quest 'One Shot. One Kill.' accepted - Run Actionlist"),
+(11711, 0, 3, 0, 38, 0, 100, 0, 1, 1, 0, 0, 80, 1171101, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Sentinel Aynasha - On Data 1 1 Set - Run Actionlist"),
+(11711, 0, 4, 0, 6, 0, 100, 0, 0, 0, 0, 0, 6, 5713, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, "Sentinel Aynasha - On Death - Fail quest 'One Shot. One Kill.'"),
+(1171100, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 20, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Sentinel Aynasha - On Script - Disable autoattack"),
+(1171100, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Sentinel Aynasha - On Script - Talk 0"),
+(1171100, 9, 2, 0, 0, 0, 100, 1, 1000, 1000, 0, 0, 12, 11713, 4, 20000, 0, 0, 0, 8,0, 0, 0, 4390.0791, -37.4953, 83.2510, 3.8278, "Sentinel Aynasha - On Script - Summon Blackwood Tracker"),
+(1171100, 9, 3, 0, 0, 0, 100, 1, 0, 0, 0, 0, 12, 11713, 4, 20000, 0, 0, 0, 8,0, 0, 0, 4390.0791, -37.4953, 83.2510, 3.8278, "Sentinel Aynasha - On Script - Summon Blackwood Tracker"),
+(1171100, 9, 4, 0, 0, 0, 100, 1, 40000, 40000, 0, 0, 12, 11713, 4, 20000, 0, 0, 0, 8,0, 0, 0, 4390.0791, -37.4953, 83.2510, 3.8278, "Sentinel Aynasha - On Script - Summon Blackwood Tracker"),
+(1171100, 9, 5, 0, 0, 0, 100, 1, 0, 0, 0, 0, 12, 11713, 4, 20000, 0, 0, 0, 8,0, 0, 0, 4390.0791, -37.4953, 83.2510, 3.8278, "Sentinel Aynasha - On Script - Summon Blackwood Tracker"),
+(1171100, 9, 6, 0, 0, 0, 100, 1, 0, 0, 0, 0, 12, 11713, 4, 20000, 0, 0, 0, 8,0, 0, 0, 4390.0791, -37.4953, 83.2510, 3.8278, "Sentinel Aynasha - On Script - Summon Blackwood Tracker"),
+(1171100, 9, 7, 0, 0, 0, 100, 1, 40000, 40000, 0, 0, 12, 11714, 4, 20000, 0, 0, 0, 8,0, 0, 0, 4390.0791, -37.4953, 83.2510, 3.8278, "Sentinel Aynasha - On Script - Summon Marosh the Devious"),
+(1171100, 9, 8, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Sentinel Aynasha - On Script - Talk 1"),
+(1171101, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 15, 5713, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, "Sentinel Aynasha - On Script - Complete quest 'One Shot. One Kill.'"),
+(1171101, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Sentinel Aynasha - On Script - Talk 2"),
+(1171101, 9, 2, 0, 0, 0, 100, 0, 7000, 7000, 0, 0, 1, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Sentinel Aynasha - On Script - Talk 3"),
+(1171101, 9, 3, 0, 0, 0, 100, 0, 7000, 7000, 0, 0, 1, 4, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Sentinel Aynasha - On Script - Talk 4"),
+(1171101, 9, 4, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Sentinel Aynasha - On Script - Despawn");
+
+UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry` IN (11713, 11714);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (11713, 11714);
+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
+(11713, 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 53, 1, 11713, 0, 0, 0, 2, 8, 0, 0, 0, 4388.3271, -64.87136, 86.7508, 0, "Blackwood Tracker - On Spawn - Start Waypoint"),
+(11714, 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 53, 1, 11713, 0, 0, 0, 2, 8, 0, 0, 0, 4388.3271, -64.87136, 86.7508, 0, "Marosh the Devious - On Spawn - Start Waypoint"),
+(11714, 0, 1, 0, 6, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 19, 11711, 0, 0, 0, 0, 0, 0, "Marosh the Devious - On Death - Set Data 1 1 on Sentinel Aynasha");
+
+DELETE FROM `creature_text` WHERE `entry` = 11711;
+INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextID`, `comment`) VALUES
+(11711, 0, 0, (SELECT `FemaleText` FROM `broadcast_text` WHERE `ID`=7200), 12, 0, 100, 0, 0, 0, 7200, "Sentinel Aynasha"),
+(11711, 1, 0, (SELECT `FemaleText` FROM `broadcast_text` WHERE `ID`=7199), 12, 0, 100, 0, 0, 0, 7199, "Sentinel Aynasha"),
+(11711, 2, 0, (SELECT `FemaleText` FROM `broadcast_text` WHERE `ID`=7201), 12, 0, 100, 0, 0, 0, 7201, "Sentinel Aynasha"),
+(11711, 3, 0, (SELECT `FemaleText` FROM `broadcast_text` WHERE `ID`=7202), 12, 0, 100, 0, 0, 0, 7202, "Sentinel Aynasha"),
+(11711, 4, 0, (SELECT `FemaleText` FROM `broadcast_text` WHERE `ID`=7328), 12, 0, 100, 0, 0, 0, 7328, "Sentinel Aynasha");
+
+DELETE FROM `waypoints` WHERE `entry`=11713;
+INSERT INTO `waypoints` (entry, pointid, position_x, position_y, position_z, point_comment) VALUES
+(11713, 1, 4378.2861, -41.5416, 79.7871, "Blackwood Tracker and Marosh the Devious"),
+(11713, 2, 4373.4531, -48.2829, 85.4378, "Blackwood Tracker and Marosh the Devious"),
+(11713, 3, 4381.4375, -56.9109, 86.7869, "Blackwood Tracker and Marosh the Devious");