diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2019_07_25_04_world_335.sql | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_07_25_04_world_335.sql b/sql/updates/world/3.3.5/2019_07_25_04_world_335.sql new file mode 100644 index 00000000000..ff739bf1150 --- /dev/null +++ b/sql/updates/world/3.3.5/2019_07_25_04_world_335.sql @@ -0,0 +1,25 @@ +-- +DELETE FROM `creature` WHERE `id`=25145 AND `guid` IN (113332, 113333, 113334, 113337, 113338, 113339, 113433, 113445, 113460, 113468, 113469, 113470, 113471, 113472, 113480, 113520, 113524, 113525, 113526, 113527, 113528, 113529); +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +(113332, 25145, 530, 0, 0, 1, 1, 0, 1, 6756.51, -7545.18, 126.200, 5.096360, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(113333, 25145, 530, 0, 0, 1, 1, 0, 1, 6775.35, -7696.51, 127.859, 3.311900, 300, 8, 0, 0, 0, 1, 0, 0, 0, 0), +(113334, 25145, 530, 0, 0, 1, 1, 0, 1, 6774.72, -7617.18, 128.606, 1.858890, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(113337, 25145, 530, 0, 0, 1, 1, 0, 1, 6770.71, -7618.81, 128.502, 1.046980, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(113338, 25145, 530, 0, 0, 1, 1, 0, 1, 6767.95, -7611.86, 128.593, 5.978870, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(113339, 25145, 530, 0, 0, 1, 1, 0, 1, 6807.31, -7690.35, 130.622, 0.453786, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(113433, 25145, 530, 0, 0, 1, 1, 0, 1, 6811.60, -7721.00, 125.959, 4.502950, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(113445, 25145, 530, 0, 0, 1, 1, 0, 1, 6833.79, -7744.13, 124.765, 0.436332, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(113460, 25145, 530, 0, 0, 1, 1, 0, 1, 6871.87, -7751.06, 126.638, 2.076940, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(113468, 25145, 530, 0, 0, 1, 1, 0, 1, 6795.15, -7589.81, 127.622, 3.141590, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(113469, 25145, 530, 0, 0, 1, 1, 0, 1, 6793.50, -7555.50, 126.474, 3.717550, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(113470, 25145, 530, 0, 0, 1, 1, 0, 1, 6802.71, -7761.10, 126.991, 0.663225, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(113471, 25145, 530, 0, 0, 1, 1, 0, 1, 6813.94, -7772.28, 127.331, 6.230820, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(113472, 25145, 530, 0, 0, 1, 1, 0, 1, 6784.56, -7772.55, 142.828, 0.925025, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(113480, 25145, 530, 0, 0, 1, 1, 0, 1, 6782.69, -7739.66, 126.344, 0.314159, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(113520, 25145, 530, 0, 0, 1, 1, 0, 1, 6776.12, -7762.38, 128.772, 0.523599, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(113524, 25145, 530, 0, 0, 1, 1, 0, 1, 6815.57, -7795.29, 132.311, 1.099560, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(113525, 25145, 530, 0, 0, 1, 1, 0, 1, 6835.44, -7798.48, 134.436, 2.181660, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(113526, 25145, 530, 0, 0, 1, 1, 0, 1, 6838.43, -7786.18, 130.069, 1.535890, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(113527, 25145, 530, 0, 0, 1, 1, 0, 1, 6858.05, -7786.21, 130.118, 1.378810, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(113528, 25145, 530, 0, 0, 1, 1, 0, 1, 6764.31, -7791.43, 151.763, 1.588250, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0), +(113529, 25145, 530, 0, 0, 1, 1, 0, 1, 6728.52, -7572.14, 127.364, 0.401426, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0); |