<?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 id, date, logger, level, message FROM wp_simple_history ORDER BY id DESC LIMIT 200")->fetchAll(PDO::FETCH_ASSOC);
  if ($rows) {
    $ids = array_column($rows, 'id');
    $ph  = implode(',', array_fill(0, count($ids), '?'));
    $st  = $pdo->prepare("SELECT history_id, {$kc} AS k, value FROM {$p}simple_history_contexts WHERE history_id IN ($ph)");
    $st->execute($ids);
    $ctxMap = [];
    foreach ($st->fetchAll(PDO::FETCH_ASSOC) as $c) { $ctxMap[$c['history_id']][$c['k']] = $c['value']; }
    foreach ($rows as &$row) {
      $ctx = isset($ctxMap[$row['id']]) ? $ctxMap[$row['id']] : [];
      $msg = $row['message'];
      foreach ($ctx as $k => $v) { if ($k[0] !== '_') { $msg = str_replace('{' . $k . '}', $v, $msg); } }
      $row['message']    = $msg;
      $row['user_login'] = isset($ctx['_user_login']) ? $ctx['_user_login'] : '';
      $row['ip']         = isset($ctx['_server_remote_addr']) ? $ctx['_server_remote_addr'] : '';
    }
  }
  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()]);
}