diff options
| author | Yorhel <git@yorhel.nl> | 2010-11-02 17:13:26 +0100 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2010-11-02 17:13:26 +0100 |
| commit | 4d42eb7cddfbf578577295c407b08beb8161af1f (patch) | |
| tree | 99972fd748cd069a2d074d46f41ad4e82f84a518 /lib/VNDB/DB/VN.pm | |
| parent | ce23a80fa7332c9b17682044a58b9dd06a9c2bdc (diff) | |
Multi::Image: Abstracted image dimension calculation into VNDBUtil
Which may also be useful for other scripts.
Diffstat (limited to 'lib/VNDB/DB/VN.pm')
| -rw-r--r-- | lib/VNDB/DB/VN.pm | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/lib/VNDB/DB/VN.pm b/lib/VNDB/DB/VN.pm index da479a9a..394e8c06 100644 --- a/lib/VNDB/DB/VN.pm +++ b/lib/VNDB/DB/VN.pm @@ -205,10 +205,11 @@ sub dbScreenshotGet { # Fetch random VN + screenshots sub dbScreenshotRandom { return shift->dbAll(q| - SELECT vs.scr, vr.vid, vr.title + SELECT vs.scr, vr.vid, vr.title, s.width, s.height FROM vn_screenshots vs JOIN vn v ON v.latest = vs.vid JOIN vn_rev vr ON vr.id = v.latest + JOIN screenshots s ON vs.scr = s.id WHERE vs.nsfw = FALSE AND v.hidden = FALSE ORDER BY RANDOM() LIMIT 4| |