Changeset 287 for quests/user.php

Timestamp:

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

Author:

maron

Message:

oprava statistic.php

File:

• quests/user.php (modified) (2 diffs)

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>