Remove SQL files wrongly added in previous cherry-pick merge

24 files changed, 0 insertions, 2071 deletions

diff --git a/sql/updates/world/2015_05_22_08_world_335.sql b/sql/updates/world/2015_05_22_08_world_335.sql
deleted file mode 100644
index 9cdb7edf295..00000000000
--- a/sql/updates/world/2015_05_22_08_world_335.sql
+++ /dev/null
@@ -1,32 +0,0 @@
---
-DELETE FROM `smart_scripts` WHERE `entryorguid` IN (14661) 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
-(14661, 0, 0, 0, 0, 0, 100, 0, 3000, 5000, 4000, 6000, 11, 5416, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0,0,'Stinglasher - IC - cast Venom Sting'),
-(14661, 0, 1, 0, 0, 0, 100, 0, 6000, 8000, 7000, 10000, 11, 6607, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0,0,'Stinglasher - IC - cast Lash');
-
-UPDATE `creature_template` SET `InhabitType`=4, `AIName`='SmartAI' WHERE `entry`=14661;
-UPDATE `creature` SET `MovementType`=2 WHERE `guid` IN (50074);
-UPDATE `creature_addon` SET `path_id`=500740 WHERE `guid` IN (50074);
-
-DELETE FROM `waypoint_data` WHERE (`id`=500740);
-INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES
-(500740, 1, -5219.040039, 90.906799, 31.608503, 0, 0, 0, 0, 100, 0),
-(500740, 2, -5224.050293, 76.003220, 29.438269, 0, 0, 0, 0, 100, 0),
-(500740, 3, -5239.147949, 63.874466, 25.338007, 0, 0, 0, 0, 100, 0),
-(500740, 4, -5238.693848, 49.682274, 24.432926, 0, 0, 0, 0, 100, 0),
-(500740, 5, -5246.642578, 32.150028, 19.696297, 0, 0, 0, 0, 100, 0),
-(500740, 6, -5261.720703, 17.697470, 18.217318, 0, 0, 0, 0, 100, 0),
-(500740, 7, -5275.494629, 20.200960, 19.163641, 0, 0, 0, 0, 100, 0),
-(500740, 8, -5287.398438, 15.724384, 19.484865, 0, 0, 0, 0, 100, 0),
-(500740, 9, -5285.921875, -4.451639, 19.543159, 0, 0, 0, 0, 100, 0),
-(500740, 10, -5266.689453, -10.566733, 15.15608, 0, 0, 0, 0, 100, 0),
-(500740, 11, -5260.603027, -1.987386, 14.133003, 0, 0, 0, 0, 100, 0),
-(500740, 12, -5260.889160, 16.419760, 17.921291, 0, 0, 0, 0, 100, 0),
-(500740, 13, -5244.723145, 31.915073, 19.788879, 0, 0, 0, 0, 100, 0),
-(500740, 14, -5240.108887, 48.679680, 24.157497, 0, 0, 0, 0, 100, 0),
-(500740, 15, -5240.560547, 62.042046, 25.325819, 0, 0, 0, 0, 100, 0),
-(500740, 16, -5225.194336, 76.540390, 29.50018, 0, 0, 0, 0, 100, 0),
-(500740, 17, -5221.191406, 84.720314, 31.15358, 0, 0, 0, 0, 100, 0),
-(500740, 18, -5207.856934, 125.004700, 33.70418, 0, 0, 0, 0, 100, 0),
-(500740, 19, -5189.811523, 162.779144, 49.10691, 0, 0, 0, 0, 100, 0),
-(500740, 20, -5185.788086, 183.261688, 49.97140, 0, 0, 0, 0, 100, 0);
diff --git a/sql/updates/world/2015_05_22_12_world.sql b/sql/updates/world/2015_05_22_12_world.sql
deleted file mode 100644
index 84b5918e7f4..00000000000
--- a/sql/updates/world/2015_05_22_12_world.sql
+++ /dev/null
@@ -1,10 +0,0 @@
---
-DELETE FROM `smart_scripts` WHERE `entryorguid`=16522 AND `id`=12;
-UPDATE `smart_scripts` SET `action_param1`=1 WHERE `entryorguid`=16522 AND `id`=0;
-UPDATE `smart_scripts` SET `event_phase_mask`=1 WHERE entryorguid=16522 AND `id`=5;
-UPDATE `smart_scripts` SET `event_phase_mask`=0, `event_flags`=0 WHERE `entryorguid`=16522 AND `id`=6;
-UPDATE `smart_scripts` SET `event_phase_mask`=0 WHERE `entryorguid`=16522 AND `id`=7;
-UPDATE `smart_scripts` SET `event_phase_mask`=2 WHERE `entryorguid`=16522 AND `id`=11;
-UPDATE `smart_scripts` SET `event_phase_mask`=1, `action_param1`=1 WHERE entryorguid=16522 AND `id`=9;
-UPDATE `smart_scripts` SET `event_flags`=1 WHERE `entryorguid`=16522 AND `id`=2;
-UPDATE `creature_template` SET `InhabitType`=4 WHERE `Entry`=17947;
diff --git a/sql/updates/world/2015_05_22_13_world.sql b/sql/updates/world/2015_05_22_13_world.sql
deleted file mode 100644
index db90e99cf4d..00000000000
--- a/sql/updates/world/2015_05_22_13_world.sql
+++ /dev/null
@@ -1,51 +0,0 @@
---
-UPDATE `creature` SET `position_x`=-4435.777, `position_y`=-13684.191, `position_z`=44.03, `orientation`= 5.189 WHERE `guid`=57310;
-UPDATE `creature` SET `MovementType`=2, `spawndist`=0 WHERE `guid` IN (57310, 57313);
-DELETE FROM `creature_addon` WHERE `guid` IN  (57310, 57313);
-INSERT INTO `creature_addon` (`guid`, `path_id`) VALUES (57310, 573100), (57313, 573130);
-DELETE FROM `waypoint_data` WHERE `id` IN (573100, 573130);
-INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES
-(573100, 1, -4443.440918, -13695.226563, 46.834724, 0, 0, 0, 0, 100, 0),
-(573100, 2, -4451.548828, -13708.859375, 48.496380, 0, 0, 0, 0, 100, 0),
-(573100, 3, -4431.984863, -13722.603516, 51.757404, 0, 0, 0, 0, 100, 0),
-(573100, 4, -4385.404297, -13720.467773, 50.135044, 0, 0, 0, 0, 100, 0),
-(573100, 5, -4380.465820, -13740.443359, 50.451973, 0, 0, 0, 0, 100, 0),
-(573100, 6, -4392.348633, -13770.427734, 52.292049, 0, 0, 0, 0, 100, 0),
-(573100, 7, -4391.951660, -13786.277344, 52.664742, 0, 0, 0, 0, 100, 0),
-(573100, 8, -4396.321777, -13804.233398, 55.976879, 0, 0, 0, 0, 100, 0),
-(573100, 9, -4404.731934, -13815.549805, 60.186996, 0, 0, 0, 0, 100, 0),
-(573100, 10, -4409.673828, -13847.877930, 71.870178, 0, 0, 0, 0, 100, 0),
-(573100, 11, -4419.165527, -13854.147461, 78.347191, 0, 0, 0, 0, 100, 0),
-(573100, 12, -4432.236816, -13856.821289, 85.815552, 0, 0, 0, 0, 100, 0),
-(573100, 13, -4453.323730, -13875.177734, 101.67051, 0, 0, 0, 0, 100, 0),
-(573100, 14, -4432.236816, -13856.821289, 85.815552, 0, 0, 0, 0, 100, 0),
-(573100, 15, -4419.165527, -13854.147461, 78.347191, 0, 0, 0, 0, 100, 0),
-(573100, 16, -4409.673828, -13847.877930, 71.870178, 0, 0, 0, 0, 100, 0),
-(573100, 17, -4404.731934, -13815.549805, 60.186996, 0, 0, 0, 0, 100, 0),
-(573100, 18, -4396.321777, -13804.233398, 55.976879, 0, 0, 0, 0, 100, 0),
-(573100, 19, -4391.951660, -13786.277344, 52.664742, 0, 0, 0, 0, 100, 0),
-(573100, 20, -4392.348633, -13770.427734, 52.292049, 0, 0, 0, 0, 100, 0),
-(573100, 21, -4380.465820, -13740.443359, 50.451973, 0, 0, 0, 0, 100, 0),
-(573100, 22, -4385.404297, -13720.467773, 50.135044, 0, 0, 0, 0, 100, 0),
-(573100, 23, -4431.984863, -13722.603516, 51.757404, 0, 0, 0, 0, 100, 0),
-(573100, 24, -4451.548828, -13708.859375, 48.496380, 0, 0, 0, 0, 100, 0),
-(573100, 25, -4443.440918, -13695.226563, 46.834724, 0, 0, 0, 0, 100, 0),
-(573130, 1, -4393.079102, -13790.173828, 52.869942, 0, 0, 0, 0, 100, 0),
-(573130, 2, -4392.134766, -13761.565430, 51.793087, 0, 0, 0, 0, 100, 0),
-(573130, 3, -4412.633301, -13752.276367, 53.840073, 0, 0, 0, 0, 100, 0),
-(573130, 4, -4429.812012, -13722.834961, 51.848553, 0, 0, 0, 0, 100, 0),
-(573130, 5, -4389.571777, -13722.364258, 50.288551, 0, 0, 0, 0, 100, 0),
-(573130, 6, -4380.811523, -13731.546875, 50.451256, 0, 0, 0, 0, 100, 0),
-(573130, 7, -4385.900391, -13759.079102, 50.621365, 0, 0, 0, 0, 100, 0),
-(573130, 8, -4391.487305, -13762.515625, 51.752522, 0, 0, 0, 0, 100, 0),
-(573130, 9, -4403.406250, -13758.519531, 53.117504, 0, 0, 0, 0, 100, 0),
-(573130, 10, -4432.480469, -13756.059570, 56.591385, 0, 0, 0, 0, 100, 0),
-(573130, 11, -4403.406250, -13758.519531, 53.117504, 0, 0, 0, 0, 100, 0),
-(573130, 12, -4391.487305, -13762.515625, 51.752522, 0, 0, 0, 0, 100, 0),
-(573130, 13, -4385.900391, -13759.079102, 50.621365, 0, 0, 0, 0, 100, 0),
-(573130, 14, -4380.811523, -13731.546875, 50.451256, 0, 0, 0, 0, 100, 0),
-(573130, 15, -4389.571777, -13722.364258, 50.288551, 0, 0, 0, 0, 100, 0),
-(573130, 16, -4429.812012, -13722.834961, 51.848553, 0, 0, 0, 0, 100, 0),
-(573130, 17, -4412.633301, -13752.276367, 53.840073, 0, 0, 0, 0, 100, 0),
-(573130, 18, -4392.134766, -13761.565430, 51.793087, 0, 0, 0, 0, 100, 0),
-(573130, 19, -4393.079102, -13790.173828, 52.869942, 0, 0, 0, 0, 100, 0);
diff --git a/sql/updates/world/2015_05_22_14_world.sql b/sql/updates/world/2015_05_22_14_world.sql
deleted file mode 100644
index 43bbacd2d1a..00000000000
--- a/sql/updates/world/2015_05_22_14_world.sql
+++ /dev/null
@@ -1,4 +0,0 @@
---
-DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=1 AND `SourceEntry`=6994;
-INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorTextId`,`Scriptname`,`Comment`) VALUES
-(1,641,6994,0,0,2,0,51315,1,1,1,0 ,'' , 'whitestone oak lumber drop only if the player doesn''t have it already');
diff --git a/sql/updates/world/2015_05_23_00_world.sql b/sql/updates/world/2015_05_23_00_world.sql
deleted file mode 100644
index 914b721b2ed..00000000000
--- a/sql/updates/world/2015_05_23_00_world.sql
+++ /dev/null
@@ -1,4 +0,0 @@
---
-UPDATE `creature_template` SET `npcflag`=3, `gossip_menu_id`=4047 WHERE `entry`=658;
-DELETE FROM `gossip_menu` WHERE `entry`=4047;
-INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (4047, 4937);
diff --git a/sql/updates/world/2015_05_23_01_world.sql b/sql/updates/world/2015_05_23_01_world.sql
deleted file mode 100644
index 44c17b81f48..00000000000
--- a/sql/updates/world/2015_05_23_01_world.sql
+++ /dev/null
@@ -1,2 +0,0 @@
---
-UPDATE `creature_template` SET `gossip_menu_id`=21212 WHERE `entry`=13000;
diff --git a/sql/updates/world/2015_05_24_00_world.sql b/sql/updates/world/2015_05_24_00_world.sql
deleted file mode 100644
index 946c20339cb..00000000000
--- a/sql/updates/world/2015_05_24_00_world.sql
+++ /dev/null
@@ -1,170 +0,0 @@
--- Gnomeregan Scripts
--- Irradiated Pillager SAI
-SET @ENTRY := 6329;
-UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
-(@ENTRY,0,0,0,25,0,100,0,0,0,0,0,75,9798,0,0,0,0,0,1,0,0,0,0,0,0,0,"Irradiated Pillager - On Reset - Add Aura 'Radiation'"),
-(@ENTRY,0,1,0,0,0,100,0,3000,5000,10000,11000,11,9771,64,0,0,0,0,17,0,50,0,0,0,0,0,"Irradiated Pillager - In Combat CMC - Cast 'Radiation Bolt'"),
-(@ENTRY,0,2,0,2,0,100,1,0,40,0,0,11,8269,2,0,0,0,0,1,0,0,0,0,0,0,0,"Irradiated Pillager - Between 0-40% Health - Cast 'Frenzy' (No Repeat)");
-
--- Caverndeep Ambusher SAI
-SET @ENTRY := 6207;
-UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
-(@ENTRY,0,0,0,0,0,100,0,3700,3700,3600,12400,11,2590,0,0,0,0,0,2,0,0,0,0,0,0,0,"Caverndeep Ambusher - In Combat - Cast 'Backstab'");
-
--- Caverndeep Burrower SAI
-SET @ENTRY := 6206;
-UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
-(@ENTRY,0,0,0,0,0,100,0,3000,5000,9000,13000,11,1604,0,0,0,0,0,2,0,0,0,0,0,0,0,"Caverndeep Burrower - In Combat - Cast 'Dazed'"),
-(@ENTRY,0,1,0,0,0,100,0,2000,4000,4000,6000,11,9770,64,0,0,0,0,2,0,0,0,0,0,0,0,"Caverndeep Burrower - In Combat CMC - Cast 'Radiation'"),
-(@ENTRY,0,2,0,0,0,100,0,6000,7000,4000,8000,11,16145,0,0,0,0,0,2,0,0,0,0,0,0,0,"Caverndeep Burrower - In Combat - Cast 'Sunder Armor'"),
-(@ENTRY,0,3,0,2,0,100,1,0,15,0,0,25,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Caverndeep Burrower - Between 0-15% Health - Flee For Assist (No Repeat)");
-
--- Irradiated Slime SAI
-SET @ENTRY := 6218;
-UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
-(@ENTRY,0,0,0,0,0,100,1,1000,2000,0,0,75,10341,0,0,0,0,0,1,0,0,0,0,0,0,0,"Irradiated Slime - In Combat - Add Aura 'Radiation Cloud'"),
-(@ENTRY,0,1,0,0,0,100,0,2000,9000,11000,14000,11,9459,0,0,0,0,0,17,0,50,0,0,0,0,0,"Irradiated Slime - In Combat - Cast 'Corrosive Ooze'"),
-(@ENTRY,0,2,0,0,0,100,0,4000,6000,8000,9000,11,1604,64,0,0,0,0,2,0,0,0,0,0,0,0,"Irradiated Slime - In Combat CMC - Cast 'Dazed'");
-
--- Irradiated Horror SAI
-SET @ENTRY := 6220;
-UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
-(@ENTRY,0,0,0,0,0,100,1,1000,2000,0,0,75,10341,0,0,0,0,0,1,0,0,0,0,0,0,0,"Irradiated Horror - In Combat - Add Aura 'Radiation Cloud' (No Repeat)"),
-(@ENTRY,0,1,0,0,0,100,0,4000,5000,10000,12000,11,8211,0,0,0,0,0,2,0,0,0,0,0,0,0,"Irradiated Horror - In Combat - Cast 'Chain Burn'"),
-(@ENTRY,0,2,0,0,0,100,0,2000,9000,11000,14000,11,9459,0,0,0,0,0,17,0,50,0,0,0,0,0,"Irradiated Horror - In Combat - Cast 'Corrosive Ooze'"),
-(@ENTRY,0,3,0,0,0,100,0,4000,6000,8000,9000,11,1604,64,0,0,0,0,2,0,0,0,0,0,0,0,"Irradiated Horror - In Combat CMC - Cast 'Dazed'");
-
--- Corrosive Lurker SAI
-SET @ENTRY := 6219;
-UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
-(@ENTRY,0,0,0,0,0,100,1,1000,2000,0,0,75,10341,0,0,0,0,0,1,0,0,0,0,0,0,0,"Corrosive Lurker - In Combat - Add Aura 'Radiation Cloud' (No Repeat)"),
-(@ENTRY,0,1,0,0,0,100,0,2000,9000,11000,14000,11,9459,0,0,0,0,0,17,0,50,0,0,0,0,0,"Corrosive Lurker - In Combat - Cast 'Corrosive Ooze'"),
-(@ENTRY,0,2,0,0,0,100,0,4000,6000,8000,9000,11,1604,64,0,0,0,0,2,0,0,0,0,0,0,0,"Corrosive Lurker - In Combat CMC - Cast 'Dazed'");
-
-UPDATE `creature` SET `spawndist`=20, `MovementType`=1 WHERE  `guid`=30137;
-
--- Viscous Fallout SAI
-SET @ENTRY := 7079;
-UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
-(@ENTRY,0,0,0,0,0,100,1,1000,2000,0,0,75,10341,2,0,0,0,0,1,0,0,0,0,0,0,0,"Viscous Fallout - In Combat - Add Aura 'Radiation Cloud'"),
-(@ENTRY,0,1,0,0,0,100,0,2000,9000,11000,14000,11,9459,64,0,0,0,0,17,0,50,0,0,0,0,0,"Viscous Fallout - In Combat CMC - Cast 'Corrosive Ooze'");
-
--- Mechanized Sentry SAI
-SET @ENTRY := 6233;
-UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
-(@ENTRY,0,0,0,0,0,100,0,3000,5000,8000,9000,11,1604,0,0,0,0,0,2,0,0,0,0,0,0,0,"Mechanized Sentry - In Combat - Cast 'Dazed'");
-
--- Leprous Defender SAI
-SET @ENTRY := 6223;
-UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
-(@ENTRY,0,0,0,0,0,100,0,1000,1500,2300,3900,11,6660,64,0,0,0,0,2,0,0,0,0,0,0,0,"Leprous Defender - Combat CMC - Cast 'Shoot'"),
-(@ENTRY,0,1,0,9,0,100,0,5,30,7000,9000,11,14443,0,0,0,0,0,2,0,0,0,0,0,0,0,"Leprous Defender - Within 5-30 Range - Cast 'Multi-Shot'"),
-(@ENTRY,0,2,0,9,0,100,0,5,30,9000,11000,11,5116,0,0,0,0,0,2,0,0,0,0,0,0,0,"Leprous Defender - Within 5-30 Range - Cast 'Concussive Shot'"),
-(@ENTRY,0,3,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Leprous Defender - Between 0-15% Health - Flee For Assist (No Repeat)");
-
--- Leprous Technician SAI
-SET @ENTRY := 6222;
-UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
-(@ENTRY,0,0,0,4,0,100,0,0,0,0,0,11,12024,64,0,0,0,0,2,0,0,0,0,0,0,0,"Leprous Technician - On Aggro CMC - Cast 'Net'"),
-(@ENTRY,0,1,0,0,0,100,0,2000,6000,8000,9000,11,1604,0,0,0,0,0,2,0,0,0,0,0,0,0,"Leprous Technician - In Combat - Cast 'Dazed'"),
-(@ENTRY,0,2,0,0,0,100,0,2000,5000,6000,8000,11,13398,64,0,0,0,0,21,30,0,0,0,0,0,0,"Leprous Technician - In Combat CMC - Cast 'Throw Wrench'");
-
--- Mechano-Tank SAI
-SET @ENTRY := 6225;
-UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
-(@ENTRY,0,0,0,0,0,100,0,5,30,2300,3900,11,1604,64,0,0,0,0,2,0,0,0,0,0,0,0,"Mechano-Tank - Combat CMC - Cast 'Dazed'"),
-(@ENTRY,0,1,0,9,0,100,0,5,30,7000,9000,11,10346,0,0,0,0,0,2,0,0,0,0,0,0,0,"Mechano-Tank - Within 5-30 Range - Cast 'Multi-Shot'"),
-(@ENTRY,0,2,0,9,0,100,0,5,30,9000,11000,11,5116,0,0,0,0,0,2,0,0,0,0,0,0,0,"Mechano-Tank - Within 5-30 Range - Cast 'Concussive Shot'"),
-(@ENTRY,0,3,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Mechano-Tank - Between 0-15% Health - Flee For Assist (No Repeat)");
-
--- Peacekeeper Security Suit SAI
-SET @ENTRY := 6230;
-UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
-(@ENTRY,0,0,0,0,0,100,0,5000,6000,6000,8000,11,6533,64,0,0,0,0,2,0,0,0,0,0,0,0,"Peacekeeper Security Suit - In Combat CMC - Cast 'Net'"),
-(@ENTRY,0,1,0,0,0,50,0,5000,6000,14000,16000,11,10730,0,0,0,0,0,2,0,0,0,0,0,0,0,"Peacekeeper Security Suit - In Combat - Cast 'Pacify'");
-
--- Mechanized Guardian SAI
-SET @ENTRY := 6234;
-UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
-(@ENTRY,0,0,0,0,0,100,0,2000,5000,6000,7000,11,1604,0,0,0,0,0,2,0,0,0,0,0,0,0,"Mechanized Guardian - In Combat - Cast 'Dazed'"),
-(@ENTRY,0,1,0,0,0,100,0,3000,6000,6000,7000,11,11820,0,0,0,0,0,21,40,0,0,0,0,0,0,"Mechanized Guardian - In Combat - Cast 'Field'");
-
--- Mechano-Flamewalker SAI
-SET @ENTRY := 6226;
-UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
-(@ENTRY,0,0,0,0,0,100,0,2000,6000,6000,10000,11,11306,64,0,0,0,0,1,0,0,0,0,0,0,0,"Mechano-Flamewalker - In Combat CMC - Cast 'Fire Nova'"),
-(@ENTRY,0,1,0,0,0,100,0,3000,6000,10000,12000,11,10733,0,0,0,0,0,2,0,0,0,0,0,0,0,"Mechano-Flamewalker - In Combat - Cast 'Flame Spray'");
-
--- Mechano-Frostwalker SAI
-SET @ENTRY := 6227;
-UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
-(@ENTRY,0,0,0,2,0,100,1,0,40,0,0,11,22519,2,0,0,0,0,1,0,0,0,0,0,0,0,"Mechano-Frostwalker - Between 0-40% Health - Cast 'Ice Nova' (No Repeat)"),
-(@ENTRY,0,1,0,0,0,100,0,2000,6000,8000,9000,11,11264,64,0,0,0,0,1,0,0,0,0,0,0,0,"Mechano-Frostwalker - In Combat CMC - Cast 'Ice Blast'");
-
--- Caverndeep Reaver SAI
-SET @ENTRY := 6211;
-UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
-(@ENTRY,0,0,0,4,0,100,1,0,0,0,0,11,7366,2,0,0,0,0,1,0,0,0,0,0,0,0,"Caverndeep Reaver - On Aggro - Cast 'Berserker Stance' (No Repeat)"),
-(@ENTRY,0,1,0,0,0,100,0,2000,6000,5000,8000,11,8374,2,0,0,0,0,2,0,0,0,0,0,0,0,"Caverndeep Reaver - In Combat - Cast 'Arcing Smash'"),
-(@ENTRY,0,2,0,0,0,100,0,4000,4000,4000,4000,11,845,2,0,0,0,0,2,0,0,0,0,0,0,0,"Caverndeep Reaver - In Combat - Cast 'Cleave'");
-
--- Holdout Medic SAI
-SET @ENTRY := 6392;
-UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
-(@ENTRY,0,0,0,2,0,100,1,0,60,0,0,11,22167,0,0,0,0,0,1,0,0,0,0,0,0,0,"Holdout Medic - Between 0-60% Health - Cast 'Heal' (No Repeat)"),
-(@ENTRY,0,1,0,4,0,100,1,0,0,0,0,11,22168,64,0,0,0,0,1,0,0,0,0,0,0,0,"Holdout Medic - On Aggro CMC - Cast 'Renew' (No Repeat)"),
-(@ENTRY,0,2,0,1,0,100,0,5000,5000,8000,10000,11,22167,0,0,0,0,0,1,0,0,0,0,0,0,0,"Holdout Medic - Out of Combat - Cast 'Heal'"),
-(@ENTRY,0,3,0,1,0,100,0,4000,10000,15000,20000,11,22168,0,0,0,0,0,1,0,0,0,0,0,0,0,"Holdout Medic - Out of Combat - Cast 'Renew'");
-
--- Walking Bomb SAI
-SET @ENTRY := 7915;
-UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
-(@ENTRY,0,0,0,0,0,100,3,0,0,15000,15000,11,11504,0,0,0,0,0,1,0,0,0,0,0,0,0,"Walking Bomb - In Combat - Cast 'Walking Bomb Effect' (No Repeat) (Normal Dungeon)");
-
-UPDATE `creature` SET `spawndist`=20, `MovementType`=1 WHERE  `guid`=30133;
-
--- Leprous Machinesmith SAI
-SET @ENTRY := 6224;
-UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
-(@ENTRY,0,0,0,0,0,100,0,4000,5000,20000,25000,11,10732,0,0,0,0,0,19,6224,50,0,0,0,0,0,"Leprous Machinesmith - In Combat - Cast 'Supercharge'"),
-(@ENTRY,0,1,0,0,0,100,0,2000,5000,4000,6000,11,13398,64,0,0,0,0,21,30,0,0,0,0,0,0,"Leprous Machinesmith - In Combat CMC - Cast 'Throw Wrench'"),
-(@ENTRY,0,2,0,2,0,100,1,0,90,0,0,11,10348,0,0,0,0,0,1,0,0,0,0,0,0,0,"Leprous Machinesmith - Between 0-90% Health - Cast 'Tune Up' (No Repeat)");
-
diff --git a/sql/updates/world/2015_05_24_02_world.sql b/sql/updates/world/2015_05_24_02_world.sql
deleted file mode 100644
index 7f8cd3a457f..00000000000
--- a/sql/updates/world/2015_05_24_02_world.sql
+++ /dev/null
@@ -1,16 +0,0 @@
--- The Farstrider Lodge flavor texts
-DELETE FROM `gossip_menu` WHERE `text_id` IN (3522, 3525, 3495);
-INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES 
-(2831, 3522),
-(2831, 3525),
-(2801, 3495);
-
--- 
-DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceEntry` IN (3522, 3525, 3495, 3523) AND `ConditionTypeOrReference` IN (8);
-INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
-(14, 2831, 3523, 0, 0, 8, 0, 258, 0, 0, 1, 0, 0, '', 'Show gossip text if player has quest 258 not completed'),
-(14, 2831, 3522, 0, 0, 8, 0, 258, 0, 0, 0, 0, 0, '', 'Show gossip text if player has quest 258 completed'),
-(14, 2831, 3525, 0, 0, 8, 0, 271, 0, 0, 0, 0, 0, '', 'Show gossip text if player has quest 271 completed'),
-(14, 2801, 3495, 0, 0, 8, 0, 385, 0, 0, 0, 0, 0, '', 'Show gossip text if player has quest 385 completed');
-
-UPDATE `npc_text` SET `BroadcastTextID0`=5854 WHERE `id`=3522;
diff --git a/sql/updates/world/2015_05_24_03_world.sql b/sql/updates/world/2015_05_24_03_world.sql
deleted file mode 100644
index e4283fae295..00000000000
--- a/sql/updates/world/2015_05_24_03_world.sql
+++ /dev/null
@@ -1,13 +0,0 @@
--- 
--- Grizzly Hills Giant SAI
-SET @ENTRY := 26261;
-UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
-(@ENTRY,0,0,1,8,0,100,0,47394,0,0,0,80,26261,0,0,0,0,0,1,0,0,0,0,0,0,0,"Grizzly Hills Giant - On Spellhit 'Kurun's Blessing' - Run Script"),
-(@ENTRY,0,1,0,61,0,100,0,47394,0,0,0,33,26261,0,0,0,0,0,7,0,0,0,0,0,0,0,"Grizzly Hills Giant - On Spellhit 'Kurun's Blessing' - Quest Credit 'Rallying the Troops'"),
-(@ENTRY,0,2,0,1,0,100,0,2000,5000,4000,6000,11,46815,0,0,0,0,0,19,26264,500,0,0,0,0,0,"Grizzly Hills Giant - Out of Combat - Cast 'Toss Boulder'");
-
-DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND  `SourceGroup`=1 AND `SourceEntry`=46815;
-INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
-(13, 1, 46815, 0, 0, 31, 0, 3, 26264, 0, 0, 0, 0, '', 'Toss Boulder - only targets Dummy');
diff --git a/sql/updates/world/2015_05_24_04_world.sql b/sql/updates/world/2015_05_24_04_world.sql
deleted file mode 100644
index 70cc65fb490..00000000000
--- a/sql/updates/world/2015_05_24_04_world.sql
+++ /dev/null
@@ -1,902 +0,0 @@
--- Complete Grizzlyhills Movement
-DELETE FROM `creature_addon` WHERE `guid` IN (109382, 109390,109409,110794, 110792,110787,110793, 110791,110797,110796,110795,110799,110798, 110801,98066, 98056, 98060, 118835, 98047, 98059, 98053);
-INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES 
-(118835,0,0,1,1,0, ''),
-(98047,0,0,1,1,0, ''),
-(98059,0,0,0,1,69, ''),
-(98060,0,0,0,1,234, ''),
-(98053,0,0,0,1,1, ''),
-(98056,0,0,0,1,234, ''),
-(98066,0,0,0,1,234, ''),
-(110801,0,0,0,1,234, ''),
-(110798,0,0,0,1,234, ''),
-(110799,0,0,0,1,234, ''),
-(110795,0,0,0,1,234, ''),
-(110796,0,0,0,1,234, ''),
-(110797,0,0,0,1,234, ''),
-(110791,0,0,0,1,234, ''),
-(110793,0,0,0,1,234, ''),
-(110787,0,0,0,1,234, ''),
-(110792,0,0,0,1,234, ''),
-(110794,0,0,0,1,234, ''),
-(109409,0,0,8,1,0, ''),
-(109390,0,0,8,1,0, ''),
-(109382,0,0,8,1,0, '');
-
-SET @NPC := 109402;
-SET @PATH := @NPC * 10;
-UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4642.88,`position_y`=-5573.969,`position_z`=43.38401 WHERE `guid`=@NPC;
-DELETE FROM `creature_addon` WHERE `guid`=@NPC;
-INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
-DELETE FROM `waypoint_data` WHERE `id`=@PATH;
-INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-(@PATH,1,4642.88,-5573.969,43.38401,0,0,0,0,100,0),
-(@PATH,2,4642.38,-5575.719,43.63401,0,0,0,0,100,0),
-(@PATH,3,4639.13,-5580.469,42.88401,0,0,0,0,100,0),
-(@PATH,4,4637.13,-5583.719,41.63401,0,0,0,0,100,0),
-(@PATH,5,4635.38,-5586.219,40.38401,0,0,0,0,100,0),
-(@PATH,6,4635.204,-5586.526,40.13166,0,0,0,0,100,0),
-(@PATH,7,4634.204,-5587.776,39.63166,0,0,0,0,100,0),
-(@PATH,8,4633.204,-5587.776,38.88166,0,0,0,0,100,0),
-(@PATH,9,4632.204,-5588.026,38.13166,0,0,0,0,100,0),
-(@PATH,10,4631.204,-5588.026,37.63166,0,0,0,0,100,0),
-(@PATH,11,4630.204,-5588.026,36.88166,0,0,0,0,100,0),
-(@PATH,12,4629.204,-5588.026,36.38166,0,0,0,0,100,0),
-(@PATH,13,4628.204,-5588.026,35.63166,0,0,0,0,100,0),
-(@PATH,14,4626.204,-5588.026,35.13166,0,0,0,0,100,0),
-(@PATH,15,4625.204,-5588.026,34.38166,0,0,0,0,100,0),
-(@PATH,16,4624.204,-5588.026,33.88166,0,0,0,0,100,0),
-(@PATH,17,4623.454,-5588.026,33.38166,0,0,0,0,100,0),
-(@PATH,18,4622.454,-5588.276,32.88166,0,0,0,0,100,0),
-(@PATH,19,4621.454,-5588.276,32.13166,0,0,0,0,100,0),
-(@PATH,20,4620.454,-5588.276,31.63166,0,0,0,0,100,0),
-(@PATH,21,4618.454,-5588.276,30.38166,0,0,0,0,100,0),
-(@PATH,22,4616.454,-5588.276,29.63166,0,0,0,0,100,0),
-(@PATH,23,4615.454,-5588.276,28.88166,0,0,0,0,100,0),
-(@PATH,24,4613.454,-5588.276,27.88166,0,0,0,0,100,0),
-(@PATH,25,4615.112,-5588.271,28.6151,0,0,0,0,100,0),
-(@PATH,26,4613.112,-5588.271,27.6151,0,0,0,0,100,0),
-(@PATH,27,4612.612,-5588.271,27.3651,0,0,0,0,100,0),
-(@PATH,28,4609.862,-5587.021,25.8651,0,0,0,0,100,0),
-(@PATH,29,4608.112,-5586.021,24.8651,0,0,0,0,100,0),
-(@PATH,30,4606.362,-5585.021,24.1151,0,0,0,0,100,0),
-(@PATH,31,4604.612,-5584.021,22.8651,0,0,0,0,100,0),
-(@PATH,32,4602.862,-5583.021,21.6151,0,0,0,0,100,0),
-(@PATH,33,4601.112,-5582.021,20.8651,0,0,0,0,100,0),
-(@PATH,34,4599.362,-5581.021,19.3651,0,0,0,0,100,0),
-(@PATH,35,4597.612,-5580.021,18.3651,0,0,0,0,100,0),
-(@PATH,36,4595.362,-5578.521,16.8651,0,0,0,0,100,0),
-(@PATH,37,4593.612,-5577.771,15.6151,0,0,0,0,100,0),
-(@PATH,38,4591.862,-5576.771,14.6151,0,0,0,0,100,0),
-(@PATH,39,4590.112,-5575.771,13.8651,0,0,0,0,100,0),
-(@PATH,40,4588.362,-5574.771,13.1151,0,0,0,0,100,0),
-(@PATH,41,4586.612,-5573.771,12.1151,0,0,0,0,100,0),
-(@PATH,42,4584.862,-5572.771,11.6151,0,0,0,0,100,0),
-(@PATH,43,4583.112,-5571.771,10.8651,0,0,0,0,100,0),
-(@PATH,44,4580.612,-5570.271,10.1151,0,0,0,0,100,0),
-(@PATH,45,4578.862,-5569.271,9.365101,0,0,0,0,100,0),
-(@PATH,46,4578.588,-5569.066,9.268532,0,0,0,0,100,0),
-(@PATH,47,4577.088,-5568.316,8.768532,0,0,0,0,100,0),
-(@PATH,48,4575.838,-5565.566,7.768532,0,0,0,0,100,0),
-(@PATH,49,4575.338,-5563.816,7.018532,0,0,0,0,100,0),
-(@PATH,50,4574.588,-5562.066,6.518532,0,0,0,0,100,0),
-(@PATH,51,4573.588,-5560.316,5.768532,0,0,0,0,100,0),
-(@PATH,52,4572.338,-5557.566,5.018532,0,0,0,0,100,0),
-(@PATH,53,4572.302,-5557.273,4.829211,0,0,0,0,100,0),
-(@PATH,54,4571.052,-5554.523,4.079211,0,0,0,0,100,0),
-(@PATH,55,4570.302,-5551.523,3.579211,0,0,0,0,100,0),
-(@PATH,56,4569.302,-5544.773,3.079211,0,0,0,0,100,0),
-(@PATH,57,4565.425,-5523.652,2.546694,0,0,0,0,100,0),
-(@PATH,58,4558.431,-5505.637,2.508454,0,0,0,0,100,0),
-(@PATH,59,4558.492,-5505.963,2.279056,0,0,0,0,100,0),
-(@PATH,60,4558.656,-5505.855,2.526844,0,0,0,0,100,0),
-(@PATH,61,4565.748,-5523.84,2.603909,0,0,0,0,100,0),
-(@PATH,62,4569.748,-5548.34,3.103909,0,0,0,0,100,0),
-(@PATH,63,4570.498,-5552.09,3.603909,0,0,0,0,100,0),
-(@PATH,64,4571.125,-5554.945,4.307666,0,0,0,0,100,0),
-(@PATH,65,4572.375,-5557.695,5.057666,0,0,0,0,100,0),
-(@PATH,66,4573.375,-5559.445,5.807666,0,0,0,0,100,0),
-(@PATH,67,4574.375,-5561.945,6.307666,0,0,0,0,100,0),
-(@PATH,68,4575.125,-5563.695,7.057666,0,0,0,0,100,0),
-(@PATH,69,4575.875,-5565.445,7.807666,0,0,0,0,100,0),
-(@PATH,70,4577.315,-5568.442,8.979671,0,0,0,0,100,0),
-(@PATH,71,4580.065,-5569.942,9.979671,0,0,0,0,100,0),
-(@PATH,72,4581.815,-5570.942,10.72967,0,0,0,0,100,0),
-(@PATH,73,4584.315,-5572.442,11.47967,0,0,0,0,100,0),
-(@PATH,74,4586.065,-5573.442,12.22967,0,0,0,0,100,0),
-(@PATH,75,4587.815,-5574.442,12.97967,0,0,0,0,100,0),
-(@PATH,76,4589.565,-5575.442,13.72967,0,0,0,0,100,0),
-(@PATH,77,4591.315,-5576.442,14.72967,0,0,0,0,100,0),
-(@PATH,78,4593.065,-5577.442,15.72967,0,0,0,0,100,0),
-(@PATH,79,4594.565,-5578.192,16.47967,0,0,0,0,100,0),
-(@PATH,80,4596.315,-5579.192,17.47967,0,0,0,0,100,0),
-(@PATH,81,4598.065,-5580.192,18.72967,0,0,0,0,100,0),
-(@PATH,82,4599.815,-5581.192,19.72967,0,0,0,0,100,0),
-(@PATH,83,4601.565,-5582.192,20.97967,0,0,0,0,100,0),
-(@PATH,84,4603.315,-5583.192,21.97967,0,0,0,0,100,0),
-(@PATH,85,4605.065,-5583.942,22.72967,0,0,0,0,100,0),
-(@PATH,86,4606.815,-5584.942,24.22967,0,0,0,0,100,0),
-(@PATH,87,4609.315,-5586.442,25.47967,0,0,0,0,100,0),
-(@PATH,88,4611.065,-5587.442,26.72967,0,0,0,0,100,0),
-(@PATH,89,4611.174,-5587.652,26.94344,0,0,0,0,100,0),
-(@PATH,90,4612.674,-5588.402,27.69344,0,0,0,0,100,0),
-(@PATH,91,4615.674,-5588.402,28.94344,0,0,0,0,100,0),
-(@PATH,92,4616.674,-5588.402,29.69344,0,0,0,0,100,0),
-(@PATH,93,4618.674,-5588.152,30.44344,0,0,0,0,100,0),
-(@PATH,94,4619.674,-5588.152,31.19344,0,0,0,0,100,0),
-(@PATH,95,4621.674,-5588.152,32.19344,0,0,0,0,100,0),
-(@PATH,96,4622.424,-5588.152,32.94344,0,0,0,0,100,0),
-(@PATH,97,4623.424,-5588.152,33.19344,0,0,0,0,100,0),
-(@PATH,98,4624.424,-5588.152,33.94344,0,0,0,0,100,0),
-(@PATH,99,4625.424,-5588.152,34.44344,0,0,0,0,100,0),
-(@PATH,100,4626.424,-5588.152,35.19344,0,0,0,0,100,0),
-(@PATH,101,4627.424,-5588.152,35.69344,0,0,0,0,100,0),
-(@PATH,102,4628.424,-5588.152,36.44344,0,0,0,0,100,0),
-(@PATH,103,4629.424,-5587.902,36.94344,0,0,0,0,100,0),
-(@PATH,104,4630.424,-5587.902,37.69344,0,0,0,0,100,0),
-(@PATH,105,4631.424,-5587.902,38.19344,0,0,0,0,100,0),
-(@PATH,106,4632.424,-5587.902,38.94344,0,0,0,0,100,0),
-(@PATH,107,4633.424,-5587.902,39.44344,0,0,0,0,100,0),
-(@PATH,108,4632.743,-5587.937,39.25474,0,0,0,0,100,0),
-(@PATH,109,4633.743,-5587.937,39.75474,0,0,0,0,100,0),
-(@PATH,110,4634.243,-5587.937,40.00474,0,0,0,0,100,0),
-(@PATH,111,4635.993,-5585.437,40.75474,0,0,0,0,100,0),
-(@PATH,112,4636.993,-5583.687,41.50474,0,0,0,0,100,0),
-(@PATH,113,4638.493,-5581.437,42.25474,0,0,0,0,100,0),
-(@PATH,114,4640.743,-5578.187,43.50474,0,0,0,0,100,0),
-(@PATH,115,4641.032,-5577.918,43.48087,0,0,0,0,100,0),
-(@PATH,116,4642.532,-5575.418,43.48087,0,0,0,0,100,0),
-(@PATH,117,4643.532,-5572.418,42.98087,0,0,0,0,100,0),
-(@PATH,118,4644.032,-5570.668,42.23087,0,0,0,0,100,0),
-(@PATH,119,4644.532,-5567.668,41.23087,0,0,0,0,100,0),
-(@PATH,120,4645.032,-5565.668,40.23087,0,0,0,0,100,0),
-(@PATH,121,4645.532,-5564.168,38.98087,0,0,0,0,100,0),
-(@PATH,122,4646.032,-5562.168,37.98087,0,0,0,0,100,0),
-(@PATH,123,4646.532,-5560.168,36.98087,0,0,0,0,100,0),
-(@PATH,124,4647.032,-5558.168,35.98087,0,0,0,0,100,0),
-(@PATH,125,4647.782,-5555.418,35.23087,0,0,0,0,100,0),
-(@PATH,126,4648.282,-5553.418,34.48087,0,0,0,0,100,0),
-(@PATH,127,4648.611,-5553.267,34.28629,0,0,0,0,100,0),
-(@PATH,128,4648.861,-5552.517,33.78629,0,0,0,0,100,0),
-(@PATH,129,4649.361,-5550.767,33.03629,0,0,0,0,100,0),
-(@PATH,130,4650.361,-5547.767,32.28629,0,0,0,0,100,0),
-(@PATH,131,4651.111,-5546.017,31.78629,0,0,0,0,100,0),
-(@PATH,132,4651.611,-5544.267,31.28629,0,0,0,0,100,0),
-(@PATH,133,4652.111,-5542.517,30.78629,0,0,0,0,100,0),
-(@PATH,134,4653.611,-5538.767,30.03629,0,0,0,0,100,0),
-(@PATH,135,4654.861,-5534.767,29.53629,0,0,0,0,100,0),
-(@PATH,136,4655.176,-5534.61,29.14608,0,0,0,0,100,0),
-(@PATH,137,4655.426,-5533.86,29.14608,0,0,0,0,100,0),
-(@PATH,138,4658.176,-5528.61,28.39608,0,0,0,0,100,0),
-(@PATH,139,4661.176,-5522.61,28.14608,0,0,0,0,100,0),
-(@PATH,140,4663.296,-5518.52,27.41638,0,0,0,0,100,0),
-(@PATH,141,4666.796,-5515.52,26.66638,0,0,0,0,100,0),
-(@PATH,142,4667.602,-5514.735,26.7351,0,0,0,0,100,0),
-(@PATH,143,4664.102,-5517.985,27.2351,0,0,0,0,100,0),
-(@PATH,144,4663.71,-5518.2,27.46549,0,0,0,0,100,0),
-(@PATH,145,4663.21,-5518.7,27.71549,0,0,0,0,100,0),
-(@PATH,146,4660.71,-5523.2,27.96549,0,0,0,0,100,0),
-(@PATH,147,4657.71,-5529.2,28.71549,0,0,0,0,100,0),
-(@PATH,148,4655.082,-5533.99,29.53152,0,0,0,0,100,0),
-(@PATH,149,4653.332,-5538.74,30.03152,0,0,0,0,100,0),
-(@PATH,150,4652.332,-5542.49,30.78152,0,0,0,0,100,0),
-(@PATH,151,4651.832,-5544.24,31.28152,0,0,0,0,100,0),
-(@PATH,152,4651.082,-5546.24,31.78152,0,0,0,0,100,0),
-(@PATH,153,4650.332,-5547.99,32.28152,0,0,0,0,100,0),
-(@PATH,154,4649.832,-5549.99,33.03152,0,0,0,0,100,0),
-(@PATH,155,4648.461,-5552.834,34.08023,0,0,0,0,100,0),
-(@PATH,156,4647.961,-5554.834,34.83023,0,0,0,0,100,0),
-(@PATH,157,4647.461,-5556.584,35.58023,0,0,0,0,100,0),
-(@PATH,158,4646.961,-5558.584,36.58023,0,0,0,0,100,0),
-(@PATH,159,4646.461,-5560.584,37.58023,0,0,0,0,100,0),
-(@PATH,160,4645.711,-5563.334,38.33023,0,0,0,0,100,0),
-(@PATH,161,4645.461,-5565.084,39.58023,0,0,0,0,100,0),
-(@PATH,162,4644.961,-5567.084,40.83023,0,0,0,0,100,0),
-(@PATH,163,4644.461,-5569.084,41.83023,0,0,0,0,100,0),
-(@PATH,164,4643.961,-5570.834,42.58023,0,0,0,0,100,0),
-(@PATH,165,4642.961,-5573.834,43.33023,0,0,0,0,100,0),
-(@PATH,166,4642.868,-5574.016,43.39613,0,0,0,0,100,0),
-(@PATH,167,4642.368,-5575.766,43.64613,0,0,0,0,100,0),
-(@PATH,168,4639.118,-5580.516,42.89613,0,0,0,0,100,0),
-(@PATH,169,4637.118,-5583.766,41.64613,0,0,0,0,100,0),
-(@PATH,170,4635.368,-5586.266,40.39613,0,0,0,0,100,0);
-
-SET @NPC := 110474;
-SET @PATH := @NPC * 10;
-UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4974.067,`position_y`=-4702.151,`position_z`=211.6858 WHERE `guid`=@NPC;
-DELETE FROM `creature_addon` WHERE `guid`=@NPC;
-INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
-DELETE FROM `waypoint_data` WHERE `id`=@PATH;
-INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-(@PATH,1,4974.067,-4702.151,211.6858,0,0,0,0,100,0),
-(@PATH,2,4973.567,-4694.401,211.6858,0,0,0,0,100,0),
-(@PATH,3,4972.317,-4684.151,211.6858,0,0,0,0,100,0),
-(@PATH,4,4972.449,-4684.032,211.6815,0,0,0,0,100,0),
-(@PATH,5,4972.199,-4683.032,211.6815,0,0,0,0,100,0),
-(@PATH,6,4972.073,-4683.314,211.4305,0,0,0,0,100,0),
-(@PATH,7,4972.434,-4683.377,211.6818,0,0,0,0,100,0),
-(@PATH,8,4973.184,-4694.377,211.6818,0,0,0,0,100,0),
-(@PATH,9,4974.222,-4702.475,211.6772,0,0,0,0,100,0),
-(@PATH,10,4976.222,-4706.975,211.6772,0,0,0,0,100,0),
-(@PATH,11,4979.872,-4716.739,211.652,0,0,0,0,100,0),
-(@PATH,12,4979.707,-4716.649,211.4221,0,0,0,0,100,0),
-(@PATH,13,4979.64,-4716.295,211.6743,0,0,0,0,100,0),
-(@PATH,14,4976.14,-4707.045,211.6743,0,0,0,0,100,0);
-
-SET @NPC := 110473;
-SET @PATH := @NPC * 10;
-UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4971.524,`position_y`=-4651.398,`position_z`=211.6646 WHERE `guid`=@NPC;
-DELETE FROM `creature_addon` WHERE `guid`=@NPC;
-INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
-DELETE FROM `waypoint_data` WHERE `id`=@PATH;
-INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-(@PATH,1,4971.524,-4651.398,211.6646,0,0,0,0,100,0),
-(@PATH,2,4971.524,-4650.148,211.6646,0,0,0,0,100,0),
-(@PATH,3,4971.274,-4642.898,211.6646,0,0,0,0,100,0),
-(@PATH,4,4971.195,-4642.912,211.4312,0,0,0,0,100,0),
-(@PATH,5,4971.593,-4650.481,211.6812,0,0,0,0,100,0),
-(@PATH,6,4971.843,-4651.481,211.6812,0,0,0,0,100,0),
-(@PATH,7,4972.093,-4657.231,211.6812,0,0,0,0,100,0),
-(@PATH,8,4972.093,-4659.231,211.6812,0,0,0,0,100,0),
-(@PATH,9,4972.093,-4660.231,211.6812,0,0,0,0,100,0),
-(@PATH,10,4972.593,-4665.231,211.6812,0,0,0,0,100,0),
-(@PATH,11,4972.628,-4665.171,211.6984,0,0,0,0,100,0),
-(@PATH,12,4972.378,-4661.171,211.6984,0,0,0,0,100,0),
-(@PATH,13,4972.128,-4659.421,211.6984,0,0,0,0,100,0),
-(@PATH,14,4972.128,-4657.421,211.6984,0,0,0,0,100,0),
-(@PATH,15,4971.628,-4651.671,211.6984,0,0,0,0,100,0);
-
-SET @NPC := 110472;
-SET @PATH := @NPC * 10;
-UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=5006.468,`position_y`=-4761.551,`position_z`=211.3855 WHERE `guid`=@NPC;
-DELETE FROM `creature_addon` WHERE `guid`=@NPC;
-INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
-DELETE FROM `waypoint_data` WHERE `id`=@PATH;
-INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-(@PATH,1,5006.468,-4761.551,211.3855,0,0,0,0,100,0),
-(@PATH,2,5005.218,-4760.301,211.3855,0,0,0,0,100,0),
-(@PATH,3,5003.468,-4759.551,211.3855,0,0,0,0,100,0),
-(@PATH,4,5001.968,-4758.551,211.6355,0,0,0,0,100,0),
-(@PATH,5,4999.169,-4756.928,211.6723,0,0,0,0,100,0),
-(@PATH,6,4999.078,-4756.74,211.6491,0,0,0,0,100,0),
-(@PATH,7,4995.578,-4756.99,211.6491,0,0,0,0,100,0),
-(@PATH,8,4994.328,-4755.24,211.6491,0,0,0,0,100,0),
-(@PATH,9,4994.02,-4755.05,211.6453,0,0,0,0,100,0),
-(@PATH,10,4994.472,-4755.252,211.6491,0,0,0,0,100,0),
-(@PATH,11,4995.472,-4757.002,211.6491,0,0,0,0,100,0),
-(@PATH,12,4999.36,-4757.021,211.6276,0,0,0,0,100,0),
-(@PATH,13,5001.86,-4758.521,211.6276,0,0,0,0,100,0),
-(@PATH,14,5003.61,-4759.271,211.3776,0,0,0,0,100,0),
-(@PATH,15,5003.792,-4759.599,211.3631,0,0,0,0,100,0),
-(@PATH,16,5005.542,-4760.349,211.6131,0,0,0,0,100,0),
-(@PATH,17,5006.792,-4761.849,211.6131,0,0,0,0,100,0),
-(@PATH,18,5011.292,-4766.849,211.6131,0,0,0,0,100,0),
-(@PATH,19,5014.042,-4769.599,211.6131,0,0,0,0,100,0),
-(@PATH,20,5014.364,-4769.94,211.6148,0,0,0,0,100,0),
-(@PATH,21,5014.864,-4770.44,211.6148,0,0,0,0,100,0),
-(@PATH,22,5018.389,-4774.991,211.6234,0,0,0,0,100,0),
-(@PATH,23,5020.639,-4778.491,211.6234,0,0,0,0,100,0),
-(@PATH,24,5021.389,-4779.741,211.3734,0,0,0,0,100,0),
-(@PATH,25,5021.803,-4779.973,211.3778,0,0,0,0,100,0),
-(@PATH,26,5023.303,-4782.723,211.6278,0,0,0,0,100,0),
-(@PATH,27,5031.042,-4794.147,211.6393,0,0,0,0,100,0),
-(@PATH,28,5032.792,-4795.897,211.6393,0,0,0,0,100,0),
-(@PATH,29,5037.042,-4799.647,211.6393,0,0,0,0,100,0),
-(@PATH,30,5023.104,-4782.475,211.6226,0,0,0,0,100,0),
-(@PATH,31,5021.354,-4779.975,211.6226,0,0,0,0,100,0),
-(@PATH,32,5020.854,-4778.725,211.6226,0,0,0,0,100,0),
-(@PATH,33,5018.14,-4774.706,211.6087,0,0,0,0,100,0),
-(@PATH,34,5014.669,-4770.225,211.5951,0,0,0,0,100,0),
-(@PATH,35,5011.419,-4766.725,211.5951,0,0,0,0,100,0);
-
-DELETE FROM `creature_template_addon` WHERE `entry`=26268;
-INSERT INTO `creature_template_addon` (`entry`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES 
-(26268,0,0,0,1,27, '');
-
-SET @NPC := 110556;
-SET @PATH := @NPC * 10;
-UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4970.492,`position_y`=-4715.575,`position_z`=219.7441 WHERE `guid`=@NPC;
-DELETE FROM `creature_addon` WHERE `guid`=@NPC;
-INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
-DELETE FROM `waypoint_data` WHERE `id`=@PATH;
-INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-(@PATH,1,4970.492,-4715.575,219.7441,0,0,0,0,100,0),
-(@PATH,2,4971.992,-4715.325,220.4941,0,0,0,0,100,0),
-(@PATH,3,4973.492,-4714.825,221.2441,0,0,0,0,100,0),
-(@PATH,4,4975.742,-4714.325,221.7441,0,0,0,0,100,0),
-(@PATH,5,4978.742,-4713.825,222.2441,0,0,0,0,100,0),
-(@PATH,6,4980.742,-4713.575,221.9941,0,0,0,0,100,0),
-(@PATH,7,4981.992,-4713.325,221.7441,0,0,0,0,100,0),
-(@PATH,8,4983.742,-4712.825,221.2441,0,0,0,0,100,0),
-(@PATH,9,4985.242,-4712.575,220.4941,0,0,0,0,100,0),
-(@PATH,10,4986.242,-4712.325,219.7441,0,0,0,0,100,0),
-(@PATH,11,4968.5,-4716.197,219.4686,0,0,0,0,100,0),
-(@PATH,12,4968.5,-4716.197,219.4686,0.2173836,0,0,0,100,0),
-(@PATH,13,4970.5,-4714.933,219.7303,0,0,0,0,100,0),
-(@PATH,14,4971.75,-4714.433,220.4803,0,0,0,0,100,0),
-(@PATH,15,4973,-4713.683,221.2303,0,0,0,0,100,0),
-(@PATH,16,4975,-4712.683,221.7303,0,0,0,0,100,0),
-(@PATH,17,4976,-4712.183,221.9803,0,0,0,0,100,0),
-(@PATH,18,4978,-4711.183,222.2303,0,0,0,0,100,0),
-(@PATH,19,4979.75,-4710.183,222.2303,0,0,0,0,100,0),
-(@PATH,20,4982.5,-4708.683,221.4803,0,0,0,0,100,0),
-(@PATH,21,4984,-4707.933,220.7303,0,0,0,0,100,0),
-(@PATH,22,4985,-4707.433,219.7303,0,0,0,0,100,0),
-(@PATH,23,4985.5,-4707.183,219.7303,0,0,0,0,100,0),
-(@PATH,24,4987.75,-4704.183,219.7303,0,0,0,0,100,0),
-(@PATH,25,4985.311,-4707.438,219.4958,0,0,0,0,100,0),
-(@PATH,26,4985.311,-4707.438,219.4958,0.6189525,0,0,0,100,0),
-(@PATH,27,4987.121,-4708.128,219.7317,0,0,0,0,100,0),
-(@PATH,28,4996.999,-4712.775,219.6996,0,0,0,0,100,0),
-(@PATH,29,4997.249,-4716.525,219.6996,0,0,0,0,100,0),
-(@PATH,30,4996.261,-4712.509,219.4735,0,0,0,0,100,0),
-(@PATH,31,4996.261,-4712.509,219.4735,5.849536,0,0,0,100,0),
-(@PATH,32,4997.006,-4716.74,219.7261,0,0,0,0,100,0),
-(@PATH,33,4997.506,-4720.74,219.4761,0,0,0,0,100,0),
-(@PATH,34,4998.006,-4723.49,219.7261,0,0,0,0,100,0),
-(@PATH,35,4998.103,-4723.636,219.7025,0,0,0,0,100,0),
-(@PATH,36,4997.853,-4720.886,219.7025,0,0,0,0,100,0),
-(@PATH,37,4997.595,-4720.635,219.7042,0,0,0,0,100,0),
-(@PATH,38,4997.345,-4720.135,219.7042,0,0,0,0,100,0),
-(@PATH,39,4997.345,-4716.885,219.4542,0,0,0,0,100,0),
-(@PATH,40,4997.056,-4712.651,219.6972,0,0,0,0,100,0),
-(@PATH,41,4991.556,-4700.401,219.6972,0,0,0,0,100,0),
-(@PATH,42,4988.556,-4693.901,219.6972,0,0,0,0,100,0),
-(@PATH,43,4986.112,-4688.446,219.7411,0,0,0,0,100,0),
-(@PATH,44,4988.362,-4693.696,219.7411,0,0,0,0,100,0),
-(@PATH,45,4989.805,-4696.215,219.7516,0,0,0,0,100,0),
-(@PATH,46,4991.805,-4699.465,219.7516,0,0,0,0,100,0),
-(@PATH,47,4988.768,-4694.563,219.4946,0,0,0,0,100,0),
-(@PATH,48,4988.768,-4694.563,219.4946,5.140615,0,0,0,100,0),
-(@PATH,49,4987.719,-4703.979,219.9336,0,0,0,0,100,0),
-(@PATH,50,4985.469,-4706.229,219.9336,0,0,0,0,100,0),
-(@PATH,51,4984.969,-4707.479,220.4336,0,0,0,0,100,0),
-(@PATH,52,4984.469,-4708.479,220.4336,0,0,0,0,100,0),
-(@PATH,53,4983.469,-4710.229,221.1836,0,0,0,0,100,0),
-(@PATH,54,4982.217,-4712.462,221.5245,0,0,0,0,100,0),
-(@PATH,55,4980.967,-4712.462,221.7745,0,0,0,0,100,0),
-(@PATH,56,4978.467,-4712.962,222.0245,0,0,0,0,100,0),
-(@PATH,57,4976.467,-4713.462,221.7745,0,0,0,0,100,0),
-(@PATH,58,4976.035,-4713.909,221.9419,0,0,0,0,100,0),
-(@PATH,59,4974.785,-4714.159,221.6919,0,0,0,0,100,0),
-(@PATH,60,4973.035,-4714.659,221.1919,0,0,0,0,100,0),
-(@PATH,61,4972.035,-4714.909,220.6919,0,0,0,0,100,0),
-(@PATH,62,4970.535,-4715.409,219.9419,0,0,0,0,100,0),
-(@PATH,63,4978.076,-4713.338,221.915,0,0,0,0,100,0),
-(@PATH,64,4978.076,-4713.338,221.915,3.368376,0,0,0,100,0),
-(@PATH,65,4976.91,-4713.574,221.9563,0,0,0,0,100,0),
-(@PATH,66,4975.91,-4713.574,221.9563,0,0,0,0,100,0),
-(@PATH,67,4972.91,-4713.824,221.2063,0,0,0,0,100,0),
-(@PATH,68,4971.41,-4714.074,220.7063,0,0,0,0,100,0),
-(@PATH,69,4970.16,-4714.324,219.9563,0,0,0,0,100,0),
-(@PATH,70,4967.606,-4714.529,219.4961,0,0,0,0,100,0),
-(@PATH,71,4967.606,-4714.529,219.4961,3.254826,0,0,0,100,0),
-(@PATH,72,4965.34,-4710.163,219.7599,0,0,0,0,100,0),
-(@PATH,73,4963.59,-4707.163,219.7599,0,0,0,0,100,0),
-(@PATH,74,4959.034,-4705.619,219.5352,0,0,0,0,100,0),
-(@PATH,75,4959.39,-4705.551,219.7635,0,0,0,0,100,0),
-(@PATH,76,4959.64,-4707.801,219.7635,0,0,0,0,100,0),
-(@PATH,77,4960.14,-4711.551,219.7635,0,0,0,0,100,0),
-(@PATH,78,4960.938,-4715.122,219.7473,0,0,0,0,100,0),
-(@PATH,79,4968.219,-4716.248,219.9708,0,0,0,0,100,0),
-(@PATH,80,4970.219,-4715.498,219.9708,0,0,0,0,100,0),
-(@PATH,81,4971.719,-4714.998,220.4708,0,0,0,0,100,0),
-(@PATH,82,4972.969,-4714.748,221.2208,0,0,0,0,100,0),
-(@PATH,83,4975.053,-4713.824,221.6586,0,0,0,0,100,0),
-(@PATH,84,4976.303,-4713.574,221.9086,0,0,0,0,100,0),
-(@PATH,85,4978.303,-4713.324,222.1586,0,0,0,0,100,0),
-(@PATH,86,4980.553,-4712.824,221.9086,0,0,0,0,100,0),
-(@PATH,87,4975.714,-4713.883,221.6543,0,0,0,0,100,0),
-(@PATH,88,4975.714,-4713.883,221.6543,0.2268625,0,0,0,100,0),
-(@PATH,89,4978.577,-4713.063,222.0859,0,0,0,0,100,0),
-(@PATH,90,4980.827,-4712.813,221.8359,0,0,0,0,100,0),
-(@PATH,91,4983.827,-4712.563,221.0859,0,0,0,0,100,0),
-(@PATH,92,4985.077,-4712.313,220.5859,0,0,0,0,100,0),
-(@PATH,93,4986.077,-4712.063,219.8359,0,0,0,0,100,0);
-
-SET @NPC := 118822;
-SET @PATH := @NPC * 10;
-UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3494.382,`position_y`=-4552.813,`position_z`=224.2461 WHERE `guid`=@NPC;
-DELETE FROM `creature_addon` WHERE `guid`=@NPC;
-INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
-DELETE FROM `waypoint_data` WHERE `id`=@PATH;
-INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-(@PATH,1,3494.382,-4552.813,224.2461,0,0,0,0,100,0),
-(@PATH,2,3495.632,-4551.813,223.9961,0,0,0,0,100,0),
-(@PATH,3,3497.382,-4550.813,222.9961,0,0,0,0,100,0),
-(@PATH,4,3499.882,-4549.313,222.4961,0,0,0,0,100,0),
-(@PATH,5,3501.382,-4548.313,221.9961,0,0,0,0,100,0),
-(@PATH,6,3503.882,-4546.813,221.2461,0,0,0,0,100,0),
-(@PATH,7,3506.382,-4545.313,220.4961,0,0,0,0,100,0),
-(@PATH,8,3506.673,-4544.896,220.2739,0,0,0,0,100,0),
-(@PATH,9,3507.423,-4544.646,220.2739,0,0,0,0,100,0),
-(@PATH,10,3508.673,-4543.396,219.7739,0,0,0,0,100,0),
-(@PATH,11,3511.423,-4540.896,219.2739,0,0,0,0,100,0),
-(@PATH,12,3514.411,-4538.24,218.5021,0,0,0,0,100,0),
-(@PATH,13,3515.411,-4534.24,217.7521,0,0,0,0,100,0),
-(@PATH,14,3516.161,-4531.74,217.2521,0,0,0,0,100,0),
-(@PATH,15,3517.161,-4528.74,216.7521,0,0,0,0,100,0),
-(@PATH,16,3518.161,-4524.99,216.2521,0,0,0,0,100,0),
-(@PATH,17,3518.383,-4524.767,216.0448,0,0,0,0,100,0),
-(@PATH,18,3518.883,-4523.517,215.7948,0,0,0,0,100,0),
-(@PATH,19,3521.883,-4521.517,215.2948,0,0,0,0,100,0),
-(@PATH,20,3523.383,-4520.267,214.7948,0,0,0,0,100,0),
-(@PATH,21,3524.552,-4519.662,214.4079,0,0,0,0,100,0),
-(@PATH,22,3526.552,-4519.912,213.4079,0,0,0,0,100,0),
-(@PATH,23,3528.552,-4519.912,212.6579,0,0,0,0,100,0),
-(@PATH,24,3530.552,-4519.912,211.9079,0,0,0,0,100,0),
-(@PATH,25,3533.302,-4520.162,211.4079,0,0,0,0,100,0),
-(@PATH,26,3535.302,-4520.162,210.6579,0,0,0,0,100,0),
-(@PATH,27,3537.302,-4520.412,209.9079,0,0,0,0,100,0),
-(@PATH,28,3537.519,-4520.006,209.603,0,0,0,0,100,0),
-(@PATH,29,3539.019,-4520.256,209.103,0,0,0,0,100,0),
-(@PATH,30,3542.519,-4518.756,208.353,0,0,0,0,100,0),
-(@PATH,31,3541.411,-4519.309,208.4283,0,0,0,0,100,0),
-(@PATH,32,3538.654,-4520.119,209.2209,0,0,0,0,100,0),
-(@PATH,33,3536.654,-4520.119,209.7209,0,0,0,0,100,0),
-(@PATH,34,3534.654,-4519.869,210.4709,0,0,0,0,100,0),
-(@PATH,35,3532.654,-4519.869,211.2209,0,0,0,0,100,0),
-(@PATH,36,3530.904,-4519.869,211.9709,0,0,0,0,100,0),
-(@PATH,37,3528.904,-4519.619,212.7209,0,0,0,0,100,0),
-(@PATH,38,3526.904,-4519.619,213.4709,0,0,0,0,100,0),
-(@PATH,39,3524.904,-4519.619,214.2209,0,0,0,0,100,0),
-(@PATH,40,3524.787,-4519.809,214.4233,0,0,0,0,100,0),
-(@PATH,41,3524.287,-4519.809,214.6733,0,0,0,0,100,0),
-(@PATH,42,3522.537,-4520.809,214.9233,0,0,0,0,100,0),
-(@PATH,43,3520.537,-4522.309,215.6733,0,0,0,0,100,0),
-(@PATH,44,3520.155,-4522.621,215.7749,0,0,0,0,100,0),
-(@PATH,45,3518.655,-4523.871,216.2749,0,0,0,0,100,0),
-(@PATH,46,3517.655,-4527.621,216.7749,0,0,0,0,100,0),
-(@PATH,47,3516.905,-4530.121,217.0249,0,0,0,0,100,0),
-(@PATH,48,3515.655,-4534.121,217.7749,0,0,0,0,100,0),
-(@PATH,49,3514.23,-4538.046,218.7422,0,0,0,0,100,0),
-(@PATH,50,3511.48,-4540.546,219.2422,0,0,0,0,100,0),
-(@PATH,51,3507.98,-4544.046,219.9922,0,0,0,0,100,0),
-(@PATH,52,3507.672,-4544.28,220.189,0,0,0,0,100,0),
-(@PATH,53,3507.172,-4544.78,220.439,0,0,0,0,100,0),
-(@PATH,54,3503.672,-4547.03,221.439,0,0,0,0,100,0),
-(@PATH,55,3501.922,-4547.78,221.939,0,0,0,0,100,0),
-(@PATH,56,3499.672,-4549.28,222.439,0,0,0,0,100,0),
-(@PATH,57,3497.922,-4550.28,223.189,0,0,0,0,100,0),
-(@PATH,58,3495.37,-4551.927,224.1924,0,0,0,0,100,0),
-(@PATH,59,3493.12,-4553.927,224.9424,0,0,0,0,100,0),
-(@PATH,60,3491.37,-4555.177,225.4424,0,0,0,0,100,0),
-(@PATH,61,3489.37,-4556.927,226.1924,0,0,0,0,100,0),
-(@PATH,62,3487.12,-4558.677,226.9424,0,0,0,0,100,0),
-(@PATH,63,3488.252,-4557.707,226.4908,0,0,0,0,100,0),
-(@PATH,64,3490.502,-4555.957,225.7408,0,0,0,0,100,0),
-(@PATH,65,3492.002,-4554.957,225.2408,0,0,0,0,100,0),
-(@PATH,66,3494.252,-4552.957,224.4908,0,0,0,0,100,0),
-(@PATH,67,3494.369,-4552.621,224.1573,0,0,0,0,100,0),
-(@PATH,68,3495.619,-4551.871,223.9073,0,0,0,0,100,0),
-(@PATH,69,3497.369,-4550.621,223.1573,0,0,0,0,100,0),
-(@PATH,70,3499.869,-4549.121,222.4073,0,0,0,0,100,0),
-(@PATH,71,3501.369,-4548.371,222.1573,0,0,0,0,100,0),
-(@PATH,72,3503.869,-4546.871,221.4073,0,0,0,0,100,0),
-(@PATH,73,3506.369,-4545.371,220.6573,0,0,0,0,100,0);
-UPDATE `smart_scripts` SET `action_param1`=1 WHERE  `entryorguid`=26356 AND `source_type`=0 AND `id`=0 AND `link`=1;
-
-SET @NPC := 98061;
-SET @PATH := @NPC * 10;
-UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4037.801,`position_y`=-4305.377,`position_z`=252.4434 WHERE `guid`=@NPC;
-DELETE FROM `creature_addon` WHERE `guid`=@NPC;
-INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
-DELETE FROM `waypoint_data` WHERE `id`=@PATH;
-INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-(@PATH,1,4037.801,-4305.377,252.4434,0,0,0,0,100,0),
-(@PATH,2,4029.266,-4311.001,252.5234,0,0,0,0,100,0),
-(@PATH,3,4029.175,-4310.955,252.2501,0,0,0,0,100,0),
-(@PATH,4,4029.509,-4310.642,252.4412,0,0,0,0,100,0),
-(@PATH,5,4037.943,-4305.163,252.2845,0,0,0,0,100,0),
-(@PATH,6,4054.193,-4300.913,251.7845,0,0,0,0,100,0),
-(@PATH,7,4062.19,-4298.607,251.5605,0,0,0,0,100,0),
-(@PATH,8,4086.898,-4293.291,251.9268,0,0,0,0,100,0),
-(@PATH,9,4086.576,-4293.453,251.7249,0,0,0,0,100,0),
-(@PATH,10,4086.678,-4293.366,251.7816,0,0,0,0,100,0),
-(@PATH,11,4062,-4298.887,251.8086,0,0,0,0,100,0),
-(@PATH,12,4046.75,-4302.637,252.0586,0,0,0,0,100,0),
-(@PATH,13,4037.769,-4305.386,252.4443,0,0,0,0,100,0),
-(@PATH,14,4029.219,-4311.032,252.5237,0,0,0,0,100,0),
-(@PATH,15,4029.175,-4310.955,252.2501,0,0,0,0,100,0);
-
-UPDATE `smart_scripts` SET `action_param1`=1 WHERE  `entryorguid`=26389 AND `source_type`=0 AND `id`=0 AND `link`=1;
-SET @NPC := 98054;
-SET @PATH := @NPC * 10;
-UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4043.963,`position_y`=-4430.786,`position_z`=261.5165 WHERE `guid`=@NPC;
-DELETE FROM `creature_addon` WHERE `guid`=@NPC;
-INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
-DELETE FROM `waypoint_data` WHERE `id`=@PATH;
-INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-(@PATH,1,4043.963,-4430.786,261.5165,0,0,0,0,100,0),
-(@PATH,2,4044.963,-4432.786,262.0165,0,0,0,0,100,0),
-(@PATH,3,4044.713,-4435.286,262.7665,0,0,0,0,100,0),
-(@PATH,4,4045.213,-4436.286,263.0165,0,0,0,0,100,0),
-(@PATH,5,4045.463,-4436.786,263.0165,0,0,0,0,100,0),
-(@PATH,6,4047.463,-4438.786,262.7665,0,0,0,0,100,0),
-(@PATH,7,4047.963,-4439.786,263.5165,0,0,0,0,100,0),
-(@PATH,8,4047.949,-4440.013,263.7135,0,0,0,0,100,0),
-(@PATH,9,4049.949,-4440.513,264.2135,0,0,0,0,100,0),
-(@PATH,10,4048.949,-4441.763,264.7135,0,0,0,0,100,0),
-(@PATH,11,4048.949,-4443.763,265.2135,0,0,0,0,100,0),
-(@PATH,12,4047.699,-4445.763,266.2135,0,0,0,0,100,0),
-(@PATH,13,4046.199,-4447.263,266.7135,0,0,0,0,100,0),
-(@PATH,14,4043.449,-4446.763,267.4635,0,0,0,0,100,0),
-(@PATH,15,4042.699,-4448.013,267.9635,0,0,0,0,100,0),
-(@PATH,16,4041.949,-4448.513,267.9635,0,0,0,0,100,0),
-(@PATH,17,4041.449,-4453.513,267.4635,0,0,0,0,100,0),
-(@PATH,18,4041.242,-4453.717,267.8022,0,0,0,0,100,0),
-(@PATH,19,4040.242,-4454.467,268.3022,0,0,0,0,100,0),
-(@PATH,20,4040.242,-4456.467,268.8022,0,0,0,0,100,0),
-(@PATH,21,4040.242,-4460.217,269.5522,0,0,0,0,100,0),
-(@PATH,22,4040.489,-4464.713,269.6811,0,0,0,0,100,0),
-(@PATH,23,4046.239,-4480.213,269.1811,0,0,0,0,100,0),
-(@PATH,24,4046.276,-4479.878,269.3551,0,0,0,0,100,0),
-(@PATH,25,4044.026,-4474.378,270.1051,0,0,0,0,100,0),
-(@PATH,26,4040.298,-4464.532,269.725,0,0,0,0,100,0),
-(@PATH,27,4040.298,-4459.782,269.225,0,0,0,0,100,0),
-(@PATH,28,4040.298,-4455.782,268.475,0,0,0,0,100,0),
-(@PATH,29,4040.299,-4455.474,268.2261,0,0,0,0,100,0),
-(@PATH,30,4040.299,-4454.224,267.9761,0,0,0,0,100,0),
-(@PATH,31,4042.799,-4453.224,267.7261,0,0,0,0,100,0),
-(@PATH,32,4046.049,-4454.224,267.7261,0,0,0,0,100,0),
-(@PATH,33,4047.799,-4452.974,267.2261,0,0,0,0,100,0),
-(@PATH,34,4048.549,-4450.474,266.7261,0,0,0,0,100,0),
-(@PATH,35,4049.049,-4444.724,265.7261,0,0,0,0,100,0),
-(@PATH,36,4050.049,-4444.724,265.7261,0,0,0,0,100,0),
-(@PATH,37,4050.549,-4442.974,264.9761,0,0,0,0,100,0),
-(@PATH,38,4049.437,-4441.189,263.9388,0,0,0,0,100,0),
-(@PATH,39,4047.937,-4438.439,262.9388,0,0,0,0,100,0),
-(@PATH,40,4045.687,-4436.939,262.9388,0,0,0,0,100,0),
-(@PATH,41,4044.687,-4436.189,262.9388,0,0,0,0,100,0),
-(@PATH,42,4043.937,-4433.189,261.9388,0,0,0,0,100,0),
-(@PATH,43,4043.437,-4430.439,261.4388,0,0,0,0,100,0),
-(@PATH,44,4043.437,-4428.939,261.4388,0,0,0,0,100,0),
-(@PATH,45,4038.512,-4412.942,261.4726,0,0,0,0,100,0),
-(@PATH,46,4045.009,-4403.787,261.2599,0,0,0,0,100,0),
-(@PATH,47,4050.509,-4398.787,260.7599,0,0,0,0,100,0),
-(@PATH,48,4054.184,-4395.831,260.5081,0,0,0,0,100,0),
-(@PATH,49,4060.914,-4401.005,260.7264,0,0,0,0,100,0),
-(@PATH,50,4060.763,-4401.35,260.5203,0,0,0,0,100,0),
-(@PATH,51,4060.835,-4401.013,260.7022,0,0,0,0,100,0);
-
--- Earthen Warrior SAI
-SET @ENTRY := 26282;
-UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
-(@ENTRY,0,0,0,1,0,100,0,5000,5000,10000,10000,49,0,0,0,0,0,0,19,26284,10,0,0,0,0,0,"Earthen Warrior - Out of Combat - Start Attacking");
-
-SET @NPC := 112260;
-SET @PATH := @NPC * 10;
-UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4626.77,`position_y`=-4468.18,`position_z`=188.7218 WHERE `guid`=@NPC;
-DELETE FROM `creature_addon` WHERE `guid`=@NPC;
-INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
-DELETE FROM `waypoint_data` WHERE `id`=@PATH;
-INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-(@PATH,1,4626.77,-4468.18,188.7218,0,0,0,0,100,0),
-(@PATH,2,4628.02,-4468.43,188.7218,0,0,0,0,100,0),
-(@PATH,3,4633.77,-4469.43,189.2218,0,0,0,0,100,0),
-(@PATH,4,4638.52,-4470.18,189.7218,0,0,0,0,100,0),
-(@PATH,5,4642.52,-4470.93,190.4718,0,0,0,0,100,0),
-(@PATH,6,4644.66,-4471.42,191.0322,0,0,0,0,100,0),
-(@PATH,7,4647.66,-4471.42,191.5322,0,0,0,0,100,0),
-(@PATH,8,4651.41,-4471.42,191.7822,0,0,0,0,100,0),
-(@PATH,9,4655.41,-4471.42,192.5322,0,0,0,0,100,0),
-(@PATH,10,4659.563,-4471.758,193.4037,0,0,0,0,100,0),
-(@PATH,11,4667.063,-4474.758,193.9037,0,0,0,0,100,0),
-(@PATH,12,4667.158,-4472.282,193.5602,0,0,0,0,100,0),
-(@PATH,13,4659.328,-4471.715,193.0153,0,0,0,0,100,0),
-(@PATH,14,4655.328,-4471.715,192.5153,0,0,0,0,100,0),
-(@PATH,15,4651.578,-4471.465,191.7653,0,0,0,0,100,0),
-(@PATH,16,4647.578,-4471.465,191.5153,0,0,0,0,100,0),
-(@PATH,17,4644.492,-4471.189,190.7167,0,0,0,0,100,0),
-(@PATH,18,4640.492,-4470.439,189.9667,0,0,0,0,100,0),
-(@PATH,19,4635.742,-4469.689,189.7167,0,0,0,0,100,0),
-(@PATH,20,4630.992,-4468.939,188.9667,0,0,0,0,100,0),
-(@PATH,21,4627.861,-4468.194,188.4529,0,0,0,0,100,0),
-(@PATH,22,4625.361,-4467.944,188.7029,0,0,0,0,100,0),
-(@PATH,23,4619.689,-4466.896,187.1016,0,0,0,0,100,0),
-(@PATH,24,4609.689,-4465.646,184.6016,0,0,0,0,100,0),
-(@PATH,25,4608.689,-4465.646,184.6016,0,0,0,0,100,0),
-(@PATH,26,4608.402,-4465.411,184.3824,0,0,0,0,100,0),
-(@PATH,27,4605.652,-4465.161,184.3824,0,0,0,0,100,0),
-(@PATH,28,4595.808,-4461.938,184.4014,0,0,0,0,100,0),
-(@PATH,29,4595.772,-4462.198,184.1551,0,0,0,0,100,0),
-(@PATH,30,4595.927,-4462.176,184.3824,0,0,0,0,100,0),
-(@PATH,31,4605.99,-4465.424,184.4906,0,0,0,0,100,0),
-(@PATH,32,4609.24,-4465.924,183.9906,0,0,0,0,100,0),
-(@PATH,33,4619.987,-4467.194,187.3334,0,0,0,0,100,0),
-(@PATH,34,4626.487,-4467.944,188.5834,0,0,0,0,100,0),
-(@PATH,35,4626.743,-4468.349,188.8552,0,0,0,0,100,0),
-(@PATH,36,4627.993,-4468.349,188.8552,0,0,0,0,100,0),
-(@PATH,37,4633.993,-4469.349,189.1052,0,0,0,0,100,0),
-(@PATH,38,4638.493,-4470.099,189.8552,0,0,0,0,100,0),
-(@PATH,39,4642.493,-4470.849,190.3552,0,0,0,0,100,0);
-
-SET @NPC := 112265;
-SET @PATH := @NPC * 10;
-UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4740.915,`position_y`=-4506.604,`position_z`=199.756 WHERE `guid`=@NPC;
-DELETE FROM `creature_addon` WHERE `guid`=@NPC;
-INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
-DELETE FROM `waypoint_data` WHERE `id`=@PATH;
-INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-(@PATH,1,4740.915,-4506.604,199.756,0,0,0,0,100,0),
-(@PATH,2,4739.165,-4508.604,200.256,0,0,0,0,100,0),
-(@PATH,3,4736.571,-4511.472,200.7764,0,0,0,0,100,0),
-(@PATH,4,4732.571,-4516.722,201.2764,0,0,0,0,100,0),
-(@PATH,5,4729.089,-4521.665,201.4696,0,0,0,0,100,0),
-(@PATH,6,4729.089,-4524.915,202.2196,0,0,0,0,100,0),
-(@PATH,7,4727.339,-4528.165,202.7196,0,0,0,0,100,0),
-(@PATH,8,4725.089,-4532.415,203.2196,0,0,0,0,100,0),
-(@PATH,9,4720.262,-4531.4,203.6031,0,0,0,0,100,0),
-(@PATH,10,4719.762,-4532.4,203.8531,0,0,0,0,100,0),
-(@PATH,11,4719.762,-4533.4,204.1031,0,0,0,0,100,0),
-(@PATH,12,4718.512,-4536.15,204.6031,0,0,0,0,100,0),
-(@PATH,13,4715.762,-4538.4,205.1031,0,0,0,0,100,0),
-(@PATH,14,4714.762,-4539.65,205.6031,0,0,0,0,100,0),
-(@PATH,15,4715.869,-4538.347,205.2154,0,0,0,0,100,0),
-(@PATH,16,4717.119,-4536.597,204.7154,0,0,0,0,100,0),
-(@PATH,17,4718.119,-4535.847,204.4654,0,0,0,0,100,0),
-(@PATH,18,4717.619,-4533.347,204.4654,0,0,0,0,100,0),
-(@PATH,19,4719.119,-4530.597,203.4654,0,0,0,0,100,0),
-(@PATH,20,4719.277,-4530.432,203.2003,0,0,0,0,100,0),
-(@PATH,21,4720.527,-4531.182,203.4503,0,0,0,0,100,0),
-(@PATH,22,4721.527,-4529.432,202.9503,0,0,0,0,100,0),
-(@PATH,23,4723.027,-4525.432,202.4503,0,0,0,0,100,0),
-(@PATH,24,4726.277,-4523.432,201.7003,0,0,0,0,100,0),
-(@PATH,25,4729.367,-4521.513,201.2202,0,0,0,0,100,0),
-(@PATH,26,4736.9,-4511.23,200.8284,0,0,0,0,100,0),
-(@PATH,27,4739.9,-4507.73,199.8284,0,0,0,0,100,0),
-(@PATH,28,4742.65,-4504.73,199.5784,0,0,0,0,100,0);
-
-SET @NPC := 112263;
-SET @PATH := @NPC * 10;
-UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4763.436,`position_y`=-4489.991,`position_z`=196.598 WHERE `guid`=@NPC;
-DELETE FROM `creature_addon` WHERE `guid`=@NPC;
-INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
-DELETE FROM `waypoint_data` WHERE `id`=@PATH;
-INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-(@PATH,1,4763.436,-4489.991,196.598,0,0,0,0,100,0),
-(@PATH,2,4777.686,-4503.491,197.098,0,0,0,0,100,0),
-(@PATH,3,4777.988,-4503.717,197.3403,0,0,0,0,100,0),
-(@PATH,4,4779.238,-4504.967,197.3403,0,0,0,0,100,0),
-(@PATH,5,4787.988,-4509.217,197.5903,0,0,0,0,100,0),
-(@PATH,6,4797.488,-4514.217,198.3403,0,0,0,0,100,0),
-(@PATH,7,4791.602,-4511.282,197.6792,0,0,0,0,100,0),
-(@PATH,8,4781.352,-4506.032,197.4292,0,0,0,0,100,0),
-(@PATH,9,4779.015,-4504.664,197.1621,0,0,0,0,100,0),
-(@PATH,10,4764.765,-4491.164,196.6621,0,0,0,0,100,0),
-(@PATH,11,4764.466,-4490.788,196.5181,0,0,0,0,100,0),
-(@PATH,12,4763.216,-4489.788,196.5181,0,0,0,0,100,0),
-(@PATH,13,4757.216,-4483.288,195.7681,0,0,0,0,100,0),
-(@PATH,14,4751.675,-4477.44,195.3216,0,0,0,0,100,0),
-(@PATH,15,4740.917,-4467.688,195.4378,0,0,0,0,100,0),
-(@PATH,16,4733.417,-4458.938,194.9378,0,0,0,0,100,0),
-(@PATH,17,4730.063,-4454.976,194.4022,0,0,0,0,100,0),
-(@PATH,18,4726.313,-4450.476,193.9022,0,0,0,0,100,0),
-(@PATH,19,4721.563,-4444.476,193.4022,0,0,0,0,100,0),
-(@PATH,20,4721.331,-4444.313,193.3035,0,0,0,0,100,0),
-(@PATH,21,4719.581,-4442.063,193.0535,0,0,0,0,100,0),
-(@PATH,22,4712.081,-4433.313,192.5535,0,0,0,0,100,0),
-(@PATH,23,4706.962,-4427.567,192.1902,0,0,0,0,100,0),
-(@PATH,24,4700.712,-4420.317,191.6902,0,0,0,0,100,0),
-(@PATH,25,4704.823,-4424.94,191.8282,0,0,0,0,100,0),
-(@PATH,26,4705.068,-4425.129,192.0756,0,0,0,0,100,0),
-(@PATH,27,4707.318,-4427.629,192.3256,0,0,0,0,100,0),
-(@PATH,28,4714.318,-4435.879,192.8256,0,0,0,0,100,0),
-(@PATH,29,4719.729,-4442.429,193.2542,0,0,0,0,100,0),
-(@PATH,30,4725.229,-4449.179,193.7542,0,0,0,0,100,0),
-(@PATH,31,4729.479,-4454.679,194.2542,0,0,0,0,100,0),
-(@PATH,32,4729.81,-4454.901,194.5507,0,0,0,0,100,0),
-(@PATH,33,4730.31,-4455.401,194.5507,0,0,0,0,100,0),
-(@PATH,34,4734.56,-4460.401,195.0507,0,0,0,0,100,0),
-(@PATH,35,4741.313,-4467.867,195.4152,0,0,0,0,100,0);
-
--- correction
--- Grizzly Hills Giant SAI
-SET @ENTRY := 26261;
-UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
-(@ENTRY,0,0,0,8,0,100,0,47394,0,0,0,33,26261,0,0,0,0,0,7,0,0,0,0,0,0,0,"Grizzly Hills Giant - On Spellhit 'Kurun's Blessing' - Quest Credit 'Rallying the Troops'"),
-(@ENTRY,0,1,0,1,0,100,0,2000,5000,4000,6000,11,46815,0,0,0,0,0,19,26264,100,0,0,0,0,0,"Grizzly Hills Giant - Out of Combat - Cast 'Toss Boulder'");
-
-SET @NPC := 110559;
-SET @PATH := @NPC * 10;
-UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4974.938,`position_y`=-4745.822,`position_z`=219.5011 WHERE `guid`=@NPC;
-DELETE FROM `creature_addon` WHERE `guid`=@NPC;
-INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
-DELETE FROM `waypoint_data` WHERE `id`=@PATH;
-INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-(@PATH,1,4974.938,-4745.822,219.5011,0,0,0,0,100,0),
-(@PATH,2,4974.938,-4745.822,219.5011,2.057687,0,0,0,100,0),
-(@PATH,3,4974.938,-4745.822,219.5011,0,0,0,0,100,0),
-(@PATH,4,4974.938,-4745.822,219.5011,2.057687,0,0,0,100,0),
-(@PATH,5,4970.268,-4736.388,219.75,0,0,0,0,100,0),
-(@PATH,6,4969.018,-4734.138,219.75,0,0,0,0,100,0),
-(@PATH,7,4968.648,-4734.162,219.7481,0,0,0,0,100,0),
-(@PATH,8,4969.148,-4736.162,219.7481,0,0,0,0,100,0),
-(@PATH,9,4970.325,-4738.761,219.7499,0,0,0,0,100,0),
-(@PATH,10,4974.973,-4749.851,219.75,0,0,0,0,100,0),
-(@PATH,11,4977.148,-4754.923,219.7599,0,0,0,0,100,0),
-(@PATH,12,4977.898,-4756.173,219.7599,0,0,0,0,100,0),
-(@PATH,13,4976.332,-4753.346,219.5004,0,0,0,0,100,0),
-(@PATH,14,4976.332,-4753.346,219.5004,5.131248,0,0,0,100,0),
-(@PATH,15,4978.357,-4755.924,219.7322,0,0,0,0,100,0),
-(@PATH,16,4985.357,-4766.174,219.7322,0,0,0,0,100,0),
-(@PATH,17,4988.607,-4770.424,219.7322,0,0,0,0,100,0),
-(@PATH,18,4990.607,-4773.424,219.7322,0,0,0,0,100,0),
-(@PATH,19,4978.615,-4756.599,219.5061,0,0,0,0,100,0),
-(@PATH,20,4978.615,-4756.599,219.5061,5.324385,0,0,0,100,0),
-(@PATH,21,4989.826,-4764.923,219.9392,0,0,0,0,100,0),
-(@PATH,22,4992.076,-4766.923,220.9392,0,0,0,0,100,0),
-(@PATH,23,4994.826,-4767.173,219.9392,0,0,0,0,100,0),
-(@PATH,24,4997.076,-4766.923,220.9392,0,0,0,0,100,0),
-(@PATH,25,4998.326,-4766.423,221.4392,0,0,0,0,100,0),
-(@PATH,26,5002.076,-4765.673,221.9392,0,0,0,0,100,0),
-(@PATH,27,5004.826,-4765.173,222.1892,0,0,0,0,100,0),
-(@PATH,28,5005.213,-4765.373,222.2207,0,0,0,0,100,0),
-(@PATH,29,5006.713,-4764.873,221.9707,0,0,0,0,100,0),
-(@PATH,30,5008.463,-4763.873,221.7207,0,0,0,0,100,0),
-(@PATH,31,5010.463,-4762.623,221.2207,0,0,0,0,100,0),
-(@PATH,32,5011.713,-4762.123,220.7207,0,0,0,0,100,0),
-(@PATH,33,5012.463,-4761.623,219.9707,0,0,0,0,100,0),
-(@PATH,34,5014.963,-4760.373,219.9707,0,0,0,0,100,0),
-(@PATH,35,5013.416,-4761.159,219.5162,0,0,0,0,100,0),
-(@PATH,36,5013.416,-4761.159,219.5162,0.5364561,0,0,0,100,0),
-(@PATH,37,5012.949,-4758.56,219.7025,0,0,0,0,100,0),
-(@PATH,38,5011.449,-4752.56,219.7025,0,0,0,0,100,0),
-(@PATH,39,5011.199,-4749.81,219.7025,0,0,0,0,100,0),
-(@PATH,40,5010.699,-4747.81,219.7025,0,0,0,0,100,0),
-(@PATH,41,5011.182,-4745.968,219.433,0,0,0,0,100,0),
-(@PATH,42,5013.682,-4748.968,219.683,0,0,0,0,100,0),
-(@PATH,43,5014.682,-4750.218,219.683,0,0,0,0,100,0),
-(@PATH,44,5013.822,-4749.14,219.4679,0,0,0,0,100,0),
-(@PATH,45,5015.072,-4750.64,219.7179,0,0,0,0,100,0),
-(@PATH,46,5015.822,-4751.89,219.7179,0,0,0,0,100,0),
-(@PATH,47,5016.797,-4758.994,219.9411,0,0,0,0,100,0),
-(@PATH,48,5014.797,-4760.244,219.9411,0,0,0,0,100,0),
-(@PATH,49,5013.047,-4760.994,219.9411,0,0,0,0,100,0),
-(@PATH,50,5011.547,-4761.994,220.6911,0,0,0,0,100,0),
-(@PATH,51,5010.547,-4762.744,221.1911,0,0,0,0,100,0),
-(@PATH,52,5008.547,-4763.994,221.6911,0,0,0,0,100,0),
-(@PATH,53,5007.547,-4764.494,221.9411,0,0,0,0,100,0),
-(@PATH,54,5016.685,-4757.653,219.5163,0,0,0,0,100,0),
-(@PATH,55,5016.685,-4757.653,219.5163,4.85295,0,0,0,100,0),
-(@PATH,56,5014.053,-4759.563,219.7658,0,0,0,0,100,0),
-(@PATH,57,5012.553,-4760.563,219.7658,0,0,0,0,100,0),
-(@PATH,58,5011.053,-4761.563,220.5158,0,0,0,0,100,0),
-(@PATH,59,5010.053,-4762.563,221.2658,0,0,0,0,100,0),
-(@PATH,60,5007.553,-4764.063,221.7658,0,0,0,0,100,0),
-(@PATH,61,5005.303,-4765.813,222.0158,0,0,0,0,100,0),
-(@PATH,62,5003.553,-4767.063,222.0158,0,0,0,0,100,0),
-(@PATH,63,5000.803,-4769.063,221.2658,0,0,0,0,100,0),
-(@PATH,64,4999.553,-4769.813,220.5158,0,0,0,0,100,0),
-(@PATH,65,4998.303,-4770.813,219.7658,0,0,0,0,100,0),
-(@PATH,66,5015.091,-4758.8,219.5454,0,0,0,0,100,0),
-(@PATH,67,5015.091,-4758.8,219.5454,3.765347,0,0,0,100,0),
-(@PATH,68,5013.777,-4759.399,219.7824,0,0,0,0,100,0),
-(@PATH,69,5012.027,-4760.149,219.5324,0,0,0,0,100,0),
-(@PATH,70,5010.527,-4760.399,220.5324,0,0,0,0,100,0),
-(@PATH,71,5009.027,-4761.149,221.2824,0,0,0,0,100,0),
-(@PATH,72,5007.277,-4761.899,221.5324,0,0,0,0,100,0),
-(@PATH,73,5005.277,-4761.899,222.0324,0,0,0,0,100,0),
-(@PATH,74,5003.527,-4763.399,222.2824,0,0,0,0,100,0),
-(@PATH,75,5001.527,-4764.899,222.2824,0,0,0,0,100,0),
-(@PATH,76,4998.527,-4766.399,221.2824,0,0,0,0,100,0),
-(@PATH,77,4997.527,-4767.149,220.7824,0,0,0,0,100,0),
-(@PATH,78,4996.527,-4767.399,219.7824,0,0,0,0,100,0),
-(@PATH,79,4995.777,-4767.649,219.7824,0,0,0,0,100,0),
-(@PATH,80,4991.527,-4767.899,219.7824,0,0,0,0,100,0),
-(@PATH,81,4987.777,-4765.649,219.7824,0,0,0,0,100,0),
-(@PATH,82,4981.399,-4761.659,219.763,0,0,0,0,100,0),
-(@PATH,83,4977.899,-4756.159,219.763,0,0,0,0,100,0),
-(@PATH,84,4977.707,-4755.765,219.7526,0,0,0,0,100,0),
-(@PATH,85,4976.957,-4754.515,219.7526,0,0,0,0,100,0),
-(@PATH,86,4974.813,-4749.59,219.7486,0,0,0,0,100,0),
-(@PATH,87,4975.045,-4750.456,219.4998,0,0,0,0,100,0),
-(@PATH,88,4975.045,-4750.456,219.4998,1.989743,0,0,0,100,0),
-(@PATH,89,4969.571,-4736.454,219.7493,0,0,0,0,100,0),
-(@PATH,90,4968.821,-4734.204,219.7493,0,0,0,0,100,0),
-(@PATH,91,4972.802,-4744.884,219.4986,0,0,0,0,100,0),
-(@PATH,92,4972.802,-4744.884,219.4986,1.953552,0,0,0,100,0),
-(@PATH,93,4969.699,-4736.418,219.7488,0,0,0,0,100,0),
-(@PATH,94,4968.699,-4734.168,219.7488,0,0,0,0,100,0);
-
--- Runed Giant SAI
-SET @ENTRY := 26417;
-UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0 AND `id`=2;
-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
-(@ENTRY,0,2,0,1,0,100,0,5000,5000,10000,10000,49,0,0,0,0,0,0,19,26261,15,0,0,0,0,0,"Runed Giant - Out of Combat - Start Attacking");
-
-SET @NPC := 86438;
-SET @PATH := @NPC * 10;
-UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4795.183,`position_y`=-4858.25,`position_z`=25.82121 WHERE `guid`=@NPC;
-DELETE FROM `creature_addon` WHERE `guid`=@NPC;
-INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
-DELETE FROM `waypoint_data` WHERE `id`=@PATH;
-INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-(@PATH,1,4795.183,-4858.25,25.82121,0,0,0,0,100,0),
-(@PATH,2,4793.933,-4857.25,25.82121,0,0,0,0,100,0),
-(@PATH,3,4786.933,-4851,25.82121,0,0,0,0,100,0),
-(@PATH,4,4783.933,-4848.5,25.57121,0,0,0,0,100,0),
-(@PATH,5,4775.606,-4841.151,25.45528,0,0,0,0,100,0),
-(@PATH,6,4775.606,-4841.151,25.45528,2.513274,0,0,0,100,0),
-(@PATH,7,4783.6,-4848.556,25.60373,0,0,0,0,100,0),
-(@PATH,8,4786.35,-4851.306,25.85373,0,0,0,0,100,0),
-(@PATH,9,4793.35,-4858.056,25.85373,0,0,0,0,100,0),
-(@PATH,10,4793.512,-4857.986,25.97804,0,0,0,0,100,0),
-(@PATH,11,4794.762,-4859.236,25.97804,0,0,0,0,100,0),
-(@PATH,12,4798.762,-4857.986,25.72804,0,0,0,0,100,0),
-(@PATH,13,4800.262,-4857.736,25.72804,0,0,0,0,100,0),
-(@PATH,14,4802.262,-4856.986,25.72804,0,0,0,0,100,0),
-(@PATH,15,4810.12,-4854.692,25.79934,0,0,0,0,100,0),
-(@PATH,16,4816.12,-4851.192,25.79934,0,0,0,0,100,0),
-(@PATH,17,4818.37,-4850.192,25.54934,0,0,0,0,100,0),
-(@PATH,18,4819.37,-4849.692,25.54934,0,0,0,0,100,0),
-(@PATH,19,4821.12,-4848.942,25.79934,0,0,0,0,100,0),
-(@PATH,20,4823.87,-4847.192,25.54934,0,0,0,0,100,0),
-(@PATH,21,4825.23,-4846.544,25.45987,5.550147,0,0,0,100,0),
-(@PATH,22,4823.903,-4847.049,25.59635,0,0,0,0,100,0),
-(@PATH,23,4821.653,-4848.049,25.59635,0,0,0,0,100,0),
-(@PATH,24,4820.403,-4848.549,25.59635,0,0,0,0,100,0),
-(@PATH,25,4816.653,-4850.049,25.59635,0,0,0,0,100,0),
-(@PATH,26,4814.903,-4850.549,25.59635,0,0,0,0,100,0),
-(@PATH,27,4803.903,-4854.799,25.84635,0,0,0,0,100,0),
-(@PATH,28,4800.153,-4856.299,25.84635,0,0,0,0,100,0),
-(@PATH,29,4799.153,-4856.799,25.84635,0,0,0,0,100,0),
-(@PATH,30,4795.174,-4858.254,25.82136,0,0,0,0,100,0),
-(@PATH,31,4793.924,-4857.254,25.82136,0,0,0,0,100,0),
-(@PATH,32,4786.924,-4851.004,25.82136,0,0,0,0,100,0),
-(@PATH,33,4783.924,-4848.504,25.57136,0,0,0,0,100,0),
-(@PATH,34,4775.606,-4841.151,25.45528,0,0,0,0,100,0),
-(@PATH,35,4775.606,-4841.151,25.45528,2.513274,0,0,0,100,0);
-
-SET @NPC := 86437;
-SET @PATH := @NPC * 10;
-UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4766.285,`position_y`=-4851.221,`position_z`=25.88538 WHERE `guid`=@NPC;
-DELETE FROM `creature_addon` WHERE `guid`=@NPC;
-INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
-DELETE FROM `waypoint_data` WHERE `id`=@PATH;
-INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-(@PATH,1,4766.285,-4851.221,25.88538,0,0,0,0,100,0),
-(@PATH,2,4764.035,-4852.971,25.63538,0,0,0,0,100,0),
-(@PATH,3,4762.535,-4853.971,25.38538,0,0,0,0,100,0),
-(@PATH,4,4761.535,-4853.971,25.38538,0,0,0,0,100,0),
-(@PATH,5,4760.035,-4853.971,25.63538,0,0,0,0,100,0),
-(@PATH,6,4758.785,-4853.971,26.13538,0,0,0,0,100,0),
-(@PATH,7,4758.035,-4854.221,26.38538,0,0,0,0,100,0),
-(@PATH,8,4756.035,-4854.471,26.38538,0,0,0,0,100,0),
-(@PATH,9,4753.785,-4854.971,26.38538,0,0,0,0,100,0),
-(@PATH,10,4752.035,-4855.221,26.38538,0,0,0,0,100,0),
-(@PATH,11,4748.035,-4856.471,26.38538,0,0,0,0,100,0),
-(@PATH,12,4745.785,-4856.721,26.38538,0,0,0,0,100,0),
-(@PATH,13,4739.535,-4857.221,26.38538,0,0,0,0,100,0),
-(@PATH,14,4733.245,-4857.637,26.4931,0,0,0,0,100,0),
-(@PATH,15,4733.245,-4857.637,26.4931,2.617994,0,0,0,100,0),
-(@PATH,16,4737.667,-4857.782,26.4303,0,0,0,0,100,0),
-(@PATH,17,4739.417,-4857.782,26.4303,0,0,0,0,100,0),
-(@PATH,18,4745.917,-4857.782,26.4303,0,0,0,0,100,0),
-(@PATH,19,4747.667,-4857.782,26.1803,0,0,0,0,100,0),
-(@PATH,20,4750.917,-4857.782,26.1803,0,0,0,0,100,0),
-(@PATH,21,4752.667,-4857.782,26.1803,0,0,0,0,100,0),
-(@PATH,22,4755.667,-4857.782,26.1803,0,0,0,0,100,0),
-(@PATH,23,4755.755,-4857.606,26.16596,0,0,0,0,100,0),
-(@PATH,24,4758.755,-4857.606,25.91596,0,0,0,0,100,0),
-(@PATH,25,4761.005,-4855.856,25.66596,0,0,0,0,100,0),
-(@PATH,26,4762.505,-4854.356,25.41596,0,0,0,0,100,0),
-(@PATH,27,4764.255,-4853.106,25.66596,0,0,0,0,100,0),
-(@PATH,28,4766.005,-4851.606,25.66596,0,0,0,0,100,0);
-
--- Shade of Arugal SAI
-SET @ENTRY := 27018;
-UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
-(@ENTRY,0,0,0,1,0,100,0,1000,1000,20000,20000,11,48185,0,0,0,0,0,19,27024,20,0,0,0,0,0,"Shade of Arugal - Out of Combat - Cast 'Arugal Channel'"),
-(@ENTRY,0,1,0,0,0,100,0,2000,3000,2000,3000,11,53086,0,0,0,0,0,2,0,0,0,0,0,0,0,"Shade of Arugal - In Combat - Cast 'Shadow Bolt'");
-
-DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceGroup`=1 AND `SourceEntry`=48185;
-INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
-(13, 1, 48185, 0, 0, 31, 0, 3, 27024, 0, 0, 0, 0, '', 'Arugal Channel only target Cultists');
diff --git a/sql/updates/world/2015_05_24_05_world.sql b/sql/updates/world/2015_05_24_05_world.sql
deleted file mode 100644
index 2b3641b257c..00000000000
--- a/sql/updates/world/2015_05_24_05_world.sql
+++ /dev/null
@@ -1,10 +0,0 @@
--- Scarlet Hound
-DELETE  FROM `creature` WHERE `id` IN (10979);
-DELETE  FROM `creature_addon` WHERE `guid` IN (52633, 52634, 52635, 52637, 52641, 52662, 52664, 52665, 52666, 52667, 52668);
-UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=10979;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=10979 AND `source_type`=0;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=1831 AND `source_type`=0 AND `id`=2;
-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
-(1831, 0, 2, 0, 25, 0, 100, 0, 0, 0, 0, 0, 11, 17164, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0,0,'Scarlet Hunter - On Reset - Cast to summon Scarlet Hound'),
-(10979, 0, 0, 0, 0, 0, 100, 0, 3000, 7000, 6000, 9000, 11, 17260, 2, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0,0,'Scarlet Hound - IC - Cast Bite'),
-(10979, 0, 1, 0, 0, 0, 100, 0, 5000, 10000, 22000, 25000, 11, 59274, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0,0,'Scarlet Hound - IC - Furious Howl');
diff --git a/sql/updates/world/2015_05_24_06_world.sql b/sql/updates/world/2015_05_24_06_world.sql
deleted file mode 100644
index 756b2d569cf..00000000000
--- a/sql/updates/world/2015_05_24_06_world.sql
+++ /dev/null
@@ -1,45 +0,0 @@
--- DB/Quest: Escape from the Staging Grounds
-DELETE FROM `waypoints` WHERE `entry`=20763;
-INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`) VALUES
-(20763, 1, 4081.3, 2296.6, 110.75),
-(20763, 2, 4095.3, 2296.37, 108.392),
-(20763, 3, 4123.42, 2297.51, 104.368),
-(20763, 4, 4146.48, 2298.85, 102.475),
-(20763, 5, 4169.75, 2301.11, 104.503),
-(20763, 6, 4181.37, 2301.19, 108.692),
-(20763, 7, 4195.51, 2301.28, 113.981),
-(20763, 8, 4215.69, 2295.79, 122.162),
-(20763, 9, 4229.79, 2295.09, 127.068),
-(20763, 10, 4250.86, 2293.49, 128.848),
-(20763, 11, 4271.72, 2290, 125.243),
-(20763, 12, 4277.21, 2276.97, 125.337),
-(20763, 13, 4269.13, 2262.97, 127.868),
-(20763, 14, 4262.07, 2250.73, 131.257),
-(20763, 15, 4253.95, 2236.66, 134.959),
-(20763, 16, 4249.61, 2220.86, 137.445),
-(20763, 17, 4251.74, 2186.12, 137.08),
-(20763, 18, 4252, 2172.27, 137.678);
-
--- Captured Protectorate Vanguard SAI
-SET @ENTRY := 20763;
-UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
-(@ENTRY,0,0,1,19,0,100,0,10425,0,0,0,1,0,0,0,0,0,0,21,10,0,0,0,0,0,0,"Captured Protectorate Vanguard - On Quest 'Escape from the Staging Grounds' Taken - Say Line 0"),
-(@ENTRY,0,1,2,61,0,100,0,10425,0,0,0,53,0,20763,0,0,0,2,1,0,0,0,0,0,0,0,"Captured Protectorate Vanguard - On Quest 'Escape from the Staging Grounds' Taken - Start Waypoint"),
-(@ENTRY,0,2,14,61,0,100,0,10425,0,0,0,64,1,0,0,0,0,0,21,10,0,0,0,0,0,0,"Captured Protectorate Vanguard - On Quest 'Escape from the Staging Grounds' Taken - Store Targetlist"),
-(@ENTRY,0,7,0,40,0,100,0,16,20763,0,0,54,4000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Captured Protectorate Vanguard - On Waypoint 16 Reached - Pause Waypoint"),
-(@ENTRY,0,8,10,40,0,100,0,17,20763,0,0,15,10425,0,0,0,0,0,12,1,0,0,0,0,0,0,"Captured Protectorate Vanguard - On Waypoint 17 Reached - Quest Credit 'Escape from the Staging Grounds'"),
-(@ENTRY,0,9,0,6,0,100,0,0,0,0,0,6,10425,0,0,0,0,0,12,1,0,0,0,0,0,0,"Captured Protectorate Vanguard - On Just Died - Fail Quest 'Escape from the Staging Grounds'"),
-(@ENTRY,0,10,0,61,0,100,0,17,20763,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Captured Protectorate Vanguard - On Waypoint 17 Reached - Say Line 1"),
-(@ENTRY,0,11,12,40,0,100,0,18,20763,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Captured Protectorate Vanguard - On Waypoint 18 Reached - Say Line 2"),
-(@ENTRY,0,12,13,61,0,100,0,18,20763,0,0,11,35517,0,0,0,0,0,1,0,0,0,0,0,0,0,"Captured Protectorate Vanguard - On Waypoint 18 Reached - Cast 'Teleport'"),
-(@ENTRY,0,13,0,61,0,100,0,18,20763,0,0,41,3000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Captured Protectorate Vanguard - On Waypoint 18 Reached - Despawn In 3000 ms"),
-(@ENTRY,0,14,0,61,0,100,0,10425,0,0,0,81,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Captured Protectorate Vanguard - On Quest 'Escape from the Staging Grounds' Taken - Set Npc Flag "),
-(@ENTRY,0,15,0,11,0,100,0,0,0,0,0,81,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Captured Protectorate Vanguard - On Respawn - Set Npc Flag Questgiver");
-
-DELETE FROM `creature_text` WHERE `entry`=20763;
-INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextID`, `comment`) VALUES
-(20763, 0, 0, 'We''re not too far from the Protectorate Watch Post, $n. This way!', 12, 0, 100, 0, 0, 0, 18566, 'Captured Protectorate Vanguard to Player'),
-(20763, 1, 0, 'Commander! This fleshling rescued me!', 12, 0, 100, 0, 0, 0, 18567, 'Captured Protectorate Vanguard to Player'),
-(20763, 2, 0, '%s salutes Commander Ameer.', 16, 0, 100, 0, 0, 0, 18568, 'Captured Protectorate Vanguard to Player');
diff --git a/sql/updates/world/2015_05_24_07_world.sql b/sql/updates/world/2015_05_24_07_world.sql
deleted file mode 100644
index af7e82b8087..00000000000
--- a/sql/updates/world/2015_05_24_07_world.sql
+++ /dev/null
@@ -1,30 +0,0 @@
--- Dragonflayer Fanatic
-DELETE FROM `waypoints` WHERE `entry`=26553;
-INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`) VALUES 
-(26553,1,467.5089,-325.5417,104.0859),
-(26553,2,483.179,-325.046,104.0471);
-
--- Dragonflayer Fanatic SAI
-SET @GUID := -126160;
-UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=26553;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=@GUID 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
-(@GUID,0,0,0,25,0,100,0,0,0,0,0,53,0,26553,1,0,0,0,1,0,0,0,0,0,0,0,"Dragonflayer Fanatic - On Reset - Start Waypoint"),
-(@GUID,0,1,0,40,0,100,0,1,26553,0,0,80,12616000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dragonflayer Fanatic - On Waypoint 1 Reached - Run Script"),
-(@GUID,0,2,0,40,0,100,0,2,26553,0,0,80,12616001,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dragonflayer Fanatic - On Waypoint 2 Reached - Run Script"),
-(@GUID,0,3,0,1,1,100,0,2000,2000,2000,2000,10,274,25,5,22,0,0,1,0,0,0,0,0,0,0,"Dragonflayer Fanatic - Out of Combat - Play Random Emote (274, 25, 5, 22)");
-
--- Actionlist SAI
-SET @ENTRY := 12616000;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
-(@ENTRY,9,0,0,0,0,100,0,0,0,0,0,54,35000,0,0,0,0,0,1,0,0,0,0,0,0,0,"On Script - Pause Waypoint"),
-(@ENTRY,9,1,0,0,0,100,0,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"On Script - Set Event Phase 1"),
-(@ENTRY,9,2,0,0,0,100,0,35000,35000,0,0,22,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"On Script - Set Event Phase 2");
-
--- Actionlist SAI
-SET @ENTRY := 12616001;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
-(@ENTRY,9,0,0,0,0,100,0,0,0,0,0,54,15000,0,0,0,0,0,1,0,0,0,0,0,0,0,"On Script - Pause Waypoint"),
-(@ENTRY,9,1,0,0,0,100,0,2000,2000,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,5.986479,"On Script - Set Orientation 5,986479");
diff --git a/sql/updates/world/2015_05_24_08_world.sql b/sql/updates/world/2015_05_24_08_world.sql
deleted file mode 100644
index d8bc19aaffb..00000000000
--- a/sql/updates/world/2015_05_24_08_world.sql
+++ /dev/null
@@ -1,94 +0,0 @@
--- Complete UP Movement
-SET @NPC := 126159;
-SET @PATH := @NPC * 10;
-UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=408.6479,`position_y`=-247.8646,`position_z`=105.1593 WHERE `guid`=@NPC;
-DELETE FROM `creature_addon` WHERE `guid`=@NPC;
-INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
-DELETE FROM `waypoint_data` WHERE `id`=@PATH;
-INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-(@PATH,1,408.6479,-247.8646,105.1593,0,0,0,0,100,0),
-(@PATH,2,413.1479,-247.3646,105.4093,0,0,0,0,100,0),
-(@PATH,3,417.3979,-247.1146,105.4093,0,0,0,0,100,0),
-(@PATH,4,421.3979,-246.8646,105.1593,0,0,0,0,100,0),
-(@PATH,5,424.6479,-246.8646,105.4093,0,0,0,0,100,0),
-(@PATH,6,431.6479,-246.3646,105.1593,0,0,0,0,100,0),
-(@PATH,7,437.3979,-245.8646,105.1593,0,0,0,0,100,0),
-(@PATH,8,439.8979,-245.6146,105.1593,0,6000,0,0,100,0),
-(@PATH,9,439.8979,-245.6146,105.1593,0,0,0,0,100,0),
-(@PATH,10,437.3979,-245.8646,105.1593,0,0,0,0,100,0),
-(@PATH,11,431.6479,-246.3646,105.1593,0,0,0,0,100,0),
-(@PATH,12,424.6479,-246.8646,105.4093,0,0,0,0,100,0),
-(@PATH,13,421.3979,-246.8646,105.1593,0,0,0,0,100,0),
-(@PATH,14,417.3979,-247.1146,105.4093,0,0,0,0,100,0),
-(@PATH,15,413.1479,-247.3646,105.4093,0,0,0,0,100,0),
-(@PATH,16,408.6479,-247.8646,105.1593,0,6000,0,0,100,0);
-
-SET @NPC := 126083;
-SET @PATH := @NPC * 10;
-UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=281.2139,`position_y`=-383.5794,`position_z`=90.28523 WHERE `guid`=@NPC;
-DELETE FROM `creature_addon` WHERE `guid`=@NPC;
-INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
-DELETE FROM `waypoint_data` WHERE `id`=@PATH;
-INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-(@PATH, 10, 273.909, -398.059, 90.1069, 0, 10, 0, 0, 100, 0),
-(@PATH, 9, 262.177, -400.701, 83.5446, 0, 10, 0, 0, 100, 0),
-(@PATH, 8, 248.65, -398.957, 75.1077, 0, 10, 0, 0, 100, 0),
-(@PATH, 7, 262.177, -400.701, 83.5446, 0, 10, 0, 0, 100, 0),
-(@PATH, 6, 273.909, -398.059, 90.1069, 0, 10, 0, 0, 100, 0),
-(@PATH, 5, 281.51, -396.934, 89.9561, 0, 10, 0, 0, 100, 0),
-(@PATH, 4, 281.066, -384.517, 90.0477, 0, 10, 0, 0, 100, 0),
-(@PATH, 3, 263.144, -381.767, 96.7176, 0, 10, 0, 0, 100, 0),
-(@PATH, 2, 248.789, -383.987, 104.753, 0, 10, 0, 0, 100, 0),
-(@PATH, 1, 263.144, -381.767, 96.7176, 0, 10, 0, 0, 100, 0);
-
-UPDATE `smart_scripts` SET `action_param1`=1 WHERE  `entryorguid`=26670 AND `source_type`=0 AND `id`=0 AND `link`=1;
-
-DELETE FROM `creature_formations` WHERE `leaderGUID`=126083;
-INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES 
-(126083, 126087, 3, 270, 2, 0, 0),
-(126083, 126088, 3, 90, 2, 0, 0),
-(126083, 126083, 0, 0, 2, 0, 0);
-
-
-SET @NPC := 126086;
-SET @PATH := @NPC * 10;
-UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC;
-DELETE FROM `creature_addon` WHERE `guid`=@NPC;
-INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
-DELETE FROM `waypoint_data` WHERE `id`=@PATH;
-INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-(@PATH, 8, 238.128, -450.66, 104.736, 0, 10, 0, 0, 100, 0),
-(@PATH, 7, 236.583, -435.635, 104.736, 0, 10, 0, 0, 100, 0),
-(@PATH, 6, 236.444, -449.692, 104.736, 0, 10, 0, 0, 100, 0),
-(@PATH, 5, 238.128, -450.66, 104.736, 0, 10, 0, 0, 100, 0),
-(@PATH, 4, 309.006, -451.589, 104.718, 0, 10, 0, 0, 100, 0),
-(@PATH, 3, 310.79, -451.589, 104.718, 0, 10, 0, 0, 100, 0),
-(@PATH, 2, 310.682, -467.433, 104.718, 0, 10, 0, 0, 100, 0),
-(@PATH, 1, 310.79, -451.589, 104.718, 0, 10, 0, 0, 100, 0);
-
-DELETE FROM `creature_formations` WHERE `leaderGUID`=126086;
-INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES 
-(126086, 126078, 5, 180, 2, 0, 0),
-(126086, 126081, 5, 90, 2, 0, 0),
-(126086, 126082, 5, 270, 2, 0, 0),
-(126086, 126086, 0, 0, 2, 0, 0);
-
-SET @NPC := 126111;
-SET @PATH := @NPC * 10;
-UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC;
-DELETE FROM `creature_addon` WHERE `guid`=@NPC;
-INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
-DELETE FROM `waypoint_data` WHERE `id`=@PATH;
-INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-(@PATH, 7, 368.053, -432.959, 75.1209, 0, 10, 0, 0, 100, 0),
-(@PATH, 6, 402.875, -428.319, 75.1263, 0, 10, 0, 0, 100, 0),
-(@PATH, 5, 407.49, -441.521, 75.0988, 0, 10, 0, 0, 100, 0),
-(@PATH, 4, 429.311, -447.42, 75.1166, 0, 10, 0, 0, 100, 0),
-(@PATH, 3, 428.506, -467.335, 75.1153, 0, 10, 0, 0, 100, 0),
-(@PATH, 2, 400.957, -455.234, 75.1132, 0, 10, 0, 0, 100, 0),
-(@PATH, 1, 372.02, -450.569, 75.1308, 0, 10, 0, 0, 100, 0);
-
-DELETE FROM `creature_formations` WHERE `leaderGUID`=126111;
-INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES 
-(126111, 126110, 3, 280, 2, 0, 0),
-(126111, 126111, 0, 0, 2, 0, 0);
diff --git a/sql/updates/world/2015_05_25_00_world.sql b/sql/updates/world/2015_05_25_00_world.sql
deleted file mode 100644
index 4b1cc48da5a..00000000000
--- a/sql/updates/world/2015_05_25_00_world.sql
+++ /dev/null
@@ -1,6 +0,0 @@
--- 
--- Forsaken Crossbowman SAI
-SET @ENTRY := 23883;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0 AND `id`=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
-(@ENTRY,0,0,0,1,0,100,0,0,2000,2000,3000,11,61512,0,0,0,0,0,19,23803,200,0,0,0,0,0,"Forsaken Crossbowman - Out of Combat - Cast 'Shoot'");
diff --git a/sql/updates/world/2015_05_26_01_world.sql b/sql/updates/world/2015_05_26_01_world.sql
deleted file mode 100644
index b1dd41196a6..00000000000
--- a/sql/updates/world/2015_05_26_01_world.sql
+++ /dev/null
@@ -1,40 +0,0 @@
---
-DELETE FROM `creature_formations` WHERE `leaderGUID`=26233;
-INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`)VALUES
-(26233,26233,0,0,2),(26233,26192,15,0,2),(26233,26194,15,90,2),(26233,26193,9,0,2),(26233,26195,9,90,2);
-UPDATE `creature` SET `MovementType`=2 WHERE `guid` IN (26233);
-UPDATE `creature_addon`  SET `path_id`=262330 WHERE `guid` IN (26233);
-DELETE FROM `creature_addon` WHERE `guid` IN  (26233);
-INSERT INTO `creature_addon` (`guid`, `path_id`) VALUES (26233, 262330);
-DELETE FROM `waypoint_data` WHERE `id` IN (262330);
-INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES
-(262330, 1,-1317.949951, -926.414978, 1.9346, 0, 0, 0, 0, 100, 0),
-(262330, 2,-1244.693726, -980.329773, -4.920392, 0, 0, 0, 0, 100, 0), 
-(262330, 3,-1193.669312, -948.340393, -3.643325, 0, 0, 0, 0, 100, 0), 
-(262330, 4,-1182.622681, -859.417419, -11.058956, 0, 0, 0, 0, 100, 0),
-(262330, 5,-1183.541138, -796.475952, -36.551662, 0, 0, 0, 0, 100, 0),
-(262330, 6,-1182.812988, -740.116638, -52.754967, 0, 0, 0, 0, 100, 0),
-(262330, 7,-1200.200806, -605.367249, -57.754887, 0, 0, 0, 0, 100, 0), 
-(262330, 8,-1242.377563, -494.067078, -57.610630, 0, 0, 0, 0, 100, 0), 
-(262330, 9,-1468.878052, -522.602173, -55.496475, 0, 0, 0, 0, 100, 0), 
-(262330, 10,-1551.133789, -656.098145, -50.817574, 0, 0, 0, 0, 100, 0), 
-(262330, 11,-1394.677490, -802.561279, -21.880009, 0, 0, 0, 0, 100, 0), 
-(262330, 12,-1317.949951, -926.414978, 1.9346, 0, 0, 0, 0, 100, 0);
-
-DELETE FROM `creature_formations` WHERE `leaderGUID`=26213;
-INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`)VALUES
-(26213,26213,0,0,2),(26213,26185,15,0,2),(26213,26207,15,90,2),(26213,26186,9,0,2),(26213,26187,9,90,2);
-UPDATE `creature` SET `MovementType`=2 WHERE `guid` IN (26213);
-UPDATE `creature_addon`  SET `path_id`=262130 WHERE `guid` IN (26213);
-DELETE FROM `creature_addon` WHERE `guid` IN  (26213);
-INSERT INTO `creature_addon` (`guid`, `path_id`) VALUES (26213, 262130);
-DELETE FROM `waypoint_data` WHERE `id` IN (262130);
-INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES
-(262130, 1,-2545.065918, 21.190157, 11.805480, 0, 0, 0, 0, 100, 0),
-(262130, 2,-2487.883789, 100.192146, 33.786736, 0, 0, 0, 0, 100, 0),
-(262130, 3,-2420.558350, 88.399445, 38.040539, 0, 0, 0, 0, 100, 0),
-(262130, 4,-2318.995361, 115.247169, 50.718586, 0, 0, 0, 0, 100, 0),
-(262130, 5,-2284.748779, 27.045509, 22.492968, 0, 0, 0, 0, 100, 0),
-(262130, 6,-2349.130615, -61.506725, -8.763674, 0, 0, 0, 0, 100, 0);
-
-UPDATE `creature` SET `MovementType`=1, `spawndist`=15 WHERE `guid` IN (26214, 26231, 26189, 26188, 26196, 26184, 26210, 26209, 26211, 26232, 26190, 26191, 26212);
diff --git a/sql/updates/world/2015_05_26_02_world.sql b/sql/updates/world/2015_05_26_02_world.sql
deleted file mode 100644
index d56e45a1514..00000000000
--- a/sql/updates/world/2015_05_26_02_world.sql
+++ /dev/null
@@ -1,8 +0,0 @@
---
-DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (12479, 12480, -12480)  AND `spell_effect` IN (12480, 530, -530);
-INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`)  VALUES 
-(12479, 12480, 0, 'Hex of Jammal''an'),
-(12480, 530, 0, 'Hex of Jammal''an'),
-(-12480, -530, 0, 'Hex of Jammal''an');
-
-UPDATE `smart_scripts` SET `event_type`=0, `Comment`= "Jammal'an the Prophet - In combat - Cast 'Hex of Jammal'an' (Phase 1)" WHERE `entryorguid`=5710 AND `source_Type`=0 AND `id`=5;
diff --git a/sql/updates/world/2015_05_26_03_world.sql b/sql/updates/world/2015_05_26_03_world.sql
deleted file mode 100644
index 30b5103caa8..00000000000
--- a/sql/updates/world/2015_05_26_03_world.sql
+++ /dev/null
@@ -1,3 +0,0 @@
---
-DELETE FROM `spell_group` WHERE `id`=1001 AND `spell_id` IN (45694, 20875, 25804, 25722, 25037);
-INSERT INTO `spell_group` (`id`, `spell_id`) VALUES (1001, 45694), (1001, 20875), (1001, 25804), (1001, 25722), (1001, 25037);
diff --git a/sql/updates/world/2015_05_26_04_world.sql b/sql/updates/world/2015_05_26_04_world.sql
deleted file mode 100644
index 39728f515ee..00000000000
--- a/sql/updates/world/2015_05_26_04_world.sql
+++ /dev/null
@@ -1,6 +0,0 @@
---
-DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid` IN (20748);
-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  
-(20748,0,0,0,25,0,100,0,0,0,0,0,11,37691,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Thunderlord Dire Wolf - On Reset - Cast Stealth Detection'),
-(20748,0,1,0,0,0,100,0,4000,6000,10000,11000,11,5781,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Thunderlord Dire Wolf - IC - Cast Threatening Growl'),
-(20748,0,2,0,8,0,100,0,32578,0,120000,120000,33,21142,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Thunderlord Dire Wolf - on spell hit - Credit quest');
diff --git a/sql/updates/world/UNABLE-2015_07_01_00_world_2015_05_22_15.sql b/sql/updates/world/UNABLE-2015_07_01_00_world_2015_05_22_15.sql
deleted file mode 100644
index c8556961769..00000000000
--- a/sql/updates/world/UNABLE-2015_07_01_00_world_2015_05_22_15.sql
+++ /dev/null
@@ -1,239 +0,0 @@
--- Quest 11343 "The Echo of Ymiron"
-
-SET @OGUID := 5603; -- One required
-SET @CGUID := 48229; -- 16 required
-SET @NPC := @CGUID+5;
-SET @PATH := @NPC * 10;
-
--- Object Spawn from sniff
-DELETE FROM `gameobject` WHERE `id`=186664;
-INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
-(@OGUID,186664,571,1,2,1073.001,-5033.952,9.771218,1.518436,0,0,0.6883545,0.7253745,300,0,1); -- Baby in Crib
-
--- Creature Spawns from sniff
-DELETE FROM `creature` WHERE `id` IN (24314,24315,24248,24327,23935);
-INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES
-(@CGUID+0,24314,571,1,2,0,0,1073.562,-5029.705,9.805857,4.660029,300,0,0,5158,0,0,0,0,0), -- Ancient Male Vrykul
-(@CGUID+1,24315,571,1,2,0,0,1074.889,-5033.892,9.711858,3.036873,300,0,0,5158,0,0,0,0,0), -- Ancient Female Vrykul
-(@CGUID+2,24248,571,1,2,0,0,1054.514,-4918.391,10.14754,3.263766,300,0,0,1,0,0,0,0,0),    -- The Lich King
-(@CGUID+3,24327,571,1,2,0,0,1055.667,-4924.913,16.54569,3.281219,300,0,0,1,0,0,0,0,0),    -- Val'kyr Soulclaimer
-(@CGUID+4,24327,571,1,2,0,0,1054.277,-4909.997,16.50003,3.263766,300,0,0,1,0,0,0,0,0),    -- Val'kyr Soulclaimer
-(@CGUID+5,23935,571,1,2,0,0,927.0462,-4925.752,4.78267,0.1288379,300,0,0,1,0,2,0,0,0),    -- Val'kyr Watcher
-(@CGUID+6,23935,571,1,2,0,0,1036.007,-4926.114,12.45767,5.548763,300,0,0,1,0,2,0,0,0),    -- Val'kyr Watcher
-(@CGUID+7,23935,571,1,2,0,0,1026.868,-4944.088,12.0571,0.7522717,300,0,0,1,0,2,0,0,0),    -- Val'kyr Watcher
-(@CGUID+8,23935,571,1,2,0,0,1028.676,-5012.598,13.78496,0.2954222,300,0,0,1,0,2,0,0,0),   -- Val'kyr Watcher
-(@CGUID+9,23935,571,1,2,0,0,910.7372,-4961.667,33.09615,0.2954222,300,0,0,1,0,2,0,0,0),   -- Val'kyr Watcher
-(@CGUID+10,23935,571,1,2,0,0,934.7177,-4890.745,34.57682,0.2954222,300,0,0,1,0,2,0,0,0),  -- Val'kyr Watcher
-(@CGUID+11,23935,571,1,2,0,0,970.6052,-4993.673,29.27757,0.2954222,300,0,0,1,0,2,0,0,0),  -- Val'kyr Watcher
-(@CGUID+12,23935,571,1,2,0,0,1006.246,-4868.183,47.70948,0.2954222,300,0,0,1,0,2,0,0,0),  -- Val'kyr Watcher
-(@CGUID+13,23935,571,1,2,0,0,1046.627,-4824.385,47.09693,0.2954222,300,0,0,1,0,2,0,0,0),  -- Val'kyr Watcher
-(@CGUID+14,23935,571,1,2,0,0,1068.264,-4965.238,47.55685,0.2954222,300,0,0,1,0,2,0,0,0),  -- Val'kyr Watcher
-(@CGUID+15,23935,571,1,2,0,0,1037.688,-4934.398,31.88609,0.2954222,300,0,0,1,0,2,0,0,0);  -- Val'kyr Watcher
-
-DELETE FROM `creature_template_addon` WHERE `entry` IN (24315,24248,24327);
-INSERT INTO `creature_template_addon` (`entry`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES
-(24315,0,0,1,0,0, ''),
-(24248,0,0,0,1,0, '41408'),
-(24327,0,0,33554432,0 ,0, '');
-
-UPDATE `creature_template` SET `AIName`='SmartAI', `unit_flags`=768 WHERE `entry` IN (24314, 24315, 24327);
-UPDATE `creature_template` SET `unit_flags`=164352, `AIName`='SmartAI' WHERE `entry`=24248;  -- 131072
-UPDATE `creature_template` SET `InhabitType`=4 WHERE `entry` IN (24327, 23935);
-
-DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid` IN (24314,24315, 24327, 24248);
-DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid` IN (2431400,2431500,2431501, 2424800, 2424801);
-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
-(24314,0,0,0,10,0,100,0,0,15,50000,50000,80,2431400,2,0,0,0,0,1,0,0,0,0,0,0,0, 'Ancient Male Vrykul - OOC_LOS - Start Script'),
-(2431400,9,0,0,0,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Anchient Male Speach 1'),
-(2431400,9,1,0,0,0,100,0,2000,2000,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Anchient Male Speach 2'),
-(2431400,9,2,0,0,0,100,0,3000,3000,0,0,1,0,0,0,0,0,0,10,@CGUID+1,24315,0,0,0,0,0, 'Anchient Female Speach 1'),
-(2431400,9,3,0,0,0,100,0,3000,3000,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Anchient Male Speach 2'),
-(2431400,9,4,0,0,0,100,0,3000,3000,0,0,5,25,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Anchient Male emote ONESHOT_POINT'),
-(2431400,9,5,0,0,0,100,0,6000,6000,0,0,45,0,1,0,0,0,0,10,@CGUID+1,24315,0,0,0,0,0, 'Anchient Female start path'),
-(2431400,9,6,0,0,0,100,0,5000,5000,0,0,1,1,0,0,0,0,0,10,@CGUID+1,24315,0,0,0,0,0, 'Anchient Female Speach 2'), -- check timing
-(2431400,9,7,0,0,0,100,0,4000,4000,0,0,5,18,0,0,0,0,0,10,@CGUID+1,24315,0,0,0,0,0, 'Anchient Female emote ONESHOT_CRY'),
-(2431400,9,8,0,0,0,100,0,4000,4000,0,0,1,3,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Anchient Male Speach 3'),
-(2431400,9,9,0,0,0,100,0,6000,6000,0,0,1,2,0,0,0,0,0,10,@CGUID+1,24315,0,0,0,0,0, 'Anchient Female Speach 2'),
-(2431400,9,10,0,0,0,100,0,3000,3000,0,0,11,43458,2,0,0,0,0,7,0,0,0,0,0,0,0, 'Quest Credit'),
-(2431400,9,11,0,0,0,100,0,3000,3000,0,0,45,0,2,0,0,0,0,10,@CGUID+1,24315,0,0,0,0,0, 'Anchient Female resume path'),
-(24315,0,0,0,11,0,100,0,0,0,0,0,8,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Ancient Female Vrykul - Set Passive'),
-(24315,0,1,0,38,0,100,0,0,1,0,0,80,2431500,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Ancient Female Vrykul - On data set 0 1 run script'),
-(24315,0,2,0,38,0,100,0,0,2,0,0,80,2431501,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Ancient Female Vrykul - On data set 0 2 run script'),
-(24315,0,3,4,40,0,100,0,1,24315,0,0,54,40000,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Ancient Female Vrykul - Pause at wp talk'),
-(24315,0,4,5,61,0,100,0,0,0,0,0,66,0,0,0,0,0,0,9,24315,0,15,0,0,0,0, 'Ancient Female Vrykul - turn to Ancient Male Vrykul'),
-(24315,0,5,0,61,0,100,0,0,0,0,0,90,8,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Ancient Female Vrykul - kneel'),
-(24315,0,6,7,40,0,100,0,2,24315,0,0,55,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Ancient Female Vrykul - Stop at wp home'),
-(24315,0,7,8,61,0,100,0,0,0,0,0,66,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Ancient Female Vrykul - turn to pos'),
-(24315,0,8,0,61,0,100,0,0,0,0,0,90,1,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Ancient Female Vrykul - kneel'),
-(2431500,9,0,0,0,0,100,0,0,0,0,0,91,1,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Ancient Female Vrykul - stand'),
-(2431500,9,1,0,0,0,100,0,0,0,0,0,53,0,24315,0,0,0,0,1,0,0,0,0,0,0,0, 'Ancient Female Vrykul - wp start'),
-(2431501,9,0,0,0,0,100,0,0,0,0,0,65,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Ancient Female Vrykul - wp resume'),
-(2431501,9,1,0,0,0,100,0,0,0,0,0,91,8,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Ancient Female Vrykul - stand'),
-(24327,0,0,0,11,0,100,0,0,0,0,0,8,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Ancient Male Vrykul - Set Passive'),
-
-(24248,0,0,0,10,0,100,0,0,15,3000,3000,80,2424800,2,0,0,0,0,1,0,0,0,0,0,0,0, 'The Lich King - OOC_LOS - Start Script'),
-(2424800,9,0,0,0,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Lich King - Action list - Talk0'),
-(2424800,9,1,0,0,0,100,0,0,0,0,0,11,29661,0,0,0,0,0,7,0,0,0,0,0,0,0, 'The Lich King - Action list - Cast Magnetic Pull'),
-(2424800,9,2,0,0,0,100,0,1000,1000,0,0,11,43489,0,0,0,0,0,7,0,0,0,0,0,0,0, 'The Lich King - Action list - Cast Grasp of the Lich King'),
-(2424800,9,3,0,0,0,100,0,1000,1000,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Lich King - Action list - Talk1'),
-(2424800,9,4,0,0,0,100,0,3000,3000,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Lich King - Action list - Talk2'),
-(2424800,9,5,0,0,0,100,0,15000,15000,0,0,1,0,0,0,0,0,0,19,24327,10,0,0,0,0,0, 'The Lich King - Action list - Talk0'),
-(2424800,9,6,0,0,0,100,0,3000,3000,0,0,1,3,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Lich King - Action list - Talk3'),
-(2424800,9,7,0,0,0,100,0,7000,7000,0,0,1,4,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Lich King - Action list - Talk4'),
-(2424800,9,8,0,0,0,100,0,19000,19000,0,0,1,5,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Lich King - Action list - Talk5'),
-(2424800,9,9,0,0,0,100,0,20000,20000,0,0,1,6,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Lich King - Action list - Talk6'),
-(2424800,9,10,0,0,0,100,0,17000,17000,0,0,11,43488,64,0,0,0,0,7,0,0,0,0,0,0,0, 'The Lich King - Action list - Cast'),
-(2424800,9,11,0,0,0,100,0,500,500,0,0,51,0,0,0,0,0,0,7,0,0,0,0,0,0,0, 'The Lich King - Action list - kill'),
-
-(24248,0,1,0,10,0,100,0,0,15,3000,3000,80,2424801,2,0,0,0,0,1,0,0,0,0,0,0,0, 'The Lich King - OOC_LOS - Start Script'),
-(2424801,9,0,0,0,0,100,0,0,0,0,0,1,7,0,0,0,0,0,1,0,0,0,0,0,0,0, 'The Lich King - Action list - Talk7'),
-(2424801,9,1,0,0,0,100,0,0,0,0,0,11,29661,0,0,0,0,0,7,0,0,0,0,0,0,0, 'The Lich King - Action list - Cast Magnetic Pull'),
-(2424801,9,2,0,0,0,100,0,1000,1000,0,0,11,43489,0,0,0,0,0,7,0,0,0,0,0,0,0, 'The Lich King - Action list - Cast Grasp of the Lich King'),
-(2424801,9,3,0,0,0,100,0,8000,8000,0,0,11,50156,0,0,0,0,0,7,0,0,0,0,0,0,0, 'The Lich King - Action list - Cast'),
-(2424801,9,4,0,0,0,100,0,500,500,0,0,51,0,0,0,0,0,0,7,0,0,0,0,0,0,0, 'The Lich King - Action list - kill');
-DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceGroup` IN (1,2) AND `SourceEntry` IN (24248, 24314);
-INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`, `ErrorTextId`,`ScriptName`,`Comment`, `NegativeCondition`) VALUES
-(22,1,24248,0,8,12485,0,0,0,'','event require quest 12485 not rewarded', 1),
-(22,2,24248,0,8,12485,0,0,0,'','event require quest 12485 rewarded', 0),
-(22,1,24314,0,9,11343,0,0,0,'','event require quest 11344 Taken', 0);
-
-DELETE FROM `disables` WHERE `sourceType` = 1 AND `entry` = 12485;
-
--- NPC Text from sniff
-DELETE FROM `creature_text` WHERE `entry` IN (24314,24315, 24248, 24327);
-INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`,`BroadcastTextId`) VALUES
-(24314,0,0, 'So then we too are cursed?',12,0,100,1,0,0, 'Ancient Male Vrykul',23116),
-(24314,1,0, '%s points to the infant.',16,0,100,0,0,0, 'Ancient Male Vrykul',23117),
-(24315,0,0, '%s sobs.',16,0,100,0,0,0, 'Ancient Female Vrykul',23118),
-(24314,2,0, 'The gods have forsaken us! We must dispose of it before Ymiron is notified!',12,0,100,53,0,0, 'Ancient Male Vrykul',23119),
-(24315,1,0, 'NO! You cannot! I beg of you! It is our child!',12,0,100,0,0,0, 'Ancient Female Vrykul',23120),
-(24314,3,0, 'Then what are we to do, wife? The others cannot find out. Should they learn of this aberration, we will all be executed.',12,0,100,1,0,0, 'Ancient Male Vrykul',23121),
-(24315,2,0, 'I... I will hide it. I will hide it until I find it a home, far away from here...',12,0,100,0,0,0, 'Ancient Female Vrykul',23122),
-(24248,0,0, '%s turns to face you.',16,0,100,0,0,0, 'The Lich King',23102),
-(24248,1,0, '%s grins. ',16,0,100,11,0,14820, 'The Lich King',23146),
-(24248,2,0, 'Shamanism has brought you here... Its scent permeates the air. *The Lich King laughs* I was once a shaman.',12,0,100,0,0,14742, 'The Lich King',23147),
-(24327,0,0, 'Shall we prepare it for you, my lord?',12,0,100,0,0,0, 'Val''kyr Soulclaimer',23152),
-(24248,3,0, 'No, minion. This one is not ready.',12,0,100,274,0,14743, 'The Lich King',23148),
-(24248,4,0, 'Do you feel it, mortal? Death seeps through me, enveloping all that I touch. With just a snap of my finger your soul will languish in damnation for all eternity.',12,0,100,1,0,14744, 'The Lich King',23149),
-(24248,5,0, 'But... It is not yet your time to serve the Lich King. Yes, a greater destiny awaits you. Power... You must become more powerful before you are to serve me.',12,0,100,1,0,14745, 'The Lich King',23150),
-(24248,6,0, 'Now watch, val''kyr. Observe as I apply pressure. Can you see that it is not yet ripe? Watch as it pops and falls lifeless to the floor.',12,0,100,1,0,14746, 'The Lich King',23151),
-(24248,7,0, 'Persistence or stupidity? It matters not. Let this be a lesson learned, mortal!',12,0,100,1,0,14747, 'The Lich King',27351);
-
--- Waypoints for Ancient Female Vrykul from sniff
-DELETE FROM `waypoints` WHERE `entry`=24315;
-INSERT INTO `waypoints` (`entry`,`pointid`,`position_x`,`position_y`,`position_z`,`point_comment`) VALUES
-(24315,1,1074.016,-5031.822,9.726947,'talk point'),
-(24315,2,1074.889,-5033.892,9.711858,'home point');
-
--- Pathing for Val'kyr Watcher Entry: 23935
-DELETE FROM `creature_addon` WHERE `guid` IN (@NPC,@NPC+1,@NPC+2,@NPC+3,@NPC+4,@NPC+5,@NPC+6,@NPC+7,@NPC+8,@NPC+9,@NPC+10);
-INSERT INTO `creature_addon` (`guid`,`path_id`) VALUES
-(@NPC,@PATH),
-(@NPC+1,@PATH+10),
-(@NPC+2,@PATH+20),
-(@NPC+3,@PATH+30),
-(@NPC+4,@PATH+40),
-(@NPC+5,@PATH+50),
-(@NPC+6,@PATH+60),
-(@NPC+7,@PATH+70),
-(@NPC+8,@PATH+80),
-(@NPC+9,@PATH+90),
-(@NPC+10,@PATH+100);
-
-DELETE FROM `waypoint_data` WHERE `id` IN (@PATH,@PATH+10,@PATH+20,@PATH+30,@PATH+40,@PATH+50,@PATH+60,@PATH+70,@PATH+80,@PATH+90,@PATH+100);
-INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`action`,`action_chance`,`wpguid`) VALUES
-(@PATH,1,946.877,-4950.67,8.72458,0,0,0,100,0),
-(@PATH,2,927.046,-4925.75,8.09321,0,0,0,100,0),
-(@PATH,3,929.734,-4899.67,9.95518,0,0,0,100,0),
-(@PATH,4,939.552,-4878.05,10.4938,0,0,0,100,0),
-(@PATH,5,929.734,-4899.67,9.95518,0,0,0,100,0),
-(@PATH,6,927.046,-4925.75,8.09321,0,0,0,100,0),
-(@PATH+10,1,1036.835,-4931.16,12.83267,0,0,0,100,0),
-(@PATH+10,2,1036.007,-4926.114,12.45767,0,0,0,100,0),
-(@PATH+10,3,1023.932,-4912.754,10.5369,0,0,0,100,0),
-(@PATH+10,4,1000.253,-4901.448,7.911896,0,0,0,100,0),
-(@PATH+10,5,1023.932,-4912.754,10.5369,0,0,0,100,0),
-(@PATH+10,6,1036.007,-4926.114,12.45767,0,0,0,100,0),
-(@PATH+20,1,1026.697,-4942.586,11.8071,0,0,0,100,0),
-(@PATH+20,2,1030.085,-4970.878,12.77823,0,0,0,100,0),
-(@PATH+20,3,1034.023,-4972.842,13.0493,0,0,0,100,0),
-(@PATH+20,4,1030.085,-4970.878,12.77823,0,0,0,100,0),
-(@PATH+20,5,1026.868,-4944.088,12.0571,0,0,0,100,0),
-(@PATH+30,1,1045.199,-5071.371,13.72586,0,0,0,100,0),
-(@PATH+30,2,1069.113,-5069.303,13.34213,0,0,0,100,0),
-(@PATH+30,3,1091.871,-5063.042,13.38427,0,0,0,100,0),
-(@PATH+30,4,1103.122,-5055.239,13.92861,0,0,0,100,0),
-(@PATH+30,5,1099.777,-5030.915,13.25463,0,0,0,100,0),
-(@PATH+30,6,1088.535,-5001.179,13.00463,0,0,0,100,0),
-(@PATH+30,7,1062.886,-4976.348,13.6743,0,0,0,100,0),
-(@PATH+30,8,1044.221,-4979.022,13.7993,0,0,0,100,0),
-(@PATH+30,9,1030.879,-4997.25,13.52823,0,0,0,100,0),
-(@PATH+30,10,1028.676,-5012.598,13.78496,0,0,0,100,0),
-(@PATH+30,11,1034.265,-5039.136,13.73875,0,0,0,100,0),
-(@PATH+40,1,919.0841,-4946.079,33.09615,0,0,0,100,0),
-(@PATH+40,2,937.5836,-4953.232,30.76281,0,0,0,100,0),
-(@PATH+40,3,936.755,-4970.46,30.76281,0,0,0,100,0),
-(@PATH+40,4,929.6907,-4992.461,30.76281,0,0,0,100,0),
-(@PATH+40,5,919.143,-5002.606,30.76281,0,0,0,100,0),
-(@PATH+40,6,899.7684,-4997.275,30.76281,0,0,0,100,0),
-(@PATH+40,7,894.8842,-4973.352,31.20726,0,0,0,100,0),
-(@PATH+40,8,910.7372,-4961.667,33.09615,0,0,0,100,0),
-(@PATH+50,1,955.5239,-4883.864,28.91015,0,0,0,100,0),
-(@PATH+50,2,975.0622,-4876.539,34.57682,0,0,0,100,0),
-(@PATH+50,3,998.4828,-4882.556,34.57682,0,0,0,100,0),
-(@PATH+50,4,1007.136,-4897.439,34.57682,0,0,0,100,0),
-(@PATH+50,5,999.5431,-4915.003,34.57682,0,0,0,100,0),
-(@PATH+50,6,977.8502,-4931.425,34.57682,0,0,0,100,0),
-(@PATH+50,7,955.9329,-4951.924,34.57682,0,0,0,100,0),
-(@PATH+50,8,932.5357,-4941.676,34.57682,0,0,0,100,0),
-(@PATH+50,9,928.3145,-4926.969,35.49352,0,0,0,100,0),
-(@PATH+50,10,934.7177,-4890.745,34.57682,0,0,0,100,0),
-(@PATH+60,1,985.4891,-4985.466,29.27757,0,0,0,100,0),
-(@PATH+60,2,1003.236,-5007.198,29.27757,0,0,0,100,0),
-(@PATH+60,3,1001.194,-5018.937,29.27757,0,0,0,100,0),
-(@PATH+60,4,983.9544,-5038.578,29.27757,0,0,0,100,0),
-(@PATH+60,5,965.2218,-5035.844,29.27757,0,0,0,100,0),
-(@PATH+60,6,955.2875,-5023.462,29.27757,0,0,0,100,0),
-(@PATH+60,7,964.6006,-5006.362,29.27757,0,0,0,100,0),
-(@PATH+60,8,970.6052,-4993.673,29.27757,0,0,0,100,0),
-(@PATH+70,1,997.6531,-4837.691,50.98726,0,0,0,100,0),
-(@PATH+70,2,978.2066,-4826.199,50.98726,0,0,0,100,0),
-(@PATH+70,3,954.6121,-4846.288,50.98726,0,0,0,100,0),
-(@PATH+70,4,915.1261,-4847.07,50.98726,0,0,0,100,0),
-(@PATH+70,5,906.7595,-4877.092,50.98726,0,0,0,100,0),
-(@PATH+70,6,911.5735,-4919.276,50.98726,0,0,0,100,0),
-(@PATH+70,7,942.1261,-4946.08,42.51503,0,0,0,100,0),
-(@PATH+70,8,978.0408,-4936.854,40.5428,0,0,0,100,0),
-(@PATH+70,9,1002.55,-4900.139,38.45948,0,0,0,100,0),
-(@PATH+70,10,1006.246,-4868.183,47.70948,0,0,0,100,0),
-(@PATH+80,1,1022.976,-4810.128,38.31916,0,0,0,100,0),
-(@PATH+80,2,996.8618,-4813.854,38.31916,0,0,0,100,0),
-(@PATH+80,3,964.6756,-4838.639,38.31916,0,0,0,100,0),
-(@PATH+80,4,940.3589,-4846.21,38.31916,0,0,0,100,0),
-(@PATH+80,5,907.9418,-4846.479,34.20804,0,0,0,100,0),
-(@PATH+80,6,887.7231,-4873.045,34.59694,0,0,0,100,0),
-(@PATH+80,7,891.8184,-4898.238,30.04136,0,0,0,100,0),
-(@PATH+80,8,912.4337,-4902.996,30.04136,0,0,0,100,0),
-(@PATH+80,9,939.5068,-4887.826,30.04136,0,0,0,100,0),
-(@PATH+80,10,961.7159,-4869.482,30.04136,0,0,0,100,0),
-(@PATH+80,11,1005.307,-4881.67,30.04136,0,0,0,100,0),
-(@PATH+80,12,1029.752,-4892.972,31.93025,0,0,0,100,0),
-(@PATH+80,13,1067.775,-4894.65,39.06914,0,0,0,100,0),
-(@PATH+80,14,1059.698,-4864.968,47.09693,0,0,0,100,0),
-(@PATH+80,15,1060.522,-4845.491,47.09693,0,0,0,100,0),
-(@PATH+80,16,1046.627,-4824.385,47.09693,0,0,0,100,0),
-(@PATH+90,1,1044.91,-4980.383,47.55685,0,0,0,100,0),
-(@PATH+90,2,1040.873,-5016.178,52.69574,0,0,0,100,0),
-(@PATH+90,3,1054.767,-5042.476,52.69574,0,0,0,100,0),
-(@PATH+90,4,1084.064,-5042.998,39.22352,0,0,0,100,0),
-(@PATH+90,5,1106.236,-5031.327,39.22352,0,0,0,100,0),
-(@PATH+90,6,1106.77,-4995.738,45.02908,0,0,0,100,0),
-(@PATH+90,7,1086.711,-4972.376,47.55685,0,0,0,100,0),
-(@PATH+90,8,1068.264,-4965.238,47.55685,0,0,0,100,0),
-(@PATH+100,1,1066.911,-4940.557,48.88609,0,0,0,100,0),
-(@PATH+100,2,1069.896,-4920.431,40.85831,0,0,0,100,0),
-(@PATH+100,3,1057.342,-4903.877,40.85831,0,0,0,100,0),
-(@PATH+100,4,1044.138,-4900.038,31.74721,0,0,0,100,0),
-(@PATH+100,5,1023.748,-4899.741,28.21942,0,0,0,100,0),
-(@PATH+100,6,1017.973,-4921.141,28.21942,0,0,0,100,0),
-(@PATH+100,7,1037.688,-4934.398,31.88609,0,0,0,100,0);
diff --git a/sql/updates/world/UNABLE-2015_07_01_00_world_2015_05_23_02.sql b/sql/updates/world/UNABLE-2015_07_01_00_world_2015_05_23_02.sql
deleted file mode 100644
index a9a1555b322..00000000000
--- a/sql/updates/world/UNABLE-2015_07_01_00_world_2015_05_23_02.sql
+++ /dev/null
@@ -1,7 +0,0 @@
---
-UPDATE `creature_template` SET `npcflag`=3, `gossip_menu_id`=694 WHERE `entry`=1343;
-DELETE FROM `gossip_menu` WHERE `entry`=694;
-INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (694, 1244);
-DELETE FROM `npc_text` WHERE `ID`=1244;
-INSERT INTO `npc_text` (`ID`, `text0_0`, `text0_1`, `BroadcastTextID0`, `lang0`, `prob0`, `em0_0`, `em0_1`) VALUES
-(1244, 'Well, if it isn''t a young, bristling $c, no doubt drawn here by talk of my exploits in fields of battle!$B$BNo time for stories now, for there are great, important deeds that need doing!  So if you''re looking for glory, then luck shines on you today...', 'Well, if it isn''t a young, bristling $c, no doubt drawn here by talk of my exploits in fields of battle!$B$BNo time for stories now, for there are great, important deeds that need doing!  So if you''re looking for glory, then luck shines on you today...', 0, 0, 1, 0, 0);
diff --git a/sql/updates/world/UNABLE-2015_07_01_00_world_2015_05_23_03.sql b/sql/updates/world/UNABLE-2015_07_01_00_world_2015_05_23_03.sql
deleted file mode 100644
index 25705f16ea4..00000000000
--- a/sql/updates/world/UNABLE-2015_07_01_00_world_2015_05_23_03.sql
+++ /dev/null
@@ -1,7 +0,0 @@
---
-UPDATE `creature_template` SET `npcflag`=3, `gossip_menu_id`=6159 WHERE `entry`=240;
-DELETE FROM `gossip_menu` WHERE `entry`=6159;
-INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (6159, 6157);
-DELETE FROM `npc_text` WHERE `ID`=6157;
-INSERT INTO `npc_text` (`ID`, `text0_0`, `text0_1`, `BroadcastTextID0`, `lang0`, `prob0`, `em0_0`, `em0_1`) VALUES
-(6157, 'Ach, it''s hard enough keeping order around here without all these new troubles popping up!  I hope you have good news, $n...', 'Ach, it''s hard enough keeping order around here without all these new troubles popping up!  I hope you have good news, $n...', 42172, 0, 1, 5, 5);
diff --git a/sql/updates/world/UNABLE-2015_07_01_00_world_2015_05_24_01.sql b/sql/updates/world/UNABLE-2015_07_01_00_world_2015_05_24_01.sql
deleted file mode 100644
index 72cb9b6b0a4..00000000000
--- a/sql/updates/world/UNABLE-2015_07_01_00_world_2015_05_24_01.sql
+++ /dev/null
@@ -1,365 +0,0 @@
--- Ammo for Rumbleshot
-UPDATE `creature` SET position_x = -6070.349121, position_y = -285.940399, position_z = 428.220367, orientation = 1.496177 WHERE guid = 263;
-UPDATE `creature` SET position_x = -6104.470703, position_y = -163.987122, position_z = 433.257080, orientation = 1.833880 WHERE guid = 1716;
-UPDATE `creature` SET position_x = -5988.834473, position_y = -135.639069, position_z = 400.818604, orientation = 4.441411 WHERE guid = 290;
--- Mortar Combat - event
--- correct spawn possition for all involved in event
-UPDATE `creature` SET position_x = -6009.25, position_y = -202.649994, position_z = 406.982605, orientation = 1.58825 WHERE guid = 269; -- angus
-UPDATE `creature` SET orientation = 0.03490658 WHERE guid = 265 ; -- hegnar
-UPDATE `creature` SET position_x = -6007.301758, position_y = -200.348206, position_z = 406.777496, orientation = 3.282219 WHERE guid = 272; -- klemmy
-UPDATE `creature` SET position_x = -6007.458984, position_y = -202.157593, position_z = 407.447937, orientation = 2.478368 WHERE guid = 267; -- shorty
-UPDATE `creature` SET position_x = -6010.668151495, position_y = -199.434006, position_z = 406.792480, orientation = 5.532694 WHERE guid = 268; -- middlecamp
-UPDATE `creature` SET position_x = -6008.527832, position_y = -199.145203, position_z = 406.687225, orientation = 4.372177 WHERE guid = 266; -- wheeler
-
-DELETE FROM `waypoints` WHERE `entry`=10610;
-INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES
-(10610, 1, -6009.25,-202.649994,406.982605, 'Angus'),
-(10610, 2, -6009.25,-202.649994,406.982605, 'Angus'),
-(10610, 3, -6009.25,-202.649994,406.982605, 'Angus'),
-(10610, 4, -6031.16,-230.264,414.361, 'Angus');
-
-DELETE FROM `spell_target_position` WHERE id IN (18634,16572,16767,16768,16772,16775,16776,16777,16778,16779,16780,16786,18634);
-INSERT INTO `spell_target_position` (id, target_map, target_position_x, target_position_y, target_position_z, target_orientation) VALUES
-(16572,0,-6046.85,-207.329,418.304,0),
-(16767,0,-6046.73,-207.159,417.267,0),
-(16768,0,-6051.39,-206.749,418.159,0),
-(16772,0,-6046.84,-204.535,416.897,0),
-(16775,0,-6044.47,-205.783,417.267,0),
-(16776,0,-6044.54,-205.562,417.663,0),
-(16777,0,-6044.53,-202.912,416.756,0),
-(16778,0,-6042.18,-204.949,416.336,0),
-(16779,0,-6042.02,-204.134,416.894,0),
-(16780,0,-6044.79,-196.959,419.19,0),
-(16786,0,-6078.3,-211.89,424.197,0),
-(18634,0,-6076,-215,424,0);
-
--- Hegnar Rumbleshot SAI
-SET @ENTRY := 1243;
-UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
-(@ENTRY,0,0,1,20,0,100,0,5541,0,0,0,45,1,0,0,0,0,0,19,10610,20,0,0,0,0,0,"Hegnar Rumbleshot - On Quest 'Ammo for Rumbleshot' Finished - Set Data 1 0"),
-(@ENTRY,0,1,2,61,0,100,0,5541,0,0,0,45,1,0,0,0,0,0,19,10611,20,0,0,0,0,0,"Hegnar Rumbleshot - On Quest 'Ammo for Rumbleshot' Finished - Set Data 1 0"),
-(@ENTRY,0,2,3,61,0,100,0,5541,0,0,0,45,1,0,0,0,0,0,19,10804,20,0,0,0,0,0,"Hegnar Rumbleshot - On Quest 'Ammo for Rumbleshot' Finished - Set Data 1 0"),
-(@ENTRY,0,3,4,61,0,100,0,5541,0,0,0,45,1,0,0,0,0,0,19,10805,20,0,0,0,0,0,"Hegnar Rumbleshot - On Quest 'Ammo for Rumbleshot' Finished - Set Data 1 0"),
-(@ENTRY,0,4,0,61,0,100,0,5541,0,0,0,45,1,0,0,0,0,0,19,10803,20,0,0,0,0,0,"Hegnar Rumbleshot - On Quest 'Ammo for Rumbleshot' Finished - Set Data 1 0"),
-(@ENTRY,0,5,0,38,0,100,0,2,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,3.68522,"Hegnar Rumbleshot - On Data Set 2 0 - Set Orientation 3,68522"),
-(@ENTRY,0,6,0,38,0,100,0,3,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,0.03490658,"Hegnar Rumbleshot - On Data Set 3 0 - Set Orientation 0.03490658");
-
--- Angus SAI
-SET @ENTRY := 10610;
-UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
-(@ENTRY,0,0,1,38,0,100,0,1,0,0,0,48,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Angus - On Data Set 1 0 - Set Active On"),
-(@ENTRY,0,1,2,61,0,100,0,1,0,0,0,53,0,10610,0,0,0,0,1,0,0,0,0,0,0,0,"Angus - On Data Set 1 0 - Start Waypoint"),
-(@ENTRY,0,2,0,61,0,100,0,1,0,0,0,4,6598,0,0,0,0,0,21,50,0,0,0,0,0,0,"Angus - On Data Set 1 0 - Play Sound 6598"),
-(@ENTRY,0,3,4,40,0,100,0,4,10610,0,0,54,250000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Angus - On Waypoint 4 Reached - Pause Waypoint"),
-(@ENTRY,0,4,0,61,0,100,0,4,10610,0,0,80,@ENTRY*100+00,0,0,0,0,0,1,0,0,0,0,0,0,0,"Angus - On Waypoint 4 Reached - Run Script"),
-(@ENTRY,0,5,0,38,0,100,0,2,0,0,0,69,0,0,0,0,0,0,8,0,0,0,-6009.25,-202.649994,406.982605,2,"Shorty - On Data Set 2 0 - Move To Position"),
-(@ENTRY,0,6,0,38,0,100,0,3,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,1.58825,"Shorty - On Data Set 3 0 - Set Orientation 1.58825");
-
--- Mortar Team Target Dummy SAI
-SET @ENTRY := 11875;
-UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
-(@ENTRY,0,0,0,1,0,100,1,100,100,0,0,75,42716,0,0,0,0,0,1,0,0,0,0,0,0,0,"Mortar Team Target Dummy - Out of Combat - Add Aura 'Self Root Forever (No Visual)' (No Repeat)");
-
--- move to eventplace
--- Shorty SAI
-SET @ENTRY := 10611;
-UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
-(@ENTRY,0,0,1,38,0,100,0,1,0,0,0,69,0,0,0,0,0,0,8,0,0,0,-6031.589,-228.182,414.4035,2,"Shorty - On Data Set 1 0 - Move To Position"),
-(@ENTRY,0,1,0,61,0,100,0,1,0,0,0,48,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shorty - On Data Set 1 0 - Set Active On"),
-(@ENTRY,0,2,0,38,0,100,0,2,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,2.18492,"Shorty - On Data Set 2 0 - Set Orientation 2,18492"),
-(@ENTRY,0,3,0,38,0,100,0,3,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,2.844887,"Shorty - On Data Set 3 0 - Set Orientation 2.844887"),
-(@ENTRY,0,4,0,38,0,100,0,4,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,4.54215,"Shorty - On Data Set 4 0 - Set Orientation 4.54215"),
-(@ENTRY,0,5,0,38,0,100,0,5,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,2.844887,"Shorty - On Data Set 4 0 - Set Orientation 2.844887"),
-(@ENTRY,0,6,0,38,0,100,0,6,0,0,0,11,18655,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shorty - On Data Set 6 0 - Cast 'Mortar Animate'"),
-(@ENTRY,0,7,0,38,0,100,0,7,0,0,0,11,16786,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shorty - On Data Set 7 0 - Cast 'Mortar Shot'"),
-(@ENTRY,0,8,0,38,0,100,0,8,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,4.54215,"Shorty - On Data Set 8 0 - Set Orientation 4.54215"),
-(@ENTRY,0,9,0,38,0,100,0,9,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,4.54215,"Shorty - On Data Set 9 0 - Set Orientation 4.54215"),
-(@ENTRY,0,10,0,38,0,100,0,10,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,2.844887,"Shorty - On Data Set 10 0 - Set Orientation 2.844887"),
-(@ENTRY,0,11,0,38,0,100,0,11,0,0,0,69,0,0,0,0,0,0,8,0,0,0,-6007.458984,-202.157593,407.447937,2,"Shorty - On Data Set 11 0 - Move To Position"),
-(@ENTRY,0,12,0,38,0,100,0,12,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,2.478368,"Shorty - On Data Set 12 0 - Set Orientation 2.478368");
-
--- Klemmy SAI
-SET @ENTRY := 10805;
-UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
-(@ENTRY,0,0,1,38,0,100,0,1,0,0,0,53,0,10805,0,0,0,0,1,0,0,0,0,0,0,0,"Klemmy - On Data Set 1 0 - Start Waypoint"),
-(@ENTRY,0,1,0,61,0,100,0,1,0,0,0,48,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Klemmy - On Data Set 1 0 - Set Active On"),
-(@ENTRY,0,2,0,38,0,100,0,2,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,5.59936,"Spotter Klemmy - On Data Set 2 0 - Set Orientation 5,59936"),
-(@ENTRY,0,3,0,38,0,100,0,3,0,0,0,69,0,0,0,0,0,0,8,0,0,0,-6077.43,-213.2565,424.0502,5.59936,"Spotter Klemmy - On Data Set 3 0 - Move To Position"),
-(@ENTRY,0,4,0,38,0,100,0,4,0,0,0,69,0,0,0,0,0,0,8,0,0,0,-6065.903,-202.2976,424.3693,5,"Spotter Klemmy - On Data Set 4 0 - Move To Position"),
-(@ENTRY,0,5,0,38,0,100,0,5,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,5.59936,"Spotter Klemmy - On Data Set 5 0 - Set Orientation 5.59936"),
-(@ENTRY,0,6,0,38,0,100,0,6,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,4.0985,"Spotter Klemmy - On Data Set 6 0 - Set Orientation 4.0985"),
-(@ENTRY,0,7,0,38,0,100,0,7,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,4.0985,"Spotter Klemmy - On Data Set 7 0 - Set Orientation 4.0985"),
-(@ENTRY,0,8,0,38,0,100,0,8,0,0,0,69,0,0,0,0,0,0,8,0,0,0,-6077.43,-213.2565,424.0502,5.59936,"Spotter Klemmy - On Data Set 8 0 - Move To Position"),
-(@ENTRY,0,9,0,38,0,100,0,9,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,2.844887,"Spotter Klemmy - On Data Set 9 0 - Set Orientation 2.844887"),
-(@ENTRY,0,10,0,38,0,100,0,10,0,0,0,69,0,0,0,0,0,0,8,0,0,0,-6071.88,-212.831,422.929,5,"Spotter Klemmy - On Data Set 10 0 - Move To Position"),
-(@ENTRY,0,11,0,38,0,100,0,11,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,6.04228,"Spotter Klemmy - On Data Set 11 0 - Set Orientation 6.04228"),
-(@ENTRY,0,12,0,38,0,100,0,12,0,0,0,69,0,0,0,0,0,0,8,0,0,0,-6065.903,-202.2976,424.3693,5,"Spotter Klemmy - On Data Set 12 0 - Move To Position"),
-(@ENTRY,0,13,0,38,0,100,0,13,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,4.0985,"Spotter Klemmy - On Data Set 13 0 - Set Orientation 4.0985"),
-(@ENTRY,0,14,0,38,0,100,0,14,0,0,0,69,0,0,0,0,0,0,8,0,0,0,-6064.07,-209.851,421.98,6.10275,"Spotter Klemmy - On Data Set 14 0 - Move To Position"),
-(@ENTRY,0,15,0,38,0,100,0,15,0,0,0,69,0,0,0,0,0,0,8,0,0,0,-6061.97,-218.956,421.085,5.92054,"Spotter Klemmy - On Data Set 15 0 - Move To Position"),
-(@ENTRY,0,16,0,38,0,100,0,16,0,0,0,69,0,0,0,0,0,0,8,0,0,0,-6040.96,-221.929,414.921,5.92054,"Spotter Klemmy - On Data Set 16 0 - Move To Position"),
-(@ENTRY,0,17,0,38,0,100,0,17,0,0,0,69,0,0,0,0,0,0,8,0,0,0,-6007.301758,-200.348206,406.777496,3.282219,"Spotter Klemmy - On Data Set 17 0 - Move To Position"),
-(@ENTRY,0,18,0,38,0,100,0,18,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,3.282219,"Spotter Klemmy - On Data Set 18 0 - Set Orientation 3.282219");
-
--- Wheeler SAI
-SET @ENTRY := 10803;
-UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
-(@ENTRY,0,0,1,38,0,100,0,1,0,0,0,53,0,10803,0,0,0,0,1,0,0,0,0,0,0,0,"Wheeler - On Data Set 1 0 - Start Waypoint"),
-(@ENTRY,0,1,0,61,0,100,0,1,0,0,0,48,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Wheeler - On Data Set 1 0 - Set Active On"),
-(@ENTRY,0,2,0,38,0,100,0,2,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,2.443461,"Wheeler - On Data Set 2 0 - Set Orientation 2,443461"),
-(@ENTRY,0,3,0,38,0,100,0,3,0,0,0,11,16767,0,0,0,0,0,1,0,0,0,0,0,0,0,"Wheeler - On Data Set 3 0 - Cast 'Shoot'"),
-(@ENTRY,0,4,0,38,0,100,0,4,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,4.00565,"Wheeler - On Data Set 4 0 - Set Orientation 4.00565"),
-(@ENTRY,0,5,0,38,0,100,0,5,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,2.443461,"Wheeler - On Data Set 5 0 - Set Orientation 2.443461"),
-(@ENTRY,0,6,0,38,0,100,0,6,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,4.00565,"Wheeler - On Data Set 6 0 - Set Orientation 4.00565"),
-(@ENTRY,0,7,0,38,0,100,0,7,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,2.443461,"Wheeler - On Data Set 7 0 - Set Orientation 2.443461"),
-(@ENTRY,0,8,0,38,0,100,0,8,0,0,0,11,16775,0,0,0,0,0,1,0,0,0,0,0,0,0,"Wheeler - On Data Set 8 0 - Cast 'Shoot'"),
-(@ENTRY,0,9,0,38,0,100,0,9,0,0,0,11,16778,0,0,0,0,0,1,0,0,0,0,0,0,0,"Wheeler - On Data Set 9 0 - Cast 'Shoot'"),
-(@ENTRY,0,10,0,38,0,100,0,10,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,4.00565,"Wheeler - On Data Set 10 0 - Set Orientation 4.00565"),
-(@ENTRY,0,11,0,38,0,100,0,11,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,2.443461,"Wheeler - On Data Set 11 0 - Set Orientation 4.00565"),
-(@ENTRY,0,12,0,38,0,100,0,12,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,4.00565,"Wheeler - On Data Set 12 0 - Set Orientation 4.00565"),
-(@ENTRY,0,13,0,38,0,100,0,13,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,4.77803,"Wheeler - On Data Set 13 0 - Set Orientation 4.77803"),
-(@ENTRY,0,14,0,38,0,100,0,14,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,3.01942,"Wheeler - On Data Set 14 0 - Set Orientation 3.01942"),
-(@ENTRY,0,15,0,38,0,100,0,15,0,0,0,69,0,0,0,0,0,0,8,0,0,0,-6008.527832,-199.145203,406.687225,4.372177,"Wheeler - On Data Set 15 0 - Move To Position"),
-(@ENTRY,0,16,0,38,0,100,0,16,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,4.372177,"Wheeler - On Data Set 16 0 - Set Orientation 4.372177");
-
--- Rifleman Middlecamp SAI
-SET @ENTRY := 10804;
-UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
-(@ENTRY,0,0,1,38,0,100,0,1,0,0,0,69,0,0,0,0,0,0,8,0,0,0,-6034.14,-223.333,413.4,1,"Rifleman Middlecamp - On Data Set 1 0 - Move To Position"),
-(@ENTRY,0,1,0,61,0,100,0,1,0,0,0,48,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Rifleman Middlecamp - On Data Set 1 0 - Set Active On"),
-(@ENTRY,0,2,0,38,0,100,0,2,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,1.884956,"Rifleman Middlecamp - On Data Set 2 0 - Set Orientation 1,884956"),
-(@ENTRY,0,3,0,38,0,100,0,3,0,0,0,11,16768,0,0,0,0,0,1,0,0,0,0,0,0,0,"Rifleman Middlecamp - On Data Set 3 0 - Cast 'Shoot'"),
-(@ENTRY,0,4,0,38,0,100,0,4,0,0,0,11,16772,0,0,0,0,0,1,0,0,0,0,0,0,0,"Rifleman Middlecamp - On Data Set 4 0 - Cast 'Shoot'"),
-(@ENTRY,0,5,0,38,0,100,0,5,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,0.810652,"Rifleman Middlecamp - On Data Set 5 0 - Set Orientation 0.810652"),
-(@ENTRY,0,6,0,38,0,100,0,6,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,1.884956,"Rifleman Middlecamp - On Data Set 6 0 - Set Orientation 1.884956"),
-(@ENTRY,0,7,0,38,0,100,0,7,0,0,0,11,16777,0,0,0,0,0,1,0,0,0,0,0,0,0,"Rifleman Middlecamp - On Data Set 7 0 - Cast 'Shoot'"),
-(@ENTRY,0,8,0,38,0,100,0,8,0,0,0,11,16780,0,0,0,0,0,1,0,0,0,0,0,0,0,"Rifleman Middlecamp - On Data Set 8 0 - Cast 'Shoot'"),
-(@ENTRY,0,9,0,38,0,100,0,9,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,0.810652,"Rifleman Middlecamp - On Data Set 9 0 - Set Orientation 0.810652"),
-(@ENTRY,0,10,0,38,0,100,0,10,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,1.884956,"Rifleman Middlecamp - On Data Set 10 0 - Set Orientation 1.884956"),
-(@ENTRY,0,11,0,38,0,100,0,11,0,0,0,11,16572,0,0,0,0,0,1,0,0,0,0,0,0,0,"Rifleman Middlecamp - On Data Set 11 0 - Cast 'Shoot'"),
-(@ENTRY,0,12,0,38,0,100,0,12,0,0,0,11,16776,0,0,0,0,0,1,0,0,0,0,0,0,0,"Rifleman Middlecamp - On Data Set 12 0 - Cast 'Shoot'"),
-(@ENTRY,0,13,0,38,0,100,0,13,0,0,0,11,16779,0,0,0,0,0,1,0,0,0,0,0,0,0,"Rifleman Middlecamp - On Data Set 13 0 - Cast 'Shoot'"),
-(@ENTRY,0,14,0,38,0,100,0,14,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,0.810652,"Rifleman Middlecamp - On Data Set 14 0 - Set Orientation 0.810652"),
-(@ENTRY,0,15,0,38,0,100,0,15,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,5.13852,"Rifleman Middlecamp - On Data Set 15 0 - Set Orientation 5.13852"),
-(@ENTRY,0,16,0,38,0,100,0,16,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,2.9147,"Rifleman Middlecamp - On Data Set 16 0 - Set Orientation 2.9147"),
-(@ENTRY,0,17,1,38,0,100,0,17,0,0,0,69,0,0,0,0,0,0,8,0,0,0,-6010.668151495,-199.434006,406.792480,5.532694,"Rifleman Middlecamp - On Data Set 17 0 - Move To Position"),
-(@ENTRY,0,18,0,38,0,100,0,18,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,5.532694,"Rifleman Middlecamp - On Data Set 18 0 - Set Orientation 5.532694");
-
-DELETE FROM `waypoints` WHERE `entry`=10805;
-INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES
-(10805, 1, -6011.17,-197.021,406.765, 'Klemmy'),
-(10805, 2, -6015.51,-184.362,407.712, 'Klemmy'),
-(10805, 3, -6042.365723,-191.418701,421.045868, 'Klemmy'),
-(10805, 4, -6065.18,-201.938,424.419, 'Klemmy');
-
-DELETE FROM `waypoints` WHERE `entry`=10803;
-INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES
-(10803, 1, -6011.87,-199.241,406.834, 'Wheeler'),
-(10803, 2, -6031.929,-221.0882,413.1531, 'Wheeler');
-
-DELETE FROM `creature_text` WHERE `entry` IN (10804, 10803);
-INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`, `BroadcastTextId`) VALUES
-(10804, 0, 0, '%s picks the orc target...', 16, 0, 100, 25, 0, 0, 'Middlecamp', 6107),
-(10804, 1, 0, '%s misses...', 16, 0, 100, 6, 0, 0, 'Middlecamp', 6140),
-(10804, 2, 0, '%s takes a more careful aim...', 16, 0, 100, 6, 0, 6247, 'Middlecamp', 6106),
-(10804, 3, 0, '%s misses again...', 16, 0, 100, 6, 0, 0, 'Middlecamp', 6141),
-(10804, 4, 0, '%s takes aim at the bottles...', 16, 0, 100, 0, 0, 0, 'Middlecamp', 6120),
-(10804, 5, 0, '%s misses...', 16, 0, 100, 15, 0, 0, 'Middlecamp', 6140),
-(10804, 6, 0, '%s takes aim at the bottles again...', 16, 0, 100, 0, 0, 0, 'Middlecamp', 6121),
-(10804, 7, 0, '%s misses again...', 16, 0, 100, 18, 0, 0, 'Middlecamp', 6141),
-(10804, 8, 0, '%s quickly shoots the orc dummy...', 16, 0, 100, 0, 0, 0, 'Middlecamp', 6137),
-(10804, 9, 0, '%s turns to the paper target...', 16, 0, 100, 0, 0, 0, 'Middlecamp', 6136),
-(10804, 10, 0, '%s shoots from the hip at the bottles...', 16, 0, 100, 0, 0, 0, 'Middlecamp', 6138),
---
-(10803, 0, 0, '%s casually points at the orc target...', 16, 0, 100, 25, 0, 0, 'Wheeler', 6118),
-(10803, 1, 0, '%s hits!', 16, 0, 100, 0, 0, 0, 'Wheeler', 6142),
-(10803, 2, 0, '%s quickly shoots the middle target dead center...', 16, 0, 100, 0, 0, 0, 'Wheeler', 6124),
-(10803, 3, 0, '%s then takes aim at the bottles...', 16, 0, 100, 0, 0, 0, 'Wheeler', 6122),
-(10803, 4, 0, '%s only hits the side of the box!', 16, 0, 100, 0, 0, 0, 'Wheeler', 6123);
-
-DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceGroup`=1 AND `SourceEntry`=18655;
-INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
-(13, 1, 18655, 0, 0, 31, 0, 5, 176557, 0, 0, 0, 0, '', 'Mörser - Mörser');
-
--- Actionlist SAI
-SET @ENTRY := 1061000;
-DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
-(@ENTRY,9,0,0,0,0,100,0,0,0,0,0,45,2,0,0,0,0,0,19,10805,100,0,0,0,0,0,"On Script - Set Data 2 0"),
-(@ENTRY,9,1,0,0,0,100,0,0,0,0,0,45,2,0,0,0,0,0,19,10611,100,0,0,0,0,0,"On Script - Set Data 2 0"),
-(@ENTRY,9,2,0,0,0,100,0,0,0,0,0,45,2,0,0,0,0,0,19,10803,100,0,0,0,0,0,"On Script - Set Data 2 0"),
-(@ENTRY,9,3,0,0,0,100,0,0,0,0,0,45,2,0,0,0,0,0,19,10804,100,0,0,0,0,0,"On Script - Set Data 2 0"),
-(@ENTRY,9,4,0,0,0,100,0,0,0,0,0,45,2,0,0,0,0,0,19,1243,100,0,0,0,0,0,"On Script - Set Data 2 0"),
-(@ENTRY,9,5,0,0,0,100,0,5000,5000,0,0,1,0,0,0,0,0,0,19,10804,100,0,0,0,0,0,"Angus - On Script - Say Line 0"),
-(@ENTRY,9,6,0,0,0,100,0,3000,3000,0,0,45,3,0,0,0,0,0,19,10804,50,0,0,0,0,0,"Angus - On Script - Set Data 3 0"),
-(@ENTRY,9,7,0,0,0,100,0,2000,2000,0,0,1,1,0,0,0,0,0,19,10804,100,0,0,0,0,0,"Angus - On Script - Say Line 1"),
-(@ENTRY,9,8,0,0,0,100,0,4000,4000,0,0,1,2,0,0,0,0,0,19,10804,100,0,0,0,0,0,"Angus - On Script - Say Line 2"),
-(@ENTRY,9,9,0,0,0,100,0,2000,2000,0,0,45,4,0,0,0,0,0,19,10804,50,0,0,0,0,0,"Angus - On Script - Set Data 4 0"),
-(@ENTRY,9,10,0,0,0,100,0,2000,2000,0,0,1,3,0,0,0,0,0,19,10804,100,0,0,0,0,0,"Angus - On Script - Say Line 3"),
-(@ENTRY,9,11,0,0,0,100,0,2000,2000,0,0,45,5,0,0,0,0,0,19,10804,50,0,0,0,0,0,"Angus - On Script - Set Data 5 0"),
-(@ENTRY,9,12,0,0,0,100,0,1000,1000,0,0,5,5,0,0,0,0,0,19,10804,100,0,0,0,0,0,"Angus - On Script - Play Emote 5"),
-(@ENTRY,9,13,0,0,0,100,0,1000,1000,0,0,5,11,0,0,0,0,0,19,10803,100,0,0,0,0,0,"Angus - On Script - Play Emote 11"),
-(@ENTRY,9,14,0,0,0,100,0,1000,1000,0,0,5,274,0,0,0,0,0,19,10611,100,0,0,0,0,0,"Angus - On Script - Play Emote 11"),
-(@ENTRY,9,15,0,0,0,100,0,0,0,0,0,5,274,0,0,0,0,0,1,0,0,0,0,0,0,0,"Angus - On Script - Play Emote 11"),
-(@ENTRY,9,16,0,0,0,100,0,1000,1000,0,0,45,6,0,0,0,0,0,19,10804,50,0,0,0,0,0,"Angus - On Script - Set Data 6 0"),
-(@ENTRY,9,17,0,0,0,100,0,1000,1000,0,0,1,0,0,0,0,0,0,19,10803,100,0,0,0,0,0,"Angus - On Script - Say Line 0"),
-(@ENTRY,9,18,0,0,0,100,0,4000,4000,0,0,45,3,0,0,0,0,0,19,10803,50,0,0,0,0,0,"Angus - On Script - Set Data 3 0"),
-(@ENTRY,9,19,0,0,0,100,0,2000,2000,0,0,1,1,0,0,0,0,0,19,10803,100,0,0,0,0,0,"Angus - On Script - Say Line 1"),
-(@ENTRY,9,20,0,0,0,100,0,2000,2000,0,0,45,4,0,0,0,0,0,19,10803,50,0,0,0,0,0,"Angus - On Script - Set Data 4 0"),
-(@ENTRY,9,21,0,0,0,100,0,1000,1000,0,0,5,25,0,0,0,0,0,19,10803,50,0,0,0,0,0,"Angus - On Script - Play Emote 25"),
-(@ENTRY,9,22,0,0,0,100,0,0,0,0,0,4,6249,0,0,0,0,0,21,100,0,0,0,0,0,0,"Angus - On Script - Play Sound 6249"),
-(@ENTRY,9,23,0,0,0,100,0,2000,2000,0,0,5,21,0,0,0,0,0,1,0,0,0,0,0,0,0,"Angus - On Script - Play Emote 21"),
-(@ENTRY,9,24,0,0,0,100,0,1000,1000,0,0,5,21,0,0,0,0,0,19,10611,100,0,0,0,0,0,"Angus - On Script - Play Emote 21"),
-(@ENTRY,9,25,0,0,0,100,0,0,0,0,0,5,23,0,0,0,0,0,19,10803,100,0,0,0,0,0,"Angus - On Script - Play Emote 23"),
-(@ENTRY,9,26,0,0,0,100,0,2000,2000,0,0,45,5,0,0,0,0,0,19,10803,50,0,0,0,0,0,"Angus - On Script - Set Data 5 0 Wheeler"),
-(@ENTRY,9,27,0,0,0,100,0,3000,3000,0,0,1,4,0,0,0,0,0,19,10804,100,0,0,0,0,0,"Angus - On Script - Say Line 4"),
-(@ENTRY,9,28,0,0,0,100,0,2000,2000,0,0,45,7,0,0,0,0,0,19,10804,50,0,0,0,0,0,"Angus - On Script - Set Data 5 0 Middlecamp"),
-(@ENTRY,9,29,0,0,0,100,0,2000,2000,0,0,1,5,0,0,0,0,0,19,10804,100,0,0,0,0,0,"Angus - On Script - Say Line 5 Middlecamp"),
-(@ENTRY,9,30,0,0,0,100,0,2000,2000,0,0,5,20,0,0,0,0,0,19,10804,100,0,0,0,0,0,"Angus - On Script - Play Emote 20 Middlecamp"),
-(@ENTRY,9,31,0,0,0,100,0,0,0,0,0,45,6,0,0,0,0,0,19,10803,50,0,0,0,0,0,"Angus - On Script - Set Data 6 0 Wheeler"),
-(@ENTRY,9,32,0,0,0,100,0,1000,1000,0,0,5,6,0,0,0,0,0,19,10803,100,0,0,0,0,0,"Angus - On Script - Play Emote 6 Wheeler"),
-(@ENTRY,9,33,0,0,0,100,0,0,0,0,0,4,6248,0,0,0,0,0,21,100,0,0,0,0,0,0,"Angus - On Script - Play Sound 6248"),
-(@ENTRY,9,34,0,0,0,100,0,3000,3000,0,0,45,7,0,0,0,0,0,19,10803,50,0,0,0,0,0,"Angus - On Script - Set Data 6 0 Wheeler"),
-(@ENTRY,9,35,0,0,0,100,0,0,0,0,0,1,6,0,0,0,0,0,19,10804,100,0,0,0,0,0,"Angus - On Script - Say Line 6 Middlecamp"),
-(@ENTRY,9,36,0,0,0,100,0,1000,1000,0,0,45,8,0,0,0,0,0,19,10804,50,0,0,0,0,0,"Angus - On Script - Set Data 8 0 Middlecamp"),
-(@ENTRY,9,38,0,0,0,100,0,0,0,0,0,1,7,0,0,0,0,0,19,10804,100,0,0,0,0,0,"Angus - On Script - Say Line 7 Middlecamp"),
-(@ENTRY,9,40,0,0,0,100,0,0,0,0,0,1,2,0,0,0,0,0,19,10803,100,0,0,0,0,0,"Angus - On Script - Say Line 2 Wheeler"),
-(@ENTRY,9,41,0,0,0,100,0,2000,2000,0,0,45,8,0,0,0,0,0,19,10803,50,0,0,0,0,0,"Angus - On Script - Set Data 8 0 Wheeler"),
-(@ENTRY,9,42,0,0,0,100,0,2000,2000,0,0,1,3,0,0,0,0,0,19,10803,100,0,0,0,0,0,"Angus - On Script - Say Line 3 Wheeler"),
-(@ENTRY,9,43,0,0,0,100,0,2000,2000,0,0,45,9,0,0,0,0,0,19,10803,50,0,0,0,0,0,"Angus - On Script - Set Data 9 0 Wheeler"),
-(@ENTRY,9,44,0,0,0,100,0,2000,2000,0,0,1,4,0,0,0,0,0,19,10803,100,0,0,0,0,0,"Angus - On Script - Say Line 4 Wheeler"),
-(@ENTRY,9,45,0,0,0,100,0,1000,1000,0,0,45,10,0,0,0,0,0,19,10803,50,0,0,0,0,0,"Angus - On Script - Set Data 10 0 Wheeler"),
-(@ENTRY,9,46,0,0,0,100,0,1000,1000,0,0,5,5,0,0,0,0,0,19,10803,100,0,0,0,0,0,"Angus - On Script - Play Emote 5 Wheeler"),
-(@ENTRY,9,47,0,0,0,100,0,0,0,0,0,45,9,0,0,0,0,0,19,10804,50,0,0,0,0,0,"Angus - On Script - Set Data 9 0 Middlecamp"),
-(@ENTRY,9,48,0,0,0,100,0,2000,2000,0,0,5,25,0,0,0,0,0,19,10804,100,0,0,0,0,0,"Angus - On Script - Play Emote 25 Middlecamp"),
-(@ENTRY,9,59,0,0,0,100,0,2000,2000,0,0,5,11,0,0,0,0,0,19,10804,100,0,0,0,0,0,"Angus - On Script - Play Emote 11 Middlecamp"),
-(@ENTRY,9,60,0,0,0,100,0,3000,3000,0,0,45,10,0,0,0,0,0,19,10803,50,0,0,0,0,0,"Angus - On Script - Set Data 10 0 Middlecamp"),
-(@ENTRY,9,61,0,0,0,100,0,0,0,0,0,45,11,0,0,0,0,0,19,10803,50,0,0,0,0,0,"Angus - On Script - Set Data 11 0 Wheeler"),
-(@ENTRY,9,62,0,0,0,100,0,2000,2000,0,0,1,8,0,0,0,0,0,19,10804,100,0,0,0,0,0,"Angus - On Script - Say Line 8 Middlecamp"),
-(@ENTRY,9,63,0,0,0,100,0,0,0,0,0,4,6250,0,0,0,0,0,21,100,0,0,0,0,0,0,"Angus - On Script - Play Sound 6250"),
-(@ENTRY,9,64,0,0,0,100,0,0,0,0,0,45,11,0,0,0,0,0,19,10804,50,0,0,0,0,0,"Angus - On Script - Set Data 11 0 Middlecamp"),
-(@ENTRY,9,65,0,0,0,100,0,3000,3000,0,0,1,9,0,0,0,0,0,19,10804,100,0,0,0,0,0,"Angus - On Script - Say Line 9 Middlecamp"),
-(@ENTRY,9,66,0,0,0,100,0,0,0,0,0,4,6250,0,0,0,0,0,21,100,0,0,0,0,0,0,"Angus - On Script - Play Sound 6250"),
-(@ENTRY,9,67,0,0,0,100,0,0,0,0,0,45,12,0,0,0,0,0,19,10804,50,0,0,0,0,0,"Angus - On Script - Set Data 12 0 Middlecamp"),
-(@ENTRY,9,68,0,0,0,100,0,3000,3000,0,0,1,10,0,0,0,0,0,19,10804,100,0,0,0,0,0,"Angus - On Script - Say Line 10 Middlecamp"),
-(@ENTRY,9,69,0,0,0,100,0,0,0,0,0,4,6250,0,0,0,0,0,21,100,0,0,0,0,0,0,"Angus - On Script - Play Sound 6250"),
-(@ENTRY,9,70,0,0,0,100,0,0,0,0,0,45,13,0,0,0,0,0,19,10804,50,0,0,0,0,0,"Angus - On Script - Set Data 13 0 Middlecamp"),
-(@ENTRY,9,71,0,0,0,100,0,0,0,0,0,5,71,0,0,0,0,0,19,10804,100,0,0,0,0,0,"Angus - On Script - Play Emote 71 Middlecamp"),
-(@ENTRY,9,72,0,0,0,100,0,0,0,0,0,4,6246,0,0,0,0,0,21,100,0,0,0,0,0,0,"Angus - On Script - Play Sound 6246"),
-(@ENTRY,9,73,0,0,0,100,0,3000,3000,0,0,45,14,0,0,0,0,0,19,10804,50,0,0,0,0,0,"Angus - On Script - Set Data 14 0 Middlecamp"),
-(@ENTRY,9,74,0,0,0,100,0,1000,1000,0,0,45,12,0,0,0,0,0,19,10803,50,0,0,0,0,0,"Angus - On Script - Set Data 12 0 Wheeler"),
-(@ENTRY,9,75,0,0,0,100,0,1000,1000,0,0,5,2,0,0,0,0,0,19,10804,100,0,0,0,0,0,"Angus - On Script - Play Emote 2 Middlecamp"),
-(@ENTRY,9,76,0,0,0,100,0,0,0,0,0,5,21,0,0,0,0,0,19,10803,100,0,0,0,0,0,"Angus - On Script - Play Emote 21 Wheeler"),
-(@ENTRY,9,77,0,0,0,100,0,4000,4000,0,0,45,15,0,0,0,0,0,19,10804,50,0,0,0,0,0,"Angus - On Script - Set Data 15 0 Middlecamp"),
-(@ENTRY,9,78,0,0,0,100,0,0,0,0,0,45,13,0,0,0,0,0,19,10803,50,0,0,0,0,0,"Angus - On Script - Set Data 13 0 Wheeler"),
-(@ENTRY,9,79,0,0,0,100,0,0,0,0,0,45,3,0,0,0,0,0,19,10611,50,0,0,0,0,0,"Angus - On Script - Set Data 3 0 Shorty"),
-(@ENTRY,9,80,0,0,0,100,0,0,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,2.844887,"Angus - On Script - Set Orientation 2,844887"),
-(@ENTRY,9,81,0,0,0,100,0,2000,2000,0,0,5,4,0,0,0,0,0,1,0,0,0,0,0,0,0,"Angus - On Script - Play Emote 4 Wheeler"),
-(@ENTRY,9,82,0,0,0,100,0,0,0,0,0,5,4,0,0,0,0,0,19,10611,100,0,0,0,0,0,"Angus - On Script - Play Emote 4 Shorty"),
-(@ENTRY,9,83,0,0,0,100,0,0,0,0,0,4,6256,0,0,0,0,0,21,100,0,0,0,0,0,0,"Angus - On Script - Play Sound 6256"),
-(@ENTRY,9,84,0,0,0,100,0,0,0,0,0,45,3,0,0,0,0,0,19,10805,100,0,0,0,0,0,"Angus - On Script - Set Data 3 0 Klemmy"),
-(@ENTRY,9,85,0,0,0,100,0,10000,10000,0,0,11,18634,2,0,0,0,0,8,0,0,0,0,0,0,0,"Angus - On Script - Summon Creature 'Mortar Team Target Dummy'"),
-(@ENTRY,9,86,0,0,0,100,0,3000,3000,0,0,45,4,0,0,0,0,0,19,10805,100,0,0,0,0,0,"Angus - On Script - Set Data 4 0 Klemmy"),
-(@ENTRY,9,87,0,0,0,100,0,3000,3000,0,0,45,5,0,0,0,0,0,19,10805,100,0,0,0,0,0,"Angus - On Script - Set Data 5 0 Klemmy"),
-(@ENTRY,9,88,0,0,0,100,0,2000,2000,0,0,5,3,0,0,0,0,0,19,10805,100,0,0,0,0,0,"Angus - On Script - Play Emote 3 Klemmy"),
-(@ENTRY,9,89,0,0,0,100,0,0,0,0,0,45,4,0,0,0,0,0,19,10611,50,0,0,0,0,0,"Angus - On Script - Set Data 4 0 Shorty"),
-(@ENTRY,9,90,0,0,0,100,0,1000,1000,0,0,45,6,0,0,0,0,0,19,10805,100,0,0,0,0,0,"Angus - On Script - Set Data 6 0 Klemmy"),
-(@ENTRY,9,91,0,0,0,100,0,1000,1000,0,0,5,16,0,0,0,0,0,19,10611,100,0,0,0,0,0,"Angus - On Script - Play Emote 16 Shorty"),
-(@ENTRY,9,92,0,0,0,100,0,1000,1000,0,0,5,69,0,0,0,0,0,19,10611,100,0,0,0,0,0,"Angus - On Script - Play Emote 69 Shorty"),
-(@ENTRY,9,93,0,0,0,100,0,1000,1000,0,0,5,0,0,0,0,0,0,19,10611,100,0,0,0,0,0,"Angus - On Script - Play Emote 0 Shorty"),
-(@ENTRY,9,94,0,0,0,100,0,2000,2000,0,0,45,5,0,0,0,0,0,19,10611,50,0,0,0,0,0,"Angus - On Script - Set Data 5 0 Shorty"),
-(@ENTRY,9,95,0,0,0,100,0,1000,1000,0,0,45,16,0,0,0,0,0,19,10804,50,0,0,0,0,0,"Angus - On Script - Set Data 16 0 Middlecamp"),
-(@ENTRY,9,96,0,0,0,100,0,0,0,0,0,45,14,0,0,0,0,0,19,10803,50,0,0,0,0,0,"Angus - On Script - Set Data 14 0 Wheeler"),
-(@ENTRY,9,97,0,0,0,100,0,0,0,0,0,5,25,0,0,0,0,0,1,0,0,0,0,0,0,0,"Angus - On Script - Play Emote 25"),
-(@ENTRY,9,98,0,0,0,100,0,1000,1000,0,0,45,6,0,0,0,0,0,19,10611,50,0,0,0,0,0,"Angus - On Script - Set Data 6 0 Shorty"),
-(@ENTRY,9,99,0,0,0,100,0,2000,2000,0,0,4,7316,0,0,0,0,0,21,100,0,0,0,0,0,0,"Angus - On Script - Play Sound 7316"),
-(@ENTRY,9,100,0,0,0,100,0,2000,2000,0,0,45,7,0,0,0,0,0,19,10611,50,0,0,0,0,0,"Angus - On Script - Set Data 7 0 Shorty"),
-(@ENTRY,9,101,0,0,0,100,0,0,0,0,0,51,0,0,0,0,0,0,19,11875,200,0,0,0,0,0,"On Script - Kill Target"),
-(@ENTRY,9,102,0,0,0,100,0,3000,3000,0,0,5,17,0,0,0,0,0,19,10611,100,0,0,0,0,0,"Angus - On Script - Play Emote 17 Shorty"),
-(@ENTRY,9,103,0,0,0,100,0,3000,3000,0,0,45,8,0,0,0,0,0,19,10611,50,0,0,0,0,0,"Angus - On Script - Set Data 8 0 Shorty"),
-(@ENTRY,9,104,0,0,0,100,0,0,0,0,0,45,8,0,0,0,0,0,19,10805,100,0,0,0,0,0,"Angus - On Script - Set Data 8 0 Klemmy"),
-(@ENTRY,9,105,0,0,0,100,0,0,0,0,0,5,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Angus - On Script - Play Emote 1"),
-(@ENTRY,9,106,0,0,0,100,0,0,0,0,0,4,6252,0,0,0,0,0,21,100,0,0,0,0,0,0,"Angus - On Script - Play Sound 6252"),
-(@ENTRY,9,107,0,0,0,100,0,1000,1000,0,0,5,4,0,0,0,0,0,19,10611,100,0,0,0,0,0,"Angus - On Script - Play Emote 4 Shorty"),
-(@ENTRY,9,108,0,0,0,100,0,3000,3000,0,0,45,9,0,0,0,0,0,19,10611,100,0,0,0,0,0,"Angus - On Script - Set Data 8 0 Shorty"),
-(@ENTRY,9,109,0,0,0,100,0,5000,5000,0,0,11,18634,2,0,0,0,0,1,0,0,0,0,0,0,0,"Angus - On Script - Summon Creature 'Mortar Team Target Dummy'"),
-(@ENTRY,9,110,0,0,0,100,0,2000,2000,0,0,45,10,0,0,0,0,0,19,10805,100,0,0,0,0,0,"Angus - On Script - Set Data 10 0 Klemmy"),
-(@ENTRY,9,111,0,0,0,100,0,2000,2000,0,0,45,11,0,0,0,0,0,19,10805,100,0,0,0,0,0,"Angus - On Script - Set Data 11 0 Klemmy"),
-(@ENTRY,9,112,0,0,0,100,0,2000,2000,0,0,5,66,0,0,0,0,0,19,10805,100,0,0,0,0,0,"Angus - On Script - Play Emote 66 Klemmy"),
-(@ENTRY,9,113,0,0,0,100,0,3000,3000,0,0,45,9,0,0,0,0,0,19,10611,100,0,0,0,0,0,"Angus - On Script - Set Data 9 0 Shorty"),
-(@ENTRY,9,114,0,0,0,100,0,2000,2000,0,0,45,12,0,0,0,0,0,19,10805,100,0,0,0,0,0,"Angus - On Script - Set Data 12 0 Klemmy"),
-(@ENTRY,9,115,0,0,0,100,0,0,0,0,0,5,25,0,0,0,0,0,19,10611,100,0,0,0,0,0,"Angus - On Script - Play Emote 8 Shorty"),
-(@ENTRY,9,116,0,0,0,100,0,2000,2000,0,0,4,6254,0,0,0,0,0,21,100,0,0,0,0,0,0,"Angus - On Script - Play Sound 6254"),
-(@ENTRY,9,117,0,0,0,100,0,1000,1000,0,0,45,13,0,0,0,0,0,19,10805,100,0,0,0,0,0,"Angus - On Script - Set Data 13 0 Klemmy"),
-(@ENTRY,9,118,0,0,0,100,0,3000,3000,0,0,17,0,0,0,0,0,0,19,10611,100,0,0,0,0,0,"Angus - On Script - Play Emote 0 Shorty"),
-(@ENTRY,9,119,0,0,0,100,0,1000,1000,0,0,45,10,0,0,0,0,0,19,10611,100,0,0,0,0,0,"Angus - On Script - Set Data 10 0 Shorty"),
-(@ENTRY,9,120,0,0,0,100,0,1000,1000,0,0,5,25,0,0,0,0,0,19,10611,100,0,0,0,0,0,"Angus - On Script - Play Emote 25 Shorty"),
-(@ENTRY,9,121,0,0,0,100,0,0,0,0,0,4,6255,0,0,0,0,0,21,100,0,0,0,0,0,0,"Angus - On Script - Play Sound 6255"),
-(@ENTRY,9,122,0,0,0,100,0,1000,1000,0,0,45,6,0,0,0,0,0,19,10611,50,0,0,0,0,0,"Angus - On Script - Set Data 6 0 Shorty"),
-(@ENTRY,9,123,0,0,0,100,0,1000,1000,0,0,4,7316,0,0,0,0,0,21,100,0,0,0,0,0,0,"Angus - On Script - Play Sound 7316"),
-(@ENTRY,9,124,0,0,0,100,0,1000,1000,0,0,45,7,0,0,0,0,0,19,10611,50,0,0,0,0,0,"Angus - On Script - Set Data 7 0 Shorty"),
-(@ENTRY,9,125,0,0,0,100,0,0,0,0,0,51,0,0,0,0,0,0,19,11875,200,0,0,0,0,0,"On Script - Kill Target"),
-(@ENTRY,9,126,0,0,0,100,0,1000,1000,0,0,45,9,0,0,0,0,0,19,10611,50,0,0,0,0,0,"Angus - On Script - Set Data 9 0 Shorty"),
-(@ENTRY,9,127,0,0,0,100,0,2000,2000,0,0,5,25,0,0,0,0,0,19,10611,100,0,0,0,0,0,"Angus - On Script - Play Emote 25 Shorty"),
-(@ENTRY,9,128,0,0,0,100,0,0,0,0,0,4,6251,0,0,0,0,0,21,100,0,0,0,0,0,0,"Angus - On Script - Play Sound 6251"),
-(@ENTRY,9,129,0,0,0,100,0,1000,1000,0,0,45,15,0,0,0,0,0,19,10804,50,0,0,0,0,0,"Angus - On Script - Set Data 15 0 Middlecamp"),
-(@ENTRY,9,130,0,0,0,100,0,0,0,0,0,45,8,0,0,0,0,0,19,10805,100,0,0,0,0,0,"Angus - On Script - Set Data 8 0 Klemmy"),
-(@ENTRY,9,131,0,0,0,100,0,1000,1000,0,0,45,13,0,0,0,0,0,19,10803,100,0,0,0,0,0,"Angus - On Script - Set Data 13 0 Wheeler"),
-(@ENTRY,9,132,0,0,0,100,0,1000,1000,0,0,45,10,0,0,0,0,0,19,10611,100,0,0,0,0,0,"Angus - On Script - Set Data 10 0 Shorty"),
-(@ENTRY,9,133,0,0,0,100,0,0,0,0,0,5,4,0,0,0,0,0,19,10803,100,0,0,0,0,0,"Angus - On Script - Play Emote 4 Wheeler"),
-(@ENTRY,9,134,0,0,0,100,0,7000,7000,0,0,11,18634,0,0,0,0,0,1,0,0,0,0,0,0,0,"Angus - On Script - Summon Creature 'Mortar Team Target Dummy'"),
-(@ENTRY,9,135,0,0,0,100,0,1000,1000,0,0,45,10,0,0,0,0,0,19,10805,100,0,0,0,0,0,"Angus - On Script - Set Data 10 0 Klemmy"),
-(@ENTRY,9,136,0,0,0,100,0,1000,1000,0,0,45,11,0,0,0,0,0,19,10805,100,0,0,0,0,0,"Angus - On Script - Set Data 11 0 Klemmy"),
-(@ENTRY,9,137,0,0,0,100,0,2000,2000,0,0,45,6,0,0,0,0,0,19,10611,50,0,0,0,0,0,"Angus - On Script - Set Data 6 0 Shorty"),
-(@ENTRY,9,138,0,0,0,100,0,0,0,0,0,5,25,0,0,0,0,0,19,10805,100,0,0,0,0,0,"Angus - On Script - Play Emote 25 Klemmy"),
-(@ENTRY,9,139,0,0,0,100,0,1000,1000,0,0,5,11,0,0,0,0,0,19,10805,100,0,0,0,0,0,"Angus - On Script - Play Emote 11 Klemmy"),
-(@ENTRY,9,140,0,0,0,100,0,0,0,0,0,5,15,0,0,0,0,0,19,10611,100,0,0,0,0,0,"Angus - On Script - Play Emote 15 Shorty"),
-(@ENTRY,9,141,0,0,0,100,0,0,0,0,0,5,5,0,0,0,0,0,1,0,0,0,0,0,0,0,"Angus - On Script - Play Emote 5"),
-(@ENTRY,9,142,0,0,0,100,0,0,0,0,0,4,6258,0,0,0,0,0,21,100,0,0,0,0,0,0,"Angus - On Script - Play Sound 6258"),
-(@ENTRY,9,143,0,0,0,100,0,2000,2000,0,0,4,7316,0,0,0,0,0,21,100,0,0,0,0,0,0,"Angus - On Script - Play Sound 7316"),
-(@ENTRY,9,144,0,0,0,100,0,1000,1000,0,0,45,16,0,0,0,0,0,19,10804,50,0,0,0,0,0,"Angus - On Script - Set Data 16 0 Middlecamp"),
-(@ENTRY,9,145,0,0,0,100,0,1000,1000,0,0,45,14,0,0,0,0,0,19,10803,100,0,0,0,0,0,"Angus - On Script - Set Data 14 0 Wheeler"),
-(@ENTRY,9,146,0,0,0,100,0,0,0,0,0,45,14,0,0,0,0,0,19,10805,100,0,0,0,0,0,"Angus - On Script - Set Data 14 0 Klemmy"),
-(@ENTRY,9,147,0,0,0,100,0,1000,1000,0,0,45,7,0,0,0,0,0,19,10611,50,0,0,0,0,0,"Angus - On Script - Set Data 6 0 Shorty"),
-(@ENTRY,9,148,0,0,0,100,0,0,0,0,0,51,0,0,0,0,0,0,19,11875,200,0,0,0,0,0,"On Script - Kill Target"),
-(@ENTRY,9,149,0,0,0,100,0,1000,1000,0,0,5,10,0,0,0,0,0,1,0,0,0,0,0,0,0,"Angus - On Script - Play Emote 10"),
-(@ENTRY,9,150,0,0,0,100,0,0,0,0,0,5,10,0,0,0,0,0,19,10611,100,0,0,0,0,0,"Angus - On Script - Play Emote 10 Shorty"),
-(@ENTRY,9,151,0,0,0,100,0,2000,2000,0,0,45,15,0,0,0,0,0,19,10805,100,0,0,0,0,0,"Angus - On Script - Set Data 15 0 Klemmy"),
-(@ENTRY,9,152,0,0,0,100,0,3000,3000,0,0,45,16,0,0,0,0,0,19,10805,100,0,0,0,0,0,"Angus - On Script - Set Data 16 0 Klemmy"),
-(@ENTRY,9,153,0,0,0,100,0,6000,6000,0,0,5,14,0,0,0,0,0,19,10805,100,0,0,0,0,0,"Angus - On Script - Play Emote 14 Klemmy"),
-(@ENTRY,9,154,0,0,0,100,0,0,0,0,0,5,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Angus - On Script - Play Emote 0"),
-(@ENTRY,9,155,0,0,0,100,0,0,0,0,0,5,0,0,0,0,0,0,19,10611,100,0,0,0,0,0,"Angus - On Script - Play Emote 0 Shorty"),
-(@ENTRY,9,156,0,0,0,100,0,0,0,0,0,5,11,0,0,0,0,0,1,0,0,0,0,0,0,0,"Angus - On Script - Play Emote 11"),
-(@ENTRY,9,157,0,0,0,100,0,0,0,0,0,5,11,0,0,0,0,0,19,10611,100,0,0,0,0,0,"Angus - On Script - Play Emote 11 Shorty"),
-(@ENTRY,9,158,0,0,0,100,0,1000,1000,0,0,5,11,0,0,0,0,0,19,10804,100,0,0,0,0,0,"Angus - On Script - Play Emote 11 Middlecamp"),
-(@ENTRY,9,159,0,0,0,100,0,0,0,0,0,5,11,0,0,0,0,0,19,10803,100,0,0,0,0,0,"Angus - On Script - Play Emote 11 Wheeler"),
-(@ENTRY,9,160,0,0,0,100,0,0,0,0,0,5,11,0,0,0,0,0,19,10805,100,0,0,0,0,0,"Angus - On Script - Play Emote 11 Klemmy"),
-(@ENTRY,9,161,0,0,0,100,0,1000,1000,0,0,5,11,0,0,0,0,0,1,0,0,0,0,0,0,0,"Angus - On Script - Play Emote 11"),
-(@ENTRY,9,162,0,0,0,100,0,0,0,0,0,5,11,0,0,0,0,0,19,10611,100,0,0,0,0,0,"Angus - On Script - Play Emote 11 Shorty"),
-(@ENTRY,9,163,0,0,0,100,0,1000,1000,0,0,5,11,0,0,0,0,0,19,10804,100,0,0,0,0,0,"Angus - On Script - Play Emote 11 Middlecamp"),
-(@ENTRY,9,164,0,0,0,100,0,0,0,0,0,5,11,0,0,0,0,0,19,10803,100,0,0,0,0,0,"Angus - On Script - Play Emote 11 Wheeler"),
-(@ENTRY,9,165,0,0,0,100,0,1000,1000,0,0,45,17,0,0,0,0,0,19,10805,100,0,0,0,0,0,"Angus - On Script - Set Data 17 0 Klemmy"),
-(@ENTRY,9,166,0,0,0,100,0,0,0,0,0,45,11,0,0,0,0,0,19,10611,50,0,0,0,0,0,"Angus - On Script - Set Data 11 0 Shorty"),
-(@ENTRY,9,167,0,0,0,100,0,0,0,0,0,45,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Angus - On Script - Set Data 2 0 Angus"),
-(@ENTRY,9,168,0,0,0,100,0,0,0,0,0,45,17,0,0,0,0,0,19,10804,50,0,0,0,0,0,"Angus - On Script - Set Data 17 0 Middlecamp"),
-(@ENTRY,9,169,0,0,0,100,0,0,0,0,0,45,15,0,0,0,0,0,19,10803,50,0,0,0,0,0,"Angus - On Script - Set Data 15 0 Wheeler"),
-(@ENTRY,9,170,0,0,0,100,0,12000,12000,0,0,45,18,0,0,0,0,0,19,10805,100,0,0,0,0,0,"Angus - On Script - Set Data 18 0 Klemmy"),
-(@ENTRY,9,171,0,0,0,100,0,4000,4000,0,0,45,16,0,0,0,0,0,19,10803,100,0,0,0,0,0,"Angus - On Script - Set Data 16 0 Wheeler"),
-(@ENTRY,9,172,0,0,0,100,0,2000,2000,0,0,45,3,0,0,0,0,0,1,0,0,0,0,0,0,0,"Angus - On Script - Set Data 3 0 Angus"),
-(@ENTRY,9,173,0,0,0,100,0,1000,1000,0,0,45,18,0,0,0,0,0,19,10804,100,0,0,0,0,0,"Angus - On Script - Set Data 18 0 Middlecamp"),
-(@ENTRY,9,174,0,0,0,100,0,1000,1000,0,0,45,3,0,0,0,0,0,19,1243,100,0,0,0,0,0,"Angus - On Script - Set Data 3 0 Hegnar"),
-(@ENTRY,9,175,0,0,0,100,0,0,0,0,0,45,12,0,0,0,0,0,19,10611,100,0,0,0,0,0,"Angus - On Script - Set Data 12 0 Shorty");
diff --git a/sql/updates/world/UNABLE-2015_07_01_00_world_2015_05_26_00.sql b/sql/updates/world/UNABLE-2015_07_01_00_world_2015_05_26_00.sql
deleted file mode 100644
index c098f448ed9..00000000000
--- a/sql/updates/world/UNABLE-2015_07_01_00_world_2015_05_26_00.sql
+++ /dev/null
@@ -1,7 +0,0 @@
---
-UPDATE `creature_template` SET `npcflag`=3, `gossip_menu_id`=5032 WHERE `entry`=241;
-DELETE FROM `gossip_menu` WHERE `entry`=5032;
-INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (5032, 6158);
-DELETE FROM `npc_text` WHERE `ID`=6158;
-INSERT INTO `npc_text` (`ID`, `text0_0`, `text0_1`, `BroadcastTextID0`, `lang0`, `prob0`, `em0_0`, `em0_1`) VALUES
-(6158, 'Hey there, friend. My name''s Remy. I''m from Redridge to the east, and came here looking for business, looking for business. You got any...got any??', 'Hey there, friend. My name''s Remy. I''m from Redridge to the east, and came here looking for business, looking for business. You got any...got any??', 0, 0, 1, 0, 0);