diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2019_01_12_14_world.sql | 35 |
1 files changed, 35 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_01_12_14_world.sql b/sql/updates/world/3.3.5/2019_01_12_14_world.sql new file mode 100644 index 00000000000..cfccb28cff4 --- /dev/null +++ b/sql/updates/world/3.3.5/2019_01_12_14_world.sql @@ -0,0 +1,35 @@ +-- +DELETE FROM `creature` WHERE `guid` IN (95109,95110,95111,95149,95150,95151,95152,95153,95154,95155,95156,95157,95158,95159,95167,95168,95169,95170,95171,95195,95196,95197,95202,95203,95204,95205,95207,95208,95211,95212,95237,95239); +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`) VALUES +(95109, 22241, 530, 1, 1, 0, 1, 4023.13, 5849.69, 266.066, 3.75246, 300, 0, 0, 6986, 0, 0), +(95110, 22241, 530, 1, 1, 0, 1, 4000.29, 5894.65, 266.54, 3.87463, 300, 0, 0, 7181, 0, 0), +(95111, 22243, 530, 1, 1, 0, 1, 3912.05, 6093.59, 270.567, 5.58119, 300, 0, 0, 5903, 3309, 0), +(95149, 22243, 530, 1, 1, 0, 1, 3695.35, 6004.69, 265.265, 5.92225, 300, 0, 0, 5744, 3231, 0), +(95150, 22241, 530, 1, 1, 0, 1, 3957.18, 6082.14, 269.598, 4.86947, 300, 0, 0, 7181, 0, 0), +(95151, 22243, 530, 1, 1, 0, 1, 4006.68, 5924.28, 267.573, 4.53786, 300, 0, 0, 5744, 3231, 0), +(95152, 22243, 530, 1, 1, 0, 1, 4040.06, 5875.89, 267.873, 3.47321, 300, 0, 0, 5903, 3309, 0), +(95153, 22243, 530, 1, 1, 0, 1, 3981.69, 6067.01, 266.442, 3.644259, 300, 0, 0, 5903, 3309, 0), +(95154, 22243, 530, 1, 1, 0, 1, 3926.36, 6023.15, 269.678, 1.71042, 300, 0, 0, 5744, 3231, 0), +(95155, 22242, 530, 1, 1, 0, 1, 3953.83, 6023.34, 266.039, 1.39232, 300, 0, 0, 5589, 3155, 0), +(95156, 22242, 530, 1, 1, 0, 1, 3970.4, 5910.05, 267.363, 4.93839, 300, 0, 0, 5744, 3231, 0), +(95157, 22242, 530, 1, 1, 0, 1, 3951.97, 5963.87, 266.679, 4.85202, 300, 0, 0, 5589, 3155, 0), +(95158, 22242, 530, 1, 1, 0, 1, 4014.49, 5876.32, 267.872, 3.80482, 300, 0, 0, 5744, 3231, 0), +(95159, 22242, 530, 1, 1, 0, 1, 3920.99, 5973.4, 267.398, 4.85202, 300, 0, 0, 5589, 3155, 0), +(95167, 22243, 530, 1, 1, 0, 1, 4053.6235, 5601.3105, 267.276, 2.254693, 300, 3, 0, 5903, 3309, 1), +(95168, 22243, 530, 1, 1, 0, 1, 4059.1462, 5594.0625, 267.276, 5.513842, 300, 3, 0, 5903, 3309, 1), +(95169, 22243, 530, 1, 1, 0, 1, 4069.7180, 5584.5781, 267.276, 2.140568, 300, 3, 0, 5903, 3309, 1), +(95170, 22243, 530, 1, 1, 0, 1, 4075.5078, 5600.2343, 267.275, 0.718997, 300, 3, 0, 5903, 3309, 1), +(95171, 22243, 530, 1, 1, 0, 1, 4053.3730, 5578.3569, 267.275, 3.892006, 300, 3, 0, 5903, 3309, 1), +(95195, 22243, 530, 1, 1, 0, 1, 4075.6162, 5578.0249, 267.276, 5.443168, 300, 3, 0, 5903, 3309, 1), +(95196, 22243, 530, 1, 1, 0, 1, 3917.178, 5117.499, 270.091, 0.593332, 300, 3, 0, 5903, 3309, 1), +(95197, 22243, 530, 1, 1, 0, 1, 3910.865, 5107.542, 270.091, 4.005892, 300, 3, 0, 5903, 3309, 1), +(95202, 22243, 530, 1, 1, 0, 1, 3901.098, 5096.722, 270.093, 0.766121, 300, 3, 0, 5903, 3309, 1), +(95203, 22243, 530, 1, 1, 0, 1, 3895.511, 5087.138, 270.093, 4.029447, 300, 3, 0, 5903, 3309, 1), +(95204, 22243, 530, 1, 1, 0, 1, 3916.576, 5086.174, 270.093, 5.557051, 300, 3, 0, 5903, 3309, 1), +(95205, 22243, 530, 1, 1, 0, 1, 3894.636, 5117.943, 270.093, 2.156276, 300, 3, 0, 5903, 3309, 1), +(95207, 22243, 530, 1, 1, 0, 1, 4005.711, 5324.081, 269.730, 4.005891, 300, 3, 0, 5903, 3309, 1), +(95208, 22243, 530, 1, 1, 0, 1, 4009.549, 5332.207, 269.730, 0.589409, 300, 3, 0, 5903, 3309, 1), +(95211, 22243, 530, 1, 1, 0, 1, 4019.608, 5342.735, 269.731, 3.903789, 300, 3, 0, 5903, 3309, 1), +(95212, 22243, 530, 1, 1, 0, 1, 4024.584, 5351.215, 269.731, 0.899641, 300, 3, 0, 5903, 3309, 1), +(95237, 22243, 530, 1, 1, 0, 1, 4005.748, 5351.169, 269.732, 2.105227, 300, 3, 0, 5903, 3309, 1), +(95239, 22243, 530, 1, 1, 0, 1, 4023.986, 5322.842, 269.730, 5.502076, 300, 3, 0, 5903, 3309, 1); |