API tools faq
paste
Advertisement
gecko32

Argent Squire/Gruntling(no pony)

gecko32
Mar 10th, 2012
104
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 9.55 KB | None | 0 0
raw download clone embed print report
  1. -- --------------------------------------
  2. -- Code for  argent squire/gruntling working non pony bridle
  3. -- --------------------------------------
  4. SET @SQUIRE=33238;
  5. SET @GRUNT=33239;
  6. SET @GOSSIP=30000;
  7. -- Add gossip menu id for argent squire and gruntling and change npc flag
  8. UPDATE `creature_template` SET `gossip_menu_id`=@GOSSIP, `npcflag`=1,`AIName`='SmartAI' WHERE `entry`IN (@SQUIRE,@GRUNT);
  9. -- Add gosip for argent squire and gruntling text already in db
  10. DELETE FROM `gossip_menu` WHERE `entry`IN (@GOSSIP,@GOSSIP+1);
  11. INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES
  12. (@GOSSIP, 14324),
  13. (@GOSSIP+1, 14372);
  14. -- Add gosip menu options for argent squire and gruntling
  15. DELETE FROM `gossip_menu_option` WHERE `menu_id`IN (@GOSSIP,@GOSSIP+1);
  16. 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
  17. (@GOSSIP, 1, 0, 'Darnassus Champion\'s Pennant', 1, 1, 0, 0, 0, 0, ''),
  18. (@GOSSIP, 2, 0, 'Exodar Champion\'s Pennant', 1, 1, 0, 0, 0, 0, ''),
  19. (@GOSSIP, 3, 0, 'Gnomeeregan Champion\'s Pennant', 1, 1, 0, 0, 0, 0, ''),
  20. (@GOSSIP, 4, 0, 'Ironforge Champion\'s Pennant', 1, 1, 0, 0, 0, 0, ''),
  21. (@GOSSIP, 5, 0, 'Stormwind Champion\'s Pennant', 1, 1, 0, 0, 0, 0, ''),
  22. (@GOSSIP+1, 1, 0, 'Darkspear Champion\'s Pennant', 1, 1, 0, 0, 0, 0, ''),
  23. (@GOSSIP+1, 2, 0, 'Forsaken Champion\'s Pennant', 1, 1, 0, 0, 0, 0, ''),
  24. (@GOSSIP+1, 3, 0, 'Orgrimmar Champion\'s Pennant', 1, 1, 0, 0, 0, 0, ''),
  25. (@GOSSIP+1, 4, 0, 'Silvermoon Champion\'s Pennant', 1, 1, 0, 0, 0, 0, ''),
  26. (@GOSSIP+1, 5, 0, 'Thunder Bluff Champion\'s Pennant', 1, 1, 0, 0, 0, 0, '');
  27. -- Add SmartAI for argent squire and gruntling
  28. DELETE FROM `smart_scripts` WHERE `entryorguid` IN (@SQUIRE,@GRUNT);
  29. 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
  30. -- Argent Squire SAI
  31. (@SQUIRE, 0, 1, 2, 62, 0, 100, 0, @GOSSIP, 3, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Argent Squire - on select Darnassus Champion\'s- close gossip'),
  32. (@SQUIRE, 0, 2, 3, 61, 0, 100, 0, 0, 0, 0, 0, 11, 65659, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Squire - on link-  cast no pennant'),
  33. (@SQUIRE, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 63443, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Argent Squire - on link- cast Darnassus Champion\'s Pennant'),
  34. (@SQUIRE, 0, 4, 5, 62, 0, 100, 0, @GOSSIP, 4, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Argent Squire - on select Exodar Champion\'s- close gossip'),
  35. (@SQUIRE, 0, 5, 6, 61, 0, 100, 0, 0, 0, 0, 0, 11, 65659, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Squire - on link-  cast no pennant'),
  36. (@SQUIRE, 0, 6, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 63439, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Squire - on link- cast Exodar Champion\'s Pennant'),
  37. (@SQUIRE, 0, 7, 8, 62, 0, 100, 0, @GOSSIP, 5, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Argent Squire - on select Gnomeeregan Champion\'s- close gossip'),
  38. (@SQUIRE, 0, 8, 9, 61, 0, 100, 0, 0, 0, 0, 0, 11, 65659, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Squire - on link-  cast no pennant'),
  39. (@SQUIRE, 0, 9, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 63442, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Squire - on link- cast Gnomeeregan Champion\'s Pennant'),
  40. (@SQUIRE, 0, 10, 11, 62, 0, 100, 0, @GOSSIP, 6, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Argent Squire - on select Ironforge Champion\'s- close gossip'),
  41. (@SQUIRE, 0, 11, 12, 61, 0, 100, 0, 0, 0, 0, 0, 11, 65659, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Squire - on link-  cast no pennant'),
  42. (@SQUIRE, 0, 12, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 63440, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Squire - on link- cast Ironforge Champion\'s Pennant'),
  43. (@SQUIRE, 0, 13, 14, 62, 0, 100, 0, @GOSSIP, 7, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Argent Squire - on select Stormwind Champion\'s- close gossip'),
  44. (@SQUIRE, 0, 14, 15, 61, 0, 100, 0, 0, 0, 0, 0, 11, 65659, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Squire - on link-  cast no pennant'),
  45. (@SQUIRE, 0, 15, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 62727, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Squire - on link- cast Stormwind Champion\'s Pennant'),
  46. -- Argent Gruntling SAI
  47. (@GRUNT, 0, 1, 2, 62, 0, 100, 0, @GOSSIP+1, 3, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Argent Gruntling - on select Darkspear Champion\'s Pennant- close gossip'),
  48. (@GRUNT, 0, 2, 3, 61, 0, 100, 0, 0, 0, 0, 0, 11, 65659, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Gruntling - on link-  cast no pennant'),
  49. (@GRUNT, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 63446, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Argent Gruntling - on link- cast Darkspear Champion\'s Pennant'),
  50. (@GRUNT, 0, 4, 5, 62, 0, 100, 0, @GOSSIP+1, 4, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Argent Gruntling - on select Forsaken Champion\'s Pennant- close gossip'),
  51. (@GRUNT, 0, 5, 6, 61, 0, 100, 0, 0, 0, 0, 0, 11, 65659, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Gruntling - on link-  cast no pennant'),
  52. (@GRUNT, 0, 6, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 63441, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Gruntling - on link- cast Forsaken Champion\'s Pennant'),
  53. (@GRUNT, 0, 7, 8, 62, 0, 100, 0, @GOSSIP+1, 5, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Argent Gruntling - on select Orgrimmar Champion\'s Pennant- close gossip'),
  54. (@GRUNT, 0, 8, 9, 61, 0, 100, 0, 0, 0, 0, 0, 11, 65659, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Gruntling - on link-  cast no pennant'),
  55. (@GRUNT, 0, 9, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 63444, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Gruntling - on link- cast Orgrimmar Champion\'s Pennant'),
  56. (@GRUNT, 0, 10, 11, 62, 0, 100, 0, @GOSSIP+1, 6, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Argent Gruntling - on select Silvermoon Champion\'s Pennant- close gossip'),
  57. (@GRUNT, 0, 11, 12, 61, 0, 100, 0, 0, 0, 0, 0, 11, 65659, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Gruntling - on link-  cast no pennant'),
  58. (@GRUNT, 0, 12, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 63438, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Gruntling - on link- cast Silvermoon Champion\'s Pennant'),
  59. (@GRUNT, 0, 13, 14, 62, 0, 100, 0, @GOSSIP+1, 7, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Argent Gruntling - on select Thunder Bluff Champion\'s Pennant- close gossip'),
  60. (@GRUNT, 0, 14, 15, 61, 0, 100, 0, 0, 0, 0, 0, 11, 65659, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Gruntling - on link-  cast no pennant'),
  61. (@GRUNT, 0, 15, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 63445, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Gruntling - on link- cast Thunder Bluff Champion\'s Pennant');
  62. -- Add conditions for gossip options
  63. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup` IN (@GOSSIP,@GOSSIP+1);
  64. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  65. (15, @GOSSIP, 3, 0, 0, 17, 0, 2777, 0, 0, 0, 0, '', 'Argent squire show Darnassus Champion\'s Pennant if player has achievement Champion of Darnassus'),
  66. (15, @GOSSIP, 4, 0, 0, 17, 0, 2778, 0, 0, 0, 0, '', 'Argent squire show Exodar Champion\'s Pennant if player has achievement Champion of the Exodar'),
  67. (15, @GOSSIP, 5, 0, 0, 17, 0, 2779, 0, 0, 0, 0, '', 'Argent squire show Gnomeeregan Champion\'s Pennant if player has achievement Champion of Gnomeregan'),
  68. (15, @GOSSIP, 6, 0, 0, 17, 0, 2780, 0, 0, 0, 0, '', 'Argent squire show Ironforge Champion\'s Pennant if player has achievement Champion of Ironforge'),
  69. (15, @GOSSIP, 7, 0, 0, 17, 0, 2781, 0, 0, 0, 0, '', 'Argent squire show Stormwind Champion\'s Pennant if player has achievement Champion of Stormwind'),
  70. (15, @GOSSIP+1, 3, 0, 0, 17, 0, 2784, 0, 0, 0, 0, '', 'Argent Gruntling show Darkspear Champion\'s Pennant if player has achievement Champion of Sen\'jin'),
  71. (15, @GOSSIP+1, 4, 0, 0, 17, 0, 2787, 0, 0, 0, 0, '', 'Argent Gruntling show Forsaken Champion\'s Pennant if player has achievement Champion of the Undercity'),
  72. (15, @GOSSIP+1, 5, 0, 0, 17, 0, 2783, 0, 0, 0, 0, '', 'Argent Gruntling show Orgrimmar Champion\'s Pennant if player has achievement Champion of Orgrimmar'),
  73. (15, @GOSSIP+1, 6, 0, 0, 17, 0, 2785, 0, 0, 0, 0, '', 'Argent Gruntling show Silvermoon Champion\'s Pennant if player has achievement Champion of Silvermoon City'),
  74. (15, @GOSSIP+1, 7, 0, 0, 17, 0, 2786, 0, 0, 0, 0, '', 'Argent Gruntling show Thunder Bluff Champion\'s Pennant if player has achievement Champion of Thunder Bluff');
  75. -- no pennant spell script
  76. DELETE FROM `spell_scripts` WHERE `id`=65659;
  77. INSERT INTO `spell_scripts` (`id`, `effIndex`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES
  78. (65659, 0, 0, 14, 63443, 1, 0, 0, 0, 0, 0),
  79. (65659, 0, 0, 14, 63439, 1, 0, 0, 0, 0, 0),
  80. (65659, 0, 0, 14, 63442, 1, 0, 0, 0, 0, 0),
  81. (65659, 0, 0, 14, 62727, 1, 0, 0, 0, 0, 0),
  82. (65659, 0, 0, 14, 63444, 1, 0, 0, 0, 0, 0),
  83. (65659, 0, 0, 14, 63446, 1, 0, 0, 0, 0, 0),
  84. (65659, 0, 0, 14, 63438, 1, 0, 0, 0, 0, 0),
  85. (65659, 0, 0, 14, 63445, 1, 0, 0, 0, 0, 0),
  86. (65659, 0, 0, 14, 63441, 1, 0, 0, 0, 0, 0),
  87. (65659, 0, 0, 14, 63440, 1, 0, 0, 0, 0, 0);
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!