Changeset 379 for trunk/log.php
- Timestamp:
- Mar 11, 2010, 5:23:58 PM (15 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/log.php
r376 r379 73 73 74 74 $TableColumns = array( 75 array('Name' => ' date', 'Title' => 'Čas'),76 array('Name' => ' text', 'Title' => 'Text'),77 array('Name' => 'User ', 'Title' => 'Uživatel'),75 array('Name' => 'Date', 'Title' => 'Čas'), 76 array('Name' => 'Text', 'Title' => 'Text'), 77 array('Name' => 'UserName', 'Title' => 'Uživatel'), 78 78 array('Name' => 'IP', 'Title' => 'Adresa'), 79 79 ); … … 82 82 echo($Order['Output']); 83 83 84 $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'];84 $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']; 85 85 //echo($sql); 86 86 $ID = $Database->SQLCommand($sql); 87 87 while($Line = mysql_fetch_assoc($ID)) 88 88 { 89 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>');89 echo('<tr><td>'.$Line['Date'].'</td><td><span style="color: '.$Line['LogColor'].'">'.$Line['Text'].'</span></td><td>'.$Line['UserName'].'</td><td>'.$Line['IP'].'</td></tr>'); 90 90 } 91 91 echo('</table>');
Note:
See TracChangeset
for help on using the changeset viewer.