setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch (Exception $e) { die("DB: ".$e->getMessage()); } // Stats $stats = [ 'campaigns' => 0, 'sent' => 0, 'opens' => 0, 'clicks' => 0, 'servers' => 0, 'domains' => 0, 'o365' => 0 ]; try { $r = $pdo->query("SELECT COUNT(*) FROM admin.mta_servers WHERE status='Running'")->fetchColumn(); $stats['servers'] = $r ?: 0; } catch(Exception $e) {} try { $r = $pdo->query("SELECT COUNT(*) FROM admin.domains")->fetchColumn(); $stats['domains'] = $r ?: 0; } catch(Exception $e) {} try { $r = $pdo->query("SELECT COUNT(*) FROM admin.office_accounts")->fetchColumn(); $stats['o365'] = $r ?: 0; } catch(Exception $e) {} // Recent activity $activities = []; try { $stmt = $pdo->query("SELECT * FROM admin.mta_servers ORDER BY id DESC LIMIT 5"); $activities = $stmt->fetchAll(PDO::FETCH_ASSOC); } catch(Exception $e) {} ?>
Office 365 OAuth + PowerMTA
GSuite SMTP Relay
Direct SMTP