<?PHP

require_once ('config.php');

mysql_connect ("$host","$user","$pass");
mysql_select_db ("$mangoscharacters");

$result = mysql_query ("SELECT name, race, class, level, gender FROM characters WHERE online = 1");
$num_online = mysql_num_rows($result);

$class = array(1=>"<img src='img/class/1.gif'>",2=>"<img src='img/class/2.gif'>",3=>"<img src='img/class/3.gif'>",4=>"<img src='img/class/4.gif'>",5=>"<img src='img/class/5.gif'>",6=>"<img src='img/class/6.gif'>",

7=>"<img src='img/class/7.gif'>",8=>"<img src='img/class/8.gif'>",9=>"<img src='img/class/9.gif'>",11=>"<img src='img/class/11.gif'>");
$race = array(1=>"<img src='img/race/1-0.gif'>",2=>"<img src='img/race/2-0.gif'>",3=>"<img src='img/race/3-0.gif'>",4=>"<img src='img/race/4-0.gif'>",5=>"<img src='img/race/5-0.gif'>",6=>"<img src='img/race/6-0.gif'>",7=>"<img src='img/race/7-0.gif'>",8=>"<img src='img/race/8-0.gif'>",10=>"<img src='img/race/10-0.gif'>",11=>"<img src='img/race/11-0.gif'>");
$gender = array(0=>"Male",1=>"Female");

if($num_online < 1) {
  echo "<tr><td colspan='4' align='center'>No Players Online!</td></tr>";
}

for($i=0; $i<$num_online; $i++) {
  $row = mysql_fetch_array($result);
  $t_name = $row['name'];
  $t_race = $row['race'];
  $t_class = $row['class'];
  $t_lvl = $row['level'];
  $t_gender = $row['gender'];
  echo "<p>$t_name";
  echo "  $race[$t_race]";
  echo "  $class[$t_class]";
  echo "  $t_lvl";
  echo "  $gender[$t_gender]</p>";
}

?>