All pastes #606266 Raw Edit

Untitled

public text v1 · immutable
·published 2007-07-06 19:07 UTC
rendered paste body
$ally1 = mysql_query("SELECT `account` FROM `character` WHERE `race`='1' and `online`!='0'") or die(mysql_error());
$noally1 = mysql_num_rows($ally1);
$ally2 = mysql_query("SELECT `account` FROM `character` WHERE `race`='3' and `online`!='0'") or die(mysql_error());
$noally2 = mysql_num_rows($ally2);
$ally3 = mysql_query("SELECT `account` FROM `character` WHERE `race`='7' and `online`!='0'") or die(mysql_error());
$noally3 = mysql_num_rows($ally3);
$ally4 = mysql_query("SELECT `account` FROM `character` WHERE `race`='4' and `online`!='0'") or die(mysql_error());
$noally4 = mysql_num_rows($ally4);
$ally5 = mysql_query("SELECT `account` FROM `character` WHERE `race`='11' and `online`!='0'") or die(mysql_error());
$noally5 = mysql_num_rows($ally5);

$noally = ($noally1+$noally2+$noally3+$noally4+$noally5);
$horde1 = mysql_query("SELECT `account` FROM `character` WHERE `race`='2' and `online`!='0'") or die(mysql_error());
$nohorde1 = mysql_num_rows($horde1);
$horde2 = mysql_query("SELECT `account` FROM `character` WHERE `race`='5' and `online`!='0'") or die(mysql_error());
$nohorde2 = mysql_num_rows($horde2);
$horde3 = mysql_query("SELECT `account` FROM `character` WHERE `race`='8' and `online`!='0'") or die(mysql_error());
$nohorde3 = mysql_num_rows($horde3);
$horde4 = mysql_query("SELECT `account` FROM `character` WHERE `race`='6' and `online`!='0'") or die(mysql_error());
$nohorde4 = mysql_num_rows($horde4);
$horde5 = mysql_query("SELECT `account` FROM `character` WHERE `race`='10' and `online`!='0'") or die(mysql_error());
$nohorde5 = mysql_num_rows($horde5);