Index: openacs-4/packages/acs-subsite/tcl/approval-expiration-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/tcl/Attic/approval-expiration-procs-oracle.xql,v
diff -u -N
--- openacs-4/packages/acs-subsite/tcl/approval-expiration-procs-oracle.xql 28 Aug 2003 09:41:39 -0000 1.2
+++ /dev/null 1 Jan 1970 00:00:00 -0000
@@ -1,20 +0,0 @@
-
-
-
- oracle8.1.6
-
-
-
-
- select u.user_id
- from cc_users u,
- acs_objects relo
- where relo.object_id = u.rel_id
- and last_visit < sysdate - :days
- and relo.last_modified < sysdate - :days
- and u.member_state = 'approved'
-
-
-
-
-
Index: openacs-4/packages/acs-subsite/tcl/approval-expiration-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/tcl/Attic/approval-expiration-procs-postgresql.xql,v
diff -u -N
--- openacs-4/packages/acs-subsite/tcl/approval-expiration-procs-postgresql.xql 28 Aug 2003 09:41:39 -0000 1.2
+++ /dev/null 1 Jan 1970 00:00:00 -0000
@@ -1,22 +0,0 @@
-
-
-
- postgresql7.1
-
-
-
-
- select u.user_id
- from cc_users u,
- acs_objects relo
- where relo.object_id = u.rel_id
- and age(u.last_visit) > interval '$days days'
- and age(relo.last_modified) > interval '$days days'
- and u.member_state = 'approved'
-
-
-
-
-
-
-
Index: openacs-4/packages/acs-subsite/tcl/approval-expiration-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/tcl/approval-expiration-procs.xql,v
diff -u -N
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-subsite/tcl/approval-expiration-procs.xql 20 Nov 2017 13:54:34 -0000 1.1
@@ -0,0 +1,16 @@
+
+
+
+
+
+ select u.user_id
+ from cc_users u,
+ acs_objects relo
+ where relo.object_id = u.rel_id
+ and u.last_visit < current_timestamp - interval :days day
+ and relo.last_modified < current_timestamp - interval :days day
+ and u.member_state = 'approved'
+
+
+
+