Index: openacs-4/packages/imsld/www/imsld-finish-resource.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/imsld/www/imsld-finish-resource.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/imsld/www/imsld-finish-resource.xql	1 Feb 2006 11:38:22 -0000	1.1
@@ -0,0 +1,58 @@
+<?xml version="1.0"?>
+<queryset>
+
+
+
+	<fullquery name="get_resource_id">
+		<querytext>
+    select resource_id
+    from imsld_cp_resourcesi
+    where item_id=:resource_item_id
+		</querytext>
+	</fullquery>
+
+
+	<fullquery name="is_feedback">
+		<querytext>
+ select 1  
+                            from acs_rels ar1,
+                                 acs_rels ar2,
+                                 imsld_feedback_rel_ext ifre 
+                            where ifre.rel_id=ar1.rel_id and 
+                                  ar1.object_id_two=ar2.object_id_one and 
+                                  ar2.object_id_two=:resource_item_id 
+    
+		</querytext>
+	</fullquery>
+
+
+	<fullquery name="prerequisites_list">
+		<querytext>
+        select prerequisite_id
+        from imsld_imslds
+    
+		</querytext>
+	</fullquery>
+
+
+	<fullquery name="objectives_list">
+		<querytext>
+        select learning_objective_id
+        from imsld_imslds
+    
+		</querytext>
+	</fullquery>
+
+
+	<fullquery name="get_identifier_resource_id">
+		<querytext>
+            select ar1.object_id_one as identifier 
+            from acs_rels ar1, 
+                 acs_rels ar2 
+            where ar1.object_id_two=ar2.object_id_one 
+                 and ar2.object_id_two=:resource_item_id;
+    
+		</querytext>
+	</fullquery>
+</queryset>
+
Index: openacs-4/packages/imsld/www/index.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/imsld/www/index.tcl,v
diff -u -r1.11 -r1.12
--- openacs-4/packages/imsld/www/index.tcl	12 Dec 2005 15:52:32 -0000	1.11
+++ openacs-4/packages/imsld/www/index.tcl	1 Feb 2006 11:38:22 -0000	1.12
@@ -1,4 +1,4 @@
-ad_page_contract {
+get_manifestsad_page_contract {
 }
 
 set page_title index
Index: openacs-4/packages/imsld/www/index.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/imsld/www/index.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/imsld/www/index.xql	1 Feb 2006 11:38:22 -0000	1.1
@@ -0,0 +1,22 @@
+<?xml version="1.0"?>
+<queryset>
+
+
+
+	<fullquery name="get_manifests">
+		<querytext>
+    select cr3.item_id as imsld_id,
+    coalesce(imsld.title, imsld.identifier) as imsld_title
+    from cr_items cr1, cr_items cr2, cr_items cr3, cr_items cr4,
+    imsld_cp_manifests icm, imsld_cp_organizations ico, imsld_imsldsi imsld 
+    where cr1.live_revision = icm.manifest_id
+    and cr1.parent_id = cr4.item_id
+    and cr4.parent_id = :cr_root_folder_id
+    and ico.manifest_id = cr1.item_id
+    and imsld.organization_id = cr2.item_id
+    and cr2.live_revision = ico.organization_id
+    and cr3.live_revision = imsld.imsld_id
+		</querytext>
+	</fullquery>
+</queryset>
+
Index: openacs-4/packages/imsld/www/admin/imsld-delete-2.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/imsld/www/admin/Attic/imsld-delete-2.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/imsld/www/admin/imsld-delete-2.xql	1 Feb 2006 11:38:23 -0000	1.1
@@ -0,0 +1,16 @@
+<?xml version="1.0"?>
+<queryset>
+
+
+
+	<fullquery name="delete_imsld">
+		<querytext>
+            update cr_items 
+            set live_revision = NULL
+            where item_id = (select item_id from cr_items where live_revision = :imsld_id)
+        
+		</querytext>
+	</fullquery>
+
+</queryset>
+
Index: openacs-4/packages/imsld/www/admin/imsld-delete.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/imsld/www/admin/imsld-delete.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/imsld/www/admin/imsld-delete.xql	1 Feb 2006 11:38:23 -0000	1.1
@@ -0,0 +1,14 @@
+<?xml version="1.0"?>
+<queryset>
+
+
+
+	<fullquery name="get_grade_info">
+		<querytext>
+    select title as imsld_title
+    from imsld_imsldsi
+	where imsld_id = :imsld_id
+		</querytext>
+	</fullquery>
+</queryset>
+
Index: openacs-4/packages/imsld/www/admin/index.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/imsld/www/admin/index.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/imsld/www/admin/index.xql	1 Feb 2006 11:38:23 -0000	1.1
@@ -0,0 +1,23 @@
+<?xml version="1.0"?>
+<queryset>
+
+	<fullquery name="get_imslds">
+		<querytext>
+    select imsld.imsld_id,
+    coalesce(imsld.title, imsld.identifier) as imsld_title,
+    cr3.item_id,
+    cr3.live_revision
+    from cr_items cr1, cr_items cr2, cr_items cr3, cr_items cr4,
+    imsld_cp_manifests icm, imsld_cp_organizations ico, imsld_imsldsi imsld 
+    where cr1.live_revision = icm.manifest_id
+    and cr1.parent_id = cr4.item_id
+    and cr4.parent_id = :cr_root_folder_id
+    and ico.manifest_id = cr1.item_id
+    and imsld.organization_id = cr2.item_id
+    and cr2.live_revision = ico.organization_id
+    and cr3.item_id = imsld.item_id
+
+		</querytext>
+	</fullquery>
+</queryset>
+