From a8a338599b3d891ee72a48a5f01f25c1ded31f21 Mon Sep 17 00:00:00 2001 From: ilotterytea Date: Sun, 26 Oct 2025 18:07:02 +0500 Subject: feat: authenticate users --- lib/users.php | 32 ++++++++++++++++++++++++++++++++ 1 file changed, 32 insertions(+) create mode 100644 lib/users.php (limited to 'lib/users.php') diff --git a/lib/users.php b/lib/users.php new file mode 100644 index 0000000..e454a72 --- /dev/null +++ b/lib/users.php @@ -0,0 +1,32 @@ +prepare('SELECT * FROM users WHERE token = ?'); + $stmt->execute([$_COOKIE['SECRET_TINYSOUNDS_KEY']]); + + $user = $stmt->fetch(PDO::FETCH_ASSOC) ?: null; + + if (!$user) { + unset($_COOKIE['SECRET_TINYSOUNDS_KEY']); + unset($_SESSION['user']); + return false; + } + + $stmt = $db->prepare('SELECT * FROM user_connections WHERE user_id = ?'); + $stmt->execute([$user['id']]); + + $user['connections'] = $stmt->fetchAll(PDO::FETCH_ASSOC); + + $_SESSION['user'] = $user; + return true; +} \ No newline at end of file -- cgit v1.2.3