API tools faq
paste
casucristy

hwerqz

casucristy
Jul 13th, 2012
98
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 16.78 KB | None | 0 0
raw download clone embed print report
  1. -- [Q] Laying Waste to the Unwanted
  2.  
  3. -- Invis Horde Siege Engine - West SAI
  4. SET @ENTRY := 19009;
  5. SET @SPELL_IGNITE_SIEGE := 32979;
  6. SET @SPELL_HELLFIRE_FIRE := 34386;
  7. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;
  8. DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY;
  9. 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
  10. (@ENTRY,0,0,1,8,0,100,0,@SPELL_IGNITE_SIEGE,0,60000,60000,11,@SPELL_HELLFIRE_FIRE,0,0,0,0,0,1,0,0,0,0,0,0,0,"Invis Horde Siege Engine - West - On Spellhit - Cast Create Hellfire Fire"),
  11. (@ENTRY,0,1,0,61,0,100,0,0,0,0,0,33,@ENTRY,0,0,0,0,0,1,0,0,0,0,0,0,0,"Invis Horde Siege Engine - West - On Spellhit - Quest Credit");
  12.  
  13. -- Invis Horde Siege Engine - West 02 SAI
  14. SET @ENTRY := 21236;
  15. SET @SPELL_IGNITE_SIEGE := 32979;
  16. SET @SPELL_HELLFIRE_FIRE := 34386;
  17. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;
  18. DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY;
  19. 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
  20. (@ENTRY,0,0,1,8,0,100,0,@SPELL_IGNITE_SIEGE,0,60000,60000,11,@SPELL_HELLFIRE_FIRE,0,0,0,0,0,1,0,0,0,0,0,0,0,"Invis Horde Siege Engine - West 02 - On Spellhit - Cast Create Hellfire Fire"),
  21. (@ENTRY,0,1,0,61,0,100,0,0,0,0,0,33,@ENTRY,0,0,0,0,0,1,0,0,0,0,0,0,0,"Invis Horde Siege Engine - West 02 - On Spellhit - Quest Credit");
  22.  
  23. -- Invis Horde Siege Engine - East SAI
  24. SET @ENTRY := 21237;
  25. SET @SPELL_IGNITE_SIEGE := 32979;
  26. SET @SPELL_HELLFIRE_FIRE := 34386;
  27. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;
  28. DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY;
  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. (@ENTRY,0,0,1,8,0,100,0,@SPELL_IGNITE_SIEGE,0,60000,60000,11,@SPELL_HELLFIRE_FIRE,0,0,0,0,0,1,0,0,0,0,0,0,0,"Invis Horde Siege Engine - East - On Spellhit - Cast Create Hellfire Fire"),
  31. (@ENTRY,0,1,0,61,0,100,0,0,0,0,0,33,@ENTRY,0,0,0,0,0,1,0,0,0,0,0,0,0,"Invis Horde Siege Engine - East - On Spellhit - Quest Credit");
  32.  
  33. -- Invis Horde Siege Engine - East 02 SAI
  34. SET @ENTRY := 18818;
  35. SET @SPELL_IGNITE_SIEGE := 32979;
  36. SET @SPELL_HELLFIRE_FIRE := 34386;
  37. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;
  38. DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY;
  39. 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
  40. (@ENTRY,0,0,1,8,0,100,0,@SPELL_IGNITE_SIEGE,0,60000,60000,11,@SPELL_HELLFIRE_FIRE,0,0,0,0,0,1,0,0,0,0,0,0,0,"Invis Horde Siege Engine - East 02 - On Spellhit - Cast Create Hellfire Fire"),
  41. (@ENTRY,0,1,0,61,0,100,0,0,0,0,0,33,@ENTRY,0,0,0,0,0,1,0,0,0,0,0,0,0,"Invis Horde Siege Engine - East 02 - On Spellhit - Quest Credit");
  42.  
  43. -- spawn triggers
  44.  
  45. SET @GUID:= 390000; -- last guid;
  46.  
  47. DELETE FROM `creature` WHERE `id` = 18818;
  48. DELETE FROM `creature` WHERE `id` = 19009;
  49. DELETE FROM `creature` WHERE `id` = 21236;
  50. DELETE FROM `creature` WHERE `id` = 21237;
  51.  
  52. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES(@GUID+0,'18818','530','1','1','0','0','-160.54','2518.76','59.9245','6.07375','300','0','0','42','0','0','0','0','0');
  53. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES(@GUID+1,'18818','530','1','1','0','0','-144.371','2517.11','44.8188','3.24248','300','0','0','42','0','0','0','0','0');
  54. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES(@GUID+2,'18818','530','1','1','0','0','-155.792','2515.96','43.5965','3.24248','300','0','0','42','0','0','0','0','0');
  55. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES(@GUID+3,'18818','530','1','1','0','0','-152.417','2520.06','43.8033','4.21795','300','0','0','42','0','0','0','0','0');
  56. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES(@GUID+4,'18818','530','1','1','0','0','-142.357','2516.71','45.8','3.82996','300','0','0','42','0','0','0','0','0');
  57. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES(@GUID+5,'18818','530','1','1','0','0','-145.177','2521.3','45.435','1.99684','300','0','0','42','0','0','0','0','0');
  58. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES(@GUID+6,'18818','530','1','1','11686','0','-153.155','2521.52','45.6623','4.80857','300','0','0','42','0','0','0','0','0');
  59. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES(@GUID+7,'18818','530','1','1','11686','0','-152.037','2510.75','46.0389','2.15392','300','0','0','42','0','0','0','0','0');
  60. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES(@GUID+8,'19009','530','1','1','0','0','-183.948','2773.39','49.1984','5.95157','300','0','0','42','0','0','0','0','0');
  61. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES(@GUID+9,'19009','530','1','1','0','0','-159.978','2780.36','37.9237','4.04595','300','0','0','42','0','0','0','0','0');
  62. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES(@GUID+10,'19009','530','1','1','0','0','-159.795','2777.17','36.9799','3.62734','300','0','0','42','0','0','0','0','0');
  63. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES(@GUID+11,'19009','530','1','1','11686','0','-164.395','2772.83','39.1834','3.24799','300','0','0','42','0','0','0','0','0');
  64. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES(@GUID+12,'19009','530','1','1','11686','0','-170.491','2776.04','38.0003','2.37541','300','0','0','42','0','0','0','0','0');
  65. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES(@GUID+13,'19009','530','1','1','11686','0','-164.531','2783.8','36.642','0.529727','300','0','0','42','0','0','0','0','0');
  66. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES(@GUID+14,'19009','530','1','1','11686','0','-166.125','2774.29','38.8397','3.36266','300','0','0','42','0','0','0','0','0');
  67. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES(@GUID+15,'19009','530','1','1','0','0','-172.441','2772.06','35.3646','3.8174','300','0','0','42','0','0','0','0','0');
  68. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES(@GUID+16,'21236','530','1','1','0','0','-168.941','2820.42','43.0941','5.98648','300','0','0','42','0','0','0','0','0');
  69. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES(@GUID+17,'21236','530','1','1','0','0','-163.359','2814.55','33.6807','2.39112','300','0','0','42','0','0','0','0','0');
  70. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES(@GUID+18,'21236','530','1','1','0','0','-153.29','2814.02','33.7264','2.77046','300','0','0','42','0','0','0','0','0');
  71. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES(@GUID+19,'21236','530','1','1','0','0','-158.231','2811.47','33.6807','2.77046','300','0','0','42','0','0','0','0','0');
  72. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES(@GUID+20,'21236','530','1','1','0','0','-164.04','2820.85','33.6807','1.60964','300','0','0','42','0','0','0','0','0');
  73. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES(@GUID+21,'21236','530','1','1','0','0','-155.122','2820.93','33.2015','5.47616','300','0','0','42','0','0','0','0','0');
  74. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES(@GUID+22,'21236','530','1','1','0','0','-150.518','2819.09','34.4048','5.00492','300','0','0','42','0','0','0','0','0');
  75. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES(@GUID+23,'21236','530','1','1','0','0','-159.103','2817.17','31.4557','2.86314','300','0','0','42','0','0','0','0','0');
  76. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES(@GUID+24,'21237','530','1','1','0','0','-160.337','2663.65','62.2968','3.57792','300','0','0','42','0','0','0','0','0');
  77. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES(@GUID+25,'21237','530','1','1','0','0','-145.587','2659.98','48.1759','2.82543','300','0','0','42','0','0','0','0','0');
  78. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES(@GUID+26,'21237','530','1','1','0','0','-153.123','2655.21','44.8277','1.60964','300','0','0','42','0','0','0','0','0');
  79. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES(@GUID+27,'21237','530','1','1','11686','0','-137.698','2656.51','47.4249','2.65265','300','0','0','42','0','0','0','0','0');
  80. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES(@GUID+28,'21237','530','1','1','11686','0','-135.066','2661.45','47.712','2.9134','300','0','0','42','0','0','0','0','0');
  81. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES(@GUID+29,'21237','530','1','1','0','0','-142.591','2660.73','46.565','3.23698','300','0','0','42','0','0','0','0','0');
  82. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES(@GUID+30,'21237','530','1','1','0','0','-150.462','2660.05','45.2717','3.23698','300','0','0','42','0','0','0','0','0');
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
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!