Add new Edit Delete History Source

Important: As of 19/09/24 all versions of MariaDB, MySQL 5.7 and 8.1 will no longer be supported. Consider upgrading to MySQL 8.0 or 8.4.

spell_target_position

The `spell_target_position` table

This table holds coordinate information on where the player should be teleported to when a spell with target type: TARGET_DST_DB(17).

Table Structure

Field	Type	Attributes	Key	Null	Comment
id	MEDIUMINT	UNSIGNED	PRI	NO	Identifier
target_map	SMALLINT	UNSIGNED		NO
target_position_x	FLOAT	SIGNED		NO
target_position_y	FLOAT	SIGNED		NO
target_position_z	FLOAT	SIGNED		NO
target_orientation	FLOAT	SIGNED		NO

Description of the fields

The spell ID. See Spell.dbc

Map where the player should be teleported to. See Map.dbc.

X coordinate for the target destination of the spell.

Y coordinate for the target destination of the spell.

Z coordinate for the target destination of the spell.

Orientation the player will get when appearing at this location