<?php
$host = 'localhost';    // Host adress
$user = 'root';         //username for MySQL
$password = 'jelszó';  //password
$realmdb = 'wow';       //Realmd Database
$charactersdb = 'wow';  // Characters Database
$world_db = 'wow';      //Mangos Database


/*                  Text Settings               */
$realmname='Szaerver';      //Realm name if only 1 realm
$realmadress='localhost';   //realmlist ip address
$patch='3.3.2';             // Your Server supported patch
$serverport = "8121";       // Your server PORT



    $conn = mysql_connect($host,$user,$password) or die(mysql_error());
    mysql_select_db($charactersdb) 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';
            ";
    $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` = '10' AND `online` = '1';
            ";
    $horde = mysql_num_rows(mysql_query($qry));


    // Lets see if Realm 1 is alive
    echo "<p align='center'>";
        $fp = @fsockopen ($ip,$serverport,$errno,$errstr, 0.5);
        if($fp)
        {
            print "</font><p><img src='images/downarrow2.gif'>";
        }
        else
        {
            print "<img src='images/uparrow2.gif'>";
        }
        @fclose($fp);
    echo "</p>";
    mysql_close($conn);

    $conn = mysql_connect($host,$user,$password) or die(mysql_error());
    mysql_select_db($realmdb) 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></p>
        </p>
    ";
?>