Changeset 284 for trunk/userlist.php
- Timestamp:
- Dec 11, 2009, 11:41:03 AM (15 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/userlist.php
r247 r284 8 8 9 9 echo('<h3>Seznam uživatelů</h3>'); 10 if(array_key_exists('Page', $_GET)) $_SESSION['Page'] = $_GET['Page'];11 else if(!array_key_exists('Page', $_SESSION)) $_SESSION['Page'] = 1;12 10 if(array_key_exists('Order', $_GET)) $_SESSION['Order'] = $_GET['Order']; 13 11 else if(!array_key_exists('Order', $_SESSION)) $_SESSION['Order'] = 'NumberTranslate'; … … 32 30 //if($_SESSION['Where'] <> '') echo(' <a href="?action=nofilter">Zrušit filtr uživatelů</a><br />'); 33 31 34 ListPaging('?Page=', 'user', $_SESSION['Where'], $Config['Web']['ItemsPerPage'], $_SESSION['Page']); 32 $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `user`'.$_SESSION['Where']); 33 $DbRow = mysql_fetch_row($DbResult); 34 $PageList = GetPageList($DbRow[0]); 35 36 echo($PageList['Output']); 35 37 echo('<table class="BaseTable">'); 36 38 … … 57 59 } 58 60 59 $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'];61 $Query = 'SELECT ID, user.user, LastLogin, GM, ('.substr($Columns, 0, -3).') as NumberTranslate FROM `user`'.$Joins.' '.$_SESSION['Where'].' ORDER BY '.$_SESSION['Order'].' '.$_SESSION['Desc'].' '.$PageList['SQLLimit']; 60 62 61 63 $ID = $Database->SQLCommand($Query); … … 73 75 } 74 76 echo('</table>'); 75 ListPaging('?Page=', 'user', $_SESSION['Where'], $Config['Web']['ItemsPerPage'], $_SESSION['Page']);77 echo($PageList['Output']); 76 78 77 79 ShowFooter();
Note:
See TracChangeset
for help on using the changeset viewer.