prepare("SELECT uploaded_by, code FROM emotes WHERE id = ?"); $stmt->execute([$emote_id]); if ($row = $stmt->fetch()) { if ($row["uploaded_by"] === $user_id) { $unlink = intval($_POST["unlink"] ?? "0") == 1; if ($unlink) { $stmt = $db->prepare("UPDATE emotes SET uploaded_by = NULL WHERE id = ? AND uploaded_by = ?"); $stmt->execute([$emote_id, $user_id]); generate_alert("/emotes/?id=$emote_id", 'Your authorship has been removed for the emote "' . $row["code"] . '"', 200); } else { $stmt = $db->prepare("DELETE FROM emotes WHERE id = ? AND uploaded_by = ?"); $stmt->execute([$emote_id, $user_id]); $path = $_SERVER["DOCUMENT_ROOT"] . "/static/userdata/emotes/$emote_id"; array_map("unlink", glob("$path/*.*")); rmdir($path); generate_alert("/emotes", 'Emote "' . $row["code"] . '" has been removed from the servers', 200); } } else { generate_alert("/emotes", "You don't own the emote \"" . $row["code"] . "\"", 403); } } else { generate_alert("/emotes", "Emote ID $emote_id not found", 404); }