Index: openacs-4/packages/calendar/tcl/calendar-callback-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/tcl/calendar-callback-procs.xql,v diff -u -N --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/calendar/tcl/calendar-callback-procs.xql 19 Jul 2005 16:49:36 -0000 1.1.2.1 @@ -0,0 +1,64 @@ + + + + + + select calendar_name + from calendars + where owner_id = :user_id + + + + + + select calendar_id,package_id + from calendars + where owner_id = :from_user_id + + + + + + select count(*) + from calendars + where owner_id = :to_user_id + and package_id = :l_pkg_id + + + + + + update calendars + set owner_id = :to_user_id + where owner_id = :from_user_id + and calendar_id = :l_cal_id + + + + + + select calendar_id + from calendars + where package_id = :l_pkg_id + and owner_id = :to_user_id + + + + + + update cal_items + set on_which_calendar = :to_cal_id + where on_which_calendar = :l_cal_id + + + + + + delete + from calendars + where calendar_id = :l_cal_id + + + + +