blob: 9eda0283f68a7cd1e3cc233e375eeb28163c8453 (
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
|
# ip\_banned
[<-Back-to:Auth](database-auth.md)
**The \`ip\_banned\` table**
This table contains all of the banned IPs and the date when (or if) the ban will expire.
**Structure**
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
| -------------- | ------------ | ---------- | --- | ---- | --------- | ----- | ------- |
| [ip][1] | VARCHAR(15) | SIGNED | PRI | NO | 127.0.0.1 | | |
| [bandate][2] | INT | UNSIGNED | PRI | NO | | | |
| [unbandate][3] | INT | UNSIGNED | | NO | | | |
| [bannedby][4] | VARCHAR(50) | SIGNED | | NO | [Console] | | |
| [banreason][5] | VARCHAR(255) | SIGNED | | NO | no reason | | |
[1]: #ip
[2]: #bandate
[3]: #unbandate
[4]: #bannedby
[5]: #banreason
**Description of the fields**
### ip
The IP address that is banned.
### bandate
The date when the IP was first banned, in Unix time.
### unbandate
The date when the IP will be unbanned in Unix time. Any date that is set lower than the current date basically classifies as a permanent ban as it will never auto expire.
### bannedby
The name of the character that banned the IP. The character should belong to an account with the rights to the .ban command in-game.
### banreason
The reason given for the IP ban.
|
