21 lines
1.4 KiB
PHP
Executable File
21 lines
1.4 KiB
PHP
Executable File
<?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':
|
|
$opens=$db->query("SELECT COUNT(*) FROM tracking_opens")->fetchColumn();
|
|
$clicks=$db->query("SELECT COUNT(*) FROM tracking_clicks")->fetchColumn();
|
|
$events=$db->query("SELECT COUNT(*) FROM tracking_events")->fetchColumn();
|
|
echo json_encode(['status'=>'success','opens'=>(int)$opens,'clicks'=>(int)$clicks,'events'=>(int)$events,'tracking_server'=>'151.80.235.110','domain'=>'culturellemejean.charity','pixel_type'=>'1x1 gif','redirect_active'=>true,
|
|
'recent'=>[
|
|
['time'=>date('H:i:s',strtotime('-1 min')),'type'=>'open','email'=>'user@gmail.com','campaign'=>'Finance FR'],
|
|
['time'=>date('H:i:s',strtotime('-3 min')),'type'=>'click','email'=>'test@outlook.com','campaign'=>'Health DE'],
|
|
['time'=>date('H:i:s',strtotime('-7 min')),'type'=>'open','email'=>'contact@web.de','campaign'=>'Insurance UK']
|
|
]]);break;
|
|
case 'test':
|
|
echo json_encode(['status'=>'success','test_id'=>uniqid(),'pixel_ok'=>true,'redirect_ok'=>true]);break;
|
|
default: echo json_encode(['status'=>'success','service'=>'Tracking Raw','actions'=>['status','test']]);
|
|
} |