diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2020_09_04_00_world.sql | 180 |
1 files changed, 180 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_09_04_00_world.sql b/sql/updates/world/3.3.5/2020_09_04_00_world.sql new file mode 100644 index 00000000000..809f26df858 --- /dev/null +++ b/sql/updates/world/3.3.5/2020_09_04_00_world.sql @@ -0,0 +1,180 @@ +-- Some values were replaced with values from ACID +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 40, `event_param5` = 40, `comment` = "Rot Hide Mystic - On Friendly Between 0-40% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 1773 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 332; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Murloc Minor Oracle - On Friendly Between 0-50% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 456 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 332; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Muad - On Friendly Between 0-50% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 1910 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 332; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Gnarlpine Shaman - On Friendly Between 0-50% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 2009 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 332; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 60, `event_param5` = 40, `comment` = "Mo'grosh Mystic - On Friendly Between 0-60% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 1183 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 547; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Stonesplinter Shaman - On Friendly Between 0-50% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 1197 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 547; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Murloc Minor Tidecaller - On Friendly Between 0-50% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 548 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 547; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 40, `event_param5` = 40, `comment` = "Razormane Dustrunner - On Friendly Between 0-40% Health - Cast 'Rejuvenation'" WHERE `entryorguid` = 3113 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 774; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Riverpaw Shaman - On Friendly Between 0-50% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 1065 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 913; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Murloc Tidecaller - On Friendly Between 0-50% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 545 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 913; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 60, `event_param5` = 40, `comment` = "Vile Fin Oracle - On Friendly Between 0-60% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 1908 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 913; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Saltspittle Oracle - On Friendly Between 0-50% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 3742 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 913; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Greymist Oracle - On Friendly Between 0-50% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 2207 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 913; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Blackwood Shaman - On Friendly Between 0-50% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 2171 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 913; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Bluegill Oracle - On Friendly Between 0-50% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 1029 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 939; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Galak Windchaser - On Friendly Between 0-50% Health - Cast 'Healing Wave' (No Repeat)" WHERE `entryorguid` = 4096 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 939; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Ward Guardian - On Friendly Between 0-50% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 4427 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 959; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Maraudine Windchaser - On Friendly Between 0-50% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 4657 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 959; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 30, `event_param5` = 40, `comment` = "Magram Windchaser - On Friendly Between 0-30% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 4641 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 959; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 30, `event_param5` = 40, `comment` = "Gelkis Windchaser - On Friendly Between 0-30% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 4649 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 959; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 35, `event_param5` = 40, `comment` = "Mirefin Oracle - On Friendly Between 0-35% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 4363 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 959; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Blackwood Ursa - On Friendly Between 0-50% Health - Cast 'Rejuvenation'" WHERE `entryorguid` = 2170 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 1058; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 70, `event_param5` = 40, `comment` = "Scarlet Friar - On Friendly Between 0-70% Health - Cast 'Lesser Heal'" WHERE `entryorguid` = 1538 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 2052; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Skeletal Healer - On Friendly Between 0-50% Health - Cast 'Heal' (No Repeat)" WHERE `entryorguid` = 787 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 2054; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Forsaken Seeker - On Friendly Between 0-50% Health - Cast 'Heal' (No Repeat)" WHERE `entryorguid` = 3732 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 2054; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Twilight Acolyte - On Friendly Between 0-50% Health - Cast 'Heal' (No Repeat)" WHERE `entryorguid` = 4809 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 2055; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 70, `event_param5` = 10, `comment` = "Vile Fin Tidehunter - On Friendly Between 0-70% Health - Cast 'Quick Frost Ward'" WHERE `entryorguid` = 1768 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 4980; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 40, `event_param5` = 40, `comment` = "Druid of the Fang - On Friendly Between 0-40% Health - Cast 'Healing Touch'" WHERE `entryorguid` = 3840 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 5187; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Blindlight Oracle - On Friendly Between 0-50% Health - Cast 'Heal'" WHERE `entryorguid` = 4820 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 6063; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Death's Head Priest - On Friendly Between 0-50% Health - Cast 'Heal'" WHERE `entryorguid` = 4517 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 6063; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Kurzen Medicine Man - On Friendly Between 0-50% Health - Cast 'Heal'" WHERE `entryorguid` = 940 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 6064; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Grizlak - On Friendly Between 0-50% Health - Cast 'Renew'" WHERE `entryorguid` = 1425 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 6074; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 85, `event_param5` = 40, `comment` = "Murloc Oracle - On Friendly Between 0-85% Health - Cast 'Renew'" WHERE `entryorguid` = 517 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 6074; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 80, `event_param5` = 40, `comment` = "Shadowforge Chanter - On Friendly Between 0-80% Health - Cast 'Renew'" WHERE `entryorguid` = 2742 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 6077; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 75, `event_param5` = 40, `comment` = "Kurzen Medicine Man - On Friendly Between 0-75% Health - Cast 'Renew'" WHERE `entryorguid` = 940 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 6077; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Hatecrest Screamer - On Friendly Between 0-50% Health - Cast 'Renew'" WHERE `entryorguid` = 5335 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 6078; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 30, `comment` = "Twilight's Hammer Ambassador - On Friendly Between 0-50% Health - Cast 'Bloodlust' (Phase 4)" WHERE `entryorguid` = 8915 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 6742; +UPDATE `smart_scripts` SET `event_type` = 0, `event_param1` = 5000, `event_param2` = 9000, `comment` = "Tur Ragepaw - In Combat - Cast 'Growl'" WHERE `entryorguid` = 27328 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 6795; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 70, `event_param5` = 10, `comment` = "Eldreth Spectre - On Friendly Between 0-70% Health - Cast 'Dark Offering' (No Repeat)" WHERE `entryorguid` = 11473 AND `source_type` = 0 AND `id` = 2 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 7154; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 40, `event_param5` = 10, `comment` = "Eldreth Spectre - On Friendly Between 0-40% Health - Cast 'Dark Offering' (No Repeat)" WHERE `entryorguid` = 11473 AND `source_type` = 0 AND `id` = 3 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 7154; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 15, `event_param5` = 10, `comment` = "Eldreth Spectre - On Friendly Between 0-15% Health - Cast 'Dark Offering' (No Repeat)" WHERE `entryorguid` = 11473 AND `source_type` = 0 AND `id` = 4 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 7154; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 70, `event_param5` = 10, `comment` = "Vilebranch Soul Eater - On Friendly Between 0-70% Health - Cast 'Dark Offering'" WHERE `entryorguid` = 2647 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 7154; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 60, `event_param5` = 40, `comment` = "Dalaran Brewmaster - On Friendly Between 0-60% Health - Cast 'Potion Toss'" WHERE `entryorguid` = 3577 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 7638; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Dustbelcher Shaman - On Friendly Between 0-50% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 2718 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 8005; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Woodpaw Mystic - On Friendly Between 0-50% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 5254 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 8005; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 30, `event_param5` = 40, `comment` = "Grimtotem Shaman - On Friendly Between 0-30% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 7727 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 8005; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 30, `event_param5` = 40, `comment` = "Gordunni Shaman - On Friendly Between 0-30% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 5236 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 8005; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 40, `event_param5` = 40, `comment` = "Vilebranch Witch Doctor - On Friendly Between 0-40% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 2640 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 8005; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 25, `event_param5` = 40, `comment` = "Muckshell Scrabbler - On Friendly Between 0-25% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 4404 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 8005; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Death's Head Acolyte - On Friendly Between 0-50% Health - Cast 'Renew'" WHERE `entryorguid` = 4515 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 8362; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Scarlet Priest - On Friendly Between 0-50% Health - Cast 'Renew'" WHERE `entryorguid` = 10608 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 8362; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 75, `event_param5` = 40, `comment` = "Shadowpriest Sezz'ziz - On Friendly Between 0-75% Health - Cast 'Renew'" WHERE `entryorguid` = 7275 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 8362; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 25, `event_param5` = 40, `comment` = "Theramore Preserver - On Friendly Between 0-25% Health - Cast 'Renew'" WHERE `entryorguid` = 3386 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 8362; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 40, `event_param5` = 40, `comment` = "Vilebranch Soothsayer - On Friendly Between 0-40% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 4467 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 10395; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 25, `event_param5` = 40, `target_type` = 7, `target_param3` = 0, `comment` = "Sleeby - On Friendly Between 0-25% Health - Cast 'Heal'" WHERE `entryorguid` = 2764 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 10577; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 40, `event_param5` = 40, `comment` = "Mudsnout Shaman - On Friendly Between 0-40% Health - Cast 'Flow of the Northspring'" WHERE `entryorguid` = 2373 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 11014; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Northspring Harpy - On Friendly Between 0-50% Health - Cast 'Flow of the Northspring'" WHERE `entryorguid` = 5362 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 11014; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Northspring Roguefeather - On Friendly Between 0-50% Health - Cast 'Flow of the Northspring'" WHERE `entryorguid` = 5363 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 11014; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Northspring Slayer - On Friendly Between 0-50% Health - Cast 'Flow of the Northspring'" WHERE `entryorguid` = 5364 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 11014; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Northspring Windcaller - On Friendly Between 0-50% Health - Cast 'Flow of the Northspring'" WHERE `entryorguid` = 5366 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 11014; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 75, `event_param5` = 40, `comment` = "Winterfall Shaman - On Friendly Between 0-75% Health - Cast 'Healing Touch'" WHERE `entryorguid` = 7439 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 11431; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 60, `event_param5` = 40, `comment` = "Qiaga the Keeper - On Friendly Between 0-60% Health - Cast 'Renew'" WHERE `entryorguid` = 7996 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 11640; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 60, `event_param5` = 40, `comment` = "Morta'gya the Keeper - On Friendly Between 0-60% Health - Cast 'Renew'" WHERE `entryorguid` = 8636 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 11640; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 40, `event_param5` = 40, `comment` = "Hitah'ya the Keeper - On Friendly Between 0-40% Health - Cast 'Renew'" WHERE `entryorguid` = 10802 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 11640; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Scarlet Medic - On Friendly Between 0-50% Health - Cast 'Renew'" WHERE `entryorguid` = 10605 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 11640; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Blood Elf Reclaimer - On Friendly Between 0-50% Health - Cast 'Renew'" WHERE `entryorguid` = 6199 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 11640; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Spitelash Siren - On Friendly Between 0-50% Health - Cast 'Renew'" WHERE `entryorguid` = 6195 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 11640; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 70, `event_param5` = 40, `comment` = "Dun Garok Priest - On Friendly Between 0-70% Health - Cast 'Heal'" WHERE `entryorguid` = 2346 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 11642; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 30, `event_param5` = 40, `comment` = "Wrathtail Priestess - On Friendly Between 0-30% Health - Cast 'Heal'" WHERE `entryorguid` = 3944 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 11642; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Atal'ai Priest - On Friendly Between 0-50% Health - Cast 'Heal' (Normal Dungeon)" WHERE `entryorguid` = 5269 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 11642; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Vile Priestess Hexx - On Friendly Between 0-50% Health - Cast 'Heal'" WHERE `entryorguid` = 7995 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 11642; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 35, `event_param5` = 40, `comment` = "Scarlet Disciple - On Friendly Between 0-35% Health - Cast 'Heal'" WHERE `entryorguid` = 4285 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 11642; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Storm Bay Oracle - On Friendly Between 0-50% Health - Cast 'Heal'" WHERE `entryorguid` = 6351 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 11642; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 60, `event_param5` = 40, `comment` = "Theramore Preserver - On Friendly Between 0-60% Health - Cast 'Heal'" WHERE `entryorguid` = 3386 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 11642; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Kurzen Mindslave - On Friendly Between 0-50% Health - Cast 'Heal'" WHERE `entryorguid` = 6366 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 11642; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 40, `event_param5` = 40, `comment` = "Shadowforge Citizen - On Friendly Between 0-40% Health - Cast 'Heal' (Phase 5)" WHERE `entryorguid` = 8902 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 11642; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Shadowforge Peasant - On Friendly Between 0-50% Health - Cast 'Heal' (Phase 4)" WHERE `entryorguid` = 8896 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 11642; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 35, `event_param5` = 40, `comment` = "Stormscale Toxicologist - On Friendly Between 0-35% Health - Cast 'Heal'" WHERE `entryorguid` = 12321 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 11642; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Mosshide Mystic - On Friendly Between 0-50% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 1013 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 11986; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 60, `event_param5` = 40, `comment` = "Bladespire Mystic - On Friendly Between 0-60% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 20766 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 11986; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 85, `event_param5` = 40, `comment` = "Winterskorn Elder - On Friendly Between 0-85% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 23670 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 11986; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 90, `event_param5` = 40, `comment` = "Winterskorn Rune-Seer - On Friendly Between 0-90% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 23667 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 11986; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 60, `event_param5` = 40, `comment` = "Ragefire Shaman - On Friendly Between 0-60% Health - Cast 'Healing Wave' (Normal Dungeon)" WHERE `entryorguid` = 11319 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 11986; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 80, `event_param5` = 40, `comment` = "Twilight Apostle - On Friendly Between 0-80% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 30179 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 11986; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Bloodscalp Mystic - On Friendly Between 0-50% Health - Cast 'Healing Wave' (No Repeat)" WHERE `entryorguid` = 701 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 11986; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Skullsplitter Mystic - On Friendly Between 0-50% Health - Cast 'Healing Wave' (No Repeat)" WHERE `entryorguid` = 780 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 11986; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 65, `event_param5` = 40, `comment` = "Atal'ai Witch Doctor - On Friendly Between 0-65% Health - Cast 'Healing Wave' (Normal Dungeon)" WHERE `entryorguid` = 5259 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 11986; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Snowfall Glade Shaman - On Friendly Between 0-50% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 26201 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 11986; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 40, `event_param5` = 40, `comment` = "Murkgill Oracle - On Friendly Between 0-40% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 4459 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 11986; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 40, `event_param5` = 40, `comment` = "Saltscale Oracle - On Friendly Between 0-40% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 873 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 11986; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Timbermaw Shaman - On Friendly Between 0-50% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 6188 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 11986; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Arkkoran Oracle - On Friendly Between 0-50% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 6138 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 11986; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 30, `event_param5` = 40, `comment` = "Marsh Oracle - On Friendly Between 0-30% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 752 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 11986; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 60, `event_param5` = 40, `comment` = "Grimtotem Elder - On Friendly Between 0-60% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 23714 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 11986; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 60, `event_param5` = 40, `comment` = "Twilight Dark Shaman - On Friendly Between 0-60% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 5860 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 11986; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Atal'ai High Priest - On Friendly Between 0-50% Health - Cast 'Heal' (Normal Dungeon)" WHERE `entryorguid` = 5273 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 12039; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 20, `event_param5` = 40, `comment` = "Scarlet Priest - On Friendly Between 0-20% Health - Cast 'Heal'" WHERE `entryorguid` = 10608 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 12039; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 60, `event_param5` = 40, `comment` = "Shadowpriest Sezz'ziz - On Friendly Between 0-60% Health - Cast 'Heal'" WHERE `entryorguid` = 7275 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 12039; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 40, `event_param5` = 40, `comment` = "Wyrmkin Dreamwalker - On Friendly Between 0-40% Health - Cast 'Rejuvenation'" WHERE `entryorguid` = 743 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 12160; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Smolderthorn Seer - On Friendly Between 0-50% Health - Cast 'Healing Wave' (Normal Dungeon)" WHERE `entryorguid` = 9269 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 12492; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 30, `comment` = "Twilight Bodyguard - On Friendly Between 0-50% Health - Cast 'Seal of Sacrifice'" WHERE `entryorguid` = 8914 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 13903; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 30, `event_param5` = 40, `comment` = "Dawnblade Blood Knight - On Friendly Between 0-30% Health - Cast 'Holy Light'" WHERE `entryorguid` = 24976 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 13952; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 40, `event_param5` = 40, `comment` = "Scarlet Preserver - On Friendly Between 0-40% Health - Cast 'Holy Light'" WHERE `entryorguid` = 4280 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 13952; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Anvilrage Officer - On Friendly Between 0-50% Health - Cast 'Holy Light'" WHERE `entryorguid` = 8895 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 13952; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Anvilrage Marshal - On Friendly Between 0-50% Health - Cast 'Holy Light'" WHERE `entryorguid` = 8898 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 13952; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 80, `event_param5` = 40, `comment` = "Redfang Elder - On Friendly Between 0-80% Health - Cast 'Chain Heal'" WHERE `entryorguid` = 26436 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 14900; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 80, `event_param5` = 40, `comment` = "High Protector Lorik - On Friendly Between 0-80% Health - Cast 'Holy Light'" WHERE `entryorguid` = 1846 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 15493; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 80, `event_param5` = 40, `comment` = "Highlord Taelan Fordring - On Friendly Between 0-80% Health - Cast 'Holy Light'" WHERE `entryorguid` = 1842 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 15493; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Scarlet Cleric - On Friendly Between 0-50% Health - Cast 'Heal'" WHERE `entryorguid` = 9449 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 15586; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 60, `event_param5` = 40, `comment` = "Condemned Cleric - On Friendly Between 0-60% Health - Cast 'Heal'" WHERE `entryorguid` = 7070 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 15586; +-- 50 health, really? Ok.. +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 99, `event_param5` = 40, `comment` = "Father Jhadras - On Friendly Between 0-99% Health - Cast 'Heal'" WHERE `entryorguid` = 31191 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 15586; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "High Elf Mage-Priest - On Friendly Between 0-50% Health - Cast 'Heal' (Phase 1) (No Repeat) (Dungeon)" WHERE `entryorguid` = 27747 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 15586; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Anvilrage Medic - On Friendly Between 0-50% Health - Cast 'Heal'" WHERE `entryorguid` = 8894 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 15586; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 70, `event_param5` = 40, `comment` = "Smolderthorn Mystic - On Friendly Between 0-70% Health - Cast 'Chain Heal' (Phase 1) (No Repeat) (Normal Dungeon)" WHERE `entryorguid` = 9239 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 15799; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 40, `event_param5` = 40, `comment` = "Grove Walker - On Friendly Between 0-40% Health - Cast 'Rejuvenation'" WHERE `entryorguid` = 31228 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 15981; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 40, `event_param5` = 40, `comment` = "Dispirited Ent - On Friendly Between 0-40% Health - Cast 'Rejuvenation' (Phase 1) (No Repeat) (Dungeon)" WHERE `entryorguid` = 31041 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 15981; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 70, `event_param5` = 40, `comment` = "Spirestone Mystic - On Friendly Between 0-70% Health - Cast 'Rejuvenation' (Normal Dungeon)" WHERE `entryorguid` = 9198 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 15981; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 60, `event_param5` = 40, `comment` = "Spirestone Mystic - On Friendly Between 0-60% Health - Cast 'Healing Wave' (Normal Dungeon)" WHERE `entryorguid` = 9198 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 15982; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 80, `event_param5` = 40, `comment` = "Merok Longstride - On Friendly Between 0-80% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 15613 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 15982; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 30, `comment` = "Spirestone Battle Mage - On Friendly Between 0-50% Health - Cast 'Bloodlust' (Normal Dungeon)" WHERE `entryorguid` = 9197 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 16170; +-- Obviously requires checks +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 95, `event_param5` = 40, `comment` = "Warsong Shaman - On Friendly Between 0-95% Health - Cast 'Chain Heal' (Phase 1) (No Repeat)" WHERE `entryorguid` = 27678 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 16367; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 40, `event_param5` = 40, `comment` = "Lost Shandaral Spirit - On Friendly Between 0-40% Health - Cast 'Regrowth'" WHERE `entryorguid` = 31231 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 16561; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 40, `event_param5` = 40, `comment` = "Shandaral Druid Spirit - On Friendly Between 0-40% Health - Cast 'Regrowth' (Phase 1)" WHERE `entryorguid` = 30863 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 16561; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 20, `event_param5` = 40, `comment` = "Moonkin Oracle - On Friendly Between 0-20% Health - Cast 'Regrowth'" WHERE `entryorguid` = 10157 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 16561; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Wandering Forest Walker - On Friendly Between 0-50% Health - Cast 'Regrowth'" WHERE `entryorguid` = 7584 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 16561; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Grimscale Oracle - On Friendly Between 0-50% Health - Cast 'Flash Heal'" WHERE `entryorguid` = 15669 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 17137; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 25, `event_param5` = 40, `comment` = "Scarlet Medic - On Friendly Between 0-25% Health - Cast 'Flash Heal'" WHERE `entryorguid` = 10605 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 17137; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Tarren Mill Protector - On Friendly Between 0-50% Health - Cast 'Flash Heal' (No Repeat)" WHERE `entryorguid` = 18093 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 17138; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 80, `event_param5` = 40, `comment` = "Shadow Priestess Shai - On Friendly Between 0-80% Health - Cast 'Flash Heal'" WHERE `entryorguid` = 15615 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 17138; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Tarren Mill Protector - On Friendly Between 0-50% Health - Cast 'Flash Heal' (No Repeat)" WHERE `entryorguid` = 18093 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 17843; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 70, `event_param5` = 40, `comment` = "Jademir Oracle - On Friendly Between 0-70% Health - Cast 'Rejuvenation'" WHERE `entryorguid` = 5317 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 20664; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 70, `event_param5` = 40, `comment` = "Verdantine Oracle - On Friendly Between 0-70% Health - Cast 'Rejuvenation'" WHERE `entryorguid` = 12478 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 20664; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 35, `event_param5` = 40, `comment` = "Jademir Oracle - On Friendly Between 0-35% Health - Cast 'Regrowth'" WHERE `entryorguid` = 5317 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 20665; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 35, `event_param5` = 40, `comment` = "Verdantine Oracle - On Friendly Between 0-35% Health - Cast 'Regrowth'" WHERE `entryorguid` = 12478 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 20665; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Warpwood Guardian - On Friendly Between 0-50% Health - Cast 'Regrowth'" WHERE `entryorguid` = 11461 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 22373; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 40, `event_param5` = 40, `comment` = "Coilfang Oracle - On Friendly Between 0-40% Health - Cast 'Heal'" WHERE `entryorguid` = 17803 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 22883; +-- Obviously requires checks +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 95, `event_param5` = 40, `comment` = "Taunka Windfury - On Friendly Between 0-95% Health - Cast 'Healing Touch'" WHERE `entryorguid` = 27571 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 23381; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 60, `event_param5` = 40, `comment` = "Condemned Acolyte - On Friendly Between 0-60% Health - Cast 'Renew'" WHERE `entryorguid` = 7068 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 25058; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 70, `event_param5` = 40, `comment` = "Fordragon High Priest - On Friendly Between 0-70% Health - Cast 'Renew'" WHERE `entryorguid` = 27677 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 25058; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 80, `event_param5` = 40, `comment` = "Janela Stouthammer - On Friendly Between 0-80% Health - Cast 'Holy Light'" WHERE `entryorguid` = 15443 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 25263; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 80, `event_param5` = 40, `comment` = "Frostpaw Shaman - On Friendly Between 0-80% Health - Cast 'Lesser Healing Wave'" WHERE `entryorguid` = 26428 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 25420; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 85, `event_param5` = 40, `comment` = "Spectral Stable Hand - On Friendly Between 0-85% Health - Cast 'Healing Touch' (No Repeat) (Normal Dungeon)" WHERE `entryorguid` = 15551 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 29339; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Murkblood Healer - On Friendly Between 0-50% Health - Cast 'Holy Light' (Normal Dungeon)" WHERE `entryorguid` = 17730 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 29427; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 40, `event_param5` = 40, `comment` = "Coilfang Oracle - On Friendly Between 0-40% Health - Cast 'Heal'" WHERE `entryorguid` = 17803 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 31730; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 30, `event_param5` = 40, `comment` = "7th Legion Cleric - On Friendly Between 0-30% Health - Cast 'Heal'" WHERE `entryorguid` = 26780 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 31739; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Unyielding Knight - On Friendly Between 0-50% Health - Cast 'Heal Other'" WHERE `entryorguid` = 16906 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 33910; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 75, `event_param5` = 30, `comment` = "Maiden of Pain - On Friendly Between 0-75% Health - Cast 'Whipped Frenzy'" WHERE `entryorguid` = 19408 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 34086; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Skettis Windwalker - On Friendly Between 0-50% Health - Cast 'Shadow Mend'" WHERE `entryorguid` = 21649 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 34110; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 20, `event_param5` = 40, `comment` = "Stormforged Sentinel - On Friendly Between 0-20% Health - Cast 'Renew'" WHERE `entryorguid` = 28837 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 34423; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 60, `event_param5` = 40, `comment` = "Murkblood Healer - On Friendly Between 0-60% Health - Cast 'Renew' (Normal Dungeon)" WHERE `entryorguid` = 17730 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 34423; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 65, `event_param5` = 40, `comment` = "Coilfang Scale-Healer - On Friendly Between 0-65% Health - Cast 'Heal' (Normal Dungeon)" WHERE `entryorguid` = 21126 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 34945; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 75, `event_param5` = 40, `action_param1` = 71020, `comment` = "Nerub'ar Broodkeeper - On Friendly Between 0-75% Health - Cast 'Dark Mending'" WHERE `entryorguid` = 36725 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 36725; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 90, `event_param5` = 40, `comment` = "Bloodwarder Vindicator - On Friendly Between 0-90% Health - Cast 'Flash of Light'" WHERE `entryorguid` = 20032 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 37254; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 90, `event_param5` = 40, `comment` = "Bloodwarder Squire - On Friendly Between 0-90% Health - Cast 'Flash of Light'" WHERE `entryorguid` = 20036 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 37254; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 90, `event_param5` = 50, `comment` = "Crimson Hand Blood Knight - On Friendly Between 0-90% Health - Cast 'Flash of Light'" WHERE `entryorguid` = 20049 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 37257; +-- Obviously requires update +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 99, `event_param5` = 20, `comment` = "Tempest Falconer - On Friendly Between 0-99% Health - Cast 'Fire Shield'" WHERE `entryorguid` = 20037 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 37318; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 20, `event_param5` = 40, `comment` = "Stormforged Sentinel - On Friendly Between 0-20% Health - Cast 'Renew'" WHERE `entryorguid` = 28837 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 37978; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 60, `event_param5` = 40, `comment` = "Murkblood Healer - On Friendly Between 0-60% Health - Cast 'Renew' (Heroic Dungeon)" WHERE `entryorguid` = 17730 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 37978; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 40, `comment` = "Murkblood Healer - On Friendly Between 0-50% Health - Cast 'Holy Light' (Heroic Dungeon)" WHERE `entryorguid` = 17730 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 37979; +UPDATE `smart_scripts` SET `event_type` = 15, `event_param1` = 0, `event_param2` = 5000, `event_param3` = 10000, `comment` = "Bloodwarder Vindicator - Friendly Crowd Controlled - Cast 'Cleanse'" WHERE `entryorguid` = 20032 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 39078; +UPDATE `smart_scripts` SET `event_type` = 15, `event_param1` = 0, `event_param2` = 5000, `event_param3` = 10000, `comment` = "Bloodwarder Squire - Friendly Crowd Controlled - Cast 'Cleanse'" WHERE `entryorguid` = 20036 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 39078; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 65, `event_param5` = 40, `comment` = "Coilfang Scale-Healer - On Friendly Between 0-65% Health - Cast 'Heal' (Heroic Dungeon)" WHERE `entryorguid` = 21126 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 39378; +-- Obviously should not target himself +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 50, `event_param5` = 25, `comment` = "Shadowsword Lifeshaper - On Friendly Between 0-50% Health - Cast 'Health Funnel'" WHERE `entryorguid` = 25506 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 46467; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 65, `event_param5` = 100, `comment` = "Sunblade Dawn Priest - On Friendly Between 0-65% Health - Cast 'Renew'" WHERE `entryorguid` = 25371 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 46563; +-- Obviously requires checks +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 95, `event_param5` = 40, `comment` = "Warsong Shaman - On Friendly Between 0-95% Health - Cast 'Lesser Healing Wave'" WHERE `entryorguid` = 27678 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 49309; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 75, `event_param5` = 40, `comment` = "Dragonflayer Spiritualist - On Friendly Between 0-75% Health - Cast 'Healing Wave'" WHERE `entryorguid` = 28410 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 51586; +-- Probably should not target himself +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 33, `event_param5` = 20, `comment` = "Snowplain Disciple - On Friendly Between 0-33% Health - Cast 'Renewing Beam'" WHERE `entryorguid` = 26705 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 52011; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 60, `event_param5` = 40, `comment` = "Argent Battle-priest - On Friendly Between 0-60% Health - Cast 'Holy Light'" WHERE `entryorguid` = 30919 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 58053; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 90, `event_param5` = 40, `comment` = "Reanimated Crusader - On Friendly Between 0-90% Health - Cast 'Unholy Light'" WHERE `entryorguid` = 30202 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 58153; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 80, `event_param5` = 40, `comment` = "Reanimated Captain - On Friendly Between 0-80% Health - Cast 'Unholy Light'" WHERE `entryorguid` = 30986 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 58153; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 65, `event_param5` = 40, `comment` = "Drakkari Shaman - On Friendly Between 0-65% Health - Cast 'Chain Heal'" WHERE `entryorguid` = 26639 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 59473; +UPDATE `smart_scripts` SET `event_type` = 74, `event_param1` = 0, `event_param2` = 66, `event_param5` = 40, `comment` = "Deathspeaker Disciple - On Friendly Between 0-66% Health - Cast 'Shadow Mend'" WHERE `entryorguid` = 36807 AND `source_type` = 0 AND `event_type` = 14 AND `action_type` = 11 AND `action_param1` = 69389; |