2015-03-30 16:59:19 -04:00
|
|
|
<html>
|
|
|
|
|
<head>
|
|
|
|
|
<link rel="stylesheet" type="text/css" href="css/style.css">
|
|
|
|
|
<link rel="shortcut icon" href="favicon.ico" />
|
|
|
|
|
<script type='text/javascript' src='mapdata/jquery-1.6.2.min.js'></script>
|
|
|
|
|
<script type='text/javascript' src='mapdata/jquery-ui.min.js'></script>
|
|
|
|
|
<script type='text/javascript' src='mapdata/mcplus/src/markerclusterer_packed.js'></script>
|
|
|
|
|
<title>Traffic Mapping</title>
|
|
|
|
|
<?php
|
|
|
|
|
$varPort2 = $_GET['formPort'];
|
|
|
|
|
if($varPort2 != ""){
|
|
|
|
|
echo "<meta http-equiv=\"refresh\" content=\"60; mapping.php?formPort=" . $varPort2. "\">";
|
|
|
|
|
}
|
|
|
|
|
?>
|
|
|
|
|
<script type="text/javascript" src="https://maps.googleapis.com/maps/api/js?sensor=false" /></script>
|
|
|
|
|
<!-- Javascript to display markers on the map at locations determined by the geolocation code below -->
|
|
|
|
|
<script type='text/javascript'>
|
|
|
|
|
//This javascript will load when the page loads.
|
|
|
|
|
jQuery(document).ready( function($){
|
2015-08-25 23:37:44 -04:00
|
|
|
|
2015-03-30 16:59:19 -04:00
|
|
|
//Initialize the Google Maps
|
|
|
|
|
var geocoder;
|
|
|
|
|
var map;
|
|
|
|
|
var markersArray = [];
|
|
|
|
|
var infos = [];
|
2015-08-25 23:37:44 -04:00
|
|
|
|
2015-03-30 16:59:19 -04:00
|
|
|
geocoder = new google.maps.Geocoder();
|
|
|
|
|
var myOptions = {
|
|
|
|
|
zoom: 2,
|
|
|
|
|
mapTypeId: google.maps.MapTypeId.ROADMAP,
|
|
|
|
|
center: new google.maps.LatLng(-50.59204, 32.16166),
|
|
|
|
|
}
|
|
|
|
|
//Load the Map into the map_canvas div
|
|
|
|
|
var map = new google.maps.Map(document.getElementById("map_canvas"), myOptions);
|
|
|
|
|
// map = new google.maps.Map(document.getElementById("map_canvas"), myOptions);
|
2015-08-25 23:37:44 -04:00
|
|
|
var mcOptions = {gridSize: 50, maxZoom: 14};
|
2015-03-30 16:59:19 -04:00
|
|
|
//Initialize a variable that the auto-size the map to whatever you are plotting
|
|
|
|
|
var bounds = new google.maps.LatLngBounds();
|
|
|
|
|
//Initialize the encoded string
|
|
|
|
|
var encodedString;
|
|
|
|
|
//Initialize the array that will hold the contents of the split string
|
|
|
|
|
var stringArray = [];
|
|
|
|
|
//Get the value of the encoded string from the hidden input
|
|
|
|
|
encodedString = document.getElementById("encodedString").value;
|
|
|
|
|
//Split the encoded string into an array the separates each location
|
|
|
|
|
stringArray = encodedString.split("****");
|
2015-08-25 23:37:44 -04:00
|
|
|
|
2015-03-30 16:59:19 -04:00
|
|
|
var x;
|
|
|
|
|
for (x = 0; x < stringArray.length; x = x + 1)
|
|
|
|
|
{
|
|
|
|
|
var addressDetails = [];
|
|
|
|
|
var marker;
|
|
|
|
|
//Separate each field
|
|
|
|
|
addressDetails = stringArray[x].split("&&&");
|
|
|
|
|
//Load the lat, long data
|
|
|
|
|
var lat = new google.maps.LatLng(addressDetails[1], addressDetails[2]);
|
|
|
|
|
//Create a new marker and info window
|
|
|
|
|
marker = new google.maps.Marker({
|
|
|
|
|
map: map,
|
|
|
|
|
position: lat,
|
|
|
|
|
//Content is what will show up in the info window
|
|
|
|
|
content: addressDetails[0]
|
|
|
|
|
});
|
|
|
|
|
//Pushing the markers into an array so that it's easier to manage them
|
|
|
|
|
markersArray.push(marker);
|
|
|
|
|
google.maps.event.addListener( marker, 'click', function () {
|
|
|
|
|
closeInfos();
|
|
|
|
|
var info = new google.maps.InfoWindow({content: this.content});
|
|
|
|
|
//On click the map will load the info window
|
|
|
|
|
info.open(map,this);
|
|
|
|
|
infos[0]=info;
|
|
|
|
|
});
|
|
|
|
|
//Extends the boundaries of the map to include this new location
|
|
|
|
|
bounds.extend(lat);
|
|
|
|
|
}
|
|
|
|
|
//Takes all the lat, longs in the bounds variable and autosizes the map
|
|
|
|
|
// map.fitBounds(bounds);
|
|
|
|
|
var mc = new MarkerClusterer(map, markersArray, mcOptions);
|
|
|
|
|
//Manages the info windows
|
|
|
|
|
function closeInfos(){
|
|
|
|
|
if(infos.length > 0){
|
|
|
|
|
infos[0].set("marker",null);
|
|
|
|
|
infos[0].close();
|
|
|
|
|
infos.length = 0;
|
|
|
|
|
}
|
|
|
|
|
}
|
2015-08-25 23:37:44 -04:00
|
|
|
|
2015-03-30 16:59:19 -04:00
|
|
|
});
|
|
|
|
|
</script>
|
|
|
|
|
</head>
|
|
|
|
|
<body>
|
|
|
|
|
<div class=header>
|
2015-08-25 23:37:44 -04:00
|
|
|
<h2>Traffic Monitoring</h2>
|
2015-03-30 16:59:19 -04:00
|
|
|
<h3>Source IP Address Mapping</h3>
|
|
|
|
|
<?php include("includes/menu.php"); ?>
|
|
|
|
|
</div>
|
|
|
|
|
<div class=content>
|
|
|
|
|
<h3>YOU MUST SELECT A SERVICE TO VIEW DATA!</h3>
|
|
|
|
|
<h4>Plotted on the map are the GeoLocated Coordinates of every Source IP from the last 15 Minutes for the selected service.</h4>
|
|
|
|
|
<!-- MySQL connection to retrieve data for the service selection dropdown -->
|
|
|
|
|
<?php
|
|
|
|
|
//Include DB Connection Info
|
|
|
|
|
include("includes/db_config.php");
|
2015-08-25 23:37:44 -04:00
|
|
|
|
2015-03-30 16:59:19 -04:00
|
|
|
// Create connection
|
|
|
|
|
$conn = new mysqli($servername, $username, $password, $dbname);
|
2015-08-25 23:37:44 -04:00
|
|
|
|
2015-03-30 16:59:19 -04:00
|
|
|
//Create dropdown
|
|
|
|
|
$query = "SELECT port, svc_name FROM commonports ORDER BY port";
|
|
|
|
|
$tbllist = mysqli_query($conn, $query);
|
|
|
|
|
$options = "";
|
|
|
|
|
while ($row = mysqli_fetch_array($tbllist))
|
|
|
|
|
{
|
|
|
|
|
$id=$row["port"];
|
|
|
|
|
$name=$row["svc_name"];
|
|
|
|
|
$options.="<option value=\"$id\">$id - $name</option>";
|
|
|
|
|
}
|
2015-08-25 23:37:44 -04:00
|
|
|
|
2015-03-30 16:59:19 -04:00
|
|
|
//Check Connection
|
|
|
|
|
if ($conn->connect_error) {
|
|
|
|
|
die("Connection Failed: " . $conn->connect_error);
|
|
|
|
|
}
|
|
|
|
|
$conn->close();
|
|
|
|
|
?>
|
|
|
|
|
<p>
|
|
|
|
|
<!-- Service Selection Menu -->
|
|
|
|
|
<form>
|
|
|
|
|
<p>
|
|
|
|
|
For which service would you like to see data?
|
|
|
|
|
<br>
|
|
|
|
|
<select name="formPort">
|
|
|
|
|
<option value=0>Select a service</option>
|
|
|
|
|
<?php echo $options?>
|
|
|
|
|
</select>
|
|
|
|
|
<br>
|
|
|
|
|
<input name="formSubmit" type="submit" value="Submit">
|
|
|
|
|
<br>
|
|
|
|
|
</p>
|
|
|
|
|
</form>
|
|
|
|
|
</div>
|
|
|
|
|
<div id='input'>
|
|
|
|
|
<!-- Geolcoate the IPs returned by the query for the selected service -->
|
|
|
|
|
<?php
|
|
|
|
|
require_once "Net/GeoIP.php";
|
|
|
|
|
$geoip = Net_GeoIP::getInstance("mapdata/GeoLiteCity.dat");
|
|
|
|
|
//Get data from the form submit
|
|
|
|
|
if(isset($_GET['formPort'])){
|
|
|
|
|
$varPort = $_GET['formPort'];
|
|
|
|
|
}else{
|
|
|
|
|
$varPort = 0;
|
|
|
|
|
}
|
2015-08-25 23:37:44 -04:00
|
|
|
|
2015-03-30 16:59:19 -04:00
|
|
|
//Connect to DB to pull IPs
|
2015-08-25 23:37:44 -04:00
|
|
|
|
2015-03-30 16:59:19 -04:00
|
|
|
// Create connection
|
|
|
|
|
$conn1 = new mysqli($servername, $username, $password, $dbname);
|
2015-08-25 23:37:44 -04:00
|
|
|
|
2015-03-30 16:59:19 -04:00
|
|
|
//Create dropdown
|
|
|
|
|
$query1 = "SELECT src_ip FROM rawdata WHERE `dst_port` = '".$varPort."' AND time > (UNIX_TIMESTAMP() - 900) GROUP BY src_ip";
|
|
|
|
|
$iplist = mysqli_query($conn1, $query1);
|
2015-08-25 23:37:44 -04:00
|
|
|
|
2015-03-30 16:59:19 -04:00
|
|
|
echo "Now Viewing data for Destination port: $varPort";
|
2015-08-25 23:37:44 -04:00
|
|
|
|
2015-03-30 16:59:19 -04:00
|
|
|
//Initialize your first couple variables
|
|
|
|
|
$encodedString = ""; //This is the string that will hold all your location data
|
|
|
|
|
$x = 0; //This is a trigger to keep the string tidy
|
2015-08-25 23:37:44 -04:00
|
|
|
|
|
|
|
|
|
2015-03-30 16:59:19 -04:00
|
|
|
//Multiple rows are returned
|
|
|
|
|
while ($row = mysqli_fetch_array($iplist))
|
|
|
|
|
{
|
|
|
|
|
$ip = $row['src_ip'];
|
|
|
|
|
$location = $geoip->lookupLocation($ip);
|
|
|
|
|
$varDestLink = "<a href=destinationips.php?formIP=".$row['src_ip']."&formPort=".$varPort." target=_blank>List</a>";
|
|
|
|
|
//This is to keep an empty first or last line from forming, when the string is split
|
|
|
|
|
if ( $x == 0 )
|
|
|
|
|
{
|
|
|
|
|
$separator = "";
|
|
|
|
|
}
|
|
|
|
|
else
|
|
|
|
|
{
|
|
|
|
|
//Each row in the database is separated in the string by four *'s
|
|
|
|
|
$separator = "****";
|
|
|
|
|
}
|
|
|
|
|
//Saving to the String, each variable is separated by three &'s
|
|
|
|
|
$encodedString = $encodedString.$separator.
|
|
|
|
|
"<p class='content'><b>IP: </b>".$row['src_ip'].
|
|
|
|
|
"<br><b>Destinations: </b>".$varDestLink.
|
|
|
|
|
//"<br><b>Lat:</b> ".$location->latitude.
|
|
|
|
|
//"<br><b>Long:</b> ".$location->longitude.
|
|
|
|
|
"</p>&&&".$location->latitude."&&&".$location->longitude;
|
|
|
|
|
$x = $x + 1;
|
|
|
|
|
}
|
|
|
|
|
$conn1->close();
|
|
|
|
|
?>
|
|
|
|
|
<input type="hidden" id="encodedString" name="encodedString" value="<?php echo $encodedString; ?>" />
|
|
|
|
|
</div>
|
|
|
|
|
<div id="map_canvas"></div>
|
|
|
|
|
<div class=footer>
|
|
|
|
|
This product includes GeoLite data created by MaxMind, available from
|
|
|
|
|
<a href="http://www.maxmind.com">http://www.maxmind.com</a>
|
|
|
|
|
</div>
|
|
|
|
|
</body>
|
|
|
|
|
</html>
|
