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

session_start();

/* set up the locale variables */

if (isset($_GET['lang'])) { // ge user-input prio
	$locale = $_GET['lang'];
} else { // defaulta till att kolla med geoip.
	$locale = $_SERVER['GEOIP_COUNTRY_NAME']=='Sweden' ? 'sv_SE' : 'en_US';  // svenska om svenskt ip
}

if ($locale=='sv_SE') {
	$_SESSION['locale'] = 'sv_SE';
	set_lang('sv_SE');
	$taxonomy_id = 3;
	$faq_lang = 'sv';
} else { 
	$_SESSION['locale'] = 'en_US';
	set_lang('en_US');
	$taxonomy_id = 4;
	$faq_lang = 'en';
}

mConnect();

if (!isset($_SESSION['lat']) || !isset($_SESSION['lon'])) {
	##echo "laddar från maxmind\n";
	$geoip_data = geoip();
	$_SESSION['lat'] = $geoip_data['lat'];
	$_SESSION['lon'] = $geoip_data['lon'];
}


$posts_sql = sprintf("SELECT a.ID,user_nicename,post_content,post_title, post_date from wp_posts a 
								LEFT JOIN wp_users b ON(b.ID = a.post_author) 
								LEFT JOIN wp_term_relationships c ON(c.object_id = a.ID)
							WHERE a.post_type = 'post' AND c.term_taxonomy_id=%d 
							ORDER BY a.post_date DESC", $taxonomy_id);
							
#echo $posts_sql;
$posts_res = mRead($posts_sql);

while($post = mysql_fetch_assoc($posts_res)) {
	$posts[] = array(	'ID' => $post['ID'], 
										'user_nicename' => $post['user_nicename'],
										'post_content' => nl2br($post['post_content']), 
										'post_title' => $post['post_title'],
										'post_date' => strftime('%y/%m/%d',strtotime($post['post_date'])),
										'post_author' => $post['user_nicename']
									);
}

$faq_sql = sprintf("SELECT a.ID,post_content,post_title, post_date,post_modified from wp_posts a 
							WHERE a.post_type = 'page' AND a.post_title = 'FAQ %s' 
							ORDER BY a.post_date DESC", $faq_lang);

#echo $faq_sql;
$faq_res = mRead($faq_sql);
$faq = mysql_fetch_assoc($faq_res);

switch($_SERVER['SERVER_NAME']) {
	case 'grazzy.mjoelkbar.net' : $key = "ABQIAAAAp7JAwWKGjg8nxP4aA_nSSxT5gwVqmmCGY-B0SIS8kmBg6ptlbxT6x0Jtkh8WPPBlhfrpxiUjFIaEYQ"; break;
	case 'test.tuurf.com' : $key = "ABQIAAAAp7JAwWKGjg8nxP4aA_nSSxS7nAhOLjEDwPAiLAdjwPxVXTZIAxRvb8etax1CrrBTAMq3dgiRDQoNmA"; break;
	case 'www.tuurf.com' : $key = "ABQIAAAAp7JAwWKGjg8nxP4aA_nSSxRTuQu_1dOkvTU4j4CZNGxjdKSH2RRKJzEAl9J_a2Jg0I4KISzfR0oCBA"; break;
	case 'tuurf.com' : $key = "ABQIAAAAp7JAwWKGjg8nxP4aA_nSSxR0q7gpKND4tmQ4YK6oyZMSXv1wRRQthRLiLGXQ0iN5rJTBpJkyaY0plA"; break;
}

#test #ABQIAAAAp7JAwWKGjg8nxP4aA_nSSxS7nAhOLjEDwPAiLAdjwPxVXTZIAxRvb8etax1CrrBTAMq3dgiRDQoNmA
#print_r($posts);
$smarty  = smartyInit();

$loadstr = sprintf( "load(%s,%s);", $_SESSION['lat'], $_SESSION['lon']);
$smarty->assign('onload', $loadstr);
$smarty->assign('onunload', 'GUnload();');
$smarty->assign('gmapkey', $key);
$smarty->assign('posts', $posts);
$smarty->assign('faq', nl2br($faq['post_content']));
$smarty->assign('rss_url', 'rss_'.$faq_lang);

$smarty->display('index.tpl');

mDisconnect();
?>