[Solved][Two] Waypoints

[Necrovoice]

With my work that I have been doing on some NPC waypoints I have came across an issue upon a server reset. My NPCs will ignore their waypoints and just stand around. I have changed their move value to both 0 and 1, both with the same result. they stand (or move around) in one spot. I can add another way point to get them moving but once I reset the server they return to their spawn and continue with their ignoring the waypoints. If needed I can post their database information for further review if someone things that's the cause.

[MrFreak]

Hi necrovoice,

please provide us with more details like the necessary content of your database.

[Necrovoice]

I pulld this from a sql dump of the table. Figure it was the best way to get the information you would need.

In creature table currentwaypointis set to 0. I have also changed this to 1 with no change in NPC movement after reset.

insert into `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) values('82514','16315','530','1','1','0','0','7020.74','-5738.52','104.97','4.58891','300','5','0','270','295','0','1');

insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('82514','2','7024.42','-5765.33','92.5564','0','0','0','0','0','0','0','0','0','151385','4.89857','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('82514','3','7022.39','-5790.88','80.1896','0','0','0','0','0','0','0','0','0','151386','4.19171','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('82514','1','7020','-5738.52','104.97','0','0','0','0','0','0','0','0','0','151384','0','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('82514','5','6983.29','-5847.61','45.9809','0','0','0','0','0','0','0','0','0','151388','4.41633','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('82514','6','6979.86','-5871.33','34.9409','0','0','0','0','0','0','0','0','0','151389','5.02815','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('82514','4','6995.64','-5825.79','58.0424','0','0','0','0','0','0','0','0','0','151387','3.90897','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('82514','7','6980.42','-5901.73','27.6123','0','0','0','0','0','0','0','0','0','151390','1.43132','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('82514','8','6979.91','-5870.92','35.056','0','0','0','0','0','0','0','0','0','151391','4.87215','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('82514','9','6983.32','-5847.19','46.1829','0','0','0','0','0','0','0','0','0','151392','4.61973','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('82514','10','6995.63','-5825.45','58.1888','0','0','0','0','0','0','0','0','0','151393','1.03831','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('82514','11','7022.39','-5790.46','80.3857','0','0','0','0','0','0','0','0','0','151394','1.62736','0','0');
insert into `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) values('82514','12','7024.42','-5764.83','92.8454','0','0','0','0','0','0','0','0','0','151395','1.67448','0','0');

I have a working file of all my current changed attached to another thread if you wanted to have a look at that.

https://getmangos.eu/index.php?topic=21471.msg158660#msg158660

[Hikari]

I have changed their move value to both 0 and 1 [..]

Please note that waypoint movement is used with MovementType 2.

0 = Idle; stay in one place

1 = Random movement inside the spawndist radius

2 = Waypoint movement

[Necrovoice]

wow, was that simple? Man do I fill silly.

Thanks a bunch