diff options
author | Killyana <morphone1@gmail.com> | 2017-04-28 17:50:30 +0200 |
---|---|---|
committer | funjoker <funjoker109@gmail.com> | 2020-04-28 22:46:56 +0200 |
commit | 57b1d76ad50f39c61423518377e9ed5ecb267f89 (patch) | |
tree | 6a700f865a5245c4246faeaf87837a0e54323f0a | |
parent | a46286a803b41b375ed9352858c742626bb85720 (diff) |
DB/Creature: Add some missing spawns to Naxxanar area
(cherry picked from commit 5a3a9381e445a7d70464d1b97364778e07bbc6f2)
-rw-r--r-- | sql/updates/world/master/2020_04_27_08_world_2017_04_28_00_world.sql | 264 |
1 files changed, 264 insertions, 0 deletions
diff --git a/sql/updates/world/master/2020_04_27_08_world_2017_04_28_00_world.sql b/sql/updates/world/master/2020_04_27_08_world_2017_04_28_00_world.sql new file mode 100644 index 00000000000..b5e6c43e35a --- /dev/null +++ b/sql/updates/world/master/2020_04_27_08_world_2017_04_28_00_world.sql @@ -0,0 +1,264 @@ +SET @CGUID:= 146625; +DELETE FROM `creature` WHERE `id` = 25390; +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+249; +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +(@CGUID+0, 25377, 571, 0, 0, '0', 1, 0, 0, 3856.362, 3761.855, 51.49897, 1.787884, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+1, 25377, 571, 0, 0, '0', 1, 0, 0, 3848.972, 3760.094, 53.60237, 2.532431, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+2, 25377, 571, 0, 0, '0', 1, 0, 0, 3845.313, 3760.938, 55.2104, 2.888491, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+3, 25377, 571, 0, 0, '0', 1, 0, 0, 3854.785, 3778.629, 56.78143, 1.964004, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+4, 25377, 571, 0, 0, '0', 1, 0, 0, 3895.797, 3773.958, 51.84527, 5.737518, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+5, 15214, 571, 0, 0, '0', 1, 0, 0, 3889.836, 3771.971, 51.535, 1.236767, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 15214 (Area: -1) +(@CGUID+6, 25378, 571, 0, 0, '0', 1, 0, 0, 3945.438, 3731.835, 62.38454, 1.710423, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25378 (Area: -1) +(@CGUID+7, 25377, 571, 0, 0, '0', 1, 0, 0, 3873.349, 3778.878, 54.86187, 0.915302, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+8, 25377, 571, 0, 0, '0', 1, 0, 0, 3937.869, 3761.81, 66.29324, 2.285362, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+9, 25377, 571, 0, 0, '0', 1, 0, 0, 3905.761, 3785.872, 56.2091, 5.008369, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+10, 25377, 571, 0, 0, '0', 1, 0, 0, 3852.035, 3777.488, 56.57757, 2.511892, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+11, 25377, 571, 0, 0, '0', 1, 0, 0, 3895.971, 3777.111, 52.89691, 5.152364, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+12, 25377, 571, 0, 0, '0', 1, 0, 0, 3859.266, 3777.747, 55.64642, 3.875577, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+13, 25377, 571, 0, 0, '0', 1, 0, 0, 3873.917, 3773.739, 53.1734, 3.546263, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+14, 25377, 571, 0, 0, '0', 1, 0, 0, 3858.755, 3773.773, 54.30145, 2.155118, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+15, 25377, 571, 0, 0, '0', 1, 0, 0, 3934.469, 3758.464, 65.99844, 0.7296588, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+16, 25377, 571, 0, 0, '0', 1, 0, 0, 3871.434, 3774.329, 52.98407, 1.029868, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+17, 25377, 571, 0, 0, '0', 1, 0, 0, 3895.806, 3782.894, 54.03167, 2.843827, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+18, 25377, 571, 0, 0, '0', 1, 0, 0, 3857.359, 3780.822, 57.45977, 6.231272, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+19, 25378, 571, 0, 0, '0', 1, 0, 0, 3887.787, 3748.568, 46.64261, 1.832596, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25378 (Area: -1) +(@CGUID+20, 25377, 571, 0, 0, '0', 1, 0, 0, 3881.459, 3771.939, 52.34649, 2.209149, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+21, 25377, 571, 0, 0, '0', 1, 0, 0, 3901.681, 3773.557, 53.1372, 2.395434, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+22, 25377, 571, 0, 0, '0', 1, 0, 0, 3876.524, 3776.051, 54.03057, 1.422759, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+23, 25377, 571, 0, 0, '0', 1, 0, 0, 3853.302, 3774.513, 55.80389, 2.107602, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+24, 25377, 571, 0, 0, '0', 1, 0, 0, 3942.292, 3757.19, 65.39615, 0.939211, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+25, 25377, 571, 0, 0, '0', 1, 0, 0, 3877.188, 3770.377, 51.82452, 0.562353, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+26, 25377, 571, 0, 0, '0', 1, 0, 0, 3946.085, 3758.676, 65.89896, 3.295287, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+27, 25377, 571, 0, 0, '0', 1, 0, 0, 3901.85, 3781.824, 55.3778, 0.7305052, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+28, 25377, 571, 0, 0, '0', 1, 0, 0, 3950.509, 3760.267, 66.09, 2.847162, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+29, 15214, 571, 0, 0, '0', 1, 0, 0, 3942.177, 3756.028, 65.025, 4.628274, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 15214 (Area: -1) (Auras: ) +-- (@CGUID+30, 25492, 571, 0, 0, '0', 0, 0, 0, 4023.196, 3604.876, 106.491, 1.675516, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25492 (Area: -1) +(@CGUID+31, 25377, 571, 0, 0, '0', 1, 0, 0, 3940.087, 3778.05, 67.43326, 5.391348, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+32, 25377, 571, 0, 0, '0', 1, 0, 0, 3947.441, 3774.648, 67.16287, 5.483166, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+33, 25377, 571, 0, 0, '0', 1, 0, 0, 3950.542, 3756.351, 65.14139, 1.024377, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+34, 25377, 571, 0, 0, '0', 1, 0, 0, 3951.158, 3783.321, 66.46609, 1.680158, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+35, 25377, 571, 0, 0, '0', 1, 0, 0, 3946.375, 3798.536, 69.6951, 1.496066, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+36, 25377, 571, 0, 0, '0', 1, 0, 0, 3950.66, 3779.663, 66.48564, 0.2942728, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+37, 25377, 571, 0, 0, '0', 1, 0, 0, 3953.416, 3814.574, 71.72324, 1.447305, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+38, 25378, 571, 0, 0, '0', 1, 0, 0, 3983.542, 3769.677, 62.64833, 4.859846, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25378 (Area: -1) +(@CGUID+39, 25377, 571, 0, 0, '0', 1, 0, 0, 3942.997, 3797.084, 69.11807, 4.048098, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+40, 25377, 571, 0, 0, '0', 1, 0, 0, 3939.094, 3821.365, 70.90989, 4.823489, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+41, 25377, 571, 0, 0, '0', 1, 0, 0, 3943.163, 3783.04, 67.5856, 0.6302186, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+42, 25377, 571, 0, 0, '0', 1, 0, 0, 3947.942, 3807.152, 70.84385, 6.25543, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+43, 25377, 571, 0, 0, '0', 1, 0, 0, 3947.802, 3804.568, 70.63902, 4.229197, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+44, 25377, 571, 0, 0, '0', 1, 0, 0, 3955.821, 3811.656, 71.62571, 2.640486, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+45, 25377, 571, 0, 0, '0', 1, 0, 0, 3942.419, 3806.433, 70.30625, 6.006355, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+46, 25377, 571, 0, 0, '0', 1, 0, 0, 3955.7, 3781.918, 64.83658, 6.117535, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+47, 25377, 571, 0, 0, '0', 1, 0, 0, 3939.559, 3803.456, 69.71299, 3.782476, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+48, 25377, 571, 0, 0, '0', 1, 0, 0, 3938.022, 3836.511, 73.84203, 5.077127, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+49, 25377, 571, 0, 0, '0', 1, 0, 0, 3956.413, 3817.224, 72.36948, 3.131958, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+50, 25377, 571, 0, 0, '0', 1, 0, 0, 4010.828, 3739.584, 66.05321, 0.8970829, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+51, 25377, 571, 0, 0, '0', 1, 0, 0, 4008.854, 3730.729, 65.51659, 5.020262, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+52, 25377, 571, 0, 0, '0', 1, 0, 0, 4013.835, 3739.858, 66.744, 3.290065, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+53, 25377, 571, 0, 0, '0', 1, 0, 0, 4013.431, 3732.159, 67.31004, 4.268528, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+54, 25377, 571, 0, 0, '0', 1, 0, 0, 4003.856, 3737.709, 64.45518, 2.910134, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +-- (@CGUID+55, 25391, 571, 0, 0, '0', 0, 0, 0, 4024.555, 3742.407, 88.99696, 3.543018, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25391 (Area: -1) (Auras: ) +(@CGUID+56, 25377, 571, 0, 0, '0', 0, 0, 0, 3985.718, 3813.569, 68.40765, 2.829013, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+57, 25377, 571, 0, 0, '0', 0, 0, 0, 4014.136, 3736.033, 67.28185, 4.049169, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+58, 25377, 571, 0, 0, '0', 0, 0, 0, 4006.304, 3819.676, 72.36139, 0.5565031, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+59, 25377, 571, 0, 0, '0', 0, 0, 0, 3983.958, 3819.676, 71.01385, 1.145607, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+60, 25377, 571, 0, 0, '0', 0, 0, 0, 4019.725, 3801.281, 66.31256, 2.917216, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+61, 25378, 571, 0, 0, '0', 0, 0, 0, 4003.135, 3791.937, 62.67893, 1.675516, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25378 (Area: -1) +-- (@CGUID+62, 25391, 571, 0, 0, '0', 0, 0, 0, 4014.546, 3773.259, 88.09467, 3.176499, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25391 (Area: -1) (Auras: ) +(@CGUID+63, 25377, 571, 0, 0, '0', 0, 0, 0, 3979.844, 3820.275, 71.65765, 4.897894, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+64, 25377, 571, 0, 0, '0', 0, 0, 0, 3977.068, 3832.302, 76.76068, 5.369745, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+65, 25377, 571, 0, 0, '0', 0, 0, 0, 3975.965, 3811.767, 69.58331, 4.890862, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+66, 25377, 571, 0, 0, '0', 0, 0, 0, 3961.483, 3809.533, 71.12608, 1.679816, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+67, 25378, 571, 0, 0, '0', 0, 0, 0, 4031.613, 3765.301, 88.1413, 2.775074, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25378 (Area: -1) +(@CGUID+68, 25377, 571, 0, 0, '0', 0, 0, 0, 3930.518, 3831.502, 70.80496, 4.922265, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+69, 25377, 571, 0, 0, '0', 0, 0, 0, 3943.751, 3825.671, 72.6898, 1.378705, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+70, 25377, 571, 0, 0, '0', 0, 0, 0, 3999.025, 3816.855, 70.74554, 0.3368048, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+71, 25377, 571, 0, 0, '0', 0, 0, 0, 3943.419, 3831.631, 74.16563, 3.242679, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+72, 25377, 571, 0, 0, '0', 0, 0, 0, 3980.091, 3835.34, 77.89709, 4.097147, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+73, 25377, 571, 0, 0, '0', 0, 0, 0, 3985.691, 3810.795, 67.0307, 5.729337, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+74, 25377, 571, 0, 0, '0', 0, 0, 0, 3961.77, 3812.996, 71.89756, 0.1600965, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+75, 25377, 571, 0, 0, '0', 0, 0, 0, 3953.116, 3839.654, 77.24921, 1.785299, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+76, 25377, 571, 0, 0, '0', 0, 0, 0, 3994.533, 3822.952, 73.17596, 0.7260628, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+77, 25377, 571, 0, 0, '0', 0, 0, 0, 3978.996, 3816.431, 70.33807, 0.5169653, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+78, 25377, 571, 0, 0, '0', 0, 0, 0, 3956.791, 3817.895, 72.57554, 2.857513, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+79, 25377, 571, 0, 0, '0', 0, 0, 0, 4007.341, 3814.753, 69.79547, 5.739625, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+80, 25377, 571, 0, 0, '0', 0, 0, 0, 4007.547, 3819.425, 72.16815, 1.637677, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+81, 25377, 571, 0, 0, '0', 0, 0, 0, 3949.229, 3843.808, 77.34271, 4.109823, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+82, 25377, 571, 0, 0, '0', 0, 0, 0, 4003.176, 3822.928, 73.94293, 4.416482, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+83, 25377, 571, 0, 0, '0', 0, 0, 0, 3973.253, 3840.189, 79.14282, 0.1356232, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +-- (@CGUID+84, 25471, 571, 0, 0, '0', 0, 0, 0, 4111.138, 3734.866, 91.84813, 3.996804, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25471 (Area: -1) -- +(@CGUID+85, 25377, 571, 0, 0, '0', 0, 0, 0, 3958.608, 3842.374, 77.76642, 3.547766, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+86, 25378, 571, 0, 0, '0', 0, 0, 0, 4042.49, 3745.191, 88.50867, 3.246312, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25378 (Area: -1) +(@CGUID+87, 25377, 571, 0, 0, '0', 0, 0, 0, 3933.178, 3842.617, 73.65913, 0.7102271, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+88, 25377, 571, 0, 0, '0', 0, 0, 0, 3985.925, 3836.56, 78.08765, 0.3928989, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+89, 25377, 571, 0, 0, '0', 0, 0, 0, 4018.704, 3807.378, 68.41994, 3.146591, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+90, 25377, 571, 0, 0, '0', 0, 0, 0, 4024.622, 3802.451, 68.20343, 2.903348, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +-- (@CGUID+91, 25391, 571, 0, 0, '0', 0, 0, 0, 4053.731, 3790.188, 88.898, 5.358161, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25391 (Area: -1) (Auras: ) +(@CGUID+92, 25377, 571, 0, 0, '0', 0, 0, 0, 4023.776, 3809.938, 69.86577, 3.449748, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+93, 25377, 571, 0, 0, '0', 0, 0, 0, 4041.068, 3812.419, 73.50181, 2.869276, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+94, 25377, 571, 0, 0, '0', 0, 0, 0, 3977.11, 3842.004, 79.86098, 0.7784538, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+95, 25377, 571, 0, 0, '0', 0, 0, 0, 4040.451, 3802.602, 70.72752, 2.495649, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+96, 25377, 571, 0, 0, '0', 0, 0, 0, 4017.696, 3822.242, 73.9433, 5.397349, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+97, 25377, 571, 0, 0, '0', 0, 0, 0, 4044.622, 3802.832, 70.57517, 0.5576683, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+98, 25377, 571, 0, 0, '0', 0, 0, 0, 4011.047, 3839.548, 76.7318, 6.244549, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+99, 25377, 571, 0, 0, '0', 0, 0, 0, 4026.381, 3805.319, 69.17072, 5.322569, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+100, 25377, 571, 0, 0, '0', 0, 0, 0, 4043.563, 3797.688, 70.98014, 5.236726, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+101, 25377, 571, 0, 0, '0', 0, 0, 0, 3993.121, 3844.239, 79.35071, 5.135974, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+102, 25377, 571, 0, 0, '0', 0, 0, 0, 4019.319, 3811.758, 70.11395, 5.55163, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+103, 25377, 571, 0, 0, '0', 0, 0, 0, 4028.581, 3822.207, 74.36981, 5.899706, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+104, 25377, 571, 0, 0, '0', 0, 0, 0, 3947.608, 3847.873, 77.20355, 2.409402, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+105, 25377, 571, 0, 0, '0', 0, 0, 0, 4026.606, 3825.278, 75.37921, 6.166935, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+106, 25377, 571, 0, 0, '0', 0, 0, 0, 4021.991, 3829.991, 76.58698, 4.33053, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+107, 25377, 571, 0, 0, '0', 0, 0, 0, 4040.658, 3797.008, 71.00822, 3.501203, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+108, 25377, 571, 0, 0, '0', 0, 0, 0, 4004.436, 3840.204, 77.43212, 1.105561, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+109, 25377, 571, 0, 0, '0', 0, 0, 0, 3956.497, 3851.48, 78.62555, 3.324586, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+110, 25377, 571, 0, 0, '0', 0, 0, 0, 4038.561, 3815.458, 74.1273, 1.256246, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+111, 25377, 571, 0, 0, '0', 0, 0, 0, 3980.532, 3839.45, 79.25122, 5.701941, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+112, 25377, 571, 0, 0, '0', 0, 0, 0, 4037.742, 3797.284, 70.75016, 3.675025, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+113, 25377, 571, 0, 0, '0', 0, 0, 0, 4024.293, 3820.985, 73.6358, 0.74111, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+114, 25377, 571, 0, 0, '0', 0, 0, 0, 3969.766, 3851.225, 80.8999, 1.407759, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+115, 25377, 571, 0, 0, '0', 0, 0, 0, 4044.113, 3798.313, 71.03507, 1.526782, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+116, 25377, 571, 0, 0, '0', 0, 0, 0, 3988.41, 3863.551, 85.09741, 1.77021, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+117, 25377, 571, 0, 0, '0', 0, 0, 0, 3980.214, 3854.178, 82.61475, 1.526452, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+118, 25377, 571, 0, 0, '0', 0, 0, 0, 4061.403, 3806.529, 73.14072, 1.009966, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+119, 25377, 571, 0, 0, '0', 0, 0, 0, 3952.42, 3855.544, 78.36176, 5.831243, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+120, 25377, 571, 0, 0, '0', 0, 0, 0, 3978.812, 3856.061, 83.19165, 1.515909, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+121, 25377, 571, 0, 0, '0', 0, 0, 0, 4041.886, 3825.319, 76.65525, 2.360835, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+122, 25378, 571, 0, 0, '0', 0, 0, 0, 4059.954, 3772.845, 88.27218, 2.076942, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25378 (Area: -1) +(@CGUID+123, 25377, 571, 0, 0, '0', 0, 0, 0, 4054.301, 3809.695, 73.50803, 1.462021, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+124, 25377, 571, 0, 0, '0', 0, 0, 0, 4001.414, 3852.939, 83.30297, 0.7778957, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+125, 25377, 571, 0, 0, '0', 0, 0, 0, 4027.71, 3835.373, 77.92162, 2.965322, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+126, 25377, 571, 0, 0, '0', 0, 0, 0, 3971.56, 3854.037, 81.95898, 3.315667, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+127, 25377, 571, 0, 0, '0', 0, 0, 0, 4043.886, 3813.275, 73.8187, 5.252536, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+128, 25377, 571, 0, 0, '0', 0, 0, 0, 3992.059, 3860.479, 85.22095, 0.3067477, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+129, 25387, 571, 0, 0, '0', 0, 0, 0, 4108.792, 3628.817, 117.1614, 1.936917, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25387 (Area: -1) +(@CGUID+130, 25377, 571, 0, 0, '0', 0, 0, 0, 4040.829, 3821.539, 75.87366, 3.807508, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+131, 25377, 571, 0, 0, '0', 0, 0, 0, 3978.755, 3862.269, 84.41016, 6.079549, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+132, 25377, 571, 0, 0, '0', 0, 0, 0, 4011.224, 3842.406, 77.72607, 1.74512, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+133, 25377, 571, 0, 0, '0', 0, 0, 0, 3972.081, 3859.687, 83.02417, 6.191478, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+134, 25377, 571, 0, 0, '0', 0, 0, 0, 4055.908, 3812.092, 74.2761, 5.387706, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+135, 15214, 571, 0, 0, '0', 0, 0, 0, 4015.447, 3812.16, 69.756, 4.06342, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 15214 (Area: -1) +(@CGUID+136, 25377, 571, 0, 0, '0', 0, 0, 0, 4041.674, 3819.853, 75.61887, 1.068842, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+137, 25377, 571, 0, 0, '0', 0, 0, 0, 3994.814, 3862.187, 86.10242, 2.840913, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+138, 25377, 571, 0, 0, '0', 0, 0, 0, 4007.844, 3844.194, 78.89172, 1.35082, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+139, 25377, 571, 0, 0, '0', 0, 0, 0, 4058.096, 3808.438, 73.66172, 0.9468706, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+140, 25377, 571, 0, 0, '0', 0, 0, 0, 3995.671, 3863.357, 86.48828, 1.222019, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+141, 25377, 571, 0, 0, '0', 0, 0, 0, 3994.089, 3869.741, 86.92256, 4.403831, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+142, 25377, 571, 0, 0, '0', 0, 0, 0, 4060.221, 3813.648, 74.87791, 2.561906, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+143, 25377, 571, 0, 0, '0', 0, 0, 0, 4060.921, 3810.31, 74.20188, 0.7864025, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +(@CGUID+144, 25378, 571, 0, 0, '0', 0, 0, 0, 4084.625, 3781.453, 88.1413, 1.308997, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25378 (Area: -1) +(@CGUID+145, 25391, 571, 0, 0, '0', 0, 0, 0, 4087.144, 3803.259, 88.88715, 6.178465, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25391 (Area: -1) (Auras: ) +(@CGUID+146, 25377, 571, 0, 0, '0', 0, 0, 0, 3995.967, 3869.417, 87.43391, 1.641255, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: -1) +-- (@CGUID+148, 25378, 571, 0, 0, '0', 0, 0, 0, 4104.68, 3755.165, 92.74696, 5.305801, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25378 (Area: -1) +-- (@CGUID+149, 25391, 571, 0, 0, '0', 0, 0, 0, 4052.662, 3672.709, 89.06155, 4.991642, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25391 (Area: -1) (Auras: ) +-- (@CGUID+150, 25383, 571, 0, 0, '0', 0, 0, 0, 3880.311, 3627.948, 46.88836, 2.70526, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25383 (Area: -1) (Auras: 45617 - 45617) +(@CGUID+151, 15214, 571, 0, 0, '0', 0, 0, 0, 4111.582, 3735.073, 91.764, 3.473205, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 15214 (Area: -1) +-- (@CGUID+152, 25391, 571, 0, 0, '0', 0, 0, 0, 4045.809, 3648.79, 88.94188, 3.298672, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25391 (Area: -1) (Auras: ) +-- (@CGUID+154, 26076, 571, 0, 0, '0', 0, 0, 0, 4111.339, 3735.037, 91.84813, 3.577925, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 26076 (Area: -1) +(@CGUID+155, 25378, 571, 0, 0, '0', 0, 0, 0, 4073.151, 3662.264, 88.30914, 2.70526, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25378 (Area: -1) +(@CGUID+156, 25393, 571, 0, 0, '0', 0, 0, 0, 4111.396, 3669.310, 88.182, 1.427202, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25393 (Area: -1) +(@CGUID+157, 25378, 571, 0, 0, '0', 0, 0, 0, 4061.825, 3641.445, 88.11076, 2.635447, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25378 (Area: -1) +(@CGUID+158, 25393, 571, 0, 0, '0', 0, 0, 0, 4022.36, 3621.078, 100.6157, 4.967927, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25393 (Area: -1) +-- (@CGUID+159, 25378, 571, 0, 0, '0', 0, 0, 0, 4120.856, 3713.722, 92.74776, 1.762783, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25378 (Area: -1) +(@CGUID+160, 25393, 571, 0, 0, '0', 0, 0, 0, 4145.623, 3676.927, 88.1825, 0.2252303, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25393 (Area: 4136) +-- (@CGUID+161, 25378, 571, 0, 0, '0', 0, 0, 0, 4127.498, 3741.052, 92.75615, 3.787364, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25378 (Area: 4136) +(@CGUID+162, 25472, 571, 0, 0, '0', 0, 0, 0, 4094.381, 3493.948, 152.6763, 0.7679449, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25472 (Area: 4136) +(@CGUID+163, 25393, 571, 0, 0, '0', 0, 0, 0, 4126.54, 3615.563, 88.83325, 4.462672, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25393 (Area: 4136) +(@CGUID+164, 25393, 571, 0, 0, '0', 0, 0, 0, 4112.138, 3573.525, 106.1573, 2.034444, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25393 (Area: 4125) (Auras: 33963 - 33963) +(@CGUID+165, 25393, 571, 0, 0, '0', 0, 0, 0, 3825.306, 3621.834, 46.977, 3.186528, 300, 7, 0, 1, 0, 1, 0, 0, 0, 23420), +(@CGUID+166, 25393, 571, 0, 0, '0', 0, 0, 0, 4007.476, 3587.082, 100.544, 3.186528, 300, 7, 0, 1, 0, 1, 0, 0, 0, 23420), +(@CGUID+167, 25393, 571, 0, 0, '0', 0, 0, 0, 4049.438, 3575.568, 106.517, 3.186528, 300, 7, 0, 1, 0, 1, 0, 0, 0, 23420), +(@CGUID+168, 25378, 571, 0, 0, '0', 0, 0, 0, 4067.834, 3528.134, 118.3771, 1.19083, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25378 (Area: -1) +(@CGUID+169, 25378, 571, 0, 0, '0', 0, 0, 0, 4101.848, 3536.834, 109.293, 2.548181, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25378 (Area: -1) +(@CGUID+170, 25378, 571, 0, 0, '0', 0, 0, 0, 4062.422, 3465.097, 109.2684, 2.635447, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25378 (Area: -1) +(@CGUID+171, 25378, 571, 0, 0, '0', 0, 0, 0, 4116.766, 3464.181, 108.9272, 1.073311, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25378 (Area: 4135) +(@CGUID+172, 25378, 571, 0, 0, '0', 0, 0, 0, 4099.074, 3478.396, 109.105, 5.759586, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25378 (Area: 4135) +(@CGUID+173, 25378, 571, 0, 0, '0', 0, 0, 0, 4094.816, 3451.6, 128.4207, 2.684189, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25378 (Area: 4135) (possible waypoints or random movement) +(@CGUID+174, 25378, 571, 0, 0, '0', 0, 0, 0, 4111.819, 3499.67, 109.1208, 5.864306, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25378 (Area: 4135) +(@CGUID+175, 25378, 571, 0, 0, '0', 0, 0, 0, 3900.854, 3515.069, 46.74826, 4.921828, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25378 (Area: 4125) +(@CGUID+176, 25393, 571, 0, 0, '0', 0, 0, 0, 4079.765, 3412.597, 107.1055, 5.053613, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25393 (Area: -1) (Auras: 33963 - 33963) +(@CGUID+177, 25393, 571, 0, 0, '0', 0, 0, 0, 3946.659, 3484.503, 99.422, 0.6282206, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25393 (Area: -1) (Auras: 33963 - 33963) +(@CGUID+178, 25393, 571, 0, 0, '0', 0, 0, 0, 3975.619, 3492.427, 99.16926, 2.584305, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25393 (Area: -1) (Auras: 33963 - 33963) +(@CGUID+179, 25393, 571, 0, 0, '0', 0, 0, 0, 3972.511, 3518.948, 99.9718, 2.297545, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25393 (Area: 4125) (Auras: 33963 - 33963) +(@CGUID+180, 25386, 571, 0, 0, '0', 0, 0, 0, 3860.269, 3521.542, 46.6651, 1.074683, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25393 (Area: 4125) +(@CGUID+181, 25377, 571, 0, 0, '0', 0, 0, 0, 3911.907, 3478.756, 58.82272, 4.34155, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: 4125) +(@CGUID+182, 25377, 571, 0, 0, '0', 0, 0, 0, 3906.862, 3476.329, 57.79526, 3.9647, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: 4125) +(@CGUID+183, 25377, 571, 0, 0, '0', 0, 0, 0, 3895.673, 3488.134, 52.07495, 0.5125694, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: 4125) +(@CGUID+184, 25377, 571, 0, 0, '0', 0, 0, 0, 3934.134, 3506.953, 51.67665, 6.170922, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: 4125) +(@CGUID+185, 25377, 571, 0, 0, '0', 0, 0, 0, 3926.452, 3498.807, 52.40866, 3.861535, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: 4125) +(@CGUID+186, 25377, 571, 0, 0, '0', 0, 0, 0, 3910.824, 3485.944, 56.78598, 3.885894, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: 4125) +(@CGUID+187, 25377, 571, 0, 0, '0', 0, 0, 0, 3903.06, 3480.468, 56.38156, 2.333228, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: 4125) +(@CGUID+188, 25377, 571, 0, 0, '0', 0, 0, 0, 3928.13, 3507.663, 50.407, 3.513032, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: 4125) +(@CGUID+189, 25377, 571, 0, 0, '0', 0, 0, 0, 3920.079, 3496.129, 52.42612, 4.809077, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: 4125) +(@CGUID+190, 25377, 571, 0, 0, '0', 0, 0, 0, 3889.21, 3490.374, 51.28994, 1.190738, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: 4125) +(@CGUID+191, 25377, 571, 0, 0, '0', 0, 0, 0, 3919.065, 3487.513, 55.48593, 0.6557075, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: 4125) +(@CGUID+192, 25377, 571, 0, 0, '0', 0, 0, 0, 3922.625, 3502.891, 50.90102, 4.851348, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: 4125) +(@CGUID+193, 25377, 571, 0, 0, '0', 0, 0, 0, 3906.744, 3481.154, 57.70981, 1.442585, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: 4125) +(@CGUID+194, 25377, 571, 0, 0, '0', 0, 0, 0, 3928.391, 3503.573, 51.66494, 4.89102, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: 4125) +(@CGUID+195, 25377, 571, 0, 0, '0', 0, 0, 0, 3882.106, 3496.834, 49.87026, 1.449227, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: 4125) +(@CGUID+196, 25377, 571, 0, 0, '0', 0, 0, 0, 3888.425, 3495.322, 50.66372, 1.623445, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: 4125) +(@CGUID+197, 25377, 571, 0, 0, '0', 0, 0, 0, 3889.816, 3492.876, 51.08229, 2.999852, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: 4125) +(@CGUID+198, 25377, 571, 0, 0, '0', 0, 0, 0, 3886.697, 3494.933, 50.59719, 1.346169, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25377 (Area: 4125) +(@CGUID+199, 15214, 571, 0, 0, '0', 0, 0, 0, 3907.229, 3491.578, 51.694, 3.174816, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 15214 (Area: 4125) (Auras: ) +(@CGUID+200, 25383, 571, 0, 0, '0', 0, 0, 0, 3969.229, 3475.197, 99.36195, 6.161329, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25383 (Area: -1) (Auras: 45617 - 45617) +(@CGUID+201, 25390, 571, 0, 0, '0', 0, 0, 0, 3736.273, 3590.903, 47.99994, 0.8899633, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: -1) (Auras: ) +(@CGUID+202, 25390, 571, 0, 0, '0', 0, 0, 0, 3741.549, 3619.058, 51.74624, 5.868149, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: -1) (Auras: ) +(@CGUID+203, 25390, 571, 0, 0, '0', 0, 0, 0, 3733.602, 3597.179, 49.17873, 5.992009, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: -1) (Auras: ) +(@CGUID+204, 25390, 571, 0, 0, '0', 0, 0, 0, 3755.551, 3614.849, 47.53596, 1.73466, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: -1) (Auras: ) +(@CGUID+205, 25390, 571, 0, 0, '0', 0, 0, 0, 3737.5, 3595.834, 47.55792, 3.263225, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: -1) (Auras: ) +(@CGUID+206, 25390, 571, 0, 0, '0', 0, 0, 0, 3745.494, 3614.806, 51.02425, 3.739824, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: -1) (Auras: ) +(@CGUID+207, 25390, 571, 0, 0, '0', 0, 0, 0, 3731.61, 3608.116, 50.42838, 4.519621, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: -1) (Auras: ) +(@CGUID+208, 25390, 571, 0, 0, '0', 0, 0, 0, 3746.177, 3610.937, 49.4919, 0.9030718, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: -1) (Auras: ) +(@CGUID+209, 25390, 571, 0, 0, '0', 0, 0, 0, 3740.296, 3606.416, 47.89117, 0.3061525, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: -1) (Auras: ) +(@CGUID+210, 25390, 571, 0, 0, '0', 0, 0, 0, 3739.774, 3586.381, 47.40804, 3.840582, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: -1) (Auras: ) +(@CGUID+211, 25390, 571, 0, 0, '0', 0, 0, 0, 3732.172, 3492.803, 66.06441, 4.919724, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: -1) (Auras: ) +(@CGUID+212, 25390, 571, 0, 0, '0', 0, 0, 0, 3722.42, 3474.34, 67.72371, 3.546465, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: -1) (Auras: ) +(@CGUID+213, 25390, 571, 0, 0, '0', 0, 0, 0, 3737.281, 3457.207, 68.44443, 6.275373, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: -1) (Auras: ) +(@CGUID+214, 25390, 571, 0, 0, '0', 0, 0, 0, 3735.691, 3481.298, 66.37328, 0.4247686, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: -1) (Auras: ) +(@CGUID+215, 25390, 571, 0, 0, '0', 0, 0, 0, 3762.339, 3460.782, 66.84665, 1.272987, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: -1) (Auras: ) +(@CGUID+216, 25390, 571, 0, 0, '0', 0, 0, 0, 3727.58, 3472.093, 67.7375, 6.149167, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: -1) (Auras: ) +(@CGUID+217, 25390, 571, 0, 0, '0', 0, 0, 0, 3729.184, 3463.325, 67.98989, 4.915916, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: -1) (Auras: ) +(@CGUID+218, 25390, 571, 0, 0, '0', 0, 0, 0, 3755.908, 3451.033, 68.73743, 1.29019, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: -1) (Auras: ) +(@CGUID+219, 25390, 571, 0, 0, '0', 0, 0, 0, 3752.901, 3443.411, 69.78725, 2.859401, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: -1) (Auras: ) +(@CGUID+220, 25390, 571, 0, 0, '0', 0, 0, 0, 3750.83, 3453.531, 68.79379, 3.341931, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: -1) (Auras: ) +(@CGUID+221, 25390, 571, 0, 0, '0', 0, 0, 0, 3929.295, 3386.144, 81.46214, 2.466242, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: 4137) (Auras: ) +(@CGUID+222, 25390, 571, 0, 0, '0', 0, 0, 0, 3932.021, 3374.059, 87.41148, 4.779801, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: 4137) (Auras: ) +(@CGUID+223, 25390, 571, 0, 0, '0', 0, 0, 0, 3944.585, 3379.264, 85.34169, 2.193203, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: 4137) (Auras: ) +(@CGUID+224, 25390, 571, 0, 0, '0', 0, 0, 0, 3945.311, 3386.357, 83.06496, 4.791557, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: 4137) (Auras: ) +(@CGUID+225, 25390, 571, 0, 0, '0', 0, 0, 0, 3936.851, 3379.988, 84.34169, 1.985053, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: 4137) (Auras: ) +(@CGUID+226, 25390, 571, 0, 0, '0', 0, 0, 0, 3956.039, 3386.022, 85.27751, 2.646924, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: 4125) (Auras: ) +(@CGUID+227, 25390, 571, 0, 0, '0', 0, 0, 0, 3959.361, 3380.454, 88.27145, 3.735828, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: 4125) (Auras: ) +(@CGUID+228, 25390, 571, 0, 0, '0', 0, 0, 0, 3995.549, 3396.604, 84.01167, 0.8137251, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: 4125) (Auras: ) +(@CGUID+229, 25390, 571, 0, 0, '0', 0, 0, 0, 3990.87, 3410.72, 81.53675, 1.899959, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: 4125) (Auras: ) +(@CGUID+230, 25390, 571, 0, 0, '0', 0, 0, 0, 4013.035, 3418.461, 87.39, 2.682534, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: 4125) (Auras: ) +(@CGUID+231, 25390, 571, 0, 0, '0', 0, 0, 0, 4001.696, 3381.575, 94.27975, 0.1066663, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: 4125) (Auras: ) +(@CGUID+232, 25390, 571, 0, 0, '0', 0, 0, 0, 4024.305, 3401.739, 88.4791, 4.252826, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: 4125) (Auras: ) +(@CGUID+233, 25390, 571, 0, 0, '0', 0, 0, 0, 3975.886, 3386.318, 85.93647, 4.24115, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: 4125) (Auras: ) +(@CGUID+234, 25390, 571, 0, 0, '0', 0, 0, 0, 4007.21, 3378.432, 96.99988, 5.743998, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: 4125) (Auras: ) +(@CGUID+235, 25390, 571, 0, 0, '0', 0, 0, 0, 4026.654, 3411.017, 91.08331, 5.944759, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: 4125) (Auras: ) +(@CGUID+236, 25390, 571, 0, 0, '0', 0, 0, 0, 4012.055, 3402.248, 88.56646, 5.85402, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: 4125) (Auras: ) +(@CGUID+237, 25390, 571, 0, 0, '0', 0, 0, 0, 4005.33, 3387.403, 91.97034, 5.87855, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: 4125) (Auras: ) +(@CGUID+238, 25390, 571, 0, 0, '0', 0, 0, 0, 4005.748, 3425.867, 87.4854, 1.783322, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: 4125) (Auras: ) +(@CGUID+239, 25390, 571, 0, 0, '0', 0, 0, 0, 4007.662, 3406.613, 88.17662, 4.847075, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: 4125) (Auras: ) +(@CGUID+240, 25390, 571, 0, 0, '0', 0, 0, 0, 4042.685, 3403.342, 93.21573, 1.982871, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: 4125) (Auras: ) +(@CGUID+241, 25396, 571, 0, 0, '0', 0, 0, 0, 4042.685, 3403.342, 93.21573, 1.982871, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: 4125) (Auras: ) +(@CGUID+242, 25396, 571, 0, 0, '0', 0, 0, 0, 3762.961, 3542.919, 294.694, 2.338741, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: 4125) (Auras: ) +(@CGUID+243, 25396, 571, 0, 0, '0', 0, 0, 0, 3753.642, 3536.274, 294.782, 1.797689, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: 4125) (Auras: ) +(@CGUID+244, 26103, 571, 0, 0, '0', 0, 0, 0, 3769.170, 3521.482, 347.866, 2.2045, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: 4125) (Auras: ) +(@CGUID+245, 26103, 571, 0, 0, '0', 0, 0, 0, 3722.833, 3486.375, 347.87, 1.36023, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: 4125) (Auras: ) +(@CGUID+246, 26103, 571, 0, 0, '0', 0, 0, 0, 3709.010, 3613.184, 347.866, 5.259722, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: 4125) (Auras: ) +(@CGUID+247, 26094, 571, 0, 0, '0', 0, 0, 0, 3743.336, 3547.376, 353.033, 5.259722, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: 4125) (Auras: ) +(@CGUID+248, 26094, 571, 0, 0, '0', 0, 0, 0, 3756.085, 3555.942, 352.890, 5.259722, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- 25390 (Area: 4125) (Auras: ) +(@CGUID+249, 26094, 571, 0, 0, '0', 0, 0, 0, 3728.194, 3550.65, 353.00, 5.259722, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420); -- 25390 (Area: 4125) (Auras: ) + +UPDATE `creature` SET `spawntimesecs` = 300 , `spawndist` = 3 , `MovementType` = 1 WHERE `id` IN (25377, 25390); +UPDATE `creature` SET `spawntimesecs` = 300 , `spawndist` = 0 , `MovementType` = 0 WHERE `id` IN (26093, 26094, 25378, 25383); +UPDATE `creature` SET `spawntimesecs` = 300 , `spawndist` = 7 , `MovementType` = 1 WHERE `id` = 25393; +UPDATE `creature` SET `spawntimesecs` = 300 WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+249; +UPDATE `creature` SET `spawndist` = 0 , `MovementType` = 0 WHERE `guid` IN (118319, 100032, 100034, 85215, 85121, 100059, 85206, 109630, 107628); +UPDATE `creature` SET `position_x`=3876.965,`position_y`=3675.559,`position_z`=46.845 WHERE `guid` =100571; +UPDATE `creature` SET `position_x`=3941.666,`position_y`=3574.805,`position_z`=69.950 WHERE `guid` =100505; +UPDATE `creature` SET `position_x`=3965.341,`position_y`=3603.879,`position_z`=72.720 WHERE `guid` =100503; +UPDATE `creature` SET `position_x`=3924.658,`position_y`=3624.454,`position_z`=70.797 WHERE `guid` =100559; +UPDATE `creature` SET `position_x`=3825.789,`position_y`=3742.629,`position_z`=51.733 WHERE `guid` =98971; +UPDATE `creature` SET `position_x`=3814.749,`position_y`=3731.839,`position_z`=53.006 WHERE `guid` =98953; |