diff options
-rw-r--r-- | sql/updates/world/master/2021_09_26_15_world_2018_05_14_00_world.sql | 13 |
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); |