- added table audit (Alexei)

 - added audit.php (Alexei)
 - new default port numbers for agent and trapper, 10050 and 10051 (Alexei)
 - better internal coding standard for ZABBIX agent (Alexei)
 - added support for md5sum for files less than 64M (Alexei)
 - added include md5.c and md5.h (Alexei)
 - remove trends.php, trend.php (Alexei)
 - remove compare.php, chart3.php (Alexei)
 - show trigger dependencies in list of configuration of triggers (Alexei)
 - make Zabbix reset nextcheck for items when updating or adding a trigger (Alexei)
 - minimum value of PingerFrequency changed to 1 (Alexei)


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

1 files changed, 164 insertions, 0 deletions

diff --git a/frontends/php/audit.php b/frontends/php/audit.php
new file mode 100644
index 00000000..3a192169
--- /dev/null
+++ b/frontends/php/audit.php
@@ -0,0 +1,164 @@
+<?php
+/* 
+** Zabbix
+** Copyright (C) 2000,2001,2002,2003,2004 Alexei Vladishev
+**
+** This program is free software; you can redistribute it and/or modify
+** it under the terms of the GNU General Public License as published by
+** the Free Software Foundation; either version 2 of the License, or
+** (at your option) any later version.
+**
+** This program is distributed in the hope that it will be useful,
+** but WITHOUT ANY WARRANTY; without even the implied warranty of
+** MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+** GNU General Public License for more details.
+**
+** You should have received a copy of the GNU General Public License
+** along with this program; if not, write to the Free Software
+** Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
+**/
+?>
+<?php
+	include "include/config.inc.php";
+	$page["title"] = S_AUDIT_LOG;
+	$page["file"] = "audit.php";
+	show_header($page["title"],30,0);
+?>
+
+<?php
+	if(isset($_GET["start"])&&isset($_GET["do"])&&($_GET["do"]=="<< Prev 100"))
+	{
+		$_GET["start"]-=100;
+	}
+	if(isset($_GET["do"])&&($_GET["do"]=="Next 100 >>"))
+	{
+		if(isset($_GET["start"]))
+		{
+			$_GET["start"]+=100;
+		}
+		else
+		{
+			$_GET["start"]=100;
+		}
+	}
+	if(isset($_GET["start"])&&($_GET["start"]<=0))
+	{
+		unset($_GET["start"]);
+	}
+?>
+
+<?php
+	show_table3_header_begin();
+	echo "&nbsp;".S_AUDIT_LOG_BIG;
+	show_table3_h_delimiter(20);
+	echo "<form name=\"form2\" method=\"get\" action=\"audit.php\">";
+	if(isset($_GET["start"]))
+	{
+		echo "<input class=\"biginput\" name=\"start\" type=hidden value=".$_GET["start"]." size=8>";
+  		echo "<input class=\"button\" type=\"submit\" name=\"do\" value=\"<< Prev 100\">";
+	}
+	else
+	{
+  		echo "<input class=\"button\" type=\"submit\" disabled name=\"do\" value=\"<< Prev 100\">";
+	}
+  	echo "<input class=\"button\" type=\"submit\" name=\"do\" value=\"Next 100 >>\">";
+	echo "</form>";
+	show_table_header_end();
+?>
+
+<FONT COLOR="#000000">
+<?php
+	$sql="select max(auditid) as max from audit";
+	$result=DBselect($sql);
+	$row=DBfetch($result);
+	$maxauditid=@iif(DBnum_rows($result)>0,$row["max"],0);
+
+	if(!isset($_GET["start"]))
+	{
+		$sql="select u.alias,a.clock,a.action,a.resource,a.details from audit a, users u 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.resource,a.details from audit a, users u where u.userid=a.userid and a.auditid>$maxauditid-".($_GET["start"]+200)." order by clock desc limit ".($_GET["start"]+200);
+
+	}
+	$result=DBselect($sql);
+
+//	echo "<TABLE WIDTH=100% align=center BORDER=0 BGCOLOR=\"#CCCCCC\" cellspacing=1 cellpadding=3>";
+	echo "<TABLE WIDTH=100% align=center BGCOLOR=\"#AAAAAA\" BORDER=0 cellspacing=1 cellpadding=3>";
+	echo "<TR BGCOLOR=\"#CCCCCC\">";
+	echo "<TD width=20%><b>".S_TIME."</b></TD>";
+	echo "<TD width=10%><b>".S_USER."</b></TD>";
+	echo "<TD width=10%><b>".S_RESOURCE."</b></TD>";
+	echo "<TD width=10%><b>".S_ACTION."</b></TD>";
+	echo "<TD><b>".S_DETAILS."</b></TD>";
+	echo "</TR>";
+	$col=0;
+	$i=0;
+	while($row=DBfetch($result))
+	{
+		$i++;
+		if(isset($_GET["start"])&&($i<$_GET["start"]))
+		{
+			continue;
+		}
+//		if(!check_right_on_trigger("R",$row["triggerid"]))
+//		{
+//			continue;
+//		}
+		if($col++%2==0)	{ echo "<tr bgcolor=#DDDDDD>"; }
+		else		{ echo "<tr bgcolor=#EEEEEE>"; }
+
+		if($col>100)	break;
+
+		echo "<TD>",date("Y.M.d H:i:s",$row["clock"]),"</TD>";
+		echo "<TD>",$row["alias"],"</TD>";
+		echo "<TD>";
+		if($row["resource"]==AUDIT_RESOURCE_USER)
+		{
+			echo S_USER;
+		}
+		else if($row["resource"]==AUDIT_RESOURCE_ZABBIX_CONFIG)
+		{
+			echo S_CONFIGURATION_OF_ZABBIX;
+		}
+		else if($row["resource"]==AUDIT_RESOURCE_MEDIA_TYPE)
+		{
+			echo S_MEDIA_TYPE;
+		}
+		else
+		{
+			echo S_UNKNOWN_RESOURCE;
+		}
+		echo "</TD>";
+		echo "<TD>";
+		if($row["action"]==AUDIT_ACTION_ADD)
+		{
+			echo S_ADDED;
+		}
+		else if($row["action"]==AUDIT_ACTION_UPDATE)
+		{
+			echo S_UPDATED;
+		}
+		else if($row["action"]==AUDIT_ACTION_DELETE)
+		{
+			echo S_DELETED;
+		}
+		else
+		{
+			echo S_UNKNOWN_ACTION;
+		}
+		echo "</TD>";
+		echo "<TD>",$row["details"],"</TD>";
+		echo "</TR>";
+		cr();
+	}
+	echo "</TABLE>";
+?>
+</FONT>
+</TR>
+</TABLE>
+
+<?php
+	show_footer();
+?>