目录

channels

<-Back-to:Characters

The `channels` table

Information and settings for ingame, player-based chat channels (not affecting the default system channels).

Structure

Field Type Attributes Key Null Default Extra Comment
channelId INT SIGNED PRI NO AUTO_INCREMENT
name VARCHAR(128) SIGNED NO
team INT UNSIGNED NO
announce TINYINT UNSIGNED NO 1
ownership TINYINT UNSIGNED NO 1
password VARCHAR(32) SIGNED YES
lastUsed INT UNSIGNED NO

Description of the fields

channelId

The id of channel.

name

Name of the channel.

team

Allow access to channel from specified player faction ID.

For multirace channels, two (or more) separate entries must exist with the EXACT same settings for all fields apart from this (it needs a different team id).

Faction Value
Horde 67
Alliance 469

announce

Channel announce (0/1).

ownership

Channel ownership.

password

Channel password.

Empty, or a standard string-based password (no spaces allowed).

lastUsed

Used for automated cleaning of unused channels from database. Time is in unixtime.