Currently I'm going through Blackwing Descent and finding issues to report to improve the quality of the repack. I've currently found bugs for most of the bosses and will report them when I finish going through the raid. I'll be doing this for all of them and will try to be as extensive as possible for reports on each raid. Although I'm unable to fix most of the stuff because it requires core edits, I am fixing what can be done through the database to reduce the work done by the developers here.
That being said, this post will include some pathing for trash mobs and correcting some positions.
I currently have done bug reports for 3 bosses from BWD, and once I finish finding major bugs from the bosses I'll report them here. You can take a look at my progress on my github repository: https://github.com/Crypticaz/Emucoach-v10-Fixes
That being said, this post will include some pathing for trash mobs and correcting some positions.
Code:
Maimgor, Ivoroc & Pyrecraw
-- I believe these npcs are supposed to be sleeping/flying around the place.
-- Fix for flying (not pathing) - Pyrecraw
UPDATE `creature_template` SET `InhabitType`='4' WHERE `entry`=42764;
INSERT INTO `creature_template_addon` (`entry`, `bytes1`, `bytes2`) VALUES ('42764', '50331648', '1');
-- Fix for flying (not pathing) - Maimgor
UPDATE `creature_template` SET `InhabitType`='4' WHERE `entry`=42768;
INSERT INTO `creature_template_addon` (`entry`, `bytes1`, `bytes2`) VALUES ('42768', '50331648', '1');
-- Fix for flying (not pathing) - Ivoroc
INSERT INTO `creature_template_addon` (`entry`, `bytes1`, `bytes2`) VALUES ('42767', '50331648', '1');
Trash Mobs
-- Trash mobs don't seem to have waypoints/pathing. This should do the trick.
-- Pathing for Drakonid Slayer Entry: 42802 'TDB FORMAT'
-- Formation Leader
SET @NPC := 173080;
SET @PATH := @NPC * 10;
UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-58.55208,`position_y`=-146.7934,`position_z`=63.61993 WHERE `guid`=@NPC;
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`inverse_formation_angle`,`wpguid`) VALUES
(@PATH,1,-58.55208,-146.7934,63.61993,0,0,0,0,100,0,0),
(@PATH,2,-49.15278,-154.2222,63.5876,0,0,0,0,100,0,0),
(@PATH,3,-38.97743,-165.0486,63.60661,0,0,0,0,1100,0,0),
(@PATH,4,-28.82639,-177.2483,63.61633,0,0,0,0,100,0,0),
(@PATH,5,-23.15278,-189.2934,63.67587,0,0,0,0,100,0,0),
(@PATH,6,-16.60243,-203.5608,63.37911,0,0,0,0,100,0,0),
(@PATH,7,-13.19097,-217.3576,63.49108,0,0,0,0,100,0,0),
(@PATH,8,-16.60243,-203.5608,63.37911,0,0,0,0,100,0,0),
(@PATH,9,-23.15278,-189.2934,63.67587,0,0,0,0,100,0,0),
(@PATH,10,-28.82639,-177.2483,63.61633,0,0,0,0,100,0,0),
(@PATH,11,-38.97743,-165.0486,63.60661,0,0,0,0,100,0,0),
(@PATH,12,-49.15278,-154.2222,63.5876,0,0,0,0,100,0,0);
DELETE FROM `creature_formations` WHERE `leaderGUID` = 173080;
INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`,`point_1`,`point_2`) VALUES
(173080,173080,0,0,2,0,0),
(173080,172993,6,300,2,1,7),
(173080,173079,6,60,2,1,7);
-- Pathing for Drakonid Slayer Entry: 42802 'TDB FORMAT'
-- Formation Leader
SET @NPC := 173081;
SET @PATH := @NPC * 10;
UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-55.96875,`position_y`=-299.4462,`position_z`=63.65685 WHERE `guid`=@NPC;
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`inverse_formation_angle`,`wpguid`) VALUES
(@PATH,1,-55.96875,-299.4462,63.65685,0,0,0,0,100,0,0),
(@PATH,2,-47.11806,-293.8333,63.58841,0,0,0,0,100,0,0),
(@PATH,3,-40.125,-286.4496,63.59059,0,0,0,0,100,0,0),
(@PATH,4,-33.0434,-277.9757,63.59935,0,0,0,0,100,0,0),
(@PATH,5,-27.32465,-267.566,63.57638,0,0,0,0,100,0,0),
(@PATH,6,-21.69965,-257.3871,63.57293,0,0,0,0,100,0,0),
(@PATH,7,-19.23785,-249.0052,63.49329,0,0,0,0,100,0,0),
(@PATH,8,-16.08681,-235.8368,63.35617,0,0,0,0,100,0,0),
(@PATH,9,-19.23785,-249.0052,63.49329,0,0,0,0,100,0,0),
(@PATH,10,-21.69965,-257.3871,63.57293,0,0,0,0,100,0,0),
(@PATH,11,-27.32465,-267.566,63.57638,0,0,0,0,100,0,0),
(@PATH,12,-33.0434,-277.9757,63.59935,0,0,0,0,100,0,0),
(@PATH,13,-40.125,-286.4496,63.59059,0,0,0,0,100,0,0),
(@PATH,14,-47.11806,-293.8333,63.58841,0,0,0,0,100,0,0);
DELETE FROM `creature_formations` WHERE `leaderGUID` = 173081;
INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`,`point_1`,`point_2`) VALUES
(173081,173081,0,0,2,0,0),
(173081,172837,6,300,2,1,7),
(173081,172836,6,60,2,1,7);