-- Ship masters & Zeppelin masters texts
INSERT IGNORE INTO `npc_text` (`ID`, `text0_0`, `text0_1`, `lang0`, `prob0`, `em0_0`, `em0_1`, `em0_2`, `em0_3`, `em0_4`, `em0_5`, `text1_0`, `text1_1`, `lang1`, `prob1`, `em1_0`, `em1_1`, `em1_2`, `em1_3`, `em1_4`, `em1_5`, `text2_0`, `text2_1`, `lang2`, `prob2`, `em2_0`, `em2_1`, `em2_2`, `em2_3`, `em2_4`, `em2_5`, `text3_0`, `text3_1`, `lang3`, `prob3`, `em3_0`, `em3_1`, `em3_2`, `em3_3`, `em3_4`, `em3_5`, `text4_0`, `text4_1`, `lang4`, `prob4`, `em4_0`, `em4_1`, `em4_2`, `em4_3`, `em4_4`, `em4_5`, `text5_0`, `text5_1`, `lang5`, `prob5`, `em5_0`, `em5_1`, `em5_2`, `em5_3`, `em5_4`, `em5_5`, `text6_0`, `text6_1`, `lang6`, `prob6`, `em6_0`, `em6_1`, `em6_2`, `em6_3`, `em6_4`, `em6_5`, `text7_0`, `text7_1`, `lang7`, `prob7`, `em7_0`, `em7_1`, `em7_2`, `em7_3`, `em7_4`, `em7_5`) VALUES
(9558, 'You look like you might be needing passage across the Great Sea. Well you have come to the right place, this here is the berth of the Maiden''s Fancy, finest passenger ship to travel these waters. When she arrives, just climb aboard and the next thing you know you will find yourself basking on the sandy beaches of stranglethorn.', NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0),
(9564, 'Of course there''s no danger in everything catching flames and exploding like a huge helium bomb. This baby will get you to Undercity faster and safer than any boat, and the view is truly breathtaking. Speaking of breath, smoking is not allowed while on board the zeppelin, and fire spells are banned from being cast during the trip.', NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0),
(12136, 'Hey there cutie, you looking for a ride to Grom''gol? I hear it gets mighty steamy down in those jungles, maybe I could join you for a show you a real jungle cat.', NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0),
(3149, 'Why you would want to leave these sunny shores and crystal blue waters I have no idea. It''s like paradise down here. But don''t tell my brother Zepetta that, he''s bitter enough already about getting stuck up there in Tirisfal all day long. This Zeppelin here drops off at Orgrimmar so you shouldn''t have to worry about having to listen to him whine. But if you are in Tirisfal anytime soon, heed my warning and don''t get him started.', NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0),
(12137, 'Slip a little coin into the boss''s hand and look what it gets ya. I love my job. Though, if I could find a way to get that little firecracker Snurk reassigned to this port....well, I can''t imagine it any better. But I''m betting that you aren''t here about my business practices. You''re looking for the Zeppelin to Undercity, am I right ? Well that''s great, because it docks right here behind me. Oh and hey, if you see Snurk, put a good word in for me, yould ya ?', NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0),
(3150, 'This here is the finest, most state of the art mode of the art mode of transportation money can build. What? Deeprun Tram? Gnomes? Listen pal, If you belive that garbage then I''ve got a statue down in Stranglethorn to sell ya. Now, are you walking to Grom''Gol or are you gonna ride in style in this fine flying machine ? Your choice.', NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0),
(9566, 'My brother said we could make great money with this trade route, but he didn''t tell me I would be the one living on this side. If you come back this way on the Zeppelin, could you bring me something to eat ? They sell some of the finest meat in Orgrimmar, and I sure could use something that didn''t die weeks before it stopped moving.', NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0),
(12716, 'I do so enjoy sitting out here, listening to the sounds of the Great Sea. Oh, what ? Yes, there is a ship that will take you to Menethil Harbor. It docks here from time to time.', NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0),
(12658, 'You can find passage to Theramore from this dock. Heed my words, those lands are rarely safe to travel for people of the Alliance. Watch your step and your back.', NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0),
(12657, 'This dock here ? Well you can catch the ship that goes to that Night Elf place. What''s it''s name ? Uhh Auberdine I think. I don''t really know for sure. I just load and unload stuff.', NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0),
(12656, 'On the northern dock, you can board a ship that will carry you to Rut\'\'theran Village and Darnassus. From the southern dock, you can find passage across the Great Sea to Menethil Harbor on Khaz Modan. The dock to the west, at the end of the pler, leads to Azuremyst Isle, near the Exodar. Safe journeys to you !', NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0),
(9559, 'I must say, Booty Bay has the best Clam Chowder to be had anywhere in the South Seas. Oh, not interested in culsine eh ? Wll then let me be the first to welcome you to the berth of the Maiden\'s Francy, the finest passenger ship to travel between the Eastern Kingdoms and Kalimdor. She\'s due back for another trip to Ratchet soon, so make yourself comfortable till she arrives.', NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0);

INSERT IGNORE INTO `npc_gossip` (`id`, `npc_guid`, `gossip_type`, `textid`, `option_count`) VALUES
(0, 626, 0, 3149, NULL),
(0, 633, 0, 12137, NULL),
(0, 9696, 0, 12658, NULL),
(0, 9830, 0, 12657, NULL),
(0, 16668, 0, 9566, NULL),
(0, 16691, 0, 3150, NULL),
(0, 26756, 0, 12716, NULL),
(0, 32925, 0, 9558, NULL),
(0, 38327, 0, 9564, NULL),
(0, 38364, 0, 12136, NULL),
(0, 43200, 0, 12656, NULL),
(0,163, 0, 9559, NULL);

-- Ancient gem vein in hyjal
DELETE FROM `gameobject_loot_template` WHERE (`entry`=185557);
INSERT IGNORE INTO `gameobject_loot_template` VALUES
(18557, 23437, 2, 0, 1, 2, 0, 0, 0, 0),
(18557, 23441, 3, 0, 1, 2, 0, 0, 0, 0),
(18557, 23440, 3, 0, 1, 2, 0, 0, 0, 0),
(18557, 23438, 3, 0, 1, 2, 0, 0, 0, 0),
(18557, 23436, 3, 0, 1, 2, 0, 0, 0, 0),
(18557, 32249, 4, 0, 1, 2, 0, 0, 0, 0),
(18557, 32230, 4, 0, 1, 2, 0, 0, 0, 0),
(18557, 32228, 5, 0, 1, 2, 0, 0, 0, 0),
(18557, 32227, 6, 0, 1, 2, 0, 0, 0, 0),
(18557, 32231, 6, 0, 1, 2, 0, 0, 0, 0),
(18557, 32229, 8, 0, 1, 2, 0, 0, 0, 0),
(18557, 23077, 8, 0, 1, 2, 0, 0, 0, 0),
(18557, 23107, 8, 0, 1, 2, 0, 0, 0, 0),
(18557, 23112, 8, 0, 1, 2, 0, 0, 0, 0),
(18557, 23079, 9, 0, 1, 2, 0, 0, 0, 0),
(18557, 23117, 9, 0, 1, 2, 0, 0, 0, 0),
(18557, 21929, 10, 0, 1, 2, 0, 0, 0, 0);

-- Fix Master Engineers
DELETE FROM `npc_trainer` WHERE (`entry`='24868');
DELETE FROM `npc_trainer` WHERE (`entry`='25099');

-- Niobe Whizzlespark
INSERT IGNORE INTO `npc_trainer` (`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES ('24868','44154','120000','202','350','70');
INSERT IGNORE INTO `npc_trainer` (`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES ('24868','44158','180000','202','375','70');
UPDATE `creature_template` SET `npcflag`='16',`trainer_type`='2' WHERE (`entry`='24868');

-- Jonathan Garrett
INSERT IGNORE INTO `npc_trainer` (`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES ('25099','44154','120000','202','350','70');
INSERT IGNORE INTO `npc_trainer` (`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES ('25099','44158','180000','202','375','70');
UPDATE `creature_template` SET `npcflag`='16',`trainer_type`='2' WHERE (`entry`='25099');

-- Some spawns
DELETE FROM `gameobject` WHERE `guid` = '274353';
INSERT IGNORE INTO `gameobject` VALUES ( 274353, 184631, 530, 1791.5, 6848.36, 139.7, 1.98147, 0, 0, 0.836429, 0.548075, 25, 0, 1, 0);
DELETE FROM `gameobject` WHERE `guid` = '274355';
INSERT IGNORE INTO `gameobject` VALUES ( 274355, 184631, 530, 1786.36, 6841.49, 138.727, 2.53517, 0, 0, 0.954383, 0.298585, 25, 0, 1, 0);
DELETE FROM `gameobject` WHERE `guid` = '274356';
INSERT IGNORE INTO `gameobject` VALUES ( 274356, 184631, 530, 1771.02, 6861.53, 141.183, 5.31234, 0, 0, 0.466582, -0.884478, 25, 0, 1, 0);
DELETE FROM `gameobject` WHERE `guid` = '274357';
INSERT IGNORE INTO `gameobject` VALUES ( 274357, 184631, 530, 1784.69, 6870.89, 141.015, 6.03019, 0, 0, 0.126158, -0.99201, 25, 0, 1, 0);
DELETE FROM `gameobject` WHERE `guid` = '274358';
INSERT IGNORE INTO `gameobject` VALUES ( 274358, 184631, 530, 1813.46, 6860.67, 144.072, 5.34533, 0, 0, 0.451931, -0.892053, 25, 0, 1, 0);
DELETE FROM `gameobject` WHERE `guid` = '274360';
INSERT IGNORE INTO `gameobject` VALUES ( 274360, 184631, 530, 1797.44, 6907.98, 142.335, 3.03547, 0, 0, 0.998593, 0.0530364, 25, 0, 1, 0);
DELETE FROM `gameobject` WHERE `guid` = '274363';
INSERT IGNORE INTO `gameobject` VALUES ( 274363, 184631, 530, 1790.25, 6894.01, 144.566, 4.50574, 0, 0, 0.776268, -0.630403, 25, 0, 1, 0);
DELETE FROM `gameobject` WHERE `guid` = '274364';
INSERT IGNORE INTO `gameobject` VALUES ( 274364, 184631, 530, 1824.89, 6867.18, 144.086, 0.102795, 0, 0, 0.0513749, 0.998679, 25, 0, 1, 0);
DELETE FROM `gameobject` WHERE `guid` = '274366';
INSERT IGNORE INTO `gameobject` VALUES ( 274366, 184631, 530, 1836.64, 6915.89, 142.313, 1.37828, 0, 0, 0.635875, 0.771792, 25, 0, 1, 0);
DELETE FROM `gameobject` WHERE `guid` = '274367';
INSERT IGNORE INTO `gameobject` VALUES ( 274367, 184631, 530, 1826.38, 6899.53, 143.678, 4.85603, 0, 0, 0.654544, -0.756024, 25, 0, 1, 0);
DELETE FROM `gameobject` WHERE `guid` = '274369';
INSERT IGNORE INTO `gameobject` VALUES ( 274369, 184631, 530, 1759.97, 6828.07, 140.181, 0.830072, 0, 0, 0.403223, 0.915102, 25, 0, 1, 0);


-- Gameobjects which aren't in world, but still exist. Original SQL provided by Yas, edited by me.

INSERT INTO `gameobject_template` VALUES ('60093', '5', '3', 'TrollskaVez', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60094', '5', '119', 'DuskwoodKer', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60095', '5', '139', 'SochaMage', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60096', '5', '153', 'ElwynnKamen', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60097', '5', '205', 'SearingGorgeSloup', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60098', '5', '207', 'SearingGorgeSloup2', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60099', '5', '239', 'Kbelik', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60100', '5', '260', 'OranzovaMlha', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60101', '5', '280', 'ElwynnKer', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60102', '5', '281', 'ElwynnKer2', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60103', '5', '282', 'ElwynnKer3', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60104', '5', '283', 'SilverpineKer', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60105', '5', '284', 'ElwynnKer4', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60106', '5', '291', 'ZnicenyVozik', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60107', '5', '294', 'Sibenice', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60108', '5', '392', 'PostelDvojluzko', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60109', '5', '393', 'Busta', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60110', '5', '420', 'ModreZavesy', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60111', '2', '421', 'DvereMech', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60112', '5', '463', 'PostelPalanda', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60113', '5', '518', 'TreninkovyPanak', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60114', '5', '624', 'VlajkaGryf', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60115', '5', '647', 'KammenaBrana', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60116', '5', '730', 'Ohniste', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60117', '5', '753', 'MulgoreSkala', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60118', '5', '754', 'LordaeronOhniste', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60119', '5', '927', 'ZasnezenyStrom', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60120', '5', '1110', 'KladkostrojSeDrevem', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60121', '5', '1167', 'Portal', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60122', '5', '1187', 'KryptaZavrena', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60123', '5', '2107', 'DrevenySloup', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60124', '5', '1508', 'ZavrenaMiniarena', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60125', '5', '4432', 'Pentagram', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60126', '5', '5073', 'Stalagmit', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60127', '5', '5112', 'Koryto', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60128', '5', '5171', 'TreninkovyPanak2', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60129', '5', '5211', 'OgreBanner', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60130', '5', '5265', 'Globus', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60131', '5', '5331', 'VystrazneSvetlo', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60132', '5', '5671', 'ElwynnLampa', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60133', '5', '5831', 'DrevenaZnicenaBrana', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60134', '5', '5914', 'Polstar', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60135', '5', '6143', 'VysokyDrevenySloup', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60136', '5', '6191', 'Slama', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60137', '5', '6192', 'DustwallowKer', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60138', '5', '6193', 'HromadaDreva', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60139', '5', '6315', 'FialovaSvicka', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60140', '5', '6355', 'ZnicenaZedKamenna', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60141', '5', '6357', 'DrevenaZidle', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60142', '5', '6361', 'BlokovaciRam', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60143', '5', '6410', 'Strasak', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60144', '5', '6413', 'ZavesenyKrystal', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60145', '5', '6474', 'Portal2', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60146', '5', '6556', 'NightElfMolo', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60147', '5', '6621', 'DarkmoonPlakat', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60148', '5', '6639', 'GoblinStroj', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60149', '5', '6669', 'MannorothovyMece', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60150', '5', '6683', 'DrevenyTram', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60151', '5', '6703', 'CervenyStanek', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60152', '5', '6713', 'MedivhuvTrun', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60153', '5', '6717', 'ZnicenaDrevenazed', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60154', '5', '6718', 'ZnicenaDrevenazed2', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60155', '5', '6617', 'SedaMlha', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60156', '5', '7221', 'FialovaMlha', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60157', '5', '6452', 'ZelenaMlha', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60158', '5', '6719', 'ZakladyDomu', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60159', '5', '6720', 'ZakladyDomu2', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60160', '5', '6721', 'ZakladyDomu3', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60161', '5', '6733', 'Barikada', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60162', '5', '6776', 'ZavesenaDraciKostra', '0', '0', '0.4', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60163', '5', '6784', 'OrkskyBanner', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60164', '5', '6847', 'BloodelfskyBanner', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60165', '5', '6919', 'KerEmeralddream', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60166', '5', '6938', 'TaxiGryphon', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60167', '5', '6950', 'TaxiGryphonZniceny', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60168', '5', '6977', 'ZeleneHouby', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60169', '5', '7018', 'OrkskyKatapultOutland', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60170', '5', '7084', 'BloodelfskaLucerna', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60171', '5', '7127', 'VelkySloupCrevenehoSvetla', '0', '0', '0.3', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `gameobject_template` VALUES ('60172', '5', '7182', 'BarieraNetherstorm', '0', '0', '0.1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');

-- Eventai scripts for Nalorakk,Halazzi,Akil'Zon,Zul'Jin bosses in ZulAman. This solution can be before ScriptDev2 Or somebody else make cpp script for bosses. Now almost blizzlike.

INSERT INTO `scriptdev2`.`eventai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_param1`, `event_param2`, `event_param3`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES
(38, 23574, 0, 0, 60000, 60000, 0, 11, 44008, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(39, 23574, 0, 0, 90000, 90000, 0, 11, 43661, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(40, 23574, 0, 0, 120000, 120000, 0, 11, 43621, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(41, 23574, 0, 0, 45000, 45000, 0, 11, 43657, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(42, 23574, 0, 0, 480000, 480000, 0, 11, 33653, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(43, 23574, 0, 0, 60000, 20000, 0, 12, 24159, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(44, 23574, 1, 0, 1000, 100, 0, 2, 1880518, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(45, 23574, 4, 0, 80, 0, 0, 2, 1880519, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(46, 23574, 4, 0, 60, 0, 0, 2, 1880520, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(47, 23574, 4, 0, 40, 0, 0, 2, 1880521, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(48, 23574, 4, 0, 20, 0, 0, 2, 1880522, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(49, 23574, 8, 0, 0, 0, 0, 2, 1880523, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(50, 23863, 0, 0, 10000, 0, 0, 11, 41195, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(51, 23863, 4, 0, 95, 60000, 0, 11, 43093, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(52, 23863, 4, 0, 80, 0, 0, 11, 42594, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(53, 23863, 4, 0, 80, 20000, 0, 11, 43095, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(54, 23863, 4, 0, 80, 15000, 0, 11, 24407, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(55, 23863, 4, 0, 60, 0, 0, 11, 42606, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(56, 23863, 4, 0, 40, 0, 0, 11, 42607, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(57, 23863, 4, 0, 40, 20000, 0, 11, 43150, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(58, 23863, 4, 0, 40, 27000, 0, 11, 43153, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(59, 23863, 4, 0, 20, 0, 0, 11, 32818, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(60, 23863, 4, 0, 20, 12000, 0, 11, 43213, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(61, 23863, 4, 0, 20, 15000, 0, 11, 43582, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(62, 23863, 4, 0, 80, 0, 0, 2, 1880524, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(63, 23863, 4, 0, 60, 0, 0, 2, 1880525, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(64, 23863, 0, 0, 1000, 999999, 0, 2, 1880526, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(65, 23863, 4, 0, 20, 0, 0, 2, 1880527, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(66, 23863, 1, 0, 1000, 100, 0, 2, 1880528, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(67, 23863, 4, 0, 1, 0, 0, 2, 1880529, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(68, 23863, 4, 0, 90, 0, 0, 2, 1880530, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(69, 23863, 7, 0, 0, 0, 0, 2, 1880531, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(71, 23863, 4, 0, 60, 0, 0, 12, 19922, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(72, 23863, 4, 0, 55, 0, 0, 12, 19922, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(74, 23576, 1, 0, 600000, 0, 0, 11, 33653, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(75, 23576, 0, 0, 25000, 0, 0, 11, 19820, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(76, 23576, 0, 0, 20000, 0, 0, 11, 25787, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(77, 23576, 4, 0, 60, 0, 0, 11, 42384, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(78, 23576, 4, 0, 55, 0, 0, 11, 42594, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(79, 23576, 4, 0, 50, 18000, 0, 11, 42395, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(80, 23576, 4, 0, 40, 20000, 0, 11, 42397, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(81, 23576, 4, 0, 30, 15000, 0, 11, 42398, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(82, 23576, 1, 0, 1000, 0, 0, 7, 1880532, 1880533, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(83, 23576, 7, 0, 0, 100, 0, 2, 1880534, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(84, 23576, 8, 0, 100, 0, 0, 2, 1880535, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(85, 23576, 4, 0, 96, 0, 0, 2, 1880536, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(86, 23576, 4, 0, 55, 0, 0, 2, 1880537, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(87, 23577, 4, 0, 90, 0, 0, 11, 41254, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(88, 23577, 4, 0, 75, 0, 0, 12, 24143, 5, 180000, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(89, 23577, 4, 0, 50, 0, 0, 12, 24143, 5, 180000, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(90, 23577, 4, 0, 25, 0, 0, 12, 24224, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(93, 23577, 8, 0, 100, 0, 0, 2, 1880538, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(94, 23577, 4, 0, 75, 0, 0, 2, 1880539, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(95, 23577, 4, 0, 50, 0, 0, 2, 1880540, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');

INSERT INTO `scriptdev2`.`localized_texts` (`id`, `locale_0`, `locale_1`, `locale_2`, `locale_3`, `locale_4`, `locale_5`, `locale_6`, `locale_7`, `comment`) VALUES
(1880518, 'Your death gonna be quick, strangers. You shoulda never have come to this place...', '', '', '', '', '', '', '', ''),
(1880519, 'I be da predator! You da prey...', '', '', '', '', '', '', '', ''),
(1880520, 'Summoning Birds: Feed, me bruddahs!', '', '', '', '', '', '', '', ''),
(1880521, 'Stop your cryin\'\'!', '', '', '', '', '', '', '', ''),
(1880522, 'Ya got nothin\'\'!', '', '', '', '', '', '', '', ''),
(1880523, 'You can\'\'t... kill... me spirit!', '', '', '', '', '', '', '', ''),
(1880524, 'Got me some new tricks...like me bruddah bear!', '', '', '', '', '', '', '', ''),
(1880525, 'Dere be no hidin'' from da eagle!', '', '', '', '', '', '', '', ''),
(1880526, 'Let me introduce to you my new bruddahs: fang and claw!', '', '', '', '', '', '', '', ''),
(1880527, 'Ya don'' have to look to da sky to see da dragonhawk!', '', '', '', '', '', '', '', ''),
(1880528, 'Everybody always wanna take from us. Now we gonna start takin\'\' back. Anybody who get in our way...gonna drown in their own blood! De Amani empire be back now...seekin\'\' vengeance. And we gonna start...with you!', '', '', '', '', '', '', '', ''),
(1880529, 'Mebbe me fall...but da Amani empire...never gonna die...', '', '', '', '', '', '', '', ''),
(1880530, 'You too slow! Me too strong!', '', '', '', '', '', '', '', ''),
(1880531, 'Lot more gonna fall like you!', '', '', '', '', '', '', '', ''),
(1880532, 'Da Amani gonna rule again!', '', '', '', '', '', '', '', ''),
(1880533, 'You be dead soon enough!', '', '', '', '', '', '', '', ''),
(1880534, 'Now whatchoo got to say?', '', '', '', '', '', '', '', ''),
(1880535, 'I... be waitin\'\' on da udda side....', '', '', '', '', '', '', '', ''),
(1880536, 'Make way for Nalorakk!', '', '', '', '', '', '', '', ''),
(1880537, 'You call on da beast, you gonna get more dan you bargain for!', '', '', '', '', '', '', '', ''),
(1880538, 'Chaga... choka''jinn.', '', '', '', '', '', '', '', ''),
(1880539, 'I fight wit\'\' untamed spirit...', '', '', '', '', '', '', '', ''),
(1880540, 'Me gonna carve ya now!', '', '', '', '', '', '', '', '');

UPDATE `creature_template` SET `ScriptName`='mob_eventai' WHERE `entry` IN (23574,23863,23576,23577);

-- Some min. lvl fix for dungeons. Onyxia, Molten Core, Shadowfang Keep
UPDATE `areatrigger_teleport` SET `required_level` = '14' where `id`=145;
UPDATE `areatrigger_teleport` SET `required_level` = '14' where `id`=194;
UPDATE `areatrigger_teleport` SET `required_level` = '40' where `id`=1472;
UPDATE `areatrigger_teleport` SET `required_level` = '50' where `id`=2848;
UPDATE `areatrigger_teleport` SET `required_level` = '50' where `id`=2890;

-- Fix charges for some items

UPDATE `item_template` SET `spellcharges_1` = -50 WHERE `entry` in (29528,29529,29530,29531,29532);

-- Stoneforged Claymore and Windforged Rapier
UPDATE item_template SET stat_type6='4',bonding='2' WHERE entry = '30086';
UPDATE item_template SET stat_type6='31',bonding='2' WHERE entry = '30077';

-- Sylvanas Windrunner
UPDATE `creature_template` SET `minlevel` = '65',
`maxlevel` = '69',
`mindmg` = '2390',
`maxdmg` = '4500',
`attackpower` = '6337',
`minrangedmg` = '2390',
`maxrangedmg` = '4500',
`rangedattackpower` = '6800',
`spell1` = '28615',
`spell2` = '35950',
`spell3` = '29881',
`spell4` = '45270' WHERE `entry` = '10181';

-- T5 and T6 Loot
REPLACE INTO `creature_loot_template` VALUES
(19516, 0, -19516, -1, 1, 1, 0, 0, 0, 0),
(19516, 30248, 100/3, -1, 1, 1, 0, 0, 0, 0),
(19516, 30249, 100/3, -1, 1, 1, 0, 0, 0, 0),
(19516, 30250, 100/3, -1, 1, 1, 0, 0, 0, 0),
(19516, 29983, 100/5, -2, 1, 1, 0, 0, 0, 0),
(19516, 29984, 100/5, -2, 1, 1, 0, 0, 0, 0),
(19516, 29985, 100/5, -2, 1, 1, 0, 0, 0, 0),
(19516, 29986, 100/5, -2, 1, 1, 0, 0, 0, 0),
(19516, 32515, 100/5, -2, 1, 1, 0, 0, 0, 0),
(19516, 30619, 13.84, 0, 1, 1, 0, 0, 0, 0),
(19516, 30450, 10.56, 0, 1, 1, 0, 0, 0, 0),
(19516, 30304, 8.61, 0, 1, 1, 0, 7, 165, 1),
(19516, 30301, 4.51, 0, 1, 1, 0, 7, 165, 1),
(19516, 30303, 4.1, 0, 1, 1, 0, 7, 165, 1),
(19516, 30321, 4.1, 0, 1, 1, 0, 7, 164, 1),
(19516, 30280, 3.69, 0, 1, 1, 0, 7, 197, 1),
(19516, 30281, 3.69, 0, 1, 1, 0, 7, 197, 1),
(19516, 30302, 2.87, 0, 1, 1, 0, 7, 165, 1),
(19516, 30322, 0.82, 0, 1, 1, 0, 7, 164, 1),
(19516, 30305, 0.8, 0, 1, 1, 0, 0, 0, 0),
(19516, 30308, 0.8, 0, 1, 1, 0, 0, 0, 0),
(19516, 30307, 0.73, 0, 1, 1, 0, 0, 0, 0),
(19516, 30283, 0.66, 0, 1, 1, 0, 0, 0, 0),
(19516, 30282, 0.51, 0, 1, 1, 0, 0, 0, 0),
(19516, 30306, 0.36, 0, 1, 1, 0, 0, 0, 0),
(19516, 24914, 0.22, 0, 1, 1, 0, 0, 0, 0),
(19516, 30323, 0.22, 0, 1, 1, 0, 0, 0, 0),
(19516, 30324, 0.22, 0, 1, 1, 0, 0, 0, 0),
(19516, 24690, 0.07, 0, 1, 1, 0, 0, 0, 0);

-- Leotheras the Blind - Two tokens, one non set.
REPLACE INTO `creature_loot_template` VALUES
(21215, 0, -21215, -1, 1, 1, 0, 0, 0, 0),
(21215, 30240, 100/3, -1, 1, 1, 0, 0, 0, 0),
(21215, 30239, 100/3, -1, 1, 1, 0, 0, 0, 0),
(21215, 30241, 100/3, -1, 1, 1, 0, 0, 0, 0),
(21215, 30092, 100/4, -2, 1, 1, 0, 0, 0, 0),
(21215, 30096, 100/4, -2, 1, 1, 0, 0, 0, 0),
(21215, 30091, 100/4, -2, 1, 1, 0, 0, 0, 0),
(21215, 30097, 100/4, -2, 1, 1, 0, 0, 0, 0),
(21215, 30095, 16.3043, 0, 1, 1, 0, 0, 0, 0),
(21215, 30627, 10.8695, 0, 1, 1, 0, 0, 0, 0),
(21215, 30280, 9.35, 0, 1, 1, 0, 7, 197, 1),
(21215, 30281, 9.35, 0, 1, 1, 0, 7, 197, 1),
(21215, 30304, 8.68, 0, 1, 1, 0, 7, 165, 1),
(21215, 30322, 8.68, 0, 1, 1, 0, 7, 164, 1),
(21215, 30302, 8.02, 0, 1, 1, 0, 7, 165, 1),
(21215, 30301, 6.68, 0, 1, 1, 0, 7, 165, 1),
(21215, 30321, 6.01, 0, 1, 1, 0, 7, 164, 1),
(21215, 30303, 4.68, 0, 1, 1, 0, 7, 165, 1);

-- Fathom-Lord Karathress - Two tokens, one non set.
REPLACE INTO `creature_loot_template` VALUES
(21214, 0, -21214, -1, 1, 1, 0, 0, 0, 0),
(21214, 30245, 100/3, -1, 1, 1, 0, 0, 0, 0),
(21214, 30246, 100/3, -1, 1, 1, 0, 0, 0, 0),
(21214, 30247, 100/3, -1, 1, 1, 0, 0, 0, 0),
(21214, 30100, 50, -2, 1, 1, 0, 0, 0, 0),
(21214, 30101, 50, -2, 1, 1, 0, 0, 0, 0),
(21214, 30090, 14.4951, 0, 1, 1, 0, 0, 0, 0),
(21214, 30099, 13.8436, 0, 1, 1, 0, 0, 0, 0),
(21214, 30663, 13.1921, 0, 1, 1, 0, 0, 0, 0),
(21214, 30626, 11.8892, 0, 1, 1, 0, 0, 0, 0),
(21214, 30303, 10.45, 0, 1, 1, 0, 7, 165, 1),
(21214, 30304, 6.82, 0, 1, 1, 0, 7, 165, 1),
(21214, 30321, 4.55, 0, 1, 1, 0, 7, 164, 1),
(21214, 30302, 4.09, 0, 1, 1, 0, 7, 165, 1),
(21214, 30280, 3.18, 0, 1, 1, 0, 7, 197, 1),
(21214, 30322, 3.18, 0, 1, 1, 0, 7, 164, 1),
(21214, 30281, 2.27, 0, 1, 1, 0, 7, 197, 1),
(21214, 30301, 1.36, 0, 1, 1, 0, 7, 165, 1),
(21214, 25309, 0.32573, 0, 1, 1, 0, 0, 0, 0),
(21214, 24689, 0.16286, 0, 1, 1, 0, 0, 0, 0),
(21214, 24910, 0.16286, 0, 1, 1, 0, 0, 0, 0),
(21214, 24913, 0.16286, 0, 1, 1, 0, 0, 0, 0),
(21214, 25057, 0.16286, 0, 1, 1, 0, 0, 0, 0),
(21214, 25099, 0.16286, 0, 1, 1, 0, 0, 0, 0);

-- Lady Vashj - Two tokens, two non set.
REPLACE INTO `creature_loot_template` VALUES
(21212, 0, -21212, -1, 1, 1, 0, 0, 0, 0),
(21212, 1, -21212, -2, 1, 1, 0, 0, 0, 0),
(21212, 30183, 100, 0, 2, 2, 0, 0, 0, 0),
(21212, 30244, 100/3, -1, 1, 1, 0, 0, 0, 0),
(21212, 30243, 100/3, -1, 1, 1, 0, 0, 0, 0),
(21212, 30242, 100/3, -1, 1, 1, 0, 0, 0, 0),
(21212, 30280, 7.22, 0, 1, 1, 0, 7, 197, 1),
(21212, 30302, 6.74, 0, 1, 1, 0, 7, 165, 1),
(21212, 30301, 4.81, 0, 1, 1, 0, 7, 165, 1),
(21212, 30321, 26.96, 0, 1, 1, 0, 7, 164, 1),
(21212, 30322, 19.26, 0, 1, 1, 0, 7, 164, 1),
(21212, 30303, 14.93, 0, 1, 1, 0, 7, 165, 1),
(21212, 30281, 14.44, 0, 1, 1, 0, 7, 197, 1),
(21212, 30304, 13.96, 0, 1, 1, 0, 7, 165, 1),
(21212, 32895, 19.51, 0, 1, 1, 0, 0, 0, 0),
(21212, 30102, 100/6, -2, 1, 1, 0, 0, 0, 0),
(21212, 30112, 100/6, -2, 1, 1, 0, 0, 0, 0),
(21212, 30107, 100/6, -2, 1, 1, 0, 0, 0, 0),
(21212, 30111, 100/6, -2, 1, 1, 0, 0, 0, 0),
(21212, 30104, 100/6, -2, 1, 1, 0, 0, 0, 0),
(21212, 30106, 100/6, -2, 1, 1, 0, 0, 0, 0),
(21212, 30110, 13.24, 0, 1, 1, 0, 0, 0, 0),
(21212, 30108, 12.53, 0, 1, 1, 0, 0, 0, 0),
(21212, 30105, 11.02, 0, 1, 1, 0, 0, 0, 0),
(21212, 30621, 11.02, 0, 1, 1, 0, 0, 0, 0),
(21212, 30103, 10.23, 0, 1, 1, 0, 0, 0, 0),
(21212, 30109, 9.6, 0, 1, 1, 0, 0, 0, 0),
(21212, 30283, 1.51, 0, 1, 1, 0, 0, 0, 0),
(21212, 30305, 1.43, 0, 1, 1, 0, 0, 0, 0),
(21212, 30308, 1.35, 0, 1, 1, 0, 0, 0, 0),
(21212, 30306, 1.27, 0, 1, 1, 0, 0, 0, 0),
(21212, 30324, 1.19, 0, 1, 1, 0, 0, 0, 0),
(21212, 30307, 0.56, 0, 1, 1, 0, 0, 0, 0),
(21212, 30282, 0.48, 0, 1, 1, 0, 0, 0, 0),
(21212, 30323, 0.48, 0, 1, 1, 0, 0, 0, 0),
(21212, 22576, 0.08, 0, 1, 1, 0, 0, 0, 0),
(21212, 28729, 0.08, 0, 1, 1, 0, 0, 0, 0),
(21212, 28731, 0.08, 0, 1, 1, 0, 0, 0, 0),
(21212, 28732, 0.08, 0, 1, 1, 0, 0, 0, 0),
(21212, 28733, 0.08, 0, 1, 1, 0, 0, 0, 0),
(21212, 28734, 0.08, 0, 1, 1, 0, 0, 0, 0),
(21212, 28735, 0.08, 0, 1, 1, 0, 0, 0, 0),
(21212, 28740, 0.08, 0, 1, 1, 0, 0, 0, 0),
(21212, 28741, 0.08, 0, 1, 1, 0, 0, 0, 0),
(21212, 28742, 0.08, 0, 1, 1, 0, 0, 0, 0),
(21212, 28743, 0.08, 0, 1, 1, 0, 0, 0, 0),
(21212, 28744, 0.08, 0, 1, 1, 0, 0, 0, 0),
(21212, 29906, 0, 100, 1, 1, 1, 0, 0, 0);

-- Kael'thas Sunstrider - Two tokens, two non set, one necklace.
-- The necklace is not listed
REPLACE INTO `creature_loot_template` VALUES
(19622, 0, -19622, -1, 1, 1, 0, 0, 0, 0),
(19622, 1, -19622, -2, 1, 1, 0, 0, 0, 0),
(19622, 30183, 100, 0, 2, 2, 0, 0, 0, 0),
(19622, 32405, 99.8, 0, 1, 1, 0, 0, 0, 0),
(19622, 30236, 100/3, -1, 1, 1, 0, 0, 0, 0),
(19622, 30237, 100/3, -1, 1, 1, 0, 0, 0, 0),
(19622, 30238, 100/3, -1, 1, 1, 0, 0, 0, 0),
(19622, 29990, 100/5, -2, 1, 1, 0, 0, 0, 0),
(19622, 29987, 100/5, -2, 1, 1, 0, 0, 0, 0),
(19622, 29991, 100/5, -2, 1, 1, 0, 0, 0, 0),
(19622, 29995, 100/5, -2, 1, 1, 0, 0, 0, 0),
(19622, 29998, 100/5, -2, 1, 1, 0, 0, 0, 0),
(19622, 29996, 16.02, 0, 1, 1, 0, 0, 0, 0),
(19622, 29994, 15.63, 0, 1, 1, 0, 0, 0, 0),
(19622, 29997, 14.26, 0, 1, 1, 0, 0, 0, 0),
(19622, 29992, 12.89, 0, 1, 1, 0, 0, 0, 0),
(19622, 29988, 11.72, 0, 1, 1, 0, 0, 0, 0),
(19622, 32896, 11.72, 0, 1, 1, 0, 0, 0, 0),
(19622, 29993, 10.55, 0, 1, 1, 0, 0, 0, 0),
(19622, 29989, 5.47, 0, 1, 1, 0, 0, 0, 0),
(19622, 30322, 5.43, 0, 1, 1, 0, 7, 164, 1),
(19622, 30302, 3.26, 0, 1, 1, 0, 7, 165, 1),
(19622, 30304, 3.26, 0, 1, 1, 0, 7, 165, 1),
(19622, 32458, 2.54, 0, 1, 1, 0, 0, 0, 0),
(19622, 30280, 2.17, 0, 1, 1, 0, 7, 197, 1),
(19622, 30281, 2.17, 0, 1, 1, 0, 7, 197, 1),
(19622, 30321, 2.17, 0, 1, 1, 0, 7, 164, 1),
(19622, 30306, 1.95, 0, 1, 1, 0, 0, 0, 0),
(19622, 30324, 1.37, 0, 1, 1, 0, 0, 0, 0),
(19622, 30308, 1.17, 0, 1, 1, 0, 0, 0, 0),
(19622, 30307, 0.98, 0, 1, 1, 0, 0, 0, 0),
(19622, 30323, 0.78, 0, 1, 1, 0, 0, 0, 0),
(19622, 29905, 0, 100, 1, 1, 1, 0, 0, 0);

-- Azgalor - Two tokens, one non set.
REPLACE INTO `creature_loot_template` VALUES
(17842, 0, -17842, -1, 1, 1, 0, 0, 0, 0),
(17842, 31094, 100/3, -1, 1, 1, 0, 0, 0, 0),
(17842, 31093, 100/3, -1, 1, 1, 0, 0, 0, 0),
(17842, 31092, 100/3, -1, 1, 1, 0, 0, 0, 0),
(17842, 30899, 100/5, -2, 1, 1, 0, 0, 0, 0),
(17842, 30898, 100/5, -2, 1, 1, 0, 0, 0, 0),
(17842, 30900, 100/5, -2, 1, 1, 0, 0, 0, 0),
(17842, 30896, 100/5, -2, 1, 1, 0, 0, 0, 0),
(17842, 30897, 100/5, -2, 1, 1, 0, 0, 0, 0),
(17842, 32295, 37.23, 0, 1, 1, 0, 7, 755, 1),
(17842, 32289, 28.37, 0, 1, 1, 0, 7, 755, 1),
(17842, 32285, 26.6, 0, 1, 1, 0, 7, 755, 1),
(17842, 32307, 21.28, 0, 1, 1, 0, 7, 755, 1),
(17842, 32298, 19.5, 0, 1, 1, 0, 7, 755, 1),
(17842, 30901, 18.55, 0, 1, 1, 0, 0, 0, 0),
(17842, 32303, 10.64, 0, 1, 1, 0, 7, 755, 1),
(17842, 32296, 8.87, 0, 1, 1, 0, 7, 755, 1),
(17842, 32297, 8.87, 0, 1, 1, 0, 7, 755, 1);

-- Archimonde the Defiler - Two tokens, two non set.
REPLACE INTO `creature_loot_template` VALUES
(17968, 0, -17968, -1, 1, 1, 0, 0, 0, 0),
(17968, 1, -17968, -2, 1, 1, 0, 0, 0, 0),
(17968, 31096, 100/3, -1, 1, 1, 0, 0, 0, 0),
(17968, 31097, 100/3, -1, 1, 1, 0, 0, 0, 0),
(17968, 31095, 100/3, -1, 1, 1, 0, 0, 0, 0),
(17968, 30913, 100/5, -2, 1, 1, 0, 0, 0, 0),
(17968, 30904, 100/5, -2, 1, 1, 0, 0, 0, 0),
(17968, 30905, 100/5, -2, 1, 1, 0, 0, 0, 0),
(17968, 30903, 100/5, -2, 1, 1, 0, 0, 0, 0),
(17968, 30912, 100/5, -2, 1, 1, 0, 0, 0, 0),
(17968, 30902, 26.09, 0, 1, 1, 0, 0, 0, 0),
(17968, 30911, 21.12, 0, 1, 1, 0, 0, 0, 0),
(17968, 30908, 16.15, 0, 1, 1, 0, 0, 0, 0),
(17968, 30909, 11.8, 0, 1, 1, 0, 0, 0, 0),
(17968, 30906, 10.56, 0, 1, 1, 0, 0, 0, 0),
(17968, 30910, 6.83, 0, 1, 1, 0, 0, 0, 0),
(17968, 32289, 63.41, 0, 1, 1, 0, 7, 755, 1),
(17968, 32285, 48.78, 0, 1, 1, 0, 7, 755, 1),
(17968, 32307, 34.15, 0, 1, 1, 0, 7, 755, 1),
(17968, 32298, 32.52, 0, 1, 1, 0, 7, 755, 1),
(17968, 32297, 30.89, 0, 1, 1, 0, 7, 755, 1),
(17968, 32303, 27.64, 0, 1, 1, 0, 7, 755, 1),
(17968, 32295, 26.02, 0, 1, 1, 0, 7, 755, 1),
(17968, 32296, 13.01, 0, 1, 1, 0, 7, 755, 1);

-- Mother Shahraz - Two tokens, one non set.
REPLACE INTO `creature_loot_template` VALUES
(22947, 0, -22947, -1, 1, 1, 0, 0, 0, 0),
(22947, 31103, 100/3, -1, 1, 1, 0, 0, 0, 0),
(22947, 31101, 100/3, -1, 1, 1, 0, 0, 0, 0),
(22947, 31102, 100/3, -1, 1, 1, 0, 0, 0, 0),
(22947, 32368, 20.22, 0, 1, 1, 0, 0, 0, 0),
(22947, 32369, 20.22, 0, 1, 1, 0, 0, 0, 0),
(22947, 32367, 100/3, -2, 1, 1, 0, 0, 0, 0),
(22947, 32365, 100/3, -2, 1, 1, 0, 0, 0, 0),
(22947, 32366, 100/3, -2, 1, 1, 0, 0, 0, 0),
(22947, 32370, 11.24, 0, 1, 1, 0, 0, 0, 0),
(22947, 32755, 4.49, 0, 1, 1, 0, 0, 0, 0),
(22947, 32738, 10.25, 0, 1, 1, 0, 7, 164, 1),
(22947, 32748, 16.39, 0, 1, 1, 0, 7, 165, 1),
(22947, 32750, 12.3, 0, 1, 1, 0, 7, 165, 1),
(22947, 32744, 4.1, 0, 1, 1, 0, 7, 165, 1),
(22947, 32754, 8.2, 0, 1, 1, 0, 7, 197, 1),
(22947, 32752, 4.1, 0, 1, 1, 0, 7, 197, 1);

-- Illidari Council - Two tokens, one non set
-- Gathios the Shatteret
REPLACE INTO `creature_loot_template` VALUES
(22949, 31098, 100/3, 0, 1, 1, 0, 0, 0, 0),
(22949, 31099, 100/3, 0, 1, 1, 0, 0, 0, 0),
(22949, 31100, 100/3, 0, 1, 1, 0, 0, 0, 0);

-- Veras Darkshadow
REPLACE INTO `creature_loot_template` VALUES
(22952, 31099, 100/3, 0, 1, 1, 0, 0, 0, 0),
(22952, 31098, 100/3, 0, 1, 1, 0, 0, 0, 0),
(22952, 31100, 100/3, 0, 1, 1, 0, 0, 0, 0);

-- High Nethermancer Zerevor
REPLACE INTO `creature_loot_template` VALUES
(22950, 32505, 37.93, 0, 1, 1, 0, 0, 0, 0),
(22950, 32331, 13.79, 0, 1, 1, 0, 0, 0, 0),
(22950, 32373, 100/4, -1, 1, 1, 0, 0, 0, 0),
(22950, 32518, 100/4, -1, 1, 1, 0, 0, 0, 0),
(22950, 32519, 100/4, -1, 1, 1, 0, 0, 0, 0),
(22950, 32376, 100/4, -1, 1, 1, 0, 0, 0, 0);

-- Illidan Stormrage - Two tokens, two non set.
REPLACE INTO `creature_loot_template` VALUES
(22917, 0, -22917, -1, 1, 1, 0, 0, 0, 0),
(22917, 32235, 100, 0, 1, 1, 0, 0, 0, 0),
(22917, 32525, 100, 0, 1, 1, 0, 0, 0, 0),
(22917, 31090, 100/3, -1, 1, 1, 0, 0, 0, 0),
(22917, 31091, 100/3, -1, 1, 1, 0, 0, 0, 0),
(22917, 31089, 100/3, -1, 1, 1, 0, 0, 0, 0),
(22917, 32336, 48.8, 0, 1, 1, 0, 0, 0, 0),
(22917, 32483, 43.8, 0, 1, 1, 0, 0, 0, 0),
(22917, 32500, 37.5, 0, 1, 1, 0, 0, 0, 0),
(22917, 32471, 27.5, 0, 1, 1, 0, 0, 0, 0),
(22917, 32497, 20, 0, 1, 1, 0, 0, 0, 0),
(22917, 32374, 18.8, 0, 1, 1, 0, 0, 0, 0),
(22917, 32375, 12.5, 0, 1, 1, 0, 0, 0, 0),
(22917, 32496, 11, 0, 1, 1, 0, 0, 0, 0),
(22917, 32838, 8, 0, 1, 1, 0, 0, 0, 0),
(22917, 32837, 4, 0, 1, 1, 0, 0, 0, 0),
(22917, 32751, 1.3, 0, 1, 1, 0, 0, 0, 0),
(22917, 32753, 1.3, 0, 1, 1, 0, 0, 0, 0),
(22917, 32739, 1.3, 0, 1, 1, 0, 0, 0, 0),
(22917, 32736, 14.49, 0, 1, 1, 0, 7, 164, 1),
(22917, 32744, 28.99, 0, 1, 1, 0, 7, 165, 1),
(22917, 32748, 14.49, 0, 1, 1, 0, 7, 165, 1),
(22917, 32746, 3.62, 0, 1, 1, 0, 7, 165, 1),
(22917, 32754, 50.72, 0, 1, 1, 0, 7, 197, 1),
(22917, 32752, 21.74, 0, 1, 1, 0, 7, 197, 1);

-- Lady Vashj Event Fight Gameobjects
UPDATE `gameobject_template` SET `type`=2 WHERE `entry` IN (185052, 185053, 185051, 185054);

DELETE FROM gameobject WHERE id IN (185052, 185053, 185051, 185054);
INSERT INTO `gameobject` (`id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
(185052, 548, 49.6262, -902.181, 43.0975, 3.95683, 0, 0, 0.918067, -0.396425, 25, 0, 0),
(185053, 548, 10.988, -901.616, 42.5371, 5.4373, 0, 0, 0.410443, -0.911886, 25, 0, 0),
(185051, 548, 10.3859, -944.036, 42.5446, 0.779888, 0, 0, 0.380137, 0.92493, 25, 0, 0),
(185054, 548, 49.3126, -943.398, 42.5501, 2.40174, 0, 0, 0.932353, 0.361548, 25, 0, 0);

INSERT INTO `creature` (id, map, position_x, position_y, position_z, orientation, spawntimesecs, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, instancemode) VALUES
(19870, 548, 49.6262, -902.181, 43.0975, 3.95683, 25, 49.6262, -902.181, 43.0975, 3.95683, 0),
(19870, 548, 10.988, -901.616, 42.5371, 5.4373, 25, 10.988, -901.616, 42.5371, 5.4373, 0),
(19870, 548, 10.3859, -944.036, 42.5446, 0.779888, 25, 10.3859, -944.036, 42.5446, 0.779888, 0),
(19870, 548, 49.3126, -943.398, 42.5501, 2.40174, 25, 49.3126, -943.398, 42.5501, 2.40174, 0);
UPDATE `gameobject_template` SET `ScriptName` = 'mob_shield_generator_channel' WHERE `entry` IN (185052, 185053, 185051, 185054);

-- Gruul The Dragon Killer
UPDATE `creature_template` SET `maxdmg` = '9000',
`attackpower` = '6500',
`maxrangedmg` = '9000',
`rangedattackpower` = '6500' WHERE `entry` = '19044';

-- Enchanted Elemental
UPDATE `creature_template` SET `mindmg` = '500',
`maxdmg` = '1000',
`minrangedmg` = '500',
`maxrangedmg` = '1000',
`type` = '4',
`flag1` = '0' WHERE `entry` = '21958';

-- Tree of Life
DELETE FROM `spell_affect` WHERE `entry` IN (5420) AND `effectId` IN (2);
INSERT INTO `spell_affect` VALUES (5420, 2, 0, 0x00, 0, 0, 0, 0x00001012100000D0, 0);

-- Cairne Bloodhoof
UPDATE `creature_template` SET `armor` = '10000',
`mindmg` = '4390',
`maxdmg` = '6800',
`minrangedmg` = '3200',
`maxrangedmg` = '5600',
`rangedattackpower` = '2800',
`spell1` = '38537',
`spell2` = '26211',
`spell3` = '25744',
`spell4` = '38846' WHERE `entry` = '3057';

-- Dupe Creature cleaning
DELETE FROM `creature` WHERE `id` in (SELECT entry
FROM `creature_template` WHERE `name` LIKE '%(1)%');

DELETE FROM `creature_template` WHERE `name` LIKE '%(1)%';

-- Db version

UPDATE `db_version` SET `version` = 'UWDB 0.50.8' WHERE CONVERT( `version` USING utf8 ) = 'UWDB 0.50.0';