echo "<table border='0' class='table1'>\n"; echo "\n <thead>\n <tr>\n <th colspan='12' align='left'>\n\n <input class='button' type='button' value='CSV Export'\n onClick=\"javascript:window.location.href='include/management/fileExport.php?reportFormat=csv'\"\n />\n <br/>\n <br/>\n "; if ($configValues['CONFIG_IFACE_TABLES_LISTING_NUM'] == "yes") { setupNumbering($numrows, $rowsPerPage, $pageNum, $orderBy, $orderType, "&username={$username}&startdate={$startdate}&enddate={$enddate}"); } echo " </th></tr>\n\t\t\t</thead>\n\t"; if ($orderType == "asc") { $orderType = "desc"; } else { if ($orderType == "desc") { $orderType = "asc"; } } echo "<thread> <tr>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=radacctid&orderType={$orderType}\">\n\t\t" . $l['all']['ID'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=hotspot&orderType={$orderType}\">\n\t\t" . $l['all']['HotSpot'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=username&orderType={$orderType}\">\n\t\t" . $l['all']['Username'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=framedipaddress&orderType={$orderType}\">\n\t\t" . $l['all']['IPAddress'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctstarttime&orderType={$orderType}\">\n\t\t" . $l['all']['StartTime'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctstoptime&orderType={$orderType}\">\n\t\t" . $l['all']['StopTime'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctsessiontime&orderType={$orderType}\">\n\t\t" . $l['all']['TotalTime'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctinputoctets&orderType={$orderType}\">\n\t\t" . $l['all']['Upload'] . " (" . $l['all']['Bytes'] . ")</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctoutputoctets&orderType={$orderType}\">\n\t\t" . $l['all']['Download'] . " (" . $l['all']['Bytes'] . ")</a>\n\t\t</th>\n\t\t<th scope='col'>\n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctterminatecause&orderType={$orderType}\">\n\t\t " . $l['all']['Termination'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=nasipaddress&orderType={$orderType}\">\n\t\t" . $l['all']['NASIPAddress'] . "</a>\n\t\t</th>\n </tr> </thread>"; while ($row = $res->fetchRow()) { printqn("<tr>\n\t\t\t\t<td> {$row['0']} </td>\n\t\t <td> {$row['1']} </td>\n\t <td> {$row['2']} </td>\n\t\t\t\t<td> {$row['3']} </td>\n\t\t\t\t<td> {$row['4']} </td>\n\t\t\t\t<td> {$row['5']} </td>\n\t\t\t\t<td> " . time2str($row[6]) . " </td>\n\t\t\t\t<td> " . toxbyte($row[7]) . "</td>\n\t\t\t\t<td> " . toxbyte($row[8]) . "</td>\n\t\t\t\t<td> {$row['9']} </td>\n\t\t\t\t<td> {$row['10']} </td>\n\t\t</tr>"); } echo "\n <tfoot>\n <tr>\n <th colspan='12' align='left'>\n "; setupLinks($pageNum, $maxPage, $orderBy, $orderType, "&username={$username}&startdate={$startdate}&enddate={$enddate}"); echo "\n </th>\n </tr>\n </tfoot>\n "; echo "</table>"; include 'library/closedb.php'; ?> </div> <?php include 'include/config/logging.php'; ?>
echo "<table border='0' class='table1'>\n"; echo "\n <thead>\n <tr>\n <th colspan='12' align='left'>\n\n <input class='button' type='button' value='CSV Export'\n onClick=\"javascript:window.location.href='include/management/fileExport.php?reportFormat=csv'\"\n />\n <br/>\n <br/>\n "; if ($configValues['CONFIG_IFACE_TABLES_LISTING_NUM'] == "yes") { setupNumbering($numrows, $rowsPerPage, $pageNum, $orderBy, $orderType, "&username={$username}&startdate={$startdate}&enddate={$enddate}"); } echo " </th></tr>\n\t\t\t</thead>\n\t"; if ($orderType == "asc") { $orderTypeNextPage = "desc"; } else { if ($orderType == "desc") { $orderTypeNextPage = "asc"; } } echo "<thread> <tr>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=radacctid&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['ID'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=hotspot&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['HotSpot'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=username&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['Username'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=framedipaddress&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['IPAddress'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctstarttime&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['StartTime'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctstoptime&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['StopTime'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctsessiontime&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['TotalTime'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctinputoctets&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['Upload'] . " (" . $l['all']['Bytes'] . ")</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctoutputoctets&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['Download'] . " (" . $l['all']['Bytes'] . ")</a>\n\t\t</th>\n\t\t<th scope='col'>\n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctterminatecause&orderType={$orderTypeNextPage}\">\n\t\t " . $l['all']['Termination'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=nasipaddress&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['NASIPAddress'] . "</a>\n\t\t</th>\n </tr> </thread>"; while ($row = $res->fetchRow()) { printqn("<tr>\n\t\t\t\t<td> {$row['0']} </td>\n\n <td> <a class='tablenovisit' href='javascript:return;'\n onClick='javascript:ajaxGeneric(\"include/management/retHotspotInfo.php\",\"retHotspotGeneralStat\",\"divContainerHotspotInfo\",\"hotspot={$row['1']}\");\n javascript:__displayTooltip();'\n tooltipText='\n <a class=\"toolTip\" href=\"mng-hs-edit.php?name={$row['1']}\">\n {$l['Tooltip']['HotspotEdit']}</a>\n \n <a class=\"toolTip\" href=\"acct-hotspot-compare.php?\">\n {$l['all']['Compare']}</a>\n <br/><br/>\n\n <div id=\"divContainerHotspotInfo\">\n Loading...\n </div>\n <br/>'\n >{$row['1']}</a>\n </td>\n\n <td> <a class='tablenovisit' href='javascript:return;'\n onClick='javascript:ajaxGeneric(\"include/management/retUserInfo.php\",\"retBandwidthInfo\",\"divContainerUserInfo\",\"username={$row['2']}\");\n javascript:__displayTooltip();'\n tooltipText='\n <a class=\"toolTip\" href=\"mng-edit.php?username={$row['2']}\">\n\t {$l['Tooltip']['UserEdit']}</a>\n <br/><br/>\n\n <div id=\"divContainerUserInfo\">\n Loading...\n </div>\n <br/>'\n >{$row['2']}</a>\n </td>\n\t\t\t\t<td> {$row['3']} </td>\n\t\t\t\t<td> {$row['4']} </td>\n\t\t\t\t<td> {$row['5']} </td>\n\t\t\t\t<td> " . time2str($row[6]) . " </td>\n\t\t\t\t<td> " . toxbyte($row[7]) . "</td>\n\t\t\t\t<td> " . toxbyte($row[8]) . "</td>\n\t\t\t\t<td> {$row['9']} </td>\n\t\t\t\t<td> {$row['10']} </td>\n\t\t</tr>"); } echo "\n <tfoot>\n <tr>\n <th colspan='12' align='left'>\n "; setupLinks($pageNum, $maxPage, $orderBy, $orderType, "&username={$username}&startdate={$startdate}&enddate={$enddate}"); echo "\n </th>\n </tr>\n </tfoot>\n "; echo "</table>"; include 'library/closedb.php'; ?> </div> <?php include 'include/config/logging.php'; ?>
<?php include '../../library/checklogin.php'; include_once 'pages_common.php'; if (isset($_GET['retBandwidthInfo'])) { $divContainer = $_GET['divContainer']; // get target div id $username = $_GET['username']; include '../../library/opendb.php'; $sql = "SELECT SUM(AcctInputOctets) AS Upload, SUM(AcctOutputOctets) AS Download FROM " . $configValues['CONFIG_DB_TBL_RADACCT'] . " WHERE UserName='******'"; $res = $dbSocket->query($sql); $row = $res->fetchRow(DB_FETCHMODE_ASSOC); $upload = toxbyte($row['Upload']); $download = toxbyte($row['Download']); if ($upload <= 0) { $upload = 0; } if ($download <= 0) { $download = 0; } printqn("\n\t\tvar divContainer = document.getElementById('{$divContainer}');\n\t\tdivContainer.innerHTML = '<span style=\"font-weight:normal;\">Upload:</span> {$upload} <br/>" . "<span style=\"font-weight:normal;\">Download: </span> {$download}';\n\t"); }
$content .= '<br/><br/><b>' . $l['all']['NASMAC'] . ':</b> ' . $row['mac']; $str = addToolTipBalloon(array('content' => $content, 'onClick' => '', 'value' => '<b>' . $row['hotspotname'] . '</b>', 'divId' => '')); echo "\n\t\t\t<tr>\n\t\t\t\t<td>\n\t\t\t\t\t{$str}\n\t\t\t\t</td>\n\t\t\t\n\t\t\t\t<td>" . $row['firmware'] . "\n\t\t\t\t\t<br/>" . $row['firmware_revision'] . "\n\t\t\t\t</td>\n\t\t\t"; $content = '<b>' . $l['all']['WanIface'] . ":</b> " . $row['wan_iface'] . "<br/>" . '<b>' . $l['all']['WanMAC'] . ":</b> " . $row['wan_mac'] . "<br/>" . '<b>' . $l['all']['WanIP'] . ":</b> " . $row['wan_ip'] . "<br/>" . '<b>' . $l['all']['WanGateway'] . ":</b> " . $row['wan_ip']; $value = '<b>' . $l['all']['WanIP'] . ":</b> " . $row['wan_ip']; $str = addToolTipBalloon(array('content' => $content, 'onClick' => '', 'value' => $value, 'divId' => '')); echo "<td> {$str} </td>"; $content = $l['all']['LanIface'] . ":</b> " . $row['lan_iface'] . "<br/><b>" . $l['all']['LanMAC'] . ":</b> " . $row['lan_mac'] . "<br/><b>" . $l['all']['LanIP'] . ":</b> " . $row['lan_ip']; $value = '<b>' . $l['all']['LanIP'] . ":</b> " . $row['lan_ip']; $str = addToolTipBalloon(array('content' => $content, 'onClick' => '', 'value' => $value, 'divId' => '')); echo "<td> {$str} </td>"; $content = $l['all']['WifiIface'] . ":</b> " . $row['wifi_iface'] . "<br/><b>" . $l['all']['WifiMAC'] . ":</b> " . $row['wifi_mac'] . "<br/><b>" . $l['all']['WifiIP'] . ":</b> " . $row['wifi_ip'] . "<br/><b>" . $l['all']['WifiSSID'] . ":</b> " . $row['wifi_ssid'] . "<br/><b>" . $l['all']['WifiKey'] . ":</b> " . $row['wifi_key'] . "<br/><b>" . $l['all']['WifiChannel'] . ":</b> " . $row['wifi_channel']; $value = '<b>' . $l['all']['WifiSSID'] . ":</b> " . $row['wifi_ssid'] . "<br/><b>" . $l['all']['WifiKey'] . ":</b> " . $row['wifi_key']; $str = addToolTipBalloon(array('content' => $content, 'onClick' => '', 'value' => $value, 'divId' => '')); echo "<td> {$str} </td>"; echo "\n\t\t\t\t<td>" . time2str($row['uptime']) . "\n\t\t\t\t</td>\n\n\t\t\t\t<td>" . $row['memfree'] . "\n\t\t\t\t</td>\n\n\t\t\t\t<td>" . toxbyte($row['wan_bup']) . "\n\t\t\t\t</td>\n\n\t\t\t\t<td>" . toxbyte($row['wan_bdown']) . "\n\t\t\t\t</td>\n\n\t\t\t\t<td>" . $row['time'] . "\n\t\t\t\t</td>\n\t\t\t\t\n\t\t\t</tr>\n\t\t"; /* printqn(" <td> <input type='checkbox' name='username[]' value='$row[0]'>$row[2]</td> <td> "); if ( ($row[1] == "Reject") && ($row[4] == "Auth-Type") ) echo "<img title='user is disabled' src='images/icons/userStatusDisabled.gif' alt='[disabled]'>"; else echo "<img title='user is enabled' src='images/icons/userStatusActive.gif' alt='[enabled]'>"; printqn(" <a class='tablenovisit' href='javascript:return;'
</span> </td> </tr> </table> <?php echo "<h3>Harddrive Information</h3>"; $hddfreespace = get_hdd_freespace(); ?> <table class='summarySection'> <tr> <td class='summaryKey'> Free Drive Space </td> <td class='summaryValue'><span class='sleft'><?php echo toxbyte($hddfreespace); ?> </span> </td> </tr> </table> <?php echo "<h3>Network Interfaces</h3>"; $iflist = get_interface_list(); foreach ($iflist as $ifname) { echo "\t<table class='summarySection'>\n"; echo "\t<tr>\n"; echo "\t\t<td class='summaryKey'></td>\n"; echo "\t\t<td class='stitle'>\n"; echo "\t\t\t{$ifname}\n";
$sql = "SELECT " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".name AS hotspot, count(distinct(UserName)) AS uniqueusers, count(radacctid) AS totalhits, " . " avg(AcctSessionTime) AS avgsessiontime, sum(AcctSessionTime) AS totaltime, " . " avg(AcctInputOctets) AS avgInputOctets, sum(AcctInputOctets) AS sumInputOctets, " . " avg(AcctOutputOctets) AS avgOutputOctets, sum(AcctOutputOctets) AS sumOutputOctets " . " FROM " . $configValues['CONFIG_DB_TBL_RADACCT'] . " JOIN " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . " on (" . $configValues['CONFIG_DB_TBL_RADACCT'] . ".calledstationid LIKE " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".mac) GROUP BY " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".name ORDER BY {$orderBy} {$orderType};"; $res = $dbSocket->query($sql); $logDebugSQL = ""; $logDebugSQL .= $sql . "\n"; echo "<table border='0' class='table1'>\n"; echo "\n <thead>\n <tr>\n <th colspan='10'>" . $l['all']['Records'] . "</th>\n </tr>\n </thead>\n "; if ($orderType == "asc") { $orderType = "desc"; } else { if ($orderType == "desc") { $orderType = "asc"; } } echo "<thread> <tr>\n <th scope='col'> \n\t\t\t<br/>\n\t\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=hotspot&orderType={$orderType}\">\n\t\t\t" . $l['all']['HotSpot'] . "</a>\n\t\t\t</th>\n\t\t\t<th scope='col'> \n\t\t\t<br/>\n\t\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=uniqueusers&orderType={$orderType}\">\n\t\t\t" . $l['all']['UniqueUsers'] . "</a>\n\t\t\t</th>\n\t\t\t<th scope='col'> \n\t\t\t<br/>\n\t\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=totalhits&orderType={$orderType}\">\n\t\t\t" . $l['all']['TotalHits'] . "</a>\n\t\t\t</th>\n\t\t\t<th scope='col'> \n\t\t\t<br/>\n\t\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=avgsessiontime&orderType={$orderType}\">\n\t\t\t" . $l['all']['AverageTime'] . "</a>\n\t\t\t</th>\n\t\t\t<th scope='col'> \n\t\t\t<br/>\n\t\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=totaltime&orderType={$orderType}\">\n\t\t\t" . $l['all']['TotalTime'] . "</a>\n\t\t\t</th>\n\t\t\t<th scope='col'> \n\t\t\t<br/>\n\t\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=sumInputOctets&orderType={$orderType}\">\n\t\t\tTotal Uploads</a>\n\t\t\t</th>\n\t\t\t<th scope='col'> \n\t\t\t<br/>\n\t\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=sumOutputOctets&orderType={$orderType}\">\n\t\t\tTotal Downloads</a>\n\t\t\t</th>\n </tr> </thread>"; while ($row = $res->fetchRow()) { echo "<tr>\n <td> {$row['0']} </td>\n <td> {$row['1']} </td>\n <td> {$row['2']} </td>\n <td> " . time2str($row[3]) . " </td>\n <td> " . time2str($row[4]) . " </td>\n\t\t\t<td> " . toxbyte($row[6]) . "</td>\n\t\t\t<td> " . toxbyte($row[8]) . "</td>\n </tr>"; } echo "</table>"; include 'library/closedb.php'; ?> </div> <div class="tabbertab" title="Graph"> <?php echo "<br/><br/><br/><center>"; echo "<img src=\"library/graphs-hotspot-compare-unique-users.php\" /><br/><br/>"; echo "<img src=\"library/graphs-hotspot-compare-hits.php\" /><br/><br/>"; echo "<img src=\"library/graphs-hotspot-compare-time.php\" /><br/><br/>"; echo "</center>";
function userConnectionStatus($username, $drawTable) { $userStatus = checkUserOnline($username); include_once 'include/management/pages_common.php'; include 'library/opendb.php'; $username = $dbSocket->escapeSimple($username); // sanitize variable for sql statement $sql = "SELECT AcctStartTime,AcctSessionTime,NASIPAddress,CalledStationId,FramedIPAddress,CallingStationId" . ",AcctInputOctets,AcctOutputOctets FROM " . $configValues['CONFIG_DB_TBL_RADACCT'] . " WHERE Username='******' ORDER BY RadAcctId DESC LIMIT 1"; $res = $dbSocket->query($sql); $row = $res->fetchRow(DB_FETCHMODE_ASSOC); $userUpload = toxbyte($row['AcctInputOctets']); $userDownload = toxbyte($row['AcctOutputOctets']); $userLastConnected = $row['AcctStartTime']; $userOnlineTime = time2str($row['AcctSessionTime']); $nasIPAddress = $row['NASIPAddress']; $nasMacAddress = $row['CalledStationId']; $userIPAddress = $row['FramedIPAddress']; $userMacAddress = $row['CallingStationId']; include 'library/closedb.php'; if ($drawTable == 1) { echo "<table border='0' class='table1'>"; echo "\r\n \t\t<thead>\r\n \t\t\t<tr>\r\n \t <th colspan='10' align='left'> \r\n \t\t\t\t<a class=\"table\" href=\"javascript:toggleShowDiv('divConnectionStatus')\">Session Info</a>\r\n \t </th>\r\n \t </tr>\r\n \t\t</thead>\r\n \t\t</table>\r\n \t"; echo "\r\n <div id='divConnectionStatus' style='display:none;visibility:visible'>\r\n \t\t<table border='0' class='table1'>\r\n \t\t<thread>\r\n\r\n <tr> \r\n <th scope='col' align='right'>\r\n User Status\r\n </th> \r\n \r\n <th scope='col' align='left'>\r\n {$userStatus}\r\n </th>\r\n </tr>\r\n\r\n <tr>\r\n <th scope='col' align='right'>\r\n Last Connection \r\n </th> \r\n \r\n <th scope='col' align='left'>\r\n {$userLastConnected}\r\n </th>\r\n </tr>\r\n\r\n <tr>\r\n <th scope='col' align='right'>\r\n Online Time\r\n </th> \r\n \r\n <th scope='col' align='left'>\r\n {$userOnlineTime}\r\n </th>\r\n </tr>\r\n\r\n <tr>\r\n <th scope='col' align='right'>\r\n Server (NAS)\r\n </th> \r\n \r\n <th scope='col' align='left'>\r\n {$nasIPAddress} (MAC: {$nasMacAddress})\r\n </th>\r\n </tr>\r\n\r\n <tr>\r\n <th scope='col' align='right'>\r\n User Workstation\r\n </th> \r\n \r\n <th scope='col' align='left'>\r\n {$userIPAddress} (MAC: {$userMacAddress})\r\n </th>\r\n </tr>\r\n\r\n <tr>\r\n <th scope='col' align='right'>\r\n User Upload\r\n </th> \r\n \r\n <th scope='col' align='left'>\r\n {$userUpload}\r\n </th>\r\n </tr>\r\n\r\n\r\n <tr>\r\n <th scope='col' align='right'>\r\n User Download\r\n </th> \r\n \r\n <th scope='col' align='left'>\r\n {$userDownload}\r\n </th>\r\n </tr>\r\n\r\n </table>\r\n\r\n \t\t</div>\r\n \t"; } }
$str = addToolTipBalloon(array('content' => $content, 'onClick' => '', 'value' => $value, 'divId' => '')); echo "<td> {$str} </td>"; // calculate time delay $currTime = time(); $checkinTime = strtotime($row['time']); if ($currTime - $checkinTime >= 60 * $hardDelay) { // this is hard delay $delayColor = 'red'; } elseif ($currTime - $checkinTime >= 60 * $softDelay && $currTime - $checkinTime < 60 * $hardDelay) { // this is soft delay $delayColor = 'orange'; } else { // this is no delay at all, meaning not above 5 minutes delay $delayColor = 'green'; } echo "\n\t\t\t\t<td>" . time2str($row['uptime']) . "\n\t\t\t\t</td>\n\n\t\t\t\t<td>" . $row['cpu'] . "\n\t\t\t\t</td>\n\t\t\t\t\n\t\t\t\t<td>" . $row['memfree'] . "\n\t\t\t\t</td>\n\n\t\t\t\t<td>" . toxbyte($row['wan_bup']) . "\n\t\t\t\t</td>\n\n\t\t\t\t<td>" . toxbyte($row['wan_bdown']) . "\n\t\t\t\t</td>\n\n\t\t\t\t<td> <font color='{$delayColor}'> " . $row['time'] . "\n\t\t\t\t\t</font>\n\t\t\t\t</td>\n\t\t\t\t\n\t\t\t</tr>\n\t\t"; } echo "\n\t\t\t\t\t<tfoot>\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<th colspan='11' align='left'> \n\t"; setupLinks($pageNum, $maxPage, $orderBy, $curOrderType); echo "\t\t\t\t\t\t\t</th>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t</tfoot>\n\t\t"; echo "</table>"; echo "</form>"; include 'library/closedb.php'; ?> <?php include 'include/config/logging.php'; ?>
<?php include '../../library/checklogin.php'; include_once 'pages_common.php'; if (isset($_GET['retHotspotGeneralStat'])) { $divContainer = $_GET['divContainer']; // get target div id $hotspot = $_GET['hotspot']; include '../../library/opendb.php'; $sql = "SELECT " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".name AS hotspot, count(distinct(UserName)) AS uniqueusers, count(radacctid) AS totalhits, " . " avg(AcctSessionTime) AS avgsessiontime, sum(AcctSessionTime) AS totaltime, " . " avg(AcctInputOctets) AS avgInputOctets, sum(AcctInputOctets) AS sumInputOctets, " . " avg(AcctOutputOctets) AS avgOutputOctets, sum(AcctOutputOctets) AS sumOutputOctets " . " FROM " . $configValues['CONFIG_DB_TBL_RADACCT'] . " JOIN " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . " on (" . $configValues['CONFIG_DB_TBL_RADACCT'] . ".calledstationid LIKE " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".mac) WHERE " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".name='" . $dbSocket->escapeSimple($hotspot) . "' " . " GROUP BY " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".name ;"; $res = $dbSocket->query($sql); $row = $res->fetchRow(DB_FETCHMODE_ASSOC); $sumUpload = toxbyte($row['sumInputOctets']); $sumDownload = toxbyte($row['sumOutputOctets']); $sumHits = $row['totalhits']; if ($sumUpload <= 0) { $sumUpload = 0; } if ($sumDownload <= 0) { $sumDownload = 0; } if ($sumHits <= 0) { $sumHits = 0; } printqn("\n\t\tvar divContainer = document.getElementById('{$divContainer}');\n\t\tdivContainer.innerHTML = '<span style=\"font-weight:normal;\">Total Uploads:</span> {$sumUpload} <br/> " . " <span style=\"font-weight:normal;\">Total Downloads:</span> {$sumDownload} <br/> " . " <span style=\"font-weight:normal;\">Total Hits:</span> {$sumHits}'\n\t"); }
} echo "<thread> <tr>\r\n\t\t<th scope='col'>\r\n\t\t<a title='Sort' class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?usernameOnline={$usernameOnline}&orderBy=username&orderType={$orderTypeNextPage}\">\r\n\t\t" . $l['all']['Username'] . "</a>\r\n\t\t</th>\r\n\r\n\t\t<th scope='col'>\r\n\t\t\t" . $l['all']['Name'] . "\r\n\t\t</th>\r\n\r\n\t\t<th scope='col'>\r\n\t\t<a title='Sort' class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?usernameOnline={$usernameOnline}&orderBy=framedipaddress&orderType={$orderTypeNextPage}\">\r\n\t\t" . $l['all']['IPAddress'] . "</a>\r\n\t\t</th>\r\n\r\n\t\t<th scope='col'>\r\n\t\t<a title='Sort' class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?usernameOnline={$usernameOnline}&orderBy=acctstarttime&orderType={$orderTypeNextPage}\">\r\n\t\t" . $l['all']['StartTime'] . "</a>\r\n\t\t</th>\r\n\r\n\t\t<th scope='col'>\r\n\t\t<a title='Sort' class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?usernameOnline={$usernameOnline}&orderBy=acctsessiontime&orderType={$orderTypeNextPage}\">\r\n\t\t" . $l['all']['TotalTime'] . "</a>\r\n\t\t</th>\r\n\r\n\r\n\r\n\t\t<th scope='col'>\r\n\t\t\t" . $l['all']['TotalTraffic'] . "\r\n\t\t</th>\t\t\r\n\t\t\r\n\r\n\t</tr> </thread>"; while ($row = $res->fetchRow(DB_FETCHMODE_ASSOC)) { $username = $row['Username']; $ip = $row['FramedIPAddress']; $usermac = $row['CallingStationId']; $start = $row['AcctStartTime']; $nasip = $row['NASIPAddress']; $nasmac = $row['CalledStationId']; $hotspot = $row['hotspot']; $nasshortname = $row['NASshortname']; $acctsessionid = $row['AcctSessionId']; $name = $row['Firstname'] . " " . $row['Lastname']; $upload = toxbyte($row['Upload']); $download = toxbyte($row['Download']); $traffic = toxbyte($row['Upload'] + $row['Download']); $totalTime = time2str($row['AcctSessionTime']); echo "<tr>\r\n\t\t\t\t<td> <input type='checkbox' name='clearSessionsUsers[]' value='{$username}||{$start}'>\r\n\t\t\t\t\t<a class='tablenovisit' href='javascript:return;'\r\n\t\t\t\t\tonclick=\"javascript:__displayTooltip();\" \r\n\t\t\t\t\ttooltipText=\"\r\n\t\t\t\t\t\t<a class='toolTip' href='mng-edit.php?username={$username}'>" . $l['Tooltip']['UserEdit'] . "</a>\r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t<a class='toolTip' href='config-maint-disconnect-user.php?username={$username}&nasaddr={$nasip}&customattributes=Acct-Session-Id={$acctsessionid}'>" . $l['all']['Disconnect'] . "</a>\r\n\t\t\t\t\t\t<br/>\"\r\n\t\t\t\t\t>{$username}</a>\r\n\t\t\t\t\t</td>\r\n\t\t\t\t<td> {$name}</td>\r\n\t\t\t\t<td> IP: {$ip}<br/>MAC: {$usermac}</td>\r\n\t\t\t\t<td> {$start} </td>\r\n\t\t\t\t<td> {$totalTime} </td>\r\n\t\t\t\t<td> " . $l['all']['Upload'] . ": {$upload} <br/> " . $l['all']['Download'] . ": {$download} <br/> " . $l['all']['TotalTraffic'] . ": <b>{$traffic}</b> </td>\r\n\t\t</tr>"; } echo "\r\n <tfoot>\r\n <tr>\r\n <th colspan='10' align='left'>\r\n "; setupLinks($pageNum, $maxPage, $orderBy, $orderType, "&usernameOnline={$usernameOnline}"); echo "\r\n </th>\r\n </tr>\r\n </tfoot>\r\n "; echo "</table>"; include 'library/closedb.php'; ?> </div> <div class="tabbertab" title="Gráfico"> <br/>
$_SESSION['reportType'] = "TopUsers"; $res = $dbSocket->query($sql); $logDebugSQL = ""; $logDebugSQL .= $sql . "\n"; echo "<table border='0' class='table1'>\n"; echo "\n\t\t\t\t\t\t<input class='button' type='button' value='CSV Export'\n \tonClick=\"javascript:window.location.href='include/management/fileExport.php?reportFormat=csv'\"\n \t/>\n\n\t\t\t\t\t<thead>\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<th colspan='10'>" . $l['all']['Records'] . "</th>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t</thead>\n\t\t\t"; if ($orderType == "asc") { $orderType = "desc"; } else { if ($orderType == "desc") { $orderType = "asc"; } } echo "<thread> <tr>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?limit={$limit}&orderBy=username&orderType={$orderType}&username={$username}&startdate={$startdate}&enddate={$enddate}\">\n\t\t" . $l['all']['Username'] . " </a>\n\t\t</th>\n\t\t<th scope='col'>\n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?limit={$limit}&orderBy=framedipaddress&orderType={$orderType}&username={$username}&startdate={$startdate}&enddate={$enddate}\">\n\t\t" . $l['all']['IPAddress'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?limit={$limit}&orderBy=acctstarttime&orderType={$orderType}&username={$username}&startdate={$startdate}&enddate={$enddate}\">\n\t\t" . $l['all']['StartTime'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?limit={$limit}&orderBy=acctstoptime&orderType={$orderType}&username={$username}&startdate={$startdate}&enddate={$enddate}\">\n\t\t" . $l['all']['StopTime'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?limit={$limit}&orderBy=Time&orderType={$orderType}&username={$username}&startdate={$startdate}&enddate={$enddate}\">\n\t\t" . $l['all']['TotalTime'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?limit={$limit}&orderBy=Upload&orderType={$orderType}&username={$username}&startdate={$startdate}&enddate={$enddate}\">\n\t\t" . $l['all']['Upload'] . " (" . $l['all']['Bytes'] . ")</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?limit={$limit}&orderBy=Download&orderType={$orderType}&username={$username}&startdate={$startdate}&enddate={$enddate}\">\n\t\t" . $l['all']['Download'] . " (" . $l['all']['Bytes'] . ")</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?limit={$limit}&orderBy=acctterminatecause&orderType={$orderType}&username={$username}&startdate={$startdate}&enddate={$enddate}\">\n\t\t" . $l['all']['Termination'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?limit={$limit}&orderBy=nasipaddress&orderType={$orderType}&username={$username}&startdate={$startdate}&enddate={$enddate}\">\n\t\t" . $l['all']['NASIPAddress'] . "</a>\n\t\t</th>\n\t\t</tr> </thread>"; while ($row = $res->fetchRow()) { echo "<tr>\n\t\t\t\t<td> {$row['0']} </td>\n\t\t\t\t<td> {$row['1']} </td>\n\t\t\t\t<td> {$row['2']} </td>\n\t\t\t\t<td> {$row['3']} </td>\n\t\t\t\t<td> " . time2str($row[4]) . "</td>\n\t\t\t\t<td> " . toxbyte($row[5]) . "</td>\n\t\t\t\t<td> " . toxbyte($row[6]) . "</td>\n\t\t\t\t<td> {$row['7']} </td>\n\t\t\t\t<td> {$row['8']} </td>\n\t\t</tr>"; } echo "</table>"; include 'library/closedb.php'; ?> <?php include 'include/config/logging.php'; ?> </div> <div id="footer">
function userBillingPayPalSummary($startdate, $enddate, $payer_email, $payment_address_status, $payer_status, $payment_status, $vendor_type, $drawTable) { include_once 'include/management/pages_common.php'; include 'library/opendb.php'; $startdate = $dbSocket->escapeSimple($startdate); $enddate = $dbSocket->escapeSimple($enddate); $payer_email = $dbSocket->escapeSimple($payer_email); $payment_address_status = $dbSocket->escapeSimple($payment_address_status); $payer_status = $dbSocket->escapeSimple($payer_status); $payment_status = $dbSocket->escapeSimple($payment_status); $sql = "SELECT " . $configValues['CONFIG_DB_TBL_DALOBILLINGMERCHANT'] . ".Username AS Username, business_email, " . $configValues['CONFIG_DB_TBL_DALOBILLINGPLANS'] . ".planName, " . $configValues['CONFIG_DB_TBL_DALOBILLINGMERCHANT'] . ".planId, SUM(payment_total) AS total, SUM(payment_fee) " . " AS fee, SUM(payment_tax) AS tax, payment_currency, SUM(AcctSessionTime) AS AcctSessionTime, SUM(AcctInputOctets) AS AcctInputOctets, " . " SUM(AcctOutputOctets) AS AcctOutputOctets " . " FROM " . $configValues['CONFIG_DB_TBL_DALOBILLINGMERCHANT'] . " LEFT JOIN " . $configValues['CONFIG_DB_TBL_RADACCT'] . " ON " . $configValues['CONFIG_DB_TBL_DALOBILLINGMERCHANT'] . ".Username="******".Username " . " LEFT JOIN " . $configValues['CONFIG_DB_TBL_DALOBILLINGPLANS'] . " ON " . $configValues['CONFIG_DB_TBL_DALOBILLINGMERCHANT'] . ".planId=" . $configValues['CONFIG_DB_TBL_DALOBILLINGPLANS'] . ".id " . " WHERE " . " (business_email LIKE '{$payer_email}') AND " . " (payment_address_status LIKE '{$payment_address_status}') AND " . " (payer_status LIKE '{$payer_status}') AND " . " (payment_status LIKE '{$payment_status}') AND " . " (vendor_type LIKE '{$vendor_type}') AND " . " (payment_date>'{$startdate}' AND payment_date<'{$enddate}')" . " GROUP BY Username"; $res = $dbSocket->query($sql); if ($res->numRows() == 0) { return; } $row = $res->fetchRow(DB_FETCHMODE_ASSOC); $planTotalCost = $row['total']; $planTotalTax = $row['tax']; $planTotalFee = $row['fee']; $userUpload = toxbyte($row['AcctInputOctets']); $userDownload = toxbyte($row['AcctOutputOctets']); $userOnlineTime = time2str($row['AcctSessionTime']); $sessionTime = $row['AcctSessionTime']; $planCurrency = $row['payment_currency']; $planName = $row['planName']; $planId = $row['planId']; $payer_email = $row['business_email']; $username = $row['Username']; $grossGain = $planTotalCost - ($planTotalTax + $planTotalFee); include 'library/closedb.php'; if ($drawTable == 1) { echo "<table border='0' class='table1'>"; echo "\n \t\t<thead>\n \t\t\t<tr>\n \t <th colspan='10' align='left'> \n \t\t\t\t<a class=\"table\" href=\"javascript:toggleShowDiv('divBillingPayPalSummary')\">Billing Summary</a>\n \t </th>\n \t </tr>\n \t\t</thead>\n \t\t</table>\n \t"; echo "\n <div id='divBillingPayPalSummary' style='display:none;visibility:visible'>\n \t\t<table border='0' class='table1'>\n \t\t<thread>\n\n <tr> \n <th scope='col' align='right'>\n Username\n </th> \n \n <th scope='col' align='left'>\n {$username} (email: {$payer_email})\n </th>\n </tr>\n\n <tr>\n <th scope='col' align='right'>\n Billing for period of\n </th> \n \n <th scope='col' align='left'>\n {$startdate} until {$enddate} (inclusive)\n </th>\n </tr>\n\n <tr>\n <th scope='col' align='right'>\n Online Time\n </th> \n \n <th scope='col' align='left'>\n {$userOnlineTime}\n </th>\n </tr>\n\n <tr>\n <th scope='col' align='right'>\n User Upload\n </th> \n \n <th scope='col' align='left'>\n {$userUpload}\n </th>\n </tr>\n\n\n <tr>\n <th scope='col' align='right'>\n User Download\n </th> \n \n <th scope='col' align='left'>\n {$userDownload}\n </th>\n </tr>\n\n\n <tr>\n <th scope='col' align='right'>\n Plan name\n </th> \n \n <th scope='col' align='left'>\n {$planName} (planId: {$planId})\n </th>\n </tr>\n\n\n <tr>\n <th scope='col' align='right'>\n Total Plans Cost <br/> Total Transaction Fees <br/> Total Transaction Taxs\n </th> \n \n <th scope='col' align='left'>\n {$planTotalCost} <br/> {$planTotalFee} <br/> {$planTotalTax}\n </th>\n </tr>\n\n\n <tr>\n <th scope='col' align='right'>\n Gross Gain\n </th> \n \n <th scope='col' align='left'>\n {$grossGain} {$planCurrency}\n </th>\n </tr>\n\n </table>\n\n \t\t</div>\n \t"; } }
if ($orderType == "asc") { $orderTypeNextPage = "desc"; } else { if ($orderType == "desc") { $orderTypeNextPage = "asc"; } } echo "<thread> <tr>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&planname={$planname}&orderBy=username&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['Username'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&planname={$planname}&orderBy=planname&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['PlanName'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&planname={$planname}&orderBy=sessiontime&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['UsedTime'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&planname={$planname}&orderBy=plantimebank&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['TotalTime'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t" . $l['all']['TotalTraffic'] . " (" . $l['all']['Bytes'] . ")</a>\n\t\t</th>\n </tr> </thread>"; while ($row = $res->fetchRow(DB_FETCHMODE_ASSOC)) { $perc = number_format($row['sessiontime'] / $row['planTimeBank'] * 100, 2); if ($perc - 100 > 0) { $percFormatted = "<font color='red'>{$perc}</font>"; } else { $percFormatted = "{$perc}"; } printqn("<tr>\n <td> <a class='tablenovisit' href='javascript:return;'\n\t\t\t\t\t\tonClick='javascript:ajaxGeneric(\"include/management/retUserInfo.php\",\"retBandwidthInfo\",\"divContainerUserInfo\",\"username={$row['username']}\");\n javascript:__displayTooltip();'\n tooltipText='\n\t\t\t\t\t\t\t\t<a class=\"toolTip\" href=\"bill-pos-edit.php?username={$row['username']}\">\n\t {$l['Tooltip']['UserEdit']}</a>\n <br/><br/>\n\n <div id=\"divContainerUserInfo\">\n Loading...\n </div>\n <br/>'\n\t\t\t\t\t\t\t\t\t>{$row['username']}</a>\n </td>\n\t\t\t\t<td> {$row['planname']} </td>\n\t\t\t\t<td> \n\t\t\t\t\t" . time2str($row['sessiontime']) . "\n\t\t\t\t\t<b>({$percFormatted})%</b>\n\t\t\t\t\t</td>\n\t\t\t\t<td> " . time2str($row['planTimeBank']) . " </td>\n\t\t\t\t<td> " . toxbyte($row['upload'] + $row['download']) . "</td>\n\t\t</tr>"); } echo "\n <tfoot>\n <tr>\n <th colspan='12' align='left'>\n "; setupLinks($pageNum, $maxPage, $orderBy, $orderType, "&username={$username}&startdate={$startdate}&enddate={$enddate}&planname={$planname}"); echo "\n </th>\n </tr>\n </tfoot>\n "; echo "</table>"; include 'library/closedb.php'; ?> </div> <?php include 'include/config/logging.php'; ?>