DB/Creature: Orc Captive

(cherry picked from commit e23de2c0b3f7e3f2425bde136348f9968460ed59)

1 files changed, 41 insertions, 0 deletions

diff --git a/sql/updates/world/master/2021_11_30_08_world_2019_04_15_02_world.sql b/sql/updates/world/master/2021_11_30_08_world_2019_04_15_02_world.sql
new file mode 100644
index 00000000000..c5e6a833b95
--- /dev/null
+++ b/sql/updates/world/master/2021_11_30_08_world_2019_04_15_02_world.sql
@@ -0,0 +1,41 @@
+-- 
+DELETE FROM `creature` WHERE `guid` IN (98691, 98825, 98856, 98886, 98887, 98888, 98889, 98890, 98891, 98892, 98920, 98921, 98922, 99014, 99015, 99017, 99100, 99101, 99102, 99141, 99142, 99143, 99144, 99146, 99147, 99148, 99149, 99150, 99151, 99163, 99172, 99177, 99178, 99179, 99180, 99232, 99285, 99292);
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `phaseId`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
+(98691, 17416, 542, 3713, 0, '1,2', 0, 0, 0, 291.2416, 65.75761, 38.2571, 0.1745329, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17416 (Area: 0 - Difficulty: 0)
+(98825, 17416, 542, 3713, 0, '1,2', 0, 0, 0, 288.1224, 61.92174, 24.67354, 0.08726646, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17416 (Area: 0 - Difficulty: 0)
+(98856, 17416, 542, 3713, 0, '1,2', 0, 0, 0, 287.8983, 70.71174, 9.728408, 4.39823, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17416 (Area: 0 - Difficulty: 0)
+(98886, 17416, 542, 3713, 0, '1,2', 0, 0, 0, 290.99, 67.86472, 38.29261, 0.1570796, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17416 (Area: 0 - Difficulty: 0)
+(98887, 17416, 542, 3713, 0, '1,2', 0, 0, 0, 286.7125, 66.71518, 9.729496, 6.091199, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17416 (Area: 0 - Difficulty: 0)
+(98888, 17416, 542, 3713, 0, '1,2', 0, 0, 0, 291.3253, 71.80742, 38.2329, 0.06981317, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17416 (Area: 0 - Difficulty: 0)
+(98889, 17416, 542, 3713, 0, '1,2', 0, 0, 0, 280.2032, 66.83339, 9.742268, 4.29351, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17416 (Area: 0 - Difficulty: 0)
+(98890, 17416, 542, 3713, 0, '1,2', 0, 0, 0, 286.7247, 65.30663, 24.57115, 0.1919862, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17416 (Area: 0 - Difficulty: 0)
+(98891, 17416, 542, 3713, 0, '1,2', 0, 0, 0, 280.1422, 70.35688, 9.743082, 6.178465, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17416 (Area: 0 - Difficulty: 0)
+(98892, 17416, 542, 3713, 0, '1,2', 0, 0, 0, 286.996, 58.7694, 24.53737, 0.2617994, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17416 (Area: 0 - Difficulty: 0)
+(98920, 17416, 542, 3713, 0, '1,2', 0, 0, 0, 288.5455, 90.53412, 24.36032, 0.01745329, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17416 (Area: 0 - Difficulty: 0)
+(98921, 17416, 542, 3713, 0, '1,2', 0, 0, 0, 367.3434, 64.74551, 24.56784, 2.949606, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17416 (Area: 0 - Difficulty: 0)
+(98922, 17416, 542, 3713, 0, '1,2', 0, 0, 0, 370.1193, 66.68924, 9.734657, 3.01942, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17416 (Area: 0 - Difficulty: 0)
+(99014, 17416, 542, 3713, 0, '1,2', 0, 0, 0, 287.6116, 95.63541, 24.37004, 0.122173, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17416 (Area: 0 - Difficulty: 0)
+(99015, 17416, 542, 3713, 0, '1,2', 0, 0, 0, 366.7844, 61.8883, 24.68211, 3.159046, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17416 (Area: 0 - Difficulty: 0)
+(99017, 17416, 542, 3713, 0, '1,2', 0, 0, 0, 288.8896, 93.17731, 24.64306, 0.08726646, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17416 (Area: 0 - Difficulty: 0)
+(99100, 17416, 542, 3713, 0, '1,2', 0, 0, 0, 364.5201, 66.25753, 38.44445, 2.96706, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17416 (Area: 0 - Difficulty: 0)
+(99101, 17416, 542, 3713, 0, '1,2', 0, 0, 0, 367.4579, 70.47686, 9.729537, 3.159046, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17416 (Area: 0 - Difficulty: 0)
+(99102, 17416, 542, 3713, 0, '1,2', 0, 0, 0, 287.0422, 97.94891, 9.729769, 4.904375, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17416 (Area: 0 - Difficulty: 0)
+(99141, 17416, 542, 3713, 0, '1,2', 0, 0, 0, 367.6326, 58.40127, 24.5171, 2.897247, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17416 (Area: 0 - Difficulty: 0)
+(99142, 17416, 542, 3713, 0, '1,2', 0, 0, 0, 364.9377, 69.1484, 38.51243, 3.281219, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17416 (Area: 0 - Difficulty: 0)
+(99143, 17416, 542, 3713, 0, '1,2', 0, 0, 0, 281.5589, 99.54732, 9.741151, 2.6529, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17416 (Area: 0 - Difficulty: 0)
+(99144, 17416, 542, 3713, 0, '1,2', 0, 0, 0, 373.1786, 69.15133, 9.740856, 3.141593, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17416 (Area: 0 - Difficulty: 0)
+(99146, 17416, 542, 3713, 0, '1,2', 0, 0, 0, 285.4963, 101.8543, 9.733561, 3.979351, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17416 (Area: 0 - Difficulty: 0)
+(99147, 17416, 542, 3713, 0, '1,2', 0, 0, 0, 290.2963, 97.91277, 38.42908, 6.265732, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17416 (Area: 0 - Difficulty: 0)
+(99148, 17416, 542, 3713, 0, '1,2', 0, 0, 0, 364.9705, 71.82652, 38.51822, 3.211406, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17416 (Area: 0 - Difficulty: 0)
+(99149, 17416, 542, 3713, 0, '1,2', 0, 0, 0, 365.7691, 91.09628, 24.45182, 3.228859, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17416 (Area: 0 - Difficulty: 0)
+(99150, 17416, 542, 3713, 0, '1,2', 0, 0, 0, 367.1545, 93.00603, 24.69671, 3.141593, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17416 (Area: 0 - Difficulty: 0)
+(99151, 17416, 542, 3713, 0, '1,2', 0, 0, 0, 366.2176, 97.75723, 9.726248, 2.024582, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17416 (Area: 0 - Difficulty: 0)
+(99163, 17416, 542, 3713, 0, '1,2', 0, 0, 0, 365.768, 94.95737, 24.43487, 3.228859, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17416 (Area: 0 - Difficulty: 0)
+(99172, 17416, 542, 3713, 0, '1,2', 0, 0, 0, 373.0691, 97.87877, 9.740945, 1.134464, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17416 (Area: 0 - Difficulty: 0)
+(99177, 17416, 542, 3713, 0, '1,2', 0, 0, 0, 364.7859, 96.31538, 38.50808, 2.879793, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17416 (Area: 0 - Difficulty: 0)
+(99178, 17416, 542, 3713, 0, '1,2', 0, 0, 0, 290.0792, 103.6548, 38.47709, 6.038839, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17416 (Area: 0 - Difficulty: 0)
+(99179, 17416, 542, 3713, 0, '1,2', 0, 0, 0, 364.9154, 102.1417, 38.52384, 2.844887, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17416 (Area: 0 - Difficulty: 0)
+(99180, 17416, 542, 3713, 0, '1,2', 0, 0, 0, 366.7072, 101.5718, 9.727448, 1.43117, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17416 (Area: 0 - Difficulty: 0)
+(99232, 17416, 542, 3713, 0, '1,2', 0, 0, 0, 364.1879, 99.67516, 38.35348, 2.96706, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17416 (Area: 0 - Difficulty: 0)
+(99285, 17416, 542, 3713, 0, '1,2', 0, 0, 0, 374.2216, 101.5313, 9.743157, 4.590216, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17416 (Area: 0 - Difficulty: 0)
+(99292, 17416, 542, 3713, 0, '1,2', 0, 0, 0, 291.076, 100.2189, 38.27271, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159); -- 17416 (Area: 0 - Difficulty: 0)