diff options
| -rw-r--r-- | sql/updates/world/2015_05_22_13_world.sql | 51 |
1 files changed, 51 insertions, 0 deletions
diff --git a/sql/updates/world/2015_05_22_13_world.sql b/sql/updates/world/2015_05_22_13_world.sql new file mode 100644 index 00000000000..db90e99cf4d --- /dev/null +++ b/sql/updates/world/2015_05_22_13_world.sql @@ -0,0 +1,51 @@ +-- +UPDATE `creature` SET `position_x`=-4435.777, `position_y`=-13684.191, `position_z`=44.03, `orientation`= 5.189 WHERE `guid`=57310; +UPDATE `creature` SET `MovementType`=2, `spawndist`=0 WHERE `guid` IN (57310, 57313); +DELETE FROM `creature_addon` WHERE `guid` IN (57310, 57313); +INSERT INTO `creature_addon` (`guid`, `path_id`) VALUES (57310, 573100), (57313, 573130); +DELETE FROM `waypoint_data` WHERE `id` IN (573100, 573130); +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(573100, 1, -4443.440918, -13695.226563, 46.834724, 0, 0, 0, 0, 100, 0), +(573100, 2, -4451.548828, -13708.859375, 48.496380, 0, 0, 0, 0, 100, 0), +(573100, 3, -4431.984863, -13722.603516, 51.757404, 0, 0, 0, 0, 100, 0), +(573100, 4, -4385.404297, -13720.467773, 50.135044, 0, 0, 0, 0, 100, 0), +(573100, 5, -4380.465820, -13740.443359, 50.451973, 0, 0, 0, 0, 100, 0), +(573100, 6, -4392.348633, -13770.427734, 52.292049, 0, 0, 0, 0, 100, 0), +(573100, 7, -4391.951660, -13786.277344, 52.664742, 0, 0, 0, 0, 100, 0), +(573100, 8, -4396.321777, -13804.233398, 55.976879, 0, 0, 0, 0, 100, 0), +(573100, 9, -4404.731934, -13815.549805, 60.186996, 0, 0, 0, 0, 100, 0), +(573100, 10, -4409.673828, -13847.877930, 71.870178, 0, 0, 0, 0, 100, 0), +(573100, 11, -4419.165527, -13854.147461, 78.347191, 0, 0, 0, 0, 100, 0), +(573100, 12, -4432.236816, -13856.821289, 85.815552, 0, 0, 0, 0, 100, 0), +(573100, 13, -4453.323730, -13875.177734, 101.67051, 0, 0, 0, 0, 100, 0), +(573100, 14, -4432.236816, -13856.821289, 85.815552, 0, 0, 0, 0, 100, 0), +(573100, 15, -4419.165527, -13854.147461, 78.347191, 0, 0, 0, 0, 100, 0), +(573100, 16, -4409.673828, -13847.877930, 71.870178, 0, 0, 0, 0, 100, 0), +(573100, 17, -4404.731934, -13815.549805, 60.186996, 0, 0, 0, 0, 100, 0), +(573100, 18, -4396.321777, -13804.233398, 55.976879, 0, 0, 0, 0, 100, 0), +(573100, 19, -4391.951660, -13786.277344, 52.664742, 0, 0, 0, 0, 100, 0), +(573100, 20, -4392.348633, -13770.427734, 52.292049, 0, 0, 0, 0, 100, 0), +(573100, 21, -4380.465820, -13740.443359, 50.451973, 0, 0, 0, 0, 100, 0), +(573100, 22, -4385.404297, -13720.467773, 50.135044, 0, 0, 0, 0, 100, 0), +(573100, 23, -4431.984863, -13722.603516, 51.757404, 0, 0, 0, 0, 100, 0), +(573100, 24, -4451.548828, -13708.859375, 48.496380, 0, 0, 0, 0, 100, 0), +(573100, 25, -4443.440918, -13695.226563, 46.834724, 0, 0, 0, 0, 100, 0), +(573130, 1, -4393.079102, -13790.173828, 52.869942, 0, 0, 0, 0, 100, 0), +(573130, 2, -4392.134766, -13761.565430, 51.793087, 0, 0, 0, 0, 100, 0), +(573130, 3, -4412.633301, -13752.276367, 53.840073, 0, 0, 0, 0, 100, 0), +(573130, 4, -4429.812012, -13722.834961, 51.848553, 0, 0, 0, 0, 100, 0), +(573130, 5, -4389.571777, -13722.364258, 50.288551, 0, 0, 0, 0, 100, 0), +(573130, 6, -4380.811523, -13731.546875, 50.451256, 0, 0, 0, 0, 100, 0), +(573130, 7, -4385.900391, -13759.079102, 50.621365, 0, 0, 0, 0, 100, 0), +(573130, 8, -4391.487305, -13762.515625, 51.752522, 0, 0, 0, 0, 100, 0), +(573130, 9, -4403.406250, -13758.519531, 53.117504, 0, 0, 0, 0, 100, 0), +(573130, 10, -4432.480469, -13756.059570, 56.591385, 0, 0, 0, 0, 100, 0), +(573130, 11, -4403.406250, -13758.519531, 53.117504, 0, 0, 0, 0, 100, 0), +(573130, 12, -4391.487305, -13762.515625, 51.752522, 0, 0, 0, 0, 100, 0), +(573130, 13, -4385.900391, -13759.079102, 50.621365, 0, 0, 0, 0, 100, 0), +(573130, 14, -4380.811523, -13731.546875, 50.451256, 0, 0, 0, 0, 100, 0), +(573130, 15, -4389.571777, -13722.364258, 50.288551, 0, 0, 0, 0, 100, 0), +(573130, 16, -4429.812012, -13722.834961, 51.848553, 0, 0, 0, 0, 100, 0), +(573130, 17, -4412.633301, -13752.276367, 53.840073, 0, 0, 0, 0, 100, 0), +(573130, 18, -4392.134766, -13761.565430, 51.793087, 0, 0, 0, 0, 100, 0), +(573130, 19, -4393.079102, -13790.173828, 52.869942, 0, 0, 0, 0, 100, 0); |