pranavk/analyse_ssh_usage.php

## analyse_ssh_usage.php
<?php
	$connect = mysql_connect("localhost", "username", "password");
	if($connect) {
		mysql_select_db("sshaccount");

		$inputquery = "select UNIX_TIMESTAMP(time) as `time`, `out` from minute where user='username' order by time;";
		$arr = mysql_query ($inputquery);

		while ($row = mysql_fetch_array($arr)) {
			$datetime = $row['time']*1000;
			$out = $row['out'];
			$data[] = "[$datetime, $out]";
		}
	}

?>

<html>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.2/jquery.min.js"></script>
<script src="http://code.highcharts.com/stock/highstock.js"></script>

<script src="https://ajax.googleapis.com/ajax/libs/prototype/1.7/prototype.js"></script>
<script src="http://code.highcharts.com/adapters/prototype-adapter.js"></script>
<script>
Highcharts.setOptions({
  global: {
    useUTC: false
  }
});

function humanFileSize(bytesStr) {
    var bytes = parseInt(bytesStr);
    var thresh = 1000;
    if(bytes < thresh) return bytes + ' B';
    var units = ['kB','MB','GB','TB','PB','EB','ZB','YB'];
    var u = -1;
    do {
        bytes /= thresh;
        ++u;
    } while(bytes >= thresh);
    var res = bytes.toFixed(1)+' '+units[u];
    return res;
}

</script>

<script>
document.observe("dom:loaded", function() {
var chart = new Highcharts.StockChart({
      chart: {
       renderTo: 'container'
      },
      tooltip: {
	      formatter: function () {
	    	var s = '<b>' + Highcharts.dateFormat('%A, %b %e, %Y', this.x) + '</b>';
    		s += '<br/>' + humanFileSize(this.y);
    		return s;
      	}
      },
      rangeSelector: {
       selected: 1
      },
      title: {
       text: 'Internet Usage by username'
      },
      series: [{
	      name: 'username',
        data: [<?php echo join($data, ',') ?>],
      }]
});
});
</script>

<body>
<div id="container" style="height: 400px; min-width: 310px"></div>
</body>
</html>
	<?php
	$connect = mysql_connect("localhost", "username", "password");
	if($connect) {
	mysql_select_db("sshaccount");

	$inputquery = "select UNIX_TIMESTAMP(time) as `time`, `out` from minute where user='username' order by time;";
	$arr = mysql_query ($inputquery);

	while ($row = mysql_fetch_array($arr)) {
	$datetime = $row['time']*1000;
	$out = $row['out'];
	$data[] = "[$datetime, $out]";
	}
	}

	?>

	<html>
	<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.2/jquery.min.js"></script>
	<script src="http://code.highcharts.com/stock/highstock.js"></script>

	<script src="https://ajax.googleapis.com/ajax/libs/prototype/1.7/prototype.js"></script>
	<script src="http://code.highcharts.com/adapters/prototype-adapter.js"></script>
	<script>
	Highcharts.setOptions({
	global: {
	useUTC: false
	}
	});

	function humanFileSize(bytesStr) {
	var bytes = parseInt(bytesStr);
	var thresh = 1000;
	if(bytes < thresh) return bytes + ' B';
	var units = ['kB','MB','GB','TB','PB','EB','ZB','YB'];
	var u = -1;
	do {
	bytes /= thresh;
	++u;
	} while(bytes >= thresh);
	var res = bytes.toFixed(1)+' '+units[u];
	return res;
	}

	</script>

	<script>
	document.observe("dom:loaded", function() {
	var chart = new Highcharts.StockChart({
	chart: {
	renderTo: 'container'
	},
	tooltip: {
	formatter: function () {
	var s = '<b>' + Highcharts.dateFormat('%A, %b %e, %Y', this.x) + '</b>';
	s += '<br/>' + humanFileSize(this.y);
	return s;
	}
	},
	rangeSelector: {
	selected: 1
	},
	title: {
	text: 'Internet Usage by username'
	},
	series: [{
	name: 'username',
	data: [<?php echo join($data, ',') ?>],
	}]
	});
	});
	</script>

	<body>
	<div id="container" style="height: 400px; min-width: 310px"></div>
	</body>
	</html>