
INSERT INTO `game_event` (`entry`, `start_time`, `end_time`, `occurence`, `length`, `description`) VALUES
(250, '2007-11-11 20:00:00', '2020-12-31 00:00:00', 1440, 15, 'Water elemental attack Gate of Stormwind'),
(251, '2007-11-11 20:00:00', '2020-12-31 00:00:00', 1440, 60, 'Water elemental attack Stormwind');

INSERT INTO `game_event_creature` VALUES 
(5782, -251),
(5797, -251),
(5921, -251),
(5925, -251),
(5941, -251),
(5954, -251),
(5990, -251),
(6004, -251),
(6099, -251),
(6100, -251),
(6105, -251),
(53379, -251),
(53378, -251),
(62570, -251),
(62569, -251),
(62568, -251),
(116834, -251),
(116832, -251),
(116840, -251),
(125448, -251),
(125449, -251),
(125424, 251),
(125408, 251),
(125409, 251),
(125410, 251),
(125411, 251),
(125412, 251),
(125413, 251),
(125414, 251),
(125415, 251),
(125416, 251),
(125417, 251),
(125418, 251),
(125419, 251),
(125420, 251),
(125421, 251),
(125422, 251),
(125423, 251),
(125405, 250),
(125407, 250),
(125406, 250),
(125404, 250);

INSERT INTO `creature_template` (`entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `class`, `race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `trash`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `RacialLeader`, `equipment_id`, `ScriptName`) VALUES
(25214, 5492, 0, 5492, 0, 'Water Elemental', 'Assault band', 30, 40, 1000, 2000, 500, 1000, 1, 14, 0, 0, 2, 0, 100, 200, 0, 350, 1600, 1800, 1, 0, 0, 0, 0, 0, 0, 60, 80, 120, 4, 0, 72, 691, 0, 0, 0, 0, 75, 50, 0, 0, 0, 0, 0, 0, 100, 10000, '', 0, 3, 0, 1, 0, 'mob_blacktemple');

INSERT INTO `creature` (`guid` ,`id` ,`map` ,`modelid` ,`equipment_id` ,`position_x` ,`position_y` ,`position_z` ,`orientation` ,`spawntimesecs` ,`spawndist` ,`currentwaypoint` ,`trash1` ,`trash2` ,`trash3` ,`trash4` ,`curhealth` ,`curmana` ,`DeathState` ,`MovementType` ) VALUES
(125404, 25214, 0, 0, 0, -8982.42, 407.307, 70.9727, 3.56695, 120, 0, 0, -8982.42, 407.307, 70.9727, 0, 96000, 100, 0, 2),
(125405, 25214, 0, 0, 0, -9069.68, 529.066, 72.384, 4.50001, 120, 0, 0, -9069.68, 529.066, 72.384, 0, 98000, 100, 0, 2),
(125406, 25214, 0, 0, 0, -8990.59, 418.923, 70.8193, 4.39476, 120, 0, 0, -8990.59, 418.923, 70.8193, 0, 96000, 100, 0, 2),
(125407, 25214, 0, 0, 0, -9062.8, 508.856, 70.7427, 3.53082, 120, 0, 0, -9062.8, 508.856, 70.7427, 0, 100000, 100, 0, 2),
(125408, 25214, 0, 0, 0, -8950.43, 513.614, 96.3576, 0.752139, 25, 0, 0, -8950.43, 513.614, 96.3576, 0, 94000, 100, 0, 0),
(125409, 25214, 0, 0, 0, -8956.83, 528.769, 96.3568, 0.855027, 25, 0, 0, -8956.83, 528.769, 96.3568, 0, 90000, 100, 0, 0),
(125410, 25214, 0, 0, 0, -8956.01, 520.191, 96.3568, 0.996397, 25, 0, 0, -8956.01, 520.191, 96.3568, 0, 94000, 100, 0, 0),
(125411, 25214, 0, 0, 0, -8902.47, 567.298, 92.9011, 0.356299, 25, 0, 0, -8902.47, 567.298, 92.9011, 0, 92000, 100, 0, 0),
(125412, 25214, 0, 0, 0, -8898.46, 562.259, 92.8634, 1.11264, 25, 0, 0, -8898.46, 562.259, 92.8634, 0, 96000, 100, 0, 0),
(125413, 25214, 0, 0, 0, -8831.19, 627.271, 93.9926, 0.374364, 25, 0, 0, -8831.19, 627.271, 93.9926, 0, 96000, 100, 0, 0),
(125414, 25214, 0, 0, 0, -8823.46, 623.451, 93.8451, 5.44018, 25, 0, 0, -8823.46, 623.451, 93.8451, 0, 92000, 100, 0, 0),
(125415, 25214, 0, 0, 0, -8864.15, 641.164, 96.074, 3.23479, 25, 0, 0, -8864.15, 641.164, 96.074, 0, 94000, 100, 0, 0),
(125416, 25214, 0, 0, 0, -8866.24, 671.217, 97.9035, 2.12345, 25, 0, 0, -8866.24, 671.217, 97.9035, 0, 94000, 100, 0, 0),
(125417, 25214, 0, 0, 0, -8765.03, 603.465, 96.9243, 2.21456, 25, 0, 0, -8765.03, 603.465, 96.9243, 0, 90000, 100, 0, 0),
(125418, 25214, 0, 0, 0, -8770.82, 675.455, 102.746, 3.68718, 25, 0, 0, -8770.82, 675.455, 102.746, 0, 94000, 100, 0, 0),
(125419, 25214, 0, 0, 0, -8795.86, 691.423, 102.972, 3.68718, 25, 0, 0, -8795.86, 691.423, 102.972, 0, 98000, 100, 0, 0),
(125420, 25214, 0, 0, 0, -8825.7, 684.693, 97.1746, 4.37833, 25, 0, 0, -8825.7, 684.693, 97.1746, 0, 94000, 100, 0, 0),
(125421, 25214, 0, 0, 0, -8813.24, 663.096, 95.4238, 5.85095, 25, 0, 0, -8813.24, 663.096, 95.4238, 0, 98000, 100, 0, 0),
(125422, 25214, 0, 0, 0, -8790.85, 615.496, 96.7734, 2.50908, 25, 0, 0, -8790.85, 615.496, 96.7734, 0, 96000, 100, 0, 0),
(125423, 25214, 0, 0, 0, -8928.62, 486.303, 93.8509, 4.62887, 25, 0, 0, -8928.62, 486.303, 93.8509, 0, 94000, 100, 0, 0),
(125424, 25214, 0, 0, 0, -8972.39, 543.056, 93.8324, 0.696378, 25, 0, 0, -8972.39, 543.056, 93.8324, 0, 100000, 100, 0, 0);

INSERT INTO `creature_movement` VALUES
(125407, 1, -9068.26, 504.636, 75.4102, 0, '', '', '', '', '', '', 0, 0, 0, 1.7676, 0, 0),
(125407, 2, -9069.88, 494.022, 76.197, 0, '', '', '', '', '', '', 0, 0, 0, 5.79748, 0, 0),
(125407, 3, -9068.89, 493.48, 76.03, 0, '', '', '', '', '', '', 0, 0, 0, 1.96081, 0, 0),
(125407, 4, -9049.16, 464.447, 91.909, 0, '', '', '', '', '', '', 0, 0, 0, 2.08805, 0, 0),
(125407, 5, -9047.15, 461, 93.2956, 0, '', '', '', '', '', '', 0, 0, 0, 2.10768, 0, 0),
(125407, 6, -9058.65, 450.737, 93.0565, 0, '', '', '', '', '', '', 0, 0, 0, 1.00027, 0, 0),
(125407, 7, -9087.27, 427.916, 92.6069, 9999999, '', '', '', '', '', '', 0, 0, 0, 3.77665, 0, 0),
(125406, 1, -8992.89, 415.588, 73.4584, 0, '', '', '', '', '', '', 0, 0, 0, 1.04109, 0, 0),
(125406, 2, -8997.93, 407.797, 73.2079, 0, '', '', '', '', '', '', 0, 0, 0, 2.4391, 0, 0),
(125406, 3, -9030.65, 442.574, 91.2736, 0, '', '', '', '', '', '', 0, 0, 0, 2.55142, 0, 0),
(125406, 4, -9041.15, 447.731, 93.0564, 0, '', '', '', '', '', '', 0, 0, 0, 5.65533, 0, 0),
(125406, 5, -9076.82, 416.011, 92.9076, 9999999, '', '', '', '', '', '', 0, 0, 0, 3.80965, 0, 0),
(125404, 1, -8991.53, 406.94, 73.3224, 0, '', '', '', '', '', '', 0, 0, 0, 1.42987, 0, 0),
(125404, 2, -8990.15, 406.632, 73.1996, 0, '', '', '', '', '', '', 0, 0, 0, 6.05587, 0, 0),
(125404, 3, -9009.74, 422.149, 78.5056, 0, '', '', '', '', '', '', 0, 0, 0, 5.3608, 0, 0),
(125404, 4, -9032.6, 441.595, 92.0429, 0, '', '', '', '', '', '', 0, 0, 0, 3.12241, 0, 0),
(125404, 5, -9053.45, 431.09, 93.0563, 9999999, '', '', '', '', '', '', 0, 0, 0, 3.79, 0, 0),
(125405, 1, -9073.2, 519.58, 75.2029, 0, '', '', '', '', '', '', 0, 0, 0, 1.56968, 0, 0),
(125405, 2, -9069.87, 495.22, 76.0069, 0, '', '', '', '', '', '', 0, 0, 0, 5.06471, 0, 0),
(125405, 3, -9048.06, 463.064, 92.7181, 0, '', '', '', '', '', '', 0, 0, 0, 5.21786, 0, 0),
(125405, 4, -9051.01, 456.504, 93.2944, 0, '', '', '', '', '', '', 0, 0, 0, 3.92588, 0, 0),
(125405, 5, -9068.94, 441.253, 93.0559, 9999999, '', '', '', '', '', '', 0, 0, 0, 3.54103, 0, 0);
