diff options
Diffstat (limited to 'includes/functions_thread.php')
-rw-r--r-- | includes/functions_thread.php | 67 |
1 files changed, 0 insertions, 67 deletions
diff --git a/includes/functions_thread.php b/includes/functions_thread.php deleted file mode 100644 index 61b8e59..0000000 --- a/includes/functions_thread.php +++ /dev/null @@ -1,67 +0,0 @@ -<?php -include_once './includes/Database.php'; -include_once './includes/Session.php'; - -function get_all_threads(): array -{ - $sql = "SELECT thread_id FROM threads"; - $result = Database::get()->query($sql); - - $threads = array(); - - foreach ($result as $row) { - $thread = new Thread(); - $thread->get_from_database($row['thread_id']); - array_push($threads, $thread); - } - - return $threads; -} - -function create_thread($subject, $category) -{ - if (!Session::get()->is_signed_in()) { - trigger_error('You must be signed in to create a thread'); - return 0; - } - - $user = Session::get()->get_current_user(); - - // Insert the new thread into the database - $sql = "INSERT INTO threads(thread_subject, thread_date_created, thread_date_lastpost, thread_category, thread_author) VALUES (?, CONVERT_TZ(NOW(), 'SYSTEM', '+00:00'), CONVERT_TZ(NOW(), 'SYSTEM', '+00:00'), ?, ?);"; - Database::get()->query($sql, "sii", $subject, $category, $user->id); - - // Get the ID of the thread we just created - $thread_id = Database::get()->get_last_id(); - - // Increment the category's thread count - $sql = "UPDATE categories SET `cat_thread_count` = `cat_thread_count` + '1' WHERE cat_id = ?;"; - Database::get()->query($sql, "i", $category); - - return $thread_id; -} - -function delete_thread($thread) -{ - // User must be signed in - if (!Session::get()->is_signed_in()) { - trigger_error('You must be signed in to delete a thread.'); - return; - } - - // User must be a moderator to delete a thread - $current_user = Session::get()->get_current_user(); - if ($current_user->level != USER_LEVEL_MODERATOR) { - trigger_error("You must be a moderator to delete this post."); - return; - } - - // TODO: The post must not be locked - // TODO: The post must have not been around for a certain amount of time - - // Delete the thread from the database - Database::get()->query("DELETE FROM threads WHERE thread_id = ?", "i", $thread->id); - - // Decrement the thread count of the category - Database::get()->query("UPDATE categories SET `cat_thread_count` = `cat_thread_count` - '1' WHERE cat_id = ?", "i", $thread->category->id); -}
\ No newline at end of file |