From 02e55d769d89ac0847d42c792c72b115ce003715 Mon Sep 17 00:00:00 2001 From: Kyren223 Date: Sat, 25 Jan 2025 16:30:50 +0200 Subject: Added a list of banned members server-side --- query/members.sql | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'query') diff --git a/query/members.sql b/query/members.sql index 3d20b01..9110759 100644 --- a/query/members.sql +++ b/query/members.sql @@ -6,6 +6,14 @@ FROM members JOIN users ON users.id = members.user_id WHERE network_id = ? AND is_member = true; +-- name: GetBannedMembers :many +SELECT + sqlc.embed(users), + sqlc.embed(members) +FROM members +JOIN users ON users.id = members.user_id +WHERE network_id = ? AND is_banned = true; + -- name: GetMemberById :one SELECT * FROM members WHERE network_id = ? AND user_id = ?; -- cgit v1.3.1