Changeset 287 for quests/statistic.php

Timestamp:

Jan 30, 2008, 6:59:15 PM (17 years ago)

Author:

maron

Message:

oprava statistic.php

File:

• quests/statistic.php (modified) (3 diffs)

quests/statistic.php

@@ -37 +37 @@
   echo '<tr><th><a href="statistic.php?order=user&amp;desc='.$desc.'">Jméno</a></th>
   <th><a href="statistic.php?order=NumberTranslate&amp;desc='.$desc.'" Title="Poèet pøelo¾ených questù">Pøelo¾ených</a></th>
-  <th><a href="statistic.php?order=vote&amp;desc='.$desc.'" Title="Prùmìrná známka questù">Prùmìrná známka</a></th>
+  <th><a href="statistic.php?order=Vote&amp;desc='.$desc.'" Title="Prùmìrná známka questù">Prùmìrná známka</a></th>
   <th><a href="statistic.php?order=GM&amp;desc='.$desc.'">Oprávnìní</a></th>
   <th><a href="statistic.php?order=LastLogin&amp;desc='.$desc.'">Poslední pøipojení</a></th></tr>';
@@ -64 +64 @@
      + IFNULL((SELECT sum(Vote) AS Vote FROM `page_text` WHERE User = user.ID AND Complete =1),0)
      + IFNULL((SELECT sum(Vote) AS Vote FROM `npc_text` WHERE User = user.ID AND Complete =1),0)
-     ) AS SumVote, (
+     ) / (
        (SELECT count(Vote) AS Vote FROM `quests` WHERE User = user.ID AND Complete =1)
      + (SELECT count(Vote) AS Vote FROM `page_text` WHERE User = user.ID AND Complete =1)
      + (SELECT count(Vote) AS Vote FROM `npc_text` WHERE User = user.ID AND Complete =1)
-     ) AS CountText
+     ) AS Vote
    FROM `user` ORDER BY $order $desc");
    
       while ($Line = mysql_fetch_array($ID)) {
-      
-        if ($Line['CountText'] <> 0)
-          $Vote = $Line['SumVote']/$Line['CountText'];
-        else $Vote = 0;
-        
+              
         if (Licence(1)) 
           $Name = '<a href="user.php?user='.$Line['ID'].'">'.$Line['user'].'</a>';
@@ -84 +80 @@
         echo '<tr><td>'.$Name.'</td>
         <td>'.$Line['NumberTranslate'].'</td>
-        <td>'.substr($Vote, 0, 4).'</td>
+        <td>'.substr($Line['Vote'], 0, 4).'</td>
         <td>'.$Moderators[$Line['GM']].'</td>
         <td>'.$Line['LastLogin'].'</td></tr>';