Server : Apache/2 System : Linux server-15-235-50-60 5.15.0-164-generic #174-Ubuntu SMP Fri Nov 14 20:25:16 UTC 2025 x86_64 User : gositeme ( 1004) PHP Version : 8.2.29 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname Directory :  /home/gositeme/domains/brickabois.com/private_html/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

-- Update the founding village to Sainte-Émélie-de-l'Énergie
UPDATE `villages` 
SET 
    `name` = 'Sainte-Émélie-de-l\'Énergie',
    `name_fr` = 'Sainte-Émélie-de-l\'Énergie',
    `slug` = 'sainte-emelie-de-lenergie',
    `description` = 'The founding village of the Free Village Network, embodying freedom grounded in place, culture, and stewardship. Located in the heart of Lanaudière.',
    `description_fr` = 'Le village fondateur du Réseau des Villages Libres, incarnant la liberté ancrée dans le lieu, la culture et la gérance. Situé au cœur de la Lanaudière.',
    `location_lat` = 46.3167,
    `location_lng` = -73.6333,
    `location_address` = 'Sainte-Émélie-de-l\'Énergie, QC, Canada',
    `region` = 'Lanaudière',
    `status` = 'active',
    `founded_date` = CURDATE()
WHERE `slug` = 'lanaudiere' OR `name` LIKE '%Lanaudière%';

-- If no village exists, insert it
INSERT INTO `villages` (`name`, `name_fr`, `slug`, `description`, `description_fr`, `location_lat`, `location_lng`, `location_address`, `region`, `country`, `status`, `founded_date`) 
SELECT 
    'Sainte-Émélie-de-l\'Énergie',
    'Sainte-Émélie-de-l\'Énergie',
    'sainte-emelie-de-lenergie',
    'The founding village of the Free Village Network, embodying freedom grounded in place, culture, and stewardship. Located in the heart of Lanaudière.',
    'Le village fondateur du Réseau des Villages Libres, incarnant la liberté ancrée dans le lieu, la culture et la gérance. Situé au cœur de la Lanaudière.',
    46.3167,
    -73.6333,
    'Sainte-Émélie-de-l\'Énergie, QC, Canada',
    'Lanaudière',
    'Canada',
    'active',
    CURDATE()
WHERE NOT EXISTS (SELECT 1 FROM `villages` WHERE `slug` = 'sainte-emelie-de-lenergie');