Changeset 67 for trunk/log.php

Timestamp:

Feb 5, 2009, 11:12:54 PM (16 years ago)

Author:

george

Message:

• Přidáno: RSS kanál pro logovací záznamy.
• Přidáno: Stránkování seznamu logovacích záznamů.
• Upraveno: Soubor global nyní nezobrazuje ihned záhlaví stránky, ale je nutné volat funkci ShowPage. V odkazovaných souborech se sjednotila inicializace databáze a dalších součástí do jednoho souboru.

File:

• trunk/log.php (modified) (1 diff)

trunk/log.php

@@ -2 +2 @@
 
 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' => $LogTypes[$Line['type']][1],
+      'Link' =>  $Config['Web']['BaseURL'].'log.php',
+      'Description' => $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('type', $_GET)) $Type = '&type='.$_GET['type'];
+    else $Type = '';
   
-echo('<b>Filtr: </b>');
-echo('<a href="log.php" title="Bez filtrování"><span style="color:black">Všechny</span></a> ');
-foreach($LogTypes as $Index => $LogItem)
-{
-  echo('<a href="log.php?type='.$LogItem[0].'" title="'.$LogItem[3].'"><span style="color:'.$LogItem[2].'">'.$LogItem[1].'</span></a> ');
+  $RSSChannels = array(array('Title' => 'Záznamy změn', 'URL' => 'log.php?rss'.$Type));
+  ShowPage();
+  
+  if(array_key_exists('Page', $_GET)) $_SESSION['Page'] = $_GET['Page']; 
+  else if(!array_key_exists('Page', $_SESSION)) $_SESSION['Page'] = 1;
+
+  echo('<b>Filtr: </b>');
+  echo('<a href="log.php" title="Bez filtrování"><span style="color:black">Všechny</span></a> ');
+  foreach($LogTypes as $Index => $LogItem)
+  {
+    echo('<a href="log.php?type='.$LogItem[0].'" title="'.$LogItem[3].'"><span style="color:'.$LogItem[2].'">'.$LogItem[1].'</span></a> ');
+  }
+
+  // echo ' Formát: datum: text zprávy (uživatel, IP)<br /><br />';
+  echo('<br /><br />');
+
+  if(array_key_exists('type', $_GET)) $Where = ' WHERE type = "'.$_GET['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) * $Config['Web']['ItemsPerPage'].','.$Config['Web']['ItemsPerPage'];
+   
+  ListPaging('?Page=', 'log', $Where, $Config['Web']['ItemsPerPage'], $_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();      
 }
 
-// echo ' Formát: datum: text zprávy (uživatel, IP)<br /><br />';
-echo('<br /><br />');
-
-if(array_key_exists('type', $_GET)) 
-{
-  $sql = "SELECT *,(SELECT user.user FROM user WHERE user.id = log.user) as user
-    FROM log WHERE type = '".$_GET['type']."' ORDER BY date DESC LIMIT 100";
-    //  if ($_GET['type'] == $LogItem[0]) { }
-} else $sql = "SELECT *,(SELECT user.user FROM user WHERE user.id = log.user) as user FROM log ORDER BY date DESC LIMIT 100";
-       
-$ID = $Database->SQLCommand($sql);
-while($Line = mysql_fetch_array($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 />');
-}            
-          
-ShowFooter();      
-
 ?>