Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/oracle/ticket-tracker-lite-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/oracle/ticket-tracker-lite-drop.sql,v diff -u -r1.1 -r1.2 --- openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/oracle/ticket-tracker-lite-drop.sql 20 Apr 2001 20:51:23 -0000 1.1 +++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/oracle/ticket-tracker-lite-drop.sql 17 May 2003 12:35:18 -0000 1.2 @@ -5,6 +5,14 @@ -- --------------------------------------------------- +drop view ttl_v_areas; +drop view ttl_va_areas; +drop view ttl_v_tickets; +drop view ttl_va_tickets; +drop view ttl_va_comments; +drop view ttl_v_comments_latest; +drop view ttl_v_users; + drop table ttl_prefs; drop table ttl_area_assignments; drop table ttl_assignments; @@ -13,6 +21,9 @@ drop table ttl_status; drop table ttl_areas; +drop function ttl_relative_date; +drop function ttl_top_privilege_for_object; + delete from acs_permissions where object_id in (select package_id from apm_packages Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/postgresql/ticket-tracker-lite-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/postgresql/ticket-tracker-lite-create.sql,v diff -u -r1.2 -r1.3 --- openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/postgresql/ticket-tracker-lite-create.sql 13 Aug 2001 21:32:05 -0000 1.2 +++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/postgresql/ticket-tracker-lite-create.sql 17 May 2003 12:36:31 -0000 1.3 @@ -89,7 +89,7 @@ constraint ttl_tickets_status_fk references ttl_status, url varchar(400), - deadline timestamp, + deadline timestamptz, message text, message_format varchar(10) default 'formatted' constraint ttl_tickets_message_format_ck @@ -112,7 +112,7 @@ references users constraint ttl_comments_user_nn not null, - creation_date timestamp default current_timestamp, + creation_date timestamptz default current_timestamp, message text, message_format varchar(10) default 'formatted' constraint ttl_comments_message_format_ck @@ -128,7 +128,7 @@ references users, constraint ttl_assignments_pk primary key(ticket_id, user_id), - date_assigned timestamp default current_timestamp + date_assigned timestamptz default current_timestamp ); create table ttl_area_assignments ( @@ -140,7 +140,7 @@ references users, constraint ttl_area_assignments_pk primary key(area_id, user_id), - date_assigned timestamp default current_timestamp + date_assigned timestamptz default current_timestamp ); create table ttl_prefs ( Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/postgresql/ticket-tracker-lite-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/postgresql/ticket-tracker-lite-drop.sql,v diff -u -r1.1 -r1.2 --- openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/postgresql/ticket-tracker-lite-drop.sql 28 May 2001 20:41:57 -0000 1.1 +++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/postgresql/ticket-tracker-lite-drop.sql 17 May 2003 12:36:31 -0000 1.2 @@ -14,7 +14,7 @@ drop view ttl_v_comments_latest; drop view ttl_v_users; -drop function ttl_relative_date (timestamp); +drop function ttl_relative_date (timestamptz); drop function ttl_top_privilege_for_object (integer, integer); drop table ttl_prefs; Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/postgresql/views-and-plsql.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/postgresql/views-and-plsql.sql,v diff -u -r1.6 -r1.7 --- openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/postgresql/views-and-plsql.sql 19 Mar 2002 06:49:29 -0000 1.6 +++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/postgresql/views-and-plsql.sql 17 May 2003 12:36:31 -0000 1.7 @@ -56,7 +56,7 @@ -- if the date is today, show just the time. Otherwise -- return the date. -- -create function ttl_relative_date (timestamp) +create function ttl_relative_date (timestamptz) returns varchar as ' declare relative_date alias for $1; Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/ticket-add-2.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/ticket-add-2.tcl,v diff -u -r1.4 -r1.5 --- openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/ticket-add-2.tcl 1 Mar 2002 19:47:15 -0000 1.4 +++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/ticket-add-2.tcl 17 May 2003 12:37:53 -0000 1.5 @@ -72,12 +72,25 @@ and p1.person_id = :caller_id } - ns_sendmail "[join $people_to_email ,]" $ticket_creator_email $name " -Ticket added by $ticket_creator_name in '$area_name' + set recipients "[join $people_to_email ,]" -$message + set notif_message "Ticket added by $ticket_creator_name in '$area_name' -[util_current_location][ad_conn package_url]ticket?ticket_id=$ticket_id" + $message + + [util_current_location][ad_conn package_url]ticket?ticket_id=$ticket_id" + + + if { [catch {ns_sendmail \ + $recipients \ + $ticket_creator_email \ + $name \ + $notif_message } errmsg ] } { + ad_return_error \ + "Email failed" \ + "ticket-tracker-lite - ticket-add-2.tcl: \n + The email could not be sent. Error was : $errmsg" + } } ad_returnredirect ticket?ticket_id=$ticket_id Index: openacs-4/contrib/obsolete-packages/wap/wap.info =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/wap/wap.info,v diff -u -r1.4 -r1.5 --- openacs-4/contrib/obsolete-packages/wap/wap.info 23 Sep 2002 23:32:37 -0000 1.4 +++ openacs-4/contrib/obsolete-packages/wap/wap.info 17 May 2003 12:41:47 -0000 1.5 @@ -16,7 +16,7 @@ ArsDigita Corporation WAP package allows developers to easily port their existing web service to a WAP-compliant format, or building one from scrach. - + Index: openacs-4/contrib/obsolete-packages/wap/sql/postgresql/wap-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/wap/sql/postgresql/wap-create.sql,v diff -u -r1.1 -r1.2 --- openacs-4/contrib/obsolete-packages/wap/sql/postgresql/wap-create.sql 9 May 2001 18:54:48 -0000 1.1 +++ openacs-4/contrib/obsolete-packages/wap/sql/postgresql/wap-create.sql 17 May 2003 12:42:42 -0000 1.2 @@ -25,7 +25,7 @@ select acs_attribute__create_attribute ( 'wap_user_agent', -- object_type 'NAME', -- attribute_name - 'string' -- datatype + 'string', -- datatype 'Name', -- pretty_name 'Names', -- pretty_plural null, -- table_name default null @@ -41,7 +41,7 @@ select acs_attribute__create_attribute ( 'wap_user_agent', -- object_type 'CREATION_COMMENT', -- attribute_name - 'string' -- datatype + 'string', -- datatype 'Comment', -- pretty_name 'Comments', -- pretty_plural null, -- table_name default null @@ -56,8 +56,8 @@ select acs_attribute__create_attribute ( 'wap_user_agent', -- object_type - 'string' -- datatype 'ACTIVE_P', -- attribute_name + 'string', -- datatype 'Active Status', -- pretty_name 'Active Status', -- pretty_plural null, -- table_name default null @@ -99,7 +99,7 @@ new_id := acs_object__new ( v_user_agent_id, -- object_id ''wap_user_agent'', -- object_type - current_time, -- creation_date + current_timestamp, -- creation_date v_creation_user, -- creation_user v_creation_ip, -- creation_ip null -- context_id Index: openacs-4/contrib/obsolete-packages/wf-ticket-tracker/wf-ticket-tracker.info =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/wf-ticket-tracker/wf-ticket-tracker.info,v diff -u -r1.3 -r1.4 --- openacs-4/contrib/obsolete-packages/wf-ticket-tracker/wf-ticket-tracker.info 4 May 2001 22:22:24 -0000 1.3 +++ openacs-4/contrib/obsolete-packages/wf-ticket-tracker/wf-ticket-tracker.info 17 May 2003 12:44:56 -0000 1.4 @@ -17,7 +17,7 @@ ArsDigita Corporation This package illustrates how to use workflow in a rat-simple ticket-tracker clone. Definitely not a full application, only for training purposes. - + Index: openacs-4/packages/user-preferences/user-preferences.info =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/user-preferences/user-preferences.info,v diff -u -r1.2 -r1.3 --- openacs-4/packages/user-preferences/user-preferences.info 23 Sep 2002 23:32:36 -0000 1.2 +++ openacs-4/packages/user-preferences/user-preferences.info 17 May 2003 12:39:24 -0000 1.3 @@ -16,18 +16,6 @@ - - - - - - - - - - - - Index: openacs-4/packages/version-control/version-control.info =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/version-control/version-control.info,v diff -u -r1.3 -r1.4 --- openacs-4/packages/version-control/version-control.info 18 Oct 2001 22:09:22 -0000 1.3 +++ openacs-4/packages/version-control/version-control.info 17 May 2003 12:40:49 -0000 1.4 @@ -18,7 +18,7 @@ ArsDigita Corporation - + Index: openacs-4/packages/webmail/webmail.info =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/webmail/webmail.info,v diff -u -r1.2 -r1.3 --- openacs-4/packages/webmail/webmail.info 9 Mar 2002 02:00:02 -0000 1.2 +++ openacs-4/packages/webmail/webmail.info 17 May 2003 12:43:52 -0000 1.3 @@ -16,7 +16,7 @@ ArsDigita Corporation Provides a web-based email service for ACS 4.x. Please follow the installation instructions in /webmail/www/doc/ that are provided with the package. - +