function getPlayerFairnessArray($name)
{
require 'variables.php';
$sql = "SELECT avg(fairness) as avg, count(*) as votes FROM {$gamestable} WHERE deleted = 'no' AND fairness != '' AND loser = '{$name}'";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$avg = $row['avg'];
$votes = $row['votes'];
$votesDisplay = "average of " . $votes . " votes";
if ($avg > 0 && $votes > 2) {
return array(formatFairness($avg), $votesDisplay);
} else {
return array("unknown", "not enough votes yet");
}
}
}
}
else if ($fairness) {
while ($row = mysql_fetch_array($result)) {
$loser = $row["loser"];
$votes = $row["votes"];
if ($votes > 2) {
$player_sql = "SELECT nationality from $playerstable where name = '$loser'";
$player_result = mysql_query($player_sql);
$player_row = mysql_fetch_array($player_result);
$nationality = $player_row['nationality'];
$nameClass = colorNameClass($loser, 'yes');
$namedisplay = "<img src='$directory/flags/".$nationality.".bmp' align='absmiddle' border='1'>" .
" <span $nameClass><a href='$directory/profile.php?name=".$loser."'>".$loser."</a></span>";
$avg = formatFairness($row["avg"]);
if ($old_avg != $avg) {
$curdisplay = $cur;
}
else {
$curdisplay = ".";
}
$old_avg = $avg;
$avgDisplay = $avg." <span class='grey-small'>(".$votes.")</span>";
$highlight = strcmp($cookie_name, $loser) == 0;
printRow($curdisplay, $namedisplay, $avgDisplay, $highlight);
$cur++;
}
}
}
