<?php
        $host = "localhost";
        $user = "root";
        $pass = "root_pass";
        $characters = "karakter_db_neve";

$con = mysql_connect($host,$user,$pass) or die (mysql_error());


$onlineplayers = mysql_num_rows(mysql_query("SELECT * FROM ".$characters.".`characters` WHERE `online` = '1'"));
	$online_alliance = mysql_num_rows(mysql_query("SELECT * FROM ".$characters.".`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'"));
	$online_horde = mysql_num_rows(mysql_query("SELECT * FROM ".$characters.".`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'"));
?>
<center><u>Online Játékosok: </u><?php echo $onlineplayers; ?><br/>
Alliance: <font color=#0000FF><?php echo $online_alliance; ?></font>&nbsp;Horde: <font color=#FF0000><?php echo $online_horde; ?></font></center>