Changeset 482 for trunk/log.php
- Timestamp:
- Jun 14, 2010, 7:09:16 AM (14 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/log.php
r455 r482 8 8 if(array_key_exists('type', $_GET)) $Where = ' WHERE `Type` = "'.($_GET['type'] * 1).'"'; 9 9 else $Where = ''; 10 $sql = 'SELECT *, UNIX_TIMESTAMP(`Date`) AS `TimeCreate`, (SELECT `User`.`Name` FROM `User` WHERE `User`.`ID` = `Log`.`User`) AS `User ` FROM `Log`'.$Where.' ORDER BY `Date` DESC LIMIT 100';10 $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'; 11 11 $DbResult = $System->Database->query($sql); 12 12 while($Line = $DbResult->fetch_assoc()) … … 17 17 $Items[] = array 18 18 ( 19 'Title' => strip_tags($LogType['Name'].': '.$Line['Text'].' ('.$Line[' Name'].', '.$Line['IP'].')'),19 'Title' => strip_tags($LogType['Name'].': '.$Line['Text'].' ('.$Line['UserName'].', '.$Line['IP'].')'), 20 20 'Link' => 'http://'.$Config['Web']['Host'].$System->Link('/log.php'), 21 'Description' => $LogType['Name'].': '.$Line['Text'].' ('.$Line[' Name'].', '.$Line['IP'].')',21 'Description' => $LogType['Name'].': '.$Line['Text'].' ('.$Line['UserName'].', '.$Line['IP'].')', 22 22 'Time' => $Line['TimeCreate'], 23 23 );
Note:
See TracChangeset
for help on using the changeset viewer.