Gecko [ gabointernational.org ]

Name	Size	Permission	Date
.well-known	[ DIR ]	drwxr-xr-x	2026-05-11 00:39
administrator	[ DIR ]	drwxr-xr-x	2026-05-09 01:10
api	[ DIR ]	drwxr-xr-x	2026-05-09 01:10
cache	[ DIR ]	drwxr-xr-x	2026-05-11 00:39
cgi-bin	[ DIR ]	drwxr-xr-x	2026-05-16 17:16
cli	[ DIR ]	drwxr-xr-x	2026-05-14 22:32
components	[ DIR ]	drwxr-xr-x	2026-05-09 01:10
docs	[ DIR ]	drwxr-xr-x	2026-05-11 00:39
files	[ DIR ]	drwxr-xr-x	2026-05-09 01:10
images	[ DIR ]	drwxr-xr-x	2026-05-11 00:37
includes	[ DIR ]	drwxr-xr-x	2026-05-11 00:37
install_fragments	[ DIR ]	drwxr-xr-x	2026-05-11 00:39
language	[ DIR ]	drwxr-xr-x	2026-05-09 01:10
layouts	[ DIR ]	drwxr-xr-x	2026-05-09 01:10
libraries	[ DIR ]	drwxr-xr-x	2026-05-09 01:10
media	[ DIR ]	drwxr-xr-x	2026-05-09 01:10
modules	[ DIR ]	drwxr-xr-x	2026-05-09 01:10
plugins	[ DIR ]	drwxr-xr-x	2026-05-09 01:10
templates	[ DIR ]	drwxr-xr-x	2026-05-09 01:10
tmp	[ DIR ]	drwxr-xr-x	2026-05-17 05:00
tools	[ DIR ]	drwxr-xr-x	2026-05-11 00:39
.htaccess	1.99 KB	-r--r--r--	2026-05-11 00:37
LICENSE.txt	17.67 KB	-rw-r--r--	2026-05-01 04:20
README.txt	5.53 KB	-rw-r--r--	2026-05-01 04:20
admin.php	496.7 KB	-rw-r--r--	2026-05-09 02:48
build_site.php	43.61 KB	-rw-r--r--	2026-05-05 16:05
bump_media.php	912 B	-rw-r--r--	2026-05-02 02:24
configuration.bak.php	2.88 KB	-rw-r--r--	2026-05-06 01:57
configuration.php	4.04 KB	-rw-r--r--	2026-05-06 01:57
debug_all_images.php	1.58 KB	-rw-r--r--	2026-05-02 01:52
debug_assets_table.php	1.85 KB	-rw-r--r--	2026-05-02 01:52
debug_compare.php	2.14 KB	-rw-r--r--	2026-05-02 01:52
debug_css.php	1.8 KB	-rw-r--r--	2026-05-02 01:52
debug_ext.php	1.52 KB	-rw-r--r--	2026-05-02 01:52
debug_hero.php	1.49 KB	-rw-r--r--	2026-05-02 01:52
debug_version.php	1.93 KB	-rw-r--r--	2026-05-02 01:52
debug_wa.php	766 B	-rw-r--r--	2026-05-02 01:52
ensure_ng_about_article.php	12.13 KB	-rw-r--r--	2026-05-03 18:45
ensure_ng_footer_modules.php	5.51 KB	-rw-r--r--	2026-05-05 16:09
ensure_ng_leadership_module.php	2.29 KB	-rw-r--r--	2026-05-05 14:15
ensure_ng_team_module.php	3.19 KB	-rw-r--r--	2026-05-05 15:29
fix_age_cards.php	2.9 KB	-rw-r--r--	2026-05-02 02:55
fix_age_cards2.php	4.61 KB	-rw-r--r--	2026-05-05 14:54
fix_assets.php	2.37 KB	-rw-r--r--	2026-05-02 01:52
fix_hero_images.php	1.73 KB	-rw-r--r--	2026-05-02 01:52
fix_menu_module.php	3.7 KB	-rw-r--r--	2026-05-02 02:05
fix_ng_phone_placeholders.php	5.12 KB	-rw-r--r--	2026-05-03 23:19
fix_services_age.php	2.72 KB	-rw-r--r--	2026-05-02 02:45
fix_sidebar_menu.php	436 B	-rw-r--r--	2026-05-02 02:14
fix_template.php	3.35 KB	-rw-r--r--	2026-05-02 01:52
htaccess.txt	6.74 KB	-rw-r--r--	2026-05-01 04:20
index.php	22.65 KB	-r--r--r--	2026-05-11 00:37
patch_contacts_article_form.php	3.47 KB	-rw-r--r--	2026-05-05 16:09
patch_hero_fullbleed_slide.php	1.33 KB	-rw-r--r--	2026-05-03 06:14
revert_hero_fullbleed.php	1.2 KB	-rw-r--r--	2026-05-03 06:40
robots.txt	102 B	-rw-r--r--	2026-05-11 00:37
strip_ng_stats_from_custom_modules.php	3.23 KB	-rw-r--r--	2026-05-05 14:43
txets.php	5.12 KB	-r--r--r--	2026-05-09 01:10
update_age_images_nigeria.php	1.19 KB	-rw-r--r--	2026-05-02 03:03
web.config.txt	2.9 KB	-rw-r--r--	2026-05-01 04:20

Rename

<?php

/**
 * Removes US-style welcome counters (.rmh-stats) and legacy CEO stat rows
 * (.rmh-about-ceo-feature__stats) from site custom HTML modules.
 *
 * Run from Joomla root (folder containing configuration.php), same as ensure_ng_leadership_module.php:
 *
 *   php ng2/strip_ng_stats_from_custom_modules.php
 */

declare(strict_types=1);

require_once __DIR__ . '/configuration.php';

$config = new JConfig();
$conn = new mysqli($config->host, $config->user, $config->password, $config->db);
if ($conn->connect_error) {
    die('DB Connection Error: ' . $conn->connect_error . "\n");
}
$conn->set_charset('utf8mb4');
$p = $config->dbprefix;

$sql = "SELECT id, title, content FROM {$p}modules WHERE client_id = 0 AND module = 'mod_custom' AND published = 1
    AND (content LIKE '%rmh-stats%' OR content LIKE '%rmh-about-ceo-feature__stats%')";
$res = $conn->query($sql);
if ($res === false) {
    die('Query failed: ' . $conn->error . "\n");
}

$strip = static function (string $html): string {
    if (strpos($html, 'rmh-stats') === false && strpos($html, 'rmh-about-ceo-feature__stats') === false) {
        return $html;
    }

libxml_use_internal_errors(true);
    $dom = new DOMDocument();
    $wrapped = '<?xml encoding="UTF-8"><div id="rmh-strip-wrap">' . $html . '</div>';
    if (!@$dom->loadHTML($wrapped, LIBXML_HTML_NOIMPLIED | LIBXML_HTML_NODEFDTD)) {
        libxml_clear_errors();
        return $html;
    }

$xp = new DOMXPath($dom);
    $wrap = $dom->getElementById('rmh-strip-wrap');
    if (!$wrap) {
        libxml_clear_errors();
        return $html;
    }

$removeList = [];
    foreach ($xp->query('//*[@id="rmh-strip-wrap"]//*[contains(concat(" ", normalize-space(@class), " "), " rmh-stats ")]') as $node) {
        $removeList[] = $node;
    }
    foreach ($xp->query('//*[@id="rmh-strip-wrap"]//*[contains(concat(" ", normalize-space(@class), " "), " rmh-about-ceo-feature__stats ")]') as $node) {
        $removeList[] = $node;
    }
    foreach ($xp->query('//*[@id="rmh-strip-wrap"]//hr[contains(concat(" ", normalize-space(@class), " "), " rmh-about-ceo-feature__rule ")][following-sibling::*[1][contains(concat(" ", normalize-space(@class), " "), " rmh-about-ceo-feature__stats ")]]') as $node) {
        $removeList[] = $node;
    }

$seen = [];
    foreach ($removeList as $node) {
        $h = spl_object_hash($node);
        if (isset($seen[$h])) {
            continue;
        }
        $seen[$h] = true;
        if ($node->parentNode) {
            $node->parentNode->removeChild($node);
        }
    }

$out = '';
    foreach ($wrap->childNodes as $child) {
        $out .= $dom->saveHTML($child);
    }
    libxml_clear_errors();
    return $out;
};

$updated = 0;
while ($row = $res->fetch_assoc()) {
    $id = (int) $row['id'];
    $title = (string) $row['title'];
    $before = (string) $row['content'];
    $after = $strip($before);
    if ($after === $before) {
        continue;
    }
    $escaped = $conn->real_escape_string($after);
    $conn->query("UPDATE {$p}modules SET content = '{$escaped}' WHERE id = {$id}");
    echo "Updated module id={$id} title=\"{$title}\" (removed stats markup).\n";
    $updated++;
}

echo $updated === 0 ? "No modules needed changes (or none matched).\n" : "Done. Updated {$updated} module(s).\n";