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++; } } }