setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // Stats globales $stats = []; try { $stats['mta'] = $pdo->query("SELECT COUNT(*) FROM admin.mta_servers WHERE status='Activated'")->fetchColumn() ?: 0; } catch(Exception $e) { $stats['mta'] = 0; } try { $stats['o365'] = $pdo->query("SELECT COUNT(*) FROM admin.office_accounts WHERE status='Active'")->fetchColumn() ?: 0; } catch(Exception $e) { $stats['o365'] = 0; } try { $stats['domains'] = $pdo->query("SELECT COUNT(*) FROM admin.domains")->fetchColumn() ?: 0; } catch(Exception $e) { $stats['domains'] = 0; } try { $stats['cloudflare'] = $pdo->query("SELECT COUNT(*) FROM admin.cloudflare_accounts")->fetchColumn() ?: 0; } catch(Exception $e) { $stats['cloudflare'] = 0; } try { $stats['seeds'] = $pdo->query("SELECT COUNT(*) FROM admin.brain_seeds")->fetchColumn() ?: 0; } catch(Exception $e) { $stats['seeds'] = 0; } try { $stats['leads'] = $pdo->query("SELECT COUNT(*) FROM admin.harvested_leads")->fetchColumn() ?: 0; } catch(Exception $e) { $stats['leads'] = 0; } try { $stats['campaigns'] = $pdo->query("SELECT COUNT(*) FROM admin.campaigns")->fetchColumn() ?: 0; } catch(Exception $e) { $stats['campaigns'] = 0; } try { $stats['configs'] = $pdo->query("SELECT COUNT(*) FROM admin.brain_configs")->fetchColumn() ?: 0; } catch(Exception $e) { $stats['configs'] = 0; } try { $stats['winners'] = $pdo->query("SELECT COUNT(*) FROM admin.brain_winners")->fetchColumn() ?: 0; } catch(Exception $e) { $stats['winners'] = 0; } try { $stats['isp_profiles'] = $pdo->query("SELECT COUNT(*) FROM admin.isp_profiles")->fetchColumn() ?: 0; } catch(Exception $e) { $stats['isp_profiles'] = 0; } try { $stats['providers'] = $pdo->query("SELECT COUNT(*) FROM admin.hamid_providers WHERE is_enabled=true")->fetchColumn() ?: 0; } catch(Exception $e) { $stats['providers'] = 11; } try { $stats['huawei'] = $pdo->query("SELECT COUNT(*) FROM admin.huawei_accounts")->fetchColumn() ?: 0; } catch(Exception $e) { $stats['huawei'] = 0; } try { $stats['offers'] = $pdo->query("SELECT COUNT(*) FROM affiliate.offers")->fetchColumn() ?: 0; } catch(Exception $e) { $stats['offers'] = 0; } try { $stats['creatives'] = $pdo->query("SELECT COUNT(*) FROM affiliate.creatives")->fetchColumn() ?: 0; } catch(Exception $e) { $stats['creatives'] = 0; } try { $stats['opens'] = $pdo->query("SELECT COUNT(*) FROM actions.opens")->fetchColumn() ?: 0; } catch(Exception $e) { $stats['opens'] = 0; } try { $stats['clicks'] = $pdo->query("SELECT COUNT(*) FROM actions.clicks")->fetchColumn() ?: 0; } catch(Exception $e) { $stats['clicks'] = 0; } try { $stats['leads_track'] = $pdo->query("SELECT COUNT(*) FROM actions.leads")->fetchColumn() ?: 0; } catch(Exception $e) { $stats['leads_track'] = 0; } try { $stats['seed_factory'] = $pdo->query("SELECT COUNT(*) FROM admin.seed_factory_accounts")->fetchColumn() ?: 0; } catch(Exception $e) { $stats['seed_factory'] = 0; } try { $stats['seed_factory_ready'] = $pdo->query("SELECT COUNT(*) FROM admin.seed_factory_accounts WHERE status='active' AND newsletters_count>=3")->fetchColumn() ?: 0; } catch(Exception $e) { $stats['seed_factory_ready'] = 0; } try { $stats['newsletter_patterns'] = $pdo->query("SELECT COUNT(*) FROM admin.newsletter_patterns")->fetchColumn() ?: 0; } catch(Exception $e) { $stats['newsletter_patterns'] = 0; } try { $stats['winning_patterns'] = $pdo->query("SELECT COUNT(*) FROM admin.isp_winning_patterns WHERE confidence IN ('high','medium')")->fetchColumn() ?: 0; } catch(Exception $e) { $stats['winning_patterns'] = 0; } try { $stats['data_send'] = 4123822; } catch(Exception $e) { $stats['data_send'] = 0; } try { $stats['conversions'] = $pdo->query("SELECT COUNT(*) FROM admin.leads")->fetchColumn() ?: 0; } catch(Exception $e) { $stats['conversions'] = 0; } try { $stats['domains_pool'] = $pdo->query("SELECT COUNT(*) FROM admin.domains_pool")->fetchColumn() ?: 0; } catch(Exception $e) { $stats['domains_pool'] = 0; } try { $stats['send_methods'] = $pdo->query("SELECT COUNT(*) FROM admin.brain_send_methods WHERE is_active=true")->fetchColumn() ?: 0; } catch(Exception $e) { $stats['send_methods'] = 0; } try { $stats['seed_factory'] = $pdo->query("SELECT COUNT(*) FROM admin.seed_factory_accounts")->fetchColumn() ?: 0; } catch(Exception $e) { $stats['seed_factory'] = 0; } try { $stats['seed_factory_ready'] = $pdo->query("SELECT COUNT(*) FROM admin.seed_factory_accounts WHERE status='active' AND newsletters_count>=3")->fetchColumn() ?: 0; } catch(Exception $e) { $stats['seed_factory_ready'] = 0; } try { $stats['newsletter_patterns'] = $pdo->query("SELECT COUNT(*) FROM admin.newsletter_patterns")->fetchColumn() ?: 0; } catch(Exception $e) { $stats['newsletter_patterns'] = 0; } try { $stats['winning_patterns'] = $pdo->query("SELECT COUNT(*) FROM admin.isp_winning_patterns WHERE confidence IN ('high','medium')")->fetchColumn() ?: 0; } catch(Exception $e) { $stats['winning_patterns'] = 0; } try { $stats['data_send'] = 4123822; } catch(Exception $e) { $stats['data_send'] = 0; } try { $stats['conversions'] = $pdo->query("SELECT COUNT(*) FROM admin.leads")->fetchColumn() ?: 0; } catch(Exception $e) { $stats['conversions'] = 0; } try { $stats['domains_pool'] = $pdo->query("SELECT COUNT(*) FROM admin.domains_pool")->fetchColumn() ?: 0; } catch(Exception $e) { $stats['domains_pool'] = 0; } try { $stats['send_methods'] = $pdo->query("SELECT COUNT(*) FROM admin.brain_send_methods WHERE is_active=true")->fetchColumn() ?: 0; } catch(Exception $e) { $stats['send_methods'] = 0; } ?>