[modify]小数点以下切り捨てをSQLで行う

diff --git a/score/db_common.inc b/score/db_common.inc
index d6144e9..f6ac275 100644 (file)
--- a/score/db_common.inc
+++ b/score/db_common.inc
@@ -317,7 +317,7 @@ SELECT
   count(sex=0 or NULL) AS female_count,
   count(*) AS total_count,
   count(winner=1 OR NULL) AS winner_count,
   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
   max(score) AS max_score
 FROM scores
 GROUP BY ${stat}_id


@@ -347,7 +347,7 @@ SELECT
   count(sex=1 OR NULL) AS male_count,
   count(sex=0 OR NULL) AS female_count,
   count(winner=1 OR NULL) AS winner_count,
   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
   max(score) AS max_score
 FROM score_realms
 NATURAL INNER JOIN scores

diff --git a/score/popularity_ranking.php b/score/popularity_ranking.php
index ce2f043..ac62e78 100644 (file)
--- a/score/popularity_ranking.php
+++ b/score/popularity_ranking.php
@@ -31,7 +31,6 @@ EOM
 
     foreach ($stat as $k => $s) {
         $name_link = "<a href='score_ranking.php?{$id_name}={$s['id']}'>{$s['name']}</a></td>";
 
     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>
         fwrite($fp, <<<EOM
 <tr>
 <td>$name_link</td>


@@ -39,7 +38,7 @@ EOM
 <td class="number">{$s['male_count']}</td>
 <td class="number">{$s['female_count']}</td>
 <td class="number">{$s['winner_count']}</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>
 
 <td class="number">{$s['max_score']}</td>
 </tr>
 


@@ -87,7 +86,6 @@ EOM
 
         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>";
 
         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>
             fwrite($fp, <<<EOM
 <tr>
 <td>$name_link</td>


@@ -95,7 +93,7 @@ EOM
 <td class="number">{$realm['male_count']}</td>
 <td class="number">{$realm['female_count']}</td>
 <td class="number">{$realm['winner_count']}</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>
 
 <td class="number">{$realm['max_score']}</td>
 </tr>