Index: openacs-4/packages/edit-this-page/www/etp-edit-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/edit-this-page/www/etp-edit-postgresql.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/edit-this-page/www/etp-edit-postgresql.xql 2 Nov 2001 01:51:24 -0000 1.1 @@ -0,0 +1,28 @@ + + + postgresql7.1 + + + + select $attribute as value, r.title as page_title + from cr_revisions r, cr_items i + where i.parent_id = etp__get_folder_id(:package_id) + and i.name = :name + and i.item_id = r.item_id + and r.revision_id = :revision_id + + + + + + select etp_get_attribute_value(r.revision_id, :attribute_id) as value, + r.title as page_title + from cr_items i, cr_revisions r + where i.parent_id = etp__get_folder_id(:package_id) + and i.name = :name + and i.item_id = r.item_id + and r.revision_id = :revision_id + + + + Index: openacs-4/packages/edit-this-page/www/etp-extlink-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/edit-this-page/www/etp-extlink-postgresql.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/edit-this-page/www/etp-extlink-postgresql.xql 2 Nov 2001 01:52:37 -0000 1.1 @@ -0,0 +1,11 @@ + + + postgresql7.1 + + + + select etp__create_extlink(:package_id, :url, :label, :description); + + + + Index: openacs-4/packages/edit-this-page/www/etp-publish-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/edit-this-page/www/etp-publish-postgresql.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/edit-this-page/www/etp-publish-postgresql.xql 2 Nov 2001 01:53:33 -0000 1.1 @@ -0,0 +1,23 @@ + + + postgresql7.1 + + + +update cr_revisions +set publish_date = now() +where revision_id = :latest_revision_id + + + + + +update acs_objects +set modifying_user = :user_id, + last_modified = now() +where object_id = :latest_revision_id + + + + + Index: openacs-4/packages/edit-this-page/www/etp-symlink-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/edit-this-page/www/etp-symlink-postgresql.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/edit-this-page/www/etp-symlink-postgresql.xql 2 Nov 2001 01:55:12 -0000 1.1 @@ -0,0 +1,26 @@ + + + postgresql7.1 + + + + select etp__create_symlink(:package_id, :target_id); + + + + + + select i.item_id, i.name, etp__get_title(i.item_id, null) as title, + repeat(' ',(tree_level(i.tree_sortkey) - 1) * 4) as indent + from cr_items i, acs_objects o + where i.item_id = o.object_id + and o.object_type in ('content_item', 'content_folder') + and i.name != 'index' + and i.tree_sortkey not like (select tree_sortkey + from cr_items + where item_id = -400) || '%' + order by i.tree_sortkey + + + +