Actions
错误 #1654
openpuaf-auth增加玩家登入限制
Status:
新建
Priority:
普通
Assignee:
-
Start date:
11/19/2025
Due date:
% Done:
0%
Estimated time:
版本:
Description
1.密码1分钟之内输错6次禁止登入15分钟
2.同一ip5分钟之内登入超过30次拉黑
Actions
Added by 肖 宏举 27 days ago. Updated 26 days ago.
0%
Description
1.密码1分钟之内输错6次禁止登入15分钟
2.同一ip5分钟之内登入超过30次拉黑
create table player_login_strict_rule(
id bigint auto_increment primary key ,
agent_info_pkid bigint,
mistake_count bigint,
lock_seconds bigint,
unique player_login_strict_rule_uk(agent_info_pkid)
);
create table player_login_rule_switch
(
id bigint auto_increment primary key,
agent_info_pkid bigint,
enable_rule bit(1),
unique login_rule_switch_uk (agent_info_pkid)
);
create table player_login_error_info(
id bigint auto_increment primary key ,
agent_info_pkid bigint,
player_info_pkid bigint,
login_ip varchar(50),
create_time datetime,
index agent_info_pkid_idx(agent_info_pkid),
index player_info_pkid_idx(player_info_pkid)
);