diff options
| -rw-r--r-- | sql/updates/world/2015_07_18_01_world.sql | 712 |
1 files changed, 712 insertions, 0 deletions
diff --git a/sql/updates/world/2015_07_18_01_world.sql b/sql/updates/world/2015_07_18_01_world.sql new file mode 100644 index 00000000000..bcc2551c26b --- /dev/null +++ b/sql/updates/world/2015_07_18_01_world.sql @@ -0,0 +1,712 @@ +-- Stormshield - Spawning + +-- Creatures +SET @CGUID := 371271; +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+280; +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES +(@CGUID+0, 62822, 1116, 3, 1, 3640.764, -3910.202, 16.34509, 2.717915, 7200, 5, 1), -- 62822 (Area: -1) (Auras: 122729 - 122729, 123240 - 123240) (possible waypoints or random movement) +(@CGUID+1, 86087, 1116, 3, 1, 3759.286, -3897.51, 33.5745, 6.060457, 7200, 0, 0), -- 86087 (Area: -1) +(@CGUID+2, 62821, 1116, 3, 1, 3640.764, -3910.202, 16.34509, 2.717915, 7200, 5, 1), -- 62821 (Area: -1) (Auras: 122729 - 122729, 123236 - 123236) (possible waypoints or random movement) +(@CGUID+3, 86136, 1116, 3, 1, 3677.712, -3951.214, 25.60425, 6.081799, 7200, 5, 1), -- 86136 (Area: -1) (Auras: 172032 - 172032) (possible waypoints or random movement) +(@CGUID+4, 86408, 1116, 3, 1, 3725.274, -3926.283, 27.53472, 3.687493, 7200, 0, 0), -- 86408 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+5, 87271, 1116, 3, 1, 3753.677, -3892.66, 33.57437, 3.071364, 7200, 0, 0), -- 87271 (Area: -1) +(@CGUID+6, 86087, 1116, 3, 1, 3713.104, -3937.474, 26.16016, 3.681638, 7200, 0, 0), -- 86087 (Area: -1) +(@CGUID+7, 87277, 1116, 3, 1, 3613.66, -3921.109, 17.74149, 4.507677, 7200, 0, 0), -- 87277 (Area: -1) +(@CGUID+8, 86413, 1116, 3, 1, 3621.675, -3931.877, 17.7784, 0.3464943, 7200, 0, 0), -- 86413 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+9, 86087, 1116, 3, 1, 3749.767, -3905.337, 33.52706, 2.077034, 7200, 0, 0), -- 86087 (Area: -1) +(@CGUID+10, 86433, 1116, 3, 1, 3605.566, -3922.781, 16.64472, 1.969897, 7200, 5, 1), -- 86433 (Area: -1) (Auras: ) (possible waypoints or random movement) +(@CGUID+11, 86087, 1116, 3, 1, 3747.212, -3902.181, 33.51853, 5.17521, 7200, 0, 0), -- 86087 (Area: -1) (Auras: 174794 - 174794) +(@CGUID+12, 87375, 1116, 3, 1, 3762.248, -3898.373, 33.90293, 2.265642, 7200, 0, 0), -- 87375 (Area: -1) (Auras: 163720 - 163720) +(@CGUID+13, 86087, 1116, 3, 1, 3750.57, -3900.248, 33.53518, 5.183171, 7200, 0, 0), -- 86087 (Area: -1) +(@CGUID+14, 87052, 1116, 3, 1, 3735.275, -3928.462, 27.40334, 4.830181, 7200, 0, 0), -- 87052 (Area: -1) +(@CGUID+15, 86087, 1116, 3, 1, 3763.077, -3894.757, 33.57451, 4.488677, 7200, 0, 0), -- 86087 (Area: -1) +(@CGUID+16, 86408, 1116, 3, 1, 3760.809, -3894.547, 33.57453, 4.889977, 7200, 0, 0), -- 86408 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+17, 87663, 1116, 3, 1, 3752.29, -3891.132, 33.57434, 4.692651, 7200, 0, 0), -- 87663 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+18, 87255, 1116, 3, 1, 3612.96, -3923.978, 17.74612, 1.338929, 7200, 0, 0), -- 87255 (Area: -1) +(@CGUID+19, 86087, 1116, 3, 1, 3751.945, -3899.603, 33.51265, 5.183171, 7200, 0, 0), -- 86087 (Area: -1) +(@CGUID+20, 86408, 1116, 3, 1, 3678.156, -3955.59, 26.37931, 0.7691891, 7200, 0, 0), -- 86408 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+21, 85919, 1116, 3, 1, 3708.269, -3950.196, 25.79231, 0.4939562, 7200, 0, 0), -- 85919 (Area: -1) +(@CGUID+22, 86413, 1116, 3, 1, 3793.945, -3851.288, 46.72764, 3.538875, 7200, 0, 0), -- 86413 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+23, 85930, 1116, 3, 1, 3767.585, -3945.257, 27.87482, 4.583912, 7200, 0, 0), -- 85930 (Area: -1) +(@CGUID+24, 87365, 1116, 3, 1, 3754.879, -3959.201, 27.30159, 3.243365, 7200, 0, 0), -- 87365 (Area: -1) +(@CGUID+25, 86084, 1116, 3, 1, 3767.985, -3954.955, 27.8786, 4.971864, 7200, 0, 0), -- 86084 (Area: -1) +(@CGUID+26, 86424, 1116, 3, 1, 3769.875, -3945.484, 27.86447, 0.1581417, 7200, 0, 0), -- 86424 (Area: -1) (Auras: 174609 - 174609) +(@CGUID+27, 85917, 1116, 3, 1, 3695.633, -3963.701, 25.94791, 1.075222, 7200, 0, 0), -- 85917 (Area: -1) +(@CGUID+28, 87243, 1116, 3, 1, 3741.93, -3972.024, 27.01073, 2.303835, 7200, 0, 0), -- 87243 (Area: -1) +(@CGUID+29, 86129, 1116, 3, 1, 3746.557, -3936.766, 26.95713, 5.220356, 7200, 0, 0), -- 86129 (Area: -1) (Auras: 164381 - 164381) +(@CGUID+30, 86408, 1116, 3, 1, 3812.773, -3837.104, 48.67755, 0.08908753, 7200, 0, 0), -- 86408 (Area: -1) (Auras: 172660 - 172660) +(@CGUID+31, 87065, 1116, 3, 1, 3725.696, -3954.052, 26.40996, 3.135039, 7200, 0, 0), -- 87065 (Area: -1) +(@CGUID+32, 86413, 1116, 3, 1, 3801.648, -3848.064, 44.74829, 2.011903, 7200, 0, 0), -- 86413 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+33, 85951, 1116, 3, 1, 3745.49, -3973.318, 27.0019, 1.763934, 7200, 0, 0), -- 85951 (Area: -1) +(@CGUID+34, 86413, 1116, 3, 1, 3805.824, -3838.089, 48.67755, 2.116024, 7200, 0, 0), -- 86413 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+35, 85918, 1116, 3, 1, 3722.739, -3956.052, 26.54352, 1.745553, 7200, 0, 0), -- 85918 (Area: -1) +(@CGUID+36, 85927, 1116, 3, 1, 3756.189, -3962.017, 27.23796, 2.777095, 7200, 0, 0), -- 85927 (Area: -1) (Auras: 172121 - 172121) +(@CGUID+37, 86141, 1116, 3, 1, 3726.853, -3949.606, 26.54352, 0.3756096, 7200, 0, 0), -- 86141 (Area: -1) (Auras: 171989 - 171989) +(@CGUID+38, 85916, 1116, 3, 1, 3752.987, -3923.826, 27.12201, 3.742417, 7200, 0, 0), -- 85916 (Area: -1) +(@CGUID+39, 86418, 1116, 3, 1, 3772.061, -3945.286, 28.92929, 4.6777, 7200, 0, 0), -- 86418 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+40, 87049, 1116, 3, 1, 3742.079, -3977.528, 27.0418, 0, 7200, 0, 0), -- 87049 (Area: -1) +(@CGUID+41, 87067, 1116, 3, 1, 3733.427, -3977.705, 27.01073, 1.582815, 7200, 0, 0), -- 87067 (Area: -1) (Auras: ) +(@CGUID+42, 85910, 1116, 3, 1, 3738.294, -3979.089, 27.06721, 1.753493, 7200, 0, 0), -- 85910 (Area: -1) +(@CGUID+43, 88076, 1116, 3, 1, 3825.701, -3915.094, 5.018142, 0, 7200, 0, 0), -- 88076 (Area: -1) +(@CGUID+44, 86408, 1116, 3, 1, 3754.383, -3980.016, 26.91931, 0.1523381, 7200, 0, 0), -- 86408 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+45, 91273, 1116, 3, 1, 3741.265, -3978.87, 27.06721, 5.986175, 7200, 0, 0), -- 91273 (Area: -1) +(@CGUID+46, 86087, 1116, 3, 1, 3780.125, -3967.019, 27.51869, 3.334578, 7200, 0, 0), -- 86087 (Area: -1) (Auras: 159510 - 159510) +(@CGUID+47, 87692, 1116, 3, 1, 3756.25, -3973.145, 26.5101, 2.205198, 7200, 5, 1), -- 87692 (Area: -1) (possible waypoints or random movement) +(@CGUID+48, 87062, 1116, 3, 1, 3684.927, -3961.611, 26.09828, 1.780814, 7200, 0, 0), -- 87062 (Area: -1) +(@CGUID+49, 88076, 1116, 3, 1, 3837.342, -3888.103, 7.638551, 1.334949, 7200, 5, 1), -- 88076 (Area: -1) (possible waypoints or random movement) +(@CGUID+50, 88076, 1116, 3, 1, 3841.935, -3920.721, -1.097416, 5.140228, 7200, 5, 1), -- 88076 (Area: -1) (possible waypoints or random movement) +(@CGUID+51, 86087, 1116, 3, 1, 3655.301, -3851.212, 45.07312, 3.473205, 7200, 5, 1), -- 86087 (Area: -1) (Auras: 175121 - 175121) (possible waypoints or random movement) +(@CGUID+52, 86408, 1116, 3, 1, 3697.486, -3975.969, 28.48155, 0.836255, 7200, 0, 0), -- 86408 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+53, 86413, 1116, 3, 1, 3664.458, -3856.177, 42.1764, 0.7691891, 7200, 0, 0), -- 86413 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+54, 86408, 1116, 3, 1, 3646.606, -3907.148, 16.533, 4.949862, 7200, 0, 0), -- 86408 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+55, 85950, 1116, 3, 1, 3635.434, -3906.658, 16.54683, 4.341692, 7200, 0, 0), -- 85950 (Area: -1) (Auras: ) +(@CGUID+56, 86142, 1116, 3, 1, 3682.667, -3968.035, 25.7009, 2.861465, 7200, 5, 1), -- 86142 (Area: -1) (Auras: 172063 - 172063) (possible waypoints or random movement) +(@CGUID+57, 86413, 1116, 3, 1, 3705.838, -3981.345, 28.24719, 0.9630923, 7200, 0, 0), -- 86413 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+58, 86087, 1116, 3, 1, 3685.702, -3946.94, 26.53204, 3.155403, 7200, 5, 1), -- 86087 (Area: -1) (Auras: 175121 - 175121) (possible waypoints or random movement) +(@CGUID+59, 86087, 1116, 3, 1, 3663.932, -3838.168, 44.88526, 3.898497, 7200, 5, 1), -- 86087 (Area: -1) (possible waypoints or random movement) +(@CGUID+60, 87057, 1116, 3, 1, 3718.045, -3982.38, 27.72292, 1.387423, 7200, 0, 0), -- 87057 (Area: -1) (Auras: ) +(@CGUID+61, 85920, 1116, 3, 1, 3715.429, -3985.918, 27.90204, 5.51067, 7200, 0, 0), -- 85920 (Area: -1) +(@CGUID+62, 87763, 1116, 3, 1, 3628.093, -3924.257, 19.23495, 0.1698937, 7200, 0, 0), -- 87763 (Area: -1) +(@CGUID+63, 86408, 1116, 3, 1, 3619.119, -3920.103, 17.7784, 0.2465885, 7200, 0, 0), -- 86408 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+64, 85849, 1116, 3, 1, 3665.896, -3828.853, 47.96662, 4.72738, 7200, 0, 0), -- 85849 (Area: -1) +(@CGUID+65, 85923, 1116, 3, 1, 3709.892, -3984.193, 27.79447, 0.1776158, 7200, 0, 0), -- 85923 (Area: -1) +(@CGUID+66, 86433, 1116, 3, 1, 3758.083, -3976.912, 26.36987, 2.194765, 7200, 5, 1), -- 86433 (Area: -1) (Auras: ) (possible waypoints or random movement) +(@CGUID+67, 86388, 1116, 3, 1, 3629.052, -3957.814, 12.34066, 3.943824, 7200, 0, 0), -- 86388 (Area: -1) +(@CGUID+68, 86087, 1116, 3, 1, 3654.326, -3824.506, 46.42204, 2.464391, 7200, 5, 1), -- 86087 (Area: -1) (possible waypoints or random movement) +(@CGUID+69, 91321, 1116, 3, 1, 3626.185, -3961.141, 12.19198, 4.290033, 7200, 0, 0), -- 91321 (Area: -1) +(@CGUID+70, 88501, 1116, 3, 1, 3680.753, -3994.497, 30.17087, 5.014379, 7200, 0, 0), -- 88501 (Area: -1) +(@CGUID+71, 86413, 1116, 3, 1, 3777.397, -3946.818, 27.82963, 4.739898, 7200, 0, 0), -- 86413 (Area: -1) (Auras: ) +(@CGUID+72, 86408, 1116, 3, 1, 3594.377, -3928.238, 19.87264, 0.1996689, 7200, 0, 0), -- 86408 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+73, 88502, 1116, 3, 1, 3679.266, -4014.345, 32.13129, 1.300693, 7200, 0, 0), -- 88502 (Area: -1) +(@CGUID+74, 86408, 1116, 3, 1, 3600.062, -3982.356, 12.11313, 1.641554, 7200, 0, 0), -- 86408 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+75, 85957, 1116, 3, 1, 3686.066, -4007.25, 29.42548, 1.170018, 7200, 0, 0), -- 85957 (Area: -1) +(@CGUID+76, 88471, 1116, 3, 1, 3684.083, -4005.573, 29.4956, 0.7665163, 7200, 0, 0), -- 88471 (Area: -1) +(@CGUID+77, 88468, 1116, 3, 1, 3680.053, -4000.363, 29.17799, 0.09308653, 7200, 0, 0), -- 88468 (Area: -1) +(@CGUID+78, 86413, 1116, 3, 1, 3607.161, -3981.691, 12.118, 1.627752, 7200, 0, 0), -- 86413 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+79, 88155, 1116, 3, 1, 3616.976, -3982.752, 12.17025, 1.251826, 7200, 0, 0), -- 88155 (Area: -1) +(@CGUID+80, 88472, 1116, 3, 1, 3674.45, -4009.984, 32.09766, 0.5581048, 7200, 0, 0), -- 88472 (Area: -1) +(@CGUID+81, 92501, 1116, 3, 1, 3625.283, -3976.911, 12.26275, 3.02338, 7200, 0, 0), -- 92501 (Area: -1) +(@CGUID+82, 88503, 1116, 3, 1, 3696.747, -4005.017, 29.64816, 2.996757, 7200, 0, 0), -- 88503 (Area: -1) +(@CGUID+83, 86387, 1116, 3, 1, 3628.22, -3968.58, 12.17003, 3.217129, 7200, 0, 0), -- 86387 (Area: -1) +(@CGUID+84, 85958, 1116, 3, 1, 3676.03, -4011.615, 32.08232, 1.004543, 7200, 0, 0), -- 85958 (Area: -1) +(@CGUID+85, 86390, 1116, 3, 1, 3623.278, -3958.283, 12.6221, 4.26717, 7200, 0, 0), -- 86390 (Area: -1) +(@CGUID+86, 86391, 1116, 3, 1, 3626.709, -3973.941, 12.2318, 3.27075, 7200, 0, 0), -- 86391 (Area: -1) +(@CGUID+87, 85964, 1116, 3, 1, 3613.524, -3997.144, 14.41869, 3.372586, 7200, 0, 0), -- 85964 (Area: -1) (Auras: ) +(@CGUID+88, 88469, 1116, 3, 1, 3681.688, -4003.236, 29.29411, 0.5483667, 7200, 0, 0), -- 88469 (Area: -1) +(@CGUID+89, 86389, 1116, 3, 1, 3627.656, -3964.571, 12.17701, 3.202895, 7200, 0, 0), -- 86389 (Area: -1) +(@CGUID+90, 88189, 1116, 3, 1, 3622.654, -3984.354, 12.26106, 1.888541, 7200, 5, 1), -- 88189 (Area: -1) (Auras: ) (possible waypoints or random movement) +(@CGUID+91, 86733, 1116, 3, 1, 3613.514, -3994.606, 14.42729, 3.155483, 7200, 0, 0), -- 86733 (Area: -1) (Auras: ) +(@CGUID+92, 87391, 1116, 3, 1, 3627.118, -3981.535, 12.59335, 2.751866, 7200, 0, 0), -- 87391 (Area: -1) +(@CGUID+93, 86388, 1116, 3, 1, 3631.896, -3974.988, 12.48535, 2.820221, 7200, 0, 0), -- 86388 (Area: -1) +(@CGUID+94, 91483, 1116, 3, 1, 3584.723, -3936.229, 21.43118, 5.903352, 7200, 0, 0), -- 91483 (Area: -1) +(@CGUID+95, 85905, 1116, 3, 1, 3589.01, -3879.46, 6.966464, 3.019417, 7200, 0, 0), -- 85905 (Area: -1) (Auras: 171987 - 171987) +(@CGUID+96, 87022, 1116, 3, 1, 3611.55, -4016.62, 11.92094, 1.325472, 7200, 0, 0), -- 87022 (Area: -1) +(@CGUID+97, 86433, 1116, 3, 1, 3710.96, -4033.646, 40.4991, 2.037331, 7200, 5, 1), -- 86433 (Area: -1) (Auras: ) (possible waypoints or random movement) +(@CGUID+98, 85921, 1116, 3, 1, 3589.907, -3883.953, 7.015789, 1.751665, 7200, 0, 0), -- 85921 (Area: -1) +(@CGUID+99, 86436, 1116, 3, 1, 3567.027, -3952.309, 24.183, 2.387426, 7200, 0, 0), -- 86436 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+100, 86184, 1116, 3, 1, 3566.25, -3926.915, 22.82864, 3.427603, 7200, 0, 0), -- 86184 (Area: -1) +(@CGUID+101, 88168, 1116, 3, 1, 3623.957, -4037.417, 7.693302, 1.97785, 7200, 0, 0), -- 88168 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+102, 85946, 1116, 3, 1, 3565.353, -3930.844, 22.82766, 3.284539, 7200, 0, 0), -- 85946 (Area: -1) +(@CGUID+103, 85914, 1116, 3, 1, 3608.684, -4014.472, 11.94099, 0.6920597, 7200, 0, 0), -- 85914 (Area: -1) +(@CGUID+104, 87048, 1116, 3, 1, 3594.028, -3877.486, 7.014996, 1.645054, 7200, 0, 0), -- 87048 (Area: -1) +(@CGUID+105, 88522, 1116, 3, 1, 3597.967, -4001.335, 14.90749, 0, 7200, 0, 0), -- 88522 (Area: -1) (Auras: ) +(@CGUID+106, 88520, 1116, 3, 1, 3597.005, -3992.556, 14.89195, 0, 7200, 0, 0), -- 88520 (Area: -1) (Auras: ) +(@CGUID+107, 85955, 1116, 3, 1, 3584.017, -3885.168, 7.013719, 1.283303, 7200, 0, 0), -- 85955 (Area: -1) +(@CGUID+108, 86182, 1116, 3, 1, 3567.24, -3934.427, 22.82788, 3.246071, 7200, 0, 0), -- 86182 (Area: -1) +(@CGUID+109, 86408, 1116, 3, 1, 3729.099, -4005.009, 32.67772, 2.832644, 7200, 0, 0), -- 86408 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+110, 86087, 1116, 3, 1, 3695.837, -4037.998, 50.14428, 1.659009, 7200, 0, 0), -- 86087 (Area: -1) (Auras: 159510 - 159510) +(@CGUID+111, 62822, 1116, 3, 1, 3702.131, -3976.389, 28.00182, 1.064739, 7200, 0, 0), -- 62822 (Area: -1) (Auras: 122729 - 122729) +(@CGUID+112, 62821, 1116, 3, 1, 3702.131, -3976.389, 28.00182, 1.064739, 7200, 0, 0), -- 62821 (Area: -1) (Auras: 122729 - 122729) +(@CGUID+113, 86154, 1116, 3, 1, 3561.086, -3867.698, 7.111576, 4.297894, 7200, 0, 0), -- 86154 (Area: -1) +(@CGUID+114, 87278, 1116, 3, 1, 3566.533, -3865.649, 7.363678, 3.37116, 7200, 0, 0), -- 87278 (Area: -1) (Auras: 174598 - 174598) +(@CGUID+115, 88194, 1116, 3, 1, 3603.415, -3851.926, 8.892266, 3.301822, 7200, 0, 0), -- 88194 (Area: -1) +(@CGUID+116, 88236, 1116, 3, 1, 3564.748, -3877.26, 7.362732, 6.055878, 7200, 0, 0), -- 88236 (Area: -1) +(@CGUID+117, 88237, 1116, 3, 1, 3566.103, -3877.479, 7.359111, 3.020856, 7200, 0, 0), -- 88237 (Area: -1) +(@CGUID+118, 87270, 1116, 3, 1, 3581.258, -3865.382, 6.939072, 0, 7200, 0, 0), -- 87270 (Area: -1) +(@CGUID+119, 88194, 1116, 3, 1, 3600.017, -3843.514, 8.975599, 1.517604, 7200, 0, 0), -- 88194 (Area: -1) +(@CGUID+120, 86749, 1116, 3, 1, 3562.262, -3870.049, 0.8043697, 1.372725, 7200, 0, 0), -- 86749 (Area: -1) +(@CGUID+121, 87269, 1116, 3, 1, 3583.583, -3865.844, 6.781141, 2.993386, 7200, 0, 0), -- 87269 (Area: -1) +(@CGUID+122, 87274, 1116, 3, 1, 3561.151, -3878.267, 13.65906, 1.312417, 7200, 0, 0), -- 87274 (Area: -1) +(@CGUID+123, 88194, 1116, 3, 1, 3602.052, -3846.315, 8.892323, 4.802765, 7200, 0, 0), -- 88194 (Area: -1) +(@CGUID+124, 86762, 1116, 3, 1, 3559.145, -3874.243, 7.110863, 2.574766, 7200, 0, 0), -- 86762 (Area: -1) +(@CGUID+125, 86069, 1116, 3, 1, 3560.73, -3869.205, 7.111576, 1.215318, 7200, 0, 0), -- 86069 (Area: -1) +(@CGUID+126, 85963, 1116, 3, 1, 3610.898, -3854.233, 8.975697, 3.105538, 7200, 0, 0), -- 85963 (Area: -1) +(@CGUID+127, 86763, 1116, 3, 1, 3556.917, -3871.668, 7.107924, 4.637369, 7200, 0, 0), -- 86763 (Area: -1) +(@CGUID+128, 87435, 1116, 3, 1, 3555.74, -3873.539, -6.014927, 3.533912, 7200, 0, 0), -- 87435 (Area: -1) +(@CGUID+129, 86408, 1116, 3, 1, 3558.142, -3860.396, 13.8235, 5.508427, 7200, 0, 0), -- 86408 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+130, 85925, 1116, 3, 1, 3559.277, -3866.498, 0.7879469, 1.472397, 7200, 0, 0), -- 85925 (Area: -1) +(@CGUID+131, 87427, 1116, 3, 1, 3553.594, -3873.51, -5.931001, 0.7850253, 7200, 0, 0), -- 87427 (Area: -1) +(@CGUID+132, 88482, 1116, 3, 1, 3551.4, -3919.974, 23.1917, 4.911041, 7200, 0, 0), -- 88482 (Area: -1) +(@CGUID+133, 87431, 1116, 3, 1, 3556.023, -3871.875, -6.015149, 0.9456598, 7200, 0, 0), -- 87431 (Area: -1) +(@CGUID+134, 87273, 1116, 3, 1, 3557.025, -3927.493, 22.82446, 0.1294105, 7200, 0, 0), -- 87273 (Area: -1) +(@CGUID+135, 88485, 1116, 3, 1, 3554.096, -3921.233, 22.82446, 4.903818, 7200, 0, 0), -- 88485 (Area: -1) +(@CGUID+136, 87657, 1116, 3, 1, 3548.623, -3875.564, 7.690316, 3.024441, 7200, 0, 0), -- 87657 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+137, 88235, 1116, 3, 1, 3545.46, -3874.898, 7.612418, 0, 7200, 0, 0), -- 88235 (Area: -1) +(@CGUID+138, 87275, 1116, 3, 1, 3549.11, -3872.32, 8.20338, 2.96706, 7200, 0, 0), -- 87275 (Area: -1) (Auras: 159510 - 159510) +(@CGUID+139, 87436, 1116, 3, 1, 3555.134, -3870.499, -6.015263, 2.746665, 7200, 0, 0), -- 87436 (Area: -1) +(@CGUID+140, 85956, 1116, 3, 1, 3551.286, -3870.589, 7.681326, 6.175763, 7200, 0, 0), -- 85956 (Area: -1) +(@CGUID+141, 88484, 1116, 3, 1, 3551.734, -3924.734, 22.82446, 0, 7200, 0, 0), -- 88484 (Area: -1) +(@CGUID+142, 85932, 1116, 3, 1, 3556.484, -3945.392, 22.82432, 0.8017564, 7200, 0, 0), -- 85932 (Area: -1) +(@CGUID+143, 88076, 1116, 3, 1, 3597.408, -3805.013, 0.5758328, 4.283698, 7200, 5, 1), -- 88076 (Area: -1) (possible waypoints or random movement) +(@CGUID+144, 86441, 1116, 3, 1, 3555.617, -3940.441, 22.82446, 4.752641, 7200, 0, 0), -- 86441 (Area: -1) +(@CGUID+145, 86087, 1116, 3, 1, 3541.168, -3872.502, 7.020814, 1.558601, 7200, 0, 0), -- 86087 (Area: -1) (Auras: 159510 - 159510) +(@CGUID+146, 86065, 1116, 3, 1, 3679.266, -3845.21, 45.13236, 3.238246, 7200, 0, 0), -- 86065 (Area: -1) +(@CGUID+147, 86436, 1116, 3, 1, 3559.361, -3953.49, 24.183, 1.169995, 7200, 0, 0), -- 86436 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+148, 88076, 1116, 3, 1, 3573.874, -3807.688, -0.3680148, 4.210324, 7200, 5, 1), -- 88076 (Area: -1) (possible waypoints or random movement) +(@CGUID+149, 86440, 1116, 3, 1, 3555.825, -3941.938, 22.82446, 1.984233, 7200, 0, 0), -- 86440 (Area: -1) +(@CGUID+150, 88076, 1116, 3, 1, 3561.345, -3823.438, 1.573089, 1.57607, 7200, 0, 0), -- 88076 (Area: -1) +(@CGUID+151, 86110, 1116, 3, 1, 3677.622, -3845.642, 44.87986, 0.0586492, 7200, 0, 0), -- 86110 (Area: -1) +(@CGUID+152, 87342, 1116, 3, 1, 3563.249, -3954.016, 24.183, 1.590217, 7200, 0, 0), -- 87342 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+153, 88076, 1116, 3, 1, 3569.84, -3827.196, 1.813768, 0, 7200, 0, 0), -- 88076 (Area: -1) +(@CGUID+154, 88076, 1116, 3, 1, 3540.785, -3833.17, 1.137885, 0.8449294, 7200, 0, 0), -- 88076 (Area: -1) +(@CGUID+155, 88076, 1116, 3, 1, 3516.976, -3872.505, 1.239825, 3.378224, 7200, 0, 0), -- 88076 (Area: -1) +(@CGUID+156, 88076, 1116, 3, 1, 3520.8, -3863.747, 0.8982744, 2.098535, 7200, 0, 0), -- 88076 (Area: -1) +(@CGUID+157, 86087, 1116, 3, 1, 3663.916, -3811.228, 50.32199, 1.382438, 7200, 0, 0), -- 86087 (Area: -1) +(@CGUID+158, 85959, 1116, 3, 1, 3686.249, -3835.151, 45.06502, 4.349704, 7200, 0, 0), -- 85959 (Area: -1) +(@CGUID+159, 88075, 1116, 3, 1, 3556.822, -3785.149, 1.023429, 0, 7200, 0, 0), -- 88075 (Area: -1) +(@CGUID+160, 88076, 1116, 3, 1, 3474.87, -3861.121, -16.6682, 4.687313, 7200, 0, 0), -- 88076 (Area: -1) +(@CGUID+161, 88076, 1116, 3, 1, 3487.522, -3866.95, -0.4781342, 2.446104, 7200, 0, 0), -- 88076 (Area: -1) +(@CGUID+162, 88076, 1116, 3, 1, 3555.603, -3798.693, -2.116821, 5.664516, 7200, 0, 0), -- 88076 (Area: -1) +(@CGUID+163, 88077, 1116, 3, 1, 3479.918, -3843.022, -6.675027, 0.1149569, 7200, 0, 0), -- 88077 (Area: -1) +(@CGUID+164, 88075, 1116, 3, 1, 3569.199, -3771.76, 6.461286, 4.875318, 7200, 0, 0), -- 88075 (Area: -1) +(@CGUID+165, 88076, 1116, 3, 1, 3537.148, -3753.845, 1.661439, 4.34313, 7200, 0, 0), -- 88076 (Area: -1) +(@CGUID+166, 88076, 1116, 3, 1, 3576.622, -3744.127, -0.3891217, 3.756269, 7200, 0, 0), -- 88076 (Area: -1) +(@CGUID+167, 88077, 1116, 3, 1, 3512.81, -3820.913, 0.2, 5.79474, 7200, 0, 0), -- 88077 (Area: -1) +(@CGUID+168, 88076, 1116, 3, 1, 3493.23, -3889.272, 0.4199371, 3.030483, 7200, 0, 0), -- 88076 (Area: -1) +(@CGUID+169, 88077, 1116, 3, 1, 3489.446, -3982.949, 0.2, 4.866099, 7200, 5, 1), -- 88077 (Area: -1) (possible waypoints or random movement) +(@CGUID+170, 88077, 1116, 3, 1, 3477.317, -3936.871, 0.2, 2.100989, 7200, 0, 0), -- 88077 (Area: -1) +(@CGUID+171, 88077, 1116, 3, 1, 3511.172, -3956.862, -6.25905, 5.540078, 7200, 5, 1), -- 88077 (Area: -1) (possible waypoints or random movement) +(@CGUID+172, 88077, 1116, 3, 1, 3473.331, -3905.261, -16.24768, 1.660993, 7200, 0, 0), -- 88077 (Area: -1) +(@CGUID+173, 88076, 1116, 3, 1, 3485.932, -3911.267, -8.330185, 5.716016, 7200, 0, 0), -- 88076 (Area: -1) +(@CGUID+174, 88076, 1116, 3, 1, 3509.677, -3981.008, -10.19435, 4.586994, 7200, 5, 1), -- 88076 (Area: -1) (possible waypoints or random movement) +(@CGUID+175, 86433, 1116, 3, 1, 3671.188, -3842.989, 44.21319, 0.7991104, 7200, 5, 1), -- 86433 (Area: -1) (Auras: ) (possible waypoints or random movement) +(@CGUID+176, 85926, 1116, 3, 1, 3548.55, -4006.344, 4.210606, 5.554703, 7200, 0, 0), -- 85926 (Area: -1) +(@CGUID+177, 88183, 1116, 3, 1, 3607.185, -4049.311, 6.924367, 0, 7200, 0, 0), -- 88183 (Area: -1) +(@CGUID+178, 86087, 1116, 3, 1, 3693.008, -3925.155, 30.51824, 3.995576, 7200, 0, 0), -- 86087 (Area: -1) +(@CGUID+179, 88076, 1116, 3, 1, 3553.621, -4026.2, 0.6473803, 4.905361, 7200, 0, 0), -- 88076 (Area: -1) +(@CGUID+180, 88076, 1116, 3, 1, 3536.016, -4015.804, 0.547609, 4.25049, 7200, 0, 0), -- 88076 (Area: -1) +(@CGUID+181, 88168, 1116, 3, 1, 3600.642, -4042.031, 6.826027, 1.867222, 7200, 0, 0), -- 88168 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+182, 88076, 1116, 3, 1, 3570.302, -4034.547, 0.6819605, 4.670776, 7200, 0, 0), -- 88076 (Area: -1) +(@CGUID+183, 88077, 1116, 3, 1, 3549.49, -4080.474, -4.634336, 0.299108, 7200, 0, 0), -- 88077 (Area: -1) +(@CGUID+184, 88076, 1116, 3, 1, 3574.375, -4093.366, -7.105989, 5.974282, 7200, 0, 0), -- 88076 (Area: -1) +(@CGUID+185, 88184, 1116, 3, 1, 3609.577, -4054.653, 6.924367, 0.7431221, 7200, 0, 0), -- 88184 (Area: -1) +(@CGUID+186, 88076, 1116, 3, 1, 3590.732, -4081.122, -5.908721, 2.405668, 7200, 0, 0), -- 88076 (Area: -1) +(@CGUID+187, 88168, 1116, 3, 1, 3624.314, -4071.545, 6.666434, 1.398944, 7200, 0, 0), -- 88168 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+188, 88077, 1116, 3, 1, 3508.676, -4046.262, -13.86511, 2.110504, 7200, 0, 0), -- 88077 (Area: -1) +(@CGUID+189, 88076, 1116, 3, 1, 3589.503, -4089.32, -8.600714, 3.242568, 7200, 0, 0), -- 88076 (Area: -1) +(@CGUID+190, 88076, 1116, 3, 1, 3540.499, -4055.885, -4.249415, 0.7963732, 7200, 0, 0), -- 88076 (Area: -1) +(@CGUID+191, 88076, 1116, 3, 1, 3506.797, -3994.229, -8.029015, 3.525471, 7200, 0, 0), -- 88076 (Area: -1) +(@CGUID+192, 88076, 1116, 3, 1, 3598.53, -4089.167, -1.227241, 0, 7200, 0, 0), -- 88076 (Area: -1) +(@CGUID+193, 88076, 1116, 3, 1, 3565.73, -4059.562, -2.400834, 3.634079, 7200, 0, 0), -- 88076 (Area: -1) +(@CGUID+194, 88168, 1116, 3, 1, 3636.708, -4067.774, 6.887478, 2.582347, 7200, 0, 0), -- 88168 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+195, 88182, 1116, 3, 1, 3628.674, -4068.125, 6.841712, 0.4203821, 7200, 0, 0), -- 88182 (Area: -1) +(@CGUID+196, 88181, 1116, 3, 1, 3630.603, -4067.5, 6.832589, 3.510381, 7200, 0, 0), -- 88181 (Area: -1) +(@CGUID+197, 88077, 1116, 3, 1, 3586.919, -4116.252, -13.14919, 5.91725, 7200, 0, 0), -- 88077 (Area: -1) +(@CGUID+198, 86148, 1116, 3, 1, 3717.146, -4055.941, 45.15958, 1.443845, 7200, 0, 0), -- 86148 (Area: -1) +(@CGUID+199, 86087, 1116, 3, 1, 3702.761, -3908.484, 30.06149, 4.147125, 7200, 5, 1), -- 86087 (Area: -1) (Auras: 172044 - 172044) (possible waypoints or random movement) +(@CGUID+200, 86087, 1116, 3, 1, 3720.156, -4063.273, 46.45479, 2.604828, 7200, 0, 0), -- 86087 (Area: -1) +(@CGUID+201, 86093, 1116, 3, 1, 3735.155, -4046.635, 45.67841, 2.427667, 7200, 0, 0), -- 86093 (Area: -1) (Auras: 32783 - 32783) +(@CGUID+202, 86408, 1116, 3, 1, 3728.915, -4053.378, 44.95645, 2.787961, 7200, 0, 0), -- 86408 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+203, 86408, 1116, 3, 1, 3748.581, -3891.401, 33.57396, 3.786388, 7200, 0, 0), -- 86408 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+204, 86413, 1116, 3, 1, 3726.811, -3875.717, 30.91771, 3.967085, 7200, 0, 0), -- 86413 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+205, 87657, 1116, 3, 1, 3745.723, -3894.649, 33.57354, 0.4667733, 7200, 0, 0), -- 87657 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+206, 86087, 1116, 3, 1, 3691.822, -3884.492, 32.60319, 2.372088, 7200, 5, 1), -- 86087 (Area: -1) (Auras: 175121 - 175121) (possible waypoints or random movement) +(@CGUID+207, 86087, 1116, 3, 1, 3726.936, -3882.394, 30.79918, 3.916554, 7200, 5, 1), -- 86087 (Area: -1) (possible waypoints or random movement) +(@CGUID+208, 86408, 1116, 3, 1, 3713.441, -3873.54, 30.98459, 5.286925, 7200, 0, 0), -- 86408 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+209, 87285, 1116, 3, 1, 3698.497, -3885.844, 31.43648, 5.873244, 7200, 0, 0), -- 87285 (Area: -1) +(@CGUID+210, 87276, 1116, 3, 1, 3700.74, -3886.917, 30.93021, 2.666314, 7200, 0, 0), -- 87276 (Area: -1) +(@CGUID+211, 86408, 1116, 3, 1, 3693.056, -3852.981, 44.9266, 3.359754, 7200, 0, 0), -- 86408 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+212, 86413, 1116, 3, 1, 3690.082, -3853.516, 45.0783, 0.1552463, 7200, 0, 0), -- 86413 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+213, 86408, 1116, 3, 1, 3777.362, -3945.548, 27.88441, 4.739898, 7200, 0, 0), -- 86408 (Area: -1) (Auras: ) +(@CGUID+214, 86432, 1116, 3, 1, 3744.533, -4058.734, 67.21564, 0.8124133, 7200, 0, 0), -- 86432 (Area: -1) (Auras: 163207 - 163207) +(@CGUID+215, 86413, 1116, 3, 1, 3802.292, -3999.911, 26.96619, 4.739961, 7200, 0, 0), -- 86413 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+216, 88230, 1116, 3, 1, 3792.076, -4033.326, 26.04898, 0.2915597, 7200, 0, 0), -- 88230 (Area: -1) +(@CGUID+217, 86408, 1116, 3, 1, 3805.528, -3999.639, 27.17535, 4.739961, 7200, 0, 0), -- 86408 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+218, 86413, 1116, 3, 1, 3805.247, -3996.314, 27.11111, 4.739961, 7200, 0, 0), -- 86413 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+219, 86408, 1116, 3, 1, 3808.481, -3996.372, 27.04861, 4.739961, 7200, 0, 0), -- 86408 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+220, 86438, 1116, 3, 1, 3808.725, -4003.609, 27.12434, 0.01203965, 7200, 5, 1), -- 86438 (Area: -1) (Auras: 18950 - 18950) (possible waypoints or random movement) +(@CGUID+221, 85962, 1116, 3, 1, 3743.269, -4058.323, 46.68205, 0.7734757, 7200, 0, 0), -- 85962 (Area: -1) +(@CGUID+222, 86175, 1116, 3, 1, 3814.504, -3995.986, 27.04684, 0.7334857, 7200, 0, 0), -- 86175 (Area: -1) +(@CGUID+223, 86408, 1116, 3, 1, 3802.106, -3996.731, 27.0402, 4.739961, 7200, 0, 0), -- 86408 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+224, 86087, 1116, 3, 1, 3733.537, -4064.59, 45.24252, 4.433136, 7200, 5, 1), -- 86087 (Area: -1) (possible waypoints or random movement) +(@CGUID+225, 86176, 1116, 3, 1, 3815.967, -3994.722, 27.08729, 3.853694, 7200, 0, 0), -- 86176 (Area: -1) +(@CGUID+226, 86413, 1116, 3, 1, 3808.601, -3999.349, 27.04861, 4.739961, 7200, 0, 0), -- 86413 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+227, 85961, 1116, 3, 1, 3746.228, -4059.238, 46.68128, 1.599436, 7200, 0, 0), -- 85961 (Area: -1) +(@CGUID+228, 87063, 1116, 3, 1, 3755.345, -4051.149, 67.23281, 3.395237, 7200, 0, 0), -- 87063 (Area: -1) +(@CGUID+229, 88215, 1116, 3, 1, 3797.414, -4044.203, 26.24311, 4.269325, 7200, 0, 0), -- 88215 (Area: -1) (Auras: 171989 - 171989) +(@CGUID+230, 35845, 1116, 3, 1, 3754.092, -4060.303, 68.13293, 3.004107, 7200, 5, 1), -- 35845 (Area: -1) (Auras: 171980 - 171980) (possible waypoints or random movement) +(@CGUID+231, 93906, 1116, 3, 1, 3820.342, -3997.153, 27.04684, 4.555138, 7200, 0, 0), -- 93906 (Area: -1) +(@CGUID+232, 86178, 1116, 3, 1, 3822.142, -3998.734, 27.04687, 4.464031, 7200, 0, 0), -- 86178 (Area: -1) +(@CGUID+233, 85911, 1116, 3, 1, 3754.266, -4059.415, 67.21613, 3.059405, 7200, 0, 0), -- 85911 (Area: -1) (Auras: 171984 - 171984) +(@CGUID+234, 35845, 1116, 3, 1, 3755.042, -4059.366, 67.1333, 1.769362, 7200, 5, 1), -- 35845 (Area: -1) (Auras: 171981 - 171981) (possible waypoints or random movement) +(@CGUID+235, 35845, 1116, 3, 1, 3754.953, -4059.081, 69.01214, 1.495632, 7200, 5, 1), -- 35845 (Area: -1) (Auras: 171962 - 171962) (possible waypoints or random movement) +(@CGUID+236, 88254, 1116, 3, 1, 3744.479, -4064.495, 67.21566, 1.200759, 7200, 0, 0), -- 88254 (Area: -1) +(@CGUID+237, 86408, 1116, 3, 1, 3774.129, -3947.825, 27.77118, 3.739084, 7200, 0, 0), -- 86408 (Area: -1) (Auras: ) +(@CGUID+238, 88211, 1116, 3, 1, 3817.35, -4078.658, 30.90458, 1.926504, 7200, 0, 0), -- 88211 (Area: -1) +(@CGUID+239, 88214, 1116, 3, 1, 3816.502, -4091.184, 30.82124, 0.7679449, 7200, 0, 0), -- 88214 (Area: -1) +(@CGUID+240, 88076, 1116, 3, 1, 3722.869, -4210.302, 23.58849, 3.368099, 7200, 0, 0), -- 88076 (Area: -1) +(@CGUID+241, 88076, 1116, 3, 1, 3673.322, -4197.833, 11.73082, 4.616605, 7200, 0, 0), -- 88076 (Area: -1) +(@CGUID+242, 88077, 1116, 3, 1, 3720.481, -4259.601, -3.552481, 4.891117, 7200, 0, 0), -- 88077 (Area: -1) +(@CGUID+243, 88075, 1116, 3, 1, 3828.564, -4159.939, 29.58502, 1.46823, 7200, 0, 0), -- 88075 (Area: -1) +(@CGUID+244, 88076, 1116, 3, 1, 3781.175, -4234.895, 13.52466, 4.89102, 7200, 0, 0), -- 88076 (Area: -1) +(@CGUID+245, 88075, 1116, 3, 1, 3723.378, -4159.403, 34.58677, 2.850416, 7200, 5, 1), -- 88075 (Area: -1) (possible waypoints or random movement) +(@CGUID+246, 88077, 1116, 3, 1, 3681.202, -4250.214, -4.187796, 2.419838, 7200, 0, 0), -- 88077 (Area: -1) +(@CGUID+247, 88076, 1116, 3, 1, 3794.694, -4241.62, 11.90086, 4.435121, 7200, 0, 0), -- 88076 (Area: -1) +(@CGUID+248, 88075, 1116, 3, 1, 3803.112, -4188.262, 31.99364, 1.913731, 7200, 0, 0), -- 88075 (Area: -1) +(@CGUID+249, 88077, 1116, 3, 1, 3778.525, -4260.613, 0.2, 1.794174, 7200, 0, 0), -- 88077 (Area: -1) +(@CGUID+250, 88076, 1116, 3, 1, 3693.695, -4210.592, 10.33922, 0.1372473, 7200, 0, 0), -- 88076 (Area: -1) +(@CGUID+251, 88077, 1116, 3, 1, 3657.719, -4225.405, -6.065119, 0.1949095, 7200, 0, 0), -- 88077 (Area: -1) +(@CGUID+252, 88076, 1116, 3, 1, 3863.374, -4202.936, 11.44087, 0, 7200, 0, 0), -- 88076 (Area: -1) +(@CGUID+253, 88076, 1116, 3, 1, 3841.764, -4224.937, 17.3052, 4.543793, 7200, 0, 0), -- 88076 (Area: -1) +(@CGUID+254, 88076, 1116, 3, 1, 3891.223, -4169.24, 11.90822, 0, 7200, 0, 0), -- 88076 (Area: -1) +(@CGUID+255, 87329, 1116, 3, 1, 3841.392, -4059.33, 31.88298, 1.675332, 7200, 0, 0), -- 87329 (Area: -1) +(@CGUID+256, 88212, 1116, 3, 1, 3821.987, -4073.214, 30.90458, 0.02040727, 7200, 0, 0), -- 88212 (Area: -1) +(@CGUID+257, 87318, 1116, 3, 1, 3844.079, -4041.135, 26.69347, 2.093792, 7200, 0, 0), -- 87318 (Area: -1) (Auras: ) +(@CGUID+258, 87320, 1116, 3, 1, 3838.563, -4042.675, 26.27721, 1.641862, 7200, 0, 0), -- 87320 (Area: -1) (Auras: ) +(@CGUID+259, 87318, 1116, 3, 1, 3833.111, -4041.896, 26.41824, 1.239629, 7200, 0, 0), -- 87318 (Area: -1) (Auras: ) +(@CGUID+260, 86436, 1116, 3, 1, 3834.99, -4029.066, 25.94345, 0.0698022, 7200, 0, 0), -- 86436 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+261, 87321, 1116, 3, 1, 3832.62, -4019.922, 27.39632, 4.661171, 7200, 0, 0), -- 87321 (Area: -1) (Auras: 167347 - 167347) +(@CGUID+262, 86413, 1116, 3, 1, 3834.544, -4031.024, 25.9118, 4.76084, 7200, 0, 0), -- 86413 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+263, 86408, 1116, 3, 1, 3841.377, -4030.656, 25.87244, 4.834315, 7200, 0, 0), -- 86408 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+264, 87322, 1116, 3, 1, 3820.877, -4022.172, 27.92805, 5.655557, 7200, 0, 0), -- 87322 (Area: -1) +(@CGUID+265, 87321, 1116, 3, 1, 3836.181, -4019.988, 27.28063, 4.752673, 7200, 0, 0), -- 87321 (Area: -1) (Auras: 167347 - 167347) +(@CGUID+266, 86408, 1116, 3, 1, 3838.059, -4030.877, 25.83939, 4.796937, 7200, 0, 0), -- 86408 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+267, 86413, 1116, 3, 1, 3851.345, -4017.908, 26.56154, 1.64015, 7200, 0, 0), -- 86413 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+268, 93907, 1116, 3, 1, 3824.371, -3997.719, 27.04686, 4.425706, 7200, 0, 0), -- 93907 (Area: -1) +(@CGUID+269, 86413, 1116, 3, 1, 3774.772, -3946.241, 27.83031, 4.815624, 7200, 0, 0), -- 86413 (Area: -1) (Auras: ) +(@CGUID+270, 86413, 1116, 3, 1, 3749.339, -3962.636, 27.19842, 5.131742, 7200, 0, 0), -- 86413 (Area: -1) (Auras: 18950 - 18950) +(@CGUID+271, 82876, 1191, 3, 1, 3915.049, -4087.158, 66.61595, 0.1901753, 7200, 0, 0), -- 82876 (Area: 7100) (Auras: 164310 - 164310) +(@CGUID+272, 88975, 1191, 3, 1, 3954.996, -3965.58, 40.42803, 1.563317, 7200, 0, 0), -- 88975 (Area: 7100) (Auras: 164310 - 164310) +(@CGUID+273, 86087, 1191, 3, 1, 3952.907, -3972.947, 39.2041, 5.649316, 7200, 0, 0), -- 86087 (Area: 7100) (Auras: 164310 - 164310, 175121 - 175121) +(@CGUID+274, 85445, 1191, 3, 1, 4089.355, -4102.321, 78.72186, 5.657169, 7200, 0, 0), -- 85445 (Area: 7100) (Auras: 164310 - 164310, 104945 - 104945) +(@CGUID+275, 88975, 1191, 3, 1, 3932.881, -3969.816, 36.00977, 4.965889, 7200, 0, 0), -- 88975 (Area: 7100) (Auras: 164310 - 164310) +(@CGUID+276, 86829, 1191, 3, 1, 3960.73, -3979.438, 40.95396, 3.168359, 7200, 0, 0), -- 86829 (Area: 7100) (Auras: 164310 - 164310, 18950 - 18950) +(@CGUID+277, 86413, 1116, 3, 1, 3775.771, -3952.802, 27.76968, 2.383016, 7200, 5, 1), -- 86413 (Area: 7332) (Auras: ) (possible waypoints or random movement) +(@CGUID+278, 88076, 1116, 3, 1, 3834.763, -3781.077, 2.646448, 6.165734, 7200, 0, 0), -- 88076 (Area: 7332) +(@CGUID+279, 88076, 1116, 3, 1, 3809.225, -3764.876, 10.39953, 6.17749, 7200, 0, 0), -- 88076 (Area: 7332) +(@CGUID+280, 88076, 1116, 3, 1, 3779.012, -3754.233, 0.8942108, 1.766699, 7200, 0, 0); -- 88076 (Area: 7332) + +-- Creature Addon +DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+280; +INSERT INTO `creature_addon` (`guid`, `mount`, `bytes1`, `bytes2`, `auras`) VALUES +(@CGUID+0, 0, 0x0, 0x1, '122729 123240'), -- 62822 - 122729 - 122729, 123240 - 123240 +(@CGUID+1, 0, 0x0, 0x0, ''), -- 86087 +(@CGUID+2, 0, 0x0, 0x1, '122729 123236'), -- 62821 - 122729 - 122729, 123236 - 123236 +(@CGUID+3, 0, 0x0, 0x1, '172032'), -- 86136 - 172032 - 172032 +(@CGUID+4, 0, 0x0, 0x100, '18950'), -- 86408 - 18950 - 18950 +(@CGUID+5, 0, 0x0, 0x1, ''), -- 87271 +(@CGUID+6, 0, 0x0, 0x0, ''), -- 86087 +(@CGUID+7, 0, 0x0, 0x1, ''), -- 87277 +(@CGUID+8, 0, 0x0, 0x100, '18950'), -- 86413 - 18950 - 18950 +(@CGUID+9, 0, 0x0, 0x1, ''), -- 86087 +(@CGUID+10, 28917, 0x0, 0x101, ''), -- 86433 +(@CGUID+11, 0, 0x0, 0x1, '174794'), -- 86087 - 174794 - 174794 +(@CGUID+12, 0, 0x0, 0x1, '163720'), -- 87375 - 163720 - 163720 +(@CGUID+13, 0, 0x0, 0x1, ''), -- 86087 +(@CGUID+14, 0, 0x0, 0x1, ''), -- 87052 +(@CGUID+15, 0, 0x0, 0x0, ''), -- 86087 +(@CGUID+16, 0, 0x0, 0x101, '18950'), -- 86408 - 18950 - 18950 +(@CGUID+17, 0, 0x0, 0x101, '18950'), -- 87663 - 18950 - 18950 +(@CGUID+18, 0, 0x0, 0x1, ''), -- 87255 +(@CGUID+19, 0, 0x0, 0x1, ''), -- 86087 +(@CGUID+20, 0, 0x0, 0x100, '18950'), -- 86408 - 18950 - 18950 +(@CGUID+21, 0, 0x0, 0x1, ''), -- 85919 +(@CGUID+22, 0, 0x0, 0x100, '18950'), -- 86413 - 18950 - 18950 +(@CGUID+23, 0, 0x0, 0x1, ''), -- 85930 +(@CGUID+24, 0, 0x0, 0x1, ''), -- 87365 +(@CGUID+25, 0, 0x0, 0x1, ''), -- 86084 +(@CGUID+26, 0, 0x0, 0x1, '174609'), -- 86424 - 174609 - 174609 +(@CGUID+27, 0, 0x0, 0x1, ''), -- 85917 +(@CGUID+28, 0, 0x0, 0x1, ''), -- 87243 +(@CGUID+29, 0, 0x0, 0x1, '164381'), -- 86129 - 164381 - 164381 +(@CGUID+30, 0, 0x0, 0x100, '172660'), -- 86408 - 172660 - 172660 +(@CGUID+31, 0, 0x0, 0x1, ''), -- 87065 +(@CGUID+32, 0, 0x0, 0x100, '18950'), -- 86413 - 18950 - 18950 +(@CGUID+33, 0, 0x0, 0x1, ''), -- 85951 +(@CGUID+34, 0, 0x0, 0x100, '18950'), -- 86413 - 18950 - 18950 +(@CGUID+35, 0, 0x0, 0x1, ''), -- 85918 +(@CGUID+36, 0, 0x0, 0x1, '172121'), -- 85927 - 172121 - 172121 +(@CGUID+37, 0, 0x0, 0x1, '171989'), -- 86141 - 171989 - 171989 +(@CGUID+38, 0, 0x0, 0x1, ''), -- 85916 +(@CGUID+39, 0, 0x3, 0x1, '18950'), -- 86418 - 18950 - 18950 +(@CGUID+40, 0, 0x0, 0x1, ''), -- 87049 +(@CGUID+41, 0, 0x0, 0x1, ''), -- 87067 +(@CGUID+42, 0, 0x0, 0x1, ''), -- 85910 +(@CGUID+43, 0, 0x0, 0x1, ''), -- 88076 +(@CGUID+44, 0, 0x0, 0x100, '18950'), -- 86408 - 18950 - 18950 +(@CGUID+45, 0, 0x0, 0x101, ''), -- 91273 +(@CGUID+46, 0, 0x0, 0x1, '159510'), -- 86087 - 159510 - 159510 +(@CGUID+47, 2404, 0x0, 0x101, ''), -- 87692 +(@CGUID+48, 0, 0x0, 0x1, ''), -- 87062 +(@CGUID+49, 0, 0x0, 0x1, ''), -- 88076 +(@CGUID+50, 0, 0x0, 0x1, ''), -- 88076 +(@CGUID+51, 0, 0x0, 0x1, '175121'), -- 86087 - 175121 - 175121 +(@CGUID+52, 0, 0x0, 0x100, '18950'), -- 86408 - 18950 - 18950 +(@CGUID+53, 0, 0x0, 0x100, '18950'), -- 86413 - 18950 - 18950 +(@CGUID+54, 0, 0x0, 0x100, '18950'), -- 86408 - 18950 - 18950 +(@CGUID+55, 0, 0x0, 0x1, ''), -- 85950 +(@CGUID+56, 0, 0x0, 0x1, '172063'), -- 86142 - 172063 - 172063 +(@CGUID+57, 0, 0x0, 0x100, '18950'), -- 86413 - 18950 - 18950 +(@CGUID+58, 0, 0x0, 0x1, '175121'), -- 86087 - 175121 - 175121 +(@CGUID+59, 0, 0x0, 0x1, ''), -- 86087 +(@CGUID+60, 0, 0x0, 0x1, ''), -- 87057 +(@CGUID+61, 0, 0x0, 0x1, ''), -- 85920 +(@CGUID+62, 0, 0x0, 0x1, ''), -- 87763 +(@CGUID+63, 0, 0x0, 0x100, '18950'), -- 86408 - 18950 - 18950 +(@CGUID+64, 0, 0x0, 0x1, ''), -- 85849 +(@CGUID+65, 0, 0x0, 0x1, ''), -- 85923 +(@CGUID+66, 28917, 0x0, 0x101, ''), -- 86433 +(@CGUID+67, 0, 0x0, 0x1, ''), -- 86388 +(@CGUID+68, 0, 0x0, 0x1, ''), -- 86087 +(@CGUID+69, 0, 0x0, 0x1, ''), -- 91321 +(@CGUID+70, 0, 0x0, 0x1, ''), -- 88501 +(@CGUID+71, 0, 0x0, 0x101, ''), -- 86413 +(@CGUID+72, 0, 0x0, 0x100, '18950'), -- 86408 - 18950 - 18950 +(@CGUID+73, 0, 0x0, 0x1, ''), -- 88502 +(@CGUID+74, 0, 0x0, 0x100, '18950'), -- 86408 - 18950 - 18950 +(@CGUID+75, 0, 0x0, 0x1, ''), -- 85957 +(@CGUID+76, 0, 0x0, 0x1, ''), -- 88471 +(@CGUID+77, 0, 0x0, 0x1, ''), -- 88468 +(@CGUID+78, 0, 0x0, 0x100, '18950'), -- 86413 - 18950 - 18950 +(@CGUID+79, 0, 0x0, 0x0, ''), -- 88155 +(@CGUID+80, 0, 0x0, 0x1, ''), -- 88472 +(@CGUID+81, 0, 0x0, 0x1, ''), -- 92501 +(@CGUID+82, 0, 0x0, 0x1, ''), -- 88503 +(@CGUID+83, 0, 0x0, 0x1, ''), -- 86387 +(@CGUID+84, 0, 0x0, 0x1, ''), -- 85958 +(@CGUID+85, 0, 0x0, 0x1, ''), -- 86390 +(@CGUID+86, 0, 0x0, 0x1, ''), -- 86391 +(@CGUID+87, 0, 0x0, 0x1, ''), -- 85964 +(@CGUID+88, 0, 0x0, 0x1, ''), -- 88469 +(@CGUID+89, 0, 0x0, 0x1, ''), -- 86389 +(@CGUID+90, 14333, 0x0, 0x101, ''), -- 88189 +(@CGUID+91, 0, 0x0, 0x1, ''), -- 86733 +(@CGUID+92, 0, 0x0, 0x1, ''), -- 87391 +(@CGUID+93, 0, 0x0, 0x1, ''), -- 86388 +(@CGUID+94, 0, 0x0, 0x1, ''), -- 91483 +(@CGUID+95, 0, 0x0, 0x1, '171987'), -- 85905 - 171987 - 171987 +(@CGUID+96, 0, 0x0, 0x1, ''), -- 87022 +(@CGUID+97, 28917, 0x0, 0x101, ''), -- 86433 +(@CGUID+98, 0, 0x0, 0x1, ''), -- 85921 +(@CGUID+99, 0, 0x0, 0x100, '18950'), -- 86436 - 18950 - 18950 +(@CGUID+100, 0, 0x0, 0x0, ''), -- 86184 +(@CGUID+101, 0, 0x0, 0x101, '18950'), -- 88168 - 18950 - 18950 +(@CGUID+102, 0, 0x0, 0x1, ''), -- 85946 +(@CGUID+103, 0, 0x0, 0x1, ''), -- 85914 +(@CGUID+104, 0, 0x0, 0x1, ''), -- 87048 +(@CGUID+105, 0, 0x0, 0x1, ''), -- 88522 +(@CGUID+106, 0, 0x0, 0x1, ''), -- 88520 +(@CGUID+107, 0, 0x0, 0x1, ''), -- 85955 +(@CGUID+108, 0, 0x0, 0x0, ''), -- 86182 +(@CGUID+109, 0, 0x0, 0x100, '18950'), -- 86408 - 18950 - 18950 +(@CGUID+110, 0, 0x0, 0x1, '159510'), -- 86087 - 159510 - 159510 +(@CGUID+111, 0, 0x0, 0x1, '122729'), -- 62822 - 122729 - 122729 +(@CGUID+112, 0, 0x0, 0x1, '122729'), -- 62821 - 122729 - 122729 +(@CGUID+113, 0, 0x0, 0x1, ''), -- 86154 +(@CGUID+114, 0, 0x0, 0x1, '174598'), -- 87278 - 174598 - 174598 +(@CGUID+115, 0, 0x0, 0x1, ''), -- 88194 +(@CGUID+116, 0, 0x0, 0x1, ''), -- 88236 +(@CGUID+117, 0, 0x0, 0x1, ''), -- 88237 +(@CGUID+118, 0, 0x0, 0x1, ''), -- 87270 +(@CGUID+119, 0, 0x0, 0x1, ''), -- 88194 +(@CGUID+120, 0, 0x0, 0x1, ''), -- 86749 +(@CGUID+121, 0, 0x0, 0x1, ''), -- 87269 +(@CGUID+122, 0, 0x0, 0x1, ''), -- 87274 +(@CGUID+123, 0, 0x0, 0x1, ''), -- 88194 +(@CGUID+124, 0, 0x0, 0x1, ''), -- 86762 +(@CGUID+125, 0, 0x0, 0x1, ''), -- 86069 +(@CGUID+126, 0, 0x0, 0x1, ''), -- 85963 +(@CGUID+127, 0, 0x0, 0x1, ''), -- 86763 +(@CGUID+128, 0, 0x0, 0x1, ''), -- 87435 +(@CGUID+129, 0, 0x0, 0x101, '18950'), -- 86408 - 18950 - 18950 +(@CGUID+130, 0, 0x0, 0x1, ''), -- 85925 +(@CGUID+131, 0, 0x0, 0x101, ''), -- 87427 +(@CGUID+132, 0, 0x0, 0x1, ''), -- 88482 +(@CGUID+133, 0, 0x0, 0x1, ''), -- 87431 +(@CGUID+134, 0, 0x0, 0x1, ''), -- 87273 +(@CGUID+135, 0, 0x0, 0x1, ''), -- 88485 +(@CGUID+136, 0, 0x0, 0x101, '18950'), -- 87657 - 18950 - 18950 +(@CGUID+137, 0, 0x0, 0x1, ''), -- 88235 +(@CGUID+138, 0, 0x0, 0x1, '159510'), -- 87275 - 159510 - 159510 +(@CGUID+139, 0, 0x0, 0x1, ''), -- 87436 +(@CGUID+140, 0, 0x0, 0x1, ''), -- 85956 +(@CGUID+141, 0, 0x0, 0x1, ''), -- 88484 +(@CGUID+142, 0, 0x0, 0x1, ''), -- 85932 +(@CGUID+143, 0, 0x0, 0x1, ''), -- 88076 +(@CGUID+144, 0, 0x0, 0x1, ''), -- 86441 +(@CGUID+145, 0, 0x0, 0x1, '159510'), -- 86087 - 159510 - 159510 +(@CGUID+146, 0, 0x0, 0x1, ''), -- 86065 +(@CGUID+147, 0, 0x0, 0x100, '18950'), -- 86436 - 18950 - 18950 +(@CGUID+148, 0, 0x0, 0x1, ''), -- 88076 +(@CGUID+149, 0, 0x0, 0x1, ''), -- 86440 +(@CGUID+150, 0, 0x0, 0x1, ''), -- 88076 +(@CGUID+151, 0, 0x0, 0x1, ''), -- 86110 +(@CGUID+152, 0, 0x0, 0x100, '18950'), -- 87342 - 18950 - 18950 +(@CGUID+153, 0, 0x0, 0x1, ''), -- 88076 +(@CGUID+154, 0, 0x0, 0x1, ''), -- 88076 +(@CGUID+155, 0, 0x0, 0x1, ''), -- 88076 +(@CGUID+156, 0, 0x0, 0x1, ''), -- 88076 +(@CGUID+157, 0, 0x0, 0x1, ''), -- 86087 +(@CGUID+158, 0, 0x0, 0x1, ''), -- 85959 +(@CGUID+159, 0, 0x0, 0x1, ''), -- 88075 +(@CGUID+160, 0, 0x0, 0x1, ''), -- 88076 +(@CGUID+161, 0, 0x0, 0x1, ''), -- 88076 +(@CGUID+162, 0, 0x0, 0x1, ''), -- 88076 +(@CGUID+163, 0, 0x0, 0x1, ''), -- 88077 +(@CGUID+164, 0, 0x0, 0x1, ''), -- 88075 +(@CGUID+165, 0, 0x0, 0x1, ''), -- 88076 +(@CGUID+166, 0, 0x0, 0x1, ''), -- 88076 +(@CGUID+167, 0, 0x0, 0x1, ''), -- 88077 +(@CGUID+168, 0, 0x0, 0x1, ''), -- 88076 +(@CGUID+169, 0, 0x0, 0x1, ''), -- 88077 +(@CGUID+170, 0, 0x0, 0x1, ''), -- 88077 +(@CGUID+171, 0, 0x0, 0x1, ''), -- 88077 +(@CGUID+172, 0, 0x0, 0x1, ''), -- 88077 +(@CGUID+173, 0, 0x0, 0x1, ''), -- 88076 +(@CGUID+174, 0, 0x0, 0x1, ''), -- 88076 +(@CGUID+175, 28917, 0x0, 0x101, ''), -- 86433 +(@CGUID+176, 0, 0x0, 0x1, ''), -- 85926 +(@CGUID+177, 0, 0x0, 0x1, ''), -- 88183 +(@CGUID+178, 0, 0x0, 0x0, ''), -- 86087 +(@CGUID+179, 0, 0x0, 0x1, ''), -- 88076 +(@CGUID+180, 0, 0x0, 0x1, ''), -- 88076 +(@CGUID+181, 0, 0x0, 0x101, '18950'), -- 88168 - 18950 - 18950 +(@CGUID+182, 0, 0x0, 0x1, ''), -- 88076 +(@CGUID+183, 0, 0x0, 0x1, ''), -- 88077 +(@CGUID+184, 0, 0x0, 0x1, ''), -- 88076 +(@CGUID+185, 0, 0x0, 0x1, ''), -- 88184 +(@CGUID+186, 0, 0x0, 0x1, ''), -- 88076 +(@CGUID+187, 0, 0x0, 0x101, '18950'), -- 88168 - 18950 - 18950 +(@CGUID+188, 0, 0x0, 0x1, ''), -- 88077 +(@CGUID+189, 0, 0x0, 0x1, ''), -- 88076 +(@CGUID+190, 0, 0x0, 0x1, ''), -- 88076 +(@CGUID+191, 0, 0x0, 0x1, ''), -- 88076 +(@CGUID+192, 0, 0x0, 0x1, ''), -- 88076 +(@CGUID+193, 0, 0x0, 0x1, ''), -- 88076 +(@CGUID+194, 0, 0x0, 0x101, '18950'), -- 88168 - 18950 - 18950 +(@CGUID+195, 0, 0x0, 0x1, ''), -- 88182 +(@CGUID+196, 0, 0x0, 0x1, ''), -- 88181 +(@CGUID+197, 0, 0x0, 0x1, ''), -- 88077 +(@CGUID+198, 0, 0x0, 0x1, ''), -- 86148 +(@CGUID+199, 0, 0x0, 0x0, '172044'), -- 86087 - 172044 - 172044 +(@CGUID+200, 0, 0x0, 0x1, ''), -- 86087 +(@CGUID+201, 0, 0x0, 0x1, '32783'), -- 86093 - 32783 - 32783 +(@CGUID+202, 0, 0x0, 0x100, '18950'), -- 86408 - 18950 - 18950 +(@CGUID+203, 0, 0x0, 0x101, '18950'), -- 86408 - 18950 - 18950 +(@CGUID+204, 0, 0x0, 0x100, '18950'), -- 86413 - 18950 - 18950 +(@CGUID+205, 0, 0x0, 0x101, '18950'), -- 87657 - 18950 - 18950 +(@CGUID+206, 0, 0x0, 0x1, '175121'), -- 86087 - 175121 - 175121 +(@CGUID+207, 0, 0x0, 0x1, ''), -- 86087 +(@CGUID+208, 0, 0x0, 0x100, '18950'), -- 86408 - 18950 - 18950 +(@CGUID+209, 0, 0x0, 0x1, ''), -- 87285 +(@CGUID+210, 0, 0x0, 0x1, ''), -- 87276 +(@CGUID+211, 0, 0x0, 0x100, '18950'), -- 86408 - 18950 - 18950 +(@CGUID+212, 0, 0x0, 0x100, '18950'), -- 86413 - 18950 - 18950 +(@CGUID+213, 0, 0x0, 0x101, ''), -- 86408 +(@CGUID+214, 0, 0x0, 0x1, '163207'), -- 86432 - 163207 - 163207 +(@CGUID+215, 0, 0x0, 0x101, '18950'), -- 86413 - 18950 - 18950 +(@CGUID+216, 0, 0x0, 0x1, ''), -- 88230 +(@CGUID+217, 0, 0x0, 0x101, '18950'), -- 86408 - 18950 - 18950 +(@CGUID+218, 0, 0x0, 0x101, '18950'), -- 86413 - 18950 - 18950 +(@CGUID+219, 0, 0x0, 0x101, '18950'), -- 86408 - 18950 - 18950 +(@CGUID+220, 0, 0x0, 0x100, '18950'), -- 86438 - 18950 - 18950 +(@CGUID+221, 0, 0x0, 0x1, ''), -- 85962 +(@CGUID+222, 0, 0x0, 0x1, ''), -- 86175 +(@CGUID+223, 0, 0x0, 0x101, '18950'), -- 86408 - 18950 - 18950 +(@CGUID+224, 0, 0x0, 0x1, ''), -- 86087 +(@CGUID+225, 0, 0x0, 0x1, ''), -- 86176 +(@CGUID+226, 0, 0x0, 0x101, '18950'), -- 86413 - 18950 - 18950 +(@CGUID+227, 0, 0x0, 0x1, ''), -- 85961 +(@CGUID+228, 0, 0x0, 0x1, ''), -- 87063 +(@CGUID+229, 0, 0x0, 0x0, '171989'), -- 88215 - 171989 - 171989 +(@CGUID+230, 0, 0x0, 0x1, '171980'), -- 35845 - 171980 - 171980 +(@CGUID+231, 0, 0x0, 0x1, ''), -- 93906 +(@CGUID+232, 0, 0x0, 0x1, ''), -- 86178 +(@CGUID+233, 0, 0x0, 0x1, '171984'), -- 85911 - 171984 - 171984 +(@CGUID+234, 0, 0x0, 0x1, '171981'), -- 35845 - 171981 - 171981 +(@CGUID+235, 0, 0x0, 0x1, '171962'), -- 35845 - 171962 - 171962 +(@CGUID+236, 0, 0x0, 0x1, ''), -- 88254 +(@CGUID+237, 0, 0x0, 0x101, ''), -- 86408 +(@CGUID+238, 0, 0x0, 0x1, ''), -- 88211 +(@CGUID+239, 0, 0x0, 0x1, ''), -- 88214 +(@CGUID+240, 0, 0x0, 0x1, ''), -- 88076 +(@CGUID+241, 0, 0x0, 0x1, ''), -- 88076 +(@CGUID+242, 0, 0x0, 0x1, ''), -- 88077 +(@CGUID+243, 0, 0x0, 0x1, ''), -- 88075 +(@CGUID+244, 0, 0x0, 0x1, ''), -- 88076 +(@CGUID+245, 0, 0x0, 0x1, ''), -- 88075 +(@CGUID+246, 0, 0x0, 0x1, ''), -- 88077 +(@CGUID+247, 0, 0x0, 0x1, ''), -- 88076 +(@CGUID+248, 0, 0x0, 0x1, ''), -- 88075 +(@CGUID+249, 0, 0x0, 0x1, ''), -- 88077 +(@CGUID+250, 0, 0x0, 0x1, ''), -- 88076 +(@CGUID+251, 0, 0x0, 0x1, ''), -- 88077 +(@CGUID+252, 0, 0x0, 0x1, ''), -- 88076 +(@CGUID+253, 0, 0x0, 0x1, ''), -- 88076 +(@CGUID+254, 0, 0x0, 0x1, ''), -- 88076 +(@CGUID+255, 0, 0x0, 0x1, ''), -- 87329 +(@CGUID+256, 0, 0x0, 0x1, ''), -- 88212 +(@CGUID+257, 0, 0x0, 0x1, ''), -- 87318 +(@CGUID+258, 0, 0x0, 0x1, ''), -- 87320 +(@CGUID+259, 0, 0x0, 0x1, ''), -- 87318 +(@CGUID+260, 0, 0x0, 0x100, '18950'), -- 86436 - 18950 - 18950 +(@CGUID+261, 0, 0x0, 0x1, '167347'), -- 87321 - 167347 - 167347 +(@CGUID+262, 0, 0x0, 0x102, '18950'), -- 86413 - 18950 - 18950 +(@CGUID+263, 0, 0x0, 0x102, '18950'), -- 86408 - 18950 - 18950 +(@CGUID+264, 0, 0x0, 0x1, ''), -- 87322 +(@CGUID+265, 0, 0x0, 0x1, '167347'), -- 87321 - 167347 - 167347 +(@CGUID+266, 0, 0x0, 0x102, '18950'), -- 86408 - 18950 - 18950 +(@CGUID+267, 0, 0x0, 0x100, '18950'), -- 86413 - 18950 - 18950 +(@CGUID+268, 0, 0x0, 0x1, ''), -- 93907 +(@CGUID+269, 0, 0x0, 0x101, ''), -- 86413 +(@CGUID+270, 0, 0x0, 0x101, '18950'), -- 86413 - 18950 - 18950 +(@CGUID+271, 0, 0x0, 0x1, '164310'), -- 82876 - 164310 - 164310 +(@CGUID+272, 0, 0x2000000, 0x1, '164310'), -- 88975 - 164310 - 164310 +(@CGUID+273, 0, 0x0, 0x0, '164310 175121'), -- 86087 - 164310 - 164310, 175121 - 175121 +(@CGUID+274, 0, 0x0, 0x1, '164310 104945'), -- 85445 - 164310 - 164310, 104945 - 104945 +(@CGUID+275, 0, 0x2000000, 0x1, '164310'), -- 88975 - 164310 - 164310 +(@CGUID+276, 0, 0x0, 0x1, '164310 18950'), -- 86829 - 164310 - 164310, 18950 - 18950 +(@CGUID+277, 0, 0x0, 0x101, ''), -- 86413 +(@CGUID+278, 0, 0x0, 0x1, ''), -- 88076 +(@CGUID+279, 0, 0x0, 0x1, ''), -- 88076 +(@CGUID+280, 0, 0x0, 0x1, ''); -- 88076 + +-- Gameobjects +SET @OGUID := 222184; +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+108; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES +(@OGUID+0, 237289, 1116, 3, 1, 3712.722, -3942.811, 25.6729, 2.984498, 0, 0, 0, 1, 7200, 255, 1), -- 237289 (Area: -1) +(@OGUID+1, 236219, 1116, 3, 1, 3766.323, -3946.451, 27.75305, 2.687807, 0, 0, 0.9999619, -0.00872653, 7200, 255, 1), -- 236219 (Area: -1) +(@OGUID+2, 228642, 1116, 3, 1, 3719.528, -3957.259, 26.3751, 2.35619, 0, 0, 0.9238795, 0.3826836, 7200, 255, 1), -- 228642 (Area: -1) +(@OGUID+3, 228646, 1116, 3, 1, 3729.605, -3952.789, 26.36808, 3.220161, 0, 0, 0.9238795, 0.3826836, 7200, 255, 1), -- 228646 (Area: -1) +(@OGUID+4, 228644, 1116, 3, 1, 3725.94, -3948.21, 26.46557, 3.647741, 0, 0, 0.9238795, 0.3826836, 7200, 255, 1), -- 228644 (Area: -1) +(@OGUID+5, 228651, 1116, 3, 1, 3725.775, -3954.021, 26.40886, 5.479995, 0, 0, 0.9238795, 0.3826836, 7200, 255, 1), -- 228651 (Area: -1) +(@OGUID+6, 228649, 1116, 3, 1, 3719.482, -3952.531, 26.42297, 2.347464, 0, 0, 0.9238795, 0.3826836, 7200, 255, 1), -- 228649 (Area: -1) +(@OGUID+7, 228653, 1116, 3, 1, 3726.856, -3956.473, 27.00985, 2.495818, 0, 0, 0.9238795, 0.3826836, 7200, 255, 1), -- 228653 (Area: -1) +(@OGUID+8, 237290, 1116, 3, 1, 3692.521, -3968.55, 25.51497, 2.321287, 0, 0, 0, 1, 7200, 255, 1), -- 237290 (Area: -1) +(@OGUID+9, 237291, 1116, 3, 1, 3688.381, -3968.734, 25.86894, 1.832595, 0, 0, 0, 1, 7200, 255, 1), -- 237291 (Area: -1) +(@OGUID+10, 236979, 1116, 3, 1, 3675.977, -3960.32, 26.11188, 5.616546, 0, 0, 0, 1, 7200, 255, 1), -- 236979 (Area: -1) +(@OGUID+11, 238944, 1116, 3, 1, 3742.086, -3977.536, 26.98307, 5.916668, 0, 0, 0, 1, 7200, 255, 1), -- 238944 (Area: -1) +(@OGUID+12, 238667, 1116, 3, 1, 3708.967, -3980.469, 27.89643, 0.9512032, 0, 0, 0, 1, 7200, 255, 1), -- 238667 (Area: -1) +(@OGUID+13, 237366, 1116, 3, 1, 3634.048, -3917.943, 17.69506, 3.892087, 0, 0, 0, 1, 7200, 255, 1), -- 237366 (Area: -1) +(@OGUID+14, 237367, 1116, 3, 1, 3635.971, -3928.503, 17.69506, 2.705255, 0, 0, 0, 1, 7200, 255, 1), -- 237367 (Area: -1) +(@OGUID+15, 237365, 1116, 3, 1, 3627.208, -3915.228, 17.69506, 4.616396, 0, 0, 0, 1, 7200, 255, 1), -- 237365 (Area: -1) +(@OGUID+16, 237369, 1116, 3, 1, 3629.724, -3923.951, 18.69327, 0.2007113, 0, 0, 0, 1, 7200, 255, 1), -- 237369 (Area: -1) +(@OGUID+17, 239438, 1116, 3, 1, 3675.356, -3978.703, 24.93131, 4.025538, 0, 0, 0, 1, 7200, 255, 1), -- 239438 (Area: -1) +(@OGUID+18, 237334, 1116, 3, 1, 3652.36, -3852.036, 45.22106, 2.098934, 0, 0, 0, 1, 7200, 255, 1), -- 237334 (Area: -1) +(@OGUID+19, 238945, 1116, 3, 1, 3715.387, -3985.887, 27.81799, 5.663594, 0, 0, 0, 1, 7200, 255, 1), -- 238945 (Area: -1) +(@OGUID+20, 237364, 1116, 3, 1, 3623.293, -3915.677, 17.69506, 5.05273, 0, 0, 0, 1, 7200, 255, 1), -- 237364 (Area: -1) +(@OGUID+21, 232558, 1116, 3, 1, 3562.155, -3863.967, 0.6985088, 1.263741, 0, 0, 0, 1, 7200, 255, 1), -- 232558 (Area: -1) +(@OGUID+22, 237259, 1116, 3, 1, 3591.64, -3921.007, 20.20557, 0.06981169, 0, 0, 0, 1, 7200, 255, 1), -- 237259 (Area: -1) +(@OGUID+23, 236818, 1116, 3, 1, 3578.33, -3940.591, 22.74113, 3.272519, 0, 0, 0.07845897, 0.9969173, 7200, 255, 1), -- 236818 (Area: -1) +(@OGUID+24, 236816, 1116, 3, 1, 3571.197, -3938.349, 22.74113, 0.157079, 0, 0, 0.07845897, 0.9969173, 7200, 255, 1), -- 236816 (Area: -1) +(@OGUID+25, 236817, 1116, 3, 1, 3573.808, -3943.912, 22.74113, 1.710422, 0, 0, 0.07845897, 0.9969173, 7200, 255, 1), -- 236817 (Area: -1) +(@OGUID+26, 233472, 1116, 3, 1, 3561.893, -3865.815, 7.082714, 2.975771, 0, 0, -0.08715588, 0.9961947, 7200, 255, 1), -- 233472 (Area: -1) +(@OGUID+27, 233478, 1116, 3, 1, 3566.03, -3877.865, 13.57573, 4.747296, 0, 0, -0.08715588, 0.9961947, 7200, 255, 1), -- 233478 (Area: -1) +(@OGUID+28, 236807, 1116, 3, 1, 3564.417, -3918.133, 22.74112, 4.904376, 0, 0, 0.07845897, 0.9969173, 7200, 255, 1), -- 236807 (Area: -1) +(@OGUID+29, 233477, 1116, 3, 1, 3563.093, -3879.24, 13.57573, 5.550147, 0, 0, -0.08715588, 0.9961947, 7200, 255, 1), -- 233477 (Area: -1) +(@OGUID+30, 233467, 1116, 3, 1, 3559.2, -3874.342, 6.984805, 2.626719, 0, 0, -0.08715588, 0.9961947, 7200, 255, 1), -- 233467 (Area: -1) +(@OGUID+31, 233470, 1116, 3, 1, 3565.229, -3863.858, 7.258985, 4.005531, 0, 0, -0.08715588, 0.9961947, 7200, 255, 1), -- 233470 (Area: -1) +(@OGUID+32, 233471, 1116, 3, 1, 3566.593, -3865.618, 7.181748, 3.289961, 0, 0, -0.08715588, 0.9961947, 7200, 255, 1), -- 233471 (Area: -1) +(@OGUID+33, 233468, 1116, 3, 1, 3563.361, -3879.292, 7.290303, 2.452184, 0, 0, -0.08715588, 0.9961947, 7200, 255, 1), -- 233468 (Area: -1) +(@OGUID+34, 237260, 1116, 3, 1, 3576.398, -3868.54, 6.930298, 5.497789, 0, 0, 0, 1, 7200, 255, 1), -- 237260 (Area: -1) +(@OGUID+35, 238947, 1116, 3, 1, 3587.573, -3879.118, 6.944018, 6.152286, 0, 0, 0, 1, 7200, 255, 1), -- 238947 (Area: -1) +(@OGUID+36, 236833, 1116, 3, 1, 3560.863, -3870.212, 3.465781, 4.273968, 0, 0, 0, 1, 7200, 255, 1), -- 236833 (Area: -1) +(@OGUID+37, 236801, 1116, 3, 1, 3561.033, -3925.169, 22.61638, 3.289961, 0, 0, 0.07845897, 0.9969173, 7200, 255, 1), -- 236801 (Area: -1) +(@OGUID+38, 236831, 1116, 3, 1, 3556.872, -3869.424, 3.958034, 1.289737, 0, 0, 0, 1, 7200, 255, 1), -- 236831 (Area: -1) +(@OGUID+39, 233473, 1116, 3, 1, 3554.134, -3873.027, 6.984805, 5.663594, 0, 0, -0.08715588, 0.9961947, 7200, 255, 1), -- 233473 (Area: -1) +(@OGUID+40, 236831, 1116, 3, 1, 3560.727, -3870.16, 3.967618, 1.402912, 0, 0, 0, 1, 7200, 255, 1), -- 236831 (Area: -1) +(@OGUID+41, 233463, 1116, 3, 1, 3558.104, -3860.308, 13.72062, 5.384341, 0, 0, -0.08715588, 0.9961947, 7200, 255, 1), -- 233463 (Area: -1) +(@OGUID+42, 236835, 1116, 3, 1, 3558.45, -3864.495, 2.118465, 2.285846, 0, 0, 0, 1, 7200, 255, 1), -- 236835 (Area: -1) +(@OGUID+43, 236810, 1116, 3, 1, 3564.683, -3920.313, 22.74112, 4.415683, 0, 0, 0.07845897, 0.9969173, 7200, 255, 1), -- 236810 (Area: -1) +(@OGUID+44, 233466, 1116, 3, 1, 3556.926, -3871.575, 6.984805, 4.73857, 0, 0, -0.08715588, 0.9961947, 7200, 255, 1), -- 233466 (Area: -1) +(@OGUID+45, 236808, 1116, 3, 1, 3562.685, -3920.728, 22.61504, 5.838127, 0, 0, 0.07845897, 0.9969173, 7200, 255, 1), -- 236808 (Area: -1) +(@OGUID+46, 233480, 1116, 3, 1, 3555.012, -3873.117, 13.57573, 6.073746, 0, 0, -0.08715588, 0.9961947, 7200, 255, 1), -- 233480 (Area: -1) +(@OGUID+47, 236809, 1116, 3, 1, 3564.625, -3922.291, 22.74112, 2.635444, 0, 0, 0.07845897, 0.9969173, 7200, 255, 1), -- 236809 (Area: -1) +(@OGUID+48, 233465, 1116, 3, 1, 3556.616, -3866.248, 6.984805, 2.923416, 0, 0, -0.08715588, 0.9961947, 7200, 255, 1), -- 233465 (Area: -1) +(@OGUID+49, 236821, 1116, 3, 1, 3560.855, -3864.823, 1.985308, 3.725472, 0, 0, 0, 1, 7200, 255, 1), -- 236821 (Area: -1) +(@OGUID+50, 236836, 1116, 3, 1, 3556.194, -3869.891, 4.152313, 0.5882603, 0, 0, 0, 1, 7200, 255, 1), -- 236836 (Area: -1) +(@OGUID+51, 233469, 1116, 3, 1, 3562.424, -3862.977, 7.000779, 2.975771, 0, 0, -0.08715588, 0.9961947, 7200, 255, 1), -- 233469 (Area: -1) +(@OGUID+52, 236831, 1116, 3, 1, 3558.214, -3869.695, 3.930408, 1.402912, 0, 0, 0, 1, 7200, 255, 1), -- 236831 (Area: -1) +(@OGUID+53, 236831, 1116, 3, 1, 3559.435, -3869.88, 3.907708, 1.402912, 0, 0, 0, 1, 7200, 255, 1), -- 236831 (Area: -1) +(@OGUID+54, 236830, 1116, 3, 1, 3561.428, -3863.339, 2.016999, 2.992223, 0, 0, 0, 1, 7200, 255, 1), -- 236830 (Area: -1) +(@OGUID+55, 236834, 1116, 3, 1, 3556.827, -3869.505, 3.958173, 6.095934, 0, 0, 0, 1, 7200, 255, 1), -- 236834 (Area: -1) +(@OGUID+56, 236832, 1116, 3, 1, 3558.184, -3869.832, 3.889264, 2.876967, 0, 0, 0, 1, 7200, 255, 1), -- 236832 (Area: -1) +(@OGUID+57, 236822, 1116, 3, 1, 3561.438, -3863.226, 2.431574, 6.130832, 0, 0, 0, 1, 7200, 255, 1), -- 236822 (Area: -1) +(@OGUID+58, 236802, 1116, 3, 1, 3561.749, -3929.665, 22.61638, 3.289961, 0, 0, 0.07845897, 0.9969173, 7200, 255, 1), -- 236802 (Area: -1) +(@OGUID+59, 236824, 1116, 3, 1, 3552.728, -3866.25, 2.848553, 0.2215047, 0, 0, 0, 1, 7200, 255, 1), -- 236824 (Area: -1) +(@OGUID+60, 233474, 1116, 3, 1, 3548.917, -3873.999, 7.55154, 2.967041, 0, 0, -0.08715588, 0.9961947, 7200, 255, 1), -- 233474 (Area: -1) +(@OGUID+61, 236803, 1116, 3, 1, 3562.921, -3936.102, 22.61638, 3.289961, 0, 0, 0.07845897, 0.9969173, 7200, 255, 1), -- 236803 (Area: -1) +(@OGUID+62, 236825, 1116, 3, 1, 3552.76, -3865.408, 1.898684, 0.7732886, 0, 0, 0, 1, 7200, 255, 1), -- 236825 (Area: -1) +(@OGUID+63, 233475, 1116, 3, 1, 3548.525, -3875.608, 7.55154, 2.862335, 0, 0, -0.08715588, 0.9961947, 7200, 255, 1), -- 233475 (Area: -1) +(@OGUID+64, 236800, 1116, 3, 1, 3557.537, -3930.434, 22.61638, 0.157079, 0, 0, 0.07845897, 0.9969173, 7200, 255, 1), -- 236800 (Area: -1) +(@OGUID+65, 233479, 1116, 3, 1, 3548.939, -3875.401, 13.57573, 3.263772, 0, 0, -0.08715588, 0.9961947, 7200, 255, 1), -- 233479 (Area: -1) +(@OGUID+66, 233476, 1116, 3, 1, 3548.98, -3872.395, 7.55154, 3.097919, 0, 0, -0.08715588, 0.9961947, 7200, 255, 1), -- 233476 (Area: -1) +(@OGUID+67, 233464, 1116, 3, 1, 3554.198, -3864.263, 7.006247, 5.349435, 0, 0, -0.08715588, 0.9961947, 7200, 255, 1), -- 233464 (Area: -1) +(@OGUID+68, 233481, 1116, 3, 1, 3553.21, -3864.422, 0.7477322, 6.108654, 0, 0, -0.08715588, 0.9961947, 7200, 255, 1), -- 233481 (Area: -1) +(@OGUID+69, 236827, 1116, 3, 1, 3552.82, -3863.453, 3.640825, 4.629312, 0, 0, 0, 1, 7200, 255, 1), -- 236827 (Area: -1) +(@OGUID+70, 236799, 1116, 3, 1, 3556.837, -3925.894, 22.61638, 0.157079, 0, 0, 0.07845897, 0.9969173, 7200, 255, 1), -- 236799 (Area: -1) +(@OGUID+71, 232978, 1116, 3, 1, 3552.788, -3863.439, 0.3393671, 0.3733751, 0, 0, 0, 1, 7200, 255, 1), -- 232978 (Area: -1) +(@OGUID+72, 236806, 1116, 3, 1, 3559.18, -3940.938, 22.61638, 0.157079, 0, 0, 0.07845897, 0.9969173, 7200, 255, 1), -- 236806 (Area: -1) +(@OGUID+73, 236804, 1116, 3, 1, 3563.6, -3940.544, 22.61638, 3.289961, 0, 0, 0.07845897, 0.9969173, 7200, 255, 1), -- 236804 (Area: -1) +(@OGUID+74, 237334, 1116, 3, 1, 3540.506, -3866.036, 7.330563, 2.098934, 0, 0, 0, 1, 7200, 255, 1), -- 237334 (Area: -1) +(@OGUID+75, 236805, 1116, 3, 1, 3558.528, -3936.545, 22.61638, 0.157079, 0, 0, 0.07845897, 0.9969173, 7200, 255, 1), -- 236805 (Area: -1) +(@OGUID+76, 236811, 1116, 3, 1, 3551.807, -3926.117, 22.74112, 5.044002, 0, 0, 0.07845897, 0.9969173, 7200, 255, 1), -- 236811 (Area: -1) +(@OGUID+77, 236814, 1116, 3, 1, 3553.455, -3935.555, 22.74112, 5.087634, 0, 0, 0.07845897, 0.9969173, 7200, 255, 1), -- 236814 (Area: -1) +(@OGUID+78, 236815, 1116, 3, 1, 3553.837, -3938.434, 22.74112, 1.658062, 0, 0, 0.07845897, 0.9969173, 7200, 255, 1), -- 236815 (Area: -1) +(@OGUID+79, 236812, 1116, 3, 1, 3553.567, -3927.67, 22.74112, 3.159062, 0, 0, 0.07845897, 0.9969173, 7200, 255, 1), -- 236812 (Area: -1) +(@OGUID+80, 236813, 1116, 3, 1, 3552.205, -3929.274, 22.74112, 1.361356, 0, 0, 0.07845897, 0.9969173, 7200, 255, 1), -- 236813 (Area: -1) +(@OGUID+81, 236408, 1116, 3, 1, 3930.365, -4079.094, 54.81159, 4.852017, 0, 0, 0.0697564, 0.9975641, 7200, 255, 1), -- 236408 (Area: -1) +(@OGUID+82, 236409, 1116, 3, 1, 3940.337, -4085.418, 54.81159, 0.1396245, 0, 0, 0.0697564, 0.9975641, 7200, 255, 1), -- 236409 (Area: -1) +(@OGUID+83, 225789, 1116, 3, 1, 3634.115, -4077.51, 6.600395, 2.041754, 0, 0, 0.8503523, 0.5262139, 7200, 255, 1), -- 225789 (Area: -1) +(@OGUID+84, 239439, 1116, 3, 1, 3613.542, -4061.137, 6.84041, 4.025538, 0, 0, 0, 1, 7200, 255, 1), -- 239439 (Area: -1) +(@OGUID+85, 238946, 1116, 3, 1, 3612.409, -4050.986, 6.841034, 3.019413, 0, 0, 0, 1, 7200, 255, 1), -- 238946 (Area: -1) +(@OGUID+86, 236184, 1116, 3, 1, 3688.267, -3968.587, 27.15407, 3.962348, 0, 0, 0, 1, 7200, 255, 1), -- 236184 (Area: -1) +(@OGUID+87, 235883, 1116, 3, 1, 3734.65, -4042.976, 44.81873, 0.9957945, 0, 0, 0, 1, 7200, 255, 1), -- 235883 (Area: -1) +(@OGUID+88, 237258, 1116, 3, 1, 3731.611, -3911.399, 30.58554, 3.036848, 0, 0, 0, 1, 7200, 255, 1), -- 237258 (Area: -1) +(@OGUID+89, 236994, 1116, 3, 1, 3753.118, -4064.017, 67.21985, 4.502952, 0, 0, 0.985556, 0.1693497, 7200, 255, 1), -- 236994 (Area: -1) +(@OGUID+90, 236993, 1116, 3, 1, 3750.534, -4065.465, 67.21985, 6.178466, 0, 0, 0.985556, 0.1693497, 7200, 255, 1), -- 236993 (Area: -1) +(@OGUID+91, 238668, 1116, 3, 1, 3804.154, -4064.724, 30.8368, 1.719148, 0, 0, 0, 1, 7200, 255, 1), -- 238668 (Area: -1) +(@OGUID+92, 239274, 1116, 3, 1, 3910.294, -4082.043, 75.77363, 0.1396245, 0, 0, 0.0697564, 0.9975641, 7200, 255, 1), -- 239274 (Area: -1) +(@OGUID+93, 239275, 1116, 3, 1, 3911.851, -4093.42, 75.77222, 0.1396245, 0, 0, 0.0697564, 0.9975641, 7200, 255, 1), -- 239275 (Area: -1) +(@OGUID+94, 239272, 1116, 3, 1, 3924.452, -4073.815, 54.74227, 4.843289, 0, 0, 0.0697564, 0.9975641, 7200, 255, 1), -- 239272 (Area: -1) +(@OGUID+95, 239273, 1116, 3, 1, 3922.341, -4083.593, 54.75831, 0.157079, 0, 0, 0.0697564, 0.9975641, 7200, 255, 1), -- 239273 (Area: -1) +(@OGUID+96, 239278, 1116, 3, 1, 3927.684, -4081.804, 66.53002, 1.692969, 0, 0, 0.0697564, 0.9975641, 7200, 255, 1), -- 239278 (Area: -1) +(@OGUID+97, 239277, 1116, 3, 1, 3931.98, -4081.201, 66.53002, 1.692969, 0, 0, 0.0697564, 0.9975641, 7200, 255, 1), -- 239277 (Area: -1) +(@OGUID+98, 239282, 1116, 3, 1, 3933.28, -4091.856, 66.53002, 1.710422, 0, 0, 0.0697564, 0.9975641, 7200, 255, 1), -- 239282 (Area: -1) +(@OGUID+99, 239280, 1116, 3, 1, 3926.953, -4078.124, 66.53002, 4.869471, 0, 0, 0.0697564, 0.9975641, 7200, 255, 1), -- 239280 (Area: -1) +(@OGUID+100, 239281, 1116, 3, 1, 3928.906, -4092.492, 66.53002, 1.710422, 0, 0, 0.0697564, 0.9975641, 7200, 255, 1), -- 239281 (Area: -1) +(@OGUID+101, 239284, 1116, 3, 1, 3932.654, -4088.115, 66.53002, 4.860743, 0, 0, 0.0697564, 0.9975641, 7200, 255, 1), -- 239284 (Area: -1) +(@OGUID+102, 239285, 1116, 3, 1, 3928.182, -4088.779, 66.53002, 4.860743, 0, 0, 0.0697564, 0.9975641, 7200, 255, 1), -- 239285 (Area: -1) +(@OGUID+103, 239279, 1116, 3, 1, 3931.452, -4077.488, 66.53002, 4.869471, 0, 0, 0.0697564, 0.9975641, 7200, 255, 1), -- 239279 (Area: -1) +(@OGUID+104, 239421, 1191, 3, 1, 4034.233, -4202.455, 1.836767, 0, 0, 0, 0, 1, 7200, 255, 1), -- 239421 (Area: 7100) +(@OGUID+105, 237727, 1191, 3, 1, 4231.481, -4001.521, 14.92727, 1.599561, 0, 0, 0, 1, 7200, 255, 1), -- 237727 (Area: 7100) +(@OGUID+106, 236408, 1191, 3, 1, 3930.365, -4079.094, 54.81159, 4.852017, 0, 0, 0.0697564, 0.9975641, 7200, 255, 1), -- 236408 (Area: 7100) +(@OGUID+107, 236409, 1191, 3, 1, 3940.337, -4085.418, 54.81159, 0.1396245, 0, 0, 0.0697564, 0.9975641, 7200, 255, 1), -- 236409 (Area: 7100) +(@OGUID+108, 236184, 1116, 3, 1, 3688.267, -3968.587, 27.15407, 3.962348, 0, 0, 0, 1, 7200, 255, 1); -- 236184 (Area: 7332) + +DELETE FROM `creature_equip_template` WHERE `CreatureID` IN (86433, 86436, 86438, 88189, 86182, 85849, 86184, 86388, 91483, 88211, 88212, 87342, 87275, 88214, 88215, 86408, 88155, 86413, 86084, 86087, 88168, 86829, 82876); +INSERT INTO `creature_equip_template` (`CreatureID`, `ItemID1`, `ItemID2`, `ItemID3`) VALUES +(86433, 65492, 0, 110155), -- 86433 +(86436, 65492, 0, 110155), -- 86436 +(86438, 65492, 0, 110155), -- 86438 +(88189, 5598, 0, 0), -- 88189 +(86182, 106254, 0, 0), -- 86182 +(85849, 1911, 0, 0), -- 85849 +(86184, 106881, 0, 0), -- 86184 +(86388, 113114, 0, 113120), -- 86388 +(91483, 119602, 0, 0), -- 91483 +(88211, 31824, 0, 0), -- 88211 +(88212, 31824, 0, 0), -- 88212 +(87342, 65492, 0, 110156), -- 87342 +(87275, 80580, 0, 0), -- 87275 +(88214, 31824, 0, 0), -- 88214 +(88215, 31824, 0, 0), -- 88215 +(86408, 65492, 0, 111717), -- 86408 +(88155, 73474, 0, 73413), -- 88155 +(86413, 65492, 0, 111717), -- 86413 +(86084, 45528, 0, 0), -- 86084 +(86087, 45123, 0, 0), -- 86087 +(88168, 5598, 0, 0), -- 88168 +(86829, 47517, 0, 110155), -- 86829 +(82876, 109639, 0, 109631); -- 82876 |