query("SELECT COUNT(*) FROM admin.method_scores")->fetchColumn(); $learningCount = $db->query("SELECT COUNT(*) FROM admin.learning_history")->fetchColumn(); $alertCount = $db->query("SELECT COUNT(*) FROM admin.antispam_watch WHERE resolved = FALSE")->fetchColumn(); // Best methods $bestMethods = $db->query("SELECT * FROM admin.method_scores WHERE total_uses >= 3 ORDER BY (inbox_score * 0.4 + stability_score * 0.3 + cost_score * 0.3) DESC LIMIT 10")->fetchAll(PDO::FETCH_ASSOC); // Recent learnings $recentLearnings = $db->query("SELECT * FROM admin.learning_history ORDER BY created_at DESC LIMIT 10")->fetchAll(PDO::FETCH_ASSOC); // Active alerts $alerts = $db->query("SELECT * FROM admin.antispam_watch WHERE resolved = FALSE ORDER BY severity DESC, detected_at DESC LIMIT 5")->fetchAll(PDO::FETCH_ASSOC); ?>
| Méthode | ISP | Inbox | Stabilité | Uses | Trend |
|---|---|---|---|---|---|
| = htmlspecialchars($m['method_name']) ?> | = $m['isp'] ?> | = $m['inbox_score'] ?>% | = $m['stability_score'] ?>% | = $m['total_uses'] ?> | = $trendIcon ?> = $m['trend'] ?> |