<?php
openside("Statistici srv. nr. 1");

$db2_host = "localhost";
$db2_user = "";
$db2_pass = "";
$db2_name = "player";

$db2_link = mysql_connect($db2_host, $db2_user, $db2_pass) OR
die("Nu sa putut conecta la baza de date.<br /> Mesaj de eroare: ".mysql_error());

mysql_select_db($db2_name, $db2_link) OR
die("Baza de date nu a putut fi folosita.");

echo "<table width='100%' cellpadding='0' cellspacing='1' align='center'>\n";
echo "<tr>";

$query = 'SELECT COUNT(id) FROM `player` WHERE gmrec!="ban"';
$result = mysql_query($query) or die('Sorry, we could not count the number of results: ' . mysql_error());
$numberofresults = mysql_result($result, 0);

echo "<td width='120' class='small'>Jucatori inregistrati:</td>\n";
echo "<td align='right' class='side-small'>".$numberofresults."</td>";

echo "</tr><tr>";

$query = 'SELECT COUNT(pid1) FROM marriage';
$result = mysql_query($query) or die('Sorry, we could not count the number of results: ' . mysql_error());
$numberofresults = mysql_result($result, 0);

echo "<td width='120' class='small'>Jucatori casatoriti:</td>\n";
echo "<td align='right' class='side-small'>".$numberofresults."</td>";

echo "</tr><tr>";

$query = 'SELECT COUNT(id) FROM `player` WHERE gmrec="ban"';
$result = mysql_query($query) or die('Sorry, we could not count the number of results: ' . mysql_error());
$numberofresults = mysql_result($result, 0);

echo "<td width='120' class='small'>Jucatori suspendati:</td>\n";
echo "<td align='right' class='side-small'>".$numberofresults."</td>";

echo "</tr><tr>";

$query = 'SELECT COUNT(id) FROM guild';
$result = mysql_query($query) or die('Sorry, we could not count the number of results: ' . mysql_error());
$numberofresults = mysql_result($result, 0);

echo "<td width='120' class='small'>Bresle existente:</td>\n";
echo "<td align='right' class='side-small'>".$numberofresults."</td>";

// baza de date de la fusion
$link = dbconnect($db_host, $db_user, $db_pass, $db_name);

echo "</td></tr></table>\n";

closeside();
?>