DB/Creature: Add some missing spawns to Tempest Keep

(cherry picked from commit 99b95ae446a99356e6360ae38534710d9799da2b)

1 files changed, 13 insertions, 0 deletions

diff --git a/sql/updates/world/master/2021_09_26_15_world_2018_05_14_00_world.sql b/sql/updates/world/master/2021_09_26_15_world_2018_05_14_00_world.sql
new file mode 100644
index 00000000000..d39666704e0
--- /dev/null
+++ b/sql/updates/world/master/2021_09_26_15_world_2018_05_14_00_world.sql
@@ -0,0 +1,13 @@
+-- 
+DELETE FROM `creature` WHERE `guid` IN (48255,64988,64989,64990,64991,64992,64993,75558,84444,84484);
+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`, `ScriptName`, `VerifiedBuild`) VALUES
+(48255, 20038, 550, 0, 0, '4', 0, 0, 0, 310.438, 41.6756, -2.38937, 3.79216, 300, 0, 0, 48902, 0, 0, 0, 0, 0, "", 0),
+(64988, 20038, 550, 0, 0, '4', 0, 0, 0, 313.605, 38.1466, -2.38937, 3.53769, 300, 0, 0, 48902, 0, 0, 0, 0, 0, "", 0),
+(64989, 20037, 550, 0, 0, '4', 0, 0, 1, 319.51, 43.7734, -2.38937, 3.57472, 300, 0, 0, 100520, 16155, 0, 0, 0, 0, "", 0),
+(64990, 20037, 550, 0, 0, '4', 0, 0, 1, 339.52, -50.6231, -2.38754, 0.416626, 300, 0, 0, 100520, 16155, 0, 0, 0, 0, "", 0),
+(64991, 20038, 550, 0, 0, '4', 0, 0, 0, 348.485, -42.0046, -2.38833, 0.531368, 300, 0, 0, 48902, 0, 0, 0, 0, 0, "", 0),
+(64992, 20038, 550, 0, 0, '4', 0, 0, 0, 352.302, -40.07, -2.38816, 0.492098, 300, 0, 0, 48902, 0, 0, 0, 0, 0, "", 0),
+(64993, 20037, 550, 0, 0, '4', 0, 0, 1, 358.22, -39.9547, -2.38682, 0.465866, 300, 0, 0, 100520, 16155, 0, 0, 0, 0, "", 0),
+(75558, 20052, 550, 0, 0, '4', 0, 0, 0, 433.013, 324.812, 15.4822, 1.68793, 300, 0, 0, 125668, 0, 0, 0, 0, 0, "", 0),
+(84444, 20052, 550, 0, 0, '4', 0, 0, 0, 479.372, 376.597, 15.5883, 3.10479, 300, 0, 0, 125668, 0, 0, 0, 0, 0, "", 0),
+(84484, 20042, 550, 0, 0, '4', 0, 0, 0, 401.508, 356.858, 14.8947, 3.68035, 300, 0, 0, 125668, 0, 0, 0, 0, 0, "", 0);