API tools faq
paste
casucristy

gaweqwrq

casucristy
Jul 13th, 2012
75
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 5.45 KB | None | 0 0
raw download clone embed print report
  1. -- [Q] The Exorcism of Colonel Jules
  2. -- http://old.wowhead.com/quest=10935
  3.  
  4.  
  5. SET @ENTRY:=22431;
  6. SET @COLONEL:=22432;
  7. SET @GOSSIP:=8539;
  8. SET @ITEM:=31828;
  9. SET @QUEST:=10935;
  10.  
  11. DELETE FROM `gossip_menu` WHERE `entry`=@GOSSIP;
  12. INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES
  13. (@GOSSIP, 10683);
  14.  
  15. DELETE FROM `gossip_menu_option` WHERE `menu_id`=@GOSSIP;
  16. INSERT INTO `gossip_menu_option` VALUES
  17. (@GOSSIP, 0, 0, 'Let''s begin...', 1, 1, 0, 0, 0, 0, '');
  18.  
  19.  
  20. UPDATE `creature_template` SET `AIName`='SmartAI', `gossip_menu_id`=@GOSSIP WHERE `entry`=@ENTRY;
  21. DELETE FROM `smart_scripts` WHERE `entryorguid` IN (@ENTRY,@ENTRY*100);
  22.  
  23. 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
  24. (@ENTRY,0,0,0,62,0,100,0,@GOSSIP,0,0,0,80,@ENTRY*100,0,2,0,0,0,1,0,0,0,0,0,0,0,"Gossip select - Run Script"),
  25. (@ENTRY*100,9,0,0,0,0,100,1,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,"close gossip"),
  26. (@ENTRY*100,9,1,0,0,0,100,1,0,0,0,0,57,@ITEM,1,0,0,0,0,7,0,0,0,0,0,0,0,"Remove item"),
  27. (@ENTRY*100,9,2,0,0,0,100,1,4000,4000,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"On Script - SAY"),
  28. (@ENTRY*100,9,3,0,0,0,100,1,4000,4000,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,"On Script - SAY"),
  29. (@ENTRY*100,9,4,0,0,0,100,1,4000,4000,0,0,1,0,0,0,0,0,0,9,@COLONEL,0,20,0,0,0,0,"On Script - SAY"),
  30. (@ENTRY*100,9,5,0,0,0,100,1,4000,4000,0,0,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,"On Script - SAY"),
  31. (@ENTRY*100,9,6,0,0,0,100,1,4000,4000,0,0,1,1,0,0,0,0,0,9,@COLONEL,0,20,0,0,0,0,"On Script - SAY"),
  32. (@ENTRY*100,9,7,0,0,0,100,1,4000,4000,0,0,1,2,0,0,0,0,0,9,@COLONEL,0,20,0,0,0,0,"On Script - SAY"),
  33. (@ENTRY*100,9,8,0,0,0,100,1,4000,4000,0,0,1,3,0,0,0,0,0,0,0,0,0,0,0,0,0,"On Script - SAY"),
  34. (@ENTRY*100,9,9,0,0,0,100,1,4000,4000,0,0,1,3,0,0,0,0,0,9,@COLONEL,0,20,0,0,0,0,"On Script - SAY"),
  35. (@ENTRY*100,9,10,0,0,0,100,1,4000,4000,0,0,1,4,0,0,0,0,0,0,0,0,0,0,0,0,0,"On Script - SAY"),
  36. (@ENTRY*100,9,11,0,0,0,100,1,4000,4000,0,0,1,4,0,0,0,0,0,9,@COLONEL,0,20,0,0,0,0,"On Script - SAY"),
  37. (@ENTRY*100,9,12,0,0,0,100,1,4000,4000,0,0,1,5,0,0,0,0,0,0,0,0,0,0,0,0,0,"On Script - SAY"),
  38. (@ENTRY*100,9,13,0,0,0,100,1,4000,4000,0,0,1,5,0,0,0,0,0,9,@COLONEL,0,20,0,0,0,0,"On Script - SAY"),
  39. (@ENTRY*100,9,14,0,0,0,100,1,4000,4000,0,0,1,6,0,0,0,0,0,0,0,0,0,0,0,0,0,"On Script - SAY"),
  40. (@ENTRY*100,9,15,0,0,0,100,1,4000,4000,0,0,1,5,0,0,0,0,0,9,@COLONEL,0,20,0,0,0,0,"On Script - SAY"),
  41. (@ENTRY*100,9,16,0,0,0,100,1,4000,4000,0,0,1,6,0,0,0,0,0,0,0,0,0,0,0,0,0,"On Script - SAY"),
  42. (@ENTRY*100,9,17,0,0,0,100,1,4000,4000,0,0,1,6,0,0,0,0,0,9,@COLONEL,0,20,0,0,0,0,"On Script - SAY"),
  43. (@ENTRY*100,9,18,0,0,0,100,1,4000,4000,0,0,1,7,0,0,0,0,0,0,0,0,0,0,0,0,0,"On Script - SAY"),
  44. (@ENTRY*100,9,19,0,0,0,100,1,4000,4000,0,0,1,8,0,0,0,0,0,0,0,0,0,0,0,0,0,"On Script - SAY"),
  45. (@ENTRY*100,9,20,0,0,0,100,1,1000,1000,0,0,33,22432,0,0,0,0,0,7,0,0,0,0,0,0,0,"On Script - Give credit.");
  46.  
  47. -- Texts
  48. DELETE FROM `creature_text` WHERE `entry` IN (@ENTRY, @COLONEL);
  49. INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
  50. (@ENTRY,0,0,"It is time. The rite of exorcism will now commence...",12,0,100,0,0,0,""),
  51. (@ENTRY,1,0,"Prepare yourself. Do not allow the ritual to be interrupted or we may loose our patient...Colonel Jules says: Keep away. The fool is mine.",12,0,100,0,0,0,""),
  52. (@ENTRY,2,0,"The power of light compells you! Back to your pit!",12,0,100,0,0,0,""),
  53. (@ENTRY,3,0,"The light is my guide... it is my sustenance!",12,0,100,0,0,0,""),
  54. (@ENTRY,4,0," I... must not... falter!",12,0,100,0,0,0,""),
  55. (@ENTRY,5,0,"In the name of the Light! It is Light that commands you! It is Light that flung you to the depths of darkness!",12,0,100,0,0,0,""),
  56. (@ENTRY,6,0,"Back you foul beings of darkness! You have no power here!",12,0,100,0,0,0,""),
  57. (@ENTRY,7,0,"Be cleansed with Light, human! Let not the demonic corruption overwhelm you.",12,0,100,0,0,0,""),
  58. (@ENTRY,8,0,"Back! I cast you back... corruptor of faith! Author of pain! Do not return, or suffer the same fate as you did here today!",12,0,100,0,0,0,""),
  59. (@COLONEL,0,0,"Keep away. The fool is mine.",12,0,100,0,0,0,""),
  60. (@COLONEL,1,0,"Give us time... Let the man die... I am no one... I am no one... Fear the anchorite... Fear the anchorite... Barada... Barada.",12,0,100,0,0,0,""),
  61. (@COLONEL,2,0,"This is fruitless, draenei! You and your little helper cannot wrest control of this pathetic human. He is mine!",12,0,100,0,0,0,""),
  62. (@COLONEL,3,0,"I will tear your soul into morsels and slow roast them over demon fire.",12,0,100,0,0,0,""),
  63. (@COLONEL,4,0,"This is fruitless, draenei! You and your little helper cannot wrest control of this pathetic human. He is mine!",12,0,100,0,0,0,""),
  64. (@COLONEL,5,0,"All is lost, Anchorite! Abandon what hope remains.",12,0,100,0,0,0,""),
  65. (@COLONEL,6,0,"I see your ancestors, Anchorite! They writhe and scream in the darkness... they are with us!",12,0,100,0,0,0,"");
  66.  
  67. -- Conditions for gossip
  68. DELETE FROM `conditions` WHERE `SourceGroup`=@GOSSIP;
  69. INSERT INTO `conditions` VALUES
  70. (15, @GOSSIP, 0, 0, 0, 9, 0, @QUEST, 0, 0, 0, 0, '', 'Only show gossip if player has quest'),
  71. (15, @GOSSIP, 0, 0, 0, 2, 0, @ITEM, 1, 0, 0, 0, '', 'Only show gossip if player has item');
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!