Want more features on Pastebin? Sign Up, it's FREE!
Guest

hgvj

By: a guest on Aug 31st, 2012  |  syntax: SQL  |  size: 2.40 KB  |  views: 25  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. SET @ENTRY := 42334;
  2.  
  3. -- Assign
  4. DELETE FROM `spell_script_names` WHERE  `spell_id`=78985 AND `ScriptName`='spell_26187_break_marls_trance_dummy' LIMIT 1;
  5. INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
  6. (78985, 'spell_26187_break_marls_trance_dummy');
  7. DELETE FROM `smart_scripts` WHERE  `entryorguid`=@ENTRY AND `source_type`=0 AND `id`=0 AND `link`=0 LIMIT 1;
  8. DELETE FROM `creature_template_addon` WHERE  `entry`=@ENTRY LIMIT 1;
  9.  
  10. -- Script
  11. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;
  12. DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY;
  13. 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`,`t​arget_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
  14. (@ENTRY,0,0,0,1,0,100,0,5000,10000,600000,600000,11,78985,0,0,0,0,0,1,0,0,0,0,0,0,0,'Cast buff'),
  15. (@ENTRY,0,1,0,4,0,100,1,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Set Phase 1 on Aggro'),
  16. (@ENTRY,0,2,0,4,1,100,1,0,0,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Stop Moving on Aggro'),
  17. (@ENTRY,0,3,0,4,1,100,1,0,0,0,0,11,9739,0,0,0,0,0,2,0,0,0,0,0,0,0,'Cast bolt on Aggro'),
  18. (@ENTRY,0,4,0,9,1,100,0,0,40,3400,4700,11,9739,0,0,0,0,0,2,0,0,0,0,0,0,0,'Cast bolt'),
  19. (@ENTRY,0,5,0,9,1,100,0,40,100,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Start Moving when not in bolt Range'),
  20. (@ENTRY,0,6,0,9,1,100,0,10,15,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Stop Moving at 15 Yards'),
  21. (@ENTRY,0,7,0,9,1,100,0,0,40,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Stop Moving when in bolt Range'),
  22. (@ENTRY,0,8,0,3,1,100,0,0,15,0,0,22,2,0,0,0,0,0,1,0,0,0,0,0,0,0,'Set Phase 2 at 15% Mana'),
  23. (@ENTRY,0,9,0,3,2,100,0,0,15,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Start Moving at 15% Mana'),
  24. (@ENTRY,0,10,0,3,2,100,0,30,100,100,100,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Set Phase 1 When Mana is above 30%'),
  25. (@ENTRY,0,11,0,1,0,100,0,500,1000,600000,600000,11,79833,0,0,0,0,0,1,0,0,0,0,0,0,0,'Cast Mark of the Wild on Spawn'),
  26. (@ENTRY,0,12,0,0,1,100,0,7000,9000,14000,20000,11,33844,0,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Entangling Roots'),
  27. (@ENTRY,0,13,0,2,1,100,0,0,40,19000,27000,11,12160,0,0,0,0,0,1,0,0,0,0,0,0,0,'Ca​st Rejuvenation at 40% HP');
clone this paste RAW Paste Data