blob: d88a19bd1fd8efcce0aa4bc10d6d2b8833738596 (
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(10) | unsigned | | NO | | | |
| [unbandate][3] | int(10) | 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.
|
