"; ?> No permissions !"); show_footer(); exit; } ?> 0 and gitemid=".$HTTP_GET_VARS["gitemid"]; $result=DBexecute($sql); show_messages($result,"Sort order updated","Cannot update sort order"); unset($HTTP_GET_VARS["gitemid"]); } if($HTTP_GET_VARS["register"]=="down") { $sql="update graphs_items set sortorder=sortorder+1 where sortorder<100 and gitemid=".$HTTP_GET_VARS["gitemid"]; $result=DBexecute($sql); show_messages($result,"Sort order updated","Cannot update sort order"); unset($HTTP_GET_VARS["gitemid"]); } } ?> "; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; show_table_header("DISPLAYED PARAMETERS"); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $sql="select i.itemid,h.host,i.description,gi.gitemid,gi.color,gi.drawtype,gi.sortorder from hosts h,graphs_items gi,items i where i.itemid=gi.itemid and gi.graphid=".$HTTP_GET_VARS["graphid"]." and h.hostid=i.hostid order by gi.sortorder"; $result=DBselect($sql); $col=0; while($row=DBfetch($result)) { if($col++%2==0) { echo ""; } else { echo ""; } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
Sort orderHostParameterTypeColorActions
".$row["sortorder"]."".$row["host"]."".$row["description"]."".get_drawtype_description($row["drawtype"])."".$row["color"].""; echo "Change"; echo " - "; echo "Up"; echo " - "; echo "Down"; echo "
"; ?> "; echo ""; if(isset($HTTP_GET_VARS["gitemid"])) { $sql="select itemid,color,drawtype,sortorder from graphs_items where gitemid=".$HTTP_GET_VARS["gitemid"]; $result=DBselect($sql); $itemid=DBget_field($result,0,0); $color=DBget_field($result,0,1); $drawtype=DBget_field($result,0,2); $sortorder=DBget_field($result,0,3); } else { $sortorder=0; } show_table2_header_begin(); echo "New item for graph"; show_table2_v_delimiter(); echo "
"; echo ""; if(isset($HTTP_GET_VARS["gitemid"])) { echo ""; } echo "Parameter"; show_table2_h_delimiter(); $result=DBselect("select h.host,i.description,i.itemid from hosts h,items i where h.hostid=i.hostid and h.status in (0,2) and i.status=0 order by h.host,i.description"); echo ""; show_table2_v_delimiter(); echo "Type"; show_table2_h_delimiter(); echo ""; show_table2_v_delimiter(); echo "Color"; show_table2_h_delimiter(); echo ""; show_table2_v_delimiter(); echo nbsp("Sort order (0->100)"); show_table2_h_delimiter(); echo ""; show_table2_v_delimiter2(); echo ""; if(isset($itemid)) { echo ""; echo ""; } show_table2_header_end(); ?>