Advertisement
Guest User

Fix 12581 A hero's Burden + Oracles / Frenzyheart Rep Swappi

a guest
Oct 9th, 2013
130
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 16.32 KB | None | 0 0
  1. DELETE FROM `creature_questender` WHERE `id` IN (28668,28667) AND `quest` IN (12582, 12689);
  2. INSERT INTO `creature_questender` (`id`, `quest`) VALUES
  3. (28668, 12582),  -- Zepik the Gorloc Hunter q12582 Frenzyheart Champion
  4. (28667, 12689);  -- Jaloot q1  2689 Hand of the Oracles
  5.  
  6. UPDATE `creature_queststarter` SET `id`=28668 WHERE `quest`=12582;
  7.  
  8. UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`= 28659;
  9.  
  10. DELETE FROM `creature_ai_scripts` WHERE `creature_id`=28659;
  11. DELETE FROM `smart_scripts` WHERE `entryorguid`=28659;
  12. 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
  13. (28659, 0, 0, 1, 11, 0, 100, 0, 0, 0, 0, 0, 70, 0, 0, 0, 0, 0, 0, 10, 202969, 28667, 0, 0, 0, 0, 0, "Artruis the Heartless - On Respawn- Respawn Jaloot"),
  14. (28659, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 70, 0, 0, 0, 0, 0, 0, 10, 202970, 28668, 0, 0, 0, 0, 0, "Artruis the Heartless - Linked with Previous Event - Respawn Zephik"),
  15. (28659, 0, 2, 0, 0, 0, 100, 0, 5000, 9000, 9000, 15000, 11, 15530, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, "Artruis the Heartless - Cast Frostbolt (Phase 1)"),
  16. (28659, 0, 3, 0, 0, 0, 100, 0, 7000, 11000, 11000, 15000, 11, 54261, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, "Artruis the Heartless - Cast Ice Lance (Phase 1)"),
  17. (28659, 0, 4, 0, 0, 0, 100, 0, 5000, 10000, 14000, 18000, 11, 11831, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,  "Artruis the Heartless - Cast Frost Nova (Phase 1)"),
  18. (28659, 0, 5, 0, 0, 0, 100, 0, 9000, 13000, 25000, 35000, 11, 54792, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,  "Artruis the Heartless - Cast Icy Veins (Phase 1)"),
  19. (28659, 0, 6,19, 6, 0, 100, 0, 0, 0, 0, 0, 11, 52518, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Artruis the Heartless - On death - Spawn Artruis' Phylactery"),
  20. (28659, 0, 7, 8, 2, 0, 100, 1, 0, 30, 0, 0, 11, 52185, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Artruis the Heartless - At 20% Hp Cast Bindings of Submission"),
  21. (28659, 0, 8, 9, 61, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 10, 202969, 28667, 0, 0, 0, 0, 0, "Artruis the Heartless - Linked with Previous Event - Send Data 1 1 to Jaloot"),
  22. (28659, 0, 9, 23, 61, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 10, 202970, 28668, 0, 0, 0, 0, 0, "Artruis the Heartless - Linked with Previous Event - Send Data 1 1 to Zephik"),
  23. (28659, 0, 10, 11, 25, 0, 100, 0, 0, 0, 0, 0, 45, 1, 2, 0, 0, 0, 0, 10, 202969, 28667, 0, 0, 0, 0, 0, "Artruis the Heartless - On Reset - Send Data 1 2 to Jaloot"),
  24. (28659, 0, 11, 0, 61, 0, 100, 0, 0, 0, 0, 0, 45, 1, 2, 0, 0, 0, 0, 10, 202970, 28668, 0, 0, 0, 0, 0, "Artruis the Heartless - Linked with Previous Event - Send Data 1 2 to Zephik"),
  25. (28659, 0, 12, 13, 38, 0, 100, 0, 1, 2, 0, 0, 45, 1, 3, 0, 0, 0, 0, 10, 202969, 28667, 0, 0, 0, 0, 0, "Artruis the Heartless - On Receive Data 1 2- Send Data 1 3 to Jaloot"),
  26. (28659, 0, 13, 14, 61, 0, 100, 0, 0, 0, 0, 0, 28, 52185, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Artruis the Heartless - Linked with Previous Event - Remove Bindings of Submission"),
  27. (28659, 0, 14,  0, 61, 0, 100, 0, 0, 0, 0, 0, 45, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Artruis the Heartless - Linked with Previous Event - Set Data 1 0"),
  28. (28659, 0, 17, 18, 4, 0, 100, 0, 0, 0, 0, 0, 70, 0, 0, 0, 0, 0, 0, 10, 202969, 28667, 0, 0, 0, 0, 0, "Artruis the Heartless - On Agro- Respawn Jaloot"),
  29. (28659, 0, 18, 21, 61, 0, 100, 0, 0, 0, 0, 0, 70, 0, 0, 0, 0, 0, 0, 10, 202970, 28668, 0, 0, 0, 0, 0, "Artruis the Heartless - Linked with Previous Event - Respawn Zephik"),
  30. (28659, 0, 19, 20, 61, 0, 100, 0, 0, 0, 0, 0, 45, 1, 4, 0, 0, 0, 0, 10, 202969, 28667, 0, 0, 0, 0, 0, "Artruis the Heartless - Linked with Previous Event- Send Data 1 4 to Jaloot"),
  31. (28659, 0, 20, 0, 61, 0, 100, 0, 0, 0, 0, 0, 45, 1, 4, 0, 0, 0, 0, 10, 202970, 28668, 0, 0, 0, 0, 0, "Artruis the Heartless - Linked with Previous Event - Send Data 1 4 to Zephik"),
  32. (28659, 0, 21, 0, 61, 0, 100, 0, 0, 0, 0, 0, 1, 0, 10000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Artruis the Heartless - Linked with Previous Event - Say Line 0"),
  33. (28659, 0, 22, 0, 52, 0, 100, 0, 0, 28659, 0, 0, 1, 1, 10000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Artruis the Heartless - On Text Over Line 0 - Say Line 1"),
  34. (28659, 0, 23, 24, 61, 0, 100, 0, 0, 0, 0, 0, 1, 2, 10000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Artruis the Heartless - Linked with Previous Event - Say Line 2"),
  35. (28659, 0, 24, 0, 61, 0, 100, 0, 0, 0, 0, 0, 1, 3, 10000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Artruis the Heartless - Linked with Previous Event - Say Line 3"),
  36. (28659, 0, 25, 26, 38, 0, 100, 0, 1, 1, 0, 0, 45, 1, 5, 0, 0, 0, 0, 10, 202970, 28668, 0, 0, 0, 0, 0, "Artruis the Heartless - On Receive Data 1 1- Send Data 1 5 to Zepik"),
  37. (28659, 0, 26, 27, 61, 0, 100, 0, 0, 0, 0, 0, 28, 52185, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Artruis the Heartless - Linked with Previous Event - Remove Bindings of Submission"),
  38. (28659, 0, 27,  0, 61, 0, 100, 0, 0, 0, 0, 0, 45, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Artruis the Heartless - Linked with Previous Event - Set Data 1 0");
  39.  
  40. DELETE FROM `creature_text` WHERE `entry` =28659;
  41. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES
  42. (28659, 0, 0, 'Ah, the hero.  Your little friends said you would come.  This certainly saves me the trouble of hunting you down myself. ', 14, 0, 100, 0, 0, 0, 'Artruis the Heartless'),
  43. (28659, 1, 0, 'Even shattered into countless pieces, the crystals all around weaken me...  perhaps I should not have underestimated the titans so...', 14, 0, 100, 0, 0, 0, 'Artruis the Heartless'),
  44. (28659, 2, 0, 'These two brave, ignorant fools despise each other, yet somehow they both spoke as you as a hero.  Perhaps you just lack the will to choose a side...  let me extend you that opportunity',14, 0, 100, 0, 0, 0, 'Artruis the Heartless'),
  45. (28659, 3, 0, 'Artruis is shielded. You must choose your side quickly to break the spell.',41, 0, 100, 0, 0, 0, 'Artruis the Heartless');
  46.  
  47. UPDATE `creature_template` SET `AIName`= 'SmartAI',`npcflag`=0,`unit_flags`=32832 WHERE `entry`= 28667;
  48. DELETE FROM `smart_scripts` WHERE `entryorguid`=28667;
  49. 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
  50. (28667, 0, 0, 1, 11, 0, 100, 0, 0, 0, 0, 0, 81, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Jaloot - On Spawn - Remove quest giver flag"),
  51. (28667, 0, 1, 21, 61, 0, 100, 0, 0, 0, 0, 0, 18, 512, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Jaloot - Linked with Previous Event - Set Unit Flags"),
  52. (28667, 0, 2, 3, 38, 0, 100, 0, 1, 1, 0, 0, 2, 14, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Jaloot - On Data Set 1 1 - Set Hostile"),
  53. (28667, 0, 3, 16, 61, 0, 100, 0, 0, 0, 0, 0, 28, 52182, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Jaloot - Linked with Previous Event - Remove Tomb of the Heartless"),
  54. (28667, 0, 4, 5, 38, 0, 100, 0, 1, 2, 0, 0, 2, 250, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Jaloot - On Data Set 1 2 - Set Friendly"),
  55. (28667, 0, 5, 15, 61, 0, 100, 0, 0, 0, 0, 0, 18, 512, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Jaloot - Linked with Previous Event - Set Unit Flags"),
  56. (28667, 0, 6, 0, 6, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 10, 202971, 28659, 0, 0, 0, 0, 0, "Jaloot - On Death - Send Data 1 1 to Artruis"),
  57. (28667, 0, 7, 8, 38, 0, 100, 0, 1, 3, 0, 0, 2, 250, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Jaloot - On Data Set 1 3 - Set Friendly"),
  58. (28667, 0, 8, 9, 61, 0, 100, 0, 0, 0, 0, 0, 19, 512, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Jaloot - Linked with Previous Event - Remove Unit Flags"),
  59. (28667, 0, 9, 10, 61, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Jaloot - Linked with Previous Event - Say Line 0"),
  60. (28667, 0, 10,23, 61, 0, 100, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 10, 202971, 28659, 0, 0, 0, 0, 0, "Jaloot - Linked with Previous Event - Attack Artruis"),
  61. (28667, 0, 11,12, 38, 0, 100, 0, 1, 4, 0, 0, 2, 250, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Jaloot - On Data Set 1 4 - Set Friendly"),
  62. (28667, 0, 12,13, 61, 0, 100, 0, 0, 0, 0, 0, 18, 512, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Jaloot - Linked with Previous Event - Set Unit Flags"),
  63. (28667, 0, 13,14, 61, 0, 100, 0, 0, 0, 0, 0, 81, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Jaloot - Linked with Previous Event - Add quest giver flag"),
  64. (28667, 0, 14,22 , 61, 0, 100, 0, 0, 0, 0, 0, 41, 120000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Jaloot - Linked with Previous Event - Despawn After 2 mins"),
  65. (28667, 0, 15,0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 52182, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Jaloot - Linked with Previous Event - Cast Tomb of the Heartless"),
  66. (28667, 0, 16, 0, 61, 0, 100, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 18, 40, 0, 0, 0, 0, 0, 0, "Jaloot - Linked with Previous Event - Attack"),
  67. (28667, 0, 17, 0, 0, 0, 100, 0, 9000, 15000, 20000, 25000, 11, 52943, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, "Jaloot - IC - Cast Lightning Whirl"),
  68. (28667, 0, 18, 0, 0, 0, 100, 0, 5000, 8000, 15000, 18000, 11, 52944, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, "Jaloot - IC - Cast Lightning Strike"),
  69. (28667, 0, 19, 0, 0, 0, 100, 0, 7000, 15000, 20000, 25000, 11, 52964, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, "Jaloot - IC - Cast Spark Frenzy"),
  70. (28667, 0, 20, 0, 2, 0, 100, 0, 0, 30, 9000, 12000, 11, 52969, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Jaloot - On Less than 30% HP - Cast Energy Siphon"),
  71. (28667, 0, 21,0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 52182, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Jaloot - Linked with Previous Event - Cast Tomb of the Heartless"),
  72. (28667, 0, 22,0, 61, 0, 100, 0, 0, 0, 0, 0, 24, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Jaloot - Linked with Previous Event - Evade"),
  73. (28667, 0, 23,0, 61, 0, 100, 0, 0, 0, 0, 0, 28, 52185, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Jaloot - Linked with Previous Event - Remove Bindings of Submission");
  74.  
  75. DELETE FROM `creature_text` WHERE `entry` =28667;
  76. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES
  77. (28667, 0, 0, 'Now you not catch us with back turned.  Now we hurt you bad undead. BAD!', 12, 0, 100, 0, 0, 0, 'Jaloot');
  78.  
  79. UPDATE `creature_template` SET `AIName`= 'SmartAI',`npcflag`=0,`unit_flags`=32832 WHERE `entry`= 28668;
  80. DELETE FROM `smart_scripts` WHERE `entryorguid`=28668;
  81. 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
  82. (28668, 0, 0, 1, 11, 0, 100, 1, 0, 0, 0, 0, 81, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Zepik the Gorloc Hunter - On Spawn - Remove quest giver flag"),
  83. (28668, 0, 1, 23, 61, 0, 100, 1, 0, 0, 0, 0, 18, 512, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Zepik the Gorloc Hunter - Linked with Previous Event - Set Unit Flags"),
  84. (28668, 0, 2, 3, 38, 0, 100, 0, 1, 1, 0, 0, 2, 14, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Zepik the Gorloc Hunter - On Data Set 1 1 - Set Hostile"),
  85. (28668, 0, 3, 16, 61, 0, 100, 0, 0, 0, 0, 0, 28, 52182, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Zepik the Gorloc Hunter - Linked with Previous Event - Remove Tomb of the Heartless"),
  86. (28668, 0, 4, 5, 38, 0, 100, 0, 1, 2, 0, 0, 2, 250, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Zepik the Gorloc Hunter - On Data Set 1 2 - Set Friendly"),
  87. (28668, 0, 5, 15, 61, 0, 100, 0, 0, 0, 0, 0, 18, 512, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Zepik the Gorloc Hunter - Linked with Previous Event - Set Unit Flags"),
  88. (28668, 0, 6, 0, 6, 0, 100, 0, 0, 0, 0, 0, 45, 1, 2, 0, 0, 0, 0, 10, 202971, 28659, 0, 0, 0, 0, 0, "Zepik the Gorloc Hunter - On Death - Send Data 1 2 to Artruis"),
  89. (28668, 0, 7, 8, 38, 0, 100, 0, 1, 5, 0, 0, 2, 250, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Zepik the Gorloc Hunter - On Data Set 1 5 - Set Friendly"),
  90. (28668, 0, 8, 9, 61, 0, 100, 0, 0, 0, 0, 0, 19, 512, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Zepik the Gorloc Hunter - Linked with Previous Event - Remove Unit Flags"),
  91. (28668, 0, 9, 10, 61, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Zepik the Gorloc Hunter - Linked with Previous Event - Say Line 0"),
  92. (28668, 0, 10,25, 61, 0, 100, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 10, 202971, 28659, 0, 0, 0, 0, 0, "Zepik the Gorloc Hunter - Linked with Previous Event - Attack Artruis"),
  93. (28668, 0, 11,12, 38, 0, 100, 0, 1, 4, 0, 0, 2, 250, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Zepik the Gorloc Hunter - On Data Set 1 4 - Set Friendly"),
  94. (28668, 0, 12,13, 61, 0, 100, 0, 0, 0, 0, 0, 18, 512, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Zepik the Gorloc Hunter - Linked with Previous Event - Set Unit Flags"),
  95. (28668, 0, 13,14, 61, 0, 100, 0, 0, 0, 0, 0, 81, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Zepik the Gorloc Hunter - Linked with Previous Event - Add quest giver flag"),
  96. (28668, 0, 14,24 ,61, 0, 100, 0, 0, 0, 0, 0, 41, 120000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Zepik the Gorloc Hunter - Linked with Previous Event - Despawn After 2 mins"),
  97. (28668, 0, 15,0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 52182, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Zepik the Gorloc Hunter - Linked with Previous Event - Cast Tomb of the Heartless"),
  98. (28668, 0, 16, 0, 61, 0, 100, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 18, 40, 0, 0, 0, 0, 0, 0, "Zepik the Gorloc Hunter - Linked with Previous Event - Attack"),
  99. (28668, 0, 17, 0, 0, 0, 100, 0, 4000, 7000, 15000, 18000, 11, 52761, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, "Zepik the Gorloc Hunter - IC - Cast Barbed Net"),
  100. (28668, 0, 18, 0, 0, 0, 100, 0, 5000, 8000, 12000, 15000, 11, 52889, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, "Zepik the Gorloc Hunter - IC - Cast Envenomed Shot"),
  101. (28668, 0, 19, 0, 0, 0, 100, 0, 0, 6000, 15000, 18000, 11, 52873, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, "Zepik the Gorloc Hunter - IC - Cast Open Wound"),
  102. (28668, 0, 20, 0, 0, 0, 100, 0, 3000, 5000, 3000, 7000, 11, 52758, 2, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, "Zepik the Gorloc Hunter - IC - Cast Piercing Arrow"),
  103. (28668, 0, 21, 0, 0, 0, 100, 0, 6000, 12000, 30000, 40000, 11, 52886, 2, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, "Zepik the Gorloc Hunter - IC - Cast Spike Trap"),
  104. (28668, 0, 22, 0, 2, 0, 100, 0, 0, 30, 30000, 30000, 11, 52895, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Zepik the Gorloc Hunter - On Less than 30% HP Cast Bandage - Cast Bandage"),
  105. (28668, 0, 23,0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 52182, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Zepik the Gorloc Hunter - Linked with Previous Event - Cast Tomb of the Heartless"),
  106. (28668, 0, 24,0, 61, 0, 100, 0, 0, 0, 0, 0, 24, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Zepik the Gorloc Hunter - Linked with Previous Event - Evade"),
  107. (28668, 0, 25,0, 61, 0, 100, 0, 0, 0, 0, 0, 28, 52185, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Zepik the Gorloc Hunter - Linked with Previous Event - Remove Bindings of Submission");
  108.  
  109. DELETE FROM `creature_text` WHERE `entry` =28668;
  110. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES
  111. (28668, 0, 0, 'You going die big bad undead thing! You not catch Zepik sleeping this time!', 12, 0, 100, 0, 0, 0, 'Zepik the Gorloc Hunter');
  112.  
  113. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceGroup`=1 AND `SourceEntry`=52185;
  114. INSERT INTO `conditions` VALUES
  115. (13,1,52185,0,0,31,0,3,28668,0,0,0,0,'','bindings of submission can hit Zepik the Gorloc Hunter'),
  116. (13,1,52185,0,1,31,0,3,28667,0,0,0,0,'','bindings of submission can hit Jaloot'),
  117. (13,1,52185,0,2,31,0,3,28659,0,0,0,0,'','bindings of submission can hit Artruis the Heartless');
  118.  
  119. UPDATE `creature_template` SET `npcflag`=`npcflag`&2 WHERE `entry` IN (28667,28668);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement