diff options
| -rw-r--r-- | sql/updates/world/2015_05_10_01_world.sql | 505 |
1 files changed, 505 insertions, 0 deletions
diff --git a/sql/updates/world/2015_05_10_01_world.sql b/sql/updates/world/2015_05_10_01_world.sql new file mode 100644 index 00000000000..ba2dc1516f2 --- /dev/null +++ b/sql/updates/world/2015_05_10_01_world.sql @@ -0,0 +1,505 @@ +SET @CGUID := 370955; +SET @OGUID := 233610; + + +UPDATE `creature_template` SET `InhabitType`=4 WHERE `entry`=67329; + +DELETE FROM `creature` WHERE `id` IN (55475, 56160); +DELETE FROM `gameobject` WHERE `id`=179965; +DELETE FROM `gameobject` WHERE `guid` IN (213585, 213588, 213591, 213610, 213611, 213624, 213625, 213683); + +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+315; +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES +(@CGUID+0, 55347, 974, 1, -3540.458, 6091.649, 3.064309, 2.75752, 120, 0, 0), -- 55347 (Area: 5869) (Auras: 73809 - 73809) +(@CGUID+1, 55347, 974, 1, -3544.965, 6093.71, 4.785177, 2.75752, 120, 0, 0), -- 55347 (Area: 5869) (Auras: 70764 - 70764) +(@CGUID+2, 55347, 974, 1, -3546.406, 6094.889, 3.710032, 2.75752, 120, 0, 0), -- 55347 (Area: 5869) (Auras: 73810 - 73810) +(@CGUID+3, 55347, 974, 1, -3546.455, 6089.76, 5.124798, 2.75752, 120, 0, 0), -- 55347 (Area: 5869) (Auras: 73811 - 73811) +(@CGUID+4, 55347, 974, 1, -3547.651, 6091.432, 4.107487, 2.776647, 120, 0, 0), -- 55347 (Area: 5869) (Auras: 70764 - 70764) +(@CGUID+5, 55347, 974, 1, -3552.378, 6084.578, 4.111493, 2.75752, 120, 0, 0), -- 55347 (Area: 5869) (Auras: 70764 - 70764) +(@CGUID+6, 55347, 974, 1, -3876.087, 6715.112, 3.523933, 2.75752, 120, 0, 0), -- 55347 (Area: 0) (Auras: 73811 - 73811) +(@CGUID+7, 55347, 974, 1, -3876.469, 6713.583, 3.545249, 2.75752, 120, 0, 0), -- 55347 (Area: 0) (Auras: 73810 - 73810) +(@CGUID+8, 55347, 974, 1, -3880.024, 6707.007, 2.658832, 2.164, 120, 0, 0), -- 55347 (Area: 0) (Auras: 73811 - 73811) +(@CGUID+9, 55347, 974, 1, -4018.266, 6363.103, 13.20009, 2.098049, 120, 0, 0), -- 55347 (Area: 5870) (Auras: 73809 - 73809) +(@CGUID+10, 55347, 974, 1, -4018.988, 6366.712, 13.20009, 4.435287, 120, 0, 0), -- 55347 (Area: 5870) (Auras: 70764 - 70764) +(@CGUID+11, 55347, 974, 1, -4021.135, 6365.648, 13.20009, 5.983479, 120, 0, 0), -- 55347 (Area: 5870) (Auras: 73104 - 73104) +(@CGUID+12, 55347, 974, 1, -4046.467, 6351.809, 13.20009, 4.554671, 120, 0, 0), -- 55347 (Area: 5870) (Auras: 73811 - 73811) +(@CGUID+13, 55347, 974, 1, -4046.663, 6348.137, 13.20009, 1.936678, 120, 0, 0), -- 55347 (Area: 5870) (Auras: 70764 - 70764) +(@CGUID+14, 55347, 974, 1, -4048.806, 6351.314, 13.20009, 5.70659, 120, 0, 0), -- 55347 (Area: 5870) (Auras: 73809 - 73809) +(@CGUID+15, 55347, 974, 1, -4085.885, 6320.245, 11.04892, 3.857727, 120, 0, 0), -- 55347 (Area: 5870) (Auras: 73809 - 73809) +(@CGUID+16, 55347, 974, 1, -4087.995, 6321.37, 11.16493, 5.009645, 120, 0, 0), -- 55347 (Area: 5870) (Auras: 73809 - 73809) +(@CGUID+17, 55347, 974, 1, -4088.007, 6318.624, 11.74757, 1.196441, 120, 0, 0), -- 55347 (Area: 5870) (Auras: 70764 - 70764) +(@CGUID+18, 55347, 974, 1, -4397.738, 6259.018, 15.20177, 3.253297, 120, 0, 0), -- 55347 (Area: 5870) (Auras: 73810 - 73810) +(@CGUID+19, 55347, 974, 1, -4398.509, 6262.621, 14.76891, 3.253297, 120, 0, 0), -- 55347 (Area: 5870) (Auras: 73809 - 73809) +(@CGUID+20, 55347, 974, 1, -4399.425, 6416.393, 15.24004, 2.776647, 120, 0, 0), -- 55347 (Area: 5870) (Auras: 73104 - 73104) +(@CGUID+21, 55347, 974, 1, -4399.543, 6260.809, 14.18574, 3.253297, 120, 0, 0), -- 55347 (Area: 5870) (Auras: 73809 - 73809) +(@CGUID+22, 55347, 974, 1, -4399.634, 6403.269, 15.4001, 3.110595, 120, 0, 0), -- 55347 (Area: 5870) (Auras: 73810 - 73810) +(@CGUID+23, 55347, 974, 1, -4399.684, 6400.793, 15.25402, 3.091469, 120, 0, 0), -- 55347 (Area: 5870) (Auras: 73811 - 73811) +(@CGUID+24, 55347, 974, 1, -4400.174, 6390.691, 15.73887, 3.253298, 120, 0, 0), -- 55347 (Area: 5870) (Auras: 73810 - 73810) +(@CGUID+25, 55347, 974, 1, -4400.186, 6388.663, 15.59765, 3.253297, 120, 0, 0), -- 55347 (Area: 5870) (Auras: 70764 - 70764) +(@CGUID+26, 55347, 974, 1, -4400.268, 6261.924, 13.73682, 3.253297, 120, 0, 0), -- 55347 (Area: 5870) (Auras: 73810 - 73810) +(@CGUID+27, 55347, 974, 1, -4400.337, 6263.297, 13.77441, 3.253297, 120, 0, 0), -- 55347 (Area: 5870) (Auras: 73809 - 73809) +(@CGUID+28, 55347, 974, 1, -4400.613, 6416.221, 14.66377, 2.75752, 120, 0, 0), -- 55347 (Area: 5870) (Auras: 73104 - 73104) +(@CGUID+29, 55347, 974, 1, -4401.156, 6389.884, 14.98538, 3.253297, 120, 0, 0), -- 55347 (Area: 5870) (Auras: 70764 - 70764) +(@CGUID+30, 55347, 974, 1, -4401.266, 6386.76, 14.97509, 3.253297, 120, 0, 0), -- 55347 (Area: 5870) (Auras: 73811 - 73811) +(@CGUID+31, 55347, 974, 1, -4401.724, 6399.641, 14.2447, 3.091469, 120, 0, 0), -- 55347 (Area: 5870) (Auras: 73811 - 73811) +(@CGUID+32, 55347, 974, 1, -4401.832, 6413.436, 14.16104, 2.75752, 120, 0, 0), -- 55347 (Area: 5870) (Auras: 73811 - 73811) +(@CGUID+33, 55347, 974, 1, -4401.965, 6391.114, 14.53761, 3.253297, 120, 0, 0), -- 55347 (Area: 5870) (Auras: 73104 - 73104) +(@CGUID+34, 55347, 974, 1, -4402.168, 6387.969, 14.41535, 3.253297, 120, 0, 0), -- 55347 (Area: 5870) (Auras: 73809 - 73809) +(@CGUID+35, 55347, 974, 1, -4402.316, 6415.527, 13.68543, 2.75752, 120, 0, 0), -- 55347 (Area: 5870) (Auras: 70764 - 70764) +(@CGUID+36, 55347, 974, 1, -4402.431, 6413.934, 13.73137, 2.75752, 120, 0, 0), -- 55347 (Area: 5870) (Auras: 73811 - 73811) +(@CGUID+37, 55348, 974, 1, -3543.615, 6081.485, 3.064309, 2.922005, 120, 0, 0), -- 55348 (Area: 5869) (Auras: 73813 - 73813) +(@CGUID+38, 55348, 974, 1, -3545.137, 6091.799, 5.200503, 2.922005, 120, 0, 0), -- 55348 (Area: 5869) (Auras: 73813 - 73813) +(@CGUID+39, 55348, 974, 1, -3547.948, 6092.467, 3.654778, 2.922005, 120, 0, 0), -- 55348 (Area: 5869) (Auras: 73814 - 73814) +(@CGUID+40, 55348, 974, 1, -3549.49, 6085.556, 5.243183, 2.922005, 120, 0, 0), -- 55348 (Area: 5869) (Auras: 73814 - 73814) +(@CGUID+41, 55348, 974, 1, -3550.72, 6085.498, 4.617259, 2.947497, 120, 0, 0), -- 55348 (Area: 5869) (Auras: 73813 - 73813) +(@CGUID+42, 55348, 974, 1, -3551.094, 6088.04, 3.703641, 3.207578, 120, 0, 0), -- 55348 (Area: 5869) (Auras: 73814 - 73814) +(@CGUID+43, 55348, 974, 1, -3552.179, 6086.276, 3.646801, 2.922005, 120, 0, 0), -- 55348 (Area: 5869) (Auras: 71084 - 71084) +(@CGUID+44, 55348, 974, 1, -3873.778, 6715.913, 4.638102, 2.947497, 120, 0, 0), -- 55348 (Area: 0) (Auras: 71084 - 71084) +(@CGUID+45, 55348, 974, 1, -3874.514, 6713.628, 4.461677, 2.922005, 120, 0, 0), -- 55348 (Area: 0) (Auras: 73815 - 73815) +(@CGUID+46, 55348, 974, 1, -3874.882, 6715.642, 4.027105, 2.922005, 120, 0, 0), -- 55348 (Area: 0) (Auras: 73815 - 73815) +(@CGUID+47, 55348, 974, 1, -3875.983, 6712.429, 3.9605, 2.922005, 120, 0, 0), -- 55348 (Area: 0) (Auras: 71084 - 71084) +(@CGUID+48, 55348, 974, 1, -3876.658, 6727.082, 2.908752, 3.207578, 120, 0, 0), -- 55348 (Area: 0) (Auras: 71084 - 71084) +(@CGUID+49, 55348, 974, 1, -4024.365, 6339.249, 13.20009, 3.659704, 120, 0, 0), -- 55348 (Area: 5870) (Auras: 73814 - 73814) +(@CGUID+50, 55348, 974, 1, -4026.936, 6336.401, 13.20008, 1.261948, 120, 0, 0), -- 55348 (Area: 5870) (Auras: 73813 - 73813) +(@CGUID+51, 55348, 974, 1, -4027.979, 6338.556, 13.20009, 5.996943, 120, 0, 0), -- 55348 (Area: 5870) (Auras: 71084 - 71084) +(@CGUID+52, 55348, 974, 1, -4126.009, 6364.827, 10.47646, 3.212799, 120, 0, 0), -- 55348 (Area: 5870) (Auras: 73814 - 73814) +(@CGUID+53, 55348, 974, 1, -4128.361, 6366.359, 10.59303, 4.916115, 120, 0, 0), -- 55348 (Area: 5870) (Auras: 73813 - 73813) +(@CGUID+54, 55348, 974, 1, -4129.24, 6363.924, 10.10825, 0.8572226, 120, 0, 0), -- 55348 (Area: 5870) (Auras: 71084 - 71084) +(@CGUID+55, 55348, 974, 1, -4379.616, 6380.463, 12.01801, 1.850658, 120, 0, 0), -- 55348 (Area: 5870) (Auras: 73813 - 73813) +(@CGUID+56, 55348, 974, 1, -4397.399, 6273.063, 15.19376, 2.947497, 120, 0, 0), -- 55348 (Area: 5870) (Auras: 73814 - 73814) +(@CGUID+57, 55348, 974, 1, -4398.363, 6275.321, 14.73031, 2.947497, 120, 0, 0), -- 55348 (Area: 5870) (Auras: 73815 - 73815) +(@CGUID+58, 55348, 974, 1, -4398.715, 6244.944, 14.6917, 2.947497, 120, 0, 0), -- 55348 (Area: 5870) (Auras: 73815 - 73815) +(@CGUID+59, 55348, 974, 1, -4399.198, 6272.111, 14.19004, 2.947497, 120, 0, 0), -- 55348 (Area: 5870) (Auras: 73815 - 73815) +(@CGUID+60, 55348, 974, 1, -4399.554, 6248.596, 14.33591, 2.947497, 120, 0, 0), -- 55348 (Area: 5870) (Auras: 73813 - 73813) +(@CGUID+61, 55348, 974, 1, -4399.681, 6414.704, 15.16792, 2.922005, 120, 0, 0), -- 55348 (Area: 5870) (Auras: 73813 - 73813) +(@CGUID+62, 55348, 974, 1, -4399.702, 6399.29, 15.23775, 2.922005, 120, 0, 0), -- 55348 (Area: 5870) (Auras: 73813 - 73813) +(@CGUID+63, 55348, 974, 1, -4400.215, 6274.204, 13.71256, 2.947497, 120, 0, 0), -- 55348 (Area: 5870) (Auras: 71084 - 71084) +(@CGUID+64, 55348, 974, 1, -4400.252, 6276.461, 13.76355, 2.947497, 120, 0, 0), -- 55348 (Area: 5870) (Auras: 73814 - 73814) +(@CGUID+65, 55348, 974, 1, -4400.3, 6417.96, 14.81304, 2.947497, 120, 0, 0), -- 55348 (Area: 5870) (Auras: 73814 - 73814) +(@CGUID+66, 55348, 974, 1, -4400.573, 6401.828, 14.71149, 3.541528, 120, 0, 0), -- 55348 (Area: 5870) (Auras: 73815 - 73815) +(@CGUID+67, 55348, 974, 1, -4400.856, 6403.986, 14.89527, 3.281446, 120, 0, 0), -- 55348 (Area: 5870) (Auras: 73813 - 73813) +(@CGUID+68, 55348, 974, 1, -4400.995, 6413.729, 14.62116, 2.922005, 120, 0, 0), -- 55348 (Area: 5870) (Auras: 73813 - 73813) +(@CGUID+69, 55348, 974, 1, -4401.505, 6403.733, 14.34081, 3.255954, 120, 0, 0), -- 55348 (Area: 5870) (Auras: 71084 - 71084) +(@CGUID+70, 55348, 974, 1, -4402.309, 6417.276, 13.71753, 2.922005, 120, 0, 0), -- 55348 (Area: 5870) (Auras: 73813 - 73813) +(@CGUID+71, 55348, 974, 1, -4402.323, 6400.667, 13.79684, 3.255954, 120, 0, 0), -- 55348 (Area: 5870) (Auras: 73815 - 73815) +(@CGUID+72, 55348, 974, 1, -4402.393, 6403.033, 13.79647, 3.255954, 120, 0, 0), -- 55348 (Area: 5870) (Auras: 73814 - 73814) +(@CGUID+73, 55348, 974, 1, -4403.847, 6417.264, 13.19444, 3.207578, 120, 0, 0), -- 55348 (Area: 5870) (Auras: 73813 - 73813) +(@CGUID+74, 55475, 974, 1, -3313.932, 6321.429, -26.46885, 5.073973, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+75, 55475, 974, 1, -3339.386, 6404.537, -27.57644, 5.386951, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+76, 55475, 974, 1, -3346.2, 6351.918, -19.01271, 5.107406, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+77, 55475, 974, 1, -3381.229, 6460.036, -24.86264, 4.886246, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+78, 55475, 974, 1, -3381.477, 6386.271, -23.9986, 1.459757, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+79, 55475, 974, 1, -3402.45, 6342.028, -17.38725, 3.010418, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+80, 55475, 974, 1, -3415.417, 6416.553, -21.49718, 2.96623, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+81, 55475, 974, 1, -3417.408, 6481.66, -23.58585, 3.368099, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+82, 55475, 974, 1, -3426.541, 6212.081, -23.02631, 1.561031, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+83, 55475, 974, 1, -3443.797, 6387.824, 1.670958, 1.845875, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+84, 55475, 974, 1, -3445.322, 6317.903, -2.592931, 0.1023915, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+85, 55475, 974, 1, -3447.342, 6363.225, 1.474651, 0.2970642, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+86, 55475, 974, 1, -3449.624, 6478.326, -7.744728, 2.338469, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+87, 55475, 974, 1, -3452.093, 6508.332, -9.212231, 1.255219, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+88, 55475, 974, 1, -3455.005, 6142.754, -30.86743, 3.929064, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+89, 55475, 974, 1, -3455.513, 6413.271, 2.663992, 4.0767, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+90, 55475, 974, 1, -3465.677, 6562.523, -13.99, 3.568454, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+91, 55475, 974, 1, -3471.428, 6459.488, -0.4364587, 0.3251488, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+92, 55475, 974, 1, -3478.317, 6469.908, 0.4252121, 5.246521, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+93, 55475, 974, 1, -3478.498, 6211.152, -27.73287, 6.228446, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+94, 55475, 974, 1, -3492.434, 6181.876, -31.7241, 2.82975, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+95, 55475, 974, 1, -3510.077, 6521.693, -6.995232, 2.019715, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+96, 55475, 974, 1, -3512.833, 6581.43, -16.43451, 5.336159, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+97, 55475, 974, 1, -3518.728, 6151.486, -35.04684, 5.750471, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+98, 55475, 974, 1, -3521.494, 6653.508, -15.92994, 1.675562, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+99, 55475, 974, 1, -3521.743, 6495.504, -0.2447563, 4.649848, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+100, 55475, 974, 1, -3532.04, 6079.061, -16.22413, 0.1291976, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+101, 55475, 974, 1, -3536.587, 5972.348, -25.70953, 3.983676, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+102, 55475, 974, 1, -3537.634, 6021.59, -12.38275, 3.854601, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+103, 55475, 974, 1, -3548.913, 6681.281, -16.2923, 2.347504, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+104, 55475, 974, 1, -3551.593, 6510.098, 0.6369895, 2.652493, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+105, 55475, 974, 1, -3576.409, 6117.609, -23.30301, 5.360305, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+106, 55475, 974, 1, -3581.899, 6165.564, -9.588398, 1.34465, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+107, 55475, 974, 1, -3583.029, 6653.2, -21.48125, 4.491813, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+108, 55475, 974, 1, -3585.837, 6713.762, -14.28456, 0.6416745, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+109, 55475, 974, 1, -3596.543, 5936.433, -28.12582, 2.927438, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+110, 55475, 974, 1, -3605.443, 6142.803, -1.119677, 1.598133, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+111, 55475, 974, 1, -3612.821, 6038.208, -22.87453, 0.3841309, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+112, 55475, 974, 1, -3612.865, 6753.339, -16.22926, 1.31397, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+113, 55475, 974, 1, -3618.269, 6117.788, -13.03176, 3.322225, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+114, 55475, 974, 1, -3623.945, 6615.721, -19.18533, 4.569964, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+115, 55475, 974, 1, -3636.703, 6153.813, 4.964289, 5.585937, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+116, 55475, 974, 1, -3641.342, 6858.263, -26.42858, 0.7066046, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+117, 55475, 974, 1, -3641.504, 6790.919, -18.86576, 0.5381923, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+118, 55475, 974, 1, -3644.3, 6652.433, 4.033398, 4.237825, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+119, 55475, 974, 1, -3644.798, 6082.059, -20.93716, 1.466425, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+120, 55475, 974, 1, -3645.861, 6883.971, -24.53216, 5.604813, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+121, 55475, 974, 1, -3650.303, 6673.94, 2.73331, 6.145986, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+122, 55475, 974, 1, -3652.542, 6726.625, -11.63122, 6.104555, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+123, 55475, 974, 1, -3653.366, 5959.856, -24.37609, 5.032287, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+124, 55475, 974, 1, -3665.284, 6686.991, 2.432378, 6.197391, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+125, 55475, 974, 1, -3673.565, 6748.247, -3.262143, 2.372767, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+126, 55475, 974, 1, -3682.457, 6819.666, -19.65886, 6.071726, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+127, 55475, 974, 1, -3685.824, 6053.145, -24.17451, 2.395765, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+128, 55475, 974, 1, -3691.061, 6708.265, 5.928362, 5.419367, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+129, 55475, 974, 1, -3696.415, 6854.742, -8.366364, 4.439289, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+130, 55475, 974, 1, -3712.752, 6769.752, 2.053334, 5.838404, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+131, 55475, 974, 1, -3714.802, 6022.569, -25.93663, 2.459033, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+132, 55475, 974, 1, -3718.174, 5984.207, -26.95175, 4.683887, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+133, 55475, 974, 1, -3729.87, 6076.369, -24.28646, 6.236253, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+134, 55475, 974, 1, -3741.677, 6808.621, -8.687475, 6.090551, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+135, 55475, 974, 1, -3749.409, 6019.45, -36.08316, 5.37283, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+136, 55475, 974, 1, -3749.938, 6747.255, 6.14193, 2.438644, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+137, 55475, 974, 1, -3776.875, 6038.385, -28.88736, 4.172343, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+138, 55475, 974, 1, -3781.219, 5985.999, -39.33307, 5.821286, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+139, 55475, 974, 1, -3785.611, 6853.598, -15.78474, 4.187766, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+140, 55475, 974, 1, -3788.819, 6793.6, -0.4130653, 2.948139, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+141, 55475, 974, 1, -3789.902, 5909.818, -34.90617, 1.069579, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+142, 55475, 974, 1, -3810.934, 6811.86, -3.405523, 3.065103, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+143, 55475, 974, 1, -3813.611, 5948.4, -34.03601, 4.259658, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+144, 55475, 974, 1, -3813.683, 6872.369, -16.24017, 5.83448, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+145, 55475, 974, 1, -3814.552, 5884.688, -31.88101, 0.6773392, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+146, 55475, 974, 1, -3815.823, 6756.446, 1.296972, 4.483981, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+147, 55475, 974, 1, -3849.52, 6848.309, -20.27527, 2.141776, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+148, 55475, 974, 1, -3851.174, 5914.97, -36.0111, 3.128898, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+149, 55475, 974, 1, -3851.811, 6790.34, -4.522545, 5.938585, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+150, 55475, 974, 1, -3852.365, 5955.535, -30.07961, 4.60087, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+151, 55475, 974, 1, -3854.069, 6726.759, 1.881665, 2.685318, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+152, 55475, 974, 1, -3876.026, 5977.604, -0.1827965, 0.2051714, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+153, 55475, 974, 1, -3882.063, 5882.401, -38.56639, 2.454017, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+154, 55475, 974, 1, -3886.623, 5815.576, -24.69967, 3.69432, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+155, 55475, 974, 1, -3891.935, 6813.063, -10.62362, 0.3393468, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+156, 55475, 974, 1, -3894.714, 6754.219, 1.289827, 3.004843, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+157, 55475, 974, 1, -3906.745, 5910.939, -28.37907, 2.851631, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+158, 55475, 974, 1, -3913.412, 6713.687, 5.58995, 4.635511, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+159, 55475, 974, 1, -3913.597, 6772.005, -7.913295, 1.181943, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+160, 55475, 974, 1, -3953.432, 5854.966, -24.49787, 2.724988, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+161, 55475, 974, 1, -3959.7, 6762.418, -4.656868, 6.195178, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+162, 55475, 974, 1, -3988.379, 6781.324, -19.78738, 3.959932, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+163, 55475, 974, 1, -4018.686, 5826.519, -24.92917, 1.823595, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+164, 55475, 974, 1, -4024.432, 6748.363, 0.7076148, 6.10209, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+165, 55475, 974, 1, -4048.701, 6780.272, -18.90916, 2.557926, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+166, 55475, 974, 1, -4079.737, 5781.727, -26.12824, 4.066347, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+167, 55475, 974, 1, -4080.309, 6725.129, 5.331882, 5.312101, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+168, 55475, 974, 1, -4085.937, 6746.07, -0.3708534, 4.537604, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+169, 55475, 974, 1, -4093.656, 5817.984, -5.46735, 2.203755, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+170, 55475, 974, 1, -4112.841, 5833.23, 12.42542, 4.525721, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+171, 55475, 974, 1, -4112.922, 5747.69, -25.27915, 2.884766, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+172, 55475, 974, 1, -4129.155, 6718.981, 0.2849679, 6.133136, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+173, 55475, 974, 1, -4145.771, 6705.766, 0.5044689, 2.851631, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+174, 55475, 974, 1, -4149.671, 5828.402, 9.382803, 3.671634, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+175, 55475, 974, 1, -4152.313, 5781.312, -11.43931, 5.392621, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+176, 55475, 974, 1, -4152.74, 5818.351, 5.761734, 2.389332, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+177, 55475, 974, 1, -4187.34, 5743.708, -24.87604, 3.728196, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+178, 55475, 974, 1, -4190.686, 6723.775, -11.94522, 2.42111, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+179, 55475, 974, 1, -4201.589, 5811.902, 3.438561, 2.781221, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+180, 55475, 974, 1, -4203.925, 6697.944, -0.4997884, 5.270574, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+181, 55475, 974, 1, -4213.943, 6751.24, -15.50737, 0.4753325, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+182, 55475, 974, 1, -4216.863, 5806.103, -0.3531361, 1.263399, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+183, 55475, 974, 1, -4222.583, 5783.536, -13.14024, 2.16576, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+184, 55475, 974, 1, -4254.156, 5827.959, 1.856683, 1.32416, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+185, 55475, 974, 1, -4255.951, 6712.135, -1.90819, 4.636142, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+186, 55475, 974, 1, -4280.682, 5781.994, -14.02826, 1.545411, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+187, 55475, 974, 1, -4281.057, 6705.473, 2.382472, 5.3203, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+188, 55475, 974, 1, -4311.102, 5776.852, -17.00743, 2.16313, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+189, 55475, 974, 1, -4318.055, 6752.943, -27.62305, 1.460733, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+190, 55475, 974, 1, -4320.882, 6684.345, 0.8362814, 1.844127, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+191, 55475, 974, 1, -4338.61, 6647.455, 3.207853, 5.542802, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+192, 55475, 974, 1, -4342.684, 6090.946, -4.94941, 3.508136, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+193, 55475, 974, 1, -4346.649, 5826.934, 1.740823, 6.089581, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+194, 55475, 974, 1, -4355.084, 6711.799, -28.20229, 4.021949, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+195, 55475, 974, 1, -4370.53, 6620.04, 2.050148, 6.087829, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+196, 55475, 974, 1, -4372.023, 5829.926, 0.8718023, 5.746428, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+197, 55475, 974, 1, -4385.319, 6681.877, -30.53719, 2.278209, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+198, 55475, 974, 1, -4387.277, 6151.067, 6.017407, 1.865997, 120, 5, 1), -- 55475 (Area: 5870) (Auras: 51583 - 51583) +(@CGUID+199, 55475, 974, 1, -4400.032, 5888.301, 1.06333, 6.147976, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+200, 55475, 974, 1, -4402.498, 6588.392, 0.4260998, 1.354246, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+201, 55475, 974, 1, -4409.666, 6035.662, -14.26149, 6.100359, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+202, 55475, 974, 1, -4411.721, 6646.702, -29.32209, 5.713609, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+203, 55475, 974, 1, -4413.792, 6085.212, -14.79804, 3.423513, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+204, 55475, 974, 1, -4413.849, 6180.515, 5.317835, 5.96668, 120, 5, 1), -- 55475 (Area: 5870) (Auras: 51583 - 51583) +(@CGUID+205, 55475, 974, 1, -4426.176, 6131.366, -9.031806, 1.985053, 120, 5, 1), -- 55475 (Area: 5870) (Auras: 51583 - 51583) +(@CGUID+206, 55475, 974, 1, -4438.476, 6527.181, 2.461359, 0.6478799, 120, 5, 1), -- 55475 (Area: 5904) (Auras: 51583 - 51583) +(@CGUID+207, 55475, 974, 1, -4439.464, 5931.841, -1.091784, 3.802293, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+208, 55475, 974, 1, -4439.572, 6291.448, -1.263654, 2.882133, 120, 5, 1), -- 55475 (Area: 5870) (Auras: 51583 - 51583) +(@CGUID+209, 55475, 974, 1, -4445.36, 6457.672, 1.502735, 5.701409, 120, 5, 1), -- 55475 (Area: 5870) (Auras: 51583 - 51583) +(@CGUID+210, 55475, 974, 1, -4446.387, 6247.357, -5.866472, 1.471781, 120, 5, 1), -- 55475 (Area: 5870) (Auras: 51583 - 51583) +(@CGUID+211, 55475, 974, 1, -4446.448, 5895.423, -2.954503, 1.039438, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+212, 55475, 974, 1, -4447.519, 6617.916, -24.75529, 0.5312068, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+213, 55475, 974, 1, -4448.618, 6556.146, -11.14995, 1.13948, 120, 5, 1), -- 55475 (Area: 5904) (Auras: 51583 - 51583) +(@CGUID+214, 55475, 974, 1, -4450.187, 6192.325, -3.249295, 0.3683649, 120, 5, 1), -- 55475 (Area: 5870) (Auras: 51583 - 51583) +(@CGUID+215, 55475, 974, 1, -4451.172, 5986.111, -24.06742, 1.44293, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+216, 55475, 974, 1, -4455.343, 6392.197, -5.747448, 3.058451, 120, 5, 1), -- 55475 (Area: 5870) (Auras: 51583 - 51583) +(@CGUID+217, 55475, 974, 1, -4462.831, 6435.464, -7.902214, 1.488819, 120, 5, 1), -- 55475 (Area: 5870) (Auras: 51583 - 51583) +(@CGUID+218, 55475, 974, 1, -4477.391, 6353.027, -14.61291, 0.2626663, 120, 5, 1), -- 55475 (Area: 5904) (Auras: 51583 - 51583) +(@CGUID+219, 55475, 974, 1, -4479.241, 6149.872, -14.53582, 5.868609, 120, 5, 1), -- 55475 (Area: 5904) (Auras: 51583 - 51583) +(@CGUID+220, 55475, 974, 1, -4480.217, 6449.47, -14.22352, 3.138663, 120, 5, 1), -- 55475 (Area: 5904) (Auras: 51583 - 51583) +(@CGUID+221, 55475, 974, 1, -4480.83, 6581.086, -24.30691, 0.2072032, 120, 5, 1), -- 55475 (Area: 0) (Auras: 51583 - 51583) +(@CGUID+222, 55475, 974, 1, -4482.029, 6284.627, -14.99236, 0.07706382, 120, 5, 1), -- 55475 (Area: 5870) (Auras: 51583 - 51583) +(@CGUID+223, 55475, 974, 1, -4482.697, 5949.789, -23.48953, 0.9695857, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+224, 55475, 974, 1, -4488.297, 6515.887, -17.99799, 5.806438, 120, 5, 1), -- 55475 (Area: 5904) (Auras: 51583 - 51583) +(@CGUID+225, 55475, 974, 1, -4508.537, 6316.83, -13.48234, 5.84065, 120, 5, 1), -- 55475 (Area: 5904) (Auras: 51583 - 51583) +(@CGUID+226, 55475, 974, 1, -4512.186, 6184.926, -10.88638, 3.63606, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+227, 55475, 974, 1, -4513.816, 6388.617, -11.04589, 4.789019, 120, 5, 1), -- 55475 (Area: 5904) (Auras: 51583 - 51583) +(@CGUID+228, 55475, 974, 1, -4518.161, 6246.943, -13.29661, 3.27717, 120, 5, 1), -- 55475 (Area: 5904) (Auras: 51583 - 51583) +(@CGUID+229, 55475, 974, 1, -4546.214, 6444.699, -17.15788, 2.611551, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+230, 55475, 974, 1, -4578.979, 6450.634, -14.52264, 0.6321713, 120, 5, 1), -- 55475 (Area: 5869) (Auras: 51583 - 51583) +(@CGUID+231, 56160, 974, 1, -3793.068, 6480.5, 18.38577, 0.4216958, 120, 5, 1), -- Moonfang Snarler (Area: 0) +(@CGUID+232, 56160, 974, 1, -3818.889, 6579.251, 13.75474, 5.759191, 120, 5, 1), -- Moonfang Snarler (Area: 0) (possible waypoints or random movement) +(@CGUID+233, 56160, 974, 1, -3844.143, 6465.961, 11.9775, 5.368204, 120, 5, 1), -- Moonfang Snarler (Area: 0) +(@CGUID+234, 56160, 974, 1, -3890.562, 6418.59, 14.22686, 2.802246, 120, 5, 1), -- Moonfang Snarler (Area: 0) (possible waypoints or random movement) +(@CGUID+235, 56160, 974, 1, -3911.653, 6521.509, 15.92983, 0.8102549, 120, 5, 1), -- Moonfang Snarler (Area: 0) +(@CGUID+236, 56160, 974, 1, -3930.605, 6634.611, 10.02799, 5.350228, 120, 5, 1), -- Moonfang Snarler (Area: 0) (Auras: ) (possible waypoints or random movement) +(@CGUID+237, 56160, 974, 1, -3943.391, 6546.864, 13.23347, 4.229451, 120, 5, 1), -- Moonfang Snarler (Area: 0) (possible waypoints or random movement) +(@CGUID+238, 56160, 974, 1, -3950.127, 6492.447, 19.88531, 2.936915, 120, 5, 1), -- Moonfang Snarler (Area: 0) (possible waypoints or random movement) +(@CGUID+239, 56160, 974, 1, -3980.259, 6703.247, 12.42365, 1.112345, 120, 5, 1), -- Moonfang Snarler (Area: 0) (possible waypoints or random movement) +(@CGUID+240, 56160, 974, 1, -3989.167, 6597.694, 17.62722, 4.199048, 120, 5, 1), -- Moonfang Snarler (Area: 0) (possible waypoints or random movement) +(@CGUID+241, 56160, 974, 1, -4037.84, 6541.493, 16.26394, 5.63148, 120, 5, 1), -- Moonfang Snarler (Area: 0) (possible waypoints or random movement) +(@CGUID+242, 56160, 974, 1, -4044.562, 6649.435, 14.87357, 1.629437, 120, 5, 1), -- Moonfang Snarler (Area: 0) (possible waypoints or random movement) +(@CGUID+243, 56160, 974, 1, -4088.994, 6651.294, 13.36706, 4.611228, 120, 5, 1), -- Moonfang Snarler (Area: 0) (possible waypoints or random movement) +(@CGUID+244, 56160, 974, 1, -4093.011, 6064.556, 16.05633, 0.04595588, 120, 5, 1), -- Moonfang Snarler (Area: 0) (possible waypoints or random movement) +(@CGUID+245, 56160, 974, 1, -4134.839, 6585.866, 19.53601, 2.363102, 120, 5, 1), -- Moonfang Snarler (Area: 0) (possible waypoints or random movement) +(@CGUID+246, 56160, 974, 1, -4158.418, 6640.745, 14.95826, 0.9648843, 120, 5, 1), -- Moonfang Snarler (Area: 0) (possible waypoints or random movement) +(@CGUID+247, 56160, 974, 1, -4193.543, 6561.745, 13.59656, 4.542222, 120, 5, 1), -- Moonfang Snarler (Area: 0) (possible waypoints or random movement) +(@CGUID+248, 56160, 974, 1, -4235.783, 6642.862, 14.43218, 5.552404, 120, 5, 1), -- Moonfang Snarler (Area: 0) (possible waypoints or random movement) +(@CGUID+249, 56160, 974, 1, -4278.184, 6608.144, 12.35217, 0.8278429, 120, 5, 1), -- Moonfang Snarler (Area: 0) (possible waypoints or random movement) +(@CGUID+250, 56160, 974, 1, -4349.397, 6576.323, 10.47269, 0.1333266, 120, 5, 1), -- Moonfang Snarler (Area: 0) (possible waypoints or random movement) +(@CGUID+251, 58570, 974, 1, -3984.116, 6292.029, 13.20008, 0, 120, 0, 0), -- 58570 (Area: 0) +(@CGUID+252, 67319, 974, 1, -4185.753, 6373.43, 14.24777, 5.030209, 120, 0, 0), -- 67319 (Area: 5870) (Auras: 132784 - 132784) +(@CGUID+253, 67329, 974, 1, -3607.139, 6278.641, 118.5082, 2.07468, 120, 5, 1), -- 67329 (Area: 5902) +(@CGUID+254, 67329, 974, 1, -3607.957, 6280.623, 118.5163, 0.9793978, 120, 5, 1), -- 67329 (Area: 0) +(@CGUID+255, 67329, 974, 1, -3626.966, 6439.831, 127.972, 5.792733, 120, 5, 1), -- 67329 (Area: 0) (possible waypoints or random movement) +(@CGUID+256, 67329, 974, 1, -3785.221, 6631.773, 53.54256, 5.370472, 120, 5, 1), -- 67329 (Area: 0) +(@CGUID+257, 67329, 974, 1, -3852.511, 6124.995, 112.3432, 5.233043, 120, 5, 1), -- 67329 (Area: 5902) (possible waypoints or random movement) +(@CGUID+258, 67329, 974, 1, -3945.39, 6414.303, 23.3153, 0.5833343, 120, 5, 1), -- 67329 (Area: 0) (possible waypoints or random movement) +(@CGUID+259, 67329, 974, 1, -4041.083, 6079.592, 22.6864, 5.979221, 120, 5, 1), -- 67329 (Area: 0) (possible waypoints or random movement) +(@CGUID+260, 67329, 974, 1, -4058.984, 6446.323, 18.21202, 3.934109, 120, 5, 1), -- 67329 (Area: 5870) (possible waypoints or random movement) +(@CGUID+261, 67329, 974, 1, -4059.942, 5947.325, 108.9655, 4.19373, 120, 5, 1), -- 67329 (Area: 0) (possible waypoints or random movement) +(@CGUID+262, 67329, 974, 1, -4119.329, 6160.051, 21.57265, 4.928595, 120, 5, 1), -- 67329 (Area: 0) (possible waypoints or random movement) +(@CGUID+263, 67329, 974, 1, -4166.705, 5942.068, 120.6176, 4.127467, 120, 5, 1), -- 67329 (Area: 0) (Auras: ) +(@CGUID+264, 67329, 974, 1, -4189.683, 6186.318, 19.26264, 3.188899, 120, 5, 1), -- 67329 (Area: 0) (possible waypoints or random movement) +(@CGUID+265, 67329, 974, 1, -4244.192, 6630.3, 20.72098, 5.278711, 120, 5, 1), -- 67329 (Area: 0) (possible waypoints or random movement) +(@CGUID+266, 67329, 974, 1, -4279.63, 6112.081, 20.84612, 5.602487, 120, 5, 1), -- 67329 (Area: 0) (possible waypoints or random movement) +(@CGUID+267, 67329, 974, 1, -4307.074, 5972.047, 99.51758, 2.038074, 120, 5, 1), -- 67329 (Area: 0) (possible waypoints or random movement) +(@CGUID+268, 67370, 974, 1, -4100.752, 6394.637, 13.20008, 4.967449, 120, 0, 0), -- 67370 (Area: 5870) +(@CGUID+269, 67382, 974, 1, -4102.958, 6394.549, 13.20009, 5.107639, 120, 0, 0), -- 67382 (Area: 5870) (Auras: ) +(@CGUID+270, 67383, 974, 1, -4098.874, 6395.912, 13.20008, 4.63765, 120, 0, 0), -- 67383 (Area: 5870) (Auras: ) +(@CGUID+271, 67384, 974, 1, -4101.963, 6394.777, 14.99535, 5.291093, 120, 0, 0), -- 67384 (Area: 5870) (Auras: ) +(@CGUID+272, 68231, 1113, 1, -6.62993, 3.931655, 1.201352, 1.110579, 120, 0, 0), +(@CGUID+273, 68232, 1113, 1, -6.316076, -3.870045, 1.201352, 2.070338, 120, 0, 0), +(@CGUID+274, 68233, 1113, 1, 6.576322, -3.682104, 1.201352, 4.203295, 120, 0, 0), +(@CGUID+275, 68238, 1113, 1, -0.162043, 7.456628, 1.201352, 0.005866661, 120, 0, 0), +(@CGUID+276, 68238, 1113, 1, 0.2709804, -7.295516, 1.201352, 3.181539, 120, 0, 0), +(@CGUID+277, 68239, 1113, 1, 6.561924, 4.008928, 1.201351, 5.255444, 120, 0, 0), +(@CGUID+278, 68402, 974, 1, -4058.214, 6331.024, 11.71875, 4.595937, 120, 0, 0), -- 68402 (Area: 5870) +(@CGUID+279, 68407, 974, 1, -4042.303, 6313.233, 12.47493, 5.918468, 120, 0, 0), -- 68407 (Area: 5870) (possible waypoints or random movement) +(@CGUID+280, 68426, 974, 1, -4030.906, 6352.476, 13.02155, 0, 120, 0, 0), -- 68426 (Area: 5870) +(@CGUID+281, 68491, 974, 1, -3628.469, 6309.486, 113.2723, 0.8599741, 120, 0, 0), -- 68491 (Area: 5902) +(@CGUID+282, 68491, 974, 1, -3632.155, 6310.541, 113.364, 1.543436, 120, 0, 0), -- 68491 (Area: 5902) +(@CGUID+283, 68491, 974, 1, -4337.907, 6194.252, 13.24175, 0.9702372, 120, 5, 1), -- 68491 (Area: 5870) (possible waypoints or random movement) +(@CGUID+284, 68492, 974, 1, -3630.217, 6310.871, 113.2768, 0.4937948, 120, 0, 0), -- 68492 (Area: 5902) +(@CGUID+285, 71982, 974, 1, -3836.375, 6482.681, 11.89613, 4.776481, 120, 5, 1), -- 71982 (Area: 0) (Auras: 133836 - 133836) (possible waypoints or random movement) +(@CGUID+286, 71982, 974, 1, -4242.462, 6114.348, 10.36993, 1.600085, 120, 5, 1), -- 71982 (Area: 0) (Auras: 133836 - 133836) (possible waypoints or random movement) +(@CGUID+287, 74056, 974, 1, -4417.674, 6358.51, 15.52252, 0.5449456, 120, 0, 0), -- 74056 (Area: 5870) +(@CGUID+288, 74333, 974, 1, -4416.618, 6256.221, 13.9757, 4.707499, 120, 0, 0), -- 74333 (Area: 5870) (Auras: 149665 - 149665) +(@CGUID+289, 74333, 974, 1, -4417.828, 6383.495, 13.50524, 4.797968, 120, 0, 0), -- 74333 (Area: 5870) (Auras: 149665 - 149665) +(@CGUID+290, 74388, 974, 1, -4406.752, 6252.348, 13.97506, 4.602068, 120, 0, 0), -- 74388 (Area: 5870) (Auras: 149746 - 149746, 151532 - 151532) +(@CGUID+291, 74388, 974, 1, -4408.347, 6385.915, 13.50524, 4.725545, 120, 0, 0), -- 74388 (Area: 5870) (Auras: 149746 - 149746, 151532 - 151532) +(@CGUID+292, 74388, 974, 1, -4425.403, 6252.244, 13.97578, 1.542731, 120, 0, 0), -- 74388 (Area: 5870) (Auras: 149746 - 149746, 151532 - 151532) +(@CGUID+293, 74388, 974, 1, -4426.769, 6385.328, 13.50524, 4.653383, 120, 0, 0), -- 74388 (Area: 5870) (Auras: 149746 - 149746, 151532 - 151532) +(@CGUID+294, 85484, 974, 1, -4253.323, 6311.426, 13.59743, 1.876229, 120, 0, 0), -- 85484 (Area: 5870) +(@CGUID+295, 85519, 974, 1, -4091.094, 6390.395, 13.21238, 3.737871, 120, 0, 0), -- 85519 (Area: 5870) +(@CGUID+296, 85522, 974, 1, -4091.582, 6392.194, 13.20008, 3.972317, 120, 0, 0), -- 85522 (Area: 5870) (Auras: ) +(@CGUID+297, 85523, 974, 1, -4089.521, 6388.737, 13.22179, 3.441971, 120, 0, 0), -- 85523 (Area: 5870) (Auras: ) +(@CGUID+298, 85525, 974, 1, -4090.34, 6389.697, 14.96317, 3.592749, 120, 0, 0), -- 85525 (Area: 5870) (Auras: ) +(@CGUID+299, 85531, 974, 1, -3852.58, 5905.405, -67.67389, 1.263545, 120, 0, 0), -- 85531 (Area: 5869) +(@CGUID+300, 85531, 974, 1, -3855.25, 5875.085, -67.02758, 5.784174, 120, 0, 0), -- 85531 (Area: 5869) +(@CGUID+301, 85531, 974, 1, -3858.149, 5898.472, -66.92779, 0.1291031, 120, 0, 0), -- 85531 (Area: 5869) +(@CGUID+302, 85531, 974, 1, -3871.529, 5879.017, -66.34899, 1.548001, 120, 5, 1), -- 85531 (Area: 5869) (possible waypoints or random movement) +(@CGUID+303, 85531, 974, 1, -3875.769, 5902.223, -66.88538, 0.07232627, 120, 5, 1), -- 85531 (Area: 5869) (possible waypoints or random movement) +(@CGUID+304, 85531, 974, 1, -3881.434, 5910.238, -67.00465, 2.112158, 120, 0, 0), -- 85531 (Area: 5869) +(@CGUID+305, 85531, 974, 1, -3884.201, 5910.596, -67.16608, 1.078099, 120, 0, 0), -- 85531 (Area: 5869) +(@CGUID+306, 85531, 974, 1, -3890.763, 5883.829, -66.31542, 3.419037, 120, 5, 1), -- 85531 (Area: 5869) (possible waypoints or random movement) +(@CGUID+307, 85546, 974, 1, -4207.55, 6369.76, 13.17307, 4.783828, 120, 0, 0), -- 85546 (Area: 5870) +(@CGUID+308, 89715, 974, 1, -4033.719, 6289.453, 10.29123, 2.597398, 120, 0, 0), -- 89715 (Area: 5870) (Auras: 46598 - 46598) +(@CGUID+309, 89734, 974, 1, -4408.507, 6273.993, 13.89466, 3.053421, 120, 0, 0), -- 89734 (Area: 5870) (Auras: 152760 - 152760, 151025 - 151025, 179281 - 179281) +(@CGUID+310, 89734, 974, 1, -4409.213, 6366.121, 13.50524, 2.65413, 120, 0, 0), -- 89734 (Area: 5870) (Auras: 152760 - 152760, 151025 - 151025, 179281 - 179281) +(@CGUID+311, 89736, 974, 1, -4424.276, 6273.732, 13.89585, 0.1174422, 120, 0, 0), -- 89736 (Area: 5870) (Auras: 152760 - 152760, 151025 - 151025, 179273 - 179273) +(@CGUID+312, 89736, 974, 1, -4425.772, 6373.782, 13.50524, 5.81508, 120, 0, 0), -- 89736 (Area: 5870) (Auras: 152760 - 152760, 151025 - 151025, 179273 - 179273) +(@CGUID+313, 90148, 974, 1, -4408.144, 6265.778, 13.94807, 2.210808, 120, 0, 0), -- 90148 (Area: 5870) (Auras: 152760 - 152760, 151025 - 151025, 179749 - 179749) +(@CGUID+314, 90148, 974, 1, -4409.493, 6374.835, 13.50524, 3.375472, 120, 0, 0), -- 90148 (Area: 5870) (Auras: 152760 - 152760, 151025 - 151025, 179749 - 179749) +(@CGUID+315, 90473, 974, 1, -4408.952, 6279.205, 14.65031, 3.060221, 120, 0, 0); -- 90473 (Area: 5870) + +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+20; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES +(@OGUID+0, 180859, 974, 1, -3531.196, 6087.679, 6.77413, 0, 0, 0, 0, 1, 120, 255, 1), -- 180859 (Area: 5869) +(@OGUID+1, 180859, 974, 1, -3556.832, 6083.604, 6.774127, 0, 0, 0, 0, 1, 120, 255, 1), -- 180859 (Area: 5869) +(@OGUID+2, 210216, 974, 1, -4204.649, 6709.91, 0, 3.141593, 0, 0, 0, 1, 120, 255, 1), -- 210216 (Area: 0) +(@OGUID+3, 210216, 974, 1, -4418.03, 5864.06, 0, 3.141593, 0, 0, 0, 1, 120, 255, 1), -- 210216 (Area: 5869) +(@OGUID+4, 210216, 974, 1, -4407.03, 6115.59, 0, 3.141593, 0, 0, 0, 1, 120, 255, 1), -- 210216 (Area: 5869) +(@OGUID+5, 210216, 974, 1, -4444.221, 6215.84, 0, 3.141593, 0, 0, 0, 1, 120, 255, 1), -- 210216 (Area: 5869) +(@OGUID+6, 210216, 974, 1, -4457.5, 6366.06, 0, 3.141593, 0, 0, 0, 1, 120, 255, 1), -- 210216 (Area: 5869) +(@OGUID+7, 210216, 974, 1, -4332.729, 6702.681, 0, 3.141593, 0, 0, 0, 1, 120, 255, 1), -- 210216 (Area: 5869) +(@OGUID+8, 210216, 974, 1, -3740.07, 6907.34, 0, 3.141593, 0, 0, 0, 1, 120, 255, 1), -- 210216 (Area: 5869) +(@OGUID+9, 210216, 974, 1, -4399.809, 6618.7, 0, 3.141593, 0, 0, 0, 1, 120, 255, 1), -- 210216 (Area: 0) +(@OGUID+10, 216667, 974, 1, -4447.792, 6329.229, 13.26463, 3.09827, 0, 0, 0, 1, 120, 255, 1), -- 216667 (Area: 5870) +(@OGUID+11, 210107, 974, 1, -4300.848, 6402.788, 16.55586, 3.115388, 0, 0, 0.9999143, 0.01308975, 120, 255, 1), -- 210107 (Area: 5870) +(@OGUID+12, 235370, 974, 1, -4253.208, 6311.089, 13.11677, 1.906481, 0, 0, 0, 1, 120, 255, 1), -- 235370 (Area: 5870) +(@OGUID+13, 216667, 974, 1, -3609.375, 6316.874, 113.1974, 3.09827, 0, 0, 0, 1, 120, 255, 1), -- 216667 (Area: 5902) +(@OGUID+14, 210216, 974, 1, -4014.3, 6763.641, 0, 3.141593, 0, 0, 0, 1, 120, 255, 1), -- 210216 (Area: 0) +(@OGUID+15, 210216, 974, 1, -3941.611, 6769, 0, 3.141593, 0, 0, 0, 1, 120, 255, 1), -- 210216 (Area: 0) +(@OGUID+16, 210216, 974, 1, -3620.46, 6682.721, 0, 3.141593, 0, 0, 0, 1, 120, 255, 1), -- 210216 (Area: 0) +(@OGUID+17, 210216, 974, 1, -3455.5, 6469.79, 0, 3.141593, 0, 0, 0, 1, 120, 255, 1), -- 210216 (Area: 5869) +(@OGUID+18, 210216, 974, 1, -3382.33, 6234.8, 0, 3.141593, 0, 0, 0, 1, 120, 255, 1), -- 210216 (Area: 5869) +(@OGUID+19, 210216, 974, 1, -3579.271, 5992.71, 0, 3.141593, 0, 0, 0, 1, 120, 255, 1), -- 210216 (Area: 5869) +(@OGUID+20, 235637, 974, 1, -3895.724, 5902.836, -54.12026, 5.723681, 0, 0, 0, 1, 120, 255, 1); -- 235637 (Area: 5869) + +DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+299 AND @CGUID+306; +INSERT INTO `creature_addon` (`guid`, `mount`, `bytes1`, `bytes2`, `auras`) VALUES +(@CGUID+299, 0, 0x1, 0x1, ''), +(@CGUID+300, 0, 0x1, 0x1, ''), +(@CGUID+301, 0, 0x3, 0x1, ''), +(@CGUID+302, 0, 0x0, 0x1, ''), +(@CGUID+303, 0, 0x0, 0x1, ''), +(@CGUID+304, 0, 0x1, 0x1, ''), +(@CGUID+305, 0, 0x1, 0x1, ''), +(@CGUID+306, 0, 0x0, 0x1, ''); + +DELETE FROM `creature_template_addon` WHERE `entry` IN (58342, 67319, 67329, 67370, 67382, 67383, 67384, 68231, 68232, 68233, 68238, 68239, 68402, 68407, 68426, 68491, 68492, 71982, 74056, 74333, 74388, 85519, 85522, 85523, 85525, 85546, 89715, 89734, 89736, 90148); +INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `auras`) VALUES +(58342, 0, 0x0, 0x1, ''), -- 58342 +(67319, 0, 0x0, 0x1, '132784'), -- 67319 - 132784 +(67329, 0, 0x3000000, 0x1, ''), -- 67329 +(67370, 0, 0x0, 0x1, ''), -- 67370 +(67382, 0, 0x0, 0x1, ''), -- 67382 +(67383, 0, 0x0, 0x1, ''), -- 67383 +(67384, 0, 0x3000000, 0x1, ''), -- 67384 +(68231, 0, 0x0, 0x1, ''), -- 68231 +(68232, 0, 0x0, 0x1, ''), -- 68232 +(68233, 0, 0x0, 0x1, ''), -- 68233 +(68238, 0, 0x0, 0x1, ''), -- 68238 +(68239, 0, 0x0, 0x1, ''), -- 68239 +(68402, 0, 0x0, 0x1, ''), -- 68402 +(68407, 0, 0x0, 0x1, ''), -- 68407 +(68426, 0, 0x0, 0x1, ''), -- 68426 +(68491, 0, 0x0, 0x1, ''), -- 68491 +(68492, 0, 0x0, 0x1, ''), -- 68492 +(71982, 0, 0x0, 0x1, '133836'), -- 71982 - 133836 +(74056, 0, 0x0, 0x1, ''), -- 74056 +(74333, 0, 0x0, 0x1, '149665'), -- 74333 - 149665 +(74388, 0, 0x0, 0x1, '149746 151532'), -- 74388 - 149746, 151532 +(85519, 2410, 0x0, 0x1, ''), -- 85519 +(85522, 0, 0x0, 0x1, ''), -- 85522 +(85523, 0, 0x0, 0x1, ''), -- 85523 +(85525, 0, 0x3000000, 0x1, ''), -- 85525 +(85546, 0, 0x0, 0x1, ''), -- 85546 +(89715, 0, 0x0, 0x1, '46598'), -- 89715 - 46598 +(89734, 0, 0x0, 0x1, '152760 151025 179281'), -- 89734 - 152760, 151025, 179281 +(89736, 0, 0x0, 0x1, '152760 151025 179273'), -- 89736 - 152760, 151025, 179273 +(90148, 0, 0x0, 0x1, '152760 151025 179749'); -- 90148 - 152760, 151025, 179749 + +DELETE FROM `creature_template_addon` WHERE `entry`=85484; +INSERT INTO `creature_template_addon` (`entry`, `bytes1`, `bytes2`, `emote`) VALUES +(85484, 0, 0x1, 461); -- 85484 + +UPDATE `creature_template` SET `HoverHeight`=1.5 WHERE `entry`=55443; -- Goldwing +UPDATE `creature_template` SET `speed_run`=1, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags2`=67110912, `VehicleId`=2724 WHERE `entry`=68231; -- Carousel Dragon +UPDATE `creature_template` SET `npcflag`=16777216, `speed_run`=1, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags2`=67110912, `VehicleId`=2724 WHERE `entry` IN (68232 /*Carousel Gryphon*/, 68233 /*Carousel Murloc*/, 68238 /*Carousel Rocket*/, 68239 /*Carousel Wyvern*/); +UPDATE `creature_template` SET `npcflag`=1, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048 WHERE `entry` IN (58342 /*Christopher Lesson*/, 68492 /*"Dusty" Brandom*/); +UPDATE `creature_template` SET `npcflag`=128, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048 WHERE `entry`=68402; -- Kae Ti +UPDATE `creature_template` SET `speed_run`=1, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048 WHERE `entry`=68407; -- "Olive" Ya +UPDATE `creature_template` SET `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=33554944, `unit_flags2`=2050 WHERE `entry`=68426; -- [DND] Darkmoon Faire Carousel Bunny +UPDATE `creature_template` SET `speed_walk`=0.666668, `speed_run`=0.8571429, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=33536, `unit_flags2`=2048 WHERE `entry`=67319; -- Darkmoon Hatchling +UPDATE `creature_template` SET `speed_run`=1.142857, `unit_flags`=32768 WHERE `entry`=56160; -- Moonfang Snarler +UPDATE `creature_template` SET `npcflag`=1073741824, `speed_run`=0.8571429, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=512, `unit_flags2`=2048 WHERE `entry`=67329; -- Darkmoon Glowfly +UPDATE `creature_template` SET `npcflag`=3, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=74056; -- -Unknown- +UPDATE `creature_template` SET `npcflag`=16777216, `speed_walk`=0.666668, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=33536, `unit_flags2`=2048 WHERE `entry`=68491; -- Darkmoon Strider +UPDATE `creature_template` SET `speed_run`=0.8571429, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048 WHERE `entry`=67382; -- Fezwick +UPDATE `creature_template` SET `speed_walk`=1.6, `speed_run`=0.8571429, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=33536, `unit_flags2`=2048 WHERE `entry`=67383; -- Honky-Tonk +UPDATE `creature_template` SET `speed_run`=1.428571, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048 WHERE `entry`=67384; -- Judgement +UPDATE `creature_template` SET `speed_walk`=1.6, `speed_run`=1.285714, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=71982; -- Moonfang Dreadhowl +UPDATE `creature_template` SET `minlevel`=95, `maxlevel`=95, `faction`=1555, `npcflag`=130, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048 WHERE `entry`=85484; -- -Unknown- +UPDATE `creature_template` SET `speed_run`=1, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=33587712, `unit_flags2`=2099200 WHERE `entry`=74333; -- -Unknown- +UPDATE `creature_template` SET `gossip_menu_id`=16970, `minlevel`=100, `maxlevel`=100, `npcflag`=3, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=85546; -- -Unknown- +UPDATE `creature_template` SET `maxlevel`=2, `speed_run`=1.190476, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=33554432, `unit_flags2`=4196352 WHERE `entry`=74388; -- -Unknown- +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=1555, `npcflag`=3, `speed_run`=1.385714, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=33536, `unit_flags2`=2048 WHERE `entry`=85519; -- -Unknown- +UPDATE `creature_template` SET `minlevel`=25, `maxlevel`=25, `speed_run`=0.8571429, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048 WHERE `entry` IN (85522 /*-Unknown-*/, 85523 /*-Unknown-*/, 85525 /*-Unknown-*/); +UPDATE `creature_template` SET `minlevel`=100, `maxlevel`=100, `faction`=16, `speed_walk`=0.888888, `speed_run`=1.428571, `BaseAttackTime`=1500, `RangeAttackTime`=2000, `unit_class`=2, `unit_flags`=32832, `unit_flags2`=2048 WHERE `entry`=85531; -- -Unknown- + +DELETE FROM `npc_vendor` WHERE `entry` IN (14846, 56335, 68402, 57983, 85484); +INSERT INTO `npc_vendor` (`entry`, `item`, `slot`, `maxcount`, `ExtendedCost`, `Type`, `VerifiedBuild`) VALUES +-- 56335 +(56335, 122338, 1, 0, 5547, 1, 19865), -- 122338 +(56335, 122339, 2, 0, 5548, 1, 19865), -- 122339 +(56335, 122387, 3, 0, 3806, 1, 19865), -- 122387 +(56335, 122388, 4, 0, 3806, 1, 19865), -- 122388 +(56335, 122381, 5, 0, 3806, 1, 19865), -- 122381 +(56335, 122355, 6, 0, 3806, 1, 19865), -- 122355 +(56335, 122356, 7, 0, 3806, 1, 19865), -- 122356 +(56335, 122379, 8, 0, 3806, 1, 19865), -- 122379 +(56335, 122357, 9, 0, 3806, 1, 19865), -- 122357 +(56335, 122380, 10, 0, 3806, 1, 19865), -- 122380 +(56335, 122382, 11, 0, 3806, 1, 19865), -- 122382 +(56335, 122359, 12, 0, 3806, 1, 19865), -- 122359 +(56335, 122358, 13, 0, 3806, 1, 19865), -- 122358 +(56335, 122383, 14, 0, 3806, 1, 19865), -- 122383 +(56335, 122360, 15, 0, 3806, 1, 19865), -- 122360 +(56335, 122384, 16, 0, 3806, 1, 19865), -- 122384 +(56335, 122350, 17, 0, 3806, 1, 19865), -- 122350 +(56335, 122349, 18, 0, 3811, 1, 19865), -- 122349 +(56335, 122352, 19, 0, 3811, 1, 19865), -- 122352 +(56335, 122354, 20, 0, 3806, 1, 19865), -- 122354 +(56335, 122353, 21, 0, 3811, 1, 19865), -- 122353 +(56335, 122386, 22, 0, 3811, 1, 19865), -- 122386 +(56335, 122351, 23, 0, 3806, 1, 19865), -- 122351 +(56335, 122385, 24, 0, 3806, 1, 19865), -- 122385 +(56335, 122389, 25, 0, 3806, 1, 19865), -- 122389 +(56335, 122362, 26, 0, 3812, 1, 19865), -- 122362 +(56335, 122361, 27, 0, 3812, 1, 19865), -- 122361 +(56335, 122363, 28, 0, 3811, 1, 19865), -- 122363 +(56335, 122390, 29, 0, 3806, 1, 19865), -- 122390 +(56335, 122391, 30, 0, 3806, 1, 19865), -- 122391 +(56335, 122392, 31, 0, 3806, 1, 19865), -- 122392 +-- 68402 +(68402, 92794, 7, 0, 0, 1, 19865), -- 92794 +-- 14846 +(14846, 73766, 1, 0, 3701, 1, 19865), -- 73766 +(14846, 72140, 2, 0, 3701, 1, 19865), -- 72140 +(14846, 91003, 3, 0, 3700, 1, 19865), -- 91003 +(14846, 73764, 4, 0, 3700, 1, 19865), -- 73764 +(14846, 74981, 5, 0, 3700, 1, 19865), -- 74981 +(14846, 73765, 6, 0, 3700, 1, 19865), -- 73765 +(14846, 73762, 7, 0, 3700, 1, 19865), -- 73762 +(14846, 73903, 8, 0, 3700, 1, 19865), -- 73903 +(14846, 73905, 9, 0, 3700, 1, 19865), -- 73905 +-- 85484 +(85484, 116133, 1, 0, 3814, 1, 19865), -- 116133 +(85484, 116052, 2, 0, 3814, 1, 19865), -- 116052 +(85484, 116134, 5, 0, 3813, 1, 19865), -- 116134 +(85484, 116139, 6, 0, 3700, 1, 19865), -- 116139 +(85484, 116138, 7, 0, 5800, 1, 19865); -- 116138 + +DELETE FROM `creature_equip_template` WHERE `CreatureID` IN (74056, 85484, 85519, 90473); +INSERT INTO `creature_equip_template` (`CreatureID`, `ItemID1`, `ItemID2`, `ItemID3`) VALUES +(74056, 110708, 0, 0), -- -Unknown- +(85484, 6235, 0, 0), -- -Unknown- +(85519, 7944, 0, 0), -- -Unknown- +(90473, 110708, 0, 0); -- -Unknown- + +DELETE FROM `gossip_menu` WHERE (`entry`=13019 AND `text_id`=18290) OR (`entry`=16970 AND `text_id`=24702); +INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES +(13019, 18290), -- 54605 +(16970, 24702); -- 85546 + +DELETE FROM `gossip_menu_option` WHERE `menu_id`=16970; +INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `OptionBroadcastTextID`) VALUES +(16970, 0, 0, 'How do I play Firebird''s Challenge?', 87053), -- 85546 +(16970, 1, 0, 'Ready to fly! |cFF0008E8(Darkmoon Game Token)|r', 87062); -- 85546 + +DELETE FROM `npc_text` WHERE `ID` IN (24704, 26114, 18472, 6961, 11538, 18290, 7381, 24702); +INSERT INTO `npc_text` (`ID`, `Probability0`, `BroadcastTextId0`, `Probability1`, `BroadcastTextId1`, `Probability2`, `BroadcastTextId2`, `Probability3`, `BroadcastTextId3`, `Probability4`, `BroadcastTextId4`, `Probability5`, `BroadcastTextId5`, `Probability6`, `BroadcastTextId6`, `Probability7`, `BroadcastTextId7`, `VerifiedBuild`) VALUES +(24704, 1, 87078, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 19865), -- 24704 +(26114, 1, 92741, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 19865), -- 26114 +(18472, 1, 53824, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 19865), -- 18472 +(6961, 1, 9557, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 19865), -- 6961 +(11538, 1, 22574, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 19865), -- 11538 +(18290, 1, 53059, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 19865), -- 18290 +(7381, 1, 10117, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 19865), -- 7381 +(24702, 1, 87077, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 19865); -- 24702 |