aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAokromes <Aokromes@users.noreply.github.com>2015-05-09 14:03:20 +0200
committerAokromes <Aokromes@users.noreply.github.com>2015-05-09 14:03:20 +0200
commitd84f7c5ebd173f7d99bc21b564e356110a3e07be (patch)
tree3c761bfe02b0ae91b36a9abca2bb2cbd9a5b27cf
parentfe70377b1bcf73f4e35cb4c26e0e106e91313fbd (diff)
DB/Misc: The Grand Melee
By Killyana, closes #14603
-rw-r--r--sql/updates/world/2015_05_09_05_world.sql835
1 files changed, 835 insertions, 0 deletions
diff --git a/sql/updates/world/2015_05_09_05_world.sql b/sql/updates/world/2015_05_09_05_world.sql
new file mode 100644
index 00000000000..41576ac375c
--- /dev/null
+++ b/sql/updates/world/2015_05_09_05_world.sql
@@ -0,0 +1,835 @@
+-- Add SAI support for Lance a Lot achievement ID: 2836
+-- Champions SAI mechanic
+SET @Sen_Valiant := 33285;
+SET @Script := 3328500;
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@Sen_Valiant;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@Sen_Valiant;
+DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid`=@Script;
+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
+(@Sen_Valiant,0,0,0,25,0,100,0,0,0,0,0,28,64223,0,0,0,0,0,1,0,0,0,0,0,0,0,'Sen Valiant - On Reset - Remove auras from Defend'),
+(@Sen_Valiant,0,1,2,62,0,100,0,10469,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'Sen Valiant - On gossip select - Close gossip'),
+(@Sen_Valiant,0,2,3,61,0,100,0,0,0,0,0,64,1,0,0,0,0,0,7,0,0,0,0,0,0,0,'Sen Valiant - Linked with previous event - store target'),
+(@Sen_Valiant,0,3,0,61,0,100,0,0,0,0,0,80,@Script,2,0,0,0,0,1,0,0,0,0,0,0,0,'Sen Valiant - Linked with previous event - Call timed actionlist'),
+(@Sen_Valiant,0,4,0,52,0,100,0,0,@Sen_Valiant,0,0,11,63010,0,0,0,0,0,7,0,0,0,0,0,0,0,'Sen Valiant - On text over - Cast Charge'),
+(@Sen_Valiant,0,5,0,0,0,100,0,0,0,1500,4000,11,62544,0,0,0,0,0,2,0,0,0,0,0,0,0,'Sen Valiant - IC - Cast Thrust'),
+(@Sen_Valiant,0,6,0,9,0,100,0,5,5,4000,7000,11,62575,0,0,0,0,0,2,0,0,0,0,0,0,0,'Sen Valiant - On more than 5 yard range - Cast Shield-Breaker'),
+(@Sen_Valiant,0,7,0,0,0,100,0,9000,11000,9000,10000,46,12,0,0,0,0,0,1,0,0,0,0,0,0,0,'Sen Valiant - IC - Move forward 12 yards'),
+(@Sen_Valiant,0,8,9,9,0,100,0,9,15,3000,3000,11,63010,0,0,0,0,0,2,0,0,0,0,0,0,0,'Sen Valiant - On 10-12 yard range - Cast Charge'),
+(@Sen_Valiant,0,9,0,61,0,100,0,0,0,0,0,11,62575,0,0,0,0,0,2,0,0,0,0,0,0,0,'Sen Valiant - Linked with previous event - Cast Shield-Breaker'),
+(@Sen_Valiant,0,10,11,2,0,100,1,1,3,60000,60000,2,35,0,0,0,0,0,1,0,0,0,0,0,0,0,'Sen Valiant - On HP% between 1% and 3% - Change faction to 35'),
+(@Sen_Valiant,0,11,12,61,0,100,0,0,0,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,'Sen Valiant - Linked with previous event - Say text'),
+(@Sen_Valiant,0,12,13,61,0,100,0,0,0,0,0,85,62724,0,0,0,0,0,12,1,0,0,0,0,0,0,'Sen Valiant - Linked with previous event - Cast Mounted Melee Victory /item/'),
+(@Sen_Valiant,0,13,14,61,0,100,0,0,0,0,0,85,64812,0,0,0,0,0,12,1,0,0,0,0,0,0,'Sen Valiant - Linked with previous event - Cast credit'),
+(@Sen_Valiant,0,14,0,61,0,100,0,0,0,0,0,24,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Sen Valiant - Linked with previous event - Evade'),
+(@Sen_Valiant,0,15,16,5,0,100,0,60000,60000,1,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Sen Valiant - On player killed - Say text'),
+(@Sen_Valiant,0,16,17,61,0,100,0,0,0,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Sen Valiant - Linked with previous event - Set unseen'),
+(@Sen_Valiant,0,17,0,61,0,100,0,0,0,0,0,41,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Sen Valiant - Linked with previous event - Despawn in 1 ms'),
+-- Timed actionlist 1
+(@Script,9,1,0,0,0,100,0,0,0,0,0,42,0,1,0,0,0,0,1,0,0,0,0,0,0,0,'All champions - Script 1 - Set INVINCIBILITY'),
+(@Script,9,2,0,0,0,100,0,0,0,0,0,59,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'All champions - Script 1 - Set run ON'),
+(@Script,9,3,0,0,0,100,0,0,0,0,0,11,62719,0,0,0,0,0,1,0,0,0,0,0,0,0,'All champions - Script 1 - Cast Defend on self/Layer 1/'),
+(@Script,9,4,0,0,0,100,0,0,0,0,0,11,62719,0,0,0,0,0,1,0,0,0,0,0,0,0,'All champions - Script 1 - Cast Defend on self/Layer 2/'),
+(@Script,9,5,0,0,0,100,0,0,0,0,0,11,62719,0,0,0,0,0,1,0,0,0,0,0,0,0,'All champions - Script 1 - Cast Defend on self/Layer 3/'),
+(@Script,9,6,0,0,0,100,0,0,0,0,0,46,20,0,0,0,0,0,1,0,0,0,0,0,0,0,'All champions - Script 1 - Move forward 15 yards'),
+(@Script,9,7,0,0,0,100,0,0,0,0,0,59,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'All champions - Script 1 - Set run Off'),
+(@Script,9,8,0,0,0,100,0,0,0,0,0,11,64223,0,0,0,0,0,1,0,0,0,0,0,0,0,'All champions - Script 1 - Cast aura TriggerS for Defend /10 sec one/'),
+(@Script,9,9,0,0,0,100,0,3500,3500,0,0,2,14,0,0,0,0,0,1,0,0,0,0,0,0,0,'All champions - Script 1 - Change faction to 14'),
+(@Script,9,10,0,0,0,100,0,0,0,0,0,1,0,1500,0,0,0,0,2,0,0,0,0,0,0,0,'All champions - Script 1 - Say text');
+-- Argent Valiants texts
+DELETE FROM `creature_text` WHERE `entry`= @Sen_Valiant;
+INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`, `BroadcastTextId`) VALUES
+(@Sen_Valiant,0,0,'Ready yourself!',12,1,100,0,0,0,'Argent Valiant', 33757),
+(@Sen_Valiant,0,1,'Prepare yourself!',12,1,100,0,0,0,'Argent Valiant', 33755),
+(@Sen_Valiant,0,2,'On your guard!',12,1,100,0,0,0,'Argent Valiant', 33756),
+(@Sen_Valiant,0,3,'Let it begin!',12,1,100,0,0,0,'Argent Valiant', 33758),
+(@Sen_Valiant,1,0,'Victory is mine!',12,1,100,0,0,0,'Argent Valiant', 33777),
+(@Sen_Valiant,1,1,'It seems you still need more practice. Perhaps another time.',12,1,100,0,0,0,'Argent Valiant', 33764),
+(@Sen_Valiant,1,2,'I have won. Better luck another time, friend.',12,1,100,0,0,0,'Argent Valiant', 33779),
+(@Sen_Valiant,1,3,'I am afraid you will need more practice to defeat me.',12,1,100,0,0,0,'Argent Valiant', 33778),
+(@Sen_Valiant,2,0,'I yield to you.',12,1,100,0,0,0,'Argent Valiant', 33774),
+(@Sen_Valiant,2,1,'That was a well fought battle. I yield to you.',12,1,100,0,0,0,'Argent Valiant', 33776),
+(@Sen_Valiant,2,2,'It would seem I underestimated your skills. Well done.',12,1,100,0,0,0,'Argent Valiant', 33775),
+(@Sen_Valiant,2,3,'I have been defeated. Good fight!',12,1,100,0,0,0,'Argent Valiant', 33760);
+-- Add condition for gossip option to show only, if player has quest: The Grand Melee is on tournament mount and have the spear equiped
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup` IN (10469, 10468, 10470, 10472, 10473, 10466, 10464, 10471, 10465, 10467);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ConditionTarget`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`,`NegativeCondition`) VALUES
+(15,10469,0,0,1,9,13772,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10469,0,0,1,1,64812,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10469,0,0,1,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10469,0,0,1,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10469,0,0,2,9,13777,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10469,0,0,2,1,64812,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10469,0,0,2,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10469,0,0,2,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10469,0,0,3,9,13782,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10469,0,0,3,1,64812,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10469,0,0,3,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10469,0,0,3,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10469,0,0,4,9,13787,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10469,0,0,4,1,64812,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10469,0,0,4,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10469,0,0,4,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10469,0,0,5,9,13767,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10469,0,0,5,1,64812,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10469,0,0,5,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10469,0,0,5,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10469,0,0,6,9,13761,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10469,0,0,6,1,64812,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10469,0,0,6,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10469,0,0,6,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10469,0,0,7,9,13745,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10469,0,0,7,1,64812,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10469,0,0,7,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10469,0,0,7,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10469,0,0,8,9,13750,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10469,0,0,8,1,64812,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10469,0,0,8,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10469,0,0,8,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10469,0,0,9,9,13756,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10469,0,0,9,1,64812,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10469,0,0,9,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10469,0,0,9,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10469,0,0,10,9,13665,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10469,0,0,10,1,64812,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10469,0,0,10,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10469,0,0,10,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10468,0,0,1,9,13772,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10468,0,0,1,1,64811,0,0,0,'','Show gossip menu only if don''t have the auran',1),
+(15,10468,0,0,1,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10468,0,0,1,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10468,0,0,2,9,13777,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10468,0,0,2,1,64811,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10468,0,0,2,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10468,0,0,2,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10468,0,0,3,9,13782,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10468,0,0,3,1,64811,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10468,0,0,3,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10468,0,0,3,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10468,0,0,4,9,13787,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10468,0,0,4,1,64811,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10468,0,0,4,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10468,0,0,4,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10468,0,0,5,9,13767,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10468,0,0,5,1,64811,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10468,0,0,5,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10468,0,0,5,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10468,0,0,6,9,13761,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10468,0,0,6,1,64811,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10468,0,0,6,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10468,0,0,6,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10468,0,0,7,9,13745,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10468,0,0,7,1,64811,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10468,0,0,7,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10468,0,0,7,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10468,0,0,8,9,13750,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10468,0,0,8,1,64811,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10468,0,0,8,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10468,0,0,8,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10468,0,0,9,9,13756,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10468,0,0,9,1,64811,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10468,0,0,9,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10468,0,0,9,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10468,0,0,10,9,13665,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10468,0,0,10,1,64811,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10468,0,0,10,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10468,0,0,10,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10470,0,0,1,9,13772,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10470,0,0,1,1,64813,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10470,0,0,1,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10470,0,0,1,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10470,0,0,2,9,13777,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10470,0,0,2,1,64813,0,0,0,'','Show gossip menu only if don''t have the auran',1),
+(15,10470,0,0,2,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10470,0,0,2,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10470,0,0,3,1,64813,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10470,0,0,3,9,13782,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10470,0,0,3,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10470,0,0,3,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10470,0,0,4,1,64813,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10470,0,0,4,9,13787,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10470,0,0,4,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10470,0,0,4,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10470,0,0,5,1,64813,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10470,0,0,5,9,13767,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10470,0,0,5,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10470,0,0,5,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10470,0,0,6,1,64813,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10470,0,0,6,9,13761,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10470,0,0,6,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10470,0,0,6,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10470,0,0,7,1,64813,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10470,0,0,7,9,13745,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10470,0,0,7,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10470,0,0,7,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10470,0,0,8,1,64813,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10470,0,0,8,9,13750,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10470,0,0,8,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10470,0,0,8,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10470,0,0,9,1,64813,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10470,0,0,9,9,13756,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10470,0,0,9,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10470,0,0,9,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10470,0,0,10,1,64813,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10470,0,0,10,9,13665,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10470,0,0,10,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10470,0,0,10,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10472,0,0,1,9,13772,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10472,0,0,1,1,64815,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10472,0,0,1,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10472,0,0,1,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10472,0,0,2,9,13777,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10472,0,0,2,1,64815,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10472,0,0,2,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10472,0,0,2,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10472,0,0,3,9,13782,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10472,0,0,3,1,64815,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10472,0,0,3,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10472,0,0,3,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10472,0,0,4,9,13787,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10472,0,0,4,1,64815,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10472,0,0,4,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10472,0,0,4,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10472,0,0,5,9,13767,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10472,0,0,5,1,64815,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10472,0,0,5,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10472,0,0,5,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10472,0,0,6,9,13761,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10472,0,0,6,1,64815,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10472,0,0,6,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10472,0,0,6,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10472,0,0,7,9,13745,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10472,0,0,7,1,64815,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10472,0,0,7,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10472,0,0,7,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10472,0,0,8,9,13750,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10472,0,0,8,1,64815,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10472,0,0,8,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10472,0,0,8,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10472,0,0,9,9,13756,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10472,0,0,9,1,64815,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10472,0,0,9,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10472,0,0,9,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10472,0,0,10,9,13665,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10472,0,0,10,1,64815,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10472,0,0,10,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10472,0,0,10,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10473,0,0,1,9,13772,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10473,0,0,1,1,64816,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10473,0,0,1,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10473,0,0,1,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10473,0,0,2,9,13777,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10473,0,0,2,1,64816,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10473,0,0,2,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10473,0,0,2,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10473,0,0,3,9,13782,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10473,0,0,3,1,64816,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10473,0,0,3,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10473,0,0,3,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10473,0,0,4,9,13787,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10473,0,0,4,1,64816,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10473,0,0,4,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10473,0,0,4,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10473,0,0,5,9,13767,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10473,0,0,5,1,64816,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10473,0,0,5,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10473,0,0,5,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10473,0,0,6,9,13761,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10473,0,0,6,1,64816,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10473,0,0,6,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10473,0,0,6,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10473,0,0,7,9,13745,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10473,0,0,7,1,64816,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10473,0,0,7,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10473,0,0,7,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10473,0,0,8,9,13750,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10473,0,0,8,1,64816,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10473,0,0,8,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10473,0,0,8,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10473,0,0,9,9,13756,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10473,0,0,9,1,64816,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10473,0,0,9,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10473,0,0,9,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10473,0,0,10,9,13665,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10473,0,0,10,1,64816,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10473,0,0,10,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10473,0,0,10,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10466,0,0,1,9,13772,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10466,0,0,1,1,64809,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10466,0,0,1,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10466,0,0,1,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10466,0,0,2,9,13777,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10466,0,0,2,1,64809,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10466,0,0,2,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10466,0,0,2,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10466,0,0,3,9,13782,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10466,0,0,3,1,64809,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10466,0,0,3,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10466,0,0,3,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10466,0,0,4,9,13787,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10466,0,0,4,1,64809,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10466,0,0,4,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10466,0,0,4,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10466,0,0,5,9,13767,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10466,0,0,5,1,64809,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10466,0,0,5,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10466,0,0,5,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10466,0,0,6,9,13761,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10466,0,0,6,1,64809,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10466,0,0,6,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10466,0,0,6,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10466,0,0,7,9,13745,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10466,0,0,7,1,64809,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10466,0,0,7,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10466,0,0,7,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10466,0,0,8,9,13750,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10466,0,0,8,1,64809,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10466,0,0,8,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10466,0,0,8,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10466,0,0,9,9,13756,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10466,0,0,9,1,64809,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10466,0,0,9,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10466,0,0,9,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10466,0,0,10,9,13665,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10466,0,0,10,1,64809,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10466,0,0,10,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10466,0,0,10,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10464,0,0,1,9,13772,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10464,0,0,1,1,64805,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10464,0,0,1,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10464,0,0,1,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10464,0,0,2,9,13777,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10464,0,0,2,1,64805,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10464,0,0,2,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10464,0,0,2,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10464,0,0,3,9,13782,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10464,0,0,3,1,64805,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10464,0,0,3,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10464,0,0,3,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10464,0,0,4,9,13787,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10464,0,0,4,1,64805,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10464,0,0,4,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10464,0,0,4,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10464,0,0,5,9,13767,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10464,0,0,5,1,64805,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10464,0,0,5,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10464,0,0,5,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10464,0,0,6,9,13761,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10464,0,0,6,1,64805,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10464,0,0,6,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10464,0,0,6,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10464,0,0,7,9,13745,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10464,0,0,7,1,64805,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10464,0,0,7,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10464,0,0,7,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10464,0,0,8,9,13750,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10464,0,0,8,1,64805,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10464,0,0,8,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10464,0,0,8,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10464,0,0,9,9,13756,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10464,0,0,9,1,64805,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10464,0,0,9,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10464,0,0,9,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10464,0,0,10,9,13665,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10464,0,0,10,1,64805,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10464,0,0,10,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10464,0,0,10,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10471,0,0,1,9,13772,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10471,0,0,1,1,64814,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10471,0,0,1,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10471,0,0,1,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10471,0,0,2,9,13777,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10471,0,0,2,1,64814,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10471,0,0,2,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10471,0,0,2,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10471,0,0,3,9,13782,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10471,0,0,3,1,64814,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10471,0,0,3,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10471,0,0,3,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10471,0,0,4,9,13787,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10471,0,0,4,1,64814,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10471,0,0,4,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10471,0,0,4,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10471,0,0,5,9,13767,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10471,0,0,5,1,64814,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10471,0,0,5,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10471,0,0,5,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10471,0,0,6,9,13761,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10471,0,0,6,1,64814,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10471,0,0,6,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10471,0,0,6,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10471,0,0,7,9,13745,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10471,0,0,7,1,64814,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10471,0,0,7,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10471,0,0,7,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10471,0,0,8,9,13750,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10471,0,0,8,1,64814,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10471,0,0,8,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10471,0,0,8,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10471,0,0,9,9,13756,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10471,0,0,9,1,64814,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10471,0,0,9,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10471,0,0,9,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10471,0,0,10,9,13665,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10471,0,0,10,1,64814,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10471,0,0,10,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10471,0,0,10,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10465,0,0,1,9,13772,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10465,0,0,1,1,64808,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10465,0,0,1,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10465,0,0,1,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10465,0,0,2,9,13777,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10465,0,0,2,1,64808,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10465,0,0,2,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10465,0,0,2,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10465,0,0,3,9,13782,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10465,0,0,3,1,64808,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10465,0,0,3,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10465,0,0,3,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10465,0,0,4,9,13787,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10465,0,0,4,1,64808,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10465,0,0,4,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10465,0,0,4,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10465,0,0,5,9,13767,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10465,0,0,5,1,64808,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10465,0,0,5,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10465,0,0,5,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10465,0,0,6,9,13761,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10465,0,0,6,1,64808,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10465,0,0,6,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10465,0,0,6,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10465,0,0,7,9,13745,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10465,0,0,7,1,64808,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10465,0,0,7,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10465,0,0,7,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10465,0,0,8,9,13750,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10465,0,0,8,1,64808,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10465,0,0,8,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10465,0,0,8,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10465,0,0,9,9,13756,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10465,0,0,9,1,64808,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10465,0,0,9,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10465,0,0,9,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10465,0,0,10,9,13665,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10465,0,0,10,1,64808,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10465,0,0,10,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10465,0,0,10,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10467,0,0,1,9,13772,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10467,0,0,1,1,64810,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10467,0,0,1,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10467,0,0,1,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10467,0,0,2,9,13777,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10467,0,0,2,1,64810,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10467,0,0,2,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10467,0,0,2,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10467,0,0,3,9,13782,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10467,0,0,3,1,64810,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10467,0,0,3,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10467,0,0,3,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10467,0,0,4,9,13787,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10467,0,0,4,1,64810,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10467,0,0,4,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10467,0,0,4,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10467,0,0,5,9,13767,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10467,0,0,5,1,64810,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10467,0,0,5,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10467,0,0,5,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10467,0,0,6,9,13761,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10467,0,0,6,1,64810,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10467,0,0,6,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10467,0,0,6,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10467,0,0,7,9,13745,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10467,0,0,7,1,64810,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10467,0,0,7,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10467,0,0,7,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10467,0,0,8,9,13750,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10467,0,0,8,1,64810,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10467,0,0,8,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10467,0,0,8,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10467,0,0,9,9,13756,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10467,0,0,9,1,64810,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10467,0,0,9,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10467,0,0,9,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10467,0,0,10,9,13665,0,0,0,'','Show gossip menu only if quest The Grand Mele is taken',0),
+(15,10467,0,0,10,1,64810,0,0,0,'','Show gossip menu only if don''t have the aura',1),
+(15,10467,0,0,10,1,63034,0,0,0,'','Show gossip menu only if the player have the aura',0),
+(15,10467,0,0,10,1,62853,0,0,0,'','Show gossip menu only if the player have the aura',0);
+
+SET @Orgri_Valiant := 33306;
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@Orgri_Valiant;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@Orgri_Valiant;
+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
+(@Orgri_Valiant,0,0,0,25,0,100,0,0,0,0,0,28,64223,0,0,0,0,0,1,0,0,0,0,0,0,0,'Orgri Valiant - On Reset - Remove auras from Defend'),
+(@Orgri_Valiant,0,1,2,62,0,100,0,10468,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'Orgri Valiant - On gossip select - Close gossip'),
+(@Orgri_Valiant,0,2,3,61,0,100,0,0,0,0,0,64,1,0,0,0,0,0,7,0,0,0,0,0,0,0,'Orgri Valiant - Linked with previous event - store target'),
+(@Orgri_Valiant,0,3,0,61,0,100,0,0,0,0,0,80,@Script,2,0,0,0,0,1,0,0,0,0,0,0,0,'Orgri Valiant - Linked with previous event - Call timed actionlist'),
+(@Orgri_Valiant,0,4,0,52,0,100,0,0,@Orgri_Valiant,0,0,11,63010,0,0,0,0,0,7,0,0,0,0,0,0,0,'Orgri Valiant - On text over - Cast Charge'),
+(@Orgri_Valiant,0,5,0,0,0,100,0,0,0,1500,4000,11,62544,0,0,0,0,0,2,0,0,0,0,0,0,0,'Orgri Valiant - IC - Cast Thrust'),
+(@Orgri_Valiant,0,6,0,9,0,100,0,5,5,9000,10000,11,62575,0,0,0,0,0,2,0,0,0,0,0,0,0,'Orgri Valiant - On more than 5 yard range - Cast Shield-Breaker'),
+(@Orgri_Valiant,0,7,0,0,0,100,0,9000,11000,9000,10000,46,12,0,0,0,0,0,1,0,0,0,0,0,0,0,'Orgri Valiant - IC - Move forward 12 yards'),
+(@Orgri_Valiant,0,8,9,9,0,100,0,9,15,3000,3000,11,63010,0,0,0,0,0,2,0,0,0,0,0,0,0,'Orgri Valiant - On 10-12 yard range - Cast Charge'),
+(@Orgri_Valiant,0,9,0,61,0,100,0,0,0,0,0,11,62575,0,0,0,0,0,2,0,0,0,0,0,0,0,'Orgri Valiant - Linked with previous event - Cast Shield-Breaker'),
+(@Orgri_Valiant,0,10,11,2,0,100,1,1,3,60000,60000,2,35,0,0,0,0,0,1,0,0,0,0,0,0,0,'Orgri Valiant - On HP% between 1% and 3% - Change faction to 35'),
+(@Orgri_Valiant,0,11,12,61,0,100,0,0,0,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,'Orgri Valiant - Linked with previous event - Say text'),
+(@Orgri_Valiant,0,12,13,61,0,100,0,0,0,0,0,85,62724,0,0,0,0,0,12,1,0,0,0,0,0,0,'Orgri Valiant - Linked with previous event - Cast Mounted Melee Victory /item/'),
+(@Orgri_Valiant,0,13,14,61,0,100,0,0,0,0,0,85,64811,0,0,0,0,0,12,1,0,0,0,0,0,0,'Orgri Valiant - Linked with previous event - Cast credit'),
+(@Orgri_Valiant,0,14,0,61,0,100,0,0,0,0,0,24,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Orgri_Valiant - Linked with previous event - Evade'),
+(@Orgri_Valiant,0,15,16,5,0,100,0,60000,60000,1,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Orgri Valiant - On player killed - Say text'),
+(@Orgri_Valiant,0,16,17,61,0,100,0,0,0,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Orgri Valiant - Linked with previous event - Set unseen'),
+(@Orgri_Valiant,0,17,0,61,0,100,0,0,0,0,0,41,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Orgri Valiant - Linked with previous event - Despawn in 1 ms');
+-- Argent Valiants texts
+DELETE FROM `creature_text` WHERE `entry`= @Orgri_Valiant;
+INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`, `BroadcastTextId`) VALUES
+(@Orgri_Valiant,0,0,'Ready yourself!',12,1,100,0,0,0,'Argent Valiant', 33757),
+(@Orgri_Valiant,0,1,'Prepare yourself!',12,1,100,0,0,0,'Argent Valiant', 33755),
+(@Orgri_Valiant,0,2,'On your guard!',12,1,100,0,0,0,'Argent Valiant', 33756),
+(@Orgri_Valiant,0,3,'Let it begin!',12,1,100,0,0,0,'Argent Valiant', 33758),
+(@Orgri_Valiant,1,0,'Victory is mine!',12,1,100,0,0,0,'Argent Valiant', 33777),
+(@Orgri_Valiant,1,1,'It seems you still need more practice. Perhaps another time.',12,1,100,0,0,0,'Argent Valiant', 33764),
+(@Orgri_Valiant,1,2,'I have won. Better luck another time, friend.',12,1,100,0,0,0,'Argent Valiant', 33779),
+(@Orgri_Valiant,1,3,'I am afraid you will need more practice to defeat me.',12,1,100,0,0,0,'Argent Valiant', 33778),
+(@Orgri_Valiant,2,0,'I yield to you.',12,1,100,0,0,0,'Argent Valiant', 33774),
+(@Orgri_Valiant,2,1,'That was a well fought battle. I yield to you.',12,1,100,0,0,0,'Argent Valiant', 33776),
+(@Orgri_Valiant,2,2,'It would seem I underestimated your skills. Well done.',12,1,100,0,0,0,'Argent Valiant', 33775),
+(@Orgri_Valiant,2,3,'I have been defeated. Good fight!',12,1,100,0,0,0,'Argent Valiant', 33760);
+SET @TB_Valiant := 33383;
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@TB_Valiant;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@TB_Valiant;
+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
+(@TB_Valiant,0,0,0,25,0,100,0,0,0,0,0,28,64223,0,0,0,0,0,1,0,0,0,0,0,0,0,'TB Valiant - On Reset - Remove auras from Defend'),
+(@TB_Valiant,0,1,2,62,0,100,0,10472,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'TB Valiant - On gossip select - Close gossip'),
+(@TB_Valiant,0,2,3,61,0,100,0,0,0,0,0,64,1,0,0,0,0,0,7,0,0,0,0,0,0,0,'TB_Valiant - Linked with previous event - store target'),
+(@TB_Valiant,0,3,0,61,0,100,0,0,0,0,0,80,@Script,2,0,0,0,0,1,0,0,0,0,0,0,0,'TB Valiant - Linked with previous event - Call timed actionlist'),
+(@TB_Valiant,0,4,0,52,0,100,0,0,@TB_Valiant,0,0,11,63010,0,0,0,0,0,7,0,0,0,0,0,0,0,'TB Valiant - On text over - Cast Charge'),
+(@TB_Valiant,0,5,0,0,0,100,0,0,0,1500,4000,11,62544,0,0,0,0,0,2,0,0,0,0,0,0,0,'TB Valiant - IC - Cast Thrust'),
+(@TB_Valiant,0,6,0,9,0,100,0,5,5,9000,10000,11,62575,0,0,0,0,0,2,0,0,0,0,0,0,0,'TB Valiant - On more than 5 yard range - Cast Shield-Breaker'),
+(@TB_Valiant,0,7,0,0,0,100,0,9000,11000,9000,10000,46,12,0,0,0,0,0,1,0,0,0,0,0,0,0,'TB Valiant - IC - Move forward 12 yards'),
+(@TB_Valiant,0,8,9,9,0,100,0,9,15,3000,3000,11,63010,0,0,0,0,0,2,0,0,0,0,0,0,0,'TB Valiant - On 10-12 yard range - Cast Charge'),
+(@TB_Valiant,0,9,0,61,0,100,0,0,0,0,0,11,62575,0,0,0,0,0,2,0,0,0,0,0,0,0,'TB Valiant - Linked with previous event - Cast Shield-Breaker'),
+(@TB_Valiant,0,10,11,2,0,100,1,1,3,60000,60000,2,35,0,0,0,0,0,1,0,0,0,0,0,0,0,'TB Valiant - On HP% between 1% and 3% - Change faction to 35'),
+(@TB_Valiant,0,11,12,61,0,100,0,0,0,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,'TB Valiant - Linked with previous event - Say text'),
+(@TB_Valiant,0,12,13,61,0,100,0,0,0,0,0,85,62724,0,0,0,0,0,12,1,0,0,0,0,0,0,'TB Valiant - Linked with previous event - Cast Mounted Melee Victory /item/'),
+(@TB_Valiant,0,13,14,61,0,100,0,0,0,0,0,85,64815,0,0,0,0,0,12,1,0,0,0,0,0,0,'TB Valiant - Linked with previous event - Cast credit'),
+(@TB_Valiant,0,14,0,61,0,100,0,0,0,0,0,24,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'TB_Valiant - Linked with previous event - Evade'),
+(@TB_Valiant,0,15,16,5,0,100,0,60000,60000,1,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'TB Valiant - On player killed - Say text'),
+(@TB_Valiant,0,16,17,61,0,100,0,0,0,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'TB Valiant - Linked with previous event - Set unseen'),
+(@TB_Valiant,0,17,0,61,0,100,0,0,0,0,0,41,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'TB Valiant - Linked with previous event - Despawn in 1 ms');
+-- Argent Valiants texts
+DELETE FROM `creature_text` WHERE `entry`= @TB_Valiant;
+INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`, `BroadcastTextId`) VALUES
+(@TB_Valiant,0,0,'Ready yourself!',12,1,100,0,0,0,'Argent Valiant', 33757),
+(@TB_Valiant,0,1,'Prepare yourself!',12,1,100,0,0,0,'Argent Valiant', 33755),
+(@TB_Valiant,0,2,'On your guard!',12,1,100,0,0,0,'Argent Valiant', 33756),
+(@TB_Valiant,0,3,'Let it begin!',12,1,100,0,0,0,'Argent Valiant', 33758),
+(@TB_Valiant,1,0,'Victory is mine!',12,1,100,0,0,0,'Argent Valiant', 33777),
+(@TB_Valiant,1,1,'It seems you still need more practice. Perhaps another time.',12,1,100,0,0,0,'Argent Valiant', 33764),
+(@TB_Valiant,1,2,'I have won. Better luck another time, friend.',12,1,100,0,0,0,'Argent Valiant', 33779),
+(@TB_Valiant,1,3,'I am afraid you will need more practice to defeat me.',12,1,100,0,0,0,'Argent Valiant', 33778),
+(@TB_Valiant,2,0,'I yield to you.',12,1,100,0,0,0,'Argent Valiant', 33774),
+(@TB_Valiant,2,1,'That was a well fought battle. I yield to you.',12,1,100,0,0,0,'Argent Valiant', 33776),
+(@TB_Valiant,2,2,'It would seem I underestimated your skills. Well done.',12,1,100,0,0,0,'Argent Valiant', 33775),
+(@TB_Valiant,2,3,'I have been defeated. Good fight!',12,1,100,0,0,0,'Argent Valiant', 33760);
+SET @SM_Valiant := 33382;
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@SM_Valiant;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@SM_Valiant;
+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
+(@SM_Valiant,0,0,0,25,0,100,0,0,0,0,0,28,64223,0,0,0,0,0,1,0,0,0,0,0,0,0,'SM Valiant - On Reset - Remove auras from Defend'),
+(@SM_Valiant,0,1,2,62,0,100,0,10470,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'SM Valiant - On gossip select - Close gossip'),
+(@SM_Valiant,0,2,3,61,0,100,0,0,0,0,0,64,1,0,0,0,0,0,7,0,0,0,0,0,0,0,'SM_Valiant - Linked with previous event - store target'),
+(@SM_Valiant,0,3,0,61,0,100,0,0,0,0,0,80,@Script,2,0,0,0,0,1,0,0,0,0,0,0,0,'SM Valiant - Linked with previous event - Call timed actionlist'),
+(@SM_Valiant,0,4,0,52,0,100,0,0,@SM_Valiant,0,0,11,63010,0,0,0,0,0,7,0,0,0,0,0,0,0,'SM Valiant - On text over - Cast Charge'),
+(@SM_Valiant,0,5,0,0,0,100,0,0,0,1500,4000,11,62544,0,0,0,0,0,2,0,0,0,0,0,0,0,'SM Valiant - IC - Cast Thrust'),
+(@SM_Valiant,0,6,0,9,0,100,0,5,5,9000,10000,11,62575,0,0,0,0,0,2,0,0,0,0,0,0,0,'SM Valiant - On more than 5 yard range - Cast Shield-Breaker'),
+(@SM_Valiant,0,7,0,0,0,100,0,9000,11000,9000,10000,46,12,0,0,0,0,0,1,0,0,0,0,0,0,0,'SM Valiant - IC - Move forward 12 yards'),
+(@SM_Valiant,0,8,9,9,0,100,0,9,15,3000,3000,11,63010,0,0,0,0,0,2,0,0,0,0,0,0,0,'SM Valiant - On 10-12 yard range - Cast Charge'),
+(@SM_Valiant,0,9,0,61,0,100,0,0,0,0,0,11,62575,0,0,0,0,0,2,0,0,0,0,0,0,0,'SM Valiant - Linked with previous event - Cast Shield-Breaker'),
+(@SM_Valiant,0,10,11,2,0,100,1,1,3,60000,60000,2,35,0,0,0,0,0,1,0,0,0,0,0,0,0,'SM Valiant - On HP% between 1% and 3% - Change faction to 35'),
+(@SM_Valiant,0,11,12,61,0,100,0,0,0,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,'SM Valiant - Linked with previous event - Say text'),
+(@SM_Valiant,0,12,13,61,0,100,0,0,0,0,0,85,62724,0,0,0,0,0,12,1,0,0,0,0,0,0,'SM Valiant - Linked with previous event - Cast Mounted Melee Victory /item/'),
+(@SM_Valiant,0,13,14,61,0,100,0,0,0,0,0,85,64813,0,0,0,0,0,12,1,0,0,0,0,0,0,'SM Valiant - Linked with previous event - Cast credit'),
+(@SM_Valiant,0,14,0,61,0,100,0,0,0,0,0,24,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'SM_Valiant - Linked with previous event - Evade'),
+(@SM_Valiant,0,15,16,5,0,100,0,60000,60000,1,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'SM Valiant - On player killed - Say text'),
+(@SM_Valiant,0,16,17,61,0,100,0,0,0,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'SM Valiant - Linked with previous event - Set unseen'),
+(@SM_Valiant,0,17,0,61,0,100,0,0,0,0,0,41,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'SM Valiant - Linked with previous event - Despawn in 1 ms');
+-- Argent Valiants texts
+DELETE FROM `creature_text` WHERE `entry`= @SM_Valiant;
+INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`, `BroadcastTextId`) VALUES
+(@SM_Valiant,0,0,'Ready yourself!',12,1,100,0,0,0,'Argent Valiant', 33757),
+(@SM_Valiant,0,1,'Prepare yourself!',12,1,100,0,0,0,'Argent Valiant', 33755),
+(@SM_Valiant,0,2,'On your guard!',12,1,100,0,0,0,'Argent Valiant', 33756),
+(@SM_Valiant,0,3,'Let it begin!',12,1,100,0,0,0,'Argent Valiant', 33758),
+(@SM_Valiant,1,0,'Victory is mine!',12,1,100,0,0,0,'Argent Valiant', 33777),
+(@SM_Valiant,1,1,'It seems you still need more practice. Perhaps another time.',12,1,100,0,0,0,'Argent Valiant', 33764),
+(@SM_Valiant,1,2,'I have won. Better luck another time, friend.',12,1,100,0,0,0,'Argent Valiant', 33779),
+(@SM_Valiant,1,3,'I am afraid you will need more practice to defeat me.',12,1,100,0,0,0,'Argent Valiant', 33778),
+(@SM_Valiant,2,0,'I yield to you.',12,1,100,0,0,0,'Argent Valiant', 33774),
+(@SM_Valiant,2,1,'That was a well fought battle. I yield to you.',12,1,100,0,0,0,'Argent Valiant', 33776),
+(@SM_Valiant,2,2,'It would seem I underestimated your skills. Well done.',12,1,100,0,0,0,'Argent Valiant', 33775),
+(@SM_Valiant,2,3,'I have been defeated. Good fight!',12,1,100,0,0,0,'Argent Valiant', 33760);
+SET @GR_Valiant := 33558;
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@GR_Valiant;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@GR_Valiant;
+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
+(@GR_Valiant,0,0,0,25,0,100,0,0,0,0,0,28,64223,0,0,0,0,0,1,0,0,0,0,0,0,0,'GR Valiant - On Reset - Remove auras from Defend'),
+(@GR_Valiant,0,1,2,62,0,100,0,10466,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'GR Valiant - On gossip select - Close gossip'),
+(@GR_Valiant,0,2,3,61,0,100,0,0,0,0,0,64,1,0,0,0,0,0,7,0,0,0,0,0,0,0,'GR_Valiant - Linked with previous event - store target'),
+(@GR_Valiant,0,3,0,61,0,100,0,0,0,0,0,80,@Script,2,0,0,0,0,1,0,0,0,0,0,0,0,'GR Valiant - Linked with previous event - Call timed actionlist'),
+(@GR_Valiant,0,4,0,52,0,100,0,0,@GR_Valiant,0,0,11,63010,0,0,0,0,0,7,0,0,0,0,0,0,0,'GR Valiant - On text over - Cast Charge'),
+(@GR_Valiant,0,5,0,0,0,100,0,0,0,1500,4000,11,62544,0,0,0,0,0,2,0,0,0,0,0,0,0,'GR Valiant - IC - Cast Thrust'),
+(@GR_Valiant,0,6,0,9,0,100,0,5,5,9000,10000,11,62575,0,0,0,0,0,2,0,0,0,0,0,0,0,'GR Valiant - On more than 5 yard range - Cast Shield-Breaker'),
+(@GR_Valiant,0,7,0,0,0,100,0,9000,11000,9000,10000,46,12,0,0,0,0,0,1,0,0,0,0,0,0,0,'GR Valiant - IC - Move forward 12 yards'),
+(@GR_Valiant,0,8,9,9,0,100,0,9,15,3000,3000,11,63010,0,0,0,0,0,2,0,0,0,0,0,0,0,'GR Valiant - On 10-12 yard range - Cast Charge'),
+(@GR_Valiant,0,9,0,61,0,100,0,0,0,0,0,11,62575,0,0,0,0,0,2,0,0,0,0,0,0,0,'GR Valiant - Linked with previous event - Cast Shield-Breaker'),
+(@GR_Valiant,0,10,11,2,0,100,1,1,3,60000,60000,2,35,0,0,0,0,0,1,0,0,0,0,0,0,0,'GR Valiant - On HP% between 1% and 3% - Change faction to 35'),
+(@GR_Valiant,0,11,12,61,0,100,0,0,0,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,'GR Valiant - Linked with previous event - Say text'),
+(@GR_Valiant,0,12,13,61,0,100,0,0,0,0,0,85,62724,0,0,0,0,0,12,1,0,0,0,0,0,0,'GR Valiant - Linked with previous event - Cast Mounted Melee Victory /item/'),
+(@GR_Valiant,0,13,14,61,0,100,0,0,0,0,0,85,64809,0,0,0,0,0,12,1,0,0,0,0,0,0,'GR Valiant - Linked with previous event - Cast credit'),
+(@GR_Valiant,0,14,0,61,0,100,0,0,0,0,0,24,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'GR_Valiant - Linked with previous event - Evade'),
+(@GR_Valiant,0,15,16,5,0,100,0,60000,60000,1,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'GR Valiant - On player killed - Say text'),
+(@GR_Valiant,0,16,17,61,0,100,0,0,0,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'GR Valiant - Linked with previous event - Set unseen'),
+(@GR_Valiant,0,17,0,61,0,100,0,0,0,0,0,41,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'GR Valiant - Linked with previous event - Despawn in 1 ms');
+-- Argent Valiants texts
+DELETE FROM `creature_text` WHERE `entry`= @GR_Valiant;
+INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`, `BroadcastTextId`) VALUES
+(@GR_Valiant,0,0,'Ready yourself!',12,7,100,0,0,0,'Argent Valiant', 33757),
+(@GR_Valiant,0,1,'Prepare yourself!',12,7,100,0,0,0,'Argent Valiant', 33755),
+(@GR_Valiant,0,2,'On your guard!',12,7,100,0,0,0,'Argent Valiant', 33756),
+(@GR_Valiant,0,3,'Let it begin!',12,7,100,0,0,0,'Argent Valiant', 33758),
+(@GR_Valiant,1,0,'Victory is mine!',12,7,100,0,0,0,'Argent Valiant', 33777),
+(@GR_Valiant,1,1,'It seems you still need more practice. Perhaps another time.',12,7,100,0,0,0,'Argent Valiant', 33764),
+(@GR_Valiant,1,2,'I have won. Better luck another time, friend.',12,7,100,0,0,0,'Argent Valiant', 33779),
+(@GR_Valiant,1,3,'I am afraid you will need more practice to defeat me.',12,7,100,0,0,0,'Argent Valiant', 33778),
+(@GR_Valiant,2,0,'I yield to you.',12,7,100,0,0,0,'Argent Valiant', 33774),
+(@GR_Valiant,2,1,'That was a well fought battle. I yield to you.',12,7,100,0,0,0,'Argent Valiant', 33776),
+(@GR_Valiant,2,2,'It would seem I underestimated your skills. Well done.',12,7,100,0,0,0,'Argent Valiant', 33775),
+(@GR_Valiant,2,3,'I have been defeated. Good fight!',12,7,100,0,0,0,'Argent Valiant', 33760);
+SET @IF_Valiant := 33564;
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@IF_Valiant;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@IF_Valiant;
+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
+(@IF_Valiant,0,0,0,25,0,100,0,0,0,0,0,28,64223,0,0,0,0,0,1,0,0,0,0,0,0,0,'IF Valiant - On Reset - Remove auras from Defend'),
+(@IF_Valiant,0,1,2,62,0,100,0,10467,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'IF Valiant - On gossip select - Close gossip'),
+(@IF_Valiant,0,2,3,61,0,100,0,0,0,0,0,64,1,0,0,0,0,0,7,0,0,0,0,0,0,0,'IF_Valiant - Linked with previous event - store target'),
+(@IF_Valiant,0,3,0,61,0,100,0,0,0,0,0,80,@Script,2,0,0,0,0,1,0,0,0,0,0,0,0,'IF Valiant - Linked with previous event - Call timed actionlist'),
+(@IF_Valiant,0,4,0,52,0,100,0,0,@IF_Valiant,0,0,11,63010,0,0,0,0,0,7,0,0,0,0,0,0,0,'IF Valiant - On text over - Cast Charge'),
+(@IF_Valiant,0,5,0,0,0,100,0,0,0,1500,4000,11,62544,0,0,0,0,0,2,0,0,0,0,0,0,0,'IF Valiant - IC - Cast Thrust'),
+(@IF_Valiant,0,6,0,9,0,100,0,5,5,9000,10000,11,62575,0,0,0,0,0,2,0,0,0,0,0,0,0,'IF Valiant - On more than 5 yard range - Cast Shield-Breaker'),
+(@IF_Valiant,0,7,0,0,0,100,0,9000,11000,9000,10000,46,12,0,0,0,0,0,1,0,0,0,0,0,0,0,'IF Valiant - IC - Move forward 12 yards'),
+(@IF_Valiant,0,8,9,9,0,100,0,9,15,3000,3000,11,63010,0,0,0,0,0,2,0,0,0,0,0,0,0,'IF Valiant - On 10-12 yard range - Cast Charge'),
+(@IF_Valiant,0,9,0,61,0,100,0,0,0,0,0,11,62575,0,0,0,0,0,2,0,0,0,0,0,0,0,'IF Valiant - Linked with previous event - Cast Shield-Breaker'),
+(@IF_Valiant,0,10,11,2,0,100,1,1,3,60000,60000,2,35,0,0,0,0,0,1,0,0,0,0,0,0,0,'IF Valiant - On HP% between 1% and 3% - Change faction to 35'),
+(@IF_Valiant,0,11,12,61,0,100,0,0,0,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,'IF Valiant - Linked with previous event - Say text'),
+(@IF_Valiant,0,12,13,61,0,100,0,0,0,0,0,85,62724,0,0,0,0,0,12,1,0,0,0,0,0,0,'IF Valiant - Linked with previous event - Cast Mounted Melee Victory /item/'),
+(@IF_Valiant,0,13,14,61,0,100,0,0,0,0,0,85,64810,0,0,0,0,0,12,1,0,0,0,0,0,0,'IF Valiant - Linked with previous event - Cast credit'),
+(@IF_Valiant,0,14,0,61,0,100,0,0,0,0,0,24,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'IF_Valiant - Linked with previous event - Evade'),
+(@IF_Valiant,0,15,16,5,0,100,0,60000,60000,1,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'IF Valiant - On player killed - Say text'),
+(@IF_Valiant,0,16,17,61,0,100,0,0,0,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'IF Valiant - Linked with previous event - Set unseen'),
+(@IF_Valiant,0,17,0,61,0,100,0,0,0,0,0,41,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'IF Valiant - Linked with previous event - Despawn in 1 ms');
+-- Argent Valiants texts
+DELETE FROM `creature_text` WHERE `entry`= @IF_Valiant;
+INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`, `BroadcastTextId`) VALUES
+(@IF_Valiant,0,0,'Ready yourself!',12,7,100,0,0,0,'Argent Valiant', 33757),
+(@IF_Valiant,0,1,'Prepare yourself!',12,7,100,0,0,0,'Argent Valiant', 33755),
+(@IF_Valiant,0,2,'On your guard!',12,7,100,0,0,0,'Argent Valiant', 33756),
+(@IF_Valiant,0,3,'Let it begin!',12,7,100,0,0,0,'Argent Valiant', 33758),
+(@IF_Valiant,1,0,'Victory is mine!',12,7,100,0,0,0,'Argent Valiant', 33777),
+(@IF_Valiant,1,1,'It seems you still need more practice. Perhaps another time.',12,7,100,0,0,0,'Argent Valiant', 33764),
+(@IF_Valiant,1,2,'I have won. Better luck another time, friend.',12,7,100,0,0,0,'Argent Valiant', 33779),
+(@IF_Valiant,1,3,'I am afraid you will need more practice to defeat me.',12,7,100,0,0,0,'Argent Valiant', 33778),
+(@IF_Valiant,2,0,'I yield to you.',12,7,100,0,0,0,'Argent Valiant', 33774),
+(@IF_Valiant,2,1,'That was a well fought battle. I yield to you.',12,7,100,0,0,0,'Argent Valiant', 33776),
+(@IF_Valiant,2,2,'It would seem I underestimated your skills. Well done.',12,7,100,0,0,0,'Argent Valiant', 33775),
+(@IF_Valiant,2,3,'I have been defeated. Good fight!',12,7,100,0,0,0,'Argent Valiant', 33760);
+SET @SW_Valiant := 33561;
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@SW_Valiant;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@SW_Valiant;
+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
+(@SW_Valiant,0,0,0,25,0,100,0,0,0,0,0,28,64223,0,0,0,0,0,1,0,0,0,0,0,0,0,'SW Valiant - On Reset - Remove auras from Defend'),
+(@SW_Valiant,0,1,2,62,0,100,0,10471,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'SW Valiant - On gossip select - Close gossip'),
+(@SW_Valiant,0,2,3,61,0,100,0,0,0,0,0,64,1,0,0,0,0,0,7,0,0,0,0,0,0,0,'SW_Valiant - Linked with previous event - store target'),
+(@SW_Valiant,0,3,0,61,0,100,0,0,0,0,0,80,@Script,2,0,0,0,0,1,0,0,0,0,0,0,0,'SW Valiant - Linked with previous event - Call timed actionlist'),
+(@SW_Valiant,0,4,0,52,0,100,0,0,@SW_Valiant,0,0,11,63010,0,0,0,0,0,7,0,0,0,0,0,0,0,'SW Valiant - On text over - Cast Charge'),
+(@SW_Valiant,0,5,0,0,0,100,0,0,0,1500,4000,11,62544,0,0,0,0,0,2,0,0,0,0,0,0,0,'SW Valiant - IC - Cast Thrust'),
+(@SW_Valiant,0,6,0,9,0,100,0,5,5,9000,10000,11,62575,0,0,0,0,0,2,0,0,0,0,0,0,0,'SW Valiant - On more than 5 yard range - Cast Shield-Breaker'),
+(@SW_Valiant,0,7,0,0,0,100,0,9000,11000,9000,10000,46,12,0,0,0,0,0,1,0,0,0,0,0,0,0,'SW Valiant - IC - Move forward 12 yards'),
+(@SW_Valiant,0,8,9,9,0,100,0,9,15,3000,3000,11,63010,0,0,0,0,0,2,0,0,0,0,0,0,0,'SW Valiant - On 10-12 yard range - Cast Charge'),
+(@SW_Valiant,0,9,0,61,0,100,0,0,0,0,0,11,62575,0,0,0,0,0,2,0,0,0,0,0,0,0,'SW Valiant - Linked with previous event - Cast Shield-Breaker'),
+(@SW_Valiant,0,10,11,2,0,100,1,1,3,60000,60000,2,35,0,0,0,0,0,1,0,0,0,0,0,0,0,'SW Valiant - On HP% between 1% and 3% - Change faction to 35'),
+(@SW_Valiant,0,11,12,61,0,100,0,0,0,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,'SW Valiant - Linked with previous event - Say text'),
+(@SW_Valiant,0,12,13,61,0,100,0,0,0,0,0,85,62724,0,0,0,0,0,12,1,0,0,0,0,0,0,'SW Valiant - Linked with previous event - Cast Mounted Melee Victory /item/'),
+(@SW_Valiant,0,13,14,61,0,100,0,0,0,0,0,85,64814,0,0,0,0,0,12,1,0,0,0,0,0,0,'SW Valiant - Linked with previous event - Cast credit'),
+(@SW_Valiant,0,14,0,61,0,100,0,0,0,0,0,24,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'SW_Valiant - Linked with previous event - Evade'),
+(@SW_Valiant,0,15,16,5,0,100,0,60000,60000,1,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'SW Valiant - On player killed - Say text'),
+(@SW_Valiant,0,16,17,61,0,100,0,0,0,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'SW Valiant - Linked with previous event - Set unseen'),
+(@SW_Valiant,0,17,0,61,0,100,0,0,0,0,0,41,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'SW Valiant - Linked with previous event - Despawn in 1 ms');
+-- Argent Valiants texts
+DELETE FROM `creature_text` WHERE `entry`= @SW_Valiant;
+INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`, `BroadcastTextId`) VALUES
+(@SW_Valiant,0,0,'Ready yourself!',12,7,100,0,0,0,'Argent Valiant', 33757),
+(@SW_Valiant,0,1,'Prepare yourself!',12,7,100,0,0,0,'Argent Valiant', 33755),
+(@SW_Valiant,0,2,'On your guard!',12,7,100,0,0,0,'Argent Valiant', 33756),
+(@SW_Valiant,0,3,'Let it begin!',12,7,100,0,0,0,'Argent Valiant', 33758),
+(@SW_Valiant,1,0,'Victory is mine!',12,7,100,0,0,0,'Argent Valiant', 33777),
+(@SW_Valiant,1,1,'It seems you still need more practice. Perhaps another time.',12,7,100,0,0,0,'Argent Valiant', 33764),
+(@SW_Valiant,1,2,'I have won. Better luck another time, friend.',12,7,100,0,0,0,'Argent Valiant', 33779),
+(@SW_Valiant,1,3,'I am afraid you will need more practice to defeat me.',12,7,100,0,0,0,'Argent Valiant', 33778),
+(@SW_Valiant,2,0,'I yield to you.',12,7,100,0,0,0,'Argent Valiant', 33774),
+(@SW_Valiant,2,1,'That was a well fought battle. I yield to you.',12,7,100,0,0,0,'Argent Valiant', 33776),
+(@SW_Valiant,2,2,'It would seem I underestimated your skills. Well done.',12,7,100,0,0,0,'Argent Valiant', 33775),
+(@SW_Valiant,2,3,'I have been defeated. Good fight!',12,7,100,0,0,0,'Argent Valiant', 33760);
+SET @Darn_Valiant := 33559;
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@Darn_Valiant;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@Darn_Valiant;
+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
+(@Darn_Valiant,0,0,0,25,0,100,0,0,0,0,0,28,64223,0,0,0,0,0,1,0,0,0,0,0,0,0,'Darn Valiant - On Reset - Remove auras from Defend'),
+(@Darn_Valiant,0,1,2,62,0,100,0,10464,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'Darn Valiant - On gossip select - Close gossip'),
+(@Darn_Valiant,0,2,3,61,0,100,0,0,0,0,0,64,1,0,0,0,0,0,7,0,0,0,0,0,0,0,'Darn_Valiant - Linked with previous event - store target'),
+(@Darn_Valiant,0,3,0,61,0,100,0,0,0,0,0,80,@Script,2,0,0,0,0,1,0,0,0,0,0,0,0,'Darn Valiant - Linked with previous event - Call timed actionlist'),
+(@Darn_Valiant,0,4,0,52,0,100,0,0,@Darn_Valiant,0,0,11,63010,0,0,0,0,0,7,0,0,0,0,0,0,0,'Darn Valiant - On text over - Cast Charge'),
+(@Darn_Valiant,0,5,0,0,0,100,0,0,0,1500,4000,11,62544,0,0,0,0,0,2,0,0,0,0,0,0,0,'Darn Valiant - IC - Cast Thrust'),
+(@Darn_Valiant,0,6,0,9,0,100,0,5,5,9000,10000,11,62575,0,0,0,0,0,2,0,0,0,0,0,0,0,'Darn Valiant - On more than 5 yard range - Cast Shield-Breaker'),
+(@Darn_Valiant,0,7,0,0,0,100,0,9000,11000,9000,10000,46,12,0,0,0,0,0,1,0,0,0,0,0,0,0,'Darn Valiant - IC - Move forward 12 yards'),
+(@Darn_Valiant,0,8,9,9,0,100,0,9,15,3000,3000,11,63010,0,0,0,0,0,2,0,0,0,0,0,0,0,'Darn Valiant - On 10-12 yard range - Cast Charge'),
+(@Darn_Valiant,0,9,0,61,0,100,0,0,0,0,0,11,62575,0,0,0,0,0,2,0,0,0,0,0,0,0,'Darn Valiant - Linked with previous event - Cast Shield-Breaker'),
+(@Darn_Valiant,0,10,11,2,0,100,1,1,3,60000,60000,2,35,0,0,0,0,0,1,0,0,0,0,0,0,0,'Darn Valiant - On HP% between 1% and 3% - Change faction to 35'),
+(@Darn_Valiant,0,11,12,61,0,100,0,0,0,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,'Darn Valiant - Linked with previous event - Say text'),
+(@Darn_Valiant,0,12,13,61,0,100,0,0,0,0,0,85,62724,0,0,0,0,0,12,1,0,0,0,0,0,0,'Darn Valiant - Linked with previous event - Cast Mounted Melee Victory /item/'),
+(@Darn_Valiant,0,13,14,61,0,100,0,0,0,0,0,85,64805,0,0,0,0,0,12,1,0,0,0,0,0,0,'Darn Valiant - Linked with previous event - Cast credit'),
+(@Darn_Valiant,0,14,0,61,0,100,0,0,0,0,0,24,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Darn_Valiant - Linked with previous event - Evade'),
+(@Darn_Valiant,0,15,16,5,0,100,0,60000,60000,1,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Darn Valiant - On player killed - Say text'),
+(@Darn_Valiant,0,16,17,61,0,100,0,0,0,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Darn Valiant - Linked with previous event - Set unseen'),
+(@Darn_Valiant,0,17,0,61,0,100,0,0,0,0,0,41,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Darn Valiant - Linked with previous event - Despawn in 1 ms');
+-- Argent Valiants texts
+DELETE FROM `creature_text` WHERE `entry`= @Darn_Valiant;
+INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`, `BroadcastTextId`) VALUES
+(@Darn_Valiant,0,0,'Ready yourself!',12,7,100,0,0,0,'Argent Valiant', 33757),
+(@Darn_Valiant,0,1,'Prepare yourself!',12,7,100,0,0,0,'Argent Valiant', 33755),
+(@Darn_Valiant,0,2,'On your guard!',12,7,100,0,0,0,'Argent Valiant', 33756),
+(@Darn_Valiant,0,3,'Let it begin!',12,7,100,0,0,0,'Argent Valiant', 33758),
+(@Darn_Valiant,1,0,'Victory is mine!',12,7,100,0,0,0,'Argent Valiant', 33777),
+(@Darn_Valiant,1,1,'It seems you still need more practice. Perhaps another time.',12,7,100,0,0,0,'Argent Valiant', 33764),
+(@Darn_Valiant,1,2,'I have won. Better luck another time, friend.',12,7,100,0,0,0,'Argent Valiant', 33779),
+(@Darn_Valiant,1,3,'I am afraid you will need more practice to defeat me.',12,7,100,0,0,0,'Argent Valiant', 33778),
+(@Darn_Valiant,2,0,'I yield to you.',12,7,100,0,0,0,'Argent Valiant', 33774),
+(@Darn_Valiant,2,1,'That was a well fought battle. I yield to you.',12,7,100,0,0,0,'Argent Valiant', 33776),
+(@Darn_Valiant,2,2,'It would seem I underestimated your skills. Well done.',12,7,100,0,0,0,'Argent Valiant', 33775),
+(@Darn_Valiant,2,3,'I have been defeated. Good fight!',12,7,100,0,0,0,'Argent Valiant', 33760);
+SET @Exo_Valiant := 33562;
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@Exo_Valiant;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@Exo_Valiant;
+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
+(@Exo_Valiant,0,0,0,25,0,100,0,0,0,0,0,28,64223,0,0,0,0,0,1,0,0,0,0,0,0,0,'Exo Valiant - On Reset - Remove auras from Defend'),
+(@Exo_Valiant,0,1,2,62,0,100,0,10465,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'Exo Valiant - On gossip select - Close gossip'),
+(@Exo_Valiant,0,2,3,61,0,100,0,0,0,0,0,64,1,0,0,0,0,0,7,0,0,0,0,0,0,0,'Exo_Valiant - Linked with previous event - store target'),
+(@Exo_Valiant,0,3,0,61,0,100,0,0,0,0,0,80,@Script,2,0,0,0,0,1,0,0,0,0,0,0,0,'Exo Valiant - Linked with previous event - Call timed actionlist'),
+(@Exo_Valiant,0,4,0,52,0,100,0,0,@Exo_Valiant,0,0,11,63010,0,0,0,0,0,7,0,0,0,0,0,0,0,'Exo Valiant - On text over - Cast Charge'),
+(@Exo_Valiant,0,5,0,0,0,100,0,0,0,1500,4000,11,62544,0,0,0,0,0,2,0,0,0,0,0,0,0,'Exo Valiant - IC - Cast Thrust'),
+(@Exo_Valiant,0,6,0,9,0,100,0,5,5,9000,10000,11,62575,0,0,0,0,0,2,0,0,0,0,0,0,0,'Exo Valiant - On more than 5 yard range - Cast Shield-Breaker'),
+(@Exo_Valiant,0,7,0,0,0,100,0,9000,11000,9000,10000,46,12,0,0,0,0,0,1,0,0,0,0,0,0,0,'Exo Valiant - IC - Move forward 12 yards'),
+(@Exo_Valiant,0,8,9,9,0,100,0,9,15,3000,3000,11,63010,0,0,0,0,0,2,0,0,0,0,0,0,0,'Exo Valiant - On 10-12 yard range - Cast Charge'),
+(@Exo_Valiant,0,9,0,61,0,100,0,0,0,0,0,11,62575,0,0,0,0,0,2,0,0,0,0,0,0,0,'Exo Valiant - Linked with previous event - Cast Shield-Breaker'),
+(@Exo_Valiant,0,10,11,2,0,100,1,1,3,60000,60000,2,35,0,0,0,0,0,1,0,0,0,0,0,0,0,'Exo Valiant - On HP% between 1% and 3% - Change faction to 35'),
+(@Exo_Valiant,0,11,12,61,0,100,0,0,0,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,'Exo Valiant - Linked with previous event - Say text'),
+(@Exo_Valiant,0,12,13,61,0,100,0,0,0,0,0,85,62724,0,0,0,0,0,12,1,0,0,0,0,0,0,'Exo Valiant - Linked with previous event - Cast Mounted Melee Victory /item/'),
+(@Exo_Valiant,0,13,14,61,0,100,0,0,0,0,0,85,64808,0,0,0,0,0,12,1,0,0,0,0,0,0,'Exo Valiant - Linked with previous event - Cast credit'),
+(@Exo_Valiant,0,14,0,61,0,100,0,0,0,0,0,24,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Exo_Valiant - Linked with previous event - Evade'),
+(@Exo_Valiant,0,15,16,5,0,100,0,60000,60000,1,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Exo Valiant - On player killed - Say text'),
+(@Exo_Valiant,0,16,17,61,0,100,0,0,0,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Exo Valiant - Linked with previous event - Set unseen'),
+(@Exo_Valiant,0,17,0,61,0,100,0,0,0,0,0,41,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Exo Valiant - Linked with previous event - Despawn in 1 ms');
+-- Argent Valiants texts
+DELETE FROM `creature_text` WHERE `entry`= @Exo_Valiant;
+INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`, `BroadcastTextId`) VALUES
+(@Exo_Valiant,0,0,'Ready yourself!',12,7,100,0,0,0,'Argent Valiant', 33757),
+(@Exo_Valiant,0,1,'Prepare yourself!',12,7,100,0,0,0,'Argent Valiant', 33755),
+(@Exo_Valiant,0,2,'On your guard!',12,7,100,0,0,0,'Argent Valiant', 33756),
+(@Exo_Valiant,0,3,'Let it begin!',12,7,100,0,0,0,'Argent Valiant', 33758),
+(@Exo_Valiant,1,0,'Victory is mine!',12,7,100,0,0,0,'Argent Valiant', 33777),
+(@Exo_Valiant,1,1,'It seems you still need more practice. Perhaps another time.',12,7,100,0,0,0,'Argent Valiant', 33764),
+(@Exo_Valiant,1,2,'I have won. Better luck another time, friend.',12,7,100,0,0,0,'Argent Valiant', 33779),
+(@Exo_Valiant,1,3,'I am afraid you will need more practice to defeat me.',12,7,100,0,0,0,'Argent Valiant', 33778),
+(@Exo_Valiant,2,0,'I yield to you.',12,7,100,0,0,0,'Argent Valiant', 33774),
+(@Exo_Valiant,2,1,'That was a well fought battle. I yield to you.',12,7,100,0,0,0,'Argent Valiant', 33776),
+(@Exo_Valiant,2,2,'It would seem I underestimated your skills. Well done.',12,7,100,0,0,0,'Argent Valiant', 33775),
+(@Exo_Valiant,2,3,'I have been defeated. Good fight!',12,7,100,0,0,0,'Argent Valiant', 33760);
+SET @UC_Valiant := 33384;
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@UC_Valiant;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@UC_Valiant;
+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
+(@UC_Valiant,0,0,0,25,0,100,0,0,0,0,0,28,64223,0,0,0,0,0,1,0,0,0,0,0,0,0,'UC Valiant - On Reset - Remove auras from Defend'),
+(@UC_Valiant,0,1,2,62,0,100,0,10473,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'UC Valiant - On gossip select - Close gossip'),
+(@UC_Valiant,0,2,3,61,0,100,0,0,0,0,0,64,1,0,0,0,0,0,7,0,0,0,0,0,0,0,'UC_Valiant - Linked with previous event - store target'),
+(@UC_Valiant,0,3,0,61,0,100,0,0,0,0,0,80,@Script,2,0,0,0,0,1,0,0,0,0,0,0,0,'UC Valiant - Linked with previous event - Call timed actionlist'),
+(@UC_Valiant,0,4,0,52,0,100,0,0,@UC_Valiant,0,0,11,63010,0,0,0,0,0,7,0,0,0,0,0,0,0,'UC Valiant - On text over - Cast Charge'),
+(@UC_Valiant,0,5,0,0,0,100,0,0,0,1500,4000,11,62544,0,0,0,0,0,2,0,0,0,0,0,0,0,'UC Valiant - IC - Cast Thrust'),
+(@UC_Valiant,0,6,0,9,0,100,0,5,5,9000,10000,11,62575,0,0,0,0,0,2,0,0,0,0,0,0,0,'UC Valiant - On more than 5 yard range - Cast Shield-Breaker'),
+(@UC_Valiant,0,7,0,0,0,100,0,9000,11000,9000,10000,46,12,0,0,0,0,0,1,0,0,0,0,0,0,0,'UC Valiant - IC - Move forward 12 yards'),
+(@UC_Valiant,0,8,9,9,0,100,0,9,15,3000,3000,11,63010,0,0,0,0,0,2,0,0,0,0,0,0,0,'UC Valiant - On 10-12 yard range - Cast Charge'),
+(@UC_Valiant,0,9,0,61,0,100,0,0,0,0,0,11,62575,0,0,0,0,0,2,0,0,0,0,0,0,0,'UC Valiant - Linked with previous event - Cast Shield-Breaker'),
+(@UC_Valiant,0,10,11,2,0,100,1,1,3,60000,60000,2,35,0,0,0,0,0,1,0,0,0,0,0,0,0,'UC Valiant - On HP% between 1% and 3% - Change faction to 35'),
+(@UC_Valiant,0,11,12,61,0,100,0,0,0,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,'UC Valiant - Linked with previous event - Say text'),
+(@UC_Valiant,0,12,13,61,0,100,0,0,0,0,0,85,62724,0,0,0,0,0,12,1,0,0,0,0,0,0,'UC Valiant - Linked with previous event - Cast Mounted Melee Victory /item/'),
+(@UC_Valiant,0,13,14,61,0,100,0,0,0,0,0,85,64816,0,0,0,0,0,12,1,0,0,0,0,0,0,'UC Valiant - Linked with previous event - Cast credit'),
+(@UC_Valiant,0,14,0,61,0,100,0,0,0,0,0,24,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'UC_Valiant - Linked with previous event - Evade'),
+(@UC_Valiant,0,15,16,5,0,100,0,60000,60000,1,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'UC Valiant - On player killed - Say text'),
+(@UC_Valiant,0,16,17,61,0,100,0,0,0,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'UC Valiant - Linked with previous event - Set unseen'),
+(@UC_Valiant,0,17,0,61,0,100,0,0,0,0,0,41,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'UC Valiant - Linked with previous event - Despawn in 1 ms');
+-- Argent Valiants texts
+DELETE FROM `creature_text` WHERE `entry`= @UC_Valiant;
+INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`, `BroadcastTextId`) VALUES
+(@UC_Valiant,0,0,'Ready yourself!',12,1,100,0,0,0,'Argent Valiant', 33757),
+(@UC_Valiant,0,1,'Prepare yourself!',12,1,100,0,0,0,'Argent Valiant', 33755),
+(@UC_Valiant,0,2,'On your guard!',12,1,100,0,0,0,'Argent Valiant', 33756),
+(@UC_Valiant,0,3,'Let it begin!',12,1,100,0,0,0,'Argent Valiant', 33758),
+(@UC_Valiant,1,0,'Victory is mine!',12,1,100,0,0,0,'Argent Valiant', 33777),
+(@UC_Valiant,1,1,'It seems you still need more practice. Perhaps another time.',12,1,100,0,0,0,'Argent Valiant', 33764),
+(@UC_Valiant,1,2,'I have won. Better luck another time, friend.',12,1,100,0,0,0,'Argent Valiant', 33779),
+(@UC_Valiant,1,3,'I am afraid you will need more practice to defeat me.',12,1,100,0,0,0,'Argent Valiant', 33778),
+(@UC_Valiant,2,0,'I yield to you.',12,1,100,0,0,0,'Argent Valiant', 33774),
+(@UC_Valiant,2,1,'That was a well fought battle. I yield to you.',12,1,100,0,0,0,'Argent Valiant', 33776),
+(@UC_Valiant,2,2,'It would seem I underestimated your skills. Well done.',12,1,100,0,0,0,'Argent Valiant', 33775),
+(@UC_Valiant,2,3,'I have been defeated. Good fight!',12,1,100,0,0,0,'Argent Valiant', 33760);
+
+DELETE FROM `gossip_menu` WHERE `entry` IN (10469, 10468, 10470, 10472, 10473, 10466, 10464, 10471, 10465, 10467);
+INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES
+(10469, 14384),
+(10469, 14492),
+(10468, 14384),
+(10468, 14492),
+(10470, 14384),
+(10470, 14492),
+(10472, 14384),
+(10472, 14492),
+(10473, 14384),
+(10473, 14492),
+(10466, 14384),
+(10466, 14492),
+(10464, 14384),
+(10464, 14492),
+(10471, 14384),
+(10471, 14492),
+(10465, 14384),
+(10465, 14492),
+(10467, 14384),
+(10467, 14492);
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup` IN (10469, 10468, 10470, 10472, 10473, 10466, 10464, 10471, 10465, 10467);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`, `ErrorTextId`,`ScriptName`,`Comment`, `NegativeCondition`) VALUES
+(14,10469,14384,0,1,64812,0,0,0,'','Show gossip menu text if the player haven''t the aura', 1),
+(14,10469,14492,0,1,64812,0,0,0,'','Show gossip menu text if the player have the aura', 0),
+(14,10468,14384,0,1,64811,0,0,0,'','Show gossip menu text if the player haven''t the aura', 1),
+(14,10468,14492,0,1,64811,0,0,0,'','Show gossip menu text if the player have the aura', 0),
+(14,10470,14384,0,1,64813,0,0,0,'','Show gossip menu text if the player haven''t the aura', 1),
+(14,10470,14492,0,1,64813,0,0,0,'','Show gossip menu text if the player have the aura', 0),
+(14,10472,14384,0,1,64815,0,0,0,'','Show gossip menu text if the player haven''t the aura', 1),
+(14,10472,14492,0,1,64815,0,0,0,'','Show gossip menu text if the player have the aura', 0),
+(14,10473,14384,0,1,64816,0,0,0,'','Show gossip menu text if the player haven''t the aura', 1),
+(14,10473,14492,0,1,64816,0,0,0,'','Show gossip menu text if the player have the aura', 0),
+(14,10466,14384,0,1,64809,0,0,0,'','Show gossip menu text if the player haven''t the aura', 1),
+(14,10466,14492,0,1,64809,0,0,0,'','Show gossip menu text if the player have the aura', 0),
+(14,10464,14384,0,1,64805,0,0,0,'','Show gossip menu text if the player haven''t the aura', 1),
+(14,10464,14492,0,1,64805,0,0,0,'','Show gossip menu text if the player have the aura', 0),
+(14,10471,14384,0,1,64814,0,0,0,'','Show gossip menu text if the player haven''t the aura', 1),
+(14,10471,14492,0,1,64814,0,0,0,'','Show gossip menu text if the player have the aura', 0),
+(14,10465,14384,0,1,64808,0,0,0,'','Show gossip menu text if the player haven''t the aura', 1),
+(14,10465,14492,0,1,64808,0,0,0,'','Show gossip menu text if the player have the aura', 0),
+(14,10467,14384,0,1,64810,0,0,0,'','Show gossip menu text if the player haven''t the aura', 1),
+(14,10467,14492,0,1,64810,0,0,0,'','Show gossip menu text if the player have the aura', 0);