Index: openacs-4/packages/calendar/www/admin/index-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/www/admin/index-oracle.xql,v diff -u -N --- openacs-4/packages/calendar/www/admin/index-oracle.xql 5 Sep 2001 05:48:18 -0000 1.1 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,24 +0,0 @@ - - - - oracle8.1.6 - - - - - select calendar_id, - calendar_name - from calendars - where owner_id = :user_id - and acs_permission.permission_p( - calendar_id, - :user_id, - 'calendar_admin' - ) = 't' - order by calendar_name - - - - - - Index: openacs-4/packages/calendar/www/admin/index-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/www/admin/index-postgresql.xql,v diff -u -N --- openacs-4/packages/calendar/www/admin/index-postgresql.xql 5 Sep 2001 05:48:18 -0000 1.1 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,24 +0,0 @@ - - - - postgresql7.1 - - - - - select calendar_id, - calendar_name - from calendars - where owner_id = :user_id - and acs_permission__permission_p( - calendar_id, - :user_id, - 'calendar_admin' - ) = 't' - order by calendar_name - - - - - - Index: openacs-4/packages/calendar/www/cal-options-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/www/cal-options-oracle.xql,v diff -u -N --- openacs-4/packages/calendar/www/cal-options-oracle.xql 10 Jan 2004 18:59:50 -0000 1.2 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,35 +0,0 @@ - - - - oracle8.1.6 - - - - - - select calendar_id, - calendar_name, - ' ' as checked_p - from calendars - where acs_permission.permission_p(calendar_id, :user_id, 'calendar_read') = 't' - and acs_permission.permission_p(calendar_id, :user_id, 'calendar_show') = 't' - and private_p = 'f' - - union - - select calendar_id, - calendar_name, - ' ' as checked_p - from cal_items, calendars - where acs_permission.permission_p(cal_item_id, :user_id, 'cal_item_read') = 't' - and calendar.private_p(on_which_calendar) = 'f' - and calendars.private_p = 'f' - and cal_items.on_which_calendar = calendars.calendar_id - - - - - - - - Index: openacs-4/packages/calendar/www/cal-options-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/www/cal-options-postgresql.xql,v diff -u -N --- openacs-4/packages/calendar/www/cal-options-postgresql.xql 10 Jan 2004 18:59:50 -0000 1.4 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,34 +0,0 @@ - - - - postgresql7.1 - - - - - - select distinct(calendar_id) as calendar_id, - calendar_name, - ' '::varchar as checked_p - from calendars - where acs_permission__permission_p(calendar_id, :user_id, 'calendar_read') = 't' - and acs_permission__permission_p(calendar_id, :user_id, 'calendar_show') = 't' - and private_p = 'f' - - union - - select on_which_calendar as calendar_id, - calendar_name, - ' '::varchar as checked_p - from cal_items, calendars - where acs_permission__permission_p(cal_item_id, :user_id, 'cal_item_read') = 't' - and calendars.private_p = 'f' - and cal_items.on_which_calendar = calendars.calendar_id - - - - - - - -