= 0 && $_GET['col'] < 5) { //Validitätsprüfung, nur Spalten 0..4 erlaubt $sort_column = $_GET['col']; } else { echo "

HANDS OFF MY URL!!!

"; $sort_column = 0; } } else { $sort_column = 0; }; if (isset($_GET['group'])) { $group = $_GET['group']; } else { $group = "no"; }; #error_log("INDEX.PHP GROUP: $group"); $title = "Who are my 'wireless' visitors"; $db = dbconnect(); $table = SEENTABLE; switch($sort_column) { case '0': $sql = "SELECT * FROM $table ORDER BY ID DESC"; $title = $title." (sort by ID)"; break; case '1': $sql = "SELECT * FROM $table ORDER BY TIME DESC"; $title = $title." (sort by Time)"; break; case '2': if ($group == "yes") { $sql = "SELECT * FROM $table GROUP BY MAC ASC"; $title = $title." (grouped by MAC)"; } else { $sql = "SELECT * FROM $table ORDER BY MAC ASC"; $title = $title." (sort by MAC)"; }; break; case '3': if ($group == "yes") { $sql = "SELECT * FROM $table GROUP BY Name DESC"; $title = $title." (grouped by Network name)"; } else { $sql = "SELECT * FROM $table ORDER BY Name DESC"; $title = $title." (sort by Network name)"; }; break; case '4': $sql = "SELECT * FROM $table ORDER BY Type DESC"; $title = $title." (sort by Network type)"; break; default: $sql = "SELECT * FROM $table ORDER BY Time DESC;"; $title = $title." (sort by Time)"; } ?> 'WhoIsWho' query($sql); while ($row = $sth->fetch()) { $comment = lookup_mac($row['MAC']); ?>


ID	Time	MAC (group)	Network name (group)	Network type	Comment
		&comment=","WhoIsWho MAC-Info","directories=0,titlebar=0,toolbar=0,location=0,status=0,menubar=0,scrollbars=yes,resizable=no,width=650,height=350"); return false;'>	","WhoIsWho Network-Info","directories=0,titlebar=0,toolbar=0,location=0,status=0,menubar=0,scrollbars=yes,resizable=no,width=950,height=350"); return false;'>