Index: openacs-4/packages/acs-subsite/www/pvt/alerts.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/pvt/Attic/alerts.xql,v
diff -u -N -r1.2 -r1.3
--- openacs-4/packages/acs-subsite/www/pvt/alerts.xql 15 May 2001 16:59:01 -0000 1.2
+++ openacs-4/packages/acs-subsite/www/pvt/alerts.xql 20 Nov 2017 13:38:49 -0000 1.3
@@ -7,5 +7,34 @@
+
+
+
+ select bea.valid_p, bea.frequency, bea.keywords, bt.topic, bea.oid as rowid
+ from bboard_email_alerts bea, bboard_topics bt
+ where bea.user_id = :user_id
+ and bea.topic_id = bt.topic_id
+ order by bea.frequency
+
+
+
+
+
+ select cea.valid_p,
+ ad.domain,
+ cea.alert_id,
+ cea.expires,
+ cea.frequency,
+ cea.alert_type,
+ cea.category,
+ cea.keywords
+ from classified_email_alerts cea, ad_domains ad
+ where user_id = :user_id
+ and ad.domain_id = cea.domain_id
+ and current_timestamp <= expires
+ order by expires desc
+
+
+