Undercity Invisible Creatures V8 Martha Alliestar Katrina Alliestar

[eyerobot]

It seems that some of the data in creature template bugged out when it was copied into the creature table. Deleting and reinserting these creatures makes them visible again.

-- 4614 Martha Alliestar Invis Fix
-- 4615 Katrina Alliestar Invis Fix
DELETE FROM `creature` WHERE `id`=4614;
INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (4614, 0, 0, 0, 1, 1, 0, 0, 1560.8, 355.098, -62.0798, 3.97935, 90, 0, 0, 1, 0, 0, 0, 0, 0, 0);

DELETE FROM `creature` WHERE `id`=4615;
INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (4615, 0, 0, 0, 1, 1, 0, 0, 1564.79, 348.156, -62.0733, 3.22886, 90, 0, 0, 1, 0, 0, 0, 0, 0, 0);

-- 5707 Reginald Grimsford Duped
UPDATE `creature_template` SET `MovementType` = 0 WHERE `entry` = 5707;

DELETE FROM `creature` WHERE `id`=5707;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (19657, 5707, 0, 1497, 1497, 1, 1, 4064, 0, 1728.59, 226.683, -62.1777, 4.93865, 90, 0, 0, 484, 0, 0, 0, 0, 0, 0);


-- 5701 Selina Pickman Duped
UPDATE `creature_template` SET `MovementType` = 0 WHERE `entry` = 5701;

DELETE FROM `creature` WHERE `id`=5701;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (19528, 5701, 0, 1497, 1497, 1, 1, 4058, 0, 1731.39, 226.295, -62.1777, 5.00026, 90, 0, 0, 484, 0, 0, 0, 0, 0, 0);

 

[ExO]

Executed thanks