Elevim Posted March 24, 2015 Report Share Posted March 24, 2015 (edited) Hey there, Well, I want to improve The Nexus, because many waypoints and spawns are missing. The problem is - they won´t start walking along the waypoints. I checked back other npcs, that allready have waypoints, but cannot find my mistake. So - here is an "example/test" npc: DELETE FROM creature WHERE guid = 3500688; INSERT INTO creature (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES (3500688, 26727, 576, 0, 0, 1, 1, 0, 1, 300.882, 102.991, -17.0831, 1.56127, 300, 5, 0, 37164, 16155, 2, 0, 0, 0, 0); DELETE FROM creature_addon WHERE guid = 3500688; INSERT INTO creature_addon (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES (3500688, 35006880, 0, 0, 0, 0, ''); DELETE FROM waypoint_data WHERE id = 35006880; INSERT INTO waypoint_data (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES (35006880, 1, 301.077, 11.823, -17.083, 0, 0, 0, 0, 100, 0), (35006880, 2, 300.298, 90.77, -17.083, 0, 0, 0, 0, 100, 0); If you kill/respawn (or load manual via command the waypoints) the creature, it will start walking along the points. Any ideas? Where is my mistake? Kind regards, Elevim /edit: TDB_full_335.57_2014_10_19 Edited March 24, 2015 by Elevim Link to comment Share on other sites More sharing options...
Bigfoot Posted February 10, 2020 Report Share Posted February 10, 2020 INSERT INTO creature (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES (3500688, 26727, 576, 0, 0, 1, 1, 0, 1, 300.882, 102.991, -17.0831, 1.56127, 300, 5, 35006800, 37164, 16155, 2, 0, 0, 0, 0); Yes, the correction is in red. I know this is old but nobody tried helping. Kind Regards, Tracey Gorrell [email protected] aka Bigfoot on Ac-Web Link to comment Share on other sites More sharing options...
Recommended Posts