blob: 13ece040532cb7cc3ed58ae1366c85139f8d80f1 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
|
# character\_banned
[<-Back-to:Characters](database-characters.md)
**The \`character\_banned\` table**
This table lists all of the characters that have been banned along with the date when (or if) the ban will expire.
**Structure**
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
| -------------- | ------------ | ---------- | --- | ---- | ------- | ----- | ------------------------ |
| [guid][1] | INT | UNSIGNED | PRI | NO | 0 | | Global Unique Identifier |
| [bandate][2] | INT | UNSIGNED | PRI | NO | 0 | | |
| [unbandate][3] | INT | UNSIGNED | | NO | 0 | | |
| [bannedby][4] | VARCHAR(50) | SIGNED | | NO | | | |
| [banreason][5] | VARCHAR(255) | SIGNED | | NO | | | |
| [active][6] | TINYINT | UNSIGNED | | NO | 1 | | |
[1]: #guid
[2]: #bandate
[3]: #unbandate
[4]: #bannedby
[5]: #banreason
[6]: #active
**Description of the fields**
### guid
The character guid. See [characters.guid](characters#guid).
### bandate
The date when the character was banned, in Unix time.
### unbandate
The date when the character will be automatically unbanned, in Unix time. A value less than the current date means, in effect, a permanent ban.
### bannedby
The character with the rights to the .ban command that banned the character.
### banreason
The reason for the ban.
### active
Boolean 0 or 1 controlling if the ban is currently active or not.
|
