DB/Creature: Zixil

By Killyana, closes #12479

1 files changed, 65 insertions, 0 deletions

diff --git a/sql/updates/world/2015_05_22_01_world.sql b/sql/updates/world/2015_05_22_01_world.sql
new file mode 100644
index 00000000000..676fa999ebb
--- /dev/null
+++ b/sql/updates/world/2015_05_22_01_world.sql
@@ -0,0 +1,65 @@
+--
+DELETE FROM `creature_formations` WHERE `leaderGUID`=15424;
+INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`)VALUES
+(15424,15424,0,0,2),(15424,15423,3,0,2);
+UPDATE `creature` SET `position_x`=-36.31, `position_y`=-916.366, `position_z`=55.075, `orientation`= 1.062 WHERE `guid`=15424;
+UPDATE `creature` SET `position_x`=-37.248, `position_y`=-914.605, `position_z`=55.343, `orientation`= 0.826 WHERE `guid`=15423;
+UPDATE `creature` SET `MovementType`=2 WHERE `guid` IN (15424);
+UPDATE `creature_addon`  SET `path_id`=154240 WHERE `guid` IN (15424);
+DELETE FROM `waypoint_data` WHERE `id` IN (154240);
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES
+(154240, 1, -36.31, -916.366, 55.075, 1.062, 180000, 0, 0, 100, 0), 
+(154240, 2, -28.532600, -902.440735, 55.908634, 0, 0, 0, 0, 100, 0),
+(154240, 3, -26.338741, -896.902466, 56.039452, 0, 0, 0, 0, 100, 0),
+(154240, 4, -51.500923, -836.734619, 56.524872, 0, 0, 0, 0, 100, 0),
+(154240, 5, -17.165236, -802.633240, 58.751846, 0, 0, 0, 0, 100, 0),
+(154240, 6, -20.983173, -719.063965, 69.290993, 0, 0, 0, 0, 100, 0),
+(154240, 7, -149.228104, -712.801025, 64.445107, 0, 0, 0, 0, 100, 0),
+(154240, 8, -226.017303, -722.711487, 60.861263, 0, 0, 0, 0, 100, 0),
+(154240, 9, -325.539337, -754.267334, 54.089657, 0, 0, 0, 0, 100, 0),
+(154240, 10, -377.870178, -776.472351, 54.472977, 0, 0, 0, 0, 100, 0),
+(154240, 11, -403.164459, -680.892700, 54.499004, 0, 0, 0, 0, 100, 0),
+(154240, 12, -331.617737, -671.147278, 54.918808, 0, 0, 0, 0, 100, 0),
+(154240, 13, -341.247772, -713.172363, 57.733025, 0, 0, 0, 0, 100, 0),
+(154240, 14, -340.614716, -711.776184, 57.733025, 0, 120000, 0, 0, 100, 0),
+(154240, 15, -325.247681, -677.673950, 54.596302, 0, 0, 0, 0, 100, 0), 
+(154240, 16, -339.869904, -673.187561, 55.012871, 0, 0, 0, 0, 100, 0),
+(154240, 17, -385.749298, -685.196350, 54.387272, 0, 0, 0, 0, 100, 0),
+(154240, 18, -413.708405, -656.887817, 54.488979, 0, 0, 0, 0, 100, 0),
+(154240, 19, -440.757660, -585.658386, 53.424225, 0, 0, 0, 0, 100, 0),
+(154240, 20, -520.923462, -558.851501, 39.920975, 0, 0, 0, 0, 100, 0),
+(154240, 21, -569.159912, -567.547302, 32.809437, 0, 0, 0, 0, 100, 0),
+(154240, 22, -594.511536, -575.940979, 31.982075, 0, 0, 0, 0, 100, 0),
+(154240, 23, -650.699402, -560.431763, 26.120964, 0, 0, 0, 0, 100, 0),
+(154240, 24, -691.624939, -568.642334, 24.540937, 0, 0, 0, 0, 100, 0),
+(154240, 25, -707.109802, -562.611023, 22.809536, 0, 0, 0, 0, 100, 0),
+(154240, 26, -724.787048, -549.384033, 20.291832, 0, 0, 0, 0, 100, 0),
+(154240, 27, -811.109985, -542.174927, 15.771987, 0, 0, 0, 0, 100, 0),
+(154240, 28, -817.549683, -533.020020, 15.160646, 0, 180000, 0, 0, 100, 0),
+(154240, 29, -811.109985, -542.174927, 15.771987, 0, 0, 0, 0, 100, 0),
+(154240, 30, -724.787048, -549.384033, 20.291832, 0, 0, 0, 0, 100, 0),
+(154240, 31, -707.109802, -562.611023, 22.809536, 0, 0, 0, 0, 100, 0),
+(154240, 32, -691.624939, -568.642334, 24.540937, 0, 0, 0, 0, 100, 0),
+(154240, 33, -650.699402, -560.431763, 26.120964, 0, 0, 0, 0, 100, 0),
+(154240, 34, -594.511536, -575.940979, 31.982075, 0, 0, 0, 0, 100, 0),
+(154240, 35, -569.159912, -567.547302, 32.809437, 0, 0, 0, 0, 100, 0),
+(154240, 36, -520.923462, -558.851501, 39.920975, 0, 0, 0, 0, 100, 0),
+(154240, 37, -440.757660, -585.658386, 53.424225, 0, 0, 0, 0, 100, 0),
+(154240, 38, -413.708405, -656.887817, 54.488979, 0, 0, 0, 0, 100, 0),
+(154240, 39, -385.749298, -685.196350, 54.387272, 0, 0, 0, 0, 100, 0),
+(154240, 40, -339.869904, -673.187561, 55.012871, 0, 0, 0, 0, 100, 0),
+(154240, 41, -325.247681, -677.673950, 54.596302, 0, 0, 0, 0, 100, 0), 
+(154240, 42, -340.614716, -711.776184, 57.733025, 0, 120000, 0, 0, 100, 0),
+(154240, 43, -341.247772, -713.172363, 57.733025, 0, 0, 0, 0, 100, 0),
+(154240, 44, -331.617737, -671.147278, 54.918808, 0, 0, 0, 0, 100, 0),
+(154240, 45, -403.164459, -680.892700, 54.499004, 0, 0, 0, 0, 100, 0),
+(154240, 46, -377.870178, -776.472351, 54.472977, 0, 0, 0, 0, 100, 0),
+(154240, 47, -325.539337, -754.267334, 54.089657, 0, 0, 0, 0, 100, 0),
+(154240, 48, -226.017303, -722.711487, 60.861263, 0, 0, 0, 0, 100, 0),
+(154240, 49, -149.228104, -712.801025, 64.445107, 0, 0, 0, 0, 100, 0),
+(154240, 50, -20.983173, -719.063965, 69.290993, 0, 0, 0, 0, 100, 0),
+(154240, 51, -17.165236, -802.633240, 58.751846, 0, 0, 0, 0, 100, 0),
+(154240, 52, -51.500923, -836.734619, 56.524872, 0, 0, 0, 0, 100, 0),
+(154240, 53, -26.338741, -896.902466, 56.039452, 0, 0, 0, 0, 100, 0),
+(154240, 54, -28.532600, -902.440735, 55.908634, 0, 0, 0, 0, 100, 0),
+(154240, 55, -38.973717, -917.010193, 55.065174, 1.062, 0, 0, 0, 100, 0);