source: trunk/userlist.php@ 291

<?php

include('includes/global.php');

ShowPage();

include('img_level.php');

echo('<h3>Seznam uživatelů</h3>');

if(array_key_exists('search', $_GET))
{
  $_SESSION['Where'] = ' WHERE `user`.`user` LIKE "%'.$_GET['search'].'%"'; 
}
if(array_key_exists('team', $_GET))
{
  $_SESSION['Where'] = ' WHERE team='.$_GET['team']; 
  if($_GET['team'] == '') $_SESSION['Where'] = '';     
}
else if(!array_key_exists('Where', $_SESSION)) $_SESSION['Where'] = '';

if(array_key_exists('action', $_GET))
{
  if($_GET['action'] == 'nofilter') $_SESSION['Where'] = '';
}
//if($_SESSION['Where'] <> '') echo(' <a href="?action=nofilter">Zrušit filtr uživatelů</a><br />');

$DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `user`'.$_SESSION['Where']);
$DbRow = mysql_fetch_row($DbResult);
$PageList = GetPageList($DbRow[0]);    

echo($PageList['Output']);
echo('<table class="BaseTable">');

$TableColumns = array(
  array('Name' => 'user', 'Title' => 'Jméno'), 
  array('Name' => 'NumberTranslate', 'Title' => 'Přeložených'), 
  array('Name' => 'XP', 'Title' => 'Úroveň'), 
  array('Name' => 'GM', 'Title' => 'Oprávnění'), 
  array('Name' => 'LastLogin', 'Title' => 'Poslední připojení'), 
);
$Order = GetOrderTableHeader($TableColumns, 'NumberTranslate', 1);
echo($Order['Output']);

$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['SQL'].$PageList['SQLLimit'];

$ID = $Database->SQLCommand($Query);
while($Line = mysql_fetch_assoc($ID)) 
{
  if(Licence(LICENCE_MODERATOR)) 
    $Name = '<a href="user.php?user='.$Line['ID'].'">'.$Line['user'].'</a>';
    else $Name = $Line['user'];
        
    echo('<tr><td>'.$Name.'</td>
      <td style="text-align: center;"><a href="TranslationList.php?user='.$Line['ID'].'&amp;action=userall" title="Zobrazit Všechny jeho přeložené texty">'.$Line['NumberTranslate'].'</a></td>
      <td><img src="tmp/'.$Line['user'].'/level.png" alt="Úroveň uživatele" /></td>
      <td>'.$Moderators[$Line['GM']].'</td>
      <td>'.HumanDate($Line['LastLogin']).'</td></tr>');
}
echo('</table>');
echo($PageList['Output']);
          
ShowFooter();      

?>