From a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3 Mon Sep 17 00:00:00 2001 From: FrancescoBorzi Date: Mon, 25 Feb 2019 19:24:20 +0100 Subject: Import DB wiki from TC 335 --- docs/channels.md | 164 +++++++++++++++++++++++++++++++++++++++++++++++++++---- 1 file changed, 153 insertions(+), 11 deletions(-) (limited to 'docs/channels.md') diff --git a/docs/channels.md b/docs/channels.md index 4bbb919..bc003e2 100644 --- a/docs/channels.md +++ b/docs/channels.md @@ -1,11 +1,153 @@ -[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [channels](channels) - -Column | Type | Description ---- | --- | --- -ChannelId | int(10) unsigned | -Name | varchar(128) | -Team | int(10) unsigned | -Announce | tinyint(3) unsigned | -Ownership | tinyint(3) unsigned | -Password | varchar(32) | -LastUsed | int(10) unsigned | +# channels + +`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. -- cgit