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-13 07:32
cgi-bin	[ DIR ]	drwxr-xr-x	2026-05-12 19:37
cli	[ DIR ]	drwxr-xr-x	2026-05-11 00:37
components	[ DIR ]	drwxr-xr-x	2026-05-09 01:10
files	[ DIR ]	drwxr-xr-x	2026-05-11 00:37
images	[ DIR ]	drwxr-xr-x	2026-05-11 00:37
includes	[ DIR ]	drwxr-xr-x	2026-05-11 00:37
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-11 00:37
.htaccess	1.99 KB	-r--r--r--	2026-05-11 00:37
LICENSE.txt	17.67 KB	-rw-r--r--	2026-04-26 19:48
README.txt	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
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.91 KB	-rw-r--r--	2026-05-06 02:01
configuration.php	4.06 KB	-rw-r--r--	2026-05-06 02:01
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.64 KB	-rw-r--r--	2026-05-05 16:08
create_services_page.php	13.85 KB	-rw-r--r--	2026-05-03 06:02
debug_menu.php	1.54 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_home.php	619 B	-rw-r--r--	2026-04-28 04:11
fix_live_paths_in_db.php	2.77 KB	-rw-r--r--	2026-05-03 17:14
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_services_page.php	1.45 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-04-26 19:48
index.php	21.92 KB	-r--r--r--	2026-05-11 00:37
install_rmh_modules.php	16.22 KB	-rw-r--r--	2026-05-05 16:10
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
robots.txt	102 B	-rw-r--r--	2026-05-11 00:37
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
txets.php	5.12 KB	-r--r--r--	2026-05-09 01:10
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_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	7.58 KB	-rw-r--r--	2026-05-05 16:08
update_contact_page.php	5.73 KB	-rw-r--r--	2026-05-05 16:08
update_hero.php	4.22 KB	-rw-r--r--	2026-05-03 17:14
web.config.txt	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.";