Accueil > Articles > ".$t[0]." > ".htmlentities($r["titre"]).""; $titre_page = "Metagames - ".$t[0]." - ".stripslashes(htmlentities($r[titre])); } elseif (!empty($cat) && is_numeric($cat) ) { $t = get_cat("cat",$cat); $cat_name = $t[0]; $cat_pic = $t[1]; $titre_page1 = "Accueil > Articles > ".$cat_name.""; $titre_page = "Metagames - ".$cat_name." articles"; } else $titre_page = "Articles PS2/XBox/Gamecube/Dreamcast/GBA et autres consoles : Backup, Gravure, Divx, MP3, Modchip, Puce"; include("theme/hpage.php"); if(empty($art) && empty($cat)){ ;} else echo $titre_page1."
"; if (isset($art) && is_numeric($art)) { /* AFFICHAGE ARTICLE UNIQUE */ $q1 = mysql_query("SELECT *, DATE_FORMAT(date, '$site_date_j') AS dateh FROM articles WHERE idx = $art"); $r1 = mysql_fetch_array($q1); $cat = $r1[cat]; /* AFFICHAGE TITRE ARTICLE */ $Design->OpenTable("100%","28","","0","","","1","","","Bottom",1); echo ""; echo "".conv(stripslashes($r1[titre])).""; $Design->CloseTable(); /* AFFICHAGE CONTENU ARTICLE */ $Design->OpenTable("100%","","","0","","","1","#666666","#000000","Middle",0); echo "
".conv($r1["texte"], 1)."
"; /* DATE/CATEGORIE/AUTEUR */ echo ""; echo " "; echo "Ecrit le ".formatdate($r1[date])." par ".htmlentities($r1["auteur"])." - Hits: ".$r1["hits"]." \n\n"; $Design->CloseTable(); /* AFFICHAGE DERNIERS MESSAGES FORUM */ /* $requete=MYSQL_QUERY("Select titre,idcat from forum_cat where idcat='$r1[cat]' ") or Die(mysql_error()); if(MYSQL_NUM_ROWS($requete)==1) { list($catforum,$idcatforum) = MYSQL_FETCH_ROW($requete); echo "

Les derniers messages du forum ".stripslashes($catforum)."

"; $requete=MYSQL_QUERY("SELECT id,cat,rep,titre,lpost FROM forum WHERE(cat=$idcatforum AND rep=0) ORDER BY lpost DESC LIMIT 5"); echo ""; while($res=MYSQL_FETCH_ARRAY($requete)) echo "".stripslashes($res[titre])."
"; echo ""; } */ } /* ARTICLES DANS UNE CATEGORIE */ elseif (!empty($cat) && is_numeric($cat)) { /* AFFICHAGE TABLEAU CATEGORIE COMPRENANT LIENS VERS SOUS CATEGORIES */ $Design->OpenTable("100%","28","","0","","","0","","","Bottom",1); echo "".$cat_name.""; $Design->CloseTable(); $Design->OpenTable("100%","","","0","","","1","#666666","#000000","Middle",0); if(!empty($cat_pic)) echo ""; $q1 = MYSQL_QUERY("SELECT DISTINCT sub_cat FROM articles WHERE cat='$cat' "); if($enable_url_rewrite) { echo "".htmlentities($cat_name)." : "; echo "
"; while( $r1 = mysql_fetch_array($q1) ) { $q2 = MYSQL_QUERY("SELECT name FROM sub_cat WHERE id='$r1[sub_cat]'"); $r2 = MYSQL_FETCH_ARRAY($q2); echo "    $r2[name]
"; } } else { echo "".htmlentities($cat_name)." : "; echo "
"; while( $r1 = mysql_fetch_array($q1) ) { $q2 = MYSQL_QUERY("SELECT name FROM sub_cat WHERE id='$r1[sub_cat]'"); $r2 = MYSQL_FETCH_ARRAY($q2); echo "    $r2[name]
"; } } $Design->CloseTable(); $Design->JumpLine(1); // Preparation de la requete d'ordre $ordre == 1 ? $sql_ordre = "ASC" : $sql_ordre = "DESC"; if ($par == 2) { $sql_par = "hits";} elseif ($par == 1) { $sql_par = "titre";} else { $sql_par = "date";} /* AFFICHAGE ARTICLES DISPO */ /* $q = mysql_query("SELECT cat FROM articles WHERE cat LIKE '$cat' LIMIT 1"); $r = mysql_fetch_array($q); echo "

Classer les articles par :
\n"; echo "\"Ascendant\" date \"Descendant\"  "; echo "  \"Ascendant\" titre \"Descendant\"  "; echo "  \"Ascendant\" hits \"Descendant\""; echo "

\n\n"; */ /* AFFICHAGE ARTICLES DISPO DANS UNE SOUS CATEGORIE */ if( !empty($sub_cat) && is_numeric($sub_cat) ) { $q4 = mysql_query("SELECT idx, titre, resume, hits, date FROM articles WHERE cat = '$cat' AND sub_cat = '$sub_cat' ORDER BY ".$sql_par." ".$sql_ordre.", titre ASC") or die(mysql_error()); $q5 = mysql_query("SELECT name,img FROM sub_cat WHERE id='$sub_cat' "); $r5 = mysql_fetch_array($q5); echo ""; $Design->OpenTable("100%","","","0","","","1","#666666","#000000","Middle",0); if(!empty($r5[img])) echo ""; echo "

".stripslashes($r5[name])."

"; if($enable_url_rewrite) { while ($r4 = mysql_fetch_array($q4)) { $url = make_url("Article",$r4[idx],stripslashes($r4[titre])); echo " ".htmlentities($r4["titre"])."

\n"; echo conv($r4["resume"]); echo "

Ecrit le ".formatdate($r4["date"])."
Hits: ".$r4["hits"]."
"; echo "
\n\n"; } } else { while ($r4 = mysql_fetch_array($q4)) { echo " ".htmlentities($r4["titre"])."

\n"; echo conv($r4["resume"]); echo "

Ecrit le ".formatdate($r4["date"])."
Hits: ".$r4["hits"]."
"; echo "
\n\n"; } } $Design->CloseTable(); $Design->jumpLine(2); navBarre("&cat=".urlencode($cat)."&ordre=$ordre&par=$par"); } /* AFFICHAGE ARTICLES DISPO DANS TOUTES LES SOUS CATEGORIES */ else { $q1 = MYSQL_QUERY("SELECT DISTINCT sub_cat FROM articles WHERE cat = '$cat' "); while( $r1 = MYSQL_FETCH_ARRAY($q1) ) { $q4 = mysql_query("SELECT idx, titre, resume, hits, date FROM articles WHERE cat = '$cat' AND sub_cat = '$r1[sub_cat]' ORDER BY ".$sql_par." ".$sql_ordre.", titre ASC") or die(mysql_error()); $q5 = mysql_query("SELECT name,img FROM sub_cat WHERE id='$r1[sub_cat]' "); $r5 = mysql_fetch_array($q5); echo ""; $Design->OpenTable("100%","","","0","","","1","#666666","#000000","Middle",0); if(!empty($r5[img])) echo ""; echo "

".stripslashes($r5[name])."

"; if($enable_url_rewrite) { while ($r4 = mysql_fetch_array($q4)) { $url = make_url("Article",$r4[idx],stripslashes($r4[titre])); echo " ".htmlentities($r4["titre"])."

\n"; echo conv($r4["resume"]); echo "

Ecrit le ".formatdate($r4["date"])."
Hits: ".$r4["hits"]."
"; echo "
\n\n"; } } else { while ($r4 = mysql_fetch_array($q4)) { echo " ".htmlentities($r4["titre"])."

\n"; echo conv($r4["resume"]); echo "

Ecrit le ".formatdate($r4["date"])."
Hits: ".$r4["hits"]."
"; echo "
\n\n"; } } $Design->CloseTable(); $Design->jumpLine(2); navBarre("&cat=".urlencode($cat)."&ordre=$ordre&par=$par"); } } } /* ACCUEIL ARTICLES */ else { /* CATEGORIES */ $q1 = mysql_query("SELECT DISTINCT cat FROM articles"); echo "

"; while ($r1 = mysql_fetch_array($q1)) { $t = get_cat("cat",$r1[cat]); $cat_name = $t[0]; $cat_pic = $t[1]; /* AFFICHAGE TITRE CATEGORIE */ $Design->OpenTable("100%","28","","0","","","0","","","Bottom",1); echo "".$cat_name.""; $Design->CloseTable(); $Design->OpenTable("100%","","","0","","","1","#666666","#000000","Middle",0); if($enable_url_rewrite) { if(!empty($cat_pic)) echo "".htmlentities($cat_name)." : "; echo "
"; $q3 = MYSQL_QUERY("SELECT DISTINCT sub_cat FROM articles WHERE cat='$r1[cat]' "); while( $r3 = mysql_fetch_array($q3) ) { $q4 = MYSQL_QUERY("SELECT name FROM sub_cat WHERE id='$r3[sub_cat]'"); $r4 = MYSQL_FETCH_ARRAY($q4); echo "    $r4[name]
"; } } else { if(!empty($cat_pic)) echo "".htmlentities($cat_name)." : "; echo "
"; $q3 = MYSQL_QUERY("SELECT DISTINCT sub_cat FROM articles WHERE cat='$r1[cat]' "); while( $r3 = mysql_fetch_array($q3) ) { $q4 = MYSQL_QUERY("SELECT name FROM sub_cat WHERE id='$r3[sub_cat]'"); $r4 = MYSQL_FETCH_ARRAY($q4); echo "    $r4[name]
"; } } $Design->CloseTable(); $Design->JumpLine(1); } echo "

\n\n"; } include("theme/bpage.php"); ?>