diff options
Diffstat (limited to 'sql/func.sql')
| -rw-r--r-- | sql/func.sql | 4 |
1 files changed, 0 insertions, 4 deletions
diff --git a/sql/func.sql b/sql/func.sql index 673ee4f7..cb120744 100644 --- a/sql/func.sql +++ b/sql/func.sql @@ -298,7 +298,6 @@ $$ LANGUAGE plpgsql SECURITY DEFINER; -- Fully recalculate all rows in stats_cache CREATE OR REPLACE FUNCTION update_stats_cache_full() RETURNS void AS $$ BEGIN - UPDATE stats_cache SET count = (SELECT COUNT(*) FROM users)-1 WHERE section = 'users'; UPDATE stats_cache SET count = (SELECT COUNT(*) FROM vn WHERE hidden = FALSE) WHERE section = 'vn'; UPDATE stats_cache SET count = (SELECT COUNT(*) FROM releases WHERE hidden = FALSE) WHERE section = 'releases'; UPDATE stats_cache SET count = (SELECT COUNT(*) FROM producers WHERE hidden = FALSE) WHERE section = 'producers'; @@ -306,9 +305,6 @@ BEGIN UPDATE stats_cache SET count = (SELECT COUNT(*) FROM staff WHERE hidden = FALSE) WHERE section = 'staff'; UPDATE stats_cache SET count = (SELECT COUNT(*) FROM tags WHERE state = 2) WHERE section = 'tags'; UPDATE stats_cache SET count = (SELECT COUNT(*) FROM traits WHERE state = 2) WHERE section = 'traits'; - UPDATE stats_cache SET count = (SELECT COUNT(*) FROM threads WHERE hidden = FALSE) WHERE section = 'threads'; - UPDATE stats_cache SET count = (SELECT COUNT(*) FROM threads_posts WHERE hidden = FALSE - AND EXISTS(SELECT 1 FROM threads WHERE threads.id = tid AND threads.hidden = FALSE)) WHERE section = 'threads_posts'; END; $$ LANGUAGE plpgsql; |