diff options
author | Yorhel <git@yorhel.nl> | 2009-03-15 12:37:52 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2009-03-15 12:37:52 +0100 |
commit | fc13aa3f69c95c8066f70275a3ea26f9f7911556 (patch) | |
tree | 0d2d7d46433860983b7346c35e6d9dfed51ff11d /lib/Multi | |
parent | c340b5db420144fc8f34d0c7cfb4ded1bdfbb1d4 (diff) |
Let Multi recalculate users.c_tags each month, and some warning fixes
Diffstat (limited to 'lib/Multi')
-rw-r--r-- | lib/Multi/Maintenance.pm | 6 |
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) |); } |