".$sql."\n"; $result = db_query($db,$sql); if ( PEAR::isError($result) ) { echo "

".$result->getMessage()."

\n"; } echo "\n"; $ncols=1; $col[0]="jobid"; echo ""; foreach ($keys as $key) { if ( $key!='node' && $key!='start_date' && $key!='end_date' ) { echo ""; $col[$ncols]=$key; $ncols++; } } echo "\n"; while ($result->fetchInto($row)) { echo ""; $rkeys=array_keys($row); foreach ($rkeys as $key) { $data[$key]=array_shift($row); if ( $col[$key]=="submit_ts" || $col[$key]=="start_ts" || $col[$key]=="end_ts") { echo "\n"; } else if ($col[$key] == "jobid") { $jobid_nodot = ereg_replace('\..*', '', $data[$key]); echo ""; } else { echo ""; } } echo "\n"; } echo "

jobid	".$key."
".date("Y-m-d H:i:s",$data[$key])."	", htmlspecialchars($jobid_nodot), "	".htmlspecialchars($data[$key])."

\n"; db_disconnect($db); bookmarkable_url(); } else { begin_form("jobs-by-node.php"); text_field("Node RegExp","node",16); system_chooser(); date_fields(); $props=array("username","groupname","account","jobname","nproc","mppe","mppssp", "nodes","feature","gres","queue","qos","submit_ts","start_ts","end_ts","cput_req", "cput","walltime_req","walltime","mem_req","mem_kb", "vmem_req","vmem_kb","software","submithost","hostlist","exit_status","script"); checkboxes_from_array("Properties",$props); end_form(); } page_footer(); ?>