source: trunk/userlist.php@ 112

<?php

include('includes/global.php');

ShowPage();

include('img_level.php');

echo('<strong>Seznam uživatelů:</strong><br />');
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'] = '';
ListPaging('?Page=', 'user', '', $Config['Web']['ItemsPerPage'], $_SESSION['Page']);

echo('<table class="BaseTable">');

$desc = $_SESSION['Desc']; 
if($desc == '') $desc = 'DESC'; else $desc = '';

echo('<tr><th><a href="?Order=user&amp;Desc='.$desc.'">Jméno</a></th>
  <th><a href="?Order=NumberTranslate&amp;Desc='.$desc.'" title="Počet přeložených textů">Přeložených</a></th>
  <th><a href="?Order=XP&amp;Desc='.$desc.'">Úroveň</a></th>
  <th><a href="?Order=GM&amp;Desc='.$desc.'">Oprávnění</a></th>
  <th><a href="?Order=LastLogin&amp;Desc='.$desc.'">Poslední připojení</a></th></tr>');

$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.' 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 = '<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" /><br /></td>
      <td>'.$Moderators[$Line['GM']].'</td>
      <td>'.$Line['LastLogin'].'</td></tr>');
}
echo('</table>');
ListPaging('?Page=', 'user', '', $Config['Web']['ItemsPerPage'], $_SESSION['Page']);
          
ShowFooter();      

?>
Projekt překládání textů WoW