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.6.10.1 -r1.6.10.2 --- openacs-4/packages/attachments/www/go-to-attachment.xql 11 Jul 2019 16:38:53 -0000 1.6.10.1 +++ openacs-4/packages/attachments/www/go-to-attachment.xql 11 Jul 2019 16:41:20 -0000 1.6.10.2 @@ -1,23 +1,28 @@ - - - select url - from cr_extlinks - where extlink_id = :attachment_id - - + + + select url + from cr_extlinks + where extlink_id = :attachment_id + + - - + - select r.title,i.name, o.package_id, m.file_extension - from cr_revisions r, cr_items i, acs_objects o, cr_mime_types m - where i.item_id = :attachment_id - and r.revision_id = i.live_revision - and i.item_id = o.object_id - and m.mime_type = r.mime_type + select r.title, + i.name, + o.package_id, + m.file_extension + from cr_revisions r, + cr_items i, + acs_objects o, + cr_mime_types m + where i.item_id = :attachment_id + and r.revision_id = i.live_revision + and i.item_id = o.object_id + and m.mime_type = r.mime_type Index: openacs-4/packages/attachments/www/download/index.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/attachments/www/download/index.xql,v diff -u -r1.2.26.1 -r1.2.26.2 --- openacs-4/packages/attachments/www/download/index.xql 11 Jul 2019 16:38:54 -0000 1.2.26.1 +++ openacs-4/packages/attachments/www/download/index.xql 11 Jul 2019 16:41:20 -0000 1.2.26.2 @@ -1,7 +1,7 @@ - - + + select live_revision from cr_items, attachments