API tools faq
paste
Advertisement
gecko32

Rare Elites Fix By Shlomi1515, Modifed for SAI

gecko32
Oct 1st, 2011
139
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 12.67 KB | None | 0 0
raw download clone embed print report
  1. -- Rare Mob Fix/Update rewrite using smartAI
  2. -- orginal http://pastebin.com/Wf87NbTE shlomi1515
  3. -- Tukemuth
  4. DELETE FROM `smart_scripts` WHERE `entryorguid`=32400;
  5. 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
  6. (32400, 0, 0, 0, 9, 0, 100, 0, 0, 5, 9000, 13000, 11, 50410, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Tukemuth - Cast Tusk Strike'),
  7. (32400, 0, 1, 0, 0, 0, 100, 0, 9000, 17000, 15000, 22000, 11, 57066, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Tukemuth - Cast Trample');
  8. UPDATE `creature_template` SET faction_A=7, faction_H=7, mindmg=2926.0, maxdmg=3542.0, skinloot=70209, spell1=50410, spell2=57066, attackpower=3384, dmg_multiplier=1.0,AIName='SmartAI', mechanic_immune_mask=2147483647 WHERE entry=32400;
  9. -- Fumblub Gearwind
  10. DELETE FROM `smart_scripts` WHERE `entryorguid`=32358;
  11. 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
  12. (32358, 0, 0, 0, 0, 0, 100, 0, 4000, 6000, 12000, 15000, 11, 60906, 1, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Fumblub Gearwind - Cast Machine Gun');
  13. UPDATE `creature_template` SET faction_A=14, faction_H=14, mindmg=2792, maxdmg=3376, spell1=60906, attackpower=3384, dmg_multiplier=1.0,AIName='SmartAI', mechanic_immune_mask=2147483647, type_flags=2048, InhabitType=4 WHERE entry=32358;
  14. UPDATE `creature_addon` SET mount=22719, bytes1=33554432 WHERE guid=151938;
  15. -- Crystalbark
  16. DELETE FROM `smart_scripts` WHERE `entryorguid`=32357;
  17. 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
  18. (32357, 0, 0, 0, 0, 0, 100, 0, 3700, 16200, 19200, 28000, 11, 50506, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Old Crystalbark - Cast Mark of Detonation'),
  19. (32357, 0, 1, 0, 0, 0, 100, 0, 1625, 8100, 9600, 14000, 11, 60903, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Old Crystalbark - Cast Arcane Breath');
  20. UPDATE `creature_template` SET faction_A=7, faction_H=7, mindmg=3231.0, maxdmg=3309.0, spell1=60903, spell2=50506, attackpower=3214, dmg_multiplier=1.0,AIName='SmartAI', mechanic_immune_mask=2147483647 WHERE entry=32357;
  21. -- Terror Spinner
  22. DELETE FROM `smart_scripts` WHERE `entryorguid`=32475;
  23. 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
  24. (32475, 0, 0, 0, 0, 0, 100, 0, 4000, 6000, 12000, 15000, 11, 36839, 1, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Terror Spinner - Cast Impairing Poison'),
  25. (32475, 0, 1, 0, 0, 0, 100, 0, 1625, 8100, 9600, 14000, 11, 28428, 1, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Terror Spinner - Cast Instant Poison');
  26. UPDATE `creature_template` SET faction_A=14, faction_H=14, mindmg=3625.0, maxdmg=4301.0, spell1=32475, spell2=28428, attackpower=3963, dmg_multiplier=1.0,AIName='SmartAI', mechanic_immune_mask=66624, name='Terror Spinner' WHERE entry=32475;
  27. -- Hildana Deathstealer
  28. DELETE FROM `smart_scripts` WHERE `entryorguid`=32495;
  29. 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
  30. (32495, 0, 0, 0, 0, 0, 100, 1, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Hildana Deathstealer - Enter phase 1'),
  31. (32495, 0, 1, 2, 0, 1, 100, 0, 3000, 6000, 4000, 6000, 11, 60991, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Hildana Deathstealer - Cast Lash'),
  32. (32495, 0, 2, 0, 61, 1, 100, 0, 0, 0, 0, 0, 22, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Hildana Deathstealer - Enter phase 2'),
  33. (32495, 0, 3, 0, 0, 2, 100, 0, 3000, 5000, 9000, 11000, 11, 57547, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Hildana Deathstealer - Cast Touch of the Valkyr'),
  34. (32495, 0, 4, 0, 0, 2, 100, 0, 12000, 13000, 13000, 15000, 22, 1, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Hildana Deathstealer - timer back to phase 1');
  35. UPDATE `creature_template` SET faction_A=14, faction_H=14, mindmg=4715, maxdmg=5474, attackpower=5094, dmg_multiplier=1.0,AIName='SmartAI', mechanic_immune_mask=2147483647 WHERE entry=32495;
  36. -- Syreian the Bonecarver
  37. UPDATE `creature_template` SET faction_A=14, faction_H=14, mindmg=2926, maxdmg=3542, spell1=38952, spell2=47168, spell3=50092, attackpower=3234, dmg_multiplier=1.0, mechanic_immune_mask=2147483647 WHERE entry=32438;
  38. -- Icehorn
  39. DELETE FROM `smart_scripts` WHERE `entryorguid`=32361;
  40. 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
  41. (32361, 0, 0, 0, 0, 0, 100, 0, 4500, 6750, 6750, 9750, 11, 57468, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Icehorn - Cast Romp');
  42. UPDATE `creature_template` SET faction_A=14, faction_H=14, mindmg=2792, maxdmg=3376, spell1=57468, attackpower=3084, dmg_multiplier=1.0,AIName='SmartAI', mechanic_immune_mask=66624, skinloot=70211 WHERE entry=32361;
  43. -- King Ping
  44. DELETE FROM `smart_scripts` WHERE `entryorguid`=32398;
  45. 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
  46. (32398, 0, 0, 0, 0, 0, 100, 0, 1600, 8000, 12400, 13000, 11, 61115, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'King Ping - Cast Belly Flop'),
  47. (32398, 0, 1, 0, 0, 0, 100, 0, 800, 2600, 4200, 6800, 11, 50169, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'King Ping - Cast Flipper Thwack');
  48. UPDATE `creature_template` SET faction_A=14, faction_H=14, mindmg=2792, maxdmg=3376, spell1=61115, spell2=50169, attackpower=3234, dmg_multiplier=1.0,AIName='SmartAI', mechanic_immune_mask=2147483647 WHERE entry=32398;
  49. -- High Thane Jorfus
  50. DELETE FROM `smart_scripts` WHERE `entryorguid`=32501;
  51. 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
  52. (32501, 0, 0, 0, 0, 0, 100, 0, 1600, 3200, 6400, 12800, 11, 60950, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'High Thane Jorfus - Cast Blood Plague'),
  53. (32501, 0, 1, 0, 0, 0, 100, 2, 10000, 20000, 10000, 20000, 11, 60945, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'High Thane Jorfus - Cast Blood Strike'),
  54. (32501, 0, 2, 0, 0, 0, 100, 0, 8000, 13000, 16000, 21000, 11, 60953, 1, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 'High Thane Jorfus - Cast Death and Decaye'),
  55. (32501, 0, 3, 0, 0, 0, 100, 4, 1000, 1400, 8500, 20500, 11, 60949, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 'High Thane Jorfus - Cast Death Coil'),
  56. (32501, 0, 4, 0, 0, 0, 100, 2, 5000, 9000, 15000, 22000, 11, 60951, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'High Thane Jorfus - Cast Frost Strike');
  57. UPDATE `creature_template` SET faction_A=14, faction_H=14, mindmg=4894, maxdmg=5649, spell1=60950, spell2=60945, spell3=60953, spell4=60949, spell5=60951, attackpower=5271, dmg_multiplier=1.0,AIName='SmartAI', mechanic_immune_mask=2147483647 WHERE entry=32501;
  58. -- Perobas the Bloodthirster
  59. DELETE FROM `smart_scripts` WHERE `entryorguid`=32377;
  60. 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
  61. (32377, 0, 0, 0, 0, 0, 100, 0, 5000, 8000, 12000, 15000, 11, 50046, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Perobas the Bloodthirster - Cast Gnaw Bone'),
  62. (32377, 0, 1, 0, 2, 0, 100, 0, 0, 50, 10000, 13000, 11, 50271, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Perobas the Bloodthirster - Cast Killing Rage');
  63. UPDATE `creature_template` SET faction_A=14, faction_H=14, mindmg=2792, maxdmg=3376, spell1=50046, spell2=52071, attackpower=3084, dmg_multiplier=1.0,AIName='SmartAI', mechanic_immune_mask=66624, skinloot=70209 WHERE entry=32377;
  64. -- Aotona
  65. UPDATE `creature` SET curhealth=15952  WHERE id=32481;
  66. UPDATE `creature_template` SET EXP=2, armor_mod=1.0, minlevel=75, maxlevel=75, faction_A=14, faction_H=14, mindmg=3376, maxdmg=4034, spell1=49865, spell2=51144, attackpower=3705, dmg_multiplier=1.0, mechanic_immune_mask=66624 WHERE entry=32481;
  67. -- Griegen
  68. DELETE FROM `smart_scripts` WHERE `entryorguid`=32471;
  69. 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
  70. (32471, 0, 0, 0, 0, 0, 100, 0, 5000, 8000, 9000, 12000, 11, 51334, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Griegen - Cast Smash');
  71. UPDATE `creature` SET curhealth=15952  WHERE id=32471;
  72. UPDATE `creature_template` SET EXP=2, armor_mod=1.0, minlevel=75, maxlevel=75, faction_A=14, faction_H=14, mindmg=3376, maxdmg=4034, spell1=51334, attackpower=3705, dmg_multiplier=1.0,AIName='SmartAI', mechanic_immune_mask=2147483647 WHERE entry=32471;
  73. -- Seething Hate
  74. UPDATE `creature_template` SET mindmg=2926, maxdmg=3542, attackpower=3234, mechanic_immune_mask=66624 WHERE entry=32429;
  75. -- Vigdis the War Maiden
  76. DELETE FROM `creature_template_addon` WHERE entry=32386;
  77. INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
  78. (32386, 0, 28040, 0, 0, 0, NULL);
  79. UPDATE `creature` SET spawndist=20.0, MovementType=1 WHERE id=32386;
  80. UPDATE `creature_template` SET faction_A=14, faction_H=14, mindmg=2792, maxdmg=3376, attackpower=3084, dmg_multiplier=1.0, mechanic_immune_mask=2147483647, InhabitType=1 WHERE entry=32386;
  81. -- King Krush
  82. UPDATE `creature_template` SET faction_A=14, faction_H=14 WHERE entry=32485;
  83. -- Scarlet Highlord Daion
  84. UPDATE `creature_template` SET faction_A=14, faction_H=14, mindmg=2926, maxdmg=3542, attackpower=3234, dmg_multiplier=1.0, mechanic_immune_mask=66624 WHERE entry=32417;
  85. -- Crazed Indu'le Survivor
  86. UPDATE `creature_template` SET mindmg=2926, maxdmg=3542, attackpower=3234, dmg_multiplier=1.0, mechanic_immune_mask=66624 WHERE entry=32409;
  87. -- Grocklar
  88. UPDATE `creature_template` SET mindmg=3137, maxdmg=3777, attackpower=3457, dmg_multiplier=1.0, mechanic_immune_mask=66624 WHERE entry=32422;
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!