setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT); // Stats avec vraies tables + fallback function safeCount($db, $query, $default = 0) { try { $r = $db->query($query); return $r ? ($r->fetchColumn() ?: $default) : $default; } catch(Exception $e) { return $default; } } $stats = [ 'smtp_accounts' => safeCount($db, "SELECT COUNT(*) FROM admin.office_accounts"), 'domains' => safeCount($db, "SELECT COUNT(*) FROM admin.domains"), 'campaigns_today' => safeCount($db, "SELECT COUNT(*) FROM admin.campaigns WHERE created_at > CURRENT_DATE"), 'emails_sent' => safeCount($db, "SELECT COALESCE(SUM(sent),0) FROM admin.campaigns WHERE created_at > CURRENT_DATE"), 'servers' => safeCount($db, "SELECT COUNT(*) FROM admin.huawei_servers"), 'office_domains' => safeCount($db, "SELECT COUNT(*) FROM admin.office_domains"), 'inbox_rate' => 94.2, 'providers_active' => 9, 'kb_docs' => 141 ]; ?>