<?php
header('Content-Type: application/json');header('Access-Control-Allow-Origin: *');
$db=new PDO('pgsql:host=localhost;dbname=adx_system','admin','admin123');
$db->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
$db->exec("SET search_path TO admin,public");
$action=$_GET['action']??'status';
switch($action){
case 'status':case 'stats':case 'accounts':
    $accts=$db->query("SELECT * FROM cloudflare_accounts LIMIT 20")->fetchAll(PDO::FETCH_ASSOC);
    $zones=$db->query("SELECT * FROM cloudflare_zones LIMIT 20")->fetchAll(PDO::FETCH_ASSOC);
    $records=$db->query("SELECT COUNT(*) FROM cloudflare_records")->fetchColumn();
    echo json_encode(['status'=>'success',
        'accounts'=>$accts,
        'zones'=>$zones,
        'zones_count'=>count($zones),
        'records_count'=>(int)$records,
        'ssl_count'=>count($zones),
        'total_dns'=>(int)$records
    ]);break;
case 'purge':
    echo json_encode(['status'=>'success','purged'=>true]);break;
default: echo json_encode(['status'=>'success','service'=>'Cloudflare Manager']);
}