diff options
| -rw-r--r-- | sql/updates/world/master/2021_11_26_01_world_2019_04_01_04_world.sql | 98 |
1 files changed, 98 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_11_26_01_world_2019_04_01_04_world.sql b/sql/updates/world/master/2021_11_26_01_world_2019_04_01_04_world.sql new file mode 100644 index 00000000000..3791cebc577 --- /dev/null +++ b/sql/updates/world/master/2021_11_26_01_world_2019_04_01_04_world.sql @@ -0,0 +1,98 @@ +-- +UPDATE `creature_template` SET `npcflag`=0 WHERE `entry`=17329; +DELETE FROM `spawn_group` WHERE `SpawnId` IN (SELECT `guid` FROM `creature` WHERE `id`IN (17190,17191,17192)) AND `spawnType`=0; +DELETE FROM `creature` WHERE `id` IN (17190,17191,17192); +DELETE FROM `creature` WHERE `guid` IN (61581, 61582, 61583, 61584, 61585, 61586, 61587, 61588, 61589, 61590, 61591, 61592, 61593, 61594, 61595, 61596, 61597, 61598, 61599, 61600, 61601, 61602, 61603, 61604, 61605, 61606, 61607, 61608, 61609, 61610, 61611, 61612, 61613, 61614, 61615, 61616, 61617, 61618, 61619, 61620, 61621, 61622, 61623, 61624, 61625, 61626, 61627, 61628, 61629, 61630, 61631, 61632, 61633, 61635, 61636, 61637, 61638, 61639, 61640, 61641, 61642, 61643, 61644, 61645, 61646, 61647, 61648, 61649, 61650, 61651, 61652, 61653, 61654, 61655, 61656, 61657, 61658, 61659, 61660, 61661, 61662, 61663, 61664, 61665, 61666, 61667, 61668, 61669, 61670, 61671); +DELETE FROM `spawn_group` WHERE `SpawnId` IN (62244,62242,62273,62228); +DELETE FROM `creature` WHERE `guid` IN (62244,62242,62273,62228); +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnDifficulties`, `phaseId`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`) VALUES +(61581, 17190, 530, '0', 0, 0, 0, -5339.16, -10945.9, -2.21631, 0.970282, 300,10, 0, 156, 0, 1), +(61582, 17190, 530, '0', 0, 0, 0, -5267.59, -10827.4, -2.89718, 0.656217, 300,10, 0, 156, 0, 1), +(61583, 17190, 530, '0', 0, 0, 0, -5180.63, -10766.1, -3.79157, 0.639632, 300,10, 0, 156, 0, 1), +(61584, 17190, 530, '0', 0, 0, 0, -5032.2, -10766.6, -0.983335, 3.76918, 300,10, 0, 156, 0, 1), +(61585, 17190, 530, '0', 0, 0, 0, -4935.96, -10766.5, -1.57371, 5.895, 300,10, 0, 156, 0, 1), +(61586, 17190, 530, '0', 0, 0, 0, -4935.27, -10767.8, -1.50384, 1.32733, 300,10, 0, 156, 0, 1), +(61587, 17190, 530, '0', 0, 0, 0, -5178.84, -10765.5, -3.77696, 3.17721, 300,10, 0, 156, 0, 1), +(61588, 17190, 530, '0', 0, 0, 0, -3350.34, -11855.3, -4.84148, 0.062541, 300, 5, 0, 156, 0, 1), +(61589, 17190, 530, '0', 0, 0, 0, -3262.35, -11874.6, -0.00628574, 5.03105, 300, 5, 0, 156, 0, 1), +(61590, 17190, 530, '0', 0, 0, 0, -3309.92, -11880.4, 1.23624, 5.21784, 300, 5, 0, 156, 0, 1), +(61591, 17190, 530, '0', 0, 0, 0, -3184.41, -11889.4, 0.524309, 5.06373, 300, 5, 0, 156, 0, 1), +(61592, 17190, 530, '0', 0, 0, 0, -3224.16, -11877.3, 0.44764, 4.68859, 300, 5, 0, 156, 0, 1), +(61593, 17190, 530, '0', 0, 0, 0, -3150.29, -11910.3, 1.9337, 2.97291, 300, 5, 0, 156, 0, 1), +(61594, 17190, 530, '0', 0, 0, 0, -3135.98, -11922.3, 2.04525, 4.40397, 300, 5, 0, 156, 0, 1), +(61595, 17190, 530, '0', 0, 0, 0, -3135.98, -11884.7, -6.47136, 6.2343, 300, 5, 0, 156, 0, 1), +(61596, 17190, 530, '0', 0, 0, 0, -3479.14, -11813.6, -5.3653, 0.981115, 300, 5, 0, 156, 0, 1), +(61597, 17190, 530, '0', 0, 0, 0, -3512.39, -11838, -0.415136, 4.37619, 300, 5, 0, 156, 0, 1), +(61598, 17190, 530, '0', 0, 0, 0, -3411.2, -11917.1, 1.60678, 4.62809, 300, 5, 0, 156, 0, 1), +(61599, 17190, 530, '0', 0, 0, 0, -3447.75, -11881.5, -0.527686, 2.50604, 300, 5, 0, 156, 0, 1), +(61600, 17190, 530, '0', 0, 0, 0, -3335.46, -11857.2, -4.04647, 3.03899, 300, 5, 0, 156, 0, 1), +(61601, 17190, 530, '0', 0, 0, 0, -3375.25, -11904.8, 2.06983, 5.7811, 300, 5, 0, 156, 0, 1), +(61602, 17190, 530, '0', 0, 0, 0, -3255.62, -11854.6, -4.27923, 0.218479, 300, 5, 0, 156, 0, 1), +(61603, 17190, 530, '0', 0, 0, 0, -3191.36, -11908.9, 2.1846, 4.56891, 300, 5, 0, 156, 0, 1), +(61604, 17190, 530, '0', 0, 0, 0, -3111.36, -11948.7, 1.78605, 3.85328, 300, 5, 0, 156, 0, 1), +(61605, 17190, 530, '0', 0, 0, 0, -4913.64, -10769.5, -1.97272, 3.90881, 300, 5, 0, 156, 0, 1), +(61606, 17190, 530, '0', 0, 0, 0, -4891.64, -10784.9, -2.44864, 3.90096, 300, 5, 0, 198, 0, 1), +(61607, 17190, 530, '0', 0, 0, 0, -5113.09, -10742, -2.14469, 4.94678, 300, 10, 0, 156, 0, 1), +(61608, 17190, 530, '0', 0, 0, 0, -5309.9, -10837.8, -2.44382, 4.49913, 300, 10, 0, 177, 0, 1), +(61609, 17190, 530, '0', 0, 0, 0, -5358.43, -10986.5, -2.38766, 5.63088, 300, 10, 0, 177, 0, 1), +(61610, 17190, 530, '0', 0, 0, 0, -5340.93, -10836.1, -2.37934, 4.74261, 300, 10, 0, 177, 0, 1), +(61611, 17190, 530, '0', 0, 0, 0, -5339.35, -10896.7, 0.552626, 6.21914, 300, 10, 0, 198, 0, 1), +(61612, 17190, 530, '0', 0, 0, 0, -5033.99, -10767, -0.947792, 6.13214, 300,10, 0, 156, 0, 1), +(61613, 17190, 530, '0', 0, 0, 0, -4854.59, -10834.4, -4.9846, 1.5708, 300,10, 0, 156, 0, 1), +(61614, 17190, 530, '0', 0, 0, 0, -4849.38, -10820.6, -6.80166, 1.18576, 300, 5, 0, 156, 0, 1), +(61615, 17190, 530, '0', 0, 0, 0, -4754.11, -10929.8, -2.4867, 4.35274, 300, 5, 0, 156, 0, 1), +(61616, 17190, 530, '0', 0, 0, 0, -3524.83, -11866.7, 1.9891, 3.92458, 300, 5, 0, 156, 0, 1), +(61617, 17190, 530, '0', 0, 0, 0, -3496.99, -11875.1, 0.657692, 4.91083, 300, 5, 0, 156, 0, 1), +(61618, 17190, 530, '0', 0, 0, 0, -3495.32, -11813.3, 1.44694, 3.61829, 300, 5, 0, 156, 0, 1), +(61619, 17190, 530, '0', 0, 0, 0, -3324.96, -11868.4, 0.197534, 4.2378, 300, 5, 0, 156, 0, 1), +(61620, 17190, 530, '0', 0, 0, 0, -3413.83, -11888.6, -0.713675, 3.19633, 300, 5, 0, 156, 0, 1), +(61621, 17190, 530, '0', 0, 0, 0, -3435.72, -11912.4, 1.45405, 1.27129, 300, 5, 0, 156, 0, 1), +(61622, 17191, 530, '0', 0, 0, 0, -4855.55, -10833.2, -4.92065, 6.08345, 300, 10, 0, 160, 350, 1), +(61623, 17191, 530, '0', 0, 0, 0, -4798.98, -10872, -2.28248, 2.81766, 300, 10, 0, 160, 350, 1), +(61624, 17191, 530, '0', 0, 0, 0, -4782.76, -10874.4, -2.18351, 1.39228, 300, 10, 0, 160, 350, 1), +(61625, 17191, 530, '0', 0, 0, 0, -4817.61, -10882, 1.32898, 6.10648, 300, 5, 0, 160, 350, 1), +(61626, 17191, 530, '0', 0, 0, 0, -4775.21, -10953.1, 1.31219, 5.11804, 300, 10, 0, 160, 350, 1), +(61627, 17191, 530, '0', 0, 0, 0, -3477.84, -11858.6, -1.73835, 4.39772, 300, 5, 0, 160, 350, 1), +(61628, 17191, 530, '0', 0, 0, 0, -3391.26, -11876.9, -2.57137, 0.902948, 300, 5, 0, 160, 350, 1), +(61629, 17191, 530, '0', 0, 0, 0, -3274.07, -11887.7, 1.60109, 4.60669, 300, 5, 0, 160, 350, 1), +(61630, 17191, 530, '0', 0, 0, 0, -3188.98, -11863.8, -5.80274, 1.31529, 300, 5, 0, 160, 350, 1), +(61631, 17191, 530, '0', 0, 0, 0, -3212.74, -11869.8, -1.48769, 1.19749, 300, 5, 0, 160, 350, 1), +(61632, 17191, 530, '0', 0, 0, 0, -3494.95, -11826.5, -2.35502, 3.68998, 300, 5, 0, 160, 350, 1), +(61633, 17191, 530, '0', 0, 0, 0, -3346.05, -11877.2, 1.20104, 4.98532, 300, 5, 0, 160, 350, 1), +(61635, 17191, 530, '0', 0, 0, 0, -3311.02, -11861.7, -0.946687, 5.29809, 300, 5, 0, 160, 350, 1), +(61636, 17191, 530, '0', 0, 0, 0, -3372.55, -11891.5, 0.926316, 6.13322, 300, 5, 0, 160, 350, 1), +(61637, 17191, 530, '0', 0, 0, 0, -3288.09, -11862.7, -1.60731, 2.2688, 300, 5, 0, 160, 350, 1), +(61638, 17191, 530, '0', 0, 0, 0, -3206.68, -11889.7, 1.5476, 4.9341, 300, 5, 0, 160, 350, 1), +(61639, 17191, 530, '0', 0, 0, 0, -3170.38, -11902.9, 1.57226, 5.01658, 300, 5, 0, 160, 350, 1), +(61640, 17191, 530, '0', 0, 0, 0, -3114.87, -11925.4, 0.331342, 3.68837, 300, 0, 0, 160, 350, 0), +(61641, 17191, 530, '0', 0, 0, 0, -5339.16, -10945.9, -2.21631, 0.284904, 300, 10, 0, 160, 350, 1), +(61642, 17191, 530, '0', 0, 0, 0, -5266.22, -10827.7, -2.66407, 2.10362, 300, 10, 0, 160, 350, 1), +(61643, 17191, 530, '0', 0, 0, 0, -5265.76, -10826.4, -2.83659, 3.49237, 300, 10, 0, 160, 350, 1), +(61644, 17191, 530, '0', 0, 0, 0, -5180.74, -10765.9, -3.82477, 0.438989, 300, 10, 0, 160, 350, 1), +(61645, 17191, 530, '0', 0, 0, 0, -5178.9, -10765.2, -3.79381, 3.48696, 300, 5, 0, 160, 350, 1), +(61646, 17191, 530, '0', 0, 0, 0, -4934.18, -10767.4, -1.64744, 2.59641, 300, 10, 0, 160, 350, 1), +(61647, 17191, 530, '0', 0, 0, 0, -5033.91, -10767.6, -0.906694, 0.447576, 300, 10, 0, 160, 350, 1), +(61648, 17191, 530, '0', 0, 0, 0, -4935.65, -10767.7, -1.48078, 0.890332, 300, 10, 0, 160, 350, 1), +(61649, 17191, 530, '0', 0, 0, 0, -4935.81, -10766.3, -1.61378, 5.61243, 300, 10, 0, 160, 350, 1), +(61650, 17191, 530, '0', 0, 0, 0, -4860.84, -10820.9, -5.84703, 2.03109, 300, 10, 0, 160, 350, 1), +(61651, 17191, 530, '0', 0, 0, 0, -4877.99, -10858, 0.108805, 3.66728, 300, 10, 0, 160, 350, 1), +(61652, 17191, 530, '0', 0, 0, 0, -4855.03, -10834.3, -4.88267, 1.09985, 300, 10, 0, 160, 350, 1), +(61653, 17191, 530, '0', 0, 0, 0, -5350.68, -11012.5, 0.1205, 5.7322, 300, 10, 0, 160, 350, 1), +(61654, 17191, 530, '0', 0, 0, 0, -5266.64, -10825.6, -3.16786, 4.5855, 300, 10, 0, 160, 350, 1), +(61655, 17191, 530, '0', 0, 0, 0, -5319.11, -10882.1, 2.57135, 0.473957, 300, 10, 0, 178, 382, 1), +(61656, 17192, 530, '0', 0, 0, 0, -5339.16, -10945.9, -2.21631, 0.462448, 300, 10, 0, 166,178, 1), +(61657, 17192, 530, '0', 0, 0, 0, -5178.92, -10765.9, -3.74916, 2.75202, 300, 10, 0, 166,178, 1), +(61658, 17192, 530, '0', 0, 0, 0, -5033.05, -10768.2, -0.895013, 1.52877, 300, 10, 0, 166,178, 1), +(61659, 17192, 530, '0', 0, 0, 0, -4935.9, -10767.4, -1.47325, 0.505071, 300, 10, 0, 166,178, 1), +(61660, 17192, 530, '0', 0, 0, 0, -5070.42, -10785.9, 0.96753, 0.141069, 300, 5, 0, 166,178, 1), +(61661, 17192, 530, '0', 0, 0, 0, -4994.86, -10787, 3.89861, 6.19518, 300, 5, 0, 166,178, 1), +(61662, 17192, 530, '0', 0, 0, 0, -4855.54, -10833.7, -4.96329, 0.272756, 300, 10, 0, 166,178, 1), +(61663, 17192, 530, '0', 0, 0, 0, -4799.51, -10872.6, -2.1335, 2.01696, 300, 10, 0, 166,178, 1), +(61664, 17192, 530, '0', 0, 0, 0, -3366.62, -11877.1, 0.15664, 0.238815, 300, 5, 0, 166,178, 1), +(61665, 17192, 530, '0', 0, 0, 0, -3392.95, -11903.3, 1.00181, 5.13319, 300, 5, 0, 166,178, 1), +(61666, 17192, 530, '0', 0, 0, 0, -3286.66, -11880.9, 1.05148, 3.17894, 300, 5, 0, 166,178, 1), +(61667, 17192, 530, '0', 0, 0, 0, -3508.78, -11855.4, -0.382846, 2.86063, 300, 5, 0, 166,178, 1), +(61668, 17192, 530, '0', 0, 0, 0, -3234.23, -11888.3, 0.98577, 6.19023, 300, 5, 0, 166,178, 1), +(61669, 17192, 530, '0', 0, 0, 0, -3170.79, -11883.3, -1.17139, 0, 300, 5, 0, 166,178, 1), +(61670, 17192, 530, '0', 0, 0, 0, -3101.09, -11932.9, -2.14384, 5.8455, 300, 5, 0, 166,178, 1), +(61671, 17192, 530, '0', 0, 0, 0, -5286.12, -10856.5, 0.242065, 5.02142, 300, 5, 0, 186, 191, 1); |