Index: openacs-4/packages/assessment/sql/oracle/assessment-actions-package-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/oracle/assessment-actions-package-create.sql,v diff -u -r1.8 -r1.9 --- openacs-4/packages/assessment/sql/oracle/assessment-actions-package-create.sql 2 Dec 2013 08:56:13 -0000 1.8 +++ openacs-4/packages/assessment/sql/oracle/assessment-actions-package-create.sql 27 Oct 2014 16:40:55 -0000 1.9 @@ -133,7 +133,7 @@ person_id = :admin_user_id"] set system_name [ad_system_name] -set system_url [ad_parameter -package_id [ad_acs_kernel_id] SystemURL ""]. +set system_url [parameter::get -package_id [ad_acs_kernel_id] -parameter SystemURL -default ""]. set admin_email [db_string unused "select email from parties where party_id = :admin_user_id"] set message "$first_names $last_name, You have been added as a user to $system_name @@ -192,7 +192,7 @@ set subject "Your $community_name membership has been approved" set message "Your $community_name membership has been approved. Please return to [ad_url] to log into [ad_system_name]." -set email_from [ad_parameter -package_id [ad_acs_kernel_id] SystemOwner] +set email_from [parameter::get -package_id [ad_acs_kernel_id] -parameter SystemOwner] db_1row select_user_info { select email, first_names, last_name from registered_users where user_id = :user_id}