select 1 from acs_objects where creation_user = :user_id and object_id = :object_id select count(user_id) from dotlrn_member_rels_full where user_id = :user_id and ( role = 'admin' or role = 'instructor' ) $extra_query select res_id from ims_cp_items_to_resources where ims_item_id = :ims_item_id select ims_item_id from ims_cp_items_to_resources where res_id = :res_id select item_id from cr_items where name = :name and parent_id = :root_folder select item_id from cr_items where parent_id = :folder and name = :subfolder_name select item_id from cr_items where name = :url_name and parent_id = :sub_folder_id select r.man_id from ims_cp_resources r, ims_cp_items_to_resources ir where ir.res_id = r.res_id and ir.ims_item_id = :ims_item_id update ims_cp_items set sort_order = :sort_order where ims_item_id = :ims_item_id select distinct sort_order from ims_cp_items where ims_item_id in ( select revision_id from cr_revisions where item_id = ( select item_id from cr_revisions where revision_id = :ims_item_id ) ) and sort_order is not null select org_id from ims_cp_organizations where man_id = :man_id select ims_item_id from ims_cp_items where org_id = :org_id and ims_item_id in ( select live_revision from cr_items ) insert into ims_cp_items_map (man_id,org_id,community_id,ims_item_id) values (:man_id,:org_id,:community_id,:ims_item_id) update ims_cp_items_map set ims_item_id = :new_ims_item_id where man_id = :man_id and community_id = :community_id and ims_item_id in ( select revision_id from cr_revisions where item_id = :item_id ) select item_id from cr_items where parent_id = :parent_id and name = :folder_name select name from cr_items where item_id = :item_id select name from cr_items where parent_id = :parent_id and name = :name select count(item_id) from cr_items where parent_id = :parent_id select count(revision_id) from cr_revisions where item_id = :item_id select folder_id from cr_folders where label = 'LORSM Root Folder' select folder_id from cr_folders where label = 'LORSM Organizations Folder' select folder_id from cr_folders where label = 'LORSM Resources Folder' select folder_id from cr_folders where label = 'LORSM Manifest Folder' select folder_id from cr_folders where label = 'LORSM Items Folder' select parent_id from cr_items where item_id = :item_id select pretty_name from dotlrn_class_instances_full where community_id = :community_id select res_id from ims_cp_items_to_resources where ims_item_id = :ims_item_id select res_id from ims_cp_items_to_resources where ims_item_id = :ims_item_id select href from ims_cp_resources where res_id = :res_id select file_id from ims_cp_files f, ims_cp_resources r where r.res_id=:res_id and f.res_id=r.res_id and f.pathtofile=r.href select name from cr_items where item_id = ( select item_id from cr_revisions where revision_id = :ims_item_id ) select file_id from ims_cp_files where res_id = :res_id and pathtofile = :href select item_id from cr_items where name = :name and parent_id = :root_folder select course_name from ims_cp_manifests where man_id =:man_id select label from cr_folders where folder_id = :folder_id select 1 from ims_cp_manifest_class where community_id = :community_id and man_id in ( select revision_id from cr_revisions where item_id = :item_id ) select count(community_id) from ims_cp_manifest_class where man_id = :man_id select 1 from ims_cp_manifest_class where man_id = :man_id delete from ims_cp_manifest_class where community_id = :community_id and man_id in ( select revision_id from cr_revisions where item_id = :item_id ) select 1 from ims_cp_manifest_class where community_id = :community_id and man_id =:man_id update ims_cp_manifest_class set lorsm_instance_id = :lorsm_instance_id, community_id = :community_id where man_id = :man_id insert into ims_cp_manifest_class (man_id, lorsm_instance_id, community_id, isenabled, istrackable) values (:man_id, :lorsm_instance_id, :community_id, 't', 'f') select item_id from cr_revisions where revision_id = :revision_id select count(revision_id) from cr_revisions where item_id = :item_id select revision_id from cr_revisions where item_id = :item_id order by revision_id asc select distinct man_id from ims_cp_manifest_class where community_id = :community_id and man_id in ( select revision_id from cr_revisions where item_id = :item_id ) select revision_id from cr_revisions where item_id = :item_id order by revision_id asc update ims_cp_manifest_class set man_id = :man_id where community_id = :community_id and man_id in ( select revision_id from cr_revisions where item_id = :item_id ) select dca.package_id from dotlrn_community_applets dca,apm_packages ap where community_id=:community_id and ap.package_id=dca.package_id and ap.package_key='lorsm' select first_names || ' ' || last_name from cc_users where user_id = :user_id select count(man_id) from ims_cp_manifest_class where man_id = :man_id and community_id is not null select 1 from acs_permissions where object_id = :item_id and grantee_id = :user_id and privilege = 'admin' select icmc.community_id as com_id, icmc.lorsm_instance_id as lors_ins_id, icmc.isenabled as ie, icmc.istrackable as it from ims_cp_manifest_class icmc where icmc.man_id in ( select revision_id from cr_revisions where item_id = :item_id ) update ims_cp_manifest_class set man_id = :man_id, lorsm_instance_id = :lors_ins_id, isenabled = :ie, istrackable = :it where community_id = :com_id and man_id in ( select revision_id from cr_revisions where item_id = :item_id ) select person__name(o.creation_user) as owner, i.name as title, r.title as name, r.description as version_notes, acs_permission__permission_p(:file_id,:user_id,'write') as write_p, acs_permission__permission_p(:file_id,:user_id,'delete') as delete_p, acs_permission__permission_p(:file_id,:user_id,'admin') as admin_p, content_item__get_path(o.object_id, :root_folder_id) as file_url, i.live_revision, i.storage_type, i.storage_area_key, r.mime_type from acs_objects o, cr_revisions r, cr_items i where o.object_id = :file_item_id and i.item_id = o.object_id and r.revision_id = :revision_id select content_revision__get_content(:revision_id) select res_id from ims_cp_items_to_resources where ims_item_id = :ims_item_id select 1 from ims_cp_files where file_id = :clipboard_object_id and res_id = :ims_res_id select distinct filename from ims_cp_files where file_id = :new_file_id select distinct pathtofile from ims_cp_files where file_id = :new_file_id select res_id from ims_cp_items_to_resources where ims_item_id = :ims_item_id select parent_item from ims_cp_items where ims_item_id = :ims_item_id select folder_id from cr_folders where label = 'LORSM Root Folder' select ims_item_id from ims_cp_items where parent_item = :item_id and org_id = :org_id select ims_item_id from ims_cp_items where parent_item = :org_id and org_id = :org_id select count(ims_item_id) from ims_cp_items where ims_item_id in ( select live_revision from cr_items where content_type = 'ims_item_object' ) and org_id = :org_id select folder_id from cr_folders where label = :name