数据库:auth数据库:ip_banned
差别
这里会显示出您选择的修订版和当前版本之间的差别。
| 后一修订版 | 前一修订版 | ||
| 数据库:auth数据库:ip_banned [2023/09/24 09:18] – 创建 admin | 数据库:auth数据库:ip_banned [2023/09/24 09:19] (当前版本) – [ip] admin | ||
|---|---|---|---|
| 行 7: | 行 7: | ||
| **表结构** | **表结构** | ||
| ^Field^Type^Attributes^Key^Null^Default^extra^Comment^ | ^Field^Type^Attributes^Key^Null^Default^extra^Comment^ | ||
| - | |[[#id|id]]|INT|UNSIGNED|PRI|NO| | | | | + | |[[#ip|ip]]|VARCHAR(15)|SIGNED|PRI|NO|127.0.0.1| | | |
| - | |[[#gmlevel|gmlevel]]|TINYINT|UNSIGNED| |NO| | | | | + | |[[# |
| - | |[[#RealmID|RealmID]]|INT|SIGNED|PRI|NO|-1| | | | + | |[[#unbandate|unbandate]]|INT|UNSIGNED| |NO| | | | |
| - | |[[#comment|comment]]|VARCHAR(255)|SIGNED| |YES|' '| | | | + | |[[#bannedby|bannedby]]|VARCHAR(50)|SIGNED| |NO|[Console]| | | |
| + | |[[#banreason|banreason]]|VARCHAR(255)|SIGNED| |NO|no reason| | | | ||
| 行 19: | 行 21: | ||
| The IP address that is banned. | The IP address that is banned. | ||
| - | bandate | + | ==== bandate |
| The date when the IP was first banned, in Unix time. | The date when the IP was first banned, in Unix time. | ||
| - | unbandate | + | ==== 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. | 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 | + | ==== 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. | 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 | + | ==== banreason |
| The reason given for the IP ban. | The reason given for the IP ban. | ||
数据库/auth数据库/ip_banned.1695518333.txt.gz · 最后更改: 2023/09/24 09:18 由 admin