source: trunk/log.php@ 507

<?php

include_once('includes/global.php');  

$Output = '';
if(array_key_exists('rss', $_GET))
{
  $Items = array();
  if(array_key_exists('type', $_GET)) $Where = ' WHERE `Type` = "'.($_GET['type'] * 1).'"'; 
    else $Where = '';
  $sql = 'SELECT *, UNIX_TIMESTAMP(`Date`) AS `TimeCreate`, (SELECT `User`.`Name` FROM `User` WHERE `User`.`ID` = `Log`.`User`) AS `UserName` FROM `Log`'.$Where.' ORDER BY `Date` DESC LIMIT 100';
  $DbResult = $System->Database->query($sql);
  while($Line = $DbResult->fetch_assoc()) 
  {
    $DbResult2 = $System->Database->query('SELECT * FROM `LogType` WHERE `Id`='.$Line['Type']);
    $LogType = $DbResult2->fetch_assoc();
    
    $Items[] = array
    (
      'Title' => strip_tags($LogType['Name'].': '.$Line['Text'].' ('.$Line['UserName'].', '.$Line['IP'].')'),
      'Link' => 'http://'.$Config['Web']['Host'].$System->Link('/log.php'),
      'Description' => $LogType['Name'].': '.$Line['Text'].' ('.$Line['UserName'].', '.$Line['IP'].')',
      'Time' => $Line['TimeCreate'],
    );
  } 

  $Output .= GenerateRSS(array
  (
    'Title' => $Config['Web']['Title'],
    'Link' => 'http://'.$Config['Web']['Host'].$System->Link('/'),
    'Description' => $Config['Web']['Title'],
    'WebmasterEmail' => $Config['Web']['AdminEmail'],
    'Items' => $Items,
  ));
  echo($Output);
} else
{
  if(array_key_exists('type', $_GET)) $_SESSION['type'] = $_GET['type'] * 1; 
  else if(!array_key_exists('type', $_SESSION)) $_SESSION['type'] = '';

  if(array_key_exists('group', $_GET)) $_SESSION['group'] = $_GET['group'];

  if($_SESSION['type'] != '') $WhereType = ' `Type`='.$_SESSION['type']; 
    else $WhereType = '1=1';
    
  $RSSChannels = array(
        array('Title' => 'Záznamy změn', 'Channel' => 'log&amp;type='.$_SESSION['type'])
  );
  
  if($User->Licence(LICENCE_MODERATOR))
  {
    $Output = '<strong>Filtr: </strong>'.
      '<span style="color:black"><a href="log.php?type=" title="Bez filtrování">Všechny</a></span> ';
    $DbResult = $System->Database->query('SELECT * FROM `LogType`');
    while($LogType = $DbResult->fetch_assoc())
    {
      $Output .= '<a href="log.php?type='.$LogType['Id'].'" style="color:'.$LogType['Color'].'" title="'.$LogType['Name'].'">'.$LogType['Name'].'</a> ';
    }
  }
  // echo ' Formát: datum: text zprávy (uživatel, IP)<br /><br />';
  $Output .= '<br /><br />';

  if(array_key_exists('type', $_SESSION)) $Where = ' WHERE '.$WhereType; 
  else
  {
    if(array_key_exists('group', $_SESSION)) $Where = ' WHERE `Text` LIKE "%'.$TranslationTree[$_SESSION['group']]['Name'].'%"';
      else $Where = '';
  } 
  //if(($Where != '') and (array_key_exists('group', $_SESSION))) $Where .= ' AND text LIKE "%'.$TranslationTree[$_SESSION['group']]['Name'].'%"';

  $DbResult = $System->Database->query('SELECT COUNT(*) FROM `Log` '.$Where);
  $DbRow = $DbResult->fetch_row();
  $PageList = GetPageList($DbRow[0]);    
  
  $Output .= $PageList['Output'];
  
  $TableColumns = array(
    array('Name' => 'Date', 'Title' => 'Čas'), 
    array('Name' => 'Text', 'Title' => 'Text'), 
    array('Name' => 'UserName', 'Title' => 'Uživatel'), 
    array('Name' => 'IP', 'Title' => 'Adresa'), 
  );
  $Order = GetOrderTableHeader($TableColumns, 'date', 1);
  $Output .= '<table width="98%" class="BaseTable">'.
    $Order['Output'];
  
  $sql = 'SELECT *, `LogType`.`Color` AS `LogColor`, (SELECT `User`.`Name` FROM `User` WHERE `User`.`ID` = `Log`.`User`) AS `UserName` FROM `Log` LEFT JOIN `LogType` ON `LogType`.`Id`=`Log`.`Type` '.$Where.$Order['SQL'].$PageList['SQLLimit'];
  //echo($sql);
  $DbResult = $System->Database->query($sql);
  while($Line = $DbResult->fetch_assoc()) 
  {
    //$Output .= '<tr><td>'.$Line['Date'].'</td><td><span style="color: '.$Line['LogColor'].'">'.$Line['Text'].'</span></td><td>'.$Line['UserName'].'</td><td>'.$Line['IP'].'</td></tr>';
  }
  $Output .= '</table>'.
    $PageList['Output'];
          
  ShowPage($Output);      
}

?>