diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2019_06_20_02_world_335.sql | 66 |
1 files changed, 66 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_06_20_02_world_335.sql b/sql/updates/world/3.3.5/2019_06_20_02_world_335.sql new file mode 100644 index 00000000000..d72adcfa958 --- /dev/null +++ b/sql/updates/world/3.3.5/2019_06_20_02_world_335.sql @@ -0,0 +1,66 @@ +-- +UPDATE `gameobject_template_addon` SET `flags`=0 WHERE `entry` =174610; +UPDATE `gameobject_template` SET `size`=2 WHERE `entry` IN (174711,174618,174619,164884,174620,174710,174616); +DELETE FROM `gameobject_addon` WHERE `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` IN (164885,174597,171939,164886,173324,164888,174594,171942,174595,164887,173327,174596,173284,174598,174599,174600,174601,174603,174604,174602,174605,174607,174708,174686,174608,174684,174606,174712,174713,174709,164881, 164882, 164883, 164884, 171940, 171943, 173325, 173326, 174609, 174610, 174612, 174613, 174614, 174615, 174616, 174617, 174618, 174619, 174620, 174621, 174622, 174623, 174624, 174625, 174685, 174687, 174710, 174711, 174714, 174715)); +DELETE FROM `gameobject` WHERE `id` IN (164885,174597,171939,164886,173324,164888,174594,171942,174595,164887,173327,174596,173284,174598,174599,174600,174601,174603,174604,174602,174605,174607,174708,174686,174608,174684,174606,174712,174713,174709,164881, 164882, 164883, 164884, 171940, 171943, 173325, 173326, 174609, 174610, 174612, 174613, 174614, 174615, 174616, 174617, 174618, 174619, 174620, 174621, 174622, 174623, 174624, 174625, 174685, 174687, 174710, 174711, 174714, 174715); +INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES +(9010, 164882, 1, 1, 1, 3723.64, -1402.23, 200.395, 5.30595, 0, 0, 0.469405, -0.882983, -1, 100, 1), +(9028, 164886, 1, 1, 1, 3723.64, -1402.23, 200.395, 5.30595, 0, 0, 0.469405, -0.882983, 1500, 100, 1), +(9029, 174609, 1, 1, 1, 3780.32, -1176, 220.555, 0.167, 0, 0, 0.083403, 0.996516, -1, 100, 1), +(9030, 173324, 1, 1, 1, 3780.32, -1176, 220.555, 0.167, 0, 0, 0.083403, 0.996516, 1500, 100, 1), +(9031, 164885, 1, 1, 1, 3831.22, -1374, 207.119, 0.85, 0, 0, 0.412321, 0.911039, 1500, 100, 1), +(9046, 164881, 1, 1, 1, 3831.22, -1374, 207.119, 0.85, 0, 0, 0.412321, 0.911039, -1, 100, 1), +(9047, 171939, 1, 1, 1, 3856.6, -1014.86, 241.341, 5.6366, 0, 0, 0.31769, -0.948195, 1500, 100, 1), +(9048, 171940, 1, 1, 1, 3856.6, -1014.86, 241.341, 5.6366, 0, 0, 0.31769, -0.948195, -1, 100, 1), +(9049, 164884, 1, 1, 1, 4066.66, -1233.34, 282.075, -1.15192, 0, 0, -0.54464, 0.83867, -1, 100, 1), +(9050, 164887, 1, 1, 1, 4066.66, -1233.34, 282.075, -1.15192, 0, 0, -0.54464, 0.83867, 1500, 100, 1), +(9051, 171943, 1, 1, 1, 4191.83, -1147.7, 315.197, 2.72276, 0, 0, 0.978153, 0.207887, -1, 100, 1), +(9057, 171942, 1, 1, 1, 4191.83, -1147.7, 315.197, 2.72276, 0, 0, 0.978153, 0.207887, 1500, 100, 1), +(9058, 174616, 1, 1, 1, 4774.45, -484.409, 330.46, 2.52721, 0, 0, 0.953187, 0.302383, -1, 100, 1), +(9060, 174602, 1, 1, 1, 4774.45, -484.409, 330.46, 2.52721, 0, 0, 0.953187, 0.302383, 1500, 100, 1), +(9092, 174684, 1, 1, 1, 4867.17, -384, 350.56, 2.762, 0, 0, 0.982043, 0.188659, 1500, 100, 1), +(9093, 173325, 1, 1, 1, 4867.17, -384, 350.56, 2.762, 0, 0, 0.982043, 0.188659, -1, 100, 1), +(9094, 174594, 1, 1, 1, 4959.46, -681.357, 294.914, 4.67448, 0, 0, 0.720383, -0.693577, 1500, 100, 1), +(9095, 174610, 1, 1, 1, 4959.46, -681.357, 294.914, 4.67448, 0, 0, 0.720383, -0.693577, -1, 100, 1), +(9102, 174617, 1, 1, 1, 5259.69, -351.762, 322.032, 4.56296, 0, 0, 0.757916, -0.652352, -1, 100, 1), +(9105, 174603, 1, 1, 1, 5259.69, -351.762, 322.032, 4.56296, 0, 0, 0.757916, -0.652352, 1500, 100, 1), +(9106, 173327, 1, 1, 1, 5533.32, -933, 376.883, 1.222, 0, 0, 0.573687, 0.819075, 1500, 100, 1), +(9107, 174711, 1, 1, 1, 5533.32, -933, 376.883, 1.222, 0, 0, 0.573687, 0.819075, -1, 100, 1), +(9108, 174604, 1, 1, 1, 5539.47, -932.794, 378.093, 0.13724, 0, 0, 0.0685662, 0.997647, 1500, 100, 1), +(9109, 174618, 1, 1, 1, 5539.47, -932.794, 378.093, 0.13724, 0, 0, 0.0685662, 0.997647, -1, 100, 1), +(9110, 173326, 1, 1, 1, 6233.34, -1533.33, 441.796, 0, 0, 0, 0, 1, -1, 100, 1), +(9111, 174599, 1, 1, 1, 6233.34, -1533.33, 441.796, 0, 0, 0, 0, 1, 1500, 100, 1), +(9112, 174708, 1, 1, 1, 6268.1, -1520.2, 442.386, 0.748996, 0, 0, 0.365805, 0.930691, 1500, 100, 1), +(9123, 174621, 1, 1, 1, 6268.1, -1520.2, 442.386, 0.748996, 0, 0, 0.365805, 0.930691, -1, 100, 1), +(9129, 174600, 1, 1, 1, 6271.71, -605.54, 469.165, 2.69449, 0, 0, 0.975116, 0.221694, 1500, 100, 1), +(9133, 174619, 1, 1, 1, 6271.71, -605.54, 469.165, 2.69449, 0, 0, 0.975116, 0.221694, -1, 100, 1), +(9141, 174597, 1, 1, 1, 6297.82, -1972.49, 562.09, 5.38682, 0, 0, 0.433329, -0.901236, 1500, 100, 1), +(9142, 174614, 1, 1, 1, 6297.82, -1972.49, 562.09, 5.38682, 0, 0, 0.433329, -0.901236, -1, 100, 1), +(9143, 164888, 1, 1, 1, 6305.33, -957, 417.3, 2.499, 0, 0, 0.948827, 0.315797, 1500, 100, 1), +(9145, 164883, 1, 1, 1, 6305.33, -957, 417.3, 2.499, 0, 0, 0.948827, 0.315797, -1, 100, 1), +(9149, 174606, 1, 1, 1, 6353.12, -690.658, 477.432, 0.730612, 0, 0, 0.357235, 0.934014, 1500, 100, 1), +(9150, 174624, 1, 1, 1, 6353.12, -690.658, 477.432, 0.730612, 0, 0, 0.357235, 0.934014, -1, 100, 1), +(9151, 174709, 1, 1, 1, 6366.73, -1666.05, 480.158, 1.08907, 0, 0, 0.51802, 0.855368, 1500, 100, 1), +(9152, 174710, 1, 1, 1, 6366.73, -1666.05, 480.158, 1.08907, 0, 0, 0.51802, 0.855368, -1, 100, 1), +(9162, 174620, 1, 1, 1, 6422.47, -957.439, 423.074, 4.52048, 0, 0, 0.7716, -0.636108, -1, 100, 1), +(9163, 174601, 1, 1, 1, 6422.47, -957.439, 423.074, 4.52048, 0, 0, 0.7716, -0.636108, 1500, 100, 1), +(9164, 173284, 1, 1, 1, 6433.25, -1267, 383.206, 2.234, 0, 0, 0.898789, 0.438381, 1500, 100, 1), +(9165, 174622, 1, 1, 1, 6433.25, -1267, 383.206, 2.234, 0, 0, 0.898789, 0.438381, -1, 100, 1), +(9169, 174607, 1, 1, 1, 6434.15, -1268.32, 383.379, 3.20225, 0, 0, 0.99954, -0.030324, 1500, 100, 1), +(9171, 174625, 1, 1, 1, 6434.15, -1268.32, 383.379, 3.20225, 0, 0, 0.99954, -0.030324, -1, 100, 1), +(9172, 174685, 1, 1, 1, 6595.34, -827.373, 474.05, 3.28765, 0, 0, 0.997335, -0.0729638, -1, 100, 1), +(9173, 174608, 1, 1, 1, 6595.34, -827.373, 474.05, 3.28765, 0, 0, 0.997335, -0.0729638, 1500, 100, 1), +(9177, 174598, 1, 1, 1, 6599.99, -1266.66, 448.401, 1.98968, 0, 0, 0.838671, 0.544639, 1500, 100, 1), +(9178, 174615, 1, 1, 1, 6599.99, -1266.66, 448.401, 1.98968, 0, 0, 0.838671, 0.544639, -1, 100, 1), +(9179, 174605, 1, 1, 1, 6666.67, -1200, 471.328, 2.164, 0, 0, 0.882899, 0.469563, 1500, 100, 1), +(9181, 174623, 1, 1, 1, 6666.67, -1200, 471.328, 2.164, 0, 0, 0.882899, 0.469563, -1, 100, 1), +(9182, 174687, 1, 1, 1, 6669.76, -1209.39, 469.181, 3.43473, 0, 0, 0.989278, -0.146044, -1, 100, 1), +(9190, 174686, 1, 1, 1, 6669.76, -1209.39, 469.181, 3.43473, 0, 0, 0.989278, -0.146044, 1500, 100, 1), +(9191, 174712, 1, 1, 1, 6724.35, -1578.87, 475.274, 2.44158, 0, 0, 0.93937, 0.342906, 1500, 100, 1), +(9201, 174714, 1, 1, 1, 6724.35, -1578.87, 475.274, 2.44158, 0, 0, 0.93937, 0.342906, -1, 100, 1), +(9202, 174596, 1, 1, 1, 6733.31, -1566.68, 477.04, -2.82743, 0, 0, 0.987688, -0.156434, 1500, 100, 1), +(9203, 174613, 1, 1, 1, 6733.31, -1566.68, 477.04, -2.82743, 0, 0, 0.987688, -0.156434, -1, 100, 1), +(9209, 174715, 1, 1, 1, 6868.36, -2025.77, 577.324, 2.49261, 0, 0, 0.947813, 0.318828, -1, 100, 1), +(9211, 174713, 1, 1, 1, 6868.36, -2025.77, 577.324, 2.49261, 0, 0, 0.947813, 0.318828, 1500, 100, 1), +(9213, 174595, 1, 1, 1, 6900, -2033.33, 583.696, 1.81514, 0, 0, 0.788011, 0.615662, 1500, 100, 1), +(9215, 174612, 1, 1, 1, 6900, -2033.33, 583.696, 1.81514, 0, 0, 0.788011, 0.615662, -1, 100, 1); |