exec("SET search_path TO admin");
$_dt=(int)$_db->query("SELECT COUNT(*) FROM dark_scout_targets")->fetchColumn();
$_dta=(int)$_db->query("SELECT COUNT(*) FROM dark_scout_targets WHERE status='active' OR status='completed'")->fetchColumn();
$_dr=(int)$_db->query("SELECT COUNT(*) FROM dark_scout_results")->fetchColumn();
$_relays=(int)$_db->query("SELECT COUNT(*) FROM dark_scout_results WHERE relay_open=true")->fetchColumn();
$_avgScore=$_db->query("SELECT ROUND(AVG(usability_score)::numeric,1) FROM dark_scout_results WHERE usability_score>0")->fetchColumn();
$_highScore=(int)$_db->query("SELECT COUNT(*) FROM dark_scout_results WHERE usability_score>70")->fetchColumn();
$_totalLeads=(int)$_db->query("SELECT COALESCE(SUM(leads_found),0) FROM dark_scout_targets")->fetchColumn();
$_totalRelays=(int)$_db->query("SELECT COALESCE(SUM(relays_found),0) FROM dark_scout_targets")->fetchColumn();
// Scan types breakdown
$_scanTypes=$_db->query("SELECT scan_type, COUNT(*) as cnt, ROUND(AVG(usability_score)::numeric,1) as avg_score FROM dark_scout_results GROUP BY scan_type ORDER BY cnt DESC")->fetchAll(PDO::FETCH_ASSOC);
// Results table
$_results=$_db->query("SELECT r.id, r.ip_address, r.hostname, r.port, r.protocol, r.relay_open, r.usability_score, r.scan_type, r.discovered_at, t.target FROM dark_scout_results r LEFT JOIN dark_scout_targets t ON r.target_id=t.id ORDER BY r.discovered_at DESC LIMIT 15")->fetchAll(PDO::FETCH_ASSOC);
// Targets table
$_targets=$_db->query("SELECT id, target, scan_type, relays_found, leads_found, status, created_at FROM dark_scout_targets ORDER BY created_at DESC")->fetchAll(PDO::FETCH_ASSOC);
?>