Getting Creatures to move!
:Step 1: Building the monster
First, you will need to create the creature. So open up your database, and create a creature with any details you want, or you can execute this sample creature into your database:
INSERT INTO `creature_names` VALUES ('25000', 'Gastricpenguin SAMPLE', 'Drug Dealer', '0', '7', '0', '0', '0', null, '21280', '1', '1', '0', '0');
INSERT INTO `creature_proto` VALUES ('25000', '70', '70', '35', '5000', '5000', '0', '1', '0', '1000', '111', '111', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1000', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '8000000', '0', '0');
NOTE: Remember your creature's DisplayID!
:Step 2: Getting the GuID
Restart your server and Log into the game.
Next, spawn your creature by using the .npc sp <ID> command. If you used my creature - it would be: .npc sp 250000
Once your creature is spawned, highlight it and type .npc info.
You will see info like this come up:
The Sql Entry ID, is what you want. So in my case - the number i want is: 340267044
:Step 3: Getting the Waypoints
While still ingame, find 3 spots near your creature. At those three spots, do the .gps command to find out your Coordinates. At this points, i cannot provide my own numbers - as we have spawned our creatures in different locations.
To make your life easier, you can run this script into your DB once you have filled in the correct information:
INSERT INTO `creature_waypoints` VALUES ('SQL ENTRY', 'waypointID', 'X', 'Y', 'Z', '5000', '0', '1', '0', '1', '0', 'DisplayID', 'DisplayID');
SQL Entry: The Id you obtained in step 2
WaypointId: If you have multiple Waypoints, this is the order the creature will go in. For your first waypoint, put in 1
X: Your X coordinate of your waypoint
Y: Your Y coordinate of your waypoint
Z: Your Z coordinate of your waypoint
DisplayID: The DisplayID of your creature, the one i used was 21280
DisplayID: The DisplayID of your creature, the one i used was 21280
Extra notes: Your second waypoint must have WaypointID set to 2. Your third waypoint must have WaypointID set to 3.
:Step 4: Restarting your Server.
Restart your server and log in game. Then locate your creature! If you used 3 waypoints, he will walk to one - wait 5 seconds - Then walk to another waypoint, so on and so forth.
All credits go to GASTRICPENGUIN. If this guide is posted anywhere else but mmowned. Expect to be in some serious shit.