API tools faq
paste
frenado05

Untitled

frenado05
Jul 28th, 2026
10
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 72.87 KB | None | 0 0
raw download clone embed print report
  1. -- Красногорье доработки
  2.  
  3. UPDATE `creature` SET `PhaseId` = '2000' WHERE `guid` = 37999;
  4. UPDATE `creature` SET `position_x` = -9277.4296875, `position_y` = -2240.889892578125, `position_z` = 64.115936279296875, `orientation` = 5.06145477294921875 WHERE `guid` = 355988;
  5. DELETE FROM `creature` WHERE `id` IN (382) AND `PhaseId` = '1009';
  6. INSERT INTO `creature` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `spawnDifficulties`, `phaseMask`, `PhaseId`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `wander_distance`, `currentwaypoint`, `MovementType`, `randomMoveType`, `randomMoveMinTimer`, `randomMoveMaxTimer`, `ScriptName`, `npcflag`, `npcflag2`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `isActive`, `personal_size`, `isTeemingSpawn`, `MiscData`, `GroupID`, `inhabitType`, `id_alliance`, `id_horde`, `VerifiedBuild`, `Comment`, `MaxExpansion`, `MinExpansion`) VALUES
  7. (382, 0, 0, 0, 1, '', 1, '1009', 0, 0, -9276.96, -2242.86, 64.1778, 1.13446, 120, 0, 0, 0, 0, 1, 500, 3500, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 68887, '', 0, 3);
  8.  
  9. DELETE FROM `phase_definitions` WHERE `zoneId` = 44 AND `entry` = 2003;
  10. INSERT INTO `phase_definitions` (`zoneId`, `entry`, `phasemask`, `phaseId`, `areaIds`, `VisibleMapID`, `UiWorldMapAreaID`, `PreloadMapID`, `flags`, `comment`, `MaxExpansion`, `MinExpansion`) VALUES
  11. (44, 2003, 0, '2003', '', 0, 0, 0, 16, 'Q26563', 0, 3);
  12.  
  13. DELETE FROM conditions WHERE SourceTypeOrReferenceId IN (23) AND SourceGroup IN (44) and SourceEntry IN (2003);
  14. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`, `MaxExpansion`, `MinExpansion`) VALUES
  15. (23, 44, 2003, 0, 0, 92, 0, 26563, 64, 0, 0, 0, '', 'Phase Q26563', 0, 3),
  16. (23, 44, 2003, 0, 0, 92, 0, 26616, 1, 0, 0, 0, '', 'Phase Q26563', 0, 3);
  17.  
  18. DELETE FROM `phase_definitions` WHERE `zoneId` = 44 AND `entry` = 2004;
  19. INSERT INTO `phase_definitions` (`zoneId`, `entry`, `phasemask`, `phaseId`, `areaIds`, `VisibleMapID`, `UiWorldMapAreaID`, `PreloadMapID`, `flags`, `comment`, `MaxExpansion`, `MinExpansion`) VALUES
  20. (44, 2004, 0, '2004', '', 0, 0, 0, 16, 'Q26563 Phase 2', 0, 3);
  21.  
  22. DELETE FROM conditions WHERE SourceTypeOrReferenceId IN (23) AND SourceGroup IN (44) and SourceEntry IN (2004);
  23. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`, `MaxExpansion`, `MinExpansion`) VALUES
  24. (23, 44, 2004, 0, 0, 92, 0, 26563, 64, 0, 1, 0, '', 'Phase Q26563 Phase 2', 0, 3);
  25.  
  26. UPDATE `creature` SET `PhaseId` = '2004' WHERE `guid` IN (
  27. 37837, 37839, 37840, 37841, 37842, 37843, 37844, 37845, 37846, 37847,
  28. 37848, 37850, 37851, 37852, 37855, 37856, 37832, 37833, 37835, 37836
  29. );
  30.  
  31. UPDATE `creature_template_addon` SET `VisFlags` = 0, `auras` = '' WHERE `entry` = 43249;
  32. UPDATE `creature_template_addon` SET `VisFlags` = 0, `auras` = '' WHERE `entry` = 43248;
  33.  
  34. DELETE FROM `creature` WHERE `guid` IN (39651, 39652, 39653, 39654, 39655, 39656);
  35. INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `spawnDifficulties`, `phaseMask`, `PhaseId`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `wander_distance`, `currentwaypoint`, `MovementType`, `randomMoveType`, `randomMoveMinTimer`, `randomMoveMaxTimer`, `ScriptName`, `npcflag`, `npcflag2`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `isActive`, `personal_size`, `isTeemingSpawn`, `MiscData`, `GroupID`, `inhabitType`, `id_alliance`, `id_horde`, `VerifiedBuild`, `Comment`, `MaxExpansion`, `MinExpansion`) VALUES
  36. (39656, 43248, 0, 44, 69, 1, '', 1, '2003', 0, 0, -9202, -2155.81, 57.2699, 1.53589, 120, 0, 0, 0, 0, 1, 500, 3500, '', 0, 0, 33587520, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 68887, '', 0, 3),
  37. (39655, 43435, 0, 44, 69, 1, '', 1, '2003', 0, 0, -9199.89, -2156.77, 57.2691, 2.74017, 120, 0, 0, 0, 0, 1, 500, 3500, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 68887, '', 0, 3),
  38. (39654, 43184, 0, 44, 69, 1, '', 1, '2003', 0, 0, -9201.46, -2155.63, 57.2699, 0.401426, 120, 0, 0, 0, 0, 1, 500, 3500, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 68887, '', 0, 3),
  39. (39653, 43434, 0, 44, 69, 1, '', 1, '2003', 0, 0, -9200.21, -2153.62, 57.269, 4.04916, 120, 0, 0, 0, 0, 1, 500, 3500, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 68887, '', 0, 3),
  40. (39652, 43433, 0, 44, 69, 1, '', 1, '2003', 0, 0, -9201.71, -2153.14, 57.2694, 4.66003, 120, 0, 0, 0, 0, 1, 500, 3500, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 68887, '', 0, 3),
  41. (39651, 43432, 0, 44, 69, 1, '', 1, '2003', 0, 0, -9200.94, -2157.94, 57.2693, 2.14675, 120, 0, 0, 0, 0, 1, 500, 3500, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 68887, '', 0, 3);
  42.  
  43. DELETE FROM `creature_addon` WHERE `guid` IN (39651, 39652, 39653, 39654, 39655, 39656);
  44. INSERT INTO `creature_addon` (`guid`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`) VALUES
  45. (39651, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- 43432
  46. (39652, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- 43433
  47. (39653, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- 43434
  48. (39654, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- 43184
  49. (39655, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- 43435
  50. (39656, 0, 7, 0, 1, 0, 0, 0, 0, 0, 0, ''); -- 43248
  51.  
  52. DELETE FROM `creature_action` WHERE `entry` = 43248 AND `target` = 43184 AND `type` = 0;
  53. DELETE FROM `creature_action` WHERE `entry` = -37882 AND `target` = 43184 AND `type` = 0;
  54. DELETE FROM `creature_action` WHERE `entry` = 43184 AND `target` = 43248 AND `type` = 0;
  55. DELETE FROM `creature_action` WHERE `entry` = 43249 AND `target` = 43248 AND `type` = 0;
  56. DELETE FROM `creature_action` WHERE `entry` = 43184 AND `target` = -37882 AND `type` = 0;
  57.  
  58. -- визуал атаки
  59.  
  60. DELETE FROM `creature_action` WHERE `entry` IN (-37853, -37857);
  61. INSERT INTO `creature_action` (`entry`, `target`, `type`, `spellId`, `action`) VALUES
  62. (-37853, -37857, 0, 0, 0),
  63. (-37857, -37853, 0, 0, 0);
  64.  
  65. DELETE FROM `phase_definitions` WHERE `zoneId` = 44 AND `entry` = 2005;
  66. INSERT INTO `phase_definitions` (`zoneId`, `entry`, `phasemask`, `phaseId`, `areaIds`, `VisibleMapID`, `UiWorldMapAreaID`, `PreloadMapID`, `flags`, `comment`, `MaxExpansion`, `MinExpansion`) VALUES
  67. (44, 2005, 0, '2005', '', 0, 0, 0, 16, 'Q26545', 0, 3);
  68.  
  69. DELETE FROM conditions WHERE SourceTypeOrReferenceId IN (23) AND SourceGroup IN (44) and SourceEntry IN (2005);
  70. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`, `MaxExpansion`, `MinExpansion`) VALUES
  71. (23, 44, 2005, 0, 0, 92, 0, 26545, 64, 0, 1, 0, '', 'Phase Q26545', 0, 3);
  72.  
  73. -- Дампи + Большой граф
  74.  
  75. UPDATE `creature` SET `PhaseId` = '2005' WHERE `guid` IN (37853,37857);
  76.  
  77. DELETE FROM `creature_addon` WHERE `guid` IN (225601,37882);
  78. INSERT INTO `creature_addon` (`guid`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvPFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`) VALUES
  79. (225601, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, NULL),
  80. (37882, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, NULL);
  81.  
  82. -- визуал атаки
  83.  
  84. DELETE FROM `creature_action` WHERE `entry` IN (-225601, -37882);
  85. INSERT INTO `creature_action` (`entry`, `target`, `type`, `spellId`, `action`) VALUES
  86. (-225601, -37882, 0, 0, 0),
  87. (-37882, -225601, 0, 0, 0);
  88.  
  89. DELETE FROM `phase_definitions` WHERE `zoneId` = 44 AND `entry` = 2006;
  90. INSERT INTO `phase_definitions` (`zoneId`, `entry`, `phasemask`, `phaseId`, `areaIds`, `VisibleMapID`, `UiWorldMapAreaID`, `PreloadMapID`, `flags`, `comment`, `MaxExpansion`, `MinExpansion`) VALUES
  91. (44, 2006, 0, '2006', '', 0, 0, 0, 16, 'Q26545 Phase 2', 0, 3);
  92.  
  93. DELETE FROM conditions WHERE SourceTypeOrReferenceId IN (23) AND SourceGroup IN (44) and SourceEntry IN (2006);
  94. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`, `MaxExpansion`, `MinExpansion`) VALUES
  95. (23, 44, 2006, 0, 0, 92, 0, 26545, 64, 0, 0, 0, '', 'Phase Q26545 Phase 2', 0, 3),
  96. (23, 44, 2006, 0, 0, 92, 0, 26563, 64, 0, 1, 0, '', 'Phase Q26545 Phase 2', 0, 3);
  97.  
  98. -- Кишан и Граф
  99.  
  100. UPDATE `creature` SET `PhaseId` = '2006' WHERE `guid` IN (225601,37882);
  101.  
  102. UPDATE `creature_template` SET `AIName` = 'SmartAI', `RegenHealth` = 0 WHERE `entry` IN (43249,43248);
  103. DELETE FROM `smart_scripts` WHERE `entryorguid` IN (-37853,-37857,-37882,-225601) AND `source_type` = 0;
  104. 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
  105. (-37853, 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 0, 224, 85, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'set HP%'),
  106. (-37857, 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 0, 224, 85, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'set HP%'),
  107.  
  108. (-37882, 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 0, 224, 85, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'set HP%'),
  109. (-225601, 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 0, 224, 85, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'set HP%');
  110.  
  111. -- оффайл скорость лодки + условия
  112. UPDATE `creature_template` SET `speed_run` = 2 WHERE `entry` = 43450;
  113. UPDATE `conditions` SET `ConditionTypeOrReference` = 92, `ConditionValue2` = 10 WHERE `SourceTypeOrReferenceId` = 23 AND `SourceGroup` = 44 AND `SourceEntry` = 10 AND `SourceId` = 0 AND `ElseGroup` = 0 AND `ConditionTypeOrReference` = 9 AND `ConditionTarget` = 0 AND `ConditionValue1` = 26616 AND `ConditionValue2` = 0 AND `ConditionValue3` = 0 AND `MaxExpansion` = 0 AND `MinExpansion` = 3;
  114. UPDATE `conditions` SET `ConditionTypeOrReference` = 92, `ConditionValue2` = 10 WHERE `SourceTypeOrReferenceId` = 18 AND `SourceGroup` = 43443 AND `SourceEntry` = 81243 AND `SourceId` = 0 AND `ElseGroup` = 0 AND `ConditionTypeOrReference` = 9 AND `ConditionTarget` = 0 AND `ConditionValue1` = 26616 AND `ConditionValue2` = 0 AND `ConditionValue3` = 0 AND `MaxExpansion` = 0 AND `MinExpansion` = 4;
  115.  
  116. UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` IN (43222,43247);
  117. DELETE FROM `smart_scripts` WHERE `entryorguid` IN (
  118. -37837, -37839, -37840, -37841, -37842, -37843, -37844, -37845, -37846, -37847,
  119. -37848, -37850, -37851, -37852, -37855, -37856, -37832, -37833, -37835, -37836
  120. ) AND `source_type` = 0;
  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`, `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
  122. (-37837, 0, 0, 0, 1, 0, 100, 0, 5000, 10000, 4000, 8000, 10, 1, 4, 5, 6, 14, 15, 1, 0, 0, 0, 0, 0, 0, 0, 'GUID 37837 - OOC Random Emote 1/2'),
  123. (-37837, 0, 1, 0, 1, 0, 100, 0, 7000, 12000, 6000, 10000, 10, 22, 25, 53, 274, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'GUID 37837 - OOC Random Emote 2/2'),
  124.  
  125. (-37839, 0, 0, 0, 1, 0, 100, 0, 5000, 10000, 4000, 8000, 10, 1, 4, 5, 6, 14, 15, 1, 0, 0, 0, 0, 0, 0, 0, 'GUID 37839 - OOC Random Emote 1/2'),
  126. (-37839, 0, 1, 0, 1, 0, 100, 0, 7000, 12000, 6000, 10000, 10, 22, 25, 53, 274, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'GUID 37839 - OOC Random Emote 2/2'),
  127.  
  128. (-37840, 0, 0, 0, 1, 0, 100, 0, 5000, 10000, 4000, 8000, 10, 1, 4, 5, 6, 14, 15, 1, 0, 0, 0, 0, 0, 0, 0, 'GUID 37840 - OOC Random Emote 1/2'),
  129. (-37840, 0, 1, 0, 1, 0, 100, 0, 7000, 12000, 6000, 10000, 10, 22, 25, 53, 274, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'GUID 37840 - OOC Random Emote 2/2'),
  130.  
  131. (-37841, 0, 0, 0, 1, 0, 100, 0, 5000, 10000, 4000, 8000, 10, 1, 4, 5, 6, 14, 15, 1, 0, 0, 0, 0, 0, 0, 0, 'GUID 37841 - OOC Random Emote 1/2'),
  132. (-37841, 0, 1, 0, 1, 0, 100, 0, 7000, 12000, 6000, 10000, 10, 22, 25, 53, 274, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'GUID 37841 - OOC Random Emote 2/2'),
  133.  
  134. (-37842, 0, 0, 0, 1, 0, 100, 0, 5000, 10000, 4000, 8000, 10, 1, 4, 5, 6, 14, 15, 1, 0, 0, 0, 0, 0, 0, 0, 'GUID 37842 - OOC Random Emote 1/2'),
  135. (-37842, 0, 1, 0, 1, 0, 100, 0, 7000, 12000, 6000, 10000, 10, 22, 25, 53, 274, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'GUID 37842 - OOC Random Emote 2/2'),
  136.  
  137. (-37843, 0, 0, 0, 1, 0, 100, 0, 5000, 10000, 4000, 8000, 10, 1, 4, 5, 6, 14, 15, 1, 0, 0, 0, 0, 0, 0, 0, 'GUID 37843 - OOC Random Emote 1/2'),
  138. (-37843, 0, 1, 0, 1, 0, 100, 0, 7000, 12000, 6000, 10000, 10, 22, 25, 53, 274, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'GUID 37843 - OOC Random Emote 2/2'),
  139.  
  140. (-37844, 0, 0, 0, 1, 0, 100, 0, 5000, 10000, 4000, 8000, 10, 1, 4, 5, 6, 14, 15, 1, 0, 0, 0, 0, 0, 0, 0, 'GUID 37844 - OOC Random Emote 1/2'),
  141. (-37844, 0, 1, 0, 1, 0, 100, 0, 7000, 12000, 6000, 10000, 10, 22, 25, 53, 274, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'GUID 37844 - OOC Random Emote 2/2'),
  142.  
  143. (-37845, 0, 0, 0, 1, 0, 100, 0, 5000, 10000, 4000, 8000, 10, 1, 4, 5, 6, 14, 15, 1, 0, 0, 0, 0, 0, 0, 0, 'GUID 37845 - OOC Random Emote 1/2'),
  144. (-37845, 0, 1, 0, 1, 0, 100, 0, 7000, 12000, 6000, 10000, 10, 22, 25, 53, 274, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'GUID 37845 - OOC Random Emote 2/2'),
  145.  
  146. (-37846, 0, 0, 0, 1, 0, 100, 0, 5000, 10000, 4000, 8000, 10, 1, 4, 5, 6, 14, 15, 1, 0, 0, 0, 0, 0, 0, 0, 'GUID 37846 - OOC Random Emote 1/2'),
  147. (-37846, 0, 1, 0, 1, 0, 100, 0, 7000, 12000, 6000, 10000, 10, 22, 25, 53, 274, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'GUID 37846 - OOC Random Emote 2/2'),
  148.  
  149. (-37847, 0, 0, 0, 1, 0, 100, 0, 5000, 10000, 4000, 8000, 10, 1, 4, 5, 6, 14, 15, 1, 0, 0, 0, 0, 0, 0, 0, 'GUID 37847 - OOC Random Emote 1/2'),
  150. (-37847, 0, 1, 0, 1, 0, 100, 0, 7000, 12000, 6000, 10000, 10, 22, 25, 53, 274, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'GUID 37847 - OOC Random Emote 2/2'),
  151.  
  152. (-37848, 0, 0, 0, 1, 0, 100, 0, 5000, 10000, 4000, 8000, 10, 1, 4, 5, 6, 14, 15, 1, 0, 0, 0, 0, 0, 0, 0, 'GUID 37848 - OOC Random Emote 1/2'),
  153. (-37848, 0, 1, 0, 1, 0, 100, 0, 7000, 12000, 6000, 10000, 10, 22, 25, 53, 274, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'GUID 37848 - OOC Random Emote 2/2'),
  154.  
  155. (-37850, 0, 0, 0, 1, 0, 100, 0, 5000, 10000, 4000, 8000, 10, 1, 4, 5, 6, 14, 15, 1, 0, 0, 0, 0, 0, 0, 0, 'GUID 37850 - OOC Random Emote 1/2'),
  156. (-37850, 0, 1, 0, 1, 0, 100, 0, 7000, 12000, 6000, 10000, 10, 22, 25, 53, 274, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'GUID 37850 - OOC Random Emote 2/2'),
  157.  
  158. (-37851, 0, 0, 0, 1, 0, 100, 0, 5000, 10000, 4000, 8000, 10, 1, 4, 5, 6, 14, 15, 1, 0, 0, 0, 0, 0, 0, 0, 'GUID 37851 - OOC Random Emote 1/2'),
  159. (-37851, 0, 1, 0, 1, 0, 100, 0, 7000, 12000, 6000, 10000, 10, 22, 25, 53, 274, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'GUID 37851 - OOC Random Emote 2/2'),
  160.  
  161. (-37852, 0, 0, 0, 1, 0, 100, 0, 5000, 10000, 4000, 8000, 10, 1, 4, 5, 6, 14, 15, 1, 0, 0, 0, 0, 0, 0, 0, 'GUID 37852 - OOC Random Emote 1/2'),
  162. (-37852, 0, 1, 0, 1, 0, 100, 0, 7000, 12000, 6000, 10000, 10, 22, 25, 53, 274, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'GUID 37852 - OOC Random Emote 2/2'),
  163.  
  164. (-37855, 0, 0, 0, 1, 0, 100, 0, 5000, 10000, 4000, 8000, 10, 1, 4, 5, 6, 14, 15, 1, 0, 0, 0, 0, 0, 0, 0, 'GUID 37855 - OOC Random Emote 1/2'),
  165. (-37855, 0, 1, 0, 1, 0, 100, 0, 7000, 12000, 6000, 10000, 10, 22, 25, 53, 274, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'GUID 37855 - OOC Random Emote 2/2'),
  166.  
  167. (-37856, 0, 0, 0, 1, 0, 100, 0, 5000, 10000, 4000, 8000, 10, 1, 4, 5, 6, 14, 15, 1, 0, 0, 0, 0, 0, 0, 0, 'GUID 37856 - OOC Random Emote 1/2'),
  168. (-37856, 0, 1, 0, 1, 0, 100, 0, 7000, 12000, 6000, 10000, 10, 22, 25, 53, 274, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'GUID 37856 - OOC Random Emote 2/2'),
  169.  
  170. (-37832, 0, 0, 0, 1, 0, 100, 0, 5000, 10000, 4000, 8000, 10, 1, 4, 5, 6, 14, 15, 1, 0, 0, 0, 0, 0, 0, 0, 'GUID 37832 - OOC Random Emote 1/2'),
  171. (-37832, 0, 1, 0, 1, 0, 100, 0, 7000, 12000, 6000, 10000, 10, 22, 25, 53, 274, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'GUID 37832 - OOC Random Emote 2/2'),
  172.  
  173. (-37833, 0, 0, 0, 1, 0, 100, 0, 5000, 10000, 4000, 8000, 10, 1, 4, 5, 6, 14, 15, 1, 0, 0, 0, 0, 0, 0, 0, 'GUID 37833 - OOC Random Emote 1/2'),
  174. (-37833, 0, 1, 0, 1, 0, 100, 0, 7000, 12000, 6000, 10000, 10, 22, 25, 53, 274, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'GUID 37833 - OOC Random Emote 2/2'),
  175.  
  176. (-37835, 0, 0, 0, 1, 0, 100, 0, 5000, 10000, 4000, 8000, 10, 1, 4, 5, 6, 14, 15, 1, 0, 0, 0, 0, 0, 0, 0, 'GUID 37835 - OOC Random Emote 1/2'),
  177. (-37835, 0, 1, 0, 1, 0, 100, 0, 7000, 12000, 6000, 10000, 10, 22, 25, 53, 274, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'GUID 37835 - OOC Random Emote 2/2'),
  178.  
  179. (-37836, 0, 0, 0, 1, 0, 100, 0, 5000, 10000, 4000, 8000, 10, 1, 4, 5, 6, 14, 15, 1, 0, 0, 0, 0, 0, 0, 0, 'GUID 37836 - OOC Random Emote 1/2'),
  180. (-37836, 0, 1, 0, 1, 0, 100, 0, 7000, 12000, 6000, 10000, 10, 22, 25, 53, 274, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'GUID 37836 - OOC Random Emote 2/2');
  181.  
  182. -- коррект к итему
  183.  
  184. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 30 AND `SourceGroup` = 1 AND `SourceEntry` = 58898;
  185. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`, `MaxExpansion`, `MinExpansion`) VALUES
  186. (30, 1, 58898, 0, 0, 92, 0, 26512, 64, 0, 0, 0, '', NULL, 0, 3);
  187.  
  188. -- [12:32:31] Quest rewarded: Они первые пролили кровь (ID: 26607)
  189. -- [12:32:41] Название квеста: Ни конца ни края (ID: 26616)
  190. -- [12:32:41] Джон Джей Кишан говорит: Похоже, нам нужно выиграть войну.
  191. -- [12:32:41] Данфорт говорит: ПОЗНАЙ БОЛЬ!
  192. -- [12:32:43] Кракауер говорит: ДЖОННИ ВЕРНУЛСЯ, ДЕТКА! ЙЕ-Е-Е!
  193. -- появляется ещё один джони но уже в экипировке
  194.  
  195. -- http://wowhead.com/ru/quest=26545 "Изувой должен умереть!" тс прикольный + после него появляется 43184 нпц наши гуиды 37882 и 225601
  196.  
  197. -- HF UPDATE `broadcast_text_locale` SET `Text_lang` = 'Надежда есть, Соломон.' WHERE `ID` = 43264 AND `locale` = 'ruRU';
  198.  
  199. DELETE FROM `creature_text` WHERE `Entry` IN (344,43221);
  200. INSERT INTO `creature_text` (`Entry`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
  201. (344, 0, 0, 'Нам конец! С тем же успехом мы могли бы сбежать из Приозерья, расчистив путь для орков.', 12, 7, 100, 6, 0, 0, 43262, 0, 'Мировой судья Соломон to Player'),
  202. (344, 1, 0, 'Как раз тогда, когда мы только закончили строить проклятый мост! На что надеяться, $n?', 12, 7, 100, 1, 0, 0, 43263, 0, 'Мировой судья Соломон to Player'),
  203. (344, 2, 0, 'Какая надежда, полковник? Что может спасти нас от неминуемого нападения?', 12, 7, 100, 6, 0, 0, 43265, 0, 'Мировой судья Соломон to Player'),
  204. (344, 3, 0, 'Кишан жив? Я думал, что он умер.', 12, 7, 100, 6, 0, 0, 43270, 0, 'Мировой судья Соломон to Player'),
  205.  
  206. (43221, 0, 0, 'Надежда есть, Соломон.', 12, 7, 100, 1, 0, 0, 43264, 0, 'Полковник Тротман to Player'),
  207. (43221, 1, 0, 'За время Первой, Второй и Третьей войн он был на дежурстве 248 раз.', 12, 7, 100, 1, 0, 0, 43266, 0, 'Полковник Тротман to Player'),
  208. (43221, 2, 0, 'Пять лет назад его захватил в плен батальон грязных свиноподобных орков Черной горы, буквально в паре шагов от южной демилитаризованной зоны.', 12, 7, 100, 1, 0, 0, 43267, 0, 'Полковник Тротман to Player'),
  209. (43221, 3, 0, 'Его пытали, но не до смерти, чтобы молодые воины орков могли мочиться на него. В течение ПЯТИ ЛЕТ.', 12, 7, 100, 1, 0, 0, 43268, 0, 'Полковник Тротман to Player'),
  210. (43221, 4, 0, 'Джон Джей Кишан.', 12, 7, 100, 5, 0, 0, 43269, 0, 'Полковник Тротман to Player'),
  211. (43221, 5, 0, 'Он по-прежнему жив, живет изгнанником в Приозерье уже пять месяцев. Или ты не $gзаметил:заметила;? Ладно, хватит болтать. Нам есть кого спасать!', 12, 7, 100, 25, 0, 0, 43271, 0, 'Полковник Тротман to Player');
  212.  
  213. UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` IN (344);
  214. DELETE FROM `smart_scripts` WHERE `entryorguid` = 344 AND `source_type` = 0;
  215. DELETE FROM `smart_scripts` WHERE `entryorguid` = 344*100 AND `source_type` = 9;
  216. 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
  217. (344, 0, 0, 0, 20, 0, 100, 0, 26545, 80000, 80000, 0, 0, 80, 344*100, 2, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'QREW - TS'),
  218.  
  219. (344*100, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'TS - SAY LINE 0'),
  220. (344*100, 9, 1, 0, 0, 0, 100, 0, 7385, 7385, 0, 0, 0, 1, 1, 0, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'TS - SAY LINE 1'),
  221. (344*100, 9, 2, 0, 0, 0, 100, 0, 3546, 3546, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 0, 0, 19, 43221, 50, 0, 0, 0, 0, 0, 0, 'Data'),
  222. (344*100, 9, 3, 0, 0, 0, 100, 0, 3360, 3360, 0, 0, 0, 84, 0, 0, 7, 0, 0, 0, 0, 0, 19, 43221, 50, 0, 0, 0, 0, 0, 0, 'TS - SAY LINE 0'),
  223. (344*100, 9, 4, 0, 0, 0, 100, 0, 3131, 3131, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 0, 0, 19, 43221, 20, 0, 0, 0, 0, 0, 0, 'TS - Orient'),
  224. (344*100, 9, 5, 0, 0, 0, 100, 0, 121, 121, 0, 0, 0, 1, 2, 0, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'TS - SAY LINE 2'),
  225. (344*100, 9, 6, 0, 0, 0, 100, 0, 3202, 3202, 0, 0, 0, 84, 1, 0, 7, 0, 0, 0, 0, 0, 19, 43221, 50, 0, 0, 0, 0, 0, 0, 'TS - SAY LINE 1'),
  226. (344*100, 9, 7, 0, 0, 0, 100, 0, 5283, 5283, 0, 0, 0, 84, 2, 0, 7, 0, 0, 0, 0, 0, 19, 43221, 50, 0, 0, 0, 0, 0, 0, 'TS - SAY LINE 2'),
  227. (344*100, 9, 8, 0, 0, 0, 100, 0, 6089, 6089, 0, 0, 0, 84, 3, 0, 7, 0, 0, 0, 0, 0, 19, 43221, 50, 0, 0, 0, 0, 0, 0, 'TS - SAY LINE 3'),
  228. (344*100, 9, 9, 0, 0, 0, 100, 0, 6074, 6074, 0, 0, 0, 84, 4, 0, 7, 0, 0, 0, 0, 0, 19, 43221, 50, 0, 0, 0, 0, 0, 0, 'TS - SAY LINE 4'),
  229. (344*100, 9, 10, 0, 0, 0, 100, 0, 6084, 6084, 0, 0, 0, 1, 3, 0, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'TS - SAY LINE 3'),
  230. (344*100, 9, 11, 0, 0, 0, 100, 0, 5683, 5683, 0, 0, 0, 84, 5, 0, 7, 0, 0, 0, 0, 0, 19, 43221, 50, 0, 0, 0, 0, 0, 0, 'TS - SAY LINE 5'),
  231. (344*100, 9, 12, 0, 0, 0, 100, 0, 8778, 8778, 0, 0, 0, 45, 2, 2, 0, 0, 0, 0, 0, 0, 19, 43221, 50, 0, 0, 0, 0, 0, 0, 'Data'),
  232. (344*100, 9, 13, 0, 0, 0, 100, 0, 817, 817, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'TS - Orient Home');
  233.  
  234. DELETE FROM `smart_scripts` WHERE `entryorguid` = 43221 AND `source_type` = 0 AND `id` IN (4,5,6,7);
  235. 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
  236. (43221, 0, 4, 0, 38, 0, 100, 1, 1, 1, 0, 0, 0, 53, 0, 43221, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'WP'),
  237. (43221, 0, 5, 0, 40, 0, 100, 0, 3, 43221, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 0, 0, 19, 344, 20, 0, 0, 0, 0, 0, 0, 'WP REACH - Orient'),
  238. (43221, 0, 6, 0, 38, 0, 100, 1, 2, 2, 0, 0, 0, 53, 0, 4322100, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'WP'),
  239. (43221, 0, 7, 0, 40, 0, 100, 0, 4, 4322100, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'WP REACH - Orient');
  240.  
  241. DELETE FROM `waypoints` WHERE `entry` = 43221;
  242. INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES
  243. (43221, 0, -9212.8, -2215.6, 66.68602, ''),
  244. (43221, 1, -9213.8, -2216.35, 66.68602, ''),
  245. (43221, 2, -9213.8, -2219.85, 67.68602, ''),
  246. (43221, 3, -9214.88, -2221.35, 67.5393, '');
  247.  
  248. DELETE FROM `waypoints` WHERE `entry` = 4322100;
  249. INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES
  250. (4322100, 0, -9214.05, -2219.6, 67.93602, ''),
  251. (4322100, 1, -9213.55, -2218.85, 67.93602, ''),
  252. (4322100, 2, -9213.3, -2217.85, 67.18602, ''),
  253. (4322100, 3, -9212.55, -2216.35, 66.68602, ''),
  254. (4322100, 4, -9212.22, -2215.35, 66.33273, '');
  255.  
  256. -- http://wowhead.com/ru/quest=26616 "Ни конца ни края"
  257.  
  258. DELETE FROM `creature_text` WHERE `Entry` IN (43458,43459,43460,43461,43462);
  259. INSERT INTO `creature_text` (`Entry`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
  260. (43458, 0, 0, 'Данфорт, докладывай.', 12, 0, 100, 0, 0, 0, 43592, 0, 'Джон Джей Кишан to Player'),
  261. (43458, 1, 0, 'Кракауер?', 12, 0, 100, 0, 0, 0, 43594, 0, 'Джон Джей Кишан to Player'),
  262. (43458, 2, 0, 'Йоргенсен, что тебе известно о долине Ренда?', 12, 0, 100, 0, 0, 0, 43597, 0, 'Джон Джей Кишан to Player'),
  263. (43458, 3, 0, 'Смертельная ловушка, говоришь? Месснер, у меня есть план. Надо добыть чуток сефория.', 12, 0, 100, 0, 0, 0, 43599, 0, 'Джон Джей Кишан to Player'),
  264. (43458, 4, 0, 'Это не моя проблема, Месснер. Надо – и все.', 12, 0, 100, 0, 0, 0, 43601, 0, 'Джон Джей Кишан to Player'),
  265. (43458, 5, 0, '$n, собирай свои шмотки. Я посылаю тебя в поле.', 12, 0, 100, 0, 0, 0, 43602, 0, 'Джон Джей Кишан to Player'),
  266. (43459, 0, 0, 'Сефорий? И где, демон побери, я теперь достану сефорий, Джонни?', 12, 0, 100, 1, 0, 0, 43600, 0, 'Месснер to Player'),
  267. (43460, 0, 0, 'Орки Черной горы тут повсюду, Джонни. Одна большая башня в узком проходе и две халупы поменьше. Это смертельная ловушка.', 12, 0, 100, 1, 0, 0, 43598, 0, 'Йоргенсен to Player'),
  268. (43461, 0, 0, 'Всего две возможности пробраться к ним в тыл, Джонни. Три, если считать верную гибель.', 12, 0, 100, 1, 0, 0, 43595, 0, 'Кракауер to Player'),
  269. (43461, 1, 0, 'На север мимо лесопилки Альтера, но там придется пробиться через стаю кровожадных воргов, или на юг через Долину Ренда.', 12, 0, 100, 1, 0, 0, 43596, 0, 'Кракауер to Player'),
  270. (43462, 0, 0, 'Орки Черной горы взорвали мост, ведущий в крепость Каменной стражи. О наступлении с фронта не может быть и речи.', 12, 0, 100, 1, 0, 0, 43593, 0, 'Данфорт to Player');
  271.  
  272. DELETE FROM `phase_definitions` WHERE `zoneId` = 44 AND `entry` = 2007;
  273. INSERT INTO `phase_definitions` (`zoneId`, `entry`, `phasemask`, `phaseId`, `areaIds`, `VisibleMapID`, `UiWorldMapAreaID`, `PreloadMapID`, `flags`, `comment`, `MaxExpansion`, `MinExpansion`) VALUES
  274. (44, 2007, 0, '2007', '', 0, 0, 0, 16, 'Q26616', 0, 3);
  275.  
  276. DELETE FROM conditions WHERE SourceTypeOrReferenceId IN (23) AND SourceGroup IN (44) and SourceEntry IN (2007);
  277. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`, `MaxExpansion`, `MinExpansion`) VALUES
  278. (23, 44, 2007, 0, 0, 92, 0, 26616, 66, 0, 0, 0, '', 'Phase Q26616', 0, 3),
  279. (23, 44, 2007, 0, 0, 92, 0, 26651, 64, 0, 1, 0, '', 'Phase Q26616', 0, 3);
  280.  
  281. DELETE FROM `creature` WHERE `guid` IN (346412, 255728, 255729, 330647);
  282. INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `spawnDifficulties`, `phaseMask`, `PhaseId`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `wander_distance`, `currentwaypoint`, `MovementType`, `randomMoveType`, `randomMoveMinTimer`, `randomMoveMaxTimer`, `ScriptName`, `npcflag`, `npcflag2`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `isActive`, `personal_size`, `isTeemingSpawn`, `MiscData`, `GroupID`, `inhabitType`, `id_alliance`, `id_horde`, `VerifiedBuild`, `Comment`, `MaxExpansion`, `MinExpansion`) VALUES
  283. (330647, 43458, 0, 44, 5326, 1, '', 1, '2007', 0, 0, -9463.47, -2829.04, 65.3617, 2.02458, 120, 0, 0, 0, 0, 1, 500, 3500, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 68887, '', 0, 3),
  284. (346412, 43462, 0, 44, 5326, 1, '', 1, '2007', 0, 0, -9465.97, -2828.57, 65.3617, 0.663225, 120, 0, 0, 0, 0, 1, 500, 3500, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 68887, '', 0, 3),
  285. (255728, 43461, 0, 44, 5326, 1, '', 1, '2007', 0, 0, -9463.47, -2825.29, 65.3617, 4.17134, 120, 0, 0, 0, 0, 1, 500, 3500, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 68887, '', 0, 3),
  286. (255729, 43459, 0, 44, 5326, 1, '', 1, '2007', 0, 0, -9465.68, -2826.04, 65.3617, 5.46288, 120, 0, 0, 0, 0, 1, 500, 3500, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 68887, '', 0, 3);
  287.  
  288. DELETE FROM `creature_addon` WHERE `guid` IN (346412, 255728, 255729, 330647, 37956);
  289. INSERT INTO `creature_addon` (`guid`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`) VALUES
  290. (255729, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, ''), -- 43459 - 81266 - 81266
  291. (37956, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, ''), -- 43460 - 81496 - 81496
  292. (255728, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, ''), -- 43461 - 81266 - 81266
  293. (346412, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, ''), -- 43462 - 81266 - 81266
  294. (330647, 0, 8, 0, 0, 2, 0, 0, 0, 0, 0, '80642'); -- 43458 - 80642 - 80642, 81266 - 81266
  295.  
  296. UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 43458;
  297. DELETE FROM `smart_scripts` WHERE `entryorguid` = 43458 AND `source_type` = 0;
  298. DELETE FROM `smart_scripts` WHERE `entryorguid` = 43458*100 AND `source_type` = 9;
  299. 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
  300. (43458, 0, 0, 0, 79, 0, 100, 64, 5, 1, 0, 0, 0, 80, 43458*100, 2, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Range - TS'),
  301.  
  302. (43458*100, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'TS - SAY LINE 0 (Данфорт, докладывай.)'),
  303. (43458*100, 9, 1, 0, 0, 0, 100, 0, 3556, 3556, 0, 0, 0, 84, 0, 0, 7, 0, 0, 0, 0, 0, 19, 43462, 50, 0, 0, 0, 0, 0, 0, 'TS - SAY LINE 1 (Данфорт: Орки Черной горы...)'),
  304. (43458*100, 9, 2, 0, 0, 0, 100, 0, 9682, 9682, 0, 0, 0, 1, 1, 0, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'TS - SAY LINE 2 (Кракауер?)'),
  305. (43458*100, 9, 3, 0, 0, 0, 100, 0, 3687, 3687, 0, 0, 0, 84, 0, 0, 7, 0, 0, 0, 0, 0, 19, 43461, 50, 0, 0, 0, 0, 0, 0, 'TS - SAY LINE 3 (Кракауер: Всего две возможности...)'),
  306. (43458*100, 9, 4, 0, 0, 0, 100, 0, 9683, 9683, 0, 0, 0, 84, 1, 0, 7, 0, 0, 0, 0, 0, 19, 43461, 50, 0, 0, 0, 0, 0, 0, 'TS - SAY LINE 4 (Кракауер: На север мимо лесопилки...)'),
  307. (43458*100, 9, 5, 0, 0, 0, 100, 0, 9759, 9759, 0, 0, 0, 1, 2, 0, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'TS - SAY LINE 5 (Йоргенсен, что тебе известно...)'),
  308. (43458*100, 9, 6, 0, 0, 0, 100, 0, 6073, 6073, 0, 0, 0, 84, 0, 0, 7, 0, 0, 0, 0, 0, 19, 43460, 50, 0, 0, 0, 0, 0, 0, 'TS - SAY LINE 6 (Йоргенсен: Орки Черной горы тут повсюду...)'),
  309. (43458*100, 9, 7, 0, 0, 0, 100, 0, 9742, 9742, 0, 0, 0, 1, 3, 0, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'TS - SAY LINE 7 (Смертельная ловушка, говоришь?...)'),
  310. (43458*100, 9, 8, 0, 0, 0, 100, 0, 7331, 7331, 0, 0, 0, 84, 0, 0, 7, 0, 0, 0, 0, 0, 19, 43459, 50, 0, 0, 0, 0, 0, 0, 'TS - SAY LINE 8 (Месснер: Сефорий? И где...)'),
  311. (43458*100, 9, 9, 0, 0, 0, 100, 0, 8508, 8508, 0, 0, 0, 1, 4, 0, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'TS - SAY LINE 9 (Это не моя проблема, Месснер...)'),
  312. (43458*100, 9, 10, 0, 0, 0, 100, 0, 4727, 4727, 0, 0, 0, 1, 5, 0, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'TS - SAY LINE 10 ($n, собирай свои шмотки...)');
  313.  
  314. -- TS QUEST
  315. DELETE FROM conditions WHERE SourceTypeOrReferenceId IN (22) AND SourceGroup IN (1) and SourceEntry IN (43458) AND SourceId = 0;
  316. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`, `MaxExpansion`, `MinExpansion`) VALUES
  317. (22, 1, 43458, 0, 0, 92, 0, 26616, 2, 0, 0, 0, '', 'True If player have quest', 0, 3);
  318.  
  319. -- Сухопек
  320.  
  321. UPDATE `creature` SET `PhaseId` = '2007', `position_x` = -9676.1904296875, `position_y` = -2841.929931640625, `position_z` = 54.28123092651367187, `orientation` = 0.104719758033752441 WHERE `guid` = 250315;
  322. UPDATE `creature_template_addon` SET `AnimTier` = 2, `VisFlags` = 0, `auras` = '29266' WHERE `entry` = 43508;
  323. UPDATE `creature_template` SET `unit_flags` = 33600, `unit_flags2` = 34817, `unit_flags3` = 1056768, `dynamicflags` = 0, `npcflag` = 2, `InhabitType` = 3, `HoverHeight` = 1 WHERE `entry` = 43508;
  324.  
  325. DELETE FROM `creature` WHERE `guid` IN (37956);
  326. INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `spawnDifficulties`, `phaseMask`, `PhaseId`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `wander_distance`, `currentwaypoint`, `MovementType`, `randomMoveType`, `randomMoveMinTimer`, `randomMoveMaxTimer`, `ScriptName`, `npcflag`, `npcflag2`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `isActive`, `personal_size`, `isTeemingSpawn`, `MiscData`, `GroupID`, `inhabitType`, `id_alliance`, `id_horde`, `VerifiedBuild`, `Comment`, `MaxExpansion`, `MinExpansion`) VALUES
  327. (37956, 43460, 0, 44, 5326, 1, '', 1, '2008', 0, 0, -9462.54, -2827.11, 65.3617, 3.22886, 120, 0, 0, 0, 0, 1, 500, 3500, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 68887, '', 0, 3); -- другая фаза
  328.  
  329. DELETE FROM `phase_definitions` WHERE `zoneId` = 44 AND `entry` = 2008;
  330. INSERT INTO `phase_definitions` (`zoneId`, `entry`, `phasemask`, `phaseId`, `areaIds`, `VisibleMapID`, `UiWorldMapAreaID`, `PreloadMapID`, `flags`, `comment`, `MaxExpansion`, `MinExpansion`) VALUES
  331. (44, 2008, 0, '2008', '', 0, 0, 0, 16, 'jorgensen', 0, 3);
  332.  
  333. DELETE FROM conditions WHERE SourceTypeOrReferenceId IN (23) AND SourceGroup IN (44) and SourceEntry IN (2008);
  334. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`, `MaxExpansion`, `MinExpansion`) VALUES
  335. (23, 44, 2008, 0, 0, 92, 0, 26616, 66, 0, 0, 0, '', 'Phase jorgensen', 0, 3),
  336. (23, 44, 2008, 0, 0, 69, 0, 43546, 0, 0, 1, 0, '', 'Phase jorgensen', 0, 3),
  337. (23, 44, 2008, 0, 0, 92, 0, 26651, 64, 0, 1, 0, '', 'Phase jorgensen', 0, 3);
  338.  
  339. DELETE FROM `spell_area` WHERE `spell` IN (81447);
  340. INSERT INTO `spell_area` (`spell`, `area`, `zone`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `classmask`, `active_event`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`, `cast_delay`, `remove_delay`, `flags`, `conditionId`, `MaxExpansion`, `MinExpansion`) VALUES
  341. (81447, 44, 0, 26646, 26651, 0, 0, 0, 0, 2, 1, 74, 64, 0, 0, 4, 0, 0, 3),
  342. (81447, 44, 0, 26651, 26651, 0, 0, 0, 0, 2, 1, 74, 64, 0, 0, 4, 0, 0, 3);
  343.  
  344. -- спрятать [05:07:35] GUID 38303, Entry: 43594 Name: Bravo Company Trigger
  345.  
  346. UPDATE `creature_template` SET `flags_extra` = 130 WHERE `entry` IN (43594);
  347.  
  348. DELETE FROM `creature_addon` WHERE `guid` IN (254001,254002,254003,254004,254000);
  349. INSERT INTO `creature_addon` (`guid`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`) VALUES
  350. (254001, 0, 0, 0, 1, 1, 0, 333, 0, 0, 0, ''), -- 43607 - 81580 - 81580
  351. (254002, 0, 0, 0, 1, 2, 0, 0, 722, 0, 0, '80642'), -- 43611 - 81580 - 81580, 80642 - 80642
  352. (254000, 0, 0, 0, 1, 1, 0, 375, 0, 0, 0, ''), -- 43609 - 81583 - 81583
  353. (254003, 0, 0, 0, 1, 1, 0, 425, 0, 0, 0, ''), -- 43610 - 81580 - 81580
  354. (254004, 0, 0, 0, 1, 1, 0, 333, 0, 0, 0, ''); -- 43608 - 81580 - 81580
  355.  
  356. DELETE FROM `creature` WHERE `guid` IN (254001,254002,254003,254004,254000);
  357. INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `spawnDifficulties`, `phaseMask`, `PhaseId`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `wander_distance`, `currentwaypoint`, `MovementType`, `randomMoveType`, `randomMoveMinTimer`, `randomMoveMaxTimer`, `ScriptName`, `npcflag`, `npcflag2`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `isActive`, `personal_size`, `isTeemingSpawn`, `MiscData`, `GroupID`, `inhabitType`, `id_alliance`, `id_horde`, `VerifiedBuild`, `Comment`, `MaxExpansion`, `MinExpansion`) VALUES
  358. (254004, 43608, 0, 44, 5324, 1, '', 1, '2010', 0, 0, -9642.72, -3476.93, 121.956, 1.93732, 120, 0, 0, 0, 0, 1, 500, 3500, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 68887, '', 0, 3),
  359. (254003, 43610, 0, 44, 5324, 1, '', 1, '2010', 0, 0, -9639.47, -3476.01, 121.956, 1.78024, 120, 0, 0, 0, 0, 1, 500, 3500, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 68887, '', 0, 3),
  360. (254002, 43611, 0, 44, 5324, 1, '', 1, '2010', 0, 0, -9636.37, -3474.71, 121.956, 2.11185, 120, 0, 0, 0, 0, 1, 500, 3500, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 68887, '', 0, 3),
  361. (254001, 43607, 0, 44, 5324, 1, '', 1, '2010', 0, 0, -9633.55, -3473.22, 121.809, 2.25147, 120, 0, 0, 0, 0, 1, 500, 3500, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 68887, '', 0, 3),
  362. (254000, 43609, 0, 44, 5324, 1, '', 1, '2009', 0, 0, -9630.64, -3471.34, 121.854, 2.3911, 120, 0, 0, 0, 0, 1, 500, 3500, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 43345, '', 0, 3);
  363.  
  364.  
  365. DELETE FROM `phase_definitions` WHERE `zoneId` = 44 AND `entry` = 2009;
  366. INSERT INTO `phase_definitions` (`zoneId`, `entry`, `phasemask`, `phaseId`, `areaIds`, `VisibleMapID`, `UiWorldMapAreaID`, `PreloadMapID`, `flags`, `comment`, `MaxExpansion`, `MinExpansion`) VALUES
  367. (44, 2009, 0, '2009', '', 0, 0, 0, 16, 'jorgensen 2', 0, 3);
  368.  
  369. DELETE FROM conditions WHERE SourceTypeOrReferenceId IN (23) AND SourceGroup IN (44) and SourceEntry IN (2009);
  370. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`, `MaxExpansion`, `MinExpansion`) VALUES
  371. (23, 44, 2009, 0, 0, 92, 0, 26651, 66, 0, 0, 0, '', 'Phase jorgensen 2', 0, 3),
  372. (23, 44, 2009, 0, 0, 69, 0, 43546, 0, 0, 1, 0, '', 'Phase jorgensen 2', 0, 3),
  373. (23, 44, 2009, 0, 0, 92, 0, 26708, 64, 0, 1, 0, '', 'Phase jorgensen 2', 0, 3);
  374.  
  375. DELETE FROM `phase_definitions` WHERE `zoneId` = 44 AND `entry` = 2010;
  376. INSERT INTO `phase_definitions` (`zoneId`, `entry`, `phasemask`, `phaseId`, `areaIds`, `VisibleMapID`, `UiWorldMapAreaID`, `PreloadMapID`, `flags`, `comment`, `MaxExpansion`, `MinExpansion`) VALUES
  377. (44, 2010, 0, '2010', '', 0, 0, 0, 16, 'Q26651', 0, 3);
  378.  
  379. DELETE FROM conditions WHERE SourceTypeOrReferenceId IN (23) AND SourceGroup IN (44) and SourceEntry IN (2010);
  380. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`, `MaxExpansion`, `MinExpansion`) VALUES
  381. (23, 44, 2010, 0, 0, 92, 0, 26651, 66, 0, 0, 0, '', 'Phase Q26651', 0, 3),
  382. (23, 44, 2010, 0, 0, 92, 0, 26708, 64, 0, 1, 0, '', 'Phase Q26651', 0, 3);
  383.  
  384. DELETE FROM `player_actions` WHERE `event_type` = 14 AND `event_param1` IN (26651) AND `action_type` IN (7);
  385. INSERT INTO `player_actions` (`event_type`, `event_param1`, `event_param2`, `event_param3`, `action_chance`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param_x`, `action_param_y`, `action_param_z`, `action_param_o`, `delay`, `options_type`, `options_param`, `options_param2`, `options_param3`, `action_text`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `comment`) VALUES
  386. (14, 26651, 0, 0, 100, 7, 43546, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, '');
  387.  
  388. DELETE FROM `creature` WHERE `guid` IN (254006,254007,254008,254009,254010,254011,254012,254013,254014);
  389. INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `spawnDifficulties`, `phaseMask`, `PhaseId`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `wander_distance`, `currentwaypoint`, `MovementType`, `randomMoveType`, `randomMoveMinTimer`, `randomMoveMaxTimer`, `ScriptName`, `npcflag`, `npcflag2`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `isActive`, `personal_size`, `isTeemingSpawn`, `MiscData`, `GroupID`, `inhabitType`, `id_alliance`, `id_horde`, `VerifiedBuild`, `Comment`, `MaxExpansion`, `MinExpansion`) VALUES
  390. (254014, 43572, 0, 44, 5324, 1, '', 1, '2010', 0, 0, -9610.29, -3490.61, 122.039, 1.06465, 120, 0, 0, 0, 0, 1, 500, 3500, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 68887, '', 0, 3),
  391. (254013, 43572, 0, 44, 5324, 1, '', 1, '2010', 0, 0, -9607.94, -3489.54, 122.039, 3.52557, 120, 0, 0, 0, 0, 1, 500, 3500, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 68887, '', 0, 3),
  392. (254012, 43571, 0, 44, 5324, 1, '', 1, '2010', 0, 0, -9604.88, -3498.8, 122.039, 0.436332, 120, 0, 0, 0, 0, 1, 500, 3500, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 68887, '', 0, 3),
  393. (254011, 43571, 0, 44, 5324, 1, '', 1, '2010', 0, 0, -9620.11, -3486.56, 122.039, 1.06465, 120, 0, 0, 0, 0, 1, 500, 3500, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 68887, '', 0, 3),
  394. (254010, 43572, 0, 44, 5324, 1, '', 1, '2010', 0, 0, -9625.46, -3482.62, 122.039, 3.19395, 120, 0, 0, 0, 0, 1, 500, 3500, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 68887, '', 0, 3),
  395. (254009, 43572, 0, 44, 5324, 1, '', 1, '2010', 0, 0, -9599.92, -3497.6, 122.039, 2.68781, 120, 0, 0, 0, 0, 1, 500, 3500, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 68887, '', 0, 3),
  396. (254008, 43572, 0, 44, 5324, 1, '', 1, '2010', 0, 0, -9610.65, -3488.24, 122.039, 5.18363, 120, 0, 0, 0, 0, 1, 500, 3500, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 68887, '', 0, 3),
  397. (254007, 43571, 0, 44, 5324, 1, '', 1, '2010', 0, 0, -9627.73, -3483.46, 122.039, 0.907571, 120, 0, 0, 0, 0, 1, 500, 3500, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 68887, '', 0, 3),
  398. (254006, 43572, 0, 44, 5324, 1, '', 1, '2010', 0, 0, -9627.51, -3481.51, 122.039, 5.18363, 120, 0, 0, 0, 0, 1, 500, 3500, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 68887, '', 0, 3);
  399.  
  400. DELETE FROM `creature_addon` WHERE `guid` IN (254006,254007,254008,254009,254010,254011,254012,254013,254014);
  401. INSERT INTO `creature_addon` (`guid`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`) VALUES
  402. (254006, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, ''), -- 43572 - 81580 - 81580
  403. (254007, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, ''), -- 43571 - 81580 - 81580
  404. (254008, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, ''), -- 43572 - 81580 - 81580
  405. (254009, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, ''), -- 43572 - 81580 - 81580
  406. (254010, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, ''), -- 43572 - 81580 - 81580
  407. (254011, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, ''), -- 43571 - 81580 - 81580
  408. (254012, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, ''), -- 43571 - 81580 - 81580
  409. (254013, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, ''), -- 43572 - 81580 - 81580
  410. (254014, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, ''); -- 43572 - 81580 - 81580
  411.  
  412. UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` IN (43611);
  413. DELETE FROM `smart_scripts` WHERE `entryorguid` = 43611 AND `source_type` = 0 AND `id` = 1;
  414. DELETE FROM `smart_scripts` WHERE `entryorguid` = 43611*100 AND `source_type` = 9;
  415. 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
  416. (43611, 0, 1, 0, 20, 0, 100, 0, 26668, 9000, 9000, 0, 0, 80, 43611*100, 2, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'QREW - TS'),
  417.  
  418. (43611*100, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 84, 0, 0, 7, 0, 0, 0, 0, 0, 19, 43610, 50, 0, 0, 0, 0, 0, 0, 'TS - SAY LINE 0'),
  419. (43611*100, 9, 1, 0, 0, 0, 100, 0, 336, 336, 0, 0, 0, 66, 19, 43610, 20, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 1.338496923446655273, 'TS - Orient'),
  420. (43611*100, 9, 3, 0, 0, 0, 100, 0, 1189, 1189, 0, 0, 0, 66, 19, 43610, 20, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 1.780235767364501953, 'TS - Orient'),
  421. (43611*100, 9, 4, 0, 0, 0, 100, 0, 2570, 2570, 0, 0, 0, 1, 1, 0, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'TS - Say');
  422.  
  423. UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` IN (43184);
  424. DELETE FROM `smart_scripts` WHERE `entryorguid` = 43184 AND `source_type` = 0 AND `id` = 1;
  425. DELETE FROM `smart_scripts` WHERE `entryorguid` = 43184*100 AND `source_type` = 9;
  426. 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
  427. (43184, 0, 1, 0, 20, 0, 100, 0, 26607, 9000, 9000, 0, 0, 80, 43184*100, 2, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'QREW - TS'),
  428.  
  429. (43184*100, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 11, 81234, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'TS - Cast'),
  430. (43184*100, 9, 1, 0, 0, 0, 100, 0, 6258, 6258, 0, 0, 0, 71, 0, 0, 5278, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, '[0] (VirtualItems) [0] ItemID: 5278'),
  431. (43184*100, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 128, 757, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'SMSG_PLAY_ONE_SHOT_ANIM_KIT 757'),
  432. (43184*100, 9, 4, 0, 0, 0, 100, 0, 1230, 1230, 0, 0, 0, 40, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, '[0] SheatheState: 0'),
  433. (43184*100, 9, 5, 0, 0, 0, 100, 0, 3637, 3637, 0, 0, 0, 11, 80642, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, '(Cast) SpellID: 80642 (80642)'),
  434. (43184*100, 9, 6, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 17, 376, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, '[1] EmoteState: 376'),
  435. (43184*100, 9, 7, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 40, 2, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, '[1] SheatheState: 2'),
  436. (43184*100, 9, 8, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 71, 0, 0, 0, 0, 42775, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, '[1] (VirtualItems) [2] ItemID: 42775'),
  437. (43184*100, 9, 9, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 5, 275, 0, 0, 0, 0, 0, 0, 0, 19, 43435, 20, 0, 0, 0, 0, 0, 0, 'SMSG_EMOTE Emote ID: 275 (OneShotTrain) Entry: 43435'),
  438. (43184*100, 9, 10, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 5, 15, 0, 0, 0, 0, 0, 0, 0, 19, 43434, 20, 0, 0, 0, 0, 0, 0, 'SMSG_EMOTE Emote ID: 15 (OneShotRoar) Entry: 43434'),
  439. (43184*100, 9, 11, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 5, 4, 0, 0, 0, 0, 0, 0, 0, 19, 43433, 20, 0, 0, 0, 0, 0, 0, 'SMSG_EMOTE Emote ID: 4 (OneShotCheer) Entry: 43433'),
  440. (43184*100, 9, 12, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 5, 66, 0, 0, 0, 0, 0, 0, 0, 19, 43432, 20, 0, 0, 0, 0, 0, 0, 'SMSG_EMOTE Emote ID: 66 (OneShotSalute) Entry: 43432'),
  441. (43184*100, 9, 13, 0, 0, 0, 100, 0, 104, 104, 0, 0, 0, 1, 1, 0, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'Похоже, нам нужно выиграть войну.'),
  442. (43184*100, 9, 14, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 84, 0, 0, 7, 0, 0, 0, 0, 0, 19, 43435, 50, 0, 0, 0, 0, 0, 0, 'ПОЗНАЙ БОЛЬ! Entry: 43435'),
  443. (43184*100, 9, 15, 0, 0, 0, 100, 0, 1624, 1624, 0, 0, 0, 84, 0, 0, 7, 0, 0, 0, 0, 0, 19, 43434, 50, 0, 0, 0, 0, 0, 0, 'ДЖОННИ ВЕРНУЛСЯ, ДЕТКА! ЙЕ-Е-Е! Entry: 43434'),
  444. (43184*100, 9, 16, 0, 0, 0, 100, 0, 118437, 118437, 0, 0, 0, 41, 0, 1200, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Respawn New Johni');
  445.  
  446. DELETE FROM `creature_text` WHERE `Entry` IN (43434,43435);
  447. INSERT INTO `creature_text` (`Entry`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
  448. (43434, 0, 0, 'ДЖОННИ ВЕРНУЛСЯ, ДЕТКА! ЙЕ-Е-Е!', 12, 0, 100, 0, 0, 0, 43518, 0, 'Кракауер to Player'),
  449. (43435, 0, 0, 'ПОЗНАЙ БОЛЬ!', 12, 0, 100, 275, 0, 0, 43517, 0, 'Данфорт to Player');
  450.  
  451. DELETE FROM `creature_text` WHERE `Entry` = 43184 AND `GroupID` = 1;
  452. INSERT INTO `creature_text` (`Entry`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
  453. (43184, 1, 0, 'Похоже, нам нужно выиграть войну.', 12, 0, 100, 0, 0, 0, 43516, 0, 'Джон Джей Кишан to Player');
  454.  
  455. DELETE FROM `creature` WHERE `guid` IN (253689,255730);
  456.  
  457. -- пацыки в лагере появляются после http://wowhead.com/ru/quest=26708 "А-А-А-А-А-А-А!!! А-А-А-А-А!!!" = 66 и если не 66 http://wowhead.com/ru/quest=26713 "Решающее сражение в крепости Каменной Стражи"
  458.  
  459. -- очередь пропадает после 64 темное пламя
  460.  
  461. -- тротман остаётся хех, даже после ласт кв
  462.  
  463. -- пример отложенной фазы =)
  464. -- UPDATE `phase_definitions` SET `flags` = 128 WHERE `zoneId` = 6722 AND `entry` = 2;
  465. -- (79890, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 253, 6722, 3365, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'Link - Cant Phase Update');
  466. -- (79890*100, 9, 16, 0, 0, 0, 100, 1, 100, 100, 0, 0, 0, 253, 6722, 3365, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'Update Phase');
  467.  
  468. DELETE FROM `phase_definitions` WHERE `zoneId` = 44 AND `entry` = 2011;
  469. INSERT INTO `phase_definitions` (`zoneId`, `entry`, `phasemask`, `phaseId`, `areaIds`, `VisibleMapID`, `UiWorldMapAreaID`, `PreloadMapID`, `flags`, `comment`, `MaxExpansion`, `MinExpansion`) VALUES
  470. (44, 2011, 0, '2011', '', 0, 0, 0, 16, 'Trotman c vehicle', 0, 3);
  471.  
  472. DELETE FROM conditions WHERE SourceTypeOrReferenceId IN (23) AND SourceGroup IN (44) and SourceEntry IN (2011);
  473. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`, `MaxExpansion`, `MinExpansion`) VALUES
  474. (23, 44, 2011, 0, 0, 92, 0, 26694, 64, 0, 0, 0, '', 'Phase Trotman c vehicle', 0, 3),
  475. (23, 44, 2011, 0, 0, 92, 0, 26708, 66, 0, 1, 0, '', 'Phase Trotman c vehicle', 0, 3),
  476. (23, 44, 2011, 0, 0, 69, 0, 43714, 0, 0, 1, 0, '', 'Phase Trotman c vehicle', 0, 3);
  477.  
  478. UPDATE `creature_template` SET `VehicleId` = 987, `InhabitType` = 3, `HoverHeight` = 1, `AIName` = 'SmartAI' WHERE `entry` = 43714;
  479.  
  480. UPDATE `creature` SET `PhaseId` = '2011', `position_x` = -9643.52, `position_y` = -3462.36, `position_z` = 119.33, `orientation` = 5.25344 WHERE `guid` = 248159;
  481. UPDATE `creature` SET `PhaseId` = '2011', `position_x` = -9646.64, `position_y` = -3454.94, `position_z` = 117.485, `orientation` = 1.93732 WHERE `guid` = 346411;
  482.  
  483. DELETE FROM `creature_addon` WHERE `guid` = 346411;
  484. INSERT INTO `creature_addon` (`guid`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvPFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`) VALUES
  485. (346411, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, NULL);
  486.  
  487. DELETE FROM `creature_template_addon` WHERE `entry` = 43714;
  488. INSERT INTO `creature_template_addon` (`entry`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvPFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`, `MaxExpansion`, `MinExpansion`) VALUES
  489. (43714, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, '81793', 0, 3);
  490.  
  491. DELETE FROM `vehicle_template_accessory` WHERE `EntryOrAura` = 43714 AND `seat_id` = 1;
  492. DELETE FROM `vehicle_template_accessory` WHERE (`EntryOrAura`=43714 AND `seat_id`=0);
  493. INSERT INTO `vehicle_template_accessory` (`EntryOrAura`, `accessory_entry`, `seat_id`, `minion`, `description`, `summontype`, `summontimer`) VALUES
  494. (43714, 43728, 0, 0, '43714 - 43728', 3, 27000); -- 43714 - 43728
  495.  
  496. DELETE FROM `vehicle_attachment_offset` WHERE `entry` = 43714;
  497. INSERT INTO `vehicle_attachment_offset` (`entry`, `seat_id`, `offsetX`, `offsetY`, `offsetZ`, `offsetO`, `description`) VALUES
  498. (43714, 0, -4.19782, 0.73745, 1.51754, 0, 'Seat 0');
  499.  
  500. -- 81793 парашут катапультировние 80743
  501.  
  502. DELETE FROM `smart_scripts` WHERE `entryorguid` = 43714 AND `source_type` = 0;
  503. 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
  504. (43714, 0, 0, 0, 25, 0, 100, 1, 0, 0, 0, 0, 0, 259, 1, 43728, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, -9643.52, -3462.36, 119.33, 5.25344, ''),
  505. (43714, 0, 1, 0, 54, 0, 100, 1, 0, 0, 0, 0, 0, 236, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0.000000, 0.000000, 0.000000, 0.000000, '');
  506.  
  507. -- DELETE FROM `waypoints` WHERE `entry` = 43714;
  508. -- INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES
  509. -- (43714, 0, -9646.64, -3454.94, 166.01332, ''),
  510. -- (43714, 1, -9646.64, -3454.94, 156.01332, ''),
  511. -- (43714, 2, -9646.64, -3454.94, 116.42028, '');
  512.  
  513. UPDATE `creature_text` SET `Emote` = 5 WHERE `Entry` = 43611 AND `GroupID` = 2;
  514. DELETE FROM `smart_scripts` WHERE `entryorguid` = 43611 AND `source_type` = 0 AND `id` IN (2,3,4);
  515. DELETE FROM `smart_scripts` WHERE `entryorguid` = 43611*100+1 AND `source_type` = 9;
  516. 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
  517. (43611, 0, 2, 0, 20, 0, 100, 0, 26694, 160000, 160000, 0, 0, 80, 43611*100+1, 2, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'QREW - TS'),
  518. (43611, 0, 3, 4, 40, 0, 100, 0, 5, 4361100, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'WP REACH - Home Orient'),
  519. (43611, 0, 4, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 128, 722, 1, 0, 0, 0, 0, 0, 395, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Link - AIKIT'),
  520.  
  521. (43611*100+1, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 0, 0, 19, 43607, 50, 0, 0, 0, 0, 0, 0, 'Data - WP'),
  522. (43611*100+1, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 0, 0, 19, 43608, 50, 0, 0, 0, 0, 0, 0, 'Data - WP'),
  523. (43611*100+1, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 0, 0, 19, 43610, 50, 0, 0, 0, 0, 0, 0, 'Data - WP'),
  524. (43611*100+1, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 128, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'AnimKit 0'),
  525. (43611*100+1, 9, 4, 0, 0, 0, 100, 0, 500, 500, 0, 0, 0, 53, 1, 43611, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Move TO'),
  526. (43611*100+1, 9, 5, 0, 0, 0, 100, 2048, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 0, 0, 11, 43609, 50, 0, 0, 0, 0, 0, 0, 'Data - WP'),
  527. (43611*100+1, 9, 6, 0, 0, 0, 100, 0, 152, 152, 0, 0, 0, 220, 43714, 3, 27000, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, -9646.64, -3454.94, 156.01332, 1.9373155, 'Pers summon'),
  528. (43611*100+1, 9, 7, 0, 0, 0, 100, 0, 49, 49, 0, 0, 0, 1, 2, 0, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'Heads up! PAYLOAD INCOMING!'),
  529. (43611*100+1, 9, 8, 0, 0, 0, 100, 0, 2219, 2219, 0, 0, 0, 84, 0, 0, 7, 0, 0, 0, 0, 0, 19, 43607, 50, 0, 0, 0, 0, 0, 0, 'TS - SAY LINE 1 И откуда это свалилось?'),
  530. (43611*100+1, 9, 9, 0, 0, 0, 100, 0, 4834, 4834, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'Troteman.'),
  531. (43611*100+1, 9, 10, 0, 0, 0, 100, 0, 1087, 1087, 0, 0, 0, 28, 81793, 0, 0, 0, 0, 0, 0, 0, 19, 43714, 200, 0, 0, 0, 0, 0, 0, 'UNAURA PARACHUTE'),
  532. (43611*100+1, 9, 11, 0, 0, 0, 100, 0, 2161, 2161, 0, 0, 0, 84, 1, 0, 7, 0, 0, 0, 0, 0, 19, 43607, 50, 0, 0, 0, 0, 0, 0, 'TS - SAY LINE 2 Тротман?'),
  533. (43611*100+1, 9, 12, 0, 0, 0, 100, 0, 1483, 1483, 0, 0, 0, 86, 80743, 0, 19, 43714, 50, 0, 0, 0, 19, 43714, 50, 0, 0, 0, 0, 0, 0, '(Cast) SpellID: 80743 on Entry: 43714'),
  534. (43611*100+1, 9, 13, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 5, 61, 0, 0, 0, 0, 0, 0, 0, 19, 43714, 200, 0, 0, 0, 0, 0, 0, 'Emote ID: 61 (OneShotAttackThrown) Entry: 43714'),
  535. (43611*100+1, 9, 14, 0, 0, 0, 100, 0, 2551, 2551, 0, 0, 0, 84, 0, 0, 7, 0, 0, 0, 0, 0, 19, 43728, 50, 0, 0, 0, 0, 0, 0, 'TS - SAY LINE 1 Text: К вашим услугам.'),
  536. (43611*100+1, 9, 15, 0, 0, 0, 100, 0, 110443, 110443, 0, 0, 0, 45, 2, 2, 0, 0, 0, 0, 0, 0, 19, 43610, 50, 0, 0, 0, 0, 0, 0, 'Data - WP HOME'),
  537. (43611*100+1, 9, 16, 0, 0, 0, 100, 0, 823, 823, 0, 0, 0, 45, 2, 2, 0, 0, 0, 0, 0, 0, 19, 43608, 50, 0, 0, 0, 0, 0, 0, 'Data - WP HOME'),
  538. (43611*100+1, 9, 17, 0, 0, 0, 100, 2048, 394, 394, 0, 0, 0, 45, 2, 2, 0, 0, 0, 0, 0, 0, 11, 43609, 50, 0, 0, 0, 0, 0, 0, 'Data - WP HOME'),
  539. (43611*100+1, 9, 18, 0, 0, 0, 100, 0, 4427, 4427, 0, 0, 0, 53, 0, 4361100, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Move TO'),
  540. (43611*100+1, 9, 19, 0, 0, 0, 100, 0, 1622, 1622, 0, 0, 0, 45, 2, 2, 0, 0, 0, 0, 0, 0, 19, 43607, 50, 0, 0, 0, 0, 0, 0, 'Data - WP HOME');
  541.  
  542. DELETE FROM `creature_text` WHERE `Entry` IN (43607,43728);
  543. INSERT INTO `creature_text` (`Entry`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
  544. (43607, 0, 0, 'И откуда это свалилось?', 12, 0, 100, 0, 0, 0, 43808, 0, 'Данфорт to Player'),
  545. (43607, 1, 0, 'Тротман?', 12, 0, 100, 6, 0, 0, 43810, 0, 'Данфорт to Player'),
  546. (43728, 0, 0, 'К вашим услугам.', 12, 0, 100, 66, 0, 0, 43811, 0, 'Полковник Тротман to Осадный танк команды \"Браво\"');
  547.  
  548. UPDATE `creature_template` SET `speed_walk` = 1, `speed_run` = 1 WHERE `entry` IN (43607, 43608, 43609, 43610, 43611);
  549. UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` IN (43607,43608,43609,43610);
  550. DELETE FROM `smart_scripts` WHERE `entryorguid` IN (43607,43608,43610,43609) AND `source_type` = 0;
  551. 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
  552. (43607, 0, 0, 0, 38, 0, 100, 0, 1, 1, 0, 0, 0, 53, 0, 43607, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Move TO'),
  553. (43607, 0, 1, 0, 40, 0, 100, 0, 1, 43607, 0, 0, 0, 5, 333, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'WP REACH - Emote'),
  554. (43607, 0, 2, 0, 38, 0, 100, 0, 2, 2, 0, 0, 0, 53, 0, 4360700, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Move TO'),
  555. (43607, 0, 3, 4, 40, 0, 100, 0, 2, 4360700, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'WP REACH - Home Orient'),
  556. (43607, 0, 4, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 5, 333, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Link - Emote'),
  557.  
  558. (43608, 0, 0, 0, 38, 0, 100, 0, 1, 1, 0, 0, 0, 53, 0, 43608, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Move TO'),
  559. (43608, 0, 1, 0, 40, 0, 100, 0, 1, 43608, 0, 0, 0, 5, 333, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'WP REACH - Emote'),
  560. (43608, 0, 2, 0, 38, 0, 100, 0, 2, 2, 0, 0, 0, 53, 0, 4360800, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Move TO'),
  561. (43608, 0, 3, 4, 40, 0, 100, 0, 3, 4360800, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'WP REACH - Home Orient'),
  562. (43608, 0, 4, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 5, 333, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Link - Emote'),
  563.  
  564. (43610, 0, 0, 0, 38, 0, 100, 0, 1, 1, 0, 0, 0, 53, 0, 43610, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Move TO'),
  565. (43610, 0, 1, 0, 40, 0, 100, 0, 1, 43610, 0, 0, 0, 5, 425, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'WP REACH - Emote'),
  566. (43610, 0, 2, 0, 38, 0, 100, 0, 2, 2, 0, 0, 0, 53, 0, 4361000, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Move TO'),
  567. (43610, 0, 3, 4, 40, 0, 100, 0, 5, 4361000, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'WP REACH - Home Orient'),
  568. (43610, 0, 4, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 5, 425, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Link - Emote'),
  569.  
  570. (43609, 0, 0, 0, 38, 0, 100, 0, 1, 1, 0, 0, 0, 53, 0, 43609, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Move TO'),
  571. (43609, 0, 1, 0, 40, 0, 100, 0, 1, 43609, 0, 0, 0, 5, 375, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'WP REACH - Emote'),
  572. (43609, 0, 2, 0, 38, 0, 100, 0, 2, 2, 0, 0, 0, 53, 0, 4360900, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Move TO'),
  573. (43609, 0, 3, 4, 40, 0, 100, 0, 9, 4360900, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'WP REACH - Home Orient'),
  574. (43609, 0, 4, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 5, 375, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Link - Emote');
  575.  
  576. DELETE FROM `waypoints` WHERE entry = 43607;
  577. INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES
  578. (43607, 0, -9635.16, -3470.755, 121.76773, ''),
  579. (43607, 1, -9637.198, -3467.8972, 121.08953, '');
  580.  
  581. DELETE FROM `waypoints` WHERE entry = 4360700;
  582. INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES
  583. (4360700, 0, -9635.374, -3470.3086, 121.44949, ''),
  584. (4360700, 1, -9634.374, -3471.8086, 121.94949, ''),
  585. (4360700, 2, -9633.55, -3473.22, 121.80946, ''); -- (MovementMonsterSpline) (MovementSpline) FaceDirection: 2.251474618911743164
  586.  
  587. DELETE FROM `waypoints` WHERE entry = 43608;
  588. INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES
  589. (43608, 0, -9644.055, -3473.495, 122.20641, ''),
  590. (43608, 1, -9646.39, -3466.56, 120.457, '');
  591.  
  592. DELETE FROM `waypoints` WHERE entry = 4360800;
  593. INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES
  594. (4360800, 0, -9645.055, -3469.495, 121.45641, ''),
  595. (4360800, 1, -9644.805, -3470.245, 121.95641, ''),
  596. (4360800, 2, -9644.305, -3471.995, 122.20641, ''),
  597. (4360800, 3, -9642.72, -3476.93, 121.955826, ''); -- (MovementMonsterSpline) (MovementSpline) FaceDirection: 1.93731546401977539
  598.  
  599. DELETE FROM `waypoints` WHERE entry = 43610;
  600. INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES
  601. (43610, 0, -9640.9, -3473.185, 121.99892, ''),
  602. (43610, 1, -9643.83, -3466.86, 120.542, '');
  603.  
  604. DELETE FROM `waypoints` WHERE entry = 4361000;
  605. INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES
  606. (4361000, 0, -9643.15, -3467.685, 121.24892, ''),
  607. (4361000, 1, -9642.4, -3469.685, 121.24892, ''),
  608. (4361000, 2, -9641.9, -3470.435, 121.49892, ''),
  609. (4361000, 3, -9641.65, -3471.435, 121.74892, ''),
  610. (4361000, 4, -9640.9, -3472.935, 121.99892, ''),
  611. (4361000, 5, -9639.47, -3476.01, 121.955826, ''); -- (MovementMonsterSpline) (MovementSpline) FaceDirection: 1.780235767364501953
  612.  
  613. DELETE FROM `waypoints` WHERE entry = 43609;
  614. INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES
  615. (43609, 0, -9631.654, -3470.02, 121.85519, ''),
  616. (43609, 1, -9635.654, -3465.02, 120.60519, ''),
  617. (43609, 2, -9639.67, -3460.7, 118.867, '');
  618.  
  619. DELETE FROM `waypoints` WHERE entry = 4360900;
  620. INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES
  621. (4360900, 0, -9638.654, -3461.52, 119.85519, ''),
  622. (4360900, 1, -9637.404, -3463.02, 120.35519, ''),
  623. (4360900, 2, -9636.904, -3463.77, 120.35519, ''),
  624. (4360900, 3, -9635.654, -3465.27, 120.60519, ''),
  625. (4360900, 4, -9635.154, -3466.02, 120.85519, ''),
  626. (4360900, 5, -9634.404, -3466.52, 121.10519, ''),
  627. (4360900, 6, -9633.154, -3468.02, 121.35519, ''),
  628. (4360900, 7, -9632.654, -3468.77, 121.60519, ''),
  629. (4360900, 8, -9631.904, -3469.52, 121.85519, ''),
  630. (4360900, 9, -9630.64, -3471.34, 121.843376, ''); -- (MovementMonsterSpline) (MovementSpline) FaceDirection: 2.39110112190246582
  631.  
  632. DELETE FROM `waypoints` WHERE entry = 43611;
  633. INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES
  634. (43611, 0, -9637.705, -3472.6948, 121.79291, ''),
  635. (43611, 1, -9641.54, -3465.18, 120.13, '');
  636.  
  637. DELETE FROM `waypoints` WHERE entry = 4361100;
  638. INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES
  639. (4361100, 0, -9640.455, -3466.9448, 121.04291, ''),
  640. (4361100, 1, -9638.955, -3469.6948, 121.29291, ''),
  641. (4361100, 2, -9638.705, -3470.1948, 121.54291, ''),
  642. (4361100, 3, -9638.205, -3471.1948, 121.79291, ''),
  643. (4361100, 4, -9637.205, -3472.9448, 122.04291, ''),
  644. (4361100, 5, -9636.37, -3474.71, 121.955826, ''); -- (MovementMonsterSpline) (MovementSpline) FaceDirection: 2.111848354339599609
  645.  
  646. DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` = 43714 AND `spell_id` = 46598;
  647. INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`, `add_npc_flag`) VALUES
  648. (43714, 46598, 1, 5, 1);
  649.  
  650. -- коррект к пацыкам
  651. DELETE FROM `conditions` WHERE SourceTypeOrReferenceId = 23 AND SourceGroup = 44 AND SourceEntry =2001;
  652. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`, `MaxExpansion`, `MinExpansion`) VALUES
  653. (23, 44, 2001, 0, 0, 69, 0, 43812, 1, 0, 1, 0, "", "Phase If Quest not Rewarded", 0, 3),
  654. (23, 44, 2001, 0, 0, 69, 0, 43826, 1, 0, 1, 0, "", "Phase If Quest not Rewarded", 0, 3),
  655. (23, 44, 2001, 0, 0, 69, 0, 43827, 1, 0, 1, 0, "", "Phase If Quest not Rewarded", 0, 3),
  656. (23, 44, 2001, 0, 0, 69, 0, 43828, 1, 0, 1, 0, "", "Phase If Quest not Rewarded", 0, 3),
  657. (23, 44, 2001, 0, 0, 69, 0, 43829, 1, 0, 1, 0, "", "Phase If Quest not Rewarded", 0, 3),
  658. (23, 44, 2001, 0, 0, 92, 0, 26708, 66, 0, 0, 0, "", "Phase If Quest not Rewarded", 0, 3),
  659. (23, 44, 2001, 0, 0, 92, 0, 26713, 66, 0, 1, 0, "", "Phase If Quest not Rewarded", 0, 3);
  660.  
  661. DELETE FROM `creature_addon` WHERE `guid` IN (9591145);
  662. INSERT INTO `creature_addon` (`guid`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvPFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`) VALUES
  663. (9591145, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, '80681');
  664.  
  665. UPDATE `creature` SET `PhaseId` = '2012', `unit_flags` = 768, `unit_flags2` = 34816 WHERE `guid` = 9591145;
  666.  
  667. DELETE FROM `phase_definitions` WHERE `zoneId` = 44 AND `entry` = 2012;
  668. INSERT INTO `phase_definitions` (`zoneId`, `entry`, `phasemask`, `phaseId`, `areaIds`, `VisibleMapID`, `UiWorldMapAreaID`, `PreloadMapID`, `flags`, `comment`, `MaxExpansion`, `MinExpansion`) VALUES
  669. (44, 2012, 0, '2012', '', 0, 0, 0, 16, 'Trotman Last', 0, 3);
  670.  
  671. DELETE FROM conditions WHERE SourceTypeOrReferenceId IN (23) AND SourceGroup IN (44) and SourceEntry IN (2012);
  672. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`, `MaxExpansion`, `MinExpansion`) VALUES
  673. (23, 44, 2012, 0, 0, 92, 0, 26708, 66, 0, 0, 0, '', 'Phase Trotman Last', 0, 3);
  674.  
  675. DELETE FROM `creature_addon` WHERE `guid` IN (9591150);
  676. INSERT INTO `creature_addon` (`guid`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvPFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`) VALUES
  677. (9591150, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, '80642');
  678.  
  679. UPDATE `creature` SET `orientation` = 5.27089 WHERE `guid` = 37887;
  680. UPDATE `creature` SET `PhaseId` = '2013' WHERE `guid` IN (37889, 37890, 37898, 37891, 37892, 37893, 37886, 37887, 37895, 37888, 37941, 37896);
  681. DELETE FROM `phase_definitions` WHERE `zoneId` = 44 AND `entry` = 2013;
  682. INSERT INTO `phase_definitions` (`zoneId`, `entry`, `phasemask`, `phaseId`, `areaIds`, `VisibleMapID`, `UiWorldMapAreaID`, `PreloadMapID`, `flags`, `comment`, `MaxExpansion`, `MinExpansion`) VALUES
  683. (44, 2013, 0, '2013', '', 0, 0, 0, 16, 'Redridge Citizen', 0, 3);
  684.  
  685. DELETE FROM conditions WHERE SourceTypeOrReferenceId IN (23) AND SourceGroup IN (44) and SourceEntry IN (2013);
  686. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`, `MaxExpansion`, `MinExpansion`) VALUES
  687. (23, 44, 2013, 0, 0, 92, 0, 26726, 66, 0, 1, 0, '', 'Phase Redridge Citizen', 0, 3);
  688.  
  689. -- Маршал Маррис Употребление алкоголя
  690.  
  691. UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 382;
  692. DELETE FROM `smart_scripts` WHERE `entryorguid` = -37999 AND `source_type` = 0;
  693. 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
  694. (-37999, 0, 0, 0, 1, 0, 100, 0, 6000, 9000, 6000, 9000, 0, 11, 58952, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'OCC - Cast 58952');
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!