<?php
session_start();
include ("docs/db.php");
if (!empty($_GET["a"]))
{
	$page = $_GET["a"];
}
else
{
	$page = "news";
}
if (isset($_SESSION["logged"]))
{
	if ($_SESSION["logged"]==true)
	{
		$user = $_SESSION["user"];
		$logged = true;
	}
	else
	{
		$logged = false;
	}
}
else
{
	$user = "";
	$logged = false;
}
if (!empty($_GET["logout"]))
{
	$_SESSION["logged"]=false;
	$_SESSION["user"]="";
	echo "<script type='text/JavaScript'>this.location='?a=news';</script>";
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
<meta http-equiv="Content-Type" content="application/xhtml+xml;charset=utf-8" />
<?php
include('./docs/stylechanger.php');
?>
<title>crimzor</title>
</head>
<body>

<h2>crimzor
<?php
	if ($logged){
		printf (" - <a href='?a=newsadmin'>add news</a> - <a href='?a=boxadmin'>add boxes</a> - <a href='?logout=1'>logout</a>");
	}
?>
</h2>
<div id="barimg"></div>
<div id="big">
<div id="main">
	<?php
	include("docs/" . $page . ".php");
	?>
</div>
<div id="right">
<?php

        $query = "SELECT * FROM boxes ORDER BY id ASC";
		$counter =  0;
        $result = pg_query($query);
        if (!$result) {
            echo "Problem with query " . $query . "<br />";
            echo pg_last_error();
            exit();
        }

        while($myrow = pg_fetch_assoc($result)) {
			if (!$counter){
				$counter = 1;
			}
			else {
				$counter = 0;
			}
			$str =  $myrow['box'];
			if ($myrow['type']==0){
				printf ("<div class='box0" . $counter . "'>%s", $str);
			}
			else{
				if ($myrow['type']==1){
					printf ("<div class='box0".$counter."'>");
					include ($str);
				}
			}
			if ($logged){
				printf ("<div class='alignright'><br />");
				printf ("<a href='?deletebox=" . $myrow['id'] . "'>delete</a> /");
				printf ("<a href='?a=boxadmin&amp;edit=" . $myrow['id'] . "'>edit</a> / " );
				printf ("<a href='?moveboxup=" . $myrow['id'] . "'>up</a> / ");
				printf ("<a href='?moveboxdown=" . $myrow['id'] . "'>down</a>");
				printf ("</div>");
			}
			printf ("</div><br />");
        }
 ?> 
</div>
</div>
</body>
</html>