PDO::ERRMODE_EXCEPTION,PDO::ATTR_DEFAULT_FETCH_MODE=>PDO::FETCH_ASSOC]);$_db->exec("SET search_path TO admin,public");
$_inbox=(int)$_db->query("SELECT COUNT(*) FROM graph_inbox_results")->fetchColumn();
$_seeds=(int)$_db->query("SELECT COUNT(*) FROM seed_accounts")->fetchColumn();
$_sboxes=(int)$_db->query("SELECT COUNT(*) FROM seed_boxes")->fetchColumn();
$_inbox_ok=(int)$_db->query("SELECT COUNT(*) FROM graph_inbox_results WHERE result ILIKE '%inbox%'")->fetchColumn();
$_inbox_spam=(int)$_db->query("SELECT COUNT(*) FROM graph_inbox_results WHERE result ILIKE '%spam%' OR result ILIKE '%junk%'")->fetchColumn();
$_rate=$_inbox>0?round($_inbox_ok/$_inbox*100,1):0;
$_recent=$_db->query("SELECT id,send_log_id as config_id,checker_email as isp,result,checked_at FROM graph_inbox_results ORDER BY id DESC LIMIT 30")->fetchAll();
$_by_isp=$_db->query("SELECT COALESCE(SPLIT_PART(checker_email,'@',2),'unknown') as isp,COUNT(*) as total,SUM(CASE WHEN result ILIKE '%inbox%' THEN 1 ELSE 0 END) as inbox_cnt FROM graph_inbox_results GROUP BY 1 ORDER BY total DESC LIMIT 15")->fetchAll();
?>
WEVADS - Inbox Tester