chars // e.g. is valid $pattern = "^[]{2,5}$"; if(ereg($pattern, $str, $reg)){ return true; } else return false; } require "/a/infofa/h/users/mgonzale/private/pg_open_db_infection.php"; $interval = $_GET['interval']; $new_infection = $_GET['new_infection']; $old_infection = $_GET['old_infection']; // assign default values if($interval == ""){ $interval = 3; } if($new_infection == ""){ $new_infection = 2; } if($old_infection == ""){ $old_infection = 7; } ?>

in day(s) Interval: > Only Machines in the interval will be listed (Interval = now - last_scanned date) New Infections Treshold: > Records of machines that have been infected for less or equal than this value are in blue text. Old Infections Treshold: > Records of machines that have been infected for more or equal than this value are in red text.

"; // if records present // iterate through resultset and print in a table $num_of_field = pg_numfields($result); //echo "number of fields = $num_of_field
"; ?> "; while(list($key, $value) = each($row)){ // check the initial_infection_date and set the flags for color format $color_flag = "black"; $num_of_days_infected = intval($row[$num_of_field-1]); if($num_of_days_infected >= $old_infection){ $color_flag = "red"; } if($num_of_days_infected <= $new_infection){ $color_flag = "blue"; } // fisrt 2 fields (allocated_to and contact) will appear in a separate row if($key == 0 && $temp != $value){ $contact = $row[1]; //debug if($contact == ""){ $contact = "N/A"; } // verify if $contact is an email address format $contact_temp = ""; $email = ""; $contact_arr = explode(" ", $contact); while(list($index, $val) = each($contact_arr)){ if(isEmail($val)){ $email = trim($val, "\<\>"); $email = "$email"; } else{ $contact_temp .= $val. " "; } } $contact_temp .= " ".$email; echo ""; echo ""; for($i=2; $i<$num_of_field-1; $i++){ $field = pg_fieldname($result, $i); echo ""; } echo ""; $temp = $value; } else{ if($key > 1 && $key!=$num_of_field-1){ // get only the date from the last_scanned and initial_infection_date fields, not the time if($key == pg_fieldnum($result, 'last_scanned') || $key == pg_fieldnum($result, 'initial_infection_date')){ $date = substr($value, 0, 11); echo ""; } else{ echo ""; } } } } echo ""; $n++; } ?>

Allocated To: $value (Contact: $contact_temp)
$field
$date	$value