186498 Gjalerbron Cage Missing

[eyerobot]

186498 Gjalerbron Cage Missing Prisoners Missing

-- 186498 Gjalerbron Cage

DELETE FROM `gameobject` WHERE `id`=186498;
INSERT INTO `gameobject` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (186498, 571, 495, 4006, 1, 1, 2642.76, -3516.55, 206.025, 5.7216, 0, 0, 0.27712, -0.960835, 300, 0, 1);

-- 24035 Gjalerbron Prisoner Missing
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 (24035, 571, 0, 0, 1, 1, 22017, 0, 2658.47, -3567.12, 205.25, 4.76475, 90, 3, 0, 3524, 0, 1, 0, 0, 0, 0);
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 (24035, 571, 0, 0, 1, 1, 22016, 0, 2658.47, -3567.12, 205.25, 2.94961, 90, 3, 0, 3524, 0, 1, 0, 0, 0, 0);
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 (24035, 571, 0, 0, 1, 1, 22017, 0, 2658.47, -3567.12, 205.25, 2.16421, 90, 3, 0, 3524, 0, 1, 0, 0, 0, 0);

 

[ExO]

Executed, thanks !