Tabelle: 'channels'
Table: channelsInformation and settings for ingame, player-based chat channels (not affecting the default system channels) StructureField | Type | Attributes | Key | Null | Default | Extra | Comment |
---|
name | varchar(128) | vorzeichenbehaftet | PRI | nein | | | | team | int(10) | vorzeichenlos | PRI | nein | | | | announce | tinyint(3) | vorzeichenlos | | nein | 1 | | | ownership | tinyint(3) | vorzeichenlos | | nein | 1 | | | password | varchar(32) | vorzeichenbehaftet | | YES | NULL | | | bannedList | text | vorzeichenbehaftet | | YES | | | | lastUsed | int(10) | vorzeichenlos | | nein | | | |
Description of the fieldsnameChannel nameName of the channel team Allow access to channel from specified player faction IDFor multirace channels, two (or more) separate entries must exist with the EXACT same settings for all fields apart from this (it needs a different ) Horde -> 67 Alliance -> 469 announceChannel announce (0/1)0 = Channel join/part actions will not be sent 1 = Channel join/part actions will be sent ownershipChannel ownership (0/1)0 = No one will ever be an owner. 1 = Ownership is the first person in the channel. passwordChannel passwordEmpty, or a standard string-based password (no spaces allowed) bannedListChannel banlist
List of banned player names, separated by spaceslastUsedUsed for automated cleaning of unused channels from database. Time is in unixtime.
|