Changeset 234 for quests/statistic.php

Timestamp:

Jan 15, 2008, 6:16:14 PM (17 years ago)

Author:

maron

Message:

Menší grafické úpravy, možnost seřazení statistiky

File:

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

quests/statistic.php

@@ -11 +11 @@
 <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");
+
+  if(array_key_exists('order', $_GET)) {
+    $order = $_GET['order'];
+    $desc = $_GET['desc'];
+  } else {
+    $order = 'NumberTranslate';
+    $desc = 'DESC';
+  }
+
+  if ($desc == '') $desc = 'desc'; else $desc = '';
+
+  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=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");
       while ($Line = mysql_fetch_array($ID))
         echo '<tr><td>'.$Line['user'].'</td><td>'.$Line['NumberTranslate'].'</td><td>'.$Line['LastLogin'].'</td></tr>';