PDO::ERRMODE_EXCEPTION,PDO::ATTR_DEFAULT_FETCH_MODE=>PDO::FETCH_ASSOC]);$_db->exec("SET search_path TO admin,public");
$_od=(int)$_db->query("SELECT COUNT(*) FROM office_domains")->fetchColumn();
$_odv=(int)$_db->query("SELECT COUNT(*) FROM office_domains WHERE verification_status='Verified'")->fetchColumn();
$_cf=(int)$_db->query("SELECT COUNT(*) FROM cloudflare_domains")->fetchColumn();
$_fd=(int)$_db->query("SELECT COUNT(*) FROM freedns_accounts")->fetchColumn();
$_td=(int)$_db->query("SELECT COUNT(*) FROM tracking_domains")->fetchColumn();
$_wd=(int)$_db->query("SELECT COUNT(*) FROM warmup_domains")->fetchColumn();
$_ptr=(int)$_db->query("SELECT COUNT(*) FROM ptr_records")->fetchColumn();
$_all=$_od+$_cf+$_fd;
$_office_doms=$_db->query("SELECT d.domain_name,d.verification_status,a.name as acc FROM office_domains d LEFT JOIN office_accounts a ON d.account_id=a.id ORDER BY d.verification_status DESC,d.domain_name LIMIT 40")->fetchAll();
$_cf_doms=$_db->query("SELECT domain,status,zone_id FROM cloudflare_domains ORDER BY domain LIMIT 20")->fetchAll();
$_fd_doms=$_db->query("SELECT username,status FROM freedns_accounts ORDER BY id DESC LIMIT 20")->fetchAll();
$_ptrs=$_db->query("SELECT ip_address,ptr_hostname,status FROM ptr_records ORDER BY id DESC LIMIT 20")->fetchAll();
?>
WEVADS - Domain Manager