PDO::ERRMODE_EXCEPTION,PDO::ATTR_DEFAULT_FETCH_MODE=>PDO::FETCH_ASSOC]);$_db->exec("SET search_path TO admin,public");
$_total=(int)$_db->query("SELECT COUNT(*) FROM campaigns")->fetchColumn();
$_active=(int)$_db->query("SELECT COUNT(*) FROM campaigns WHERE status='active'")->fetchColumn();
$_sched=(int)$_db->query("SELECT COUNT(*) FROM scheduled_campaigns")->fetchColumn();
$_sends=(int)$_db->query("SELECT COUNT(*) FROM unified_send_log")->fetchColumn();
$_opens=(int)$_db->query("SELECT COUNT(*) FROM open_log")->fetchColumn();
$_clicks=(int)$_db->query("SELECT COUNT(*) FROM click_log")->fetchColumn();
$_convs=(int)$_db->query("SELECT COUNT(*) FROM conversion_log WHERE source='real'")->fetchColumn();
$_rev=(float)$_db->query("SELECT COALESCE(SUM(payout),0) FROM conversion_log WHERE source='real'")->fetchColumn();
$_camps=$_db->query("SELECT id,name,status,created_at FROM campaigns ORDER BY id DESC LIMIT 20")->fetchAll();
$_scheds=$_db->query("SELECT id,campaign_id,scheduled_at,status FROM scheduled_campaigns ORDER BY id DESC LIMIT 15")->fetchAll();
?>
WEVADS - Campaign Manager