-- File generated by Dolibarr 22.0.0-beta --;

-- Page ID 1__+MAX_llx_website_page__ - Aliases config --;
INSERT INTO llx_website_page(rowid, fk_page, fk_website, pageurl, aliasalt, title, description, lang, image, keywords, status, date_creation, tms, import_key, grabbed_from, type_container, htmlheader, content, author_alias, allowed_in_frames) VALUES(1__+MAX_llx_website_page__, null, __WEBSITE_ID__, 'config', '', 'config', '', '', '', '', '0', '2025-04-30 09:05:35', '2025-05-16 14:06:30', null, '', 'setup', '', '<?php__N__includeContainer(\'_library_lib.php\', 1);__N__setSessionLang();__N__$socInfo = getSocInfo();__N____N__$message = \'\';__N__if (!isModEnabled(\'eventorganization\') || !isModEnabled(\'member\') || !isModEnabled(\'don\') || !isModEnabled(\'webportal\')) {__N__    $message = $langs->trans(\"TEMPLATE_MODULES_NOTICE\") .\"<br><br>\";__N__}__N____N____N__$item = $formSetup->newItem(\'WS_\'.strtoupper($website->ref).\'_\' . \'USE_TEXT_LOGO\')->setAsYesNo();__N__$item->nameText = $langs->trans(\"USE_TEXT_LOGO\");__N____N__$item = $formSetup->newItem(\'WS_\'.strtoupper($website->ref).\'_\' . \'CUSTOM_SLOGAN\');__N__$item->nameText = $langs->trans(\"CUSTOM_SLOGAN\");__N__$item->cssClass = \'minwidth500\';__N____N__$item = $formSetup->newItem(\'WS_\'.strtoupper($website->ref).\'_\' . \'CUSTOM_DESCRIPTION\');__N__$item->nameText = $langs->trans(\"CUSTOM_DESCRIPTION\");__N__$item->cssClass = \'minwidth500\';__N____N__$item = $formSetup->newItem(\'WS_\'.strtoupper($website->ref).\'_\' . \'SHOW_LANG_SELECTOR\')->setAsYesNo();__N__$item->nameText = $langs->trans(\"SHOW_LANG_SELECTOR\");__N____N__// Get available langs for the website__N__$TField = array();__N__$website_langs = getAvailableLangs();__N__$available_langs = $website_langs[\'langs\'];__N__$langs_code_shortcode = $website_langs[\'langs_code_shortcode\'];__N__foreach ($available_langs as $key => $value) {__N__    $TField[$key] = trim(explode(\'(\', $langs->trans(\"Language_\".$langs_code_shortcode[$key]))[0]);__N__}__N__$item = $formSetup->newItem(\'WS_\'.strtoupper($website->ref).\'_\' . \'SUPPORTED_LANGS\');__N__$item->nameText = $langs->trans(\"SUPPORTED_LANGS\");__N__$item->setAsMultiSelect($TField);__N____N__$item = $formSetup->newItem(\'WS_\'.strtoupper($website->ref).\'_\' . \'MAIN_COLOR\');__N__$item->nameText = $langs->trans(\"MAIN_COLOR\");__N__$item->cssClass = \'minwidth500\';__N____N__$item = $formSetup->newItem(\'WS_\'.strtoupper($website->ref).\'_\' . \'SECONDARY_COLOR\');__N__$item->nameText = $langs->trans(\"SECONDARY_COLOR\");__N__$item->cssClass = \'minwidth500\';__N____N__if (isModEnabled(\'member\')) {__N__    $formSetup->newItem(\'membersArea\')->setAsTitle();__N__    __N__    $item = $formSetup->newItem(\'MEMBER_ENABLE_PUBLIC\')->setAsYesNo();__N__    $item->nameText = $langs->trans(\"ENABLE_MEMBER_REGISTRATION_PAGE\");__N__    __N__    $item = $formSetup->newItem(\'WS_\'.strtoupper($website->ref).\'_\' . \'ENABLE_MEMBER_LIST_PAGE\')->setAsYesNo();__N__    $item->nameText = $langs->trans(\"ENABLE_MEMBER_LIST_PAGE\");__N__    __N__    if (isModEnabled(\'webportal\')) {__N__        $item = $formSetup->newItem(\'WS_\'.strtoupper($website->ref).\'_\' . \'ENABLE_MEMBER_AREA_PAGE\')->setAsYesNo();__N__        $item->nameText = $langs->trans(\"ENABLE_MEMBER_AREA_PAGE\");__N__    }__N__}__N____N__if (isModEnabled(\'eventorganization\')) {__N__    $formSetup->newItem(\'eventsArea\')->setAsTitle();__N__    $item = $formSetup->newItem(\'WS_\'.strtoupper($website->ref).\'_\' . \'DISABLE_EVENTS_SECTION\')->setAsYesNo();__N__    $item->nameText = $langs->trans(\"DISABLE_EVENTS_SECTION\");__N__    __N__    $item = $formSetup->newItem(\'WS_\'.strtoupper($website->ref).\'_\' . \'SHOW_EVENT_PARTICIPATE_LINK\')->setAsYesNo();__N__    $item->nameText = $langs->trans(\"SHOW_EVENT_PARTICIPATE_LINK\");__N__    __N__    $item = $formSetup->newItem(\'WS_\'.strtoupper($website->ref).\'_\' . \'SHOW_EVENT_GOAL_RAISED_AMOUNTS\')->setAsYesNo();__N__    $item->nameText = $langs->trans(\"SHOW_EVENT_GOAL_RAISED_AMOUNTS\");__N__}__N____N__if (isModEnabled(\'don\')) {__N__    $formSetup->newItem(\'DonationsArea\')->setAsTitle();__N__    $item = $formSetup->newItem(\'DONATION_ENABLE_PUBLIC\')->setAsYesNo();__N__    $item->nameText = $langs->trans(\"ENABLE_DONATION_PAGE\");__N__    __N__    $item = $formSetup->newItem(\'DONATION_COUNTERS_ARE_PUBLIC\')->setAsYesNo();__N__    $item->nameText = $langs->trans(\"DONATION_COUNTERS_ARE_PUBLIC\");__N__}__N____N__?>__N__', '', 0);

-- Page ID 2__+MAX_llx_website_page__ - Aliases contact --;
INSERT INTO llx_website_page(rowid, fk_page, fk_website, pageurl, aliasalt, title, description, lang, image, keywords, status, date_creation, tms, import_key, grabbed_from, type_container, htmlheader, content, author_alias, allowed_in_frames) VALUES(2__+MAX_llx_website_page__, null, __WEBSITE_ID__, 'contact', '', 'contact', '', '', '', '', '1', '2025-04-08 14:35:43', '2025-05-16 14:25:23', null, '', 'banner', '', '<?php__N__includeContainer(\'_library_lib.php\', 1);__N__setSessionLang();__N__$socInfo = getSocInfo();__N____N__if (GETPOST(\'action\') == \'sendmail\') {__N__    include_once DOL_DOCUMENT_ROOT.\'/core/class/CMailFile.class.php\';__N__    __N__    // Set message language__N__	$emaillang = new Translate(\'\', $conf);__N__	if ($mysoc->default_lang) {__N__	    $emaillang->setDefaultLang($mysoc->default_lang);__N__	    $emaillang->loadLangs(array(\"main\", \"website\"));__N__	}__N__	__N____N__    $from = GETPOST(\'email\', \'alpha\');__N__    $to = $mysoc->email;__N__    $subject = html_entity_decode ($emaillang->trans(\"contactFormReceived\", $website->ref));__N____N__    $firstname = GETPOST(\'firstname\', \'alpha\');__N__    $phone = GETPOST(\'phone\', \'alpha\');__N__    $usersubject = GETPOST(\'subject\', \'alpha\');__N__    $messageContent = GETPOST(\'message\', \'alpha\');__N____N__    $message = html_entity_decode ($emaillang->trans(\"contactFormReceived\", $website->ref)) . \"\\n\\n\";__N__    $message .= html_entity_decode ($emaillang->trans(\"contactFormName\")) . \": $firstname\\n\";__N__    $message .= html_entity_decode ($emaillang->trans(\"contactFormEmail\")) . \": $from\\n\";__N__    $message .= html_entity_decode ($emaillang->trans(\"contactFormPhone\")) . \": \" . (!empty($phone) ? $phone : \"N/A\") . \"\\n\";__N__    $message .= html_entity_decode ($emaillang->trans(\"contactFormSubjectEntered\")) . \": $usersubject\\n\\n\";__N__    $message .= html_entity_decode ($emaillang->trans(\"contactFormMessageLabel\")) . \":\\n$messageContent\\n\";__N____N__    $cmail = new CMailFile($subject, $to, $from, $message);__N____N__    if ($cmail->sendfile()) {__N__        ?>__N__        <script>__N__            alert(\"<?php echo html_entity_decode ($emaillang->trans(\"contactFormSuccessAlert\")); ?>\");__N__        </script>__N__        <?php__N__    } else {__N__        echo html_entity_decode ($langs->trans(\"ErrorFailedToSendMail\", $from, $to)) . \'. \' . $cmail->error;__N__    }__N__}__N____N____N____N__?>__N__<div class=\"container-fluid\">__N__    <div class=\"container py-5\">__N__        __N__        <div class=\"container-fluid contact py-5\">__N__            <div class=\"row g-4\">__N__                <div class=\"col-xl-5\">__N__                    __N__                    <div class=\"section-title\" id=\"section-contact\" style=\"scroll-margin-top: 130px;\">__N__                      <div class=\"line left-line\"></div>__N__                      <h1><?php echo $weblangs->trans(\"contactTitle\"); ?></h1>__N__                      <div class=\"line right-line\"></div>__N__                    </div>__N__        __N__                    <p class=\"mb-4\"><?php echo $weblangs->trans(\"contactMessage\"); ?></p>__N__                    <form method=\"post\" action=\"#\">__N__                        <div class=\"row gx-4 gy-3\">__N__                            <div class=\"col-xl-6\">__N__                                <input type=\"text\" name=\"firstname\" class=\"form-control bg-white border-0 py-3 px-4\" placeholder=\"<?php echo $weblangs->trans(\"labelFirstName\"); ?>\" required>__N__                            </div>__N__                            <div class=\"col-xl-6\">__N__                                <input type=\"email\" name=\"email\" class=\"form-control bg-white border-0 py-3 px-4\" placeholder=\"<?php echo $weblangs->trans(\"labelEmail\"); ?>\" required>__N__                            </div>__N__                            <div class=\"col-xl-6\">__N__                                <input type=\"text\" name=\"phone\" class=\"form-control bg-white border-0 py-3 px-4\" placeholder=\"<?php echo $weblangs->trans(\"labelPhone\"); ?>\">__N__                            </div>__N__                            <div class=\"col-xl-6\">__N__                                <input type=\"text\" name=\"subject\" class=\"form-control bg-white border-0 py-3 px-4\" placeholder=\"<?php echo $weblangs->trans(\"labelSubject\"); ?>\" required>__N__                            </div>__N__                            <div class=\"col-12\">__N__                                <textarea name=\"message\" class=\"form-control bg-white border-0 py-3 px-4\" rows=\"7\" cols=\"10\" placeholder=\"<?php echo $weblangs->trans(\"labelMessage\"); ?>\" required></textarea>__N__                            </div>__N__                            <div class=\"col-12\">__N__                                <button class=\"btn flat-button text-white py-2 px-3 float-end\" type=\"submit\" name=\"action\" value=\"sendmail\"><?php echo $weblangs->trans(\"submit\"); ?></button>__N__                            </div>__N__                        </div>__N__                    </form>__N__                </div>__N__                <div class=\"col-xl-7\">__N__                    <div>__N__                        <div class=\"row g-4\">__N__                            <div class=\"col-lg-6\">__N__                                <div class=\"bg-white p-2 text-center\">__N__                                    <i class=\"fas fa-map-marker-alt fa-2x secondary-color mb-2\"></i>__N__                                    <h4><?php echo $weblangs->trans(\"labelAddress\"); ?></h4>__N__                                    <p class=\"mb-0\"><?php echo $socInfo[\'address\']; ?></p>__N__                                </div>__N__                            </div>__N__                            <div class=\"col-lg-6\">__N__                                <div class=\"bg-white p-2 text-center\">__N__                                    <i class=\"fas fa-envelope fa-2x secondary-color mb-2\"></i>__N__                                    <h4><?php echo $weblangs->trans(\"labelEmail\"); ?></h4>__N__                                    <p class=\"mb-0\">__N__                                        <a href=\"mailto:<?php echo htmlspecialchars($socInfo[\'email\']); ?>\">__N__                                            <?php echo htmlspecialchars($socInfo[\'email\']); ?>__N__                                        </a>__N__                                    </p>__N__                                </div>__N__                            </div>__N__                            <!--<div class=\"col-lg-4\">__N__                                <div class=\"bg-white p-2 text-center\">__N__                                    <i class=\"fa fa-phone-alt fa-2x secondary-color mb-2\"></i>__N__                                    <h4><?php echo $weblangs->trans(\"labelPhone\"); ?></h4>__N__                                    <p class=\"mb-0\"><?php echo $socInfo[\'phone\']; ?></p>__N__                                </div>__N__                            </div>-->__N__                            <div class=\"col-lg-12\">__N__                                <iframe class=\"w-100\" style=\"height: 412px; margin-bottom: -6px;\" src=\"https://maps.google.com/maps?q=<?php echo urlencode($mysoc->getFullAddress()); ?>&t=&z=13&ie=UTF8&iwloc=&output=embed\" __N__                                    loading=\"lazy\" referrerpolicy=\"no-referrer-when-downgrade\"></iframe>__N__                            </div>__N__                        </div>__N__                    </div>__N__                </div>__N__            </div>__N__        </div>__N__    </div>__N__</div>', '', 0);

-- Page ID 3__+MAX_llx_website_page__ - Aliases donation-list --;
INSERT INTO llx_website_page(rowid, fk_page, fk_website, pageurl, aliasalt, title, description, lang, image, keywords, status, date_creation, tms, import_key, grabbed_from, type_container, htmlheader, content, author_alias, allowed_in_frames) VALUES(3__+MAX_llx_website_page__, null, __WEBSITE_ID__, 'donation-list', '', 'donation-list', '', '', '', '', '1', '2025-04-29 17:00:33', '2025-05-16 14:26:52', null, '', 'page', '<!-- DataTables CSS/JS -->__N__<link rel=\"stylesheet\" href=\"https://cdn.datatables.net/1.13.6/css/jquery.dataTables.min.css\">__N__<script src=\"https://cdn.datatables.net/1.13.6/js/jquery.dataTables.min.js\"></script>', '<?php__N__includeContainer(\'_library_lib.php\', 1);__N__setSessionLang();__N__$socInfo = getSocInfo();__N____N__if (!isModEnabled(\'don\') || !getDolGlobalInt(\'DONATION_ENABLE_PUBLIC\') || !getDolGlobalInt(\'DONATION_COUNTERS_ARE_PUBLIC\')) {__N__    redirectToContainer(\'index\');__N__}__N____N____N__$data = array();__N____N__$sql = \"SELECT d.rowid, d.datedon as datec, s.nom as societe, d.firstname, d.lastname, p.title, d.amount\";__N__$sql .= \" FROM \".MAIN_DB_PREFIX.\"don as d LEFT JOIN \".MAIN_DB_PREFIX.\"projet AS p\";__N__$sql .= \" ON p.rowid = d.fk_projet\";__N__$sql .= \" LEFT JOIN \" . MAIN_DB_PREFIX . \"societe AS s ON s.rowid = d.fk_soc\";__N__$sql .= \" WHERE d.entity IN (\". getEntity(\'donation\') . \")\";__N__$sql .= \" AND d.fk_statut IN (2)\";__N__$sql .= \" AND d.paid = 1\";__N__$sql .= \" AND d.public = 1\";__N__$sql .= \" AND p.public = 1\";__N__$sql .= $db->order(\"datedon\", \"DESC\");__N__    __N__$resql = $db->query($sql);__N__if ($resql) {__N__    while ($obj = $db->fetch_object($resql)) {__N__        $data[] = array(__N__			\'firstname\' => $obj->firstname,__N__			\'lastname\' => $obj->lastname,__N__			\'societe\' => $obj->societe,__N__			\'datec\' => $obj->datec,__N__			\'project\' => $obj->title,__N__			\'amount\' => $obj->amount,__N__		);__N__    }__N__}__N__/*print \"<pre>\";__N__print_r ($data);__N__print \"</pre>\";*/__N__define(\"__SEO_PAGE_TITLE__\", $weblangs->trans(\"listOfPublicDonations\")); __N__?>__N__    __N__<?php includeContainer(\'navbar\'); ?>__N____N__<div class=\"js-sticky-header-blog\"></div>__N____N__<section class=\"slogan has-section-divider\" style=\"min-height: 0;\">__N__    <svg class=\"section-divider\" viewBox=\"0 0 1920 60\" aria-hidden=\"true\"><path data-theme=\"softSecondary\" fill=\"white\" d=\"M0,80.75H1920V45.833H1742.083a80.491,80.491,0,0,1,12.863-1.55c5.2-.26,17.24-.3,24.153-.24,26.69.222,54.377,1.094,79.341.96,19.287-.1,37.1-.372,53.573-.788L1920,44V34.078l-6.614.216-9.221.256c-6.252.147-12.7.249-19.265.32-13.132.14-26.739.15-40.206.125-26.935-.052-53.313-.247-74.22.168-14.367-1.4-32.582-.756-48.293-1.92-10.145.509-20.876.936-24.149,2.4-16.09-.266-37.611,2.532-50.019.479V34.684c-10.959-2.291-33.371-1.869-48.292-3.84-15.861-.512-26.214,1.347-39.671,1.92-7.032.178-5.941-.773-13.8-.481-40.751-.071-41.131,5.477-62.087,8.16-4.569-5.691-47.085-5.126-77.622-5.04-2.333-4.154-22.643-5.808-50.015-6.479-4.677-2.069-17.763-2.969-22.423-5.04-4.7-.175-3.474.477-6.9.479-11.485-2.964-40.092-2.449-63.813-3.36-23.312.6-29.4,3.589-55.195,3.841-8.3-3.783-56.5-4.561-84.513-3.361-.316-1.857-5.682-3.862-20.7-4.8-2.193-.137-6.78.122-10.352,0-16.331-.564-22.974-3.145-39.671-1.441-22.812-1.938-73.831-3.919-98.311-.719-4.315-2.2-15.369-3.462-20.7-5.521-23.122-.714-41.26-2.815-65.54-2.64-13.5,1-29.918,1.6-39.671,3.12.27,1.317-1.305,2.38-6.9,2.88-35.562-1.333-83.117-2.545-93.139,2.88-14.338-.314-8.341,2.2-22.423,1.92-5.17-.16-2.615-1.4-6.9-1.68-36.327-1.894-80.653-1.762-100.041,2.161-12.433-1.631-21.648-3.708-36.221-5.04-13.359.1-36.33-.325-48.293-1.2-32.483.6-42.463,4.331-53.471,7.92-25.227-.147-43.752,2.274-58.641,4.321-11.966-1.189-27.56-.426-39.67-1.441-19.514,1.284-40.772,2.328-53.468,4.561C301.584,31.04,294,33.888,283.7,37.8c-15.047-.774-19.865-3.5-36.221-4.321-10.453-.522-37.12-1.01-48.3-.959-10.184.046-17.188,1.062-27.595.719-18.244,2.022-31.516,4.736-46.57,7.2-3.726,2.091-9.8,3.854-17.5,5.39H4.061c-.734-1.281-1.512-2.592-2.344-3.949-.546-.09-1.13-.175-1.717-.26Z\"/></svg>__N__</section>__N__        __N__<div class=\"container mt-5\">__N__	<div class=\"row\">__N____N__		__N____N__<div class=\"col-md-8\">__N__    <div class=\"section-title\">__N__      <div class=\"line left-line\"></div>__N__      <h1><?php print $weblangs->trans(\"listOfPublicDonations\"); ?></h1>__N__      <div class=\"line right-line\"></div>__N__    </div>__N__            __N__    <table id=\"membersTable\" class=\"table table-striped\">__N__        <thead>__N__            <tr>__N__                <th>#</th>__N__                <th><?php echo $weblangs->trans(\"Firstname\"); ?></th>__N__                <th><?php echo $weblangs->trans(\"Lastname\"); ?></th>__N__                <th><?php echo $weblangs->trans(\"Company\"); ?></th>__N__                <th><?php echo $weblangs->trans(\"Date\"); ?></th>__N__                __N__                <th><?php echo $weblangs->trans(\"project\"); ?></th>__N__                <th><?php echo $weblangs->trans(\"amount\"); ?></th>__N__            </tr>__N__        </thead>__N__        <tbody>__N__            <?php if (!empty($data) && is_array($data)): ?>__N__                <?php foreach ($data as $index => $row): ?>__N__                    <tr>__N__                        <td><?php echo (int)($index + 1); ?></td>__N__                        <td><?php echo !empty($row[\'firstname\']) ? htmlspecialchars($row[\'firstname\'], ENT_QUOTES, \'UTF-8\') : \'-\'; ?></td>__N__                        <td><?php echo !empty($row[\'lastname\']) ? htmlspecialchars($row[\'lastname\'], ENT_QUOTES, \'UTF-8\') : \'-\'; ?></td>__N__                        <td><?php echo !empty($row[\'societe\']) ? htmlspecialchars($row[\'societe\'], ENT_QUOTES, \'UTF-8\') : \'-\'; ?></td>__N__                        <td><?php echo dol_print_date($row[\'datec\'], \'daytext\', \'tzuser\', $weblangs); ?></td>__N__                        <td><?php echo htmlspecialchars($row[\'project\'] ?? \'\', ENT_QUOTES, \'UTF-8\'); ?></td>__N__                        <td><?php echo price(price2num($row[\'amount\'], \'MT\'), 1, \'\', 1, -1); ?> €</td>__N__                    </tr>__N__                <?php endforeach; ?>__N__            <?php endif; ?>__N__        </tbody>__N__    </table>__N__    <script>__N__        $(document).ready(function() {__N__            $(\'#membersTable\').DataTable({__N__                language: {__N__                    url: \"https://cdn.datatables.net/plug-ins/1.13.6/i18n/<?php print str_replace(\'_\', \'-\', $_SESSION[\'lang\'][\'code\']); ?>.json\"__N__                }__N__            });__N__        });__N__    </script>__N__</div>__N____N____N____N__	    <?php includeContainer(\'sidebar\'); ?>__N__		__N__	</div>__N__</div>__N____N__<?php includeContainer(\'footer\'); ?>', '', 0);

-- Page ID 4__+MAX_llx_website_page__ - Aliases events --;
INSERT INTO llx_website_page(rowid, fk_page, fk_website, pageurl, aliasalt, title, description, lang, image, keywords, status, date_creation, tms, import_key, grabbed_from, type_container, htmlheader, content, author_alias, allowed_in_frames) VALUES(4__+MAX_llx_website_page__, null, __WEBSITE_ID__, 'events', '', 'events', '', '', '', '', '1', '2025-04-14 14:16:40', '2025-05-16 14:25:29', null, '', 'banner', '', '<?php__N__includeContainer(\'_library_lib.php\', 1);__N__setSessionLang();__N__$socInfo = getSocInfo();__N____N__$showDonationLink = 0;__N__if (isModEnabled(\'don\') && getDolGlobalString(\'DONATION_ENABLE_PUBLIC\')) {__N__    $showDonationLink = 1;__N__}__N____N__$showEventGoalRaised = 0;__N__if (isModEnabled(\'don\') && isModEnabled(\'eventorganization\') && getDolGlobalString(\'WS_\'.strtoupper($website->ref).\'_\' . \'SHOW_EVENT_GOAL_RAISED_AMOUNTS\')) {__N__    $showEventGoalRaised = 1;__N__}__N____N__$showParticipateLink = 0;__N__if (isModEnabled(\'eventorganization\') && getDolGlobalString(\'WS_\'.strtoupper($website->ref).\'_\' . \'SHOW_EVENT_PARTICIPATE_LINK\')) {__N__    $showParticipateLink = 1;__N__}__N__?>__N__<div class=\"container-fluid causes\">__N__    <div class=\"container\">__N__        <div class=\"section-title\" id=\"section-events\" style=\"scroll-margin-top: 100px;\">__N__          <div class=\"line left-line\"></div>__N__          <h1><?php echo $weblangs->trans(\"actionsEvents\"); ?></h1>__N__          <div class=\"line right-line\"></div>__N__        </div>__N__        <div class=\"row g-4\">__N____N__            <?php __N__            $maxevents = GETPOSTINT(\'maxevents\') ? GETPOSTINT(\'maxevents\') : 3;__N__            $countofevents = 0;__N__            $sqlCount = \"SELECT count(p.rowid) as countofevents __N__                    FROM \".MAIN_DB_PREFIX.\"projet as p __N__                    WHERE p.fk_statut IN (0,1) AND p.usage_organize_event IN (1) __N__                    ORDER BY p.datec DESC \";__N__            $resqlCount = $db->query($sqlCount);__N__            if ($resqlCount) {__N__                $objCount = $db->fetch_object($resqlCount);__N__                $countofevents = $objCount->countofevents ? $objCount->countofevents : 0;__N__            }__N__        __N__            $sql = \"SELECT p.rowid, p.title, p.description, p.datec, p.dateo, p.datee, p.budget_amount, p.fk_statut __N__                    FROM \".MAIN_DB_PREFIX.\"projet as p __N__                    WHERE p.fk_statut IN (0,1) AND p.usage_organize_event IN (1) __N__                    ORDER BY p.datec DESC __N__                    LIMIT \".$maxevents;__N__            $resql = $db->query($sql);__N__            if ($resql) {__N__                $countofblogs = $db->num_rows($resql);__N__                $i=1;__N__                while ($obj = $db->fetch_object($resql)) {__N__                    ?>__N__                    <div class=\"col-lg-6 col-xl-4 event-item\" id=\"event-<?php echo $i; ?>\">__N__                        <div class=\"causes-item\">__N__                            <div class=\"causes-img\">__N__                                <?php__N__                                    $urlforimage = getImageFromHtmlContent($obj->description ? $obj->description : \"\");__N__                                    if (empty($urlforimage)) {__N__                                        $urlforimage = \'medias/image/\'.$website->ref.\'/noimage.jpg\';__N__                                    }__N__                                ?>__N__                                <img src=\"<?php echo $urlforimage; ?>\" class=\"img-fluid w-100\" style=\"height: 275px; object-fit: cover;\" alt=\"Image\">__N__                                <div class=\"causes-link pb-2 px-3\">__N__                                    <?php__N__                                        $progress = 100;__N__                                        if ($obj->budget_amount > 0 && $showEventGoalRaised) {__N__                                            $sqlCollected = \"SELECT SUM(amount) as total_collected __N__                                                             FROM \".MAIN_DB_PREFIX.\"don __N__                                                             WHERE fk_projet = \".$obj->rowid;__N__                                            $resqlCollected = $db->query($sqlCollected);__N__                                            $collected = 0;__N__                                            if ($resqlCollected) {__N__                                                $objCollected = $db->fetch_object($resqlCollected);__N__                                                $collected = $objCollected->total_collected ? $objCollected->total_collected : 0;__N__                                            }__N__                                            $progress = round(($collected / $obj->budget_amount) * 100, 2);__N__                                        }__N__                                    ?>__N__                                    <?php if ($showEventGoalRaised) { ?>__N__                                        <small class=\"text-white\"><i class=\"fas fa-chart-bar secondary-color me-2\"></i><?php echo $weblangs->trans(\"goal\"); ?>: <?php print price(price2num($obj->budget_amount, \'MT\'), 1, \'\', 1, -1); ?> €</small>__N__                                        <small class=\"text-white\"><i class=\"fa fa-thumbs-up secondary-color me-2\"></i><?php echo $weblangs->trans(\"raised\"); ?>: <?php print price(price2num($collected, \'MT\'), 1, \'\', 1, -1); ?> €</small>__N__                                    <?php } ?>    __N__                                </div>__N__                                <div class=\"causes-dination p-2\">__N__                                    <?php if ($showDonationLink) { ?>__N__                                        <?php if (getDolGlobalInt(\'WS_\' . strtoupper($website->ref) . \'_PAYMENT_IN_FRAME\')) { ?>__N__                                            <a href=\"page.php?donation=<?php echo $obj->rowid; ?>\" class=\"btn flat-button text-white py-2 px-3\"><?php echo $weblangs->trans(\"donateNow\"); ?></a>__N__                                        <?php } else { ?>__N__                                            <a href=\"<?php echo $socInfo[\'link_donation\'] . \'?project_id=\'.urlencode($obj->rowid); ?>\" target=\"new\" class=\"btn flat-button text-white py-2 px-3\"><?php echo $weblangs->trans(\"donateNow\"); ?></a>__N__                                        <?php } ?>__N__                                    <?php } ?>__N__                                    __N__                                    <?php if ($showParticipateLink) { ?>__N__                                        <?php $encodedsecurekey = dol_hash(getDolGlobalString(\'EVENTORGANIZATION_SECUREKEY\').\'conferenceorbooth\'.((int) $obj->rowid), \'md5\'); ?>__N__                                        <a href=\"<?php echo $socInfo[\'link_participation\'] . \'&id=\'.urlencode($obj->rowid).\'&securekey=\'.urlencode($encodedsecurekey); ?>\" target=\"new\" class=\"btn flat-button text-white py-2 px-3\"><?php echo $weblangs->trans(\"Participate\"); ?></a>__N__                                    <?php } ?>__N__                                </div>__N__                            </div>__N__                            __N__                            __N__                            <div class=\"progress\">__N__                              <div class=\"progress-bar\" role=\"progressbar\" style=\"width: <?php echo $progress; ?>%;\" aria-valuenow=\"<?php echo $progress; ?>\" aria-valuemin=\"0\" aria-valuemax=\"100\">__N__                                <?php if ($showEventGoalRaised) { ?>__N__                                <span><?php echo $progress; ?>%</span>__N__                                <?php } ?>__N__                              </div>__N__                            </div>__N____N__                            __N__                            <div class=\"causes-content p-4\">__N__                                <span class=\"text-body\">__N__                                    <i class=\"fas fa-calendar-alt me-2\"></i> <?php echo dol_print_date($obj->datec, \'daytext\', \'tzuser\', $weblangs); ?>__N__                                </span>__N__                                <h4 class=\"py-3\"><?php echo $obj->title; ?></h4>__N____N__                                <a href=\"page.php?id=<?php echo $obj->rowid; ?>\" class=\"btn flat-button text-white py-2 px-3 float-end\"><?php echo $weblangs->trans(\"readMore\"); ?></a>__N__                            </div>__N__                        </div>__N__                    </div>__N__                    <?php__N__                    $i++;__N__                }__N__            }__N__            ?>__N__        </div>__N__        __N__        <?php if ($maxevents <= $countofevents) { ?>__N__            <div class=\"row\">__N__                <div class=\"col-lg-7 text-center py-5 section-title\">__N__                    <div class=\"line left-line left-gradient\"></div>__N__                    <a href=\"javascript:void(0);\" class=\"btn flat-button text-white bgmaincolor\" id=\"loadMoreEventsBtn\"><?php echo $weblangs->trans(\"loadMore\"); ?> (<?php echo $maxevents; ?>/<?php echo $countofevents; ?>)</a>__N__                    <div class=\"line right-line right-gradient\"></div>__N__                </div>__N__            </div>__N__        <?php } ?>__N__        <script>__N__            document.getElementById(\'loadMoreEventsBtn\').addEventListener(\'click\', function() {__N__            const currentUrl = new URL(window.location.href);__N__            const maxEventsParam = <?php echo $maxevents; ?>;__N__            const newMaxEvents = parseInt(maxEventsParam) + 3;__N__            currentUrl.searchParams.set(\'maxevents\', newMaxEvents);__N__            currentUrl.hash = \'#event-\' + (parseInt(maxEventsParam) + 1).toString();__N__            window.location.href = currentUrl.toString();__N__            });__N__        </script>__N__    </div>__N__</div>', '', 0);

-- Page ID 5__+MAX_llx_website_page__ - Aliases footer --;
INSERT INTO llx_website_page(rowid, fk_page, fk_website, pageurl, aliasalt, title, description, lang, image, keywords, status, date_creation, tms, import_key, grabbed_from, type_container, htmlheader, content, author_alias, allowed_in_frames) VALUES(5__+MAX_llx_website_page__, null, __WEBSITE_ID__, 'footer', '', 'footer', '', '', '', '', '1', '2025-04-08 14:37:00', '2025-05-16 14:25:35', null, '', 'banner', '', '<?php__N__includeContainer(\'_library_lib.php\', 1);__N__setSessionLang();__N__$socInfo = getSocInfo();__N__?>__N__<div class=\"container-fluid\" style=\"margin:0; padding:0;\">__N__    <svg class=\"section-divider\" viewBox=\"0 0 1920 60\" aria-hidden=\"true\"><path data-theme=\"softSecondary\" fill=\"<?php print getDolGlobalString(\'WS_\' . strtoupper($website->ref) . \'_MAIN_COLOR\') ?: \'#5d5b6a\'; ?>\" d=\"M0,80.75H1920V45.833H1742.083a80.491,80.491,0,0,1,12.863-1.55c5.2-.26,17.24-.3,24.153-.24,26.69.222,54.377,1.094,79.341.96,19.287-.1,37.1-.372,53.573-.788L1920,44V34.078l-6.614.216-9.221.256c-6.252.147-12.7.249-19.265.32-13.132.14-26.739.15-40.206.125-26.935-.052-53.313-.247-74.22.168-14.367-1.4-32.582-.756-48.293-1.92-10.145.509-20.876.936-24.149,2.4-16.09-.266-37.611,2.532-50.019.479V34.684c-10.959-2.291-33.371-1.869-48.292-3.84-15.861-.512-26.214,1.347-39.671,1.92-7.032.178-5.941-.773-13.8-.481-40.751-.071-41.131,5.477-62.087,8.16-4.569-5.691-47.085-5.126-77.622-5.04-2.333-4.154-22.643-5.808-50.015-6.479-4.677-2.069-17.763-2.969-22.423-5.04-4.7-.175-3.474.477-6.9.479-11.485-2.964-40.092-2.449-63.813-3.36-23.312.6-29.4,3.589-55.195,3.841-8.3-3.783-56.5-4.561-84.513-3.361-.316-1.857-5.682-3.862-20.7-4.8-2.193-.137-6.78.122-10.352,0-16.331-.564-22.974-3.145-39.671-1.441-22.812-1.938-73.831-3.919-98.311-.719-4.315-2.2-15.369-3.462-20.7-5.521-23.122-.714-41.26-2.815-65.54-2.64-13.5,1-29.918,1.6-39.671,3.12.27,1.317-1.305,2.38-6.9,2.88-35.562-1.333-83.117-2.545-93.139,2.88-14.338-.314-8.341,2.2-22.423,1.92-5.17-.16-2.615-1.4-6.9-1.68-36.327-1.894-80.653-1.762-100.041,2.161-12.433-1.631-21.648-3.708-36.221-5.04-13.359.1-36.33-.325-48.293-1.2-32.483.6-42.463,4.331-53.471,7.92-25.227-.147-43.752,2.274-58.641,4.321-11.966-1.189-27.56-.426-39.67-1.441-19.514,1.284-40.772,2.328-53.468,4.561C301.584,31.04,294,33.888,283.7,37.8c-15.047-.774-19.865-3.5-36.221-4.321-10.453-.522-37.12-1.01-48.3-.959-10.184.046-17.188,1.062-27.595.719-18.244,2.022-31.516,4.736-46.57,7.2-3.726,2.091-9.8,3.854-17.5,5.39H4.061c-.734-1.281-1.512-2.592-2.344-3.949-.546-.09-1.13-.175-1.717-.26Z\"/></svg>__N__</div>__N__<div class=\"container-fluid footer text-body\">__N__    __N__    <div class=\"container py-5\">__N__        <div class=\"row g-5\">__N__            __N__            <div class=\"col-md-6 col-lg-6 col-xl-3\">__N__                <div class=\"footer-item d-flex flex-column\">__N__                    <h4 class=\"mb-4 text-white\"><?php echo $weblangs->trans(\"presentation\"); ?></h4>__N__                    <a href=\"/index#section-overview\"><i class=\"fas fa-angle-right me-2\"></i> <?php echo $weblangs->trans(\"missionVision\"); ?></a>__N__                    <a href=\"rgpd.php\"><i class=\"fas fa-angle-right me-2\"></i> <?php echo $weblangs->trans(\"rgpd\"); ?></a>__N__                </div>__N__            </div>__N__            <div class=\"col-md-6 col-lg-6 col-xl-3\">__N__                <div class=\"footer-item d-flex flex-column\">__N__                    <h4 class=\"mb-4 text-white\"><?php echo $weblangs->trans(\"newsEvents\"); ?></h4>__N__                    <a href=\"index#section-news\"><i class=\"fas fa-angle-right me-2\"></i> <?php echo $weblangs->trans(\"news\"); ?></a>__N__                    <?php if (isModEnabled(\'eventorganization\') && !getDolGlobalInt(\'WS_\'.strtoupper($website->ref).\'_\' . \'DISABLE_EVENTS_SECTION\')): ?>__N__                        <a href=\"index#section-events\"><i class=\"fas fa-angle-right me-2\"></i> <?php echo $weblangs->trans(\"actionsEvents\"); ?></a>__N__                    <?php endif; ?>__N__                </div>__N__            </div>__N__            <div class=\"col-md-6 col-lg-6 col-xl-3\">__N__                <div class=\"footer-item d-flex flex-column\">__N__                    <h4 class=\"mb-4 text-white\"><?php echo $weblangs->trans(\"volunteer\"); ?></h4>__N__                        <?php if (isModEnabled(\'webportal\') && getDolGlobalInt(\'WS_\'.strtoupper($website->ref).\'_\' . \'ENABLE_MEMBER_AREA_PAGE\')): ?>__N__                          <?php__N__                          if (getDolGlobalString(\'WEBPORTAL_ROOT_URL\')) {__N__                            $url = getDolGlobalString(\'WEBPORTAL_ROOT_URL\');__N__                          } else {__N__                            if (isModEnabled(\'multicompany\')) {__N__                              $entity_qr = \'?entity=\' . ((int) $conf->entity);__N__                            } else {__N__                              $entity_qr = \'\';__N__                            }__N__            __N__                            $urlwithouturlroot = preg_replace(\'/\' . preg_quote(DOL_URL_ROOT, \'/\') . \'$/i\', \'\', trim($conf->file->dol_main_url_root));__N__                            $urlwithroot = $urlwithouturlroot . DOL_URL_ROOT;__N__                            $url = $urlwithroot . \'/public/webportal/index.php\' . $entity_qr;__N__                          }__N__                          ?>__N__                          <a href=\"<?php echo $url; ?>\"><i class=\"fas fa-angle-right me-2\"></i> <?php echo $weblangs->trans(\"memberArea\"); ?></a>__N__                        <?php endif; ?>__N__                        __N__                    <?php if (getDolGlobalInt(\'WS_\'.strtoupper($website->ref).\'_\' . \'ENABLE_MEMBER_LIST_PAGE\')): ?>__N__                        <a href=\"members-list.php\"><i class=\"fas fa-angle-right me-2\"></i> <?php echo $weblangs->trans(\"directory\"); ?></a>__N__                    <?php endif; ?>__N__                    __N__                    <?php if (isModEnabled(\'member\') && getDolGlobalInt(\'MEMBER_ENABLE_PUBLIC\')): ?>__N__                        <a href=\"<?php print $socInfo[\'subscription_link\']; ?>\" target=\"new\"><i class=\"fas fa-angle-right me-2\"></i> <?php echo $weblangs->trans(\"becomeMember\"); ?></a>__N__                    <?php endif; ?>__N__                    __N__                    <?php if (isModEnabled(\'don\') && getDolGlobalInt(\'DONATION_ENABLE_PUBLIC\')): ?>__N__                        <a href=\"<?php print $socInfo[\'link_donation\']; ?>\"><i class=\"fas fa-angle-right me-2\"></i> <?php echo $weblangs->trans(\"makeDonation\"); ?></a>__N__                    <?php endif; ?>__N__                </div>__N__            </div>__N__            <div class=\"col-md-6 col-lg-6 col-xl-3\">__N__                <div class=\"footer-item\">__N__                    <h4 class=\"mb-4 text-white\"><?php echo $weblangs->trans(\"socials\"); ?></h4>__N__                    <div class=\"social\">__N__                        <?php__N__                            $socialIcons = [__N__                              \'facebook\' => \'fa-facebook-f\',__N__                              \'twitter\' => \'fa-x-twitter\',__N__                              \'linkedin\' => \'fa-linkedin-in\',__N__                              \'instagram\' => \'fa-instagram\',__N__                              \'youtube\' => \'fa-youtube\',__N__                              \'skype\' => \'fa-skype\',__N__                              \'whatsapp\' => \'fa-whatsapp\',__N__                              \'snapchat\' => \'fa-snapchat-ghost\',__N__                            ];__N__                __N__                            foreach ($socialIcons as $key => $icon) {__N__                              if (!empty($socInfo[$key])) {__N__                                echo \'<a href=\"\' . htmlspecialchars($socInfo[$key]) . \'\" target=\"_blank\" class=\"btn-hover-color btn-square text-white me-2\"><i class=\"fa-brands \' . $icon . \'\"></i></a>\';__N__                              }__N__                            }__N__                        ?>__N__                    </div>__N__                </div>__N__            </div>__N__            <!--<div class=\"col-md-6 col-lg-6 col-xl-3\">__N__                <div class=\"footer-item d-flex flex-column\">__N__                    <h4 class=\"mb-4 text-white\">RGPD</h4>__N__                    <a href=\"\"><i class=\"fas fa-angle-right me-2\"></i> Politique de Confidentialité</a>__N__                    <a href=\"\"><i class=\"fas fa-angle-right me-2\"></i> Gestion des Données</a>__N__                    <a href=\"\"><i class=\"fas fa-angle-right me-2\"></i> Droits des Utilisateurs</a>__N____N__                </div>__N__            </div>-->__N__        </div>__N__    </div>__N__</div>', '', 0);

-- Page ID 6__+MAX_llx_website_page__ - Aliases highlights --;
INSERT INTO llx_website_page(rowid, fk_page, fk_website, pageurl, aliasalt, title, description, lang, image, keywords, status, date_creation, tms, import_key, grabbed_from, type_container, htmlheader, content, author_alias, allowed_in_frames) VALUES(6__+MAX_llx_website_page__, null, __WEBSITE_ID__, 'highlights', '', 'highlights', '', 'en', '', '', '1', '2025-04-14 10:49:38', '2025-05-16 14:25:42', null, '', 'banner', '', '<div class=\"col-lg-3 stats section\" id=\"stats\">__N__                __N__    <div class=\"section-title\">__N__      <div class=\"line left-line\"></div>__N__      <h1><?php echo $weblangs->trans(\"highlights\"); ?></h1>__N__      <div class=\"line right-line\"></div>__N__    </div>__N____N__    <div class=\"container aos-init aos-animate\" data-aos=\"fade-up\" data-aos-delay=\"100\">__N____N__        <div class=\"row gy-4\">__N__            __N__            <!--<div class=\"col-lg-12 counter-box\">__N__                <i class=\"fas fa-users fa-4x text-white\"></i>__N__                <div class=\"stats-item\">__N__                  <span data-purecounter-start=\"0\" data-purecounter-end=\"232\" data-purecounter-duration=\"0\" class=\"purecounter\">000</span>__N__                  <p><?php echo $weblangs->trans(\"volunteer\"); ?></p>__N__                </div>__N__            </div><!-- End Stats Item -->__N__            __N__            <?php if (isModEnabled(\'member\')): ?>__N__                <div class=\"col-lg-12 counter-box\">__N__                    <i class=\"fas fa-user-friends fa-4x text-white\"></i>__N__                    <div class=\"stats-item\">__N__                      <?php__N__                      $sql = \"SELECT COUNT(rowid) as total_members FROM llx_adherent WHERE statut = 1 AND public = 1\";__N__                      $resql = $db->query($sql);__N__                      $total_members = 0;__N__                      if ($resql) {__N__                        $obj = $db->fetch_object($resql);__N__                        if ($obj) {__N__                          $total_members = $obj->total_members;__N__                        }__N__                      }__N__                      ?>__N__                      <span data-purecounter-start=\"0\" data-purecounter-end=\"<?php echo $total_members; ?>\" data-purecounter-duration=\"0\" class=\"purecounter\"><?php echo $total_members; ?></span>__N__                      <p><?php echo $weblangs->trans(\"member\"); ?></p>__N__                    </div>__N__                </div><!-- End Stats Item -->__N__            <?php endif; ?>__N__            __N__            <?php if (isModEnabled(\'eventorganization\')): ?>__N__            <div class=\"col-lg-12 counter-box\">__N__              <i class=\"fas fa-hands-helping fa-4x text-white\"></i>__N__              <div class=\"stats-item\">__N__              <?php__N__                $sql = \"SELECT COUNT(rowid) as total_events FROM \".MAIN_DB_PREFIX.\"projet as p WHERE p.fk_statut IN (0,1) AND p.usage_organize_event IN (1)\";__N__              $resql = $db->query($sql);__N__              $total_events = 0;__N__              if ($resql) {__N__                $obj = $db->fetch_object($resql);__N__                if ($obj) {__N__                $total_events = $obj->total_events;__N__                }__N__              }__N__              ?>__N__              <span data-purecounter-start=\"0\" data-purecounter-end=\"<?php echo $total_events; ?>\" data-purecounter-duration=\"0\" class=\"purecounter\"><?php echo $total_events; ?></span>__N__              <p><?php echo $weblangs->trans(\"actions\"); ?></p>__N__              </div>__N__            </div><!-- End Stats Item -->__N__            <?php endif; ?>__N____N__            <?php if (isModEnabled(\'don\') && getDolGlobalInt(\'DONATION_ENABLE_PUBLIC\') && getDolGlobalInt(\'DONATION_COUNTERS_ARE_PUBLIC\')): ?>__N__                <div class=\"col-lg-12 counter-box\">__N__                    <i class=\"fas fa-hands-helping fa-4x text-white\"></i>__N__                    <div class=\"stats-item\">__N__                      <?php__N__                        $sql = \"SELECT count(amount) as count_funds FROM llx_don WHERE paid = 1\";__N__                        $resql = $db->query($sql);__N__                        $count_funds = 0;__N__                        if ($resql) {__N__                        $obj = $db->fetch_object($resql);__N__                        if ($obj) {__N__                          $count_funds = $obj->count_funds;__N__                        }__N__                        }__N__                        ?>__N__                        <span data-purecounter-start=\"0\" data-purecounter-end=\"<?php echo $count_funds; ?>\" data-purecounter-duration=\"0\" class=\"purecounter\"><?php print $count_funds; ?></span>__N__                        <p><?php echo $weblangs->trans(\"Donation\"); ?></p>__N__                    </div>__N__                </div><!-- End Stats Item -->__N__            <?php endif; ?>__N__            __N__            <?php if (isModEnabled(\'don\') && getDolGlobalInt(\'DONATION_ENABLE_PUBLIC\') && getDolGlobalInt(\'DONATION_COUNTERS_ARE_PUBLIC\')): ?>__N__                <div class=\"col-lg-12 counter-box\">__N__                    <i class=\"fas fa-file-invoice-dollar fa-4x text-white\"></i>__N__                    <div class=\"stats-item\">__N__                      <?php__N__                        $sql = \"SELECT SUM(amount) as total_funds FROM llx_don WHERE paid = 1\";__N__                        $resql = $db->query($sql);__N__                        $total_funds = 0;__N__                        if ($resql) {__N__                        $obj = $db->fetch_object($resql);__N__                        if ($obj) {__N__                          $total_funds = $obj->total_funds;__N__                        }__N__                        }__N__                        ?>__N__                        <span data-purecounter-start=\"0\" data-purecounter-end=\"<?php echo $total_funds; ?>\" data-purecounter-duration=\"0\" class=\"purecounter\"><?php print intval($total_funds); ?> €</span>__N__                        <p><?php echo $weblangs->trans(\"fundsCollected\"); ?></p>__N__                    </div>__N__                </div><!-- End Stats Item -->__N__            <?php endif; ?>__N____N__        </div>__N__    __N__      </div>__N__</div>', '', 0);

-- Page ID 7__+MAX_llx_website_page__ - Aliases index --;
INSERT INTO llx_website_page(rowid, fk_page, fk_website, pageurl, aliasalt, title, description, lang, image, keywords, status, date_creation, tms, import_key, grabbed_from, type_container, htmlheader, content, author_alias, allowed_in_frames) VALUES(7__+MAX_llx_website_page__, null, __WEBSITE_ID__, 'index', '', 'Index', '', '', '', '', '1', '2025-03-21 15:58:56', '2025-05-16 14:25:48', null, '', 'banner', '', '<?php includeContainer(\'navbar\'); ?>__N____N__<?php includeContainer(\'slider\'); ?>__N____N__<?php __N__includeContainer(\'overview\');__N__?>__N____N__<?php includeContainer(\'news\'); ?>__N____N__<?php__N__if (!getDolGlobalString(\'WS_\'.strtoupper($website->ref).\'_\' . \'DISABLE_EVENTS_SECTION\') && isModEnabled(\'eventorganization\')) {__N__    includeContainer(\'events\'); __N__}__N__?>__N____N__<?php includeContainer(\'contact\'); ?>__N____N__<?php includeContainer(\'footer\'); ?>', '', 0);
UPDATE llx_website SET fk_default_home = 7__+MAX_llx_website_page__ WHERE rowid = __WEBSITE_ID__;

-- Page ID 8__+MAX_llx_website_page__ - Aliases members-list --;
INSERT INTO llx_website_page(rowid, fk_page, fk_website, pageurl, aliasalt, title, description, lang, image, keywords, status, date_creation, tms, import_key, grabbed_from, type_container, htmlheader, content, author_alias, allowed_in_frames) VALUES(8__+MAX_llx_website_page__, null, __WEBSITE_ID__, 'members-list', '', 'members-list', '', '', '', '', '1', '2025-04-29 15:02:20', '2025-05-16 14:27:14', null, '', 'page', '<!-- DataTables CSS/JS -->__N__<link rel=\"stylesheet\" href=\"https://cdn.datatables.net/1.13.6/css/jquery.dataTables.min.css\">__N__<script src=\"https://cdn.datatables.net/1.13.6/js/jquery.dataTables.min.js\"></script>', '<?php__N__includeContainer(\'_library_lib.php\', 1);__N__setSessionLang();__N__$socInfo = getSocInfo();__N____N__if (!getDolGlobalInt(\'WS_\'.strtoupper($website->ref).\'_\' . \'ENABLE_MEMBER_LIST_PAGE\')) {__N__    redirectToContainer(\'index\');__N__}__N____N__$data = array();__N__$sql = \"SELECT rowid, firstname, lastname, societe, zip, town, email, birth, photo, datec\";__N____N__$sqlfields = $sql;__N____N__$sql .= \" FROM \".MAIN_DB_PREFIX.\"adherent\";__N__$sql .= \" WHERE entity = 1\";__N__$sql .= \" AND statut = 1\";__N__$sql .= \" AND public = 1\";__N__$sql .= $db->order(\"datec\", \"DESC\");__N__    __N__$resql = $db->query($sql);__N__if ($resql) {__N__    while ($obj = $db->fetch_object($resql)) {__N__        $data[] = array(__N__			\'firstname\' => $obj->firstname,__N__			\'lastname\' => $obj->lastname,__N__			\'societe\' => $obj->societe,__N__			\'datec\' => $obj->datec,__N__		);__N__    }__N__}__N__/*print \"<pre>\";__N__print_r ($data);__N__print \"</pre>\";*/__N__define(\"__SEO_PAGE_TITLE__\", $weblangs->trans(\"ListOfValidatedPublicMembers\")); __N__?>__N__    __N__<?php includeContainer(\'navbar\'); ?>__N____N__<div class=\"js-sticky-header-blog\"></div>__N____N__<section class=\"slogan has-section-divider\" style=\"min-height: 0;\">__N__    <svg class=\"section-divider\" viewBox=\"0 0 1920 60\" aria-hidden=\"true\"><path data-theme=\"softSecondary\" fill=\"white\" d=\"M0,80.75H1920V45.833H1742.083a80.491,80.491,0,0,1,12.863-1.55c5.2-.26,17.24-.3,24.153-.24,26.69.222,54.377,1.094,79.341.96,19.287-.1,37.1-.372,53.573-.788L1920,44V34.078l-6.614.216-9.221.256c-6.252.147-12.7.249-19.265.32-13.132.14-26.739.15-40.206.125-26.935-.052-53.313-.247-74.22.168-14.367-1.4-32.582-.756-48.293-1.92-10.145.509-20.876.936-24.149,2.4-16.09-.266-37.611,2.532-50.019.479V34.684c-10.959-2.291-33.371-1.869-48.292-3.84-15.861-.512-26.214,1.347-39.671,1.92-7.032.178-5.941-.773-13.8-.481-40.751-.071-41.131,5.477-62.087,8.16-4.569-5.691-47.085-5.126-77.622-5.04-2.333-4.154-22.643-5.808-50.015-6.479-4.677-2.069-17.763-2.969-22.423-5.04-4.7-.175-3.474.477-6.9.479-11.485-2.964-40.092-2.449-63.813-3.36-23.312.6-29.4,3.589-55.195,3.841-8.3-3.783-56.5-4.561-84.513-3.361-.316-1.857-5.682-3.862-20.7-4.8-2.193-.137-6.78.122-10.352,0-16.331-.564-22.974-3.145-39.671-1.441-22.812-1.938-73.831-3.919-98.311-.719-4.315-2.2-15.369-3.462-20.7-5.521-23.122-.714-41.26-2.815-65.54-2.64-13.5,1-29.918,1.6-39.671,3.12.27,1.317-1.305,2.38-6.9,2.88-35.562-1.333-83.117-2.545-93.139,2.88-14.338-.314-8.341,2.2-22.423,1.92-5.17-.16-2.615-1.4-6.9-1.68-36.327-1.894-80.653-1.762-100.041,2.161-12.433-1.631-21.648-3.708-36.221-5.04-13.359.1-36.33-.325-48.293-1.2-32.483.6-42.463,4.331-53.471,7.92-25.227-.147-43.752,2.274-58.641,4.321-11.966-1.189-27.56-.426-39.67-1.441-19.514,1.284-40.772,2.328-53.468,4.561C301.584,31.04,294,33.888,283.7,37.8c-15.047-.774-19.865-3.5-36.221-4.321-10.453-.522-37.12-1.01-48.3-.959-10.184.046-17.188,1.062-27.595.719-18.244,2.022-31.516,4.736-46.57,7.2-3.726,2.091-9.8,3.854-17.5,5.39H4.061c-.734-1.281-1.512-2.592-2.344-3.949-.546-.09-1.13-.175-1.717-.26Z\"/></svg>__N__</section>__N__        __N__<div class=\"container mt-5\">__N__	<div class=\"row\">__N____N__		__N____N__<div class=\"col-md-8\">__N__    <div class=\"section-title\">__N__      <div class=\"line left-line\"></div>__N__      <h1><?php print $weblangs->trans(\"ListOfValidatedPublicMembers\"); ?></h1>__N__      <div class=\"line right-line\"></div>__N__    </div>__N__            __N__    <table id=\"membersTable\" class=\"table table-striped\">__N__        <thead>__N__            <tr>__N__                <th>#</th>__N__                <th><?php echo $weblangs->trans(\"Firstname\"); ?></th>__N__                <th><?php echo $weblangs->trans(\"Lastname\"); ?></th>__N__                <th><?php echo $weblangs->trans(\"Company\"); ?></th>__N__                <th><?php echo $weblangs->trans(\"DateSubscription\"); ?></th>__N__            </tr>__N__        </thead>__N__        <tbody>__N__            <?php if (!empty($data) && is_array($data)): ?>__N__                <?php foreach ($data as $index => $row): ?>__N__                    <tr>__N__                        <td><?php echo (int)($index + 1); ?></td>__N__                        <td><?php echo htmlspecialchars($row[\'firstname\'] ?? \'\', ENT_QUOTES, \'UTF-8\'); ?></td>__N__                        <td><?php echo htmlspecialchars($row[\'lastname\'] ?? \'\', ENT_QUOTES, \'UTF-8\'); ?></td>__N__                        <td><?php echo htmlspecialchars($row[\'societe\'] ?? \'\', ENT_QUOTES, \'UTF-8\'); ?></td>__N__                        <td><?php echo dol_print_date($row[\'datec\'], \'daytext\', \'tzuser\', $weblangs); ?></td>__N__                    </tr>__N__                <?php endforeach; ?>__N__            <?php endif; ?>__N__        </tbody>__N__    </table>__N__    <script>__N__        $(document).ready(function() {__N__            $(\'#membersTable\').DataTable({__N__                language: {__N__                    url: \"https://cdn.datatables.net/plug-ins/1.13.6/i18n/<?php print str_replace(\'_\', \'-\', $_SESSION[\'lang\'][\'code\']); ?>.json\"__N__                }__N__            });__N__        });__N__    </script>__N__</div>__N____N____N____N__	    <?php includeContainer(\'sidebar\'); ?>__N__		__N__	</div>__N__</div>__N____N__<?php includeContainer(\'footer\'); ?>', '', 0);

-- Page ID 9__+MAX_llx_website_page__ - Aliases navbar --;
INSERT INTO llx_website_page(rowid, fk_page, fk_website, pageurl, aliasalt, title, description, lang, image, keywords, status, date_creation, tms, import_key, grabbed_from, type_container, htmlheader, content, author_alias, allowed_in_frames) VALUES(9__+MAX_llx_website_page__, null, __WEBSITE_ID__, 'navbar', '', 'navbar', '', '', '', '', '1', '2025-04-08 14:20:56', '2025-05-16 14:26:37', null, '', 'menu', '', '<?php__N__includeContainer(\'_library_lib.php\', 1);__N__setSessionLang();__N__$socInfo = getSocInfo();__N____N__// Get available langs for the website__N__$website_langs = getAvailableLangs();__N__$available_langs = $website_langs[\'langs\'];__N__if (getDolGlobalString(\'WS_\'.strtoupper($website->ref).\'_\' . \'SUPPORTED_LANGS\')) {__N__    $used_langs = explode(\',\', getDolGlobalString(\'WS_\'.strtoupper($website->ref).\'_\' . \'SUPPORTED_LANGS\'));__N__    foreach ($available_langs as $key => $value) {__N__        if (!in_array($key, $used_langs)) {__N__            unset($available_langs[$key]);__N__        }__N__    }__N__}__N____N__$langs_code_shortcode = $website_langs[\'langs_code_shortcode\'];__N____N__//$weblangs->load(\"website\", \"languages\");__N__//$langs->load(\"website\", \"languages\");__N__?>__N__<div class=\"site-mobile-menu site-navbar-target\">__N__  <div class=\"site-mobile-menu-header\">__N__    <div class=\"site-mobile-menu-close mt-3\">__N__      <span class=\"icon-close2 js-menu-toggle\"></span>__N__    </div>__N__  </div>__N__  <div class=\"site-mobile-menu-body\"></div>__N__</div>__N____N__<header class=\"site-navbar js-sticky-header js-sticky-header-blog site-navbar-target\" role=\"banner\">__N____N__  <div class=\"container\">__N__    <div class=\"row align-items-center\">__N__      __N__      <div class=\"col-6 col-xl-2\">__N__        <?php__N__            if(getDolGlobalInt(\'WS_\'.strtoupper($website->ref).\'_\' . \'USE_TEXT_LOGO\')) {__N__                $html_logo = $mysoc->name . \'<span class=\"text-secondary-color\">.</span>\';__N__            } else {__N__                $path = getImageFileNameForSize($mysoc->logo_squarred ? $mysoc->logo_squarred : $mysoc->logo, \'_small\');__N__                $html_logo = \'<img class=\"logo img-responsive-logo img-responsive\" alt=\"\" height=\"42\" src=\"\' . DOL_URL_ROOT . \'/viewimage.php?modulepart=mycompany&file=\'.urlencode(\'logos/\'.$path).\'\">\'; __N__            }__N__          __N__            __N__        ?>__N__        <h1 class=\"mb-0 site-logo\"><a href=\"/index\"><?php print $html_logo; ?> </a></h1>__N__      </div>__N____N__      <div class=\"col-12 col-md-10 d-none d-xl-block\">__N__        <nav class=\"site-navigation position-relative text-right\" role=\"navigation\">__N____N__        <ul class=\"site-menu main-menu js-clone-nav mr-auto d-none d-lg-block\" style=\"float: right;\">__N__            <li class=\"has-children\">__N__                <a class=\"nav-link\"><?php echo $weblangs->trans(\"presentation\"); ?></a>__N__                <ul class=\"dropdown\">__N__                    <li><a href=\"/index#section-overview\" class=\"nav-link\"><?php echo $weblangs->trans(\"missionVision\"); ?></a></li>__N__                    <?php if (getDolGlobalInt(\'WS_\'.strtoupper($website->ref).\'_\' . \'ENABLE_MEMBER_LIST_PAGE\')): ?>__N__                        <li><a href=\"members-list.php\" class=\"nav-link\"><?php echo $weblangs->trans(\"directory\"); ?></a></li>__N__                    <?php endif; ?>__N__                </ul>__N__            </li>__N__            <li class=\"has-children\">__N__                <a class=\"nav-link\"><?php echo $weblangs->trans(\"newsEvents\"); ?></a>__N__                <ul class=\"dropdown\">__N__                    <li><a href=\"index#section-news\" class=\"nav-link\"><?php echo $weblangs->trans(\"news\"); ?></a></li>__N__                    <?php if (isModEnabled(\'eventorganization\') && !getDolGlobalInt(\'WS_\'.strtoupper($website->ref).\'_\' . \'DISABLE_EVENTS_SECTION\')): ?>__N__                        <li><a href=\"index#section-events\" class=\"nav-link\"><?php echo $weblangs->trans(\"actionsEvents\"); ?></a></li>__N__                    <?php endif; ?>__N__                </ul>__N__            </li>__N__            <li class=\"has-children\">__N__                <a class=\"nav-link\"><?php echo $weblangs->trans(\"commitmentSupport\"); ?></a>__N__                <ul class=\"dropdown\">__N__                    <?php if (isModEnabled(\'member\') && getDolGlobalInt(\'MEMBER_ENABLE_PUBLIC\')): ?>__N__                        <li><a href=\"<?php print $socInfo[\'subscription_link\']; ?>\" target=\"new\" class=\"nav-link\"><?php echo $weblangs->trans(\"becomeMember\"); ?></a></li>__N__                    <?php endif; ?>__N__                    __N__                    <?php if (isModEnabled(\'don\') && getDolGlobalInt(\'DONATION_ENABLE_PUBLIC\')): ?>__N__                        <li><a href=\"<?php print $socInfo[\'link_donation\']; ?>\" target=\"new\" class=\"nav-link\"><?php echo $weblangs->trans(\"makeDonation\"); ?></a></li>__N__                        <?php if (getDolGlobalInt(\'DONATION_COUNTERS_ARE_PUBLIC\')): ?>__N__                            <li><a href=\"donation-list.php\" class=\"nav-link\"><?php echo $weblangs->trans(\"listOfPublicDonations\"); ?></a></li>__N__                        <?php endif; ?>__N__                    <?php endif; ?>__N__                </ul>__N__            </li>__N__            <li>__N__                <a href=\"index#section-contact\" class=\"nav-link\"><?php echo $weblangs->trans(\"contact\"); ?></a>__N__            </li>__N__            __N__            <?php if (isModEnabled(\'webportal\') && getDolGlobalInt(\'WS_\'.strtoupper($website->ref).\'_\' . \'ENABLE_MEMBER_AREA_PAGE\')): ?>__N__              <?php__N__              if (getDolGlobalString(\'WEBPORTAL_ROOT_URL\')) {__N__                $url = getDolGlobalString(\'WEBPORTAL_ROOT_URL\');__N__              } else {__N__                if (isModEnabled(\'multicompany\')) {__N__                  $entity_qr = \'?entity=\' . ((int) $conf->entity);__N__                } else {__N__                  $entity_qr = \'\';__N__                }__N____N__                $urlwithouturlroot = preg_replace(\'/\' . preg_quote(DOL_URL_ROOT, \'/\') . \'$/i\', \'\', trim($conf->file->dol_main_url_root));__N__                $urlwithroot = $urlwithouturlroot . DOL_URL_ROOT;__N__                $url = $urlwithroot . \'/public/webportal/index.php\' . $entity_qr;__N__              }__N__              ?>__N__              <li>__N__                <a href=\"<?php echo $url; ?>\" target=\"new\" class=\"nav-link\"><i class=\"fa-solid fa-user\"></i> <?php echo $weblangs->trans(\"memberArea\"); ?></a>__N__              </li>__N__            <?php endif; ?>__N__            __N__            <?php__N__                $socialIcons = [__N__                  \'facebook\' => \'fa-facebook-f\',__N__                  \'twitter\' => \'fa-x-twitter\',__N__                  \'linkedin\' => \'fa-linkedin-in\',__N__                  \'instagram\' => \'fa-instagram\',__N__                  \'youtube\' => \'fa-youtube\',__N__                  \'skype\' => \'fa-skype\',__N__                  \'whatsapp\' => \'fa-whatsapp\',__N__                  \'snapchat\' => \'fa-snapchat-ghost\',__N__                ];__N__    __N__                foreach ($socialIcons as $key => $icon) {__N__                  if (!empty($socInfo[$key])) {__N__                    echo \'<li class=\"social\"><a href=\"\' . htmlspecialchars($socInfo[$key]) . \'\" target=\"_blank\" class=\"nav-link\"><i class=\"fa-brands \' . $icon . \'\"></i></a></li>\';__N__                  }__N__                }__N__            ?>__N__            __N__            <?php if (getDolGlobalInt(\'WS_\'.strtoupper($website->ref).\'_\' . \'SHOW_LANG_SELECTOR\')): ?>__N__            <li class=\"has-children\">__N__                <a href=\"#language-section\" class=\"nav-link\"><?php print trim(explode(\'(\', $langs->trans(\"Language_\".$langs_code_shortcode[$_SESSION[\'lang\'][\'shortcode\']]))[0]); ?></a>__N__                <!--<a href=\"#language-section\" class=\"nav-link\"><?php print $_SESSION[\'lang\'][\'shortcode\']; ?></a>-->__N__                <ul class=\"dropdown lang-menu\">__N__                    <?php if (count($available_langs) > 1): ?>__N__                        <?php foreach ($available_langs as $key => $value) : ?>__N__                            <?php $value = trim(explode(\'(\', $langs->trans(\"Language_\".$langs_code_shortcode[$key]))[0]); ?>__N__                            <?php if ($key != $_SESSION[\'lang\'][\'shortcode\']): ?>__N__                        		<li>__N__                                  <form id=\"languageForm-<?php print $key; ?>\" method=\"post\" action=\"#\">__N__                                    <input type=\"hidden\" name=\"l\" value=\"<?php print $key; ?>\">__N__                                    <a href=\"#\" class=\"nav-link\" title=\"<?php print $langs->trans(\"Language_\".$langs_code_shortcode[$key]); ?>\" onclick=\"__N__                                           const form = document.getElementById(\'languageForm-<?php print $key; ?>\');__N__                                           const parser = document.createElement(\'a\');__N__                                           parser.href = form.action || window.location.href;__N__                                           const params = new URLSearchParams(parser.search);__N__                                           params.delete(\'l\');__N__                                           parser.search = params.toString();__N__                                           form.action = parser.href;__N__                                           form.submit();__N__                                           return false;__N__                                       \">    __N__                                      <?php print $value ; ?>__N__                                    </a>__N__                                  </form>__N__                                </li>__N__                        	<?php endif ?>__N__                        <?php endforeach ?>__N__                    <?php endif ?>__N__                </ul>__N__            </li>__N__            <?php endif; ?>__N__            __N__        </ul>__N__        </nav>__N__      </div>__N____N____N__      <div class=\"col-6 d-inline-block d-xl-none ml-md-0 py-3\" style=\"position: relative; top: 3px;\">__N__        <a href=\"#\" class=\"site-menu-toggle js-menu-toggle float-right\">__N__            <i class=\"fas fa-bars\"></i>__N__        </a>__N__      </div>__N____N__    </div>__N__  </div>__N__  __N__</header>', '', 0);

-- Page ID 10__+MAX_llx_website_page__ - Aliases news --;
INSERT INTO llx_website_page(rowid, fk_page, fk_website, pageurl, aliasalt, title, description, lang, image, keywords, status, date_creation, tms, import_key, grabbed_from, type_container, htmlheader, content, author_alias, allowed_in_frames) VALUES(10__+MAX_llx_website_page__, null, __WEBSITE_ID__, 'news', '', 'news', '', '', '', '', '1', '2025-04-14 14:16:15', '2025-05-16 14:25:57', null, '', 'banner', '', '<div class=\"container-fluid causes\">__N__    <div class=\"container py-5\">__N__        <div class=\"section-title\" id=\"section-news\" style=\"scroll-margin-top: 100px;\">__N__          <div class=\"line left-line\"></div>__N__          <h1><?php echo $weblangs->trans(\"news\"); ?></h1>__N__          <div class=\"line right-line\"></div>__N__        </div>__N__        <div class=\"row g-4\">__N__        <?php __N__        $MAXNEWS = GETPOSTINT(\'maxnews\') ? GETPOSTINT(\'maxnews\') : 3;__N__        $allblogs = $websitepage->fetchAll($website->id, \'DESC\', \'date_creation\', 0, 0, array(\'type_container\'=>\'blogpost\', \'status\'=>1, \'lang\'=>\'null, \"\" \'.$_SESSION[\'lang\'][\'shortcode\']));__N__        $countofblogs = count($allblogs);__N__        $arrayofblogs = $websitepage->fetchAll($website->id, \'DESC\', \'date_creation\', $MAXNEWS, 0, array(\'type_container\'=>\'blogpost\', \'status\'=>1, \'lang\'=>\'null, \"\" \'.$_SESSION[\'lang\'][\'shortcode\']));__N__        $i=1;__N__        foreach($arrayofblogs as $blog)__N__        {__N__        ?>__N__            <div class=\"col-lg-6 col-xl-4 blog-item\" id=\"blog-<?php echo $i; ?>\">__N__                <div class=\"causes-item\">__N__                    <div class=\"causes-img\">__N__                        <?php__N__                            $urlforimage = getImageFromHtmlContent($blog->content);__N__                            if (empty($urlforimage)) {__N__                                $urlforimage = \'medias/image/\'.$website->ref.\'/noimage.jpg\';__N__                            }__N__                        ?>__N__                        <img src=\"<?php echo $urlforimage; ?>\" class=\"img-fluid w-100\" style=\"height: 275px; object-fit: cover;\" alt=\"Image\">__N__                    </div>__N__                    <div class=\"progress progress-news\">__N__                      <div class=\"progress-bar\" role=\"progressbar\" style=\"width: 100%;\" aria-valuenow=\"100\" aria-valuemin=\"0\" aria-valuemax=\"100\">__N__                      </div>__N__                    </div>__N__                    <div class=\"causes-content p-4\">__N__                        <span class=\"text-body\">__N__                            <i class=\"fas fa-calendar-alt me-2\"></i> <?php echo dol_print_date($blog->date_creation, \'daytext\', \'tzuser\', $weblangs); ?>__N__                            <span class=\"author-span\"><i class=\"fas fa-user me-2\"></i> <?php echo ($blog->author_alias ? $blog->author_alias : \'anonymous\'); ?></span>__N__                        </span>__N__                        <h4 class=\"py-3\"><?php echo $blog->title; ?></h4>__N__                        <hr>__N__                        <p class=\"mb-4 truncate3\"><?php echo $blog->description; ?></p>__N__                        <a href=\"page.php?ref=<?php print $blog->pageurl; ?>&blog=<?php print $blog->id; ?>\" class=\"btn flat-button text-white py-2 px-3 float-end\"><?php echo $weblangs->trans(\"readMore\"); ?></a>__N__                    </div>__N__                </div>__N__            </div>__N__            <?php __N__            $i++;__N__        }__N__        ?>__N__        </div>__N__        __N__        <?php if ($MAXNEWS <= $countofblogs) { ?>__N__            <div class=\"row\">__N__                <div class=\"col-lg-7 text-center py-5 section-title\">__N__                    <div class=\"line left-line left-gradient\"></div>__N__                    <a href=\"javascript:void(0);\" class=\"btn flat-button text-white bgmaincolor\" id=\"loadMoreNewsBtn\"><?php echo $weblangs->trans(\"loadMore\"); ?>...</a>__N__                    <div class=\"line right-line right-gradient\"></div>__N__                </div>__N__            </div>__N__        <?php } ?>__N__        <script>__N__            document.getElementById(\'loadMoreNewsBtn\').addEventListener(\'click\', function() {__N__            const currentUrl = new URL(window.location.href);__N__            const maxNewsParam = <?php echo $MAXNEWS; ?>;__N__            const newMaxNews = parseInt(maxNewsParam) + 3;__N__            currentUrl.searchParams.set(\'maxnews\', newMaxNews);__N__            currentUrl.hash = \'#blog-\' + (parseInt(maxNewsParam) + 1).toString();__N__            window.location.href = currentUrl.toString();__N__            });__N__        </script>__N__            __N__            __N__    </div>__N__</div>', '', 0);

-- Page ID 11__+MAX_llx_website_page__ - Aliases our-company-is-now-on-dolibarr-erp-crm --;
INSERT INTO llx_website_page(rowid, fk_page, fk_website, pageurl, aliasalt, title, description, lang, image, keywords, status, date_creation, tms, import_key, grabbed_from, type_container, htmlheader, content, author_alias, allowed_in_frames) VALUES(11__+MAX_llx_website_page__, null, __WEBSITE_ID__, 'our-company-is-now-on-dolibarr-erp-crm', '', 'Our company is now on Dolibarr ERP CRM', 'Like several thousands of companies, our company (DMNA) has moved all its information system to Dolibarr ERP CRM. More than 20 applications have been replaced by only one.', '', '', '', '1', '2025-04-14 15:39:29', '2025-05-07 10:24:39', null, '', 'blogpost', '', '<article>__N__    <div id=\"article\" contenteditable=\"true\">__N__        Like several thousands of companies, our company (<?php echo $mysoc->name ?>) has moved all its information system to <a href=\"https://www.dolibarr.org\">Dolibarr ERP CRM</a>. More than 20 applications have been replaced by only one, easier to use and fully integrated.__N__        This is an important step in improving all of our services.__N__        __N__        <br><br><br>__N__        __N__        <figure>__N__        <img src=\"/viewimage.php?modulepart=medias&file=image/exemple/background_dolibarr.webp\">__N__        <br><br>__N__        <figcaption style=\"opacity: 0.5; text-align: center;\">Screenshot of our new Open Source solution</figcaption>__N__        </figure>__N__    </div>__N__</article>', '', 0);

-- Page ID 12__+MAX_llx_website_page__ - Aliases our-new-web-site-has-been-launched --;
INSERT INTO llx_website_page(rowid, fk_page, fk_website, pageurl, aliasalt, title, description, lang, image, keywords, status, date_creation, tms, import_key, grabbed_from, type_container, htmlheader, content, author_alias, allowed_in_frames) VALUES(12__+MAX_llx_website_page__, null, __WEBSITE_ID__, 'our-new-web-site-has-been-launched', '', 'Our new web site has been launched', 'Now it is modern and directly integrated with the internal management tools of the company. Many new online services will be available for our customers', '', '', '', '1', '2025-04-08 14:18:29', '2025-05-07 10:25:04', null, '', 'blogpost', '', '<article>__N__    <div id=\"article\" contenteditable=\"true\">__N__            Our new website, based on Dolibarr CMS, has been launched. <br>__N__            Now it is modern and directly integrated with the internal management tools of the company. Many new online services will be available for our customers...__N__            <br><br>__N__            <figure>__N__            <img src=\"/viewimage.php?modulepart=medias&file=image/__WEBSITE_KEY__/5.jpg\">__N__            <br><br>__N__            <figcaption style=\"opacity: 0.5; text-align: center;\">Theme of our new web site</figcaption>__N__            </figure>__N__    </div>__N__</article>', '', 0);

-- Page ID 13__+MAX_llx_website_page__ - Aliases overview --;
INSERT INTO llx_website_page(rowid, fk_page, fk_website, pageurl, aliasalt, title, description, lang, image, keywords, status, date_creation, tms, import_key, grabbed_from, type_container, htmlheader, content, author_alias, allowed_in_frames) VALUES(13__+MAX_llx_website_page__, null, __WEBSITE_ID__, 'overview', '', 'overview', '', 'en', '', '', '1', '2025-04-08 14:30:11', '2025-05-16 14:26:04', null, '', 'banner', '', '<?php__N__includeContainer(\'_library_lib.php\', 1);__N__setSessionLang();__N__$socInfo = getSocInfo();__N__?>__N__<div class=\"container-fluid volunteer\">__N__    <div class=\"container py-5\">__N____N__        <div class=\"row g-5\">__N__            __N__            <div class=\"col-lg-9\">__N____N__              <div class=\"section-title\" id=\"section-overview\" style=\"scroll-margin-top: 100px;\">__N__                <div class=\"line left-line\"></div>__N__                <h1><?php echo $weblangs->trans(\"missionVision\"); ?></h1>__N__                <div class=\"line right-line\"></div>__N__              </div>__N__            __N__              <p class=\"mb-4\">__N__                <?php echo $weblangs->trans(\"missionVisionDesc\"); ?>__N__              </p>__N__              <p class=\"text-dark\"><i class=\"fa fa-check secondary-color me-2\"></i> <?php echo $weblangs->trans(\"SampleGoalOne\"); ?></p>__N__              <p class=\"text-dark\"><i class=\"fa fa-check secondary-color me-2\"></i> <?php echo $weblangs->trans(\"SampleGoaltwo\"); ?></p>__N__              <p class=\"text-dark\"><i class=\"fa fa-check secondary-color me-2\"></i> <?php echo $weblangs->trans(\"SampleGoalthree\"); ?></p>__N__              __N__                <?php if (isModEnabled(\'member\') && getDolGlobalInt(\'MEMBER_ENABLE_PUBLIC\')): ?>__N__                    <a href=\"<?php print $socInfo[\'subscription_link\']; ?>\" target=\"new\" class=\"btn flat-button text-white py-2 px-3\"><?php echo $weblangs->trans(\"joinUs\"); ?></a>__N__                <?php endif; ?>__N__            </div>__N____N__            __N__            <?php includeContainer(\'highlights\'); ?>__N__        </div>__N__    </div>__N__</div>', '', 0);

-- Page ID 14__+MAX_llx_website_page__ - Aliases page --;
INSERT INTO llx_website_page(rowid, fk_page, fk_website, pageurl, aliasalt, title, description, lang, image, keywords, status, date_creation, tms, import_key, grabbed_from, type_container, htmlheader, content, author_alias, allowed_in_frames) VALUES(14__+MAX_llx_website_page__, null, __WEBSITE_ID__, 'page', '', 'page', '', '', '', '', '1', '2025-04-16 10:10:24', '2025-05-16 14:27:25', null, '', 'page', '', '<?php__N__includeContainer(\'_library_lib.php\', 1);__N__setSessionLang();__N__$socInfo = getSocInfo();__N____N__$pageId = GETPOSTINT(\'blog\');__N__$eventId = GETPOSTINT(\'id\');__N__$donationForId = GETPOSTINT(\'donation\');__N____N__if ((!$pageId && !$eventId && !$donationForId) || ($pageId && $eventId)) {__N__    redirectToContainer(\'index\');__N__}__N____N__$showEventGoalRaised = 0;__N__if (isModEnabled(\'don\') && getDolGlobalString(\'DONATION_ENABLE_PUBLIC\') && isModEnabled(\'eventorganization\') && getDolGlobalString(\'WS_\'.strtoupper($website->ref).\'_\' . \'SHOW_EVENT_GOAL_RAISED_AMOUNTS\')) {__N__    $showEventGoalRaised = 1;__N__}__N____N__$showDonationLink = 0;__N__if (isModEnabled(\'don\') && getDolGlobalString(\'DONATION_ENABLE_PUBLIC\')) {__N__    $showDonationLink = 1;__N__}__N____N__$showParticipateLink = 0;__N__if (isModEnabled(\'eventorganization\') && getDolGlobalString(\'WS_\'.strtoupper($website->ref).\'_\' . \'SHOW_EVENT_PARTICIPATE_LINK\')) {__N__    $showParticipateLink = 1;__N__}__N____N__$data = array();__N__if ($pageId) {__N__    $type = \"blogpage\";__N__    $blog = $websitepage->fetch($pageId);__N__    if ($blog < 0) {__N__        redirectToContainer(\'index\');__N__    } else {__N__        $data[\'date_creation\'] = $websitepage->date_creation;__N__        $data[\'author_alias\'] = ($websitepage->author_alias ? $websitepage->author_alias : \'\');__N__        $data[\'title\'] = $websitepage->title;__N__        $data[\'content\'] = $websitepage->content;__N__        $data[\'budget_amount\'] = 0;__N__        $data[\'collected\'] = 0;__N__        $data[\'type\'] = $type;__N__    }__N__}__N____N__if ($eventId) {__N__    if (!isModEnabled(\'eventorganization\') || getDolGlobalInt(\'WS_\'.strtoupper($website->ref).\'_\' . \'DISABLE_EVENTS_SECTION\')) {__N__        redirectToContainer(\'index\');__N__    }__N__    $type = \"eventpage\";__N__    __N__    $sql = \"SELECT p.rowid, p.title, p.description, p.datec, p.dateo, p.datee, p.budget_amount, p.fk_statut __N__        FROM \".MAIN_DB_PREFIX.\"projet as p __N__        WHERE p.fk_statut IN (0,1) AND p.usage_organize_event IN (1) AND p.rowid = \" . $eventId;__N__        __N__    $resql = $db->query($sql);__N__    if ($resql) {__N__        $obj = $db->fetch_object($resql);__N__        $collected = 0;__N__        if ($obj->budget_amount > 0) {__N__            $sqlCollected = \"SELECT SUM(amount) as total_collected __N__                             FROM \".MAIN_DB_PREFIX.\"don __N__                             WHERE fk_projet = \".$obj->rowid;__N__            $resqlCollected = $db->query($sqlCollected);__N__            __N__            if ($resqlCollected) {__N__                $objCollected = $db->fetch_object($resqlCollected);__N__                $collected = $objCollected->total_collected ? $objCollected->total_collected : 0;__N__            }__N__        }__N__        __N__        $data[\'date_creation\'] = $obj->datec;__N__        $data[\'author_alias\'] = \"\";__N__        $data[\'title\'] = $obj->title;__N__        $data[\'content\'] = $obj->description;__N__        $data[\'budget_amount\'] = $obj->budget_amount;__N__        $data[\'collected\'] = $collected;__N__        $data[\'type\'] = $type;__N__       __N__    } else {__N__        redirectToContainer(\'index\');__N__    }__N__}__N____N__if ($donationForId) {__N__    $type = \"donationpage\";__N__    __N__    $sql = \"SELECT p.rowid, p.title, p.description, p.datec, p.dateo, p.datee, p.budget_amount, p.fk_statut __N__        FROM \".MAIN_DB_PREFIX.\"projet as p __N__        WHERE p.fk_statut IN (0,1) AND p.usage_organize_event IN (1) AND p.rowid = \" . $donationForId;__N__        __N__    $resql = $db->query($sql);__N__    if ($resql) {__N__        $obj = $db->fetch_object($resql);__N__        $collected = 0;__N__        if ($obj->budget_amount > 0) {__N__            $sqlCollected = \"SELECT SUM(amount) as total_collected __N__                             FROM \".MAIN_DB_PREFIX.\"don __N__                             WHERE fk_projet = \".$obj->rowid;__N__            $resqlCollected = $db->query($sqlCollected);__N__            __N__            if ($resqlCollected) {__N__                $objCollected = $db->fetch_object($resqlCollected);__N__                $collected = $objCollected->total_collected ? $objCollected->total_collected : 0;__N__            }__N__        }__N__        __N__        $data[\'date_creation\'] = $obj->datec;__N__        $data[\'author_alias\'] = \"\";__N__        $data[\'title\'] = $obj->title;__N__        $data[\'content\'] = \'<div id=\"iframe-container\"><iframe id=\"donationFrame\" frameborder=\"0\" style=\"overflow:hidden;width:100%;height:100%;\" src=\"\' . $socInfo[\'link_donation\'] . \'?project_id=\' . urlencode($donationForId) . \'&ws=\' . urlencode($website->id) . \'\"__N__></iframe></div>\';__N__        $data[\'budget_amount\'] = $obj->budget_amount;__N__        $data[\'collected\'] = $collected;__N__        $data[\'type\'] = $type;__N__       __N__    } else {__N__        redirectToContainer(\'index\');__N__    }__N__}__N____N__/*print \"<pre>\";__N__print_r ($data);__N__print \"</pre>\";*/__N__define(\"__SEO_PAGE_TITLE__\", $data[\'title\']); __N__?>__N__    __N__<?php includeContainer(\'navbar\'); ?>__N____N__<div class=\"js-sticky-header-blog\"></div>__N____N__<section class=\"slogan has-section-divider\" style=\"min-height: 190px;\">__N__    <div class=\"container d-flex justify-content-center align-items-center \" style=\"min-height: 190px;\">__N__        <div class=\"col-lg-12 text-center breadcrumb-box\">__N__            __N__            <ol class=\"breadcrumb justify-content-center mb-3 lead\">__N__				<li class=\"breadcrumb-item\"><a href=\"/\" class=\"text-decoration-none\"><?php echo $weblangs->trans(\"home\"); ?></a></li>__N__				<li class=\"breadcrumb-item\">__N__				    <a href=\"/events\" class=\"text-decoration-none\">__N__				        <?php echo $weblangs->trans($data[\'type\'] === \"blogpage\" ? \"news\" : \"actionsEvents\"); ?>__N__				    </a>__N__				</li>__N__			</ol>__N__			__N__            <h1 class=\"mb-3\"><?php print $data[\'title\']; ?></h1>__N__            <span>__N__                <i class=\"fas fa-calendar-alt me-2\"></i> <?php echo dol_print_date($data[\'date_creation\'], \'daytext\', \'tzuser\', $weblangs); ?>__N__                __N__                <?php if ($data[\'type\'] == \"blogpage\") { ?>__N__                    <span class=\"author-span ms-3\"><i class=\"fas fa-user me-2\"></i> __N__                        <?php __N__                            if ($data[\'author_alias\']) { __N__                                echo $data[\'author_alias\']; __N__                            } else { __N__                                echo $weblangs->trans(\"anonymous\");__N__                            } __N__                        ?> __N__                    </span>__N__                <?php } ?>__N__                __N__                <?php if ($data[\'budget_amount\'] && $showEventGoalRaised) { ?>__N__                    <span class=\"text-white ms-3\"><i class=\"fas fa-chart-bar secondary-color me-2\"></i><?php echo $weblangs->trans(\"goal\"); ?>: <?php print price(price2num($data[\'budget_amount\'], \'MT\'), 1, \'\', 1, -1); ?> €</span>__N__                <?php } ?>__N__                __N__                <?php if ($data[\'budget_amount\'] && $showEventGoalRaised) { ?>__N__                    <span class=\"text-white ms-3\"><i class=\"fa fa-thumbs-up secondary-color me-2\"></i><?php echo $weblangs->trans(\"raised\"); ?>: <?php print price(price2num($data[\'collected\'], \'MT\'), 1, \'\', 1, -1); ?> €</span>__N__                <?php } ?>__N__            </span>__N__        </div>__N__    </div>__N__    <svg class=\"section-divider\" viewBox=\"0 0 1920 60\" aria-hidden=\"true\"><path data-theme=\"softSecondary\" fill=\"white\" d=\"M0,80.75H1920V45.833H1742.083a80.491,80.491,0,0,1,12.863-1.55c5.2-.26,17.24-.3,24.153-.24,26.69.222,54.377,1.094,79.341.96,19.287-.1,37.1-.372,53.573-.788L1920,44V34.078l-6.614.216-9.221.256c-6.252.147-12.7.249-19.265.32-13.132.14-26.739.15-40.206.125-26.935-.052-53.313-.247-74.22.168-14.367-1.4-32.582-.756-48.293-1.92-10.145.509-20.876.936-24.149,2.4-16.09-.266-37.611,2.532-50.019.479V34.684c-10.959-2.291-33.371-1.869-48.292-3.84-15.861-.512-26.214,1.347-39.671,1.92-7.032.178-5.941-.773-13.8-.481-40.751-.071-41.131,5.477-62.087,8.16-4.569-5.691-47.085-5.126-77.622-5.04-2.333-4.154-22.643-5.808-50.015-6.479-4.677-2.069-17.763-2.969-22.423-5.04-4.7-.175-3.474.477-6.9.479-11.485-2.964-40.092-2.449-63.813-3.36-23.312.6-29.4,3.589-55.195,3.841-8.3-3.783-56.5-4.561-84.513-3.361-.316-1.857-5.682-3.862-20.7-4.8-2.193-.137-6.78.122-10.352,0-16.331-.564-22.974-3.145-39.671-1.441-22.812-1.938-73.831-3.919-98.311-.719-4.315-2.2-15.369-3.462-20.7-5.521-23.122-.714-41.26-2.815-65.54-2.64-13.5,1-29.918,1.6-39.671,3.12.27,1.317-1.305,2.38-6.9,2.88-35.562-1.333-83.117-2.545-93.139,2.88-14.338-.314-8.341,2.2-22.423,1.92-5.17-.16-2.615-1.4-6.9-1.68-36.327-1.894-80.653-1.762-100.041,2.161-12.433-1.631-21.648-3.708-36.221-5.04-13.359.1-36.33-.325-48.293-1.2-32.483.6-42.463,4.331-53.471,7.92-25.227-.147-43.752,2.274-58.641,4.321-11.966-1.189-27.56-.426-39.67-1.441-19.514,1.284-40.772,2.328-53.468,4.561C301.584,31.04,294,33.888,283.7,37.8c-15.047-.774-19.865-3.5-36.221-4.321-10.453-.522-37.12-1.01-48.3-.959-10.184.046-17.188,1.062-27.595.719-18.244,2.022-31.516,4.736-46.57,7.2-3.726,2.091-9.8,3.854-17.5,5.39H4.061c-.734-1.281-1.512-2.592-2.344-3.949-.546-.09-1.13-.175-1.717-.26Z\"/></svg>__N__  __N__</section>__N__        __N__<div class=\"container mt-5\">__N__	<div class=\"row\">__N____N__		<div class=\"<?php echo $data[\'type\'] === \'donationpage\' ? \'col-md-12\' : \'col-md-8\'; ?>\" style=\"min-height:1200px;\">__N__			<article id=\"content\">__N__				<?php print html_entity_decode($data[\'content\']); ?>__N__			</article>__N__		</div>__N__		__N__		<?php if ($data[\'type\'] !== \"donationpage\") { ?>__N__		    <?php includeContainer(\'sidebar\'); ?>__N__		<?php } ?>__N__		__N__	</div>__N__</div>__N____N__<?php includeContainer(\'footer\'); ?>', '', 0);

-- Page ID 15__+MAX_llx_website_page__ - Aliases rgpd --;
INSERT INTO llx_website_page(rowid, fk_page, fk_website, pageurl, aliasalt, title, description, lang, image, keywords, status, date_creation, tms, import_key, grabbed_from, type_container, htmlheader, content, author_alias, allowed_in_frames) VALUES(15__+MAX_llx_website_page__, null, __WEBSITE_ID__, 'rgpd', '', 'rgpd', '', 'en', '', '', '1', '2025-05-05 13:44:30', '2025-05-16 14:27:32', null, '', 'page', '', '<?php__N__includeContainer(\'_library_lib.php\', 1);__N__setSessionLang();__N____N__define(\"__SEO_PAGE_TITLE__\", $weblangs->trans(\"RGPD\")); __N__?>__N__    __N__<?php includeContainer(\'navbar\'); ?>__N____N__<div class=\"js-sticky-header-blog\"></div>__N____N__<section class=\"slogan has-section-divider\" style=\"min-height: 190px;\">__N__    <div class=\"container d-flex justify-content-center align-items-center \" style=\"min-height: 190px;\">__N__        <div class=\"col-lg-12 text-center breadcrumb-box\">__N__            __N__            <ol class=\"breadcrumb justify-content-center mb-3 lead\">__N__				<li class=\"breadcrumb-item\"><a href=\"/\" class=\"text-decoration-none\"><?php echo $weblangs->trans(\"home\"); ?></a></li>__N__				<li class=\"breadcrumb-item\">__N__				    <a href=\"/events\" class=\"text-decoration-none\">__N__				        <?php echo $weblangs->trans(\"RGPD\"); ?>__N__				    </a>__N__				</li>__N__			</ol>__N__			__N__            <h1 class=\"mb-3\"><?php echo $weblangs->trans(\"RGPD\"); ?></h1>__N__        </div>__N__    </div>__N__    <svg class=\"section-divider\" viewBox=\"0 0 1920 60\" aria-hidden=\"true\"><path data-theme=\"softSecondary\" fill=\"white\" d=\"M0,80.75H1920V45.833H1742.083a80.491,80.491,0,0,1,12.863-1.55c5.2-.26,17.24-.3,24.153-.24,26.69.222,54.377,1.094,79.341.96,19.287-.1,37.1-.372,53.573-.788L1920,44V34.078l-6.614.216-9.221.256c-6.252.147-12.7.249-19.265.32-13.132.14-26.739.15-40.206.125-26.935-.052-53.313-.247-74.22.168-14.367-1.4-32.582-.756-48.293-1.92-10.145.509-20.876.936-24.149,2.4-16.09-.266-37.611,2.532-50.019.479V34.684c-10.959-2.291-33.371-1.869-48.292-3.84-15.861-.512-26.214,1.347-39.671,1.92-7.032.178-5.941-.773-13.8-.481-40.751-.071-41.131,5.477-62.087,8.16-4.569-5.691-47.085-5.126-77.622-5.04-2.333-4.154-22.643-5.808-50.015-6.479-4.677-2.069-17.763-2.969-22.423-5.04-4.7-.175-3.474.477-6.9.479-11.485-2.964-40.092-2.449-63.813-3.36-23.312.6-29.4,3.589-55.195,3.841-8.3-3.783-56.5-4.561-84.513-3.361-.316-1.857-5.682-3.862-20.7-4.8-2.193-.137-6.78.122-10.352,0-16.331-.564-22.974-3.145-39.671-1.441-22.812-1.938-73.831-3.919-98.311-.719-4.315-2.2-15.369-3.462-20.7-5.521-23.122-.714-41.26-2.815-65.54-2.64-13.5,1-29.918,1.6-39.671,3.12.27,1.317-1.305,2.38-6.9,2.88-35.562-1.333-83.117-2.545-93.139,2.88-14.338-.314-8.341,2.2-22.423,1.92-5.17-.16-2.615-1.4-6.9-1.68-36.327-1.894-80.653-1.762-100.041,2.161-12.433-1.631-21.648-3.708-36.221-5.04-13.359.1-36.33-.325-48.293-1.2-32.483.6-42.463,4.331-53.471,7.92-25.227-.147-43.752,2.274-58.641,4.321-11.966-1.189-27.56-.426-39.67-1.441-19.514,1.284-40.772,2.328-53.468,4.561C301.584,31.04,294,33.888,283.7,37.8c-15.047-.774-19.865-3.5-36.221-4.321-10.453-.522-37.12-1.01-48.3-.959-10.184.046-17.188,1.062-27.595.719-18.244,2.022-31.516,4.736-46.57,7.2-3.726,2.091-9.8,3.854-17.5,5.39H4.061c-.734-1.281-1.512-2.592-2.344-3.949-.546-.09-1.13-.175-1.717-.26Z\"/></svg>__N__  __N__</section>__N__        __N__<div class=\"container mt-5\">__N__	<div class=\"row\">__N__		<div class=\"col-md-12\" style=\"min-height:1200px;\">__N__			<p>__N__              We are committed to respecting your privacy and protecting any personal information you choose to share with us.  __N__              Your data is handled responsibly, securely, and in accordance with applicable data protection laws.  __N__              We believe in transparency, accountability, and safeguarding your rights at every step.__N__            </p>__N__		</div>__N__	</div>__N__</div>__N____N__<?php includeContainer(\'footer\'); ?>', '', 0);

-- Page ID 16__+MAX_llx_website_page__ - Aliases sidebar --;
INSERT INTO llx_website_page(rowid, fk_page, fk_website, pageurl, aliasalt, title, description, lang, image, keywords, status, date_creation, tms, import_key, grabbed_from, type_container, htmlheader, content, author_alias, allowed_in_frames) VALUES(16__+MAX_llx_website_page__, null, __WEBSITE_ID__, 'sidebar', '', 'sidebar', '', '', '', '', '1', '2025-04-16 11:08:11', '2025-05-16 14:26:11', null, '', 'banner', '', '<?php__N__includeContainer(\'_library_lib.php\', 1);__N__setSessionLang();__N__$socInfo = getSocInfo();__N____N__$pageId = GETPOSTINT(\'blog\');__N__$eventId = GETPOSTINT(\'id\');__N____N__$showDonationLink = 0;__N__if (isModEnabled(\'don\') && getDolGlobalString(\'DONATION_ENABLE_PUBLIC\')) {__N__    $showDonationLink = 1;__N__}__N____N__$showEventGoalRaised = 0;__N__if (isModEnabled(\'don\') && getDolGlobalString(\'DONATION_ENABLE_PUBLIC\') && isModEnabled(\'eventorganization\') && getDolGlobalString(\'WS_\'.strtoupper($website->ref).\'_\' . \'SHOW_EVENT_GOAL_RAISED_AMOUNTS\')) {__N__    $showEventGoalRaised = 1;__N__}__N____N__$showParticipateLink = 0;__N__if (isModEnabled(\'eventorganization\') && getDolGlobalString(\'WS_\'.strtoupper($website->ref).\'_\' . \'SHOW_EVENT_PARTICIPATE_LINK\')) {__N__    $showParticipateLink = 1;__N__}__N____N__$link_participation = \'\';__N____N__if ($eventId) {__N__    $sql = \"SELECT p.rowid, p.title, p.description, p.datec, p.dateo, p.datee, p.budget_amount, p.fk_statut __N__        FROM \".MAIN_DB_PREFIX.\"projet as p __N__        WHERE p.fk_statut IN (0,1) AND p.usage_organize_event IN (1) AND p.rowid = \" . $eventId;__N__        __N__    $resql = $db->query($sql);__N__    if ($resql) {__N__        $obj = $db->fetch_object($resql);__N__        $encodedsecurekey = dol_hash(getDolGlobalString(\'EVENTORGANIZATION_SECUREKEY\').\'conferenceorbooth\'.((int) $obj->rowid), \'md5\');__N__        $link_participation = $socInfo[\'link_participation\'] . \'&id=\'.urlencode($obj->rowid).\'&securekey=\'.urlencode($encodedsecurekey);__N__    }__N__}__N____N__?>__N__<div class=\"col-md-4\">__N____N__	__N__	<div class=\"container-fluid causes sidebar-joinus\">__N__        <div class=\"container\">__N__            <div class=\"section-title\">__N__              <div class=\"line left-line\"></div>__N__              <h1><?php echo $weblangs->trans(\"joinUs\"); ?></h1>__N__              <div class=\"line right-line\"></div>__N__            </div>__N__            <div class=\"row g-4\">__N__                <?php if ($showDonationLink) { ?>__N__                    <?php if ($eventId) { ?>__N__                        <a href=\"<?php echo $socInfo[\'link_donation\'] . \'?project_id=\'.urlencode($obj->rowid); ?>\" target=\"new\" class=\"btn flat-button text-white py-2 px-3\"><i class=\"fas fa-donate\"></i> <?php echo $weblangs->trans(\"donateNow\"); ?> </a>__N__                    <?php } else { ?>__N__                        <a href=\"<?php echo $socInfo[\'link_donation\']; ?>\" target=\"new\" class=\"btn flat-button text-white py-2 px-3\"><i class=\"fas fa-donate\"></i> <?php echo $weblangs->trans(\"donateNow\"); ?> </a>__N__                    <?php } ?>__N__                    __N__                <?php } ?>__N__                <?php if ($link_participation && $showParticipateLink) { ?>__N__                    <a href=\"<?php echo $link_participation; ?>\" target=\"new\" class=\"btn flat-button text-white py-2 px-3\"><i class=\"fas fa-user-plus\"></i> <?php echo $weblangs->trans(\"Participate\"); ?> </a>__N__                <?php } ?>__N__            </div>__N__        </div>__N__    </div>__N__	__N__	<div class=\"container-fluid causes\">__N__        <div class=\"container py-5\">__N__            <div class=\"section-title\">__N__              <div class=\"line left-line\"></div>__N__              <h1><?php echo $weblangs->trans(\"news\"); ?></h1>__N__              <div class=\"line right-line\"></div>__N__            </div>__N__            <div class=\"row g-4\">__N__            <?php __N__            $MAXNEWS = 2;__N__            $allblogs = $websitepage->fetchAll($website->id, \'DESC\', \'date_creation\', 0, 0, array(\'type_container\'=>\'blogpost\', \'status\'=>1, \'lang\'=>\'null, \"\" \'.$_SESSION[\'lang\'][\'shortcode\']));__N__            $countofblogs = count($allblogs);__N__            $arrayofblogs = $websitepage->fetchAll($website->id, \'DESC\', \'date_creation\', $MAXNEWS, 0, array(\'type_container\'=>\'blogpost\', \'status\'=>1, \'lang\'=>\'null, \"\" \'.$_SESSION[\'lang\'][\'shortcode\']));__N__            foreach($arrayofblogs as $blog)__N__            {__N__            ?>__N__                <div class=\"col-12-12\">__N__                    <div class=\"causes-item\">__N__                        <div class=\"causes-img\">__N__                            <?php__N__                                $urlforimage = getImageFromHtmlContent($blog->content);__N__                                if (empty($urlforimage)) {__N__                                    $urlforimage = \'medias/image/\'.$website->ref.\'/noimage.jpg\';__N__                                }__N__                            ?>__N__                            <img src=\"<?php echo $urlforimage; ?>\" class=\"img-fluid w-100\" style=\"height: 275px; object-fit: cover;\" alt=\"Image\">__N__                        </div>__N__                        <div class=\"progress progress-news\">__N__                          <div class=\"progress-bar\" role=\"progressbar\" style=\"width: 100%;\" aria-valuenow=\"100\" aria-valuemin=\"0\" aria-valuemax=\"100\">__N__                          </div>__N__                        </div>__N__                        <div class=\"causes-content p-4\">__N__                            <span class=\"text-body\">__N__                                <i class=\"fas fa-calendar-alt me-2\"></i> <?php echo dol_print_date($blog->date_creation, \'daytext\', \'tzuser\', $weblangs); ?>__N__                                <span class=\"author-span\"><i class=\"fas fa-user me-2\"></i> <?php echo ($blog->author_alias ? $blog->author_alias : \'anonymous\'); ?></span>__N__                            </span>__N__                            <h4 class=\"py-3\"><?php echo $blog->title; ?></h4>__N__                            <hr>__N__                            <p class=\"mb-4 truncate3\"><?php echo $blog->description; ?></p>__N__                            <a href=\"page.php?ref=<?php print $blog->pageurl; ?>&blog=<?php print $blog->id; ?>\" class=\"btn flat-button text-white py-2 px-3 float-end\"><?php echo $weblangs->trans(\"readMore\"); ?></a>__N__                        </div>__N__                    </div>__N__                </div>__N__                <?php __N__            }__N__            ?>__N__            </div>__N__                __N__        </div>__N__    </div>__N__    __N__    __N__    <div class=\"container-fluid causes\">__N__        <div class=\"container\">__N__            <div class=\"section-title\">__N__              <div class=\"line left-line\"></div>__N__              <h1><?php echo $weblangs->trans(\"actions\"); ?></h1>__N__              <div class=\"line right-line\"></div>__N__            </div>__N__            <div class=\"row g-4\">__N__    __N__                <?php __N__                $maxevents = 2;__N__                $countofevents = 0;__N__                $sqlCount = \"SELECT count(p.rowid) as countofevents __N__                        FROM \".MAIN_DB_PREFIX.\"projet as p __N__                        WHERE p.fk_statut IN (0,1) AND p.usage_organize_event IN (1) __N__                        ORDER BY p.datec DESC \";__N__                $resqlCount = $db->query($sqlCount);__N__                if ($resqlCount) {__N__                    $objCount = $db->fetch_object($resqlCount);__N__                    $countofevents = $objCount->countofevents ? $objCount->countofevents : 0;__N__                }__N__            __N__                $sql = \"SELECT p.rowid, p.title, p.description, p.datec, p.dateo, p.datee, p.budget_amount, p.fk_statut __N__                        FROM \".MAIN_DB_PREFIX.\"projet as p __N__                        WHERE p.fk_statut IN (0,1) AND p.usage_organize_event IN (1) __N__                        ORDER BY p.datec DESC __N__                        LIMIT \".$maxevents;__N__                $resql = $db->query($sql);__N__                if ($resql) {__N__                    $countofblogs = $db->num_rows($resql);__N__                    while ($obj = $db->fetch_object($resql)) {__N__                        ?>__N__                        <div class=\"col-xs-12\">__N__                            <div class=\"causes-item\">__N__                                <div class=\"causes-img\">__N__                                    <?php__N__                                        $urlforimage = getImageFromHtmlContent($obj->description ? $obj->description : \"\");__N__                                        if (empty($urlforimage)) {__N__                                            $urlforimage = \'medias/image/\'.$website->ref.\'/noimage.jpg\';__N__                                        }__N__                                    ?>__N__                                    <img src=\"<?php echo $urlforimage; ?>\" class=\"img-fluid w-100\" style=\"height: 275px; object-fit: cover;\" alt=\"Image\">__N__                                    <div class=\"causes-link pb-2 px-3\">__N__                                        <?php__N__                                            $progress = 100;__N__                                            if ($obj->budget_amount > 0 && $showEventGoalRaised) {__N__                                                $sqlCollected = \"SELECT SUM(amount) as total_collected __N__                                                                 FROM \".MAIN_DB_PREFIX.\"don __N__                                                                 WHERE fk_projet = \".$obj->rowid;__N__                                                $resqlCollected = $db->query($sqlCollected);__N__                                                $collected = 0;__N__                                                if ($resqlCollected) {__N__                                                    $objCollected = $db->fetch_object($resqlCollected);__N__                                                    $collected = $objCollected->total_collected ? $objCollected->total_collected : 0;__N__                                                }__N__                                                $progress = round(($collected / $obj->budget_amount) * 100, 2);__N__                                            }__N__                                        ?>__N__                                        __N__                                        <?php if ($showEventGoalRaised) { ?>__N__                                            <small class=\"text-white\"><i class=\"fas fa-chart-bar secondary-color me-2\"></i><?php echo $weblangs->trans(\"goal\"); ?>: <?php print price(price2num($obj->budget_amount, \'MT\'), 1, \'\', 1, -1); ?> €</small>__N__                                            <small class=\"text-white\"><i class=\"fa fa-thumbs-up secondary-color me-2\"></i><?php echo $weblangs->trans(\"raised\"); ?>: <?php print price(price2num($collected, \'MT\'), 1, \'\', 1, -1); ?> €</small>__N__                                        <?php } ?>  __N__                                    </div>__N__                                    <div class=\"causes-dination p-2\">__N__                                        <?php if ($showDonationLink) { ?>__N__                                            <?php if (getDolGlobalInt(\'WS_\' . strtoupper($website->ref) . \'_PAYMENT_IN_FRAME\')) { ?>__N__                                                <a href=\"page.php?donation=<?php echo $obj->rowid; ?>\" class=\"btn flat-button text-white py-2 px-3\"><?php echo $weblangs->trans(\"donateNow\"); ?></a>__N__                                            <?php } else { ?>__N__                                                <a href=\"<?php echo $socInfo[\'link_donation\'] . \'?project_id=\'.urlencode($obj->rowid); ?>\" target=\"new\" class=\"btn flat-button text-white py-2 px-3\"><?php echo $weblangs->trans(\"donateNow\"); ?></a>__N__                                            <?php } ?>__N__                                        <?php } ?>__N__                                        __N__                                        <?php if ($showParticipateLink) { ?>__N__                                            <?php $encodedsecurekey = dol_hash(getDolGlobalString(\'EVENTORGANIZATION_SECUREKEY\').\'conferenceorbooth\'.((int) $obj->rowid), \'md5\'); ?>__N__                                            <a href=\"<?php echo $socInfo[\'link_participation\'] . \'&id=\'.urlencode($obj->rowid).\'&securekey=\'.urlencode($encodedsecurekey); ?>\" target=\"new\" class=\"btn flat-button text-white py-2 px-3\"><?php echo $weblangs->trans(\"Participate\"); ?></a>__N__                                        <?php } ?>__N____N__                                    </div>__N__                                </div>__N__                                __N__                                <div class=\"progress\">__N__                                  <div class=\"progress-bar\" role=\"progressbar\" style=\"width: <?php echo $progress; ?>%;\" aria-valuenow=\"<?php echo $progress; ?>\" aria-valuemin=\"0\" aria-valuemax=\"100\">__N__                                    <?php if ($showEventGoalRaised) { ?>__N__                                    <span><?php echo $progress; ?>%</span>__N__                                    <?php } ?>__N__                                  </div>__N__                                </div>__N__                                <div class=\"causes-content p-4\">__N__                                    <span class=\"text-body\">__N__                                        <i class=\"fas fa-calendar-alt me-2\"></i> <?php echo dol_print_date($obj->datec, \'daytext\', \'tzuser\', $weblangs); ?>__N__                                    </span>__N__                                    <h4 class=\"py-3\"><?php echo $obj->title; ?></h4>__N__    __N__                                    <a href=\"page.php?id=<?php echo $obj->rowid; ?>\" class=\"btn flat-button text-white py-2 px-3 float-end\"><?php echo $weblangs->trans(\"readMore\"); ?></a>__N__                                </div>__N__                            </div>__N__                        </div>__N__                        <?php__N__                    }__N__                }__N__                ?>__N__            </div>__N____N__        </div>__N__    </div>__N__	__N__</div>', '', 0);

-- Page ID 17__+MAX_llx_website_page__ - Aliases slider --;
INSERT INTO llx_website_page(rowid, fk_page, fk_website, pageurl, aliasalt, title, description, lang, image, keywords, status, date_creation, tms, import_key, grabbed_from, type_container, htmlheader, content, author_alias, allowed_in_frames) VALUES(17__+MAX_llx_website_page__, null, __WEBSITE_ID__, 'slider', '', 'slider', '', '', '', '', '1', '2025-04-08 14:25:00', '2025-05-16 14:26:45', null, '', 'other', '', '<?php__N__includeContainer(\'_library_lib.php\', 1);__N__//setSessionLang();__N__$socInfo = getSocInfo();__N__?>__N____N__<section class=\"slogan has-section-divider\">__N__  __N__    <div class=\"container d-flex justify-content-center align-items-center \" style=\"min-height: 460px;\">__N__        <div class=\"col-lg-8 text-center\">__N__            <h1 class=\"mb-3\"><?php print $socInfo[\'slogan\']; ?></h1>__N__            <p class=\"lead\"><?php print $socInfo[\'description\']; ?></p>__N__            <?php if (isModEnabled(\'member\') && getDolGlobalInt(\'MEMBER_ENABLE_PUBLIC\')): ?>__N__                <p><a href=\"<?php print $socInfo[\'subscription_link\']; ?>\" target=\"new\" class=\"btn flat-button\">Devenir Membre</a></p>__N__            <?php endif; ?>__N__        </div>__N__    </div>__N__  __N__  __N__  <svg class=\"section-divider\" viewBox=\"0 0 1920 60\" aria-hidden=\"true\"><path data-theme=\"softSecondary\" fill=\"var(--light-secondary-color)\" d=\"M0,80.75H1920V45.833H1742.083a80.491,80.491,0,0,1,12.863-1.55c5.2-.26,17.24-.3,24.153-.24,26.69.222,54.377,1.094,79.341.96,19.287-.1,37.1-.372,53.573-.788L1920,44V34.078l-6.614.216-9.221.256c-6.252.147-12.7.249-19.265.32-13.132.14-26.739.15-40.206.125-26.935-.052-53.313-.247-74.22.168-14.367-1.4-32.582-.756-48.293-1.92-10.145.509-20.876.936-24.149,2.4-16.09-.266-37.611,2.532-50.019.479V34.684c-10.959-2.291-33.371-1.869-48.292-3.84-15.861-.512-26.214,1.347-39.671,1.92-7.032.178-5.941-.773-13.8-.481-40.751-.071-41.131,5.477-62.087,8.16-4.569-5.691-47.085-5.126-77.622-5.04-2.333-4.154-22.643-5.808-50.015-6.479-4.677-2.069-17.763-2.969-22.423-5.04-4.7-.175-3.474.477-6.9.479-11.485-2.964-40.092-2.449-63.813-3.36-23.312.6-29.4,3.589-55.195,3.841-8.3-3.783-56.5-4.561-84.513-3.361-.316-1.857-5.682-3.862-20.7-4.8-2.193-.137-6.78.122-10.352,0-16.331-.564-22.974-3.145-39.671-1.441-22.812-1.938-73.831-3.919-98.311-.719-4.315-2.2-15.369-3.462-20.7-5.521-23.122-.714-41.26-2.815-65.54-2.64-13.5,1-29.918,1.6-39.671,3.12.27,1.317-1.305,2.38-6.9,2.88-35.562-1.333-83.117-2.545-93.139,2.88-14.338-.314-8.341,2.2-22.423,1.92-5.17-.16-2.615-1.4-6.9-1.68-36.327-1.894-80.653-1.762-100.041,2.161-12.433-1.631-21.648-3.708-36.221-5.04-13.359.1-36.33-.325-48.293-1.2-32.483.6-42.463,4.331-53.471,7.92-25.227-.147-43.752,2.274-58.641,4.321-11.966-1.189-27.56-.426-39.67-1.441-19.514,1.284-40.772,2.328-53.468,4.561C301.584,31.04,294,33.888,283.7,37.8c-15.047-.774-19.865-3.5-36.221-4.321-10.453-.522-37.12-1.01-48.3-.959-10.184.046-17.188,1.062-27.595.719-18.244,2.022-31.516,4.736-46.57,7.2-3.726,2.091-9.8,3.854-17.5,5.39H4.061c-.734-1.281-1.512-2.592-2.344-3.949-.546-.09-1.13-.175-1.717-.26Z\"/></svg>__N__  __N__</section>', '', 0);

-- Page ID 18__+MAX_llx_website_page__ - Aliases _library_lib --;
INSERT INTO llx_website_page(rowid, fk_page, fk_website, pageurl, aliasalt, title, description, lang, image, keywords, status, date_creation, tms, import_key, grabbed_from, type_container, htmlheader, content, author_alias, allowed_in_frames) VALUES(18__+MAX_llx_website_page__, null, __WEBSITE_ID__, '_library_lib', '', 'lib', '', '', '', '', '1', '2025-04-11 10:57:25', '2025-05-16 14:26:30', null, '', 'library', '', '<?php__N__/**__N__ * Set session language based on:__N__ * - Cookie \'lang\' (if exists)__N__ * - Browser language (if not present among website languages, use website main language)__N__ * - Form field \'language\' (if present)__N__ *__N__ * The function also updates the product labels of the products in the session__N__ * to match the current language.__N__ *__N__ * @return bool__N__ */__N__function setSessionLang() {__N__   global $langs, $website, $weblangs, $db;__N__    // Get available langs for the website__N__    $website_langs = getAvailableLangs();__N__    $available_langs = $website_langs[\'langs\'];__N__    $langs_code_shortcode = $website_langs[\'langs_code_shortcode\'];__N____N__    // If no language is set or if a new language is selected (via form field)__N__    if (!isset($_COOKIE[\'lang\']) || GETPOST(\'l\', \'alpha\')) {__N__        // Get browser language__N__        $browser_lang = $weblangs->getDefaultLang(1);__N____N__        // Change used lang__N__        $new_lang = GETPOST(\'l\', \'alpha\');__N__        if ($new_lang && array_key_exists ($new_lang, $available_langs)) {__N__            setcookie(\'lang\', $new_lang, time() + (86400 * 30), \'/\');__N__            $session_lang = $new_lang;__N__        }__N____N__        // If no language is set in cookie and browser language is not present among available languages__N__        // use website main language as default__N__        if (!isset($_COOKIE[\'lang\'])) {__N__            if (array_key_exists ($browser_lang, $available_langs)){__N__                // The browser language is present among the available languages__N__                setcookie(\'lang\', $browser_lang, time() + (86400 * 30), \'/\');__N__                $session_lang = $browser_lang;__N__            } else {__N__                // The browser language is not present among the available languages__N__                setcookie(\'lang\', $website->lang, time() + (86400 * 30), \'/\');__N__                $session_lang = $website->lang;__N__            }__N__        }__N____N__        // Set session lang__N__        if (!empty($session_lang)) {__N__            $_SESSION[\'lang\'][\'shortcode\'] = $session_lang;__N__            $_SESSION[\'lang\'][\'code\'] = $langs_code_shortcode[$session_lang];__N__        }__N____N__    }__N____N__    // If session language is not set, use cookie language__N__    if (empty($_SESSION[\'lang\'][\'shortcode\']) || empty($_SESSION[\'lang\'][\'code\'])) {__N__        $_SESSION[\'lang\'][\'shortcode\'] = $_COOKIE[\'lang\'];__N__        $_SESSION[\'lang\'][\'code\'] = $langs_code_shortcode[$_COOKIE[\'lang\']];__N__    }__N____N__    // Set Dolibarr default language__N__    $langs->setDefaultLang($_SESSION[\'lang\'][\'code\']);__N__    $weblangs->setDefaultLang($_SESSION[\'lang\'][\'code\']);__N__    $langs->loadLangs(array(\"main\", \"website\", \"languages\", \"members\", \"admin\", \"donations\", \"companies\"));__N__    $weblangs->loadLangs(array(\"main\", \"website\", \"languages\", \"members\", \"admin\", \"donations\", \"companies\"));__N____N__    return true;__N__}__N____N__/**__N__ * The function loops through the languages of the website configuration and__N__ * checks if they exist in the list of supported languages. If they do, they__N__ * are added to the $available_langs array, along with their corresponding__N__ * shortcode in the $langs_code_shortcode array.__N__ *__N__ * The function returns an array with two keys: \'langs\' containing the list__N__ * of available languages and \'langs_code_shortcode\' containing the list__N__ * of corresponding shortcodes.__N__ *__N__ * @return array__N__ */__N__function getAvailableLangs() {__N__    global $website, $weblangs;__N____N__    $available_langs = array();__N__    $langs_code_shortcode = array();__N__    $ws_langs_list = explode(\',\', $website->lang.\',\'.$website->otherlang);__N__    $dol_available_langs = $weblangs->get_available_languages(DOL_DOCUMENT_ROOT, 1, 2, 1);__N__    foreach ($ws_langs_list as $lang) {__N__        foreach ($dol_available_langs as $key => $value) {__N__            if (strpos($key, $lang) === 0) {__N__                $available_langs[$lang] = $value;__N__                $langs_code_shortcode[$lang] = $key;__N__                break;__N__            }__N__        }__N__    }__N__    __N__    return array(\'langs\' => $available_langs, \'langs_code_shortcode\' => $langs_code_shortcode);__N__}__N____N__/**__N__ * Get societe information from Dolibarr configuration.__N__ *__N__ * This function retrieves the societe information from the global $conf object__N__ * and returns it as an associative array.__N__ *__N__ * @return array__N__ */__N__function getSocInfo() {__N__    global $conf, $mysoc, $weblangs, $website;__N__    $weblangs->load(\"admin\");__N____N__    $societe_info = array(__N__        \'name\' => !empty($mysoc->name) ? html_entity_decode($mysoc->name) : \'\',__N__        \'address\' => !empty($mysoc->getFullAddress(1)) ? html_entity_decode($mysoc->getFullAddress(1)) : \'\',__N__        \'zip\' => !empty($mysoc->zip) ? html_entity_decode($mysoc->zip) : \'\',__N__        \'town\' => !empty($mysoc->town) ? html_entity_decode($mysoc->town) : \'\',__N__        \'country\' => !empty($mysoc->country) ? html_entity_decode($mysoc->country) : \'\',__N__        \'phone\' => !empty($mysoc->phone) ? html_entity_decode($mysoc->phone) : \'\',__N__        \'fax\' => !empty($mysoc->fax) ? html_entity_decode($mysoc->fax) : \'\',__N__        \'email\' => !empty($mysoc->email) ? html_entity_decode($mysoc->email) : \'\',__N__        \'slogan\' => getDolGlobalString(\'WS_\'.strtoupper($website->ref).\'_\' . \'CUSTOM_SLOGAN\') __N__                ? html_entity_decode(getDolGlobalString(\'WS_\'.strtoupper($website->ref).\'_\' . \'CUSTOM_SLOGAN\')) __N__                : (!empty($mysoc->name) __N__                    ? html_entity_decode($mysoc->name) __N__                    : html_entity_decode($weblangs->trans(\"noCompanyInfoSlogan\"))),__N__        \'description\' => getDolGlobalString(\'WS_\'.strtoupper($website->ref).\'_\' . \'CUSTOM_DESCRIPTION\') __N__                ? html_entity_decode(getDolGlobalString(\'WS_\'.strtoupper($website->ref).\'_\' . \'CUSTOM_DESCRIPTION\')) __N__                : (!empty($mysoc->socialobject) __N__                    ? html_entity_decode($mysoc->socialobject) __N__                    : html_entity_decode($weblangs->trans(\"noCompanyInfoDescription\", $weblangs->trans(\"CompanyObject\"))))__N__    );__N____N__    // Add social networks if they are set__N__    foreach($mysoc->socialnetworks as $key => $value) {__N__        if (!empty($value)) {__N__            $societe_info[$key] = preg_match(\'/^http/\', $value) ? $value : \'https://www.\'.$key.\'.com/\'.$value;__N__        }__N__    }__N__    __N__    // Add link to subscription__N__    if (isModEnabled(\'multicompany\')) {__N__      $entity_qr = \'?entity=\' . ((int) $conf->entity);__N__    } else {__N__      $entity_qr = \'\';__N__    }__N__    $urlwithouturlroot = preg_replace(\'/\' . preg_quote(DOL_URL_ROOT, \'/\') . \'$/i\', \'\', trim($conf->file->dol_main_url_root));__N__    $urlwithroot = $urlwithouturlroot . DOL_URL_ROOT;__N__    $societe_info[\'subscription_link\'] = $urlwithroot . \'/public/members/new.php\'.$entity_qr;__N__    __N__    // Add participation link__N__    $link_participation = $urlwithroot.\'/public/eventorganization/attendee_new.php?type=global\';__N__	$societe_info[\'link_participation\'] = $link_participation;__N__	__N__	// Add donation link__N__    $link_donation = $urlwithroot.\'/public/donations/new.php\';__N__	$societe_info[\'link_donation\'] = $link_donation;__N____N__    return $societe_info;__N__}', '', 0);


-- For Dolibarr v14+ --;
UPDATE llx_website SET lang = 'en' WHERE rowid = __WEBSITE_ID__;
UPDATE llx_website SET otherlang = 'en,fr,de,it,es' WHERE rowid = __WEBSITE_ID__;
