<?php
$nodes = array();
$q = "SELECT nodes.*, jobname FROM nodes LEFT JOIN jobs ON current_job_id=jobs.id WHERE user_id='" . $m->escape_string($_SESSION["u"]->id) . "' ORDER BY nodes.dt_lastactive DESC";
if (($r = @$m->query($q)) !== FALSE) {
$nodes_count = $r->num_rows;
$nodes_timespent = 0;
while ($row = $r->fetch_object()) {
$q = "SELECT SUM(UNIX_TIMESTAMP(completed) - UNIX_TIMESTAMP(acquired)) AS timespent FROM packets WHERE node_id={$row->id} AND done=1 ORDER BY acquired DESC";
$r_ts = $m->query($q);
$packets_summary = $r_ts->fetch_object();
$r_ts->close();
$row->timespent = time_friendly($packets_summary->timespent);
if ($packets_summary->timespent != NULL) {
$nodes_timespent += $t;
}
$nodes[] = $row;
}
$r->close();
}
// Display diagnostic messages, if any
if (isset($_SESSION["info"])) {
$msg = $_SESSION["info"];
unset($_SESSION["info"]);
?>
<div class="info">
<p><?php
echo htmlspecialchars($msg);
?>
</p>
</div>
?>
</td>
<td><?php
echo htmlspecialchars($row->hashtype);
?>
</td>
<td><?php
echo htmlspecialchars($row->summary_numhashes);
?>
</td>
<td><?php
echo htmlspecialchars($row->summary_numcracked) . $cached_num_cracked_html . $percent_html;
?>
</td>
<td align="right"><?php
echo htmlspecialchars(time_friendly($total_std_cpu_time, TRUE));
?>
</td>
<td>
<?php
if (($row->jobflags & JOB_FLAG_ACTIVE) == JOB_FLAG_ACTIVE) {
echo '<span style="color:green">ACTIVE</span>';
} else {
if (($row->jobflags & JOB_FLAG_DONE) == JOB_FLAG_DONE) {
echo '<strong>DONE</strong>';
} else {
echo '<span style="color:red">PAUSED</span>';
}
}
?>
</td>
<td><?php
echo "{$job->summary_numcracked} / {$job->summary_numhashes}";
?>
</td>
<td><?php
echo date_friendly($job->dt_lastactive);
?>
</td>
<td>
<?php
echo time_friendly($total_timespent);
?>
<br />
Std CPU: <?php
echo time_friendly($total_std_cpu_time);
?>
</td>
<td>
<?php
if (($job->jobflags & JOB_FLAG_ACTIVE) == JOB_FLAG_ACTIVE) {
echo '<span style="color:green">ACTIVE</span>';
} else {
if (($job->jobflags & JOB_FLAG_DONE) != 0) {
echo '<strong>DONE</strong>';
} else {
echo '<span style="color:red">PAUSED</span>';
}
}
?>
</td>
