Index: openacs-4/packages/imsld/catalog/imsld.en_US.ISO-8859-1.xml
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/imsld/catalog/imsld.en_US.ISO-8859-1.xml,v
diff -u -r1.11 -r1.12
--- openacs-4/packages/imsld/catalog/imsld.en_US.ISO-8859-1.xml 13 Dec 2005 17:35:23 -0000 1.11
+++ openacs-4/packages/imsld/catalog/imsld.en_US.ISO-8859-1.xml 1 Feb 2006 12:31:32 -0000 1.12
@@ -5,20 +5,28 @@
Act Identifier
Activity Structures
Acts in play %count%
+ Caluclate Identifier
+ Calulate Identifier
Class
+ Complete Act
+ Complete Acts
Component Identifier
Conference Type
Confirm: New IMS-LD
Create New?
Creating new IMS-LD...
+ Data Type
+ Else Identifier
Error parsing file
+ Existing href
Feedbach Title
File name
finished
Href
Identifier
Identifier Reference
Identifierref
+ If Identifier
IMD-LD Environment
IMD-LD Environments
IMD LD Level
@@ -28,14 +36,19 @@
IMS-LD Acts
IMS-LD Component
IMS-LD Components
+ IMS-LD Condition
+ IMS-LD Conditions
IMS-LD CP Dependency
IMS-LD CP File
IMS-LD CP Filed
IMS-LD CP Manifest
IMS-LD CP Manifests
IMS-LD CP Resource
IMS-LD CP Resources
+ IMS-LD Expression
+ IMS-LD Expressions
IMS-LD Identifier
+ IMS-LD Intifier
IMS-LD Item
IMS-LD Items
IMS-LD Method
@@ -47,20 +60,28 @@
IMS-LD Plays
IMS-LD Prerequisite
IMS-LD Prerequisites
+ IMS-LD Properties
+ IMS-LD Property
+ IMS-LD Restriction
+ IMS-LD Restrictions
IMS-LD Role
IMS-LD Role Part
IMS-LD Role Parts
IMS-LD Roles
IMS-LD Sendmail Data
IMS-LD Service
IMS-LD Services
+ IMS-LD Then Model
+ IMS-LD Then Models
IMS-LD Time Limit
IMS-LD Time Limits
IMS-LD ZIP File
IMS-LDs
+ Initial Value
Is shared?
Is Visible?
Item Identifier
+ Langstring
Learners Roles
Learning Activities
Learning Object
@@ -72,12 +93,18 @@
Activity Description Identifier
Activity Structure Identifier
<br /> Warnings: <ul> %warnings% </ul>
+ Change Property Value Identifier
+ Complete Act Identifier
Could not determine whit what program uncompress the file %upload_file% has. Aborting
Couldn't determine if this is a well formed IMS-LD: %message%
Creaginting new IMS-LD
+ Email Propery Identifier
Environment Identifier
Error creating folder
Error parsing manifest.
+ Expression Identifier
+ Expression One Identifier
+ Expression Two Identifer
IMS-LD Activity Description
IMS-LD Activity Descriptions
IMS-LD Activity Structure
@@ -87,15 +114,24 @@
IMS-LD CP Dependencies
IMS-LD CP Organization
IMS-LD CP Organizations
+ IMS-LD Item Identifier
IMS-LD Learning Activity
IMS-LD Learning Activities
IMS-LD Learning Objective
IMS-LD Learning Objectives
+ IMS-LD Monitor Service
+ IMS-LD Monitor Services
IMS-LD On Completions
+ IMS-LD Property Group
+ IMS-LD Property Groups
+ IMS-LD Property Value
+ IMS-LD Property Values
IMS-LD Sendmail Service
IMS-LD Sendmail Services
IMS-LD Support Activity
IMS-LD Support Activities
+ IMS-LD When Condition True
+ IMS-LD When Conditions True
Index search service not supported
Information given but no item associated to it for the role %role_title%
Information given but no item associated to it for the activity structure %identifier%
@@ -104,11 +140,14 @@
Learning Object Identifier
Learning Objective ID
Learning Objectives ID
+ Learning Unit finished
<li> desc (no file associated) </li>
More than one validation tried at the same time
No imsmanifest.xml found
No imsmanifest.xml was found in the compressed file. Aborting.
No information found in the manifest file
+ No parent folder found
+ No parent folder found for the ims-ld in the community %community_id%. Please report this error to the administrator.
Number of Organizations:
On Completion Identifier
Organization Identifier
@@ -146,26 +185,37 @@
The resource %resource_identifier% has a reference to a non existing file (%resource_href%).
There can't be less than %multiplicity% %element_name% and there are %tree_length%. This is not supported, sorry.
There can't greather than %multiplicity% %element_name% and there are %tree_length%. This is not supported, sorry.
+ There is no property-group with the identifier %ref% (referenced by property-group %identifier%)
+ There is no property with the identifier %ref% (referenced by: property group %identifier%)
+ There is no property with the identifier %email_property_ref% (referenced from an email data)
+ There is no property with the identifier %username_property_ref% (referenced from an email data)
+ There is no property with the identifier %ref% (referenced by: property value
There is no role with the identifier %role_ref% (referenced by an email data)
There is no role with the identifier %role_ref% (referenced by: manager)
There is no role with the identifier %role_ref% (referenced by: participant)
There is no role with the identifier %role_ref% (referenced by: observer)
There is no role with the identifier %role_ref% (referenced by: moderator)
There is no role with the identifier %ref% (referenced by: support activity)
+ There is no role with the identifier %ref% (referenced by: locrole property)
+ There is no role with the identifier %ref% (referenced from a monitor service)
+ There is no role with the identifier %role_ref% (referenced from within an expression)
There must be exactly %multiplicity% %element_name% and there are %tree_length%. This is not supported, sorry.
There was an error creating the folder. Aborting.
There was an error creating the tmp_dir to unzip the file.
There was an error generating the tmp_dir to unzip the file.
There was an error parsing the manifest. Please correct it and try again. <br /><code>%errmsg%</code>
There was an error trying to delete the dir %dir%.
Time Limit Identifier
+ Time Property Identifier
<ul> Completed Activities <br />
<ul> %first_or_next% Activity: %activity_name%
Uploading and processing your course, please wait...
+ Username Property Identifier
Valid types are learning, support and structure
More than one learning object in environment %identifier%. Just one used (the first one)
We will continue automatically when processing is complete.
When Last Act Completed?
+ When Property Value is Set Identifier
Mail Data
Manager Identifier
Manifest Identifier
@@ -185,10 +235,16 @@
Play Identifier
Prerequistes ID
Pretty Title
+ Property Identifier
+ Property Value Ref.
Recipients
+ Reference Identifier
+ Reference Type
Resource Identifier
+ Restriction Type
Role Identifier
Role Type
+ Self
Sendmail Identifier
Sequence Used
Service Identifier
@@ -198,6 +254,7 @@
Staff Roels
Structure Type
Support Activities
+ Then Identifier
Time in Seconds
Total Activities
Total Roles
@@ -207,7 +264,11 @@
Learning Units
Units of Learning Administration
Uploading IMS LD
+ URI
User Choice?
Value
Version
+ When Condition True
+ With Control
+ XML Piece
Index: openacs-4/packages/imsld/tcl/imsld-cr-procs.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/imsld/tcl/imsld-cr-procs.tcl,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/imsld/tcl/imsld-cr-procs.tcl 9 Dec 2005 12:01:31 -0000 1.4
+++ openacs-4/packages/imsld/tcl/imsld-cr-procs.tcl 1 Feb 2006 12:31:32 -0000 1.5
@@ -137,7 +137,7 @@
set folder_id [content::item::get_id -item_path "imsld_root_cr_folder_${community_id}" -resolve_index f]
if { [string eq "" $folder_id] } {
- ad_return_error "<#_ No parent folder found #>" "<#_ No parent folder found for the ims-ld in the community %community_id%. Please report this error to the administrator. #>"
+ ad_return_error "[_ imsld.lt_No_parent_folder_foun]" "[_ imsld.lt_No_parent_folder_foun_1]"
ad_script_abort
}
return $folder_id
Index: openacs-4/packages/imsld/tcl/imsld-install-procs.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/imsld/tcl/imsld-install-procs.tcl,v
diff -u -r1.15 -r1.16
--- openacs-4/packages/imsld/tcl/imsld-install-procs.tcl 30 Jan 2006 19:31:05 -0000 1.15
+++ openacs-4/packages/imsld/tcl/imsld-install-procs.tcl 1 Feb 2006 12:31:32 -0000 1.16
@@ -88,12 +88,12 @@
content::type::attribute::new -content_type imsld_learning_activity -attribute_name component_id -datatype number -pretty_name "#imsld.Component_Identifier#" -column_spec "integer"
content::type::attribute::new -content_type imsld_learning_activity -attribute_name activity_description_id -datatype number -pretty_name "#imsld.lt_Activity_Description_#" -column_spec "integer"
content::type::attribute::new -content_type imsld_learning_activity -attribute_name is_visible_p -datatype string -pretty_name "#imsld.Is_Visible#" -column_spec "char(1)"
- content::type::attribute::new -content_type imsld_learning_activity -attribute_name complete_act_id -datatype number -pretty_name "<#_ Complete Act Identifier #>" -column_spec "integer"
+ content::type::attribute::new -content_type imsld_learning_activity -attribute_name complete_act_id -datatype number -pretty_name "#imsld.lt_Complete_Act_Identifi#" -column_spec "integer"
content::type::attribute::new -content_type imsld_learning_activity -attribute_name on_completion_id -datatype number -pretty_name "#imsld.lt_On_Completion_Identif#" -column_spec "integer"
content::type::attribute::new -content_type imsld_learning_activity -attribute_name parameters -datatype string -pretty_name "#imsld.Parameters#" -column_spec "varchar(4000)"
content::type::attribute::new -content_type imsld_learning_activity -attribute_name learning_objective_id -datatype number -pretty_name "#imsld.lt_Learning_Objective_ID#" -column_spec "integer"
content::type::attribute::new -content_type imsld_learning_activity -attribute_name prerequisite_id -datatype number -pretty_name "#imsld.Prerequistes_ID#" -column_spec "integer"
- content::type::attribute::new -content_type imsld_learning_activity -attribute_name sort_order -datatype number -pretty_name "<#_ Sort Order #>" -column_spec "integer"
+ content::type::attribute::new -content_type imsld_learning_activity -attribute_name sort_order -datatype number -pretty_name "#imsld.Sort_Order#" -column_spec "integer"
# support activities
content::type::new -content_type imsld_support_activity -supertype content_revision -pretty_name "#imsld.lt_IMS-LD_Support_Activi#" -pretty_plural "#imsld.lt_IMS-LD_Support_Activi_1#" -table_name imsld_support_activities -id_column activity_id
@@ -103,10 +103,10 @@
content::type::attribute::new -content_type imsld_support_activity -attribute_name activity_description_id -datatype number -pretty_name "#imsld.lt_Activity_Description_#" -column_spec "integer"
content::type::attribute::new -content_type imsld_support_activity -attribute_name parameter_id -datatype number -pretty_name "#imsld.Parameter_Identifier#" -column_spec "integer"
content::type::attribute::new -content_type imsld_support_activity -attribute_name is_visible_p -datatype string -pretty_name "#imsld.Is_Visible#" -column_spec "char(1)"
- content::type::attribute::new -content_type imsld_support_activity -attribute_name complete_act_id -datatype number -pretty_name "<#_ Complete Act Identifier #>" -column_spec "integer"
+ content::type::attribute::new -content_type imsld_support_activity -attribute_name complete_act_id -datatype number -pretty_name "#imsld.lt_Complete_Act_Identifi#" -column_spec "integer"
content::type::attribute::new -content_type imsld_support_activity -attribute_name on_completion_id -datatype number -pretty_name "#imsld.lt_On_Completion_Identif#" -column_spec "integer"
content::type::attribute::new -content_type imsld_support_activity -attribute_name parameters -datatype string -pretty_name "#imsld.Parameters#" -column_spec "varchar(4000)"
- content::type::attribute::new -content_type imsld_support_activity -attribute_name sort_order -datatype number -pretty_name "<#_ Sort Order #>" -column_spec "integer"
+ content::type::attribute::new -content_type imsld_support_activity -attribute_name sort_order -datatype number -pretty_name "#imsld.Sort_Order#" -column_spec "integer"
# activity structures
content::type::new -content_type imsld_activity_structure -supertype content_revision -pretty_name "#imsld.lt_IMS-LD_Activity_Struc#" -pretty_plural "#imsld.lt_IMS-LD_Activity_Struc_1#" -table_name imsld_activity_structures -id_column structure_id
@@ -116,7 +116,7 @@
content::type::attribute::new -content_type imsld_activity_structure -attribute_name number_to_select -datatype number -pretty_name "#imsld.Number_to_Select#" -column_spec "integer"
content::type::attribute::new -content_type imsld_activity_structure -attribute_name structure_type -datatype string -pretty_name "#imsld.Structure_Type#" -column_spec "char(9)"
content::type::attribute::new -content_type imsld_activity_structure -attribute_name sort -datatype string -pretty_name "#imsld.Sort#" -column_spec "varchar(4)"
- content::type::attribute::new -content_type imsld_activity_structure -attribute_name sort_order -datatype number -pretty_name "<#_ Sort Order #>" -column_spec "integer"
+ content::type::attribute::new -content_type imsld_activity_structure -attribute_name sort_order -datatype number -pretty_name "#imsld.Sort_Order#" -column_spec "integer"
# environments
content::type::new -content_type imsld_environment -supertype content_revision -pretty_name "#imsld.IMD-LD_Environment#" -pretty_plural "#imsld.IMD-LD_Environments#" -table_name imsld_environments -id_column environment_id
@@ -161,7 +161,7 @@
content::type::new -content_type imsld_method -supertype content_revision -pretty_name "#imsld.IMS-LD_Method#" -pretty_plural "#imsld.IMS-LD_Methods#" -table_name imsld_methods -id_column method_id
content::type::attribute::new -content_type imsld_method -attribute_name imsld_id -datatype number -pretty_name "#imsld.IMS-LD_Identifier#" -column_spec "integer"
- content::type::attribute::new -content_type imsld_method -attribute_name complete_act_id -datatype number -pretty_name "<#_ Complete Act Identifier #>" -column_spec "integer"
+ content::type::attribute::new -content_type imsld_method -attribute_name complete_act_id -datatype number -pretty_name "#imsld.lt_Complete_Act_Identifi#" -column_spec "integer"
content::type::attribute::new -content_type imsld_method -attribute_name on_completion_id -datatype number -pretty_name "#imsld.lt_On_Completion_Identif#" -column_spec "integer"
# plays
@@ -170,15 +170,15 @@
content::type::attribute::new -content_type imsld_play -attribute_name method_id -datatype number -pretty_name "#imsld.Method_Identifier#" -column_spec "integer"
content::type::attribute::new -content_type imsld_play -attribute_name is_visible_p -datatype string -pretty_name "#imsld.Is_Visible#" -column_spec "char(1)"
content::type::attribute::new -content_type imsld_play -attribute_name identifier -datatype string -pretty_name "#imsld.Identifier#" -column_spec "varchar(100)"
- content::type::attribute::new -content_type imsld_play -attribute_name complete_act_id -datatype number -pretty_name "<#_ Complete Act Identifier #>" -column_spec "integer"
+ content::type::attribute::new -content_type imsld_play -attribute_name complete_act_id -datatype number -pretty_name "#imsld.lt_Complete_Act_Identifi#" -column_spec "integer"
content::type::attribute::new -content_type imsld_play -attribute_name on_completion_id -datatype number -pretty_name "#imsld.lt_On_Completion_Identif#" -column_spec "integer"
content::type::attribute::new -content_type imsld_play -attribute_name sort_order -datatype number -pretty_name "#imsld.Sort_Order#" -column_spec "integer"
# acts
content::type::new -content_type imsld_act -supertype content_revision -pretty_name "#imsld.IMS-LD_Act#" -pretty_plural "#imsld.IMS-LD_Acts#" -table_name imsld_acts -id_column act_id
content::type::attribute::new -content_type imsld_act -attribute_name play_id -datatype number -pretty_name "#imsld.Play_Identifier#" -column_spec "integer"
- content::type::attribute::new -content_type imsld_act -attribute_name complete_act_id -datatype number -pretty_name "<#_ Complete Act Identifier #>" -column_spec "integer"
+ content::type::attribute::new -content_type imsld_act -attribute_name complete_act_id -datatype number -pretty_name "#imsld.lt_Complete_Act_Identifi#" -column_spec "integer"
content::type::attribute::new -content_type imsld_act -attribute_name identifier -datatype string -pretty_name "#imsld.Identifier#" -column_spec "varchar(100)"
content::type::attribute::new -content_type imsld_act -attribute_name on_completion_id -datatype number -pretty_name "#imsld.lt_On_Completion_Identif#" -column_spec "integer"
content::type::attribute::new -content_type imsld_act -attribute_name sort_order -datatype number -pretty_name "#imsld.Sort_Order#" -column_spec "integer"
@@ -196,7 +196,7 @@
content::type::attribute::new -content_type imsld_role_part -attribute_name sort_order -datatype number -pretty_name "#imsld.Sort_Order#" -column_spec "integer"
# complete acts
- content::type::new -content_type imsld_complete_act -supertype content_revision -pretty_name "<#_ Complete Act #>" -pretty_plural "<#_ Complete Acts #>" -table_name imsld_complete_acts -id_column complete_act_id
+ content::type::new -content_type imsld_complete_act -supertype content_revision -pretty_name "#imsld.Complete_Act#" -pretty_plural "#imsld.Complete_Acts#" -table_name imsld_complete_acts -id_column complete_act_id
content::type::attribute::new -content_type imsld_complete_act -attribute_name time_in_seconds -datatype number -pretty_name "#imsld.Time_in_Seconds#" -column_spec "integer"
content::type::attribute::new -content_type imsld_complete_act -attribute_name user_choice_p -datatype string -pretty_name "#imsld.User_Choice#" -column_spec "char(1)"
@@ -247,95 +247,95 @@
### IMS-LD LEVEL B
# properties
- content::type::new -content_type imsld_property -supertype content_revision -pretty_name "<#_ IMS-LD Property #>" -pretty_plural "<#_ IMS-LD Properties #>" -table_name imsld_properties -id_column property_id
+ content::type::new -content_type imsld_property -supertype content_revision -pretty_name "#imsld.IMS-LD_Property#" -pretty_plural "#imsld.IMS-LD_Properties#" -table_name imsld_properties -id_column property_id
- content::type::attribute::new -content_type imsld_property -attribute_name component_id -datatype number -pretty_name "<#_ Component Identifier #>" -column_spec "integer"
- content::type::attribute::new -content_type imsld_property -attribute_name identifier -datatype string -pretty_name "<#_ Identifier #>" -column_spec "varchar(100)"
- content::type::attribute::new -content_type imsld_property -attribute_name type -datatype string -pretty_name "<#_ Type #>" -column_spec "varchar(20)"
- content::type::attribute::new -content_type imsld_property -attribute_name datatype -datatype string -pretty_name "<#_ Data Type #>" -column_spec "varchar(20)"
- content::type::attribute::new -content_type imsld_property -attribute_name initial_value -datatype string -pretty_name "<#_ Initial Value #>" -column_spec "varchar(4000)"
- content::type::attribute::new -content_type imsld_property -attribute_name role_id -datatype number -pretty_name "<#_ Role Identifier #>" -column_spec "integer"
- content::type::attribute::new -content_type imsld_property -attribute_name existing_href -datatype string -pretty_name "<#_ Existing href #>" -column_spec "varchar(2000)"
- content::type::attribute::new -content_type imsld_property -attribute_name uri -datatype string -pretty_name "<#_ URI #>" -column_spec "varchar(2000)"
+ content::type::attribute::new -content_type imsld_property -attribute_name component_id -datatype number -pretty_name "#imsld.Component_Identifier#" -column_spec "integer"
+ content::type::attribute::new -content_type imsld_property -attribute_name identifier -datatype string -pretty_name "#imsld.Identifier#" -column_spec "varchar(100)"
+ content::type::attribute::new -content_type imsld_property -attribute_name type -datatype string -pretty_name "#imsld.Type#" -column_spec "varchar(20)"
+ content::type::attribute::new -content_type imsld_property -attribute_name datatype -datatype string -pretty_name "#imsld.Data_Type#" -column_spec "varchar(20)"
+ content::type::attribute::new -content_type imsld_property -attribute_name initial_value -datatype string -pretty_name "#imsld.Initial_Value#" -column_spec "varchar(4000)"
+ content::type::attribute::new -content_type imsld_property -attribute_name role_id -datatype number -pretty_name "#imsld.Role_Identifier#" -column_spec "integer"
+ content::type::attribute::new -content_type imsld_property -attribute_name existing_href -datatype string -pretty_name "#imsld.Existing_href#" -column_spec "varchar(2000)"
+ content::type::attribute::new -content_type imsld_property -attribute_name uri -datatype string -pretty_name "#imsld.URI#" -column_spec "varchar(2000)"
# property groups
- content::type::new -content_type imsld_property_group -supertype content_revision -pretty_name "<#_ IMS-LD Property Group #>" -pretty_plural "<#_ IMS-LD Property Groups #>" -table_name imsld_property_groups -id_column property_group_id
+ content::type::new -content_type imsld_property_group -supertype content_revision -pretty_name "#imsld.lt_IMS-LD_Property_Group#" -pretty_plural "#imsld.lt_IMS-LD_Property_Group_1#" -table_name imsld_property_groups -id_column property_group_id
- content::type::attribute::new -content_type imsld_property_group -attribute_name component_id -datatype number -pretty_name "<#_ Component Identifier #>" -column_spec "integer"
- content::type::attribute::new -content_type imsld_property_group -attribute_name identifier -datatype string -pretty_name "<#_ Identifier #>" -column_spec "varchar(100)"
+ content::type::attribute::new -content_type imsld_property_group -attribute_name component_id -datatype number -pretty_name "#imsld.Component_Identifier#" -column_spec "integer"
+ content::type::attribute::new -content_type imsld_property_group -attribute_name identifier -datatype string -pretty_name "#imsld.Identifier#" -column_spec "varchar(100)"
# restrictions
- content::type::new -content_type imsld_restriction -supertype content_revision -pretty_name "<#_ IMS-LD Restriction #>" -pretty_plural "<#_ IMS-LD Restrictions #>" -table_name imsld_restrictions -id_column restriction_id
+ content::type::new -content_type imsld_restriction -supertype content_revision -pretty_name "#imsld.IMS-LD_Restriction#" -pretty_plural "#imsld.IMS-LD_Restrictions#" -table_name imsld_restrictions -id_column restriction_id
- content::type::attribute::new -content_type imsld_restriction -attribute_name property_id -datatype number -pretty_name "<#_ Property Identifier #>" -column_spec "integer"
- content::type::attribute::new -content_type imsld_restriction -attribute_name restriction_type -datatype string -pretty_name "<#_ Restriction Type #>" -column_spec "varchar(20)"
- content::type::attribute::new -content_type imsld_restriction -attribute_name value -datatype string -pretty_name "<#_ Value #>" -column_spec "varchar"
+ content::type::attribute::new -content_type imsld_restriction -attribute_name property_id -datatype number -pretty_name "#imsld.Property_Identifier#" -column_spec "integer"
+ content::type::attribute::new -content_type imsld_restriction -attribute_name restriction_type -datatype string -pretty_name "#imsld.Restriction_Type#" -column_spec "varchar(20)"
+ content::type::attribute::new -content_type imsld_restriction -attribute_name value -datatype string -pretty_name "#imsld.Value#" -column_spec "varchar"
# property values
- content::type::new -content_type imsld_property_value -supertype content_revision -pretty_name "<#_ IMS-LD Property Value #>" -pretty_plural "<#_ IMS-LD Property Values #>" -table_name imsld_property_values -id_column property_value_id
+ content::type::new -content_type imsld_property_value -supertype content_revision -pretty_name "#imsld.lt_IMS-LD_Property_Value#" -pretty_plural "#imsld.lt_IMS-LD_Property_Value_1#" -table_name imsld_property_values -id_column property_value_id
- content::type::attribute::new -content_type imsld_property_value -attribute_name property_id -datatype number -pretty_name "<#_ Property Identifier #>" -column_spec "integer"
- content::type::attribute::new -content_type imsld_property_value -attribute_name langstring -datatype string -pretty_name "<#_ Langstring #>" -column_spec "varchar(4000)"
- content::type::attribute::new -content_type imsld_property_value -attribute_name calculate_id -datatype number -pretty_name "<#_ Calulate Identifier #>" -column_spec "integer"
- content::type::attribute::new -content_type imsld_property_value -attribute_name property_value_ref -datatype number -pretty_name "<#_ Property Value Ref. #>" -column_spec "integer"
+ content::type::attribute::new -content_type imsld_property_value -attribute_name property_id -datatype number -pretty_name "#imsld.Property_Identifier#" -column_spec "integer"
+ content::type::attribute::new -content_type imsld_property_value -attribute_name langstring -datatype string -pretty_name "#imsld.Langstring#" -column_spec "varchar(4000)"
+ content::type::attribute::new -content_type imsld_property_value -attribute_name calculate_id -datatype number -pretty_name "#imsld.Calulate_Identifier#" -column_spec "integer"
+ content::type::attribute::new -content_type imsld_property_value -attribute_name property_value_ref -datatype number -pretty_name "#imsld.Property_Value_Ref#" -column_spec "integer"
# complete acts
- content::type::attribute::new -content_type imsld_complete_act -attribute_name time_property_id -datatype number -pretty_name "<#_ Time Property Identifier #>" -column_spec "integer"
- content::type::attribute::new -content_type imsld_complete_act -attribute_name when_prop_val_is_set_id -datatype number -pretty_name "<#_ When Property Value is Set Identifier #>" -column_spec "integer"
- content::type::attribute::new -content_type imsld_complete_act -attribute_name when_condition_true_id -datatype number -pretty_name "<#_ When Condition True #>" -column_spec "integer"
+ content::type::attribute::new -content_type imsld_complete_act -attribute_name time_property_id -datatype number -pretty_name "#imsld.lt_Time_Property_Identif#" -column_spec "integer"
+ content::type::attribute::new -content_type imsld_complete_act -attribute_name when_prop_val_is_set_id -datatype number -pretty_name "#imsld.lt_When_Property_Value_i#" -column_spec "integer"
+ content::type::attribute::new -content_type imsld_complete_act -attribute_name when_condition_true_id -datatype number -pretty_name "#imsld.When_Condition_True#" -column_spec "integer"
# monitor service
- content::type::new -content_type imsld_monitor_service -supertype content_revision -pretty_name "<#_ IMS-LD Monitor Service #>" -pretty_plural "<#_ IMS-LD Monitor Services #>" -table_name imsld_monitor_services -id_column monitor_id
+ content::type::new -content_type imsld_monitor_service -supertype content_revision -pretty_name "#imsld.lt_IMS-LD_Monitor_Servic#" -pretty_plural "#imsld.lt_IMS-LD_Monitor_Servic_1#" -table_name imsld_monitor_services -id_column monitor_id
- content::type::attribute::new -content_type imsld_monitor_service -attribute_name service_id -datatype number -pretty_name "<#_ Service Identifier #>" -column_spec "integer"
- content::type::attribute::new -content_type imsld_monitor_service -attribute_name role_id -datatype number -pretty_name "<#_ Role Identifier #>" -column_spec "integer"
- content::type::attribute::new -content_type imsld_monitor_service -attribute_name self_p -datatype string -pretty_name "<#_ Self #>" -column_spec "char(1)"
- content::type::attribute::new -content_type imsld_monitor_service -attribute_name imsld_item_id -datatype number -pretty_name "<#_ IMS-LD Item Identifier #>" -column_spec "integer"
+ content::type::attribute::new -content_type imsld_monitor_service -attribute_name service_id -datatype number -pretty_name "#imsld.Service_Identifier#" -column_spec "integer"
+ content::type::attribute::new -content_type imsld_monitor_service -attribute_name role_id -datatype number -pretty_name "#imsld.Role_Identifier#" -column_spec "integer"
+ content::type::attribute::new -content_type imsld_monitor_service -attribute_name self_p -datatype string -pretty_name "#imsld.Self#" -column_spec "char(1)"
+ content::type::attribute::new -content_type imsld_monitor_service -attribute_name imsld_item_id -datatype number -pretty_name "#imsld.lt_IMS-LD_Item_Identifie#" -column_spec "integer"
# send mail service
- content::type::attribute::new -content_type imsld_send_mail_service -attribute_name email_property_id -datatype number -pretty_name "<#_ Email Propery Identifier #>" -column_spec "integer"
- content::type::attribute::new -content_type imsld_send_mail_service -attribute_name username_property_id -datatype number -pretty_name "<#_ Username Property Identifier #>" -column_spec "integer"
+ content::type::attribute::new -content_type imsld_send_mail_service -attribute_name email_property_id -datatype number -pretty_name "#imsld.lt_Email_Propery_Identif#" -column_spec "integer"
+ content::type::attribute::new -content_type imsld_send_mail_service -attribute_name username_property_id -datatype number -pretty_name "#imsld.lt_Username_Property_Ide#" -column_spec "integer"
# when condition true
- content::type::new -content_type imsld_when_condition_true -supertype content_revision -pretty_name "<#_ IMS-LD When Condition True #>" -pretty_plural "<#_ IMS-LD When Conditions True #>" -table_name imsld_when_condition_true -id_column when_condition_true_id
+ content::type::new -content_type imsld_when_condition_true -supertype content_revision -pretty_name "#imsld.lt_IMS-LD_When_Condition#" -pretty_plural "#imsld.lt_IMS-LD_When_Condition_1#" -table_name imsld_when_condition_true -id_column when_condition_true_id
- content::type::attribute::new -content_type imsld_when_condition_true -attribute_name role_id -datatype number -pretty_name "<#_ Role Identifier #>" -column_spec "integer"
- content::type::attribute::new -content_type imsld_when_condition_true -attribute_name expression_id -datatype number -pretty_name "<#_ Expression Identifier #>" -column_spec "integer"
+ content::type::attribute::new -content_type imsld_when_condition_true -attribute_name role_id -datatype number -pretty_name "#imsld.Role_Identifier#" -column_spec "integer"
+ content::type::attribute::new -content_type imsld_when_condition_true -attribute_name expression_id -datatype number -pretty_name "#imsld.lt_Expression_Identifier#" -column_spec "integer"
# expressions, conditions and calculate
- content::type::new -content_type imsld_expression -supertype content_revision -pretty_name "<#_ IMS-LD Expression #>" -pretty_plural "<#_ IMS-LD Expressions #>" -table_name imsld_expressions -id_column expression_id
+ content::type::new -content_type imsld_expression -supertype content_revision -pretty_name "#imsld.IMS-LD_Expression#" -pretty_plural "#imsld.IMS-LD_Expressions#" -table_name imsld_expressions -id_column expression_id
- content::type::attribute::new -content_type imsld_expression -attribute_name imsld_id -datatype number -pretty_name "<#_ IMS-LD Intifier #>" -column_spec "integer"
- content::type::attribute::new -content_type imsld_expression -attribute_name xml_piece -datatype string -pretty_name "<#_ XML Piece #>" -column_spec "text"
+ content::type::attribute::new -content_type imsld_expression -attribute_name imsld_id -datatype number -pretty_name "#imsld.IMS-LD_Intifier#" -column_spec "integer"
+ content::type::attribute::new -content_type imsld_expression -attribute_name xml_piece -datatype string -pretty_name "#imsld.XML_Piece#" -column_spec "text"
# # conditions
-# content::type::new -content_type imsld_condition -supertype content_revision -pretty_name "<#_ IMS-LD Condition #>" -pretty_plural "<#_ IMS-LD Conditions #>" -table_name imsld_conditions -id_column condition_id
+# content::type::new -content_type imsld_condition -supertype content_revision -pretty_name "#imsld.IMS-LD_Condition#" -pretty_plural "#imsld.IMS-LD_Conditions#" -table_name imsld_conditions -id_column condition_id
-# content::type::attribute::new -content_type imsld_condition -attribute_name method_id -datatype number -pretty_name "<#_ Method Identifier #>" -column_spec "integer"
-# content::type::attribute::new -content_type imsld_condition -attribute_name if_id -datatype number -pretty_name "<#_ If Identifier #>" -column_spec "integer"
-# content::type::attribute::new -content_type imsld_condition -attribute_name then_id -datatype number -pretty_name "<#_ Then Identifier #>" -column_spec "integer"
-# content::type::attribute::new -content_type imsld_condition -attribute_name else_id -datatype number -pretty_name "<#_ Else Identifier #>" -column_spec "integer"
+# content::type::attribute::new -content_type imsld_condition -attribute_name method_id -datatype number -pretty_name "#imsld.Method_Identifier#" -column_spec "integer"
+# content::type::attribute::new -content_type imsld_condition -attribute_name if_id -datatype number -pretty_name "#imsld.If_Identifier#" -column_spec "integer"
+# content::type::attribute::new -content_type imsld_condition -attribute_name then_id -datatype number -pretty_name "#imsld.Then_Identifier#" -column_spec "integer"
+# content::type::attribute::new -content_type imsld_condition -attribute_name else_id -datatype number -pretty_name "#imsld.Else_Identifier#" -column_spec "integer"
# # expressions
-# content::type::new -content_type imsld_expression -supertype content_revision -pretty_name "<#_ IMS-LD Expression #>" -pretty_plural "<#_ IMS-LD Expressions #>" -table_name imsld_expressions -id_column expression_id
+# content::type::new -content_type imsld_expression -supertype content_revision -pretty_name "#imsld.IMS-LD_Expression#" -pretty_plural "#imsld.IMS-LD_Expressions#" -table_name imsld_expressions -id_column expression_id
-# content::type::attribute::new -content_type imsld_expression -attribute_name type -datatype string -pretty_name "<#_ Type #>" -column_spec "varchar(25)"
-# content::type::attribute::new -content_type imsld_expression -attribute_name role_id -datatype number -pretty_name "<#_ Role Identifier #>" -column_spec "integer"
-# content::type::attribute::new -content_type imsld_expression -attribute_name calculate_id -datatype number -pretty_name "<#_ Caluclate Identifier #>" -column_spec "integer"
-# content::type::attribute::new -content_type imsld_expression -attribute_name exp_one_id -datatype number -pretty_name "<#_ Expression One Identifier #>" -column_spec "integer"
-# content::type::attribute::new -content_type imsld_expression -attribute_name exp_two_id -datatype number -pretty_name "<#_ Expression Two Identifer #>" -column_spec "integer"
-# content::type::attribute::new -content_type imsld_expression -attribute_name property_id -datatype number -pretty_name "<#_ Property Identifier #>" -column_spec "integer"
-# content::type::attribute::new -content_type imsld_expression -attribute_name ref_type -datatype string -pretty_name "<#_ Reference Type #>" -column_spec "varchar(20)"
-# content::type::attribute::new -content_type imsld_expression -attribute_name ref_id -datatype number -pretty_name "<#_ Reference Identifier #>" -column_spec "integer"
+# content::type::attribute::new -content_type imsld_expression -attribute_name type -datatype string -pretty_name "#imsld.Type#" -column_spec "varchar(25)"
+# content::type::attribute::new -content_type imsld_expression -attribute_name role_id -datatype number -pretty_name "#imsld.Role_Identifier#" -column_spec "integer"
+# content::type::attribute::new -content_type imsld_expression -attribute_name calculate_id -datatype number -pretty_name "#imsld.Caluclate_Identifier#" -column_spec "integer"
+# content::type::attribute::new -content_type imsld_expression -attribute_name exp_one_id -datatype number -pretty_name "#imsld.lt_Expression_One_Identi#" -column_spec "integer"
+# content::type::attribute::new -content_type imsld_expression -attribute_name exp_two_id -datatype number -pretty_name "#imsld.lt_Expression_Two_Identi#" -column_spec "integer"
+# content::type::attribute::new -content_type imsld_expression -attribute_name property_id -datatype number -pretty_name "#imsld.Property_Identifier#" -column_spec "integer"
+# content::type::attribute::new -content_type imsld_expression -attribute_name ref_type -datatype string -pretty_name "#imsld.Reference_Type#" -column_spec "varchar(20)"
+# content::type::attribute::new -content_type imsld_expression -attribute_name ref_id -datatype number -pretty_name "#imsld.Reference_Identifier#" -column_spec "integer"
# # then model
-# content::type::new -content_type imsld_then_model -supertype content_revision -pretty_name "<#_ IMS-LD Then Model #>" -pretty_plural "<#_ IMS-LD Then Models #>" -table_name imsld_then_model -id_column then_model_id
+# content::type::new -content_type imsld_then_model -supertype content_revision -pretty_name "#imsld.IMS-LD_Then_Model#" -pretty_plural "#imsld.IMS-LD_Then_Models#" -table_name imsld_then_model -id_column then_model_id
-# content::type::attribute::new -content_type imsld_then_model -attribute_name type -datatype string -pretty_name "<#_ Type #>" -column_spec "varchar(20)"
-# content::type::attribute::new -content_type imsld_then_model -attribute_name ref_type -datatype string -pretty_name "<#_ Reference Type #>" -column_spec "varchar(20)"
-# content::type::attribute::new -content_type imsld_then_model -attribute_name ref_id -datatype number -pretty_name "<#_ Reference Identifier #>" -column_spec "integer"
-# content::type::attribute::new -content_type imsld_then_model -attribute_name with_control_p -datatype string -pretty_name "<#_ With Control #>" -column_spec "char(1)"
-# content::type::attribute::new -content_type imsld_then_model -attribute_name change_prop_val_id -datatype number -pretty_name "<#_ Change Property Value Identifier #>" -column_spec "integer"
+# content::type::attribute::new -content_type imsld_then_model -attribute_name type -datatype string -pretty_name "#imsld.Type#" -column_spec "varchar(20)"
+# content::type::attribute::new -content_type imsld_then_model -attribute_name ref_type -datatype string -pretty_name "#imsld.Reference_Type#" -column_spec "varchar(20)"
+# content::type::attribute::new -content_type imsld_then_model -attribute_name ref_id -datatype number -pretty_name "#imsld.Reference_Identifier#" -column_spec "integer"
+# content::type::attribute::new -content_type imsld_then_model -attribute_name with_control_p -datatype string -pretty_name "#imsld.With_Control#" -column_spec "char(1)"
+# content::type::attribute::new -content_type imsld_then_model -attribute_name change_prop_val_id -datatype number -pretty_name "#imsld.lt_Change_Property_Value#" -column_spec "integer"
}
Index: openacs-4/packages/imsld/tcl/imsld-parse-procs.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/imsld/tcl/imsld-parse-procs.tcl,v
diff -u -r1.28 -r1.29
--- openacs-4/packages/imsld/tcl/imsld-parse-procs.tcl 1 Feb 2006 11:34:48 -0000 1.28
+++ openacs-4/packages/imsld/tcl/imsld-parse-procs.tcl 1 Feb 2006 12:31:32 -0000 1.29
@@ -981,7 +981,7 @@
and component_id = :component_id
}] } {
# there is no property with that identifier, return the error
- return [list 0 "<#_ There is no property with the identifier %ref% (referenced by: property group %identifier%) #>"]
+ return [list 0 "[_ imsld.lt_There_is_no_property_]"]
}
relation_add imsld_gprop_prop_rel $property_group_id $property_item_id
}
@@ -1029,7 +1029,7 @@
relation_add imsld_gprop_gprop_rel $property_group_id $property_group_ref_id
} else {
# error
- return [list 0 "<#_ There is no property-group with the identifier %ref% (referenced by property-group %identifier%) #>"]
+ return [list 0 "[_ imsld.lt_There_is_no_property-]"]
}
} else {
# do the mappings
@@ -1169,7 +1169,7 @@
and component_id = :component_id
}] } {
# there is no role with that identifier, return the error
- return [list 0 "<#_ There is no role with the identifier %ref% (referenced by: locrole property) #>"]
+ return [list 0 "[_ imsld.lt_There_is_no_role_with_6]"]
}
set lrp_initial_value [$locrole_property child all imsld:initial-value]
@@ -1566,7 +1566,7 @@
and content_revision__is_live(property_id) = 't'
and component_id = :component_id }] } {
# there is no property with that identifier, return the error
- return [list 0 "<#_ There is no property with the identifier %email_property_ref% (referenced from an email data) #>"]
+ return [list 0 "[_ imsld.lt_There_is_no_property__1]"]
}
} else {
set email_property_id ""
@@ -1582,7 +1582,7 @@
and content_revision__is_live(property_id) = 't'
and component_id = :component_id }] } {
# there is no property with that identifier, return the error
- return [list 0 "<#_ There is no property with the identifier %username_property_ref% (referenced from an email data) #>"]
+ return [list 0 "[_ imsld.lt_There_is_no_property__2]"]
}
} else {
set username_property_id ""
@@ -1789,7 +1789,7 @@
and ir.component_id = :component_id
}] } {
# there is no role with that identifier, return the error
- return [list 0 "<#_ There is no role with the identifier %ref% (referenced from a monitor service) #>"]
+ return [list 0 "[_ imsld.lt_There_is_no_role_with_7]"]
}
# monitor: self
@@ -1986,7 +1986,7 @@
and component_id = :component_id
}] } {
# there is no property with that identifier, return the error
- return [list 0 "<#_ There is no property with the identifier %ref% (referenced by: property value #>"]
+ return [list 0 "[_ imsld.lt_There_is_no_property__3]"]
}
# Property Value
@@ -3623,7 +3623,7 @@
# and content_revision__is_live(ir.role_id) = 't'
# }] } {
# # there is no role with that identifier, return the error
-# return [list 0 "<#_ There is no role with the identifier %role_ref% (referenced from within an expression) #>]"]
+# return [list 0 "[_ imsld.lt_There_is_no_role_with_8]]"]
# }
# }
Index: openacs-4/packages/imsld/tcl/imsld-procs.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/imsld/tcl/imsld-procs.tcl,v
diff -u -r1.21 -r1.22
--- openacs-4/packages/imsld/tcl/imsld-procs.tcl 1 Feb 2006 11:48:25 -0000 1.21
+++ openacs-4/packages/imsld/tcl/imsld-procs.tcl 1 Feb 2006 12:31:32 -0000 1.22
@@ -273,7 +273,7 @@
set activity_id [lindex $referenced_sa 1]
set time_in_seconds [lindex $referenced_sa 2]
set role_part_id [imsld::get_role_part_from_activity -activity_type support -leaf_id $sa_item_id]
- db_1row get_activity_info {
+ db_1row get_sa_activity_info {
select icm.manifest_id,
ii.imsld_id,
ip.play_id,
@@ -330,7 +330,7 @@
set activity_id [lindex $referenced_la 1]
set time_in_seconds [lindex $referenced_la 2]
set role_part_id [imsld::get_role_part_from_activity -activity_type learning -leaf_id $la_item_id]
- db_1row get_activity_info {
+ db_1row get_la_activity_info {
select icm.manifest_id,
ii.imsld_id,
ip.play_id,
@@ -2185,7 +2185,7 @@
and rp.sort_order = (select min(irp2.sort_order) from imsld_role_parts irp2 where irp2.act_id = ia.item_id)
}] } {
# there is no more to search, we reached the end of the unit of learning
- template::multirow append imsld_multirow {} {} {} {} {} "<#_ Learning Unit finished #>"
+ template::multirow append imsld_multirow {} {} {} {} {} "[_ imsld.lt_Learning_Unit_finishe]"
return [template::multirow size imsld_multirow]
}
}
Index: openacs-4/packages/imsld/tcl/imsld-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/imsld/tcl/imsld-procs.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/imsld/tcl/imsld-procs.xql 1 Feb 2006 11:34:48 -0000 1.1
+++ openacs-4/packages/imsld/tcl/imsld-procs.xql 1 Feb 2006 12:31:32 -0000 1.2
@@ -20,15 +20,15 @@
select icm.manifest_id,
ii.imsld_id,
im.method_id,
- tl.time_in_seconds,
+ ca.time_in_seconds,
icm.creation_date
from imsld_cp_manifestsi icm, imsld_cp_organizationsi ico,
- imsld_imsldsi ii, imsld_methodsi im, imsld_time_limitsi tl
+ imsld_imsldsi ii, imsld_methodsi im, imsld_complete_actsi ca
where im.imsld_id = ii.item_id
and ii.organization_id = ico.item_id
and ico.manifest_id = icm.item_id
- and im.time_limit_id is not null
- and im.time_limit_id = tl.item_id
+ and im.complete_act_id = ca.item_id
+ and ca.time_in_seconds is not null
and content_revision__is_live(im.method_id) = 't'
@@ -60,17 +60,17 @@
select icm.manifest_id,
ii.imsld_id,
ip.play_id,
- tl.time_in_seconds,
+ ca.time_in_seconds,
icm.creation_date
from imsld_cp_manifestsi icm, imsld_cp_organizationsi ico,
imsld_imsldsi ii, imsld_methodsi im, imsld_plays ip,
- imsld_time_limitsi tl
+ imsld_complete_actsi ca
where ip.method_id = im.item_id
and im.imsld_id = ii.item_id
and ii.organization_id = ico.item_id
and ico.manifest_id = icm.item_id
- and ip.time_limit_id is not null
- and ip.time_limit_id = tl.item_id
+ and ip.complete_act_id = ca.item_id
+ and ca.time_in_seconds is not null
and content_revision__is_live(ip.play_id) = 't'
@@ -86,18 +86,18 @@
ii.imsld_id,
ip.play_id,
ia.act_id,
- tl.time_in_seconds,
+ ca.time_in_seconds,
icm.creation_date
from imsld_cp_manifestsi icm, imsld_cp_organizationsi ico,
imsld_imsldsi ii, imsld_methodsi im, imsld_playsi ip, imsld_acts ia,
- imsld_time_limitsi tl
+ imsld_complete_actsi ca
where ia.play_id = ip.item_id
and ip.method_id = im.item_id
and im.imsld_id = ii.item_id
and ii.organization_id = ico.item_id
and ico.manifest_id = icm.item_id
- and ia.time_limit_id is not null
- and ia.time_limit_id = tl.item_id
+ and ia.complete_act_id = ca.item_id
+ and ca.time_in_seconds is not null
and content_revision__is_live(ia.act_id) = 't'
@@ -107,70 +107,79 @@
-
+
- select icm.manifest_id,
+ select sa.item_id as sa_item_id,
sa.activity_id,
- ii.imsld_id,
- ip.play_id,
- ia.act_id,
- irp.role_part_id,
- tl.time_in_seconds,
- icm.creation_date
- from imsld_cp_manifestsi icm, imsld_cp_organizationsi ico,
- imsld_imsldsi ii, imsld_methodsi im, imsld_playsi ip,
- imsld_actsi ia, imsld_role_partsi irp, imsld_support_activitiesi sa,
- imsld_time_limitsi tl
- where sa.item_id = irp.support_activity_id
- and irp.act_id = ia.item_id
- and ia.play_id = ip.item_id
- and ip.method_id = im.item_id
- and im.imsld_id = ii.item_id
- and ii.organization_id = ico.item_id
- and ico.manifest_id = icm.item_id
- and sa.time_limit_id is not null
- and sa.time_limit_id = tl.item_id
- and content_revision__is_live(sa.activity_id) = 't'
+ ca.time_in_seconds
+ from imsld_support_activitiesi sa,
+ imsld_complete_actsi ca
+ where sa.complete_act_id = ca.item_id
+ and content_revision__is_live(ca.complete_act_id) = 't'
+ and ca.time_in_seconds is not null
+
+
+ select icm.manifest_id,
+ ii.imsld_id,
+ ip.play_id,
+ ia.act_id,
+ icm.creation_date
+ from imsld_cp_manifestsi icm, imsld_cp_organizationsi ico,
+ imsld_imsldsi ii, imsld_methodsi im, imsld_playsi ip,
+ imsld_actsi ia, imsld_role_partsi irp
+ where irp.role_part_id = :role_part_id
+ and irp.act_id = ia.item_id
+ and ia.play_id = ip.item_id
+ and ip.method_id = im.item_id
+ and im.imsld_id = ii.item_id
+ and ii.organization_id = ico.item_id
+ and ico.manifest_id = icm.item_id
+ and content_revision__is_live(icm.manifest_id) = 't'
+
+
+
-
-
-
-
+
- select icm.manifest_id,
+ select la.item_id as la_item_id,
la.activity_id,
- ii.imsld_id,
- ip.play_id,
- ia.act_id,
- irp.role_part_id,
- tl.time_in_seconds,
- icm.creation_date
- from imsld_cp_manifestsi icm, imsld_cp_organizationsi ico,
- imsld_imsldsi ii, imsld_methodsi im, imsld_playsi ip,
- imsld_actsi ia, imsld_role_partsi irp, imsld_learning_activitiesi la,
- imsld_time_limitsi tl
- where la.item_id = irp.learning_activity_id
- and irp.act_id = ia.item_id
- and ia.play_id = ip.item_id
- and ip.method_id = im.item_id
- and im.imsld_id = ii.item_id
- and ii.organization_id = ico.item_id
- and ico.manifest_id = icm.item_id
- and la.time_limit_id is not null
- and la.time_limit_id = tl.item_id
- and content_revision__is_live(la.activity_id) = 't'
+ ca.time_in_seconds
+ from imsld_learning_activitiesi la,
+ imsld_complete_actsi ca
+ where la.complete_act_id = ca.item_id
+ and content_revision__is_live(ca.complete_act_id) = 't'
+ and ca.time_in_seconds is not null
+
+
+ select icm.manifest_id,
+ ii.imsld_id,
+ ip.play_id,
+ ia.act_id,
+ icm.creation_date
+ from imsld_cp_manifestsi icm, imsld_cp_organizationsi ico,
+ imsld_imsldsi ii, imsld_methodsi im, imsld_playsi ip,
+ imsld_actsi ia, imsld_role_partsi irp
+ where irp.role_part_id = :role_part_id
+ and irp.act_id = ia.item_id
+ and ia.play_id = ip.item_id
+ and ip.method_id = im.item_id
+ and im.imsld_id = ii.item_id
+ and ii.organization_id = ico.item_id
+ and ico.manifest_id = icm.item_id
+ and content_revision__is_live(icm.manifest_id) = 't'
+
+
-
select item_id as role_part_item_id
@@ -459,16 +468,17 @@
ip.item_id as play_item_id,
ia.act_id,
ia.item_id as act_item_id,
- ip.when_last_act_completed_p,
+ ica.when_last_act_completed_p,
im.method_id,
im.item_id as method_item_id
- from imsld_imsldsi ii, imsld_methodsi im, imsld_playsi ip, imsld_actsi ia, imsld_role_parts irp
+ from imsld_imsldsi ii, imsld_actsi ia, imsld_role_parts irp,
+ imsld_methodsi im, imsld_playsi ip left outer join imsld_complete_actsi ica on (ip.complete_act_id = ica.item_id)
where irp.role_part_id = :role_part_id
and irp.act_id = ia.item_id
and ia.play_id = ip.item_id
and ip.method_id = im.item_id
and im.imsld_id = ii.item_id
- and content_revision__is_live(ii.imsld_id) = 't'
+ and content_revision__is_live(ii.imsld_id) = 't';
@@ -1448,8 +1458,7 @@
select la.activity_id,
la.item_id as activity_item_id,
la.title as activity_title,
- la.identifier,
- la.user_choice_p
+ la.identifier
from imsld_learning_activitiesi la
where la.activity_id = :activity_id
@@ -1462,8 +1471,7 @@
select sa.activity_id,
sa.item_id as activity_item_id,
sa.title as activity_title,
- sa.identifier,
- sa.user_choice_p
+ sa.identifier
from imsld_support_activitiesi sa
where sa.activity_id = :activity_id