require(dirname(__FILE__) . '/../includes/config.php'); mysql_select_db('radius'); require('head.php'); $res = fetch_array( 'SELECT sum(`acctinputoctets`) as acctinputoctets, sum(`acctoutputoctets`) as acctoutputoctets, COUNT( radacctid ) as logins, (sum(`acctinputoctets`) + sum(`acctoutputoctets`)) AS total, MAX( `acctstarttime` ) AS date, MIN( `acctstarttime` ) AS first_date, `callingstationid` as mac,b.id as macid, b.user FROM `radacct` as a LEFT JOIN mac_addresses as b ON a.callingstationid=b.mac GROUP BY callingstationid ORDER BY DATE DESC ' ); if (is_array($res) && count($res) > 0) { echo '
| Benutzer | MAC | Hersteller | Logins | Transfer | Transfer (in/out) | Erster Login | Letzer Login |
|---|---|---|---|---|---|---|---|
| ' . $row['user'] . ' | ' . $row['mac'] . ' | ' . $vendor . ' | ' . $row['logins'] . ' | ' . human_filesize($row['total']) . ' | ' . human_filesize($row['acctinputoctets']) . ' / ' . human_filesize($row['acctoutputoctets']) . ' | ' . $row['first_date'] . ' | ' . $row['date'] . ' |