<?
$preventDirectLink = 0;
require_once("page.php");

if (isset($_SESSION['admin']))
{
	$sql = GetDB();
	$sql->query("SELECT day FROM general");
	if (!$sql->next())
		die("Error in database table 'general'. Please contact the site administrator.");

	$page = new Page();

	$page->Add(new CBlock(new CParagraph(SelectLang(array('en' => "Hello, ",
														  'nl' => "Hallo, ")) . $_SESSION['admin'])));
	$page->Add(new CBlock(new CParagraph(SelectLang(array('en' => "The toto is currently in stage " . $sql->get(0) . ".",
														  'nl' => "De toto zit in etappe " . $sql->get(0) . ".")))));
	$page->Add(new CBlock(new CParagraph(SelectLang(array('en' => "The current server time is " . date("Y-m-d H:i:s") . ".",
														  'nl' => "De huidige servertijd is " . date("Y-m-d H:i:s") . ".")))));

	unset($sql);
	$page->Display();
}
else if (isset($_SESSION['name'])) // members page
{
	// get data from db
	$sql = GetDB();
	// get day
	$sql->query("SELECT day, next_lock, next_unlock FROM general");
	$gen = $sql->next();
	// get last day with results
	$sql->query("SELECT MAX(day) FROM history");
	$sql->next();
	$last_day = $sql->get(0);
	// get player data
	$sql->query("SELECT budget, team_value FROM player WHERE player_id='" . $_SESSION['id'] . "'");
	$pl = $sql->next();
	// get team size
	$sql->query("SELECT cyclist_id FROM current_team WHERE player_id='" . $_SESSION['id'] . "'");
	$team_size = $sql->nr_results();
	// get rankings
	$sql->query("SELECT wealth, points, gained, pos1, pos2, pos3 FROM history WHERE player_id='" . $_SESSION['id'] . "' AND day='" . $last_day . "'");
	$sql->next();

	// create page
	$page = new Page();

	$page->Add(new CBlock(new CParagraph(SelectLang(array('en' => "Hello, ", 'nl' => "Hallo, ")) . $_SESSION['name'])));
	$page->Add(new CBlock(new CParagraph(SelectLang(array('en' => "Your budget is &euro; " . $pl[0] . ".<br/>\nYou have " . $team_size . " cyclists on your team.<br/>\nYour team value is &euro; " . $pl[1] . ".<br/>\nYour total wealth is &euro; " . ($pl[0] + $pl[1]) . ".",
														  'nl' => "Je budget is &euro; " . $pl[0] . ".<br/>\nJe hebt " . $team_size . " renners in je team.<br/>\nDe waarde van je team is &euro; " . $pl[1] . ".<br/>\nJe totale vermogen is &euro; " . ($pl[0] + $pl[1]) . ".")))));

	$block = new CBlock();
	$time = date("Y-m-d H:i:s");
	if ($time < $gen[1])
	{
		$block->Add(new CParagraph(SelectLang(array('en' => "The system is currently unlocked. You are free to make changes to your team.",
													'nl' => "Het systeem in momenteel open. Je kunt je team aanpassen."))));
		$block->Add(new CParagraph(SelectLang(array('en' => "The next lock-in is set to " . $gen[1] . ".<br/>\nThe current server time is " . $time . ".",
													'nl' => "De volgende sluiting is om " . $gen[1] . ".<br/>\nDe huidige servertijd is " . $time . "."))));
	}
	else
	{
		$block->Add(new CParagraph(SelectLang(array('en' => "The system is currently locked. You cannot make any changes to your team, but you can view the teams of the other players.",
													'nl' => "Het systeem is momenteel op slot. Je kunt je team niet veranderen, maar je kunt de teams van de andere spelers wel bekijken."))));
		$block->Add(new CParagraph(SelectLang(array('en' => "The expected time when the lock-in ends is " . $gen[2] . ".<br/>\nThe current server time is " . $time . ".",
													'nl' => "De verwachte tijd wanneer de sluiting eindigt is " . $gen[2] . ".<br/>\nDe huidige servertijd is " . $time . "."))));
	}
	$page->Add($block);

	if ($gen[0] > 1)
	{
		$table = new CTable(3, 1, true);
		$table->AddRow(SelectLang(array('en' => array("", "Value", "Your ranking"),
										'nl' => array("", "Waarde", "Jouw plaats"))));
		$table->AddRow(array(SelectLang(array('en' => "Wealth",
											  'nl' => "Vermogen")), "&euro; " . $sql->get(0), $sql->get(3)));
		$table->AddRow(array(SelectLang(array('en' => "Points",
											  'nl' => "Punten")), $sql->get(1), $sql->get(4)));
		$table->AddRow(array(SelectLang(array('en' => "Last day's results",
											  'nl' => "Laatste etappe")), $sql->get(2), $sql->get(5)));
		$page->Add(new CBlock($table));
	}

	unset($sql);
	$page->Display();
}
else
{
	$page = new Page();

	// number of players
	$sql = GetDB();
	$sql->query("SELECT active FROM player_info WHERE active='0'");
	$n_players = $sql->nr_results();

	$page->Add(new CBlock(array(
		new CParagraph(SelectLang(array('en' => "Welcome to the Giro Toto, the cycling manager game for the Giro d'Italia 2007.",
										'nl' => "Welkom bij de Giro Toto, het wielren manager spel voor de Giro d'Italia 2007."))),
		new CParagraph(SelectLang(array('en' => "There are currently " . $n_players . " participants in the toto. If you would like to join, click the 'Register' link on the top or left.",
										'nl' => "Er zijn op het moment " . $n_players . " deelnemers in de toto. Wil je ook meedoen, klik dan op 'Registreer' bovenaan of links.")))
		)));

	// welcome text
	$text = null;
	$sql->query("SELECT * FROM welcome");
	while ($sql->next())
	{
		if ($sql->get(0) == $_SESSION['lang'])
		{
			$text = $sql->get(1);
			break;
		}
		else if (!$text)
			$text = $sql->get(1);
	}
	unset($sql);

	$block = new CBlock();
	$text = explode("~", $text);
	for ($i = 0; $i < sizeof($text); $i++)
	{
		$str = stripslashes($text[$i]);
		$block->Add(new CParagraph($str));
	}
	$page->Add($block);

	$page->Display();
}
?>