Changeset 444 for trunk/log.php


Ignore:
Timestamp:
Apr 11, 2010, 1:23:53 PM (15 years ago)
Author:
george
Message:
  • Opraveno: Exportování všech zvolených skupin.
File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/log.php

    r417 r444  
    88  if(array_key_exists('type', $_GET)) $Where = ' WHERE `Type` = "'.($_GET['type'] * 1).'"';
    99    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';
    1111  $ID = $Database->SQLCommand($sql);
    1212  while($Line = mysql_fetch_assoc($ID))
     
    2020      'Link' => 'http://'.$Config['Web']['Host'].$System->Link('/log.php'),
    2121      'Description' => $LogType['Name'].': '.$Line['Text'].' ('.$Line['Name'].', '.$Line['IP'].')',
    22       'Time' => $Line['UNIX_TIMESTAMP(Date)'],
     22      'Time' => $Line['TimeCreate'],
    2323    );
    2424  }
Note: See TracChangeset for help on using the changeset viewer.