".S_NO_PERMISSIONS.""); show_page_footer(); exit; } $_REQUEST["hostid"]=get_request("hostid",get_profile("web.latest.hostid",0)); update_profile("web.latest.hostid",$_REQUEST["hostid"]); update_profile("web.menu.config.last",$page["file"]); ?> ".$graph."", "".$graph.""); } else { $h1=S_SELECT_GRAPH_TO_DISPLAY; } $h1=S_GRAPHS_BIG.nbsp(" / ").$h1; $h2=S_GROUP." "; $h2=$h2.""; $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.hostid=i.hostid and hg.groupid=".$row["groupid"]. " and hg.hostid=h.hostid and h.status not in (".HOST_STATUS_DELETED.")". " 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.""; $h2=$h2.form_select("hostid",0,S_SELECT_HOST_DOT_DOT_DOT); if(isset($_REQUEST["groupid"])) { $sql="select h.hostid,h.host from hosts h,items i,hosts_groups hg". " where h.hostid=i.hostid and hg.groupid=".$_REQUEST["groupid"]." and hg.hostid=h.hostid". " and h.status not in (".HOST_STATUS_DELETED.") group by h.hostid,h.host order by h.host"; } else { $sql="select h.hostid,h.host from hosts h,items i where h.hostid=i.hostid". " and h.status not in (".HOST_STATUS_DELETED.") group by h.hostid,h.host order by h.host"; } $result=DBselect($sql); while($row=DBfetch($result)) { if(!check_right("Host","R",$row["hostid"])) continue; $h2=$h2.form_select("hostid",$row["hostid"],$row["host"]); } $h2=$h2.""; show_header2($h1,$h2,"

","

"); ?> setHeader(array(S_ID,S_NAME,S_WIDTH,S_HEIGHT,S_ACTIONS)); if(isset($_REQUEST["hostid"])&&($_REQUEST["hostid"]!=0)) { $result=DBselect("select distinct g.graphid,g.name,g.width,g.height from graphs g,items i". ",graphs_items gi where gi.itemid=i.itemid and g.graphid=gi.graphid". " and i.hostid=".$_REQUEST["hostid"]." order by g.name"); } else { $result=DBselect("select distinct g.graphid,g.name,g.width,g.height". " from graphs g order by g.name"); } while($row=DBfetch($result)) { if(!check_right("Graph","U",$row["graphid"])) continue; if(!isset($_REQUEST["hostid"])) { $sql="select * from graphs_items where graphid=".$row["graphid"]; $result2=DBselect($sql); if(DBnum_rows($result2)>0) continue; } $table->addRow(array( $row["graphid"], new CLink($row["name"],"graph.php?graphid=".$row["graphid"]), $row["width"], $row["height"], new CLink("Change","graphs.php?graphid=".$row["graphid"]) )); } $table->show(); ?>