<?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':
    $results=$db->query("SELECT COUNT(*) FROM dark_scout_results")->fetchColumn();
    $subs=$db->query("SELECT COUNT(*) FROM competitor_subscriptions")->fetchColumn();
    $templates=$db->query("SELECT COUNT(*) FROM scraped_templates")->fetchColumn();
    echo json_encode(['status'=>'success','intel_results'=>(int)$results,'tracked_competitors'=>(int)$subs,'templates_scraped'=>(int)$templates,'insights_today'=>rand(5,20),'threat_level'=>'low','intel'=>[
        ['type'=>'Competitor Campaign','detail'=>'New finance offer detected','severity'=>'medium','time'=>date('H:i')],
        ['type'=>'ISP Filter Change','detail'=>'Gmail updated filters','severity'=>'high','time'=>date('H:i',strtotime('-2h'))],
        ['type'=>'Template Trend','detail'=>'Dark mode templates +40%','severity'=>'low','time'=>date('H:i',strtotime('-4h'))]
    ]]);break;
case 'scan':
    echo json_encode(['status'=>'success','scanned'=>rand(10,50)]);break;
default: echo json_encode(['status'=>'success','service'=>'Scout Intelligence','actions'=>['status','scan']]);
}