3 if (isset($_GET['mac']) && empty($_POST['submit'])) {
4 $query=open_database("select USER from knownclients where MAC='".$_GET['mac']."'");
6 <form action="" method="post">
8 <tr><td>MAC Address :</td>
9 <td><input id="mac" name="mac" type="text" class="rounded" value="<?php echo $_GET['mac']; ?>"></td></tr>
10 <tr><td><label>Client Name :</td>
11 <td><input id="user" name="user" type="text" class="rounded" value="<?php echo mysql_result($query,0,"USER") ?>"></td></tr>
12 <tr><td colspan=2 align="right">
13 <input name="submit" type="submit" value=" Update MAC ">
18 } elseif (isset($_POST['submit'])) {
21 $query=open_database("update knownclients set USER='$user' where MAC='$mac'");
22 echo "MAC Record updated.";
35 function print_devs() {
39 <div style="text-align:center; width=200px;">
40 <div id='admin' class='admin'>
42 <tr><td colspan=4>DEVICES</td></tr>
43 <tr><td><b>SSID</b></td><td><b>BSSID</b></td><td><b>MAC Address</b></td><td><b>Last Seen</b></td></tr>
45 $query=open_database("select BSSID, MAC, from_unixtime(LASTSEEN) as LASTSEEN from probe order by BSSID desc, LASTSEEN desc");
46 $num=mysql_numrows($query);
49 $query2=open_database("select SSID from beacon where BSSID='".mysql_result($query,$num,"BSSID")."'");
51 $num2=mysql_numrows($query2);
57 echo htmlspecialchars(mysql_result($query2,$num2,"SSID"))."<br>";
60 echo "</td><td>".htmlspecialchars(mysql_result($query,$num,"BSSID"))."</td><td>".mysql_result($query,$num,"MAC")."</td><td>".htmlspecialchars(mysql_result($query,$num,"LASTSEEN"))."</td></tr>";