diff options
| author | randomdan <randomdan@localhost> | 2010-12-14 00:20:38 +0000 |
|---|---|---|
| committer | randomdan <randomdan@localhost> | 2010-12-14 00:20:38 +0000 |
| commit | 315ae8de9631c40bd488563d824203d8e6b20d6e (patch) | |
| tree | 5d5035ab9816e4b178dca21538650f8fc67b76aa /gentoobrowse/emails | |
| parent | Switch to XHTML Strict (diff) | |
| download | gentoobrowse-315ae8de9631c40bd488563d824203d8e6b20d6e.tar.bz2 gentoobrowse-315ae8de9631c40bd488563d824203d8e6b20d6e.tar.xz gentoobrowse-315ae8de9631c40bd488563d824203d8e6b20d6e.zip | |
All new fangled iterators, views, row engines, exceptions, the list goes on
Includes site and console updates to match
Diffstat (limited to 'gentoobrowse/emails')
| -rw-r--r-- | gentoobrowse/emails/newpackageversions.xml | 10 | ||||
| -rw-r--r-- | gentoobrowse/emails/newpackageversions.xslt | 5 | ||||
| -rw-r--r-- | gentoobrowse/emails/welcome.xml | 12 |
3 files changed, 17 insertions, 10 deletions
diff --git a/gentoobrowse/emails/newpackageversions.xml b/gentoobrowse/emails/newpackageversions.xml index f65a2de..45bba93 100644 --- a/gentoobrowse/emails/newpackageversions.xml +++ b/gentoobrowse/emails/newpackageversions.xml @@ -2,7 +2,7 @@ <view root="newpackageversions" style="emails/newpackageversions.xslt" xmlns:xi="http://www.w3.org/2001/XInclude" xmlns:project2="http://project2.randomdan.homeip.net"> <xi:include href="../datasources/postgres.xml" /> - <project2:sqlview name="newpackageversions" recordname="version" datasource="postgres"> + <project2:sqlrows name="newpackageversions" datasource="postgres"> <sql> select ut.cname, ut.pname, ut.version from ( @@ -10,7 +10,7 @@ from ebuilds e, user_packages up, users u, packages p, categories c where e.packageid = up.packageid and u.userid = up.userid - and u.userid = ? + and u.userid = <param name="userid" /> and e.packageid = p.packageid and c.categoryid = p.categoryid and e.firstseen > up.trackedsince) as ut left outer join user_ebuild_emails ebe @@ -18,9 +18,11 @@ where ebe.userid is null order by ut.cname, ut.pname, ut.version </sql> + </project2:sqlrows> + <project2:view name="newpackageversionsforuser" source="newpackageversions" rootname="newpackageversions" recordname="version"> <parameters> - <param bind="0" value="^userid" /> + <param name="userid" value="^^userid" /> </parameters> - </project2:sqlview> + </project2:view> </view> diff --git a/gentoobrowse/emails/newpackageversions.xslt b/gentoobrowse/emails/newpackageversions.xslt index 67301db..e5e23be 100644 --- a/gentoobrowse/emails/newpackageversions.xslt +++ b/gentoobrowse/emails/newpackageversions.xslt @@ -14,7 +14,10 @@ <ul> <xsl:for-each select="newpackageversions/version"> <li> - <xsl:value-of select="cname"/>/<xsl:value-of select="pname"/>-<xsl:value-of select="version"/> + <a> + <xsl:attribute name="href">http://gentoobrowse.randomdan.homeip.net/package/<xsl:value-of select="cname"/>/<xsl:value-of select="pname"/></xsl:attribute> + <xsl:value-of select="cname"/>/<xsl:value-of select="pname"/>-<xsl:value-of select="version"/> + </a> </li> </xsl:for-each> </ul> diff --git a/gentoobrowse/emails/welcome.xml b/gentoobrowse/emails/welcome.xml index 09d2c3d..ad48f66 100644 --- a/gentoobrowse/emails/welcome.xml +++ b/gentoobrowse/emails/welcome.xml @@ -1,16 +1,18 @@ <?xml version="1.0"?> <view root="signup" style="emails/signup.xslt" xmlns:xi="http://www.w3.org/2001/XInclude" xmlns:project2="http://project2.randomdan.homeip.net"> - <xi:include href="../datasources/postgres.xml" /> - <project2:sqlview name="verifyguids" recordname="verifyguid" datasource="postgres"> + <xi:include href="../datasources/postgres-web.xml" /> + <project2:sqlrows name="verifyguidsbyemail" datasource="postgres-web"> <sql> SELECT userid, CAST(verifyguid AS TEXT) AS guid FROM users u - WHERE useremail = ? + WHERE useremail = <param name="email" /> AND verifyguid IS NOT NULL </sql> + </project2:sqlrows> + <project2:view name="verifyguids" source="verifyguidsbyemail" rootname="verifyguids" recordname="verifyguid"> <parameters> - <param bind="0" value="$email" /> + <param name="email" value="$email" /> </parameters> - </project2:sqlview> + </project2:view> </view> |