Changeset 284 for trunk/team.php
- Timestamp:
- Dec 11, 2009, 11:41:03 AM (15 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/team.php
r252 r284 11 11 echo('<h3>Seznam překladatelských týmů</h3>'); 12 12 13 if(array_key_exists('Page', $_GET)) $_SESSION['Page'] = $_GET['Page'];14 else if(!array_key_exists('Page', $_SESSION)) $_SESSION['Page'] = 1;15 13 if(array_key_exists('Order', $_GET)) $_SESSION['Order'] = $_GET['Order']; 16 14 else if(!array_key_exists('Order', $_SESSION)) $_SESSION['Order'] = 'numberuser'; 17 15 if(array_key_exists('Desc', $_GET)) $_SESSION['Desc'] = $_GET['Desc']; 18 16 else if(!array_key_exists('Desc', $_SESSION)) $_SESSION['Desc'] = ''; 19 ListPaging('?Page=', 'team', '', $Config['Web']['ItemsPerPage'], $_SESSION['Page']); 17 18 $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `team`'); 19 $DbRow = mysql_fetch_row($DbResult); 20 $PageList = GetPageList($DbRow[0]); 21 22 echo($PageList['Output']); 20 23 echo('<table class="BaseTable">'); 21 24 … … 52 55 echo('</tr>'); 53 56 54 $ID = $Database->SQLCommand('SELECT *, (SELECT COUNT(*) FROM user WHERE user.team = team.ID) AS numberuser FROM team '.$_SESSION['search'].' ORDER BY '.$_SESSION['Order'].' '.$_SESSION['Desc'].' LIMIT '.($_SESSION['Page'] - 1) * $Config['Web']['ItemsPerPage'].','.$Config['Web']['ItemsPerPage']);57 $ID = $Database->SQLCommand('SELECT *, (SELECT COUNT(*) FROM user WHERE user.team = team.ID) AS numberuser FROM team '.$_SESSION['search'].' ORDER BY '.$_SESSION['Order'].' '.$_SESSION['Desc'].' '.$PageList['SQLLimit']); 55 58 while($Line = mysql_fetch_assoc($ID)) 56 59 { … … 62 65 } 63 66 echo('</table>'); 64 65 ListPaging('?Page=', 'team', '', $Config['Web']['ItemsPerPage'], $_SESSION['Page']);67 echo($PageList['Output']); 68 66 69 if(Licence(LICENCE_USER)) echo('<br /><div style="text-align: center;"><a href="?action=create">Vytvořit překladatelský tým</a></div>'); 67 70 }
Note:
See TracChangeset
for help on using the changeset viewer.