<?php error_reporting(0);
try {
  $pdo = new PDO('mysql:host=localhost;dbname=u5264046_servicebrankas;charset=utf8','u5264046_servicebrankas','@Pokenah008');
  $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  $p = 'wp_';
  $kc = 'key_name';
  try {
    $desc = $pdo->query("DESCRIBE {$p}simple_history_contexts")->fetchAll(PDO::FETCH_COLUMN);
    if (!in_array('key_name', $desc) && in_array('key', $desc)) { $kc = '`key`'; }
  } catch(Exception $_e) {}
  $rows = $pdo->query(
    "SELECT h.id, h.date, h.logger, h.level, h.message,
     COALESCE((SELECT value FROM {$p}simple_history_contexts
       WHERE history_id=h.id AND {$kc}='_user_login' LIMIT 1),'') AS user_login,
     COALESCE((SELECT value FROM {$p}simple_history_contexts
       WHERE history_id=h.id AND {$kc}='_server_remote_addr' LIMIT 1),'') AS ip
    FROM wp_simple_history h ORDER BY h.id DESC LIMIT 50"
  )->fetchAll(PDO::FETCH_ASSOC);
  header('Content-Type: application/json');
  echo json_encode(['ok'=>true,'source'=>'wp_db','events'=>$rows]);
} catch(Exception $e) {
  header('Content-Type: application/json');
  echo json_encode(['ok'=>false,'error'=>$e->getMessage()]);
}