diff options
| -rw-r--r-- | sql/updates/world/master/2021_11_16_32_world_2018_12_08_45_world.sql | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_11_16_32_world_2018_12_08_45_world.sql b/sql/updates/world/master/2021_11_16_32_world_2018_12_08_45_world.sql new file mode 100644 index 00000000000..9188dcc8a16 --- /dev/null +++ b/sql/updates/world/master/2021_11_16_32_world_2018_12_08_45_world.sql @@ -0,0 +1,16 @@ +-- +DELETE FROM `gameobject` WHERE `guid` IN (6673,6674,6675,6677,6679); +INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnDifficulties`, `phaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES +(6673, 184689, 530, '0', 0, 1319.47, 6672.38, -19.1232, -1.48353, 0, 0, -0.67559, 0.737277, 300, 255, 1), +(6674, 184689, 530, '0', 0, 1310.23, 6705.16, -18.4085, -0.017452, 0, 0, -0.00872589, 0.999962, 300, 255, 1), +(6675, 184689, 530, '0', 0, 1368.66, 6687.15, -21.0585, -0.942477, 0, 0, -0.45399, 0.891007, 300, 255, 1), +(6677, 184689, 530, '0', 0, 1392.39, 6637.55, -15.6358, 1.55334, 0, 0, 0.700908, 0.713252, 300, 255, 1), +(6679, 184689, 530, '0', 0, 1395.99, 6693.23, -18.1502, 0.122173, 0, 0, 0.0610485, 0.998135, 300, 255, 1); + +DELETE FROM `creature` WHERE `guid` IN (154,3224,3225,168,1727); +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 +(154, 21238, 530, 0, 0, '0', 0, 0, 1, 1390.72, 6685.59, -17.414, 0.837758, 600, 5, 0, 5914, 0, 1, 0, 0, 0, 0), +(3224, 21238, 530, 0, 0, '0', 0, 0, 1, 1367.9, 6675.38, -19.5506, 2.41902, 600, 5, 0, 5914, 0, 1, 0, 0, 0, 0), +(3225, 21238, 530, 0, 0, '0', 0, 0, 1, 1321.46, 6680.95, -19.6069, 0.698132, 600, 5, 0, 5914, 0, 1, 0, 0, 0, 0), +(168, 21238, 530, 0, 0, '0', 0, 0, 1, 1387.14, 6643.17, -15.315, 5.77704, 600, 5, 0, 5914, 0, 1, 0, 0, 0, 0), +(1727, 21238, 530, 0, 0, '0', 0, 0, 1, 1342.002, 6585.488, -7.348, 5.056723, 600, 5, 0, 5914, 0, 1, 0, 0, 0, 0); |