$sql = "SELECT * FROM " . $configValues['CONFIG_DB_TBL_RADHG']; $res = $dbSocket->query($sql); $logDebugSQL = ""; $logDebugSQL .= $sql . "\n"; $numrows = $res->numRows(); $sql = "SELECT * FROM " . $configValues['CONFIG_DB_TBL_RADHG'] . " ORDER BY {$orderBy} {$orderType} LIMIT {$offset}, {$rowsPerPage};"; $res = $dbSocket->query($sql); $logDebugSQL .= $sql . "\n"; /* START - Related to pages_numbering.php */ $maxPage = ceil($numrows / $rowsPerPage); /* END */ echo "<form name='listallhunt' method='post' action='mng-rad-hunt-del.php'>"; echo "<table border='0' class='table1'>\n"; echo "\n\t\t\t\t\t<thead>\n <tr>\n <th colspan='4' align='left'>\n\n Select:\n <a class=\"table\" href=\"javascript:SetChecked(1,'nashost[]','listallhunt')\">All</a>\n\n <a class=\"table\" href=\"javascript:SetChecked(0,'nashost[]','listallhunt')\">None</a>\n <br/>\n <input class='button' type='button' value='Delete' onClick='javascript:removeCheckbox(\"listallhunt\",\"mng-rad-hunt-del.php\")' />\n <br/><br/>\n\n\n "; if ($configValues['CONFIG_IFACE_TABLES_LISTING_NUM'] == "yes") { setupNumbering($numrows, $rowsPerPage, $pageNum, $orderBy, $orderType); } echo " </th></tr>\n </thead>\n\n "; if ($orderType == "asc") { $orderType = "desc"; } else { if ($orderType == "desc") { $orderType = "asc"; } } echo "<thread> <tr>\n\t\t<th scope='col'>\n\t\t<a title='Sort' class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=id&orderType={$orderType}\">\n\t\t" . $l['all']['HgID'] . "</a>\n\t\t<br/>\n\t\t</th>\n\n\t\t<th scope='col'>\n\t\t<a title='Sort' class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=nasipaddress&orderType={$orderType}\">\n\t\t" . $l['all']['HgIPHost'] . "</a>\n\t\t<br/>\n\t\t</th>\n\n\t\t<th scope='col'>\n\t\t<a title='Sort' class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=groupname&orderType={$orderType}\">\n\t\t" . $l['all']['HgGroupName'] . "</a>\n\t\t<br/>\n\t\t</th>\n\n\t\t<th scope='col'>\n\t\t<a title='Sort' class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=nasportid&orderType={$orderType}\">\n\t\t" . $l['all']['HgPortId'] . "</a>\n\t\t<br/>\n\t\t</th>\n\n\t</tr> </thread>"; while ($row = $res->fetchRow()) { echo "<tr>\n <td> <input type='checkbox' name='nashost[]' value='{$row['2']}||{$row['3']}'> {$row['0']} </td>\n <td> <a class='tablenovisit' href='javascript:return;'\n onclick=\"javascript:__displayTooltip();\"\n tooltipText=\"\n <a class='toolTip' href='mng-rad-hunt-edit.php?nasipaddress={$row['2']}&nasportid={$row['3']}'>" . $l['Tooltip']['EditHG'] . "</a>\n <a class='toolTip' href='mng-rad-hunt-del.php?nasipaddress={$row['2']}&nasportid={$row['3']}'>" . $l['Tooltip']['RemoveHG'] . "</a>\n <br/>\"\n >{$row['2']}</a></td>\n\t\t\t\t<td> {$row['1']} </td>\n\t\t\t\t<td> {$row['3']} </td>\n\n\t\t</tr>"; } echo "\n <tfoot>\n <tr>\n <th colspan='4' align='left'>\n "; setupLinks($pageNum, $maxPage, $orderBy, $orderType);
$logDebugSQL = ""; $logDebugSQL .= $sql . "\n"; /* START - Related to pages_numbering.php */ $maxPage = ceil($numrows / $rowsPerPage); /* END */ $counter = 0; $bytesin = 0; $bytesout = 0; $megabytesout = 0; $megabytesin = 0; $session_seconds = 0; $session_minutes = 0; 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}");
//userConnectionStatus($username, 1); // userConnectionStatus (same as above) include 'library/opendb.php'; //orig: used as maethod to get total rows - this is required for the pages_numbering.php page $sql = "SELECT " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".RadAcctId, " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".name as hotspot, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".UserName, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".FramedIPAddress, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctStartTime, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctStopTime, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctSessionTime, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctInputOctets, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctOutputOctets, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctTerminateCause, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".NASIPAddress FROM " . $configValues['CONFIG_DB_TBL_RADACCT'] . " LEFT JOIN " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . " ON " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".calledstationid = " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".mac WHERE UserName='******';"; $res = $dbSocket->query($sql); $numrows = $res->numRows(); $sql = "SELECT " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".RadAcctId, " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".name as hotspot, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".UserName, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".FramedIPAddress, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctStartTime, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctStopTime, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctSessionTime, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctInputOctets, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctOutputOctets, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctTerminateCause, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".NASIPAddress FROM " . $configValues['CONFIG_DB_TBL_RADACCT'] . " LEFT JOIN " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . " ON " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".calledstationid = " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".mac WHERE UserName='******' ORDER BY {$orderBy} {$orderType} LIMIT {$offset}, {$rowsPerPage};"; $res = $dbSocket->query($sql); $logDebugSQL .= $sql . "\n"; /* START - Related to pages_numbering.php */ $maxPage = ceil($numrows / $rowsPerPage); /* END */ echo "<table border='0' class='table1'>\n"; echo "\n\t\t\t<thead>\n\t\t\t<tr>\n\t\t\t\t<th colspan='12' align='left'>\n\n\t\t\t<input class='button' type='button' value='Exportar CSV'\n\t\t\tonClick=\"javascript:window.location.href='include/management/fileExport.php?reportFormat=csv'\"\n\t\t\t/>\n\t\t\t<br/>\n\t\t\t<br/>\n\t\t"; if ($configValues['CONFIG_IFACE_TABLES_LISTING_NUM'] == "yes") { setupNumbering($numrows, $rowsPerPage, $pageNum, $orderBy, $orderType, "&username={$username}"); } echo " </th></tr></thead>"; if ($orderType == "asc") { $orderTypeNextPage = "desc"; } else { if ($orderType == "desc") { $orderTypeNextPage = "asc"; } } echo "<thread> <tr>\n\t\t\t<th scope='col'> \n\t\t\t<br/>\n\t\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&orderBy=radacctid&orderType={$orderTypeNextPage}\">\n\t\t\t" . $l['all']['ID'] . "</a>\n\t\t\t</th>\n\n\t\t\t<th scope='col'> \n\t\t\t<br/>\n\t\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&orderBy=username&orderType={$orderTypeNextPage}\">\n\t\t\t" . $l['all']['Username'] . "</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'] . "?username={$username}&orderBy=framedipaddress&orderType={$orderTypeNextPage}\">\n\t\t\t" . $l['all']['IPAddress'] . "</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'] . "?username={$username}&orderBy=acctstarttime&orderType={$orderTypeNextPage}\">\n\t\t\t" . $l['all']['StartTime'] . "</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'] . "?username={$username}&orderBy=acctstoptime&orderType={$orderTypeNextPage}\">\n\t\t\t" . $l['all']['StopTime'] . "</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'] . "?username={$username}&orderBy=acctsessiontime&orderType={$orderTypeNextPage}\">\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'] . "?username={$username}&orderBy=acctinputoctets&orderType={$orderTypeNextPage}\">\n\t\t\t" . $l['all']['Upload'] . " (" . $l['all']['Bytes'] . ")</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'] . "?username={$username}&orderBy=acctoutputoctets&orderType={$orderTypeNextPage}\">\n\t\t\t" . $l['all']['Download'] . " (" . $l['all']['Bytes'] . ")</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'] . "?username={$username}&orderBy=acctterminatecause&orderType={$orderTypeNextPage}\">\n\t\t\t" . $l['all']['Termination'] . "</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'] . "?username={$username}&orderBy=nasipaddress&orderType={$orderTypeNextPage}\">\n\t\t\t" . $l['all']['NASIPAddress'] . "</a>\n\t\t\t</th>\n\t\t\t</tr> </thread>"; while ($row = $res->fetchRow()) { printqn("<tr>\n\t\t\t\t\t\t\n\t\t\t\t\t\t<td> <a class='tablenovisit' href='javascript:return;'\n\t\t\t\t\t\t\t\tonClick='javascript:ajaxGeneric(\"include/management/retHotspotInfo.php\",\"retHotspotGeneralStat\",\"divContainerHotspotInfo\",\"hotspot={$row['1']}\");\n\t\t\t\t\t\t\t\t\t\tjavascript:__displayTooltip();'\n\t\t\t\t\t\t\t\ttooltipText='\n\t\t\t\t\t\t\t\t\t\t<a class=\"toolTip\" href=\"mng-hs-edit.php?name={$row['1']}\">\n\t\t\t\t\t\t\t\t\t\t\t\t{$l['Tooltip']['HotspotEdit']}</a>\n\t\t\t\t\t\t\t\t\t\t \n\t\t\t\t\t\t\t\t\t\t<a class=\"toolTip\" href=\"acct-hotspot-compare.php?\">\n\t\t\t\t\t\t\t\t\t\t\t\t{$l['all']['Compare']}</a>\n\t\t\t\t\t\t\t\t\t\t<br/><br/>\n\n\t\t\t\t\t\t\t\t\t\t<div id=\"divContainerHotspotInfo\">\n\t\t\t\t\t\t\t\t\t\t\t\tLoading...\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t<br/>'\n\t\t\t\t\t\t\t\t>{$row['1']}</a>\n\t\t\t\t\t\t</td>\n\n\t\t\t\t\t\t<td> <a class='tablenovisit' href='javascript:return;'\n\t\t\t\t\t\t\t\tonClick='javascript:ajaxGeneric(\"include/management/retUserInfo.php\",\"retBandwidthInfo\",\"divContainerUserInfo\",\"username={$row['2']}\");\n\t\t\t\t\t\t\t\t\t\tjavascript:__displayTooltip();'\n\t\t\t\t\t\t\t\ttooltipText='\n\t\t\t\t\t\t\t\t\t\t<a class=\"toolTip\" href=\"mng-edit.php?username={$row['2']}\">\n\t\t\t\t\t\t\t\t\t\t\t{$l['Tooltip']['UserEdit']}</a>\n\t\t\t\t\t\t\t\t\t\t<br/><br/>\n\n\t\t\t\t\t\t\t\t\t\t<div id=\"divContainerUserInfo\">\n\t\t\t\t\t\t\t\t\t\t\t\tLoading...\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t<br/>'\n\t\t\t\t\t\t\t\t>{$row['2']}</a>\n\t\t\t\t\t\t</td>\n\n\t\t\t\t\t\t<td> {$row['3']} </td>\n\t\t\t\t\t\t<td> {$row['4']} </td>\n\t\t\t\t\t\t<td> {$row['5']} </td>\n\t\t\t\t\t\t<td> " . time2str($row[6]) . " </td>\n\t\t\t\t\t\t<td> " . toxbyte($row[7]) . "</td>\n\t\t\t\t\t\t<td> " . toxbyte($row[8]) . "</td>\n\t\t\t\t\t\t<td> {$row['9']} </td>\n\t\t\t\t\t\t<td> {$row['10']} </td>\n\t\t\t\t</tr>"); } echo "\n\t\t\t\t<tfoot>\n\t\t\t\t\t<tr>\n\t\t\t\t\t<th colspan='12' align='left'>\n\t "; setupLinks($pageNum, $maxPage, $orderBy, $orderType, "&username={$username}");
$sql = "SELECT id, Vendor, Attribute FROM dictionary WHERE Attribute like '%{$attribute}%' AND Type <> ''" . " GROUP BY Attribute;"; $res = $dbSocket->query($sql); $logDebugSQL = ""; $logDebugSQL .= $sql . "\n"; $numrows = $res->numRows(); $sql = "SELECT id, Vendor, Attribute FROM dictionary WHERE Attribute like '%{$attribute}%' AND Type <> '' " . " GROUP BY Attribute ORDER BY {$orderBy} {$orderType} LIMIT {$offset}, {$rowsPerPage};"; $res = $dbSocket->query($sql); $logDebugSQL .= $sql . "\n"; /* START - Related to pages_numbering.php */ $maxPage = ceil($numrows / $rowsPerPage); /* END */ echo "<form name='listvendorattributes' method='post' action='mng-rad-attributes-del.php'>"; echo "<table border='0' class='table1'>\n"; echo "\n\t\t<thead>\n\t\t\t<tr>\n\t\t\t<th colspan='10' align='left'>\n\n\t\t\tSelect:\n\t\t\t<a class=\"table\" href=\"javascript:SetChecked(1,'vendor[]','listvendorattributes')\">All</a>\n\t\t\t<a class=\"table\" href=\"javascript:SetChecked(0,'vendor[]','listvendorattributes')\">None</a>\n\t\t\t<br/>\n\t\t\t<input class='button' type='button' value='Delete' onClick='javascript:removeCheckbox(\"listvendorattributes\",\"mng-rad-attributes-del.php\")' />\n\t\t\t<br/><br/>\n\t"; if ($configValues['CONFIG_IFACE_TABLES_LISTING_NUM'] == "yes") { setupNumbering($numrows, $rowsPerPage, $pageNum, $orderBy, $orderType, "&attribute={$attribute}"); } echo "\t</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<a title='Sort' class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=id&orderType={$orderTypeNextPage}&attribute={$attribute}\">\n\t\t" . $l['all']['VendorID'] . "</a>\n\t\t</th>\n\n\t\t<th scope='col'>\n\t\t<a title='Sort' class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=vendor&orderType={$orderTypeNextPage}&attribute={$attribute}\">\n\t\t" . $l['all']['VendorName'] . "</a>\n\t\t</th>\n\n\t\t<th scope='col'>\n\t\t<a title='Sort' class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=attribute&orderType={$orderTypeNextPage}&attribute={$attribute}\">\n\t\t" . $l['all']['VendorAttribute'] . "</a>\n\t\t</th>\n\n\t\t</tr> </thread>"; while ($row = $res->fetchRow()) { printqn("<tr>\n <td> <input type='checkbox' name='vendor[]' value='{$row['1']}||{$row['2']}'> {$row['0']} </td>\n\t\t\t\t<td> <a class='tablenovisit' href='mng-rad-attributes-list.php?vendor={$row['1']}'>{$row['1']}</a></td>\n <td> <a class='tablenovisit' href='javascript:return;'\n onClick='javascript:ajaxGeneric(\"include/management/retVendorAttributeInfo.php\",\"retAttributeInfo\",\"divContainerAttributeInfo\",\"attribute={$row['2']}\");\n javascript:__displayTooltip();'\n tooltipText='\n <a class=\"toolTip\" href=\"mng-rad-attributes-edit.php?vendor={$row['1']}&attribute={$row['2']}\">\n {$l['Tooltip']['AttributeEdit']}</a>\n <br/><br/>\n\n <div id=\"divContainerAttributeInfo\">\n Loading...\n </div>\n <br/>'\n >{$row['2']}</a>\n </td>\n </tr>\n "); } echo "\n\t\t<tfoot>\n\t\t\t<tr>\n\t\t\t<th colspan='10' align='left'>\n\t"; setupLinks($pageNum, $maxPage, $orderBy, $orderType, "&attribute={$attribute}");
// sanitizing the array passed to us in the get request $select = $dbSocket->escapeSimple($select); $sql = "SELECT {$select} FROM " . $configValues['CONFIG_DB_TBL_DALOBILLINGMERCHANT'] . " WHERE " . " (payer_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}')"; $res = $dbSocket->query($sql); $numrows = $res->numRows(); $sql = "SELECT {$select} FROM " . $configValues['CONFIG_DB_TBL_DALOBILLINGMERCHANT'] . " WHERE " . " (payer_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}') " . " ORDER BY {$orderBy} {$orderType} LIMIT {$offset}, {$rowsPerPage};"; $res = $dbSocket->query($sql); $logDebugSQL = ""; $logDebugSQL .= $sql . "\n"; /* START - Related to pages_numbering.php */ $maxPage = ceil($numrows / $rowsPerPage); /* END */ echo "<table border='0' class='table1'>\n"; echo "\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='25'>" . $l['all']['Records'] . "</th>\n\t\t\t\t\t\t\t</tr>\n\n <tr>\n <th colspan='25' align='left'>\n <br/>\n "; if ($configValues['CONFIG_IFACE_TABLES_LISTING_NUM'] == "yes") { setupNumbering($numrows, $rowsPerPage, $pageNum, $orderBy, $orderType, $getFields, $getQuery); } echo " </th></tr>\n </thead>\n\n "; // building the dybamic table list fields echo "<thread> <tr>"; foreach ($sqlfields as $value) { switch ($value) { case "id": $title = $l['all']['ID']; break; case "username": $title = $l['all']['Username']; break; case "password": $title = $l['all']['Password']; break;
$sql = "SELECT id, Vendor, Attribute FROM dictionary WHERE Vendor = '{$vendor}' AND Type <> '';"; $res = $dbSocket->query($sql); $logDebugSQL = ""; $logDebugSQL .= $sql . "\n"; $numrows = $res->numRows(); $sql = "SELECT id, Vendor, Attribute FROM dictionary WHERE Vendor = '{$vendor}' AND Type <> '' " . "ORDER BY {$orderBy} {$orderType} LIMIT {$offset}, {$rowsPerPage};"; $res = $dbSocket->query($sql); $logDebugSQL .= $sql . "\n"; /* START - Related to pages_numbering.php */ $maxPage = ceil($numrows / $rowsPerPage); /* END */ echo "<form name='listvendorattributes' method='post' action='mng-rad-attributes-del.php'>"; echo "<table border='0' class='table1'>\n"; echo "\n\t\t\t\t\t<thead>\n <tr>\n <th colspan='10' align='left'>\n\n Select:\n <a class=\"table\" href=\"javascript:SetChecked(1,'vendor[]','listvendorattributes')\">All</a>\n\n <a class=\"table\" href=\"javascript:SetChecked(0,'vendor[]','listvendorattributes')\">None</a>\n <br/>\n <input class='button' type='button' value='Delete' onClick='javascript:removeCheckbox(\"listvendorattributes\",\"mng-rad-attributes-del.php\")' />\n <br/><br/>\n\n\n "; if ($configValues['CONFIG_IFACE_TABLES_LISTING_NUM'] == "yes") { setupNumbering($numrows, $rowsPerPage, $pageNum, $orderBy, $orderType, "&vendor={$vendor}"); } echo " </th></tr>\n </thead>\n\n "; if ($orderType == "asc") { $orderTypeNextPage = "desc"; } else { if ($orderType == "desc") { $orderTypeNextPage = "asc"; } } echo "<thread> <tr>\n\t\t<th scope='col'>\n\t\t<a title='Sort' class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=id&orderType={$orderTypeNextPage}&vendor={$vendor}\">\n\t\t" . $l['all']['VendorID'] . "</a>\n\t\t</th>\n\n\t\t<th scope='col'>\n\t\t<a title='Sort' class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=vendor&orderType={$orderTypeNextPage}&vendor={$vendor}\">\n\t\t" . $l['all']['VendorName'] . "</a>\n\t\t</th>\n\n\t\t<th scope='col'>\n\t\t<a title='Sort' class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=attribute&orderType={$orderTypeNextPage}&vendor={$vendor}\">\n\t\t" . $l['all']['VendorAttribute'] . "</a>\n\t\t</th>\n\n\t\t</tr> </thread>"; while ($row = $res->fetchRow()) { printqn("<tr>\n <td> <input type='checkbox' name='vendor[]' value='{$row['1']}||{$row['2']}'> {$row['0']} </td>\n\n\t\t\t\t<td>{$row['1']}</td>\n\n\t\t <td> <a class='tablenovisit' href='javascript:return;'\n onClick='javascript:ajaxGeneric(\"include/management/retVendorAttributeInfo.php\",\"retAttributeInfo\",\"divContainerAttributeInfo\",\"attribute={$row['2']}\");\n javascript:__displayTooltip();'\n tooltipText='\n <a class=\"toolTip\" href=\"mng-rad-attributes-edit.php?vendor={$row['1']}&attribute={$row['2']}\">\n {$l['Tooltip']['AttributeEdit']}</a>\n <br/><br/>\n\n <div id=\"divContainerAttributeInfo\">\n Loading...\n </div>\n <br/>'\n >{$row['2']}</a>\n \t </td>\n\t\t\t</tr>\n\t\t\t"); } echo "\n <tfoot>\n <tr>\n <th colspan='10' align='left'>\n "; setupLinks($pageNum, $maxPage, $orderBy, $orderType, "&vendor={$vendor}");
$_SESSION['reportType'] = "accountingGeneric"; //orig: used as maethod to get total rows - this is required for the pages_numbering.php page $sql = "SELECT " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".RadAcctId, " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".name as hotspot, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".UserName, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".FramedIPAddress, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctStartTime, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctStopTime, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctSessionTime, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctInputOctets, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctOutputOctets, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctTerminateCause, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".NASIPAddress FROM " . $configValues['CONFIG_DB_TBL_RADACCT'] . " LEFT JOIN " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . " ON " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".calledstationid = " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".mac WHERE " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".name='{$hotspot}';"; $res = $dbSocket->query($sql); $numrows = $res->numRows(); $sql = "SELECT " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".RadAcctId, " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".name as hotspot, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".UserName, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".FramedIPAddress, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctStartTime, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctStopTime, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctSessionTime, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctInputOctets, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctOutputOctets, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctTerminateCause, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".NASIPAddress FROM " . $configValues['CONFIG_DB_TBL_RADACCT'] . " LEFT JOIN " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . " ON " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".calledstationid = " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".mac WHERE " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".name='{$hotspot}' ORDER BY {$orderBy} {$orderType} LIMIT {$offset}, {$rowsPerPage};"; $res = $dbSocket->query($sql); $logDebugSQL = ""; $logDebugSQL .= $sql . "\n"; /* START - Related to pages_numbering.php */ $maxPage = ceil($numrows / $rowsPerPage); /* END */ echo "<table border='0' class='table1'>\n"; echo "\n <thead>\n\t\t\t\t<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\t\t\t<br/>\n\n <br/>\n "; if ($configValues['CONFIG_IFACE_TABLES_LISTING_NUM'] == "yes") { setupNumbering($numrows, $rowsPerPage, $pageNum, $orderBy, $orderType, "&hotspot={$hotspot}"); } echo " </th></tr>\n </thead>\n\n "; 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'] . "?hotspot={$hotspot}&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'] . "?hotspot={$hotspot}&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'] . "?hotspot={$hotspot}&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'] . "?hotspot={$hotspot}&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'] . "?hotspot={$hotspot}&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'] . "?hotspot={$hotspot}&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'] . "?hotspot={$hotspot}&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'] . "?hotspot={$hotspot}&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'] . "?hotspot={$hotspot}&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'] . "?hotspot={$hotspot}&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'] . "?hotspot={$hotspot}&orderBy=nasipaddress&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['NASIPAddress'] . "</a>\n\t\t</th>\n\t\t</tr> </thread>"; while ($row = $res->fetchRow()) { printqn("<tr>\n <td> {$row['0']} </td>\n <td> {$row['1']} </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 {$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\n <td> {$row['3']} </td>\n <td> {$row['4']} </td>\n <td> {$row['5']} </td>\n <td> " . time2str($row[6]) . " </td>\n <td> " . toxbyte($row[7]) . "</td>\n <td> " . toxbyte($row[8]) . "</td>\n <td> {$row['9']} </td>\n <td> {$row['10']} </td>\n </tr>"); } echo "\n <tfoot>\n <tr>\n <th colspan='12' align='left'>\n "; setupLinks($pageNum, $maxPage, $orderBy, $orderType, "&hotspot={$hotspot}");
$_SESSION['reportType'] = "accountingGeneric"; //orig: used as maethod to get total rows - this is required for the pages_numbering.php page $sql = "SELECT " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".RadAcctId, " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".name as hotspot, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".UserName, radacct.FramedIPAddress, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctStartTime, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctStopTime, radacct.AcctSessionTime, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctInputOctets, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctOutputOctets, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctTerminateCause, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".NASIPAddress FROM " . $configValues['CONFIG_DB_TBL_RADACCT'] . " LEFT JOIN " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . " ON " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".calledstationid = " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".mac WHERE FramedIPAddress='{$ipaddress}';"; $res = $dbSocket->query($sql); $numrows = $res->numRows(); $sql = "SELECT " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".RadAcctId, " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".name as hotspot, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".UserName, radacct.FramedIPAddress, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctStartTime, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctStopTime, radacct.AcctSessionTime, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctInputOctets, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctOutputOctets, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctTerminateCause, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".NASIPAddress FROM " . $configValues['CONFIG_DB_TBL_RADACCT'] . " LEFT JOIN " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . " ON " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".calledstationid = " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".mac WHERE FramedIPAddress='{$ipaddress}' ORDER BY {$orderBy} {$orderType} LIMIT {$offset}, {$rowsPerPage};"; $res = $dbSocket->query($sql); $logDebugSQL = ""; $logDebugSQL .= $sql . "\n"; /* START - Related to pages_numbering.php */ $maxPage = ceil($numrows / $rowsPerPage); /* END */ 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, "&ipaddress={$ipaddress}"); } echo " </th></tr>\n </thead>\n\n "; 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'] . "?ipaddress={$ipaddress}&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'] . "?ipaddress={$ipaddress}&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'] . "?ipaddress={$ipaddress}&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'] . "?ipaddress={$ipaddress}&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'] . "?ipaddress={$ipaddress}&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'] . "?ipaddress={$ipaddress}&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'] . "?ipaddress={$ipaddress}&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'] . "?ipaddress={$ipaddress}&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'] . "?ipaddress={$ipaddress}&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'] . "?ipaddress={$ipaddress}&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'] . "?ipaddress={$ipaddress}&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 <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 <td> {$row['3']} </td>\n <td> {$row['4']} </td>\n <td> {$row['5']} </td>\n <td> " . time2str($row[6]) . " </td>\n <td> " . toxbyte($row[7]) . "</td>\n <td> " . toxbyte($row[8]) . "</td>\n <td> {$row['9']} </td>\n <td> {$row['10']} </td>\n </tr>"); } echo "\n <tfoot>\n <tr>\n <th colspan='12' align='left'>\n "; setupLinks($pageNum, $maxPage, $orderBy, $orderType, "&ipaddress={$ipaddress}");
// +-------------+-------------+---------------+---------------------+ $user = $row[0]; $pass = $row[1]; $starttime = $row[3]; $reply = $row[2]; array_push($array_users, "{$user}"); array_push($array_pass, "{$pass}"); array_push($array_starttime, "{$starttime}"); array_push($array_reply, "{$reply}"); $count++; } // creating the table: echo "<table border='0' class='table1'>\n"; echo "\r\n <thead>\r\n\r\n <tr>\r\n <th colspan='10' align='left'>\r\n\r\n <input class='button' type='button' value='Exportar CSV'\r\n onClick=\"javascript:window.location.href='include/management/fileExport.php?reportFormat=csv'\"\r\n />\r\n\t\t <br/><br/>\r\n "; if ($configValues['CONFIG_IFACE_TABLES_LISTING_NUM'] == "yes") { setupNumbering($numrows, $rowsPerPage, $pageNum, $orderBy, $orderType, "&usernameLastConnect={$usernameLastConnect}"); } echo " </th></tr>\r\n </thead>\r\n\r\n "; if ($orderType == "asc") { $orderTypeNextPage = "desc"; } else { if ($orderType == "desc") { $orderTypeNextPage = "asc"; } } echo "<thread> <tr>\r\n <th scope='col'>\r\n <a title='Sort' class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?usernameLastConnect={$usernameLastConnect}&orderBy=" . $tableSetting['postauth']['user'] . "&orderType={$orderTypeNextPage}\">\r\n\t\t" . $l['all']['Username'] . " \r\n\t\t</th>\r\n\r\n <th scope='col'>\r\n <a title='Sort' class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?usernameLastConnect={$usernameLastConnect}&orderBy=pass&orderType={$orderTypeNextPage}\">\r\n\t\t" . $l['all']['Password'] . " \r\n\t\t</th>\r\n\r\n <th scope='col'>\r\n <a title='Sort' class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?usernameLastConnect={$usernameLastConnect}&orderBy=" . $tableSetting['postauth']['date'] . "&orderType={$orderTypeNextPage}\">\r\n\t\t" . $l['all']['StartTime'] . " \r\n\t\t</th>\r\n\r\n <th scope='col'>\r\n <a title='Sort' class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?usernameLastConnect={$usernameLastConnect}&orderBy=reply&orderType={$orderTypeNextPage}\">\r\n\t\t" . $l['all']['RADIUSReply'] . " \r\n\t\t</th>\r\n\r\n </tr> </thread>"; $i = 0; while ($i != $count) { if ($array_reply[$i] == "Access-Reject") { $reply = "<font color='red'> Rechazado </font>"; } else {