diff options
| author | Freya Murphy <freya@freyacat.org> | 2024-04-01 15:02:51 -0400 |
|---|---|---|
| committer | Freya Murphy <freya@freyacat.org> | 2024-04-01 15:02:51 -0400 |
| commit | 9ed46c335d6020b10f720d9738b8252d424dd24c (patch) | |
| tree | fd8751ebf01472d16c6f1bb00797ba921a246d3f /src/db/rest/user/api_avatar.sql | |
| parent | login and register, liking on homepage (diff) | |
| download | xssbook2-9ed46c335d6020b10f720d9738b8252d424dd24c.tar.gz xssbook2-9ed46c335d6020b10f720d9738b8252d424dd24c.tar.bz2 xssbook2-9ed46c335d6020b10f720d9738b8252d424dd24c.zip | |
start custom banner and avatar loading
Diffstat (limited to 'src/db/rest/user/api_avatar.sql')
| -rw-r--r-- | src/db/rest/user/api_avatar.sql | 22 |
1 files changed, 0 insertions, 22 deletions
diff --git a/src/db/rest/user/api_avatar.sql b/src/db/rest/user/api_avatar.sql deleted file mode 100644 index 981409f..0000000 --- a/src/db/rest/user/api_avatar.sql +++ /dev/null @@ -1,22 +0,0 @@ -CREATE FUNCTION api.avatar( - user_id INTEGER DEFAULT 0 -) -RETURNS sys."*/*" -LANGUAGE plpgsql VOLATILE -AS $BODY$ -DECLARE - _mod INTEGER; - _name TEXT; -BEGIN - _mod = MOD(user_id, 24); - _name = 'default_avatar_' || _mod || '.png'; - RETURN _api.serve_media(_name); -END -$BODY$; - -GRANT EXECUTE ON FUNCTION api.avatar(INTEGER) - TO rest_anon, rest_user; -GRANT SELECT ON TABLE admin.user - TO rest_anon, rest_user; -GRANT SELECT ON TABLE admin.media - TO rest_anon, rest_user; |