| 111 |
{ |
{ |
| 112 |
// Failed login attempts from the same source (subnet /24) during certain time period |
// Failed login attempts from the same source (subnet /24) during certain time period |
| 113 |
$sql = "SELECT COUNT(*) AS err_count FROM user_err_login_log |
$sql = "SELECT COUNT(*) AS err_count FROM user_err_login_log |
| 114 |
WHERE login_dt >= SUBDATE(NOW(), INTERVAL '10' MINUTE) |
WHERE login_dt >= SUBDATE(NOW(), INTERVAL 10 MINUTE) |
| 115 |
AND login_ip LIKE '" . client_addr(1) . "'"; |
AND login_ip LIKE '" . client_addr(1) . "'"; |
| 116 |
$rs = mysqli_query($db_conn, $sql); |
$rs = mysqli_query($db_conn, $sql); |
| 117 |
if ($rs == false) |
if ($rs == false) |
| 138 |
|
|
| 139 |
// Failed login attempts against the current username during certain time period |
// Failed login attempts against the current username during certain time period |
| 140 |
$sql = "SELECT COUNT(*) AS err_count FROM user_err_login_log |
$sql = "SELECT COUNT(*) AS err_count FROM user_err_login_log |
| 141 |
WHERE username = '$username' AND login_dt >= SUBDATE(NOW(), INTERVAL '1' DAY)"; |
WHERE username = '$username' AND login_dt >= SUBDATE(NOW(), INTERVAL 1 DAY)"; |
| 142 |
$rs = mysqli_query($db_conn, $sql); |
$rs = mysqli_query($db_conn, $sql); |
| 143 |
if ($rs == false) |
if ($rs == false) |
| 144 |
{ |
{ |