diff options
| author | citizenz7 <citizenz7@protonmail.com> | 2017-04-20 18:50:55 +0200 |
|---|---|---|
| committer | citizenz7 <citizenz7@protonmail.com> | 2017-04-20 18:50:55 +0200 |
| commit | 5fd9fa480f302902328b81f912dd67ce378284f8 (patch) | |
| tree | 66234843ae2857fda12442e4f7577c527d48977c /Html/catpost.php | |
| parent | ebe731862c7c741171138b1083906f391fc35aff (diff) | |
| download | freetorrent-5fd9fa480f302902328b81f912dd67ce378284f8.tar.xz freetorrent-5fd9fa480f302902328b81f912dd67ce378284f8.zip | |
V.1.4.6
Diffstat (limited to '')
| -rw-r--r-- | Html/catpost.php | 137 |
1 files changed, 137 insertions, 0 deletions
diff --git a/Html/catpost.php b/Html/catpost.php new file mode 100644 index 0000000..3e5c8e3 --- /dev/null +++ b/Html/catpost.php @@ -0,0 +1,137 @@ +<?php +require_once('includes/config.php'); + +$stmt = $db->prepare('SELECT catID,catTitle FROM blog_cats WHERE catSlug = :catSlug'); +$stmt->bindValue(':catSlug', $_GET['id'], PDO::PARAM_INT); +$stmt->execute(); +$row = $stmt->fetch(); + + +if (!isset($row['catID']) || empty($row['catID'])) { + header('Location: ./'); + exit(); +} + +elseif (!filter_var($row['catID'], FILTER_VALIDATE_INT)) { + header('Location: ./'); + exit(); +} + + +$pagetitle = 'Catégorie : '.html($row['catTitle']); + +include_once('includes/header.php'); + +define("_BBC_PAGE_NAME", $pagetitle); +define("_BBCLONE_DIR", "bbclone/"); +define("COUNTER", _BBCLONE_DIR."mark_page.php"); +if (is_readable(COUNTER)) include_once(COUNTER); +?> + +<body> +<div id="container"> + + <?php + include_once('includes/header-logo.php'); + include_once('includes/nav.php'); + ?> + + <div id="body"> + <div id="content"> + + <?php + include_once('includes/ariane.php'); + ?> + + <br /> + + <h3><?php echo html($row['catTitle']); ?></h3> + + + <?php + try { + + $pages = new Paginator('5','p'); + + $stmt = $db->prepare('SELECT blog_posts_seo.postID FROM blog_posts_seo, blog_post_cats WHERE blog_posts_seo.postID = blog_post_cats.postID AND blog_post_cats.catID = :catID'); + $stmt->bindValue(':catID', $row['catID'], PDO::PARAM_INT); + $stmt->execute(); + + $count = $stmt->rowCount(); + + if (empty($count)) { + echo '<p>Aucun torrent dans cette catégorie.</p>'; + } + + + //pass number of records to + $pages->set_total($stmt->rowCount()); + + $stmt = $db->prepare(' + SELECT + blog_posts_seo.postID, blog_posts_seo.postHash, blog_posts_seo.postTitle, blog_posts_seo.postAuthor, blog_posts_seo.postSlug, blog_posts_seo.postLink, blog_posts_seo.postDesc, blog_posts_seo.postTaille, blog_posts_seo.postDate, blog_posts_seo.postViews, blog_posts_seo.postImage + FROM + blog_posts_seo, + blog_post_cats + WHERE + blog_posts_seo.postID = blog_post_cats.postID + AND blog_post_cats.catID = :catID + ORDER BY + postID DESC + '.$pages->get_limit()); + $stmt->bindValue(':catID', $row['catID'], PDO::PARAM_INT); + $stmt->execute(); + + while($row = $stmt->fetch()){ + + echo '<fieldset>'; + echo '<span style="font-weight: bold; font-size: 18px;"><a style="text-decoration: none;" href="'.html($row['postSlug']).'">'.html($row['postTitle']).'</a></span>'; + echo '<br /><span style="font-size: 12px;">Posté le '.date_fr('l j F Y à H:i:s', strtotime($row['postDate'])).' par '; + + $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'); + $stmt2->bindValue(':postID', $row['postID'], PDO::PARAM_INT); + $stmt2->execute(); + $catRow = $stmt2->fetchAll(PDO::FETCH_ASSOC); + + echo html($row['postAuthor']).' dans '; + + $links = array(); + foreach ($catRow as $cat) + { + $links[] = "<a href='c-".html($cat['catSlug'])."'>".html($cat['catTitle'])."</a>"; + } + echo implode(", ", $links); + + echo '</span>'; + + echo '<p style="text-align:justify; font-size:12px;">'; + echo '<img src="'.$WEB_IMAGES_TORRENTS.$row['postImage'].'" alt="'.$row['postTitle'].'" style="float:left; margin-right:15px; margin-bottom:10px; margin-top:6px; border: 1px solid #C0C0C0; max-width:70px; max-height:70px;" />'; + echo bbcode($row['postDesc']); + echo '</p>'; + + echo '</fieldset>'; + + } + + echo '<br /><br />'; + echo $pages->page_links('c-'.html($_GET['id']).'&'); + + } catch(PDOException $e) { + echo $e->getMessage(); + } + + ?> + </div> + + <?php include_once('sidebar.php'); ?> + + <div class="clear"></div> + </div> +</div> + +<div id="footer"> + <?php include_once('includes/footer.php'); ?> +</div> + +</body> +</html> |