So here is the sql stuff.
On Waypoint 1 NPC should start to run but it doesnt work...
it just walks to waypoint 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 and then it walks strait to the spawnpoint of this npcs and there it walks with random movement and will never stops
creature.sql
replace 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
(40000,50000,0,1,1,0,0,x,x,x,x,25,5,0,42,0,0,2);
creature_movement.sql
replace 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
(40000,1,x,x,x,0,1,0,0,0,0,0,0,0,0,x,0,0),
(40000,2,x,x,x,0,0,0,0,0,0,0,0,0,0,x,0,0),
(40000,3,x,x,x,0,0,0,0,0,0,0,0,0,0,x,0,0),
(40000,4,x,x,x,0,0,0,0,0,0,0,0,0,0,x,0,0),
(40000,5,x,x,x,0,0,0,0,0,0,0,0,0,0,x,0,0),
(40000,6,x,x,x,0,0,0,0,0,0,0,0,0,0,x,0,0),
(40000,7,x,x,x,0,0,0,0,0,0,0,0,0,0,x,0,0),
(40000,8,x,x,x,0,0,0,0,0,0,0,0,0,0,x,0,0),
(40000,9,x,x,x,0,0,0,0,0,0,0,0,0,0,x,0,0),
(40000,10,x,x,x,60000,2,0,0,0,0,0,0,0,0,x,0,0),
(40000,11,x,x,x,0,0,0,0,0,0,0,0,0,0,x,0,0),
(40000,12,x,x,x,0,0,0,0,0,0,0,0,0,0,x,0,0),
(40000,13,x,x,x,0,0,0,0,0,0,0,0,0,0,x,0,0),
(40000,14,x,x,x,0,0,0,0,0,0,0,0,0,0,x,0,0),
(40000,15,x,x,x,0,0,0,0,0,0,0,0,0,0,x,0,0),
(40000,16,x,x,x,0,0,0,0,0,0,0,0,0,0,x,0,0),
(40000,17,x,x,x,0,0,0,0,0,0,0,0,0,0,x,0,0),
(40000,18,x,x,x,0,0,0,0,0,0,0,0,0,0,x,0,0),
(40000,19,x,x,x,0,0,0,0,0,0,0,0,0,0,x,0,0),
(40000,20,x,x,x,60000,2,0,0,0,0,0,0,0,0,x,0,0);
creature_movement_script.sql
replace into `creature_movement_scripts`(`id`,`delay`,`command`,`datalong`,`datalong2`,`buddy_entry`,`search_radius`,`data_flags`,`dataint`,`dataint2`,`dataint3`,`dataint4`,`x`,`y`,`z`,`o`,`comments`)
values
(2,60,20,2,0,50000,5,0,0,0,0,0,0,0,0,0,'Waypoint Movement'),
(1,0,25,1,0,50000,5,0,0,0,0,0,0,0,0,0,'Run'),
(2,0,20,1,0,50000,5,0,0,0,0,0,0,0,0,0,'Random Movement');
just replaced the x,y,z,o stuff with x its not importand