[Battle for Azeroth]: [Bfa]Groyat, The Blind Hunter

[jela]

Title: [Bfa]Groyat, The Blind Hunter
Bugtracker Link:

https://firestorm-servers.com/en/report/see_report/102710

Patch Content:

Spoiler

-- 75247 Groyat, the Blind Hunter
DELETE FROM `creature_template` WHERE `entry`='75247'

INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `name`, `femaleName`, `subname`, `TitleAlt`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `HealthScalingExpansion`, `RequiredExpansion`, `VignetteID`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `dmgschool`, `BaseAttackTime`, `RangeAttackTime`, `BaseVariance`, `RangeVariance`, `unit_class`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `family`, `trainer_type`, `trainer_class`, `trainer_race`, `type`, `type_flags`, `type_flags2`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `HealthModifier`, `HealthModifierExtra`, `ManaModifier`, `ManaModifierExtra`, `ArmorModifier`, `DamageModifier`, `ExperienceModifier`, `RacialLeader`, `movementId`, `FadeRegionRadius`, `WidgetSetID`, `WidgetSetUnitConditionID`, `RegenHealth`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `VerifiedBuild`) values
('75247','0','0','0','0','0','Groyat, the Blind Hunter','','','','','0','35','35','5','0','0','14','0','1','1.14286','1','1','0','2000','2000','1','1','4','0','0','0','0','0','0','0','0','1','270532680','0','75247','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1000','2000','','0','3','1','20','1','1','1','1','1','1','0','0','0','0','0','1','0','0','','35662');

-- Not sure how to get guid here,some changes may be needed
DELETE FROM `creature` WHERE `id`='75247'
SET `guid`=@Guid
INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) values
('@Guid','75247','47','0','0','1','0','0','0','-1','0','0','2083.19','2005.93','62.8982','4.303','300','0','0','19835','0','0','0','0','0','0','0','','0');


-- 4425 Blind Hunter(REMOVED IN WOD)
DELETE FROM `creature` WHERE `id`='4425'
-- 4427 Ward Guardian(REMOVED IN WOD)
DELETE FROM `creature` WHERE `id`='4427'
-- 4625 Death's Head Ward Keeper(REMOVED IN WOD)
DELETE FROM `creature` WHERE `id`='4625'
-- 4519 Death's Head Seer(REMOVED IN WOD)
DELETE FROM `creature` WHERE `id`='4519'
-- 4422 Agathelos the Raging(Groyat, the Blind Hunter should be a top of his corpse)
DELETE FROM `creature` WHERE `id`='4422'