Admin at 05:21, 9 January 2013

2013-01-09T05:21:41Z

← Older revision		Revision as of 00:21, 9 January 2013
Line 2:		Line 2:
	\| __TOC__		\| __TOC__
	\|}		\|}
	[[Category: ~~TrinityCore2~~ World database tables]]		[[Category: SkyFire World database tables]]
	{{Back-to:World}}		{{Back-to:World}}

Admin: Created page with "{| align="right" | TOC |} Category: TrinityCore2 World database tables {{Back-to:World}} '''The `game_tele` table''' This table contains a list of telepo..."

2013-01-09T05:19:41Z

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..."

New page

{| align="right"
| __TOC__
|}
[[Category: TrinityCore2 World database tables]]
{{Back-to:World}}

<big>'''The `game_tele` table'''</big>

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.

<big>'''Structure'''</big>
{| border="1"
|'''Field'''
|'''Type'''
|'''Attributes'''
|'''Key'''
|'''Null'''
|'''Default'''
|'''Extra'''
|'''Comment'''
|-
|[[#id|id]]
|mediumint(8)
|unsigned
|PRI
|NO
|NULL
|Auto increment
|
|-
|[[#position_x|position_x]]
|float
|signed
|
|NO
|0
|
|
|-
|[[#position_y|position_y]]
|float
|signed
|
|NO
|0
|
|
|-
|[[#position_z|position_z]]
|float
|signed
|
|NO
|0
|
|
|-
|[[#orientation|orientation]]
|float
|signed
|
|NO
|0
|
|
|-
|[[#map|map]]
|smallint(5)
|unsigned
|
|NO
|0
|
|
|-
|[[#name|name]]
|varchar(100)
|signed
|
|NO
|NULL
|
|
|}

<big>'''Description of the fields'''</big>
====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.

Game tele SF - Revision history

Admin at 05:21, 9 January 2013

Admin: Created page with "{| align="right" | __TOC__ |} Category: TrinityCore2 World database tables {{Back-to:World}} '''The `game_tele` table''' This table contains a list of telepo..."

Admin: Created page with "{| align="right" | TOC |} Category: TrinityCore2 World database tables {{Back-to:World}} '''The `game_tele` table''' This table contains a list of telepo..."