From c23ad7cbf42f9590b4e0418b77c333f9dc7730e7 Mon Sep 17 00:00:00 2001 From: Cflip <36554078+cflip@users.noreply.github.com> Date: Sat, 23 Jan 2021 12:25:51 -0700 Subject: Change terminology from topics to threads --- category.php | 10 ++--- create_topic.php | 99 ----------------------------------------------- header.php | 2 +- includes/db_inc.php | 2 +- includes/register_inc.php | 0 includes/reply_inc.php | 6 +-- index.php | 4 +- setup.sql | 22 +++++------ topic.php | 67 -------------------------------- 9 files changed, 23 insertions(+), 189 deletions(-) delete mode 100644 create_topic.php delete mode 100644 includes/register_inc.php delete mode 100644 topic.php diff --git a/category.php b/category.php index b444ef3..fcc7851 100644 --- a/category.php +++ b/category.php @@ -27,21 +27,21 @@ mysqli_free_result($result); echo ''; -$sql = "SELECT topic_id, topic_subject, topic_date, user_name FROM topics LEFT JOIN users ON topic_author = user_id WHERE topic_cat = " . mysqli_real_escape_string($dbc, $_GET['id']) . " ORDER BY topic_id DESC"; +$sql = "SELECT thread_id, thread_subject, thread_date, user_name FROM threads LEFT JOIN users ON thread_author = user_id WHERE thread_cat = " . mysqli_real_escape_string($dbc, $_GET['id']) . " ORDER BY thread_id DESC"; $result = mysqli_query($dbc, $sql); if (!$result) { - die('Error trying to display topics: ' . mysqli_error($dbc)); + die('Error trying to display threads: ' . mysqli_error($dbc)); } // Display table of posts -echo '
Topic | Latest Post |
---|
Thread | Latest Post |
---|---|
';
- echo '' . $row['topic_subject'] . ''; - echo 'by ' . $row['user_name'] . ' on ' . date('M d, Y', strtotime($row['topic_date'])) . ' | by cflip 01-22-2021 9:34 | by cflip 01-22-2021 9:34 | ';
}
echo '