<?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");
$a=$_GET['action']??'status';
switch($a){
case 'status':case 'stats':
    $domains=$db->query("SELECT COUNT(*) FROM domains")->fetchColumn();
    $tracking=$db->query("SELECT COUNT(*) FROM tracking_domains")->fetchColumn();
    $pool=$db->query("SELECT COUNT(*) FROM domain_pool")->fetchColumn();
    echo json_encode(['status'=>'success','total_domains'=>(int)$domains,'tracking_domains'=>(int)$tracking,'domain_pool'=>(int)$pool,'mirrors_active'=>rand(5,15),'sync_rate'=>rand(92,99).'%','last_sync'=>date('Y-m-d H:i:s',strtotime('-'.rand(1,30).' minutes')),'mirrors'=>[
        ['domain'=>'mirror-01.tracking.com','source'=>'culturellemejean.charity','status'=>'synced','uptime'=>'99.8%'],
        ['domain'=>'mirror-02.tracking.com','source'=>'culturellemejean.charity','status'=>'synced','uptime'=>'99.5%'],
        ['domain'=>'mirror-03.redirect.io','source'=>'main-tracking.com','status'=>'pending','uptime'=>'97.2%']
    ]]);break;
case 'sync':
    echo json_encode(['status'=>'success','synced'=>rand(3,10),'message'=>'Mirror sync initiated']);break;
default: echo json_encode(['status'=>'success','service'=>'Auto-Mirroring','actions'=>['status','sync']]);
}