<?php require("connect.php"); ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
	<head>
		<?php require("header.php"); ?>
	</head>
	<body>
		<div id="container">
			<div id="banner">
				<?php
				if(!isset($_GET["p"]))
					$page_id = 1;
				else
					$page_id = mysql_real_escape_string($_GET["p"]);
				$sql_query = "SELECT title FROM pages WHERE id = " . $page_id;
				$sql_result = mysql_query($sql_query, $sql_con);
				$row = mysql_fetch_row($sql_result);
				echo $row[0];
				?>
			</div>
			<div id="menu">
				<?php
				$sql_query = "SELECT * FROM pages";
				$sql_result = mysql_query($sql_query, $sql_con);
				while($row = mysql_fetch_array($sql_result))
				{
					echo "<a class=\"menulink\" href=\"index.php?p=" . $row["id"] . "\">" . $row["menutitle"] . "</a> ";
				}
				?>
			</div>
			<div id="body">
				<?php
				$sql_query = "SELECT * FROM texts WHERE pageid = $page_id AND type = 'page' ORDER BY date DESC";
				$sql_result = mysql_query($sql_query, $sql_con);
				if($sql_result)
				{
					while($row = mysql_fetch_array($sql_result))
					{
						echo "<div class=\"text\">";
						echo "<h1>" . $row["title"] . "</h1>";
						echo $row["text"] . "<br />";
						echo "</div>";
					}
				}
				$sql_query = "SELECT * FROM texts WHERE pageid = $page_id AND type = 'entry' ORDER BY date DESC";
				$sql_result = mysql_query($sql_query, $sql_con);
				if($sql_result)
				{
					while($row = mysql_fetch_array($sql_result))
					{
						echo "<div class=\"entry\">";
						echo "<div class=\"entryheader\">";
						echo "<div class=\"entrydate\">" . $row["date"] . "</div>";
						echo "<div class=\"entrytitle\">" . $row["title"] . "</div>";
						echo "</div>";
						echo "<div class=\"entrybody\">" . $row["text"] . "</div>";
						echo "</div>";
					}
				}
				?>
			</div>
			<div id="footer"><?php include("footer.php"); ?></div>
		</div>
		<script type="text/javascript">
		var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
		document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
		</script>
		<script type="text/javascript">
		var pageTracker = _gat._getTracker("UA-6563506-1");
		pageTracker._trackPageview();
		</script>
	</body>
</html>
