diff options
| author | randomdan <randomdan@localhost> | 2010-07-01 13:57:53 +0000 |
|---|---|---|
| committer | randomdan <randomdan@localhost> | 2010-07-01 13:57:53 +0000 |
| commit | 3817c65b3e06613191398b5bf02628cb4ea17b6c (patch) | |
| tree | e15c72fbd098d7f69e2ea7d1ab2c78ff73aece05 /gentoobrowse/views | |
| parent | Use cgicc, add checks, tasks, dynamic loader, atom feed, login page (diff) | |
| download | gentoobrowse-3817c65b3e06613191398b5bf02628cb4ea17b6c.tar.bz2 gentoobrowse-3817c65b3e06613191398b5bf02628cb4ea17b6c.tar.xz gentoobrowse-3817c65b3e06613191398b5bf02628cb4ea17b6c.zip | |
Fix monthly roll over bug on new ebuilds
Fix layout problem when cursive font not available
Diffstat (limited to 'gentoobrowse/views')
| -rw-r--r-- | gentoobrowse/views/newebuilds.xml | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/gentoobrowse/views/newebuilds.xml b/gentoobrowse/views/newebuilds.xml index 1f0c5f4..93d7286 100644 --- a/gentoobrowse/views/newebuilds.xml +++ b/gentoobrowse/views/newebuilds.xml @@ -4,7 +4,7 @@ <project2:sqlview name="newebuilds" recordname="ebuild" datasource="postgres"> <sql> SELECT filename, description, moddate, p.name AS pkgname, c.name AS catname, - EXTRACT('day' FROM (SELECT MAX(fm.firstseen) FROM files fm)) - EXTRACT('day' FROM f.firstseen) AS age + EXTRACT('day' FROM ((SELECT MAX(fm.firstseen) FROM files fm) - (f.firstseen - interval '1hour'))) AS age FROM ebuilds e, files f, packages p, categories c WHERE e.ebuildid = f.fileid AND e.packageid = p.packageid |