UPDATE `creature_template` SET `VehicleId` = 486 WHERE `entry` = 35644;

UPDATE `creature_template` SET `InhabitType` = 7 WHERE `entry` = 35491;

UPDATE `vehicle_template_accessory` SET `summontype`='8' WHERE `entry`='35491' AND `seat_id`='0';

DELETE FROM `creature` WHERE `id`=35491;

DELETE FROM `spell_script_names` WHERE spell_id IN (66515, 66867, 67534, 67830, 66482);

INSERT INTO `spell_script_names` VALUES

(66867, 'spell_eadric_hammer_of_righteous'), -- Hammer can be picked by target if isn't under HoJ effect

(66515, 'spell_paletress_shield'), -- Reflect 25% of abosorbed damage

(67534, 'spell_toc5_hex_mending'), -- Hex of mending spell effect

(67830, 'spell_toc5_ride_mount'), -- Allow ride only if a Lance is equiped

(66482, 'spell_toc5_defend'); -- Add visual shields depending on stack size

DELETE FROM `spell_linked_spell` WHERE `spell_trigger` = 66905;

INSERT INTO `spell_linked_spell` VALUES

(66905, -66904, 0, 'Eadric Hammer of Righteous'); -- Remove the Hammer of Righteous spell after using it

DELETE FROM achievement_criteria_data WHERE criteria_id IN (11863, 11420, 12439, 11858);

DELETE FROM achievement_criteria_data WHERE criteria_id BETWEEN 12298 AND 12306;

DELETE FROM achievement_criteria_data WHERE criteria_id BETWEEN 12310 AND 12324;

DELETE FROM achievement_criteria_data WHERE criteria_id BETWEEN 11904 AND 11927;

INSERT INTO `achievement_criteria_data` VALUES

(11420, 18, 0, 0, ''),

(12298, 18, 0, 0, ''),

(12299, 18, 0, 0, ''),

(12300, 18, 0, 0, ''),

(12301, 18, 0, 0, ''),

(12302, 18, 0, 0, ''),

(12303, 18, 0, 0, ''),

(12304, 18, 0, 0, ''),

(12305, 18, 0, 0, ''),

(12306, 18, 0, 0, ''),

(12310, 18, 0, 0, ''),

(12311, 18, 0, 0, ''),

(12312, 18, 0, 0, ''),

(12313, 18, 0, 0, ''),

(12314, 18, 0, 0, ''),

(12318, 18, 0, 0, ''),

(12319, 18, 0, 0, ''),

(12320, 18, 0, 0, ''),

(12321, 18, 0, 0, ''),

(12322, 18, 0, 0, ''),

(11863, 18, 0, 0, ''),

(11904, 18, 0, 0, ''),

(11905, 18, 0, 0, ''),

(11906, 18, 0, 0, ''),

(11907, 18, 0, 0, ''),

(11908, 18, 0, 0, ''),

(11909, 18, 0, 0, ''),

(11910, 18, 0, 0, ''),

(11911, 18, 0, 0, ''),

(11912, 18, 0, 0, ''),

(11913, 18, 0, 0, ''),

(11914, 18, 0, 0, ''),

(11915, 18, 0, 0, ''),

(11916, 18, 0, 0, ''),

(11917, 18, 0, 0, ''),

(11918, 18, 0, 0, ''),

(11919, 18, 0, 0, ''),

(11920, 18, 0, 0, ''),

(11921, 18, 0, 0, ''),

(11922, 18, 0, 0, ''),

(11923, 18, 0, 0, ''),

(11924, 18, 0, 0, ''),

(11925, 18, 0, 0, ''),

(11926, 18, 0, 0, ''),

(11927, 18, 0, 0, ''),

(12310, 12, 1, 0, ''),

(12311, 12, 1, 0, ''),

(12312, 12, 1, 0, ''),

(12313, 12, 1, 0, ''),

(12314, 12, 1, 0, ''),

(12315, 12, 1, 0, ''),

(12316, 12, 1, 0, ''),

(12317, 12, 1, 0, ''),

(12318, 12, 1, 0, ''),

(12319, 12, 1, 0, ''),

(12320, 12, 1, 0, ''),

(12321, 12, 1, 0, ''),

(12322, 12, 1, 0, ''),

(12323, 12, 1, 0, ''),

(12324, 12, 1, 0, ''),

(12439, 12, 1, 0, ''),

(11858, 12, 1, 0, ''),

(11863, 12, 1, 0, ''),

(11904, 12, 1, 0, ''),

(11905, 12, 1, 0, ''),

(11906, 12, 1, 0, ''),

(11907, 12, 1, 0, ''),

(11908, 12, 1, 0, ''),

(11909, 12, 1, 0, ''),

(11910, 12, 1, 0, ''),

(11911, 12, 1, 0, ''),

(11912, 12, 1, 0, ''),

(11913, 12, 1, 0, ''),

(11914, 12, 1, 0, ''),

(11915, 12, 1, 0, ''),

(11916, 12, 1, 0, ''),

(11917, 12, 1, 0, ''),

(11918, 12, 1, 0, ''),

(11919, 12, 1, 0, ''),

(11920, 12, 1, 0, ''),

(11921, 12, 1, 0, ''),

(11922, 12, 1, 0, ''),

(11923, 12, 1, 0, ''),

(11924, 12, 1, 0, ''),

(11925, 12, 1, 0, ''),

(11926, 12, 1, 0, ''),

(11927, 12, 1, 0, '');

DELETE FROM `creature_template` WHERE `entry` IN (12000, 12001, 12002, 12003, 12004, 12005, 12006, 12007, 12008, 12009, 12010, 12011, 12444, 12436);

UPDATE `creature_template` SET `difficulty_entry_1` = 36089 WHERE `entry` = 35572;

UPDATE `creature_template` SET `difficulty_entry_1` = 36085 WHERE `entry` = 35569;

UPDATE `creature_template` SET `difficulty_entry_1` = 36090 WHERE `entry` = 35571;

UPDATE `creature_template` SET `difficulty_entry_1` = 36091 WHERE `entry` = 35570;

UPDATE `creature_template` SET `difficulty_entry_1` = 36084 WHERE `entry` = 35617;

UPDATE `creature_template` SET `difficulty_entry_1` = 36088 WHERE `entry` = 34705;

UPDATE `creature_template` SET `difficulty_entry_1` = 36082 WHERE `entry` = 34702;

UPDATE `creature_template` SET `difficulty_entry_1` = 36083 WHERE `entry` = 34701;

UPDATE `creature_template` SET `difficulty_entry_1` = 36086 WHERE `entry` = 34657;

UPDATE `creature_template` SET `difficulty_entry_1` = 36087 WHERE `entry` = 34703;

UPDATE `creature_template` SET `difficulty_entry_1` = 35518 WHERE `entry` = 35119;

UPDATE `creature_template` SET `difficulty_entry_1` = 35517 WHERE `entry` = 34928;

UPDATE `creature_template` SET `difficulty_entry_1` = 35717 WHERE `entry` = 35590;

UPDATE `creature_template` SET `modelid3` = 0 WHERE `entry` = 35309;

UPDATE `creature_template` SET `minlevel` = 80, `maxlevel` = 80, `mindmg` = 420, `maxdmg` = 630, `attackpower` = 158, `mechanic_immune_mask` = 650854267 WHERE `entry` = 35310;

UPDATE `creature_template` SET `modelid3` = 0 WHERE `entry` = 35305;

UPDATE `creature_template` SET `minlevel` = 80, `maxlevel` = 80, `mindmg` = 420, `maxdmg` = 650, `attackpower` = 158, `mechanic_immune_mask` = 650854267 WHERE `entry` = 35306;

UPDATE `creature_template` SET `modelid3` = 0 WHERE `entry` = 35307;

UPDATE `creature_template` SET `minlevel` = 80, `maxlevel` = 80, `mindmg` = 420, `maxdmg` = 630, `attackpower` = 158, `mechanic_immune_mask` = 650854267 WHERE `entry` = 35308;

UPDATE `creature_template` SET `mindmg` = 330, `maxdmg` = 495, `attackpower` = 124, `baseattacktime` = 2000, `mechanic_immune_mask` = 617297499 WHERE `name` LIKE 'Memory of%(1)';

UPDATE `creature_template` SET `mechanic_immune_mask` = 617299835 WHERE `entry` IN (34928,35517,35119,35518,35451,35490);

UPDATE `creature_template` SET `mindmg` = 420, `maxdmg` = 630, `attackpower` = 158 WHERE `entry` = 35717;

UPDATE `creature_template` SET `difficulty_entry_1` = 35546 WHERE `entry` = 35545;

UPDATE `creature_template` SET `difficulty_entry_1` = 35568 WHERE `entry` = 35564;

UPDATE `creature_template` SET `minlevel` = 80, `maxlevel` = 80, `mindmg` = 420, `maxdmg` = 630, `attackpower` = 158 WHERE `entry` IN (35568, 35546);

UPDATE `creature_template` SET `minlevel` = 80, `maxlevel` = 80, `baseattacktime` = 2000, `faction_A` = 14, `faction_H` = 14 WHERE `entry` IN (35564, 35568, 35545, 35546, 35717, 35590);

UPDATE creature_template SET ScriptName = 'npc_argent_monk' WHERE entry = 35305;

UPDATE creature_template SET ScriptName = 'npc_argent_lightwielder' WHERE entry = 35309;

UPDATE creature_template SET ScriptName = 'npc_argent_priest' WHERE entry = 35307;

UPDATE `creature_template` SET `mechanic_immune_mask` = '650854267' WHERE `entry` IN (35305, 35309, 35307, 12488, 12439, 12448);

UPDATE `creature_template` SET `Health_mod` = 29.4806 WHERE `entry`IN (35306, 35308, 35310);

UPDATE `creature_template` SET `Health_mod` = 51.8533 WHERE `entry` = 35490;

UPDATE `creature_template` SET `Health_mod` = 16.4286 WHERE `entry` = 35451;

DELETE FROM `creature_template_addon` WHERE `entry` IN (35305, 35306, 35307, 35308, 35309, 35310);

INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES

(35305, 0, 0, 0, 1, 27, '63501'),

(35306, 0, 0, 0, 1, 27, '63501'),

(35307, 0, 0, 0, 1, 375, '63501'),

(35308, 0, 0, 0, 1, 375, '63501'),

(35309, 0, 0, 0, 1, 375, '63501'),

(35310, 0, 0, 0, 1, 375, '63501');

DELETE FROM `creature_template_addon` WHERE (`entry` IN (35614, 35311));

INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES

(35614, 0, 0, 0, 0, 0, 67782), -- Desecration Stalker (Periodic Desecration)

(35311, 0, 0, 0, 0, 0, 67196); -- Fountain of Light (Periodic Light rain)

UPDATE `creature_template` SET `flags_extra` = 130 WHERE `entry` = 35614;

UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 35311;

DELETE FROM `smart_scripts` WHERE (`entryorguid`=35311 AND `source_type`=0);

INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES

(35311, 0, 0, 0, 25, 0, 100, 7, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Fountain of Light - Set passive');

UPDATE `creature_template` SET `equipment_id` = 22 WHERE `entry` IN (34942, 35531);

UPDATE `creature_template` SET `equipment_id` = 1431 WHERE `entry` IN (35028, 35541);

UPDATE `creature_template` SET `equipment_id` = 1178 WHERE `entry` IN (35030, 35530);

UPDATE `creature_template` SET `equipment_id` = 1330 WHERE `entry` IN (35031, 35536);

UPDATE `creature_template` SET `equipment_id` = 1808 WHERE `entry` IN (35036, 35543);

UPDATE `creature_template` SET `equipment_id` = 1496 WHERE `entry` IN (35037, 35535);

UPDATE `creature_template` SET `equipment_id` = 2216 WHERE `entry` IN (35042, 35533);

UPDATE `creature_template` SET `equipment_id` = 714 WHERE `entry` IN (35045, 35534);

UPDATE `creature_template` SET `equipment_id` = 271 WHERE `entry` IN (35049, 35529);

UPDATE `creature_template` SET `equipment_id` = 833 WHERE `entry` IN (35119, 35518);

UPDATE `creature_template` SET `equipment_id` = 1892 WHERE `entry` IN (35572, 36089);

UPDATE `creature_template` SET `equipment_id` = 1895 WHERE `entry` IN (35569, 36085);

UPDATE `creature_template` SET `equipment_id` = 1899 WHERE `entry` IN (35571, 36090);

UPDATE `creature_template` SET `equipment_id` = 1893 WHERE `entry` IN (35570, 36091);

UPDATE `creature_template` SET `equipment_id` = 1894 WHERE `entry` IN (35617, 36084);

UPDATE `creature_template` SET `equipment_id` = 1966 WHERE `entry` IN (34705, 36088);

UPDATE `creature_template` SET `equipment_id` = 1993 WHERE `entry` IN (36082, 34702);

UPDATE `creature_template` SET `equipment_id` = 1970 WHERE `entry` IN (36083, 34701);

UPDATE `creature_template` SET `equipment_id` = 1969 WHERE `entry` IN (36086, 34657);

UPDATE `creature_template` SET `equipment_id` = 1967 WHERE `entry` IN (34703, 36087);

UPDATE `creature_template` SET `spell1` = 68505, `spell2` = 62575, `spell3` = 68282, `spell4` = 66482 WHERE `entry` IN (35644, 36558);

UPDATE `creature_template` SET `type_flags` = 2048, `ScriptName` = 'generic_vehicleAI_toc5' WHERE `entry` IN (35328, 35329, 35331, 35332, 35330, 35314, 35325, 35327, 35323, 35326);

UPDATE `creature_template` SET `type_flags` = 2048,`mechanic_immune_mask` = 617299835 WHERE `entry` IN (35572, 35569, 35571, 35570, 35617, 34705, 34702, 34701, 34657, 34703);

UPDATE `creature_template_addon` SET `auras` = LEFT(`auras`, 11) WHERE `entry` IN (35572, 35569, 35571, 35570, 35617, 34705, 34702, 34701, 34657, 34703);

CREATE TABLE `entry_temp` (`id` INT);

INSERT INTO `entry_temp` SELECT `difficulty_entry_1` FROM `creature_template` WHERE `entry` IN (35572, 35569, 35571, 35570, 35617, 34705, 34702, 34701, 34657, 34703);

UPDATE `creature_template` SET `type_flags` = 2048, `mechanic_immune_mask` = 617299835 WHERE `entry` IN (SELECT id FROM`entry_temp`);

UPDATE `creature_template_addon` SET `auras` = LEFT(`auras`, 11) WHERE `entry` IN (SELECT id FROM`entry_temp`);

DROP TABLE `entry_temp`;

UPDATE `creature_template` SET `faction_A` = 84, `faction_H` = 84 WHERE `entry` = 35644;

UPDATE `creature_template` SET `faction_A` = 83, `faction_H` = 83 WHERE `entry` = 36558;

DELETE FROM `creature_template_addon` WHERE `entry` IN (35644, 36558);

UPDATE `creature_template` SET `unit_flags` = 64 WHERE `entry` IN (35451, 35490);

UPDATE `gameobject` SET `state` = 1 WHERE `guid` = 150081;

UPDATE `creature_template` SET `faction_A` = 35, `faction_H` = 35, `flags_extra` = 2, `ScriptName` = 'npc_black_knight_skeletal_gryphon' WHERE `entry` = 35491;

DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` = 35491;

INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`) VALUES

(35491,46598,0,0);

DELETE FROM `script_waypoint` WHERE `entry` = 35491;

INSERT INTO `script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES

(35491,1,781.513,657.99,466.821,0,''),

(35491,2,759.005,665.142,462.541,0,''),

(35491,3,732.937,657.164,452.678,0,''),

(35491,4,717.491,646.009,440.137,0,''),

(35491,5,707.57,628.978,431.129,0,''),

(35491,6,705.164,603.628,422.957,0,''),

(35491,7,716.351,588.49,420.802,0,''),

(35491,8,741.703,580.168,420.523,0,''),

(35491,9,761.634,586.383,422.206,0,''),

(35491,10,775.983,601.992,423.606,0,''),

(35491,11,769.051,624.686,420.035,0,''),

(35491,12,756.582,631.692,412.53,0,''),

(35491,13,744.841,634.505,411.575,2000,''),

(35491,14,759.005,665.142,462.541,0,''),

(35491,15,747.127,813.51,460.707,0,'');

SET @TIRION := 34996;

SET @THRALL := 34994;

SET @GARROSH := 34995;

SET @VARIAN := 34990;

SET @JAINA := 34992;

SET @EADRIC := 35119;

SET @PALETRESS := 34928;

SET @BLACK_KNIGHT := 35451;

SET @SCRIPT_TEXTS_ID := -1999900;

DELETE FROM `script_texts` WHERE `entry` <= @SCRIPT_TEXTS_ID AND `entry` >= @SCRIPT_TEXTS_ID-24;

INSERT INTO `script_texts` (`npc_entry`,`entry`,`content_default`,`sound`,`type`,`language`,`emote`,`comment`) VALUES

(0,@SCRIPT_TEXTS_ID-00, 'The public cheer for %s.',15882,2,0,1, 'ToC5 Cheers'),

(0,@SCRIPT_TEXTS_ID-01, 'The humans of Stormwind cheer for %s.',13838,2,0,1, 'ToC5 Cheers'),

(0,@SCRIPT_TEXTS_ID-02, 'The orcs of Orgrimmar cheer for %s.',13839,2,0,1, 'ToC5 Cheers'),

(0,@SCRIPT_TEXTS_ID-03, 'The dwarfs of Ironforge cheer for %s.',13838,2,0,1, 'ToC5 Cheers'),

(0,@SCRIPT_TEXTS_ID-05, 'The forsaken of Undercity cheer for %s.',13839,2,0,1, 'ToC5 Cheers'),

(0,@SCRIPT_TEXTS_ID-04, 'The night elves of Darnassus cheer for%s.',13838,2,0,1, 'ToC5 Cheers'),

(0,@SCRIPT_TEXTS_ID-06, 'The taurens of Thunder Bluff cheer for %s.',13839,2,0,1, 'ToC5 Cheers'),

(0,@SCRIPT_TEXTS_ID-07, 'The gnomes of Gnomeregan cheer for %s.',13838,2,0,1, 'ToC5 Cheers'),

(0,@SCRIPT_TEXTS_ID-08, 'The trols of Sen\'jin cheer for %s.',13839,2,0,1, 'ToC5 Cheers'),

(0,@SCRIPT_TEXTS_ID-10, 'The blood elves of Silvermoon cheer for %s.',13839,2,0,1, 'ToC5 Cheers'),

(0,@SCRIPT_TEXTS_ID-11, 'The draeneis of Exodar cheer for %s.',13838,2,0,1, 'ToC5 Cheers'),

(0,@SCRIPT_TEXTS_ID-12, 'ˇ%s begins to invoke the Waking Nightmare!',0,3,0,0, 'Paletress - Memory warning.'),

(0,@SCRIPT_TEXTS_ID-13, '%s targets $N with the Hammer of Righteous!',0,3,0,0, 'Eadric - Combat - Warning - Hammer'),

(0,@SCRIPT_TEXTS_ID-20, '$N has risen to the ranks of champion in our tournament. We are proud to present him today.',0,1,0,1, 'ToC5 Player presentation'),

(0,@SCRIPT_TEXTS_ID-21, 'We offer a mighty capable $c, an honorable $r. We present $N.',13838,1,0,1, 'ToC5 Player presentation'),

(0,@SCRIPT_TEXTS_ID-22, 'If you do not yet know his name, we are certain you will after these battles. We present, $N.',13838,1,0,1, 'ToC5 Player presentation'),

(0,@SCRIPT_TEXTS_ID-23, 'Champions on the tournament ground speak highly of this $c Today we present $N.',13838,1,0,1, 'ToC5 Player presentation'),

(0,@SCRIPT_TEXTS_ID-24, 'If you still do not know his name, we are sure you will do after this fight. Introducing $N.',13838,1,0,1, 'ToC5 Player presentation');

DELETE FROM creature_text WHERE entry IN (35004, 35005, @TIRION, @THRALL, @GARROSH , @VARIAN , @JAINA, @EADRIC, @PALETRESS, @BLACK_KNIGHT);

INSERT INTO creature_text (entry, groupid, id, TEXT, TYPE, LANGUAGE, probability, emote, duration, sound, COMMENT) VALUES

/*.*/ (35004,0,0,'The Sunreavers are proud to present to their representatives in these tests of combat.',14,0,100,1,0,0,'Announcer - Player Horde Champions - Intro'),

/*.*/ (35005,0,0,'Silver Covenant is delighted to present their fighters for this event, High Lord.',14,0,100,1,0,0,'Announcer - Player Alliance Champions - Intro'),

/*.*/ (@TIRION,0,0,'Welcome champions. Today, in the eyes of your fellow leaders and fighters will you prove as worthy.',14,0,100,1,0,0,'Tirion - Intro'),

/*....*/ (@THRALL,0,0,'Fight well, Horde! Lok\'tar Ogar!',14,0,100,1,0,0,'Thrall - Intro'),

/*....*/ (@GARROSH,0,0,'Finally, a fight worth watching.',12,0,100,1,0,0,'Garrosh - Intro'),

/*....*/ (@VARIAN,0,0,'I did not come here to watch animals tear at each other senselessly, Tirion',12,0,100,1,0,0,'Varian - Intro'),

/*....*/ (@JAINA,0,0,'They are worthy fighters, I see.',12,0,100,1,0,0,'Jaina - Intro'),

/*....*/ (@VARIAN,1,0,'Do not see the grace to these games , Tirion . Still ... I hope that it will make an admirable way .',12,0,100,1,0,0,'Thrall - Intro'),

/*....*/ (@JAINA,1,0,'Of course they will.',12,0,100,1,0,0,'Garrosh - Intro'),

/*....*/ (@GARROSH,1,0,'Admirable? Ha! I will enjoy watching your little champions fail, man.',14,0,100,1,0,0,'Varian - Intro'),

/*....*/ (@THRALL,1,0,'Garrosh is enough.',12,0,100,1,0,0,'Jaina - Intro'),

/*.*/ (@TIRION,1,0,'You will first be facing three of the Grand Champions of the Tournament! These fierce contenders have beaten out all others to reach the pinnacle of skill in the just.',14,0,100,1,0,0,'Tirion - Intro'),

/*....*/ (35004,1,0,'Here comes the small but deadly Ambrose Boltspark, Grand Champion of Gnomeregan.',14,0,100,1,0,0,'Announcer - Alliance Champions - Intro Mage'),

/*....*/ (35004,2,0,'Colosos, the huge Grand Champion of the Exodar, is out the door.',14,0,100,1,0,0,'Announcer - Alliance Champions - Intro Shaman'),

/*....*/ (35004,3,0,'Entering the arena is the Grand Champion of Darnassus, the skilled sentinel Jaelyne Evensong.',14,0,100,1,0,0,'Announcer - Alliance Champions - Intro Hunter'),

/*....*/ (35004,4,0,'Proud and strong, give a cheer for Marshal Jacob Alerius, the Grand Champion of Stormwind!',14,0,100,1,0,0,'Announcer - Alliance Champions - Intro Warrior'),

/*....*/ (35004,5,0,'Today the power of the dwarfs is represented by the Grand Champion of Ironforge, Lana Stouthammer.',14,0,100,1,0,0,'Announcer - Alliance Champions - Intro Rouge'),

/*....*/ (35005,1,0,'Coming out of the gate is Eressea Dawnsinger, skilled mage and Grand Champion of Silvermoon!',14,0,100,1,0,0,'Announcer - Horde Champions - Intro Mage'),

/*....*/ (35005,2,0,'Tall in the saddle of his kodo, here is the venerable Runok Wildmane, Grand Champion of Thunder Bluff!',14,0,100,1,0,0,'Announcer - Horde Champions - Intro Shaman'),

/*....*/ (35005,3,0,'Entering the dry sand but dangerous Zul\'tore, Grand Champion of Sen\'jin!',14,0,100,1,0,0,'Announcer - Horde Champions - Intro Hunter'),

/*....*/ (35005,4,0,'We presented the Grand Champion of Orgrimmar, the Mokra the Skullcrusher! ',14,0,100,1,0,0,'Announcer - Horde Champions - Intro Warrior'),

/*....*/ (35005,5,0,'Representing the tenacity of the Forsaken, here is the Grand Champion of the Undercity, Deathstalker Visceri!',14,0,100,1,0,0,'Announcer - Horde Champions - Intro Rouge'),

/*.*/ (@TIRION,2,0,'Well fought! Your next challange comes from the Crusader\'s own ranks. You will be tested against their considerable prowess.',14,0,100,1,0,0,'Tirion - Intro'),

/*....*/ (35004,11,0,'Entering the arena, a paladin who is no stranger to the battlefield or tournament ground, the Grand Champion of the Argent Crusade. Eadric the Pure!',14,0,100,1,0,0,'Announcer - Eadric - Intro'),

/*....*/ (35005,11,0,'Entering the arena, a paladin who is no stranger to the battlefield or tournament ground, the Grand Champion of the Argent Crusade. Eadric the Pure!',14,0,100,1,0,0,'Announcer - Eadric - Intro'),

/*....*/ (@EADRIC,10,0,'Are you up to the challenge? I will not hold back.',12,0,100,1,0,16134,'Eadric - Intro'),

/*....*/ (35004,12,0,'The next combatant is second to none is her passion for upholding the Light. I give you Argent Confessor Paletress!',14,0,100,1,0,0,'Announcer - Paletress - Intro'),

/*....*/ (35005,12,0,'The next combatant is second to none is her passion for upholding the Light. I give you Argent Confessor Paletress!',14,0,100,1,0,0,'Announcer - Paletress - Intro'),

/*....*/ (@PALETRESS,10,0,'Thank you, good herald. Your words are too kind.',12,0,100,1,0,16245,'Paletress - Intro'),

/*....*/ (@PALETRESS,11,0,'May the Light give me strength to provide a worthy challenge.',12,0,100,1,0,16246,'Paletress - Intro'),

/*.*/ (@TIRION,3,0,'You may begin!',14,0,100,1,0,0,'Tirion - Intro'),

/*.*/ (@TIRION,4,0,'Well done. You have proven yourself today...',14,0,100,1,0,0,'Tirion - Intro'),

/*.*/ (35004,13,0,'What\'s that. up near the rafters?',12,0,100,1,0,0,'Announcer - Black Knight - Intro'),

/*.*/ (35005,13,0,'What\'s that. up near the rafters?',12,0,100,1,0,0,'Announcer - Black Knight - Intro'),

/*.*/ (@BLACK_KNIGHT,10,0,'You spoiled my grand entrance. Rat.',12,0,100,1,0,16256,'Black Knight - Intro'),

/*.*/ (@TIRION,5,0,'What is the meaning of this?',14,0,100,1,0,0,'Tirion - Intro'),

/*.*/ (@BLACK_KNIGHT,11,0,'Did you honestly think an agent if the Kich King would be bested on the field of your pathetic little tournament?',12,0,100,1,0,16257,'Black Knight - Intro'),

/*.*/ (@BLACK_KNIGHT,12,0,'I have come to finish my task',12,0,100,1,0,16258,'Black Knight - Intro'),

/*.*/ (@GARROSH,10,0,'Tear him apart!',14,0,100,1,0,0,'Garrosh - Black Knight - Intro'),

/*.*/ (@VARIAN,10,0,'Not just stand there. Kill him!',14,0,100,1,0,0,'Varian - Black Knight - Intro'),

(@EADRIC,1,0,'Prepare yourselves!',14,0,100,0,0,16135,'Eadric - Combat - Aggro'),

(@EADRIC,2,0,'Hammer of the Righteous!',14,0,100,0,0,16136,'Eadric - Combat - Hammer'),

(@EADRIC,3,0,'You... You need more practice!',14,0,100,0,0,16137,'Eadric - Combat - Slay 1'),

(@EADRIC,3,1,'Nay! Nay! And I say yet again nay! Not good enough!',14,0,100,0,0,16138,'Eadric - Combat - Slay 2'),

(@EADRIC,4,0,'I yield! I submit. Excellent work. May I run away now?',14,0,100,0,0,16139,'Eadric - Combat - Death'),

(@EADRIC,5,0,'%s begins to radiate light. Shield your eyes!',41,0,100,0,0,0,'Eadric - Combat - Warning - Radiance'),

(@PALETRESS,1,0,'Well then, let us begin.',14,0,100,0,0,16247,'Paletress - Combat - Aggro'),

(@PALETRESS,2,0,'Take this time to consider your past deeds.',14,0,100,0,0,16248,'Paletress - Combat - Summon Memory'),

(@PALETRESS,3,0,'Take your rest.',14,0,100,0,0,16250,'Paletress - Combat - Slay 1'),

(@PALETRESS,3,1,'Be at ease.',14,0,100,0,0,16251,'Paletress - Combat - Slay 2'),

(@PALETRESS,4,0,'Excellent work!',14,0,100,0,0,16252,'Paletress - Combat - Death'),

(@PALETRESS,5,0,'Even the darkest memory fades when confronted.',14,0,100,0,0,16249,'Paletress - Combat - Memory dies'),

(@BLACK_KNIGHT,1,0,'This farce ends here!',14,0,100,0,0,16259,'Black Knight - Combat - Aggro'),

(@BLACK_KNIGHT,2,0,'Pathetic.',14,0,100,0,0,16260,'Black Knight - Combat - Slay 1'),

(@BLACK_KNIGHT,2,1,'A waste of flesh!',14,0,100,0,0,16261,'Black Knight - Combat - Slay 2'),

(@BLACK_KNIGHT,3,0,'My roting flash was just getting in the way!',14,0,100,0,0,16262,'Black Knight - Combat - Skeleton Res'),

(@BLACK_KNIGHT,4,0,'I have no need for bones to best you!',14,0,100,0,0,16263,'Black Knight - Combat - Ghost Res'),

(@BLACK_KNIGHT,5,0,'No! I must not fail...again...',14,0,100,0,0,16264,'Black Knight - Combat - Death');

DELETE FROM `vehicle_template_accessory` WHERE `entry` = 35491;

INSERT INTO `vehicle_template_accessory` (`entry`, `accessory_entry`, `seat_id`, `minion`, `description`, `summontype`, `summontimer`) VALUES

(35491,35451,0,0,'Trial of the Champion - Black Knight on his gryphon',6,30000);

SET @SPAWN_GUID := 1000500;

DELETE FROM `creature` WHERE `map` = 650;

INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES

(@SPAWN_GUID+000,36558,650,1,1,0,0,726.826,661.201,412.472,4.66003,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+001,36558,650,1,1,0,0,716.665,573.495,412.475,0.977384,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+002,36558,650,1,1,0,0,705.497,583.944,412.476,0.698132,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+003,36558,650,1,1,0,0,770.486,571.552,412.475,2.05949,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+004,36558,650,1,1,0,0,717.443,660.646,412.467,4.92183,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+005,36558,650,1,1,0,0,700.531,591.927,412.475,0.523599,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+006,36558,650,1,1,0,0,790.177,589.059,412.475,2.56563,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+007,36558,650,1,1,0,0,702.165,647.267,412.475,5.68977,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+008,36558,650,1,1,0,0,773.097,660.733,412.467,4.45059,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+009,36558,650,1,1,0,0,793.052,642.851,412.474,3.63029,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+010,36558,650,1,1,0,0,778.741,576.049,412.476,2.23402,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+011,35004,650,0,1,0,0,746.675,619.318,411.091,4.79268,300,0,0,10635,0,0,0,0,0),

(@SPAWN_GUID+012,36558,650,1,1,0,0,788.016,650.788,412.475,3.80482,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+013,35644,650,1,1,0,0,704.943,651.33,412.475,5.60251,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+014,35644,650,1,1,0,0,774.898,573.736,412.475,2.14675,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+015,35644,650,1,1,0,0,699.943,643.37,412.474,5.77704,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+016,34871,650,0,1,0,0,795.968,651.859,435.421,3.6569,300,0,0,42,0,0,0,0,0),

(@SPAWN_GUID+017,35644,650,1,1,0,0,793.009,592.667,412.475,2.6529,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+018,35644,650,1,1,0,0,702.967,587.649,412.475,0.610865,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+019,35644,650,1,1,0,0,768.255,661.606,412.47,4.55531,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+020,35644,650,1,1,0,0,720.569,571.285,412.475,1.06465,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+021,35644,650,1,1,0,0,787.439,584.969,412.476,2.47837,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+022,35644,650,1,1,0,0,722.363,660.745,412.468,4.83456,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+023,35644,650,1,1,0,0,790.49,646.533,412.474,3.71755,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+024,35644,650,1,1,0,0,777.564,660.3,412.467,4.34587,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+025,34990,650,0,1,0,0,807.814,618.058,435.395,3.0884,300,0,0,8367000,0,0,0,0,0),

(@SPAWN_GUID+026,35016,650,1,1,0,0,702.274,638.76,412.47,0,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+027,35016,650,1,1,0,0,697.285,618.253,412.476,0,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+028,35016,650,1,1,0,0,714.486,581.722,412.476,0,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+029,35016,650,1,1,0,0,703.884,596.601,412.474,0,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+030,35016,650,1,1,0,0,712.413,653.931,412.474,0,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+031,34977,650,1,1,0,0,733.809,545.215,442.075,1.41372,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+032,34977,650,1,1,0,0,730.998,552.719,438.812,1.3439,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+033,34977,650,1,1,0,0,734.411,560.158,435.501,1.37881,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+034,34977,650,1,1,0,0,726.38,557.151,436.978,1.25664,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+035,34979,650,1,1,0,0,709.576,570.106,435.504,0.942478,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+036,34979,650,1,1,0,0,712.873,563.172,436.967,1.02974,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+037,34979,650,1,1,0,0,714.34,553.708,440.223,1.11701,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+038,34979,650,1,1,0,0,700.273,559.224,442.08,0.925025,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+039,34966,650,1,1,0,0,718.917,564.078,435.504,1.11701,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+040,34966,650,1,1,0,0,721.971,548.191,442.072,1.23918,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+041,34966,650,1,1,0,0,718.405,555.92,438.803,1.15192,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+042,34966,650,1,1,0,0,725.661,560.835,435.503,1.23918,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+043,34858,650,1,1,0,0,697.241,583.858,435.504,0.628319,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+044,34858,650,1,1,0,0,689.635,582.823,438.819,0.558505,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+045,34858,650,1,1,0,0,696.26,577.507,436.966,0.698132,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+046,34858,650,1,1,0,0,682.856,586.2,440.243,0.471239,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+047,34858,650,1,1,0,0,688.012,573.852,442.074,0.663225,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+048,34860,650,1,1,0,0,699.005,654.894,435.504,5.53269,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+049,34860,650,1,1,0,0,693.635,654.892,436.963,5.60251,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+050,34860,650,1,1,0,0,690.486,661.661,440.209,5.55015,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+051,34860,650,1,1,0,0,684.069,656.681,442.074,5.68977,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+052,34860,650,1,1,0,0,686.866,650.837,438.779,5.75959,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+053,34861,650,1,1,0,0,677.17,640.74,442.069,6.00393,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+054,34861,650,1,1,0,0,689.436,639.259,435.503,5.95157,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+055,34861,650,1,1,0,0,679.981,648.878,440.198,5.86431,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+056,34861,650,1,1,0,0,686.392,643.351,436.973,5.88176,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+057,34861,650,1,1,0,0,692.406,644.87,435.504,5.8294,86400,0,0,1,0,0,0,0,0),

(@SPAWN_GUID+058,34970,650,1,1,0,0,767.512,546.841,441.991,1.66197,86400,0,0,1,0,0,0,0,0),