diff options
| author | randomdan <randomdan@localhost> | 2010-08-13 01:16:02 +0000 |
|---|---|---|
| committer | randomdan <randomdan@localhost> | 2010-08-13 01:16:02 +0000 |
| commit | d3b1f6043992052d87c0d1fd04fff3c376b74329 (patch) | |
| tree | db9703bfde7f03b0466352a5165024c8097c84c9 /gentoobrowse/views | |
| parent | Bind merge populators recursively to leafs (diff) | |
| download | gentoobrowse-d3b1f6043992052d87c0d1fd04fff3c376b74329.tar.bz2 gentoobrowse-d3b1f6043992052d87c0d1fd04fff3c376b74329.tar.xz gentoobrowse-d3b1f6043992052d87c0d1fd04fff3c376b74329.zip | |
Import and deal with the existance of changelogs
Diffstat (limited to 'gentoobrowse/views')
| -rw-r--r-- | gentoobrowse/views/newebuilds.xml | 13 | ||||
| -rw-r--r-- | gentoobrowse/views/newebuildsatom.xml | 1 |
2 files changed, 12 insertions, 2 deletions
diff --git a/gentoobrowse/views/newebuilds.xml b/gentoobrowse/views/newebuilds.xml index a95fa3c..8f1b544 100644 --- a/gentoobrowse/views/newebuilds.xml +++ b/gentoobrowse/views/newebuilds.xml @@ -11,7 +11,12 @@ WHERE e.ebuildid = f.fileid AND e.packageid = p.packageid AND p.categoryid = c.categoryid - AND f.firstseen IN (SELECT DISTINCT f.firstseen FROM files f ORDER BY f.firstseen DESC LIMIT 3) + AND f.firstseen IN ( + SELECT DISTINCT f.firstseen + FROM files f + WHERE f.filetypeid = 1 + ORDER BY f.firstseen + DESC LIMIT 3) ORDER BY tracked DESC, c.name, p.name, e.versioninst </sql> <parameters> @@ -20,7 +25,11 @@ </project2:sqlview> <project2:sqlview name="syncs" recordname="sync" datasource="postgres"> <sql> - SELECT DISTINCT f.firstseen AS synctime FROM files f ORDER BY f.firstseen DESC LIMIT 3 + SELECT DISTINCT f.firstseen AS synctime + FROM files f + WHERE filetypeid = 1 + ORDER BY f.firstseen + DESC LIMIT 3 </sql> </project2:sqlview> </block> diff --git a/gentoobrowse/views/newebuildsatom.xml b/gentoobrowse/views/newebuildsatom.xml index fba9e2b..93ae207 100644 --- a/gentoobrowse/views/newebuildsatom.xml +++ b/gentoobrowse/views/newebuildsatom.xml @@ -12,6 +12,7 @@ AND u.username = ? AND up.packageid = p.packageid AND f.firstseen >= up.trackedsince + AND f.filetypeid = 1 ORDER BY f.firstseen DESC, c.name, p.name, e.versioninst LIMIT 50 </sql> |