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

/**
 * Creates/updates Nigeria footer to match US layout: About Us + Quick Links + Contact form,
 * with module titles and rmhFooter chrome params (showtitle, heading class).
 * Unpublishes footer-posts so the grid shows three columns with .rmh-site--ng CSS.
 *
 *   php ensure_ng_footer_modules.php
 *
 * To refresh the Contact article HTML (validated form), run:
 *   php patch_contacts_article_form.php
 *
 * From Joomla root (folder containing configuration.php).
 */

declare(strict_types=1);

require_once __DIR__ . '/configuration.php';

function ng_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, '/');
    }

return $default;
}

function upsert_footer_module(mysqli $conn, string $p, string $title, string $position, string $content, array $chrome): void
{
    $escaped = $conn->real_escape_string($content);
    $titleEsc = $conn->real_escape_string($title);
    $posEsc = $conn->real_escape_string($position);
    $showtitle = (int) ($chrome['showtitle'] ?? 1);
    $headerTag = (string) ($chrome['header_tag'] ?? 'h4');
    $headerClass = (string) ($chrome['header_class'] ?? 'rmh-footer__heading');
    $paramsArr = [
        'prepare_content' => '1',
        'layout'          => '_:default',
        'moduleclass_sfx' => '',
        'cache'           => '1',
        'cache_time'      => '900',
        'cachemode'       => 'static',
        'module_tag'      => 'div',
        'header_tag'      => $headerTag,
        'header_class'    => $headerClass,
        'style'           => '0',
    ];
    $paramsJson = json_encode($paramsArr, JSON_UNESCAPED_UNICODE) ?: '{}';
    $paramsEsc = $conn->real_escape_string($paramsJson);

$exists = $conn->query("SELECT id FROM {$p}modules WHERE title='{$titleEsc}' AND position='{$posEsc}' AND client_id=0 LIMIT 1")->fetch_assoc();
    if ($exists) {
        $id = (int) $exists['id'];
        $conn->query("UPDATE {$p}modules SET content='{$escaped}', published=1, position='{$posEsc}', module='mod_custom', showtitle={$showtitle}, params='{$paramsEsc}' WHERE id={$id}");
        echo "Updated \"{$title}\" (id={$id}) → {$position}\n";
        return;
    }
    $conn->query("INSERT INTO {$p}modules (title, content, module, position, published, access, showtitle, client_id, language, params, ordering)
        VALUES ('{$titleEsc}', '{$escaped}', 'mod_custom', '{$posEsc}', 1, 1, {$showtitle}, 0, '*', '{$paramsEsc}', 0)");
    $modId = (int) $conn->insert_id;
    $conn->query("INSERT INTO {$p}modules_menu (moduleid, menuid) VALUES ({$modId}, 0)");
    echo "Created \"{$title}\" (id={$modId}) → {$position}\n";
}

$config = new JConfig();
$base = ng_site_base($config);
$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;

$chrome = [
    'showtitle'    => 1,
    'header_tag'   => 'h4',
    'header_class' => 'rmh-footer__heading',
];

$about = '<p>Resilient Mental Health Services, Nigeria provides compassionate, accessible mental health care in Lagos and across Nigeria. We commit ourselves fully to the growth and wellness of individuals and their families through holistic, evidence-based approaches.</p>';
upsert_footer_module($conn, $p, 'About Us', 'footer-about', $about, $chrome);

$links = <<<HTML
<ul>
    <li><a href="{$base}/">Home</a></li>
    <li><a href="{$base}/index.php/about">About Us</a></li>
    <li><a href="{$base}/index.php/our-therapy-services">Our Services</a></li>
    <li><a href="{$base}/index.php/contacts">Contact</a></li>
</ul>
HTML;
upsert_footer_module($conn, $p, 'Quick Links', 'footer-links', $links, $chrome);

$form = <<<HTML
<form class="rmh-footer-contact-form" action="#" method="post" novalidate data-rmh-contact-redirect="{$base}/index.php/contacts">
    <p class="rmh-contact-form__error rmh-form-error" role="alert" hidden></p>
    <input type="text" name="name" id="rmh-fc-name" class="form-control" required maxlength="30" autocomplete="name" placeholder="Your Name" title="Name, max 30 characters">
    <input type="email" name="email" id="rmh-fc-email" class="form-control" required maxlength="30" inputmode="email" autocomplete="email" placeholder="Your E-Mail" title="E-mail, max 30 characters">
    <input type="tel" name="phone" id="rmh-fc-phone" class="form-control" required maxlength="18" inputmode="tel" autocomplete="tel" placeholder="Nigerian mobile (e.g. 0803… or +234…)" title="Nigerian mobile number only">
    <textarea name="message" id="rmh-fc-message" class="form-control" rows="3" required maxlength="12000" placeholder="Message" title="Message, max 200 words"></textarea>
    <small class="rmh-word-count" data-rmh-word-count data-rmh-word-max="200">0 / 200 words</small>
    <input type="text" name="website" class="rmh-hp-field" tabindex="-1" autocomplete="off" aria-hidden="true" value="">
    <button type="submit" class="rmh-btn rmh-btn--primary">SUBMIT</button>
</form>
HTML;
upsert_footer_module($conn, $p, 'Contact Us', 'footer-contact', $form, $chrome);

$conn->query("UPDATE {$p}modules SET published=0 WHERE client_id=0 AND position='footer-posts'");
echo "Unpublished modules in position footer-posts (if any).\n";
echo "Deploy template.css (.rmh-site--ng footer grid) and clear Joomla cache.\n";

$conn->close();