summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorrandomdan <randomdan@localhost>2010-07-01 13:57:53 +0000
committerrandomdan <randomdan@localhost>2010-07-01 13:57:53 +0000
commit3817c65b3e06613191398b5bf02628cb4ea17b6c (patch)
treee15c72fbd098d7f69e2ea7d1ab2c78ff73aece05
parentUse cgicc, add checks, tasks, dynamic loader, atom feed, login page (diff)
downloadgentoobrowse-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
-rw-r--r--gentoobrowse/style.css3
-rw-r--r--gentoobrowse/views/newebuilds.xml2
2 files changed, 3 insertions, 2 deletions
diff --git a/gentoobrowse/style.css b/gentoobrowse/style.css
index efa2810..9e85628 100644
--- a/gentoobrowse/style.css
+++ b/gentoobrowse/style.css
@@ -1,6 +1,6 @@
html {
background: white url('/images/glogo-small.png') no-repeat 10px 5px;
- font-family: cursive;
+ font-family: cursive, sans-serif;
}
body {
font-size: 11px;
@@ -11,6 +11,7 @@ h1 {
font-size: 45px;
margin: 20px 160px 5px;
border-bottom: 1px solid black;
+ height: 66px;
}
.tabs {
font-size: 15px;
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