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

/**
 * Replaces placeholder Nigeria phones and the old "Visit Us" short address in the DB
 * (template params, articles, modules, optional com_contact rows).
 *
 * Run from Joomla root (next to configuration.php):
 *   php fix_ng_phone_placeholders.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_errno) {
    fwrite(STDERR, "DB connect failed: {$conn->connect_error}\n");
    exit(1);
}
$conn->set_charset('utf8mb4');
$p = $config->dbprefix;

$phone1 = '09018642021';
$phone2 = '08105960922';
$addr   = '14, Ayorosiji Crescent, GRA Ikeja Lagos';

$oldDisplay = '+234-XXX-XXX-XXXX';
$oldTelHref = 'tel:+234XXXXXXXXXX';
$oldAnchor  = '<a href="tel:+234XXXXXXXXXX">+234-XXX-XXX-XXXX</a>';
$newPhonesHtml = '<a href="tel:+2349018642021">+234 901 864 2021</a><br><a href="tel:+2348105960922">+234 810 596 0922</a>';

echo "Updating template styles (wds-rmh)...\n";
$r = $conn->query("SELECT id, params FROM {$p}template_styles WHERE template='wds-rmh' AND client_id=0");
if ($r) {
    while ($row = $r->fetch_assoc()) {
        $j = json_decode((string) $row['params'], true);
        if (!\is_array($j)) {
            $j = [];
        }
        $j['phoneNumber']  = $phone1;
        $j['phoneNumber2'] = $phone2;
        if (empty($j['officeAddress']) || str_contains((string) ($j['officeAddress'] ?? ''), 'XXX')
            || ($j['officeAddress'] ?? '') === 'Lagos, Nigeria') {
            $j['officeAddress'] = $addr;
        }
        $new = json_encode($j, JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES);
        $esc = $conn->real_escape_string($new);
        $conn->query("UPDATE {$p}template_styles SET params='{$esc}' WHERE id=" . (int) $row['id']);
        echo "  template_styles id={$row['id']} rows=" . $conn->affected_rows . "\n";
    }
}

echo "Updating template extension params...\n";
$r2 = $conn->query("SELECT extension_id, params FROM {$p}extensions WHERE element='wds-rmh' AND type='template' AND client_id=0");
if ($r2) {
    while ($row = $r2->fetch_assoc()) {
        $j = json_decode((string) $row['params'], true);
        if (!\is_array($j)) {
            $j = [];
        }
        $j['phoneNumber']  = $phone1;
        $j['phoneNumber2'] = $phone2;
        if (empty($j['officeAddress']) || str_contains((string) ($j['officeAddress'] ?? ''), 'XXX')
            || ($j['officeAddress'] ?? '') === 'Lagos, Nigeria') {
            $j['officeAddress'] = $addr;
        }
        $new = json_encode($j, JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES);
        $esc = $conn->real_escape_string($new);
        $conn->query("UPDATE {$p}extensions SET params='{$esc}' WHERE extension_id=" . (int) $row['extension_id']);
        echo "  extensions extension_id={$row['extension_id']} rows=" . $conn->affected_rows . "\n";
    }
}

$patterns = [
    [$oldAnchor, $newPhonesHtml],
    [$oldDisplay, $phone1],
    ['+234XXXXXXXXXX', '09018642021'],
    ['<h3>Visit Us</h3><p>Lagos, Nigeria</p>', '<h3>Visit Us</h3><p>' . $addr . '</p>'],
];

echo "Replacing in #__content...\n";
foreach (['introtext', 'fulltext'] as $col) {
    foreach ($patterns as [$from, $to]) {
        $fromEsc = $conn->real_escape_string($from);
        $toEsc   = $conn->real_escape_string($to);
        $conn->query("UPDATE {$p}content SET `{$col}` = REPLACE(`{$col}`, '{$fromEsc}', '{$toEsc}')");
        if ($conn->affected_rows > 0) {
            echo "  content.{$col}: affected {$conn->affected_rows}\n";
        }
    }
}

echo "Replacing in #__modules (custom HTML)...\n";
foreach ($patterns as [$from, $to]) {
    $fromEsc = $conn->real_escape_string($from);
    $toEsc   = $conn->real_escape_string($to);
    $conn->query("UPDATE {$p}modules SET content = REPLACE(content, '{$fromEsc}', '{$toEsc}')");
    if ($conn->affected_rows > 0) {
        echo "  modules: affected {$conn->affected_rows}\n";
    }
}

echo "Updating #__contact_details address (if still 'Lagos, Nigeria')...\n";
$addrEsc = $conn->real_escape_string($addr);
$conn->query("UPDATE {$p}contact_details SET address = '{$addrEsc}' WHERE TRIM(address) = 'Lagos, Nigeria'");
if ($conn->affected_rows > 0) {
    echo "  contact_details.address rows=" . $conn->affected_rows . "\n";
}

echo "Updating #__contact_details telephone/mobile if placeholder...\n";
$conn->query("UPDATE {$p}contact_details SET telephone = '{$phone1}', mobile = '{$phone2}' WHERE telephone LIKE '%XXX%' OR telephone LIKE '%XXXX%'");
echo "  contact_details rows=" . $conn->affected_rows . "\n";

$cacheDirs = [__DIR__ . '/cache', __DIR__ . '/administrator/cache'];
foreach ($cacheDirs as $dir) {
    if (!is_dir($dir)) {
        continue;
    }
    $it = new RecursiveIteratorIterator(
        new RecursiveDirectoryIterator($dir, RecursiveDirectoryIterator::SKIP_DOTS),
        RecursiveIteratorIterator::CHILD_FIRST
    );
    foreach ($it as $file) {
        if ($file->isDir()) {
            @rmdir($file->getRealPath());
        } else {
            @unlink($file->getRealPath());
        }
    }
    echo "Cleared cache: {$dir}\n";
}

echo "Done. Reload the site; phones and Contact page Visit Us address should be correct.\n";