Index: openacs-4/packages/news/www/item-create-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/news/www/Attic/item-create-oracle.xql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/news/www/item-create-oracle.xql 9 Nov 2008 23:29:28 -0000 1.2 +++ openacs-4/packages/news/www/item-create-oracle.xql 7 Sep 2013 09:07:45 -0000 1.3 @@ -5,7 +5,7 @@ - select to_char(sysdate + [ad_parameter ActiveDays "news" 14], 'YYYY-MM-DD') as date_proj, + select to_char(sysdate + [parameter::get -parameter ActiveDays -default 14], 'YYYY-MM-DD') as date_proj, to_char(sysdate, 'YYYY-MM-DD') as date_today from dual Index: openacs-4/packages/news/www/item-create-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/news/www/Attic/item-create-postgresql.xql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/news/www/item-create-postgresql.xql 9 Nov 2008 23:29:28 -0000 1.3 +++ openacs-4/packages/news/www/item-create-postgresql.xql 7 Sep 2013 09:07:45 -0000 1.4 @@ -6,7 +6,7 @@ select - to_char(current_timestamp + interval '[ad_parameter ActiveDays "news" 14] days', 'YYYY-MM-DD') as date_proj, + to_char(current_timestamp + interval '[parameter::get -parameter ActiveDays -default 14] days', 'YYYY-MM-DD') as date_proj, to_char(current_timestamp, 'YYYY-MM-DD') as date_today Index: openacs-4/packages/news/www/admin/approve-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/news/www/admin/approve-oracle.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/news/www/admin/approve-oracle.xql 15 Oct 2001 13:41:03 -0000 1.1 +++ openacs-4/packages/news/www/admin/approve-oracle.xql 7 Sep 2013 09:07:45 -0000 1.2 @@ -5,7 +5,7 @@ - select sysdate + [ad_parameter ActiveDays "news" 14] from dual + select sysdate + [parameter::get -parameter ActiveDays -default 14] from dual Index: openacs-4/packages/news/www/admin/approve-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/news/www/admin/approve-postgresql.xql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/news/www/admin/approve-postgresql.xql 23 Aug 2003 22:08:48 -0000 1.3 +++ openacs-4/packages/news/www/admin/approve-postgresql.xql 7 Sep 2013 09:07:45 -0000 1.4 @@ -5,7 +5,7 @@ - select to_char(current_timestamp + interval '[ad_parameter ActiveDays "news" 14] days', 'YYYY-MM-DD') + select to_char(current_timestamp + interval '[parameter::get -parameter ActiveDays -default 14] days', 'YYYY-MM-DD') Index: openacs-4/packages/news/www/admin/revision-add-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/news/www/admin/Attic/revision-add-oracle.xql,v diff -u -r1.5 -r1.6 --- openacs-4/packages/news/www/admin/revision-add-oracle.xql 22 Dec 2009 22:24:02 -0000 1.5 +++ openacs-4/packages/news/www/admin/revision-add-oracle.xql 7 Sep 2013 09:07:45 -0000 1.6 @@ -15,7 +15,7 @@ publish_body, publish_format, publish_date, - NVL(archive_date, sysdate+[ad_parameter ActiveDays "news" 14]) as archive_date, + NVL(archive_date, sysdate+[parameter::get -parameter ActiveDays -default 14]) as archive_date, status from news_item_full_active Index: openacs-4/packages/news/www/admin/revision-add-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/news/www/admin/Attic/revision-add-postgresql.xql,v diff -u -r1.5 -r1.6 --- openacs-4/packages/news/www/admin/revision-add-postgresql.xql 22 Dec 2009 22:24:02 -0000 1.5 +++ openacs-4/packages/news/www/admin/revision-add-postgresql.xql 7 Sep 2013 09:07:45 -0000 1.6 @@ -16,7 +16,7 @@ publish_format, to_char(publish_date, 'YYYY-MM-DD') as publish_date, publish_body, - to_char(coalesce(archive_date, current_timestamp + interval '[ad_parameter ActiveDays "news" 14] days'), 'YYYY-MM-DD') as archive_date, + to_char(coalesce(archive_date, current_timestamp + interval '[parameter::get -parameter ActiveDays -default 14] days'), 'YYYY-MM-DD') as archive_date, status from news_item_full_active Index: openacs-4/packages/photo-album/tcl/photo-album-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/photo-album/tcl/photo-album-procs.xql,v diff -u -r1.7 -r1.8 --- openacs-4/packages/photo-album/tcl/photo-album-procs.xql 8 Aug 2006 21:27:08 -0000 1.7 +++ openacs-4/packages/photo-album/tcl/photo-album-procs.xql 7 Sep 2013 09:11:03 -0000 1.8 @@ -27,7 +27,7 @@ select - ceil(count(*) / [ad_parameter ThumbnailsPerPage]) + ceil(count(*) / [parameter::get -parameter ThumbnailsPerPage]) from ($sql)