diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2016_04_14_01_world.sql | 338 |
1 files changed, 338 insertions, 0 deletions
diff --git a/sql/updates/world/2016_04_14_01_world.sql b/sql/updates/world/2016_04_14_01_world.sql new file mode 100644 index 00000000000..01720b623f9 --- /dev/null +++ b/sql/updates/world/2016_04_14_01_world.sql @@ -0,0 +1,338 @@ +-- +SET @Oguid:=235252; +DELETE FROM `gameobject` WHERE `map`=34; +DELETE FROM `gameobject` WHERE `guid` BETWEEN @Oguid+0 AND @Oguid+33; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(@Oguid+0, 206117, 34, 0, 0, 2, 169, 0, 80.1872, -21.7123, -26.5229, 0.95993, 0, 0, 0.461748, 0.887011, 7200, 255, 1, 0), +(@Oguid+1, 206038, 34, 0, 0, 2, 169, 0, 126.142, -33.6665, -33.9396, 2.46091, 0, 0, 0.942641, 0.333807, 7200, 255, 1, 0), +(@Oguid+2, 206038, 34, 0, 0, 2, 169, 0, 77.1255, -85.7675, -33.9396, 2.46091, 0, 0, 0.942641, 0.333807, 7200, 255, 1, 0), +(@Oguid+3, 206039, 34, 0, 0, 2, 169, 0, 136.405, -62.4725, -34.8562, 0, 0, 0, 0, 1, 7200, 255, 1, 0), +(@Oguid+4, 206038, 34, 0, 0, 2, 169, 0, 105.513, -34.6987, -34.8562, 2.46091, 0, 0, 0.942641, 0.333807, 7200, 255, 1, 0), +(@Oguid+5, 206038, 34, 0, 0, 2, 169, 0, 117.186, -49.3382, -33.5413, 2.46091, 0, 0, 0.942641, 0.333807, 7200, 255, 1, 0), +(@Oguid+6, 206038, 34, 0, 0, 2, 169, 0, 113.598, -79.2585, -31.5162, 2.46091, 0, 0, 0.942641, 0.333807, 7200, 255, 1, 0), +(@Oguid+7, 206039, 34, 0, 0, 2, 169, 0, 82.5491, -86.3351, -32.9531, 0, 0, 0, 0, 1, 7200, 255, 1, 0), +(@Oguid+8, 206038, 34, 0, 0, 2, 169, 0, 118.107, -91.1957, -33.6035, 2.46091, 0, 0, 0.942641, 0.333807, 7200, 255, 1, 0), +(@Oguid+9, 206038, 34, 0, 0, 2, 169, 0, 100.02, -44.5863, -34.8562, 2.46091, 0, 0, 0.942641, 0.333807, 7200, 255, 1, 0), +(@Oguid+10, 206038, 34, 0, 0, 2, 169, 0, 97.0995, -96.3035, -35.1896, 2.46091, 0, 0, 0.942641, 0.333807, 7200, 255, 1, 0), +(@Oguid+11, 206038, 34, 0, 0, 2, 169, 0, 102.467, -53.2114, -34.8562, 2.46091, 0, 0, 0.942641, 0.333807, 7200, 255, 1, 0), +(@Oguid+12, 206038, 34, 0, 0, 2, 169, 0, 125.139, -69.8723, -33.9396, 2.46091, 0, 0, 0.942641, 0.333807, 7200, 255, 1, 0), +(@Oguid+13, 206038, 34, 0, 0, 2, 169, 0, 128.726, -62.7564, -33.3152, 2.46091, 0, 0, 0.942641, 0.333807, 7200, 255, 1, 0), +(@Oguid+14, 206039, 34, 0, 0, 2, 169, 0, 104.716, -92.3675, -34.977, 0, 0, 0, 0, 1, 7200, 255, 1, 0), +(@Oguid+15, 206038, 34, 0, 0, 2, 169, 0, 133.237, -36.2304, -33.545, 2.46091, 0, 0, 0.942641, 0.333807, 7200, 255, 1, 0), +(@Oguid+16, 206039, 34, 0, 0, 2, 169, 0, 113.787, -68.6769, -34.4421, -0.890117, 0, 0, -0.43051, 0.902586, 7200, 255, 1, 0), +(@Oguid+17, 206039, 34, 0, 0, 2, 169, 0, 114.113, -116.77, -35.1896, 0, 0, 0, 0, 1, 7200, 255, 1, 0), +(@Oguid+18, 206039, 34, 0, 0, 2, 169, 0, 139.263, -37.9274, -34.8562, 0, 0, 0, 0, 1, 7200, 255, 1, 0), +(@Oguid+19, 206038, 34, 0, 0, 2, 169, 0, 133.514, -112.958, -33.9396, 2.46091, 0, 0, 0.942641, 0.333807, 7200, 255, 1, 0), +(@Oguid+20, 206039, 34, 0, 0, 2, 169, 0, 130.886, -127.941, -33.9396, 0, 0, 0, 0, 1, 7200, 255, 1, 0), +(@Oguid+21, 206038, 34, 0, 0, 2, 169, 0, 100.471, -63.4066, -34.8562, 2.46091, 0, 0, 0.942641, 0.333807, 7200, 255, 1, 0), +(@Oguid+22, 206039, 34, 0, 0, 2, 169, 0, 143.322, -80.2735, -34.8562, 0, 0, 0, 0, 1, 7200, 255, 1, 0), +(@Oguid+23, 206038, 34, 0, 0, 2, 169, 0, 85.4526, -102.806, -32.4805, 2.46091, 0, 0, 0.942641, 0.333807, 7200, 255, 1, 0), +(@Oguid+24, 206038, 34, 0, 0, 2, 169, 0, 122.655, -48.4107, -31.062, 2.46091, 0, 0, 0.942641, 0.333807, 7200, 255, 1, 0), +(@Oguid+25, 206038, 34, 0, 0, 2, 169, 0, 159.953, -56.0504, -34.8562, 2.46091, 0, 0, 0.942641, 0.333807, 7200, 255, 1, 0), +(@Oguid+26, 206039, 34, 0, 0, 2, 169, 0, 118.08, -105.927, -35.1896, 0, 0, 0, 0, 1, 7200, 255, 1, 0), +(@Oguid+27, 206038, 34, 0, 0, 2, 169, 0, 106.757, -89.6077, -31.5528, 2.46091, 0, 0, 0.942641, 0.333807, 7200, 255, 1, 0), +(@Oguid+28, 206038, 34, 0, 0, 2, 169, 0, 130.461, -39.3777, -33.9396, 2.46091, 0, 0, 0.942641, 0.333807, 7200, 255, 1, 0), +(@Oguid+29, 206038, 34, 0, 0, 2, 169, 0, 92.377, -116.607, -31.0731, 2.46091, 0, 0, 0.942641, 0.333807, 7200, 255, 1, 0), +(@Oguid+30, 206039, 34, 0, 0, 2, 169, 0, 143.363, -53.1464, -34.8562, 0, 0, 0, 0, 1, 7200, 255, 1, 0), +(@Oguid+31, 206038, 34, 0, 0, 2, 169, 0, 123.561, -71.0415, -28.8443, 2.46091, 0, 0, 0.942641, 0.333807, 7200, 255, 1, 0), +(@Oguid+32, 206038, 34, 0, 0, 2, 169, 0, 136.253, -50.0208, -34.8562, 2.46091, 0, 0, 0.942641, 0.333807, 7200, 255, 1, 0), +(@Oguid+33, 206038, 34, 0, 0, 2, 169, 0, 127.26, -125.315, -32.7396, 2.46091, 0, 0, 0.942641, 0.333807, 7200, 255, 1, 0); + +SET @Cguid:= 375668; +DELETE FROM `creature` WHERE `map`=34; +DELETE FROM `creature` WHERE `guid` BETWEEN @Oguid+0 AND @Oguid+142; +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +(@Cguid+0, 46252, 34, 0, 0, 2, 169, 0, 413, 0, 138.8, 68.2195, -33.8563, 3.75246, 7200, 0, 0, 2284, 1743, 0, 0, 0, 0, 0), +(@Cguid+1, 46249, 34, 0, 0, 2, 169, 0, 384, 1, 143.643, 107.928, -35.1063, 1.09956, 7200, 0, 0, 2420, 0, 0, 0, 0, 0, 0), +(@Cguid+2, 46251, 34, 0, 0, 2, 169, 0, 383, 1, 142.502, 111.638, -35.1063, 5.49779, 7200, 0, 0, 2420, 0, 0, 0, 0, 0, 0), +(@Cguid+3, 46248, 34, 0, 0, 2, 169, 0, 175, 1, 145.88, 111.855, -35.1063, 3.49066, 7200, 0, 0, 2420, 0, 0, 0, 0, 0, 0), +(@Cguid+4, 46250, 34, 0, 0, 2, 169, 0, 374, 1, 147.363, 102.737, -35.1896, 4.74935, 7200, 0, 0, 2604, 0, 2, 0, 0, 0, 0), -- 1 +(@Cguid+5, 46251, 34, 0, 0, 2, 169, 0, 383, 1, 126.643, 48.8055, -33.8563, 5.34071, 7200, 0, 0, 2420, 0, 0, 0, 0, 0, 0), +(@Cguid+6, 46260, 34, 0, 0, 2, 169, 0, 1405, 0, 99.583, -39.0376, -34.8562, 2.37755, 7200, 0, 0, 2284, 1236, 2, 0, 0, 0, 0), -- 2 +(@Cguid+7, 46263, 34, 0, 0, 2, 169, 0, 2169, 0, 79.106, -96.1999, -33.9396, 2.88742, 7200, 0, 0, 2132, 1162, 0, 0, 0, 0, 0), +(@Cguid+8, 46263, 34, 0, 0, 2, 169, 0, 2169, 0, 142.243, -74.6631, -34.8562, 0.60646, 7200, 0, 0, 2132, 1162, 0, 0, 0, 0, 0), +(@Cguid+9, 46262, 34, 0, 0, 2, 169, 0, 1128, 0, 115.934, -62.6386, -34.8561, 2.66776, 7200, 0, 0, 302, 0, 2, 0, 0, 0, 0), -- 3 +(@Cguid+10, 46261, 34, 0, 0, 2, 169, 0, 35014, 0, 130.089, -115.885, -33.9396, 2.24391, 7200, 5, 0, 2132, 1162, 1, 0, 0, 0, 0), +(@Cguid+11, 46261, 34, 0, 0, 2, 169, 0, 35014, 0, 143.314, -42.6761, -34.8562, 3.36318, 7200, 0, 0, 2132, 1162, 0, 0, 0, 0, 0), +(@Cguid+12, 46251, 34, 0, 0, 2, 169, 0, 383, 1, 140.377, 88.779, -33.8563, 5.16617, 7200, 0, 0, 2420, 0, 0, 0, 0, 0, 0), +(@Cguid+13, 46249, 34, 0, 0, 2, 169, 0, 384, 1, 145.945, 87.9651, -33.8563, 3.49066, 7200, 0, 0, 2420, 0, 0, 0, 0, 0, 0), +(@Cguid+14, 46249, 34, 0, 0, 2, 169, 0, 384, 1, 115.646, 46.6108, -34.8562, 3.05838, 7200, 0, 0, 2420, 0, 0, 0, 0, 0, 0), +(@Cguid+15, 46251, 34, 0, 0, 2, 169, 0, 383, 1, 169.457, 131.567, -33.9396, 0.0420607, 7200, 0, 0, 2420, 0, 0, 0, 0, 0, 0), +(@Cguid+16, 46251, 34, 0, 0, 2, 169, 0, 383, 1, 128.467, 60.6504, -33.8563, 5.60251, 7200, 0, 0, 2420, 0, 0, 0, 0, 0, 0), +(@Cguid+17, 46251, 34, 0, 0, 2, 169, 0, 383, 1, 151.236, 61.0594, -34.7729, 2.3911, 7200, 0, 0, 2420, 0, 0, 0, 0, 0, 0), +(@Cguid+18, 46249, 34, 0, 0, 2, 169, 0, 384, 1, 151.978, 65.7358, -34.7729, 4.2586, 7200, 0, 0, 2420, 0, 0, 0, 0, 0, 0), +(@Cguid+19, 46250, 34, 0, 0, 2, 169, 0, 374, 1, 124.068, 119.782, -33.9396, 2.84049, 7200, 0, 0, 2604, 0, 0, 0, 0, 0, 0), +(@Cguid+20, 46251, 34, 0, 0, 2, 169, 0, 383, 1, 114.621, 71.3001, -34.7729, 0.383972, 7200, 0, 0, 2420, 0, 0, 0, 0, 0, 0), +(@Cguid+21, 46248, 34, 0, 0, 2, 169, 0, 175, 1, 118.116, 75.7636, -34.7729, 4.2586, 7200, 0, 0, 2420, 0, 0, 0, 0, 0, 0), +(@Cguid+22, 46252, 34, 0, 0, 2, 169, 0, 413, 0, 119.789, 125.887, -33.9396, 2.52888, 7200, 0, 0, 2284, 1743, 0, 0, 0, 0, 0), +(@Cguid+23, 46251, 34, 0, 0, 2, 169, 0, 383, 1, 149.402, 39.6148, -34.7729, 1.25664, 7200, 0, 0, 2420, 0, 0, 0, 0, 0, 0), +(@Cguid+24, 46249, 34, 0, 0, 2, 169, 0, 384, 1, 150.557, 45.8164, -34.7729, 3.80482, 7200, 0, 0, 2420, 0, 0, 0, 0, 0, 0), +(@Cguid+25, 46251, 34, 0, 0, 2, 169, 0, 383, 1, 190.948, 92.736, -33.9396, 3.35267, 7200, 0, 0, 2420, 0, 0, 0, 0, 0, 0), +(@Cguid+26, 46262, 34, 0, 0, 2, 169, 0, 1128, 0, 91.4122, -133.32, -33.9396, 0.911975, 7200, 5, 0, 302, 0, 1, 0, 0, 0, 0), +(@Cguid+27, 46263, 34, 0, 0, 2, 169, 0, 2169, 0, 95.1225, -58.5109, -34.8562, 0.875983, 7200, 0, 0, 2132, 1162, 0, 0, 0, 0, 0), +(@Cguid+28, 46262, 34, 0, 0, 2, 169, 0, 1128, 0, 134.673, -122.773, -33.9396, 5.86751, 7200, 0, 0, 302, 0, 0, 0, 0, 0, 0), +(@Cguid+29, 46261, 34, 0, 0, 2, 169, 0, 35014, 0, 111.376, -45.8854, -34.8562, 5.65932, 7200, 0, 0, 2132, 1162, 0, 0, 0, 0, 0), +(@Cguid+30, 46263, 34, 0, 0, 2, 169, 0, 2169, 0, 105.616, -57.7929, -34.8562, 5.6134, 7200, 0, 0, 2132, 1162, 0, 0, 0, 0, 0), +(@Cguid+31, 46263, 34, 0, 0, 2, 169, 0, 2169, 0, 109.941, -100.341, -35.1896, -0.611966, 7200, 0, 0, 2132, 1162, 0, 0, 0, 0, 0), +(@Cguid+32, 46261, 34, 0, 0, 2, 169, 0, 35014, 0, 125.033, -55.2645, -33.8563, 1.8326, 7200, 0, 0, 2132, 1162, 0, 0, 0, 0, 0), +(@Cguid+33, 46263, 34, 0, 0, 2, 169, 0, 2169, 0, 128.403, -51.1683, -33.8563, 1.8326, 7200, 0, 0, 2132, 1162, 0, 0, 0, 0, 0), +(@Cguid+34, 46262, 34, 0, 0, 2, 169, 0, 1128, 0, 116.784, -84.3837, -33.9396, 0.986595, 7200, 0, 0, 302, 0, 0, 0, 0, 0, 0), +(@Cguid+35, 46260, 34, 0, 0, 2, 169, 0, 1405, 0, 89.6001, -143.828, -33.9396, 3.61654, 7200, 0, 0, 2284, 1236, 0, 0, 0, 0, 0), +(@Cguid+36, 46263, 34, 0, 0, 2, 169, 0, 2169, 0, 130.427, -116.848, -33.9396, 2.46724, 7200, 5, 0, 2132, 1162, 1, 0, 0, 0, 0), +(@Cguid+37, 46375, 34, 0, 0, 2, 169, 0, 35078, 1, 102.054, 0.80921, -25.5229, 3.68265, 7200, 0, 0, 2604, 0, 0, 0, 0, 0, 0), +(@Cguid+38, 46382, 34, 0, 0, 2, 169, 0, 35069, 0, 114.333, -2.55397, -25.5229, 1.18682, 7200, 0, 0, 302, 0, 0, 0, 0, 0, 0), +(@Cguid+39, 46382, 34, 0, 0, 2, 169, 0, 35069, 0, 111.162, -2.44849, -25.5229, 1.93731, 7200, 0, 0, 302, 0, 0, 0, 0, 0, 0), -- 4 +(@Cguid+40, 46382, 34, 0, 0, 2, 169, 0, 35069, 0, 100.28, -0.705868, -25.6062, 4.72614, 7200, 0, 0, 302, 0, 0, 0, 0, 0, 0), -- 5 +(@Cguid+41, 46382, 34, 0, 0, 2, 169, 0, 35069, 0, 113.127, -13.4419, -26.4396, 2.19912, 7200, 0, 0, 302, 0, 0, 0, 0, 0, 0), +(@Cguid+42, 46382, 34, 0, 0, 2, 169, 0, 35069, 0, 111.682, -15.3287, -26.4396, 2.3911, 7200, 0, 0, 302, 0, 0, 0, 0, 0, 0), -- 6 +(@Cguid+43, 46382, 34, 0, 0, 2, 169, 0, 35069, 0, 112.539, -18.1699, -26.4396, 3.54302, 7200, 0, 0, 302, 0, 0, 0, 0, 0, 0), +(@Cguid+44, 46375, 34, 0, 0, 2, 169, 0, 35078, 1, 100.19, 1.53123, -25.6062, -2.79082, 7200, 0, 0, 2604, 0, 0, 0, 0, 0, 0), +(@Cguid+45, 46382, 34, 0, 0, 2, 169, 0, 35069, 0, 133.763, 3.99191, -25.5229, 4.13643, 7200, 0, 0, 302, 0, 0, 0, 0, 0, 0), +(@Cguid+46, 46382, 34, 0, 0, 2, 169, 0, 35069, 0, 132.188, 5.22533, -25.5229, 3.75246, 7200, 0, 0, 302, 0, 0, 0, 0, 0, 0), -- 7 +(@Cguid+47, 46382, 34, 0, 0, 2, 169, 0, 35069, 0, 120.915, 0.512058, -25.6062, 3.24348, 7200, 0, 0, 302, 0, 0, 0, 0, 0, 0), -- 8 +(@Cguid+48, 46379, 34, 0, 0, 2, 169, 0, 35076, 1, 135.391, 5.12026, -24.3964, -2.53755, 7200, 0, 0, 2604, 0, 0, 0, 0, 0, 0), +(@Cguid+49, 46375, 34, 0, 0, 2, 169, 0, 35078, 1, 161.964, 5.82574, -25.5229, 5.96903, 7200, 0, 0, 2604, 0, 0, 0, 0, 0, 0), +(@Cguid+50, 46381, 34, 0, 0, 2, 169, 0, 35073, 1, 164.323, 5.37318, -25.5229, 3.01942, 7200, 0, 0, 2604, 0, 0, 0, 0, 0, 0), +(@Cguid+51, 46264, 34, 0, 0, 2, 169, 0, 1204, 0, 99.4527, -116.802, -35.1063, 1.09956, 43200, 0, 0, 15250, 3930, 0, 0, 0, 0, 0), +(@Cguid+52, 46254, 34, 0, 0, 2, 169, 0, 501, 1, 158.016, 116.564, -35.1063, 4.2586, 43200, 0, 0, 23456, 0, 0, 0, 0, 0, 0), +(@Cguid+53, 46249, 34, 0, 0, 2, 169, 0, 384, 1, 132.665, 123.228, -33.9396, 0.0124326, 7200, 0, 0, 2420, 0, 0, 0, 0, 0, 0), +(@Cguid+54, 46252, 34, 0, 0, 2, 169, 0, 413, 0, 164.711, 135.636, -33.9396, 6.06013, 7200, 0, 0, 2284, 1743, 0, 0, 0, 0, 0), +(@Cguid+55, 46248, 34, 0, 0, 2, 169, 0, 175, 1, 132.976, 40.8171, -33.8563, 3.90954, 7200, 0, 0, 2420, 0, 0, 0, 0, 0, 0), +(@Cguid+56, 46248, 34, 0, 0, 2, 169, 0, 175, 1, 159.443, 98.5626, -35.1063, 0.191986, 7200, 0, 0, 2420, 0, 0, 0, 0, 0, 0), +(@Cguid+57, 46252, 34, 0, 0, 2, 169, 0, 413, 0, 161.406, 97.0804, -35.1063, 2.72271, 7200, 0, 0, 2284, 1743, 0, 0, 0, 0, 0), +(@Cguid+58, 46250, 34, 0, 0, 2, 169, 0, 374, 1, 161.415, 100.436, -35.1063, 3.89208, 7200, 0, 0, 2604, 0, 0, 0, 0, 0, 0), +(@Cguid+59, 46249, 34, 0, 0, 2, 169, 0, 384, 1, 171.285, 135.533, -33.9396, 2.47638, 7200, 0, 0, 2420, 0, 0, 0, 0, 0, 0), +(@Cguid+60, 46252, 34, 0, 0, 2, 169, 0, 413, 0, 112.905, 42.6389, -34.7729, 1.25664, 7200, 0, 0, 2284, 1743, 0, 0, 0, 0, 0), +(@Cguid+61, 46250, 34, 0, 0, 2, 169, 0, 374, 1, 110.525, 50.7815, -34.7729, 5.39307, 7200, 0, 0, 2604, 0, 0, 0, 0, 0, 0), +(@Cguid+62, 46252, 34, 0, 0, 2, 169, 0, 413, 0, 178.448, 98.6488, -33.9396, 0.533069, 7200, 0, 0, 2284, 1743, 0, 0, 0, 0, 0), +(@Cguid+63, 46248, 34, 0, 0, 2, 169, 0, 175, 1, 179.873, 90.7396, -33.9396, 2.95521, 7200, 0, 0, 2420, 0, 2, 0, 0, 0, 0), -- 9 +(@Cguid+64, 46248, 34, 0, 0, 2, 169, 0, 175, 1, 147.842, 43.3093, -34.8562, 6.19657, 7200, 0, 0, 2420, 0, 0, 0, 0, 0, 0), +(@Cguid+65, 46250, 34, 0, 0, 2, 169, 0, 374, 1, 154.114, 100.941, -35.1896, 3.43802, 7200, 0, 0, 2604, 0, 2, 0, 0, 0, 0), -- 10 +(@Cguid+66, 46260, 34, 0, 0, 2, 169, 0, 1405, 0, 138.332, -126.504, -33.9396, 2.10357, 7200, 0, 0, 2284, 1236, 0, 0, 0, 0, 0), +(@Cguid+67, 46263, 34, 0, 0, 2, 169, 0, 2169, 0, 117.771, -75.4089, -33.8563, 0, 7200, 0, 0, 2132, 1162, 0, 0, 0, 0, 0), +(@Cguid+68, 46260, 34, 0, 0, 2, 169, 0, 1405, 0, 119.77, -81.5856, -33.8563, 0, 7200, 0, 0, 2284, 1236, 0, 0, 0, 0, 0), +(@Cguid+69, 46262, 34, 0, 0, 2, 169, 0, 1128, 0, 125.86, -61.6993, -33.9396, 1.00045, 7200, 0, 0, 302, 0, 2, 0, 0, 0, 0), -- 11 +(@Cguid+70, 46261, 34, 0, 0, 2, 169, 0, 35014, 0, 99.3459, -102.593, -35.1063, 0.436332, 7200, 0, 0, 2132, 1162, 0, 0, 0, 0, 0), +(@Cguid+71, 46263, 34, 0, 0, 2, 169, 0, 2169, 0, 105.885, -101.519, -35.1063, 1.69297, 7200, 0, 0, 2132, 1162, 0, 0, 0, 0, 0), +(@Cguid+72, 46260, 34, 0, 0, 2, 169, 0, 1405, 0, 111.092, -98.399, -35.1896, 4.32032, 7200, 0, 0, 2284, 1236, 0, 0, 0, 0, 0), +(@Cguid+73, 46262, 34, 0, 0, 2, 169, 0, 1128, 0, 151.518, -47.9823, -34.8562, 2.91744, 7200, 0, 0, 302, 0, 2, 0, 0, 0, 0), -- 12 +(@Cguid+74, 46261, 34, 0, 0, 2, 169, 0, 35014, 0, 154.18, -69.5024, -34.8562, 5.11699, 7200, 0, 0, 2132, 1162, 0, 0, 0, 0, 0), +(@Cguid+75, 46260, 34, 0, 0, 2, 169, 0, 1405, 0, 146.644, -49.8948, -34.8562, 1.7966, 7200, 0, 0, 2284, 1236, 2, 0, 0, 0, 0), -- 13 +(@Cguid+76, 46262, 34, 0, 0, 2, 169, 0, 1128, 0, 113.612, -59.6646, -34.8562, 1.07341, 7200, 0, 0, 302, 0, 0, 0, 0, 0, 0), +(@Cguid+77, 46262, 34, 0, 0, 2, 169, 0, 1128, 0, 91.3291, -133.327, -33.9396, 2.51738, 7200, 5, 0, 302, 0, 1, 0, 0, 0, 0), +(@Cguid+78, 46262, 34, 0, 0, 2, 169, 0, 1128, 0, 77.8695, -88.568, -33.9396, 6.13929, 7200, 0, 0, 302, 0, 0, 0, 0, 0, 0), +(@Cguid+79, 46379, 34, 0, 0, 2, 169, 0, 35076, 1, 104.795, -29.1012, -26.4396, 0.864969, 7200, 0, 0, 2604, 0, 2, 0, 0, 0, 0), -- 14 +(@Cguid+80, 46379, 34, 0, 0, 2, 169, 0, 35076, 1, 151.833, 0.695342, -25.6062, 1.42085, 7200, 0, 0, 2604, 0, 0, 0, 0, 0, 0), +(@Cguid+81, 46375, 34, 0, 0, 2, 169, 0, 35078, 1, 136.11, 2.21884, -25.6062, 5.32628, 7200, 0, 0, 2604, 0, 0, 0, 0, 0, 0), +(@Cguid+82, 46381, 34, 0, 0, 2, 169, 0, 35073, 1, 151.78, -0.610041, -25.6062, 2.92175, 7200, 0, 0, 2604, 0, 0, 0, 0, 0, 0), +(@Cguid+83, 46381, 34, 0, 0, 2, 169, 0, 35073, 1, 141.334, -0.052255, -25.6062, 2.70265, 7200, 0, 0, 2604, 0, 0, 0, 0, 0, 0), +(@Cguid+84, 46379, 34, 0, 0, 2, 169, 0, 35076, 1, 138.974, 3.55755, -25.6062, 5.04733, 7200, 0, 0, 2604, 0, 0, 0, 0, 0, 0), +(@Cguid+85, 46382, 34, 0, 0, 2, 169, 0, 35069, 0, 101.52, -27.0801, -26.4396, 5.20108, 7200, 0, 0, 302, 0, 0, 0, 0, 0, 0), +(@Cguid+86, 46382, 34, 0, 0, 2, 169, 0, 35069, 0, 100.542, -28.7851, -26.4396, 5.86431, 7200, 0, 0, 302, 0, 0, 0, 0, 0, 0), -- 15 +(@Cguid+87, 46382, 34, 0, 0, 2, 169, 0, 35069, 0, 103.314, -31.4143, -26.4396, 1.88496, 7200, 0, 0, 302, 0, 0, 0, 0, 0, 0), +(@Cguid+88, 46379, 34, 0, 0, 2, 169, 0, 35076, 1, 108.927, 21.8863, -26.5229, 2.2088, 7200, 0, 0, 2604, 0, 0, 0, 0, 0, 0), +(@Cguid+89, 46382, 34, 0, 0, 2, 169, 0, 35069, 0, 102.194, 3.97128, -25.5229, 3.56047, 7200, 0, 0, 302, 0, 0, 0, 0, 0, 0), +(@Cguid+90, 46382, 34, 0, 0, 2, 169, 0, 35069, 0, 100.528, 3.50848, -25.5229, 3.7705, 7200, 0, 0, 302, 0, 0, 0, 0, 0, 0), -- 16 +(@Cguid+91, 46382, 34, 0, 0, 2, 169, 0, 35069, 0, 93.2359, -0.0572555, -25.6062, 3.70497, 7200, 0, 0, 302, 0, 0, 0, 0, 0, 0), -- 17 +(@Cguid+92, 46375, 34, 0, 0, 2, 169, 0, 35078, 1, 98.96, -1.139, -25.6062, -0.0470873, 7200, 0, 0, 2604, 0, 0, 0, 0, 0, 0), +(@Cguid+93, 46382, 34, 0, 0, 2, 169, 0, 35069, 0, 112.535, 23.3279, -26.4396, 4.13643, 7200, 0, 0, 302, 0, 0, 0, 0, 0, 0), +(@Cguid+94, 46382, 34, 0, 0, 2, 169, 0, 35069, 0, 110.96, 24.5613, -26.4396, 3.75246, 7200, 0, 0, 302, 0, 0, 0, 0, 0, 0), -- 18 +(@Cguid+95, 46382, 34, 0, 0, 2, 169, 0, 35069, 0, 111.84, 18.6591, -26.4396, 2.16421, 7200, 0, 0, 302, 0, 0, 0, 0, 0, 0), +(@Cguid+96, 46379, 34, 0, 0, 2, 169, 0, 35076, 1, 132.009, 1.1699, -25.5229, 2.53995, 7200, 0, 0, 2604, 0, 2, 0, 0, 0, 0), -- 19 +(@Cguid+97, 46379, 34, 0, 0, 2, 169, 0, 35076, 1, 109.06, -15.5223, -26.5229, 1.99201, 7200, 0, 0, 2604, 0, 2, 0, 0, 0, 0), -- 20 +(@Cguid+98, 46383, 34, 0, 0, 2, 169, 0, 35068, 1, 172.463, -2.24164, -25.5229, 2.72271, 43200, 0, 0, 17475, 0, 0, 0, 0, 0, 0), +(@Cguid+99, 46300, 34, 0, 0, 2, 169, 0, 35073, 0, 126.23, -33.708, -33.8563, 0.785398, 7200, 0, 0, 521, 0, 0, 0, 0, 0, 0), +(@Cguid+100, 46299, 34, 0, 0, 2, 169, 0, 35076, 0, 97.0772, -96.3446, -35.1063, 1.36136, 7200, 0, 0, 484, 0, 0, 0, 0, 0, 0), +(@Cguid+101, 46299, 34, 0, 0, 2, 169, 0, 35076, 0, 100.069, -44.6332, -34.7729, 1.36136, 7200, 0, 0, 484, 0, 0, 0, 0, 0, 0), +(@Cguid+102, 46300, 34, 0, 0, 2, 169, 0, 35073, 0, 125.168, -69.6588, -33.8563, 1.36136, 7200, 0, 0, 521, 0, 0, 0, 0, 0, 0), +(@Cguid+103, 46299, 34, 0, 0, 2, 169, 0, 35076, 0, 130.365, -39.4408, -33.8563, 4.01426, 7200, 0, 0, 484, 0, 0, 0, 0, 0, 0), +(@Cguid+104, 46299, 34, 0, 0, 2, 169, 0, 35076, 0, 136.265, -50.0503, -34.7729, 0.837758, 7200, 0, 0, 484, 0, 0, 0, 0, 0, 0), +(@Cguid+105, 46300, 34, 0, 0, 2, 169, 0, 35073, 0, 77.1173, -85.7022, -33.8563, 1.36136, 7200, 0, 0, 521, 0, 0, 0, 0, 0, 0), +(@Cguid+106, 46300, 34, 0, 0, 2, 169, 0, 35073, 0, 100.481, -63.3902, -34.7729, 4.41568, 7200, 0, 0, 521, 0, 0, 0, 0, 0, 0), +(@Cguid+107, 46406, 34, 0, 0, 2, 169, 0, 2989, 1, 78.7384, -0.682292, -25.5229, 0, 7200, 0, 0, 1302, 0, 0, 0, 0, 0, 0), +(@Cguid+108, 46405, 34, 0, 0, 2, 169, 0, 2989, 1, 78.6935, 15.392, -26.4396, 0.610865, 7200, 0, 0, 1124, 0, 0, 0, 0, 0, 0), +(@Cguid+109, 46406, 34, 0, 0, 2, 169, 0, 2989, 1, 77.0925, 3.23572, -25.5229, 0, 7200, 0, 0, 1302, 0, 0, 0, 0, 0, 0), +(@Cguid+110, 46406, 34, 0, 0, 2, 169, 0, 2990, 1, 76.7786, -1.54392, -25.5229, 0, 7200, 0, 0, 1302, 0, 0, 0, 0, 0, 0), +(@Cguid+111, 46405, 34, 0, 0, 2, 169, 0, 2992, 1, 89.3952, 9.3915, -26.4396, 3.40339, 7200, 0, 0, 1124, 0, 0, 0, 0, 0, 0), -- 21 +(@Cguid+112, 46407, 34, 0, 0, 2, 169, 0, 2988, 0, 91.6768, -29.3938, -26.4396, 3.12414, 7200, 0, 0, 1124, 0, 0, 0, 0, 0, 0), +(@Cguid+113, 46408, 34, 0, 0, 2, 169, 0, 2992, 0, 90.7331, -8.76813, -26.4396, 4.13643, 7200, 0, 0, 1124, 0, 0, 0, 0, 0, 0), +(@Cguid+114, 46405, 34, 0, 0, 2, 169, 0, 2989, 1, 90.0439, -2.58535, -25.5229, 0.139626, 7200, 0, 0, 1124, 0, 0, 0, 0, 0, 0), -- 22 +(@Cguid+115, 46406, 34, 0, 0, 2, 169, 0, 2989, 1, 78.9916, 4.26081, -25.5229, 0, 7200, 0, 0, 1302, 0, 0, 0, 0, 0, 0), +(@Cguid+116, 46406, 34, 0, 0, 2, 169, 0, 2989, 1, 78.7236, -2.62016, -25.5229, 0, 7200, 0, 0, 1302, 0, 0, 0, 0, 0, 0), +(@Cguid+117, 46407, 34, 0, 0, 2, 169, 0, 2987, 0, 78.9247, -27.3705, -26.4396, 1.62316, 7200, 0, 0, 1124, 0, 0, 0, 0, 0, 0), +(@Cguid+118, 46405, 34, 0, 0, 2, 169, 0, 2989, 1, 79.3117, 17.1223, -26.4396, 5.21853, 7200, 0, 0, 1124, 0, 0, 0, 0, 0, 0), +(@Cguid+119, 46408, 34, 0, 0, 2, 169, 0, 2990, 0, 88.6199, -21.0578, -26.4396, 1.72788, 7200, 0, 0, 1124, 0, 0, 0, 0, 0, 0), +(@Cguid+120, 46405, 34, 0, 0, 2, 169, 0, 2992, 1, 79.9497, 22.0916, -26.4396, 5.48033, 7200, 0, 0, 1124, 0, 0, 0, 0, 0, 0), -- 23 +(@Cguid+121, 46405, 34, 0, 0, 2, 169, 0, 2989, 1, 85.3679, 18.7793, -26.4396, 5.42797, 7200, 0, 0, 1124, 0, 0, 0, 0, 0, 0), +(@Cguid+122, 46408, 34, 0, 0, 2, 169, 0, 2989, 0, 77.3381, -15.1934, -26.4396, 0, 7200, 0, 0, 1124, 0, 0, 0, 0, 0, 0), +(@Cguid+123, 46407, 34, 0, 0, 2, 169, 0, 2986, 0, 91.3948, -16.1498, -26.4396, 3.05433, 7200, 0, 0, 1124, 0, 0, 0, 0, 0, 0), +(@Cguid+124, 46405, 34, 0, 0, 2, 169, 0, 2992, 1, 80.8261, 15.4966, -26.4396, 2.80998, 7200, 0, 0, 1124, 0, 0, 0, 0, 0, 0), +(@Cguid+125, 46405, 34, 0, 0, 2, 169, 0, 2992, 1, 90.0527, 4.0865, -25.5229, 6.05629, 7200, 0, 0, 1124, 0, 0, 0, 0, 0, 0), -- 24 +(@Cguid+126, 46411, 34, 0, 0, 2, 169, 0, 27769, 0, 85.5236, -17.4515, -26.4396, 0, 7200, 0, 0, 5342, 0, 0, 0, 0, 0, 0), +(@Cguid+127, 46410, 34, 0, 0, 2, 169, 0, 2993, 0, 83.9379, -14.7392, -26.4396, 3.22886, 7200, 0, 0, 635, 0, 0, 0, 0, 0, 0), +(@Cguid+128, 46406, 34, 0, 0, 2, 169, 0, 2990, 1, 79.0145, 2.2961, -25.5229, 0, 7200, 0, 0, 1302, 0, 0, 0, 0, 0, 0), +(@Cguid+129, 46407, 34, 0, 0, 2, 169, 0, 2988, 0, 79.8477, -31.7496, -26.4396, 0.907571, 7200, 0, 0, 1124, 0, 0, 0, 0, 0, 0), +(@Cguid+130, 46407, 34, 0, 0, 2, 169, 0, 2986, 0, 86.7224, -32.0406, -26.4396, 1.62316, 7200, 0, 0, 1124, 0, 0, 0, 0, 0, 0), +(@Cguid+131, 46405, 34, 0, 0, 2, 169, 0, 2989, 1, 89.7979, -0.81802, -25.5229, 0.0698132, 7200, 0, 0, 1124, 0, 0, 0, 0, 0, 0), -- 25 +(@Cguid+132, 46409, 34, 0, 0, 2, 169, 0, 1865, 1, 83.5244, 32.7149, -26.4829, 3.29497, 7200, 0, 0, 4229, 0, 2, 0, 0, 0, 0), -- 26 +(@Cguid+133, 46482, 34, 0, 0, 2, 169, 0, 35068, 1, 88.8999, 21.8505, -26.4421, 4.4855, 7200, 0, 0, 5592, 0, 0, 0, 0, 0, 0), +(@Cguid+134, 46405, 34, 0, 0, 2, 169, 0, 2992, 1, 89.7199, 2.35929, -25.5229, 6.12611, 7200, 0, 0, 1124, 0, 0, 0, 0, 0, 0), -- 27 +(@Cguid+135, 46408, 34, 0, 0, 2, 169, 0, 2991, 0, 80.187, -6.52612, -26.4396, 4.72984, 7200, 0, 0, 1124, 0, 0, 0, 0, 0, 0), +(@Cguid+136, 46405, 34, 0, 0, 2, 169, 0, 2989, 1, 86.3939, 17.585, -26.4396, 2.33874, 7200, 0, 0, 1124, 0, 0, 0, 0, 0, 0), +(@Cguid+137, 46405, 34, 0, 0, 2, 169, 0, 2989, 1, 90.0658, 17.493, -26.4396, 2.79253, 7200, 0, 0, 1124, 0, 0, 0, 0, 0, 0), -- 28 +(@Cguid+138, 46417, 34, 0, 0, 2, 169, 0, 2991, 1, 73.7084, 0.704101, -25.5229, 0, 7200, 0, 0, 1953, 0, 0, 0, 0, 0, 0), +(@Cguid+139, 46407, 34, 0, 0, 2, 169, 0, 2986, 0, 90.2458, -32.1359, -26.4396, 1.62316, 7200, 0, 0, 1124, 0, 0, 0, 0, 0, 0), +(@Cguid+140, 1720, 34, 0, 0, 2, 169, 0, 0, 0, 103.112, 77.7348, -34.8562, 5.94116, 28800, 0, 0, 2097, 0, 0, 0, 0, 0, 0), +(@Cguid+141, 53488, 34, 0, 0, 2, 169, 0, 16925, 0, 66.8395, 0.820416, -22.9799, 0, 7200, 0, 0, 12600, 0, 0, 0, 0, 0, 0), +(@Cguid+142, 53488, 34, 0, 0, 2, 169, 0, 16925, 0, 76.7849, 0.891, -25.5229, 0, 7200, 0, 0, 12600, 0, 0, 0, 0, 0, 0); + +DELETE FROM `creature_addon` WHERE `guid` IN (@Cguid+4, @Cguid+6, @Cguid+9, @Cguid+39, @Cguid+40, @Cguid+42, @Cguid+46, @Cguid+47, @Cguid+63, @Cguid+65, @Cguid+69, @Cguid+73, @Cguid+75, @Cguid+79, @Cguid+86, @Cguid+90, @Cguid+91, @Cguid+94, @Cguid+96, @Cguid+97, @Cguid+111, @Cguid+114, @Cguid+120, @Cguid+125, @Cguid+131, @Cguid+132, @Cguid+134, @Cguid+137); +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(@Cguid+4, (@Cguid+4)*10, 0, 0, 0, 0, ""), -- 1 +(@Cguid+6, (@Cguid+6)*10, 0, 0, 0, 0, ""), -- 2 +(@Cguid+9, (@Cguid+9)*10, 0, 0, 0, 0, ""), -- 3 +(@Cguid+39, 0, 0, 1, 1, 0, ""), -- 4 +(@Cguid+40, 0, 0, 0, 1, 0, ""), -- 5 +(@Cguid+42, 0, 0, 1, 1, 0, ""), -- 6 +(@Cguid+46, 0, 0, 1, 1, 0, ""), -- 7 +(@Cguid+47, 0, 0, 0, 1, 0, ""), -- 8 +(@Cguid+63, (@Cguid+63)*10, 0, 0, 0, 0, ""), -- 9 +(@Cguid+65, (@Cguid+65)*10, 0, 0, 0, 0, ""), -- 10 +(@Cguid+69, (@Cguid+69)*10, 0, 0, 0, 0, ""), -- 11 +(@Cguid+73, (@Cguid+73)*10, 0, 0, 0, 0, ""), -- 12 +(@Cguid+75, (@Cguid+75)*10, 0, 0, 0, 0, ""), -- 13 +(@Cguid+79, (@Cguid+79)*10, 0, 0, 0, 0, ""), -- 14 +(@Cguid+86, 0, 0, 1, 1, 0, ""), -- 15 +(@Cguid+90, 0, 0, 0, 1, 0, ""), -- 16 +(@Cguid+91, 0, 0, 0, 1, 0, ""), -- 17 +(@Cguid+94, 0, 0, 1, 1, 0, ""), -- 18 +(@Cguid+96, (@Cguid+96)*10, 0, 0, 0, 0, ""), -- 19 +(@Cguid+97, (@Cguid+97)*10, 0, 0, 0, 0, ""), -- 20 +(@Cguid+111, 0, 0, 3, 1, 0, "55474"), -- 21 +(@Cguid+114, 0, 0, 0, 1, 333, ""), -- 22 +(@Cguid+120, 0, 0, 3, 1, 0, "55474"), -- 23 +(@Cguid+125, 0, 0, 0, 1, 333, ""), -- 24 +(@Cguid+131, 0, 0, 0, 1, 333, ""), -- 25 +(@Cguid+132, (@Cguid+132)*10, 0, 0, 0, 0, ""), -- 26 +(@Cguid+134, 0, 0, 0, 1, 333, ""), -- 27 +(@Cguid+137, 0, 0, 3, 1, 0, "55474"); -- 28 + +DELETE FROM `waypoint_data` WHERE `id` IN ((@Cguid+4)*10, (@Cguid+6)*10, (@Cguid+9)*10, (@Cguid+63)*10, (@Cguid+65)*10, (@Cguid+69)*10, (@Cguid+73)*10, (@Cguid+75)*10, (@Cguid+79)*10, (@Cguid+96)*10, (@Cguid+97)*10, (@Cguid+132)*10); +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +((@Cguid+4)*10, 1, 110.294, -18.2778, -26.5229, 0, 0, 0, 0, 100, 0), +((@Cguid+4)*10, 2, 110.703, -19.1904, -26.5229, 0, 0, 0, 0, 100, 0), +((@Cguid+4)*10, 3, 108.707, -14.7353, -26.5229, 0, 0, 0, 0, 100, 0), +((@Cguid+4)*10, 4, 108.707, -14.7353, -26.5229, 0, 0, 0, 0, 100, 0), +((@Cguid+6)*10, 1, 132.866, 1.68494, -25.6062, 0, 0, 0, 0, 100, 0), +((@Cguid+6)*10, 2, 132.009, 1.1699, -25.6062, 0, 0, 0, 0, 100, 0), +((@Cguid+6)*10, 3, 131.334, 1.63358, -25.6062, 0, 0, 0, 0, 100, 0), +((@Cguid+6)*10, 4, 131.334, 1.63358, -25.6062, 0, 0, 0, 0, 100, 0), +((@Cguid+9)*10, 1, 105.652, -28.5862, -26.5229, 0, 0, 0, 0, 100, 0), +((@Cguid+9)*10, 2, 104.795, -29.1012, -26.5229, 0, 0, 0, 0, 100, 0), +((@Cguid+9)*10, 3, 105.953, -27.7429, -26.5229, 0, 0, 0, 0, 100, 0), +((@Cguid+9)*10, 4, 105.953, -27.7429, -26.5229, 0, 0, 0, 0, 100, 0), +((@Cguid+63)*10, 1, 147.865, -50.7881, -34.8562, 0, 0, 0, 0, 100, 0), +((@Cguid+63)*10, 2, 146.868, -50.8707, -34.8562, 0, 0, 0, 0, 100, 0), +((@Cguid+63)*10, 3, 146.571, -49.5761, -34.8562, 0, 0, 0, 0, 100, 0), +((@Cguid+63)*10, 4, 146.571, -49.5761, -34.8562, 0, 0, 0, 0, 100, 0), +((@Cguid+65)*10, 1, 153.951, -47.9694, -34.8562, 0, 0, 0, 0, 100, 0), +((@Cguid+65)*10, 2, 154.64, -48.6941, -34.8562, 0, 0, 0, 0, 100, 0), +((@Cguid+65)*10, 3, 153.149, -48.3541, -34.8562, 0, 0, 0, 0, 100, 0), +((@Cguid+65)*10, 4, 151.191, -47.9077, -34.8562, 0, 0, 0, 0, 100, 0), +((@Cguid+65)*10, 5, 151.191, -47.9077, -34.8562, 0, 0, 0, 0, 100, 0), +((@Cguid+69)*10, 1, 125.32, -62.541, -33.9396, 0, 0, 0, 0, 100, 0), +((@Cguid+69)*10, 2, 125.86, -61.6993, -33.9396, 0, 0, 0, 0, 100, 0), +((@Cguid+69)*10, 3, 126.255, -61.0834, -33.9396, 0, 0, 0, 0, 100, 0), +((@Cguid+69)*10, 4, 128.001, -58.3609, -33.9396, 0, 0, 0, 0, 100, 0), +((@Cguid+69)*10, 5, 130.018, -51.5804, -33.9396, 0, 0, 0, 0, 100, 0), +((@Cguid+69)*10, 6, 130.34, -50.4989, -33.9396, 0, 0, 0, 0, 100, 0), +((@Cguid+69)*10, 7, 129.576, -45.469, -33.9396, 0, 0, 0, 0, 100, 0), +((@Cguid+69)*10, 8, 129.426, -44.4811, -33.9396, 0, 0, 0, 0, 100, 0), +((@Cguid+69)*10, 9, 129.426, -44.4811, -33.9396, 0, 0, 0, 0, 100, 0), +((@Cguid+73)*10, 1, 162.874, 101.41, -34.9649, 0, 0, 0, 0, 100, 0), +((@Cguid+73)*10, 2, 161.891, 101.591, -34.9649, 0, 0, 0, 0, 100, 0), +((@Cguid+73)*10, 3, 158.366, 102.24, -35.1896, 0, 0, 0, 0, 100, 0), +((@Cguid+73)*10, 4, 152.103, 100.327, -35.1896, 0, 0, 0, 0, 100, 0), +((@Cguid+73)*10, 5, 150.572, 99.8595, -35.1896, 0, 0, 0, 0, 100, 0), +((@Cguid+73)*10, 6, 150.572, 99.8595, -35.1896, 0, 0, 0, 0, 100, 0), +((@Cguid+75)*10, 1, 181.549, 91.3863, -33.9396, 0, 0, 0, 0, 100, 0), +((@Cguid+75)*10, 2, 181.055, 90.5167, -33.9396, 0, 0, 0, 0, 100, 0), +((@Cguid+75)*10, 3, 176.763, 91.3261, -33.9396, 0, 0, 0, 0, 100, 0), +((@Cguid+75)*10, 4, 176.763, 91.3261, -33.9396, 0, 0, 0, 0, 100, 0), +((@Cguid+79)*10, 1, 122.621, -65.386, -33.9378, 0, 0, 0, 0, 100, 0), +((@Cguid+79)*10, 2, 121.682, -65.0414, -33.9378, 0, 0, 0, 0, 100, 0), +((@Cguid+79)*10, 3, 121.157, -64.8486, -33.9374, 0, 0, 0, 0, 100, 0), +((@Cguid+79)*10, 4, 119.006, -64.059, -34.8494, 0, 0, 0, 0, 100, 0), +((@Cguid+79)*10, 5, 117.944, -63.6694, -34.856, 0, 0, 0, 0, 100, 0), +((@Cguid+79)*10, 6, 114.462, -61.8837, -34.8562, 0, 0, 0, 0, 100, 0), +((@Cguid+79)*10, 7, 111.293, -60.2584, -34.8562, 0, 0, 0, 0, 100, 0), +((@Cguid+79)*10, 8, 110.055, -60.4123, -34.8562, 0, 0, 0, 0, 100, 0), +((@Cguid+79)*10, 9, 104.609, -61.0894, -34.8562, 0, 0, 0, 0, 100, 0), +((@Cguid+79)*10, 10, 104.609, -61.0894, -34.8562, 0, 0, 0, 0, 100, 0), +((@Cguid+96)*10, 1, 100.193, -38.7373, -34.8562, 0, 0, 0, 0, 100, 0), +((@Cguid+96)*10, 2, 100.307, -39.7309, -34.8562, 0, 0, 0, 0, 100, 0), +((@Cguid+96)*10, 3, 99.3503, -38.8146, -34.8562, 0, 0, 0, 0, 100, 0), +((@Cguid+96)*10, 4, 99.3503, -38.8146, -34.8562, 0, 0, 0, 0, 100, 0), +((@Cguid+97)*10, 1, 147.326, 103.736, -35.1896, 0, 0, 0, 0, 100, 0), +((@Cguid+97)*10, 2, 147.363, 102.737, -35.1896, 0, 0, 0, 0, 100, 0), +((@Cguid+97)*10, 3, 147.419, 101.211, -35.1896, 0, 0, 0, 0, 100, 0), +((@Cguid+97)*10, 4, 146.919, 99.3285, -35.1896, 0, 0, 0, 0, 100, 0), +((@Cguid+97)*10, 5, 146.392, 97.3472, -35.1896, 0, 0, 0, 0, 100, 0), +((@Cguid+97)*10, 6, 146.056, 96.0809, -34.7753, 0, 0, 0, 0, 100, 0), +((@Cguid+97)*10, 7, 145.617, 94.4278, -33.9411, 0, 0, 0, 0, 100, 0), +((@Cguid+97)*10, 8, 145.173, 92.758, -33.9396, 0, 0, 0, 0, 100, 0), +((@Cguid+97)*10, 9, 145.173, 92.758, -33.9396, 0, 0, 0, 0, 100, 0), +((@Cguid+132)*10, 1, 84.4642, 33.8602, -26.442, 0, 0, 0, 0, 100, 0), +((@Cguid+132)*10, 2, 84.4642, 32.8602, -26.442, 0, 0, 0, 0, 100, 0), +((@Cguid+132)*10, 3, 82.5378, 32.5624, -26.5259, 0, 0, 0, 0, 100, 0), +((@Cguid+132)*10, 4, 80.4382, 32.1262, -26.5265, 0, 0, 0, 0, 100, 0), +((@Cguid+132)*10, 5, 79.0513, 30.7565, -26.5262, 0, 0, 0, 0, 100, 0), +((@Cguid+132)*10, 6, 78.5776, 28.8914, -26.5229, 0, 0, 0, 0, 100, 0), +((@Cguid+132)*10, 7, 78.9996, 27.247, -26.5229, 0, 0, 0, 0, 100, 0), +((@Cguid+132)*10, 8, 81.4716, 26.7795, -26.5298, 0, 0, 0, 0, 100, 0), +((@Cguid+132)*10, 9, 83.6806, 26.924, -26.5335, 0, 0, 0, 0, 100, 0), +((@Cguid+132)*10, 10, 86.3659, 26.8395, -26.5267, 0, 0, 0, 0, 100, 0), +((@Cguid+132)*10, 11, 88.4547, 26.7095, -26.5229, 0, 0, 0, 0, 100, 0), +((@Cguid+132)*10, 12, 90.2688, 26.9445, -26.5229, 0, 0, 0, 0, 100, 0), +((@Cguid+132)*10, 13, 91.2195, 28.3116, -26.5229, 0, 0, 0, 0, 100, 0), +((@Cguid+132)*10, 14, 91.276, 29.5049, -26.5229, 0, 0, 0, 0, 100, 0), +((@Cguid+132)*10, 15, 90.8135, 30.8675, -26.5229, 0, 0, 0, 0, 100, 0), +((@Cguid+132)*10, 16, 89.6863, 31.783, -26.5229, 0, 0, 0, 0, 100, 0), +((@Cguid+132)*10, 17, 88.7407, 32.3032, -26.5229, 0, 0, 0, 0, 100, 0), +((@Cguid+132)*10, 18, 87.2978, 32.709, -26.5229, 0, 0, 0, 0, 100, 0), +((@Cguid+132)*10, 19, 85.5401, 32.9464, -26.5229, 0, 0, 0, 0, 100, 0), +((@Cguid+132)*10, 20, 84.5596, 32.7557, -26.5251, 0, 0, 0, 0, 100, 0), +((@Cguid+132)*10, 21, 84.4853, 31.0094, -26.5272, 0, 0, 0, 0, 100, 0), +((@Cguid+132)*10, 22, 84.4622, 29.6961, -26.5286, 0, 0, 0, 0, 100, 0), +((@Cguid+132)*10, 23, 84.4622, 29.6961, -26.5286, 0, 0, 0, 0, 100, 0); + +DELETE FROM `creature_template_addon` WHERE `entry` IN (46252,46249,46251,46248,46250,46260,46263,46262,46261,46375,46382,46379,46381,46264,46254,46383,46300,46299,46406,46405,46407,46408,46411,46410,46409,46482,46417,1720); +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(46252, 0, 0, 0, 1, 0, ""), +(46249, 0, 0, 0, 1, 0, ""), +(46251, 0, 0, 0, 1, 0, ""), +(46248, 0, 0, 0, 1, 0, ""), +(46250, 0, 0, 0, 1, 0, ""), +(46260, 0, 0, 0, 1, 0, ""), +(46263, 0, 0, 0, 1, 0, "19818"), +(46262, 0, 0, 0, 1, 0, ""), +(46261, 0, 0, 0, 1, 0, ""), +(46375, 0, 0, 0, 1, 0, ""), +(46382, 0, 0, 3, 1, 0, ""), +(46379, 0, 0, 0, 1, 0, ""), +(46381, 0, 0, 0, 1, 0, "10022"), +(46264, 0, 0, 0, 1, 0, ""), +(46254, 0, 0, 0, 1, 0, ""), +(46383, 0, 0, 0, 1, 0, ""), +(46300, 0, 0, 0, 1, 0, "29266"), +(46299, 0, 0, 0, 1, 0, "29266"), +(46406, 0, 0, 0, 3, 214, ""), +(46405, 0, 0, 1, 1, 0, ""), +(46407, 0, 0, 3, 1, 0, ""), +(46408, 0, 0, 1, 1, 0, ""), +(46411, 0, 0, 0, 1, 0, ""), +(46410, 0, 0, 0, 1, 0, ""), +(46409, 0, 0, 0, 1, 0, ""), +(46482, 0, 0, 0, 1, 0, ""), +(46417, 0, 0, 0, 3, 214, ""), +(1720, 0, 0, 0, 4097, 0, ""); |