rendered paste body<?php
$connection = mysql_connect('HOST', 'USER', 'PASSWORD')
or die("No connection to the database!");
mysql_select_db('DATABASE', $connection); #Usually mangos_bc
$ally = "SELECT
count(*)
FROM
`character`
WHERE
`character`.`race` = '1' AND
`character`.`online` = '1' OR
`character`.`race` = '3' AND
`character`.`online` = '1' OR
`character`.`race` = '7' AND
`character`.`online` = '1' OR
`character`.`race` = '4' AND
`character`.`online` = '1' OR
`character`.`race` = '11' AND
`character`.`online` = '1'";
$horde = "SELECT
count(*)
FROM
`character`
WHERE
`character`.`race` = '2' AND
`character`.`online` = '1' OR
`character`.`race` = '5' AND
`character`.`online` = '1' OR
`character`.`race` = '8' AND
`character`.`online` = '1' OR
`character`.`race` = '6' AND
`character`.`online` = '1' OR
`character`.`race` = '10' AND
`character`.`online` = '1'";
$all = mysql_query($ally, $connection);
$hor = mysql_query($horde, $connection);
while($Allian = mysql_fetch_array($all))
{
$Hord = mysql_fetch_array($hor);
$Alliance = $Allian['count(*)'];
$Horde = $Hord['count(*)'];
}
mysql_close($connection);
?>
<B><font color="#0000FF">Alliance Players</font><br></b> </font> <font size="1" face="Verdana"><? echo $Alliance; ?></font><br>
<B><font color="#0000FF">Horde Players</font><br></b> </font><font size="1" face="Verdana"> <? echo $Horde; ?></font>