API tools faq
paste
Advertisement
gecko32

Prepping the Speech

gecko32
Feb 26th, 2012
167
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 7.20 KB | None | 0 0
raw download clone embed print report
  1. -- FIx for Prepping the Speech
  2. SET @MEKKATORQUE=39712;
  3. SET @OZZIE=1268;
  4. SET @MILLI=7955;
  5. SET @TOG=6119;
  6. -- Add creature text for npc's
  7. DELETE FROM `creature_text` WHERE `entry` =@MEKKATORQUE;
  8. DELETE FROM `creature_text` WHERE `entry` =@OZZIE;
  9. DELETE FROM `creature_text` WHERE `entry` =@MILLI;
  10. DELETE FROM `creature_text` WHERE `entry` =@TOG;
  11. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES
  12. (@MEKKATORQUE, 0, 0, 'They may take our lives, but they\'ll never take...', 12, 0, 100, 0, 0, 0, 'High Tinker Mekkatorque to Milli Featherwhistle 1'),
  13. (@MEKKATORQUE, 1, 0, '...our INNOVATION!', 12, 0, 100, 0, 0, 0, 'High Tinker Mekkatorque to Milli Featherwhistle 2'),
  14. (@MEKKATORQUE, 2, 0, 'What I want out of each and every one of you is a hard-target search of every refuelling station, residence, warehouse, farmhouse, henhouse, outhouse, and doghouse in this area.', 12, 0, 100, 0, 0, 0, 'High Tinker Mekkatorque to Ozzie Togglevolt 1'),
  15. (@MEKKATORQUE, 3, 0, 'Your fugitive\'s name is Mekgineer Thermaplugg.', 12, 0, 100, 0, 0, 0, 'High Tinker Mekkatorque to Ozzie Togglevolt 2'),
  16. (@MEKKATORQUE, 4, 0, 'Go get him.', 12, 0, 100, 0, 0, 0, 'High Tinker Mekkatorque to Ozzie Togglevolt 3'),
  17. (@MEKKATORQUE, 5, 0, 'We will not go quietly into the night! We will not vanish without a fight!', 12, 0, 100, 0, 0, 0, 'High Tinker Mekkatorque to Tog Rustsprocket 1'),
  18. (@MEKKATORQUE, 6, 0, 'We\'re going to live on! We\'re going to survive! Today we celebrate...', 12, 0, 100, 0, 0, 0, 'High Tinker Mekkatorque to Tog Rustsprocket 2'),
  19. (@MEKKATORQUE, 7, 0, '...our Autonomy Day!', 12, 0, 100, 0, 0, 0, 'High Tinker Mekkatorque to Tog Rustsprocket 3'),
  20. (@OZZIE, 0, 0, 'Hmm, I suppose it could work. But it could really use a little more umph!', 12, 0, 100, 0, 0, 0, 'Ozzie Togglevolt reply'),
  21. (@MILLI, 0, 0, 'What? I don\'t even know what you\'re talking about! That\'s terrible!', 12, 0, 100, 0, 0, 0, 'Milli Featherwhistle reply'),
  22. (@TOG, 0, 0, 'Horrible! Well, all right, maybe it just needs a little cleaning up?', 12, 0, 100, 0, 0, 0, 'Tog Rustsprocket reply');
  23. -- Add SAI for Milli Featherwhistle
  24. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@MILLI;
  25. DELETE FROM `smart_scripts` WHERE `entryorguid`=@MILLI;
  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. (@MILLI,0,0,0,8,0,100,1,74222,0,0,0,1,0,2000,0,0,0,0,11,@MEKKATORQUE,10,0,0.0,0.0,0.0,0.0,'Milli Featherwhistle - On spell hit - High Tinker Mekkatorque say part1'),
  28. (@MILLI,0,1,0,52,0,100,0,0,@MEKKATORQUE,0,0,1,1,4000,0,0,0,0,11,@MEKKATORQUE,10,0,0.0,0.0,0.0,0.0,'Milli Featherwhistle - On text over - High Tinker Mekkatorque say part2'),
  29. (@MILLI,0,2,3,52,0,100,0,1,@MEKKATORQUE,0,0,1,0,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'Milli Featherwhistle - On text over - Reply'),
  30. (@MILLI,0,3,4,61,0,100,0,0,0,0,0,33,@MILLI,0,0,0,0,0,7,0,0,0,0.0,0.0,0.0,0.0,'Milli Featherwhistle - On link - credit quest'),
  31. (@MILLI,0,4,0,61,0,100,0,0,0,0,0,45,1,1,0,0,0,0,11,@MEKKATORQUE,10,0,0.0,0.0,0.0,0.0,'Milli Featherwhistle - On link - set data 1');
  32. -- Add SAI for Ozzie Togglevolt
  33. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@OZZIE;
  34. DELETE FROM `smart_scripts` WHERE `entryorguid`=@OZZIE;
  35. 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
  36. (@OZZIE,0,0,0,8,0,100,1,74222,0,0,0,1,2,2000,0,0,0,0,11,@MEKKATORQUE,10,0,0.0,0.0,0.0,0.0,'Ozzie Togglevolt - On spell hit - High Tinker Mekkatorque say part1'),
  37. (@OZZIE,0,1,0,52,0,100,0,2,@MEKKATORQUE,0,0,1,3,4000,0,0,0,0,11,@MEKKATORQUE,10,0,0.0,0.0,0.0,0.0,'Ozzie Togglevolt - On text over - High Tinker Mekkatorque say part2'),
  38. (@OZZIE,0,2,0,52,0,100,0,3,@MEKKATORQUE,0,0,1,4,4000,0,0,0,0,11,@MEKKATORQUE,10,0,0.0,0.0,0.0,0.0,'Ozzie Togglevolt - On text over - High Tinker Mekkatorque say part3'),
  39. (@OZZIE,0,3,4,52,0,100,0,4,@MEKKATORQUE,0,0,1,0,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'Ozzie Togglevolt - On text over - Reply'),
  40. (@OZZIE,0,4,5,61,0,100,0,0,0,0,0,33,@OZZIE,0,0,0,0,0,7,0,0,0,0.0,0.0,0.0,0.0,'Milli Featherwhistle - On link - credit quest'),
  41. (@OZZIE,0,5,0,61,0,100,0,0,0,0,0,45,1,1,0,0,0,0,11,@MEKKATORQUE,10,0,0.0,0.0,0.0,0.0,'Milli Featherwhistle - On link - set data 1');
  42. -- Add SAI for Tog Rustsprocket
  43. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@TOG;
  44. DELETE FROM `smart_scripts` WHERE `entryorguid`=@TOG;
  45. 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
  46. (@TOG,0,0,0,8,0,100,1,74222,0,0,0,1,5,2000,0,0,0,0,11,@MEKKATORQUE,10,0,0.0,0.0,0.0,0.0,'Tog Rustsprocket - On spell hit - High Tinker Mekkatorque say part1'),
  47. (@TOG,0,1,0,52,0,100,0,5,@MEKKATORQUE,0,0,1,6,4000,0,0,0,0,11,@MEKKATORQUE,10,0,0.0,0.0,0.0,0.0,'Tog Rustsprocket - On text over - High Tinker Mekkatorque say part2'),
  48. (@TOG,0,2,0,52,0,100,0,6,@MEKKATORQUE,0,0,1,7,4000,0,0,0,0,11,@MEKKATORQUE,10,0,0.0,0.0,0.0,0.0,'Tog Rustsprocket - On text over - High Tinker Mekkatorque say part3'),
  49. (@TOG,0,3,4,52,0,100,0,7,@MEKKATORQUE,0,0,1,0,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'Tog Rustsprocket - On text over - Reply'),
  50. (@TOG,0,4,5,61,0,100,0,0,0,0,0,33,@TOG,0,0,0,0,0,7,0,0,0,0.0,0.0,0.0,0.0,'Tog Rustsprocket - On link - credit quest'),
  51. (@TOG,0,5,0,61,0,100,0,0,0,0,0,45,1,1,0,0,0,0,11,@MEKKATORQUE,10,0,0.0,0.0,0.0,0.0,'Tog Rustsprocket - On link - set data 1');
  52. -- Add SAI for High Tinker Mekkatorque
  53. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@MEKKATORQUE;
  54. DELETE FROM `smart_scripts` WHERE `entryorguid`=@MEKKATORQUE;
  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. (@MEKKATORQUE,0,0,0,38,0,100,1,1,1,0,0,41,1000,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,'High Tinker Mekkatorque - on data set- despawn');
  57. -- add prev quest id to both Words for Delivery
  58. UPDATE `quest_template` SET `PrevQuestId`=25283 WHERE `Id`=25500;-- below 75
  59. UPDATE `quest_template` SET `PrevQuestId`=25283 WHERE `Id`=25286;-- 75+
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!