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

/**
 * Fixes "Who We Serve" on Our Therapy Services: adds rmh-age-card__image + __body
 * and uses /images/home-services/ assets (same as homepage services grid).
 *
 * Run from Joomla root (folder with configuration.php):
 *   php ng2/fix_age_cards2.php
 */

declare(strict_types=1);

require_once __DIR__ . '/configuration.php';

function therapy_site_base(JConfig $config): string
{
    $default = '/joomla/ng2';
    $live = isset($config->live_site) ? trim((string) $config->live_site) : '';
    if ($live === '') {
        return $default;
    }
    $path = parse_url($live, PHP_URL_PATH);
    if (is_string($path) && $path !== '' && $path !== '/') {
        return rtrim($path, '/');
    }

// live_site set but path is empty or "/" (e.g. http://localhost) — use same default as build_site.php
    return $default;
}

$config = new JConfig();
$base = therapy_site_base($config);
$imgVer = 'ngpeople1';

$newAgeSection = <<<HTML
<div class="rmh-age-groups">
        <div class="rmh-age-card">
            <div class="rmh-age-card__image">
                <img src="{$base}/images/home-services/service-family.jpg?v={$imgVer}" alt="Children and family mental health support" width="840" height="560" loading="lazy" decoding="async">
            </div>
            <div class="rmh-age-card__body">
                <h3>Children</h3>
                <p>Age-appropriate therapy to support emotional development, behavioural challenges, and family dynamics.</p>
            </div>
        </div>
        <div class="rmh-age-card">
            <div class="rmh-age-card__image">
                <img src="{$base}/images/home-services/service-cbt.jpg?v={$imgVer}" alt="Adolescent mental health support" width="840" height="560" loading="lazy" decoding="async">
            </div>
            <div class="rmh-age-card__body">
                <h3>Adolescents</h3>
                <p>Specialized support for navigating the challenges of adolescence.</p>
            </div>
        </div>
        <div class="rmh-age-card">
            <div class="rmh-age-card__image">
                <img src="{$base}/images/home-services/service-positive.jpg?v={$imgVer}" alt="Adults and families in therapy" width="840" height="560" loading="lazy" decoding="async">
            </div>
            <div class="rmh-age-card__body">
                <h3>Adults &amp; Families</h3>
                <p>Comprehensive mental health services for individuals, couples, and families seeking healing.</p>
            </div>
        </div>
    </div>
HTML;

$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;

$r = $conn->query("SELECT id, introtext FROM {$p}content WHERE alias='our-therapy-services'");
$row = $r ? $r->fetch_assoc() : null;

if (!$row) {
    echo "Article alias=our-therapy-services not found.\n";
    $conn->close();
    exit(1);
}

$html = (string) $row['introtext'];
$startMarker = '<div class="rmh-age-groups">';
$startPos = strpos($html, $startMarker);

if ($startPos === false) {
    echo "No rmh-age-groups block found in article introtext.\n";
    $conn->close();
    exit(1);
}

$depth = 0;
$pos = $startPos;
$endPos = false;
$len = strlen($html);

while ($pos < $len) {
    $nextOpen = strpos($html, '<div', $pos);
    $nextClose = strpos($html, '</div>', $pos);

if ($nextOpen === false) {
        $nextOpen = $len;
    }
    if ($nextClose === false) {
        break;
    }

if ($nextOpen < $nextClose) {
        $depth++;
        $pos = $nextOpen + 4;
    } else {
        $depth--;
        if ($depth === 0) {
            $endPos = $nextClose + 6;
            break;
        }
        $pos = $nextClose + 6;
    }
}

if ($endPos === false) {
    echo "Could not find end of rmh-age-groups div.\n";
    $conn->close();
    exit(1);
}

$updated = substr($html, 0, $startPos) . $newAgeSection . substr($html, $endPos);
$conn->query("UPDATE {$p}content SET introtext='" . $conn->real_escape_string($updated) . "' WHERE id=" . (int) $row['id']);
echo 'Updated article id=' . (int) $row['id'] . " (Who We Serve cards with images, base={$base}).\n";

foreach ([__DIR__ . '/cache', __DIR__ . '/administrator/cache'] as $cacheDir) {
    if (!is_dir($cacheDir)) {
        continue;
    }
    foreach (glob($cacheDir . '/*') ?: [] as $f) {
        if (is_file($f) && str_ends_with($f, '.php')) {
            @unlink($f);
        }
    }
}
echo "Cleared PHP cache files in /cache and /administrator/cache (if present).\n";
echo "Also use Administrator → System → Clear Cache, then hard-refresh the browser.\n";

$conn->close();