count(sex=0 or NULL) AS female_count,
count(*) AS total_count,
count(winner=1 OR NULL) AS winner_count,
- avg(score) AS average_score,
+ CAST(avg(score) AS INTEGER) AS average_score,
max(score) AS max_score
FROM scores
GROUP BY ${stat}_id
count(sex=1 OR NULL) AS male_count,
count(sex=0 OR NULL) AS female_count,
count(winner=1 OR NULL) AS winner_count,
- avg(score) AS average_score,
+ CAST(avg(score) AS INTEGER) AS average_score,
max(score) AS max_score
FROM score_realms
NATURAL INNER JOIN scores
foreach ($stat as $k => $s) {
$name_link = "<a href='score_ranking.php?{$id_name}={$s['id']}'>{$s['name']}</a></td>";
- $average_score = floor($s['average_score']);
fwrite($fp, <<<EOM
<tr>
<td>$name_link</td>
<td class="number">{$s['male_count']}</td>
<td class="number">{$s['female_count']}</td>
<td class="number">{$s['winner_count']}</td>
-<td class="number">$average_score</td>
+<td class="number">{$s['average_score']}</td>
<td class="number">{$s['max_score']}</td>
</tr>
foreach ($class_realm_stat as $realm) {
$name_link = "<a href='score_ranking.php?class_id={$class_id}&{$id_name}={$realm['realm_id']}'>{$realm['realm_name']}</a></td>";
- $average_score = floor($realm['average_score']);
fwrite($fp, <<<EOM
<tr>
<td>$name_link</td>
<td class="number">{$realm['male_count']}</td>
<td class="number">{$realm['female_count']}</td>
<td class="number">{$realm['winner_count']}</td>
-<td class="number">$average_score</td>
+<td class="number">{$realm['average_score']}</td>
<td class="number">{$realm['max_score']}</td>
</tr>