Changeset 233 for quests/statistic.php

Timestamp:

Jan 15, 2008, 5:25:15 PM (17 years ago)

Author:

maron

Message:

Statistika, oprava global.php

File:

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

quests/statistic.php

@@ -7 +7 @@
 <b>Statistika pøelo¾ených questù:</b><br>
  <img alt="quests" src="quests_statistic.php" title="statistika pøekladu úkolù">
-
+<br />
+<br />
+<b>Seznam u¾ivatelù: </b>
+<table border="1" cellpadding="1" cellspacing="0">
+<tr><th>Jméno</th><th>Poèet pøelo¾ených</th><th>Poslední pøipojení</th></tr>
 <?php  
+  $ID = $Database->SQLCommand("SELECT user,Email,LastLogin,(SELECT count(*) FROM `quests` WHERE User = user.id AND User <> 0) as NumberTranslate FROM `user` ORDER BY NumberTranslate DESC");
+      while ($Line = mysql_fetch_array($ID))
+        echo '<tr><td>'.$Line['user'].'</td><td>'.$Line['NumberTranslate'].'</td><td>'.$Line['LastLogin'].'</td></tr>';
+          
+          
+  echo '</table>';
           
   ShowFooter();