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

1 files changed, 2 insertions, 2 deletions

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 (