API tools faq
paste
Guest User

Untitled

a guest
Jan 19th, 2012
81
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.45 KB | None | 0 0
raw download clone embed print report
  1. -- The Last Line Of Defense
  2. -- start event gossip
  3.  
  4. UPDATE `creature_template` SET `gossip_menu_id`=30657 WHERE `entry`=30657;
  5. DELETE FROM `gossip_menu` WHERE `entry`=30657;
  6. INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES (30657, 1);
  7. DELETE FROM `gossip_menu_option` WHERE `menu_id`=30657;
  8. INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`, `box_coded`, `box_money`, `box_text`) VALUES
  9. ('30657', '0', '0', 'The Lich kings minnions are comming. May i prepare cannon for you?', '1', '3', '0', '0', '0', '0', '0', 'Are you ready to defend the camp?');
  10. /*
  11. +DELETE FROM `gossip_scripts` WHERE `id`=30657;
  12. +INSERT INTO `gossip_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES
  13. +(30657, 0, 10, 730017, 600000, 0, 6291.32, 140.507, 386.517, 4.43048),
  14. +(30657, 0, 10, 730017, 600000, 0, 6311.92, 127.115, 389.501, 3.98517),
  15. +(30657, 0, 10, 730019, 600000, 0, 6325.59, 115.692, 390.431, 3.78489),
  16. +(30657, 0, 10, 730019, 600000, 0, 6343.48, 94.1783, 391.444, 3.54927),
  17. +(30657, 0, 10, 730019, 600000, 0, 6339.35, 67.395, 390.09, 2.6657),
  18. +(30657, 0, 10, 730017, 600000, 0, 6265.25, 145.87, 383.394, 4.59306),
  19. +(30657, 0, 10, 730021, 600000, 0, 6272.11, 77.81, 393.821, 0.69),
  20. +(30657, 0, 6, 571, 0, 0, 6272.30, 77.69, 393.82, 0.82),
  21. +(30657, 0, 10, 30236, 600000, 0, 6282.92, 70.2466, 396.427, 0.936193),
  22. +(30657, 0, 10, 30236, 600000, 0, 6273.69, 79.3612, 396.309, 0.791233),
  23. +(30657, 0, 10, 30236, 600000, 0, 6264.18, 85.28, 391.7, 0.68),
  24. +(30657, 0, 10, 30236, 600000, 0, 6289.03, 61.45, 391.81, 0.92);
  25. +*/
  26. -- skript ke zkontrolovani
  27. SET @NPC_Fezzik :=30657;
  28. UPDATE `creature_template` SET `AIName`='SmartAI',`ScriptName`='',`npcflag`=3 WHERE `entry`=@NPC_Fezzik;
  29. DELETE FROM `smart_scripts` WHERE `entryorguid`=@NPC_Fezzik AND `source_type`=0;
  30. 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
  31. (@NPC_Fezzik,0,0,0,1,0,100,0,1000,1000,1000,1000,15,3070,0,0,0,0,0,18,1,0,0,0,0,0,0,'Complete quest on player range'),
  32. (@NPC_Fezzik,0,1,2,62,0,100,0,30657,0,0,0,12,30236,3,600000,0,0,0,8,0,0,0,6282.92,70.2466,396.427,0.936193,'Siegemaster Fezzik - summon cannon on gossip'),
  33. (@NPC_Fezzik,0,2,3,61,0,100,0,0,0,0,0,12,30236,3,600000,0,0,0,8,0,0,0,6289.03,61.45,391.81,0.92,'Siegemaster Fezzik - summon cannon on gossip'),
  34. (@NPC_Fezzik,0,3,4,61,0,100,0,0,0,0,0,12,30236,3,600000,0,0,0,8,0,0,0,6273.69,79.3612,396.309,0.791233,'Siegemaster Fezzik - summon cannon on gossip'),
  35. (@NPC_Fezzik,0,4,5,61,0,100,0,0,0,0,0,12,30236,3,600000,0,0,0,8,0,0,0,6264.18,85.28,391.7,0.68,'Siegemaster Fezzik - summon cannon on gossip'),
  36. (@NPC_Fezzik,0,5,6,61,0,100,0,0,0,0,0,12,730017,3,600000,0,0,0,8,0,0,0,6291.32, 140.507, 386.517, 4.43048,'Siegemaster Fezzik - summon spawner on gossip'),
  37. (@NPC_Fezzik,0,6,7,61,0,100,0,0,0,0,0,12,730017,3,600000,0,0,0,8,0,0,0,6311.92, 127.115, 389.501, 3.98517,'Siegemaster Fezzik - summon spawner on gossip'),
  38. (@NPC_Fezzik,0,7,8,61,0,100,0,0,0,0,0,12,730017,3,600000,0,0,0,8,0,0,0,6265.25, 145.87, 383.394, 4.59306,'Siegemaster Fezzik - summon spawner on gossip'),
  39. (@NPC_Fezzik,0,8,9,61,0,100,0,0,0,0,0,12,730019,3,600000,0,0,0,8,0,0,0,6325.59, 115.692, 390.431, 3.78489,'Siegemaster Fezzik - summon spawner on gossip'),
  40. (@NPC_Fezzik,0,9,10,61,0,100,0,0,0,0,0,12,730019,3,600000,0,0,0,8,0,0,0,6343.48, 94.1783, 391.444, 3.54927,'Siegemaster Fezzik - summon spawner on gossip'),
  41. (@NPC_Fezzik,0,10,11,61,0,100,0,0,0,0,0,12,730019,3,600000,0,0,0,8,0,0,0,6339.35, 67.395, 390.09, 2.6657,'Siegemaster Fezzik - summon spawner on gossip'),
  42. (@NPC_Fezzik,0,11,12,61,0,100,0,0,0,0,0,81,2,0,0,0,0,0,7,0,0,0,0,0,0,0,'Fezzik - set flag to gossip'),
  43. (@NPC_Fezzik,0,12,0,1,0,100,0,600000,600000,0,0,81,3,0,0,0,0,0,7,0,0,0,0,0,0,0,'Fezzik - set flag back to quest giver ');
  44.  
  45.  
  46.  
  47. -- Argent Cannon
  48. SET @ENTRY := 30236;
  49. SET @VEHICLE := 246;
  50. -- spawn utocicich mobu
  51. DELETE FROM `smart_scripts` WHERE `entryorguid`IN (730017, 730019, 30593);
  52. 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
  53. (730017, 0, 0, 0, 1, 0, 100, 0, 20000, 30000, 2000, 3000, 12, 30593, 3, 60000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Summon spider'),
  54. (730017, 0, 1, 0, 1, 0, 100, 0, 20000, 80000, 30000, 40000, 12, 30575, 3, 60000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Summon wyrm'),
  55. (730019, 0, 0, 0, 1, 0, 100, 0, 20000, 30000, 2000, 3000, 12, 730020, 3, 60000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Summon spider'),
  56. (730019, 0, 1, 0, 1, 0, 100, 0, 20000, 80000, 30000, 40000, 12, 30575, 3, 60000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Summon wyrm'),
  57. (730017, 0, 2, 0, 1, 0, 100, 0, 20000, 30000, 15000, 15000, 12, 30189, 3, 30000, 0, 0, 0, 1, 0, 0, 0, 6288.7, 96.6109, 390.21, 0.8, 'Summon defender'),
  58. (730019, 0, 2, 0, 1, 0, 100, 0, 20000, 30000, 15000, 15000, 12, 30189, 3, 30000, 0, 0, 0, 1, 0, 0, 0, 6301.15, 86.1998, 389.705, 0.8, 'Summon defender');
  59. UPDATE `quest_template` SET `StartScript`=13086 WHERE `Id`=13086;
  60.  
  61. /*
  62. -- spawn dela a vyvolavace utoku
  63. DELETE FROM `quest_start_scripts` WHERE `id`=13086;
  64. INSERT INTO `quest_start_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES
  65. -(13086, 0, 10, 730017, 180000, 0, 6291.32, 140.507, 386.517, 4.43048),
  66. -(13086, 0, 10, 730017, 180000, 0, 6311.92, 127.115, 389.501, 3.98517),
  67. -(13086, 0, 10, 730019, 180000, 0, 6325.59, 115.692, 390.431, 3.78489),
  68. -(13086, 0, 10, 730019, 180000, 0, 6343.48, 94.1783, 391.444, 3.54927),
  69. -(13086, 0, 10, 730019, 180000, 0, 6339.35, 67.395, 390.09, 2.6657),
  70. -(13086, 0, 10, 730017, 180000, 0, 6265.25, 145.87, 383.394, 4.59306),
  71. -(13086, 0, 10, 730021, 180000, 0, 6272.11, 77.81, 393.821, 0.69),
  72. +(13086, 0, 10, 730017, 600000, 0, 6291.32, 140.507, 386.517, 4.43048),
  73. +(13086, 0, 10, 730017, 600000, 0, 6311.92, 127.115, 389.501, 3.98517),
  74. +(13086, 0, 10, 730019, 600000, 0, 6325.59, 115.692, 390.431, 3.78489),
  75. +(13086, 0, 10, 730019, 600000, 0, 6343.48, 94.1783, 391.444, 3.54927),
  76. +(13086, 0, 10, 730019, 600000, 0, 6339.35, 67.395, 390.09, 2.6657),
  77. +(13086, 0, 10, 730017, 600000, 0, 6265.25, 145.87, 383.394, 4.59306),
  78. +(13086, 0, 10, 730021, 600000, 0, 6272.11, 77.81, 393.821, 0.69),
  79. (13086, 0, 6, 571, 0, 0, 6272.30, 77.69, 393.82, 0.82),
  80. -(13086, 0, 10, 30236, 180000, 0, 6282.92, 70.2466, 396.427, 0.936193),
  81. -(13086, 0, 10, 30236, 180000, 0, 6273.69, 79.3612, 396.309, 0.791233);
  82. +(13086, 0, 10, 30236, 600000, 0, 6282.92, 70.2466, 396.427, 0.936193),
  83. +(13086, 0, 10, 30236, 600000, 0, 6273.69, 79.3612, 396.309, 0.791233),
  84. +(13086, 0, 10, 30236, 600000, 0, 6264.18, 85.28, 391.7, 0.68),
  85. +(13086, 0, 10, 30236, 600000, 0, 6289.03, 61.45, 391.81, 0.92);
  86. +*/
  87.  
  88. -- nastaveni utocniku
  89. UPDATE `creature_template` SET `minrangedmg`=1000,`maxrangedmg`=2000,`InhabitType`=4 WHERE `entry`=30575;
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!