Changeset 519 for trunk/log.php
- Timestamp:
- Feb 18, 2013, 10:40:08 PM (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/log.php
r518 r519 77 77 $TableColumns = array( 78 78 array('Name' => 'Date', 'Title' => 'Čas'), 79 array('Name' => 'Text', 'Title' => 'Text'), 79 array('Name' => 'LogName', 'Title' => 'Typ'), 80 array('Name' => 'Text', 'Title' => 'Text'), 80 81 array('Name' => 'UserName', 'Title' => 'Uživatel'), 81 82 array('Name' => 'IP', 'Title' => 'Adresa'), … … 85 86 $Order['Output']; 86 87 87 $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']; 88 $sql = 'SELECT *, `LogType`.`Color` AS `LogColor`, `LogType`.`Name` AS `LogName`, '. 89 '(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']; 88 90 $DbResult = $System->Database->query($sql); 89 91 while($Line = $DbResult->fetch_assoc()) 90 92 { 93 if($Line['Type'] == LOG_TYPE_ERROR) $Line['Text'] = htmlspecialchars($Line['Text']); 91 94 $Output .= '<tr><td>'.$Line['Date'].'</td>'. 92 '<td><span style="color: '.$Line['LogColor'].'">'.htmlspecialchars($Line['Text']).'</span></td>'. 95 '<td>'.$Line['LogName'].'</td>'. 96 '<td><span style="color: '.$Line['LogColor'].'">'.$Line['Text'].'</span></td>'. 93 97 '<td>'.$Line['UserName'].'</td>'. 94 98 '<td>'.$Line['IP'].'</td></tr>';
Note:
See TracChangeset
for help on using the changeset viewer.