From be2912e26bdf1843c3a91fc0717b301f168d4962 Mon Sep 17 00:00:00 2001
From: ilotterytea <iltsu@alright.party>
Date: Fri, 9 May 2025 18:15:54 +0500
Subject: feat: option to log user actions

---
 public/users.php | 167 ++++++++++++++++++++++++++++---------------------------
 1 file changed, 86 insertions(+), 81 deletions(-)

(limited to 'public/users.php')

diff --git a/public/users.php b/public/users.php
index 5d1f125..7146cd1 100644
--- a/public/users.php
+++ b/public/users.php
@@ -231,10 +231,13 @@ $stmt->execute([$user->id(), $user->id()]);
 $uploaded_emotes = $stmt->fetchAll(PDO::FETCH_ASSOC);
 
 // gathering actions
-$stmt = $db->prepare("SELECT a.* FROM actions a WHERE a.user_id = ? ORDER BY a.created_at DESC LIMIT 15");
-$stmt->execute([$user->id()]);
+$actions = [];
 
-$actions = $stmt->fetchAll(PDO::FETCH_ASSOC);
+if (ACCOUNT_LOG_ACTIONS) {
+    $stmt = $db->prepare("SELECT a.* FROM actions a WHERE a.user_id = ? ORDER BY a.created_at DESC LIMIT 15");
+    $stmt->execute([$user->id()]);
+    $actions = $stmt->fetchAll(PDO::FETCH_ASSOC);
+}
 
 // TODO: add functionality
 
@@ -514,56 +517,46 @@ if ($is_json) {
                     }
                     ?>
 
-                    <!-- Actions -->
-                    <section class="box">
-                        <div class="box navtab">
-                            <p>Actions</p>
-                        </div>
-                        <div class="box content">
-                            <?php
-                            if (empty($actions)) {
-                                echo "<p>This user has done nothing bad or good...</p>";
-                            }
-
-                            foreach ($actions as $action) {
-                                echo '<div class="row">';
-
-                                list($action_name, $preposition, $icon_name) = match ($action["action_type"]) {
-                                    "EMOTESET_ADD" => ["added", "to", "yes.png"],
-                                    "EMOTESET_REMOVE" => ["removed", "from", "no.png"],
-                                    "EMOTESET_ALIAS" => ["renamed", "in", "pencil.png"],
-                                    "EMOTE_CREATE" => ["created", null, "new_emote.png"],
-                                    "EMOTE_DELETE" => ["deleted", null, "deleted_emote.png"],
-                                    "EMOTE_RENAME" => ["renamed", null, "renamed_emote.png"]
-                                };
+                    <?php if (ACCOUNT_LOG_ACTIONS): ?>
+                        <!-- Actions -->
+                        <section class="box">
+                            <div class="box navtab">
+                                <p>Actions</p>
+                            </div>
+                            <div class="box content">
+                                <?php
+                                if (empty($actions)) {
+                                    echo "<p>This user has done nothing bad or good...</p>";
+                                }
 
-                                echo "<div><img src='/static/img/icons/$icon_name' width='16' /></div>";
+                                foreach ($actions as $action) {
+                                    echo '<div class="row">';
 
-                                echo '<div class="column">';
-                                echo '<p>';
-                                echo '<i>' . $user->username() . '</i> ';
+                                    list($action_name, $preposition, $icon_name) = match ($action["action_type"]) {
+                                        "EMOTESET_ADD" => ["added", "to", "yes.png"],
+                                        "EMOTESET_REMOVE" => ["removed", "from", "no.png"],
+                                        "EMOTESET_ALIAS" => ["renamed", "in", "pencil.png"],
+                                        "EMOTE_CREATE" => ["created", null, "new_emote.png"],
+                                        "EMOTE_DELETE" => ["deleted", null, "deleted_emote.png"],
+                                        "EMOTE_RENAME" => ["renamed", null, "renamed_emote.png"]
+                                    };
 
-                                $payload = json_decode($action["action_payload"], true);
+                                    echo "<div><img src='/static/img/icons/$icon_name' width='16' /></div>";
 
-                                list($action_root, $action_sub) = explode("_", $action["action_type"]);
+                                    echo '<div class="column">';
+                                    echo '<p>';
+                                    echo '<i>' . $user->username() . '</i> ';
 
-                                switch ($action_root) {
-                                    case "EMOTESET": {
-                                        $e_stmt = $db->prepare("SELECT COUNT(*) FROM emotes WHERE id = ?");
-                                        $e_stmt->execute([$payload["emote"]["id"]]);
+                                    $payload = json_decode($action["action_payload"], true);
 
-                                        echo "$action_name emote <a href=\"";
+                                    list($action_root, $action_sub) = explode("_", $action["action_type"]);
 
-                                        if ($e_stmt->rowCount() == 1) {
-                                            echo '/emotes?id=' . $payload["emote"]["id"] . '">';
-                                            echo '<img src="/static/userdata/emotes/' . $payload["emote"]["id"] . '/1x.webp" height="16" /> ';
-                                        } else {
-                                            echo '">';
-                                        }
+                                    switch ($action_root) {
+                                        case "EMOTESET": {
+                                            $e_stmt = $db->prepare("SELECT COUNT(*) FROM emotes WHERE id = ?");
+                                            $e_stmt->execute([$payload["emote"]["id"]]);
 
-                                        if (isset($payload["emote"]["original_code"])) {
-                                            echo $payload["emote"]["original_code"] . '</a> to ';
-                                            echo "<a href=\"";
+                                            echo "$action_name emote <a href=\"";
 
                                             if ($e_stmt->rowCount() == 1) {
                                                 echo '/emotes?id=' . $payload["emote"]["id"] . '">';
@@ -572,51 +565,63 @@ if ($is_json) {
                                                 echo '">';
                                             }
 
-                                            echo $payload["emote"]["code"] . '</a>';
-                                        } else {
-                                            echo $payload["emote"]["code"] . '</a>';
-                                        }
+                                            if (isset($payload["emote"]["original_code"])) {
+                                                echo $payload["emote"]["original_code"] . '</a> to ';
+                                                echo "<a href=\"";
 
-                                        $es_stmt = $db->prepare("SELECT COUNT(*) FROM emote_sets WHERE id = ?");
-                                        $es_stmt->execute([$payload["emoteset"]["id"]]);
+                                                if ($e_stmt->rowCount() == 1) {
+                                                    echo '/emotes?id=' . $payload["emote"]["id"] . '">';
+                                                    echo '<img src="/static/userdata/emotes/' . $payload["emote"]["id"] . '/1x.webp" height="16" /> ';
+                                                } else {
+                                                    echo '">';
+                                                }
 
-                                        echo " $preposition <a href=\"";
-                                        if ($es_stmt->rowCount() == 1) {
-                                            echo '/emotesets.php?id=' . $payload["emoteset"]["id"];
-                                        }
+                                                echo $payload["emote"]["code"] . '</a>';
+                                            } else {
+                                                echo $payload["emote"]["code"] . '</a>';
+                                            }
 
-                                        echo '">' . $payload["emoteset"]["name"] . '</a>';
-                                        break;
-                                    }
-                                    case "EMOTE": {
-                                        $e_stmt = $db->prepare("SELECT COUNT(*) FROM emotes WHERE id = ?");
-                                        $e_stmt->execute([$payload["emote"]["id"]]);
+                                            $es_stmt = $db->prepare("SELECT COUNT(*) FROM emote_sets WHERE id = ?");
+                                            $es_stmt->execute([$payload["emoteset"]["id"]]);
 
-                                        echo "$action_name emote <a href=\"";
+                                            echo " $preposition <a href=\"";
+                                            if ($es_stmt->rowCount() == 1) {
+                                                echo '/emotesets.php?id=' . $payload["emoteset"]["id"];
+                                            }
 
-                                        if ($e_stmt->rowCount() == 1) {
-                                            echo '/emotes?id=' . $payload["emote"]["id"] . '">';
-                                            echo '<img src="/static/userdata/emotes/' . $payload["emote"]["id"] . '/1x.webp" height="16" /> ';
-                                        } else {
-                                            echo '">';
+                                            echo '">' . $payload["emoteset"]["name"] . '</a>';
+                                            break;
                                         }
+                                        case "EMOTE": {
+                                            $e_stmt = $db->prepare("SELECT COUNT(*) FROM emotes WHERE id = ?");
+                                            $e_stmt->execute([$payload["emote"]["id"]]);
 
-                                        echo $payload["emote"]["code"] . '</a>';
-                                        break;
-                                    }
-                                    default: {
-                                        echo "something that we don't know";
-                                        break;
+                                            echo "$action_name emote <a href=\"";
+
+                                            if ($e_stmt->rowCount() == 1) {
+                                                echo '/emotes?id=' . $payload["emote"]["id"] . '">';
+                                                echo '<img src="/static/userdata/emotes/' . $payload["emote"]["id"] . '/1x.webp" height="16" /> ';
+                                            } else {
+                                                echo '">';
+                                            }
+
+                                            echo $payload["emote"]["code"] . '</a>';
+                                            break;
+                                        }
+                                        default: {
+                                            echo "something that we don't know";
+                                            break;
+                                        }
                                     }
-                                }
 
-                                echo '</p>';
-                                echo '<span class="font-small" style="color: gray;">[' . format_timestamp(time() - strtotime($action["created_at"])) . ' ago]</span> ';
-                                echo '</div></div>';
-                            }
-                            ?>
-                        </div>
-                    </section>
+                                    echo '</p>';
+                                    echo '<span class="font-small" style="color: gray;">[' . format_timestamp(time() - strtotime($action["created_at"])) . ' ago]</span> ';
+                                    echo '</div></div>';
+                                }
+                                ?>
+                            </div>
+                        </section>
+                    <?php endif; ?>
                 </section>
             </section>
         </div>
-- 
cgit v1.2.3