[LF] Need DB developers for the Emucoach repack projects
What's new

Sha Can Awe and Ahead of the Way Fixes

orangefire

orangefire

Gold Supporter
MoP Premium
Veteran Member
112
2021
91
I noticed the quest Sha Can Awe was not working well, I wasn't getting credit which I later realized was only one of the two defender entries was actually scripted. I fixed the acolytes to have the proper scripting, made Anduin do his light explosion visual, and fixed the defenders to properly remove the sha aura visual after being inspired.

Edit: Adjacent quest Ahead on the Way was not giving credit at all, the Maws of Despair had their script triggers for their spell casts messed up, and a bunch of Ripples of Despair were spawned into the world when they shouldn't be. Made some more fixes so this quest gives proper credit and the fights work mostly properly. (Exact script pacing is hard to find data on so I just put something that seemed reasonable for it.)

Also fixed the missing visual on Ripple of Despair creatures so they aren't just floating health bars that hit you.

SQL: 
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `text_female`, `TextRange`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `comment`) VALUES (58969, 0, 5, 'Of course. We must not lose hope.', NULL, 0, 12, 0, 12.5, 0, 0, 0, 0, 'Hopeless Monk Krasarang Wilds');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `text_female`, `TextRange`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `comment`) VALUES (58969, 0, 4, 'No, I cannot let it end like this. I have to keep fighting!', NULL, 0, 12, 0, 12.5, 0, 0, 0, 0, 'Hopeless Monk Krasarang Wilds');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `text_female`, `TextRange`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `comment`) VALUES (58969, 0, 3, 'It was... so dark...', NULL, 0, 12, 0, 12.5, 0, 0, 0, 0, 'Hopeless Monk Krasarang Wilds');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `text_female`, `TextRange`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `comment`) VALUES (58969, 0, 2, 'It seems we haven\'t lost yet.', NULL, 0, 12, 0, 12.5, 0, 0, 0, 0, 'Hopeless Monk Krasarang Wilds');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `text_female`, `TextRange`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `comment`) VALUES (58969, 0, 1, 'I... I don\'t know what came over me.', NULL, 0, 12, 0, 12.5, 0, 0, 0, 0, 'Hopeless Monk Krasarang Wilds');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `text_female`, `TextRange`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `comment`) VALUES (58969, 0, 0, 'How can I give up when heroes still fight at my side?', NULL, 0, 12, 0, 12.5, 0, 0, 0, 0, 'Hopeless Monk Krasarang Wilds');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `text_female`, `TextRange`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `comment`) VALUES (58969, 0, 6, 'So they CAN die... I have to stay focused.', NULL, 0, 12, 0, 12.5, 0, 0, 0, 0, 'Hopeless Monk Krasarang Wilds');
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `text_female`, `TextRange`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `comment`) VALUES (58969, 0, 7, 'Thank you, I had lost sight of the Way.', NULL, 0, 12, 0, 12.5, 0, 0, 0, 0, 'Hopeless Monk Krasarang Wilds');
DELETE FROM `smart_scripts` WHERE `entryorguid`  IN (58968, 58969, 59608, 59237, 59315) AND `source_type`=0;
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 (58968, 0, 0, 1, 38, 0, 100, 1, 0, 1, 0, 0, 33, 59297, 0, 0, 0, 0, 0, 18, 8, 0, 0, 0, 0, 0, 0, 'On data set 1 give credit to player');
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 (58968, 0, 1, 2, 61, 0, 100, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On link say text 0');
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 (58968, 0, 2, 3, 61, 0, 100, 1, 0, 0, 0, 0, 89, 10, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On link start random movement');
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 (58968, 0, 3, 4, 61, 0, 100, 0, 0, 0, 0, 0, 41, 3000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On link force despawn');
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 (58968, 0, 4, 0, 61, 0, 100, 0, 0, 0, 0, 0, 28, 129572, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On link force despawn');
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 (58969, 0, 0, 1, 38, 0, 100, 1, 0, 1, 0, 0, 33, 59297, 0, 0, 0, 0, 0, 18, 8, 0, 0, 0, 0, 0, 0, 'On data set 1 give credit to player');
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 (58969, 0, 1, 2, 61, 0, 100, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On link say text 0');
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 (58969, 0, 2, 3, 61, 0, 100, 1, 0, 0, 0, 0, 89, 10, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On link start random movement');
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 (58969, 0, 3, 4, 61, 0, 100, 0, 0, 0, 0, 0, 41, 3000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On link force despawn');
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 (58969, 0, 4, 0, 61, 0, 100, 0, 0, 0, 0, 0, 28, 129572, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On link force despawn');
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 (59237, 0, 0, 0, 2, 0, 100, 1, 0, 50, 0, 0, 11, 113998, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Cast Torrent of Despair');
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 (59237, 0, 1, 0, 0, 0, 100, 0, 8000, 10000, 12000, 15000, 11, 129921, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Cast Wail of Despair');
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 (59237, 0, 2, 0, 6, 0, 100, 0, 0, 0, 0, 0, 45, 0, 2, 0, 0, 0, 0, 19, 59608, 0, 0, 0, 0, 0, 0, 'On death set data 1 to anduin');
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 (59315, 0, 0, 0, 2, 0, 100, 1, 0, 50, 0, 0, 11, 113998, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Cast Torrent of Despair');
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 (59315, 0, 1, 0, 0, 0, 100, 0, 8000, 10000, 12000, 15000, 11, 129921, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Cast Wail of Despair');
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 (59315, 0, 2, 0, 6, 0, 100, 0, 0, 0, 0, 0, 45, 0, 4, 0, 0, 0, 0, 19, 59608, 0, 0, 0, 0, 0, 0, 'On death set data 1 to anduin');
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 (59608, 0, 0, 1, 38, 0, 100, 0, 0, 1, 0, 0, 45, 0, 1, 0, 0, 0, 0, 19, 58968, 0, 0, 0, 0, 0, 0, 'On data 1 give credit to player');
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 (59608, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 129783, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Anduin Red Crane Scripting');
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 (59608, 0, 2, 1, 38, 0, 100, 0, 0, 1, 0, 0, 45, 0, 1, 0, 0, 0, 0, 19, 58969, 0, 0, 0, 0, 0, 0, 'On data 1 give credit to player');
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 (59608, 0, 3, 4, 38, 0, 100, 0, 0, 4, 0, 0, 33, 59314, 1, 0, 0, 0, 0, 18, 20, 0, 0, 0, 0, 0, 0, 'Anduin Red Crane Scripting');
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 (59608, 0, 4, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 129791, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On data 1 give credit to player');
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 (59608, 0, 5, 4, 38, 0, 100, 0, 0, 2, 0, 0, 33, 59313, 1, 0, 0, 0, 0, 18, 20, 0, 0, 0, 0, 0, 0, 'Anduin Red Crane Scripting');
DELETE FROM creature WHERE id IN (59306);
UPDATE creature_template SET modelid1 = 40625 WHERE entry IN (59306);
 
Last edited:
You must log in or register to reply here.
Top