<?php
/* Copyright (C) 2011  Jacopo Cascioli

This file is part of stupidCMS

This program is free software: you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
 along with this program.  If not, see <http://www.gnu.org/licenses/>. */

require "settings.php";
require "format.php";
require "layout.php";

$con = mysql_connect($server, $user, $password);
mysql_select_db($database, $con);
/* header and footer vars*/
$query = mysql_query("SELECT * FROM general LIMIT 1");
$general = mysql_fetch_array($query);
$title = $general[1];
$description = $general[2];
$sentence = $general[3];
$license = $general[4];
$version = $general[5];
$lastupdate = 'Last update: '.date("l j F Y", $general[6]);
$navbar = format_navbar(0, 0, 0);
/* statistics are shown in one page */
$page_slide = '';
/* main content: statistics table */
$query = mysql_query("SELECT * FROM statistics LIMIT 1");
$statistics = mysql_fetch_array($query);
$main_content = '
<table>
	<tr><th>Posts</th><td>'.$statistics[1].'</td></tr>
	<tr><th>Languages</th><td>'.$statistics[2].'</td></tr>
	<tr><th>Categories</th><td>'.$statistics[3].'</td></tr>
</table>';

html_main_page($title, $description, $sentence, $license, $version, $main_content,
			          $navbar, $page_slide, $lastupdate);
?>