Fisheye: Tag 1.3 refers to a dead (removed) revision in file `openacs-4/packages/calendar/tcl/calendar-procs-oracle.xql'. Fisheye: No comparison available. Pass `N' to diff? Index: openacs-4/packages/calendar/tcl/calendar-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/tcl/calendar-procs-postgresql.xql,v diff -u -r1.6 -r1.7 --- openacs-4/packages/calendar/tcl/calendar-procs-postgresql.xql 9 Jan 2004 20:36:13 -0000 1.6 +++ openacs-4/packages/calendar/tcl/calendar-procs-postgresql.xql 9 Jan 2004 21:02:50 -0000 1.7 @@ -1,95 +1,56 @@ - postgresql7.1 +postgresql7.1 - - select calendar__new( - null, - :calendar_name, - 'calendar', - :owner_id, - :private_p, - :package_id, - null, - now(), - :creation_user, - :creation_ip - ); - + + select calendar__new( + null, + :calendar_name, + 'calendar', + :owner_id, + :private_p, + :package_id, + null, + now(), + :creation_user, + :creation_ip + ); + - - - - select acs__magic_object_id('the_public') - as party_id - from dual - - + + + select calendar__name(:calendar_id) + from dual + - - - - - select acs_object__name(:private_id) - from dual - - + + + select calendar_name, + calendar_id, + acs_permission__permission_p(calendar_id, :user_id, 'calendar_admin') as calendar_admin_p + from calendars + where (private_p = 'f' and package_id = :package_id $permissions_clause) or + (private_p = 't' and owner_id = :user_id) + order by private_p asc, upper(calendar_name) + - - - - - select calendar__name(:calendar_id) - from dual - - - + + + and acs_permission__permission_p(calendar_id, :user_id, :privilege) = 't' + + - - - - - select acs_permission__permission_p( - :calendar_id, - acs__magic_object_id('the_public'), - 'calendar_read' - ) - from dual - - - + + + select calendar__delete(:calendar_id) + - - - - select calendar_name, - calendar_id, - acs_permission__permission_p(calendar_id, :user_id, 'calendar_admin') as calendar_admin_p - from calendars - where (private_p = 'f' and package_id = :package_id $permissions_clause) or - (private_p = 't' and owner_id = :user_id) - order by private_p asc, upper(calendar_name) - - - - - - and acs_permission__permission_p(calendar_id, :user_id, :privilege) = 't' - - - - - - select calendar__delete(:calendar_id) - - - Index: openacs-4/packages/calendar/tcl/calendar-procs.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/tcl/calendar-procs.tcl,v diff -u -r1.18 -r1.19 --- openacs-4/packages/calendar/tcl/calendar-procs.tcl 9 Jan 2004 20:36:13 -0000 1.18 +++ openacs-4/packages/calendar/tcl/calendar-procs.tcl 9 Jan 2004 21:02:50 -0000 1.19 @@ -12,7 +12,9 @@ } +namespace eval calendar {} + #------------------------------------------------ # datetime info extraction @@ -183,12 +185,7 @@ if { [string equal $cal_privilege "public"] } { - db_1row get_magic_id { - select acs.magic_object_id('the_public') - as party_id - from dual - } - + set party_id [acs_magic_object "the_public"] set cal_privilege "calendar_read" } elseif { [string equal $cal_privilege "private"] } { set cal_privilege "calendar_read" @@ -247,8 +244,6 @@ } -namespace eval calendar {} - ad_proc -public calendar::get_month_multirow_information { {-current_day:required} {-today_julian_date:required}