<?php

session_start();

include ('includes/header.html');

if (is_numeric($_GET['id'])) {

    $id = $_GET['id'];

    $q = "SELECT post_id, in_thread, post_content, post_date, post_author FROM posts WHERE in_thread='$id' ORDER BY post_date ASC";
    $q2 = "SELECT thread_title FROM threads WHERE thread_id='$id'";
    $r = mysqli_query($dbc, $q);
    $r2 = mysqli_query($dbc, $q2);
    $row2 = mysqli_fetch_array($r2, MYSQLI_ASSOC);
    
    if (mysqli_num_rows($r) > 0) {


        echo "<div id=\"nav\"><p><a href=\"/myboard/\">Index</a> > {$row2['thread_title']}</p></div>";

        while ($row = mysqli_fetch_array($r, MYSQLI_ASSOC)) {
        	
        	$date = date_create($row['post_date']);    		
    		$fdate = date_format($date, 'j-m-y G:i:s');
    		
    		$q3 = "SELECT username, date FROM users WHERE user_id='{$row['post_author']}'";
			$r3 = mysqli_query($dbc, $q3);
			$row3 = mysqli_fetch_array($r3);
			
			$regdate = date_create($row3['date']);
			$fregdate = date_format($regdate, 'jS F');
			
			$q4 = "SELECT post_author FROM posts WHERE post_author='{$row['post_author']}'";
    		$r4 = mysqli_query($dbc, $q4);
    		$rows4 = mysqli_num_rows($r4);

            echo '<div id="post">';
            echo "<div id=\"leftpost\">
			<p><a href=\"user.php?id={$row['post_author']}\" class=\"thread-user\">" . ucwords($row3['username']) . "</a></p>
			<p>Joined:</p>
			<p>$fregdate</p>
			<p>Posts:</p>
			<p>$rows4</p>
			</div>
			<div id=\"rightpost\">
			<div id=\"toppost\">
			{$fdate}
			</div>			
			{$row['post_content']}
			
			</div>
			<div id=\"bottompost\">
			<a href=\"reply.php?id=$id\">Reply</a>
			</div>
			";
            echo '</div>';
            
            $_SESSION['thread'] = $id;

        }

        echo "
		<p><a href=\"/myboard/\">Back</a></p>
		<p></p>";

    } else {
        echo "This is an empty thread!";
    }

} else {
    echo "Invalid thread specified.";
}

include ('includes/footer.html');

?>