No permissions !"); // show_page_footer(); // exit; // } ?> "; $h2=$h2.form_select("period","day",S_DAY); $h2=$h2.form_select("period","week",S_WEEK); $h2=$h2.form_select("period","month",S_MONTH); $h2=$h2.form_select("period","year",S_YEAR); $h2=$h2.""; show_header2($h1, $h2, "

", "

"); ?> setHeader(array(S_HOST,S_TRIGGER,S_SEVERITY,S_NUMBER_OF_STATUS_CHANGES)); $time_now=time(); if($_REQUEST["period"]=="day") { $time_dif=24*3600; } elseif($_REQUEST["period"]=="week") { $time_dif=7*24*3600; } elseif($_REQUEST["period"]=="month") { $time_dif=30*24*3600; } elseif($_REQUEST["period"]=="year") { $time_dif=365*24*3600; } $result=DBselect("select h.host, t.triggerid, t.description, t.priority, count(a.alarmid) from hosts h, triggers t, functions f, items i, alarms a where h.hostid = i.hostid and i.itemid = f.itemid and t.triggerid=f.triggerid and t.triggerid=a.triggerid and a.clock>$time_now-$time_dif group by h.host,t.triggerid,t.description,t.priority order by 5 desc,1,3", 100); while($row=DBfetch($result)) { $priority_style=NULL; 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=S_AVERAGE; $priority_style="average"; } elseif($row["priority"]==4) { $priority=S_HIGH; $priority_style="high"; } elseif($row["priority"]==5) { $priority=S_DISASTER; $priority_style="disaster"; } else $priority=$row["priority"]; $severity=new CSpan($priority,$priority_style); $table->addRow(array( $row["host"], expand_trigger_description($row["triggerid"]), new CCol($priority,$priority_style), $row["count(a.alarmid)"], )); } $table->show(); show_page_footer(); ?>