source: trunk/userlist.php@ 57

<?php

include('includes/global.php');

$ItemsPerPage = 50;

function WritePages($Address, $Table, $Where, $ItemsPerPage, $CurrentPage)
{
  global $Database;
        
  $Line = mysql_fetch_row($Database->SQLCommand('SELECT count(*) FROM '.$Table.' '.$Where));        
  $ItemCount = floor($Line[0] / $ItemsPerPage);
        
  echo('Počet položek: <strong>'.$Line[0].'</strong> &nbsp; Zobrazit stránku: ');

  if($CurrentPage > $ItemCount) $CurrentPage = ($ItemCount / $ItemsPerPage) - 1;
  for($Page = 1; $Page <= $ItemCount; $Page++) 
  {
    if($CurrentPage == $Page) echo('<strong>'.$Page.'</strong> ');
      else echo('<a href="'.$Address.$Page.'">'.$Page.'</a> ');
  }       
}

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'] = 'user';
if(array_key_exists('Desc', $_GET)) $_SESSION['Desc'] = $_GET['Desc']; 
else if(!array_key_exists('Desc', $_SESSION)) $_SESSION['Desc'] = '';
WritePages('?Page=', 'user', '', $ItemsPerPage, $_SESSION['Page']);

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

if(array_key_exists('Order', $_GET)) 
{
  $order = $_GET['Order'];
  $desc = $_GET['Desc'];
} else 
{
  $order = 'NumberTranslate';
  $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=Vote&amp;Desc='.$desc.'" title="Průměrná známka textů">Hodnocení</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>');

$Query = 'SELECT ID,user, LastLogin, GM, (';
foreach($TranslationTree as $Group)
  if($Group['TablePrefix'] != '')
    $Query .= '(SELECT count(*) FROM `'.$Group['TablePrefix'].'` WHERE (User = user.ID) AND (Complete = 1) AND (Language <> 0)) + ';
$Query .= '0) as NumberTranslate, (';
foreach($TranslationTree as $Group)
  if($Group['TablePrefix'] != '')
    $Query .= 'IFNULL((SELECT sum(Vote) AS Vote FROM `'.$Group['TablePrefix'].'` WHERE (User = user.ID) AND (Complete = 1) AND (Language <> 0)), 0) + ';
$Query .= '0) / (';
foreach($TranslationTree as $Group)
  if($Group['TablePrefix'] != '')
    $Query .= '(SELECT count(Vote) AS Vote FROM `'.$Group['TablePrefix'].'` WHERE (User = user.ID) AND (Complete = 1) AND (Language <> 0)) + ';
$Query .= '0) AS Vote FROM `user` ORDER BY '.$order.' '.$desc.' LIMIT '.($_SESSION['Page'] - 1) * $ItemsPerPage.','.$ItemsPerPage;
$ID = $Database->SQLCommand($Query);
while($Line = mysql_fetch_array($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;">'.$Line['NumberTranslate'].'</td>
      <td style="text-align: center;">'.substr($Line['Vote'], 0, 4).'</td>
      <td>'.$Moderators[$Line['GM']].'</td>
      <td>'.$Line['LastLogin'].'</td></tr>');
}
echo('</table>');
WritePages('?Page=', 'user', '', $ItemsPerPage, $_SESSION['Page']);
          
ShowFooter();      

?>