Admin: Add content and update

2021-08-09T00:26:09Z

Add content and update

New page

{| align="right"
| __TOC__
|}
{{Back-to:World_18414}}

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

This table holds the information for "zone portals."

<big>'''Structure'''</big>
{| border="1"
|'''Field'''
|'''Type'''
|'''Attribute'''
|'''Key'''
|'''Null'''
|'''Default'''
|'''Comment'''
|-
|[[#id|id]]
|mediumint(8)
|unsigned
|PRI
|NO
|0
|Identifier
|-
|[[#name|name]]
|text
|signed
|
|YES
|
|
|-
|[[#target_map|target_map]]
|float
|signed
|
|NO
|0
|
|-
|[[#target_position_x|target_position_x]]
|float
|signed
|
|NO
|0
|
|-
|[[#target_position_y|target_position_y]]
|float
|signed
|
|NO
|0
|
|-
|[[#target_position_z|target_position_z]]
|float
|signed
|
|NO
|0
|
|-
|[[#target_orientation|target_orientation]]
|float
|signed
|
|NO
|0
|
|}
<br> <big>'''DB Structure'''</big>
<br>
{| border="1"<br>
<pre style="color: red">
CREATE TABLE `areatrigger_teleport` (
`id` MEDIUMINT NOT NULL DEFAULT '0' COMMENT 'Identifier',
`name` TEXT NULL COLLATE 'utf8_general_ci',
`target_map` SMALLINT NOT NULL DEFAULT '0',
`target_position_x` FLOAT NOT NULL DEFAULT '0',
`target_position_y` FLOAT NOT NULL DEFAULT '0',
`target_position_z` FLOAT NOT NULL DEFAULT '0',
`target_orientation` FLOAT NOT NULL DEFAULT '0',
PRIMARY KEY (`id`) USING BTREE,
FULLTEXT INDEX `name` (`name`)
)
COMMENT='Trigger System'
COLLATE='utf8_general_ci'
ENGINE=MyISAM
ROW_FORMAT=FIXED
;
</pre>
<br> <big>'''Description of the fields'''</big>

===id===

The ID# of the areatrigger. Contained in AreaTrigger.dbc.

===name===

The name for the areatrigger. Used for easy reference purposes.

===target_map===

The ID# of the map to teleport to. Contained in Maps.dbc.

===target_position_x===

The X coordinate to spawn the player.

===target_position_y===

The Y coordinate to spawn the player.

===target_position_z===

The Z coordinate to spawn the player.

===target_orientation===

The orientation to spawn the player (0 = North, moving clockwise. Circle is Pi*2).

Areatrigger teleport 548 - Revision history

Admin: Add content and update