예제 #1
0
 include_once "dbconnect.php";
 //grab all topics, but sort them by descending order based on "last post"
 $post_query = "SELECT * FROM posts WHERE topic_id = '{$topic_id}' ORDER BY id ASC";
 $post_result = $conn->query($post_query);
 $responses = $post_result->num_rows;
 if ($responses == 0) {
     //not a valid topic
     $post_result->free();
     giveError("Invalid Post");
 } else {
     if (isset($_GET['u'])) {
         if (is_numeric($_GET['u'])) {
             $filtered_user = $_GET['u'];
         }
     }
     $user_array = generateUserArray();
     //board_functions
     include_once "board_header.php";
     //board_functions
     while ($post = $post_result->fetch_assoc()) {
         //check to see if post has been edited
         if ($post['edited'] > 0) {
             $edited = array('exist' => true, 'times' => $post['edited'], 'id' => $post['id']);
         } else {
             $edited = array('exist' => false);
         }
         $poster = matchUserIdToUsername($post['post_creator_id'], $user_array);
         //board_functions
         $date = formatTime($post['post_time']);
         $details = array('exist' => true, 'id' => $post['id'], 'topic_id' => $topic_id);
         if (!isset($filtered_user)) {
예제 #2
0
<?php

include_once "board_functions.php";
$user_array = generateUserArray($conn);
//board_functions
$user = matchUserIdToUsername($_SESSION['id'], $user_array);
$user_query = "SELECT * FROM members WHERE username='******'";
$user_result = $conn->query($user_query);
while ($user = $user_result->fetch_assoc()) {
    if (!isset($_GET['topic_id'])) {
        //not in a topic
        echo "<center>";
        echo "<a href='profile.php?id=" . $user['id'] . "'>" . $user['username'] . "</a> | <a href='postmsg.php'>Create New Topic</a> | <a href='logout.php'>Logout</a>";
        echo "</center>";
    } else {
        echo "<center>";
        echo "<a href='profile.php?id=" . $user['id'] . "'>" . $user['username'] . "</a> | <a href='topiclist.php'>Topic List</a> | <a href='postmsg.php?topic_id=" . $_GET['topic_id'] . "'>Reply</a> | <a href='logout.php'>Logout</a>";
        echo "</center>";
    }
    echo "<br>";
}