diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2017_07_16_00_world.sql | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_07_16_00_world.sql b/sql/updates/world/3.3.5/2017_07_16_00_world.sql new file mode 100644 index 00000000000..4af22673208 --- /dev/null +++ b/sql/updates/world/3.3.5/2017_07_16_00_world.sql @@ -0,0 +1,27 @@ +-- +DELETE FROM `creature` WHERE `guid` IN (80437,80438,80439,80441,80442,80451,80452,80468,80469,80474,80476,80478,80479,80480,80481,80482,80487,80490,80492,80493,80499,80500,80501); +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`, `ScriptName`, `VerifiedBuild`) VALUES +(80437, 20878, 530, 0, 0, 1, 1, 0, 1, -3374.05, 2096.69, 33.9606, 4.98658, 300, 0, 0, 6761, 0, 0, 0, 0, 0, "", 0), +(80438, 19754, 530, 0, 0, 1, 1, 0, 0, -3482.37, 2189.11, 33.4005, 2.94297, 300, 0, 0, 6542, 0, 0, 0, 0, 0, "", 0), +(80439, 19754, 530, 0, 0, 1, 1, 0, 0, -3450.09, 2222.93, 33.4608, 5.09496, 300, 5, 0, 6761, 0, 1, 0, 0, 0, "", 0), +(80441, 19754, 530, 0, 0, 1, 1, 0, 0, -3437.45, 2248.48, 33.6584, 2.29266, 300, 5, 0, 6542, 0, 1, 0, 0, 0, "", 0), +(80442, 19754, 530, 0, 0, 1, 1, 0, 0, -3408.19, 2264.77, 33.8722, 0.311879, 300, 5, 0, 6542, 0, 1, 0, 0, 0, "", 0), +(80451, 20878, 530, 0, 0, 1, 1, 0, 1, -3408.75, 2293.33, 33.9996, 4.81143, 300, 0, 0, 6761, 0, 0, 0, 0, 0, "", 0), +(80452, 20878, 530, 0, 0, 1, 1, 0, 1, -3420.39, 2292.38, 33.8544, 4.81143, 300, 0, 0, 6761, 0, 0, 0, 0, 0, "", 0), +(80468, 20887, 530, 0, 0, 1, 1, 0, 0, -3419.58, 2319.73, 36.8641, 4.84441, 300, 5, 0, 1518, 2933, 1, 0, 0, 0, "", 0), +(80469, 20872, 530, 0, 0, 1, 1, 0, 1, -3409.13, 2322.22, 37.1603, 4.9451, 300, 0, 0, 4869, 3080, 0, 0, 0, 0, "", 0), +(80474, 19759, 530, 0, 0, 1, 1, 0, 0, -3439.65, 2237.67, 33.706, 0.552004, 300, 5, 0, 6761, 0, 1, 0, 0, 0, "", 0), +(80476, 19759, 530, 0, 0, 1, 1, 0, 0, -3416.91, 2263.98, 33.6662, 1.36833, 300, 5, 0, 6761, 0, 1, 0, 0, 0, "", 0), +(80478, 21080, 530, 0, 0, 1, 1, 0, 0, -3426.86, 2279.58, 33.224, 6.11549, 300, 0, 0, 6761, 0, 0, 0, 0, 0, "", 0), +(80479, 20878, 530, 0, 0, 1, 1, 0, 1, -3542.3, 2175.09, 34.605, 0.112182, 300, 0, 0, 6542, 0, 0, 0, 0, 0, "", 0), +(80480, 20878, 530, 0, 0, 1, 1, 0, 1, -3539.62, 2158.01, 33.6429, 0.362725, 300, 0, 0, 6761, 0, 0, 0, 0, 0, "", 0), +(80481, 19759, 530, 0, 0, 1, 1, 0, 0, -3554.47, 2144.46, 24.5201, 0.812755, 300, 5, 0, 6761, 0, 1, 0, 0, 0, "", 0), +(80482, 19759, 530, 0, 0, 1, 1, 0, 0, -3594.73, 2116.83, 20.2744, 0.626613, 300, 5, 0, 6761, 0, 1, 0, 0, 0, "", 0), +(80487, 20878, 530, 0, 0, 1, 1, 0, 1, -3662.5, 2072.94, 10.3361, 5.55746, 300, 0, 0, 6542, 0, 0, 0, 0, 0, "", 0), +(80490, 20878, 530, 0, 0, 1, 1, 0, 1, -3652.5, 2084.2, 10.5056, 5.55746, 300, 0, 0, 6761, 0, 0, 0, 0, 0, "", 0), +(80492, 20878, 530, 0, 0, 1, 1, 0, 1, -3644.13, 2055.73, 9.68677, 2.40328, 300, 0, 0, 6542, 0, 0, 0, 0, 0, "", 0), +(80493, 20878, 530, 0, 0, 1, 1, 0, 1, -3637.7, 2038.1, 10.4644, 1.91553, 300, 0, 0, 6542, 0, 0, 0, 0, 0, "", 0), +(80499, 20878, 530, 0, 0, 1, 1, 0, 1, -3622.26, 2053.14, 9.36395, 2.79277, 300, 0, 0, 6542, 0, 0, 0, 0, 0, "", 0), +(80500, 20872, 530, 0, 0, 1, 1, 0, 1, -3649.29, 2072, 9.88089, 4.49401, 300, 5, 0, 4869, 3080, 1, 0, 0, 0, "", 0), +(80501, 20887, 530, 0, 0, 1, 1, 0, 0, -3651.97, 2070.35, 9.96041, 4.50972, 300, 5, 0, 1518, 2933, 1, 0, 0, 0, "", 0); +UPDATE `creature` SET `position_x`=-3666.342, `position_y`=2086.453, `position_z`=10.4205, `orientation`=5.6084 WHERE `guid`=213829 |