Back-to:Characters

Table: channels

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

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
name	varchar(128)	signed	PRI	NO
team	int(10)	unsigned	PRI	NO
announce	tinyint(3)	unsigned		NO	1
ownership	tinyint(3)	unsigned		NO	1
password	varchar(32)	signed		YES	NULL
bannedList	text	signed		YES
lastUsed	int(10)	unsigned		NO

Description of the fields

name

Channel name

Name of the channel

team

<team id> 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>)

Horde -> 67

Alliance -> 469

announce

Channel announce (0/1)

0 = Channel join/part actions will not be sent

1 = Channel join/part actions will be sent

ownership

Channel ownership (0/1)

0 = No one will ever be an owner.

1 = Ownership is the first person in the channel.

password

Channel password

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

bannedList

Channel banlist

List of banned player names, separated by spaces

lastUsed

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