<?php

$dbuser="root";
$dbpass="password";
$dbserver="localhost";
$dbname="queue";

error_reporting(E_ALL); // vypisovanie chyb

$spojenie = mysql_connect($dbserver,$dbuser,$dbpass);

if (!$spojenie)
    die('Could not connect to database server!');

mysql_select_db($dbname,$spojenie);
mysql_query('SET NAMES UTF8');
mysql_query('SET COLLATION_CONNECTION=UTF8_GENERAL_CI');

$dotaz = "SELECT COUNT(*) FROM loginqueueplayertable WHERE connected = 1";
$pocet_na_servery = mysql_result(mysql_query($dotaz), 0);

echo "<span onclick=\"hide()\" style=\"cursor:pointer\">Počet hráčov na servery: ".$pocet_na_servery."</span><br />";

$dotaz = "SELECT * FROM loginqueueplayertable WHERE connected = 1 ORDER BY becameEligible";
$vysledok = mysql_query($dotaz, $spojenie);

echo '<script>
    function hide() {
        var obj = document.getElementById("list");
        if (obj.style.visibility == \'hidden\') {
            obj.style.visibility=\'visible\';
            obj.style.display=\'block\';
        }  else  {
            obj.style.visibility=\'hidden\';
            obj.style.display=\'none\';
        }
    }
</script>

<span id="list" style="visibility: hidden; display: none;">';
while ($zaznam = mysql_fetch_array($vysledok)) {
    echo $zaznam['playername']."<br />";
}
echo '</span>';

/*********************** ELIGIBLE ***********************/

$dotaz = "SELECT COUNT(*) FROM loginqueueplayertable WHERE eligible = 1";
$pocet_mozu_pripojit = mysql_result(mysql_query($dotaz), 0);

echo "<br />".$pocet_mozu_pripojit." hraci sa mozu pripojit: <br />";

$dotaz = "SELECT * FROM loginqueueplayertable WHERE eligible = 1 ORDER BY becameEligible";
$vysledok = mysql_query($dotaz, $spojenie);

while ($zaznam = mysql_fetch_array($vysledok)) {
    echo $zaznam['playername']."<br />";
}

/*********************** QUEUE ***********************/

$dotaz = "SELECT COUNT(*) FROM loginqueueplayertable WHERE queued = 1";
$pocet_v_rade = mysql_result(mysql_query($dotaz), 0);

$dotaz = "SELECT * FROM loginqueueplayertable WHERE queued = 1 ORDER BY polledQueue";
$vysledok = mysql_query($dotaz, $spojenie);

echo "<br />Počet hráčov čakajúcich v rade: ".$pocet_v_rade."<br />";

while ($zaznam = mysql_fetch_array($vysledok)) {
    $cas_v_rade = round($zaznam['polledQueue']/1000);
    echo $zaznam['playername']." - ".round((time() - $cas_v_rade)/60)." minút<br />";
}