<?
require_once("../cms/lib/database.inc.php");
require_once(dirname(__FILE__) . "/config.inc.php");

if (isset($_GET['show'])) {
	print_r (file_get_contents("http://geoip.maxmind.com/b?l=IrAcnvIKfXTr&i=" . (isset($_GET['ip']) ? $_GET['ip'] : $_SERVER['REMOTE_ADDR'])));
} else if (isset($_GET['id']) && isset($_GET['version'])) {
	$db = new Database("data", $config['db']);
	$id = Database::escape($_GET['id']);
	$version = Database::escape($_GET['version']);
	$db->query("DELETE FROM `geo` WHERE time<(NOW() - INTERVAL 7 DAY)");
	if (!$db->query("UPDATE `geo` SET time=NOW() WHERE user_id='$id'")) {
		$info = preg_split("/,/", file_get_contents("http://geoip.maxmind.com/b?l=" . $config['maxmind_key'] . "&i=" . (isset($_GET['ip']) ? $_GET['ip'] : $_SERVER['REMOTE_ADDR'])));
		if ($id && $info && $info[3] && $info[4]) {
			$db->query("INSERT INTO `geo` (user_id, lat, lng, version) VALUES ('$id', '{$info[3]}', '{$info[4]}', '$version')");
		}
	}
}