daily pastebin goal
16%
SHARE
TWEET

Blacksmith

Valhrona Mar 13th, 2018 65 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -- Blacksmithing
  2. SET @CGUID = 20801300;
  3. SET @GGUID = 20801300;
  4.  
  5. -- Questchain
  6. UPDATE `quest_template_addon` SET `PrevQuestId`='', `NextQuestId`='39681', `ExclusiveGroup`='' WHERE `ID`='38499';
  7. UPDATE `quest_template_addon` SET `PrevQuestId`='38499', `NextQuestId`='38502', `ExclusiveGroup`='' WHERE `ID`='39681';
  8. UPDATE `quest_template_addon` SET `PrevQuestId`='39681', `NextQuestId`='', `ExclusiveGroup`='-38502' WHERE `ID`='38502';
  9. UPDATE `quest_template_addon` SET `PrevQuestId`='39681', `NextQuestId`='', `ExclusiveGroup`='-38502' WHERE `ID`='38501';
  10. UPDATE `quest_template_addon` SET `PrevQuestId`='38502', `NextQuestId`='38506', `ExclusiveGroup`='' WHERE `ID`='38505';
  11. UPDATE `quest_template_addon` SET `PrevQuestId`='38505', `NextQuestId`='38507', `ExclusiveGroup`='' WHERE `ID`='38506';
  12. UPDATE `quest_template_addon` SET `PrevQuestId`='38506', `NextQuestId`='38515', `ExclusiveGroup`='' WHERE `ID`='38507';
  13. UPDATE `quest_template_addon` SET `PrevQuestId`='38507', `NextQuestId`='', `ExclusiveGroup`='-38500' WHERE `ID`='38515';
  14. UPDATE `quest_template_addon` SET `PrevQuestId`='38507', `NextQuestId`='', `ExclusiveGroup`='-38500' WHERE `ID`='38500';
  15. UPDATE `quest_template_addon` SET `PrevQuestId`='38500', `NextQuestId`='38513', `ExclusiveGroup`='' WHERE `ID`='38563';
  16. UPDATE `quest_template_addon` SET `PrevQuestId`='38563', `NextQuestId`='38514', `ExclusiveGroup`='' WHERE `ID`='38513';
  17. UPDATE `quest_template_addon` SET `PrevQuestId`='38513', `NextQuestId`='39699', `ExclusiveGroup`='' WHERE `ID`='38514';
  18. UPDATE `quest_template_addon` SET `PrevQuestId`='38514', `NextQuestId`='', `ExclusiveGroup`='-38519' WHERE `ID`='39699';
  19. UPDATE `quest_template_addon` SET `PrevQuestId`='38514', `NextQuestId`='', `ExclusiveGroup`='-38519' WHERE `ID`='38519';
  20. UPDATE `quest_template_addon` SET `PrevQuestId`='38519', `NextQuestId`='38522', `ExclusiveGroup`='' WHERE `ID`='38518';
  21. UPDATE `quest_template_addon` SET `PrevQuestId`='38518', `NextQuestId`='38523', `ExclusiveGroup`='' WHERE `ID`='38522';
  22. UPDATE `quest_template_addon` SET `PrevQuestId`='38522', `NextQuestId`='', `ExclusiveGroup`='' WHERE `ID`='38523';
  23. UPDATE `quest_template_addon` SET `PrevQuestId`='38523', `NextQuestId`='39680', `ExclusiveGroup`='' WHERE `ID`='39702';
  24. UPDATE `quest_template_addon` SET `PrevQuestId`='39702', `NextQuestId`='', `ExclusiveGroup`='-39680' WHERE `ID`='39680';
  25. UPDATE `quest_template_addon` SET `PrevQuestId`='39702', `NextQuestId`='', `ExclusiveGroup`='-39680' WHERE `ID`='39726';
  26. UPDATE `quest_template_addon` SET `PrevQuestId`='39680', `NextQuestId`='38564', `ExclusiveGroup`='' WHERE `ID`='39729';
  27. UPDATE `quest_template_addon` SET `PrevQuestId`='39729', `NextQuestId`='44449', `ExclusiveGroup`='' WHERE `ID`='38564';
  28. UPDATE `quest_template_addon` SET `PrevQuestId`='38564', `NextQuestId`='38524', `ExclusiveGroup`='' WHERE `ID`='44449';
  29. UPDATE `quest_template_addon` SET `PrevQuestId`='44449', `NextQuestId`='38525', `ExclusiveGroup`='' WHERE `ID`='38524';
  30. UPDATE `quest_template_addon` SET `PrevQuestId`='38524', `NextQuestId`='38526', `ExclusiveGroup`='' WHERE `ID`='38525';
  31. UPDATE `quest_template_addon` SET `PrevQuestId`='38525', `NextQuestId`='38527', `ExclusiveGroup`='' WHERE `ID`='38526';
  32. UPDATE `quest_template_addon` SET `PrevQuestId`='38526', `NextQuestId`='38528', `ExclusiveGroup`='' WHERE `ID`='38527';
  33. UPDATE `quest_template_addon` SET `PrevQuestId`='38527', `NextQuestId`='38530', `ExclusiveGroup`='' WHERE `ID`='38528';
  34. UPDATE `quest_template_addon` SET `PrevQuestId`='38528', `NextQuestId`='38531', `ExclusiveGroup`='' WHERE `ID`='38530';
  35. UPDATE `quest_template_addon` SET `PrevQuestId`='38530', `NextQuestId`='', `ExclusiveGroup`='-38531' WHERE `ID`='38531';
  36. UPDATE `quest_template_addon` SET `PrevQuestId`='38530', `NextQuestId`='', `ExclusiveGroup`='-38531' WHERE `ID`='38532';
  37. UPDATE `quest_template_addon` SET `PrevQuestId`='38531', `NextQuestId`='38833', `ExclusiveGroup`='' WHERE `ID`='38559';
  38. UPDATE `quest_template_addon` SET `PrevQuestId`='38559', `NextQuestId`='38533', `ExclusiveGroup`='' WHERE `ID`='38833';
  39. UPDATE `quest_template_addon` SET `PrevQuestId`='38833', `NextQuestId`='', `ExclusiveGroup`='' WHERE `ID`='38533';
  40.  
  41. -- Spawn missing creature
  42. UPDATE `creature` SET `PhaseId`=3200 WHERE `id`=92183;
  43. UPDATE `creature` SET `PhaseId`=3204 WHERE `id`=92438;
  44. DELETE FROM `creature` WHERE `id`=97261;
  45. DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+01 AND @CGUID+16;
  46. INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES
  47. (@CGUID+01, 97261, 1220, 0, 0, 3, 3201, 0, 0, 0, -740.861023, 4509.919922, 731.080994, 5.534260, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 25996),
  48. (@CGUID+02, 92183, 1220, 0, 0, 3, 3202, 0, 0, 0, -740.861023, 4509.919922, 731.080994, 5.534260, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 25996),
  49. (@CGUID+03, 96763, 1220, 0, 0, 3, 0, 0, 0, 0, 2954.992920, 7405.303711, 65.204597, 3.939429, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 25996),
  50. (@CGUID+04, 92438, 1220, 0, 0, 3, 3203, 0, 0, 0,  -748.458557, 4506.065918, 730.997986, 5.114434, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 25996),
  51. (@CGUID+05, 92438, 1220, 0, 0, 3, 3205, 0, 0, 0,   -745.721008, 4459.109863, 733.934998, 4.677490, 7200, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, '', 25996),
  52. (@CGUID+06, 92438, 1220, 0, 0, 3, 3206, 0, 0, 0,   -745.721008, 4459.109863, 733.934998, 4.677490, 7200, 0, 0, 0, 0, 0, 16777216, 0, 0, 0, 0, '', 25996);
  53.  
  54. -- Spawn missing gameobject
  55. DELETE FROM `gameobject` WHERE `guid` BETWEEN @GGUID+01 AND @GGUID+19;
  56. INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `isActive`, `ScriptName`, `VerifiedBuild`) VALUES
  57. (@GGUID+1, 267019, 1220, 0, 0, 1, 0, 0, 2981.59, 3768.4, 1349.34, 4.65384, -0, -0, -0.727502, 0.686106, 300, 255, 1, 0, '', 0),
  58. (@GGUID+2, 241510, 1220, 0, 0, 1, 0, 0, -747.525, 4505.13, 731.692, 2.01042, -0, -0, -0.844274, -0.535911, 300, 255, 1, 0, '', 0),
  59. (@GGUID+3, 241691, 1220, 0, 0, 1, 0, 0, 1470.03, 4999.18, 183.749, 4.93248, -0, -0, -0.625172, 0.780487, 300, 255, 1, 0, '', 0),
  60. (@GGUID+4, 241696, 1220, 0, 0, 1, 0, 0, 1477.85, 4998.25, 184.206, 0.404539, -0, -0, -0.200893, -0.979613, 300, 255, 1, 0, '', 0),
  61. (@GGUID+5, 241695, 1220, 0, 0, 1, 0, 0, 1471.04, 5002.41, 184.185, 5.94553, -0, -0, -0.168027, 0.985783, 300, 255, 1, 0, '', 0),
  62. (@GGUID+6, 241694, 1220, 0, 0, 1, 0, 0, 1474.7, 5002.6, 184.44, 3.54614, -0, -0, -0.979612, 0.200897, 300, 255, 1, 0, '', 0),
  63. (@GGUID+7, 241515, 1220, 0, 0, 1, 0, 0, -746.801, 4505.75, 731.692, 3.75162, -0, -0, -0.953844, 0.300304, 300, 255, 1, 0, '', 0),
  64. (@GGUID+8, 241438, 1220, 0, 0, 1, 0, 0, 2990.83, 3805.43, 1348.55, 5.5193, -0, -0, -0.372723, 0.927943, 300, 255, 1, 0, '', 0),
  65. (@GGUID+9, 241438, 1220, 0, 0, 1, 0, 0, 2985.27, 3808.88, 1348.98, 2.84502, -0, -0, -0.989026, -0.147743, 300, 255, 1, 0, '', 0),
  66. (@GGUID+10, 241438, 1220, 0, 0, 1, 0, 0, 2978.52, 3810.68, 1348.45, 5.97876, -0, -0, -0.151625, 0.988438, 300, 255, 1, 0, '', 0),
  67. (@GGUID+11, 241437, 1220, 0, 0, 1, 0, 0, 2968.18, 3800.52, 1348.52, 0.571292, -0, -0, -0.281777, -0.95948, 300, 255, 1, 0, '', 0),
  68. (@GGUID+12, 241420, 1220, 0, 0, 1, 0, 0, -742.863, 4512.27, 730.997, 0.819432, -0, -0, -0.398349, -0.917234, 300, 255, 1, 0, '', 0),
  69. (@GGUID+13, 241514, 1220, 0, 0, 1, 0, 0, -740.684, 4496.64, 730.997, 5.54086, -0, -0, -0.362699, 0.931906, 300, 255, 1, 0, '', 0),
  70. (@GGUID+14, 241515, 1220, 0, 0, 1, 0, 0, -747.295, 4505.16, 730.997, 3.95206, -0, -0, -0.91901, 0.394234, 300, 255, 1, 0, '', 0),
  71. (@GGUID+15, 241516, 1220, 0, 0, 1, 0, 0, -739.596, 4509, 731.051, 2.40879, -0, -0, -0.933623, -0.358258, 300, 255, 1, 0, '', 0),
  72. (@GGUID+16, 241516, 1220, 0, 0, 1, 0, 0, -743.406, 4502.72, 730.997, 5.55574, -0, -0, -0.355756, 0.934579, 300, 255, 1, 0, '', 0),
  73. (@GGUID+17, 241454, 1220, 0, 0, 1, 0, 0, -737.111, 4511.58, 731.991, 3.9555, -0, -0, -0.918331, 0.395814, 300, 255, 1, 0, '', 0),
  74. (@GGUID+18, 241454, 1220, 0, 0, 1, 0, 0, -745.526, 4500.28, 731.974, 0.820489, -0, -0, -0.398834, -0.917023, 300, 255, 1, 0, '', 0),
  75. (@GGUID+19, 241511, 1220, 0, 0, 1, 0, 0, -739.596, 4509, 731.051, 2.40879, -0, -0, -0.933623, -0.358256, 300, 255, 1, 0, '', 0);
  76.  
  77. -- The Properties of Leystone
  78. -- Alard Basic
  79. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN (92183);
  80. DELETE FROM `smart_scripts` WHERE `entryorguid` IN (92183);
  81. 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`, `event_param_string`, `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
  82. -- Event
  83. ('92183', '0', '0', '1', '19', '0', '100', '0', '39681', '0', '0', '0', '', '83', '2', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', 'Questaccept - Remove npc flag 2 - Invoker'),
  84. ('92183', '0', '1', '2', '61', '0', '100', '0', '0', '0', '0', '0', '', '1', '0', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', 'On link - Say - Invoker'),
  85. ('92183', '0', '2', '0', '61', '0', '100', '0', '0', '0', '0', '0', '', '53', '0', '92183', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', 'On link - WP Start - Invoker'),
  86. ('92183', '0', '3', '4', '40', '0', '100', '0', '1', '92183', '0', '0', '', '54', '5000', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', 'WP Reached - WP Pause - Self'),
  87. ('92183', '0', '4', '5', '61', '0', '100', '0', '0', '0', '0', '0', '', '5', '606', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', 'On link  - Play emote - Self'),
  88. ('92183', '0', '5', '0', '61', '0', '100', '0', '0', '0', '0', '0', '', '1', '1', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', 'On link  - Say - Self'),
  89. ('92183', '0', '6', '7', '40', '0', '100', '0', '2', '92183', '0', '0', '', '66', '0', '0', '0', '0', '0', '0', '8', '0', '0', '0', '0', '0', '0', '5.534260', 'WP Reached - Set orientation - Self'),
  90. ('92183', '0', '7', '8', '61', '0', '100', '0', '0', '0', '0', '0', '', '5', '233', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', 'On link  - Play emote - Self'),
  91. ('92183', '0', '8', '9', '61', '0', '100', '0', '0', '0', '0', '0', '', '1', '2', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', 'On link  - Say - Self'),
  92. ('92183', '0', '9', '0', '61', '0', '100', '0', '0', '0', '0', '0', '', '67', '1', '5000', '5000', '0', '0', '100', '1', '0', '0', '0', '0', '0', '0', '0', 'On link  - Timed event - Self'),
  93. ('92183', '0', '10', '11', '59', '0', '100', '0', '1', '0', '0', '0', '', '33', '96642', '0', '0', '0', '0', '0', '18', '20', '0', '0', '0', '0', '0', '0', 'On Timed event  - Player cast - On player dist'),
  94. ('92183', '0', '11', '12', '61', '0', '100', '0', '0', '0', '0', '0', '', '86', '183107', '0', '18', '20', '0', '0', '18', '20', '0', '0', '0', '0', '0', '0', 'On link  - Give KC - On player dist'),
  95. ('92183', '0', '12', '24', '61', '0', '100', '0', '0', '0', '0', '0', '', '82', '2', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', 'on link - Add npcflag'),
  96. -- 38500
  97. ('92183', '0', '13', '14', '19', '0', '100', '0', '38500', '0', '0', '0', '', '56', '124005', '4', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', 'Quest accept - Invoker cast - Invoker'),
  98. ('92183', '0', '14', '25', '61', '0', '100', '0', '0', '0', '0', '0', '', '1', '3', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', 'Quest accept - Say - Invoker'),
  99. -- 38522
  100. ('92183', '0', '17', '25', '19', '0', '100', '0', '38522', '0', '0', '0', '', '56', '124417', '5', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', 'Quest accept - Invoker cast - Invoker'),
  101. --
  102. ('92183', '0', '20', '0', '19', '0', '100', '0', '38564', '0', '0', '0', '', '1', '4', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', 'Quest accept - Say - Invoker'),
  103. --
  104. ('92183', '0', '21', '25', '19', '0', '100', '0', '44449', '0', '0', '0', '', '56', '124392', '2', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', 'Quest accept - Invoker cast - Invoker'),
  105. --
  106. ('92183', '0', '24', '0', '61', '0', '100', '0', '0', '0', '0', '0', '', '86', '155164', '0', '18', '20', '0', '0', '18', '20', '0', '0', '0', '0', '0', '0', 'On link - Invoker cast - Player'),
  107.  
  108. ('92183', '0', '25', '0', '61', '0', '100', '0', '0', '0', '0', '0', '', '85', '201699', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', 'On link  - Give KC - On player dist');
  109.  
  110. DELETE FROM `creature_text` WHERE `creatureID` IN (92183);
  111. INSERT INTO `creature_text` (`creatureID`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextID`, `comment`) VALUES
  112. (92183, 0, 0, 'Alright, let''s see what we can do with this ore. First things first: we heat the ore.', 12, 0, 100, 1, 0, 0, 98567, 'Alard'),
  113. (92183, 1, 0, 'Now let''s see what we can make with it.', 12, 0, 100, 1, 0, 0, 98568, 'Alard'),
  114. (92183, 2, 0, 'And now for the simple step of applying the flux. Lean in closely and watch my technique.', 12, 0, 100, 1, 0, 0, 98569, 'Alard'),
  115. (92183, 3, 0, 'You know what to do, smith: temper, heat, hammer, and weld. You can use any of the shop''s equipment.', 12, 0, 100, 1, 0, 0, 95029, 'Alard'),
  116. (92183, 4, 0, 'Go see if you can find a frost mage to help us, $n. If we can get our quenching trough cool enough, we can perform this leysmithing technique.', 12, 0, 100, 1, 0, 0, 95030, 'Alard');
  117.  
  118. DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId`='17') AND (`SourceEntry`='183107') AND (`ConditionTypeOrReference`='9') AND (`ConditionValue1`='39681');
  119. DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId`='17') AND (`SourceEntry`='183107') AND (`ConditionTypeOrReference`='47') AND (`ConditionValue1`='39681');
  120. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `NegativeCondition`, `Comment`) VALUES
  121. ('17', '0', '183107', '0', '47', '39681', '2', '0', 'Spell 183107 only if has quest 39681');
  122.  
  123. DELETE FROM `waypoints` WHERE `entry`='92183';
  124. INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES
  125. (92183, 1, -745.437622, 4502.655762, 731.050232, 'Jabrul Event Intro'),
  126. (92183, 2, -740.861023, 4509.919922, 731.080994, 'Jabrul Event Intro');
  127.  
  128. DELETE FROM `scene_template` WHERE `SceneId` IN (973);
  129. INSERT INTO `scene_template` (`SceneId`, `Flags`, `ScriptPackageID`) VALUES
  130. (973, 17, 1393);
  131.  
  132. -- Alard Exploded
  133. UPDATE `creature_template` SET `faction`=2007, `minlevel`=105, `maxlevel`=105, `gossip_menu_id`=18759 WHERE `entry`=97261;
  134.  
  135. DELETE FROM `creature_addon` WHERE `guid` IN (@CGUID+1);
  136. INSERT INTO `creature_addon` (`guid`, `emote`, `bytes1`, `bytes2`, `auras`) VALUES
  137. (@CGUID+1, 64, 0, 1, '');
  138.  
  139. DELETE FROM gossip_menu_option WHERE `MenuId` IN (18759);
  140. INSERT INTO gossip_menu_option (`MenuId`, `OptionIndex`, `OptionIcon`, `OptionText`, `OptionBroadcastTextId`, `OptionType`, `OptionNpcFlag`, `VerifiedBuild`) VALUES
  141. ('18759', '1', '3', 'Train me.', '3266', '5', '16', '0');
  142.  
  143. DELETE FROM `gossip_menu` WHERE `MenuId`=18759;
  144. INSERT INTO `gossip_menu` (`MenuId`, `TextId`) VALUES
  145. (18759, 29523);
  146.  
  147. DELETE FROM `npc_text` WHERE `id` IN (29523);
  148. INSERT INTO `npc_text` (`ID`, `Probability0`, `Probability1`, `Probability2`, `Probability3`, `Probability4`, `Probability5`, `Probability6`, `Probability7`, `BroadcastTextId0`, `BroadcastTextId1`, `BroadcastTextId2`, `BroadcastTextId3`, `BroadcastTextId4`, `BroadcastTextId5`, `BroadcastTextId6`, `BroadcastTextId7`, `VerifiedBuild`) VALUES
  149. (29523, 1, 0, 0, 0, 0, 0, 0, 0, 98986, 0, 0, 0, 0, 0, 0, 0, 25996);
  150.  
  151. --
  152. DELETE FROM `phase_area` WHERE `PhaseId`=3200 AND  `AreaId`=8413;
  153. DELETE FROM `phase_area` WHERE `PhaseId`=3201 AND  `AreaId`=8413;
  154. DELETE FROM `phase_area` WHERE `PhaseId`=3202 AND  `AreaId`=8413;
  155. DELETE FROM `phase_area` WHERE `PhaseId`=169 AND  `AreaId`=8413;
  156. DELETE FROM `phase_area` WHERE `PhaseId`=3203 AND  `AreaId`=8413;
  157. INSERT INTO `phase_area` (`AreaId`, `PhaseId`, `Comment`) VALUES
  158. ('8413', '169', 'Tank for everything - See See all'),
  159. ('8413', '3203', 'Tank for everything - See basic Alard'),
  160. ('8413', '3202', 'Tank for everything - See basic Alard'),
  161. ('8413', '3200', 'Tank for everything - See basic Alard'),
  162. ('8413', '3201', 'Tank for everything  - See Exploded Alard');
  163.  
  164. DELETE FROM `conditions` WHERE `SourceGroup`=3200 AND `SourceEntry`=8413 AND `ConditionTypeOrReference`=47 AND `ConditionValue1`=39681;
  165. DELETE FROM `conditions` WHERE `SourceGroup`=3201 AND `SourceEntry`=8413 AND `ConditionTypeOrReference`=47 AND `ConditionValue1`=39681;
  166. DELETE FROM `conditions` WHERE `SourceGroup`=3200 AND `SourceEntry`=8413 AND `ConditionTypeOrReference`=47 AND `ConditionValue1`=40542;
  167. DELETE FROM `conditions` WHERE `SourceGroup`=3201 AND `SourceEntry`=8413 AND `ConditionTypeOrReference`=47 AND `ConditionValue1`=40542;
  168. DELETE FROM `conditions` WHERE `SourceGroup`=3201 AND `SourceEntry`=8413 AND `ConditionTypeOrReference`=47 AND `ConditionValue1`=38501;
  169. DELETE FROM `conditions` WHERE `SourceGroup`=3202 AND `SourceEntry`=8413 AND `ConditionTypeOrReference`=47 AND `ConditionValue1`=38501;
  170. DELETE FROM `conditions` WHERE `SourceGroup`=3203 AND `SourceEntry`=8413 AND `ConditionTypeOrReference`=47 AND `ConditionValue1`=38564;
  171. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `NegativeCondition`, `Comment`) VALUES
  172. ('26', '3200', '8413', '47', '39681', '66', '1', 'Phase 3500 if quest 39681 not complete/rewarded'),
  173. ('26', '3201', '8413', '47', '39681', '66', '0', 'Phase 3501 if quest 39681 complete/rewarded'),
  174. ('26', '3201', '8413', '47', '38501', '66', '1', 'Phase 3501 if quest 38501 not complete/rewarded'),
  175. ('26', '3202', '8413', '47', '38501', '66', '0', 'Phase 3502 if quest 38501 complete/rewarded'),
  176. ('26', '3203', '8413', '47', '38564', '66', '0', 'Phase 3503 if quest 38564 complete/rewarded');
  177.  
  178. -- Timofey
  179. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN (92194);
  180. DELETE FROM `smart_scripts` WHERE `entryorguid` IN (92194);
  181. 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`, `event_param_string`, `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
  182. ('92194', '0', '0', '1', '19', '0', '100', '0', '38506', '0', '0', '0', '', '83', '2', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', 'Questaccept - Remove npc flag 2 - Invoker'),
  183. ('92194', '0', '1', '2', '61', '0', '100', '0', '0', '0', '0', '0', '', '1', '0', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', 'On link - Say - Invoker'),
  184. ('92194', '0', '2', '3', '61', '0', '100', '0', '0', '0', '0', '0', '', '56', '123978', '1', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', 'On link - Say - Invoker'),
  185. ('92194', '0', '3', '0', '61', '0', '100', '0', '0', '0', '0', '0', '', '69', '1', '0', '0', '0', '0', '0', '1', '0', '0', '0', -723.837036,4560.879395, 729.930786, 1.072411, 'On link - Move to pos - Self'),
  186. ('92194', '0', '4', '5', '34', '0', '100', '0', '0', '1', '0', '0', '', '5', '606', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', 'Movement Inform - Play emote - Self'),
  187. ('92194', '0', '5', '0', '61', '0', '100', '0', '0', '0', '0', '0', '', '67', '1', '5000', '5000', '0', '0', '100', '1', '0', '0', '0', '0', '0', '0', '0', 'On link  - Timed event - Self'),
  188. ('92194', '0', '6', '7', '59', '0', '100', '0', '1', '0', '0', '0', '', '1', '1', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', 'On Timed event  - Say - Self'),
  189. ('92194', '0', '7', '0', '61', '0', '100', '0', '1', '0', '0', '0', '', '69', '2', '0', '0', '0', '0', '0', '1', '0', '0', '0', -726.593994, 4561.290039, 729.719971, 4.709670, 'On link - Move to pos - Self'),
  190. ('92194', '0', '8', '9', '34', '0', '100', '0', '0', '2', '0', '0', '', '66', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', 'Movement Inform - Set orientation - Self'),
  191. ('92194', '0', '9', '0', '61', '0', '100', '0', '0', '1', '0', '0', '', '82', '2', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', 'On link - Add Npc flag - Self');
  192.  
  193.  
  194. DELETE FROM `creature_text` WHERE `creatureID` IN (92194);
  195. INSERT INTO `creature_text` (`creatureID`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextID`, `comment`) VALUES
  196. (92194, 0, 0, 'The Data Extratinator 3000 might be able to decipher this core. Cross your fingers that it doesn''t explode in the process.', 12, 0, 100, 1, 0, 0, 98376, 'Timofey'),
  197. (92194, 1, 0, 'This core contains a script written in an ancient Highborne dialect, which I can''t read. Professor Pallin in the Scribes'' Sacellum may be able to translate this.', 12, 0, 100, 1, 0, 0, 98378, 'Timofey');
  198.  
  199.  
  200. DELETE FROM `gameobject_template` WHERE `entry` IN (241514, 241515, 241516, 241454, 241420, 241437, 241438, 241691, 241694, 241695, 241696, 241510);
  201. INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `size`, `Data0`, `Data1`, `Data2`, `Data3`, `Data4`, `Data5`, `Data6`, `Data7`, `Data8`, `Data9`, `Data10`, `Data11`, `Data12`, `Data13`, `Data14`, `Data15`, `Data16`, `Data17`, `Data18`, `Data19`, `Data20`, `Data21`, `Data22`, `Data23`, `Data24`, `Data25`, `Data26`, `Data27`, `Data28`, `Data29`, `Data30`, `Data31`, `Data32`, `RequiredLevel`, `AIName`, `ScriptName`, `VerifiedBuild`) VALUES
  202. ('241514', '8', '0', 'Alard''s Workbench', '', '', '', '1', '1863', '7', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0'),
  203. ('241515', '8', '0', 'Alard''s Quenching Trough', '', '', '', '1', '1865', '7', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0'),
  204. ('241516', '8', '0', 'Alard''s Anvil', '', '', '', '1', '1861', '7', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0'),
  205. ('241454', '8', '0', 'Alard''s Forge', '', '', '', '1', '1862', '7', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0'),
  206. ('241420', '8', '0', 'Alard''s Whetstone', '', '', '', '1', '1868', '7', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0'),
  207. ('241437', '8', '0', 'Greenhoof''s Forge', '', '', '', '1', '1869', '7', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0'),
  208. ('241438', '8', '0', 'Greenhoof''s Anvil', '', '', '', '1', '1870', '7', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0'),
  209. ('241694', '8', '0', 'Felsmith Forge', '', '', '', '1', '1872', '7', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0'),
  210. ('241695', '8', '0', 'Felsmith Anvil', '', '', '', '1', '1871', '7', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0'),
  211. ('241696', '8', '0', 'Felsmith Workbench', '', '', '', '1', '1873', '7', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0'),
  212. ('241691', '8', '0', 'Felsmith Quenching Trough', '', '', '', '1', '1874', '7', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0'),
  213. ('241510', '8', '0', 'Frozen Quenching Trough', '', '', '', '1', '1867', '7', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0');
  214.  
  215. -- Flower-Pickers and Potion-Quaffers
  216. -- Linzy Blackbolt
  217. UPDATE `creature_template` SET `gossip_menu_id`=18380, `AIName`='SmartAI' WHERE `entry`= '92456';
  218. DELETE FROM `smart_scripts` WHERE (`entryorguid`=92456 AND `source_type`=0);
  219. 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
  220. (92456, 0, 0, 1, 62, 0, 100, 0, 18380, 2, 0, 0, 33, 92456, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "Gossip Select - Give KC - Player"),
  221. (92456, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "On link - Say - Player"),
  222. (92456, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "On link - Close gossip - Player");
  223.  
  224.  
  225. DELETE FROM `creature_text` WHERE `creatureID` IN (92456);
  226. INSERT INTO `creature_text` (`creatureID`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextID`, `comment`) VALUES
  227. (92456, 0, 0, 'Whoah! Neat recipe. As long as the herbalists keep bringing me fresh foxflower, I can certainly make this preparation for you. No problem.', 12, 0, 100, 1, 0, 0, 94508, 'Linzy');
  228.  
  229. DELETE FROM `gossip_menu_option` WHERE `MenuId` IN (18380);
  230. INSERT INTO `gossip_menu_option` (`MenuID`, `OptionIndex`, `OptionIcon`, `OptionText`, `OptionBroadcastTextId`, `OptionType`, `OptionNpcflag`) VALUES
  231. ('18380', '2', '0', 'Alard at the blacksmith shop will need a regular supply of foxflower flux. Can you make any?', '94482', '1', '1'),
  232. ('18380', '1', '0', 'Hello again, Linzy. What''s new with you?', '98720', '1', '1'),
  233. ('18380', '0', '3', 'I Would like to train', '8221', '5', '16');
  234.  
  235.  
  236. DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId`='15') AND (`SourceGroup`='18380') AND (`ConditionTypeOrReference`='48');
  237. DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId`='15') AND (`SourceGroup`='18380') AND (`ConditionTypeOrReference`='9');
  238. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `NegativeCondition`, `Comment`) VALUES
  239. ('15', '18380', '2', '0', '48', '278183', '0', '1', 'See gossip if objective is not complete'),
  240. ('15', '18380', '2', '0', '9', '38563', '0', '0', 'See gossip if have quest taken');
  241.  
  242. DELETE FROM `gossip_menu` WHERE `MenuId`=18736 AND `TextId`=27231;
  243. DELETE FROM `gossip_menu` WHERE `MenuId`=18735 AND `TextId`=27230;
  244. DELETE FROM `gossip_menu` WHERE `MenuId`=18380 AND `TextId`=14712;
  245. INSERT INTO `gossip_menu` (`MenuId`, `TextId`) VALUES
  246. (18736, 27231),
  247. (18735, 27230),
  248. (18380, 14712);
  249.  
  250. DELETE FROM `npc_text` WHERE `ID` IN (27231, 27230, 14712);
  251. INSERT INTO `npc_text` (`ID`, `Probability0`, `Probability1`, `Probability2`, `Probability3`, `Probability4`, `Probability5`, `Probability6`, `Probability7`, `BroadcastTextId0`, `BroadcastTextId1`, `BroadcastTextId2`, `BroadcastTextId3`, `BroadcastTextId4`, `BroadcastTextId5`, `BroadcastTextId6`, `BroadcastTextId7`, `VerifiedBuild`) VALUES
  252. (27231, 1, 0, 0, 0, 0, 0, 0, 0, 98726, 0, 0, 0, 0, 0, 0, 0, 25996),
  253. (27230, 1, 0, 0, 0, 0, 0, 0, 0, 98721, 0, 0, 0, 0, 0, 0, 0, 25996),
  254. (14712, 1, 0, 0, 0, 0, 0, 0, 0, 35401, 0, 0, 0, 0, 0, 0, 0, 25996);
  255.  
  256. DELETE FROM `gossip_menu_option_action` WHERE `MenuId`=18735 AND `OptionIndex`=1;
  257. DELETE FROM `gossip_menu_option_action` WHERE `MenuId`=18380 AND `OptionIndex`=1;
  258. INSERT INTO `gossip_menu_option_action` (`MenuId`, `OptionIndex`, `ActionMenuId`, `ActionPoiId`) VALUES
  259. (18735, 1, 18736, 0),
  260. (18380, 1, 18735, 0);
  261.  
  262. -- Kuhuine Tenderstride
  263. UPDATE `creature_template` SET `gossip_menu_id`=18379, `AIName`='SmartAI' WHERE `entry`= '92464';
  264. DELETE FROM `smart_scripts` WHERE (`entryorguid`=92464 AND `source_type`=0);
  265. 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
  266. (92464, 0, 0, 1, 62, 0, 100, 0, 18379, 1, 0, 0, 33, 92464, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "Gossip Select - Give KC - Player"),
  267. (92464, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "On link - Say - Player"),
  268. (92464, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "On link - Close gossip - Player");
  269.  
  270.  
  271. DELETE FROM `creature_text` WHERE `creatureID` IN (92464);
  272. INSERT INTO `creature_text` (`creatureID`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextID`, `comment`) VALUES
  273. (92464, 0, 0, 'Of course. Our herbalists bring in plenty of foxflower. I will make sure to set some aside for your metalwork.', 12, 0, 100, 1, 0, 0, 94507, 'Kuhuine');
  274.  
  275. DELETE FROM `gossip_menu` WHERE `MenuId`=18379 AND `TextId`=26474;
  276. INSERT INTO `gossip_menu` (`MenuId`, `TextId`) VALUES
  277. (18379, 26474);
  278.  
  279. DELETE FROM `npc_text` WHERE `ID` IN (26474);
  280. INSERT INTO `npc_text` (`ID`, `Probability0`, `Probability1`, `Probability2`, `Probability3`, `Probability4`, `Probability5`, `Probability6`, `Probability7`, `BroadcastTextId0`, `BroadcastTextId1`, `BroadcastTextId2`, `BroadcastTextId3`, `BroadcastTextId4`, `BroadcastTextId5`, `BroadcastTextId6`, `BroadcastTextId7`, `VerifiedBuild`) VALUES
  281. (26474, 1, 1, 1, 0, 0, 0, 0, 0, 94478, 94479, 94480, 0, 0, 0, 0, 0, 25996);
  282.  
  283. DELETE FROM `gossip_menu_option` WHERE `MenuId` IN (18379);
  284. INSERT INTO `gossip_menu_option` (`MenuID`, `OptionIndex`, `OptionIcon`, `OptionText`, `OptionBroadcastTextId`, `OptionType`, `OptionNpcflag`) VALUES
  285. ('18379', '1', '0', 'Alard at the blacksmith shop will need a regular supply of foxflower. Do you have any?', '94481', '1', '1'),
  286. ('18379', '0', '3', 'I Would like to train', '8221', '5', '16');
  287.  
  288. DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId`='15') AND (`SourceGroup`='18379') AND (`ConditionTypeOrReference`='48');
  289. DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId`='15') AND (`SourceGroup`='18379') AND (`ConditionTypeOrReference`='9');
  290. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `NegativeCondition`, `Comment`) VALUES
  291. ('15', '18379', '1', '0', '48', '278184', '0', '1', 'See gossip if objective is not complete'),
  292. ('15', '18379', '1', '0', '9', '38563', '0', '0', 'See gossip if have quest taken');
  293.  
  294.  
  295.  
  296. -- Ironhorn Leysmithing
  297. -- Barm
  298. UPDATE `creature_template` SET `gossip_menu_id`=30020, `AIName`='SmartAI' WHERE `entry`=92242;
  299. DELETE FROM `smart_scripts` WHERE (`entryorguid`=92242 AND `source_type`=0);
  300. 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
  301. (92242, 0, 0, 0, 19, 0, 100, 0, 39699, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "Quest accept - Say - Player"),
  302. (92242, 0, 1, 0, 19, 0, 100, 0, 0, 0, 0, 0, 85, 201699, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "Quest accept - Say - Player");
  303.  
  304.  
  305. DELETE FROM `creature_text` WHERE `creatureID` IN (92242);
  306. INSERT INTO `creature_text` (`creatureID`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextID`, `comment`) VALUES
  307. (92242, 0, 0, 'A responsible smith does not waste material. You may use any pieces of scrap metal that you find around our camp.', 12, 0, 100, 1, 0, 0, 94507, 'Kuhuine');
  308.  
  309. DELETE FROM `gossip_menu` WHERE `MenuId`=30020 AND `TextId`=35020;
  310. INSERT INTO `gossip_menu` (`MenuId`, `TextId`) VALUES
  311. (30020, 35020);
  312.  
  313. DELETE FROM `npc_text` WHERE `ID` IN (35020);
  314. INSERT INTO `npc_text` (`ID`, `Probability0`, `Probability1`, `Probability2`, `Probability3`, `Probability4`, `Probability5`, `Probability6`, `Probability7`, `BroadcastTextId0`, `BroadcastTextId1`, `BroadcastTextId2`, `BroadcastTextId3`, `BroadcastTextId4`, `BroadcastTextId5`, `BroadcastTextId6`, `BroadcastTextId7`, `VerifiedBuild`) VALUES
  315. (35020, 1, 0, 0, 0, 0, 0, 0, 0, 95400, 0, 0, 0, 0, 0, 0, 0, 25996);
  316.  
  317. DELETE FROM `gossip_menu_option` WHERE `MenuId` IN (30020);
  318. INSERT INTO `gossip_menu_option` (`MenuID`, `OptionIndex`, `OptionIcon`, `OptionText`, `OptionBroadcastTextId`, `OptionType`, `OptionNpcflag`) VALUES
  319. ('30020', '0', '3', 'I Would like to train', '8221', '5', '16');
  320.  
  321.  
  322. UPDATE `gameobject_template` SET `Data1`='241635', `Data8`='39699' WHERE (`entry`='241635');
  323. UPDATE `gameobject_template` SET `Data1`='241634', `Data8`='39699' WHERE (`entry`='241634');
  324. UPDATE `gameobject_template` SET `Data1`='241633', `Data8`='39699' WHERE (`entry`='241633');
  325.  
  326. DELETE FROM `gameobject_loot_template` WHERE (`Entry`='241635') AND (`Item`='124404');
  327. DELETE FROM `gameobject_loot_template` WHERE (`Entry`='241634') AND (`Item`='124403');
  328. DELETE FROM `gameobject_loot_template` WHERE (`Entry`='241633') AND (`Item`='124405');
  329. INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `QuestRequired`) VALUES
  330. ('241635', '124404', '1'),
  331. ('241634', '124403', '1'),
  332. ('241633', '124405', '1');
  333.  
  334. -- Greyheft
  335. UPDATE `creature_loot_template` SET `Chance`='100', `GroupId`='1' WHERE (`Entry`='93021') AND (`Item`='124004');
  336. UPDATE `creature_template` SET `LootId`=93021 WHERE `entry`=93021;
  337.  
  338.  
  339. -- Leystone Hoofplates
  340. -- Mei Francis
  341. UPDATE `creature_template` SET `gossip_menu_id`=18383, `AIName`='SmartAI' WHERE `entry`= '92489';
  342. DELETE FROM `smart_scripts` WHERE (`entryorguid`=92489 AND `source_type`=0);
  343. DELETE FROM `smart_scripts` WHERE (`entryorguid`=9248900 AND `source_type`=9);
  344. 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
  345. (92489, 0, 0, 1, 62, 0, 100, 0, 18383, 1, 0, 0, 80, 9248900, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Gossip Select - Begin action list - Self"),
  346. (9248900, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 83, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Actionlist - Remove npc flag - Self"),
  347. (9248900, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "On link - Say - Player"),
  348. (9248900, 9, 2, 0, 0, 0, 100, 0, 5000, 5000, 5000, 5000, 1, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "On link - Say - Player"),
  349. (9248900, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 75, 182993, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "On link - InvokerCast - Player"),
  350. (9248900, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 33, 92492, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "On link - Give KC - Player"),
  351. (9248900, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 82, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "On link - Add npcflag - Player");
  352.  
  353.  
  354. DELETE FROM `creature_text` WHERE `creatureID` IN (92489);
  355. INSERT INTO `creature_text` (`creatureID`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextID`, `comment`) VALUES
  356. (92489, 0, 0, 'You need your mount shod? Let''s see if I can make these hoofplates fit...', 12, 0, 100, 1, 0, 0, 94518, 'Mei Francis'),
  357. (92489, 1, 0, 'All done! You take care of that mount now. It''s a beauty.', 12, 0, 100, 1, 0, 0, 94519, 'Mei Francis');
  358.  
  359. DELETE FROM `gossip_menu` WHERE `MenuId`=18383 AND `TextId`=14127;
  360. DELETE FROM `gossip_menu` WHERE `MenuId`=18384 AND `TextId`=35021;
  361. INSERT INTO `gossip_menu` (`MenuId`, `TextId`) VALUES
  362. (18383, 14127),
  363. (18384, 35021);
  364.  
  365. DELETE FROM `gossip_menu_option_action` WHERE `MenuId`=18383 AND `OptionIndex`=1;
  366. INSERT INTO `gossip_menu_option_action` (`MenuId`, `OptionIndex`, `ActionMenuId`, `ActionPoiId`) VALUES
  367. (18383, 1, 18384, 0);
  368.  
  369. DELETE FROM `npc_text` WHERE `ID` IN (14127, 35021);
  370. INSERT INTO `npc_text` (`ID`, `Probability0`, `Probability1`, `Probability2`, `Probability3`, `Probability4`, `Probability5`, `Probability6`, `Probability7`, `BroadcastTextId0`, `BroadcastTextId1`, `BroadcastTextId2`, `BroadcastTextId3`, `BroadcastTextId4`, `BroadcastTextId5`, `BroadcastTextId6`, `BroadcastTextId7`, `VerifiedBuild`) VALUES
  371. (14127, 1, 0, 0, 0, 0, 0, 0, 0, 32779, 0, 0, 0, 0, 0, 0, 0, 25996),
  372. (35021, 1, 0, 0, 0, 0, 0, 0, 0, 94521, 0, 0, 0, 0, 0, 0, 0, 25996);
  373.  
  374. DELETE FROM `gossip_menu_option` WHERE `MenuId` IN (18383);
  375. INSERT INTO `gossip_menu_option` (`MenuID`, `OptionIndex`, `OptionIcon`, `OptionText`, `OptionBroadcastTextId`, `OptionType`, `OptionNpcflag`) VALUES
  376. ('18383', '1', '0', 'Can you fit these hoofplates on my mount?', '94520', '1', '1'),
  377. ('18383', '0', '0', 'I want to browse your goods.', '3370', '3', '128');
  378.  
  379. DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId`='15') AND (`SourceGroup`='18383') AND (`ConditionTypeOrReference`='48');
  380. DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId`='15') AND (`SourceGroup`='18383') AND (`ConditionTypeOrReference`='9');
  381. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `NegativeCondition`, `Comment`) VALUES
  382. ('15', '18383', '1', '0', '48', '278195', '0', '1', 'See gossip if objective is not complete'),
  383. ('15', '18383', '1', '0', '9', '38523', '0', '0', 'See gossip if have quest taken');
  384.  
  385. -- Legend of the Black Rook
  386. DELETE FROM `event_scripts` WHERE `id`=46338;
  387. INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `x`, `y`, `z`, `o`) VALUES
  388. ('46338', '1', '10', '96726', '220000',  3061.896729, 7294.654785, 51.557743, 3.770569);
  389.  
  390. -- Saris Swifthammer
  391. UPDATE `creature_template` SET `AIName`='SmartAI', `minlevel`=105, `maxlevel`=110, `faction`=15, `unit_flags`=0 WHERE `entry`= '96726';
  392. DELETE FROM `smart_scripts` WHERE (`entryorguid`=96726 AND `source_type`=0);
  393. DELETE FROM `smart_scripts` WHERE (`entryorguid`=9672600 AND `source_type`=9);
  394. 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
  395. (96726, 0, 0, 1, 54, 0, 100, 0, 0, 0, 0, 0, 69, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 3056.664307, 7289.800781, 51.55774, 3.853036, "Just sum - Move to pos - Self"),
  396. (96726, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "On link - Say - Self"),
  397. (96726, 0, 2, 3, 34, 0, 100, 0, 0, 1, 0, 0, 18, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Movement inform - Set unit flag - Self"),
  398. (96726, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 2, 16, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "On link - Set faction - Self"),
  399. (96726, 0, 4, 0, 2, 0, 100, 1, 0, 50, 1, 1, 80, 9672600, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Health pct - Begin actionlist - Self"),
  400. (9672600, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 2, 35, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Actionlist - Set faction - Self"),
  401. (9672600, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 27, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Actionlist - Combat stop - Self"),
  402. (9672600, 9, 3, 0, 0, 0, 100, 0, 2000, 2000, 2000, 2000, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Actionlist - Say - Self"),
  403. (9672600, 9, 4, 0, 0, 0, 100, 0, 5000, 5000, 5000, 5000, 1, 2, 0, 0, 0, 0, 0, 21, 30, 0, 0, 0, 0, 0, 0, "Actionlist - Say - Closest player"),
  404. (9672600, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 33, 96736, 0, 0, 0, 0, 0, 18, 70, 0, 0, 0, 0, 0, 0, "Actionlist - Say - Closest player"),
  405. (9672600, 9, 6, 0, 0, 0, 100, 0, 0, 0, 0, 0, 41, 2000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Actionlist - Despawn - Self");
  406.  
  407. DELETE FROM `creature_text` WHERE `creatureID` IN (96726);
  408. INSERT INTO `creature_text` (`creatureID`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextID`, `comment`) VALUES
  409. (96726, 0, 0, 'Here to pillage our wares, demon?! You shall take NOTHING!', 12, 0, 100, 1, 0, 0, 98722, 'Saris Swifthammer'),
  410. (96726, 1, 0, 'Wait! Stop! You''re... you''re no demon...', 12, 0, 100, 1, 0, 0, 98723, 'Saris Swifthammer'),
  411. (96726, 2, 0, 'The fog has lifted and I can see the truth once more. Thank you, $pc. If you would join me at my old shop, perhaps we can speak further.', 12, 0, 100, 1, 0, 0, 98725, 'Saris Swifthammer');
  412.  
  413. -- Saris Swifthammer questgiver
  414. UPDATE `creature_template` SET `faction`=35, `minlevel`=105, `maxlevel`=110, `gossip_menu_id`=30021 WHERE `entry`=96763;
  415.  
  416. DELETE FROM `gossip_menu` WHERE `MenuId`=30021 AND `TextId`=35021;
  417. INSERT INTO `gossip_menu` (`MenuId`, `TextId`) VALUES
  418. (30021, 35021);
  419.  
  420. DELETE FROM `npc_text` WHERE `ID` IN (35021);
  421. INSERT INTO `npc_text` (`ID`, `Probability0`, `Probability1`, `Probability2`, `Probability3`, `Probability4`, `Probability5`, `Probability6`, `Probability7`, `BroadcastTextId0`, `BroadcastTextId1`, `BroadcastTextId2`, `BroadcastTextId3`, `BroadcastTextId4`, `BroadcastTextId5`, `BroadcastTextId6`, `BroadcastTextId7`, `VerifiedBuild`) VALUES
  422. (35021, 1, 0, 0, 0, 0, 0, 0, 0, 98958, 0, 0, 0, 0, 0, 0, 0, 25996);
  423.  
  424. -- Between the Hammer...
  425. UPDATE `gameobject_template` SET `Data1`='244000', `Data8`='39680' WHERE (`entry`='244000');
  426.  
  427. DELETE FROM `gameobject_loot_template` WHERE (`Entry`='244000') AND (`Item`='128745');
  428. INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `QuestRequired`) VALUES
  429. ('244000', '128745', '1');
  430.  
  431. -- ... And the Anvil
  432. UPDATE `creature_loot_template` SET `Chance`='80', `GroupId`='1' WHERE `Item`='128751';
  433.  
  434. -- The Knowledge of Black Rook
  435. UPDATE `gameobject_template` SET `Data1`='244001', `Data8`='39729' WHERE (`entry`='244001');
  436. DELETE FROM `gameobject_loot_template` WHERE (`Entry`='244001') AND (`Item`='128746');
  437. INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `QuestRequired`) VALUES
  438. ('244001', '128746', '1');
  439.  
  440.  
  441. -- A Sweet Bargain
  442.  
  443. DELETE FROM `phase_area` WHERE `PhaseId`=169 AND  `AreaId`=7581;
  444. DELETE FROM `phase_area` WHERE `PhaseId`=3204 AND  `AreaId`=7581;
  445. DELETE FROM `phase_area` WHERE `PhaseId`=3205 AND  `AreaId`=7581;
  446. DELETE FROM `phase_area` WHERE `PhaseId`=3206 AND  `AreaId`=7581;
  447. INSERT INTO `phase_area` (`AreaId`, `PhaseId`, `Comment`) VALUES
  448. ('7581', '169', 'Dalaran - See See all'),
  449. ('7581', '3204', 'Dalaran - See basic Glaciela'),
  450. ('7581', '3205', 'Dalaran - See Talk to Glaciela'),
  451. ('7581', '3206', 'Dalaran - See SpellClick Glaciela');
  452.  
  453. DELETE FROM `conditions` WHERE `SourceGroup`=3204 AND `SourceEntry`=7581 AND `ConditionTypeOrReference`=9 AND `ConditionValue1`=38564;
  454. DELETE FROM `conditions` WHERE `SourceGroup`=3205 AND `SourceEntry`=7581 AND `ConditionTypeOrReference`=48 AND `ConditionValue1`=278114;
  455. DELETE FROM `conditions` WHERE `SourceGroup`=3205 AND `SourceEntry`=7581 AND `ConditionTypeOrReference`=9 AND `ConditionValue1`=38564;
  456. DELETE FROM `conditions` WHERE `SourceGroup`=3206 AND `SourceEntry`=7581 AND `ConditionTypeOrReference`=48 AND `ConditionValue1`=278114;
  457. DELETE FROM `conditions` WHERE `SourceGroup`=3206 AND `SourceEntry`=7581 AND `ConditionTypeOrReference`=48 AND `ConditionValue1`=278116;
  458. DELETE FROM `conditions` WHERE `SourceGroup`=3206 AND `SourceEntry`=7581 AND `ConditionTypeOrReference`=9 AND `ConditionValue1`=38564;
  459. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `NegativeCondition`, `Comment`) VALUES
  460. ('26', '3204', '7581', '9', '38564', '0', '1', 'Phase 3204 if havn''t quest 38564'),
  461. --
  462. ('26', '3205', '7581', '48', '278114', '0', '1', 'Phase 3204 if quest 39681 not complete/rewarded'),
  463. ('26', '3205', '7581', '9', '38564', '0', '0', 'Phase 3204 if have quest 38564'),
  464. --
  465. ('26', '3206', '7581', '48', '278114', '0', '0', 'Phase 3204 if quest 39681 not complete/rewarded'),
  466. ('26', '3206', '7581', '48', '278116', '0', '1', 'Phase 3204 if quest 39681 not complete/rewarded'),
  467. ('26', '3206', '7581', '9', '38564', '0', '0', 'Phase 3204 if have quest 38564');
  468.  
  469.  
  470.  
  471. -- Glaciala
  472. UPDATE `creature_template` SET `AIName`='SmartAI', `npcflag`=0 WHERE `entry`= '92438';
  473. DELETE FROM `smart_scripts` WHERE (`entryorguid`=92438 AND `source_type`=0);
  474. 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
  475. (92438, 0, 0, 1, 64, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "On gossip hello - Say - Invoker"),
  476. (92438, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "On link - Close gossip - Invoker"),
  477. (92438, 0, 2, 3, 61, 0, 100, 0, 0, 0, 0, 0, 85, 155164, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "On link - Close gossip - Invoker"),
  478. (92438, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 45, 0, 1, 0, 0, 0, 0, 19, 92936, 30, 0, 0, 0, 0, 0, "On link - Close gossip - Invoker");
  479.  
  480. DELETE FROM `creature_text` WHERE `creatureID` IN (92438);
  481. INSERT INTO `creature_text` (`creatureID`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextID`, `comment`) VALUES
  482. (92438, 0, 0, 'You need my help in the blacksmithing shop? Fine, but every mage has her price... and my price happens to be candy.', 12, 0, 100, 1, 0, 0, 94455, '');
  483.  
  484.  
  485. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`= '92936';
  486. DELETE FROM `smart_scripts` WHERE (`entryorguid`=92936 AND `source_type`=0);
  487. 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
  488. (92936, 0, 0, 1, 38, 0, 100, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "On gossip hello - Say - Invoker"),
  489. (92936, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 85, 155164, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "On link - Close gossip - Invoker");
  490.  
  491. DELETE FROM `creature_text` WHERE `creatureID` IN (92936);
  492. INSERT INTO `creature_text` (`creatureID`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextID`, `comment`) VALUES
  493. (92936, 0, 0, 'Glaciela, I swear, your teeth are going to fall out one day from eating all my delicious candies.', 12, 0, 100, 1, 0, 0, 98999, '');
  494.  
  495.  
  496. DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`=92438;
  497. INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`) VALUES
  498. ('92438', '184169', '3');
  499.  
  500. DELETE FROM `conditions` WHERE `SourceGroup`=92438 AND `SourceEntry`=184169 AND `ConditionTypeOrReference`=48 AND `ConditionValue1`=278116;
  501. DELETE FROM `conditions` WHERE `SourceGroup`=92438 AND `SourceEntry`=184169 AND `ConditionTypeOrReference`=48 AND `ConditionValue1`=278115;
  502. DELETE FROM `conditions` WHERE `SourceGroup`=92438 AND `SourceEntry`=184169 AND `ConditionTypeOrReference`=9 AND `ConditionValue1`=38564;
  503. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ConditionTypeOrReference`, `ConditionValue1`, `NegativeCondition`, `Comment`) VALUES
  504. ('18', '92438', '184169', '48', '278115', '0', 'Npc spell click only if has objective complete'),
  505. ('18', '92438', '184169', '9', '38564', '0', 'Npc spell click only if has quest taken');
  506.  
  507. -- Glaciala summon
  508. UPDATE `creature_template` SET `AIName`='SmartAI', `minlevel`=105, `maxlevel`=105, `faction`=2007 WHERE `entry`= '92938';
  509. DELETE FROM `smart_scripts` WHERE (`entryorguid`=92938 AND `source_type`=0);
  510. 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
  511. (92938, 0, 0, 1, 54, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "Just sum - Say - Self"),
  512. (92938, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 41, 5000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "On link - Despawn - Self"),
  513. (92938, 0, 2, 3, 61, 0, 100, 0, 0, 0, 0, 0, 56, 124398, 20, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "On link - Close gossip - Invoker"),
  514. (92938, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 33, 92925, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "On link - Close gossip - Invoker");
  515.  
  516. DELETE FROM `creature_text` WHERE `creatureID` IN (92938);
  517. INSERT INTO `creature_text` (`creatureID`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextID`, `comment`) VALUES
  518. (92938, 0, 0, 'Consider me hired. See you there!', 12, 0, 100, 1, 0, 0, 94457, '');
  519.  
  520.  
  521.  
  522. -- Nal'ryssa
  523. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`= '92264';
  524. DELETE FROM `smart_scripts` WHERE (`entryorguid`=92264 AND `source_type`=0);
  525. 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
  526. (92264, 0, 0, 1, 19, 0, 100, 0, 38526, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "Quest accept - Say - Player"),
  527. (92264, 0, 1, 5, 61, 0, 100, 0, 0, 0, 0, 0, 56, 124425, 8, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "Quest accept - Add item - Player"),
  528. --
  529. (92264, 0, 3, 4, 19, 0, 100, 0, 38528, 0, 0, 0, 56, 124451, 2, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "Quest accept - Add item - Player"),
  530. (92264, 0, 4, 5, 61, 0, 100, 0, 0, 0, 0, 0, 56, 124449, 1, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "Quest accept - Add item - Player"),
  531. (92264, 0, 5, 0, 61, 0, 100, 0, 0, 0, 0, 0, 85, 201699, 1, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "Quest accept - Add item - Player");
  532.  
  533. DELETE FROM `creature_text` WHERE `creatureID` IN (92264);
  534. INSERT INTO `creature_text` (`creatureID`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextID`, `comment`) VALUES
  535. (92264, 0, 0, 'Be quick about your work. You''ll only have a small window of time to hammer out those red-hot leystone bars into the components you need.', 12, 0, 100, 1, 0, 0, 95033, 'Nal''ryssa');
  536.  
  537. -- Leysmithing Masteries
  538. DELETE FROM `spell_learn_spell` WHERE `entry`=201699;
  539. INSERT INTO `spell_learn_spell` (`entry`, `SpellID`) VALUES
  540. ('201699', '183562'),
  541. ('201699', '183281'),
  542. ('201699', '183280'),
  543. ('201699', '183283'),
  544. ('201699', '183279'),
  545. --
  546. ('201699', '184214'),
  547. ('201699', '184215'),
  548. ('201699', '184216'),
  549. ('201699', '184217'),
  550. ('201699', '184218'),
  551. ('201699', '184219'),
  552. ('201699', '184220'),
  553. -- Not just Weapons and Armor  
  554. ('201699', '184315'),
  555. ('201699', '184309'),
  556. ('201699', '184313'),
  557. ('201699', '184314'),
  558. ('201699', '184308'),
  559. ('201699', '184312'),
  560. ('201699', '184310'),
  561. ('201699', '183278'),
  562. -- Advanced Quenching
  563. ('201699', '184181'),
  564. ('201699', '184183'),
  565. ('201699', '184182'),
  566. ('201699', '184185'),
  567. ('201699', '184184'),
  568. -- Smith under fire
  569. ('201699', '184336'),
  570. ('201699', '184337'),
  571. ('201699', '184338'),
  572. ('201699', '184339'),
  573. ('201699', '184344'),
  574. ('201699', '184340'),
  575. -- Leystone's potential
  576. ('201699', '184405'),
  577. ('201699', '184407'),
  578. ('201699', '184404'),
  579. ('201699', '184408'),
  580. ('201699', '184403');
  581.  
  582. DELETE FROM `spell_script_names` WHERE `spell_id`=184758;
  583. INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
  584. ('184758', 'spell_gen_firmament_stone_dummy');
  585.  
  586.  
  587. DELETE FROM `creature_template_addon` WHERE `entry` IN (92247, 92244, 92246);
  588. INSERT INTO `creature_template_addon` (`entry`, `emote`, `bytes1`, `bytes2`, `auras`) VALUES
  589. (92247, 233, 0, 1, ''),
  590. (92244, 233, 0, 1, ''),
  591. (92246, 233, 0, 1, '');
RAW Paste Data
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
 
Top