API tools faq
paste
Guest User

Untitled

a guest
Jun 29th, 2010
262
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 11.73 KB | None | 0 0
raw download clone embed print report
  1. -- Fix for the quest I Sense a Disturbance
  2. UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 28671;
  3. INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (2867100, 28671, 4, 0, 100, 0, 0, 0, 0, 0, 15, 12665, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Quest complete.');
  4.  
  5. -- Fix for the quest Argent Crusade, We Are Leaving!
  6. UPDATE `quest_template` SET `ReqSpellCast1` = 34656 WHERE `entry` = 12504;
  7. INSERT INTO `creature_ai_scripts` (`id`,`creature_id`,`event_type`,`event_inverse_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action1_type`,`action1_param1`,`action1_param2`,`action1_param3`,`action2_type`,`action2_param1`,`action2_param2`,`action2_param3`,`action3_type`,`action3_param1`,`action3_param2`,`action3_param3`,`comment`) VALUES ('2804102','28041','10','0','100','0','1','3','0','0','16','28041','34656','6','0','0','0','0','0','0','0','0','Quest credit when moving close to talk.');
  8.  
  9. -- Fix for the quest A Tangled Skein
  10. UPDATE `quest_template` SET `ReqCreatureOrGOId1` = 28274, `ReqSpellCast1` = 51165 WHERE `entry` = 12555;
  11. UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 28274;
  12. INSERT INTO `creature_ai_scripts` VALUES
  13. ( 2827400, 28274, 8, 0, 100, 0, 51165, -1, 0, 0, 23, 1, 0, 0, 0, 0, 0, 0, 20, 0, 0, 0, 'Increase phase on spellhit.'),
  14. ( 2827401, 28274, 0, 1, 100, 0, 5100, 5200, 0, 0, 11, 53236, 0, 23, 0, 0, 0, 0, 0, 0, 0, 0, 'Sprayer explosion.'),
  15. ( 2827402, 28274, 0, 1, 100, 0, 5400, 5500, 0, 0, 11, 51314, 0, 23, 0, 0, 0, 0, 0, 0, 0, 0, 'Sprayer spawn corpse.'),
  16. (2827403, 28274, 0, 1, 100, 0, 5600, 5700, 0, 0, 41, 0, 0, 0, 23, -1, 0, 0, 0, 0, 0, 0, 'Sprayer despawn.');
  17.  
  18. -- Fix for the quest Leave No One Behind
  19. UPDATE `quest_template` SET `ReqSpellCast1` = 50662, `ReqSpellCast2` = 50662, `ReqSpellCast3` = 50662 WHERE `entry` = 12512;
  20. INSERT INTO `creature_ai_texts` (`entry`,`content_default`,`sound`,`type`,`language`,`emote`,`comment`) VALUES ('-40000','<sigh>... Well, I suppose it could be worse.','0','0','0','1','Lamoof Say'),
  21. ('-40001','Thank you, friend. Were it not for your aid I would be no more.','0','0','0','1','Jonathan Say'),
  22. ('-40002','I am in your debt, friend. Thank you for my life.','0','0','0','1','Josephine Say');
  23. UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 28136;
  24. UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 28142;
  25. UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 28148;
  26. INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (2813600, 28136, 8, 0, 100, 0, 50662, -1, 0, 0, 1, -40001, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Speak on spellhit.'),
  27. (2814200, 28142, 8, 0, 100, 0, 50662, -1, 0, 0, 1, -40000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Speak on spellhit.'),
  28. (2814800, 28148, 8, 0, 100, 0, 50662, -1, 0, 0, 1, -40002, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Speak on spellhit.');
  29.  
  30. -- Fix for the quest Scalps!
  31. UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 28600;
  32. INSERT INTO `creature_ai_scripts` (`id`,`creature_id`,`event_type`,`event_inverse_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action1_type`,`action1_param1`,`action1_param2`,`action1_param3`,`action2_type`,`action2_param1`,`action2_param2`,`action2_param3`,`action3_type`,`action3_param1`,`action3_param2`,`action3_param3`,`comment`) VALUES ('2846505','28465','8','0','100','0','52090','-1','0','0','16','28622','52090','6','0','0','0','0','0','0','0','0','Credit for scalping.'),
  33. ('2860000','28600','8','0','100','0','52090','-1','0','0','16','28622','52090','6','0','0','0','0','0','0','0','0','Credit for scalping.');
  34. UPDATE `quest_template` SET `ReqSpellCast1` = 52090 WHERE `entry` = 12659;
  35.  
  36. -- Fix for the quest Tails Up
  37. UPDATE `quest_template` SET `ReqCreatureOrGOId1` = 29327, `ReqCreatureOrGOId2` = 29319, `ReqSpellCast1` = 62105, `ReqSpellCast2` = 62105 WHERE `entry` = 13549;
  38. UPDATE `creature_template` SET `unit_flags` = 0 WHERE `entry` = 29319;
  39. INSERT INTO `creature_ai_scripts` (`id`,`creature_id`,`event_type`,`event_inverse_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action1_type`,`action1_param1`,`action1_param2`,`action1_param3`,`action2_type`,`action2_param1`,`action2_param2`,`action2_param3`,`action3_type`,`action3_param1`,`action3_param2`,`action3_param3`,`comment`) VALUES ('2932702','29327','8','0','100','0','62105','-1','0','0','23','1','0','0','11','17743','0','23','0','0','0','0','Fall asleep on spellhit and increase phase by 1.'),
  40. ('2932703','29327','0','1','100','0','5000','6000','0','0','23','-1','0','0','41','0','0','0','0','0','0','0','Despawn after 5 seconds to avoid abusing.'),
  41. ('2931902','29319','8','0','100','0','62105','-1','0','0','23','1','0','0','11','17743','0','23','0','0','0','0','Fall asleep on spellhit and increase phase by 1.'),
  42. ('2931903','29319','0','1','100','0','5000','6000','0','0','23','-1','0','0','41','0','0','0','0','0','0','0','Despawn after 5 seconds to avoid abusing.');
  43.  
  44. -- Fix for the quest Latent Power
  45. UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 26857;
  46. UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 26856;
  47. UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 26855;
  48. INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (2685600, 26856, 8, 0, 100, 0, 47542, -1, 0, 0, 16, 26856, 47542, 6, 0, 0, 0, 0, 0, 0, 0, 0, 'Credit for charging.'),
  49. (2685700, 26857, 8, 0, 100, 0, 47542, -1, 0, 0, 16, 26857, 47542, 6, 0, 0, 0, 0, 0, 0, 0, 0, 'Credit for charging.'),
  50. (2685500, 26855, 8, 0, 100, 0, 47542, -1, 0, 0, 16, 26855, 47542, 6, 0, 0, 0, 0, 0, 0, 0, 0, 'Credit for charging.');
  51.  
  52. -- Fix Southsea Freeboother's ranged attack.
  53. DELETE FROM `creature_ai_scripts` WHERE (`id`='785604');
  54. DELETE FROM `creature_ai_scripts` WHERE (`id`='785605');
  55. DELETE FROM `creature_ai_scripts` WHERE (`id`='785606');
  56. DELETE FROM `creature_ai_scripts` WHERE (`id`='785607');
  57. DELETE FROM `creature_ai_scripts` WHERE (`id`='785608');
  58. DELETE FROM `creature_ai_scripts` WHERE (`id`='785609');
  59.  
  60. UPDATE `creature_ai_scripts` SET `id`='785601',`creature_id`='7856',`event_type`='11',`event_inverse_phase_mask`='0',`event_chance`='100',`event_flags`='0',`event_param1`='0',`event_param2`='0',`event_param3`='0',`event_param4`='0',`action1_type`='40',`action1_param1`='2',`action1_param2`='0',`action1_param3`='0',`action2_type`='29',`action2_param1`='20',`action2_param2`='10',`action2_param3`='0',`action3_type`='0',`action3_param1`='0',`action3_param2`='0',`action3_param3`='0',`comment`='Southsea Freebooter - Ranged Combat' WHERE (`id`='785601');
  61. UPDATE `creature_ai_scripts` SET `id`='785602',`creature_id`='7856',`event_type`='4',`event_inverse_phase_mask`='0',`event_chance`='100',`event_flags`='0',`event_param1`='0',`event_param2`='0',`event_param3`='0',`event_param4`='0',`action1_type`='11',`action1_param1`='6660',`action1_param2`='1',`action1_param3`='3',`action2_type`='29',`action2_param1`='15',`action2_param2`='10',`action2_param3`='0',`action3_type`='0',`action3_param1`='0',`action3_param2`='0',`action3_param3`='0',`comment`='Shoot on aggro.' WHERE (`id`='785602');
  62. UPDATE `creature_ai_scripts` SET `id`='785603',`creature_id`='7856',`event_type`='0',`event_inverse_phase_mask`='0',`event_chance`='100',`event_flags`='1',`event_param1`='2000',`event_param2`='2800',`event_param3`='2500',`event_param4`='3000',`action1_type`='11',`action1_param1`='6660',`action1_param2`='1',`action1_param3`='3',`action2_type`='29',`action2_param1`='15',`action2_param2`='10',`action2_param3`='0',`action3_type`='0',`action3_param1`='0',`action3_param2`='0',`action3_param3`='0',`comment`='Shoot.' WHERE (`id`='785603');
  63.  
  64. -- Fix for the quest Anatoly Will Talk
  65. UPDATE `quest_template` SET `SpecialFlags` = 0, `ReqCreatureOrGOId1` = 27627, `ReqCreatureOrGOCount1` = 1, `ReqSpellCast1` = 49134 WHERE `entry` = 12330;
  66.  
  67. -- Fix for the quest Escape from Silverbrook
  68. UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 26875;
  69. INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES (2687500, 26875, 10, 0, 100, 0, 1, 35, 0, 0, 33, 28019, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Credit for escaping Silverbrook.');
  70.  
  71. -- Fix for the quest Saragosa's End
  72. UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 26231;
  73. DELETE FROM `creature_ai_scripts` WHERE (`creature_id`=26231);
  74. INSERT INTO `creature_ai_scripts` VALUES
  75. ( 2623100, 26231, 11, 0, 100, 0, 0, 0, 0, 0, 11, 66514, 0, 23, 2, 35, 0, 0, 0, 0, 0, 0, 'Frost Breath on spawn.'),
  76. ( 2623101, 26231, 4, 0, 100, 0, 0, 0, 0, 0, 11, 51779, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Saragosa - Cast Frostfire Bolt and Set Phase 1 on Aggro'),
  77. ( 2623102, 26231, 9, 5, 100, 1, 0, 40, 3400, 6200, 11, 51779, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Saragosa - Cast Frostfire Bolt (Phase 1)'),
  78. ( 2623103, 26231, 3, 5, 100, 0, 15, 0, 0, 0, 21, 1, 0, 0, 23, 1, 0, 0, 0, 0, 0, 0, 'Saragosa - Start Combat Movement and Set Phase 2 when Mana is at 15% (Phase 1)'),
  79. ( 2623104, 26231, 9, 5, 100, 0, 35, 80, 0, 0, 21, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Saragosa - Start Combat Movement at 35 Yards (Phase 1)'),
  80. ( 2623105, 26231, 9, 5, 100, 0, 5, 15, 0, 0, 21, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Saragosa - Prevent Combat Movement at 15 Yards (Phase 1)'),
  81. ( 2623106, 26231, 3, 3, 100, 1, 100, 30, 100, 100, 23, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Saragosa - Set Phase 1 when Mana is above 30% (Phase 2)'),
  82. ( 2623107, 26231, 0, 0, 100, 1, 8500, 17500, 20100, 40100, 11, 15063, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Saragosa - Cast Frost Nova'),
  83. ( 2623109, 26231, 1, 0, 100, 0, 8000, 9000, 0, 0, 3, 26232, 0, 0, 2, 14, 0, 0, 0, 0, 0, 0, 'Saragosa - Change to woman.'),
  84. (2623108, 26231, 7, 0, 100, 0, 0, 0, 0, 0, 22, 0, 0, 0, 3, 0, 0, 0, 2, 0, 0, 0, 'Saragosa - Set Phase to 0 on Evade');
  85.  
  86. -- Fix for Nethermine Burster
  87. UPDATE `creature_template` SET `unit_flags` = 0 WHERE `entry` = 23285;
  88.  
  89. -- Fix for the quest Slim Pickings
  90. INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`,`lootcondition`,`condition_value1`,`condition_value2`) VALUES ('26809','36765','-100','1','0','1','1','0','0','0');
  91. UPDATE `creature_template` SET `faction_A` = 1990, `faction_H` = 1990, `lootid` = 26809, `unit_flags` = 0, `dynamicflags` = 0, `type_flags` = 0 WHERE `entry` = 26809;
  92.  
  93. -- Fix Water Terror
  94. UPDATE `creature_template` SET `unit_flags` = 0, `dynamicflags` = 0 WHERE `entry` = 30633;
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!