Index: openacs-4/packages/download/www/index-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/download/www/index-oracle.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/download/www/index-oracle.xql	16 May 2001 02:22:16 -0000	1.3
+++ openacs-4/packages/download/www/index-oracle.xql	16 May 2001 09:41:05 -0000	1.4
@@ -32,7 +32,7 @@
        dar.revision_id,
        dar.file_name,
        dar.version_name,
-       dbms_lob.getlength(dar.content) as file_size,       
+       round(dbms_lob.getlength(dar.content)/1024) as file_size,       
        (select count(*) from download_downloads where revision_id = dar.revision_id) as downloads,
        dar.approved_p 
        $metadata_selects
@@ -57,12 +57,28 @@
       </querytext>
 </partialquery>
 
-<partialquery name="date_clause">      
+<partialquery name="date_clause_1">
       <querytext>
 
-   sysdate
+	dar.publish_date + 1 > sysdate
 
       </querytext>
 </partialquery>
+ 
+<partialquery name="date_clause_7">
+      <querytext>
 
+	dar.publish_date + 7 > sysdate
+
+      </querytext>
+</partialquery>
+
+<partialquery name="date_clause_30">
+      <querytext>
+
+	dar.publish_date + 30 > sysdate
+
+      </querytext>
+</partialquery>
+
 </queryset>