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 @@
<vendor url="http://www.arsdigita.com/">ArsDigita Corporation</vendor>
<description format="text/plain">WAP package allows developers to easily port their existing web service to a WAP-compliant format, or building one from scrach.</description>
- <requires url="acs-kernel" version="4.0"/>
+ <requires url="acs-kernel" version="4.6.2"/>
<requires url="acs-templating" version="4.1"/>
<files>
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 @@
<vendor url="http://www.arsdigita.com/">ArsDigita Corporation</vendor>
<description format="text/html">This package illustrates how to use workflow in a rat-simple ticket-tracker clone. Definitely not a full application, only for training purposes.</description>
- <requires url="acs-kernel" version="4.0"/>
+ <requires url="acs-kernel" version="4.6.2"/>
<requires url="acs-workflow" version="4.0"/>
<files>
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 @@
<!-- No dependency information -->
- <files>
- <file type="data_model" db_type="oracle" path="sql/oracle/user-preferences-core-create.sql"/>
- <file type="data_model" db_type="oracle" path="sql/oracle/user-preferences-core-drop.sql"/>
- <file type="data_model_create" db_type="oracle" path="sql/oracle/user-preferences-create.sql"/>
- <file type="data_model" db_type="oracle" path="sql/oracle/user-preferences-package-create.sql"/>
- <file type="query_file" db_type="oracle" path="tcl/preference-procs-oracle.xql"/>
- <file type="query_file" db_type="postgresql" path="tcl/preference-procs-postgresql.xql"/>
- <file type="tcl_procs" path="tcl/preference-procs.tcl"/>
- <file type="query_file" path="tcl/preference-procs.xql"/>
- <file type="tcl_procs" path="tcl/preference-types-procs.tcl"/>
- <file type="package_spec" path="user-preferences.info"/>
- </files>
<parameters>
<!-- No version parameters -->
</parameters>
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 @@
<vendor url="http://www.arsdigita.com/">ArsDigita Corporation</vendor>
<provides url="version-control" version="4.0d"/>
- <requires url="acs-kernel" version="4.0"/>
+ <requires url="acs-kernel" version="4.6.2"/>
<files>
<file type="tcl_procs" path="tcl/version-control-procs.tcl"/>
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 @@
<vendor url="http://www.arsdigita.com">ArsDigita Corporation</vendor>
<description format="text/html">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.</description>
- <requires url="acs-kernel" version="4.0"/>
+ <requires url="acs-kernel" version="4.6.2"/>
<files>
<file type="java_code" path="java/BlobDataSource.java"/>