Changeset 444 for trunk/log.php
- Timestamp:
- Apr 11, 2010, 1:23:53 PM (15 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/log.php
r417 r444 8 8 if(array_key_exists('type', $_GET)) $Where = ' WHERE `Type` = "'.($_GET['type'] * 1).'"'; 9 9 else $Where = ''; 10 $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';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'; 11 11 $ID = $Database->SQLCommand($sql); 12 12 while($Line = mysql_fetch_assoc($ID)) … … 20 20 'Link' => 'http://'.$Config['Web']['Host'].$System->Link('/log.php'), 21 21 'Description' => $LogType['Name'].': '.$Line['Text'].' ('.$Line['Name'].', '.$Line['IP'].')', 22 'Time' => $Line[' UNIX_TIMESTAMP(Date)'],22 'Time' => $Line['TimeCreate'], 23 23 ); 24 24 }
Note:
See TracChangeset
for help on using the changeset viewer.