$event_id = $query_string['event_id']; $region_id = $query_string['region_id']; $sample_id = $query_string['sample_id']; $experiment_id = $query_string['experiment_id']; $show_errors = $query_string['show_errors']; $start_time = $query_string['start_time']; $limit = $query_string['limit']; if ($_POST['jump_to_time'] != '') { $query = "SELECT UNIX_TIMESTAMP('" . $_POST['jump_year'] . "-" . $_POST['jump_month'] . "-" . $_POST['jump_day'] . " 23:59:59Ab')"; $sql->get_row($query, $res); $start_time = $res[0][0]; header("Location: view_hosts_log.php?host_id={$host_id}&start_time=" . $start_time . "&limit=" . $limit . "\n\n"); die(""); } if ($start_time == 0) { $start_time = ns_current_time(); } ns_expand_unix_timestamp($start_time, $cur_min, $cur_hour, $cur_day, $cur_month, $cur_year); if ($query_string['delete_before'] != '' && $query_string['delete_before'] != 0) { $query = "DELETE FROM host_event_log WHERE host_id='{$host_id}' AND time <= " . $query_string['delete_before']; $sql->send_query($query); } $samples = array(); if ($experiment_id != '') { $query = "SELECT id FROM capture_samples WHERE experiment_id = {$experiment_id}"; $sql->get_row($query, $res); for ($i = 0; $i < sizeof($res); $i++) { array_push($samples, $res[$i][0]); } } if ($sample_id != '' && $sample_id != "all") {
<input name="device_name" type="hidden" value="all"> </form> <form action="view_hosts_and_devices.php" method="post"> <table bgcolor="#555555" cellspacing='0' cellpadding='1'><tr><td> <table cellspacing='0' cellpadding='3' > <tr <?php echo $table_header_color; ?> ><td>Host Name</td> <td>Version</td> <td>IP Address</td> <td>Last Ping</td> <td>Comments</td> <td> </td></tr> <?php $cur_time = ns_current_time(); $k = 0; foreach ($base_hosts as $base_host_name => $host) { for ($i = 0; $i < sizeof($host); $i++) { $clrs = $table_colors[$k % 2]; $edit_host = $host_id == $host[$i][0]; echo "<tr><td bgcolor=\"{$clrs['0']}\">"; $current = $cur_time - $host[$i][3] < $current_device_cutoff; if ($current) { echo "<b>"; } if ($highlight_host_id == $host[$i][0]) { echo "<i>"; } echo $host[$i][1]; if ($host[$i][10] == "1") {
$query .= 'problem=0'; } else { if ($sample_action == 'clear_busy') { $query .= 'currently_being_processed=0'; } else { throw new ns_exception("Unknown sample action: {$sample_action}"); } } $query .= " WHERE sample_id={$sample_id}"; //die($query); $sql->send_query($query); $sample_id = 0; $refresh_page = TRUE; } if ($sample_id != 0 && $_POST['cancel_pending_scans'] != '') { $query = "DELETE FROM capture_schedule WHERE sample_id = {$sample_id} AND time_at_start='0' AND missed='0' AND time_at_start='0' AND scheduled_time > " . ns_current_time(); $sql->send_query($query); header("Location: manage_samples.php?experiment_id={$experiment_id}&{$region_job_query_string}#{$sample_id}\n\n"); die(""); } if ($sample_id != 0 && $_POST['censor_sample'] != '') { $query = "UPDATE capture_samples SET censored=1 WHERE id=" . $sample_id; $sql->send_query($query); header("Location: manage_samples.php?experiment_id={$experiment_id}&{$region_job_query_string}#{$sample_id}\n\n"); die(""); } if ($sample_id != 0 && $_POST['uncensor_sample'] != '') { $query = "UPDATE capture_samples SET censored=0 WHERE id=" . $sample_id; $sql->send_query($query); header("Location: manage_samples.php?experiment_id={$experiment_id}&{$region_job_query_string}#{$sample_id}\n\n"); die("");
if (!$live_dangerously) { throw new ns_exception("I can't let you do that Dave! (Enable dangerous operations to continue)"); } for ($i = 0; $i < sizeof($samples_to_process); $i++) { $query = "SELECT id FROM sample_region_image_info WHERE sample_id = " . $samples_to_process[$i]; //echo $query . "<BR>"; $sql->get_row($query, $sample_regions[$i]); } $sql->send_query($lock_jobs_query, TRUE); for ($i = 0; $i < sizeof($samples_to_process); $i++) { if ($delete_files_from_disk) { //make a processing job for the sample--this will allow us to delete all temprary data later on. $job = new ns_processing_job(); $job->id = 0; $job->maintenance_task = $ns_maintenance_tasks['ns_maintenance_delete_files_from_disk_request']; $job->time_submited = ns_current_time(); for ($d = 0; $d < sizeof($file_deletion_job->operations); $d++) { $job->operations[$d] = 0; } if ($delete_sample_images != '') { $job->sample_id = $samples_to_process[$i]; $job->save_to_db($sql); // ns_delete_sample_from_database($samples_to_process[$i],$sql); } else { if ($clear_region != '') { for ($b = 0; $b < sizeof($sample_regions[$i]); $b++) { $file_deletion_job = clone $job; $file_deletion_job->region_id = $sample_regions[$i][$b][0]; $file_deletion_job->save_to_db($sql); ns_delete_region_from_database($sample_regions[$i][$b][0], $sql); }
<?php class ns_stat { public $mean, $var, $count; } require_once "worm_environment.php"; require_once "ns_processing_job.php"; display_worm_page_header("Cluster Throughput Statistics"); $query = "SELECT id, name, last_ping,software_version_major,software_version_minor,software_version_compile FROM hosts WHERE last_ping > " . ns_current_time() . " - 600 ORDER BY name"; $sql->get_row($query, $hosts); $stats = array(); for ($i = 0; $i < sizeof($hosts); $i++) { $query = "SELECT operation,mean,variance,count FROM performance_statistics WHERE host_id = " . $hosts[$i][0] . " ORDER BY operation"; $sql->get_row($query, $stats[$i]); } $host_stats = array(); $host_total_stats = array(); for ($i = 0; $i < sizeof($hosts); $i++) { $host_stats[$i] = array(); for ($j = 0; $j < sizeof($stats[$i]); $j++) { $host_stats[$i][(int) $stats[$i][$j][0]] = new ns_stat(); $host_stats[$i][(int) $stats[$i][$j][0]]->mean = $stats[$i][$j][1]; $host_stats[$i][(int) $stats[$i][$j][0]]->var = $stats[$i][$j][2]; $host_stats[$i][(int) $stats[$i][$j][0]]->count = $stats[$i][$j][3]; } } //var_dump($host_stats[0]); $operations_specified = array(); foreach ($stats as $s) { foreach ($s as $sa) {
$device_index[$devices[$i][0]] = $i; $schedule_future[$i] = array(); $schedule_past[$i] = array(); } $number_past = @(int) $query_string['number_past']; if (!isset($query_string['number_past'])) { $number_past = 5; } $number_future = @(int) $query_string['number_future']; if (!isset($query_string['number_future'])) { $number_future = 5; } $query = "SELECT c.scheduled_time, c.time_at_start, c.time_at_finish, s.experiment_id, c.sample_id, s.name, c.problem, c.captured_image_id, s.device_name, c.missed,c.transferred_to_long_term_storage FROM capture_schedule as c, capture_samples as s WHERE c.sample_id = s.id"; $query .= " AND (c.time_at_start != 0 || c.censored=0)"; $query_future = $query . " AND c.scheduled_time >= " . ns_current_time() . " ORDER BY c.scheduled_time ASC LIMIT " . sizeof($devices) * $number_future; $query_past = $query . " AND c.scheduled_time <= " . ns_current_time() . " ORDER BY c.scheduled_time DESC LIMIT " . sizeof($devices) * $number_past; // echo $query_past . "<br>"; // flush(); // ob_flush(); $sql->get_row($query_future, $fut); $sql->get_row($query_past, $past); foreach ($fut as &$f) { $schedule_future[$device_index[$f[8]]] = array(); } foreach ($past as &$f) { $schedule_past[$device_index[$f[8]]] = array(); } foreach ($fut as &$f) { array_push($schedule_future[$device_index[$f[8]]], $f); } foreach ($past as &$f) {
function ns_delete_images_from_database($experiment_id, $sample_id, $region_id, $image_id, $sql) { global $ns_maintenance_tasks; global $ns_maintenance_flags; $job = new ns_processing_job(); $job->maintenance_task = $ns_maintenance_tasks['ns_maintenance_delete_images_from_database']; $job->experiment_id = $experiment_id; $job->sample_id = $sample_id; $job->region_id = $region_id; $job->image_id = $image_id; $job->urgent = 2; $job->time_submitted = ns_current_time(); if ($experiment_id == 0 && $sample_id == 0 && $region_id != 0 && $image_id == 0) { // die("WHOOP!"); $job->maintenance_flag = $ns_maintenance_flags['ns_delete_entire_sample_region']; } $job->save_to_db($sql); ns_update_job_queue($sql); }
} ?> </font></center></td> <td bgcolor="<?php echo $table_colors[$c][1]; ?> "><center><font size="-1"> <?php if ($images[$i][7] == '1') { echo $images[$i][9] . 'x' . $images[$i][8]; } ?> </font></center></td> </tr> <?php } ?> </table> </table> <?php $offset = $stop_time - $start_time; $forward = $stop_time + $offset; echo "<a href=\"ns_view_sample_images.php?experiment_id=" . (int) $experiment_id . "&all_running_experiments=" . (int) $all_running_experiments . "&sample_id=" . (int) $sample_id . "&start_time=" . (int) ($start_time - $offset) . "&stop_time=" . (int) ($stop_time - $offset) . "\">[Earlier Time Points]</a>"; echo "<a href=\"ns_view_sample_images.php?experiment_id=" . (int) $experiment_id . "&all_running_experiments=" . (int) $all_running_experiments . "&sample_id=" . (int) $sample_id . "&start_time=" . (int) (ns_current_time() - 365 * 24 * 60 * 60) . "&stop_time=\">[View All Time Points]</a>"; } ?> <?php display_worm_page_footer(); ?>