From 0fac4eabc661e4425cf21d461c0e18b542fa8003 Mon Sep 17 00:00:00 2001 From: ilotterytea Date: Fri, 16 May 2025 01:04:52 +0500 Subject: feat: some code refactoring --- src/emote.php | 148 ++++++++++++++++++++++++++++++++++++++++++++++++++-------- 1 file changed, 129 insertions(+), 19 deletions(-) (limited to 'src/emote.php') diff --git a/src/emote.php b/src/emote.php index 74db4ca..01a204a 100644 --- a/src/emote.php +++ b/src/emote.php @@ -1,4 +1,6 @@ id = $id; - $this->code = $code; - $this->ext = $ext; - $this->created_at = $created_at; - $this->uploaded_by = $uploaded_by; - $this->is_in_user_set = $is_in_user_set; - $this->rating = $rating; - $this->visibility = $visibility; - $this->source = $source; - $this->tags = $tags; + $e = new Emote(); + + $e->id = $arr["id"]; + $e->code = $arr["code"]; + $e->ext = $arr["ext"] ?? "webp"; + $e->uploaded_by = $arr["uploaded_by"]; + $e->created_at = strtotime($arr["created_at"] ?? 0); + $e->is_in_user_set = $arr["is_in_user_set"] ?? false; + $e->visibility = $arr["visibility"]; + $e->source = $arr["source"] ?? null; + $e->tags = $arr["tags"] ?? []; + + if (isset($arr["total_rating"], $arr["average_rating"])) { + $e->rating = [ + "total" => $arr["total_rating"], + "average" => $arr["average_rating"] + ]; + } else { + $e->rating = $arr["rating"] ?? null; + } + + return $e; + } + + public static function from_array_with_user(array $arr, PDO &$db): Emote + { + if ($arr["uploaded_by"]) { + $arr["uploaded_by"] = User::get_user_by_id($db, $arr["uploaded_by"]); + } + + return Emote::from_array($arr); } function get_id() @@ -79,6 +102,58 @@ class Emote } } +class Emoteset +{ + public string $id; + public string $name; + public User|null $owner; + public array $emotes; + + public bool $is_default; + + public static function from_array(array $arr): Emoteset + { + $s = new Emoteset(); + + $s->id = $arr["id"]; + $s->name = $arr["name"]; + $s->owner = $arr["owner_id"]; + $s->emotes = $arr["emotes"] ?? []; + $s->is_default = $arr["is_default"] ?? false; + + return $s; + } + + public static function from_array_extended(array $arr, string $user_id, PDO &$db): Emoteset + { + if ($arr["owner_id"]) { + $arr["owner_id"] = User::get_user_by_id($db, $arr["owner_id"]); + } + + $arr["emotes"] = fetch_all_emotes_from_emoteset($db, $arr["id"], $user_id); + + return Emoteset::from_array($arr); + } + + public static function get_all_user_emotesets(PDO &$db, string $user_id): array + { + $stmt = $db->prepare("SELECT es.*, aes.is_default FROM emote_sets es + INNER JOIN acquired_emote_sets aes ON aes.emote_set_id = es.id + WHERE aes.user_id = ? + "); + $stmt->execute([$user_id]); + + $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); + $emote_sets = []; + + foreach ($rows as $row) { + array_push($emote_sets, Emoteset::from_array_extended($row, $user_id, $db)); + } + + return $emote_sets; + } +} + function fetch_all_emotes_from_emoteset(PDO &$db, string $emote_set_id, string $user_id, int|null $limit = null): array { // fetching emotes @@ -106,17 +181,16 @@ function fetch_all_emotes_from_emoteset(PDO &$db, string $emote_set_id, string $ $stmt = $db->prepare($sql); $stmt->execute([$user_id, $emote_set_id]); - $emotes = $stmt->fetchAll(PDO::FETCH_ASSOC); + $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); + $emotes = []; // fetching uploaders - foreach ($emotes as &$e) { - if ($e["uploaded_by"]) { - $stmt = $db->prepare("SELECT id, username FROM users WHERE id = ?"); - $stmt->execute([$e["uploaded_by"]]); - - $e["uploaded_by"] = $stmt->fetch(PDO::FETCH_ASSOC); + foreach ($rows as $row) { + if ($row["uploaded_by"]) { + $row["uploaded_by"] = User::get_user_by_id($db, $row["uploaded_by"]); } - unset($e); + + array_push($emotes, Emote::from_array($row)); } return $emotes; @@ -171,4 +245,40 @@ function html_featured_emote(PDO &$db) get_id() . '">'; + + if ($e->is_added_by_user()) { + echo ''; + } + + echo '' . $e->get_code() . ''; + echo '

' . $e->get_code() . '

'; + echo '

' . ($e->get_uploaded_by() == null ? (ANONYMOUS_DEFAULT_NAME . "*") : $e->get_uploaded_by()->username) . '

'; + echo ''; + } +} + +function html_display_emoteset(array $emotesets) +{ + foreach ($emotesets as $es) { + echo ""; + + echo '
'; + echo "

$es->name

"; + echo '
'; + + echo '
'; + + foreach ($es->emotes as $e) { + echo "{$e->code}"; + } + + echo '
'; + + } } \ No newline at end of file -- cgit v1.2.3