<?
include('common.php');
include('database_login.php');

mConnect();

if (!isset($_SESSION['lat']) || !isset($_SESSION['lng'])) {
	##echo "laddar från maxmind\n";
	$geoip_data = geoip();
	$_SESSION['lat'] = $geoip_data['lat'];
	$_SESSION['lng'] = $geoip_data['lng'];
}

/*

$sql = sprintf("select p1.id as posid, user.id, p1.lng,p1.lat,p1.positioned from pos p1 
							left join pos p2 on(p1.user = p2.user and p1.positioned < p2.positioned) 
							left join user on (user.id = p1.user) 
							where p2.user is null and user.public = 1 
							order by positioned desc 
							LIMIT 10");
*/

$sql = sprintf("SELECT id FROM user ORDER BY pos_last_updated DESC LIMIT 10");
$user_res = mRead($sql);

$pos_arr = array();

$sql_frm = "SELECT p1.id AS posid, %d AS id, p1.lng,p1.lat,p1.positioned FROM pos p1 WHERE user = %d ORDER BY positioned DESC LIMIT 1"; 
while($tmp_user = mysql_fetch_assoc($user_res)) {
	$sql = sprintf($sql_frm, $tmp_user['id'],$tmp_user['id']);
	$pos_res = mRead($sql);
	while($pos = mysql_fetch_assoc($pos_res)) {
		$pos['positioned'] = prettyDateStrSwedish(time()-strtotime($pos['positioned']));
		$pos_arr[] = $pos;
	
	}

}

$smarty  = smartyInit();

pageMenu($smarty,basename(__FILE__));


switch($_SERVER['HTTP_HOST']) {
case 'lite.tuurf.com' : $gmapkey = 'ABQIAAAAp7JAwWKGjg8nxP4aA_nSSxTxZ8FEKgBhB4uI2V_8hQKY3_6H2xT0pbIXYqppHKGhpD473DVNfqVEKw'; break;
case 'grazzy.mjoelkbar.net': $gmapkey = 'ABQIAAAAp7JAwWKGjg8nxP4aA_nSSxQQWyZ49-SXz7NEMEMRhdl0_jifqhQkuO9pBQM3VRSSvNp-H9L9VAXRug'; break;
case 'litedev.tuurf.com': $gmapkey = 'ABQIAAAAp7JAwWKGjg8nxP4aA_nSSxReAlMsPVLnIz6vc6O7HDhQbOEdHBTbUUGw1Cof_vbGWTt6d0BszdZOZg'; break;
default: $gmapkey = 'ABQIAAAAp7JAwWKGjg8nxP4aA_nSSxTxZ8FEKgBhB4uI2V_8hQKY3_6H2xT0pbIXYqppHKGhpD473DVNfqVEKw'; break;
}

$loadstr = sprintf( "load(%s,%s); loadMarkers(pos); fetchLocNames($('lookmeup'));", $_SESSION['lat'], $_SESSION['lng']);
$smarty->assign('onload', $loadstr);
$smarty->assign('onunload', 'GUnload();');

$smarty->assign('base', sprintf('http://%s/',$_SERVER['SERVER_NAME']));
$smarty->assign('positioner', $pos_arr);
//$smarty->assign('gmapkey', 'ABQIAAAAp7JAwWKGjg8nxP4aA_nSSxTPDJcgliXv7sW1W3CpZ39yyX41EhTO4nu57sBygLiPXxUYtqqOs4Jjxw');
$smarty->assign('gmapkey',$gmapkey);
$smarty->display('index.tpl');


mDisconnect();
?>