API tools faq
paste
Advertisement
gecko32

Hallow's End Treats for Jesper/spoops 8311/8312

gecko32
Oct 17th, 2011
313
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 10.22 KB | None | 0 0
raw download clone embed print report
  1. -- Flexing for Nougat (Alliance)
  2. SET @INNKEEPER=6740;
  3. SET @QUEST=8356;
  4. DELETE FROM `smart_scripts` WHERE `entryorguid`=@INNKEEPER AND `id`=2;
  5. 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
  6. (@INNKEEPER, 0, 2, 0, 22, 0, 100, 0, 41, 0, 0, 0, 33, @INNKEEPER, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Innkeeper Allison - on /flex credit for quest');
  7. DELETE FROM `conditions` WHERE `SourceEntry`=@QUEST;
  8. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  9. (19, 0, @QUEST, 0, 12, 12, 0, 0, 0, '', NULL);
  10. -- Chicken Clucking for a Mint (Alliance)
  11. SET @INNKEEPER=5111;
  12. SET @QUEST=8353;
  13. DELETE FROM `smart_scripts` WHERE `entryorguid`=@INNKEEPER AND `id`=2;
  14. 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
  15. (@INNKEEPER, 0, 2, 0, 22, 0, 100, 0, 22, 0, 0, 0, 33, @INNKEEPER, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Innkeeper Firebrew - on /chicken credit for quest');
  16. DELETE FROM `conditions` WHERE `SourceEntry`=@QUEST;
  17. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  18. (19, 0, @QUEST, 0, 12, 12, 0, 0, 0, '', NULL);
  19. -- Dancing for Marzipan (Alliance)
  20. SET @INNKEEPER=6735;
  21. SET @QUEST=8357;
  22. DELETE FROM `smart_scripts` WHERE `entryorguid`=@INNKEEPER AND `id`=2;
  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. (@INNKEEPER, 0, 2, 0, 22, 0, 100, 0, 34, 0, 0, 0, 33, @INNKEEPER, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Innkeeper Saelienne - on /dance credit for quest');
  25. DELETE FROM `conditions` WHERE `SourceEntry`=@QUEST;
  26. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  27. (19, 0, @QUEST, 0, 12, 12, 0, 0, 0, '', NULL);
  28. -- Incoming Gumdrop (Alliance)
  29. SET @INNKEEPER=6826;
  30. SET @QUEST=8355;
  31. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@INNKEEPER;
  32. DELETE FROM `smart_scripts` WHERE `entryorguid`=@INNKEEPER;
  33. 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
  34. (@INNKEEPER, 0, 0, 0, 22, 0, 100, 0, 264, 0, 0, 0, 33, @INNKEEPER, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Talvash del Kissel - on /train credit for quest');
  35. DELETE FROM `conditions` WHERE `SourceEntry`=@QUEST;
  36. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  37. (19, 0, @QUEST, 0, 12, 12, 0, 0, 0, '', NULL);
  38. -- Flexing for Nougat (Horde)
  39. SET @INNKEEPER=6929;
  40. SET @QUEST=8359;
  41. DELETE FROM `smart_scripts` WHERE `entryorguid`=@INNKEEPER AND `id`=2;
  42. 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
  43. (@INNKEEPER, 0, 2, 0, 22, 0, 100, 0, 41, 0, 0, 0, 33, @INNKEEPER, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Innkeeper Gryshka - on /flex credit for quest');
  44. DELETE FROM `conditions` WHERE `SourceEntry`=@QUEST;
  45. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  46. (19, 0, @QUEST, 0, 12, 12, 0, 0, 0, '', NULL);
  47. -- Chicken Clucking for a Mint (Horde)
  48. SET @INNKEEPER=6741;
  49. SET @QUEST=8354;
  50. -- remove special flag changed from 2 to 0
  51. UPDATE `quest_template` SET `SpecialFlags`=0 WHERE `entry`=8354 LIMIT 1;
  52. DELETE FROM `smart_scripts` WHERE `entryorguid`=@INNKEEPER AND `id`=2;
  53. DELETE FROM `smart_scripts` WHERE `entryorguid`=@INNKEEPER AND `id`=3;
  54. 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
  55. (@INNKEEPER, 0, 2, 3, 22, 0, 100, 0, 22, 0, 0, 0, 33, @INNKEEPER, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Innkeeper Norman - on /chicken credit for quest'),
  56. (@INNKEEPER, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 15, @QUEST, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Innkeeper Norman - on /chicken credit exploreded for quest');
  57. DELETE FROM `conditions` WHERE `SourceEntry`=@QUEST;
  58. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  59. (19, 0, @QUEST, 0, 12, 12, 0, 0, 0, '', NULL);
  60. -- Dancing for Marzipan (Horde)
  61. SET @INNKEEPER=6746;
  62. SET @QUEST=8360;
  63. SET @GOSSIP=21215;
  64. UPDATE `creature_template` SET `AIName`='SmartAI', `ScriptName`='' WHERE `entry`=@INNKEEPER;
  65. -- Add trick or treat SAI since the .cpp script was removed
  66. DELETE FROM `smart_scripts` WHERE `entryorguid`=@INNKEEPER;
  67. 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
  68. (@INNKEEPER, 0, 0, 1, 62, 0, 100, 0, @GOSSIP, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Innkeeper Pala - On gossip option 0 select - Close gossip'),
  69. (@INNKEEPER, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 85, 24751, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Innkeeper Pala - On gossip option 0 select - Player cast Trick or Treat on self'),
  70. (@INNKEEPER, 0, 2, 0, 22, 0, 100, 0, 34, 0, 0, 0, 33, @INNKEEPER, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Innkeeper Pala - on /dance credit for quest');
  71. -- Add gossip menu option for trick or treat
  72. DELETE FROM `gossip_menu_option` WHERE `menu_id`=@GOSSIP;
  73. INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`) VALUES
  74. (@GOSSIP, 1, 5, 'Make this inn your home.', 8, 65536, 0, 0, 0, 0, ''),
  75. (@GOSSIP, 2, 1, 'I want to browse your goods', 3, 128, 0, 0, 0, 0, ''),
  76. (@GOSSIP, 0, 0, 'Trick or Treat!', 1, 1, 0, 0, 0, 0, '');
  77. -- Add conditions must be hallows end for Dancing for Marzipan quest and trick or treat option
  78. DELETE FROM `conditions` WHERE `SourceEntry`=@QUEST;
  79. DELETE FROM `conditions` WHERE `SourceGroup`=@GOSSIP;
  80. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  81. (19, 0, @QUEST, 0, 12, 12, 0, 0, 0, '', NULL),
  82. (15, @GOSSIP, 0, 0, 12, 12, 0, 0, 0, '', NULL),
  83. (15, @GOSSIP, 0, 0, 11, 24755, 0, 0, 0, '', NULL);
  84. -- Incoming Gumdrop (Horde)
  85. SET @INNKEEPER=11814;
  86. SET @QUEST=8358;
  87. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@INNKEEPER;
  88. DELETE FROM `smart_scripts` WHERE `entryorguid`=@INNKEEPER;
  89. 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
  90. (@INNKEEPER, 0, 0, 0, 22, 0, 100, 0, 264, 0, 0, 0, 33, @INNKEEPER, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Kali Remik - on /train credit for quest');
  91. DELETE FROM `conditions` WHERE `SourceEntry`=@QUEST;
  92. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  93. (19, 0, @QUEST, 0, 12, 12, 0, 0, 0, '', NULL);
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!