diff options
| author | ilotterytea <iltsu@alright.party> | 2025-04-22 17:24:24 +0500 |
|---|---|---|
| committer | ilotterytea <iltsu@alright.party> | 2025-04-22 17:24:24 +0500 |
| commit | 4e6193e82532967ff7159c91050a6bf33dceab1a (patch) | |
| tree | 41705b7156c825dac0394e579cb377275d3e297b /public | |
| parent | 08e8563f94e8b46c08df4c231c838d32365d8f08 (diff) | |
upd: show all user's reactions
Diffstat (limited to 'public')
| -rw-r--r-- | public/users.php | 18 |
1 files changed, 8 insertions, 10 deletions
diff --git a/public/users.php b/public/users.php index 54c7aed..2de3ed2 100644 --- a/public/users.php +++ b/public/users.php @@ -193,15 +193,11 @@ $contributions += intval($stmt->fetch()[0]); // getting status $status = 1; -// getting favorite reaction -$fav_reaction = null; - -$stmt = $db->prepare("SELECT rate, COUNT(*) AS c FROM ratings WHERE user_id = ? GROUP BY rate ORDER BY c DESC LIMIT 1"); +// getting reactions +$stmt = $db->prepare("SELECT rate, COUNT(*) AS c FROM ratings WHERE user_id = ? GROUP BY rate ORDER BY c DESC"); $stmt->execute([$user->id()]); -if ($row = $stmt->fetch()) { - $fav_reaction = $row; -} +$fav_reactions = $stmt->fetchAll(PDO::FETCH_ASSOC); // getting favorite emote $fav_emote = 1; @@ -295,12 +291,14 @@ if ($is_json) { <td><?php echo $contributions ?></td> </tr> <?php - if ($fav_reaction != null) { ?> + if ($fav_reactions != null) { ?> <tr> - <th><img src="/static/img/icons/emoticon_happy.png"> Favorite reaction</th> + <th><img src="/static/img/icons/emoticon_happy.png"> Reactions</th> <td> <?php - echo $fav_reaction["c"] . ' <img src="/static/img/icons/ratings/' . $fav_reaction["rate"] . '.png" alt="' . RATING_NAMES[$fav_reaction["rate"]] . '" title="' . RATING_NAMES[$fav_reaction["rate"]] . '">'; + foreach ($fav_reactions as $reaction) { + echo $reaction["c"] . ' <img src="/static/img/icons/ratings/' . $reaction["rate"] . '.png" alt="' . RATING_NAMES[$reaction["rate"]] . '" title="' . RATING_NAMES[$reaction["rate"]] . '">'; + } ?> </td> </tr><?php |