2 require('../conf/config.php3');
7 if (is_file("../lib/sql/drivers/$config[sql_type]/functions.php3"))
8 include_once("../lib/sql/drivers/$config[sql_type]/functions.php3");
11 <title>Failed logins</title>
12 <link rel="stylesheet" href="style.css">
14 <body bgcolor="#80a040" background="images/greenlines1.gif" link="black" alink="black">
16 <b>Could not include SQL library functions. Aborting</b>
25 $last = ($config[general_most_recent_fl]) ? $config[general_most_recent_fl] : 5;
26 $start = $now - ($last*60);
27 $now_str = date($config[sql_full_date_format],$now);
28 $prev_str = date($config[sql_full_date_format],$start);
29 $pagesize = ($pagesize) ? $pagesize : 10;
30 $limit = ($pagesize == 'all') ? '' : "LIMIT $pagesize";
31 $selected[$pagesize] = 'selected';
32 $order = ($order) ? $order : $config[general_accounting_info_order];
33 if ($order != 'desc' && $order != 'asc')
35 $selected[$order] = 'selected';
37 $callerid_str = "AND CallingStationId = '$callerid'";
42 <title>Failed Logins</title>
43 <link rel="stylesheet" href="style.css">
45 <body bgcolor="#80a040" background="images/greenlines1.gif" link="black" alink="black">
47 <table border=0 width=550 cellpadding=0 cellspacing=0>
49 <td align=center><img src="images/title2.gif"></td>
52 <table border=0 width=400 cellpadding=0 cellspacing=2>
55 <table border=0 width=840 cellpadding=1 cellspacing=1>
58 <td bgcolor="black" width=35%>
59 <table border=0 width=100% cellpadding=2 cellspacing=0>
60 <tr bgcolor="#907030" align=right valign=top><th>
61 <font color="white">Failed Logins</font>
65 <tr bgcolor="black" valign=top><td colspan=2>
66 <table border=0 width=100% cellpadding=12 cellspacing=0 bgcolor="#ffffd0" valign=top>
70 <b>$prev_str</b> up to <b>$now_str</b>
75 <table border=1 bordercolordark=#ffffe0 bordercolorlight=#000000 width=100% cellpadding=2 cellspacing=0 bgcolor="#ffffe0" valign=top>
76 <tr bgcolor="#d0ddb0">
77 <th>#</th><th>login</th><th>time</th><th>server</th><th>terminate cause</th><th>callerid</th>
81 $link = @da_sql_pconnect($config);
83 $search = @da_sql_query($link,$config,
84 "SELECT AcctStopTime,UserName,NASIPAddress,NASPortId,AcctTerminateCause,CallingStationId
85 FROM $config[sql_accounting_table]
86 WHERE AcctStopTime <= '$now_str' AND AcctStopTime >= '$prev_str'
87 AND (AcctTerminateCause LIKE 'Login-Incorrect%' OR
88 AcctTerminateCause LIKE 'Invalid-User%' OR
89 AcctTerminateCause LIKE 'Multiple-Logins%') $callerid_str
90 ORDER BY AcctStopTime $order $limit;");
92 while( $row = @da_sql_fetch_array($search,$config) ){
94 $acct_login = $row[UserName];
95 if ($acct_login == '')
98 $acct_login = "<a href=\"user_admin.php3?login=$acct_login\" title=\"Edit user $acct_login\">$acct_login</a>";
99 $acct_time = $row[AcctStopTime];
100 $acct_server = $da_name_cache[$row[NASIPAddress]];
101 if (!isset($acct_server)){
102 $acct_server = gethostbyaddr($row[NASIPAddress]);
103 if (!isset($da_name_cache) && $config[general_use_session] == 'yes'){
104 $da_name_cache[$row[NASIPAddress]] = $acct_server;
105 session_register('da_name_cache');
108 $da_name_cache[$row[NASIPAddress]] = $acct_server;
110 $acct_server = "$acct_server:$row[NASPortId]";
111 $acct_terminate_cause = "$row[AcctTerminateCause]";
112 if ($acct_terminate_cause == '')
113 $acct_terminate_cause = '-';
114 $acct_callerid = "$row[CallingStationId]";
115 if ($acct_callerid == '')
116 $acct_callerid = '-';
118 <tr align=center bgcolor="white">
122 <td>$acct_server</td>
123 <td>$acct_terminate_cause</td>
124 <td>$acct_callerid</td>
134 <tr><td align="left">
135 <form action="failed_logins.php3" method="get" name="master">
138 <td><small><b>time back (mins)</td><td><small><b>pagesize</td><td><small><b>caller id</td><td><b>order</td>
139 <tr valign="middle"><td>
140 <input type="text" name="last" size="11" value="$last"></td>
141 <td><select name="pagesize">
142 <option $selected[5] value="5" >05
143 <option $selected[10] value="10">10
144 <option $selected[15] value="15">15
145 <option $selected[20] value="20">20
146 <option $selected[40] value="40">40
147 <option $selected[80] value="80">80
148 <option $selected[all] value="all">all
152 <input type="text" name="callerid" size="11" value="$callerid"></td>
153 <td><select name="order">
154 <option $selected[asc] value="asc">older first
155 <option $selected[desc] value="desc">recent first
161 <td><input type="submit" class=button value="show"></td></tr>
162 </table></td></tr></form>