Changeset 124 for trunk/userlist.php

Timestamp:

Feb 22, 2009, 9:41:58 PM (16 years ago)

Author:

maron

Message:

Překladatelské týmy (změna struktury)

File:

• trunk/userlist.php (modified) (4 diffs)

trunk/userlist.php

@@ -5 +5 @@
 ShowPage();
 
-include('img_level.php');
+//include('img_level.php');
 
 echo('<strong>Seznam uživatelů:</strong><br />');
@@ -14 +14 @@
 if(array_key_exists('Desc', $_GET)) $_SESSION['Desc'] = $_GET['Desc']; 
 else if(!array_key_exists('Desc', $_SESSION)) $_SESSION['Desc'] = '';
-ListPaging('?Page=', 'user', '', $Config['Web']['ItemsPerPage'], $_SESSION['Page']);
 
+if(array_key_exists('Where', $_GET)) {
+         $_SESSION['Where'] = ' WHERE '.$_GET['Where']; 
+     if($_GET['Where'] == '') $_SESSION['Where'] = '';
+ }
+else if(!array_key_exists('Where', $_SESSION)) $_SESSION['Where'] = '';
+
+if ($_SESSION['Where'] <> '') echo (' <a href="?Where">Zrušit filtr uživatelů</a><br />');
+
+ListPaging('?Page=', 'user', $_SESSION['Where'], $Config['Web']['ItemsPerPage'], $_SESSION['Page']);
 echo('<table class="BaseTable">');
 
 $desc = $_SESSION['Desc']; 
 if($desc == '') $desc = 'DESC'; else $desc = '';
+
+//ochrana proti špatným údajům v session z jiných tabulek
+if (($_SESSION['Order'] <> 'user') and ($_SESSION['Order'] <> 'XP') and ($_SESSION['Order'] <> 'NumberTranslate') and ($_SESSION['Order'] <> 'GM') and ($_SESSION['Order'] <> 'LastLogin'))
+$_SESSION['Order'] = 'NumberTranslate';
 
 echo('<tr><th><a href="?Order=user&amp;Desc='.$desc.'">Jméno</a></th>
@@ -36 +48 @@
   }
 
-$Query = 'SELECT ID, user.user, LastLogin, GM, ('.substr($Columns, 0, -3).') as NumberTranslate FROM `user`'.$Joins.' ORDER BY '.$_SESSION['Order'].' '.$_SESSION['Desc'].' LIMIT '.($_SESSION['Page'] - 1) * $Config['Web']['ItemsPerPage'].','.$Config['Web']['ItemsPerPage'];
+$Query = 'SELECT ID, user.user, LastLogin, GM, ('.substr($Columns, 0, -3).') as NumberTranslate FROM `user`'.$Joins.' '.$_SESSION['Where'].' ORDER BY '.$_SESSION['Order'].' '.$_SESSION['Desc'].' LIMIT '.($_SESSION['Page'] - 1) * $Config['Web']['ItemsPerPage'].','.$Config['Web']['ItemsPerPage'];
 
 $ID = $Database->SQLCommand($Query);
@@ -52 +64 @@
 }
 echo('</table>');
-ListPaging('?Page=', 'user', '', $Config['Web']['ItemsPerPage'], $_SESSION['Page']);
+ListPaging('?Page=', 'user', $_SESSION['Where'], $Config['Web']['ItemsPerPage'], $_SESSION['Page']);
           
 ShowFooter();