Ученый
Регистрация: 14.06.2010
Адрес: Огриммар,улица гоблинов-инженеров 23
Сообщений: 267
Сказал(а) спасибо: 41
Поблагодарили 144 раз(а) в 111 сообщениях
|
Код:
DELETE FROM creature WHERE id = 18970;
------------------------------------------------------------------Unit 18970------------------------------------------------------------------
SET @GUID := XXXXX+2;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18970, 530, 1, 1, 15574, 0, -235.1163, 1071.609, 54.3077, 6.254465, 300, 0, 0, 12652, 0, 0, 2);
REPLACE INTO `creature_addon` VALUES (@GUID, @GUID, 0, 0, 1, 0);
UPDATE `creature_model_info` SET `combat_reach` = 1.5 WHERE `modelid` = 15574;
UPDATE `creature_template` SET `equipment_id` = 18970, WHERE entry = 18970;
UPDATE `creature_equip_template` SET `entry` = 18970 WHERE `entry` = 300;
REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(@GUID, 1, -240.4557, 1071.739, 54.3075),
(@GUID, 2, -241.4543, 1071.791, 54.3075),
(@GUID, 3, -230.8612, 1071.487, 54.30785),
(@GUID, 4, -227.9551, 1071.403, 54.31306),
(@GUID, 5, -227.9551, 1071.403, 54.31306);
------------------------------------------------------------------Unit 18970------------------------------------------------------------------
SET @GUID := XXXXX+8;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18970, 530, 1, 1, 15577, 0, -237.0864, 1069.114, 54.32008, 0.6026492, 300, 0, 0, 13084, 0, 0, 2);
REPLACE INTO `creature_addon` VALUES (@GUID, @GUID, 0, 0, 1, 0);
REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(@GUID, 1, -241.8903, 1064.612, 54.33144),
(@GUID, 2, -242.3148, 1065.517, 54.33144),
(@GUID, 3, -240.6434, 1066.667, 54.33157),
(@GUID, 4, -233.8176, 1071.363, 54.30952),
(@GUID, 5, -230.8504, 1073.405, 54.3136),
(@GUID, 6, -230.8504, 1073.405, 54.3136);
------------------------------------------------------------------Unit 18970------------------------------------------------------------------
SET @GUID := XXXXX+83;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18970, 530, 1, 1, 15574, 0, -239.2372, 1070.235, 54.30887, 0.6681901, 300, 0, 0, 12652, 0, 0, 1);
REPLACE INTO `creature_addon` VALUES (@GUID, 0, 0, 0, 1, 0);
------------------------------------------------------------------Unit 18970------------------------------------------------------------------
SET @GUID := XXXXX+89;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18970, 530, 1, 1, 15574, 0, -233.8166, 1071.011, 54.30952, 1.292333, 300, 0, 0, 12652, 0, 0, 1);
REPLACE INTO `creature_addon` VALUES (@GUID, 0, 0, 0, 1, 0);
------------------------------------------------------------------Unit 18970------------------------------------------------------------------
SET @GUID := XXXXX+93;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18970, 530, 1, 1, 15574, 0, -234.3484, 1081.479, 49.78738, 4.345839, 300, 0, 0, 13084, 0, 0, 1);
REPLACE INTO `creature_addon` VALUES (@GUID, 0, 0, 0, 1, 0);
------------------------------------------------------------------Unit 18970------------------------------------------------------------------
SET @GUID := XXXXX+99;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18970, 530, 1, 1, 15578, 0, -227.9551, 1071.403, 54.31306, 1.30748, 300, 0, 0, 12652, 0, 0, 1);
REPLACE INTO `creature_addon` VALUES (@GUID, 0, 0, 0, 1, 0);
------------------------------------------------------------------Unit 18970------------------------------------------------------------------
SET @GUID := XXXXX+144;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18970, 530, 1, 1, 15574, 0, -234.8402, 1063.812, 54.33169, 1.602194, 300, 0, 0, 13084, 0, 0, 1);
REPLACE INTO `creature_addon` VALUES (@GUID, 0, 0, 0, 1, 0);
------------------------------------------------------------------Unit 18970------------------------------------------------------------------
SET @GUID := XXXXX+156;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18970, 530, 1, 1, 15579, 0, -160.6884, 966.2561, 54.36349, 1.815142, 300, 0, 0, 13084, 0, 0, 1);
REPLACE INTO `creature_addon` VALUES (@GUID, 0, 0, 0, 1, 0);
Код:
------------------------------------------------------------------Unit 19445------------------------------------------------------------------
SET @GUID := XXXXX+1;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 19445, 530, 1, 1, 18891, 0, -358.443, 997.756, 54.20879, 0.7382522, 300, 0, 0, 5228, 0, 0, 2);
REPLACE INTO `creature_addon` VALUES (@GUID, @GUID, 0, 0, 1, 0);
UPDATE `creature_template` SET `faction_A` = 1756, `faction_H` = 1756 WHERE `entry` = 19445;
UPDATE `creature_model_info` SET `combat_reach` = 1.5 WHERE `modelid` = 18891;
REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(@GUID, 1, -366.672, 993.3828, 54.2785),
(@GUID, 2, -365.8839, 992.7672, 54.2785),
(@GUID, 3, -360.7302, 995.6749, 54.20843),
(@GUID, 4, -351.6769, 1003.912, 54.20984),
(@GUID, 5, -351.6769, 1003.912, 54.20984);
Код:
DELETE FROM creature WHERE id = 18944
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+3;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -240.2755, 1076.022, 53.35101, 5.857597, 300, 0, 0, 90818, 0, 0, 2);
UPDATE `creature_template` SET `equipment_id` = 18944, WHERE entry = 18944;
UPDATE `creature_equip_template` SET `entry` = 18944 WHERE `entry` = 292;
REPLACE INTO `creature_addon` VALUES (@GUID, @GUID, 0, 0, 1, 0);
UPDATE `creature_template` SET `faction_A` = 1754, `faction_H` = 1754 WHERE `entry` = 18944;
UPDATE `creature_model_info` SET `combat_reach` = 5 WHERE `modelid` = 18345;
REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(@GUID, 1, -242.9914, 1076.797, 52.81688),
(@GUID, 2, -241.9914, 1076.8, 52.81688),
(@GUID, 3, -237.2071, 1074.631, 54.30616),
(@GUID, 4, -235.8466, 1074.015, 54.30786),
(@GUID, 5, -235.8466, 1074.015, 54.30786);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+4;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -235.4772, 1074.005, 54.30787, 4.233199, 300, 0, 0, 90818, 0, 0, 1);
REPLACE INTO `creature_addon` VALUES (@GUID, 0, 0, 0, 1, 0);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+73;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -258.8555, 1094.271, 41.79165, 5.231437, 300, 0, 0, 90818, 0, 0, 1);
REPLACE INTO `creature_addon` VALUES (@GUID, 0, 0, 0, 1, 0);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+74;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -259.8593, 1075.415, 53.55476, -1.40455, 300, 0, 0, 90818, 0, 0, 1);
REPLACE INTO `creature_addon` VALUES (@GUID, 0, 0, 0, 1, 0);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+75;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -235.6032, 1064.832, 54.33144, -2.127592, 300, 0, 0, 90818, 0, 0, 1);
REPLACE INTO `creature_addon` VALUES (@GUID, 0, 0, 0, 1, 0);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+76;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -235.7688, 1070.205, 54.30929, 2.888316, 300, 0, 0, 90818, 0, 0, 1);
REPLACE INTO `creature_addon` VALUES (@GUID, 0, 0, 0, 1, 0);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+78;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -237.9554, 1072.083, 54.30836, 0.4942765, 300, 0, 0, 90818, 0, 0, 1);
REPLACE INTO `creature_addon` VALUES (@GUID, 0, 0, 0, 1, 0);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+86;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -232.5514, 1071.879, 54.30782, 4.847863, 300, 0, 0, 90818, 0, 0, 1);
REPLACE INTO `creature_addon` VALUES (@GUID, 0, 0, 0, 1, 0);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+96;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -238.6446, 1066.396, 54.33157, 1.505664, 300, 0, 0, 90818, 0, 0, 1);
REPLACE INTO `creature_addon` VALUES (@GUID, 0, 0, 0, 1, 0);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+97;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -245.3523, 1071.995, 54.30853, 6.242895, 300, 0, 0, 90818, 0, 0, 1);
REPLACE INTO `creature_addon` VALUES (@GUID, 0, 0, 0, 1, 0);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+104;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -281.5328, 1147.342, 41.66781, 4.681788, 300, 0, 0, 90818, 0, 0, 1);
REPLACE INTO `creature_addon` VALUES (@GUID, 0, 0, 0, 1, 0);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+119;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -231.0694, 1103.1, 41.70796, -1.442607, 300, 0, 0, 90818, 0, 0, 1);
REPLACE INTO `creature_addon` VALUES (@GUID, 0, 0, 0, 1, 0);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+120;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -242.6451, 1081.412, 49.74723, 5.123934, 300, 0, 0, 90818, 0, 0, 2);
REPLACE INTO `creature_addon` VALUES (@GUID, @GUID, 0, 0, 1, 0);
REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(@GUID, 1, -244.8869, 1087.404, 46.40815),
(@GUID, 2, -244.8247, 1086.406, 46.40815),
(@GUID, 3, -239.8952, 1075.112, 53.95973),
(@GUID, 4, -239.8952, 1075.112, 53.95973);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+121;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -239.7774, 1073.147, 54.30766, -1.848192, 300, 0, 0, 90818, 0, 0, 1);
REPLACE INTO `creature_addon` VALUES (@GUID, 0, 0, 0, 1, 0);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+122;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -255.7888, 1081.902, 49.28724, 5.679891, 300, 0, 0, 90818, 0, 0, 2);
REPLACE INTO `creature_addon` VALUES (@GUID, @GUID, 0, 0, 1, 0);
REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(@GUID, 1, -260.5009, 1086.266, 46.98958),
(@GUID, 2, -260.7003, 1085.286, 46.98958),
(@GUID, 3, -245.0615, 1074.511, 54.30572),
(@GUID, 4, -242.6514, 1072.851, 54.30753),
(@GUID, 5, -242.6514, 1072.851, 54.30753);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+123;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -256.5432, 1146.62, 41.67099, 4.683529, 300, 0, 0, 90818, 0, 0, 1);
REPLACE INTO `creature_addon` VALUES (@GUID, 0, 0, 0, 1, 0);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+124;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -231.5536, 1145.899, 41.74142, 4.682695, 300, 0, 0, 90818, 0, 0, 1);
REPLACE INTO `creature_addon` VALUES (@GUID, 0, 0, 0, 1, 0);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+164;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -237.406, 1092.132, 43.0003, -1.728979, 300, 0, 0, 90818, 0, 0, 1);
REPLACE INTO `creature_addon` VALUES (@GUID, 0, 0, 0, 1, 0);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+169;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -222.2613, 1146.497, 41.61642, 4.721256, 300, 0, 0, 90818, 0, 0, 1);
REPLACE INTO `creature_addon` VALUES (@GUID, 0, 0, 0, 1, 0);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+171;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -272.2593, 1146.032, 41.66781, 4.721465, 300, 0, 0, 90818, 0, 0, 1);
REPLACE INTO `creature_addon` VALUES (@GUID, 0, 0, 0, 1, 0);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+172;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -297.2544, 1145.383, 41.54281, 4.659742, 300, 0, 0, 90818, 0, 0, 1);
REPLACE INTO `creature_addon` VALUES (@GUID, 0, 0, 0, 1, 0);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+173;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -206.564, 1145.178, 41.61642, 4.685148, 300, 0, 0, 90818, 0, 0, 1);
REPLACE INTO `creature_addon` VALUES (@GUID, 0, 0, 0, 1, 0);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+174;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -197.2628, 1146.729, 41.67369, 4.722222, 300, 0, 0, 90818, 0, 0, 1);
REPLACE INTO `creature_addon` VALUES (@GUID, 0, 0, 0, 1, 0);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+181;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -252.437, 1330.134, 14.62227, 4.902894, 300, 0, 0, 90818, 0, 0, 2);
REPLACE INTO `creature_addon` VALUES (@GUID, @GUID, 0, 0, 1, 0);
REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(@GUID, 1, -252.7599, 1334.08, 14.23101),
(@GUID, 2, -252.6954, 1333.082, 14.23101),
(@GUID, 3, -252.5723, 1331.175, 14.51553),
(@GUID, 4, -252.5664, 1330.805, 14.51553),
(@GUID, 5, -251.8086, 1326.875, 15.14053),
(@GUID, 6, -250.8613, 1321.963, 15.76553),
(@GUID, 7, -250.293, 1319.016, 16.39053),
(@GUID, 8, -249.5352, 1315.086, 17.14053),
(@GUID, 9, -248.7773, 1311.156, 17.76553),
(@GUID, 10, -248.209, 1308.209, 18.39053),
(@GUID, 11, -247.2617, 1303.297, 19.01553),
(@GUID, 12, -246.5039, 1299.367, 19.61111),
(@GUID, 13, -245.7461, 1295.438, 20.36111),
(@GUID, 14, -245.4288, 1293.755, 20.48611),
(@GUID, 15, -245.4288, 1293.755, 20.48611);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+182;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -260.2625, 1328.785, 14.86153, 4.821968, 300, 0, 0, 90818, 0, 0, 2);
REPLACE INTO `creature_addon` VALUES (@GUID, @GUID, 0, 0, 1, 0);
REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(@GUID, 1, -260.3711, 1329.779, 14.89053),
(@GUID, 2, -260.2617, 1328.785, 14.89053),
(@GUID, 3, -259.7402, 1325.829, 15.51553),
(@GUID, 4, -259.6104, 1325.083, 15.51553),
(@GUID, 5, -259.6104, 1325.083, 15.51553);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+183;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -244.5071, 1331.484, 14.559, 4.808905, 300, 0, 0, 90818, 0, 0, 2);
REPLACE INTO `creature_addon` VALUES (@GUID, @GUID, 0, 0, 1, 0);
REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(@GUID, 1, -244.6042, 1332.479, 14.51553),
(@GUID, 2, -244.5078, 1331.483, 14.51553),
(@GUID, 3, -243.8998, 1328.112, 15.14053),
(@GUID, 4, -243.8998, 1328.112, 15.14053);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+184;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -236.6146, 1332.63, 14.62951, 4.789327, 300, 0, 0, 90818, 0, 0, 2);
REPLACE INTO `creature_addon` VALUES (@GUID, @GUID, 0, 0, 1, 0);
REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(@GUID, 1, -236.6921, 1333.627, 14.64053),
(@GUID, 2, -236.6152, 1332.63, 14.64053),
(@GUID, 3, -236.0527, 1329.683, 15.26553),
(@GUID, 4, -236.0527, 1329.683, 15.26553);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+185;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -267.6493, 1373.356, 10.43449, 4.763175, 300, 0, 0, 90818, 0, 0, 2);
REPLACE INTO `creature_addon` VALUES (@GUID, @GUID, 0, 0, 1, 0);
REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(@GUID, 1, -267.6992, 1374.354, 10.52421),
(@GUID, 2, -267.6484, 1373.355, 10.52421),
(@GUID, 3, -267.4012, 1369.639, 10.77421),
(@GUID, 4, -267.4012, 1369.639, 10.77421);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+186;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -237.7241, 1375.277, 10.8382, 4.782592, 300, 0, 0, 90818, 0, 0, 2);
REPLACE INTO `creature_addon` VALUES (@GUID, @GUID, 0, 0, 1, 0);
REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(@GUID, 1, -237.7948, 1376.274, 10.8382),
(@GUID, 2, -237.7246, 1375.276, 10.8382),
(@GUID, 3, -237.4755, 1371.749, 10.9632),
(@GUID, 4, -237.4755, 1371.749, 10.9632);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+187;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -247.7001, 1374.629, 10.86003, 4.777107, 300, 0, 0, 90818, 0, 0, 2);
REPLACE INTO `creature_addon` VALUES (@GUID, @GUID, 0, 0, 1, 0);
REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(@GUID, 1, -247.7639, 1375.627, 10.8382),
(@GUID, 2, -247.6992, 1374.629, 10.8382),
(@GUID, 3, -247.4508, 1371.047, 10.8382),
(@GUID, 4, -247.4508, 1371.047, 10.8382);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+188;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -257.6822, 1373.977, 10.84458, 4.782779, 300, 0, 0, 90818, 0, 0, 2);
REPLACE INTO `creature_addon` VALUES (@GUID, @GUID, 0, 0, 1, 0);
REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(@GUID, 1, -257.7218, 1380.952, 10.76818),
(@GUID, 2, -257.8336, 1379.958, 10.76818),
(@GUID, 3, -257.9998, 1378.481, 10.7132),
(@GUID, 4, -256.5938, 1358.539, 11.29487),
(@GUID, 5, -256.1016, 1351.56, 11.91987),
(@GUID, 6, -255.7661, 1346.958, 12.29487),
(@GUID, 7, -255.7661, 1346.958, 12.29487);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+190;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -231.2752, 1456.191, 15.37039, 4.647796, 300, 0, 0, 90818, 0, 0, 2);
REPLACE INTO `creature_addon` VALUES (@GUID, @GUID, 0, 0, 1, 0);
REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(@GUID, 1, -231.2108, 1457.188, 15.305),
(@GUID, 2, -231.2754, 1456.19, 15.305),
(@GUID, 3, -232.2448, 1452.54, 14.93),
(@GUID, 4, -232.2448, 1452.54, 14.93);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+191;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -244.8125, 1460.238, 15.49049, 4.746629, 300, 0, 0, 90818, 0, 0, 2);
REPLACE INTO `creature_addon` VALUES (@GUID, @GUID, 0, 0, 1, 0);
REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(@GUID, 1, -244.8467, 1461.238, 15.44707),
(@GUID, 2, -244.8125, 1460.238, 15.44707),
(@GUID, 3, -245.7137, 1456.852, 15.19719),
(@GUID, 4, -245.7137, 1456.852, 15.19719);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+192;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -222.4811, 1460.924, 16.39148, 4.760912, 300, 0, 0, 90818, 0, 0, 2);
REPLACE INTO `creature_addon` VALUES (@GUID, @GUID, 0, 0, 1, 0);
REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(@GUID, 1, -222.529, 1461.923, 16.43),
(@GUID, 2, -222.4805, 1460.924, 16.43),
(@GUID, 3, -223.3551, 1457.12, 16.055),
(@GUID, 4, -223.3551, 1457.12, 16.055);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+197;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -249.5603, 1469.04, 16.88333, 5.122855, 300, 0, 0, 90818, 0, 0, 2);
REPLACE INTO `creature_addon` VALUES (@GUID, @GUID, 0, 0, 1, 0);
REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(@GUID, 1, -249.9596, 1469.956, 16.91916),
(@GUID, 2, -249.5605, 1469.039, 16.91916),
(@GUID, 3, -250.2938, 1465.74, 16.57207),
(@GUID, 4, -250.2938, 1465.74, 16.57207);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+199;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -278.3636, 1512.696, 30.24022, 0.07631282, 300, 0, 0, 90818, 0, 0, 2);
REPLACE INTO `creature_addon` VALUES (@GUID, @GUID, 0, 0, 1, 0);
REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(@GUID, 1, -281.3409, 1512.469, 30.44566),
(@GUID, 2, -280.3438, 1512.545, 30.44566),
(@GUID, 3, -276.7293, 1512.821, 30.07066),
(@GUID, 4, -276.7293, 1512.821, 30.07066);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+200;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -277.7594, 1504.719, 29.18361, 0.0762392, 300, 0, 0, 90818, 0, 0, 2);
REPLACE INTO `creature_addon` VALUES (@GUID, @GUID, 0, 0, 1, 0);
REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(@GUID, 1, -280.7451, 1504.491, 29.32066),
(@GUID, 2, -279.748, 1504.567, 29.32066),
(@GUID, 3, -276.1205, 1504.844, 29.07066),
(@GUID, 4, -276.1205, 1504.844, 29.07066);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+202;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -196.1944, 1498.664, 25.92807, 3.266088, 300, 0, 0, 90818, 0, 0, 2);
REPLACE INTO `creature_addon` VALUES (@GUID, @GUID, 0, 0, 1, 0);
REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(@GUID, 1, -193.2597, 1499.031, 26.06499),
(@GUID, 2, -194.252, 1498.907, 26.06499),
(@GUID, 3, -197.7977, 1498.464, 25.81506),
(@GUID, 4, -197.7977, 1498.464, 25.81506);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+203;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -195.2068, 1490.726, 25.10884, 3.266204, 300, 0, 0, 90818, 0, 0, 2);
REPLACE INTO `creature_addon` VALUES (@GUID, @GUID, 0, 0, 1, 0);
REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(@GUID, 1, -192.2657, 1491.095, 25.31499),
(@GUID, 2, -193.2578, 1490.97, 25.31499),
(@GUID, 3, -196.8032, 1490.526, 24.93999),
(@GUID, 4, -196.8032, 1490.526, 24.93999);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+206;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -266.6102, 1529.64, 31.21456, 0.07605889, 300, 0, 0, 90818, 0, 0, 2);
REPLACE INTO `creature_addon` VALUES (@GUID, @GUID, 0, 0, 1, 0);
REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(@GUID, 1, -267.6065, 1529.565, 31.16641),
(@GUID, 2, -266.6094, 1529.641, 31.16641),
(@GUID, 3, -263.0021, 1529.916, 30.79141),
(@GUID, 4, -263.0021, 1529.916, 30.79141);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+207;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -267.2198, 1537.617, 32.05139, 0.07610077, 300, 0, 0, 90818, 0, 0, 2);
REPLACE INTO `creature_addon` VALUES (@GUID, @GUID, 0, 0, 1, 0);
REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(@GUID, 1, -268.2178, 1537.541, 32.15049),
(@GUID, 2, -267.2207, 1537.617, 32.15049),
(@GUID, 3, -263.6109, 1537.892, 31.78071),
(@GUID, 4, -263.6109, 1537.892, 31.78071);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+208;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -211.0306, 1513.694, 22.25521, 3.266917, 300, 0, 0, 90818, 0, 0, 2);
REPLACE INTO `creature_addon` VALUES (@GUID, @GUID, 0, 0, 1, 0);
REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(@GUID, 1, -210.0391, 1513.819, 22.3132),
(@GUID, 2, -211.0313, 1513.694, 22.3132),
(@GUID, 3, -214.9444, 1512.846, 21.9382),
(@GUID, 4, -214.9444, 1512.846, 21.9382);
------------------------------------------------------------------Unit 18944------------------------------------------------------------------
SET @GUID := XXXXX+209;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18944, 530, 1, 1, 18345, 0, -207.5619, 1522.728, 23.38855, 2.902283, 300, 0, 0, 90818, 0, 0, 2);
REPLACE INTO `creature_addon` VALUES (@GUID, @GUID, 0, 0, 1, 0);
REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(@GUID, 1, -206.591, 1522.49, 23.3132),
(@GUID, 2, -207.5625, 1522.728, 23.3132),
(@GUID, 3, -216.881, 1520.608, 22.8132),
(@GUID, 4, -216.881, 1520.608, 22.8132);
Код:
SET @GUID := 58328;
UPDATE `creature` SET `position_z` = 54.3165, `orientation` = -3.0747 WHERE `guid` = 58275;
UPDATE `creature_template` SET `faction_A` = 1759, `faction_H` = 1759 WHERE `entry` = 18971;
UPDATE `creature_model_info` SET `combat_reach` = 1.5 WHERE `modelid` = 18454;
UPDATE `creature` SET `position_x` = -234.7398, `position_y` = 1060.616, `position_z` = 54.33185, `orientation` = 2.321373, `curmana` = 70310 WHERE `guid` = 58328;
REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(@GUID, 18971, 530, 1, 1, 301, 0, -234.7403, 1060.632, 54.33163, 1.602193, 300, 0, 0, 9466, 70310, 0, 2);
REPLACE INTO `creature_addon` VALUES (@GUID, @GUID, 0, 0, 1, 0);
REPLACE INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(@GUID, 1, -227.3438, 1039.114, 54.33458),
(@GUID, 2, -227.8372, 1039.984, 54.33458),
(@GUID, 3, -228.8853, 1041.831, 54.33599),
(@GUID, 4, -234.4584, 1051.655, 54.3308),
(@GUID, 5, -234.6355, 1057.295, 54.33119),
(@GUID, 6, -234.7914, 1062.259, 54.33184),
(@GUID, 7, -234.835, 1063.647, 54.3317),
(@GUID, 8, -234.9299, 1066.667, 54.33163),
(@GUID, 9, -235.0578, 1070.74, 54.30938),
(@GUID, 10, -235.0578, 1070.74, 54.30938);
__________________
Медовуха с медом настоящее рай для больных гриппом! Мир становится тебе побую когда ты в хламину пьян
Последний раз редактировалось Heisenberg; 05.02.2011 в 13:32.
|