DB/Creature: Add missing spawn to the Hibernal Cavern

(cherry picked from commit 6d569eb60a6ee036cab784b3fc13c4e3ec4bfeb9)

1 files changed, 33 insertions, 0 deletions

diff --git a/sql/updates/world/master/2019_09_15_01_world_2017_01_11_15_world.sql b/sql/updates/world/master/2019_09_15_01_world_2017_01_11_15_world.sql
new file mode 100644
index 00000000000..7b386b14d21
--- /dev/null
+++ b/sql/updates/world/master/2019_09_15_01_world_2017_01_11_15_world.sql
@@ -0,0 +1,33 @@
+-- Ravenous Jormungar (29605)
+-- Icemaw Bear (29562)
+DELETE FROM `creature` WHERE `guid` IN (47005,47007,47011,47014,47015,47019,47020,47022,47024,47058,47059,47269,47270,47271,58296,72679,72679,72694,73925,73926,73927,73928,73929,73930,73931,73932,73933,73934,73935,73936);
+INSERT INTO `creature` (`guid`, `id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`) VALUES
+(47005, 29605, 571, 0, 0, 7329.02, -2096.36, 772.981, 4.2904, 300, 5, 0, 12175, 0, 1),
+(47007, 29605, 571, 0, 0, 7315.78, -2071.91, 763.048, 3.6818, 300, 5, 0, 12175, 0, 1),
+(47011, 29605, 571, 0, 0, 7315, -2021.31, 763.381, 5.7145, 300, 5, 0, 12175, 0, 1),
+(47014, 29605, 571, 0, 0, 7304.69, -2036.38, 762.714, 0.867, 300, 5, 0, 12175, 0, 1),
+(47015, 29605, 571, 0, 0, 7280.62, -2072.3, 761.956, 0.4111, 300, 5, 0, 12175, 0, 1),
+(47019, 29605, 571, 0, 0, 7272.03, -2014.92, 768.024, 5.081, 300, 5, 0, 12175, 0, 1),
+(47020, 29605, 571, 0, 0, 7270.6, -2119.66, 776.91, 4.382, 300, 5, 0, 12175, 0, 1),
+(47022, 29605, 571, 0, 0, 7252.53, -2072.12, 763.08, 2.8011, 300, 5, 0, 12175, 0, 1),
+(47024, 29605, 571, 0, 0, 7250.86, -2092.35, 774.785, 3.593, 300, 5, 0, 12175, 0, 1),
+(47058, 29605, 571, 0, 0, 7208.14, -2036.18, 764.755, 4.6086, 300, 5, 0, 12175, 0, 1),
+(47059, 29605, 571, 0, 0, 7181.413, -2030.195, 766.1735, 0.143750, 300, 5, 0, 12175, 0, 1),
+(47269, 29605, 571, 0, 0, 7209.085, -1997.225, 767.6403, 0.882025, 300, 5, 0, 12175, 0, 1),
+(47270, 29605, 571, 0, 0, 7342.41, -2037.04, 763.419, 2.9583, 300, 5, 0, 12175, 0, 1),
+(47271, 29605, 571, 0, 0, 7203.25, -2056.41, 765.201, 5.4181, 300, 5, 0, 12175, 0, 1),
+(58296, 29605, 571, 0, 0, 7158.9, -2137.43, 764.273, 3.6641, 300, 5, 0, 12175, 0, 1),
+(72679, 29562, 571, 0, 0, 7340.23, -2057.24, 764.845, 0.5759, 300, 5, 0, 12600, 0, 1),
+(72694, 29562, 571, 0, 0, 7314.18, -2095.16, 774.167, 5.8468, 300, 5, 0, 12600, 0, 1),
+(73925, 29562, 571, 0, 0, 7296.43, -2007.46, 765.695, 3.3859, 300, 5, 0, 12600, 0, 1),
+(73926, 29562, 571, 0, 0, 7248.95, -2123.74, 778.771, 3.6128, 300, 5, 0, 12600, 0, 1),
+(73927, 29562, 571, 0, 0, 7234.18, -2082.77, 764.002, 1.1344, 300, 5, 0, 12600, 0, 1),
+(73928, 29562, 571, 0, 0, 7207.93, -2038.16, 764.583, 5.3058, 300, 5, 0, 12600, 0, 1),
+(73929, 29562, 571, 0, 0, 7202.35, -2113.44, 768.618, 4.276, 300, 5, 0, 12600, 0, 1),
+(73930, 29562, 571, 0, 0, 7198.54, -2107.91, 766.632, 2.1293, 300, 5, 0, 12600, 0, 1),
+(73931, 29562, 571, 0, 0, 7290.5, -2114.23, 775.277, 4.0142, 300, 5, 0, 12600, 0, 1),
+(73932, 29562, 571, 0, 0, 7289.43, -2024.69, 771.763, 1.274, 300, 5, 0, 12600, 0, 1),
+(73933, 29562, 571, 0, 0, 7283.68, -2046.53, 761.719, 2.6354, 300, 5, 0, 12600, 0, 1),
+(73934, 29562, 571, 0, 0, 7262.65, -2075.82, 764.758, 3.4557, 300, 5, 0, 12600, 0, 1),
+(73935, 29562, 571, 0, 0, 7248.99, -2088.13, 774.497, 2.1467, 300, 5, 0, 12600, 0, 1),
+(73936, 29562, 571, 0, 0, 7162.11, -2132.87, 762.305, 5.1836, 300, 5, 0, 12600, 0, 1);