- 916
- 2015
- 24
- Location
- Barryton Michigan USA
The undead should be in the grave, Not on the ground next to it.
Code:
-- 24959 Fresh out of the Grave Placement Fix
-- Undead Create Coordinates
DELETE FROM `playercreateinfo` WHERE `race`=5 AND `class`=9;
INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES (5, 9, 0, 85, 1704.27, 1703.97, 133.81, 4.59);
DELETE FROM `playercreateinfo` WHERE `race`=5 AND `class`=6;
INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES (5, 6, 609, 4298, 2355.84, -5662.21, 426.028, 3.93485);
DELETE FROM `playercreateinfo` WHERE `race`=5 AND `class`=5;
INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES (5, 5, 0, 85, 1704.27, 1703.97, 133.81, 4.59);
DELETE FROM `playercreateinfo` WHERE `race`=5 AND `class`=3;
INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES (5, 3, 0, 85, 1704.27, 1703.97, 133.81, 4.59);
DELETE FROM `playercreateinfo` WHERE `race`=5 AND `class`=1;
INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES (5, 1, 0, 85, 1704.27, 1703.97, 133.81, 4.59);
-- Agatha 49044 Placement Fix
DELETE FROM `creature` WHERE `id`=49044;
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 (49044, 0, 85, 5692, 1, 1, 0, 0, 1704.44, 1701.71, 135.973, 1.37036, 120, 0, 0, 5580, 3820, 0, 0, 0, 0, 0);