diff options
Diffstat (limited to 'frontends/php/audit.php')
| -rw-r--r-- | frontends/php/audit.php | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/frontends/php/audit.php b/frontends/php/audit.php index cd98b459..d38f4153 100644 --- a/frontends/php/audit.php +++ b/frontends/php/audit.php @@ -75,16 +75,18 @@ if(!isset($_REQUEST["start"])) { $sql="select u.alias,a.clock,a.action,a.resourcetype,a.details from auditlog a, users u". - " where u.userid=a.userid and a.auditid>$maxauditid-200 order by clock desc limit 200"; + " where u.userid=a.userid and a.auditid>$maxauditid-200 order by clock desc"; + $limit = 200; } else { $sql="select u.alias,a.clock,a.action,a.resourcetype,a.details from auditlog a, users u". " where u.userid=a.userid and a.auditid>$maxauditid-".($_REQUEST["start"]+200). - " order by clock desc limit ".($_REQUEST["start"]+200); + " order by clock desc"; + $limit = $_REQUEST["start"]+200; } - $result=DBselect($sql); + $result=DBselect($sql,$limit); $table = new CTableInfo(); $table->setHeader(array(S_TIME,S_USER,S_RESOURCE,S_ACTION,S_DETAILS)); |