<?php
 
include('geoipcity.inc');
 
$gi = geoip_open('/usr/local/share/GeoIP/GeoLiteCity.dat',GEOIP_STANDARD);
 
$connect = mysql_pconnect ('localhost','eprintstatspriv','AuldGrizzel');
$db = mysql_select_db('eprintstats',$connect) or die("Could not connect");
 
$query = "SELECT ip, COUNT(*) AS count FROM view WHERE (view_type = 'download') GROUP BY ip ORDER BY count DESC LIMIT 500";
$result = mysql_query($query,$connect);
 
if (mysql_num_rows($result) > 0)
{
	$i = 0;
	while ($row = mysql_fetch_assoc($result))
	{
		$ip = $row["ip"];
		$count = $row["count"];
		
		$location = GeoIP_record_by_addr($gi, $ip);
		
		if (isset($location->latitude))
		{
			$lat = $location->latitude;
			$long = $location->longitude;
			$city = $location->city;
			
			if ($city == '') $city = 'Unknown';
 
			$cities[$city]['lat'] = $lat;
			$cities[$city]['long'] = $long;
			if (!isset($cities[$city]['count'])) $cities[$city]['count'] = 0;
			$cities[$city]['count'] += $count;
			
		}
	}
 
	print "<markers>\n";
	foreach ($cities as $city => $loc)
	{
		print '<marker lat="' .
			$loc['lat'] .
			'" lng="' .
			$loc['long'] .
			'" city="' .
			$city .
			'" num="' .
			$loc['count'] .
			'" />' . "\n";
	}
	print "</markers>\n";
 
}
 
?>