Project

General

Profile

Actions

错误 #1654

open

puaf-auth增加玩家登入限制

Added by 肖 宏举 26 days ago. Updated 25 days ago.

Status:
新建
Priority:
普通
Assignee:
-
Start date:
11/19/2025
Due date:
% Done:

0%

Estimated time:
版本:

Description

1.密码1分钟之内输错6次禁止登入15分钟
2.同一ip5分钟之内登入超过30次拉黑

Actions #1

Updated by 肖 宏举 25 days ago

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)
);

Actions

Also available in: Atom PDF