get_results($wpdb->prepare( "SELECT botkey, verdict, SUM(hits) h FROM %i WHERE kind='bot' AND day >= %s GROUP BY botkey, verdict", $t, $since )); $by = array(); $tot = array('verified' => 0, 'fake' => 0, 'unverifiable' => 0, 'hidden' => 0); foreach ($rows as $r) { $by[$r->botkey][$r->verdict] = (int) $r->h; $tot[$r->verdict] = ($tot[$r->verdict] ?? 0) + (int) $r->h; } uasort($by, function ($a, $b) { return array_sum($b) <=> array_sum($a); }); $pages = $wpdb->get_results($wpdb->prepare( "SELECT path, SUM(hits) h FROM %i WHERE kind='bot' AND verdict='verified' AND day >= %s GROUP BY path ORDER BY h DESC LIMIT 15", $t, $since )); $refs = $wpdb->get_results($wpdb->prepare( "SELECT botkey, SUM(hits) h FROM %i WHERE kind='ref' AND day >= %s GROUP BY botkey ORDER BY h DESC", $t, $since )); $agents = $wpdb->get_results($wpdb->prepare( "SELECT botkey, verdict, SUM(hits) h FROM %i WHERE kind='agent' AND day >= %s GROUP BY botkey, verdict ORDER BY h DESC", $t, $since )); // phpcs:enable WordPress.DB.DirectDatabaseQuery $checkable = $tot['verified'] + $tot['fake']; ?>

array($tot['verified'], '#047857'), __('Fake (spoofed)', 'botledger') => array($tot['fake'], '#c81e1e'), __("Can't verify", 'botledger') => array($tot['unverifiable'] + $tot['hidden'], '#555'), ); foreach ($cards as $label => $c) : ?>

' . (int) round(100 * $tot['fake'] / $checkable) . '%' )); ?>

$v) : $b = $names[$slug] ?? null; ?>

path); ?>h)); ?>

botkey); ?>h)); ?>

__('Valid signature', 'botledger'), 'invalid' => __('Invalid signature', 'botledger'), 'nokey' => __('Key not found', 'botledger'), 'unsupported' => __('Unsupported algorithm', 'botledger'), ); foreach ($agents as $a) : ?>
botkey); ?> verdict] ?? $a->verdict); ?> h)); ?>

botledger.website' )); ?>