'; } // Pas d'accès direct à la page download sans file ID if(isset($_GET['action']) && $_GET['action'] == 'nodirect') { echo ''; } // Pas d'accès à la page download si le file ID n'existe pas if(isset($_GET['action']) && $_GET['action'] == 'noexist') { echo ''; } //On affiche le message de suppression if(isset($_GET['delpost'])){ echo ''; } ?> query('SELECT postHash FROM blog_posts_seo'); $pages->set_total($stmt->rowCount()); // On met en place le tri-------------------------------------------- if(isset($_GET['tri'])) { $tri = html($_GET['tri']); } else { $post_tri = 'postDate'; $tri = html($post_tri); } if(isset($_GET['ordre'])) { $ordre = html($_GET['ordre']); } else { $ordre_tri = 'desc'; $ordre = html($ordre_tri); } // Protection du tri ----------------------------------------------- if (!empty($_GET['tri']) && !in_array($_GET['tri'], array('postID','postHash', 'postTitle', 'postViews', 'postTaille', 'postDate', 'postAuthor', 'seeders', 'leechers', 'completed'))) { header('Location: index.php'); exit(); } if (!empty($_GET['ordre']) && !in_array($_GET['ordre'], array('asc','desc','ASC','DESC'))) { header('Location: index.php'); exit(); } $stmt = $db->query('SELECT * FROM blog_posts_seo b LEFT JOIN xbt_files x ON x.fid = b.postID ORDER BY '.$tri.' '.$ordre.' '.$pages->get_limit()); while($row = $stmt->fetch()){ $stmt2 = $db->prepare('SELECT catTitle, catSlug FROM blog_cats, blog_post_cats WHERE blog_cats.catID = blog_post_cats.catID AND blog_post_cats.postID = :postID ORDER BY catTitle ASC'); $stmt2->execute(array(':postID' => $row['postID'])); $catRow = $stmt2->fetchAll(PDO::FETCH_ASSOC); echo ''; echo ''; echo ''; sscanf($row['postDate'], "%4s-%2s-%2s %2s:%2s:%2s", $annee, $mois, $jour, $heure, $minute, $seconde); echo ''; //echo ''; $links = array(); foreach ($catRow as $cat) { $links[] = ''.$cat['catTitle'].''; } $max = 120; $chaine = implode(", ", $links); if (strlen($chaine) >= $max) { $chaine = substr($chaine, 0, $max); $espace = strrpos($chaine, ", "); $chaine = substr($chaine, 0, $espace).' ...'; } echo ''; $exa = '0x'; $hash = $exa.$row['postHash']; $stmt3 = $db->prepare('SELECT * FROM blog_posts_seo,xbt_files WHERE blog_posts_seo.postHash = :postHash AND xbt_files.info_hash = '.$hash); $stmt3->execute(array(':postHash' => $row['postHash'])); $xbt = $stmt3->fetch(); echo ''; echo ''; echo ''; echo ''; } } catch(PDOException $e) { echo $e->getMessage(); } ?>

↑Nom↓	↑Taille↓	↑Ajouté↓	Catégorie(s)	↑S↓	↑L↓	↑T↓
'.html($row['postTitle']).''; echo '	'; echo html(makesize($row['postTaille'])); echo '	'.$jour.'-'.$mois.'-'.$annee.'	'.html($row['postAuthor']).'	'.$chaine.'	'.$xbt['seeders'].'	'.$xbt['leechers'].'	'.$xbt['completed'].'

page_links('?tri='.$tri.'&ordre='.$ordre.'&'); ?>

Légende : S = Nb de Seeders, L = Nb de Leechers, T = Nb de Téléchargements