Back-to:Characters<big>The `channels` table</big>
Table: channels
Information and settings for ingame, player-based chatchannels chat channels (not affecting the default system channels)<big>
Structure
...
Field | Type | Attributes | Key | Null | Default | Extra | Comment |
varchar(128) | signed | PRI | NO |
|
|
| |
int(10) | unsigned | PRI | NO |
|
|
| |
tinyint(3) | unsigned |
| NO | 1 |
|
| |
tinyint(3) | unsigned |
| NO | 1 |
|
| |
varchar(32) | signed |
| YES | NULL |
|
| |
text | signed |
| YES |
|
|
| |
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
...
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) h3. BannedList
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.