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>MAC Address</b></td><td><b>Client</b></td></tr>
45 $query=open_database("select t1.SSID as SSID, t2.MAC as MAC from ssid t1, clients t2 where t1.MAC=t2.BSSID order by t1.SSID desc");
46 $num=mysql_numrows($query);
49 $query2=open_database("select USER from knownclients where MAC='".mysql_result($query,$num,"MAC")."'");
50 echo "<tr><td>".htmlspecialchars(mysql_result($query,$num,"SSID"))."</td><td><a href='?mac=".mysql_result($query,$num,"MAC")."'>".mysql_result($query,$num,"MAC")."</a></td><td>".htmlspecialchars(mysql_result($query2,0,"USER"))."</td></tr>";