- fixed oracle sql request limitation

git-svn-id: svn://svn.zabbix.com/trunk@2859 97f52cf1-0a1b-0410-bd0e-c28be96e8082

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));