SQL: Fix import

1 files changed, 101 insertions, 101 deletions

diff --git a/sql/updates/world/master/2017_01_09_11_world.sql b/sql/updates/world/master/2017_01_09_11_world.sql
index a962991d91c..a23b1a7de75 100644
--- a/sql/updates/world/master/2017_01_09_11_world.sql
+++ b/sql/updates/world/master/2017_01_09_11_world.sql
@@ -2,24 +2,24 @@
 SET @CGUID := 250026;
 DELETE FROM `creature` WHERE `id` BETWEEN 8210 AND 8219;
 DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+16;
-INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
-(@CGUID+0, 8210, 0, 0, 0, 1, 1, 0, 0, 0, 101.2535, -4123.439, 172.8117, 2.513274, 120000, 0, 0, 1, 0, 0, 0, 0, 0, 23222), -- 8210 Razortalon Rare
-(@CGUID+1, 8211, 0, 0, 0, 1, 1, 0, 0, 0, 80.68924, -2095.195, 113.1613, 3.735005, 120000, 0, 0, 1, 0, 0, 0, 0, 0, 23222), -- 8211 Old Cliff Jumper Rare
-(@CGUID+2, 8212, 0, 0, 0, 1, 1, 0, 0, 0, 364.6962, -3795.405, 171.4433, 0.50505, 120000, 5, 0, 1, 0, 1, 0, 0, 0, 23222), -- 8212 The Reak Rare
-(@CGUID+3, 8213, 0, 0, 0, 1, 1, 0, 0, 0, 13.55792, -4670.14, 9.560886, 5.367609, 120000, 10, 0, 1, 0, 1, 0, 0, 0, 23222), -- 8213 Ironback Rare
-(@CGUID+4, 8214, 0, 0, 0, 1, 1, 0, 0, 0, 58.53993, -2908.906, 115.6817, 2.199115, 120000, 0, 0, 1, 0, 0, 0, 0, 0, 23222), -- 8214 Jalinde Summerdrake Rare
-(@CGUID+5, 8215, 0, 0, 0, 1, 1, 0, 0, 0, -131.599, -4337.361, 135.6074, 5.575138, 120000, 0, 0, 1, 0, 0, 0, 0, 0, 23222), -- 8215 Grimungous Rare
-(@CGUID+6, 8216, 0, 0, 0, 1, 1, 0, 0, 0, -252.7065, -3418.581, 163.9043, 3.83404, 120000, 0, 0, 1, 0, 2, 0, 0, 0, 23222), -- 8216 Retherokk The Berserker Rare
-(@CGUID+7, 8217, 0, 0, 0, 1, 1, 0, 0, 0, -631.6024, -4072.503, 238.6663, 3.159046, 120000, 0, 0, 1, 0, 0, 0, 0, 0, 23222), -- 8217 Mith`rethis The Enchanter Rare
-(@CGUID+8, 8218, 0, 0, 0, 1, 1, 0, 0, 0, -237.7153, -3112.335, 125.751, 1.727876, 120000, 0, 0, 1, 0, 0, 0, 0, 0, 23222), -- 8218 Witherheart The Stalker Rare
-(@CGUID+9, 8219, 0, 0, 0, 1, 1, 0, 0, 0, -214.1649, -2523.273, 118.5041, 4.18879, 120000, 0, 0, 1, 0, 0, 0, 0, 0, 23222), -- 8219 Zul'arek Hatefowler Rare
-(@CGUID+10, 2640, 0, 0, 0, 1, 1, 0, 0, 0, -296.8905, -4167.815, 136.4466, 0.9849242, 120, 2, 0, 1, 0, 1, 0, 0, 0, 23222), -- 2640 
-(@CGUID+11, 2640, 0, 0, 0, 1, 1, 0, 0, 0, -294.7113, -4111.446, 137.4777, 4.027113, 120, 2, 0, 1, 0, 1, 0, 0, 0, 23222), -- 2640 
-(@CGUID+12, 4465, 0, 0, 0, 1, 1, 0, 0, 0, -310.6821, -4202.085, 137.5622, 5.925552, 120, 2, 0, 1, 0, 1, 0, 0, 0, 23222), -- 4465 
-(@CGUID+13, 4465, 0, 0, 0, 1, 1, 0, 0, 0, -311.3799, -4135.26, 136.9623, 2.597605, 120, 2, 0, 1, 0, 1, 0, 0, 0, 23222), -- 4465 
-(@CGUID+14, 4465, 0, 0, 0, 1, 1, 0, 0, 0, -283.0217, -4142.365, 136.7434, 0.01745329, 120, 2, 0, 1, 0, 1, 0, 0, 0, 23222), -- 4465
-(@CGUID+15, 4465, 0, 0, 0, 1, 1, 0, 0, 0, -276.6738, -4212.105, 136.3606, 5.826622, 120, 2, 0, 1, 0, 1, 0, 0, 0, 23222), -- 4465
-(@CGUID+16, 4465, 0, 0, 0, 1, 1, 0, 0, 0, -280.7188, -4214.664, 136.8459, 2.8292, 120, 2, 0, 1, 0, 1, 0, 0, 0, 23222); -- 4465
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
+(@CGUID+0, 8210, 0, 0, 0, 1, 0, 0, 0, 0, 101.2535, -4123.439, 172.8117, 2.513274, 120000, 0, 0, 1, 0, 0, 0, 0, 0, 23222), -- 8210 Razortalon Rare
+(@CGUID+1, 8211, 0, 0, 0, 1, 0, 0, 0, 0, 80.68924, -2095.195, 113.1613, 3.735005, 120000, 0, 0, 1, 0, 0, 0, 0, 0, 23222), -- 8211 Old Cliff Jumper Rare
+(@CGUID+2, 8212, 0, 0, 0, 1, 0, 0, 0, 0, 364.6962, -3795.405, 171.4433, 0.50505, 120000, 5, 0, 1, 0, 1, 0, 0, 0, 23222), -- 8212 The Reak Rare
+(@CGUID+3, 8213, 0, 0, 0, 1, 0, 0, 0, 0, 13.55792, -4670.14, 9.560886, 5.367609, 120000, 10, 0, 1, 0, 1, 0, 0, 0, 23222), -- 8213 Ironback Rare
+(@CGUID+4, 8214, 0, 0, 0, 1, 0, 0, 0, 0, 58.53993, -2908.906, 115.6817, 2.199115, 120000, 0, 0, 1, 0, 0, 0, 0, 0, 23222), -- 8214 Jalinde Summerdrake Rare
+(@CGUID+5, 8215, 0, 0, 0, 1, 0, 0, 0, 0, -131.599, -4337.361, 135.6074, 5.575138, 120000, 0, 0, 1, 0, 0, 0, 0, 0, 23222), -- 8215 Grimungous Rare
+(@CGUID+6, 8216, 0, 0, 0, 1, 0, 0, 0, 0, -252.7065, -3418.581, 163.9043, 3.83404, 120000, 0, 0, 1, 0, 2, 0, 0, 0, 23222), -- 8216 Retherokk The Berserker Rare
+(@CGUID+7, 8217, 0, 0, 0, 1, 0, 0, 0, 0, -631.6024, -4072.503, 238.6663, 3.159046, 120000, 0, 0, 1, 0, 0, 0, 0, 0, 23222), -- 8217 Mith`rethis The Enchanter Rare
+(@CGUID+8, 8218, 0, 0, 0, 1, 0, 0, 0, 0, -237.7153, -3112.335, 125.751, 1.727876, 120000, 0, 0, 1, 0, 0, 0, 0, 0, 23222), -- 8218 Witherheart The Stalker Rare
+(@CGUID+9, 8219, 0, 0, 0, 1, 0, 0, 0, 0, -214.1649, -2523.273, 118.5041, 4.18879, 120000, 0, 0, 1, 0, 0, 0, 0, 0, 23222), -- 8219 Zul'arek Hatefowler Rare
+(@CGUID+10, 2640, 0, 0, 0, 1, 0, 0, 0, 0, -296.8905, -4167.815, 136.4466, 0.9849242, 120, 2, 0, 1, 0, 1, 0, 0, 0, 23222), -- 2640 
+(@CGUID+11, 2640, 0, 0, 0, 1, 0, 0, 0, 0, -294.7113, -4111.446, 137.4777, 4.027113, 120, 2, 0, 1, 0, 1, 0, 0, 0, 23222), -- 2640 
+(@CGUID+12, 4465, 0, 0, 0, 1, 0, 0, 0, 0, -310.6821, -4202.085, 137.5622, 5.925552, 120, 2, 0, 1, 0, 1, 0, 0, 0, 23222), -- 4465 
+(@CGUID+13, 4465, 0, 0, 0, 1, 0, 0, 0, 0, -311.3799, -4135.26, 136.9623, 2.597605, 120, 2, 0, 1, 0, 1, 0, 0, 0, 23222), -- 4465 
+(@CGUID+14, 4465, 0, 0, 0, 1, 0, 0, 0, 0, -283.0217, -4142.365, 136.7434, 0.01745329, 120, 2, 0, 1, 0, 1, 0, 0, 0, 23222), -- 4465
+(@CGUID+15, 4465, 0, 0, 0, 1, 0, 0, 0, 0, -276.6738, -4212.105, 136.3606, 5.826622, 120, 2, 0, 1, 0, 1, 0, 0, 0, 23222), -- 4465
+(@CGUID+16, 4465, 0, 0, 0, 1, 0, 0, 0, 0, -280.7188, -4214.664, 136.8459, 2.8292, 120, 2, 0, 1, 0, 1, 0, 0, 0, 23222); -- 4465
 
 SET @CGUID := 251184;
 DELETE FROM `creature` WHERE `guid` IN (278801,278787,278426,278427);
@@ -28,84 +28,84 @@ DELETE FROM `creature_addon` WHERE `guid` BETWEEN 278812 AND 278840;
 DELETE FROM `creature` WHERE `guid` IN (278810,278811,278817,278833,278844,278848,278863,278864);
 DELETE FROM `creature_addon` WHERE `guid` IN (278810,278811,278817,278833,278844,278848,278863,278864);
 DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+66;
-INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
-(@CGUID+0, 4075, 0, 0, 0, 1, 1, 0, 0, 0, -608.7956, -3806.088, 238.9825, 0.3391256, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 4075 Rat
-(@CGUID+1, 4075, 0, 0, 0, 1, 1, 0, 0, 0, -638.423, -3813.172, 230.7805, 1.849781, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 4075 Rat
-(@CGUID+2, 4075, 0, 0, 0, 1, 1, 0, 0, 0, -664.152, -3795.323, 223.439, 5.390024, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 4075 Rat
-(@CGUID+3, 4075, 0, 0, 0, 1, 1, 0, 0, 0, -701.6794, -3718.922, 238.1163, 0.6001411, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 4075 Rat
-(@CGUID+4, 4075, 0, 0, 0, 1, 1, 0, 0, 0, -731.1082, -3750.499, 235.2371, 3.583518, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 4075 Rat
-(@CGUID+5, 4075, 0, 0, 0, 1, 1, 0, 0, 0, -710.8499, -3700.889, 233.908, 5.032559, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 4075 Rat
-(@CGUID+6, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -627.1963, -3841.872, 235.0289, 4.363582, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+7, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -600.8868, -3799.866, 236.493, 0.3592527, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+8, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -574.8731, -3806.915, 235.4047, 4.899583, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+9, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -593.2894, -3788.529, 236.7897, 5.968546, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+10, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -605.1924, -3794.589, 237.9833, 3.620992, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+11, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -608.329, -3781.287, 240.1658, 1.192191, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+12, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -627.267, -3794.745, 235.7311, 3.474902, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+13, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -656.5789, -3813.464, 226.1417, 1.755308, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+14, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -636.5413, -3785.888, 231.2919, 5.654318, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+15, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -611.775, -3763.216, 233.2912, 4.610962, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+16, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -609.386, -3757.009, 232.0977, 2.132595, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+17, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -659.9223, -3798.425, 224.5815, 1.962019, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+18, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -627.1904, -3739.672, 233.293, 0.08660996, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+19, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -618.6515, -3740.074, 232.5356, 6.202462, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+20, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -669.9534, -3792.662, 222.7375, 6.031985, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+21, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -661.8912, -3767.821, 223.5414, 3.680815, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+22, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -635.5818, -3727.25, 234.8563, 0.5121437, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+23, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -626.7623, -3734.221, 233.2612, 6.132655, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+24, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -671.5661, -3743.432, 221.2046, 5.201729, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+25, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -680.4857, -3768.191, 220.6308, 2.64238, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+26, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -641.0101, -3726.152, 235.6062, 5.662982, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+27, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -672.3889, -3757.501, 220.9368, 2.202346, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+28, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -693.2059, -3756.623, 220.7856, 2.11699, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+29, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -705.5532, -3781.617, 226.4135, 3.639673, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+30, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -713.0941, -3780.002, 226.8275, 2.970215, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+31, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -712.642, -3755.924, 234.1238, 1.191027, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+32, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -721.307, -3757.205, 233.8016, 3.353385, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+33, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -677.909, -3703.467, 224.9244, 5.608123, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+34, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -731.611, -3780.07, 230.2183, 0, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+35, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -671.8797, -3700.797, 224.9471, 6.204938, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+36, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -737.0838, -3762.26, 233.2035, 4.43078, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+37, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -733.5049, -3778.053, 230.347, 0.8571718, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+38, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -704.7576, -3719.207, 238.1415, 3.972723, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+39, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -736.3867, -3762.977, 233.0542, 0.7418172, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+40, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -718.1517, -3728.705, 238.2844, 4.311355, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+41, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -743.6503, -3784.961, 231.5213, 2.880282, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+42, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -675.6412, -3690.571, 228.5154, 4.886071, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+43, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -676.618, -3685.632, 230.4247, 5.341321, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+44, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -674.0057, -3677.806, 231.4881, 3.279948, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+45, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -709.3322, -3680.713, 232.1908, 1.277609, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+46, 14881, 0, 0, 0, 1, 1, 0, 0, 0, -697.691, -3673.721, 232.8588, 1.259923, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
-(@CGUID+47, 42879, 0, 0, 0, 1, 1, 0, 0, 0, -565.5434, -3831.823, 234.9122, 5.864306, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 42879 Spawn of Shadra
-(@CGUID+48, 42879, 0, 0, 0, 1, 1, 0, 0, 0, -578.7448, -3803.799, 235.0221, 2.154474, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 42879 Spawn of Shadra
-(@CGUID+49, 42879, 0, 0, 0, 1, 1, 0, 0, 0, -604.2947, -3791.699, 238.5831, 6.183424, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 42879 Spawn of Shadra
-(@CGUID+50, 42879, 0, 0, 0, 1, 1, 0, 0, 0, -611.9299, -3748.688, 231.1299, 3.266886, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 42879 Spawn of Shadra
-(@CGUID+51, 42879, 0, 0, 0, 1, 1, 0, 0, 0, -645.0364, -3811.121, 229.167, 1.647379, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 42879 Spawn of Shadra
-(@CGUID+52, 42879, 0, 0, 0, 1, 1, 0, 0, 0, -667.4815, -3801.322, 222.9417, 4.726198, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 42879 Spawn of Shadra
-(@CGUID+53, 42879, 0, 0, 0, 1, 1, 0, 0, 0, -625.8585, -3736.616, 233.1844, 5.646459, 120, 0, 0, 1, 0, 2, 0, 0, 0, 23222), -- 42879 Spawn of Shadra
-(@CGUID+54, 42879, 0, 0, 0, 1, 1, 0, 0, 0, -638.6163, -3730.158, 230.592, 2.373648, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 42879 Spawn of Shadra
-(@CGUID+55, 42879, 0, 0, 0, 1, 1, 0, 0, 0, -675.9734, -3779.973, 221.9275, 4.978273, 120, 0, 0, 1, 0, 2, 0, 0, 0, 23222), -- 42879 Spawn of Shadra
-(@CGUID+56, 42879, 0, 0, 0, 1, 1, 0, 0, 0, -690.4488, -3779.787, 228.1711, 0.192542, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 42879 Spawn of Shadra
-(@CGUID+57, 42879, 0, 0, 0, 1, 1, 0, 0, 0, -677.6154, -3764.926, 220.8464, 5.583363, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 42879 Spawn of Shadra
-(@CGUID+58, 42879, 0, 0, 0, 1, 1, 0, 0, 0, -682.3189, -3735.995, 218.923, 0.7508205, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 42879 Spawn of Shadra
-(@CGUID+59, 42879, 0, 0, 0, 1, 1, 0, 0, 0, -714.1218, -3747.265, 235.3767, 1.025457, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 42879 Spawn of Shadra
-(@CGUID+60, 42879, 0, 0, 0, 1, 1, 0, 0, 0, -726.3847, -3777.65, 229.8129, 0.9328126, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 42879 Spawn of Shadra
-(@CGUID+61, 42879, 0, 0, 0, 1, 1, 0, 0, 0, -706.651, -3721.888, 238.1756, 1.559227, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 42879 Spawn of Shadra
-(@CGUID+62, 42879, 0, 0, 0, 1, 1, 0, 0, 0, -715.2934, -3732.658, 238.1331, 4.315888, 120, 0, 0, 1, 0, 2, 0, 0, 0, 23222), -- 42879 Spawn of Shadra
-(@CGUID+63, 42879, 0, 0, 0, 1, 1, 0, 0, 0, -688.2827, -3674.572, 233.4627, 5.552467, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 42879 Spawn of Shadra
-(@CGUID+64, 45439, 0, 0, 0, 1, 1, 0, 0, 0, -680.3643, -3771.307, 220.7337, 2.174744, 120, 8, 0, 0, 0, 1, 0, 0, 0, 23222), -- 45439 Cockroach
-(@CGUID+65, 45439, 0, 0, 0, 1, 1, 0, 0, 0, -675.3947, -3734.667, 220.0398, 1.739893, 120, 8, 0, 0, 0, 1, 0, 0, 0, 23222), -- 45439 Cockroach
-(@CGUID+66, 42877, 0, 0, 0, 1, 1, 0, 0, 0, -752.4427, -3787.913, 230.9504, 3.543018, 120, 0, 0, 1, 0, 0, 0, 0, 0, 23222); -- 42877 Morta'gya the Keeper
-
-INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
-(278810, 2645, 0, 0, 0, 1, 1, 0, 0, 0, -162.014, -3792.81, 238.2969, 2.513274, 120, 0, 0, 1, 0, 0, 0, 0, 0, 23222), -- 2645 Vilebranch Shadow Hunter
-(278811, 4465, 0, 0, 0, 1, 1, 0, 0, 0, -300.8814, -4190.363, 136.5622, 2.513274, 120, 0, 0, 1, 0, 0, 0, 0, 0, 23222), -- 4465 Vilebranch Warrior 
-(278817, 2640, 0, 0, 0, 1, 1, 0, 0, 0, -336.711, -4213.299, 152.1899, 0.2114051, 120, 2, 0, 1, 0, 1, 0, 0, 0, 23222), -- 2640
-(278833, 2640, 0, 0, 0, 1, 1, 0, 0, 0, -313.7775, -4228.961, 136.6896, 3.159046, 120, 2, 0, 1, 0, 1, 0, 0, 0, 23222), -- 2640
-(278844, 2641, 0, 0, 0, 1, 1, 0, 0, 0, -351.2706, -4181.298, 152.1125, 1.68542, 120, 2, 0, 1, 0, 1, 0, 0, 0, 23222), -- 2641
-(278848, 2641, 0, 0, 0, 1, 1, 0, 0, 0, -351.9893, -4205.648, 152.3052, 2.485164, 120, 2, 0, 1, 0, 1, 0, 0, 0, 23222), -- 2641
-(278863, 2641, 0, 0, 0, 1, 1, 0, 0, 0, -348.0254, -4222.727, 152.3547, 3.40067, 120, 2, 0, 1, 0, 1, 0, 0, 0, 23222), -- 2641
-(278864, 2641, 0, 0, 0, 1, 1, 0, 0, 0, -358.0292, -4116.998, 154.2687, 3.40067, 120, 2, 0, 1, 0, 1, 0, 0, 0, 23222); -- 2641
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
+(@CGUID+0, 4075, 0, 0, 0, 1, 0, 0, 0, 0, -608.7956, -3806.088, 238.9825, 0.3391256, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 4075 Rat
+(@CGUID+1, 4075, 0, 0, 0, 1, 0, 0, 0, 0, -638.423, -3813.172, 230.7805, 1.849781, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 4075 Rat
+(@CGUID+2, 4075, 0, 0, 0, 1, 0, 0, 0, 0, -664.152, -3795.323, 223.439, 5.390024, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 4075 Rat
+(@CGUID+3, 4075, 0, 0, 0, 1, 0, 0, 0, 0, -701.6794, -3718.922, 238.1163, 0.6001411, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 4075 Rat
+(@CGUID+4, 4075, 0, 0, 0, 1, 0, 0, 0, 0, -731.1082, -3750.499, 235.2371, 3.583518, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 4075 Rat
+(@CGUID+5, 4075, 0, 0, 0, 1, 0, 0, 0, 0, -710.8499, -3700.889, 233.908, 5.032559, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 4075 Rat
+(@CGUID+6, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -627.1963, -3841.872, 235.0289, 4.363582, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+7, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -600.8868, -3799.866, 236.493, 0.3592527, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+8, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -574.8731, -3806.915, 235.4047, 4.899583, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+9, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -593.2894, -3788.529, 236.7897, 5.968546, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+10, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -605.1924, -3794.589, 237.9833, 3.620992, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+11, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -608.329, -3781.287, 240.1658, 1.192191, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+12, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -627.267, -3794.745, 235.7311, 3.474902, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+13, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -656.5789, -3813.464, 226.1417, 1.755308, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+14, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -636.5413, -3785.888, 231.2919, 5.654318, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+15, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -611.775, -3763.216, 233.2912, 4.610962, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+16, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -609.386, -3757.009, 232.0977, 2.132595, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+17, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -659.9223, -3798.425, 224.5815, 1.962019, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+18, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -627.1904, -3739.672, 233.293, 0.08660996, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+19, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -618.6515, -3740.074, 232.5356, 6.202462, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+20, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -669.9534, -3792.662, 222.7375, 6.031985, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+21, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -661.8912, -3767.821, 223.5414, 3.680815, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+22, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -635.5818, -3727.25, 234.8563, 0.5121437, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+23, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -626.7623, -3734.221, 233.2612, 6.132655, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+24, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -671.5661, -3743.432, 221.2046, 5.201729, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+25, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -680.4857, -3768.191, 220.6308, 2.64238, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+26, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -641.0101, -3726.152, 235.6062, 5.662982, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+27, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -672.3889, -3757.501, 220.9368, 2.202346, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+28, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -693.2059, -3756.623, 220.7856, 2.11699, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+29, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -705.5532, -3781.617, 226.4135, 3.639673, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+30, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -713.0941, -3780.002, 226.8275, 2.970215, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+31, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -712.642, -3755.924, 234.1238, 1.191027, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+32, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -721.307, -3757.205, 233.8016, 3.353385, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+33, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -677.909, -3703.467, 224.9244, 5.608123, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+34, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -731.611, -3780.07, 230.2183, 0, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+35, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -671.8797, -3700.797, 224.9471, 6.204938, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+36, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -737.0838, -3762.26, 233.2035, 4.43078, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+37, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -733.5049, -3778.053, 230.347, 0.8571718, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+38, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -704.7576, -3719.207, 238.1415, 3.972723, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+39, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -736.3867, -3762.977, 233.0542, 0.7418172, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+40, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -718.1517, -3728.705, 238.2844, 4.311355, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+41, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -743.6503, -3784.961, 231.5213, 2.880282, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+42, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -675.6412, -3690.571, 228.5154, 4.886071, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+43, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -676.618, -3685.632, 230.4247, 5.341321, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+44, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -674.0057, -3677.806, 231.4881, 3.279948, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+45, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -709.3322, -3680.713, 232.1908, 1.277609, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+46, 14881, 0, 0, 0, 1, 0, 0, 0, 0, -697.691, -3673.721, 232.8588, 1.259923, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 14881 Spider
+(@CGUID+47, 42879, 0, 0, 0, 1, 0, 0, 0, 0, -565.5434, -3831.823, 234.9122, 5.864306, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 42879 Spawn of Shadra
+(@CGUID+48, 42879, 0, 0, 0, 1, 0, 0, 0, 0, -578.7448, -3803.799, 235.0221, 2.154474, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 42879 Spawn of Shadra
+(@CGUID+49, 42879, 0, 0, 0, 1, 0, 0, 0, 0, -604.2947, -3791.699, 238.5831, 6.183424, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 42879 Spawn of Shadra
+(@CGUID+50, 42879, 0, 0, 0, 1, 0, 0, 0, 0, -611.9299, -3748.688, 231.1299, 3.266886, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 42879 Spawn of Shadra
+(@CGUID+51, 42879, 0, 0, 0, 1, 0, 0, 0, 0, -645.0364, -3811.121, 229.167, 1.647379, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 42879 Spawn of Shadra
+(@CGUID+52, 42879, 0, 0, 0, 1, 0, 0, 0, 0, -667.4815, -3801.322, 222.9417, 4.726198, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 42879 Spawn of Shadra
+(@CGUID+53, 42879, 0, 0, 0, 1, 0, 0, 0, 0, -625.8585, -3736.616, 233.1844, 5.646459, 120, 0, 0, 1, 0, 2, 0, 0, 0, 23222), -- 42879 Spawn of Shadra
+(@CGUID+54, 42879, 0, 0, 0, 1, 0, 0, 0, 0, -638.6163, -3730.158, 230.592, 2.373648, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 42879 Spawn of Shadra
+(@CGUID+55, 42879, 0, 0, 0, 1, 0, 0, 0, 0, -675.9734, -3779.973, 221.9275, 4.978273, 120, 0, 0, 1, 0, 2, 0, 0, 0, 23222), -- 42879 Spawn of Shadra
+(@CGUID+56, 42879, 0, 0, 0, 1, 0, 0, 0, 0, -690.4488, -3779.787, 228.1711, 0.192542, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 42879 Spawn of Shadra
+(@CGUID+57, 42879, 0, 0, 0, 1, 0, 0, 0, 0, -677.6154, -3764.926, 220.8464, 5.583363, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 42879 Spawn of Shadra
+(@CGUID+58, 42879, 0, 0, 0, 1, 0, 0, 0, 0, -682.3189, -3735.995, 218.923, 0.7508205, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 42879 Spawn of Shadra
+(@CGUID+59, 42879, 0, 0, 0, 1, 0, 0, 0, 0, -714.1218, -3747.265, 235.3767, 1.025457, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 42879 Spawn of Shadra
+(@CGUID+60, 42879, 0, 0, 0, 1, 0, 0, 0, 0, -726.3847, -3777.65, 229.8129, 0.9328126, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 42879 Spawn of Shadra
+(@CGUID+61, 42879, 0, 0, 0, 1, 0, 0, 0, 0, -706.651, -3721.888, 238.1756, 1.559227, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 42879 Spawn of Shadra
+(@CGUID+62, 42879, 0, 0, 0, 1, 0, 0, 0, 0, -715.2934, -3732.658, 238.1331, 4.315888, 120, 0, 0, 1, 0, 2, 0, 0, 0, 23222), -- 42879 Spawn of Shadra
+(@CGUID+63, 42879, 0, 0, 0, 1, 0, 0, 0, 0, -688.2827, -3674.572, 233.4627, 5.552467, 120, 6, 0, 1, 0, 1, 0, 0, 0, 23222), -- 42879 Spawn of Shadra
+(@CGUID+64, 45439, 0, 0, 0, 1, 0, 0, 0, 0, -680.3643, -3771.307, 220.7337, 2.174744, 120, 8, 0, 0, 0, 1, 0, 0, 0, 23222), -- 45439 Cockroach
+(@CGUID+65, 45439, 0, 0, 0, 1, 0, 0, 0, 0, -675.3947, -3734.667, 220.0398, 1.739893, 120, 8, 0, 0, 0, 1, 0, 0, 0, 23222), -- 45439 Cockroach
+(@CGUID+66, 42877, 0, 0, 0, 1, 0, 0, 0, 0, -752.4427, -3787.913, 230.9504, 3.543018, 120, 0, 0, 1, 0, 0, 0, 0, 0, 23222); -- 42877 Morta'gya the Keeper
+
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
+(278810, 2645, 0, 0, 0, 1, 0, 0, 0, 0, -162.014, -3792.81, 238.2969, 2.513274, 120, 0, 0, 1, 0, 0, 0, 0, 0, 23222), -- 2645 Vilebranch Shadow Hunter
+(278811, 4465, 0, 0, 0, 1, 0, 0, 0, 0, -300.8814, -4190.363, 136.5622, 2.513274, 120, 0, 0, 1, 0, 0, 0, 0, 0, 23222), -- 4465 Vilebranch Warrior 
+(278817, 2640, 0, 0, 0, 1, 0, 0, 0, 0, -336.711, -4213.299, 152.1899, 0.2114051, 120, 2, 0, 1, 0, 1, 0, 0, 0, 23222), -- 2640
+(278833, 2640, 0, 0, 0, 1, 0, 0, 0, 0, -313.7775, -4228.961, 136.6896, 3.159046, 120, 2, 0, 1, 0, 1, 0, 0, 0, 23222), -- 2640
+(278844, 2641, 0, 0, 0, 1, 0, 0, 0, 0, -351.2706, -4181.298, 152.1125, 1.68542, 120, 2, 0, 1, 0, 1, 0, 0, 0, 23222), -- 2641
+(278848, 2641, 0, 0, 0, 1, 0, 0, 0, 0, -351.9893, -4205.648, 152.3052, 2.485164, 120, 2, 0, 1, 0, 1, 0, 0, 0, 23222), -- 2641
+(278863, 2641, 0, 0, 0, 1, 0, 0, 0, 0, -348.0254, -4222.727, 152.3547, 3.40067, 120, 2, 0, 1, 0, 1, 0, 0, 0, 23222), -- 2641
+(278864, 2641, 0, 0, 0, 1, 0, 0, 0, 0, -358.0292, -4116.998, 154.2687, 3.40067, 120, 2, 0, 1, 0, 1, 0, 0, 0, 23222); -- 2641
 
 UPDATE `creature` SET `spawndist`=8,`MovementType`=1 WHERE `id` IN (2505,2655,2656,2657,2658,2923,2924,2925,2926,2927,2928,2929,16030,42913);
 UPDATE `creature` SET `spawndist`=5,`MovementType`=1 WHERE `id` IN (2639,2681,4466,4467,42592,43891);
@@ -118,7 +118,7 @@ UPDATE `creature` SET `position_x`=375.012, `position_y`=-2812.79, `position_z`=
 UPDATE `npc_spellclick_spells` SET `cast_flags`=3 WHERE `npc_entry` IN (44776);
 
 DELETE FROM `gossip_menu` WHERE `entry`=12091;
-INSERT INTO `gossip_menu` (`entry`,`text_id`,`VerifiedBuild`) VALUES (12091,16975,23222);
+INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (12091,16975);
 
 UPDATE `creature_template` SET `flags_extra`=128 WHERE `entry` IN (42704);
 UPDATE `creature_template_addon` SET `auras`="" WHERE `entry` IN (42704);
@@ -136,10 +136,10 @@ UPDATE `creature_template` SET `gossip_menu_id`=12127 WHERE `entry` IN (46475);
 UPDATE `creature_template` SET `gossip_menu_id`=11772 WHERE `entry` IN (43200);
 
 DELETE FROM `gossip_menu` WHERE `entry` IN (11687,11715,11716,11771);
-INSERT INTO `gossip_menu` (`entry`,`text_id`,`VerifiedBuild`) VALUES (11687,16364,23222);
-INSERT INTO `gossip_menu` (`entry`,`text_id`,`VerifiedBuild`) VALUES (11715,16394,23222);
-INSERT INTO `gossip_menu` (`entry`,`text_id`,`VerifiedBuild`) VALUES (11716,16396,23222);
-INSERT INTO `gossip_menu` (`entry`,`text_id`,`VerifiedBuild`) VALUES (11771,16505,23222);
+INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (11687,16364);
+INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (11715,16394);
+INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (11716,16396);
+INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (11771,16505);
 
 DELETE FROM `gossip_menu_option` WHERE `menu_id`=11716;
 INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `OptionBroadcastTextID`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`) VALUES