From: Russ Handorf Date: Wed, 2 Mar 2016 03:41:46 +0000 (-0500) Subject: testing for Chris X-Git-Url: https://handorf.org/code/?p=soho-sigint.git;a=commitdiff_plain;h=d12bfc61e602468e331c843c842135ccac3056c8 testing for Chris --- diff --git a/server/clientdevices.soho b/server/clientdevices.soho index 28e03a2..a5ce3bb 100644 --- a/server/clientdevices.soho +++ b/server/clientdevices.soho @@ -6,15 +6,15 @@ if (isset($_GET['mac']) && empty($_POST['submit'])) {
- + - +
MAC Address :
">
">
- DEVICES SSIDBSSIDMAC AddressLast Seen 0) { $num--; - $query2=open_database("select SSID from ssid where MAC='".mysql_result($query,$num,"BSSID")."'"); + $query2=open_database("select SSID from beacon where BSSID='".mysql_result($query,$num,"BSSID")."'"); echo ""; $num2=mysql_numrows($query2); if ($num2==0) { diff --git a/server/database.sql b/server/database.sql index 681bc9f..3cb69c4 100644 --- a/server/database.sql +++ b/server/database.sql @@ -1,3 +1,9 @@ +-- MySQL dump 10.13 Distrib 5.5.41, for debian-linux-gnu (x86_64) +-- +-- Host: localhost Database: wireless +-- ------------------------------------------------------ +-- Server version 5.5.41-0+wheezy1 + /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; @@ -9,6 +15,23 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; +-- +-- Table structure for table `beacon` +-- + +DROP TABLE IF EXISTS `beacon`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `beacon` ( + `SSID` varchar(32) NOT NULL DEFAULT '', + `BSSID` varchar(17) NOT NULL DEFAULT '00:00:00:00:00:00', + `CHANNEL` varchar(4) DEFAULT NULL, + `RSSI` int(11) DEFAULT NULL, + `LASTSEEN` int(11) DEFAULT NULL, + PRIMARY KEY (`SSID`,`BSSID`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1; +/*!40101 SET character_set_client = @saved_cs_client */; + -- -- Table structure for table `bssid` -- @@ -103,6 +126,24 @@ CREATE TABLE `knownclients` ( ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `probe` +-- + +DROP TABLE IF EXISTS `probe`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `probe` ( + `SSID` varchar(32) NOT NULL DEFAULT '', + `MAC` varchar(17) NOT NULL DEFAULT '00:00:00:00:00:00', + `BSSID` varchar(17) NOT NULL DEFAULT '00:00:00:00:00:00', + `CHANNEL` varchar(4) DEFAULT NULL, + `RSSI` int(11) DEFAULT NULL, + `LASTSEEN` int(11) DEFAULT NULL, + PRIMARY KEY (`SSID`,`MAC`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1; +/*!40101 SET character_set_client = @saved_cs_client */; + -- -- Table structure for table `ssid` -- @@ -127,3 +168,4 @@ CREATE TABLE `ssid` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; +-- Dump completed on 2016-03-01 22:40:22 diff --git a/server/index.php b/server/index.php index 72ce911..c77a55c 100644 --- a/server/index.php +++ b/server/index.php @@ -1,5 +1,4 @@ diff --git a/server/index.soho b/server/index.soho index ba003b5..e4c06ff 100644 --- a/server/index.soho +++ b/server/index.soho @@ -6,15 +6,15 @@ if (isset($_GET['mac']) && empty($_POST['submit'])) {
- + - +
MAC Address :
">
">
- - + - +
MAC Address :
">
">
- - + 0) { $num--; - echo ""; + echo ""; } ?>
DEVICES
SSIDMAC AddressLast Seen
SSIDBSSID AddressLast Seen
".htmlspecialchars(mysql_result($query,$num,"SSID"))."".mysql_result($query,$num,"MAC")."".htmlspecialchars(mysql_result($query,$num,"LASTSEEN"))."
".htmlspecialchars(mysql_result($query,$num,"SSID"))."".mysql_result($query,$num,"BSSID")."".htmlspecialchars(mysql_result($query,$num,"LASTSEEN"))."