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