Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Jul 31st, 2012  |  syntax: None  |  size: 61.20 KB  |  hits: 19  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. -- A Chip Off the Ulduar Block
  2. UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=33435;
  3. DELETE FROM `creature_questrelation` WHERE `quest`=13681;
  4. INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES
  5. (33435, 13681);
  6. DELETE FROM `creature_involvedrelation` WHERE `quest`=13681;
  7. INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES
  8. (33435, 13681);
  9. SET @GO_SBLOCK := 900101;
  10. DELETE FROM `gameobject` WHERE `id`=194461;
  11. INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
  12. (@GO_SBLOCK, 194461, 571, 1, 1, 7652.58, -1007.84, 910.189, 1.52205, 0, 0, 0.689663, 0.72413, 300, 0, 1),
  13. (@GO_SBLOCK+1, 194461, 571, 1, 1, 7787.41, -1041.7, 962.852, 2.77736, 0, 0, 0.983463, 0.18111, 300, 0, 1),
  14. (@GO_SBLOCK+2, 194461, 571, 1, 1, 7277.52, -853.137, 927.42, 0.443636, 0, 0, 0.220003, 0.975499, 300, 0, 1),
  15. (@GO_SBLOCK+3, 194461, 571, 1, 1, 7716.48, -1072.21, 919.808, 0.430193, 0, 0, 0.213442, 0.976956, 300, 0, 1),
  16. (@GO_SBLOCK+4, 194461, 571, 1, 1, 7403.1, -854.007, 920.523, 2.54684, 0, 0, 0.956108, 0.293013, 300, 0, 1),
  17. (@GO_SBLOCK+5, 194461, 571, 1, 1, 8102.84, -1020.1, 936.523, 5.45407, 0, 0, 0.402785, -0.915295, 300, 0, 1),
  18. (@GO_SBLOCK+6, 194461, 571, 1, 1, 8204.35, -1139.17, 928.227, 5.80531, 0, 0, 0.236668, -0.97159, 300, 0, 1),
  19. (@GO_SBLOCK+7, 194461, 571, 1, 1, 8229.81, -1044.96, 923.874, 5.04234, 0, 0, 0.581379, -0.813633, 300, 0, 1),
  20. (@GO_SBLOCK+8, 194461, 571, 1, 1, 8309.5, -1057.97, 923.874, 2.47823, 0, 0, 0.945497, 0.325632, 300, 0, 1),
  21. (@GO_SBLOCK+9, 194461, 571, 1, 1, 8113.47, -1090.97, 928.014, 0.0838518, 0, 0, 0.0419136, 0.999121, 300, 0, 1),
  22. (@GO_SBLOCK+10, 194461, 571, 1, 1, 8225.12, -908.638, 924.89, 1.17446, 0, 0, 0.554058, 0.832478, 300, 0, 1),
  23. (@GO_SBLOCK+11, 194461, 571, 1, 1, 8145.76, -938.17, 956.536, 0.0998165, 0, 0, 0.0498875, 0.998755, 300, 0, 1),
  24. (@GO_SBLOCK+12, 194461, 571, 1, 1, 8112.04, -830.939, 957.941, 3.88413, 0, 0, 0.931868, -0.362796, 300, 0, 1),
  25. (@GO_SBLOCK+13, 194461, 571, 1, 1, 8176.38, -749.3, 928.853, 5.07335, 0, 0, 0.568695, -0.822549, 300, 0, 1),
  26. (@GO_SBLOCK+14, 194461, 571, 1, 1, 8223.27, -812.829, 926.654, 5.58167, 0, 0, 0.343608, -0.939113, 300, 0, 1),
  27. (@GO_SBLOCK+15, 194461, 571, 1, 1, 8382.91, -975.986, 909.193, 3.87475, 0, 0, 0.933559, -0.358423, 300, 0, 1),
  28. (@GO_SBLOCK+16, 194461, 571, 1, 1, 7989.92, -1082.12, 1046.78, 0.559582, 0, 0, 0.276155, 0.961113, 300, 0, 1);
  29. -- Stone Block Bunny
  30. DELETE FROM `creature_template` WHERE `entry` IN (900106, 900107);
  31. INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `inhabitType`, `HoverHeight`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES
  32. (900106, 0, 0, 0, 0, 0, 19725, 13069, 0, 0, 'Stone Block Bunny', '', '', 0, 1, 1, 0, 35, 35, 0, 1, 1.14286, 1, 0, 2, 2, 0, 24, 1, 2000, 0, 1, 0, 8, 0, 0, 0, 0, 0, 1, 1, 0, 10, 1024, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'SmartAI', 0, 3, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 128, '', 12340),
  33. (900107, 0, 0, 0, 0, 0, 19725, 13069, 0, 0, 'Stone Block Bunny 2', '', '', 0, 1, 1, 0, 35, 35, 0, 1, 1.14286, 1, 0, 2, 2, 0, 24, 1, 2000, 0, 1, 0, 8, 0, 0, 0, 0, 0, 1, 1, 0, 10, 1024, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 128, '', 12340);
  34. -- SAI
  35. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN (33660, 900106);
  36. DELETE FROM `smart_scripts` WHERE `entryorguid` IN (33660, 900106) AND `source_type` IN (0, 9);
  37. 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
  38. -- Goblin Chisel
  39. (33660, 0, 0, 0, 1, 0, 100, 1, 0, 0, 0, 0, 12, 900106, 3, 60000, 0, 0, 0, 15, 194461, 30, 0, 0, 0, 0, 0, 'Goblin Chisel - OOC - cast Bunny'),
  40. (33660, 0, 1, 0, 1, 0, 100, 1, 0, 0, 0, 0, 12, 900106, 3, 60000, 0, 0, 0, 15, 194461, 30, 0, 0, 0, 0, 0, 'Goblin Chisel - OOC - cast Bunny'),
  41. (33660, 0, 2, 0, 1, 0, 100, 1, 0, 0, 0, 0, 12, 900106, 3, 60000, 0, 0, 0, 15, 194461, 30, 0, 0, 0, 0, 0, 'Goblin Chisel - OOC - cast Bunny'),
  42. (33660, 0, 3, 0, 1, 0, 100, 1, 0, 0, 0, 0, 12, 900106, 3, 60000, 0, 0, 0, 15, 194461, 30, 0, 0, 0, 0, 0, 'Goblin Chisel - OOC - cast Bunny'),
  43. (33660, 0, 4, 0, 1, 0, 100, 1, 0, 0, 0, 0, 255, 60, 0, 0, 0, 0, 0, 11, 900107, 30, 0, 0, 0, 0, 0, 'Goblin Chisel - OOC - kill bunny'),
  44. (33660, 0, 5, 0, 1, 0, 100, 1, 5500, 5500, 0, 0, 11, 20476, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Goblin Chisel - OOC - cast exploze'),
  45. (33660, 0, 6, 0, 1, 0, 100, 1, 5500, 5500, 0, 0, 255, 60, 0, 0, 0, 0, 0, 15, 194461, 30, 0, 0, 0, 0, 0, 'Goblin Chisel - OOC - despawn Stone Block'),
  46. -- Stone Block Bunny
  47. (900106, 0, 0, 0, 1, 0, 100, 1, 0, 0, 0, 0, 59, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Bunny - OOC - switch run'),
  48. (900106, 0, 1, 0, 1, 0, 100, 1, 100, 100, 0, 0, 89, 5, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Bunny - OOC - random move'),
  49. (900106, 0, 2, 0, 1, 0, 100, 1, 5500, 5500, 0, 0, 50, 194463, 60, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Bunny - OOC - summon Small Stone Block');
  50. -- loot
  51. UPDATE `gameobject_template` SET `data1`=90000 WHERE `entry`=194463;
  52. DELETE FROM `gameobject_loot_template` WHERE `entry`=90000;
  53. INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
  54. (90000, 45278, -100, 1, 0, 1, 1);
  55.  
  56. -- Jack Me Some Lumber
  57. UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=33434;
  58. DELETE FROM `creature_questrelation` WHERE `quest`=13627;
  59. INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES
  60. (33434, 13627);
  61. DELETE FROM `creature_involvedrelation` WHERE `quest`=13627;
  62. INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES
  63. (33434, 13627);
  64.  
  65. -- The Blastbolt Brothers
  66. DELETE FROM `creature_questrelation` WHERE `quest`=13820;
  67. INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES
  68. (33817, 13820);
  69. DELETE FROM `creature_involvedrelation` WHERE `quest`=13820;
  70. INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES
  71. (33434, 13820);
  72. UPDATE `quest_template` SET `NextQuestId`=13681 WHERE `Id`=13820;
  73. UPDATE `quest_template` SET `PrevQuestId`=13820 WHERE `Id`=13627;
  74.  
  75. -- Mastery of Melee/Charge/Shield Breaker
  76. -- Argent Tournament trainers part
  77. -- variables
  78. SET @SPELL_ON_ARGENT_MOUNT         := 63034;
  79. SET @NPC_JAERAN_LOCKWOOD           := 33973;
  80. SET @QUEST_MASTERY_OF_MELEE_A      := 13828;
  81. SET @QUEST_MASTERY_OF_MELEE_H      := 13829;
  82. SET @GOSSIP_MENU_JERAN_MOUNTED     := 10398;
  83. SET @GOSSIP_MENU_JERAN_EXPLANATION := 10397;
  84. SET @GOSSIP_TEXT_JERAN_MOUNTED     := 14431;
  85. SET @GOSSIP_TEXT_JERAN_EXPLANATION := 14434;
  86. SET @SPELL_CREDIT_JERAN            := 64113;
  87. SET @NPC_RUGAN_STEELBELLY          := 33972;
  88. SET @QUEST_MASTERY_OF_CHARGE_A     := 13837;
  89. SET @QUEST_MASTERY_OF_CHARGE_H     := 13839;
  90. SET @GOSSIP_MENU_RUGAN_MOUNTED     := 10400;
  91. SET @GOSSIP_MENU_RUGAN_EXPLANATION := 10399;
  92. SET @GOSSIP_TEXT_RUGAN_MOUNTED     := 14436;
  93. SET @GOSSIP_TEXT_RUGAN_EXPLANATION := 14437;
  94. SET @SPELL_CREDIT_RUGAN            := 64114;
  95. SET @NPC_VALIS_WINDCHASER          := 33974;
  96. SET @QUEST_MASTERY_OF_SH_BREAKER_A := 13835;
  97. SET @QUEST_MASTERY_OF_SH_BREAKER_H := 13838;
  98. SET @GOSSIP_MENU_VALIS_MOUNTED     := 10402;
  99. SET @GOSSIP_MENU_VALIS_EXPLANATION := 10401;
  100. SET @GOSSIP_TEXT_VALIS_MOUNTED     := 14438;
  101. SET @GOSSIP_TEXT_VALIS_EXPLANATION := 14439;
  102. SET @SPELL_CREDIT_VALIS            := 64115;
  103. -- SAI
  104. UPDATE `creature_template` SET `AIName`='SmartAI', `ScriptName`='' WHERE `entry` IN (@NPC_JAERAN_LOCKWOOD, @NPC_RUGAN_STEELBELLY, @NPC_VALIS_WINDCHASER);
  105. DELETE FROM `smart_scripts` WHERE `entryorguid` IN (@NPC_JAERAN_LOCKWOOD, @NPC_RUGAN_STEELBELLY, @NPC_VALIS_WINDCHASER) AND `source_type`=0;
  106. 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
  107. (@NPC_JAERAN_LOCKWOOD, 0, 0, 0, 64, 0, 100, 0, 0, 0, 0, 0, 98, @GOSSIP_MENU_JERAN_MOUNTED, @GOSSIP_TEXT_JERAN_MOUNTED, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Jeran Lockwood - Send different gossip when mounted (Requires conditions)'),
  108. (@NPC_JAERAN_LOCKWOOD, 0, 1, 3, 62, 0, 100, 0, @GOSSIP_MENU_JERAN_MOUNTED, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Jeran Lockwood - Send text when option clicked'),
  109. (@NPC_JAERAN_LOCKWOOD, 0, 2, 3, 62, 0, 100, 0, @GOSSIP_MENU_JERAN_EXPLANATION, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Jeran Lockwood - Send text when option clicked'),
  110. (@NPC_JAERAN_LOCKWOOD, 0, 3, 4, 61, 0, 100, 0, 0, 0, 0, 0, 11, @SPELL_CREDIT_JERAN, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Jeran Lockwood - Give Credit'),
  111. (@NPC_JAERAN_LOCKWOOD, 0, 4, 0, 61, 0, 100, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Jeran Lockwood - Close Gossip'),
  112. (@NPC_RUGAN_STEELBELLY, 0, 0, 0, 64, 0, 100, 0, 0, 0, 0, 0, 98, @GOSSIP_MENU_RUGAN_MOUNTED, @GOSSIP_TEXT_RUGAN_MOUNTED, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Rugan Steelbelly - Send different gossip when mounted (Requires conditions)'),
  113. (@NPC_RUGAN_STEELBELLY, 0, 1, 3, 62, 0, 100, 0, @GOSSIP_MENU_RUGAN_MOUNTED, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Rugan Steelbelly - Send text when option clicked'),
  114. (@NPC_RUGAN_STEELBELLY, 0, 2, 3, 62, 0, 100, 0, @GOSSIP_MENU_RUGAN_EXPLANATION, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Rugan Steelbelly - Send text when option clicked'),
  115. (@NPC_RUGAN_STEELBELLY, 0, 3, 4, 61, 0, 100, 0, 0, 0, 0, 0, 11, @SPELL_CREDIT_RUGAN, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Rugan Steelbelly - Give Credit'),
  116. (@NPC_RUGAN_STEELBELLY, 0, 4, 0, 61, 0, 100, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Rugan Steelbelly - Close Gossip'),
  117. (@NPC_VALIS_WINDCHASER, 0, 0, 0, 64, 0, 100, 0, 0, 0, 0, 0, 98, @GOSSIP_MENU_VALIS_MOUNTED, @GOSSIP_TEXT_VALIS_MOUNTED, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Valis Windchaser - Send different gossip when mounted (Requires conditions)'),
  118. (@NPC_VALIS_WINDCHASER, 0, 1, 3, 62, 0, 100, 0, @GOSSIP_MENU_VALIS_MOUNTED, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Valis Windchaser - Send text when option clicked'),
  119. (@NPC_VALIS_WINDCHASER, 0, 2, 3, 62, 0, 100, 0, @GOSSIP_TEXT_VALIS_EXPLANATION, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Valis Windchaser - Send text when option clicked'),
  120. (@NPC_VALIS_WINDCHASER, 0, 3, 4, 61, 0, 100, 0, 0, 0, 0, 0, 11, @SPELL_CREDIT_VALIS, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Valis Windchaser - Give Credit'),
  121. (@NPC_VALIS_WINDCHASER, 0, 4, 0, 61, 0, 100, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Valis Windchaser - Close Gossip');
  122. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceEntry` IN (@NPC_JAERAN_LOCKWOOD, @NPC_RUGAN_STEELBELLY, @NPC_VALIS_WINDCHASER);
  123. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup` IN (@GOSSIP_MENU_JERAN_MOUNTED, @GOSSIP_MENU_RUGAN_MOUNTED, @GOSSIP_MENU_VALIS_MOUNTED);
  124. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  125. (22, 1, @NPC_JAERAN_LOCKWOOD, 0, 0, 1, 0, @SPELL_ON_ARGENT_MOUNT, 0, 0, 0, '', 'SAI - Jeran Lockwood show different menu if player mounted'),
  126. (15, @GOSSIP_MENU_JERAN_MOUNTED, 0, 0, 0, 9, 0, @QUEST_MASTERY_OF_MELEE_A, 0, 0, 0, '', 'Jeran Lockwood - Show gossip if player has quest'),
  127. (15, @GOSSIP_MENU_JERAN_MOUNTED, 0, 0, 0, 1, 0, @SPELL_ON_ARGENT_MOUNT, 0, 0, 0, '', 'Jeran Lockwood - Show gossip if player has aura'),
  128. (15, @GOSSIP_MENU_JERAN_MOUNTED, 0, 0, 1, 9, 0, @QUEST_MASTERY_OF_MELEE_H, 0, 0, 0, '', 'Jeran Lockwood - Show gossip if player has quest'),
  129. (15, @GOSSIP_MENU_JERAN_MOUNTED, 0, 0, 1, 1, 0, @SPELL_ON_ARGENT_MOUNT, 0, 0, 0, '', 'Jeran Lockwood - Show gossip if player has aura'),
  130. (15, @GOSSIP_MENU_JERAN_MOUNTED, 1, 0, 0, 9, 0, @QUEST_MASTERY_OF_MELEE_A, 0, 0, 0, '', 'Jeran Lockwood - Show gossip if player has quest'),
  131. (15, @GOSSIP_MENU_JERAN_MOUNTED, 1, 0, 0, 1, 0, @SPELL_ON_ARGENT_MOUNT, 0, 0, 0, '', 'Jeran Lockwood - Show gossip if player has aura'),
  132. (15, @GOSSIP_MENU_JERAN_MOUNTED, 1, 0, 1, 9, 0, @QUEST_MASTERY_OF_MELEE_H, 0, 0, 0, '', 'Jeran Lockwood - Show gossip if player has quest'),
  133. (15, @GOSSIP_MENU_JERAN_MOUNTED, 1, 0, 1, 1, 0, @SPELL_ON_ARGENT_MOUNT, 0, 0, 0, '', 'Jeran Lockwood - Show gossip if player has aura'),
  134. (22, 1, @NPC_RUGAN_STEELBELLY, 0, 0, 1, 0, @SPELL_ON_ARGENT_MOUNT, 0, 0, 0, '', 'SAI - Rugan Steelbelly show different menu if player mounted'),
  135. (15, @GOSSIP_MENU_RUGAN_MOUNTED, 0, 0, 0, 9, 0, @QUEST_MASTERY_OF_CHARGE_A, 0, 0, 0, '', 'Rugan Steelbelly - Show gossip if player has quest'),
  136. (15, @GOSSIP_MENU_RUGAN_MOUNTED, 0, 0, 0, 1, 0, @SPELL_ON_ARGENT_MOUNT, 0, 0, 0, '', 'Rugan Steelbelly - Show gossip if player has aura'),
  137. (15, @GOSSIP_MENU_RUGAN_MOUNTED, 0, 0, 1, 9, 0, @QUEST_MASTERY_OF_CHARGE_H, 0, 0, 0, '', 'Rugan Steelbelly - Show gossip if player has quest'),
  138. (15, @GOSSIP_MENU_RUGAN_MOUNTED, 0, 0, 1, 1, 0, @SPELL_ON_ARGENT_MOUNT, 0, 0, 0, '', 'Rugan Steelbelly - Show gossip if player has aura'),
  139. (15, @GOSSIP_MENU_RUGAN_MOUNTED, 1, 0, 0, 9, 0, @QUEST_MASTERY_OF_CHARGE_A, 0, 0, 0, '', 'Rugan Steelbelly - Show gossip if player has quest'),
  140. (15, @GOSSIP_MENU_RUGAN_MOUNTED, 1, 0, 0, 1, 0, @SPELL_ON_ARGENT_MOUNT, 0, 0, 0, '', 'Rugan Steelbelly - Show gossip if player has aura'),
  141. (15, @GOSSIP_MENU_RUGAN_MOUNTED, 1, 0, 1, 9, 0, @QUEST_MASTERY_OF_CHARGE_H, 0, 0, 0, '', 'Rugan Steelbelly - Show gossip if player has quest'),
  142. (15, @GOSSIP_MENU_RUGAN_MOUNTED, 1, 0, 1, 1, 0, @SPELL_ON_ARGENT_MOUNT, 0, 0, 0, '', 'Rugan Steelbelly - Show gossip if player has aura'),
  143. (22, 1, @NPC_VALIS_WINDCHASER, 0, 0, 1, 0, @SPELL_ON_ARGENT_MOUNT, 0, 0, 0, '', 'SAI - Valis Windchaser show different menu if player mounted'),
  144. (15, @GOSSIP_MENU_VALIS_MOUNTED, 0, 0, 0, 9, 0, @QUEST_MASTERY_OF_SH_BREAKER_A, 0, 0, 0, '', 'Valis Windchaser - Show gossip if player has quest'),
  145. (15, @GOSSIP_MENU_VALIS_MOUNTED, 0, 0, 0, 1, 0, @SPELL_ON_ARGENT_MOUNT, 0, 0, 0, '', 'Valis Windchaser - Show gossip if player has aura'),
  146. (15, @GOSSIP_MENU_VALIS_MOUNTED, 0, 0, 1, 9, 0, @QUEST_MASTERY_OF_SH_BREAKER_H, 0, 0, 0, '', 'Valis Windchaser - Show gossip if player has quest'),
  147. (15, @GOSSIP_MENU_VALIS_MOUNTED, 0, 0, 1, 1, 0, @SPELL_ON_ARGENT_MOUNT, 0, 0, 0, '', 'Valis Windchaser - Show gossip if player has aura'),
  148. (15, @GOSSIP_MENU_VALIS_MOUNTED, 1, 0, 0, 9, 0, @QUEST_MASTERY_OF_SH_BREAKER_A, 0, 0, 0, '', 'Valis Windchaser - Show gossip if player has quest'),
  149. (15, @GOSSIP_MENU_VALIS_MOUNTED, 1, 0, 0, 1, 0, @SPELL_ON_ARGENT_MOUNT, 0, 0, 0, '', 'Valis Windchaser - Show gossip if player has aura'),
  150. (15, @GOSSIP_MENU_VALIS_MOUNTED, 1, 0, 1, 9, 0, @QUEST_MASTERY_OF_SH_BREAKER_H, 0, 0, 0, '', 'Valis Windchaser - Show gossip if player has quest'),
  151. (15, @GOSSIP_MENU_VALIS_MOUNTED, 1, 0, 1, 1, 0, @SPELL_ON_ARGENT_MOUNT, 0, 0, 0, '', 'Valis Windchaser - Show gossip if player has aura');
  152. DELETE FROM `gossip_menu` WHERE `entry` IN (@GOSSIP_MENU_JERAN_EXPLANATION, @GOSSIP_MENU_RUGAN_EXPLANATION, @GOSSIP_MENU_VALIS_EXPLANATION);
  153. INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES
  154. (@GOSSIP_MENU_JERAN_EXPLANATION, @GOSSIP_TEXT_JERAN_EXPLANATION),
  155. (@GOSSIP_MENU_RUGAN_EXPLANATION, @GOSSIP_TEXT_RUGAN_EXPLANATION),
  156. (@GOSSIP_MENU_VALIS_EXPLANATION, @GOSSIP_TEXT_VALIS_EXPLANATION);
  157. DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (@GOSSIP_MENU_JERAN_MOUNTED, @GOSSIP_MENU_JERAN_EXPLANATION, @GOSSIP_MENU_RUGAN_MOUNTED, @GOSSIP_MENU_RUGAN_EXPLANATION, @GOSSIP_MENU_VALIS_MOUNTED, @GOSSIP_MENU_VALIS_EXPLANATION);
  158. INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`) VALUES
  159. (@GOSSIP_MENU_JERAN_MOUNTED, 0, 0, 'Show me how to train with a Melee Target.', 1, 1, 0, 0, 0, 0, ''),
  160. (@GOSSIP_MENU_JERAN_MOUNTED, 1, 0, 'Tell me more about Defend and Thrust!', 1, 1, @GOSSIP_MENU_JERAN_EXPLANATION, 0, 0, 0, ''),
  161. (@GOSSIP_MENU_JERAN_EXPLANATION, 0, 0, 'Show me how to train with a Melee Target.', 1, 1, 0, 0, 0, 0, ''),
  162. (@GOSSIP_MENU_RUGAN_MOUNTED, 0, 0, 'Show me how to train with a Charge Target.', 1, 1, 0, 0, 0, 0, ''),
  163. (@GOSSIP_MENU_RUGAN_MOUNTED, 1, 0, 'Tell me more about the Charge!', 1, 1, @GOSSIP_MENU_RUGAN_EXPLANATION, 0, 0, 0, ''),
  164. (@GOSSIP_MENU_RUGAN_EXPLANATION, 0, 0, 'Show me how to train with a Charge Target.', 1, 1, 0, 0, 0, 0, ''),
  165. (@GOSSIP_MENU_VALIS_MOUNTED, 0, 0, 'Show me how to train with a Ranged Target.', 1, 1, 0, 0, 0, 0, ''),
  166. (@GOSSIP_MENU_VALIS_MOUNTED, 1, 0, 'Tell me more about the Shield-Breaker!', 1, 1, @GOSSIP_MENU_VALIS_EXPLANATION, 0, 0, 0, ''),
  167. (@GOSSIP_MENU_VALIS_EXPLANATION, 0, 0, 'Show me how to train with a Ranged Target.', 1, 1, 0, 0, 0, 0, '');
  168. DELETE FROM `creature_text` WHERE `entry` IN (@NPC_JAERAN_LOCKWOOD, @NPC_RUGAN_STEELBELLY, @NPC_VALIS_WINDCHASER);
  169. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES
  170. (@NPC_JAERAN_LOCKWOOD, 0, 0, 'Put up defend$B|TInterface\\Icons\\ability_warrior_shieldmastery.blp:32|t$BThen use Thrust on a Melee Target$B|TInterface\\Icons\\inv_sword_65.blp:32|t', 42, 0, 0, 0, 0, 0, 'Argent Tournament - Melee Tutorial'),
  171. (@NPC_RUGAN_STEELBELLY, 0, 0, 'Use Shield-Breaker on a Charge Target$B|TInterface\\Icons\\ability_warrior_shieldbreak.blp:32|t$BFollow up with Charge while the target is vulnerable$B|TInterface\\Icons\\ability_mount_charger.blp:32|t', 42, 0, 0, 0, 0, 0, 'Argent Tournament - Charge Tutorial'),
  172. (@NPC_VALIS_WINDCHASER, 0, 0, 'Use Shield-Breaker on a Ranged Target$B|TInterface\\Icons\\ability_warrior_shieldbreak.blp:32|t$BThen use Shield-Breaker while the target is defenseless$B|TInterface\\Icons\\ability_warrior_shieldbreak.blp:32|t', 42, 0, 0, 0, 0, 0, 'Argent Tournament - Ranged Tutorial');
  173.  
  174. -- Training Dummies Part
  175. UPDATE `creature_template` SET `ScriptName`='npc_tournament_training_dummy' WHERE `entry` IN (33272, 33229, 33243);
  176. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=62709;
  177. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  178. (13, 3, 62709, 0, 0, 18, 1, 33845, 0, 0, '', 'Counterattack! (Argent Tournament) - Target near aspirant mounts'),
  179. (13, 3, 62709, 0, 1, 18, 1, 33323, 0, 0, '', 'Counterattack! (Argent Tournament) - Target near aspirant mounts');
  180. DELETE FROM `spell_script_names` WHERE `spell_id`=62709;
  181. INSERT INTO `spell_script_names` VALUES (62709, 'spell_gen_tournament_counterattack');
  182. -- vehicle
  183. DELETE FROM `mq_vehicle_data` WHERE `entry`=349;
  184. INSERT INTO `mq_vehicle_data` (`entry`, `flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `spell9`, `spell10`, `linked_auras`, `speed_walk`, `speed_run`, `speed_run_back`, `speed_swim`, `speed_swim_back`, `speed_turn_rate`, `speed_flight`, `speed_flight_back`, `speed_pitch_rate`) values
  185. (349, 0, 62544, 62575, 62960, 62552, 64077, 62863, 63034, 0, 0, 0, '', 1.2, 1, 1, 1, 1, 1, 1, 1, 1);
  186. UPDATE `creature_template` SET `spell1`=0, `spell2`=0, `spell3`=0, `spell4`=0, `spell5`=0, `spell6`=0, `spell7`=0 WHERE `entry`=33845;
  187.  
  188. -- A Blade Fit For A Champion (all versions)
  189. SET @MAIDEN          := 33220; -- Maiden of Ashwood Lake
  190. SET @FROG            := 33224; -- Lake Frog
  191. SET @FROG_BAD        := 33211; -- Lake Frog
  192. SET @SPELL_TRANSFORM := 62550; -- Maiden of Ashwood Lake Transform
  193. SET @SPELL_SWORD     := 62554; -- Summon Ashwood Brand
  194. SET @SPELL_KISS      := 62536; -- Frog Kiss (removes potion)
  195. SET @SPELL_FROG_LOVE := 62537; -- Frog Love
  196. SET @SPELL_WARTS     := 62581; -- Warts!
  197. SET @SPELL_BALM      := 62574; -- Warts-B-Gone Lip Balm
  198. UPDATE `creature_template` SET `AIName`='SmartAI', `npcflag`=0, `ScriptName`='' WHERE `entry`=@FROG;
  199. UPDATE `creature_template` SET `AIName`='SmartAI', `npcflag`=0, `ScriptName`='' WHERE `entry`=@FROG_BAD;
  200. UPDATE `creature` SET `spawndist`=3, `MovementType`=1 WHERE `id` IN (@FROG, @FROG_BAD);
  201. DELETE FROM `smart_scripts` WHERE `entryorguid` IN (@FROG, @FROG_BAD) AND `source_type`=0;
  202. 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
  203. (@FROG, 0, 0, 1, 22, 0, 100, 1, 58, 0, 0, 0, 11, @SPELL_WARTS, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'On emote - Cast spell - Invoker'),
  204. (@FROG, 0, 1, 2, 61, 0, 100, 1, 0, 0, 0, 0, 11, @SPELL_KISS, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'On link - Cast spell - Invoker'),
  205. (@FROG, 0, 2, 3, 61, 0, 100, 1, 0, 0, 0, 0, 11, @SPELL_FROG_LOVE, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On Link - Cast spell - Self'),
  206. (@FROG, 0, 3, 4, 61, 0, 100, 1, 0, 0, 0, 0, 29, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'On Link - Follow - Invoker'),
  207. (@FROG, 0, 4, 0, 61, 0, 100, 1, 0, 0, 0, 0, 41, 60000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On Link - Force despawn 1 min - Self'),
  208. (@FROG, 0, 5, 6, 22, 0, 100, 1, 58, 0, 0, 0, 11, @SPELL_TRANSFORM, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On emote - Cast spell - Self'),
  209. (@FROG, 0, 6, 0, 61, 0, 100, 1, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On link - Set phase 1 - Self'),
  210. (@FROG, 0, 7, 8, 23, 1, 100, 1, @SPELL_TRANSFORM, 1, 0, 0, 81, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On aura - Set flag - Self'),
  211. (@FROG, 0, 8, 0, 61, 1, 100, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On link - Say - Self'),
  212. (@FROG, 0, 9, 0, 62, 1, 100, 0, 10316, 0, 0, 0, 11, @SPELL_SWORD, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'On Gossip select - Cast spel - Invoker'),
  213. (@FROG, 0, 10, 0, 60, 1, 100, 1, 55000, 55000, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On update 1 min - Say - Self'),
  214. (@FROG, 0, 11, 12, 60, 1, 100, 1, 60000, 60000, 0, 0, 81, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On update 1 min - Set flag - Self'),
  215. (@FROG, 0, 12, 13, 61, 1, 100, 1, 0, 0, 0, 0, 28, @SPELL_TRANSFORM, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On link - Remove aura - Self'),
  216. (@FROG, 0, 13, 0, 61, 1, 100, 1, 0, 0, 0, 0, 41, 1000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On link - Force despawn - Self'),
  217. (@FROG_BAD, 0, 0, 1, 22, 0, 100, 1, 58, 0, 0, 0, 11, @SPELL_WARTS, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'On emote - Cast spell - Invoker'),
  218. (@FROG_BAD, 0, 1, 2, 61, 0, 100, 1, 0, 0, 0, 0, 11, @SPELL_KISS, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'On link - Cast spell - Invoker'),
  219. (@FROG_BAD, 0, 2, 3, 61, 0, 100, 1, 0, 0, 0, 0, 11, @SPELL_FROG_LOVE, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On Link - Cast spell - Self'),
  220. (@FROG_BAD, 0, 3, 4, 61, 0, 100, 1, 0, 0, 0, 0, 29, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'On Link - Follow - Invoker'),
  221. (@FROG_BAD, 0, 4, 0, 61, 0, 100, 1, 0, 0, 0, 0, 41, 60000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On Link - Force despawn 1 min - Self');
  222. DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (@SPELL_KISS, @SPELL_BALM);
  223. INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES
  224. (@SPELL_KISS, -@SPELL_BALM, 1, 'Frog Kiss spellhit removes Warts-B-Gone Lip Balm'), -- using this instead of scripting the dummy effect of spell to remove
  225. (@SPELL_BALM, -@SPELL_WARTS, 2, 'Warts-B-Gone Lip Balm makes caster immune to Warts!');
  226. DELETE FROM `creature_text` WHERE `entry`=@FROG;
  227. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES
  228. (@FROG, 0, 0, 'Can it really be? Free after all these years?', 12, 0, 100, 1, 0, 0, 'say text and emote talk'),
  229. (@FROG, 1, 0, 'And now, I must return to the waters of the lake.', 12, 0, 100, 2, 0, 0, 'say text and emote talk');
  230. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceEntry`=@FROG;
  231. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  232. (22, 1, @FROG, 0, 0, 14, 0, 13666, 0, 0, 0, 0, '', 'execute sai only if player doesn''t have quest taken'),
  233. (22, 1, @FROG, 0, 0, 14, 0, 13603, 0, 0, 0, 0, '', 'execute sai only if player doesn''t have quest taken'),
  234. (22, 1, @FROG, 0, 0, 14, 0, 13741, 0, 0, 0, 0, '', 'execute sai only if player doesn''t have quest taken'),
  235. (22, 1, @FROG, 0, 0, 14, 0, 13746, 0, 0, 0, 0, '', 'execute sai only if player doesn''t have quest taken'),
  236. (22, 1, @FROG, 0, 0, 14, 0, 13752, 0, 0, 0, 0, '', 'execute sai only if player doesn''t have quest taken'),
  237. (22, 1, @FROG, 0, 0, 14, 0, 13757, 0, 0, 0, 0, '', 'execute sai only if player doesn''t have quest taken'),
  238. (22, 1, @FROG, 0, 0, 14, 0, 13673, 0, 0, 0, 0, '', 'execute sai only if player doesn''t have quest taken'),
  239. (22, 1, @FROG, 0, 0, 14, 0, 13762, 0, 0, 0, 0, '', 'execute sai only if player doesn''t have quest taken'),
  240. (22, 1, @FROG, 0, 0, 14, 0, 13768, 0, 0, 0, 0, '', 'execute sai only if player doesn''t have quest taken'),
  241. (22, 1, @FROG, 0, 0, 14, 0, 13773, 0, 0, 0, 0, '', 'execute sai only if player doesn''t have quest taken'),
  242. (22, 1, @FROG, 0, 0, 14, 0, 13778, 0, 0, 0, 0, '', 'execute sai only if player doesn''t have quest taken'),
  243. (22, 1, @FROG, 0, 0, 14, 0, 13783, 0, 0, 0, 0, '', 'execute sai only if player doesn''t have quest taken'),
  244. (22, 6, @FROG, 0, 0, 9, 0, 13666, 0, 0, 0, 0, '', 'execute sai only if player has quest taken'),
  245. (22, 6, @FROG, 0, 1, 9, 0, 13603, 0, 0, 0, 0, '', 'execute sai only if player has quest taken'),
  246. (22, 6, @FROG, 0, 2, 9, 0, 13741, 0, 0, 0, 0, '', 'execute sai only if player has quest taken'),
  247. (22, 6, @FROG, 0, 3, 9, 0, 13746, 0, 0, 0, 0, '', 'execute sai only if player has quest taken'),
  248. (22, 6, @FROG, 0, 4, 9, 0, 13752, 0, 0, 0, 0, '', 'execute sai only if player has quest taken'),
  249. (22, 6, @FROG, 0, 5, 9, 0, 13757, 0, 0, 0, 0, '', 'execute sai only if player has quest taken'),
  250. (22, 6, @FROG, 0, 6, 9, 0, 13673, 0, 0, 0, 0, '', 'execute sai only if player has quest taken'),
  251. (22, 6, @FROG, 0, 7, 9, 0, 13762, 0, 0, 0, 0, '', 'execute sai only if player has quest taken'),
  252. (22, 6, @FROG, 0, 8, 9, 0, 13768, 0, 0, 0, 0, '', 'execute sai only if player has quest taken'),
  253. (22, 6, @FROG, 0, 9, 9, 0, 13773, 0, 0, 0, 0, '', 'execute sai only if player has quest taken'),
  254. (22, 6, @FROG, 0, 10, 9, 0, 13778, 0, 0, 0, 0, '', 'execute sai only if player has quest taken'),
  255. (22, 6, @FROG, 0, 11, 9, 0, 13783, 0, 0, 0, 0, '', 'execute sai only if player has quest taken');
  256. DELETE FROM `creature` WHERE `id`=33211;
  257. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES
  258. (820051, 33211, 571, 1, 1, 0, 0, 3714.92, -4303.66, 182.632, 5.09898, 120, 0, 0, 1, 0, 0, 0, 0, 0),
  259. (820052, 33211, 571, 1, 1, 0, 0, 3727.9, -4302.24, 182.257, 3.08221, 120, 0, 0, 1, 0, 0, 0, 0, 0),
  260. (820053, 33211, 571, 1, 1, 0, 0, 3745.24, -4297.1, 182.39, 2.71587, 120, 0, 0, 1, 0, 0, 0, 0, 0),
  261. (820054, 33211, 571, 1, 1, 0, 0, 3756.48, -4301.29, 182.095, 2.80784, 120, 0, 0, 1, 0, 0, 0, 0, 0),
  262. (820055, 33211, 571, 1, 1, 0, 0, 3771.69, -4302.97, 185.325, 2.31953, 120, 0, 0, 1, 0, 0, 0, 0, 0),
  263. (820056, 33211, 571, 1, 1, 0, 0, 3772.79, -4310.51, 181.825, 0.84316, 120, 0, 0, 1, 0, 0, 0, 0, 0),
  264. (820057, 33211, 571, 1, 1, 0, 0, 3775.22, -4321.11, 180.2, 3.22583, 120, 0, 0, 1, 0, 0, 0, 0, 0),
  265. (820058, 33211, 571, 1, 1, 0, 0, 3788.88, -4324.48, 183.075, 5.38701, 120, 0, 0, 1, 0, 0, 0, 0, 0),
  266. (820059, 33211, 571, 1, 1, 0, 0, 3794.86, -4332.32, 181.45, 1.17659, 120, 0, 0, 1, 0, 0, 0, 0, 0),
  267. (820060, 33211, 571, 1, 1, 0, 0, 3802.85, -4337.22, 182.431, 6.15077, 120, 0, 0, 1, 0, 0, 0, 0, 0),
  268. (820061, 33211, 571, 1, 1, 0, 0, 3806.7, -4355.51, 181.681, 1.17746, 120, 0, 0, 1, 0, 0, 0, 0, 0),
  269. (820062, 33211, 571, 1, 1, 0, 0, 3809.69, -4349.24, 182.556, 5.63714, 120, 0, 0, 1, 0, 0, 0, 0, 0),
  270. (820063, 33211, 571, 1, 1, 0, 0, 3813.42, -4361.89, 181.931, 2.17209, 120, 0, 0, 1, 0, 0, 0, 0, 0),
  271. (820064, 33211, 571, 1, 1, 0, 0, 3814.98, -4356.1, 183.181, 2.89564, 120, 0, 0, 1, 0, 0, 0, 0, 0);
  272.  
  273. -- Black Knight Chain
  274. -- The Stories Dead Men Tell
  275. DELETE FROM `creature_template_addon` WHERE `entry`=33439;
  276. INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
  277. (33439, '', 0, 7, 0, 65, '49132');
  278. DELETE FROM `event_scripts` WHERE `id`=21077;
  279. INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES
  280. (21077, 0, 10, 33439, 10000, '', 8461.674, 468.795, 596.072, 4.770);
  281. UPDATE `creature_template` SET `dynamicflags`=40 WHERE `entry`=33439;
  282. DELETE FROM `creature_template_addon` WHERE `entry`=33455;
  283. INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
  284. (33455, '', 0, 7, 0, 65, '12881 1');
  285. DELETE FROM `event_scripts` WHERE `id`=21075;
  286. INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES
  287. (21075, 0, 10, 33455, 10000, '', 8441.304, 452.848, 596.072, 1.432);
  288. UPDATE `creature_template` SET `dynamicflags`=40 WHERE `entry` IN (33457, 33439);
  289. DELETE FROM `event_scripts` WHERE `id`=21076;
  290. INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES
  291. (21076, 0, 10, 33457, 10000, '', 8471.503, 452.309, 596.072, 4.673);
  292. DELETE FROM `creature_template_addon` WHERE `entry`=33457;
  293. INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
  294. (33457, '', 0, 7, 0, 65, '');
  295.  
  296. -- There's Something About the Squire
  297. SET @ENTRY      := 33499; -- Skeletal Woodcutter
  298. SET @QUEST_LOOT := 45080; -- Large Femur
  299. SET @QUEST      := 13654; -- There's Something About the Squire
  300. SET @SPELL1     := 63124; -- Incapacitate Maloric
  301. SET @SPELL2     := 63126; -- Search Maloric
  302. -- add quest item to Skeletal Woodcutter
  303. UPDATE `creature_template` SET `lootid`=`entry` WHERE `entry`=@ENTRY;
  304. DELETE FROM `creature_loot_template` WHERE `entry`=@ENTRY;
  305. INSERT INTO `creature_loot_template` VALUES
  306. (@ENTRY, @QUEST_LOOT, -100, 1, 0, 1, 1);
  307. -- set visual effects on the skeletons
  308. DELETE FROM `creature_template_addon` WHERE `entry`=@ENTRY;
  309. INSERT INTO `creature_template_addon` (`entry`, `emote`) VALUES
  310. (@ENTRY, 234); -- chopping wood
  311. SET @ENTRY := 33498; -- Maloric
  312. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;
  313. DELETE FROM `smart_scripts` WHERE `entryorguid`=33498 AND `source_type`=0;
  314. 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
  315. (33498, 0, 0, 1, 23, 0, 100, 0, 63124, 1, 0, 0, 81, 16777216, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Maloric - on Aura: Incapacitate Maloric - set npcflag: Spellclick'),
  316. (33498, 0, 1, 0, 23, 0, 100, 0, 63124, 1, 0, 0, 2, 35, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Maloric - on Aura: Incapacitate Maloric - set npcflag: Spellclick'),
  317. (33498, 0, 2, 3, 23, 0, 100, 0, 63124, 0, 0, 0, 81, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Maloric - on NoAura: Incapacitate Maloric - set npcflag: none'),
  318. (33498, 0, 3, 0, 23, 0, 100, 0, 63124, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Maloric - on NoAura: Incapacitate Maloric - set npcflag: none');
  319. -- conditions for Large Femur and Maloric
  320. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `SourceEntry` IN (@SPELL1, @SPELL2);
  321. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  322. (17, 0, @SPELL1, 0, 31, 3, @ENTRY, 0, 0, '', 'Incapacitate Maloric only target Maloric'),
  323. (17, 0, @SPELL2, 0, 9, @QUEST, 0, 0, 0, '', 'Needs taken Quest 13654 to perform Spell Search Maloric');
  324. -- cast search Maloric, get quest item, quest completed
  325. DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`=@ENTRY;
  326. INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`) VALUES
  327. (@ENTRY, @SPELL2, 3, 1);
  328.  
  329. -- The Black Knight's Orders
  330. -- Black Knights Camp Spawns
  331. SET @OGUID := 100489; -- Need 10
  332. SET @CGUID := 152277; -- Need 3
  333. DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+9;
  334. INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
  335. (@OGUID+0, 194357, 571, 1, 1, 9070.324, 2050.733, 67.21755, 0, 0, 0, 0, 1, 0, 0, 0), -- Poison Vial
  336. (@OGUID+1, 194357, 571, 1, 1, 9073.764, 2050.120, 68.15718, 0, 0, 0, 0, 1, 0, 0, 0), -- Poison Vial
  337. (@OGUID+2, 194357, 571, 1, 1, 9074.699, 2050.709, 68.17049, 0, 0, 0, 0, 1, 0, 0, 0), -- Poison Vial
  338. (@OGUID+3, 194357, 571, 1, 1, 9069.595, 2050.349, 67.21755, 0, 0, 0, 0, 1, 0, 0, 0), -- Poison Vial
  339. (@OGUID+4, 194357, 571, 1, 1, 9069.961, 2050.538, 67.21755, 0, 0, 0, 0, 1, 0, 0, 0), -- Poison Vial
  340. (@OGUID+5, 194357, 571, 1, 1, 9072.077, 2049.292, 67.78963, 0, 0, 0, 0, 1, 0, 0, 0), -- Poison Vial
  341. (@OGUID+6, 194357, 571, 1, 1, 9065.680, 2052.618, 67.28638, 0, 0, 0, 0, 1, 0, 0, 0), -- Poison Vial
  342. (@OGUID+7, 194394, 571, 1, 1, 9083.578, 2041.696, 67.81812, 0, 0, 0, 0, 1, 0, 0, 0), -- Cult Rune Circle
  343. (@OGUID+8, 195011, 571, 1, 1, 9078.471, 2057.547, 67.21606, 0, 0, 0, 0.9981346, 0.06105176, 0, 0, 0), -- Bonfire
  344. (@OGUID+9, 300007, 571, 1, 1, 8523.51, 566.994, 552.841, 2.1518, 0, 0, 0.880019, 0.474938, 300, 0, 1); -- Spell Focus GO?
  345. DELETE FROM `creature` WHERE `id`=33537;
  346. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES
  347. (@CGUID+0, 33537, 571, 1, 1, 0, 0, 9071.043, 2075.388, 67.21542, 4.935980, 120, 0, 0, 1, 0, 0, 0, 0, 0),
  348. (@CGUID+1, 33537, 571, 1, 1, 0, 0, 9074.414, 2049.259, 67.34636, 2.181662, 120, 0, 0, 1, 0, 0, 0, 0, 0),
  349. (@CGUID+2, 33537, 571, 1, 1, 0, 0, 9081.280, 2058.925, 67.38979, 3.612832, 120, 0, 0, 1, 0, 0, 0, 0, 0);
  350. -- template updates
  351. UPDATE `creature_template` SET `unit_flags`=`unit_flags`|8, `speed_run`=8, `InhabitType`=5 WHERE `entry`=33519; -- Black Knight''s Gryphon
  352. UPDATE `creature_template` SET `faction_A`=2080, `faction_H`=2080, `unit_flags`=`unit_flags`|32768, `equipment_id`=823 WHERE `entry`=33537; -- Cult Conspirator
  353. -- see black knight's invisibility while on quest The Black Knight's Orders
  354. DELETE FROM `spell_area` WHERE `spell`=67471 AND `area`=4658;
  355. INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_start_active`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`) VALUES
  356. (67471, 4658, 13663, 1, 13663, 0, 0, 2, 1);
  357. -- addon data
  358. DELETE FROM `creature_template_addon` WHERE `entry` IN (33519, 33537);
  359. INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
  360. (33519, 0, 0, 2049, 0, NULL), -- Black Knight''s Gryphon
  361. (33537, 0, 1, 1, 0, NULL); -- Cult Conspirator
  362. -- SAI for Black Knight's Gryphon
  363. SET @ENTRY := 33519;
  364. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;
  365. DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY;
  366. 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
  367. (@ENTRY, 0, 0, 0, 27, 0, 100, 0, 0, 0, 0, 0, 53, 0, @ENTRY, 0, 13663, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Black Knight''s Gryphon - On passenger - Start WP movement'),
  368. (@ENTRY, 0, 1, 0, 40, 0, 100, 0, 40, @ENTRY, 0, 0, 33, 33519, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Black Knight''s Gryphon - On WP 40 - Quest Credit'),
  369. (@ENTRY, 0, 2, 0, 40, 0, 100, 0, 43, @ENTRY, 0, 0, 11, 50630, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Black Knight''s Gryphon - On WP 43 - Dismount Spell'),
  370. (@ENTRY, 0, 3, 0, 40, 0, 100, 0, 44, @ENTRY, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Black Knight''s Gryphon - On WP 44 - Despawn');
  371. DELETE FROM `waypoints` WHERE `entry`=33519;
  372. INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES
  373. (33519, 1, 8521.271, 569.5960, 552.8375, 'Black Knight''s Gryphon'),
  374. (33519, 2, 8517.864, 579.1095, 553.2125, 'Black Knight''s Gryphon'),
  375. (33519, 3, 8513.146, 594.6724, 551.2125, 'Black Knight''s Gryphon'),
  376. (33519, 4, 8505.263, 606.5569, 550.4177, 'Black Knight''s Gryphon'),
  377. (33519, 5, 8503.017, 628.4188, 547.4177, 'Black Knight''s Gryphon'),
  378. (33519, 6, 8480.271, 652.7083, 547.4177, 'Black Knight''s Gryphon'),
  379. (33519, 7, 8459.121, 686.1427, 547.4177, 'Black Knight''s Gryphon'),
  380. (33519, 8, 8436.802, 713.8687, 547.3428, 'Black Knight''s Gryphon'),
  381. (33519, 9, 8405.380, 740.0045, 547.4177, 'Black Knight''s Gryphon'),
  382. (33519, 10, 8386.139, 770.6009, 547.5881, 'Black Knight''s Gryphon'),
  383. (33519, 11, 8374.297, 802.2525, 547.9304, 'Black Knight''s Gryphon'),
  384. (33519, 12, 8374.271, 847.0363, 548.0427, 'Black Knight''s Gryphon'),
  385. (33519, 13, 8385.988, 868.9881, 548.0491, 'Black Knight''s Gryphon'),
  386. (33519, 14, 8413.027, 867.8573, 547.2991, 'Black Knight''s Gryphon'),
  387. (33519, 15, 8452.552, 869.0339, 547.2991, 'Black Knight''s Gryphon'),
  388. (33519, 16, 8473.058, 875.2012, 547.2955, 'Black Knight''s Gryphon'),
  389. (33519, 17, 8472.278, 912.3134, 547.4169, 'Black Knight''s Gryphon'),
  390. (33519, 18, 8479.666, 954.1650, 547.3298, 'Black Knight''s Gryphon'),
  391. (33519, 19, 8477.349, 1001.368, 547.3372, 'Black Knight''s Gryphon'),
  392. (33519, 20, 8484.538, 1025.797, 547.4622, 'Black Knight''s Gryphon'),
  393. (33519, 21, 8525.363, 1029.284, 547.4177, 'Black Knight''s Gryphon'),
  394. (33519, 22, 8532.808, 1052.904, 548.1677, 'Black Knight''s Gryphon'),
  395. (33519, 23, 8537.356, 1077.927, 554.5791, 'Black Knight''s Gryphon'),
  396. (33519, 24, 8540.528, 1083.379, 569.6827, 'Black Knight''s Gryphon'),
  397. (33519, 25, 8563.641, 1140.965, 569.6827, 'Black Knight''s Gryphon'),
  398. (33519, 26, 8594.897, 1205.458, 569.6827, 'Black Knight''s Gryphon'),
  399. (33519, 27, 8617.104, 1257.399, 566.1833, 'Black Knight''s Gryphon'),
  400. (33519, 28, 8648.496, 1329.349, 558.0187, 'Black Knight''s Gryphon'),
  401. (33519, 29, 8667.723, 1388.411, 546.1880, 'Black Knight''s Gryphon'),
  402. (33519, 30, 8699.145, 1474.898, 528.2197, 'Black Knight''s Gryphon'),
  403. (33519, 31, 8726.869, 1546.006, 501.7741, 'Black Knight''s Gryphon'),
  404. (33519, 32, 8739.058, 1592.157, 478.5511, 'Black Knight''s Gryphon'),
  405. (33519, 33, 8750.799, 1636.771, 455.0797, 'Black Knight''s Gryphon'),
  406. (33519, 34, 8760.006, 1669.482, 423.2208, 'Black Knight''s Gryphon'),
  407. (33519, 35, 8783.310, 1701.852, 375.8872, 'Black Knight''s Gryphon'),
  408. (33519, 36, 8817.336, 1735.731, 343.3323, 'Black Knight''s Gryphon'),
  409. (33519, 37, 8882.320, 1789.754, 301.5807, 'Black Knight''s Gryphon'),
  410. (33519, 38, 8958.597, 1841.807, 259.9141, 'Black Knight''s Gryphon'),
  411. (33519, 39, 9045.891, 1908.076, 233.4143, 'Black Knight''s Gryphon'),
  412. (33519, 40, 9107.177, 1964.594, 215.9704, 'Black Knight''s Gryphon'),
  413. (33519, 41, 9134.763, 2036.925, 175.1925, 'Black Knight''s Gryphon'),
  414. (33519, 42, 9128.608, 2089.091, 141.3593, 'Black Knight''s Gryphon'),
  415. (33519, 43, 9093.364, 2128.384, 99.38685, 'Black Knight''s Gryphon'),
  416. (33519, 44, 9050.709, 2123.656, 60.24802, 'Black Knight''s Gryphon');
  417.  
  418. /*
  419. case 63163: // Apply Enchanted Bridle (Argent Tournament)
  420. spellInfo->EffectDieSides[0]=0; // was 1, that should probably mean seat 0, but instead it's treated as spell 1
  421. spellInfo->EffectBasePoints[0]=52391; // Ride Vehicle (forces seat 0)
  422. break;
  423. */
  424.  
  425. -- The Black Knight's Fall
  426. SET @QUEST                         := 13664;
  427. SET @NPC_BLACK_KNIGHT              := 33785;
  428. SET @NPC_BLACK_KNIGHT_GRYPHON      := 33513;
  429. SET @NPC_CAVIN                     := 33522;
  430. SET @SPELL_CHARGE                  := 63003;
  431. SET @SPELL_SHIELD_BREAKER          := 65147;
  432. SET @SPELL_DARK_SHIELD             := 64505;
  433. SET @SPELL_BLACK_NIGHT_TRANSFORM   := 64490; -- Apply Aura: Change Model (34104)
  434. SET @SPELL_BLACK_NIGHT_TRANSFORM_2 := 64498; -- Apply Aura: Increase Max Health
  435. SET @SPELL_FULL_HEAL               := 25840;
  436. SET @GOSSIP                        := 10383;
  437. -- add Gossip to NPC Cavin
  438. DELETE FROM `gossip_menu_option` WHERE `menu_id`=@GOSSIP AND `id`=1;
  439. INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`, `box_coded`, `box_money`, `box_text`) VALUES
  440. (@GOSSIP, 1, 0, 'Ask Cavin to summon the Black Knight.', 1, 1, 0, 0, 0, 0, 0, NULL);
  441. -- add gossip_menu_option condition for 13664
  442. DELETE FROM `conditions` WHERE `SourceGroup`=@GOSSIP AND `SourceTypeOrReferenceId`=15;
  443. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  444. (15, @GOSSIP, 1, 0, 9, @QUEST, 0, 0, 0, '', 'Only show gossip when player is on quest The Black Knight\'s Fall');
  445. -- SAI for NPC Cavin
  446. UPDATE `creature_template` SET AIName='SmartAI' WHERE `entry`=@NPC_CAVIN;
  447. DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@NPC_CAVIN;
  448. DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid`=@NPC_CAVIN*100;
  449. 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
  450. (@NPC_CAVIN, 0, 0, 1, 62, 0, 100, 0, @GOSSIP, 1, 0, 0, 80, @NPC_CAVIN*100, 0, 2, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Cavin - On gossip option select - Run script'),
  451. (@NPC_CAVIN, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 12, @NPC_BLACK_KNIGHT, 1, 120000, 0, 0, 0, 8, 0, 0, 0, 8436.9, 970.9, 544.7, 0, 'Cavin - On gossip option select - Summon the Black Knight'),
  452. (@NPC_CAVIN, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Cavin - On gossip option select - Close gossip'),
  453. (@NPC_CAVIN*100, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 81, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Cavin - On Script - Turn off Gossip & Gossip flags'),
  454. (@NPC_CAVIN*100, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Cavin - On Script - Say text 0'),
  455. (@NPC_CAVIN*100, 9, 2, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 1, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Cavin - On Script - Say text 1');
  456. -- add text for NPC Cavin
  457. DELETE FROM `creature_text` WHERE `entry`=@NPC_CAVIN;
  458. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES
  459. (@NPC_CAVIN, 0, 0, '$N challenges the Black Knight to trial by combat!', 14, 0, 0, 0, 0, 0, 'yell'),
  460. (@NPC_CAVIN, 1, 0, 'Good luck, $N.', 12, 0, 0, 0, 0, 0, 'say');
  461. -- SAI for NPC The Black Knight
  462. UPDATE `creature_template` SET AIName='SmartAI' WHERE `entry`=@NPC_BLACK_KNIGHT;
  463. DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@NPC_BLACK_KNIGHT;
  464. DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid`=@NPC_BLACK_KNIGHT*100;
  465. 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
  466. (@NPC_BLACK_KNIGHT, 0, 0, 0, 54, 0, 100, 1, 0, 0, 0, 0, 43, @NPC_BLACK_KNIGHT_GRYPHON, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Blackknight - Just Summoned - Mount to entry'),
  467. (@NPC_BLACK_KNIGHT, 0, 1, 0, 4, 0, 100, 1, 0, 0, 0, 0, 11, @SPELL_CHARGE, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Blackknight - On Aggro - Cast Charge'),
  468. (@NPC_BLACK_KNIGHT, 0, 2, 3, 0, 0, 100, 0, 15000, 20000, 15000, 20000, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Blackknight - On Aggro - Set Phase 1'),
  469. (@NPC_BLACK_KNIGHT, 0, 3, 0, 61, 1, 100, 0, 0, 0, 0, 0, 25, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Blackknight - In Phase 1 - Flee for assist'),
  470. (@NPC_BLACK_KNIGHT, 0, 4, 0, 9, 1, 100, 0, 5, 30, 1000, 1000, 11, @SPELL_CHARGE, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Blackknight - In Phase 1 - Cast Charge'),
  471. (@NPC_BLACK_KNIGHT, 0, 5, 0, 9, 1, 100, 0, 3, 30, 1500, 2000, 11, @SPELL_SHIELD_BREAKER, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Blackknight - In Phase 1 & On Range - Cast Shield Breaker'),
  472. (@NPC_BLACK_KNIGHT, 0, 6, 0, 6, 0, 100, 1, 0, 0, 0, 0, 81, 1, 0, 0, 0, 0, 0, 9, @NPC_CAVIN, 0, 200, 0, 0, 0, 0, 'Blackknight - On Death - Turn on Gossip & Gossip flags on Cavin'),
  473. (@NPC_BLACK_KNIGHT, 0, 7, 8, 1, 0, 100, 0, 60000, 60000, 80000, 80000, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Blackknight - Out Of Combat after 60s - Despawn'),
  474. (@NPC_BLACK_KNIGHT, 0, 8, 0, 61, 0, 100, 0, 0, 0, 0, 0, 81, 1, 0, 0, 0, 0, 0, 9, @NPC_CAVIN, 0, 200, 0, 0, 0, 0, 'Blackknight - Out Of Combat after 60s - Turn on Gossip & Gossip flags on Cavin'),
  475. (@NPC_BLACK_KNIGHT, 0, 9, 0, 2, 1, 100, 1, 0, 25, 0, 0, 80, @NPC_BLACK_KNIGHT*100, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Blackknight - On 25% health - Run script'),
  476. (@NPC_BLACK_KNIGHT*100, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 24, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Blackknight - On Script - Evade'),
  477. (@NPC_BLACK_KNIGHT*100, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Blackknight - On Script - State passive'),
  478. (@NPC_BLACK_KNIGHT*100, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Blackknight - On Script - Say text 0'),
  479. (@NPC_BLACK_KNIGHT*100, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 43, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Blackknight - On Script - Unmount'),
  480. (@NPC_BLACK_KNIGHT*100, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 11, @SPELL_DARK_SHIELD, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Blackknight - On Script - Cast Dark Shield'),
  481. (@NPC_BLACK_KNIGHT*100, 9, 5, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 11, @SPELL_BLACK_NIGHT_TRANSFORM, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Blackknight - On Script - Apply Aura'),
  482. (@NPC_BLACK_KNIGHT*100, 9, 6, 0, 0, 0, 100, 0, 0, 0, 0, 0, 11, @SPELL_FULL_HEAL, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Blackknight - On Script - Full hp'),
  483. (@NPC_BLACK_KNIGHT*100, 9, 7, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 11, @SPELL_BLACK_NIGHT_TRANSFORM_2, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Blackknight - On Script - Increase Max Health'),
  484. (@NPC_BLACK_KNIGHT*100, 9, 8, 0, 0, 0, 100, 0, 0, 0, 0, 0, 43, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Blackknight - On Script - Unmount player'),
  485. (@NPC_BLACK_KNIGHT*100, 9, 9, 0, 0, 0, 100, 0, 0, 0, 0, 0, 8, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Blackknight - On Script - State Aggresive'),
  486. (@NPC_BLACK_KNIGHT*100, 9, 10, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Blackknight - On Script - Say text 1'),
  487. (@NPC_BLACK_KNIGHT*100, 9, 11, 0, 0, 0, 100, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Blackknight - On Script - Start Attack');
  488. -- add text for NPC The Black Knight
  489. DELETE FROM `creature_text` WHERE `entry`=@NPC_BLACK_KNIGHT;
  490. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES
  491. (@NPC_BLACK_KNIGHT, 0, 0, 'Get off that horse and fight me man-to-man!', 14, 0, 0, 0, 0, 0, 'yell'),
  492. (@NPC_BLACK_KNIGHT, 1, 0, 'I will not fail you, master!', 14, 0, 0, 0, 0, 0, 'yell');
  493.  
  494. -- Argent Tournament mounts implementation
  495. SET @GUID := 200000;
  496. UPDATE `creature_template` SET `npcflag`=`npcflag`|16777216, `speed_run`=1.5714285714286 WHERE `entry`=33870; -- Stabled Argent Warhorse
  497. UPDATE `creature_template` SET `npcflag`=`npcflag`|16777216, `speed_run`=1.5714285714286 WHERE `entry`=33790; -- Stabled Exodar Elekk
  498. UPDATE `creature_template` SET `npcflag`=`npcflag`|16777216, `speed_run`=1.5714285714286 WHERE `entry`=33791; -- Stabled Silvermoon Hawkstrider
  499. UPDATE `creature_template` SET `npcflag`=`npcflag`|16777216, `speed_run`=1.5714285714286 WHERE `entry`=33792; -- Stabled Thunder Bluff Kodo
  500. UPDATE `creature_template` SET `npcflag`=`npcflag`|16777216, `speed_run`=1.5714285714286 WHERE `entry`=33793; -- Stabled Gnomeregan Mechanostrider
  501. UPDATE `creature_template` SET `npcflag`=`npcflag`|16777216, `speed_run`=1.5714285714286 WHERE `entry`=33794; -- Stabled Darnassian Nightsaber
  502. UPDATE `creature_template` SET `npcflag`=`npcflag`|16777216, `speed_run`=1.5714285714286 WHERE `entry`=33795; -- Stabled Ironforge Ram
  503. UPDATE `creature_template` SET `npcflag`=`npcflag`|16777216, `speed_run`=1.5714285714286 WHERE `entry`=33796; -- Stabled Darkspear Raptor
  504. UPDATE `creature_template` SET `npcflag`=`npcflag`|16777216, `speed_run`=1.5714285714286 WHERE `entry`=33798; -- Stabled Forsaken Warhorse
  505. UPDATE `creature_template` SET `npcflag`=`npcflag`|16777216, `speed_run`=1.5714285714286 WHERE `entry`=33799; -- Stabled Orgrimmar Wolf
  506. UPDATE `creature_template` SET `npcflag`=`npcflag`|16777216, `speed_run`=1.5714285714286 WHERE `entry`=33800; -- Stabled Stormwind Steed
  507. UPDATE `creature_template` SET `npcflag`=`npcflag`|16777216, `speed_run`=1.5714285714286 WHERE `entry`=33842; -- Stabled Sunreaver Hawkstrider
  508. UPDATE `creature_template` SET `npcflag`=`npcflag`|16777216, `speed_run`=1.5714285714286 WHERE `entry`=33843; -- Stabled Quel'dorei Steed
  509. UPDATE `creature_model_info` SET `bounding_radius`=1, `combat_reach`=1, `gender`=0 WHERE `modelid`=29255; -- Stabled Exodar Elekk
  510. UPDATE `creature_model_info` SET `bounding_radius`=1.185, `combat_reach`=2.25, `gender`=0 WHERE `modelid`=29256; -- Stabled Darnassian Nightsaber
  511. UPDATE `creature_model_info` SET `bounding_radius`=0.818, `combat_reach`=2, `gender`=0 WHERE `modelid`=29258; -- Stabled Ironforge Ram
  512. UPDATE `creature_model_info` SET `bounding_radius`=0.35, `combat_reach`=1.5, `gender`=0 WHERE `modelid`=29261; -- Stabled Darkspear Raptor
  513. UPDATE `creature_model_info` SET `bounding_radius`=0, `combat_reach`=1, `gender`=2 WHERE `modelid`=28918; -- Stabled Argent Warhorse
  514. DELETE FROM `creature_template_addon` WHERE `entry` IN (33870, 33790, 33791, 33792, 33793, 33794, 33795, 33796, 33798, 33799, 33800, 33842, 33843);
  515. INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
  516. (33870, 0, 0, 1, 0, NULL), -- Stabled Argent Warhorse
  517. (33790, 0, 0, 1, 0, NULL), -- Stabled Exodar Elekk
  518. (33791, 0, 0, 1, 0, NULL), -- Stabled Silvermoon Hawkstrider
  519. (33792, 0, 0, 1, 0, NULL), -- Stabled Thunder Bluff Kodo
  520. (33793, 0, 0, 1, 0, NULL), -- Stabled Gnomeregan Mechanostrider
  521. (33794, 0, 0, 1, 0, NULL), -- Stabled Darnassian Nightsaber
  522. (33795, 0, 0, 1, 0, NULL), -- Stabled Ironforge Ram
  523. (33796, 0, 0, 1, 0, NULL), -- Stabled Darkspear Raptor
  524. (33798, 0, 0, 1, 0, NULL), -- Stabled Forsaken Warhorse
  525. (33799, 0, 0, 1, 0, NULL), -- Stabled Orgrimmar Wolf
  526. (33800, 0, 0, 1, 0, NULL), -- Stabled Stormwind Steed
  527. (33842, 0, 0, 1, 0, NULL), -- Stabled Sunreaver Hawkstrider
  528. (33843, 0, 0, 1, 0, NULL); -- Stabled Quel'dorei Steed
  529. UPDATE `creature_template` SET `npcflag`=`npcflag`|16777216, `unit_flags`=0, `speed_run`=1.5714285714286, `vehicleid`=349 WHERE `entry`=33782; -- Argent Warhorse
  530. UPDATE `creature_template` SET `npcflag`=`npcflag`|16777216, `faction_A`=35, `faction_H`=35, `unit_flags`=0, `speed_run`=1.5714285714286, `vehicleid`=349 WHERE `entry`=33318; -- Exodar Elekk
  531. UPDATE `creature_template` SET `npcflag`=`npcflag`|16777216, `unit_flags`=0, `speed_run`=1.5714285714286, `vehicleid`=349 WHERE `entry`=33323; -- Silvermoon Hawkstrider
  532. UPDATE `creature_template` SET `npcflag`=`npcflag`|16777216, `unit_flags`=0, `speed_run`=1.5714285714286, `vehicleid`=349 WHERE `entry`=33322; -- Thunder Bluff Kodo
  533. UPDATE `creature_template` SET `npcflag`=`npcflag`|16777216, `faction_A`=35, `faction_H`=35, `unit_flags`=0, `speed_run`=1.5714285714286, `vehicleid`=349 WHERE `entry`=33317; -- Gnomeregan Mechanostrider
  534. UPDATE `creature_template` SET `npcflag`=`npcflag`|16777216, `faction_A`=35, `faction_H`=35, `unit_flags`=0, `speed_run`=1.5714285714286, `vehicleid`=349 WHERE `entry`=33319; -- Darnassian Nightsaber
  535. UPDATE `creature_template` SET `npcflag`=`npcflag`|16777216, `unit_flags`=0, `speed_run`=1.5714285714286, `vehicleid`=349 WHERE `entry`=33316; -- Ironforge Ram
  536. UPDATE `creature_template` SET `npcflag`=`npcflag`|16777216, `unit_flags`=0, `speed_run`=1.5714285714286, `vehicleid`=349 WHERE `entry`=33321; -- Darkspear Raptor
  537. UPDATE `creature_template` SET `npcflag`=`npcflag`|16777216, `unit_flags`=0, `speed_run`=1.5714285714286, `vehicleid`=349 WHERE `entry`=33324; -- Forsaken Warhorse
  538. UPDATE `creature_template` SET `npcflag`=`npcflag`|16777216, `unit_flags`=0, `speed_run`=1.5714285714286, `vehicleid`=349 WHERE `entry`=33320; -- Orgrimmar Wolf
  539. UPDATE `creature_template` SET `npcflag`=`npcflag`|16777216, `faction_A`=35, `faction_H`=35, `unit_flags`=0, `speed_run`=1.5714285714286, `vehicleid`=349 WHERE `entry`=33845; -- Quel'dorei Steed
  540. UPDATE `creature_template` SET `npcflag`=`npcflag`|16777216, `unit_flags`=0, `speed_run`=1.5714285714286, `vehicleid`=349 WHERE `entry`=33844; -- Sunreaver Hawkstrider
  541. UPDATE `creature_template` SET `npcflag`=`npcflag`|16777216, `unit_flags`=0, `speed_run`=1.5714285714286, `vehicleid`=349 WHERE `entry`=33217; -- Stormwind Steed
  542. UPDATE `creature_template` SET
  543. `spell1`=62544, -- Thurst
  544. `spell2`=62575, -- Shield-Breaker
  545. `spell3`=62960, -- Charge
  546. `spell4`=62552, -- Defend
  547. `spell5`=64077, -- Refresh Mount
  548. `spell6`=62863, -- Duel
  549. `spell7`=63034 -- Player On Tournament Mount (aura)
  550. WHERE `vehicleid`=349;
  551. DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (33870, 33790, 33791, 33792, 33793, 33794, 33795, 33796, 33798, 33799, 33800, 33842, 33843);
  552. INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`) VALUES
  553. (33870, 63663, 1, 0), -- Stabled Argent Warhorse - Summon Tournament Argent Charger - requires quest The Black Knight's Fall (shall not be completed nor rewarded)
  554. (33790, 62781, 1, 0), -- Stabled Exodar Elekk - Summon Tournament Elekk - requires quest A Valiant Of The Exodar
  555. (33791, 62786, 1, 0), -- Stabled Silvermoon Hawkstrider - Summon Tournament Hawkstrider - requires quest A Valiant Of Silvermoon
  556. (33792, 62785, 1, 0), -- Stabled Thunder Bluff Kodo - Summon Tournament Kodo - requires quest A Valiant Of Thunder Bluff
  557. (33793, 62780, 1, 0), -- Stabled Gnomeregan Mechanostrider - Summon Tournament Mechanostrider - requires quest A Valiant Of Gnomeregan
  558. (33794, 62782, 1, 0), -- Stabled Darnassian Nightsaber - Summon Tournament Nightsaber - requires quest A Valiant Of Darnassus
  559. (33795, 62779, 1, 0), -- Stabled Ironforge Ram - Summon Tournament Ram - requires quest A Valiant Of Ironforge
  560. (33796, 62784, 1, 0), -- Stabled Darkspear Raptor - Summon Tournament Raptor - requires quest A Valiant Of Sen'jin
  561. (33798, 62787, 1, 0), -- Stabled Forsaken Warhorse - Summon Tournament Warhorse - requires quest A Valiant Of Undercity
  562. (33799, 62783, 1, 0), -- Stabled Orgrimmar Wolf - Summon Tournament Wolf - requires quest A Valiant Of Orgrimmar
  563. (33800, 62774, 1, 0), -- Stabled Stormwind Steed - Summon Tournament Charger - requires quest A Valiant Of Stormwind
  564. (33842, 63791, 1, 0), -- Stabled Sunreaver Hawkstrider - Summon Tournament Hawkstrider (Aspirant) - requires quest The Argent Tournament (H/Argent Aspiration)
  565. (33843, 63792, 1, 0); -- Stabled Quel'dorei Steed - Summon Tournament Steed (Aspirant) - requires quest The Argent Tournament (A/Argent Aspiration)
  566. -- Note: spell 62853 (Lance Equipped) is required for all vehicles.
  567. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=16 AND `ConditionTypeOrReference`=1 AND `ConditionValue1`=64373;
  568. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  569. -- dismount in wrong zones condition
  570. (16, 0, 33782, 0, 1, 64373, 0, 0, 0, '', 'Vehicle Argent Warhorse requires aura Armistice'),
  571. (16, 0, 33318, 0, 1, 64373, 0, 0, 0, '', 'Vehicle Exodar Elekk requires aura Armistice'),
  572. (16, 0, 33323, 0, 1, 64373, 0, 0, 0, '', 'Vehicle Silvermoon Hawkstrider requires aura Armistice'),
  573. (16, 0, 33322, 0, 1, 64373, 0, 0, 0, '', 'Vehicle Thunder Bluff Kodo requires aura Armistice'),
  574. (16, 0, 33317, 0, 1, 64373, 0, 0, 0, '', 'Vehicle Gnomeregan Mechanostrider requires aura Armistice'),
  575. (16, 0, 33319, 0, 1, 64373, 0, 0, 0, '', 'Vehicle Darnassian Nightsaber requires aura Armistice'),
  576. (16, 0, 33316, 0, 1, 64373, 0, 0, 0, '', 'Vehicle Ironforge Ram requires aura Armistice'),
  577. (16, 0, 33321, 0, 1, 64373, 0, 0, 0, '', 'Vehicle Darkspear Raptor requires aura Armistice'),
  578. (16, 0, 33324, 0, 1, 64373, 0, 0, 0, '', 'Vehicle Forsaken Warhorse requires aura Armistice'),
  579. (16, 0, 33320, 0, 1, 64373, 0, 0, 0, '', 'Vehicle Orgrimmar Wolf requires aura Armistice'),
  580. (16, 0, 33845, 0, 1, 64373, 0, 0, 0, '', 'Vehicle Quel''dorei Steed requires aura Armistice'),
  581. (16, 0, 33844, 0, 1, 64373, 0, 0, 0, '', 'Vehicle Sunreaver Hawkstrider requires aura Armistice'),
  582. (16, 0, 33217, 0, 1, 64373, 0, 0, 0, '', 'Vehicle Stormwind Steed requires aura Armistice');
  583. DELETE FROM `creature_template_addon` WHERE `entry` IN (33782, 33318, 33323, 33322, 33317, 33319, 33316, 33321, 33324, 33320, 33845, 33844, 33217);
  584. INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
  585. (33782, 0, 0, 2305, 0, NULL), -- Argent Warhorse
  586. (33318, 0, 0, 2305, 0, NULL), -- Exodar Elekk
  587. (33323, 0, 0, 2305, 0, NULL), -- Silvermoon Hawkstrider
  588. (33322, 0, 0, 2305, 0, NULL), -- Thunder Bluff Kodo
  589. (33317, 0, 0, 2305, 0, NULL), -- Gnomeregan Mechanostrider
  590. (33319, 0, 0, 2305, 0, NULL), -- Darnassian Nightsaber
  591. (33316, 0, 0, 2305, 0, NULL), -- Ironforge Ram
  592. (33321, 0, 0, 2305, 0, NULL), -- Darkspear Raptor
  593. (33324, 0, 0, 2305, 0, NULL), -- Forsaken Warhorse
  594. (33320, 0, 0, 2305, 0, NULL), -- Orgrimmar Wolf
  595. (33845, 0, 0, 2305, 0, NULL), -- Quel''dorei Steed
  596. (33844, 0, 0, 2305, 0, NULL), -- Sunreaver Hawkstrider
  597. (33217, 0, 0, 2305, 0, NULL); -- Stormwind Steed
  598. UPDATE `creature_model_info` SET `bounding_radius`=1, `combat_reach`=1, `gender`=0 WHERE `modelid`=29255; -- Exodar Elekk
  599. UPDATE `creature_model_info` SET `bounding_radius`=1.185, `combat_reach`=2.25, `gender`=0 WHERE `modelid`=29256; -- Darnassian Nightsaber
  600. UPDATE `creature_model_info` SET `bounding_radius`=2, `combat_reach`=0, `gender`=0 WHERE `modelid`=29258; -- Ironforge Ram
  601. UPDATE `creature_model_info` SET `bounding_radius`=0.35, `combat_reach`=1.5, `gender`=0 WHERE `modelid`=29261; -- Darkspear Raptor
  602. UPDATE `gameobject` SET `rotation0`=0, `rotation1`=0, `rotation2`=0, `rotation3`=0, `spawntimesecs`=300, `animprogress`=0 WHERE `id`=300008; -- equal field values for all the entries
  603.  
  604. -- Disables
  605. -- Up To The Challenge - quest po jehoz splneni hrac muze sbirat dalsi rank sealu - zatim neni doopravene, takze nepujde odevzdat
  606. DELETE FROM `creature_involvedrelation` WHERE `quest` IN (13672, 13678);
  607. -- The Black Knight's Curse - prvni 3.2.0 quest z chainu na Black Knighta
  608. DELETE FROM `disables` WHERE `sourceType`=1 AND `entry`=14016;
  609. INSERT INTO `disables` (`sourceType`, `entry`, `flags`, `params_0`, `params_1`, `comment`) VALUES
  610. (1, 14016, 0, '', '', '3.2.0 quest - The Black Knight''s Curse');
create a new version of this paste RAW Paste Data