Changeset 286 for quests/statistic.php

Timestamp:

Jan 30, 2008, 6:43:37 PM (17 years ago)

Author:

maron

Message:

Oprava statistiky, přidání uživatelského infa s napsáním emailu

File:

• quests/statistic.php (modified) (1 diff)

quests/statistic.php

@@ -36 +36 @@
 
   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øel. Q.</a></th>
-  <th><a href="statistic.php?order=NumberTranslateNPC&amp;desc='.$desc.'" Title="Poèet pøeloœených NPC_textù">Pøel. N.</a></th>
-  <th><a href="statistic.php?order=vote&amp;desc='.$desc.'" Title="Prùmìrná známka questù">Z. Q</a></th>
-  <th><a href="statistic.php?order=voteNPC&amp;desc='.$desc.'" Title="Prùmìrná známka NPC_text">Z. N.</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=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>';
 
-  $ID = $Database->SQLCommand("SELECT user,Email,LastLogin,GM,
-  (SELECT count(*) FROM `quests` WHERE User = user.id AND User <> 0) as NumberTranslate,
-  (SELECT count(*) FROM `npc_text` WHERE User = user.id AND User <> 0) as NumberTranslateNPC,
-  (SELECT avg(vote) FROM `quests` WHERE User = user.id AND Complete = 1) as vote,
-  (SELECT avg(Vote) FROM `npc_text` WHERE User = user.id AND Complete = 1) as voteNPC
+/*
+SELECT user, LastLogin, GM, (
+     (SELECT count(*) FROM `quests` WHERE User = user.ID AND User <> 0 AND Complete = 1) + 
+     (SELECT count(*) FROM `npc_text` WHERE User = user.ID AND User <> 0 AND Complete = 1) +
+     (SELECT count(*) FROM `page_text` WHERE User = user.ID AND User <> 0 AND Complete = 1)
+   ) as NumberTranslate, (
+     SELECT IFNULL((SELECT AVG(Vote) AS Vote FROM `quests` WHERE User = user.ID AND Complete =1),0)
+     + IFNULL((SELECT AVG(Vote) AS Vote FROM `page_text` WHERE User = user.ID AND Complete =1),0)
+     + IFNULL((SELECT AVG(Vote) AS Vote FROM `npc_text` WHERE User = user.ID AND Complete =1),0)
+     ) /3 AS Vote
+   FROM `user`
+   
+   */
+
+  $ID = $Database->SQLCommand("
+  SELECT ID,user, LastLogin, GM, (
+     (SELECT count(*) FROM `quests` WHERE User = user.ID AND User <> 0 AND Complete = 1) + 
+     (SELECT count(*) FROM `npc_text` WHERE User = user.ID AND User <> 0 AND Complete = 1) +
+     (SELECT count(*) FROM `page_text` WHERE User = user.ID AND User <> 0 AND Complete = 1)
+   ) as NumberTranslate, (
+       IFNULL((SELECT sum(Vote) AS Vote FROM `quests` WHERE User = user.ID AND Complete =1),0)
+     + 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
    FROM `user` ORDER BY $order $desc");
-      while ($Line = mysql_fetch_array($ID))
-        echo '<tr><td>'.$Line['user'].'</td>
+   
+      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>';
+        else 
+          $Name = $Line['user'];
+        
+        echo '<tr><td>'.$Name.'</td>
         <td>'.$Line['NumberTranslate'].'</td>
-        <td>'.$Line['NumberTranslateNPC'].'</td>
-        <td>'.substr($Line['vote'], 0, 4).'</td>
-        <td>'.substr($Line['voteNPC'], 0, 4).'</td>
+        <td>'.substr($Vote, 0, 4).'</td>
         <td>'.$Moderators[$Line['GM']].'</td>
         <td>'.$Line['LastLogin'].'</td></tr>';
           
+      }
           
   echo '</table>';