DB/Quest: Add support for 'Bodyguard for Hire' & 'Gizelton Caravan'

Closes #1657 Closes #3260

Info for some parts taken from https://github.com/TrinityCore/TrinityCore/pull/20116 https://github.com/classicdb/database/pull/686 https://github.com/classicdb/database/commit/baff23f7cc4eab3348fdadf50c793435eaf93d81

1 files changed, 493 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2020_08_21_03_world_335.sql b/sql/updates/world/3.3.5/2020_08_21_03_world_335.sql
new file mode 100644
index 00000000000..3b68f6745fe
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_08_21_03_world_335.sql
@@ -0,0 +1,493 @@
+-- NYI spells 19770 Apply Area Aura - Party: Dummy, 19768
+-- Despawn if player abbandoned quest is not implemented (works with all escorts?) https://www.wowhead.com/npc=12245/vendor-tron-1000#comments:id=632118
+-- They respawns in wrong place https://www.wowhead.com/npc=12245/vendor-tron-1000#comments:id=632118
+-- Path was probably sniffed but some points are incorrect
+-- Despawn if player was killed or one of caravan's member was killed(requires research) is not implemented
+
+-- Cork Gizelton SAI
+SET @ID := 11625;
+UPDATE `creature_template` SET `AIName` = "SmartAI" WHERE `entry` = @ID;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = @ID AND `source_type` = 0;
+DELETE FROM `smart_scripts` WHERE `entryorguid` BETWEEN @ID*100+0 AND @ID*100+12 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
+(@ID,0,0,1,11,0,100,0,0,0,0,0,0,53,1,11625,1,0,0,2,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Respawn - Start Waypoint"),
+(@ID,0,1,2,61,0,100,0,0,0,0,0,0,83,3,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Link - Remove NPC Flags Gossip & Questgiver"),
+(@ID,0,2,0,61,0,100,0,0,0,0,0,0,83,3,0,0,0,0,0,19,11626,0,0,0,0,0,0,0,"Cork Gizelton - On Link - Remove NPC Flags Gossip & Questgiver (Rigger Gizelton)"),
+-- Player accepted Rigger's quest
+(@ID,0,3,4,38,0,100,0,0,1,0,0,0,65,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Data Set 0 1 - Resume Waypoint"),
+(@ID,0,4,5,61,0,100,0,0,0,0,0,0,59,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Link - Set Run Off"),
+(@ID,0,5,0,61,0,100,0,0,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Link - Set Event Phase 1"),
+
+(@ID,0,6,0,40,0,100,0,52,0,0,0,0,80,@ID*100+0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Waypoint 52 Reached - Run Script"),
+(@ID,0,7,0,40,0,100,0,76,0,0,0,0,80,@ID*100+1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Waypoint 76 Reached - Run Script"),
+(@ID,0,8,0,40,1,100,0,84,0,0,0,0,80,@ID*100+2,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Waypoint 84 Reached - Run Script (Phase 1)"),
+(@ID,0,9,0,40,1,100,0,92,0,0,0,0,80,@ID*100+3,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Waypoint 92 Reached - Run Script (Phase 1)"),
+(@ID,0,10,0,40,1,100,0,100,0,0,0,0,80,@ID*100+4,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Waypoint 100 Reached - Run Script (Phase 1)"),
+(@ID,0,11,0,40,1,100,0,107,0,0,0,0,80,@ID*100+5,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Waypoint 107 Reached - Run Script (Phase 1)"),
+(@ID,0,12,0,40,0,100,0,193,0,0,0,0,80,@ID*100+6,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Waypoint 193 Reached - Run Script"),
+(@ID,0,13,0,40,0,100,0,209,0,0,0,0,80,@ID*100+7,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Waypoint 209 Reached - Run Script"),
+(@ID,0,14,0,40,1,100,0,215,0,0,0,0,80,@ID*100+8,0,1,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Waypoint 215 Reached - Run Script (Phase 1)"),
+(@ID,0,15,0,40,1,100,0,223,0,0,0,0,80,@ID*100+9,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Waypoint 223 Reached - Run Script (Phase 1)"),
+(@ID,0,16,0,40,1,100,0,233,0,0,0,0,80,@ID*100+10,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Waypoint 233 Reached - Run Script (Phase 1)"),
+(@ID,0,17,0,40,1,100,0,240,0,0,0,0,80,@ID*100+11,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Waypoint 240 Reached - Run Script (Phase 1)"),
+
+(@ID,0,18,0,19,0,100,0,5821,0,0,0,0,80,@ID*100+12,0,1,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Quest 'Bodyguard for Hire' Taken - Run Script"),
+(@ID,0,19,20,6,0,100,0,0,0,0,0,0,6,5821,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"Cork Gizelton - On Death - Fail Quest 'Bodyguard for Hire'"),
+(@ID,0,20,21,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,19,11626,0,0,0,0,0,0,0,"Cork Gizelton - On Link - Despawn Instant (Rigger Gizelton)"),
+(@ID,0,21,22,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,11,11564,100,0,0,0,0,0,0,"Cork Gizelton - On Link - Despawn Instant (Gizelton Caravan Kodo)"),
+(@ID,0,22,0,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Link - Despawn Instant"),
+
+-- Vendor-Tron 1000
+(@ID*100+0,9,0,0,0,0,100,0,0,0,0,0,0,54,600000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Pause Waypoint"),
+(@ID*100+0,9,1,0,0,0,100,0,0,0,0,0,0,107,6,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Summon Group 6"),
+(@ID*100+0,9,2,0,0,0,100,0,0,0,0,0,0,82,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Add NPC Flag Gossip"),
+(@ID*100+0,9,3,0,0,0,100,0,600000,600000,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Say Line 0"),
+(@ID*100+0,9,4,0,0,0,100,0,0,0,0,0,0,83,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Remove NPC Flag Gossip"),
+-- Propose Bodyguard for Hire
+(@ID*100+1,9,0,0,0,0,100,0,0,0,0,0,0,54,300000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Pause Waypoint"),
+(@ID*100+1,9,1,0,0,0,100,0,0,0,0,0,0,82,2,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Add NPC Flag Questgiver"),
+(@ID*100+1,9,2,0,0,0,100,0,0,0,0,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Say Line 1"),
+(@ID*100+1,9,3,0,0,0,100,0,300000,300000,0,0,0,83,2,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Remove NPC Flag Questgiver"),
+-- Kolkar ambush 1 https://youtu.be/9TLf3OF9gLM?t=69
+(@ID*100+2,9,0,0,0,0,100,0,0,0,0,0,0,54,3000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Pause Waypoint"),
+(@ID*100+2,9,1,0,0,0,100,0,3000,3000,0,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Say Line 2"),
+(@ID*100+2,9,2,0,0,0,100,0,2000,2000,0,0,0,107,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Summon Group 0"),
+-- Kolkar ambush 2 https://youtu.be/9TLf3OF9gLM?t=185
+(@ID*100+3,9,0,0,0,0,100,0,0,0,0,0,0,54,3000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Pause Waypoint"),
+(@ID*100+3,9,1,0,0,0,100,0,3000,3000,0,0,0,1,3,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Say Line 3"),
+(@ID*100+3,9,2,0,0,0,100,0,2000,2000,0,0,0,107,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Summon Group 1"),
+-- Kolkar ambush 3 https://youtu.be/9TLf3OF9gLM?t=327
+(@ID*100+4,9,0,0,0,0,100,0,0,0,0,0,0,54,3000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Pause Waypoint"),
+(@ID*100+4,9,1,0,0,0,100,0,3000,3000,0,0,0,1,4,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Say Line 4"),
+(@ID*100+4,9,2,0,0,0,100,0,2000,2000,0,0,0,107,2,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Summon Group 2"),
+-- Complete https://youtu.be/9TLf3OF9gLM?t=449
+(@ID*100+5,9,0,0,0,0,100,0,0,0,0,0,0,54,7000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Pause Waypoint"),
+(@ID*100+5,9,1,0,0,0,100,0,0,0,0,0,0,1,5,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Say Line 5"),
+(@ID*100+5,9,2,0,0,0,100,0,0,0,0,0,0,2,35,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Faction 35"),
+(@ID*100+5,9,3,0,0,0,100,0,0,0,0,0,0,2,35,0,0,0,0,0,19,11626,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Faction 35 (Rigger Gizelton)"),
+(@ID*100+5,9,4,0,0,0,100,0,0,0,0,0,0,2,35,0,0,0,0,0,11,11564,40,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Faction 35 (Gizelton Caravan Kodo)"),
+(@ID*100+5,9,5,0,0,0,100,0,0,0,0,0,0,18,512,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Flag Immune To NPC's"),
+(@ID*100+5,9,6,0,0,0,100,0,0,0,0,0,0,18,512,0,0,0,0,0,19,11626,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Flag Immune To NPC's (Rigger Gizelton)"),
+(@ID*100+5,9,7,0,0,0,100,0,0,0,0,0,0,18,512,0,0,0,0,0,11,11564,40,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Flag Immune To NPC's (Gizelton Caravan Kodo)"),
+(@ID*100+5,9,8,0,0,0,100,0,0,0,0,0,0,59,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Run On"),
+(@ID*100+5,9,9,0,0,0,100,0,0,0,0,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Event Phase 0"),
+(@ID*100+5,9,10,0,0,0,100,0,7000,7000,0,0,0,15,5821,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Quest Credit 'Bodyguard for Hire'"),
+-- Super-Seller 680
+(@ID*100+6,9,0,0,0,0,100,0,0,0,0,0,0,54,600000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Pause Waypoint"),
+(@ID*100+6,9,1,0,0,0,100,0,0,0,0,0,0,107,7,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Summon Group 7"),
+(@ID*100+6,9,2,0,0,0,100,0,0,0,0,0,0,82,1,0,0,0,0,0,19,11626,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Add NPC Flag Gossip (Rigger Gizelton)"),
+(@ID*100+6,9,3,0,0,0,100,0,600000,600000,0,0,0,1,0,0,0,0,0,0,19,11626,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Say Line 0 (Rigger Gizelton)"),
+(@ID*100+6,9,4,0,0,0,100,0,0,0,0,0,0,83,1,0,0,0,0,0,19,11626,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Remove NPC Flag Gossip (Rigger Gizelton)"),
+-- Propose Gizelton Caravan
+(@ID*100+7,9,0,0,0,0,100,0,0,0,0,0,0,54,300000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Pause Waypoint"),
+(@ID*100+7,9,1,0,0,0,100,0,0,0,0,0,0,82,2,0,0,0,0,0,19,11626,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Add NPC Flag Questgiver (Rigger Gizelton)"),
+(@ID*100+7,9,2,0,0,0,100,0,0,0,0,0,0,1,1,0,0,0,0,0,19,11626,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Say Line 1 (Rigger Gizelton)"),
+(@ID*100+7,9,3,0,0,0,100,0,300000,300000,0,0,0,83,2,0,0,0,0,0,19,11626,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Remove NPC Flag Questgiver (Rigger Gizelton)"),
+-- Demon ambush 1 https://youtu.be/3-kKd4VNuU8?t=47
+(@ID*100+8,9,0,0,0,0,100,0,0,0,0,0,0,54,2000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Pause Waypoint"),
+(@ID*100+8,9,1,0,0,0,100,0,2000,2000,0,0,0,1,2,0,0,0,0,0,19,11626,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Say Line 2 (Rigger Gizelton)"),
+(@ID*100+8,9,2,0,0,0,100,0,1000,1000,0,0,0,107,3,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Summon Group 3"),
+-- Demon ambush 2 https://youtu.be/3-kKd4VNuU8?t=106
+(@ID*100+9,9,0,0,0,0,100,0,0,0,0,0,0,54,2000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Pause Waypoint"),
+(@ID*100+9,9,1,0,0,0,100,0,2000,2000,0,0,0,1,3,0,0,0,0,0,19,11626,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Say Line 3 (Rigger Gizelton)"),
+(@ID*100+9,9,2,0,0,0,100,0,1000,1000,0,0,0,107,4,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Summon Group 4"),
+-- Demon ambush 2 https://youtu.be/3-kKd4VNuU8?t=161
+(@ID*100+10,9,0,0,0,0,100,0,0,0,0,0,0,54,2000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Pause Waypoint"),
+(@ID*100+10,9,1,0,0,0,100,0,2000,2000,0,0,0,1,4,0,0,0,0,0,19,11626,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Say Line 4 (Rigger Gizelton)"),
+(@ID*100+10,9,2,0,0,0,100,0,1000,1000,0,0,0,107,5,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Summon Group 5"),
+-- Complete https://youtu.be/3-kKd4VNuU8?t=226
+(@ID*100+11,9,0,0,0,0,100,0,0,0,0,0,0,54,3000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Pause Waypoint"),
+(@ID*100+11,9,1,0,0,0,100,0,0,0,0,0,0,1,5,0,0,0,0,0,19,11626,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Say Line 5 (Rigger Gizelton)"),
+(@ID*100+11,9,2,0,0,0,100,0,0,0,0,0,0,2,35,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Faction 35"),
+(@ID*100+11,9,3,0,0,0,100,0,0,0,0,0,0,2,35,0,0,0,0,0,19,11626,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Faction 35 (Rigger Gizelton)"),
+(@ID*100+11,9,4,0,0,0,100,0,0,0,0,0,0,2,35,0,0,0,0,0,11,11564,40,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Faction 35 (Gizelton Caravan Kodo)"),
+(@ID*100+11,9,5,0,0,0,100,0,0,0,0,0,0,18,512,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Flag Immune To NPC's"),
+(@ID*100+11,9,6,0,0,0,100,0,0,0,0,0,0,18,512,0,0,0,0,0,19,11626,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Flag Immune To NPC's (Rigger Gizelton)"),
+(@ID*100+11,9,7,0,0,0,100,0,0,0,0,0,0,18,512,0,0,0,0,0,11,11564,40,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Flag Immune To NPC's (Gizelton Caravan Kodo)"),
+(@ID*100+11,9,8,0,0,0,100,0,0,0,0,0,0,59,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Run On"),
+(@ID*100+11,9,9,0,0,0,100,0,0,0,0,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Event Phase 0"),
+(@ID*100+11,9,10,0,0,0,100,0,3000,3000,0,0,0,15,5943,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Quest Credit 'Gizelton Caravan'"),
+
+-- Not a group quest, do not store party's guids
+-- https://www.wowhead.com/quest=5943/gizelton-caravan#comments:id=666145
+(@ID*100+12,9,0,0,0,0,100,0,0,0,0,0,0,64,1,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Store Targetlist"),
+(@ID*100+12,9,1,0,0,0,100,0,0,0,0,0,0,65,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Resume Waypoint"),
+(@ID*100+12,9,2,0,0,0,100,0,0,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Event Phase 1"),
+(@ID*100+12,9,3,0,0,0,100,0,0,0,0,0,0,83,2,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Remove NPC Flag Questgiver"),
+(@ID*100+12,9,4,0,0,0,100,0,0,0,0,0,0,2,113,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Faction 113"),
+(@ID*100+12,9,5,0,0,0,100,0,0,0,0,0,0,2,113,0,0,0,0,0,19,11626,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Faction 113 (Rigger Gizelton)"),
+(@ID*100+12,9,6,0,0,0,100,0,0,0,0,0,0,2,113,0,0,0,0,0,11,11564,40,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Faction 113 (Gizelton Caravan Kodo)"),
+(@ID*100+12,9,7,0,0,0,100,0,0,0,0,0,0,19,512,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Remove Flag Immune To NPC's"),
+(@ID*100+12,9,8,0,0,0,100,0,0,0,0,0,0,19,512,0,0,0,0,0,19,11626,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Remove Flag Immune To NPC's (Rigger Gizelton)"),
+(@ID*100+12,9,9,0,0,0,100,0,0,0,0,0,0,19,512,0,0,0,0,0,11,11564,40,0,0,0,0,0,0,"Cork Gizelton - On Script - Remove Flag Immune To NPC's (Gizelton Caravan Kodo)"),
+(@ID*100+12,9,10,0,0,0,100,0,0,0,0,0,0,59,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Cork Gizelton - On Script - Set Run Off");
+
+DELETE FROM `creature_text` WHERE `CreatureID` = @ID;
+INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES
+(@ID,0,0,"So sorry to leave a customer but we have places to go and people to swindle. We will be back sometime later today. Good-bye!",12,0,100,0,0,0,7505,0,"Cork Gizelton"),
+-- Probably zonewide
+(@ID,1,0,"I am looking for some bodyguards that would like to protect the Gizelton Caravan. We are stopped on the road east of Kormek's Hut, north of Kolkar Centaur Village.",14,0,100,0,0,0,7474,0,"Cork Gizelton"),
+(@ID,2,0,"Hey, you call yourself a body guard? Get to work and protect us...",12,0,100,0,0,0,7310,0,"Cork Gizelton"),
+(@ID,3,0,"Mister body guard, are you going to earn your money or what?",12,0,100,0,0,0,7311,0,"Cork Gizelton"),
+(@ID,4,0,"You're fired! <Cough...Cork clears throat.> I mean, help!",12,0,100,0,0,0,7312,0,"Cork Gizelton"),
+(@ID,5,0,"Blast those stupid centaurs! Sigh - well, it seems you kept your bargain. Up the road you shall find Smeed Scrabblescrew, he has your money.",12,0,100,0,0,0,7334,0,"Cork Gizelton");
+
+DELETE FROM `creature_summon_groups` WHERE `summonerId` = @ID AND `summonerType` = 0;
+INSERT INTO `creature_summon_groups` (`summonerId`,`summonerType`,`groupId`,`entry`,`position_x`,`position_y`,`position_z`,`orientation`,`summonType`,`summonTime`,`Comment`) VALUES
+(@ID,0,0,12976,-786.496399,1186.830444,98.872955,4.338541,4,60000,"Cork Gizelton - Group 0 - Kolkar Waylayer"),
+(@ID,0,0,12976,-810.522156,1168.825928,99.596046,1.259777,4,60000,"Cork Gizelton - Group 0 - Kolkar Waylayer"),
+(@ID,0,0,12977,-804.962158,1184.335938,99.555801,4.977856,4,60000,"Cork Gizelton - Group 0 - Kolkar Ambusher"),
+(@ID,0,0,12977,-789.564453,1167.567505,97.738983,2.225817,4,60000,"Cork Gizelton - Group 0 - Kolkar Ambusher"),
+(@ID,0,1,12976,-941.752502,1171.344360,91.599319,1.051649,4,60000,"Cork Gizelton - Group 1 - Kolkar Waylayer"),
+(@ID,0,1,12976,-915.573914,1171.861816,94.556068,0.702927,4,60000,"Cork Gizelton - Group 1 - Kolkar Waylayer"),
+(@ID,0,1,12977,-931.896179,1188.513672,92.509621,4.437494,4,60000,"Cork Gizelton - Group 1 - Kolkar Ambusher"),
+(@ID,0,1,12977,-907.493713,1190.668213,95.699776,4.036945,4,60000,"Cork Gizelton - Group 1 - Kolkar Ambusher"),
+(@ID,0,2,12976,-1114.50512,1197.017822,89.739799,5.670575,4,60000,"Cork Gizelton - Group 2 - Kolkar Waylayer"),
+(@ID,0,2,12976,-1086.44262,1176.773315,89.744904,2.301221,4,60000,"Cork Gizelton - Group 2 - Kolkar Waylayer"),
+(@ID,0,2,12977,-1108.92358,1180.153076,89.740318,0.526221,4,60000,"Cork Gizelton - Group 2 - Kolkar Ambusher"),
+(@ID,0,2,12977,-1094.88842,1196.839111,89.739746,4.555314,4,60000,"Cork Gizelton - Group 2 - Kolkar Ambusher"),
+(@ID,0,3,4676,-1818.365112,2051.031738,61.448582,1.282561,4,60000,"Cork Gizelton - Group 3 - Lesser Infernal"),
+(@ID,0,3,4677,-1819.779419,2082.620117,65.348495,5.704354,4,60000,"Cork Gizelton - Group 3 - Doomwarder"),
+(@ID,0,3,4684,-1825.155640,2059.577393,61.964958,0.885935,4,60000,"Cork Gizelton - Group 3 - Nether Sorceress"),
+(@ID,0,4,4676,-1787.307495,1923.290405,59.631226,2.902831,4,60000,"Cork Gizelton - Group 4 - Lesser Infernal"),
+(@ID,0,4,4677,-1801.117310,1935.664307,60.699883,0.722568,4,60000,"Cork Gizelton - Group 4 - Doomwarder"),
+(@ID,0,4,4684,-1783.754150,1942.123413,60.261951,2.759897,4,60000,"Cork Gizelton - Group 4 - Nether Sorceress"),
+(@ID,0,5,4676,-1671.754150,1855.579102,59.029522,1.452987,4,60000,"Cork Gizelton - Group 5 - Lesser Infernal"),
+(@ID,0,5,4677,-1692.874023,1858.821533,58.936962,4.662123,4,60000,"Cork Gizelton - Group 5 - Doomwarder"),
+-- Both of them were sniffed in TBC
+(@ID,0,6,12245,-692.743,1522.2,90.3611,0.558505,3,600000,"Cork Gizelton - Group 6 - Vendor-Tron 1000"),
+(@ID,0,7,12246,-1926.6,2412.79,60.6956,0.174533,3,600000,"Cork Gizelton - Group 7 - Super-Seller 680");
+
+-- Rigger Gizelton SAI
+SET @ID := 11626;
+UPDATE `creature_template` SET `AIName` = "SmartAI" WHERE `entry` = @ID;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = @ID AND `source_type` = 0;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = @ID*100+0 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
+(@ID,0,0,0,19,0,100,0,5943,0,0,0,0,80,@ID*100+0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Rigger Gizelton - On Quest 'Gizelton Caravan' Taken - Run Script"),
+(@ID,0,1,2,6,0,100,0,0,0,0,0,0,6,5943,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"Rigger Gizelton - On Death - Fail Quest 'Gizelton Caravan'"),
+(@ID,0,2,3,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,19,11625,0,0,0,0,0,0,0,"Rigger Gizelton - On Link - Despawn Instant (Cork Gizelton)"),
+(@ID,0,3,4,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,11,11564,100,0,0,0,0,0,0,"Rigger Gizelton - On Link - Despawn Instant (Gizelton Caravan Kodo)"),
+(@ID,0,4,0,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Rigger Gizelton - On Link - Despawn Instant"),
+
+-- Not a group quest, do not store party's guids
+-- https://www.wowhead.com/quest=5943/gizelton-caravan#comments:id=666145
+(@ID*100+0,9,0,0,0,0,100,0,0,0,0,0,0,64,1,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Rigger Gizelton - On Script - Store Targetlist"),
+(@ID*100+0,9,1,0,0,0,100,0,0,0,0,0,0,100,1,0,0,0,0,0,19,11625,0,0,0,0,0,0,0,"Rigger Gizelton - On Script - Send Target 1 (Cork Gizelton)"),
+(@ID*100+0,9,2,0,0,0,100,0,0,0,0,0,0,45,0,1,0,0,0,0,19,11625,0,0,0,0,0,0,0,"Rigger Gizelton - On Script - Set Data 0 1 (Cork Gizelton)"),
+(@ID*100+0,9,3,0,0,0,100,0,0,0,0,0,0,83,2,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Rigger Gizelton - On Script - Remove NPC Flag Questgiver"),
+(@ID*100+0,9,4,0,0,0,100,0,0,0,0,0,0,2,113,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Rigger Gizelton - On Script - Set Faction 113"),
+(@ID*100+0,9,5,0,0,0,100,0,0,0,0,0,0,2,113,0,0,0,0,0,19,11625,0,0,0,0,0,0,0,"Rigger Gizelton - On Script - Set Faction 113 (Cork Gizelton)"),
+(@ID*100+0,9,6,0,0,0,100,0,0,0,0,0,0,2,113,0,0,0,0,0,11,11564,40,0,0,0,0,0,0,"Rigger Gizelton - On Script - Set Faction 113 (Gizelton Caravan Kodo)"),
+(@ID*100+0,9,7,0,0,0,100,0,0,0,0,0,0,19,512,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Rigger Gizelton - On Script - Remove Flag Immune To NPC's"),
+(@ID*100+0,9,8,0,0,0,100,0,0,0,0,0,0,19,512,0,0,0,0,0,19,11625,0,0,0,0,0,0,0,"Rigger Gizelton - On Script - Remove Flag Immune To NPC's (Cork Gizelton)"),
+(@ID*100+0,9,9,0,0,0,100,0,0,0,0,0,0,19,512,0,0,0,0,0,11,11564,40,0,0,0,0,0,0,"Rigger Gizelton - On Script - Remove Flag Immune To NPC's (Gizelton Caravan Kodo)");
+
+DELETE FROM `creature_text` WHERE `CreatureID` = @ID;
+INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES
+(@ID,0,0,"Time for the Gizleton Caravan to head on out! We'll be back soon but if you cannot wait, head north to Kormek's Hut. We open shop in about an hour.",12,0,100,0,0,0,7506,0,"Rigger Gizelton"),
+(@ID,1,0,"This is Rigger Gizelton asking for assistance escorting my caravan past Mannoroc Coven. I'm on the road east of Shadowprey village.",14,0,100,0,0,0,7475,0,"Rigger Gizelton"),
+(@ID,2,0,"Eeck! Demons appear hungry for the kodos!",12,0,100,0,0,0,7330,0,"Rigger Gizelton"),
+(@ID,3,0,"What am I paying you for? The kodos are nearly dead!",12,0,100,0,0,0,7331,0,"Rigger Gizelton"),
+(@ID,4,0,"Only if I were about five feet taller, then I would show these blasphemous demons a thing or two! Help!",12,0,100,0,0,0,7332,0,"Rigger Gizelton"),
+(@ID,5,0,"Wow! We did it... not sure why we thought we needed the likes of you. Nevertheless, speak with Smeed Scrabblescrew; he will give you your earnings!
+",12,0,100,0,0,0,7333,0,"Rigger Gizelton");
+
+DELETE FROM `waypoint_data` WHERE `id` IN (272900,272890,287140,287280);
+UPDATE `creature` SET `MovementType` = 0 WHERE `id` IN (11564,11625,11626);
+UPDATE `creature_addon` SET `path_id` = 0 WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (11564,11625,11626));
+
+DELETE FROM `creature_addon` WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (12245,12246));
+DELETE FROM `creature` WHERE `id` IN (12245,12246);
+
+DELETE FROM `creature_formations` WHERE `leaderGUID` = 28714;
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES
+(28714,28714,0,0,515,0,0),
+(28714,28728,8,360,515,0,0),
+(28714,27290,18,360,515,0,0),
+(28714,27289,28,360,515,0,0);
+
+DELETE FROM `waypoints` WHERE `entry` = 11625;
+INSERT INTO `waypoints` (`entry`,`pointid`,`position_x`,`position_y`,`position_z`,`point_comment`) VALUES
+(11625,1,-1290.31,1231.38,109.237,"Cork Gizelton"),
+(11625,2,-1277.59,1225.54,108.85,"Cork Gizelton"),
+(11625,3,-1264.86,1219.71,108.452,"Cork Gizelton"),
+(11625,4,-1230.04,1204.31,104.374,"Cork Gizelton"),
+(11625,5,-1216.17,1206.24,101.889,"Cork Gizelton"),
+(11625,6,-1202.32,1208.28,99.7026,"Cork Gizelton"),
+(11625,7,-1188.03,1207.66,97.2208,"Cork Gizelton"),
+(11625,8,-1170.99,1195.93,94.5615,"Cork Gizelton"),
+(11625,9,-1155.46,1192.16,92.4374,"Cork Gizelton"),
+(11625,10,-1127.52,1190.39,89.8358,"Cork Gizelton"),
+(11625,11,-1113.58,1189.12,89.7403,"Cork Gizelton"),
+(11625,12,-1070.8,1186.15,89.7403,"Cork Gizelton"),
+(11625,13,-1037.27,1183.2,89.8006,"Cork Gizelton"),
+(11625,14,-995.58,1177.92,89.7409,"Cork Gizelton"),
+(11625,15,-981.817,1180.48,89.8152,"Cork Gizelton"),
+(11625,16,-952.606,1181.99,89.7313,"Cork Gizelton"),
+(11625,17,-935.445,1182.25,91.2113,"Cork Gizelton"),
+(11625,18,-921.448,1182.53,93.1746,"Cork Gizelton"),
+(11625,19,-879.467,1183.72,97.6043,"Cork Gizelton"),
+(11625,20,-858.976,1184.22,99.0322,"Cork Gizelton"),
+(11625,21,-828.316,1180.2,99.6657,"Cork Gizelton"),
+(11625,22,-799.811,1176,99.3364,"Cork Gizelton"),
+(11625,23,-757.106,1191.47,96.9164,"Cork Gizelton"),
+(11625,24,-731.879,1208.14,92.6956,"Cork Gizelton"),
+(11625,25,-719.12,1213.91,91.3297,"Cork Gizelton"),
+(11625,26,-706.36,1219.67,90.2856,"Cork Gizelton"),
+(11625,27,-689.935,1228.43,89.4426,"Cork Gizelton"),
+(11625,28,-679.121,1237.31,89.17,"Cork Gizelton"),
+(11625,29,-661.434,1247.28,89.17,"Cork Gizelton"),
+(11625,30,-635.655,1258.2,89.2063,"Cork Gizelton"),
+(11625,31,-614.489,1269.64,89.1686,"Cork Gizelton"),
+(11625,32,-600.078,1274.85,89.1238,"Cork Gizelton"),
+(11625,33,-586.268,1277.15,89.145,"Cork Gizelton"),
+(11625,34,-546.297,1287.15,89.1597,"Cork Gizelton"),
+(11625,35,-541.257,1300.21,89.1602,"Cork Gizelton"),
+(11625,36,-536.026,1313.2,89.1314,"Cork Gizelton"),
+(11625,37,-525.098,1338.97,89.1005,"Cork Gizelton"),
+(11625,38,-518.852,1356.12,89.0827,"Cork Gizelton"),
+(11625,39,-516.879,1395.56,89.0827,"Cork Gizelton"),
+(11625,40,-518.905,1436.25,89.0696,"Cork Gizelton"),
+(11625,41,-525.605,1446.54,88.4907,"Cork Gizelton"),
+(11625,42,-543.459,1462.9,88.3752,"Cork Gizelton"),
+(11625,43,-557.591,1471.17,88.9477,"Cork Gizelton"),
+(11625,44,-584.698,1478.14,88.3754,"Cork Gizelton"),
+(11625,45,-598.459,1480.72,88.3754,"Cork Gizelton"),
+(11625,46,-632.084,1491.03,88.3754,"Cork Gizelton"),
+(11625,47,-644.249,1497.95,88.3754,"Cork Gizelton"),
+(11625,48,-660.456,1507.56,88.3874,"Cork Gizelton"),
+(11625,49,-666.507,1504.7,89.0746,"Cork Gizelton"),
+(11625,50,-673.795,1499.48,90.3922,"Cork Gizelton"),
+(11625,51,-692.154,1480.43,90.5302,"Cork Gizelton"),
+(11625,52,-710.764,1470.11,91.3034,"Cork Gizelton"), -- Vendor-Tron 1000
+(11625,53,-697.048,1484.75,91.0929,"Cork Gizelton"),
+(11625,54,-676.552,1497.37,90.6505,"Cork Gizelton"),
+(11625,55,-665.209,1505.76,88.8321,"Cork Gizelton"),
+(11625,56,-657.898,1510.94,88.3752,"Cork Gizelton"),
+(11625,57,-647.387,1501.69,88.3752,"Cork Gizelton"),
+(11625,58,-630.597,1491.17,88.3752,"Cork Gizelton"),
+(11625,59,-603.756,1483.26,88.3752,"Cork Gizelton"),
+(11625,60,-576.573,1476.54,88.3752,"Cork Gizelton"),
+(11625,61,-556.868,1470.92,88.8685,"Cork Gizelton"),
+(11625,62,-547.471,1464.89,88.3747,"Cork Gizelton"),
+(11625,63,-529.316,1449.97,88.402,"Cork Gizelton"),
+(11625,64,-517.699,1433.75,89.0816,"Cork Gizelton"),
+(11625,65,-518.09,1405.76,89.0816,"Cork Gizelton"),
+(11625,66,-518.149,1377.76,89.0816,"Cork Gizelton"),
+(11625,67,-521.289,1350.76,89.0816,"Cork Gizelton"),
+(11625,68,-531.625,1324.74,89.1339,"Cork Gizelton"),
+(11625,69,-537.391,1311.99,89.1594,"Cork Gizelton"),
+(11625,70,-551.845,1284.12,89.1594,"Cork Gizelton"),
+(11625,71,-578.054,1278.57,89.1685,"Cork Gizelton"),
+(11625,72,-591.957,1276.92,89.1634,"Cork Gizelton"),
+(11625,73,-611.806,1271.05,89.1694,"Cork Gizelton"),
+(11625,74,-623.928,1264.06,89.1694,"Cork Gizelton"),
+(11625,75,-653.384,1249.74,89.1694,"Cork Gizelton"),
+(11625,76,-666.372,1244.51,89.1694,"Cork Gizelton"), -- Propose Bodyguard for Hire
+(11625,77,-684.6,1232.06,89.2134,"Cork Gizelton"),
+(11625,78,-694.027,1225.67,89.6627,"Cork Gizelton"),
+(11625,79,-706.605,1219.58,90.2981,"Cork Gizelton"),
+(11625,80,-732.184,1208.23,92.7376,"Cork Gizelton"),
+(11625,81,-738.514,1204.75,93.8662,"Cork Gizelton"),
+(11625,82,-754.159,1193.91,96.6195,"Cork Gizelton"),
+(11625,83,-766.62,1187.59,97.8394,"Cork Gizelton"),
+(11625,84,-792.515,1177.07,98.8327,"Cork Gizelton"), -- Kolkar ambush 1 https://youtu.be/9TLf3OF9gLM?t=69
+(11625,85,-802.533,1175.57,99.4435,"Cork Gizelton"),
+(11625,86,-821.772,1178.84,99.6542,"Cork Gizelton"),
+(11625,87,-835.435,1181.9,99.6662,"Cork Gizelton"),
+(11625,88,-848.98,1184.67,99.5782,"Cork Gizelton"),
+(11625,89,-861.251,1185.3,98.8033,"Cork Gizelton"),
+(11625,90,-889.179,1183.34,96.6117,"Cork Gizelton"),
+(11625,91,-903.158,1182.57,95.2033,"Cork Gizelton"),
+(11625,92,-931.15,1182.17,91.8346,"Cork Gizelton"),  -- Kolkar ambush 2 https://youtu.be/9TLf3OF9gLM?t=185
+(11625,93,-945.149,1182.01,89.8612,"Cork Gizelton"),
+(11625,94,-959.149,1181.92,89.7397,"Cork Gizelton"),
+(11625,95,-973.149,1181.97,89.7397,"Cork Gizelton"),
+(11625,96,-1001.65,1178.06,89.7398,"Cork Gizelton"),
+(11625,97,-1011.8,1177.4,89.7398,"Cork Gizelton"),
+(11625,98,-1033.08,1182.29,89.7629,"Cork Gizelton"),
+(11625,99,-1073.62,1186.33,89.7398,"Cork Gizelton"),
+(11625,100,-1101.59,1187.56,89.7398,"Cork Gizelton"),  -- Kolkar ambush 3 https://youtu.be/9TLf3OF9gLM?t=327
+(11625,101,-1129.48,1190.01,89.8855,"Cork Gizelton"),
+(11625,102,-1143.44,1191.11,91.0344,"Cork Gizelton"),
+(11625,103,-1166.85,1194.28,93.9649,"Cork Gizelton"),
+(11625,104,-1184.71,1203.56,96.6406,"Cork Gizelton"),
+(11625,105,-1201.45,1208.2,99.5698,"Cork Gizelton"),
+(11625,106,-1225.42,1204.68,103.502,"Cork Gizelton"),
+(11625,107,-1235.55,1206.75,105.129,"Cork Gizelton"), -- Complete
+(11625,108,-1261.05,1218.25,108.207,"Cork Gizelton"),
+(11625,109,-1286.64,1229.58,109.112,"Cork Gizelton"),
+(11625,110,-1306.84,1233.21,109.771,"Cork Gizelton"),
+(11625,111,-1331.25,1233.54,110.674,"Cork Gizelton"),
+(11625,112,-1350.02,1227.22,111.201,"Cork Gizelton"),
+(11625,113,-1389.37,1212.53,111.587,"Cork Gizelton"),
+(11625,114,-1415.8,1202.23,111.948,"Cork Gizelton"),
+(11625,115,-1424.26,1196.81,112.038,"Cork Gizelton"),
+(11625,116,-1449.27,1188.13,111.53,"Cork Gizelton"),
+(11625,117,-1474.53,1186.42,109.366,"Cork Gizelton"),
+(11625,118,-1491.78,1189.4,106.114,"Cork Gizelton"),
+(11625,119,-1502.95,1198.12,101.757,"Cork Gizelton"),
+(11625,120,-1512.09,1209.44,96.2469,"Cork Gizelton"),
+(11625,121,-1520.19,1226.67,89.7861,"Cork Gizelton"),
+(11625,122,-1522.75,1243.63,83.3864,"Cork Gizelton"),
+(11625,123,-1520.9,1257.51,77.7027,"Cork Gizelton"),
+(11625,124,-1518.48,1273.17,71.8991,"Cork Gizelton"),
+(11625,125,-1516.17,1290.94,66.8473,"Cork Gizelton"),
+(11625,126,-1514.74,1306.19,63.4211,"Cork Gizelton"),
+(11625,127,-1511.54,1328.73,60.2051,"Cork Gizelton"),
+(11625,128,-1505.75,1341.47,59.2142,"Cork Gizelton"),
+(11625,129,-1494.42,1367.08,58.9254,"Cork Gizelton"),
+(11625,130,-1485.84,1393.02,58.9251,"Cork Gizelton"),
+(11625,131,-1485.47,1407,58.9469,"Cork Gizelton"),
+(11625,132,-1487.57,1434.84,58.9347,"Cork Gizelton"),
+(11625,133,-1489.45,1448.71,58.9302,"Cork Gizelton"),
+(11625,134,-1489.77,1469.49,58.9251,"Cork Gizelton"),
+(11625,135,-1483.8,1482.15,58.9251,"Cork Gizelton"),
+(11625,136,-1471.32,1507.22,58.9251,"Cork Gizelton"),
+(11625,137,-1464.94,1519.68,58.9251,"Cork Gizelton"),
+(11625,138,-1452.27,1544.64,58.9251,"Cork Gizelton"),
+(11625,139,-1442.94,1584.75,58.9255,"Cork Gizelton"),
+(11625,140,-1452.7,1610.98,58.9255,"Cork Gizelton"),
+(11625,141,-1464.1,1641.7,58.9255,"Cork Gizelton"),
+(11625,142,-1474.86,1647.49,58.9255,"Cork Gizelton"),
+(11625,143,-1500.84,1657.91,58.9255,"Cork Gizelton"),
+(11625,144,-1521.76,1671.96,58.9255,"Cork Gizelton"),
+(11625,145,-1541.37,1691.94,58.9255,"Cork Gizelton"),
+(11625,146,-1551.2,1701.92,58.9255,"Cork Gizelton"),
+(11625,147,-1571.41,1721.29,58.9255,"Cork Gizelton"),
+(11625,148,-1592.97,1739.14,58.9255,"Cork Gizelton"),
+(11625,149,-1613.28,1758.07,58.9255,"Cork Gizelton"),
+(11625,150,-1630.32,1780.27,58.9255,"Cork Gizelton"),
+(11625,151,-1645.92,1803.52,58.9296,"Cork Gizelton"),
+(11625,152,-1661.7,1826.65,58.9271,"Cork Gizelton"),
+(11625,153,-1681.42,1858.29,58.9271,"Cork Gizelton"),
+(11625,154,-1686.38,1877.21,59.2059,"Cork Gizelton"),
+(11625,155,-1692.06,1899.02,60.7504,"Cork Gizelton"),
+(11625,156,-1699.45,1908.31,61.1412,"Cork Gizelton"),
+(11625,157,-1717,1915.93,60.0908,"Cork Gizelton"),
+(11625,158,-1738.04,1917.48,59.0673,"Cork Gizelton"),
+(11625,159,-1757.16,1918.92,58.9757,"Cork Gizelton"),
+(11625,160,-1772.71,1926.58,59.1537,"Cork Gizelton"),
+(11625,161,-1791.81,1939.62,60.7298,"Cork Gizelton"),
+(11625,162,-1802.7,1951.89,60.7237,"Cork Gizelton"),
+(11625,163,-1809.79,1963.96,59.7477,"Cork Gizelton"),
+(11625,164,-1815.2,1976.74,59.0006,"Cork Gizelton"),
+(11625,165,-1817.51,2008.7,59.5336,"Cork Gizelton"),
+(11625,166,-1823,2032.7,60.6767,"Cork Gizelton"),
+(11625,167,-1821.87,2042.21,60.944,"Cork Gizelton"),
+(11625,168,-1813.14,2068.68,63.0096,"Cork Gizelton"),
+(11625,169,-1810.52,2082.43,63.114,"Cork Gizelton"),
+(11625,170,-1806.9,2095.9,63.1144,"Cork Gizelton"),
+(11625,171,-1802.03,2111.56,63.6862,"Cork Gizelton"),
+(11625,172,-1802.03,2111.56,63.6862,"Cork Gizelton"),
+(11625,173,-1801.53,2141.07,63.006,"Cork Gizelton"),
+(11625,174,-1801.53,2141.07,63.006,"Cork Gizelton"),
+(11625,175,-1802.25,2155.05,61.5195,"Cork Gizelton"),
+(11625,176,-1803.02,2183.03,59.8215,"Cork Gizelton"),
+(11625,177,-1808.36,2207.2,59.8215,"Cork Gizelton"),
+(11625,178,-1822.66,2219.86,59.8215,"Cork Gizelton"),
+(11625,179,-1836.76,2232.87,59.8215,"Cork Gizelton"),
+(11625,180,-1843.44,2245.11,59.8215,"Cork Gizelton"),
+(11625,181,-1844.75,2266.9,59.8215,"Cork Gizelton"),
+(11625,182,-1846.34,2280.81,59.8215,"Cork Gizelton"),
+(11625,183,-1849.89,2294.13,59.8215,"Cork Gizelton"),
+(11625,184,-1864.58,2316.31,59.8215,"Cork Gizelton"),
+(11625,185,-1872.72,2327.7,59.8224,"Cork Gizelton"),
+(11625,186,-1884.98,2346.82,59.8224,"Cork Gizelton"),
+(11625,187,-1887.2,2354.3,59.8696,"Cork Gizelton"),
+(11625,188,-1893.87,2379.11,59.9196,"Cork Gizelton"),
+(11625,189,-1900.07,2391.67,59.8224,"Cork Gizelton"),
+(11625,190,-1904,2405.04,59.8224,"Cork Gizelton"),
+(11625,191,-1904,2405.04,59.8224,"Cork Gizelton"),
+(11625,192,-1895.71,2431.78,59.8224,"Cork Gizelton"),
+(11625,193,-1888.72,2458.89,59.8224,"Cork Gizelton"), -- Super-Seller 680
+(11625,194,-1895.4,2432.5,59.8224,"Cork Gizelton"),
+(11625,195,-1899.03,2418.98,59.8224,"Cork Gizelton"),
+(11625,196,-1899.68,2393.35,59.8224,"Cork Gizelton"),
+(11625,197,-1892.03,2375.61,59.9178,"Cork Gizelton"),
+(11625,198,-1885.29,2346.94,59.8216,"Cork Gizelton"),
+(11625,199,-1881.12,2339.05,59.8216,"Cork Gizelton"),
+(11625,200,-1864.4,2316.59,59.8226,"Cork Gizelton"),
+(11625,201,-1852.79,2300.12,59.8226,"Cork Gizelton"),
+(11625,202,-1847.08,2287.99,59.8226,"Cork Gizelton"),
+(11625,203,-1844.34,2264.2,59.8226,"Cork Gizelton"),
+(11625,204,-1842.38,2243.22,59.8226,"Cork Gizelton"),
+(11625,205,-1840.11,2237.75,59.8226,"Cork Gizelton"),
+(11625,206,-1830.64,2226.2,59.8226,"Cork Gizelton"),
+(11625,207,-1810.22,2209.43,59.8226,"Cork Gizelton"),
+(11625,208,-1802.8,2194.02,59.8226,"Cork Gizelton"),
+(11625,209,-1800.41,2180.08,59.8226,"Cork Gizelton"), -- Propose Gizelton Caravan https://www.youtube.com/watch?v=3-kKd4VNuU8
+(11625,210,-1800.26,2166.08,60.1822,"Cork Gizelton"),
+(11625,211,-1801.62,2148.85,62.344,"Cork Gizelton"),
+(11625,212,-1801.15,2134.86,63.1766,"Cork Gizelton"),
+(11625,213,-1802.26,2110.11,63.6737,"Cork Gizelton"),
+(11625,214,-1805.87,2096.6,63.1784,"Cork Gizelton"),
+(11625,215,-1809.25,2083.01,63.0772,"Cork Gizelton"), -- Demon ambush 1 https://youtu.be/3-kKd4VNuU8?t=47
+(11625,216,-1812.63,2069.43,63.043,"Cork Gizelton"),
+(11625,217,-1816.72,2056.04,61.8496,"Cork Gizelton"),
+(11625,218,-1822.89,2032.23,60.6524,"Cork Gizelton"),
+(11625,219,-1822.76,2027.39,60.3783,"Cork Gizelton"),
+(11625,220,-1815.56,2003.46,59.4022,"Cork Gizelton"),
+(11625,221,-1814.41,1983.18,58.9549,"Cork Gizelton"),
+(11625,222,-1811.8,1967.01,59.4735,"Cork Gizelton"),
+(11625,223,-1803.12,1951.78,60.7154,"Cork Gizelton"), -- Demon ambush 2 https://youtu.be/3-kKd4VNuU8?t=106
+(11625,224,-1793.24,1941.87,60.8439,"Cork Gizelton"),
+(11625,225,-1775.92,1926.82,59.3033,"Cork Gizelton"),
+(11625,226,-1759.93,1918.92,58.9613,"Cork Gizelton"),
+(11625,227,-1751.9,1917.2,59.0003,"Cork Gizelton"),
+(11625,228,-1737.91,1917.04,59.0673,"Cork Gizelton"),
+(11625,229,-1712.18,1914.85,60.4394,"Cork Gizelton"),
+(11625,230,-1701.72,1911.02,61.0949,"Cork Gizelton"),
+(11625,231,-1694.06,1904.03,61.03,"Cork Gizelton"),
+(11625,232,-1687.1,1886.34,59.7501,"Cork Gizelton"),
+(11625,233,-1684.12,1872.66,59.0354,"Cork Gizelton"), -- Demon ambush 3 https://youtu.be/3-kKd4VNuU8?t=161
+(11625,234,-1673.14,1845.28,58.9273,"Cork Gizelton"),
+(11625,235,-1657.63,1821.97,58.9273,"Cork Gizelton"),
+(11625,236,-1649.83,1810.34,58.9273,"Cork Gizelton"),
+(11625,237,-1634.24,1787.08,58.9252,"Cork Gizelton"),
+(11625,238,-1626.45,1775.45,58.9252,"Cork Gizelton"),
+(11625,239,-1605.77,1750.66,58.9256,"Cork Gizelton"),
+(11625,240,-1594.91,1741.83,58.9256,"Cork Gizelton"), -- Complete https://youtu.be/3-kKd4VNuU8?t=226
+(11625,241,-1573.31,1724.02,58.9256,"Cork Gizelton"),
+(11625,242,-1553.4,1704.35,58.9256,"Cork Gizelton"),
+(11625,243,-1543.67,1694.29,58.9256,"Cork Gizelton"),
+(11625,244,-1523.39,1674.99,58.9256,"Cork Gizelton"),
+(11625,245,-1505.1,1659.98,58.9256,"Cork Gizelton"),
+(11625,246,-1489.89,1652.47,58.9256,"Cork Gizelton"),
+(11625,247,-1460.15,1634.27,58.9256,"Cork Gizelton"),
+(11625,248,-1453.16,1621.35,58.9256,"Cork Gizelton"),
+(11625,249,-1446.87,1598.31,58.9256,"Cork Gizelton"),
+(11625,250,-1440.81,1573.28,58.9256,"Cork Gizelton"),
+(11625,251,-1445.9,1553.99,58.9256,"Cork Gizelton"),
+(11625,252,-1451.91,1541.35,58.9256,"Cork Gizelton"),
+(11625,253,-1458.46,1528.97,58.9256,"Cork Gizelton"),
+(11625,254,-1471.62,1504.26,58.9256,"Cork Gizelton"),
+(11625,255,-1478.08,1491.84,58.9256,"Cork Gizelton"),
+(11625,256,-1490.08,1466.54,58.9256,"Cork Gizelton"),
+(11625,257,-1491.71,1455.14,58.9291,"Cork Gizelton"),
+(11625,258,-1488.22,1427.36,58.9348,"Cork Gizelton"),
+(11625,259,-1486.41,1413.48,58.9418,"Cork Gizelton"),
+(11625,260,-1487.62,1388.44,58.9251,"Cork Gizelton"),
+(11625,261,-1491.84,1375.08,58.9301,"Cork Gizelton"),
+(11625,262,-1502.72,1349.31,58.9416,"Cork Gizelton"),
+(11625,263,-1508.49,1336.58,59.525,"Cork Gizelton"),
+(11625,264,-1511.68,1327.41,60.3754,"Cork Gizelton"),
+(11625,265,-1514.03,1314.22,62.0185,"Cork Gizelton"),
+(11625,266,-1514.79,1300.27,64.5471,"Cork Gizelton"),
+(11625,267,-1516.1,1286.34,68.0841,"Cork Gizelton"),
+(11625,268,-1518.52,1272.55,72.0932,"Cork Gizelton"),
+(11625,269,-1523.17,1245.16,82.7876,"Cork Gizelton"),
+(11625,270,-1522.5,1234.75,87.008,"Cork Gizelton"),
+(11625,271,-1517.95,1221.51,91.5343,"Cork Gizelton"),
+(11625,272,-1511.76,1208.2,96.7403,"Cork Gizelton"),
+(11625,273,-1501.33,1196.53,102.475,"Cork Gizelton"),
+(11625,274,-1490.76,1188.95,106.376,"Cork Gizelton"),
+(11625,275,-1475.92,1185.48,109.181,"Cork Gizelton"),
+(11625,276,-1452.6,1187.95,111.422,"Cork Gizelton"),
+(11625,277,-1433.28,1193.58,111.857,"Cork Gizelton"),
+(11625,278,-1414.55,1203.63,111.886,"Cork Gizelton"),
+(11625,279,-1388.31,1213.37,111.599,"Cork Gizelton"),
+(11625,280,-1375.11,1218.03,111.465,"Cork Gizelton"),
+(11625,281,-1348.49,1226.69,111.175,"Cork Gizelton"),
+(11625,282,-1319.41,1232.27,110.201,"Cork Gizelton");