From be2912e26bdf1843c3a91fc0717b301f168d4962 Mon Sep 17 00:00:00 2001 From: ilotterytea Date: Fri, 9 May 2025 18:15:54 +0500 Subject: feat: option to log user actions --- public/account/index.php | 18 ++--- public/emotes/setmanip.php | 18 +++-- public/emotes/upload.php | 28 ++++---- public/users.php | 167 +++++++++++++++++++++++---------------------- src/config.sample.php | 1 + 5 files changed, 124 insertions(+), 108 deletions(-) diff --git a/public/account/index.php b/public/account/index.php index 7bb19f5..48bfb8d 100644 --- a/public/account/index.php +++ b/public/account/index.php @@ -144,14 +144,16 @@ if ($_SERVER['REQUEST_METHOD'] == "POST") {
- prepare("SELECT hide_actions FROM user_preferences WHERE id = ?"); - $stmt->execute([$_SESSION["user_id"]]); - if (intval($stmt->fetch()[0]) == 1) { - echo 'checked'; - } - ?>> - + + prepare("SELECT hide_actions FROM user_preferences WHERE id = ?"); + $stmt->execute([$_SESSION["user_id"]]); + if (intval($stmt->fetch()[0]) == 1) { + echo 'checked'; + } + ?>> + +
diff --git a/public/emotes/setmanip.php b/public/emotes/setmanip.php index 71d922b..8e8d840 100644 --- a/public/emotes/setmanip.php +++ b/public/emotes/setmanip.php @@ -82,8 +82,10 @@ switch ($action) { $stmt = $db->prepare("INSERT INTO emote_set_contents(emote_set_id, emote_id, added_by) VALUES (?, ?, ?)"); $stmt->execute([$emote_set_id, $emote_id, $user_id]); - $db->prepare("INSERT INTO actions(user_id, action_type, action_payload) VALUES (?, ?, ?)") - ->execute([$user_id, "EMOTESET_ADD", json_encode($payload)]); + if (ACCOUNT_LOG_ACTIONS) { + $db->prepare("INSERT INTO actions(user_id, action_type, action_payload) VALUES (?, ?, ?)") + ->execute([$user_id, "EMOTESET_ADD", json_encode($payload)]); + } $db = null; @@ -100,8 +102,10 @@ switch ($action) { exit; } - $db->prepare("INSERT INTO actions(user_id, action_type, action_payload) VALUES (?, ?, ?)") - ->execute([$user_id, "EMOTESET_REMOVE", json_encode($payload)]); + if (ACCOUNT_LOG_ACTIONS) { + $db->prepare("INSERT INTO actions(user_id, action_type, action_payload) VALUES (?, ?, ?)") + ->execute([$user_id, "EMOTESET_REMOVE", json_encode($payload)]); + } $db = null; @@ -137,8 +141,10 @@ switch ($action) { $stmt = $db->prepare("UPDATE emote_set_contents SET code = ? WHERE emote_set_id = ? AND emote_id = ?"); $stmt->execute([$value, $emote_set_id, $emote_id]); - $db->prepare("INSERT INTO actions(user_id, action_type, action_payload) VALUES (?, ?, ?)") - ->execute([$user_id, "EMOTESET_ALIAS", json_encode($payload)]); + if (ACCOUNT_LOG_ACTIONS) { + $db->prepare("INSERT INTO actions(user_id, action_type, action_payload) VALUES (?, ?, ?)") + ->execute([$user_id, "EMOTESET_ALIAS", json_encode($payload)]); + } $db = null; diff --git a/public/emotes/upload.php b/public/emotes/upload.php index 42e58c6..96544fd 100644 --- a/public/emotes/upload.php +++ b/public/emotes/upload.php @@ -389,19 +389,21 @@ if ($is_manual) { } } -$db->prepare("INSERT INTO actions(user_id, action_type, action_payload) VALUES (?, ?, ?)") - ->execute([ - $uploaded_by, - "EMOTE_CREATE", - json_encode([ - "emote" => [ - "id" => $id, - "code" => $code, - "visibility" => $visibility, - "uploaded_by" => $uploaded_by, - ] - ]) - ]); +if (ACCOUNT_LOG_ACTIONS) { + $db->prepare("INSERT INTO actions(user_id, action_type, action_payload) VALUES (?, ?, ?)") + ->execute([ + $uploaded_by, + "EMOTE_CREATE", + json_encode([ + "emote" => [ + "id" => $id, + "code" => $code, + "visibility" => $visibility, + "uploaded_by" => $uploaded_by, + ] + ]) + ]); +} $db = null; 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

-
-
- This user has done nothing bad or good...

"; - } - - foreach ($actions as $action) { - echo '
'; - - 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"] - }; + + +
+
+

Actions

+
+
+ This user has done nothing bad or good...

"; + } - echo "
"; + foreach ($actions as $action) { + echo '
'; - echo '
'; - echo '

'; - echo '' . $user->username() . ' '; + 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 "

"; - list($action_root, $action_sub) = explode("_", $action["action_type"]); + echo '
'; + echo '

'; + echo '' . $user->username() . ' '; - 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 rowCount() == 1) { - echo '/emotes?id=' . $payload["emote"]["id"] . '">'; - echo ' '; - } 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"] . ' to '; - echo "rowCount() == 1) { echo '/emotes?id=' . $payload["emote"]["id"] . '">'; @@ -572,51 +565,63 @@ if ($is_json) { echo '">'; } - echo $payload["emote"]["code"] . ''; - } else { - echo $payload["emote"]["code"] . ''; - } + if (isset($payload["emote"]["original_code"])) { + echo $payload["emote"]["original_code"] . ' to '; + echo "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 ' '; + } else { + echo '">'; + } - echo " $preposition rowCount() == 1) { - echo '/emotesets.php?id=' . $payload["emoteset"]["id"]; - } + echo $payload["emote"]["code"] . ''; + } else { + echo $payload["emote"]["code"] . ''; + } - echo '">' . $payload["emoteset"]["name"] . ''; - 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 rowCount() == 1) { + echo '/emotesets.php?id=' . $payload["emoteset"]["id"]; + } - if ($e_stmt->rowCount() == 1) { - echo '/emotes?id=' . $payload["emote"]["id"] . '">'; - echo ' '; - } else { - echo '">'; + echo '">' . $payload["emoteset"]["name"] . ''; + break; } + case "EMOTE": { + $e_stmt = $db->prepare("SELECT COUNT(*) FROM emotes WHERE id = ?"); + $e_stmt->execute([$payload["emote"]["id"]]); - echo $payload["emote"]["code"] . ''; - break; - } - default: { - echo "something that we don't know"; - break; + echo "$action_name emote rowCount() == 1) { + echo '/emotes?id=' . $payload["emote"]["id"] . '">'; + echo ' '; + } else { + echo '">'; + } + + echo $payload["emote"]["code"] . ''; + break; + } + default: { + echo "something that we don't know"; + break; + } } - } - echo '

'; - echo '[' . format_timestamp(time() - strtotime($action["created_at"])) . ' ago] '; - echo '
'; - } - ?> -
-
+ echo '

'; + echo '[' . format_timestamp(time() - strtotime($action["created_at"])) . ' ago] '; + echo '
'; + } + ?> +
+ + diff --git a/src/config.sample.php b/src/config.sample.php index 7478be6..9a50d2d 100644 --- a/src/config.sample.php +++ b/src/config.sample.php @@ -49,6 +49,7 @@ define("ACCOUNT_SECRET_KEY_LENGTH", 32); // The length for secret keys. define("ACCOUNT_PFP_MAX_SIZE", [128, 128]); // Max dimensions for account pictures. define("ACCOUNT_BANNER_MAX_SIZE", [1920, 1080]); // Max dimensions for account banners. define("ACCOUNT_PUBLIC_LIST", true); // The public list of accounts. +define("ACCOUNT_LOG_ACTIONS", true); // Log user's actions (emote addition, etc.). // TWITCH define("TWITCH_REGISTRATION_ENABLE", false); // Enable account registration via Twitch. -- cgit v1.2.3