Seznam uživatelů'); if(array_key_exists('Page', $_GET)) $_SESSION['Page'] = $_GET['Page']; else if(!array_key_exists('Page', $_SESSION)) $_SESSION['Page'] = 1; if(array_key_exists('Order', $_GET)) $_SESSION['Order'] = $_GET['Order']; else if(!array_key_exists('Order', $_SESSION)) $_SESSION['Order'] = 'NumberTranslate'; if(array_key_exists('Desc', $_GET)) $_SESSION['Desc'] = $_GET['Desc']; else if(!array_key_exists('Desc', $_SESSION)) $_SESSION['Desc'] = 'DESC'; if(array_key_exists('search', $_GET)) { $_SESSION['Where'] = ' WHERE `user`.`user` LIKE "%'.$_GET['search'].'%"'; } 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(' Zrušit filtr uživatelů
'); ListPaging('?Page=', 'user', $_SESSION['Where'], $Config['Web']['ItemsPerPage'], $_SESSION['Page']); echo(''); $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(''); $Columns = ''; $Joins = ''; foreach($TranslationTree as $Group) if($Group['TablePrefix'] != '') { $Columns .= 'COALESCE(T'.$Group['Id'].'.Count, 0) + '; $Joins .= ' LEFT JOIN (SELECT User, COUNT(User) as Count FROM `'.$Group['TablePrefix'].'` WHERE (Complete = 1) AND (Language <> 0) GROUP BY User) as T'.$Group['Id'].' ON user.ID=T'.$Group['Id'].'.User'; } $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); while($Line = mysql_fetch_assoc($ID)) { if(Licence(LICENCE_MODERATOR)) $Name = ''.$Line['user'].''; else $Name = $Line['user']; echo(''); } echo('

Jméno	Přeložených	Úroveň	Oprávnění	Poslední připojení
'.$Name.'	'.$Line['NumberTranslate'].'		'.$Moderators[$Line['GM']].'	'.HumanDate($Line['LastLogin']).'

'); ListPaging('?Page=', 'user', $_SESSION['Where'], $Config['Web']['ItemsPerPage'], $_SESSION['Page']); ShowFooter(); ?>