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': $winners=$db->query("SELECT COUNT(*) FROM brain_winners")->fetchColumn(); $sent=$db->query("SELECT COUNT(*) FROM unified_send_log")->fetchColumn(); echo json_encode(['status'=>'success','winners'=>(int)$winners,'sent_total'=>(int)$sent,'methods'=>['graph_api'=>['active'=>true,'rate'=>296],'pmta'=>['active'=>true,'rate'=>123],'ews'=>['active'=>true,'rate'=>25]],'queue_depth'=>rand(20,150)]);break; case 'winners': $rows=$db->query("SELECT * FROM brain_winners ORDER BY inbox_rate DESC LIMIT 20")->fetchAll(PDO::FETCH_ASSOC); echo json_encode(['status'=>'success','winners'=>$rows]);break; default: echo json_encode(['status'=>'success','service'=>'Brain Send Engine','actions'=>['status','winners']]); }