$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, nomCategorie, descCat, 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);
// -----------------------------------------
$entete2 = '' . $defcat->nomCategorie . '
';
// si la categorie est une sous-categorie
$nomcat = stripslashes($defcat->nomCategorie);
$cat = $defcat->id_categorie;
// EN-TETE DE PAGE
$entete = "$LG_ACCUEIL$lg_mod_titre\n";
} else {
$entete = "$LG_ACCUEIL$lg_mod_titre\n";
$entete2 = "Toutes les vidéos
\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";
$ajoutnomcat = ', nomCategorie, id_categorie, url_friendly';
}
// AFFICHAGE DES VIDEOS
// ----------------------
$page = intval($page);
$limit = intval($limit);
if ($idcat) {
$requete = "SELECT id_video, nom_video, url_video, date_video, id_cat, videorewriting FROM `" . ARTI_PREFIX_TB . $mod_encours_dir . "` WHERE affichagePage2='1' AND id_cat='$idcat' ORDER BY date_video desc LIMIT $page, $limit";
} else {
$requete = "SELECT id_video, nom_video, url_video, date_video, id_cat, videorewriting FROM `" . ARTI_PREFIX_TB . $mod_encours_dir . "` WHERE affichagePage2='1' ORDER BY date_video desc LIMIT $page, $limit";
}
$result = mysql_query($requete, $link);
$ix = 0;
$listedossiers = '';
while ($dossier = mysql_fetch_object($result)) {
// decodage du texte
$dossier->nom_video = stripslashes($dossier->nom_video);
$dossier->url_video = stripslashes($dossier->url_video);
$dossier->id_cat = intval($dossier->id_cat);
$dossier->date_video = stripslashes($dossier->date_video);
if (! $idcat) {
if ($dossier->id_cat=='0') {
$liscategorie = "\n";
} else {
$requetecat = "SELECT id_categorie, nomCategorie, url_friendly FROM " . ARTI_PREFIX_TB . "categories WHERE id_categorie='$dossier->id_cat' AND nom_cmodule='" . $mod_encours_sys . "'";
$resultcat = mysql_query($requetecat, $link);
$donneecat = mysql_fetch_object($resultcat);
$dossier->nomCategorie = stripslashes($donneecat->nomCategorie);
// url friendly pour cat
$urlfriendlycat = stripslashes($donneecat->url_friendly);
if (ARTI_URL_TYPE == 1) {
$valurl2 = 'cat.php?val=' . $donneecat->id_categorie . '_' . $urlfriendlycat;
} else {
$valurl2 = 'categorie_' . $donneecat->id_categorie . '_' . $urlfriendlycat . '.html';
}
// --------------
$liscategorie = "" . $dossier->nomCategorie . "\n";
}
} else {
$liscategorie = '';
}
$urlfriendly10 = stripslashes($dossier->videorewriting);
if (ARTI_URL_TYPE == 1) {
$valurl10 = 'video.php?val=' . $dossier->id_video . '_' . $urlfriendly10;
} else {
$valurl10 = 'video_' . $dossier->id_video . '_' . $urlfriendly10 . '.html';
}
// recherche image webp
$filename = '../video/images/' . $dossier->url_video . '.webp';
if (file_exists($filename)) {
$imgvideoaff=$filename;
} else {
$imgvideoaff="https://i.ytimg.com/vi/" . $dossier->url_video . "/hqdefault.jpg";
}
$listedossiers .= "\n";
}
mysql_free_result($result);
// -----------------------------------------------------------------------
// 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') {
$pagination .= "« $LG_PGPRECED | \n";
} else {
$pagination .= "« $LG_PGPRECED | \n";
}
}
}
for ($i = 1; $i <= $pages; $i++) {
$ppage = $limit * ($i - 1);
if ($ppage == $page) {
if ($total == 1) {
$pagination .= '';
} else {
$pagination .= "" . $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;
$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);
?>