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>