diff options
| -rw-r--r-- | sql/updates/world/2015_05_22_06_world.sql | 35 |
1 files changed, 35 insertions, 0 deletions
diff --git a/sql/updates/world/2015_05_22_06_world.sql b/sql/updates/world/2015_05_22_06_world.sql new file mode 100644 index 00000000000..939ee2dbc7a --- /dev/null +++ b/sql/updates/world/2015_05_22_06_world.sql @@ -0,0 +1,35 @@ +-- +UPDATE `creature_template` SET `InhabitType`=4 WHERE `entry`=8276; +UPDATE `creature_template` SET `InhabitType`=4 WHERE `entry`=20454; +UPDATE `creature` SET `position_x`=274.23, `position_y`=-2162.325, `position_z`=159.94, `orientation`= 3.227 WHERE `guid`=92880; +UPDATE `creature` SET `MovementType`=2 WHERE `guid` IN (92880, 92881); +DELETE FROM `creature_addon` WHERE `guid` IN (92881, 92880); +INSERT INTO `creature_addon` (`guid`, `path_id`) VALUES (92880, 928800), (92881, 928810); + +DELETE FROM `waypoint_data` WHERE `id` IN (928810, 928800); +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(928810, 1, 87.198, -2237.385, 161.785, 0, 0, 1, 0, 100, 0), +(928810, 2, -7.544, -2549.668, 181.017, 0, 0, 1, 0, 100, 0), +(928810, 3, -237.996, -2624.749, 189.896, 0, 0, 1, 0, 100, 0), +(928810, 4, -217.604, -3346.965, 189.025, 0, 0, 1, 0, 100, 0), +(928810, 5, 63.265, -3628.146, 172.660, 0, 0, 1, 0, 100, 0), +(928810, 6, 354.298, -3663.979, 170.469, 0, 0, 1, 0, 100, 0), +(928810, 7, 438.654, -3378.017, 166.627, 0, 0, 1, 0, 100, 0), +(928810, 8, 198.273, -3037.064, 169.242, 0, 0, 1, 0, 100, 0), +(928810, 9, 61.098, -2856.964, 158.961, 0, 0, 1, 0, 100, 0), +(928810, 10, -48.316, -2553.932, 190.939, 0, 0, 1, 0, 100, 0), +(928810, 11, 139.328, -2296.988, 155.313, 0, 0, 1, 0, 100, 0), +(928810, 12, 272.772, -2096.04, 160.766, 0, 0, 1, 0, 100, 0), +(928800, 1, 160.229, -2189.599, 134.889, 0, 0, 1, 0, 100, 0), +(928800, 2, 92.713, -2488.815, 171.090, 0, 0, 1, 0, 100, 0), +(928800, 3, 34.246, -2612.019, 151.869, 0, 0, 1, 0, 100, 0), +(928800, 4, 66.592, -2894.712, 151.56, 0, 0, 1, 0, 100, 0), +(928800, 5, 242.969, -3067.849, 147.831, 0, 0, 1, 0, 100, 0), +(928800, 6, 340.322, -3286.022, 160.143, 0, 0, 1, 0, 100, 0), +(928800, 7, 383.039, -3522.556, 154.207, 0, 0, 1, 0, 100, 0), +(928800, 8, 111.62, -3633.633, 166.753, 0, 0, 1, 0, 100, 0), +(928800, 9, -156.406, -3358.144, 162.886, 0, 0, 1, 0, 100, 0), +(928800, 10, -34.626, -3047.4, 160.192, 0, 0, 1, 0, 100, 0), +(928800, 11, 171.691, -2338.09, 152.636, 0, 0, 1, 0, 100, 0), +(928800, 12, 197.218, -2249.241, 147.71, 0, 0, 1, 0, 100, 0), +(928800, 13, 274.237, -2162.325, 147.09, 0, 0, 1, 0, 100, 0); |