Changeset 287

Timestamp:

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

Author:

maron

Message:

oprava statistic.php

Location:

quests

Files:

• statistic.php (modified) (3 diffs)
• user.php (modified) (2 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>';

quests/user.php

@@ -34 +34 @@
      + IFNULL((SELECT sum(Vote) AS Vote FROM `page_text` WHERE User = ".$_GET['user']." AND Complete =1),0)
      + IFNULL((SELECT sum(Vote) AS Vote FROM `npc_text` WHERE User = ".$_GET['user']." AND Complete =1),0)
-     ) AS SumVote, (
+     ) / (
        (SELECT count(Vote) AS Vote FROM `quests` WHERE User = ".$_GET['user']." AND Complete =1)
      + (SELECT count(Vote) AS Vote FROM `page_text` WHERE User = ".$_GET['user']." AND Complete =1)
      + (SELECT count(Vote) AS Vote FROM `npc_text` WHERE User = ".$_GET['user']." AND Complete =1)
-     ) AS CountText
+     ) AS Vote
    FROM `user` WHERE ID = ".$_GET['user']));
    
-        if ($LineUser['CountText'] <> 0)
-          $Vote = $LineUser['SumVote']/$LineUser['CountText'];
-        else $Vote = 0;
-
     echo 'ID: <b>'.$_GET['user'].'</b><br />';
     echo 'Jméno: <b>'.$LineUser['user'].'</b><br />';
@@ -51 +47 @@
     echo 'Posledí IP: <b>'.$LineUser['LastIP'].'</b><br />';
     echo 'Poèet pøelo¾ených: <b>'.$LineUser['NumberTranslate'].'</b><br />';
-    echo 'Prùmìrná známka: <b>'.$Vote.'</b><br />';
+    echo 'Prùmìrná známka: <b>'.$LineUser['Vote'].'</b><br />';
     echo 'Email: <b>'.$LineUser['Email'].'</b><br />';
     echo '<br>