Changeset 245 for quests/statistic.php

Timestamp:

Jan 18, 2008, 4:07:44 PM (17 years ago)

Author:

maron

Message:

struktura, statistika, oprava zobrazení prioritních questů

File:

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

quests/statistic.php

@@ -18 +18 @@
 </b><br /><br />
 <b>Seznam u¾ivatelù: </b>
-<table border="1" cellpadding="1" cellspacing="0">
+<table border="1" cellpadding="2" cellspacing="0">
 <?php  
 
@@ -32 +32 @@
 
   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.'">Poèet pøelo¾ených</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ù">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,(SELECT count(*) FROM `quests` WHERE User = user.id AND User <> 0) as NumberTranslate FROM `user` ORDER BY $order $desc");
+  $ID = $Database->SQLCommand("SELECT user,Email,LastLogin,GM,
+  (SELECT count(*) FROM `quests` WHERE User = user.id AND User <> 0) as NumberTranslate,
+  (SELECT avg(vote) FROM `quests` WHERE User = user.id AND Complete = 1) as vote
+   FROM `user` ORDER BY $order $desc");
       while ($Line = mysql_fetch_array($ID))
-        echo '<tr><td>'.$Line['user'].'</td><td>'.$Line['NumberTranslate'].'</td><td>'.$Line['LastLogin'].'</td></tr>';
+        echo '<tr><td>'.$Line['user'].'</td>
+        <td>'.$Line['NumberTranslate'].'</td>
+        <td>'.substr($Line['vote'], 0, 4).'</td>
+        <td>'.$Moderators[$Line['GM']].'</td>
+        <td>'.$Line['LastLogin'].'</td></tr>';