API tools faq
paste
Advertisement
P0WER

circle4

P0WER
Aug 21st, 2019
95
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 9.56 KB | None | 0 0
raw download clone embed print report
  1. UPDATE creature_template SET spell1 = "0" WHERE entry = "997364" AND spell1 = "198915";
  2. UPDATE creature_template SET spell2 = "0" WHERE entry = "997323" AND spell2 = "133022";
  3.  
  4. UPDATE `gameobject_template_addon` SET `flags`=16 WHERE `entry`=213276;
  5. UPDATE `gameobject_template_addon` SET `flags`=16 WHERE `entry`=214483;
  6.  
  7. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  8. (22, 1, 997255, 0, 1, 1, 0, 126749, 0, 0, 0, 0, 0, '', 'tp if both auras are present @Power'),
  9. (22, 1, 997255, 0, 1, 1, 0, 204936, 0, 0, 0, 0, 0, '', 'tp if both auras are present @Power');
  10.  
  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. (997266,0,7,0,23,0,100,1,119895,1,1000,1000,51,0,0,0,0,0,0,17,0,500,0,0,0,0,0,"wipe @Power");
  13.  
  14. 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
  15. (997257,0,6,0,60,0,100,0,5000,5000,5000,5000,75,72351,0,0,0,0,0,17,0,500,0,0,0,0,0,"prevent resurrection @Power"),
  16. (997257,0,7,0,60,0,100,0,1000,1000,1000,1000,83,3,0,0,0,0,0,19,997263,200,0,0,0,0,0,"remove gossip & questgiver @Power");
  17.  
  18. SET @ENTRY := 997263;
  19. UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
  20. 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
  21. (@ENTRY,0,0,1,23,0,100,0,119895,1,1000,1000,28,72351,0,0,0,0,0,17,0,500,0,0,0,0,0,"TE1 10s @Power"),
  22. (@ENTRY,0,1,0,61,0,100,0,0,0,0,0,11,72423,2,0,0,0,0,17,0,500,0,0,0,0,0,"mass ress @Power");
  23.  
  24. SET @ENTRY := 998982;
  25. UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
  26. 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
  27. (@ENTRY,0,0,0,10,0,100,0,1,5,1000,1000,62,870,0,0,0,0,0,7,0,0,0,170,4044,257,1.76,"failsafe teleporter @Power");
  28.  
  29. SET @ENTRY := 997323;
  30. UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
  31. DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0;
  32. 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
  33. (@ENTRY,0,0,0,64,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,"close @Power"),
  34. (@ENTRY,0,1,0,64,0,100,0,0,0,0,0,85,237873,0,0,0,0,0,1,0,0,0,0,0,0,0,"ride @Power"),
  35. (@ENTRY,0,2,0,28,0,100,0,0,0,0,0,41,500,0,0,0,0,0,1,0,0,0,0,0,0,0,"despawn @Power"),
  36. (@ENTRY,0,3,0,23,0,100,1,119895,1,1000,1000,51,0,0,0,0,0,0,17,0,500,0,0,0,0,0,"wipe @Power");
  37.  
  38. INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`) VALUES
  39. (997326, 0, 0, 0, 0, 0, 0, 0, 0, '142465');
  40.  
  41. SET @ENTRY := 997365;
  42. UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
  43. 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
  44. (@ENTRY,0,0,0,54,0,100,0,0,0,0,0,11,248642,0,0,0,0,0,1,0,0,0,0,0,0,0,"dark eruption @Power");
  45.  
  46. SET @ENTRY := 997364;
  47. UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
  48. 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
  49. (@ENTRY,0,0,0,54,0,100,0,0,0,0,0,11,246966,0,0,0,0,0,1,0,0,0,0,0,0,0,"thorns @Power"),
  50. (@ENTRY,0,1,0,0,0,100,0,18000,18000,18000,18000,11,184629,0,0,0,0,0,1,0,0,0,0,0,0,0,"Heal every 18s @Power"),
  51. (@ENTRY,0,2,0,0,0,100,0,10000,10000,10000,10000,11,248516,0,0,0,0,0,21,20,0,0,0,0,0,0,"sleep  every 10s @Power"),
  52. (@ENTRY,0,3,0,23,0,100,1,119895,1,2000,2000,51,0,0,0,0,0,0,17,0,500,0,0,0,0,0,"overlap = wipe @Power");
  53.  
  54.  
  55. 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
  56. (997363,0,2,0,23,0,100,1,119895,1,1000,1000,51,0,0,0,0,0,0,17,0,500,0,0,0,0,0,"overlap = wipe @Power");
  57.  
  58.  
  59. SET @ENTRY := 997366;
  60. UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
  61. 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
  62. (@ENTRY,0,0,0,54,0,100,0,0,0,0,0,75,173473,0,0,0,0,0,1,0,0,0,0,0,0,0,"beam visual @Power"),
  63. (@ENTRY,0,1,0,23,0,100,0,119895,0,500,500,11,203562,0,0,0,0,0,1,0,0,0,0,0,0,0,"cyclone @Power");
  64.  
  65. SET @ENTRY := 997367;
  66. UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
  67. 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
  68. (@ENTRY,0,0,0,54,0,100,0,0,0,0,0,67,1,5000,5000,0,0,100,1,0,0,0,0,0,0,0,"TE1 5s @Power"),
  69. (@ENTRY,0,1,0,60,0,100,0,500,500,500,500,215,997366,75,2,8100,0,0,1,0,0,0,0,0,0,0,"summon Cyclones @Power"),
  70. (@ENTRY,0,2,0,59,0,100,0,1,0,0,0,75,119895,0,0,0,0,0,9,997366,0,150,0,0,0,0,"trigger cyclones @Power"),
  71. (@ENTRY,0,3,0,59,0,100,0,1,0,0,0,41,500,0,0,0,0,0,1,0,0,0,0,0,0,0,"despawn @Power"),
  72. (@ENTRY,0,4,0,23,0,100,1,119895,1,1000,1000,51,0,0,0,0,0,0,17,0,500,0,0,0,0,0,"overlap = wipe @Power");
  73.  
  74. SET @ENTRY := 997369;
  75. UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
  76. 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
  77. (@ENTRY,0,0,0,6,0,100,0,0,0,0,0,9,0,0,0,0,0,0,20,998202,15,0,0,0,0,0,"activate wall @Power");
  78.  
  79. SET @ENTRY := 997326;
  80. UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
  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. (@ENTRY,0,0,0,0,0,100,0,5000,5000,5000,5000,11,245101,0,0,0,0,0,2,0,0,0,0,0,0,0,"devour flesh @Power"),
  83. (@ENTRY,0,1,0,75,0,100,0,0,997326,10,1000,75,133249,0,0,0,0,0,1,0,0,0,0,0,0,0,"shield up @Power"),
  84. (@ENTRY,0,2,0,75,0,100,0,0,997325,5,1000,28,133249,0,0,0,0,0,1,0,0,0,0,0,0,0,"shield down @Power");
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!