exec("SET search_path TO admin");
$_total=(int)$_db->query("SELECT COUNT(*) FROM brain_send_configs")->fetchColumn();
$_tested=(int)$_db->query("SELECT COUNT(*) FROM brain_send_configs WHERE total_sent>0")->fetchColumn();
$_winners=(int)$_db->query("SELECT COUNT(*) FROM brain_send_configs WHERE inbox_rate>70 AND total_sent>0")->fetchColumn();
$_methods=$_db->query("SELECT send_method, COUNT(*) as cnt, ROUND(AVG(NULLIF(inbox_rate,0))::numeric,1) as avg_inbox, SUM(total_sent) as total_sent FROM brain_send_configs GROUP BY send_method ORDER BY cnt DESC")->fetchAll(PDO::FETCH_ASSOC);
$_isps=$_db->query("SELECT isp_target as isp, COUNT(*) as cnt, ROUND(AVG(NULLIF(inbox_rate,0))::numeric,1) as avg_inbox, SUM(total_sent) as total_sent FROM brain_send_configs WHERE isp_target IS NOT NULL AND isp_target!='' GROUP BY isp_target ORDER BY cnt DESC LIMIT 12")->fetchAll(PDO::FETCH_ASSOC);
$_top=$_db->query("SELECT id, send_method, isp_target, from_domain, inbox_rate, total_sent, total_inbox, status FROM brain_send_configs WHERE total_sent>0 ORDER BY inbox_rate DESC LIMIT 10")->fetchAll(PDO::FETCH_ASSOC);
$_worst=$_db->query("SELECT id, send_method, isp_target, from_domain, inbox_rate, total_sent, status FROM brain_send_configs WHERE total_sent>0 AND inbox_rate<30 ORDER BY inbox_rate ASC LIMIT 5")->fetchAll(PDO::FETCH_ASSOC);
$_untested=(int)$_db->query("SELECT COUNT(*) FROM brain_send_configs WHERE status='untested' OR total_sent=0")->fetchColumn();
$_avgInbox=$_db->query("SELECT ROUND(AVG(NULLIF(inbox_rate,0))::numeric,1) FROM brain_send_configs WHERE total_sent>0")->fetchColumn();
$_totalSent=(int)$_db->query("SELECT COALESCE(SUM(total_sent),0) FROM brain_send_configs")->fetchColumn();
?>
WEVADS - Dark Slot