define("IN_NWN2MONITOR", TRUE);
require("functions_nwn2monitor.php");
require("template.php");
//quelques tests comme ça, pour le plaisir.
if (isset($_GET["salle"])) $salle = $_GET["salle"];
//On charge la connexion SQL
SQLConnect();
//On précharge le template
$template = new Template('./templates/');
$template->set_filenames(array('body' => './templates/viewsection.tpl'));
//prises des infos basiques utilisées pour l'entete et le pied de page.
$query = "SELECT groupname FROM chatroom WHERE groupid='".$salle."'";
$result = mysql_query($query);
if ($row = mysql_fetch_array($result))
{
$room_name = $row[0];
}
else Redirect("stats.html");
$query = "SELECT SUM(numplayers),COUNT(groupid) FROM serverlists WHERE groupid='".$salle."' AND UNIX_TIMESTAMP(refreshdate)>=(UNIX_TIMESTAMP(NOW())-530)";
$result = mysql_query($query);
if ($row = mysql_fetch_array($result))
{
if ($row[0] == NULL) $row[0] = 0;
$total_serveurs = $row[1];
$total_joueurs = $row[0];
$room_url = "stats-".base64_encode("page#section|salle#".$salle).".html";
$template->assign_vars(array('TOTAL_SERVEURS' => $total_serveurs,
'TOTAL_JOUEURS' => $total_joueurs,
'SALLE_NAME' => $room_name,
'U_SALLE_NAME' => $room_url));
}
mysql_free_result($result);
//Collecte des infos serveurs par serveurs
$query = "SELECT hostname, modulename, numplayers, maxplayers, haspassword, ip, port FROM serverlists WHERE groupid='".$salle."' AND UNIX_TIMESTAMP(refreshdate) >= (UNIX_TIMESTAMP(NOW())-530) ORDER BY numplayers DESC ";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result))
{
$ip = $row[5];
$port = $row[6];
$hostname = ($row[0]=="")?"Serveur sans nom":$row[0];
$module_name = $row[1];
$num_connecte = $row[2];
$num_maxconnecte = $row[3];
$password = $row[4];
$page_url = "stats-".base64_encode("page#module|ip#".$ip."|port#".$port).".html";
$template->assign_block_vars('serveurrow', array('U_VIEW_SERVEUR' => $page_url,
'SERVEUR_TITLE' => $hostname,
'MODULE_TITLE' => $module_name,
'CONNECTE' => $num_connecte."/".$num_maxconnecte
));
}
mysql_free_result($result);
$template->pparse('body');
?>