Index: openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.22d3-0.22d4.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.22d3-0.22d4.sql,v diff -u -N -r1.3 -r1.3.6.1 --- openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.22d3-0.22d4.sql 7 Oct 2007 22:36:53 -0000 1.3 +++ openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.22d3-0.22d4.sql 26 Aug 2014 11:36:55 -0000 1.3.6.1 @@ -213,7 +213,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 @@ -272,7 +272,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}