[Исправлено после ближайшего обновления] Крутогорье - Бастион боласов

[Thermaplugg]

1. https://www.wowhead.com/quest=42630
2.а могу ошибаться, но по ощущению текущий фикс ctrl-c ctrl-v c слитых сырцов ушоша. https://www.wowhead.com/npc=108052 и https://www.wowhead.com/npc=108060 тупа заспавнены в большом количестве неподалеку от https://www.wowhead.com/npc=107988, а должо быть некое подобие волны и чисто косметически https://www.wowhead.com/npc=107660 должен сидеть в соседней https://www.wowhead.com/npc=108084
2.б у https://www.wowhead.com/spell=214473 и https://www.wowhead.com/spell=214479 не прописаны цели, https://www.wowhead.com/spell=214479 может убить игрока сидящего в https://www.wowhead.com/npc=108081, сам метатель и рядом стоящих нипов
3.
4. 2x.02.23 / Realm BFA

fix(возможно полезная информация для разработчиков)

Скрытый текст

-- Quest: 42630 / Bolas Bastion

SET @ID0 := 4809; -- VehicleId
SET @ID1 := 4811;
UPDATE `creature_template` SET `AIName`='SmartAI', `ScriptName`='', `npcflag`=`npcflag`|16777216, `IconName`='', `unit_flags`=`unit_flags`|0, `spell1`=214357/*Launch Bolas*/, `spell2`=214476/*Flaming Bolas*/, `VehicleId`=@ID0 WHERE `entry`=108081;
UPDATE `creature_template` SET `AIName`='SmartAI', `ScriptName`='', `npcflag`=`npcflag`|16777216, `IconName`='', `unit_flags`=`unit_flags`|0, `VehicleId`=@ID1 WHERE `entry`=108084;
UPDATE `creature_template` SET `AIName`='', `ScriptName`='', `npcflag`=`npcflag`|16777216, `IconName`='gunner', `unit_flags`=`unit_flags`|0 WHERE `entry`=107988;
UPDATE `creature_template` SET `AIName`='SmartAI', `ScriptName`='', `unit_flags`=`unit_flags`|0, `speed_walk`=0.85715 WHERE `entry`=108052;
UPDATE `creature_template` SET `AIName`='SmartAI', `ScriptName`='', `unit_flags`=`unit_flags`|0, `speed_walk`=1.07143 WHERE `entry`=108060;
UPDATE `creature_template_addon` SET `auras`='214567'/*Mod Scale 90-110%*/ WHERE  `entry` IN (108052, 108060);

DELETE FROM `creature_addon` WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id`=108084 AND `map`=1220 AND `zoneId`=7503);
DELETE FROM `creature_addon` WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id`=108052 AND `map`=1220 AND `zoneId`=7503);
DELETE FROM `creature_addon` WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id`=108060 AND `map`=1220 AND `zoneId`=7503);
DELETE FROM `creature` WHERE `id`=108084 AND `map`=1220 AND `zoneId`=7503;
DELETE FROM `creature` WHERE `id`=108052 AND `map`=1220 AND `zoneId`=7503;
DELETE FROM `creature` WHERE `id`=108060 AND `map`=1220 AND `zoneId`=7503;

DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (108084, 108081, 107988);
INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`) VALUES 
(108084,  46598, 1, 0), -- Bolas Launcher - Ride Vehicle Hardcoded
(108081, 220413, 1, 0), -- Bolas Launcher - Ride Bolas Launcher
(107988, 214537, 3, 0); -- Bolas Launcher - Summon Bolas Launcher

DELETE FROM `vehicle_template_accessory` WHERE `entry`=108084;
INSERT INTO `vehicle_template_accessory` (`entry`, `accessory_entry`, `seat_id`, `minion`, `description`, `summontype`, `summontimer`) VALUES 
(108084, 107660, 0, 1, 'Bolas Launcher - Bolas Skyfeather', 6, 30000);

DELETE FROM `conditions` WHERE `SourceEntry` IN (214538, 214473, 214479) AND `SourceTypeOrReferenceId` IN (13, 17);
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
(13, 1, 214538, 0, 0, 31, 0, 3, 107988, 0, 0, 0, 0, '', 'Summon Bolas Launcher - Bolas Launcher'),
(13, 3, 214473, 0, 0, 31, 0, 3, 108052, 0, 0, 0, 0, '', 'Launch Bolas - Coven Hag'),
(13, 3, 214473, 0, 1, 31, 0, 3, 108060, 0, 0, 0, 0, '', 'Launch Bolas - Coven Roc'),
(13, 3, 214479, 0, 0, 31, 0, 3, 108052, 0, 0, 0, 0, '', 'Flaming Bolas - Coven Hag'),
(13, 3, 214479, 0, 1, 31, 0, 3, 108060, 0, 0, 0, 0, '', 'Flaming Bolas - Coven Roc');

DELETE FROM `smart_scripts` WHERE `entryorguid` IN (108081, 108084, 108052, 108060) AND `source_type`=0 OR `entryorguid` IN (10808100, 10808101, 10808102, 10805200, 10805201) AND `source_type`=9;
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 
(108081, 0, 0, 1, 54, 0, 100, 0, 0, 0, 0, 0, 12, 108084, 1, 180000, 0, 0, 0, 8, 0, 0, 0, 4160.22, 4404.29, 768.482, 0.97334, 'Bolas Launcher - On Respawn - Summon Bolas Launcher Trigger'),
(108081, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 18, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Bolas Launcher - On Respawn - Set Immune Flags'),
(108081, 0, 2, 3, 61, 0, 100, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Bolas Launcher - On Respawn - Set Passive'),
(108081, 0, 3, 4, 61, 0, 100, 0, 0, 0, 0, 0, 103, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Bolas Launcher - On Respawn - Set Root'),
(108081, 0, 4, 0, 61, 0, 100, 0, 0, 0, 0, 0, 86, 220413, 0, 23, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Bolas Launcher - On Respawn - Cross Cast Ride Bolas Launcher'),

(108084, 0, 0, 1, 54, 0, 100, 0, 0, 0, 0, 0, 83, 16777216, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Bolas Launcher - On Respawn - Remove Spellclick Flag'),
(108084, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Bolas Launcher - On Respawn - Set Phase 1'),
(108084, 0, 2, 0, 60, 1, 100, 0, 1000, 2000, 3000, 6000, 87, 10808100, 10808101, 10808102, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Bolas Launcher - OOC - Run Random Script'),
(108084, 0, 3, 0, 60, 1, 100, 0, 2000, 3000, 4000, 7000, 66, 0, 0, 0, 0, 0, 0, 19, 108052, 100, 0, 0, 0, 0, 0, 'Bolas Launcher - OOC - Set Random Orientation'),
(108084, 0, 4, 0, 60, 1, 100, 0, 3000, 4000, 5000, 8000, 5, 61, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Bolas Launcher - OOC - Play Emote'),
(108084, 0, 5, 6, 38, 0, 100, 0, 1, 1, 0, 0, 41, 0, 0, 0, 0, 0, 0, 9, 108052, 0, 200, 0, 0, 0, 0, 'Bolas Launcher - On Data Set - Despawn'),
(108084, 0, 6, 7, 61, 0, 100, 0, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 9, 108060, 0, 200, 0, 0, 0, 0, 'Bolas Launcher - On Data Set - Despawn'),
(108084, 0, 7, 8, 61, 0, 100, 0, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Bolas Launcher - On Data Set - Despawn'),
(108084, 0, 8, 0, 61, 0, 100, 0, 0, 0, 0, 0, 22, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Bolas Launcher - On Data Set - Reset Phase'),

(10808100, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 108052, 1, 40000, 0, 0, 0, 8, 0, 0, 0, 4293.64, 4504.04, 800.849, 3.77156, 'Bolas Launcher - On Script - Summon Coven'),
(10808100, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 108052, 1, 40000, 0, 0, 0, 8, 0, 0, 0, 4313.35, 4467.64, 790.681, 3.55927, 'Bolas Launcher - On Script - Summon Coven'),
(10808100, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 108052, 1, 40000, 0, 0, 0, 8, 0, 0, 0, 4264.68, 4460.08, 802.207, 3.66881, 'Bolas Launcher - On Script - Summon Coven'),
(10808100, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 108060, 1, 40000, 0, 0, 0, 8, 0, 0, 0, 4264.65, 4489.54, 797.381, 3.81152, 'Bolas Launcher - On Script - Summon Coven'),
(10808101, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 108052, 1, 40000, 0, 0, 0, 8, 0, 0, 0, 4305.71, 4419.05, 800.439, 3.35241, 'Bolas Launcher - On Script - Summon Coven'),
(10808101, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 108052, 1, 40000, 0, 0, 0, 8, 0, 0, 0, 4293.61, 4387.81, 800.439, 3.22216, 'Bolas Launcher - On Script - Summon Coven'),
(10808101, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 108052, 1, 40000, 0, 0, 0, 8, 0, 0, 0, 4265.21, 4377.81, 778.383, 3.14222, 'Bolas Launcher - On Script - Summon Coven'),
(10808101, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 108060, 1, 40000, 0, 0, 0, 8, 0, 0, 0, 4275.94, 4418.61, 796.063, 3.40386, 'Bolas Launcher - On Script - Summon Coven'),
(10808102, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 108052, 1, 40000, 0, 0, 0, 8, 0, 0, 0, 4264.68, 4460.08, 802.207, 3.66881, 'Bolas Launcher - On Script - Summon Coven'),
(10808102, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 108052, 1, 40000, 0, 0, 0, 8, 0, 0, 0, 4313.35, 4467.64, 790.681, 3.55927, 'Bolas Launcher - On Script - Summon Coven'),
(10808102, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 108052, 1, 40000, 0, 0, 0, 8, 0, 0, 0, 4305.71, 4419.05, 800.439, 3.35241, 'Bolas Launcher - On Script - Summon Coven'),
(10808102, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 108060, 1, 40000, 0, 0, 0, 8, 0, 0, 0, 4275.94, 4418.61, 796.063, 3.40386, 'Bolas Launcher - On Script - Summon Coven'),

(108052, 0, 0, 1, 54, 0, 100, 0, 0, 0, 0, 0, 48, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Coven Hag - On Respawn - Set Active'),
(108052, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 102, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Coven Hag - On Respawn - Disable Health Regen'),
(108052, 0, 2, 3, 61, 0, 100, 0, 0, 0, 0, 0, 59, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Coven Hag - On Respawn - Set Walk'),
(108052, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 87, 10805200, 10805201, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Coven Hag - On Respawn - Run Random Pos'),
(108060, 0, 0, 1, 54, 0, 100, 0, 0, 0, 0, 0, 48, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Coven Roc - On Respawn - Set Active'),
(108060, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 102, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Coven Roc - On Respawn - Disable Health Regen'),
(108060, 0, 2, 3, 61, 0, 100, 0, 0, 0, 0, 0, 59, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Coven Roc - On Respawn - Set Walk'),
(108060, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 87, 10805200, 10805201, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Coven Roc - On Respawn - Run Random Pos'),

(10805200, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 69, 1, 0, 0, 0, 0, 0, 8, 0, 0, 0, 2992.57, 4219.97, 600.063, 0, 'Coven - On Script - Move to Pos'),
(10805201, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 69, 1, 0, 0, 0, 0, 0, 8, 0, 0, 0, 3061.13, 3619.51, 600.063, 0, 'Coven - On Script - Move to Pos'),

(108081, 0, 5, 6, 28, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 9, 108084, 0, 40, 0, 0, 0, 0, 'Bolas Launcher - On Passenger Removed - Data Set to Bolas Launcher'),
(108081, 0, 6, 7, 61, 0, 100, 0, 0, 0, 0, 0, 86, 214554, 0, 23, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Bolas Launcher - On Passenger Removed - Cross Cast Abandon Bolas Quest'),
(108081, 0, 7, 0, 61, 0, 100, 0, 0, 0, 0, 0, 103, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Bolas Launcher - On Passenger Removed - Reset Root');

[свернуть]

[Herald]

Ожидайте обновления.