Index: openacs-4/packages/assessment/www/admin/view/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/admin/view/Attic/index-postgresql.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/assessment/www/admin/view/index-postgresql.xql	25 Jan 2005 12:38:16 -0000	1.1
@@ -0,0 +1,15 @@
+<?xml version="1.0"?>
+
+<queryset>
+   <rdbms><type>postgresql</type><version>7.1</version></rdbms>
+
+<fullquery name="template_root">      
+      <querytext>
+
+      select content_template__get_root_folder()
+
+      </querytext>
+</fullquery>
+
+ 
+</queryset>
Index: openacs-4/packages/assessment/www/admin/view/index.vuh
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/admin/view/Attic/index.vuh,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/assessment/www/admin/view/index.vuh	25 Jan 2005 12:38:16 -0000	1.1
@@ -0,0 +1,37 @@
+ad_page_contract {
+   
+    @author Unknown
+    @creation-date Unknown
+    @cvs-id $Id: index.vuh,v 1.1 2005/01/25 12:38:16 maltes Exp $
+} {    
+    revision_id:integer,notnull
+}
+
+# Get the paths
+set the_root [ns_info pageroot]
+set package_id [ad_conn package_id]
+
+# Get the IDs
+
+db_1row revision_info { *SQL* } 
+set the_url $name
+set content_root [as::assessment::folder_id -package_id $package_id]
+
+set template_root ""
+
+# Serve the page
+
+if { [content::init the_url the_root $content_root $template_root public $revision_id $content_type] } {
+  set file "$the_root/$the_url"
+  rp_internal_redirect -absolute_path $file
+} else {
+  # ns_returnnotfound
+  set page "[ad_header {Content Item Not Found}]"
+  append page "<h3>Content Item Not Found</h3>"
+  append page "The requested item is not available for viewing.  "
+  append page "The item is either not available on this server or it is not in a publishable state  "
+  append page "Unpublished items can be viewed via the CMS interface if the CMS package is installed.<br>"
+  append page "[ad_footer]"
+  doc_return 200 text/html $page
+}
+
Index: openacs-4/packages/assessment/www/admin/view/index.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/admin/view/Attic/index.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/assessment/www/admin/view/index.xql	25 Jan 2005 12:38:16 -0000	1.1
@@ -0,0 +1,14 @@
+<?xml version="1.0"?>
+
+<queryset>
+
+<fullquery name="revision_info">      
+      <querytext>
+	select cri.content_type, cri.name
+        from cr_items cri, cr_revisions crr
+        where cri.item_id = crr.item_id 
+ 	and crr.revision_id = :revision_id
+      </querytext>
+</fullquery>
+
+</queryset>