<?php
$host = '127.0.0.1:3306';       // Hoszt:port
$user = 'root';             //MySQL felhasználó
$password = 'root';             //MySQL jelszó
$realmdb = 'auth';          //Auth DB
$charactersdb = 'characters';   // Characters DB
$world_db = 'world';            // World DB

/*                  Tovabbi beallitasok         */
$patch='patch: 4.0.6';  // Milyen patch-el mukodik a szerver
$serverport = "8085";       // Your server PORT
$realmlist = "set realmlist 127.0.0.1";



$conn = mysql_connect($host,$user,$password) or die(mysql_error());
    mysql_select_db($charactersdb2) or die(mysql_error());

    $numonline=@mysql_num_rows(mysql_query("SELECT NULL FROM `characters` WHERE `online`='1'"));

    $qry = "
            SELECT * FROM characters WHERE
             `race` = '1' AND `online` = '1' OR
             `race` = '3' AND `online` = '1' OR
             `race` = '4' AND `online` = '1' OR
             `race` = '7' AND `online` = '1' OR
             `race` = '11' AND `online` = '1' OR
             `race` = '22' AND `online` = '1';
            ";
    $ally = mysql_num_rows(mysql_query($qry));


    $qry = "
            SELECT * FROM characters WHERE
             `race` = '2' AND `online` = '1' OR
             `race` = '5' AND `online` = '1' OR
             `race` = '6' AND `online` = '1' OR
             `race` = '8' AND `online` = '1' OR
             `race` = '9' AND `online` = '1' OR
             `race` = '10' AND `online` = '1';
            ";
    $horde = mysql_num_rows(mysql_query($qry));


    // Lets see if Realm 1 is alive
    echo "<p align='center'>";
        $fp2 = @fsockopen ($ip,$serverport,$errno,$errstr, 0.5);
        if($fp)
        {
            print "<font color='red'>Offline</font>";
        }
        else
        {
            print "<font color='green'>Online</font>";
        }
        @fclose($fp);
    echo "</p>";
    mysql_close($conn);

    $conn2 = mysql_connect($host2,$user,$password) or die(mysql_error());
    mysql_select_db($realmdb2) or die(mysql_error());


    echo "
        <p align='center'><font color='gold'>
        <font color='green'>
            <b>
                <u>
                    Online Players: ".$numonline."
                </u>
            </b>
        </font>

        <br/><br/>

        <b>Alliance :</b>
        <font color='blue'>".$ally."</font>
        <b>Horde :</b>
        <font color='red'>".$horde."</font>
        <br><br>
        ".$patch."
        <br><br>
        ".$realmlist."
        </font></p>
    ";

?>