'". $date_troismois. "'"; $results = mysql_query($requete2, $link); $rows = mysql_num_rows($results); // A REVOIR if ($rows == 0) { $listedossiers = "$LG_NORESULT\n"; } $pages = intval($rows / $limit); if ($rows % $limit) { $pages++; } $current = ($page / $limit) + 1; if (($pages < 1) || ($pages == 0)) { $total = 1; } else { $total = $pages; } $first = $page + 1; if (!((($page + $limit) / $limit) >= $pages) && $pages != 1) { $last = $page + $limit; } else { $last = $rows; } mysql_free_result($results); // ------------------------- // DEFINITION DE LA CATEGORIE if ($idcat) { // la catégorie $requete2 = "SELECT id_categorie, id_parentcat, nomCategorie, descCat, group_c_visu, verifsscat, url_friendly FROM " . ARTI_PREFIX_TB . "categories WHERE id_categorie='$idcat' AND nom_cmodule='" . $mod_encours_sys . "'"; $result2 = mysql_query($requete2, $link); $defcat = mysql_fetch_object($result2); $defcat->nomCategorie = stripslashes($defcat->nomCategorie); $urlfriendlycat = stripslashes($defcat->url_friendly); // liens uniquement sur categories autorisees $visucat = explode('][', trim($defcat->group_c_visu, '[]')); if (in_array($SESSION_ARTIGROUP, $visucat)) { } else { header('Location: ' . ARTI_WEB_INT_FCT_PATH . 'erreur.php?ec=2'); exit(); } // ----------------------------------------- $entete2 = '

' . $defcat->nomCategorie . '

'; // si la categorie est une sous-categorie if ($defcat->id_parentcat) { $nomsscat = stripslashes($defcat->nomCategorie); $sscat = $defcat->id_categorie; $requete3 = "SELECT id_categorie, nomCategorie, group_c_visu, url_friendly FROM " . ARTI_PREFIX_TB . "categories WHERE id_categorie='$defcat->id_parentcat'"; $result3 = mysql_query($requete3, $link); $defcat1 = mysql_fetch_object($result3); $nomcat = stripslashes($defcat1->nomCategorie); $cat = $defcat1->id_categorie; $urlcat = stripslashes($defcat1->url_friendly); // liens uniquement sur categories autorisees $visucat2 = explode('][', trim($defcat1->group_c_visu, '[]')); if (in_array($SESSION_ARTIGROUP, $visucat2)) { } else { header('Location: ' . ARTI_WEB_INT_FCT_PATH . 'erreur.php?ec=2'); exit(); } // si la categorie n'est pas une sous-categorie } else { $nomcat = stripslashes($defcat->nomCategorie); $cat = $defcat->id_categorie; if ($defcat->verifsscat == '2') { $entete2 .= '
'; $entete2 .= "$LG_SSCAT"; $requete5 = "SELECT id_categorie, nomCategorie, descCat, imgCat, group_c_visu, url_friendly FROM " . ARTI_PREFIX_TB . "categories WHERE id_parentcat='$idcat'"; $result5 = mysql_query($requete5, $link); while ($sscatsuite = mysql_fetch_object($result5)) { $sscatsuite->nomCategorie = stripslashes($sscatsuite->nomCategorie); $sscatsuite->descCat = stripslashes($sscatsuite->descCat); $sscatsuite->imgCat = stripslashes($sscatsuite->imgCat); $urlfriendly = stripslashes($sscatsuite->url_friendly); // liens uniquement sur categories autorisees $visucat2 = explode('][', trim($sscatsuite->group_c_visu, '[]')); if (ARTI_URL_TYPE == 1) { $valurl = 'cat.php?val=' . $sscatsuite->id_categorie . '_' . $urlfriendly; } else { $valurl = 'categorie_' . $sscatsuite->id_categorie . '_' . $urlfriendly . '.html'; } if (in_array($SESSION_ARTIGROUP, $visucat2)) { if ($sscatsuite->imgCat == '') { $photocat = ''; } else { $photocat = "imgCat\" alt=\"\"> "; } $entete2 .= "
" . $photocat . "" . $sscatsuite->nomCategorie . "
$sscatsuite->descCat
\n"; } } $entete2 .= "
$LG_LISTE_DOSSIERS
"; } } // EN-TETE DE PAGE if ($sscat) { if (ARTI_URL_TYPE == 1) { $valurl = 'cat.php?val=' . $cat . '_' . $urlcat; } else { $valurl = 'categorie_' . $cat . '_' . $urlcat . '.html'; } $entete = "$LG_ACCUEIL$lg_mod_titre" . $nomcat . "\n"; } else { $entete = "$LG_ACCUEIL$lg_mod_titre\n"; } } else { $entete = "$LG_ACCUEIL$lg_mod_titre\n"; $entete2 = "

$lg_mod_titre

\n\n"; // metatags include('langues/' . $SESSION_LANGSKIN .'/metatags.inc.php'); $metatitle = $LG_METADOS . ' '; $metaDescription = $LG_METADESDOS . ' - ' . $metaplus; } if ($idcat) { $ajouttable = ''; $ajoutnomcat = ''; } else { $ajouttable = ', ' . ARTI_PREFIX_TB . 'categories'; $ajoutcat = " AND id_categorie=id_cat AND group_c_visu LIKE '%[" . $SESSION_ARTIGROUP . "]%'"; $ajoutnomcat = ', nomCategorie, id_categorie, url_friendly'; } // AFFICHAGE DES DOSSIERS // ---------------------- $page = intval($page); $limit = intval($limit); //$requete = "SELECT id_dossier, titreDossier, dateDossier, imgDossier, chapoDossier, dosrewriting " . $ajoutnomcat . " FROM `" . ARTI_PREFIX_TB . $mod_encours_dir . "`" . $ajouttable . " WHERE id_parentdos='0' " . $ajoutcat . " AND pubDossier='1' ORDER BY " . $ordre . " " . $ascdesc . " LIMIT $page, $limit"; $requete = "SELECT id_dossier, titreDossier, dateDossier, imgDossier, chapoDossier, dosrewriting " . $ajoutnomcat . " FROM `" . ARTI_PREFIX_TB . $mod_encours_dir . "`" . $ajouttable . " WHERE id_parentdos='0' " . $ajoutcat . " AND pubDossier='1' AND dateDossier>'". $date_troismois. "' ORDER BY " . $ordre . " " . $ascdesc . " LIMIT $page, $limit"; $result = mysql_query($requete, $link); $ix = 0; $testschema=$limit-1; if (mysql_num_rows($result)<=$testschema) { $limitschema=mysql_num_rows($result); } else { $limitschema=$limit; } $listedossiers = ''; $itemListElement = ''; while ($dossier = mysql_fetch_object($result)) { // decodage du texte $dossier->titreDossier = stripslashes($dossier->titreDossier); $dossier->chapoDossier = stripslashes($dossier->chapoDossier); $dossier->nomCategorie = stripslashes($dossier->nomCategorie); $urlfriendly = stripslashes($dossier->dosrewriting); if (ARTI_URL_TYPE == 1) { $valurl = 'dossier.php?val=' . $dossier->id_dossier . '_' . $urlfriendly; } else { $valurl = 'dossier_' . $dossier->id_dossier . '_' . $urlfriendly . '.html'; } if ($dossier->imgDossier == '') { $photo = ''; } else { $photo = ''; } if (! $idcat) { // url friendly pour cat $urlfriendlycat = stripslashes($dossier->url_friendly); if (ARTI_URL_TYPE == 1) { $valurl2 = 'cat.php?val=' . $dossier->id_categorie . '_' . $urlfriendlycat; } else { $valurl2 = 'categorie_' . $dossier->id_categorie . '_' . $urlfriendlycat . '.html'; } // -------------- $liscategorie = ''; } else { $liscategorie = ''; } if ($dosss == '2') { // colonne de gauche if ($ix % 2 == 0) { $listedoss .= "
\n"; $listedoss .= "
" . $photo . "

" . $dossier->titreDossier . "

" . arti_date_court($dossier->dateDossier) . "
\n"; $listedoss .= "
" . $dossier->chapoDossier . $liscategorie . "
\n"; // Colonne de droite } else { $listedoss2 .= "
\n"; $listedoss2 .= "
" . $photo . "

" . $dossier->titreDossier . "

" . arti_date_court($dossier->dateDossier) . "
\n"; $listedoss2 .= "
" . $dossier->chapoDossier . $liscategorie . "
\n"; } $ix++; } else { $listedossiers .= "
\n"; $listedossiers .= "
" . $photo . "

" . $dossier->titreDossier . "

" . arti_date_court($dossier->dateDossier) . "
\n"; $listedossiers .= "
" . $dossier->chapoDossier; $listedossiers .= $liscategorie . "
\n
"; } // ajout pour schema.org $date20 = new DateTime($dossier->dateDossier, new DateTimeZone('Europe/Paris')); $datepublished=$date20->format('Y-m-d\TH:i:sP'); $ix++; if ($ix<$limitschema) { $virgule=","; } else { $virgule=""; } $itemListElement .=" { \"@type\": \"ListItem\", \"position\": ".$ix.", \"item\": { \"@type\": \"NewsArticle\", \"headline\": \"".$dossier->titreDossier."\", \"url\": \"https://www.cholet.fr/dossiers/" . $valurl . "\", \"datePublished\": \"".$datepublished."\", \"dateModified\": \"".$datepublished."\", \"image\": \"https://www.cholet.fr/dossiers/images/".$dossier->imgDossier."\", \"author\": { \"@id\": \"https://www.cholet.fr/#organization\" }, \"publisher\": { \"@id\": \"https://www.cholet.fr/#organization\" } } }".$virgule." "; } if ($dosss == '2') { $listedossiers .= "
$listedoss
\n"; $listedossiers .= "
$listedoss2
\n"; } // schema.org // ----------------------- $activschemeorg="1"; $schemeorg=" "; // ----------------------------------------------------------------------- // Deuxieme partie du code de pagination // (à modifier si vous avez d'autres données à faire circuler dans l'URL) // ----------------------------------------------------------------------- if ($idcat) { $ajoutrewrite2 = '_' . $urlfriendlycat; } else { $ajoutrewrite2 = ''; } if ($page != 0) { $pagination = ''; $back_page = $page - $limit; if (ARTI_URL_TYPE == 1) { if ($back_page == '0') { $pagination .= "« $LG_PGPRECED | \n"; } else { $pagination .= "« $LG_PGPRECED | \n"; } } else { if ($back_page == '0') { if ($idcat =='0') { $pagination .= "« $LG_PGPRECED | \n"; } else { $pagination .= "« $LG_PGPRECED | \n"; } } else { $pagination .= "« $LG_PGPRECED | \n"; } } $entete2 = "

Archives d'actu

\n\n"; } for ($i = 1; $i <= $pages; $i++) { $ppage = $limit * ($i - 1); if ($ppage == $page) { if ($total == 1) { $pagination .= ''; } else { $pagination .= "Archives d'actu " . $LG_PAGE . " $i/$pages | \n"; $ajmeta = "- " . $LG_PAGE . " $i/$pages"; } } } if (!((($page + $limit) / $limit) >= $pages) && $pages != 1) { $next_page = $page + $limit; if (ARTI_URL_TYPE == 1) { $pagination .= "$LG_PGSUITE »\n"; } else { $pagination .= "$LG_PGSUITE »\n"; } } if (! $pagination) { $finpag .= ''; } else { $debutpag .= "
"; $finpag .= "
"; } // ------------------------------------------------------------------------- // metatags -------------------------------- $nCat = htmlspecialchars($nomcat); $nCat2 = htmlspecialchars($nomsscat); $metatitle .= $nCat . ' ' . $nCat2 . ' ' . $ajmeta . ' - ' . ARTI_SITE_NAME; $nCatDes = strip_tags($defcat->descCat); $nCatDes = htmlspecialchars($nCatDes); $metaDescription .= $nCatDes . ' - ' . $nCat . ' ' . $nCat2; mysql_free_result($result); // presentation // ------------ $milieu = "
\n\n"; $milieu .= $entete2; //$milieu .= $debutpag . ' ' . $pagination . ' ' . $finpag; $milieu .= $listedossiers; if ($dosss != '2') { $milieu .= $debutpag . ' ' . $pagination . ' ' . $finpag; } $milieu .= '
'; // Template // -------- $SESSION_SKIN = $_SESSION['SESSION_SKIN']; include(ARTI_SYS_INT_PATH . "templates/temp$SESSION_SKIN/temp.html"); echo $arti; mysql_close($link); ?>