diff options
author | Aokromes <Aokromes@users.noreply.github.com> | 2015-05-09 14:03:20 +0200 |
---|---|---|
committer | Aokromes <Aokromes@users.noreply.github.com> | 2015-05-09 14:03:20 +0200 |
commit | d84f7c5ebd173f7d99bc21b564e356110a3e07be (patch) | |
tree | 3c761bfe02b0ae91b36a9abca2bb2cbd9a5b27cf | |
parent | fe70377b1bcf73f4e35cb4c26e0e106e91313fbd (diff) |
DB/Misc: The Grand Melee
By Killyana, closes #14603
-rw-r--r-- | sql/updates/world/2015_05_09_05_world.sql | 835 |
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); |