'; } $reply = mysqli_fetch_assoc($result); if (empty($reply)) { return '

Invalid quote!

'; } return '

Quote from ' . $reply['user_name'] . '
' . $reply['post_content'] . '

'; } } $sql = "SELECT thread_id, thread_subject, thread_date, user_id, user_name FROM threads LEFT JOIN users ON thread_author = user_id WHERE thread_id = " . mysqli_real_escape_string($dbc, $_GET['id']); $result = mysqli_query($dbc, $sql); if (!$result) { die('Error trying to display thread page: ' . mysqli_error($dbc)); } if (mysqli_num_rows($result) == 0) { echo 'This thread does not exist'; } else { while ($row = mysqli_fetch_assoc($result)) { echo '

' . $row['thread_subject'] . '

'; echo 'Created by ' . $row['user_name'] . ' on ' . date('M d, Y', strtotime($row['thread_date'])) . '

'; $thread_id = $row['thread_id']; } } echo ''; mysqli_free_result($result); $sql = "SELECT post_id, post_content, post_date, post_author, user_id, user_name FROM posts LEFT JOIN users ON post_author = user_id WHERE post_thread = " . mysqli_real_escape_string($dbc, $_GET['id']); $result = mysqli_query($dbc, $sql); if (!$result) { die('Error trying to display posts: ' . mysqli_error($dbc)); } if (mysqli_num_rows($result) == 0) { echo '

This thread has no posts

'; } else { echo ''; $post_index = 1; $thread_id = $_GET['id']; while ($row = mysqli_fetch_assoc($result)) { echo ''; echo ''; $post_content = $row['post_content']; $post_content = preg_replace_callback('/>#\d+/', function($matches) use($thread_id, $dbc) { return add_quote($dbc, $thread_id, $matches); }, $post_content); $post_content = preg_replace( "/\s*[a-zA-Z\/\/:\.]*youtu(be.com\/watch\?v=|.be\/)([a-zA-Z0-9\-_]+)([a-zA-Z0-9\/\*\-\_\?\&\;\%\=\.]*)/i", '
', $post_content); $post_content = preg_replace('/(https?:\/\/[^ ]+?(?:\.jpg|\.png|\.gif))/', '

', $post_content); //$post_content = preg_replace('/^>/', 'garb', $post_content); $post_content = preg_replace('@\b(http(s)?://)?([^\s]*?(?:\.[a-z\d?=/_-]+)+)(?![^<]*?(?:|/?>))@i', '$0', $post_content); echo ''; $post_index++; } echo '

	' . $post_index . '
Posted by ' . $row['user_name'] . ' ' . date('m/d/Y g:ia', strtotime($row['post_date'])) . '	' . $post_content . '

'; } mysqli_free_result($result); if (isset($_SESSION['signed_in'])) { echo '

'; } else { echo '

'; } include_once 'footer.php'; ?>

' . $row['thread_subject'] . '

Reply to this thread