From 35d8ea775c67e508061906c698038e396606b326 Mon Sep 17 00:00:00 2001 From: kkalev Date: Wed, 28 Aug 2002 12:26:58 +0000 Subject: [PATCH] Show number of failed logins in the last 7 days in the user admin page --- dialup_admin/Changelog | 1 + dialup_admin/htdocs/user_admin.php3 | 10 ++++++++++ dialup_admin/html/user_admin.html.php3 | 2 ++ 3 files changed, 13 insertions(+) diff --git a/dialup_admin/Changelog b/dialup_admin/Changelog index 4e6599e..d03cb44 100644 --- a/dialup_admin/Changelog +++ b/dialup_admin/Changelog @@ -1,5 +1,6 @@ Ver 1.56: * Small html fixes in user_edit.php3 and password.php3 +* Show number of failed logins in the last 7 days in the user admin page Ver 1.55: * Update the FAQ about missing attributes from the user/group edit pages and add a few comments in the configuration files diff --git a/dialup_admin/htdocs/user_admin.php3 b/dialup_admin/htdocs/user_admin.php3 index 3420623..d962c48 100644 --- a/dialup_admin/htdocs/user_admin.php3 +++ b/dialup_admin/htdocs/user_admin.php3 @@ -98,6 +98,16 @@ if ($link){ $avg_output = bytes2str($row['avg(AcctOutputOctets)']); $tot_conns = $row['COUNT(*)']; } + $search = @da_sql_query($link,$config, + "SELECT COUNT(*) FROM $config[sql_accounting_table] WHERE UserName = '$login' + AND AcctStopTime >= '$week_str' AND AcctStopTime <= '$now_str' + AND AcctTerminateCause LIKE 'Login-Incorrect%' OR + AcctTerminateCause LIKE 'Invalid-User%' OR + AcctTerminateCause LIKE 'Multiple-Logins%';"); + if ($search){ + $row = @da_sql_fetch_array($search,$config); + $tot_badlogins = $row['COUNT(*)']; + } for($i = 0; $i <=6; $i++){ if ($days[$i] == '') continue; diff --git a/dialup_admin/html/user_admin.html.php3 b/dialup_admin/html/user_admin.html.php3 index 015784c..ea1c43e 100644 --- a/dialup_admin/html/user_admin.html.php3 +++ b/dialup_admin/html/user_admin.html.php3 @@ -240,6 +240,8 @@ lign=top> $tot_conns Online time $tot_time + Failed Logins + $tot_badlogins Upload $tot_input Download -- 2.1.4