<?php
mysqli_report(MYSQLI_REPORT_OFF);
$site = $argv[1]; $full = ($argv[2] ?? '') === 'full';
$cfg = getenv('HOME')."/$site/wp-config.php";
$c = @file_get_contents($cfg);
if ($c === false) { echo "  PAS DE wp-config: $site\n"; exit(0); }
$g = function($k) use ($c) {
  return preg_match("/define\(\s*['\"]".$k."['\"]\s*,\s*['\"]([^'\"]*)['\"]/", $c, $m) ? $m[1] : '';
};
$p = preg_match('/\$table_prefix\s*=\s*[\'"]([^\'"]+)[\'"]/', $c, $m) ? $m[1] : 'wp_';
$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 "  ERREUR CONNEXION DB ($site)\n"; exit(0); }
echo "  [$site] prefix=$p db=".$g('DB_NAME')."\n";
$r = mysqli_query($db, "SELECT u.ID,u.user_login,u.user_email,u.user_registered FROM {$p}users u JOIN {$p}usermeta m ON m.user_id=u.ID WHERE m.meta_key='{$p}capabilities' AND m.meta_value LIKE '%administrator%' ORDER BY u.user_registered DESC");
echo "  admins:\n";
while ($r && $row = mysqli_fetch_row($r)) echo "    ".implode("\t",$row)."\n";
$r = mysqli_query($db, "SELECT COUNT(*) FROM {$p}users");
if ($r && $row = mysqli_fetch_row($r)) echo "  users_total=".$row[0]."\n";
if ($full) {
  echo "  active_plugins:\n";
  $r = mysqli_query($db, "SELECT option_value FROM {$p}options WHERE option_name='active_plugins'");
  if ($r && $row = mysqli_fetch_row($r)) print_r(@unserialize($row[0]));
}
mysqli_close($db);