Execute("SELECT * FROM scm_langues WHERE NAPublic = 0 AND CodeLangue = '" . $strBufLng . "'"); if ($rsIfLangExist->EOF == true) $_SESSION['strLangue'] = CstrDefaultLanguage; else $_SESSION['strLangue'] = $strBufLng; } } $bPagePreviewBeforeSave = false; if (isset($_GET['bpagepreview'])) { if ($_GET['bpagepreview'] == '1') $bPagePreviewBeforeSave = true; } /********* Récupère les traductions de texte (contenu de page au format HTML, longs textes) *********/ function GetContent($strCodeText) { $strSQLContent = ''; $rsContent = ''; $strReturn = ''; $bNA = 0; global $objConnMySQLCA; global $bPagePreviewBeforeSave; if ($bPagePreviewBeforeSave == true) { if (isset($_POST['cbContentNA_' . $strCodeText . '_' . $_SESSION['strLangue']])) $bNA = 0; else $bNA = 1; if ($bNA == 0 && isset($_POST['txtContent_' . $strCodeText . '_' . $_SESSION['strLangue']])) $strReturn = stripslashes($_POST['txtContent_' . $strCodeText . '_' . $_SESSION['strLangue']]); else $strReturn = ''; } else { $strSQLContent = ''; $strSQLContent .= 'SELECT Content FROM scm_contenttexts t INNER JOIN scm_pages p '; $strSQLContent .= 'ON t.IDPage = p.IDPage '; $strSQLContent .= "WHERE NonActif = 0 AND UCASE(t.CodeLangue) = '" . strtoupper($_SESSION['strLangue']) . "' "; $strSQLContent .= "AND UCASE(p.PageName) = '" . fctSQLSlashes(strtoupper(CstrCurrentPageName)) . "' "; $strSQLContent .= "AND t.CodeText = '" . fctSQLSlashes($strCodeText) . "' "; $rsContent = $objConnMySQLCA->Execute($strSQLContent); if ($rsContent != false) $strReturn = $rsContent->fields['Content']; else $strReturn = ''; } return $strReturn; } /********* Récupère les traductions de messages d'informations ou d'erreurs *********/ function GetMessage($strCodeMessage) { $strSQLMessage = ''; $rsMessage = ''; $strReturn = ''; global $objConnMySQLCA; $strSQLMessage = ''; $strSQLMessage .= 'SELECT Message FROM scm_transmessages '; $strSQLMessage .= "WHERE UCASE(CodeLangue) = '" . strtoupper($_SESSION['strLangue']) . "' "; $strSQLMessage .= "AND CodeMessage = '" . fctSQLSlashes($strCodeMessage) . "' "; $rsMessage = $objConnMySQLCA->Execute($strSQLMessage); if ($rsMessage != false) $strReturn = $rsMessage->fields['Message']; else $strReturn = ''; return $strReturn; } /********* Récupère les traductions de libellé (textes succincts) *********/ function Label($strLabel) { $strSQLLabel = ''; $rsLabel = ''; $strReturn = ''; global $objConnMySQLCA; $strSQLLabel = ''; $strSQLLabel .= 'SELECT Label FROM scm_translabels '; $strSQLLabel .= "WHERE UCASE(CodeLangue) = '" . strtoupper($_SESSION['strLangue']) . "' "; $strSQLLabel .= "AND CodeLabel = '" . fctSQLSlashes($strLabel) . "' "; $rsLabel = $objConnMySQLCA->Execute($strSQLLabel); if ($rsLabel != false) { if ($rsLabel->fields['Label'] != '') $strReturn = $rsLabel->fields['Label']; else $strReturn = $strLabel; } else $strReturn = $strLabel; return $strReturn; } /********* Récupère le texte de référencement de la page en cours et l'affiche dans le tag TITLE *********/ function GetTitle() { $strSQLTitle = ''; $rsTitle = ''; $strReturn = ''; global $objConnMySQLCA; $strSQLTitle = ''; $strSQLTitle .= 'SELECT PageReference FROM scm_pages '; $strSQLTitle .= "WHERE UCASE(CodeLangue) = '" . strtoupper($_SESSION['strLangue']) . "' "; $strSQLTitle .= "AND UCASE(PageName) = '" . fctSQLSlashes(strtoupper(CstrCurrentPageName)) . "'"; $rsTitle = $objConnMySQLCA->Execute($strSQLTitle); if ($rsTitle != false) $strReturn = $rsTitle->fields['PageReference']; else $strReturn = ''; return $strReturn; } /********* Récupère les images pour une page *********/ function GetImage($strCodeImage) { $strSQLImage = ''; $rsImage = ''; $strReturn = ''; global $objConnMySQLCA; $strSQLImage = ''; $strSQLImage .= 'SELECT Image FROM scm_contentimages t INNER JOIN scm_pages p '; $strSQLImage .= 'ON t.IDPage = p.IDPage '; $strSQLImage .= "WHERE NonActif = 0 AND UCASE(t.CodeLangue) = '" . strtoupper($_SESSION['strLangue']) . "' "; $strSQLImage .= "AND UCASE(p.PageName) = '" . fctSQLSlashes(strtoupper(CstrCurrentPageName)) . "' "; $strSQLImage .= "AND t.CodeImage = '" . fctSQLSlashes($strCodeImage) . "' "; $rsImage = $objConnMySQLCA->Execute($strSQLImage); if ($rsImage != false) $strReturn = $rsImage->fields['Image']; else $strReturn = ''; return $strReturn; } /********* Récupère les traductions de texte (contenu de page au format HTML, longs textes) *********/ function GetFooterText($strCodeText) { $strSQLContent = ''; $rsContent = ''; $strReturn = ''; global $objConnMySQLCA; global $bPagePreviewBeforeSave; if ($bPagePreviewBeforeSave == true) { if (isset($_POST['txtContent_' . $strCodeText . '_' . $_SESSION['strLangue']])) $strReturn = stripslashes($_POST['txtContent_' . $strCodeText . '_' . $_SESSION['strLangue']]); else $strReturn = ''; } else { $strSQLContent = ''; $strSQLContent .= 'SELECT Content FROM scm_footer_texts '; $strSQLContent .= "WHERE UCASE(CodeLangue) = '" . strtoupper($_SESSION['strLangue']) . "' "; $strSQLContent .= "AND CodeText = '" . fctSQLSlashes($strCodeText) . "' "; $rsContent = $objConnMySQLCA->Execute($strSQLContent); if ($rsContent != false) $strReturn = $rsContent->fields['Content']; else $strReturn = ''; } return $strReturn; } ?>Execute($strSQL); if($rsCategorie->EOF != true) { if($iIDCategorie == 0) { if($rsCategorie->fields['Categorie'] != '') { $strTitlePageComplement = $rsCategorie->fields['Categorie']; // Fil d'Ariane if($bIsFirstVisit == 0) $strPictTitle = $rsCategorie->fields['Categorie']; } if($rsCategorie->fields['Description'] != '') $strDescriptionPageComplement = html_entity_decode(strip_tags($rsCategorie->fields['Description']),ENT_QUOTES,'UTF-8'); $iIDCategorie = $rsCategorie->fields['IDCategorie']; } else { $strSQL = ''; $strSQL .= 'SELECT Categorie' . $_SESSION['strLangue'] . ' AS Categorie, Description' . $_SESSION['strLangue'] . ' AS Description '; $strSQL .= 'FROM scm_catgalerie '; $strSQL .= 'WHERE IDCategorie = ' . intval($iIDCategorie); $rsTemp = $objConnMySQLCA->Execute($strSQL); if($rsTemp->EOF != true){ // Référencement if($rsTemp->fields['Categorie'] != '') { $strTitlePageComplement = $rsTemp->fields['Categorie']; $strPictTitle = $rsTemp->fields['Categorie']; } if($rsTemp->fields['Description'] != '') $strDescriptionPageComplement = html_entity_decode(strip_tags($rsTemp->fields['Description']),ENT_QUOTES,'UTF-8'); } } $strSQL = ''; $strSQL .= 'SELECT scm_galerie.IDImage, Image, Title' . $_SESSION['strLangue'] . ' AS Title, Description' . $_SESSION['strLangue'] . ' AS Description, '; $strSQL .= 'AltTag' . $_SESSION['strLangue'] . ' AS AltTag '; $strSQL .= 'FROM scm_galerie LEFT JOIN scm_rel_catgalerie ON scm_galerie.IDImage = scm_rel_catgalerie.IDImage '; $strSQL .= 'WHERE NonActif = 0 '; $strSQL .= 'AND scm_rel_catgalerie.IDCategorie = ' . intval($iIDCategorie) . ' '; $strSQL .= 'ORDER BY scm_rel_catgalerie.Ordre ASC'; $rsGalerie = $objConnMySQLCA->Execute($strSQL); } ?> Execute($strSQLInfo); if ($rsTitlePage->EOF != true) { $strTitlePage = $rsTitlePage->fields['MetaTitle']; $strDescriptionPage = $rsTitlePage->fields['MetaDesc']; if($rsTitlePage->fields['Image'] != '' && CstrCurrentPageName != 'index.php') $strImageBackground = 'url(Images/Background/Pages/' . $rsTitlePage->fields['Image'] . ') no-repeat center fixed'; } else $strTitlePage = CstrTitlePage; ?> <?($strTitlePageComplement != '') ? print $strTitlePageComplement : print $strTitlePage;?>