[Legion]: Grizzled Ben

[Herculano]

Title: Grizzled Ben
Bugtracker Link:

https://firestorm-servers.com/es/report/see_report/30660

Patch Content:

-- Grizzled Ben
-- http://www.wowhead.com/npc=50926
UPDATE `creature_template` SET type_flags ='65537' WHERE entry='50926';
SET @CGUID := xxxxxx;

DELETE FROM `creature` WHERE `guid`=@CGUID;

INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
(@CGUID, 50926, 0, 12, 60, 1, 1, 0, 0, 0, -9501.841, 587.4207, 52.40701, 4.33007, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420);

DELETE FROM `creature_addon` WHERE `guid`=@CGUID;
INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
(@CGUID, 0, 0, 3, 0, 0, '');

 

[Mikrole]

On 8.2.2017 at 6:36 PM, Herculano said:

Title: Grizzled Ben
Bugtracker Link:

https://firestorm-servers.com/es/report/see_report/30660

Patch Content:

 

-- Grizzled Ben
-- http://www.wowhead.com/npc=50926
UPDATE `creature_template` SET type_flags ='65537' WHERE entry='50926';
SET @CGUID := xxxxxx;

DELETE FROM `creature` WHERE `guid`=@CGUID;

INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
(@CGUID, 50926, 0, 12, 60, 1, 1, 0, 0, 0, -9501.841, 587.4207, 52.40701, 4.33007, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420);

DELETE FROM `creature_addon` WHERE `guid`=@CGUID;
INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
(@CGUID, 0, 0, 3, 0, 0, '');

 

 

Most Rare NPC's which got added between 5.1 and 5.4 aren't spawned, indeed. But also they got issues with their model. I will look into this.

[Mikrole]

Patch accepted, merged soon on live realm. Thanks!