Diagnosis — nothing was changed

2026-11-13 17:19:49 · host new.adminsilver.com

Constants

miss	api/_api_inc.php : BASE_URL	not defined here
info	config.php : SUPERADMIN_DOMAIN	currently https://new.adminsilver.com
skip	config.php : SUPERADMIN_DOMAIN	already points at this host

Re-run with ?apply=1 to write the fix. Both files are backed up first.

Source I need for the UK / USA selector on reviews

Press the button and paste the result back in chat.

===== admin/_layout.php :: all_sites() =====
function all_sites() {
    static $s = null;
    if ($s === null) $s = db()->query("SELECT id, domain, company_name, is_active, jurisdiction FROM sites ORDER BY jurisdiction, company_name")->fetchAll();
    return $s;
}

===== admin/_layout.php :: site_checkboxes() =====
function site_checkboxes(array $checked, $name = 'sites') {
    $sites = all_sites();
    if (!$sites) {
        echo '<div class="flash error" style="margin-top:12px">There are no sites yet. <a href="site_form.php">Add the first site</a>.</div>';
        return;
    }

    // Split the satellites by jurisdiction so a UK review is never ticked onto
    // a US site by accident. Sites with no jurisdiction set count as UK.
    $groups = ['uk' => ['United Kingdom', []], 'us' => ['United States', []]];
    foreach ($sites as $s) {
        $j = (($s['jurisdiction'] ?? 'uk') === 'us') ? 'us' : 'uk';
        $groups[$j][1][] = $s;
    }
    ?>
    <div style="display:flex;gap:10px;margin:12px 0 4px;flex-wrap:wrap">
      <button type="button" class="btn small secondary" onclick="satTick(this,'all',true)">Tick all</button>
      <button type="button" class="btn small secondary" onclick="satTick(this,'all',false)">Untick all</button>
    </div>
    <script>
    if (typeof satTick !== 'function') {
      function satTick(el, jur, on) {
        var root = el.closest('.sitegroups') || document;
        var sel  = (jur === 'all') ? '.sitechecks input' : '.sitechecks input[data-jur="' + jur + '"]';
        root.querySelectorAll(sel).forEach(function (c) { c.checked = on; });
      }
    }
    </script>
    <div class="sitegroups">
      <?php foreach ($groups as $code => $g): if (!$g[1]) continue; ?>
      <div style="margin-top:14px">
        <div style="display:flex;align-items:center;gap:10px;flex-wrap:wrap">
          <strong><?= h($g[0]) ?></strong>
          <span class="muted" style="font-size:12px"><?= count($g[1]) ?> site<?= count($g[1]) === 1 ? '' : 's' ?></span>
          <button type="button" class="btn small secondary" onclick="satTick(this,'<?= $code ?>',true)">Tick these</button>
          <button type="button" class="btn small secondary" onclick="satTick(this,'<?= $code ?>',false)">Untick these</button>
        </div>
        <div class="sitechecks">
          <?php foreach ($g[1] as $s): ?>
          <label>
            <input type="checkbox" name="<?= h($name) ?>[]" value="<?= (int)$s['id'] ?>" data-jur="<?= $code ?>" <?= in_array((int)$s['id'], $checked, true) ? 'checked' : '' ?>>
            <span><?= h($s['company_name']) ?>
              <span class="dom"><?= h($s['domain']) ?><?= $s['is_active'] ? '' : ' (disabled)' ?></span>
            </span>
          </label>
          <?php endforeach; ?>
        </div>
      </div>
      <?php endforeach; ?>
    </div>
    <?php
}

===== admin/reviews.php :: filter bar =====
       $map[(int)$r['review_id']][] = $r['company_name'];
    }
}

$pending = (int)db()->query("SELECT COUNT(*) c FROM reviews WHERE is_approved = 0")->fetch()['c'];

admin_head('Reviews');
admin_topbar('Reviews', '<a href="review_form.php" class="btn">+ Add review</a>');
?>
<div class="card">
  <form method="get" class="filters">
    <select name="jur" onchange="this.form.submit()">
      <option value="">All countries</option>
      <option value="uk" <?= $jur === 'uk' ? 'selected' : '' ?>>United Kingdom</option>
      <option value="us" <?= $jur === 'us' ? 'selected' : '' ?>>United States</option>
    </select>
    <select name="site" onchange="this.form.submit()">
      <option value="">All sites</option>
      <?php foreach (all_sites() as $s): ?>
        <option value="<?= (int)$s['id'] ?>" <?= $siteId === (int)$s['id'] ? 'selected' : '' ?>><?= h($s['company_name']) ?></option>
      <?php endforeach; ?>
    </select>
    <?php if ($pending): ?><span class="muted"><?= $pending ?> pending across the platform</span><?php endif; ?>
    <noscript><button class="btn small" type="submit">Filter</button></noscript>
  </form>

  <table>
    <tr><th>Date</th><th>Author</th><th>Rating</th><th>Content</th><th>Shown on</th><th>Status</th><th></th></tr>
    <?php foreach ($reviews as $r

Delete this file, check-site.php, fix-api-db.php and patch-jurisdiction.php from the server when we are done.