Changeset 365 for trunk/log.php

Timestamp:

Mar 9, 2010, 11:29:05 AM (14 years ago)

Author:

george

Message:

• Upraveno: Jména tabulek v databází upraveny na stejná s prvními velkými písmeny.
• Upraveno: Doplněny SQL uvozovky do mnoha SQL dotazů.

File:

• trunk/log.php (modified) (5 diffs)

trunk/log.php

@@ -6 +6 @@
 {
   $Items = array();
-  if(array_key_exists('type', $_GET)) $Where = ' WHERE `type` = "'.($_GET['type'] * 1).'"'; 
+  if(array_key_exists('type', $_GET)) $Where = ' WHERE `Type` = "'.($_GET['type'] * 1).'"'; 
     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';
+  $sql = 'SELECT *,UNIX_TIMESTAMP(`Date`), (SELECT `User`.`Name` 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)) 
   {
-    $DbResult = $Database->SQLCommand('SELECT * FROM `LogType` WHERE `Id`='.$Line['type']);
+    $DbResult = $Database->SQLCommand('SELECT * FROM `LogType` WHERE `Id`='.$Line['Type']);
     $LogType = mysql_fetch_assoc($DbResult);
     
     $Items[] = array
     (
-      'Title' => strip_tags($LogType['Name'].': '.$Line['text'].' ('.$Line['user'].', '.$Line['IP'].')'),
+      'Title' => strip_tags($LogType['Name'].': '.$Line['Text'].' ('.$Line['Name'].', '.$Line['IP'].')'),
       'Link' =>  $Config['Web']['BaseURL'].'log.php',
-      'Description' => $LogType['Name'].': '.$Line['text'].' ('.$Line['user'].', '.$Line['IP'].')',
-      'Time' => $Line['UNIX_TIMESTAMP(date)'],
+      'Description' => $LogType['Name'].': '.$Line['Text'].' ('.$Line['Name'].', '.$Line['IP'].')',
+      'Time' => $Line['UNIX_TIMESTAMP(Date)'],
     );
   } 
@@ -39 +39 @@
   if(array_key_exists('group', $_GET)) $_SESSION['group'] = $_GET['group'];
 
-  if($_SESSION['type'] != '') $WhereType = ' `type`='.$_SESSION['type']; 
+  if($_SESSION['type'] != '') $WhereType = ' `Type`='.$_SESSION['type']; 
     else $WhereType = '1=1';
     
@@ -61 +61 @@
   else
   {
-    if(array_key_exists('group', $_SESSION)) $Where = ' WHERE `text` LIKE "%'.$TranslationTree[$_SESSION['group']]['Name'].'%"';
+    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 = $Database->SQLCommand('SELECT COUNT(*) FROM `log` '.$Where);
+  $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `Log` '.$Where);
   $DbRow = mysql_fetch_row($DbResult);
   $PageList = GetPageList($DbRow[0]);    
@@ -75 +75 @@
     array('Name' => 'date', 'Title' => 'Čas'), 
     array('Name' => 'text', 'Title' => 'Text'), 
-    array('Name' => 'user', 'Title' => 'Uživatel'), 
+    array('Name' => 'User', 'Title' => 'Uživatel'), 
     array('Name' => 'IP', 'Title' => 'Adresa'), 
   );
@@ -82 +82 @@
   echo($Order['Output']);
   
-  $sql = 'SELECT *, `LogType`.`Color` AS `LogColor`, (SELECT `user`.`user` FROM `user` WHERE `user`.`id` = `log`.`user`) AS `user` FROM `log` LEFT JOIN `LogType` ON `LogType`.`Id`=`log`.`type` '.$Where.$Order['SQL'].$PageList['SQLLimit'];
+  $sql = 'SELECT *, `LogType`.`Color` AS `LogColor`, (SELECT `User`.`Name` FROM `User` WHERE `User`.`ID` = `Log`.`User`) AS `User` FROM `Log` LEFT JOIN `LogType` ON `LogType`.`Id`=`Log`.`Type` '.$Where.$Order['SQL'].$PageList['SQLLimit'];
   //echo($sql);
   $ID = $Database->SQLCommand($sql);
   while($Line = mysql_fetch_assoc($ID)) 
   {
-    echo('<tr><td>'.$Line['date'].'</td><td><span style="color: '.$Line['LogColor'].'">'.$Line['text'].'</span></td><td>'.$Line['user'].'</td><td>'.$Line['IP'].'</td></tr>');
+    echo('<tr><td>'.$Line['Date'].'</td><td><span style="color: '.$Line['LogColor'].'">'.$Line['Text'].'</span></td><td>'.$Line['Name'].'</td><td>'.$Line['IP'].'</td></tr>');
   }
   echo('</table>');