All pastes #606524 Raw Edit

Stuff

public text v1 · immutable
·published 2007-07-06 22:09 UTC
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>