//echo $query . "<BR>"; $sql->send_query($query); } header("Location:manage_samples.php?experiment_id={$experiment_id}\n\n"); die(""); } if ($delete_experiment_jobs) { $query = "DELETE FROM processing_jobs WHERE experiment_id = {$experiment_id} AND sample_id=0 AND region_id = 0"; $sql->send_query($query); header("Location: manage_samples.php?experiment_id={$experiment_id}\n\n"); die(""); } $experiment = new ns_experiment($experiment_id, '', $sql, false); #if ($hide_censored)die("HIDE"); # else die("NO HIDE"); $experiment->get_sample_information($sql, !$hide_censored); /************************** Sort Samples, putting censored samples at back of list. *************************/ $uncensored = array(); $censored = array(); for ($i = 0; $i < sizeof($experiment->samples); $i++) { if ($experiment->samples[$i]->censored) { array_push($censored, $experiment->samples[$i]); } else { array_push($uncensored, $experiment->samples[$i]); } } for ($i = 0; $i < sizeof($uncensored); $i++) { $experiment->samples[$i] = $uncensored[$i]; }
} } $query = "UPDATE sample_region_image_info SET censored = " . ($was_censored ? "1" : "0") . ", details='" . $value['details'] . "', strain='" . $value['strain'] . "',reason_censored='{$censored_reason}', strain_condition_1= '" . $value['condition_1'] . "', strain_condition_2='" . $value['condition_2'] . "' WHERE id=" . $key; // echo $query . "<br>"; $sql->send_query($query); } $query = "UNLOCK TABLES"; $sql->send_query($query); // $refresh_page = TRUE; } //die(''); if ($refresh_page === TRUE) { header("Location: experiment_overview.php?experiment_id={$experiment_id}&start_position={$start_position}&count={$count}\n\n"); die(""); } $experiment->get_sample_information($sql); $regions = array(); $sample_list = ''; $query = "SELECT v from constants WHERE k='mask_time={$experiment_id}'"; $sql->get_row($query, $res); $mask_time = 0; if (sizeof($res) > 0) { $mask_time = $res[0][0]; } //die($mask_time); for ($i = $start_position; $i < $start_position + $count && $i < sizeof($experiment->samples); $i++) { $sample_list .= $experiment->samples[$i]->id() . "o"; $query = "SELECT id,name,details,censored,reason_censored,strain,{$video_column}, time_at_which_animals_had_zero_age, time_of_last_valid_sample,strain_condition_1,strain_condition_2 FROM sample_region_image_info WHERE sample_id = " . $experiment->samples[$i]->id() . " ORDER BY name"; $region_info_data_column_size = 11; $reg =& $regions[$experiment->samples[$i]->id()]; $sql->get_row($query, $reg);