<?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>