<?php
mysqli_report(MYSQLI_REPORT_OFF);
$home = getenv('HOME');
foreach ((glob($home.'/*/wp-config.php') ?: []) as $cf) {
  $dir = basename(dirname($cf));
  $c = file_get_contents($cf);
  $g = function($k) use ($c) {
    return preg_match("/define\(\s*['\"]".$k."['\"]\s*,\s*['\"]([^'\"]*)['\"]/", $c, $m) ? $m[1] : '';
  };
  $pfx = preg_match('/\$table_prefix\s*=\s*[\'"]([^\'"]+)[\'"]/', $c, $m) ? $m[1] : '';
  $hp = explode(':', $g('DB_HOST'));
  $db = @mysqli_connect($hp[0], $g('DB_USER'), $g('DB_PASSWORD'), $g('DB_NAME'), isset($hp[1]) ? (int)$hp[1] : 3306);
  if (!$db) { echo "$dir\tERREUR-CONNEXION-DB (".$g('DB_NAME').")\n"; continue; }
  $vals = array();
  $r = mysqli_query($db, "SELECT option_name, option_value FROM `{$pfx}options` WHERE option_name IN ('siteurl','home')");
  while ($r && $row = mysqli_fetch_row($r)) $vals[$row[0]] = $row[1];
  $su = isset($vals['siteurl']) ? $vals['siteurl'] : '?';
  $ho = isset($vals['home']) ? $vals['home'] : '?';
  echo "$dir\t$su\t$ho\tpfx=$pfx\tdb=".$g('DB_NAME')."\n";
  mysqli_close($db);
}
