API tools faq
paste
Advertisement
gecko32

Argent Squire/Gruntling

gecko32
Mar 10th, 2012
146
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 21.62 KB | None | 0 0
raw download clone embed print report
  1. -- --------------------------------------
  2. -- Code for  argent squire/gruntling
  3. -- --------------------------------------
  4. -- Working
  5. -- -- Gossip text and options (maybe missing horde female)
  6. -- -- Gossip conditions (Achievement conditions)
  7. -- -- Bannners are working
  8. -- -- Bank & shop
  9. -- -- Casting of auras & despawning using SAI
  10. -- Not Working
  11. -- -- Mounting (spell to mount or creature unknow)(model id 2188 looks like mount)
  12. -- -- Conditions (creature having aura)
  13. -- -- No auras are saved for non-combat pets
  14. -- -- Mailbox option (?maybe invisible object spawn?)
  15. -- -- auras being recast each time you talk
  16. SET @SQUIRE=33238;
  17. SET @GRUNT=33239;
  18. SET @GOSSIP=30000;
  19. -- Add gossip menu id for argent squire and gruntling and change npc flag(1+128+131072)
  20. UPDATE `creature_template` SET `gossip_menu_id`=@GOSSIP, `npcflag`=131201,`AIName`='SmartAI' WHERE `entry`IN (@SQUIRE,@GRUNT);
  21. -- Add gosip for argent squire and gruntling text already in db
  22. DELETE FROM `gossip_menu` WHERE `entry`IN (@GOSSIP,@GOSSIP+1);
  23. INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES
  24. (@GOSSIP, 14324),
  25. (@GOSSIP+1, 14372);
  26. -- Add gosip menu options for argent squire and gruntling
  27. DELETE FROM `gossip_menu_option` WHERE `menu_id`IN (@GOSSIP,@GOSSIP+1);
  28. 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
  29. (@GOSSIP, 0, 6, 'Visit a bank', 9, 131072, 0, 0, 0, 0, ''),
  30. (@GOSSIP, 1, 1, 'Visit a trader', 3, 128, 0, 0, 0, 0, ''),
  31. (@GOSSIP, 2, 0, 'Visit a mailbox', 1, 1, 0, 0, 0, 0, ''),
  32. (@GOSSIP, 3, 0, 'Darnassus Champion\'s Pennant', 1, 1, 0, 0, 0, 0, ''),
  33. (@GOSSIP, 4, 0, 'Exodar Champion\'s Pennant', 1, 1, 0, 0, 0, 0, ''),
  34. (@GOSSIP, 5, 0, 'Gnomeeregan Champion\'s Pennant', 1, 1, 0, 0, 0, 0, ''),
  35. (@GOSSIP, 6, 0, 'Ironforge Champion\'s Pennant', 1, 1, 0, 0, 0, 0, ''),
  36. (@GOSSIP, 7, 0, 'Stormwind Champion\'s Pennant', 1, 1, 0, 0, 0, 0, ''),
  37. (@GOSSIP+1, 0, 6, 'Visit a bank', 9, 131072, 0, 0, 0, 0, ''),
  38. (@GOSSIP+1, 1, 1, 'Visit a trader', 3, 128, 0, 0, 0, 0, ''),
  39. (@GOSSIP+1, 2, 0, 'Visit a mailbox', 1, 1, 0, 0, 0, 0, ''),
  40. (@GOSSIP+1, 3, 0, 'Darkspear Champion\'s Pennant', 1, 1, 0, 0, 0, 0, ''),
  41. (@GOSSIP+1, 4, 0, 'Forsaken Champion\'s Pennant', 1, 1, 0, 0, 0, 0, ''),
  42. (@GOSSIP+1, 5, 0, 'Orgrimmar Champion\'s Pennant', 1, 1, 0, 0, 0, 0, ''),
  43. (@GOSSIP+1, 6, 0, 'Silvermoon Champion\'s Pennant', 1, 1, 0, 0, 0, 0, ''),
  44. (@GOSSIP+1, 7, 0, 'Thunder Bluff Champion\'s Pennant', 1, 1, 0, 0, 0, 0, '');
  45. -- Add SmartAI for argent squire and gruntling
  46. DELETE FROM `smart_scripts` WHERE `entryorguid` IN (@SQUIRE,@GRUNT);
  47. 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
  48. -- Argent Squire SAI
  49. (@SQUIRE, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 11, 67039, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Squire - on spawn- cast mount check'),
  50. (@SQUIRE, 0, 1, 2, 62, 0, 100, 0, @GOSSIP, 0, 0, 0, 11, 67368, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Squire - on select Visit a bank- cast Bank Errand'),
  51. (@SQUIRE, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Squire - on link- set phase 1'),
  52. (@SQUIRE, 0, 3, 4, 23, 1, 100, 1, 67368, 0, 2000, 2000, 11, 68852, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Squire - no bank errand aura- cast tired'),
  53. (@SQUIRE, 0, 4, 0, 61, 1, 100, 0, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Squire - on link - despawn'),
  54. (@SQUIRE, 0, 5, 6, 62, 0, 100, 0, @GOSSIP, 1, 0, 0, 11, 67377, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Squire - on select Visit a trader- cast Squire Shop'),
  55. (@SQUIRE, 0, 6, 0, 61, 0, 100, 0, 0, 0, 0, 0, 22, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Squire - on link- set phase 2'),
  56. (@SQUIRE, 0, 7, 8, 23, 2, 100, 1, 67377, 0, 2000, 2000, 11, 68852, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Squire - no squire shop aura- cast tired'),
  57. (@SQUIRE, 0, 8, 0, 61, 2, 100, 0, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Squire - on link - despawn'),
  58. (@SQUIRE, 0, 9, 10, 62, 0, 100, 0, @GOSSIP, 2, 0, 0, 11, 67376, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Squire - on select Visit a mailbox- cast Squire Postman'),
  59. (@SQUIRE, 0, 10, 0, 61, 0, 100, 0, 0, 0, 0, 0, 22, 4, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Squire - on link- set phase 4'),
  60. (@SQUIRE, 0, 11, 12, 23, 4, 100, 1, 67376, 0, 2000, 2000, 11, 68852, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Squire - no Squire Postman- cast tired'),
  61. (@SQUIRE, 0, 12, 0, 61, 4, 100, 0, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Squire - on link - despawn'),
  62. (@SQUIRE, 0, 13, 14, 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'),
  63. (@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'),
  64. (@SQUIRE, 0, 15, 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'),
  65. (@SQUIRE, 0, 16, 17, 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'),
  66. (@SQUIRE, 0, 17, 18, 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'),
  67. (@SQUIRE, 0, 18, 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'),
  68. (@SQUIRE, 0, 19, 20, 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'),
  69. (@SQUIRE, 0, 20, 21, 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'),
  70. (@SQUIRE, 0, 21, 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'),
  71. (@SQUIRE, 0, 22, 23, 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'),
  72. (@SQUIRE, 0, 23, 24, 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'),
  73. (@SQUIRE, 0, 24, 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'),
  74. (@SQUIRE, 0, 25, 26, 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'),
  75. (@SQUIRE, 0, 26, 27, 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'),
  76. (@SQUIRE, 0, 27, 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'),
  77. -- Argent Gruntling SAI
  78. (@GRUNT, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 11, 67039, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Gruntling - on spawn- cast mount check'),
  79. (@GRUNT, 0, 1, 2, 62, 0, 100, 0, @GOSSIP+1, 0, 0, 0, 11, 68849, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Gruntling - on select Visit a bank- cast Bank Errand'),
  80. (@GRUNT, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Gruntling - on link- set phase 1'),
  81. (@GRUNT, 0, 3, 4, 23, 1, 100, 1, 68849, 0, 2000, 2000, 11, 67401, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Gruntling - no bank errand aura- cast tired'),
  82. (@GRUNT, 0, 4, 0, 61, 1, 100, 0, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Gruntling - on link - despawn'),
  83. (@GRUNT, 0, 5, 0, 62, 0, 100, 0, @GOSSIP+1, 1, 0, 0, 11, 68851, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Gruntling - on select Visit a trader- cast Gruntling Shop'),
  84. (@GRUNT, 0, 6, 0, 61, 0, 100, 0, 0, 0, 0, 0, 22, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Gruntling - on link- set phase 2'),
  85. (@GRUNT, 0, 7, 8, 23, 2, 100, 1, 68851, 0, 2000, 2000, 11, 67401, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Gruntling - no Gruntling shop aura- cast tired'),
  86. (@GRUNT, 0, 8, 0, 61, 2, 100, 0, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Gruntling - on link - despawn'),
  87. (@GRUNT, 0, 9, 0, 62, 0, 100, 0, @GOSSIP+1, 2, 0, 0, 11, 68850, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Gruntling - on select Visit a mailbox- cast Gruntling Postman'),
  88. (@GRUNT, 0, 10, 0, 61, 0, 100, 0, 0, 0, 0, 0, 22, 4, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Gruntling - on link- set phase 4'),
  89. (@GRUNT, 0, 11, 12, 23, 4, 100, 1, 68850, 0, 2000, 2000, 11, 67401, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Gruntling - no Gruntling Postman- cast tired'),
  90. (@GRUNT, 0, 12, 0, 61, 4, 100, 0, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Gruntling - on link - despawn'),
  91. (@GRUNT, 0, 13, 14, 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'),
  92. (@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'),
  93. (@GRUNT, 0, 15, 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'),
  94. (@GRUNT, 0, 16, 17, 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'),
  95. (@GRUNT, 0, 17, 18, 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'),
  96. (@GRUNT, 0, 18, 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'),
  97. (@GRUNT, 0, 19, 20, 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'),
  98. (@GRUNT, 0, 20, 21, 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'),
  99. (@GRUNT, 0, 21, 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'),
  100. (@GRUNT, 0, 22, 23, 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'),
  101. (@GRUNT, 0, 23, 24, 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'),
  102. (@GRUNT, 0, 24, 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'),
  103. (@GRUNT, 0, 25, 26, 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'),
  104. (@GRUNT, 0, 26, 27, 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'),
  105. (@GRUNT, 0, 27, 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'),
  106. -- Add conditions for gossip options
  107. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup` IN (@GOSSIP,@GOSSIP+1);
  108. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  109. (15, @GOSSIP, 0, 0, 1, 17, 0, 3736, 0, 0, 0, 0, '', 'Argent squire show Visit a bank if player has achievement pony up'),
  110. (15, @GOSSIP, 0, 0, 1, 1, 1, 68852, 0, 0, 1, 0, '', 'Argent squire show Visit a bank no tired aura'),
  111. (15, @GOSSIP, 0, 0, 1, 1, 1, 67377, 0, 0, 1, 0, '', 'Argent squire show Visit a bank no squire shop aura'),
  112. (15, @GOSSIP, 0, 0, 1, 1, 1, 67376, 0, 0, 1, 0, '', 'Argent squire show Visit a bank no postman aura'),
  113. (15, @GOSSIP, 1, 0, 2, 17, 0, 3736, 0, 0, 0, 0, '', 'Argent squire show Visit a trader if player has achievement pony up'),
  114. (15, @GOSSIP, 1, 0, 2, 1, 1, 68852, 0, 0, 1, 0, '', 'Argent squire show Visit a trader no tired aura'),
  115. (15, @GOSSIP, 1, 0, 2, 1, 1, 67368, 0, 0, 1, 0, '', 'Argent squire show Visit a trader no bank errand aura'),
  116. (15, @GOSSIP, 1, 0, 2, 1, 1, 67376, 0, 0, 1, 0, '', 'Argent squire show Visit a trader no postman aura'),
  117. (15, @GOSSIP, 2, 0, 3, 17, 0, 3736, 0, 0, 0, 0, '', 'Argent squire show Visit a mailbox if player has achievement pony up'),
  118. (15, @GOSSIP, 2, 0, 3, 1, 1, 68852, 0, 0, 1, 0, '', 'Argent squire show Visit a mailbox no tired aura'),
  119. (15, @GOSSIP, 2, 0, 3, 1, 1, 67368, 0, 0, 1, 0, '', 'Argent squire show Visit a mailbox no bank errand aura'),
  120. (15, @GOSSIP, 2, 0, 3, 1, 1, 67377, 0, 0, 1, 0, '', 'Argent squire show Visit a mailbox no squire shop aura'),
  121. (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'),
  122. (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'),
  123. (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'),
  124. (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'),
  125. (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'),
  126. (15, @GOSSIP+1, 0, 0, 1, 17, 0, 3736, 0, 0, 0, 0, '', 'Argent Gruntling show Visit a bank if player has achievement pony up'),
  127. (15, @GOSSIP+1, 0, 0, 1, 1, 1, 67401, 0, 0, 1, 0, '', 'Argent Gruntling show Visit a bank no tired aura'),
  128. (15, @GOSSIP+1, 0, 0, 1, 1, 1, 68851, 0, 0, 1, 0, '', 'Argent Gruntling show Visit a bank no Gruntling Shop aura'),
  129. (15, @GOSSIP+1, 0, 0, 1, 1, 1, 68850, 0, 0, 1, 0, '', 'Argent Gruntling show Visit a bank no Gruntling Postman aura'),
  130. (15, @GOSSIP+1, 1, 0, 2, 17, 0, 3736, 0, 0, 0, 0, '', 'Argent Gruntling show Visit a trader if player has achievement pony up'),
  131. (15, @GOSSIP+1, 1, 0, 2, 1, 1, 67401, 0, 0, 1, 0, '', 'Argent Gruntling show Visit a trader no tired aura'),
  132. (15, @GOSSIP+1, 1, 0, 2, 1, 1, 68849, 0, 0, 1, 0, '', 'Argent Gruntling show Visit a trader no bank errand aura'),
  133. (15, @GOSSIP+1, 1, 0, 2, 1, 1, 68850, 0, 0, 1, 0, '', 'Argent Gruntling show Visit a trader no Gruntling Postman aura'),
  134. (15, @GOSSIP+1, 2, 0, 3, 17, 0, 3736, 0, 0, 0, 0, '', 'Argent Gruntling show Visit a mailbox if player has achievement pony up'),
  135. (15, @GOSSIP+1, 2, 0, 3, 1, 1, 67401, 0, 0, 1, 0, '', 'Argent Gruntling show Visit a trader no tired aura'),
  136. (15, @GOSSIP+1, 2, 0, 3, 1, 1, 68849, 0, 0, 1, 0, '', 'Argent Gruntling show Visit a trader no bank errand aura'),
  137. (15, @GOSSIP+1, 2, 0, 3, 1, 1, 68851, 0, 0, 1, 0, '', 'Argent Gruntling show Visit a trader no Gruntling Shop aura'),
  138. (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'),
  139. (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'),
  140. (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'),
  141. (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'),
  142. (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');
  143. -- Add vendor items for argent squire and gruntling
  144. DELETE FROM `npc_vendor` WHERE `entry` IN (@SQUIRE,@GRUNT);
  145. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES
  146. (@SQUIRE, 0, 33449, 0, 0, 0),-- Crusty Flatbread
  147. (@SQUIRE, 0, 33443, 0, 0, 0),-- Sour Goat Cheese
  148. (@SQUIRE, 0, 33451, 0, 0, 0),-- Fillet of Icefin
  149. (@SQUIRE, 0, 35949, 0, 0, 0),-- Tundra Berries
  150. (@SQUIRE, 0, 33452, 0, 0, 0),-- Honey-Spiced Lichen
  151. (@SQUIRE, 0, 33454, 0, 0, 0),-- Salted Venison
  152. (@SQUIRE, 0, 35950, 0, 0, 0),-- Sweet Potato Bread
  153. (@SQUIRE, 0, 35952, 0, 0, 0),-- Briny Hardcheese
  154. (@SQUIRE, 0, 35951, 0, 0, 0),-- Poached Emperor Salmon
  155. (@SQUIRE, 0, 35948, 0, 0, 0),-- Savory Snowplum
  156. (@SQUIRE, 0, 35947, 0, 0, 0),-- Sparkling Frostcap
  157. (@SQUIRE, 0, 35953, 0, 0, 0),-- Mead Basted Caribou
  158. (@SQUIRE, 0, 17034, 0, 0, 0),-- Maple Seed
  159. (@SQUIRE, 0, 17035, 0, 0, 0),-- Stranglethorn Seed
  160. (@SQUIRE, 0, 17036, 0, 0, 0),-- Ashwood Seed
  161. (@SQUIRE, 0, 17037, 0, 0, 0),-- Hornbeam Seed
  162. (@SQUIRE, 0, 17038, 0, 0, 0),-- Ironwood Seed
  163. (@SQUIRE, 0, 22147, 0, 0, 0),-- Flintwood Seed
  164. (@SQUIRE, 0, 17031, 0, 0, 0),-- Rune of Teleportation
  165. (@SQUIRE, 0, 17032, 0, 0, 0),-- Rune of Portals
  166. (@SQUIRE, 0, 17020, 0, 0, 0),-- Arcane Powder
  167. (@SQUIRE, 0, 17030, 0, 0, 0),-- Ankh
  168. (@SQUIRE, 0, 17033, 0, 0, 0),-- Symbol of Divinity
  169. (@SQUIRE, 0, 17028, 0, 0, 0),-- Holy Candle
  170. (@SQUIRE, 0, 17029, 0, 0, 0),-- Sacred Candle
  171. (@SQUIRE, 0, 17021, 0, 0, 0),-- Wild Berries
  172. (@SQUIRE, 0, 17026, 0, 0, 0),-- Wild Thornroot
  173. (@SQUIRE, 0, 22148, 0, 0, 0),-- Wild Quillvine
  174. (@SQUIRE, 0, 5565, 0, 0, 0),-- Infernal Stone
  175. (@SQUIRE, 0, 16583, 0, 0, 0),-- Demonic Figurine
  176. (@SQUIRE, 0, 21177, 0, 0, 0),-- Symbol of Kings
  177. (@SQUIRE, 0, 37201, 0, 0, 0),-- Corpse Dust
  178. (@SQUIRE, 0, 44614, 0, 0, 0),-- Starleaf Seed
  179. (@SQUIRE, 0, 44615, 0, 0, 0),-- Devout Candle
  180. (@SQUIRE, 0, 44605, 0, 0, 0),-- Wild Spineleaf
  181. (@SQUIRE, 0, 28056, 0, 0, 0),-- Blackflight Arrow
  182. (@SQUIRE, 0, 41586, 0, 0, 0),-- Terrorshaft Arrow
  183. (@SQUIRE, 0, 28061, 0, 0, 0),-- Ironbite Shells
  184. (@SQUIRE, 0, 41584, 0, 0, 0),-- Frostbite Shells
  185. (@SQUIRE, 0, 29014, 0, 0, 0),-- Blacksteel Throwing Dagger
  186. (@SQUIRE, 0, 29013, 0, 0, 0),-- Jagged Throwing Axe
  187. (@SQUIRE, 0, 8928, 0, 0, 0),-- Instant Poison VI
  188. (@SQUIRE, 0, 43230, 0, 0, 0),-- Instant Poison VIII
  189. (@SQUIRE, 0, 22053, 0, 0, 0),-- Deadly Poison VI
  190. (@SQUIRE, 0, 43232, 0, 0, 0),-- Deadly Poison VIII
  191. (@SQUIRE, 0, 43234, 0, 0, 0),-- Wound Poison VI
  192. (@SQUIRE, 0, 21835, 0, 0, 0),-- Anesthetic Poison
  193. (@GRUNT, 0, 33449, 0, 0, 0),-- Crusty Flatbread
  194. (@GRUNT, 0, 33443, 0, 0, 0),-- Sour Goat Cheese
  195. (@GRUNT, 0, 33451, 0, 0, 0),-- Fillet of Icefin
  196. (@GRUNT, 0, 35949, 0, 0, 0),-- Tundra Berries
  197. (@GRUNT, 0, 33452, 0, 0, 0),-- Honey-Spiced Lichen
  198. (@GRUNT, 0, 33454, 0, 0, 0),-- Salted Venison
  199. (@GRUNT, 0, 35950, 0, 0, 0),-- Sweet Potato Bread
  200. (@GRUNT, 0, 35952, 0, 0, 0),-- Briny Hardcheese
  201. (@GRUNT, 0, 35951, 0, 0, 0),-- Poached Emperor Salmon
  202. (@GRUNT, 0, 35948, 0, 0, 0),-- Savory Snowplum
  203. (@GRUNT, 0, 35947, 0, 0, 0),-- Sparkling Frostcap
  204. (@GRUNT, 0, 35953, 0, 0, 0),-- Mead Basted Caribou
  205. (@GRUNT, 0, 17034, 0, 0, 0),-- Maple Seed
  206. (@GRUNT, 0, 17035, 0, 0, 0),-- Stranglethorn Seed
  207. (@GRUNT, 0, 17036, 0, 0, 0),-- Ashwood Seed
  208. (@GRUNT, 0, 17037, 0, 0, 0),-- Hornbeam Seed
  209. (@GRUNT, 0, 17038, 0, 0, 0),-- Ironwood Seed
  210. (@GRUNT, 0, 22147, 0, 0, 0),-- Flintwood Seed
  211. (@GRUNT, 0, 17031, 0, 0, 0),-- Rune of Teleportation
  212. (@GRUNT, 0, 17032, 0, 0, 0),-- Rune of Portals
  213. (@GRUNT, 0, 17020, 0, 0, 0),-- Arcane Powder
  214. (@GRUNT, 0, 17030, 0, 0, 0),-- Ankh
  215. (@GRUNT, 0, 17033, 0, 0, 0),-- Symbol of Divinity
  216. (@GRUNT, 0, 17028, 0, 0, 0),-- Holy Candle
  217. (@GRUNT, 0, 17029, 0, 0, 0),-- Sacred Candle
  218. (@GRUNT, 0, 17021, 0, 0, 0),-- Wild Berries
  219. (@GRUNT, 0, 17026, 0, 0, 0),-- Wild Thornroot
  220. (@GRUNT, 0, 22148, 0, 0, 0),-- Wild Quillvine
  221. (@GRUNT, 0, 5565, 0, 0, 0),-- Infernal Stone
  222. (@GRUNT, 0, 16583, 0, 0, 0),-- Demonic Figurine
  223. (@GRUNT, 0, 21177, 0, 0, 0),-- Symbol of Kings
  224. (@GRUNT, 0, 37201, 0, 0, 0),-- Corpse Dust
  225. (@GRUNT, 0, 44614, 0, 0, 0),-- Starleaf Seed
  226. (@GRUNT, 0, 44615, 0, 0, 0),-- Devout Candle
  227. (@GRUNT, 0, 44605, 0, 0, 0),-- Wild Spineleaf
  228. (@GRUNT, 0, 28056, 0, 0, 0),-- Blackflight Arrow
  229. (@GRUNT, 0, 41586, 0, 0, 0),-- Terrorshaft Arrow
  230. (@GRUNT, 0, 28061, 0, 0, 0),-- Ironbite Shells
  231. (@GRUNT, 0, 41584, 0, 0, 0),-- Frostbite Shells
  232. (@GRUNT, 0, 29014, 0, 0, 0),-- Blacksteel Throwing Dagger
  233. (@GRUNT, 0, 29013, 0, 0, 0),-- Jagged Throwing Axe
  234. (@GRUNT, 0, 8928, 0, 0, 0),-- Instant Poison VI
  235. (@GRUNT, 0, 43230, 0, 0, 0),-- Instant Poison VIII
  236. (@GRUNT, 0, 22053, 0, 0, 0),-- Deadly Poison VI
  237. (@GRUNT, 0, 43232, 0, 0, 0),-- Deadly Poison VIII
  238. (@GRUNT, 0, 43234, 0, 0, 0),-- Wound Poison VI
  239. (@GRUNT, 0, 21835, 0, 0, 0);-- Anesthetic Poison
  240. -- no pennant spell script
  241. DELETE FROM `spell_scripts` WHERE `id`=65659;
  242. INSERT INTO `spell_scripts` (`id`, `effIndex`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES
  243. (65659, 0, 0, 14, 63443, 1, 0, 0, 0, 0, 0),
  244. (65659, 0, 0, 14, 63439, 1, 0, 0, 0, 0, 0),
  245. (65659, 0, 0, 14, 63442, 1, 0, 0, 0, 0, 0),
  246. (65659, 0, 0, 14, 62727, 1, 0, 0, 0, 0, 0),
  247. (65659, 0, 0, 14, 63444, 1, 0, 0, 0, 0, 0),
  248. (65659, 0, 0, 14, 63446, 1, 0, 0, 0, 0, 0),
  249. (65659, 0, 0, 14, 63438, 1, 0, 0, 0, 0, 0),
  250. (65659, 0, 0, 14, 63445, 1, 0, 0, 0, 0, 0),
  251. (65659, 0, 0, 14, 63441, 1, 0, 0, 0, 0, 0),
  252. (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!