summaryrefslogtreecommitdiff
path: root/gentoobrowse/emails
diff options
context:
space:
mode:
authorDan Goodliffe <dan@randomdan.homeip.net>2016-12-21 15:02:57 +0000
committerDan Goodliffe <dan@randomdan.homeip.net>2017-01-16 21:47:53 +0000
commit1f675b4dea063c5272b9b0421dafcb23f55ad959 (patch)
treeb1a483a44bb3a4d319853cffc71865b022c75b2b /gentoobrowse/emails
parentSet cxxflags specifically, not cflags (diff)
downloadgentoobrowse-1f675b4dea063c5272b9b0421dafcb23f55ad959.tar.bz2
gentoobrowse-1f675b4dea063c5272b9b0421dafcb23f55ad959.tar.xz
gentoobrowse-1f675b4dea063c5272b9b0421dafcb23f55ad959.zip
Line in the sand, all basic functionality is working
Diffstat (limited to 'gentoobrowse/emails')
-rw-r--r--gentoobrowse/emails/.htaccess1
-rw-r--r--gentoobrowse/emails/base.xslt69
-rw-r--r--gentoobrowse/emails/newpackageversions.xml37
-rw-r--r--gentoobrowse/emails/newpackageversions.xslt48
-rw-r--r--gentoobrowse/emails/signup.xslt23
-rw-r--r--gentoobrowse/emails/welcome.xml17
6 files changed, 0 insertions, 195 deletions
diff --git a/gentoobrowse/emails/.htaccess b/gentoobrowse/emails/.htaccess
deleted file mode 100644
index e13f618..0000000
--- a/gentoobrowse/emails/.htaccess
+++ /dev/null
@@ -1 +0,0 @@
-Order allow,deny
diff --git a/gentoobrowse/emails/base.xslt b/gentoobrowse/emails/base.xslt
deleted file mode 100644
index a8ceaac..0000000
--- a/gentoobrowse/emails/base.xslt
+++ /dev/null
@@ -1,69 +0,0 @@
-<?xml version="1.0" encoding="UTF-8" ?>
-<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
- xmlns:project2="http://project2.randomdan.homeip.net" exclude-result-prefixes="project2" >
- <xsl:output encoding="utf-8" method="html" media-type="text/html" indent="yes" />
-
- <xsl:template match="/*">
- <xsl:text disable-output-escaping="yes">&lt;!DOCTYPE html&gt;&#10;</xsl:text>
- <html lang="en">
- <head>
- <meta charset="utf-8" />
- <link href="http://gentoobrowse.randomdan.homeip.net/css/bootstrap.min.css" rel="stylesheet" media="screen" />
- <link href="http://gentoobrowse.randomdan.homeip.net/css/bootstrap-responsive.min.css" rel="stylesheet" media="screen" />
- <link href="http://gentoobrowse.randomdan.homeip.net/css/general.css" rel="stylesheet" media="screen" />
- <xsl:call-template name="head" />
- </head>
- <body data-spy="scroll" data-target=".bs-docs-sidebar">
- <!-- nav -->
- <nav class="navbar navbar-inverse navbar-fixed-top">
- <div class="navbar-inner">
- <div class="container">
- <button type="button" class="btn btn-navbar" data-toggle="collapse" data-target=".nav-collapse">
- <span class="icon-bar"></span>
- <span class="icon-bar"></span>
- <span class="icon-bar"></span>
- </button>
- <a class="brand" href="http://gentoobrowse.randomdan.homeip.net/">Gentoo Browse</a>
- <div class="nav-collapse collapse">
- <ul class="nav">
- <li><a href="http://gentoobrowse.randomdan.homeip.net/">Home</a></li>
- <li><a href="http://gentoobrowse.randomdan.homeip.net/categories">Browse</a></li>
- <li><a href="http://gentoobrowse.randomdan.homeip.net/popular">Popular</a></li>
- </ul>
- </div>
- </div>
- </div>
- </nav>
-
- <!-- page content -->
- <header class="jumbotron subhead">
- <div class="container">
- <xsl:call-template name="header" />
- </div>
- </header>
- <div class="container">
- <article class="row">
- <xsl:call-template name="content" />
- </article>
- </div>
-
- <!-- footer -->
- <footer class="footer">
- <div class="container">
- <p>Gentoo Browse is not an official Gentoo website. The name "Gentoo" and the "g" logo are trademarks of the Gentoo Foundation, Inc.</p>
- </div>
- </footer>
-
- <script src="http://code.jquery.com/jquery-latest.js"></script>
- <script src="http://gentoobrowse.randomdan.homeip.net/js/bootstrap.min.js"></script>
- <script src="http://gentoobrowse.randomdan.homeip.net/js/js.js"></script>
- </body>
- </html>
- </xsl:template>
-
- <xsl:template name="head">
- </xsl:template>
-
- <xsl:template name="header">
- </xsl:template>
-</xsl:stylesheet>
diff --git a/gentoobrowse/emails/newpackageversions.xml b/gentoobrowse/emails/newpackageversions.xml
deleted file mode 100644
index 08825e3..0000000
--- a/gentoobrowse/emails/newpackageversions.xml
+++ /dev/null
@@ -1,37 +0,0 @@
-<?xml version="1.0"?>
-<view root="newpackageversions" style="emails/newpackageversions.xslt" xmlns:xi="http://www.w3.org/2001/XInclude"
- xmlns:project2="http://project2.randomdan.homeip.net">
- <project2:sqlrows name="newpackageversions" datasource="postgres">
- <sql>
- select ut.cname, ut.pname, ut.version, ut.description
- from (
- select e.ebuildid, up.userid, u.useremail, p.name as pname, c.name as cname, e.version, p.description
- 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 = <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
- on ebe.userid = ut.userid and ebe.ebuildid = ut.ebuildid
- where ebe.userid is null
- order by ut.cname, ut.pname, ut.version
- </sql>
- </project2:sqlrows>
- <project2:autotree name="newpackageversionsforuser" source="newpackageversions">
- <parameters>
- <userid source="parent" name="userid" depth="1" />
- </parameters>
- <tree rootname="categories" objectname="category">
- <key source="parent" name="cname" />
- <tree rootname="packages" objectname="package">
- <key source="parent" name="pname" />
- <include source="parent" name="description" />
- <tree rootname="versions">
- <key source="parent" name="version" />
- </tree>
- </tree>
- </tree>
- </project2:autotree>
-</view>
-
diff --git a/gentoobrowse/emails/newpackageversions.xslt b/gentoobrowse/emails/newpackageversions.xslt
deleted file mode 100644
index 928edd5..0000000
--- a/gentoobrowse/emails/newpackageversions.xslt
+++ /dev/null
@@ -1,48 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fn="http://exslt.org/strings" xmlns:project2="http://project2.randomdan.homeip.net" version="1.0" exclude-result-prefixes="project2 fn">
- <xsl:import href="base.xslt"/>
- <xsl:output encoding="utf-8" method="html" media-type="text/html" indent="yes"/>
-
- <xsl:template name="header">
- <h2>New versions of packages you're tracking.</h2>
- </xsl:template>
-
- <xsl:template name="content">
- <div class="span3 bs-docs-sidebar">
- <ul class="nav nav-list bs-docs-sidenav">
- <xsl:for-each select="categories/category">
- <li>
- <a>
- <xsl:attribute name="href">#<xsl:value-of select="cname" /></xsl:attribute>
- <i class="icon-chevron-right"></i> <xsl:value-of select="cname" />
- </a>
- </li>
- </xsl:for-each>
- </ul>
- </div>
- <div class="span9">
- <xsl:for-each select="categories//package">
- <section>
- <xsl:if test="count(preceding-sibling::package) = 0">
- <xsl:attribute name="id"><xsl:value-of select="../../cname" /></xsl:attribute>
- </xsl:if>
- <h3>
- <xsl:value-of select="../../cname"/> /
- <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="pname"/>
- </a>
- </h3>
- <p>
- <xsl:value-of select="description"/>
- </p>
- <ul>
- <xsl:for-each select="versions/version">
- <li><xsl:value-of select="../../../../cname"/>/<xsl:value-of select="../../pname"/>-<xsl:value-of select="."/></li>
- </xsl:for-each>
- </ul>
- </section>
- </xsl:for-each>
- </div>
- </xsl:template>
-</xsl:stylesheet>
diff --git a/gentoobrowse/emails/signup.xslt b/gentoobrowse/emails/signup.xslt
deleted file mode 100644
index d0a0823..0000000
--- a/gentoobrowse/emails/signup.xslt
+++ /dev/null
@@ -1,23 +0,0 @@
-<?xml version="1.0" encoding="UTF-8" ?>
-<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
- xmlns:project2="http://project2.randomdan.homeip.net" exclude-result-prefixes="project2" >
- <xsl:output encoding="utf-8" method="html" media-type="text/html" indent="yes"
- doctype-system="http://www.w3.org/TR/html4/loose.dtd"
- doctype-public="-//W3C//DTD HTML 4.01 Transitional//EN" />
- <xsl:template match="/signup">
- <html>
- <head>
- <title>Welcome to Gentoo Browse</title>
- </head>
- <body>
- <p>Welcome to Gentoo Browse!</p>
- <p>
- Click <a><xsl:attribute name="href">http://gentoobrowse.randomdan.homeip.net/confirm?verifyguid=<xsl:value-of select="/signup/verifyguids/verifyguid/guid" />
- </xsl:attribute>this link</a> to confirm your account.
- </p>
- <p>Or alternatively, copy and paste this code into the confirmation page: <xsl:value-of select="/signup/verifyguids/verifyguid/guid" /></p>
- </body>
- </html>
- </xsl:template>
-</xsl:stylesheet>
-
diff --git a/gentoobrowse/emails/welcome.xml b/gentoobrowse/emails/welcome.xml
deleted file mode 100644
index e245a34..0000000
--- a/gentoobrowse/emails/welcome.xml
+++ /dev/null
@@ -1,17 +0,0 @@
-<?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">
- <project2:sqlrows name="verifyguidsbyemail" datasource="postgres-web">
- <sql>
- SELECT userid, CAST(verifyguid AS TEXT) AS guid
- FROM users u
- WHERE useremail = <param name="email" />
- AND verifyguid IS NOT NULL
- </sql>
- </project2:sqlrows>
- <project2:view name="verifyguids" source="verifyguidsbyemail" rootname="verifyguids" recordname="verifyguid">
- <parameters>
- <email source="param" name="email" />
- </parameters>
- </project2:view>
-</view>
generated by cgit v1.2.3 (git 2.25.1) at 2024-11-29 22:03:36 +0000