blob: 4340570f906e9150059ce227ceb54a5ded47bdaa (
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
|
# account\_banned
[<-Back-to:Auth](database-auth.md)
**The \`account\_banned\` table**
This table lists all of the accounts that have been banned along with the date when (or if) the ban will expire.
**Structure**
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
| -------------- | ------------ | ---------- | --- | ---- | ------- | ----- | ---------- |
| [id][1] | INT | UNSIGNED | PRI | NO | 0 | | Account id |
| [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]: #id
[2]: #bandate
[3]: #unbandate
[4]: #bannedby
[5]: #banreason
[6]: #active
**Description of the fields**
### id
The account ID. See [account.id](account#id).
### bandate
The date when the account was banned, in Unix time.
### unbandate
The date when the account will be automatically unbanned, in Unix time. A value less than the current date means, in effect, a permanent ban.
### bannedby
The GM character's name who banned that account. If banned from the console, then it will be empty (until improved).
### banreason
The reason for the ban.
### active
Boolean 0 or 1 controlling if the ban is currently active or not.
|
