creature_movement

Description of the 'creature_movement' table for MaNGOSThree

This table holds all the information on each creature's waypoints. In essence, a set of waypoints just defines a path that the creature will follow by going from point to point. More specifically, once the creature arrives at a point, it can do different things like cast a spell, do an emote, etc. Usually this table is filled through the .wp command (and its various subcommands) in the world.

Please note that for a creature to use waypoints, its MovementType must be 2.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

id int(10) unsigned

Creature GUID [See creature.guid].

point mediumint(8) unsigned

An index count for all movement points attached to a creature spawn. Starts with 1 and increments by one.

position_x float

The X position for the creature's movement point.

position_y float

The Y position for the creature's movement point.

position_z float

The Z position for the creature's movement point.

waittime int(10) unsigned

If the creature should wait at the movement point, set this to the time in milliseconds. Otherwise set to zero for the creature to immediately proceed to the next movement point.

script_id mediumint(8) unsigned

If a script should be executed, this references the db_scripts table [See db_scripts.id] with a type of 3 to form a unique ID for which the entry is valid. If not, set the value to zero.

textid1 int(11)

If a text should be emoted, this references the "db_script_string" table tables unique ID for which the entry is valid. If not, set the value to zero.

textid2 int(11)

If a text should be emoted, this references the "db_script_string" table tables unique ID for which the entry is valid. If not, set the value to zero.

textid3 int(11)

If a text should be emoted, this references the "db_script_string" table tables unique ID for which the entry is valid. If not, set the value to zero.

textid4 int(11)

If a text should be emoted, this references the "db_script_string" table tables unique ID for which the entry is valid. If not, set the value to zero.

textid5 int(11)

If a text should be emoted, this references the "db_script_string" table tables unique ID for which the entry is valid. If not, set the value to zero.

emote mediumint(8) unsigned

Emote ID that the creature should perform.

List of often used emote IDs and what they do ie. 65 Makes the creature look dead by lying on the ground.

spell mediumint(8) unsigned

The spell identifier. The value has to match with a spell identifier defined in Spell.dbc. This refers to a spell which should be cast by the creature on this waypoint.

wpguid int(11)

A unique identifier for this waypoint.

orientation float

The orientation for the creature's movement point. Measured in radians, where 0 is north on the mini-map and pi is south on the mini-map.

model1 mediumint(9)

A display model identifier activated on the waypoint. This references the "creature_model_info" table tables unique ID for which this entry is valid.

model2 mediumint(9)

An alternative display model identifier activated on the waypoint. This references the "creature_model_info" table tables unique ID for which this entry is valid.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module