API tools faq
paste
frenado05

123

frenado05
Apr 21st, 2026 (edited)
29
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 15.18 KB | None | 0 0
raw download clone embed print report
  1. -- 1. Обновляем quest_template (Expansion = 6, AllowableRaces = 824380493)
  2. UPDATE `quest_template`
  3. SET `Expansion` = 6, `AllowableRaces` = 824380493
  4. WHERE `ID` IN (52750, 49737, 52787, 49757);
  5.  
  6. DELETE FROM `creature_queststarter`
  7. WHERE `quest` IN (52750, 49737, 52787, 49757);
  8. INSERT INTO `creature_queststarter` (`id`, `quest`, `MaxExpansion`, `MinExpansion`) VALUES
  9. -- Моб 131048 выдает Фермерское ополчение (52750) и Воздушный налет (49737)
  10. (131048, 52750, 0, 6),
  11. (131048, 49737, 0, 6),
  12. -- Моб 142393 выдает Облегчить боль (52787)
  13. (142393, 52787, 0, 6),
  14. -- Моб 131654 выдает Кошка на раскаленной медной крыше (49757)
  15. (131654, 49757, 0, 6);
  16.  
  17. DELETE FROM `quest_template_addon`
  18. WHERE `ID` IN (52750, 49737, 52787, 49757);
  19. INSERT INTO `quest_template_addon` (`ID`, `MaxLevel`, `AllowableClasses`, `SourceSpellID`, `PrevQuestID`, `NextQuestID`, `ExclusiveGroup`, `RewardMailTemplateID`, `RequiredSkillID`, `RequiredSkillPoints`, `RequiredMinRepFaction`, `RequiredMaxRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepValue`, `ProvidedItemCount`, `SpecialFlags`, `MaxExpansion`, `MinExpansion`) VALUES
  20. (52750, 0, 0, 0, 49869, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6),
  21. (49737, 0, 0, 0, 49869, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6),
  22. (52787, 0, 0, 0, 49869, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6),
  23. (49757, 0, 0, 0, 49869, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6);
  24.  
  25. DELETE FROM `vehicle_attachment_offset` WHERE `entry` IN (130703,131665);
  26. INSERT INTO `vehicle_attachment_offset` (`entry`, `seat_id`, `offsetX`, `offsetY`, `offsetZ`, `offsetO`, `description`) VALUES
  27. (130703, 0, 0.45, 0.1, -0.55, 3.14159, ''),
  28. (131665, 0, 0.45, 0.1, -0.55, 3.14159, '');
  29.  
  30.  
  31. DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (130703,131665);
  32. INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`, `add_npc_flag`) VALUES
  33. (130703, 258668, 1, 0, 1),
  34. (131665, 259768, 1, 0, 1);
  35.  
  36. -- конд на спеллклик по квесту только
  37. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 18 AND `SourceGroup` IN (130703,131665) AND `SourceEntry` IN (258668,259768);
  38. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`, `MaxExpansion`, `MinExpansion`) VALUES
  39. (18, 130703, 258668, 0, 0, 9, 0, 49757, 0, 0, 0, 0, '', 'Required quest active for spellclick', 0, 6),
  40. (18, 131665, 259768, 0, 0, 9, 0, 49757, 0, 0, 0, 0, '', 'Required quest active for spellclick', 0, 6);
  41.  
  42. UPDATE `creature_template` SET `dynamicflags` = 0, `InhabitType` = 7 WHERE `entry` IN (131665,130703);
  43.  
  44. UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 72587;
  45. DELETE FROM `smart_scripts` WHERE `entryorguid` IN (-849539,-849696) AND `source_type` = 0;
  46. 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`, `target_type`, `comment`) VALUES
  47. (-849539, 0, 0, 0, 1, 0, 100, 0, 7000, 9000, 7000, 9000, 11, 259763, 0, 0, 0, 1, 'OOC - CAST'),
  48. (-849696, 0, 0, 0, 1, 0, 100, 0, 7000, 9000, 7000, 9000, 11, 259763, 0, 0, 0, 1, 'OOC - CAST');
  49.  
  50. -- триггер обломков
  51. DELETE FROM `spell_linked_spell` WHERE `spell_trigger` = 259763 AND `spell_effect` = 259766;
  52. INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `caster`, `target`, `hastype`, `hastalent`, `hasparam`, `hastype2`, `hastalent2`, `hasparam2`, `chance`, `cooldown`, `duration`, `hitmask`, `removeMask`, `effectMask`, `targetCountType`, `targetCount`, `actiontype`, `group`, `param`, `randList`, `comment`, `MaxExpansion`, `MinExpansion`) VALUES
  53. (259763, 259766, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, '', '', 0, 6);
  54.  
  55. DELETE FROM `spell_scripts` WHERE `id` = 92678;
  56. INSERT INTO `spell_scripts` (`id`, `effIndex`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES
  57. (92678, 0, 0, 14, 258668, 0, 0, 0, 0, 0, 0);
  58.  
  59. UPDATE `creature_template` SET `AIName` = 'SmartAI', `dynamicflags` = 0 WHERE `entry` = 130746;
  60. DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` = 130746;
  61. INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`, `add_npc_flag`) VALUES
  62. (130746, 258717, 1, 0, 1);
  63.  
  64. -- конд на спеллклик по квесту только
  65. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 18 AND `SourceGroup` IN (130746) AND `SourceEntry` IN (258717);
  66. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`, `MaxExpansion`, `MinExpansion`) VALUES
  67. (18, 130746, 258717, 0, 0, 9, 0, 49757, 0, 0, 0, 0, '', 'Required quest active for spellclick', 0, 6);
  68.  
  69. DELETE FROM `smart_scripts` WHERE `entryorguid` IN (130746) AND `source_type` = 0;
  70. 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_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `action_param_float`, `action_delay`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  71. (130746, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 4156, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'SAY - WHEN SUMM'),
  72. (130746, 0, 1, 0, 8, 0, 100, 0, 258717, 0, 0, 0, 0, 11, 258718, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'Spell HIT - CAST'),
  73. (130746, 0, 2, 0, 8, 0, 100, 0, 258717, 0, 0, 0, 0, 56, 155858, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'Spell HIT - CAST COND');
  74.  
  75.  
  76. DELETE FROM conditions WHERE SourceTypeOrReferenceId IN (22) AND SourceGroup IN (2,3) and SourceEntry IN (130746) AND SourceId = 0;
  77. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`, `MaxExpansion`, `MinExpansion`) VALUES
  78. (22, 2, 130746, 0, 0, 76, 0, 258718, 0, 0, 1, 0, '', '', 0, 6),
  79. (22, 3, 130746, 0, 0, 76, 0, 258718, 0, 0, 0, 0, '', '', 0, 6);
  80.  
  81. UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 131665;
  82. DELETE FROM `smart_scripts` WHERE `entryorguid` IN (131665) AND `source_type` = 0;
  83. 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_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `action_param_float`, `action_delay`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  84. (131665, 0, 0, 0, 25, 0, 100, 0, 0, 0, 0, 0, 0, 259, 0, 0, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, -718.197, 626.67, 61.8379, 6.04293, 'RESET - Leave Vehicle Coord');
  85.  
  86. UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 131654;
  87. DELETE FROM `smart_scripts` WHERE `entryorguid` IN (131654) AND `source_type` = 0;
  88. 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_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `action_param_float`, `action_delay`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  89. (131654, 0, 0, 1, 19, 0, 100, 4096, 49757, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'SAY - WHEN QUEST ACCEPTED'),
  90. (131654, 0, 1, 0, 61, 0, 100, 4096, 0, 0, 0, 0, 0, 220, 130746, 3, 7718, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, -720.648, 621.898, 58.5978, 1.58923, 'Link - Summ Pers Cat'),
  91. (131654, 0, 2, 0, 1, 0, 100, 4096, 15000, 45000, 15000, 45000, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'OOC SAY - WHEN QUEST NOT ACCEPTED'),
  92. (131654, 0, 3, 0, 1, 0, 100, 4096, 15000, 45000, 15000, 45000, 0, 1, 2, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'OOC SAY - WHEN QUEST ACCEPTED'),
  93. (131654, 0, 4, 0, 20, 0, 100, 4096, 49757, 0, 0, 0, 0, 80, 131654*100, 2, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'QREW - TS');
  94.  
  95. DELETE FROM conditions WHERE SourceTypeOrReferenceId IN (22) AND SourceGroup IN (3,4) and SourceEntry IN (131654) AND SourceId = 0;
  96. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`, `MaxExpansion`, `MinExpansion`) VALUES
  97. (22, 3, 131654, 0, 0, 92, 2, 49757, 1, 0, 0, 0, '', '', 0, 6),
  98. (22, 4, 131654, 0, 0, 92, 2, 49757, 8, 0, 0, 0, '', '', 0, 6);
  99.  
  100. DELETE FROM `creature_text` WHERE `Entry` = 131654;
  101. INSERT INTO `creature_text` (`Entry`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextID`, `MinTimer`, `MaxTimer`, `SpellID`, `AutoType`, `TextRange`, `comment`, `MaxExpansion`, `MinExpansion`) VALUES
  102. (131654, 0, 0, 'Держись, Царапка! Помощь уже в пути!!!', 14, 0, 100, 0, 0, 104795, 143893, 0, 0, 0, 0, 0, 'Мередит', 0, 6),
  103.  
  104. (131654, 1, 0, 'Цара-а-апка-а-а!!! Спускайся!!!', 14, 0, 100, 0, 0, 104798, 143890, 0, 0, 0, 0, 0, 'Мередит', 0, 6),
  105. (131654, 1, 1, 'Спускайся, Царапка, спускайся! Там опасно!', 14, 0, 100, 0, 0, 104800, 143892, 0, 0, 0, 0, 0, 'Мередит', 0, 6),
  106. (131654, 1, 2, 'Прыгай, Царапка! Я тебя поймаю!', 14, 0, 100, 0, 0, 104799, 143891, 0, 0, 0, 0, 0, 'Мередит', 0, 6),
  107.  
  108. (131654, 2, 0, 'Мы тебя спустим, Царапка! Только будь паинькой!', 14, 0, 100, 0, 0, 104802, 143898, 0, 0, 0, 0, 0, 'Мередит', 0, 6),
  109. (131654, 2, 1, 'Все будет хорошо, Царапка! Держись там!', 14, 0, 100, 0, 0, 104801, 143897, 0, 0, 0, 0, 0, 'Мередит', 0, 6),
  110. (131654, 2, 2, 'Цара-а-апка-а! Ты еще там?! Мяукни дважды, если меня слышишь!!!', 14, 0, 100, 0, 0, 104803, 143900, 0, 0, 0, 0, 0, 'Мередит', 0, 6),
  111.  
  112. (131654, 3, 0, 'Ура! Спасибо!', 12, 0, 100, 0, 0, 104796, 143978, 0, 0, 0, 0, 0, 'Мередит', 0, 6),
  113. (131654, 4, 0, 'За мной, Царапка, пошли!', 12, 0, 100, 0, 0, 104797, 143979, 0, 0, 0, 0, 0, 'Мередит', 0, 6);
  114.  
  115. DELETE FROM `creature_text` WHERE `Entry` = 130746;
  116. INSERT INTO `creature_text` (`Entry`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextID`, `MinTimer`, `MaxTimer`, `SpellID`, `AutoType`, `TextRange`, `comment`, `MaxExpansion`, `MinExpansion`) VALUES
  117. (130746, 0, 0, 'Мрр-мяу!', 14, 0, 100, 0, 0, 116618, 143894, 0, 0, 0, 0, 0, 'Царапка to Player', 0, 6);
  118.  
  119. UPDATE `creature_template` SET `speed_run` = 1, `speed_fly` = 1 WHERE `entry` = 131654;
  120. DELETE FROM `smart_scripts` WHERE `entryorguid` = 131654*100 AND `source_type` = 9;
  121. 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_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `action_param_float`, `action_delay`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  122. (131654*100, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 220, 131654, 3, 14594, 0, 0, 1, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'СУММ'), -- СУММ),
  123. (131654*100, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 220, 131692, 3, 14594, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, -729.6007, 639.1823, 39.347057, 0.902521848678588867, 'СУММ'), -- СУММ),
  124. (131654*100, 9, 2, 0, 0, 0, 100, 0, 2187, 2187, 0, 0, 0, 1, 3, 0, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'Ура! Спасибо!'), -- Ура! Спасибо!),
  125. (131654*100, 9, 3, 0, 0, 0, 100, 0, 3641, 3641, 0, 0, 0, 1, 4, 0, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'За мной, Царапка, пошли!'), -- За мной, Царапка, пошли!),
  126. (131654*100, 9, 4, 0, 0, 0, 100, 0, 1078, 1078, 0, 0, 0, 53, 1, 131654, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'идёт'); -- идёт);
  127.  
  128. DELETE FROM `creature` WHERE `guid` = 849445; -- суммоном идёт, не нужен в спавнах
  129. DELETE FROM `waypoints` WHERE `entry` = 131654;
  130. INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES
  131. (131654, 0, -723.4132, 646.0347, 39.554665, ''),
  132. (131654, 1, -722.72107, 646.72833, 39.294342, ''),
  133. (131654, 2, -718.3744, 650.73395, 39.19033, ''),
  134. (131654, 3, -716.3744, 652.73395, 38.94033, ''),
  135. (131654, 4, -715.6244, 653.23395, 38.94033, ''),
  136. (131654, 5, -713.6244, 653.73395, 38.69033, ''),
  137. (131654, 6, -710.6244, 654.23395, 38.44033, ''),
  138. (131654, 7, -709.6244, 654.23395, 38.19033, ''),
  139. (131654, 8, -707.8744, 654.48395, 37.94033, ''),
  140. (131654, 9, -706.8744, 654.73395, 37.94033, ''),
  141. (131654, 10, -706.5473, 654.80676, 37.660187, ''),
  142. (131654, 11, -705.7268, 655.0137, 37.659264, ''),
  143. (131654, 12, -704.7268, 655.0137, 37.659264, ''),
  144. (131654, 13, -702.7268, 655.2637, 37.409264, ''),
  145. (131654, 14, -701.7268, 655.5137, 37.159264, ''),
  146. (131654, 15, -699.7268, 655.7637, 36.659264, ''),
  147. (131654, 16, -695.7268, 656.5137, 36.409264, ''),
  148. (131654, 17, -694.2268, 656.7637, 36.159264, ''),
  149. (131654, 18, -693.4768, 656.0137, 35.909264, ''),
  150. (131654, 19, -692.2268, 654.5137, 35.409264, ''),
  151. (131654, 20, -691.4768, 653.7637, 35.159264, ''),
  152. (131654, 21, -691.2268, 653.0137, 34.909264, ''),
  153. (131654, 22, -689.7268, 651.5137, 34.659264, ''),
  154. (131654, 23, -688.9768, 650.7637, 34.409264, ''),
  155. (131654, 24, -687.7268, 649.5137, 34.159264, ''),
  156. (131654, 25, -686.9768, 648.7637, 33.659264, ''),
  157. (131654, 26, -685.7268, 647.2637, 33.409264, ''),
  158. (131654, 27, -684.2268, 646.0137, 33.159264, ''),
  159. (131654, 28, -682.9768, 644.5137, 32.659264, ''),
  160. (131654, 29, -682.2268, 643.7637, 32.159264, ''),
  161. (131654, 30, -680.9768, 642.2637, 31.909264, ''),
  162. (131654, 31, -680.2268, 641.5137, 31.409264, ''),
  163. (131654, 32, -678.9768, 640.2637, 30.909264, ''),
  164. (131654, 33, -677.4768, 638.7637, 29.909264, ''),
  165. (131654, 34, -676.40625, 637.2205, 29.158339, '');
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!