Gecko [ gabointernational.org ]

Name	Size	Permission	Date
administrator	[ DIR ]	drwxr-xr-x	2026-05-03 18:20
administrator.1	[ DIR ]	drwxr-xr-x	2026-05-03 17:02
api	[ DIR ]	drwxr-xr-x	2026-05-03 18:20
api.1	[ DIR ]	drwxr-xr-x	2026-05-03 17:02
cache	[ DIR ]	drwxr-xr-x	2026-05-03 18:20
cache.1	[ DIR ]	drwxr-xr-x	2026-05-03 17:02
cli	[ DIR ]	drwxr-xr-x	2026-05-03 18:20
cli.1	[ DIR ]	drwxr-xr-x	2026-05-03 17:02
components	[ DIR ]	drwxr-xr-x	2026-05-03 18:20
components.1	[ DIR ]	drwxr-xr-x	2026-05-03 17:02
docs	[ DIR ]	drwxr-xr-x	2026-05-03 18:20
files	[ DIR ]	drwxr-xr-x	2026-05-03 18:20
files.1	[ DIR ]	drwxr-xr-x	2026-05-03 17:02
images	[ DIR ]	drwxr-xr-x	2026-05-03 18:20
images.1	[ DIR ]	drwxr-xr-x	2026-05-03 17:02
includes	[ DIR ]	drwxr-xr-x	2026-05-03 18:20
includes.1	[ DIR ]	drwxr-xr-x	2026-05-03 17:02
language	[ DIR ]	drwxr-xr-x	2026-05-03 18:20
language.1	[ DIR ]	drwxr-xr-x	2026-05-03 17:02
layouts	[ DIR ]	drwxr-xr-x	2026-05-03 18:20
layouts.1	[ DIR ]	drwxr-xr-x	2026-05-03 17:02
libraries	[ DIR ]	drwxr-xr-x	2026-05-03 18:20
libraries.1	[ DIR ]	drwxr-xr-x	2026-05-03 17:02
media	[ DIR ]	drwxr-xr-x	2026-05-03 18:20
media.1	[ DIR ]	drwxr-xr-x	2026-05-03 17:02
modules	[ DIR ]	drwxr-xr-x	2026-05-03 18:20
modules.1	[ DIR ]	drwxr-xr-x	2026-05-03 17:02
plugins	[ DIR ]	drwxr-xr-x	2026-05-03 18:20
plugins.1	[ DIR ]	drwxr-xr-x	2026-05-03 17:02
templates	[ DIR ]	drwxr-xr-x	2026-05-03 18:20
templates.1	[ DIR ]	drwxr-xr-x	2026-05-03 17:02
tmp	[ DIR ]	drwxr-xr-x	2026-05-03 18:20
tmp.1	[ DIR ]	drwxr-xr-x	2026-05-03 17:02
tools	[ DIR ]	drwxr-xr-x	2026-05-03 18:20
.trash_restore	7.88 KB	-rw-r--r--	2026-05-17 08:37
LICENSE.txt	17.67 KB	-rw-r--r--	2026-05-01 04:20
LICENSE.txt.1	17.67 KB	-rw-r--r--	2026-04-26 19:48
README.txt	5.53 KB	-rw-r--r--	2026-05-01 04:20
README.txt.1	5.53 KB	-rw-r--r--	2026-04-26 19:48
add_menu.php	664 B	-rw-r--r--	2026-04-28 04:05
append_css.php	171 B	-rw-r--r--	2026-05-02 01:52
append_js.php	1.84 KB	-rw-r--r--	2026-04-28 05:22
append_js_fixed.php	2.13 KB	-rw-r--r--	2026-04-28 05:38
build_site.php	36.49 KB	-rw-r--r--	2026-05-03 11:04
bump_media.php	912 B	-rw-r--r--	2026-05-02 02:24
bump_media_version.php	1.21 KB	-rw-r--r--	2026-05-02 01:52
check_about.php	1.42 KB	-rw-r--r--	2026-05-02 01:52
check_article_content.php	520 B	-rw-r--r--	2026-05-02 01:52
check_full_html.php	974 B	-rw-r--r--	2026-05-02 01:52
check_headings.php	559 B	-rw-r--r--	2026-05-02 01:52
check_hero.php	488 B	-rw-r--r--	2026-05-02 01:52
check_html_output.php	296 B	-rw-r--r--	2026-05-02 01:52
check_icons.php	492 B	-rw-r--r--	2026-05-02 01:52
check_menu.php	686 B	-rw-r--r--	2026-05-02 02:38
check_services_page.php	1.21 KB	-rw-r--r--	2026-05-02 01:52
check_sidebars.php	895 B	-rw-r--r--	2026-05-02 01:52
configuration.bak.php	2.88 KB	-rw-r--r--	2026-05-03 18:22
configuration.bak.php.1	2.91 KB	-rw-r--r--	2026-05-03 17:05
configuration.php	4.02 KB	-rw-r--r--	2026-05-03 18:22
configuration.php.1	4.01 KB	-rw-r--r--	2026-05-03 17:05
create_about_article.php	13.12 KB	-rw-r--r--	2026-05-02 01:52
create_about_page.php	1012 B	-rw-r--r--	2026-05-02 01:52
create_contact_page.php	10.4 KB	-rw-r--r--	2026-05-02 01:52
create_services_page.php	13.85 KB	-rw-r--r--	2026-05-03 06:02
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_menu.php	1.54 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
fix_age_cards.php	2.9 KB	-rw-r--r--	2026-05-02 02:55
fix_age_cards2.php	4.17 KB	-rw-r--r--	2026-05-02 02:57
fix_assets.php	2.37 KB	-rw-r--r--	2026-05-02 01:52
fix_contact_menu.php	1.3 KB	-rw-r--r--	2026-05-02 01:52
fix_contact_menu2.php	1.16 KB	-rw-r--r--	2026-05-02 01:52
fix_header.php	2.37 KB	-rw-r--r--	2026-04-28 03:29
fix_hero_images.php	1.73 KB	-rw-r--r--	2026-05-02 01:52
fix_home.php	619 B	-rw-r--r--	2026-04-28 04:11
fix_menu.php	770 B	-rw-r--r--	2026-05-02 01:52
fix_menu2.php	1.83 KB	-rw-r--r--	2026-05-02 01:52
fix_menu_items.php	798 B	-rw-r--r--	2026-05-02 02:39
fix_menu_module.php	3.7 KB	-rw-r--r--	2026-05-02 02:05
fix_services_age.php	2.72 KB	-rw-r--r--	2026-05-02 02:45
fix_services_page.php	1.45 KB	-rw-r--r--	2026-05-02 01:52
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
get_colors.php	1.08 KB	-rw-r--r--	2026-04-28 04:30
htaccess.txt	6.74 KB	-rw-r--r--	2026-05-01 04:20
htaccess.txt.1	6.74 KB	-rw-r--r--	2026-04-26 19:48
index.php	1.52 KB	-rw-r--r--	2026-05-01 04:20
index.php.1	1.52 KB	-rw-r--r--	2026-04-26 19:48
install_rmh_modules.php	15.4 KB	-rw-r--r--	2026-05-03 09:56
menu_all.php	452 B	-rw-r--r--	2026-05-02 03:31
menu_children1.php	436 B	-rw-r--r--	2026-05-02 03:22
menu_cols.php	316 B	-rw-r--r--	2026-05-02 03:22
menu_full.php	453 B	-rw-r--r--	2026-05-02 03:21
menu_order_check.php	478 B	-rw-r--r--	2026-05-02 03:21
menu_parents.php	498 B	-rw-r--r--	2026-05-02 03:22
menu_root.php	380 B	-rw-r--r--	2026-05-02 03:21
menu_root2.php	464 B	-rw-r--r--	2026-05-02 03:21
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	764 B	-rw-r--r--	2026-05-01 04:20
robots.txt.1	764 B	-rw-r--r--	2026-04-26 19:49
set_color.php	748 B	-rw-r--r--	2026-04-28 04:31
set_logo.php	863 B	-rw-r--r--	2026-04-28 04:21
update_about_page.php	9.5 KB	-rw-r--r--	2026-05-03 10:20
update_about_treatments.php	2.64 KB	-rw-r--r--	2026-05-02 01:52
update_age_images_nigeria.php	1.19 KB	-rw-r--r--	2026-05-02 03:03
update_all_content.php	17.6 KB	-rw-r--r--	2026-05-03 09:56
update_contact_colors.php	713 B	-rw-r--r--	2026-05-02 01:52
update_contact_icons.php	6.4 KB	-rw-r--r--	2026-05-02 01:52
update_contact_page.php	4.56 KB	-rw-r--r--	2026-05-02 01:52
update_hero.php	3.53 KB	-rw-r--r--	2026-05-03 16:32
web.config.txt	2.9 KB	-rw-r--r--	2026-05-01 04:20
web.config.txt.1	2.9 KB	-rw-r--r--	2026-04-26 19:49

Rename

<?php

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);
}
$conn->set_charset('utf8mb4');

$prefix = $config->dbprefix;

// 1. Find existing Main Menu module or create one
$menuResult = $conn->query("SELECT id FROM {$prefix}modules WHERE module='mod_menu' AND client_id=0 LIMIT 1");
$menu = $menuResult->fetch_assoc();

if ($menu) {
    // Update existing menu module to position 'menu'
    $conn->query("UPDATE {$prefix}modules SET position='menu', published=1, showtitle=0 WHERE id={$menu['id']}");
    echo "Updated existing menu module. ";
} else {
    // Create new menu module
    $paramsEsc = $conn->real_escape_string(json_encode([
        'menutype' => 'mainmenu',
        'startLevel' => '1',
        'endLevel' => '0',
        'showAllChildren' => '1',
        'window_open' => '',
        'layout' => '_:default',
        'moduleclass_sfx' => '',
        'cache' => '1',
        'cache_time' => '900',
        'cachemode' => 'itemid'
    ]));
    
    $now = date('Y-m-d H:i:s');
    $sql = "INSERT INTO {$prefix}modules (title, note, ordering, position, publish_up, published, module, access, showtitle, params, client_id, language) 
            VALUES ('Main Menu', '', 1, 'menu', '$now', 1, 'mod_menu', 1, 0, '$paramsEsc', 0, '*')";
    if ($conn->query($sql)) {
        $moduleId = $conn->insert_id;
        $conn->query("INSERT INTO {$prefix}modules_menu (moduleid, menuid) VALUES ($moduleId, 0)");
        echo "Created new menu module. ";
    }
}

// 2. Set the Appointment URL and text in template styles
$styleResult = $conn->query("SELECT id, params FROM {$prefix}template_styles WHERE template='wds-rmh' AND client_id=0");
$style = $styleResult->fetch_assoc();

if ($style) {
    $params = json_decode($style['params'], true);
    if (!is_array($params)) $params = [];
    
    // Add logo text if we don't have an image
    $params['siteTitle'] = 'Mental Health';
    $params['appointmentUrl'] = '/joomla/ray/index.php/contacts';
    $params['appointmentText'] = 'APPOINTMENT';
    
    $updatedParams = $conn->real_escape_string(json_encode($params));
    $conn->query("UPDATE {$prefix}template_styles SET params='$updatedParams' WHERE id={$style['id']}");
    echo "Updated template params. ";
}

echo "Done.";