HTML attributes, including JavaScript event handlers, may be
specified as attributes to the formtemplate tag. The system
Index: openacs-4/packages/address-book/address-book.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/address-book/address-book.info,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/address-book/address-book.info 9 Mar 2002 02:00:02 -0000 1.5
+++ openacs-4/packages/address-book/address-book.info 17 May 2003 10:09:53 -0000 1.6
@@ -17,7 +17,7 @@
The Address Book is an application/service hybrid. As an application, it provides a complete UI for storing, retrieving and searching for individually permissioned contacts. As a service, Address Book provides a storage mechanism for contact information and associating it with other objects. Each contact has identity info as well as an arbitrary number of custom attributes (which may be used for phone numbers, email addresses, etc.) and an arbitrary number of street addresses.
-
+
Index: openacs-4/packages/address-book/sql/postgresql/address-book-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/address-book/sql/postgresql/address-book-create.sql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/address-book/sql/postgresql/address-book-create.sql 2 Sep 2001 17:06:29 -0000 1.4
+++ openacs-4/packages/address-book/sql/postgresql/address-book-create.sql 17 May 2003 10:10:13 -0000 1.5
@@ -154,7 +154,7 @@
-- type_key
integer, -- ab_contact_attr_types.type_id%TYPE
varchar, -- acs_objects.object_type%TYPE
- timestamp, -- acs_objects.creation_date%TYPE
+ timestamptz, -- acs_objects.creation_date%TYPE
integer, -- acs_objects.creation_user%TYPE
varchar, -- acs_objects.creation_ip%TYPE
integer, -- acs_objects.context_id%TYPE
@@ -356,7 +356,7 @@
-- before_attr_id in ab_contact_attrs.attr_id%TYPE
integer, -- ab_contact_attrs.attr_id%TYPE
varchar, -- acs_objects.object_type%TYPE
- timestamp, -- acs_objects.creation_date%TYPE
+ timestamptz, -- acs_objects.creation_date%TYPE
integer, -- acs_objects.creation_user%TYPE
varchar, -- acs_objects.creation_ip%TYPE
integer, -- acs_objects.context_id%TYPE
@@ -596,7 +596,7 @@
-- category
integer, -- ab_contacts.contact_id%TYPE default null,
varchar, -- acs_objects.object_type%TYPE
- timestamp, -- acs_objects.creation_date%TYPE
+ timestamptz, -- acs_objects.creation_date%TYPE
integer, -- acs_objects.creation_user%TYPE
varchar, -- acs_objects.creation_ip%TYPE
integer, -- acs_objects.context_id%TYPE
Index: openacs-4/packages/address-book/sql/postgresql/address-book-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/address-book/sql/postgresql/address-book-drop.sql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/address-book/sql/postgresql/address-book-drop.sql 29 Aug 2001 00:52:20 -0000 1.3
+++ openacs-4/packages/address-book/sql/postgresql/address-book-drop.sql 17 May 2003 10:10:13 -0000 1.4
@@ -19,7 +19,7 @@
drop function ab_contact_attr_type__new(
integer,
varchar,
- timestamp,
+ timestamptz,
integer,
varchar,
integer,
@@ -30,7 +30,7 @@
drop function ab_contact_attr__new (
integer,
varchar,
- timestamp,
+ timestamptz,
integer,
varchar,
integer,
@@ -54,7 +54,7 @@
drop function ab_contact_rel__delete(integer);
drop function ab_contact_rel__new(integer,integer,integer,integer,varchar,varchar,varchar);
-drop function ab_contact__new( integer,varchar,timestamp,integer,varchar,integer,varchar,varchar,varchar,varchar,integer,varchar);
+drop function ab_contact__new( integer,varchar,timestamptz,integer,varchar,integer,varchar,varchar,varchar,varchar,integer,varchar);
drop function ab_contact__name( integer);
drop function ab_contact__delete(integer, boolean);
Index: openacs-4/packages/adserver/adserver.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/adserver/adserver.info,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/adserver/adserver.info 16 Jan 2003 13:42:37 -0000 1.4
+++ openacs-4/packages/adserver/adserver.info 17 May 2003 10:10:43 -0000 1.5
@@ -19,7 +19,7 @@
furfly.net, LLC
-
+
Index: openacs-4/packages/adserver/www/admin/add-adv-2.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/adserver/www/admin/add-adv-2.tcl,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/adserver/www/admin/add-adv-2.tcl 18 Sep 2002 12:11:29 -0000 1.3
+++ openacs-4/packages/adserver/www/admin/add-adv-2.tcl 17 May 2003 10:11:05 -0000 1.4
@@ -19,7 +19,7 @@
@cvs-id $Id$
} {
adv_key:notnull
- target_url:html
+ target_url:allhtml
local_image_p
track_clickthru_p
adv_filename
Index: openacs-4/packages/attachments/attachments.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/attachments/attachments.info,v
diff -u -r1.9 -r1.10
--- openacs-4/packages/attachments/attachments.info 29 Jan 2003 16:12:35 -0000 1.9
+++ openacs-4/packages/attachments/attachments.info 17 May 2003 10:11:20 -0000 1.10
@@ -8,7 +8,7 @@
t
attachments
-
+
oracle
postgresql
@@ -19,46 +19,9 @@
OpenForce, Inc.
Attachments
-
-
+
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Index: openacs-4/packages/attachments/sql/oracle/attachments-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/attachments/sql/oracle/attachments-create.sql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/attachments/sql/oracle/attachments-create.sql 30 Aug 2002 14:44:06 -0000 1.4
+++ openacs-4/packages/attachments/sql/oracle/attachments-create.sql 17 May 2003 10:11:35 -0000 1.5
@@ -30,6 +30,9 @@
primary key (package_id, folder_id)
);
+--RI Indexes
+create index attachments_fsr_fm_folder_id_i ON attachments_fs_root_folder_map(folder_id);
+
create table attachments (
object_id constraint attachments_object_id_fk
references acs_objects (object_id)
@@ -46,3 +49,7 @@
constraint attachments_pk
primary key (object_id, item_id)
);
+
+--RI Indexes
+create index attachments_item_id_idx ON attachments(item_id);
+
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/attachments/sql/oracle/upgrade/upgrade-0.3-0.4.sql'.
Fisheye: No comparison available. Pass `N' to diff?
Index: openacs-4/packages/attachments/sql/postgresql/attachments-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/attachments/sql/postgresql/attachments-create.sql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/attachments/sql/postgresql/attachments-create.sql 30 Aug 2002 14:44:08 -0000 1.3
+++ openacs-4/packages/attachments/sql/postgresql/attachments-create.sql 17 May 2003 10:12:03 -0000 1.4
@@ -32,6 +32,9 @@
primary key (package_id, folder_id)
);
+-- RI Indexes
+create index attachments_fsr_fm_folder_id_i ON attachments_fs_root_folder_map(folder_id);
+
create table attachments (
object_id integer
constraint attachments_object_id_fk
@@ -50,3 +53,6 @@
constraint attachments_pk
primary key (object_id, item_id)
);
+
+-- RI Indexes
+create index attachments_item_id_idx ON attachments(item_id);
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/attachments/sql/postgresql/upgrade/upgrade-0.3-0.4.sql'.
Fisheye: No comparison available. Pass `N' to diff?
Index: openacs-4/packages/attachments/www/file-add-2.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/attachments/www/file-add-2.tcl,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/attachments/www/file-add-2.tcl 7 Nov 2002 15:11:50 -0000 1.3
+++ openacs-4/packages/attachments/www/file-add-2.tcl 17 May 2003 10:13:01 -0000 1.4
@@ -45,10 +45,7 @@
# Get the ip
set creation_ip [ad_conn peeraddr]
-# The content repository is kinda stupid about mime types,
-# so we have to check if we know about this one and possibly
-# add it.
-set mime_type [fs_maybe_create_new_mime_type $upload_file]
+set mime_type [cr_filename_to_mime_type -create $upload_file]
# Get the storage type
set indb_p [ad_parameter "StoreFilesInDatabaseP" -package_id [ad_conn package_id]]
Index: openacs-4/packages/attachments/www/go-to-attachment.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/attachments/www/go-to-attachment.tcl,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/attachments/www/go-to-attachment.tcl 16 Jan 2003 13:43:15 -0000 1.4
+++ openacs-4/packages/attachments/www/go-to-attachment.tcl 17 May 2003 10:13:01 -0000 1.5
@@ -18,9 +18,8 @@
}
switch $object_type {
- fs_url {
- set url [db_string select_url {}]
- ad_returnredirect $url
+ content_extlink {
+ ad_returnredirect [db_string select_url {}]
ad_script_abort
return
}
Index: openacs-4/packages/attachments/www/go-to-attachment.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/attachments/www/go-to-attachment.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/attachments/www/go-to-attachment.xql 16 Jan 2003 13:43:15 -0000 1.2
+++ openacs-4/packages/attachments/www/go-to-attachment.xql 17 May 2003 10:13:02 -0000 1.3
@@ -2,25 +2,22 @@
-
-select
-object_type
-from attachments, acs_objects
-where
-attachments.object_id = :object_id and
-attachments.item_id = :attachment_id and
-attachments.item_id = acs_objects.object_id
-
+
+ select object_type
+ from attachments, acs_objects
+ where
+ attachments.object_id = :object_id and
+ attachments.item_id = :attachment_id and
+ attachments.item_id = acs_objects.object_id
+
-
-select
-url
-from fs_urls
-where
-url_id = :attachment_id
-
+
+ select url
+ from cr_extlinks
+ where extlink_id = :attachment_id
+
Index: openacs-4/packages/attachments/www/simple-add-2.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/attachments/www/simple-add-2.tcl,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/attachments/www/simple-add-2.tcl 7 Nov 2002 15:11:50 -0000 1.2
+++ openacs-4/packages/attachments/www/simple-add-2.tcl 17 May 2003 10:13:02 -0000 1.3
@@ -24,11 +24,11 @@
ad_require_permission $folder_id write
db_transaction {
- # Create the URL (for now)
- set url_id [fs::url_new -url $url -name $title -description $description -folder_id $folder_id]
- # Attach the URL
- attachments::attach -object_id $object_id -attachment_id $url_id
+ # Create and attach the URL
+ attachments::attach -object_id $object_id \
+ -attachment_id [content_simple::new -url $url -label $title -description $description -parent_id $folder_id]
+
}
ad_returnredirect "$return_url"
Index: openacs-4/packages/attachments/www/simple-add.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/attachments/www/simple-add.tcl,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/attachments/www/simple-add.tcl 10 Nov 2002 16:13:21 -0000 1.6
+++ openacs-4/packages/attachments/www/simple-add.tcl 17 May 2003 10:13:02 -0000 1.7
@@ -41,7 +41,6 @@
# Should probably generate the item_id and version_id now for
# double-click protection
-
# if title isn't passed in ignore lock_title_p
if {[empty_string_p $title]} {
set lock_title_p 0
Index: openacs-4/packages/authorize-gateway/sql/postgresql/authorize-gateway-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/authorize-gateway/sql/postgresql/authorize-gateway-create.sql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/authorize-gateway/sql/postgresql/authorize-gateway-create.sql 26 Sep 2002 22:42:13 -0000 1.2
+++ openacs-4/packages/authorize-gateway/sql/postgresql/authorize-gateway-create.sql 17 May 2003 10:13:24 -0000 1.3
@@ -1,7 +1,7 @@
create table authorize_gateway_result_log (
transaction_id varchar(20) not null,
txn_attempted_type varchar(18),
- txn_attempted_time datetime,
+ txn_attempted_time timestamptz,
response varchar(400),
response_code varchar(1),
response_reason_code varchar(2),