API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 19th, 2014
189
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 32.64 KB | None | 0 0
raw download clone embed print report
  1. /*
  2. Autor: Dr- J
  3. Ticket: #564
  4. Descr.: full questfix for quest : An End And A Beginning
  5. */
  6.  
  7. UPDATE `quest_template` SET `SpecialFlags`=2 WHERE `Id`=12473;
  8.  
  9. DELETE FROM `smart_scripts` WHERE `entryorguid`=27857 AND `source_type`=0;
  10. DELETE FROM `smart_scripts` WHERE `entryorguid`=26780 AND `source_type`=0;
  11. DELETE FROM `smart_scripts` WHERE `entryorguid`=27713 AND `source_type`=0;
  12. DELETE FROM `smart_scripts` WHERE `entryorguid`=27851 AND `source_type`=0 AND `id`>1;
  13. DELETE FROM `smart_scripts` WHERE `entryorguid`=27383 AND `source_type`=0;
  14. DELETE FROM `smart_scripts` WHERE `entryorguid`=27858 AND `source_type`=0;
  15.  
  16. DELETE FROM `smart_scripts` WHERE `entryorguid`=2785700 AND `source_type`=9;
  17. DELETE FROM `smart_scripts` WHERE `entryorguid`=2785701 AND `source_type`=9;
  18.  
  19. DELETE FROM `smart_scripts` WHERE `entryorguid`=2738300 AND `source_type`=9;
  20.  
  21. 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
  22. (27383, 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - On Spawn - Disable Combat Movement'),
  23. (27383, 0, 1, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 31256, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - On Spawn - Cast Frost Armor'),
  24. (27383, 0, 2, 0, 9, 1, 100, 0, 0, 40, 3400, 4800, 11, 42719, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - Within 0-40 Range - Cast Frostbolt (No Repeat)'),
  25. (27383, 0, 3, 0, 3, 1, 100, 1, 0, 7, 0, 0, 21, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - Between 0-7% Mana - Enable Combat Movement (Phase 1) (No Repeat)'),
  26. (27383, 0, 4, 0, 4, 0, 100, 0, 0, 0, 0, 0, 11, 49735, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - On Agro - Cast Terrifying Countenance'),
  27. (27383, 0, 5, 0, 9, 1, 100, 1, 35, 80, 0, 0, 21, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - Within 35-80 Range - Enable Combat Movement (Phase 1) (No Repeat)'),
  28. (27383, 0, 6, 0, 9, 1, 100, 1, 5, 15, 0, 0, 21, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - Within 5-15 Range - Disable Combat Movement (Phase 1) (No Repeat)'),
  29. (27383, 0, 7, 0, 9, 1, 100, 1, 0, 5, 0, 0, 21, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - Within 0-5 Range - Enable Combat Movement (Phase 1) (No Repeat)'),
  30. (27383, 0, 8, 0, 2, 0, 100, 1, 0, 50, 0, 0, 11, 50497, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - Between 0-50% Health - Cast Scream of Chaos (Phase 1) (No Repeat)'),
  31. (27383, 0, 9, 0, 2, 0, 100, 1, 0, 15, 0, 0, 11, 50497, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - Between 0-15% Health - Cast Scream of Chaos (Phase 1) (No Repeat)'),
  32. (27383, 0, 10, 0, 9, 1, 100, 0, 0, 10, 15000, 20000, 11, 22643, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - Within 0-10 Range - Cast Frostbolt Volley (Phase 1) (No Repeat)'),
  33. (27383, 0, 11, 0, 0, 1, 100, 0, 7000, 11000, 14000, 18000, 11, 39268, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - In Combat - Cast Chains of Ice (Phase 1) (No Repeat)'),
  34. (27383, 0, 12, 13, 11, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - On Spawn - Say'),
  35. (27383, 0, 13, 0, 61, 0, 100, 0, 0, 0, 0, 0, 53, 0, 27383, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - On Spawn - Start WP'),
  36. (27383, 0, 14, 15, 40, 0, 100, 0, 1, 27383, 0, 0, 19, 768, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - On Reached WP1 - Run Script'),
  37. (27383, 0, 15, 16, 61, 0, 100, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 19, 27713, 0, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - On Reached WP1 - Run Script'),
  38. (27383, 0, 16, 17, 61, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 19, 27857, 0, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - On Reached WP1 - Set Data'),
  39. (27383, 0, 17, 0, 61, 0, 100, 0, 0, 0, 0, 0, 80, 2738300, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - On Reached WP1 - Run Script'),
  40. (27383, 0, 18, 0, 7, 0, 100, 0, 0, 0, 0, 0, 19, 768, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - On Evade- Set Unit Flags'),
  41. (27383, 0, 19, 20, 6, 0, 100, 0, 0, 0, 0, 0, 15, 12473, 0, 0, 0, 0, 0, 17, 0, 100, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - On Death - Quest Credit'),
  42. (27383, 0, 20, 0, 61, 0, 100, 0, 0, 0, 0, 0, 45, 3, 3, 0, 0, 0, 0, 19, 27857, 0, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - On Death - Set Data'),
  43. (27851, 0, 2, 0, 38, 0, 100, 0, 1, 1, 0, 0, 22, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thel zan Spell Dummy - On Data Set - Set Phase 2'),
  44. (27851, 0, 3, 0, 1, 2, 100, 0, 90000, 90000, 90000, 90000, 22, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thel zan Spell Dummy - OOC (Phase 2) - Set Phase 0'),
  45. (27851, 0, 4, 0, 1, 2, 100, 0, 0, 300, 300, 500, 11, 49734, 0, 0, 0, 0, 0, 9, 27851, 5, 30, 0, 0, 0, 0, 'Thel zan Spell Dummy - Cast Thel zan Intro Beams'),
  46. (27851, 0, 5, 0, 38, 0, 100, 0, 3, 3, 0, 0, 12, 27383, 1, 900000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thel zan Spell Dummy - On Data Set - Spawn Thel zan the Duskbringer'),
  47. (27851, 0, 6, 0, 38, 0, 100, 0, 5, 5, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thel zan Spell Dummy - On Data Set - Set Phase 1'),
  48. (27851, 0, 7, 0, 38, 0, 100, 0, 6, 6, 0, 0, 12, 27868, 1, 60000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thel zan Spell Dummy - On Data Set - Spawn Thel zan s Phylactery'),
  49. (27851, 0, 8, 0, 1, 1, 100, 0, 0, 0, 1000, 1000, 11, 45849, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thel zan Spell Dummy - OOC (Phase 1) - Cast Cast Camera Shake - Tremor'),
  50. (27851, 0, 9, 0, 1, 1, 100, 0, 5000, 5000, 5000, 5000, 22, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thel zan Spell Dummy - OOC (Phase 1) - Set Phase 0'),
  51. (27857, 0, 0, 1, 1, 0, 100, 1, 0, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Legion Commander Yorik - Out of Combat - Disable Combat Movement (No Repeat)'),
  52. (27857, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 20, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Legion Commander Yorik - Out of Combat - Stop Attacking (No Repeat)'),
  53. (27857, 0, 2, 3, 4, 0, 100, 0, 0, 0, 0, 0, 11, 15620, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Legion Commander Yorik - On Aggro - Cast \'Shoot\' (No Repeat)'),
  54. (27857, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Legion Commander Yorik - On Aggro - Set Phase 1'),
  55. (27857, 0, 4, 5, 9, 1, 100, 0, 5, 30, 2300, 3900, 11, 15620, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Legion Commander Yorik - Within 5-30 Range - Cast \'Shoot\' (Phase 1)'),
  56. (27857, 0, 5, 0, 61, 1, 100, 0, 0, 0, 0, 0, 40, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Legion Commander Yorik - Within 5-30 Range - Set Sheath Ranged (Phase 1)'),
  57. (27857, 0, 6, 7, 9, 1, 100, 0, 25, 80, 0, 0, 21, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Legion Commander Yorik - Within 25-80 Range - Enable Combat Movement (Phase 1)'),
  58. (27857, 0, 7, 0, 61, 1, 100, 0, 0, 0, 0, 0, 20, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Legion Commander Yorik - Within 25-80 Range - Start Attacking (Phase 1)'),
  59. (27857, 0, 8, 9, 9, 1, 100, 0, 0, 5, 0, 0, 21, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Legion Commander Yorik - Within 0-5 Range - Enable Combat Movement (Phase 1)'),
  60. (27857, 0, 9, 10, 61, 1, 100, 0, 0, 0, 0, 0, 40, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Legion Commander Yorik - Within 0-5 Range - Set Sheath Melee (Phase 1)'),
  61. (27857, 0, 10, 0, 61, 1, 100, 0, 0, 0, 0, 0, 20, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Legion Commander Yorik - Within 0-5 Range - Start Attacking (Phase 1)'),
  62. (27857, 0, 12, 0, 61, 1, 100, 0, 0, 0, 0, 0, 20, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Legion Commander Yorik - Within 5-15 Range - Stop Attacking (Phase 1)'),
  63. (27857, 0, 11, 12, 9, 1, 100, 0, 5, 15, 0, 0, 21, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Legion Commander Yorik - Within 5-15 Range - Disable Combat Movement (Phase 1)'),
  64. (27857, 0, 13, 0, 7, 0, 100, 1, 0, 0, 0, 0, 40, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Legion Commander Yorik - On Evade - Set Sheath Melee (Phase 1)'),
  65. (27857, 0, 14, 0, 11, 0, 100, 0, 0, 0, 0, 0, 22, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Legion Commander Yorik - OOC - Set Phase 2'),
  66. (27857, 0, 15, 0, 1, 2, 100, 0, 6000, 19000, 27000, 32000, 1, 0, 0, 0, 0, 0, 0, 10, 133302, 27713, 0, 0, 0, 0, 0, 'Legion Commander Yorik - OOC - Say (Phase 2)'),
  67. (27857, 0, 16, 0, 1, 2, 100, 0, 12000, 16000, 35000, 40000, 1, 0, 0, 0, 0, 0, 0, 10, 133303, 27713, 0, 0, 0, 0, 0, 'Legion Commander Yorik - OOC - Say (Phase 2)'),
  68. (27857, 0, 17, 0, 1, 2, 100, 0, 23000, 37000, 48000, 53000, 1, 0, 0, 0, 0, 0, 0, 10, 133304, 27713, 0, 0, 0, 0, 0, 'Legion Commander Yorik - OOC - Say (Phase 2)'),
  69. (27857, 0, 18, 0, 1, 2, 100, 0, 10000, 14000, 21000, 34000, 1, 0, 0, 0, 0, 0, 0, 10, 133305, 27713, 0, 0, 0, 0, 0, 'Legion Commander Yorik - OOC - Say (Phase 2)'),
  70. (27857, 0, 19, 20, 19, 0, 100, 0, 12473, 0, 0, 0, 64, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Legion Commander Yorik - On Quest 12473 Accepted - Store Targetlist'),
  71. (27857, 0, 20, 21, 61, 0, 100, 0, 0, 0, 0, 0, 81, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Legion Commander Yorik - On Quest 12473 Accepted - Set NPC Flags'),
  72. (27857, 0, 21, 22, 61, 0, 100, 0, 0, 0, 0, 0, 22, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Legion Commander Yorik - On Quest 12473 Accepted - Set Phase 0'),
  73. (27857, 0, 22, 0, 61, 0, 100, 0, 0, 0, 0, 0, 80, 2785700, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Legion Commander Yorik - On Quest 12473 Accepted - Run Script'),
  74. (27857, 0, 23, 24, 38, 0, 100, 0, 2, 2, 0, 0, 8, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Legion Commander Yorik - On Data Set - Set Agressive'),
  75. (27857, 0, 24, 25, 61, 0, 100, 0, 0, 0, 0, 0, 28, 49735, 0, 0, 0, 0, 0, 17, 0, 200, 0, 0, 0, 0, 0, 'Legion Commander Yorik - On Data Set - Remove Aura'),
  76. (27857, 0, 25, 26, 61, 0, 100, 0, 0, 0, 0, 0, 28, 49735, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Legion Commander Yorik - On Data Set - Remove Aura'),
  77. (27857, 0, 26, 27, 61, 0, 100, 0, 0, 0, 0, 0, 28, 49735, 0, 0, 0, 0, 0, 11, 27713, 200, 0, 0, 0, 0, 0, 'Legion Commander Yorik - On Data Set - Remove Aura'),
  78. (27857, 0, 27, 28, 61, 0, 100, 0, 0, 0, 0, 0, 28, 49735, 0, 0, 0, 0, 0, 11, 26780, 200, 0, 0, 0, 0, 0, 'Legion Commander Yorik - On Data Set - Remove Aura'),
  79. (27857, 0, 28, 0, 61, 0, 100, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 19, 27383, 0, 0, 0, 0, 0, 0, 'Legion Commander Yorik - On Data Set - Attack'),
  80. (27857, 0, 29, 0, 38, 0, 100, 0, 3, 3, 0, 0, 80, 2785701, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Legion Commander Yorik - On Data Set - Run Script'),
  81. (27857, 0, 30, 0, 1, 0, 100, 0, 120000, 120000, 120000, 120000, 22, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Legion Commander Yorik - OOC - S'),
  82. (27857, 0, 31, 0, 40, 0, 100, 0, 1, 27857, 0, 0, 45, 6, 6, 0, 0, 0, 0, 10, 133697, 27851, 0, 0, 0, 0, 0, 'Legion Commander Yorik - On Reached WP1 - Set Data'),
  83. (27857, 0, 32, 33, 38, 0, 100, 0, 1, 1, 0, 0, 8, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Legion Commander Yorik - On Data Set - Set Agressive'),
  84. (27857, 0, 33, 0, 61, 0, 100, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 19, 27383, 0, 0, 0, 0, 0, 0, 'Legion Commander Yorik - On Data Set - Attack'),
  85. (27858, 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 53, 0, 27858, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Highlord Bolvar Fordragon - On Spawn - Start WP'),
  86. (27858, 0, 1, 2, 38, 0, 100, 0, 1, 1, 0, 0, 1, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Highlord Bolvar Fordragon - On Data Set - Say'),
  87. (27858, 0, 2, 3, 61, 0, 100, 0, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Highlord Bolvar Fordragon - On Data Set - Set Home Position'),
  88. (27858, 0, 3, 4, 61, 0, 100, 0, 0, 0, 0, 0, 8, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Highlord Bolvar Fordragon - On Data Set - Set Agressive'),
  89. (27858, 0, 4, 0, 61, 0, 100, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 19, 27383, 0, 0, 0, 0, 0, 0, 'Highlord Bolvar Fordragon - On Data Set Attack'),
  90. (27858, 0, 5, 0, 4, 0, 100, 0, 0, 0, 0, 0, 11, 49765, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Highlord Bolvar Fordragon - On Agro - Cast Fordragons resolve '),
  91. (27858, 0, 6, 0, 40, 0, 100, 0, 1, 27858, 0, 0, 54, 10000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Highlord Bolvar Fordragon - On reached WP1 -Pause WP 10 seconds'),
  92. (26780, 0, 0, 0, 1, 0, 100, 1, 0, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '7th Legion Cleric - Out of Combat - Disable Combat Movement (Phase 1)'),
  93. (26780, 0, 1, 2, 4, 0, 100, 1, 0, 0, 0, 0, 11, 25054, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, '7th Legion Cleric - On Aggro - Cast \'Holy Smite\' (No Repeat)'),
  94. (26780, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '7th Legion Cleric - On Aggro - Increment Phase By 1 (No Repeat)'),
  95. (26780, 0, 3, 0, 9, 1, 100, 0, 0, 40, 3400, 4800, 11, 25054, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, '7th Legion Cleric - Within 0-40 Range - Cast \'Holy Smite\' (No Repeat)'),
  96. (26780, 0, 4, 5, 3, 1, 100, 1, 0, 7, 0, 0, 21, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '7th Legion Cleric - Between 0-7% Mana - Enable Combat Movement (Phase 1) (No Repeat)'),
  97. (26780, 0, 5, 0, 61, 1, 100, 0, 0, 0, 0, 0, 23, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '7th Legion Cleric - Between 0-7% Mana - Increment Phase By 1 (Phase 1) (No Repeat)'),
  98. (26780, 0, 6, 0, 9, 1, 100, 1, 35, 80, 0, 0, 21, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '7th Legion Cleric - Within 35-80 Range - Enable Combat Movement (Phase 1) (No Repeat)'),
  99. (26780, 0, 7, 0, 9, 1, 100, 1, 5, 15, 0, 0, 21, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '7th Legion Cleric - Within 5-15 Range - Disable Combat Movement (Phase 1) (No Repeat)'),
  100. (26780, 0, 8, 0, 9, 1, 100, 1, 0, 5, 0, 0, 21, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '7th Legion Cleric - Within 0-5 Range - Enable Combat Movement (Phase 1) (No Repeat)'),
  101. (26780, 0, 9, 0, 3, 2, 100, 0, 15, 100, 100, 100, 22, 0, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '7th Legion Cleric - Between 15-100% Mana - Decrement Phase By 1 (Phase 1) (No Repeat)'),
  102. (26780, 0, 10, 0, 14, 0, 100, 0, 7000, 40, 17000, 24000, 11, 31739, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, '7th Legion Cleric - Friendly At 7000 Health - Cast \'Heal\' (Phase 1) (No Repeat)'),
  103. (26780, 0, 11, 12, 2, 0, 100, 1, 0, 15, 0, 0, 22, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '7th Legion Cleric - Between 0-15% Health - Set Event Phase 3 (No Repeat)'),
  104. (26780, 0, 12, 13, 61, 0, 100, 0, 0, 0, 0, 0, 21, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '7th Legion Cleric - Between 0-15% Health - Enable Combat Movement (No Repeat)'),
  105. (26780, 0, 13, 0, 61, 0, 100, 0, 0, 0, 0, 0, 25, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '7th Legion Cleric - Between 0-15% Health - Flee For Assist (No Repeat)'),
  106. (26780, 0, 14, 15,38, 0, 100, 0, 1, 1, 0, 0, 11, 25054, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, '7th Legion Cleric - On Data Set - Cast \'Holy Smite\' (No Repeat)'),
  107. (26780, 0, 15, 0, 61, 0, 100, 0, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '7th Legion Cleric - On Data Set - Increment Phase By 1 (No Repeat)'),
  108. (27713, 0, 0, 1, 1, 0, 100, 1, 0, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '7th Legion Elite - Out of Combat - Disable Combat Movement (No Repeat)'),
  109. (27713, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 20, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '7th Legion Elite - Out of Combat - Stop Attacking (No Repeat)'),
  110. (27713, 0, 2, 3, 4, 0, 100, 1, 0, 0, 0, 0, 11, 50092, 2, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, '7th Legion Elite - On Aggro - Cast \'Shoot\' (No Repeat)'),
  111. (27713, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '7th Legion Elite - On Aggro - Increment Phase By 1 (No Repeat)'),
  112. (27713, 0, 4, 5, 9, 1, 100, 0, 5, 30, 2300, 3900, 11, 50092, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, '7th Legion Elite - Within 5-30 Range - Cast \'Shoot\' (Phase 1)'),
  113. (27713, 0, 5, 0, 61, 1, 100, 0, 0, 0, 0, 0, 40, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '7th Legion Elite - Within 5-30 Range - Set Sheath Ranged (Phase 1)'),
  114. (27713, 0, 6, 7, 9, 1, 100, 0, 25, 80, 0, 0, 21, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '7th Legion Elite - Within 25-80 Range - Enable Combat Movement (Phase 1)'),
  115. (27713, 0, 7, 0, 61, 1, 100, 0, 0, 0, 0, 0, 20, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '7th Legion Elite - Within 25-80 Range - Start Attacking (Phase 1)'),
  116. (27713, 0, 8, 9, 9, 1, 100, 0, 0, 5, 0, 0, 21, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '7th Legion Elite - Within 0-5 Range - Enable Combat Movement (Phase 1)'),
  117. (27713, 0, 9, 10, 61, 1, 100, 0, 0, 0, 0, 0, 40, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '7th Legion Elite - Within 0-5 Range - Set Sheath Melee (Phase 1)'),
  118. (27713, 0, 10, 0, 61, 1, 100, 0, 0, 0, 0, 0, 20, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '7th Legion Elite - Within 0-5 Range - Start Attacking (Phase 1)'),
  119. (27713, 0, 12, 0, 61, 1, 100, 0, 0, 0, 0, 0, 20, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '7th Legion Elite - Within 5-15 Range - Stop Attacking (Phase 1)'),
  120. (27713, 0, 11, 12, 9, 1, 100, 0, 5, 15, 0, 0, 21, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '7th Legion Elite - Within 5-15 Range - Disable Combat Movement (Phase 1)'),
  121. (27713, 0, 13, 0, 9, 1, 100, 0, 0, 20, 9000, 12000, 11, 62312, 1, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, '7th Legion Elite - Within 0-20 Range - Cast \'Net\' (Phase 1)'),
  122. (27713, 0, 14, 0, 7, 0, 100, 1, 0, 0, 0, 0, 40, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '7th Legion Elite - On Evade - Set Sheath Melee (Phase 1)'),
  123. (27713, 0, 15, 16 ,38, 0, 100, 0, 1, 1, 0, 0, 11, 50092, 2, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, '7th Legion Elite - On Data Set - Cast \'Shoot\' (No Repeat)'),
  124. (27713, 0, 16, 0, 61, 0, 100, 0, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '7th Legion Elite - On Aggro - Increment Phase By 1 (No Repeat)'),
  125. (2738300, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 19, 27857, 0, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - Script - Say'),
  126. (2738300, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - Script - Set Home Position'),
  127. (2738300, 9, 2, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 22, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - Script - Set Phase 0'),
  128. (2738300, 9, 3, 0, 0, 0, 100, 0, 7000, 7000, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - Script - Say'),
  129. (2738300, 9, 4, 0, 0, 0, 100, 0, 7000, 7000, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - Script - Say'),
  130. (2738300, 9, 5, 0, 0, 0, 100, 0, 7000, 7000, 0, 0, 1, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - Script - Say'),
  131. (2738300, 9, 6, 0, 0, 0, 100, 0, 7000, 7000, 0, 0, 1, 4, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - Script - Say'),
  132. (2738300, 9, 7, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 27858, 1, 900000, 0, 0, 0, 8, 0, 0, 0, 3678.688965,-951.346069,90.707184,1.534565, 'Thel zan the Duskbringer - Script - Say'),
  133. (2738300, 9, 8, 0, 0, 0, 100, 0, 10000, 10000, 0, 0, 1, 5, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - Script - Say'),
  134. (2738300, 9, 9, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 19, 27858, 0, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - Script - Say'),
  135. (2738300, 9, 10, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 1, 1, 0, 0, 0, 0, 0, 19, 27713, 0, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - Script - Say'),
  136. (2738300, 9, 11, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 1, 1, 0, 0, 0, 0, 0, 19, 27858, 0, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - Script - Say'),
  137. (2738300, 9, 12, 0, 0, 0, 100, 0, 10000, 10000, 0, 0, 1, 2, 0, 0, 0, 0, 0, 19, 27858, 0, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - Script - Say'),
  138. (2738300, 9, 13, 0, 0, 0, 100, 0, 7000, 7000, 0, 0, 1, 6, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - Script - Say'),
  139. (2738300, 9, 14, 0, 0, 0, 100, 0, 7000, 7000, 0, 0, 1, 7, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - Script - Say'),
  140. (2738300, 9, 15, 0, 0, 0, 100, 0, 0, 0, 0, 0, 11, 49808, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - Script - Cast Minions of Thel zan'),
  141. (2738300, 9, 16, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 28, 49735, 0, 0, 0, 0, 0, 19, 27857, 0, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - Script - Set Data'),
  142. (2738300, 9, 17, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 2, 2, 0, 0, 0, 0, 19, 27857, 0, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - Script - Set Data'),
  143. (2738300, 9, 18, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 19, 27858, 0, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - Script - Set Data'),
  144. (2738300, 9, 19, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 11, 27713, 200, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - Script - Set Data'),
  145. (2738300, 9, 20, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 11, 26780, 200, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - Script - Set Data'),
  146. (2738300, 9, 21, 0, 0, 0, 100, 0, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - Script - Set Phase 1'),
  147. (2738300, 9, 22, 0, 0, 0, 100, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 21, 100, 0, 0, 0, 0, 0, 0, 'Thel zan the Duskbringer - Script - Attack'),
  148.  
  149. (2785700, 9, 0, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 'Legion Commander Yorik - Script - Say'),
  150. (2785700, 9, 1, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 53, 0, 27857, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 'Legion Commander Yorik - Script - Start WP'),
  151. (2785700, 9, 2, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 45, 5, 5, 0, 0, 0, 0, 10, 133697, 27851, 0, 0, 0, 0, 0, 'Legion Commander Yorik - Script - Set Data'),
  152. (2785700, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 10, 133700, 27851, 0, 0, 0, 0, 0, 'Legion Commander Yorik - Script - Set Data'),
  153. (2785700, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 10, 133701, 27851, 0, 0, 0, 0, 0, 'Legion Commander Yorik - Script - Set Data'),
  154. (2785700, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 10, 133702, 27851, 0, 0, 0, 0, 0, 'Legion Commander Yorik - Script - Set Data'),
  155. (2785700, 9, 6, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 10, 133694, 27851, 0, 0, 0, 0, 0, 'Legion Commander Yorik - Script - Set Data'),
  156. (2785700, 9, 7, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 10, 133698, 27851, 0, 0, 0, 0, 0, 'Legion Commander Yorik - Script - Set Data'),
  157. (2785700, 9, 8, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 10, 133699, 27851, 0, 0, 0, 0, 0, 'Legion Commander Yorik - Script - Set Data'),
  158. (2785700, 9, 9, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 'Legion Commander Yorik - Script - Say'),
  159. (2785700, 9, 10, 0, 0, 0, 100, 0, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Legion Commander Yorik - Script - Set Home Position'),
  160. (2785700, 9, 11, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 45, 3, 3, 0, 0, 0, 0, 10, 133695, 27851, 0, 0, 0, 0, 0, 'Legion Commander Yorik - Script - Set Data'),
  161. (2785701, 9, 0, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 1, 4, 0, 0, 0, 0, 0, 19, 27858, 0, 0, 0, 0, 0, 0, 'Legion Commander Yorik - Script 2 - Say'),
  162. (2785701, 9, 1, 0, 0, 0, 100, 0, 7000, 7000, 0, 0, 1, 5, 0, 0, 0, 0, 0, 19, 27858, 0, 0, 0, 0, 0, 0, 'Legion Commander Yorik - Script 2 - Say'),
  163. (2785701, 9, 2, 0, 0, 0, 100, 0, 7000, 7000, 0, 0, 41, 0, 0, 0, 0, 0, 0, 19, 27858, 0, 0, 0, 0, 0, 0, 'Legion Commander Yorik - Script 2 - Despawn'),
  164. (2785701, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Legion Commander Yorik - Script 2 - Despawn');
  165.  
  166. DELETE FROM `creature_text` WHERE `entry`IN(27383,27857,27858,27713);
  167. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES
  168. (27383, 0, 0, 'I was... once like you. Mortal. Soft. Only flesh and bone. WEAK AND TIMID!', 14, 0, 100, 0, 0, 0, 'Thel zan the Duskbringer'),
  169. (27383, 1, 0, 'Our lord, Arthas saw in me the frailty of man.', 14, 0, 100, 0, 0, 0, 'Thel zan the Duskbringer'),
  170. (27383, 2, 0, '"Serve me in life and I will promise to rend the weakness from your soul. To erase it from existence!" To be chosen... blessed by the Lich King in such a way.', 14, 0, 100, 0, 0, 0, 'Thel zan the Duskbringer'),
  171. (27383, 3, 0, 'So serve him I did... Were it not for me the glorious dread citadel of Naxxramas may never have returned to Northrend.', 14, 0, 100, 0, 0, 0, 'Thel zan the Duskbringer'),
  172. (27383, 4, 0, 'But enough talk... You have fought hard and come from the distant reaches of this world to face the Duskbringer. I shall not disappoint...', 14, 0, 100, 0, 0, 0, 'Thel zan the Duskbringer'),
  173. (27383, 5, 0, 'Just as our lord saved me, so too shall I save you!', 14, 0, 100, 0, 0, 0, 'Thel zan the Duskbringer'),
  174. (27383, 6, 0, 'THIS WILL BE THE LAST TIME YOU UTTER THAT NAME, PALADIN! Breathe your dying breath!', 14, 0, 100, 0, 0, 0, 'Thel zan the Duskbringer'),
  175. (27383, 7, 0, 'Rise, my minions! Your master commands it!', 14, 0, 100, 0, 0, 0, 'Thel zan the Duskbringer'),
  176. (27857, 0, 0, 'Steel yourselves, soldiers. $N has provided us us with the final piece of this puzzle. The dread lich, Thel''zan, will soon come out of hiding, only to be rendered powerless against us!', 12, 0, 100, 0, 0, 0, 'Legion Commander Yorik'),
  177. (27857, 1, 0, 'It is this phylactery, Thel''zan''s phylactery - that is the key to this victory!', 12, 0, 100, 0, 0, 0, 'Legion Commander Yorik'),
  178. (27857, 2, 0, 'LEGION, STEADY YOURSELVES!', 12, 0, 100, 0, 0, 0, 'Legion Commander Yorik'),
  179. (27858, 0, 0, 'Honor, courage, compassion and justice! Those were once the virtues you fought for as a cleric of the Argent Dawn, Thel''zan.', 14, 0, 100, 0, 0, 0, 'Highlord Bolvar Fordragon'),
  180. (27858, 1, 0, 'You dedicated your whole life to fighting the Scourge. You saw what they did to our beloved Lordaeron. The Lich King took everything from you!', 14, 0, 100, 0, 0, 0, 'Highlord Bolvar Fordragon'),
  181. (27858, 2, 0, 'So how, then, did Father Inigo Montoy, bastion of virtue for the Argent Dawn, become the embodiment of that which he hated most?', 12, 0, 100, 0, 0, 0, 'Highlord Bolvar Fordragon'),
  182. (27858, 3, 0, 'Now, be free and join the battle! Let us end this together!', 12, 0, 100, 0, 0, 0, 'Highlord Bolvar Fordragon'),
  183. (27858, 4, 0, 'Victory for the Alliance!', 14, 0, 100, 0, 0, 0, 'Highlord Bolvar Fordragon'),
  184. (27858, 5, 0, 'You have saved Wintergarde! With Thel''zan''s filth washed away, the 7th Legion will easily clean up the remaining Scourge. When you are done here, report to Angrathar!', 12, 0, 100, 0, 0, 0, 'Highlord Bolvar Fordragon'),
  185. (27713, 0, 0, 'What is it?', 12, 0, 100, 0, 0, 0, '7th Legion Elite'),
  186. (27713, 0, 1, 'Is this the end? If we stop this bastard now, is victory assured at the Wrathgate?', 12, 0, 100, 0, 0, 0, '7th Legion Elite'),
  187. (27713, 0, 2, 'Let it be known that it has been an honor and a privilege fighting alongside all of you.', 12, 0, 100, 0, 0, 0, '7th Legion Elite'),
  188. (27713, 0, 3, 'Death comes for us all eventually, but sometimes it comes a little faster than anticipated. Today we call that blind heroics... Tomorrow someone may call it stupidity.', 12, 0, 100, 0, 0, 0, '7th Legion Elite'),
  189. (27713, 0, 4, 'Come on... Let''s get this over with!', 12, 0, 100, 0, 0, 0, '7th Legion Elite'),
  190. (27713, 0, 5, 'It looks like a gateway to hell!', 12, 0, 100, 0, 0, 0, '7th Legion Elite'),
  191. (27713, 0, 6, 'I''m getting a little worried. Where is this hero that is supposed to lead us into battle?', 12, 0, 100, 0, 0, 0, '7th Legion Elite'),
  192. (27713, 0, 7, 'If I don''t make it back to Wintergarde, let my family know that I did my best and that I love them...', 12, 0, 100, 0, 0, 0, '7th Legion Elite'),
  193. (27713, 1, 0, 'It''s the Highlord!', 12, 0, 100, 0, 0, 0, '7th Legion Elite');
  194.  
  195. DELETE FROM `waypoints` WHERE `entry`IN(27383,27857,27858);
  196. INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES
  197. (27857, 1, 3681.841309,-917.651672,76.984685, 'Legion Commander Yorik'),
  198. (27858, 1, 3681.391113,-930.485779,78.656433, 'Highlord Bolvar Fordragon'),
  199. (27858, 2, 3679.555664,-914.486389,77.093231, 'Highlord Bolvar Fordragon'),
  200. (27383, 1, 3681.604, -912.2283, 77.64017, 'Thel zan the Duskbringer');
  201.  
  202.  
  203.  
  204. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`IN(49734,49735);
  205. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  206. (13, 1, 49734, 0, 0, 31, 0, 3, 27851, 0, 0, 0, 0, '', 'Thel zan Intro Beams targets Thel zan Spell Dummy'),
  207. (13, 3, 49735, 0, 0, 31, 0, 3, 27713, 0, 0, 0, 0, '', 'Terrifying Countenance targets 7th Legion Elite'),
  208. (13, 3, 49735, 0, 1, 31, 0, 3, 27857, 0, 0, 0, 0, '', 'Terrifying Countenance targets Legion Commander Yorik'),
  209. (13, 3, 49735, 0, 2, 31, 0, 3, 26780, 0, 0, 0, 0, '', 'Terrifying Countenance targets 7th Legion Clerick'),
  210. (13, 3, 49735, 0, 3, 31, 0, 4, 0, 0, 0, 0, 0, '', 'Terrifying Countenance targets Player');
  211.  
  212. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceEntry` IN(27713,26780);
  213. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  214. (22, 3, 27713, 0, 0, 29, 0, 27383, 200, 0, 1, 0, 0, '', 'Only run SAI if no Thel zan the Duskbringer near'),
  215. (22, 2, 26780, 0, 0, 29, 0, 27383, 200, 0, 1, 0, 0, '', 'Only run SAI if no Thel zan the Duskbringer near');
  216.  
  217. DELETE FROM `smart_scripts` WHERE `entryorguid`=27851 AND `source_type`=0 AND `id` IN(0,1);
  218. DELETE FROM `smart_scripts` WHERE `entryorguid`=27879 AND `source_type`=0;
  219. DELETE FROM `smart_scripts` WHERE `entryorguid`=2785100 AND `source_type`=9;
  220. DELETE FROM `smart_scripts` WHERE `entryorguid`=2787900 AND `source_type`=9;
  221.  
  222. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=27879;
  223.  
  224. 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
  225. (27879, 0, 0, 1, 54, 0, 100, 0, 0, 0, 0, 0, 3, 0, 17200, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Frostmourne Cavern Quest Credit - On Just Summoned - Morph To Model 17200 (Phase 1)'),
  226. (27879, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 80, 2787900, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Frostmourne Cavern Quest Credit - On Just Summoned - Run Script (Phase 1)'),
  227. (2787900, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Frostmourne Cavern Quest Credit - On Script - Say Line 0'),
  228. (2787900, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 11, 33271, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Frostmourne Cavern Quest Credit - On Script - Cast \'Internal Shake Camera w/ rumble sound\''),
  229. (2787900, 9, 2, 0, 0, 0, 100, 0, 7000, 7000, 0, 0, 12, 27480, 3, 116000, 0, 0, 0, 8, 0, 0, 0, 4817.49, -579.605, 163.096, 5.10213, 'Frostmourne Cavern Quest Credit - On Script - Summon Creature \'Muradin\''),
  230. (2787900, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 27455, 3, 102000, 0, 0, 0, 8, 0, 0, 0, 4821.53, -579.882, 163.594, 4.16751, 'Frostmourne Cavern Quest Credit - On Script - Summon Creature \'Prince Arthas\''),
  231. (2787900, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 9, 0, 0, 0, 0, 0, 0, 20, 190332, 5, 0, 0, 0, 0, 0, 'Frostmourne Cavern Quest Credit - On Script - Activate Gameobject'),
  232. (2787900, 9, 5, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 1, 4, 0, 0, 0, 0, 0, 19, 27455, 10, 0, 0, 0, 0, 0, 'Frostmourne Cavern Quest Credit - On Script - Say Line 4'),
  233. (2787900, 9, 6, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 5, 25, 0, 0, 0, 0, 0, 19, 27455, 10, 0, 0, 0, 0, 0, 'Frostmourne Cavern Quest Credit - On Script - Play Emote 25'),
  234. (2787900, 9, 7, 0, 0, 0, 100, 0, 3500, 3500, 0, 0, 45, 0, 10, 0, 0, 0, 0, 19, 27480, 10, 0, 0, 0, 0, 0, 'Frostmourne Cavern Quest Credit - On Script - Set Data 0 10');
  235.  
  236. UPDATE `creature_text` SET `entry`=27879 WHERE `entry`=27851 AND `groupid`=0 AND `id`=0;
  237. UPDATE `conditions` SET `SourceEntry`=27879 WHERE `SourceTypeOrReferenceId`=22 AND `SourceGroup`=2 AND `SourceEntry`=27851 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=29 AND `ConditionTarget`=0 AND `ConditionValue1`=27480 AND `ConditionValue2`=100 AND `ConditionValue3`=0;
  238. UPDATE `event_scripts` SET `datalong`=27879 WHERE `id`=18281;
  239. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN (27857, 27858, 26786, 27713, 27383);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!