Alliance Log Ride , Horde Log Ride in the GrizzlyHills

[Krutok]

Description

Alliance Log Ride and Horde Log Ride Not work. I created a patch for this and forked from Azerothcore. With this fix it works now. See my video about it. Yes, I know I shouldn't post it like this, but this is the first solution I've been able to fix. I did it step by step and always copied the lines of code.

--> https://www.youtube.com/watch?v=1WqiN04HWIo

SQL fix

-- FIX Darrok smart ai
SET @ENTRY := 27425;
DELETE FROM `smart_scripts` WHERE `source_type` = 0 AND `entryOrGuid` = @ENTRY;
UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` = @ENTRY;
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
(@ENTRY, 0, 0, 1, 62, 0, 100, 512, 9528, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'On gossip action Yes, I am ready to travel... (0) from menu 9528 selected - Gossip player: Close gossip'),
(@ENTRY, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 85, 48960, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'On gossip action Yes, I am ready to travel... (0) from menu 9528 selected - Gossip player: Cast spell Horde Log Ride 01 Begin (48960) on self'),
(@ENTRY, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 85, 48961, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'On gossip action Yes, I am ready to travel... (0) from menu 9528 selected - Gossip player: Cast spell Log Ride Horde 00 (48961) on self');


DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 22 AND `SourceEntry` = 27425 AND `SourceId` = 0;

 -- Fix Gordun smart ai
SET @ENTRY := 27414;
DELETE FROM `smart_scripts` WHERE `source_type` = 0 AND `entryOrGuid` = @ENTRY;
UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` = @ENTRY;
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
(@ENTRY, 0, 0, 1, 62, 0, 100, 512, 21251, 1, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'On gossip action Yes, I am ready to travel... (1) from menu 21251 selected - Gossip player: Close gossip'),
(@ENTRY, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 85, 48622, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'On gossip action Yes, I am ready to travel... (1) from menu 21251 selected - Gossip player: Cast spell Alliance Log Ride 01 Begin (48622) on self'),
(@ENTRY, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 85, 48621, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'On gossip action Yes, I am ready to travel... (1) from menu 21251 selected - Gossip player: Cast spell Log Ride Alliance 01 (48621) on self');


DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 22 AND `SourceEntry` = 27414 AND `SourceId` = 0;

-- Alliance NPC 27414 have no AINAME

UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 27414;

-- Fix Alliance Gossip Menu Options and Broadcast Text

DELETE FROM `gossip_menu_option` WHERE `MenuID` = 21251;
INSERT INTO `gossip_menu_option` (`MenuID`, `OptionID`, `OptionIcon`, `OptionText`, `OptionBroadcastTextID`, `OptionType`, `OptionNpcFlag`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `VerifiedBuild`) VALUES
(21251, 1, 0, 'Yes, I am ready to travel to Venture Bay!', 26605, 1, 1, 0, 0, 0, 0, NULL, 0, 0);
DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId` = 15) AND (`SourceGroup` IN (21251));

DELETE FROM `gossip_menu` WHERE `MenuID` = 21251;
INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES
(21251, 8076, 0),
(21251, 12845, 0);
DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId` = 14) AND (`SourceGroup` IN (21251));


INSERT INTO `broadcast_text` (`ID`, `LanguageID`, `Text`, `Text1`, `EmoteID1`, `EmoteID2`, `EmoteID3`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `SoundEntriesID`, `EmotesID`, `Flags`, `VerifiedBuild`) VALUES
(26605, 0, 'Yes, I am ready to travel to Venture Bay!', 'Yes, I am ready to travel to Venture Bay!', 0, 0, 0, 0, 0, 0, 0, 0, 1, 18019);


INSERT INTO `broadcast_text_locale` (`ID`, `locale`, `Text`, `Text1`, `VerifiedBuild`) VALUES
(26605, 'deDE', 'Ja, ich bin bereit, in die Venturebucht zu reisen!', 'Ja, ich bin bereit, in die Venturebucht zu reisen!', 18019),
(26605, 'esES', '¡Sí, estoy preparado para viajar a Bahía Ventura!', '¡Sí, estoy preparada para viajar a Bahía Ventura!', 18019),
(26605, 'esMX', '¡Sí, estoy preparado para viajar a Bahía Ventura!', '¡Sí, estoy preparada para viajar a Bahía Ventura!', 18019),
(26605, 'frFR', 'Oui, je suis prêt à aller à la baie de la KapitalRisk !', 'Oui, je suis prête à aller à la baie de la KapitalRisk !', 18019),
(26605, 'koKR', '예, 투자개발 만으로 갈 준비를 마쳤습니다!', '예, 투자개발 만으로 갈 준비를 마쳤습니다!', 18019),
(26605, 'ruRU', 'Да, я готов отправиться в Бухту торговцев!', 'Да, я готова отправиться в Бухту торговцев!', 18019),
(26605, 'zhCN', '是的，我已经准备好前往风险湾了！', '是的，我已经准备好前往风险湾了！', 18019),
(26605, 'zhTW', '是的，我準備好要去風險海灣了!', '是的，我準備好要去風險海灣了!', 18019);

Branch

3.3.5

TC rev. hash/commit

TrinityCore rev. bac3eda13574+ 2022-08-03 09:24:05 +0200 (3.3.5 branch) (Unix, RelWithDebInfo, Static)