目录

channels 表


<-返回:Characters 数据库

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

表结构

FieldTypeAttributesKeyNullDefaultextraComment
channelIdINTSIGNEDPRINO AUTO_INCREMENT
nameVARCHAR(128)SIGNED NO
teamINTUNSIGNED NO
announceTINYINTUNSIGNED NO1
ownershipTINYINTUNSIGNED NO1
passwordVARCHAR(32)SIGNED YES
lastUsedINTUNSIGNED NO

字段说明


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

FactionValue
Horde67
Alliance469

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.