source: trunk/log.php@ 222

<?php

include('includes/global.php');  
include('rss.php');

if(array_key_exists('rss', $_GET))
{
  $Items = array();
  if(array_key_exists('type', $_GET)) $Where = ' WHERE type = "'.$_GET['type'].'"'; 
    else $Where = '';
  $sql = 'SELECT *,UNIX_TIMESTAMP(date), (SELECT user.user FROM user WHERE user.id = log.user) as user FROM log'.$Where.' ORDER BY date DESC LIMIT 100';
  $ID = $Database->SQLCommand($sql);
  while($Line = mysql_fetch_assoc($ID)) 
  {
    $Items[] = array
        (
      'Title' => strip_tags($LogTypes[$Line['type']][1].': '.$Line['text'].' ('.$Line['user'].', '.$Line['IP'].')'),
      'Link' =>  $Config['Web']['BaseURL'].'log.php',
      'Description' => $LogTypes[$Line['type']][1].': '.$Line['text'].' ('.$Line['user'].', '.$Line['IP'].')',
      'Time' => $Line['UNIX_TIMESTAMP(date)'],
    );
  }     

  echo(GenerateRSS(array
  (
    'Title' => 'WoWpřeklad',
    'Link' => $Config['Web']['BaseURL'],
    'Description' => 'Překlad textů WoW',
    'WebmasterEmail' => $Config['Web']['AdminEmail'],
    'Items' => $Items,
  )));
} else
{
  if(array_key_exists('Page', $_GET)) $_SESSION['Page'] = $_GET['Page']; 
  else if(!array_key_exists('Page', $_SESSION)) $_SESSION['Page'] = 1;

  if(array_key_exists('type', $_GET)) $_SESSION['type'] = $_GET['type']; 
  else if(!array_key_exists('type', $_SESSION)) $_SESSION['type'] = '';
  
  if($_SESSION['type'] <> '') $Type = '&amp;type='.$_SESSION['type'];
    else {
                 $Type = '';
                 unset($_SESSION['type']);
        }
          
  $RSSChannels = array(array('Title' => 'Záznamy změn', 'URL' => 'log.php?rss'.$Type));
  ShowPage();
  
  if(Licence(LICENCE_MODERATOR))
  {
    echo('<strong>Filtr: </strong>');
    echo('<span style="color:black"><a href="log.php?type=" title="Bez filtrování">Všechny</a></span> ');
    foreach($LogTypes as $Index => $LogItem)
    {
      echo('<a href="log.php?type='.$LogItem[0].'" style="color:'.$LogItem[2].'" title="'.$LogItem[3].'">'.$LogItem[1].'</a> ');
    }
  }
  // echo ' Formát: datum: text zprávy (uživatel, IP)<br /><br />';
  echo('<br /><br />');

  if(array_key_exists('type', $_SESSION)) $Where = ' WHERE type = "'.$_SESSION['type'].'"'; 
    else $Where = '';
  $sql = 'SELECT *,(SELECT user.user FROM user WHERE user.id = log.user) as user FROM log '.$Where.'ORDER BY date DESC LIMIT '.(($_SESSION['Page'] - 1)*100).',100';
   
  ListPaging('?Page=', 'log', $Where, 100, $_SESSION['Page']);    
  $ID = $Database->SQLCommand($sql);
  while($Line = mysql_fetch_assoc($ID)) 
  {
    foreach($LogTypes as $Index => $LogItem)
    {
      if($Line['type'] == $LogItem[0]) $color = $LogItem[2]; 
    }
    echo($Line['date'].': <span style="color:'.$color.'">'.$Line['text'].'</span> ('.$Line['user'].', '.$Line['IP'].')<br />');
  }
  //ListPaging('?Page=', 'log', $Where, $Config['Web']['ItemsPerPage'], $_SESSION['Page']);    
          
  ShowFooter();      
}

?>