>"))
{
if(isset($_REQUEST["start"]))
{
$_REQUEST["start"]+=100;
}
else
{
$_REQUEST["start"]=100;
}
}
if(isset($_REQUEST["start"])&&($_REQUEST["start"]<=0))
{
unset($_REQUEST["start"]);
}
if(isset($_REQUEST["groupid"])&&($_REQUEST["groupid"]==0))
{
unset($_REQUEST{"groupid"});
}
?>
";
$h2=$h2.form_select("groupid",0,S_ALL_SMALL);
$result=DBselect("select groupid,name from groups order by name");
while($row=DBfetch($result))
{
// Check if at least one host with read permission exists for this group
$result2=DBselect("select h.hostid,h.host from hosts h,items i,hosts_groups hg where h.status=".HOST_STATUS_MONITORED." and h.hostid=i.hostid and hg.groupid=".$row["groupid"]." and hg.hostid=h.hostid group by h.hostid,h.host order by h.host");
$cnt=0;
while($row2=DBfetch($result2))
{
if(!check_right("Host","R",$row2["hostid"]))
{
continue;
}
$cnt=1; break;
}
if($cnt!=0)
{
$h2=$h2.form_select("groupid",$row["groupid"],$row["name"]);
}
}
$h2=$h2."";
$h2=$h2." ".S_HOST." ";
$h2=$h2." ";
if(isset($_REQUEST["start"]))
{
$h2=$h2."";
$h2=$h2."";
}
else
{
$h2=$h2."";
}
$h2=$h2.">\">";
show_header2($h1,$h2,"");
?>
0,$row["max"],0);
// $sql="select t.description,a.clock,a.value,t.triggerid,t.priority from alarms a,triggers t where t.triggerid=a.triggerid and a.alarmid>$maxalarmid-".($_REQUEST["start"]+200)." order by clock desc limit ".($_REQUEST["start"]+200);
if(isset($_REQUEST["hostid"]))
{
$sql="select t.description,a.clock,a.value,t.triggerid,t.priority from alarms a,triggers t,hosts h,items i,functions f where t.triggerid=a.triggerid and f.triggerid=t.triggerid and f.itemid=i.itemid and i.hostid=h.hostid and h.hostid=".$_REQUEST["hostid"]." and a.alarmid>$maxalarmid-".($_REQUEST["start"]+200)." order by clock desc limit ".($_REQUEST["start"]+200);
}
else
{
$sql="select t.description,a.clock,a.value,t.triggerid,t.priority from alarms a,triggers t,hosts h,items i,functions f where t.triggerid=a.triggerid and f.triggerid=t.triggerid and f.itemid=i.itemid and i.hostid=h.hostid and a.alarmid>$maxalarmid-".($_REQUEST["start"]+200)." order by clock desc limit ".($_REQUEST["start"]+200);
}
$result=DBselect($sql);
$table = new CTableInfo();
$table->setHeader(array(S_TIME, S_DESCRIPTION, S_VALUE, S_SEVERITY));
$col=0;
$i=0;
while($row=DBfetch($result))
{
$i++;
if(isset($_REQUEST["start"])&&($i<$_REQUEST["start"]))
{
continue;
}
if(!check_right_on_trigger("R",$row["triggerid"]))
{
continue;
}
if($col>100) break;
$description=expand_trigger_description($row["triggerid"]);
$description="$description";
if($row["value"] == 0)
{
$value=new CCol(S_OFF,"off");
}
elseif($row["value"] == 1)
{
$value=new CCol(S_ON,"on");
}
else
{
$value=new CCol(S_UNKNOWN_BIG,"unknown");
}
if($row["priority"]==0) $priority=S_NOT_CLASSIFIED;
elseif($row["priority"]==1) $priority=S_INFORMATION;
elseif($row["priority"]==2) $priority=S_WARNING;
elseif($row["priority"]==3) $priority=array("value"=>S_AVERAGE,"class"=>"average");
elseif($row["priority"]==4) $priority=array("value"=>S_HIGH,"class"=>"high");
elseif($row["priority"]==5) $priority=array("value"=>S_DISASTER,"class"=>"disaster");
else $priority=$row["priority"];
$table->addRow(array(
date("Y.M.d H:i:s",$row["clock"]),
$description,
$value,
$priority));
}
$table->show();
?>