From 999bfa6cad76900d4550e00e8e29f0252fb006b5 Mon Sep 17 00:00:00 2001
From: ilotterytea <iltsu@alright.party>
Date: Tue, 22 Apr 2025 22:39:58 +0500
Subject: feat: inbox system

---
 src/partials.php | 15 +++++++++++++++
 1 file changed, 15 insertions(+)

(limited to 'src/partials.php')

diff --git a/src/partials.php b/src/partials.php
index 71f4f63..174b1d3 100644
--- a/src/partials.php
+++ b/src/partials.php
@@ -12,6 +12,21 @@ function html_navigation_bar()
             <a href="/users.php" class="button">Users</a>
             <a href="/emotes/upload.php" class="button">Upload</a>
             <a href="/account" class="button">Account</a>
+            <?php
+            if (isset($_SESSION["user_id"])) {
+                $db = new PDO(DB_URL, DB_USER, DB_PASS);
+                $stmt = $db->prepare("SELECT COUNT(*) FROM inbox_messages WHERE recipient_id = ? AND has_read = false");
+                $stmt->execute([$_SESSION["user_id"]]);
+                $unread_count = intval($stmt->fetch()[0]);
+                echo '' ?>
+                <a href="/inbox.php" class="button">
+                    Inbox <?php echo $unread_count > 0 ? "($unread_count)" : "" ?>
+                </a>
+                <?php ;
+                $stmt = null;
+                $db = null;
+            }
+            ?>
         </div>
         <?php
         if (isset($_SESSION["user_id"])) {
-- 
cgit v1.2.3