<?
        require("config.php");
        require("phemplate.class.php");
        require("globals.php");

        error_reporting(7);

        $dbconn = mysql_pconnect($config["dbserver"],$config["dbuser"],$config["dbpass"]) or die ("Could not connect to mySQL server");
        if (!mysql_select_db($config["dbname"])) {
                die("Could not select database (" . $config["dbname"] . ")!");
        }

        $getgroups = mysql_query("SELECT `groupid`,`groupname`,`ports` from groups");
        if (mysql_num_rows($getgroups) < 1) {
                die("No server groups in database");
        }

        $phemplate = new phemplate();

        while ($row = mysql_fetch_array($getgroups)) {
                $i=0;
                $servers=array();
                $id=$row["groupid"];
                $groups[$id]["name"] = $row["groupname"];
                $getservers = mysql_query("SELECT `friendlyname`,`ip`,`hostname` from servers where groupid='$id'");
                while ($server = mysql_fetch_array($getservers)) {
                        $servers[$i]["friendly"] = $server["friendlyname"];
                        $servers[$i]["ip"] = $server["ip"];
                        $servers[$i]["hostname"] = $server["hostname"];
                        $i++;
                }
                $groups[$id]["output"] = do_group($servers,$row["ports"]);
        }

        if ($config["announce"]) {
                $getannouncements = mysql_query("SELECT `announcement`,UNIX_TIMESTAMP(`atime`) as atime from announcements order by atime desc LIMIT
0,5");
                while ($row=mysql_fetch_array($getannouncements)) {
                        $announces[$aindex]["announcement"] = $row["announcement"];
                        $announces[$aindex++]["atime"] = date($config["dateformat"],$row["atime"]+($config["timezone"]*3600));
                }
                $phemplate->set_file('announce','templates/announcements.htm');
                $phemplate->set_loop('announcements',$announces);
                $announcements = $phemplate->process('proc_announce','announce',1);
        } else {
                $announcements = "";
        }

        $phemplate->set_file('main','templates/main.htm');
        $phemplate->set_var('announcements',$announcements);
        $phemplate->set_loop('groups',$groups);
        echo $phemplate->process('proc_main','main',1);
?>