From 1b35cf3f1124b161ebde5e9e3a2c74c8ea2821d0 Mon Sep 17 00:00:00 2001 From: Connor Thomson Date: Sun, 20 Sep 2026 21:01:48 -0700 Subject: Add status and more --- php/user.php | 49 +++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 49 insertions(+) create mode 100644 php/user.php (limited to 'php/user.php') diff --git a/php/user.php b/php/user.php new file mode 100644 index 0000000..8a424e5 --- /dev/null +++ b/php/user.php @@ -0,0 +1,49 @@ +. + */ + +require_once ROOT . '/php/session.php'; +require_once ROOT . '/php/database.php'; + +const USER_STATUSES = ['none', 'member', 'mod', 'admin']; + +function find_user(string $username): ?array { + $sql = "SELECT id, username, status FROM users WHERE username = :username"; + + return fetch_row($sql, ['username' => $username]); +} + +function current_user(): ?array { + $user_id = get_user_id(); + + if ($user_id === null) { + return null; + } + + $sql = "SELECT id, username, status FROM users WHERE id = :id"; + + return fetch_row($sql, ['id' => $user_id]); +} + +function is_admin(): bool { + $user = current_user(); + + return $user !== null && $user['status'] === 'admin'; +} + +?> -- cgit v1.2.3