summaryrefslogtreecommitdiff
path: root/lib/Multi/Maintenance.pm
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2009-03-15 12:37:52 +0100
committerYorhel <git@yorhel.nl>2009-03-15 12:37:52 +0100
commitfc13aa3f69c95c8066f70275a3ea26f9f7911556 (patch)
tree0d2d7d46433860983b7346c35e6d9dfed51ff11d /lib/Multi/Maintenance.pm
parentc340b5db420144fc8f34d0c7cfb4ded1bdfbb1d4 (diff)
Let Multi recalculate users.c_tags each month, and some warning fixes
Diffstat (limited to 'lib/Multi/Maintenance.pm')
-rw-r--r--lib/Multi/Maintenance.pm6
1 files changed, 6 insertions, 0 deletions
diff --git a/lib/Multi/Maintenance.pm b/lib/Multi/Maintenance.pm
index 10f02681..51c6cec8 100644
--- a/lib/Multi/Maintenance.pm
+++ b/lib/Multi/Maintenance.pm
@@ -66,6 +66,12 @@ sub usercache {
FROM changes
WHERE requester = users.id
GROUP BY requester
+ ), 0),
+ c_tags = COALESCE(
+ (SELECT COUNT(tag)
+ FROM tags_vn
+ WHERE uid = users.id
+ GROUP BY uid
), 0)
|);
}