diff options
author | Yorhel <git@yorhel.nl> | 2011-04-03 16:56:59 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2011-04-03 16:56:59 +0200 |
commit | bdc8abf02ecff773382932c3ca5a8e21c3ec5901 (patch) | |
tree | 4f64985cb6d296cd83341cde51819c99a7ed043d | |
parent | c5a937285d8601dad81cb20fb7c17138fa446ef3 (diff) |
Bugfix: use the 'vnlists' table to calculate stats on user page
-rw-r--r-- | ChangeLog | 8 | ||||
-rw-r--r-- | lib/VNDB/DB/Users.pm | 2 |
2 files changed, 9 insertions, 1 deletions
@@ -1,3 +1,11 @@ +2.20 - ? + - Bugfix: don't accidentally remove char traits when editing + - Bugfix: fixed possible SQL table name clash on history browser + - Bugfix: properly announce chars and traits in Multi::IRC + - Bugfix: display more than 10 characters on VN page + - Bugfix: removed Perl warning in Handler::Chars + - Bugfix: use the 'vnlists' table to calculate stats on user page + 2.19 - 2011-03-30 - Character database: - New DB item (versioned): character, page: /c+ diff --git a/lib/VNDB/DB/Users.pm b/lib/VNDB/DB/Users.pm index 36ae02af..17f360cc 100644 --- a/lib/VNDB/DB/Users.pm +++ b/lib/VNDB/DB/Users.pm @@ -63,7 +63,7 @@ sub dbUserGet { '(SELECT COUNT(*) FROM notifications WHERE uid = u.id AND read IS NULL) AS notifycount' : (), $o{what} =~ /stats/ ? ( '(SELECT COUNT(*) FROM rlists WHERE uid = u.id) AS releasecount', - '(SELECT COUNT(DISTINCT rv.vid) FROM rlists rl JOIN releases r ON rl.rid = r.id JOIN releases_vn rv ON rv.rid = r.latest WHERE uid = u.id) AS vncount', + '(SELECT COUNT(*) FROM vnlists WHERE uid = u.id) AS vncount', '(SELECT COUNT(*) FROM threads_posts WHERE uid = u.id) AS postcount', '(SELECT COUNT(*) FROM threads_posts WHERE uid = u.id AND num = 1) AS threadcount', '(SELECT COUNT(DISTINCT tag) FROM tags_vn WHERE uid = u.id) AS tagcount', |