Game tele SF: Difference between revisions
Jump to navigation
Jump to search
(Created page with "{| align="right" | __TOC__ |} Category: TrinityCore2 World database tables {{Back-to:World}} <big>'''The `game_tele` table'''</big> This table contains a list of telepo...") |
No edit summary |
||
Line 2: | Line 2: | ||
| __TOC__ | | __TOC__ | ||
|} | |} | ||
[[Category: | [[Category: SkyFire World database tables]] | ||
{{Back-to:World}} | {{Back-to:World}} | ||
Latest revision as of 00:21, 9 January 2013
Back to world database list of tables.
The `game_tele` table
This table contains a list of teleport locations that can be used with the .tele command in-game. Entries in this table can be added/deleted manually or with the .addtele/.deltele commands.
Structure
Field | Type | Attributes | Key | Null | Default | Extra | Comment |
id | mediumint(8) | unsigned | PRI | NO | NULL | Auto increment | |
position_x | float | signed | NO | 0 | |||
position_y | float | signed | NO | 0 | |||
position_z | float | signed | NO | 0 | |||
orientation | float | signed | NO | 0 | |||
map | smallint(5) | unsigned | NO | 0 | |||
name | varchar(100) | signed | NO | NULL |
Description of the fields
id
The ID of the teleport location. This number is unique to every location added.
position_x
The X position where the location exists.
position_y
The Y position where the location exists.
position_z
The Z position where the location exists.
orientation
The orientation to face after teleport.
(North = 0, South = 3.14159)
map
The map ID of the location.
name
The name given to the location. The name must not have a space as this will be read in from the .tele command.