DB/Creature: Kodo Spirit

1 files changed, 21 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2018_10_19_01_world_335.sql b/sql/updates/world/3.3.5/2018_10_19_01_world_335.sql
new file mode 100644
index 00000000000..1adfdc96938
--- /dev/null
+++ b/sql/updates/world/3.3.5/2018_10_19_01_world_335.sql
@@ -0,0 +1,21 @@
+-- 
+DELETE FROM `creature_template_addon` WHERE `entry`=10988;
+INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
+(10988, 0, 0, 0, 0, 0, "10848");
+
+UPDATE `creature_template` SET `flags_extra`=1024 WHERE `entry` IN (10988);
+DELETE FROM `creature` WHERE `guid` IN (92277,92280,92568,92826,92828,92829,92864,93587,93610,93639,93646,93652,93695);
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`,`spawndist`, `MovementType`) VALUES
+(92277, 10988, 1, 1, 1, 0, 0, -1247.3, 1825.32, 50.15, 0.189608, 600, 6, 1),
+(92280, 10988, 1, 1, 1, 0, 0, -1364, 1830.68, 51.281, 1.427, 600, 6, 1),
+(92568, 10988, 1, 1, 1, 0, 0, -1353, 2059.29, 50.455, 2.322, 600, 7, 1),
+(92826, 10988, 1, 1, 1, 0, 0, -1339, 2012.71, 50.394, 1.421, 600, 7, 1),
+(92828, 10988, 1, 1, 1, 0, 0, -1333, 1972.31, 50.144, 5.188, 600, 7, 1),
+(92829, 10988, 1, 1, 1, 0, 0, -1307, 1813.98, 50.228, 6.213, 600, 7, 1),
+(92864, 10988, 1, 1, 1, 0, 0, -1255.157, 1965.387, 50.144, 5.822480, 600, 7, 1),
+(93587, 10988, 1, 1, 1, 0, 0, -1287.059, 1920.125, 50.624, 4.032559, 600, 7, 1),
+(93610, 10988, 1, 1, 1, 0, 0, -1269.852, 1864.019, 50.298, 5.031582, 600, 7, 1),
+(93639, 10988, 1, 1, 1, 0, 0, -1354.506, 1890.478, 50.148, 3.497707, 600, 7, 1),
+(93646, 10988, 1, 1, 1, 0, 0, -1296.158, 1999.375, 51.106, 1.970108, 600, 7, 1),
+(93652, 10988, 1, 1, 1, 0, 0, -1442.202, 1792.259, 50.144, 0.843056, 600, 7, 1),
+(93695, 10988, 1, 1, 1, 0, 0, -1384.608, 1797.856, 50.337, 5.842114, 600, 7, 1);