diff options
author | Yorhel <git@yorhel.nl> | 2009-01-10 10:27:33 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2009-01-10 10:27:33 +0100 |
commit | 49814b83b322adea8b2c385dfbb8300c0e2a2ebc (patch) | |
tree | ab5b8bd773620e8135014a3f9c5c76d95d4485b3 /lib/VNDB/DB/VN.pm | |
parent | 9663376cd572b6f94c83f9a580c25fbd2bdc67f2 (diff) |
Added VN popularity ranking
The following query should be run periodically to update the rankings:
SELECT update_vnpopularity();
I'll fix Multi::Maintenance to do this automatically.
Diffstat (limited to 'lib/VNDB/DB/VN.pm')
-rw-r--r-- | lib/VNDB/DB/VN.pm | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/VNDB/DB/VN.pm b/lib/VNDB/DB/VN.pm index df2e0a03..6e6686c0 100644 --- a/lib/VNDB/DB/VN.pm +++ b/lib/VNDB/DB/VN.pm @@ -87,7 +87,7 @@ sub dbVNGet { ); my @select = ( - qw|v.id v.locked v.hidden v.c_released v.c_languages v.c_platforms vr.title vr.original v.rgraph|, 'vr.id AS cid', + qw|v.id v.locked v.hidden v.c_released v.c_languages v.c_platforms vr.title vr.original v.rgraph v.c_popularity|, 'vr.id AS cid', $o{what} =~ /extended/ ? ( qw|vr.alias vr.image vr.img_nsfw vr.length vr.desc vr.l_wp vr.l_encubed vr.l_renai vr.l_vnn| ) : (), $o{what} =~ /changes/ ? ( |