From 8cdd763ec1dd461d9ff56451b7186029a0b1aa32 Mon Sep 17 00:00:00 2001 From: Kyren223 Date: Sun, 12 Jan 2025 16:46:07 +0200 Subject: Fixed a bunch of security issues with people not inside a server being able to read it and also fixed some other bugs and implemented propagation for members joining/leavings servers --- query/members.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'query/members.sql') diff --git a/query/members.sql b/query/members.sql index 65d3600..3d20b01 100644 --- a/query/members.sql +++ b/query/members.sql @@ -10,10 +10,10 @@ WHERE network_id = ? AND is_member = true; SELECT * FROM members WHERE network_id = ? AND user_id = ?; --- name: GetNetworksOfUser :many +-- name: GetUserNetworks :many SELECT networks.* FROM networks JOIN members ON networks.id = members.network_id -WHERE members.user_id = ?; +WHERE members.user_id = ? AND members.is_member = true; -- name: SetMember :one INSERT INTO members ( -- cgit v1.3.1