0) $filter = " AND a.IDCATEGORIE='".(int)$_GET['id']."'"; $sql_nb = 10; $sql_begin = $_GET['page']*$sql_nb; $sql = "SELECT a.*, b.CATEGORIE FROM FONT_NEW a INNER JOIN CATEGORIE_NEW b ON a.IDCATEGORIE=b.IDCATEGORIE WHERE a.STATUS='1' $filter ORDER BY a.IDFONT DESC LIMIT ".$sql_begin.",".$sql_nb; $db->Query($sql); $i = 0; while($row = $db->FetchResult($db->result)){ $link = URL_SITE."download-font-".(int)$row['IDFONT']."-".clean($row['FONT']).".htm"; $image = URL_SITE."fonts/small/".(int)$row['IDFONT'].".png"; $categorie = $row['CATEGORIE']; $debut_link = URL."download-font/"; $template->assign(array("font_link" => $link, "font_id" => $row['IDFONT'], "font_font" => $row['FONT'], "font_categorie" => $row['CATEGORIE'], "font_file" => $link, "font_img" => $image, "font_nbview" => $row['NBVIEW'], "font_keyword" => $keyword[$i])); $block = 'body.bloc.line'; $template->parse($block); $i++; } $template->parse('body.bloc'); if($_GET['id']>0){ $template->assign(array("title" => "Polices d'écriture - Fonts ".$categorie." - page ".(int)($_GET['page']+1) )); } else{ $template->assign(array("title" => "Polices d'écriture - Fonts gratuits - page ".(int)($_GET['page']+1) )); } $meta_title = TITRE_INDEX; $meta_description = $meta_title; $meta_keyword = $meta_title; $meta_textedur = $meta_title; if($_GET['id']>0){ $sql = "SELECT CATEGORIE FROM CATEGORIE_NEW WHERE IDCATEGORIE='".(int)$_GET['id']."'"; $db->Query($sql); $row = $db->FetchResult($db->result); $meta_title = TITRE_INDEX." ".$row['CATEGORIE']; $categorie = $row['CATEGORIE']; $meta_description = $row['CATEGORIE']; $meta_keyword = $row['CATEGORIE']; $meta_textedur = $row['CATEGORIE']; } else{ $categorie = ''; } if($_GET['page']>0){ $meta_title .= " - page ".(int)($_GET['page']+1); } /* D├ębut affichage bas de page */ $sql = "SELECT count(*) AS NB FROM FONT_NEW a WHERE a.STATUS='1' $filter"; $db->Query($sql); $row = $db->FetchResult($db->result); $nb = (int)$row['NB']; $debut_link = "free-font"; display_bas_page($nb, $debut_link, $categorie); $id = $_GET["page"]; require "./config/footer.php"; ?>