DB/Creature: Fjord Penguin

1 files changed, 42 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2019_06_06_10_world.sql b/sql/updates/world/3.3.5/2019_06_06_10_world.sql
new file mode 100644
index 00000000000..ff1ea5453d5
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_06_06_10_world.sql
@@ -0,0 +1,42 @@
+-- 
+DELETE FROM `creature` WHERE `id`  IN (28407) AND `guid` IN (110507, 110509, 110518, 110522, 110523, 110525, 110531, 110574, 110576, 110751, 110772, 110827, 110935, 110937, 110938, 110939, 110942, 110947, 110948, 110949, 110957, 110968, 111003, 111004, 111006, 111007, 111009, 111011, 111012, 111013, 111015, 111018, 111019, 111020, 111021, 111023, 111024, 111026, 111027);
+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`) VALUES
+(110507, 28407, 571, 0, 0, 1, 1, 0, 0, -265.347, -5393.54, 17.6095, 3.58607, 600, 0, 0, 0, 0, 0),
+(110509, 28407, 571, 0, 0, 1, 1, 0, 0, -242.517, -5385.04, 17.4231, 3.36774, 600, 0, 0, 0, 0, 0),
+(110518, 28407, 571, 0, 0, 1, 1, 0, 0, -256.988, -5391.26, 17.5252, 4.77045, 600, 0, 0, 0, 0, 0),
+(110522, 28407, 571, 0, 0, 1, 1, 0, 0, -244.555, -5373.01, 18.2294, 3.7353, 600, 0, 0, 0, 0, 0),
+(110523, 28407, 571, 0, 0, 1, 1, 0, 0, -254.252, -5386.46, 17.5632, 0.593704, 600, 0, 0, 0, 0, 0),
+(110525, 28407, 571, 0, 0, 1, 1, 0, 0, -248.147, -5383.43, 17.6198, 0.660463, 600, 0, 0, 0, 0, 0),
+(110531, 28407, 571, 0, 0, 1, 1, 0, 0, -250.77, -5379.14, 17.8239, 4.21046, 600, 0, 0, 0, 0, 0),
+(110574, 28407, 571, 0, 0, 1, 1, 0, 0, -244.315, -5367.23, 18.3083, 4.12407, 600, 0, 0, 0, 0, 0),
+(110576, 28407, 571, 0, 0, 1, 1, 0, 0, -246.717, -5369.39, 18.3706, 1.85427, 600, 0, 0, 0, 0, 0),
+(110751, 28407, 571, 0, 0, 1, 1, 0, 0, -249.526, -5370.2, 18.3764, 1.73646, 600, 0, 0, 0, 0, 0),
+(110772, 28407, 571, 0, 0, 1, 1, 0, 0, -253.78, -5374.76, 18.0204, 4.38718, 600, 0, 0, 0, 0, 0),
+(110827, 28407, 571, 0, 0, 1, 1, 0, 0, -259.04, -5379.18, 17.6642, 5.03513, 600, 0, 0, 0, 0, 0),
+(110935, 28407, 571, 0, 0, 1, 1, 0, 0, -259.956, -5373.97, 17.5147, 4.83485, 600, 0, 0, 0, 0, 0),
+(110937, 28407, 571, 0, 0, 1, 1, 0, 0, -264.477, -5391.84, 17.7496, 2.71428, 600, 0, 0, 0, 0, 0),
+(110938, 28407, 571, 0, 0, 1, 1, 0, 0, -265.944, -5385.17, 17.6643, 1.01782, 600, 0, 0, 0, 0, 0),
+(110939, 28407, 571, 0, 0, 1, 1, 0, 0, -259.321, -5545.38, 18.5444, 3.53658, 600, 0, 0, 0, 0, 0),
+(110942, 28407, 571, 0, 0, 1, 1, 0, 0, -264.037, -5377.74, 17.541, 4.66207, 600, 0, 0, 0, 0, 0),
+(110947, 28407, 571, 0, 0, 1, 1, 0, 0, -251.769, -5343.58, 17.1284, 1.63592, 600, 0, 0, 0, 0, 0),
+(110948, 28407, 571, 0, 0, 1, 1, 0, 0, -267.306, -5374.55, 17.006, 3.09912, 600, 0, 0, 0, 0, 0),
+(110949, 28407, 571, 0, 0, 1, 1, 0, 0, -257.881, -5369.12, 17.7324, 1.29271, 600, 0, 0, 0, 0, 0),
+(110957, 28407, 571, 0, 0, 1, 1, 0, 0, -250.398, -5365.01, 18.2174, 2.14094, 600, 0, 0, 0, 0, 0),
+(110968, 28407, 571, 0, 0, 1, 1, 0, 0, -245.45, -5363.43, 18.3257, 2.27289, 600, 0, 0, 0, 0, 0),
+(111003, 28407, 571, 0, 0, 1, 1, 0, 0, -248.439, -5360.94, 18.1971, 2.49672, 600, 0, 0, 0, 0, 0),
+(111004, 28407, 571, 0, 0, 1, 1, 0, 0, -244.487, -5358.34, 18.0473, 1.82521, 600, 0, 0, 0, 0, 0),
+(111006, 28407, 571, 0, 0, 1, 1, 0, 0, -249.684, -5353.78, 17.891, 3.84368, 600, 0, 0, 0, 0, 0),
+(111007, 28407, 571, 0, 0, 1, 1, 0, 0, -255.397, -5359.23, 17.6402, 1.78594, 600, 0, 0, 0, 0, 0),
+(111009, 28407, 571, 0, 0, 1, 1, 0, 0, -254.876, -5367.99, 18.0053, 0.7335, 600, 0, 0, 0, 0, 0),
+(111011, 28407, 571, 0, 0, 1, 1, 0, 0, -254.761, -5545.15, 18.4633, 6.24621, 600, 0, 0, 0, 0, 0),
+(111012, 28407, 571, 0, 0, 1, 1, 0, 0, -256.129, -5547.07, 18.825, 4.52619, 600, 0, 0, 0, 0, 0),
+(111013, 28407, 571, 0, 0, 1, 1, 0, 0, -248.415, -5549.75, 19.0899, 4.01568, 600, 0, 0, 0, 0, 0),
+(111015, 28407, 571, 0, 0, 1, 1, 0, 0, -252.347, -5553.98, 18.9586, 1.72153, 600, 0, 0, 0, 0, 0),
+(111018, 28407, 571, 0, 0, 1, 1, 0, 0, -248.222, -5560.57, 18.8848, 2.59725, 600, 0, 0, 0, 0, 0),
+(111019, 28407, 571, 0, 0, 1, 1, 0, 0, -246.338, -5557.52, 19.1707, 1.45842, 600, 0, 0, 0, 0, 0),
+(111020, 28407, 571, 0, 0, 1, 1, 0, 0, -239.584, -5577.61, 18.6126, 5.31865, 600, 0, 0, 0, 0, 0),
+(111021, 28407, 571, 0, 0, 1, 1, 0, 0, -237.446, -5571.52, 18.7673, 2.73862, 600, 0, 0, 0, 0, 0),
+(111023, 28407, 571, 0, 0, 1, 1, 0, 0, -232.998, -5563.14, 18.9112, 1.68225, 600, 0, 0, 0, 0, 0),
+(111024, 28407, 571, 0, 0, 1, 1, 0, 0, -232.222, -5568.88, 18.6566, 2.53441, 600, 0, 0, 0, 0, 0),
+(111026, 28407, 571, 0, 0, 1, 1, 0, 0, -228.268, -5573.36, 18.5249, 6.1276, 600, 0, 0, 0, 0, 0),
+(111027, 28407, 571, 0, 0, 1, 1, 0, 0, -232.346, -5579.26, 18.5982, 5.21261, 600, 0, 0, 0, 0, 0);