Index: openacs-4/packages/wp-slim/www/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/wp-slim/www/index-postgresql.xql,v
diff -u -N -r1.4 -r1.5
--- openacs-4/packages/wp-slim/www/index-postgresql.xql 22 Sep 2003 18:41:27 -0000 1.4
+++ openacs-4/packages/wp-slim/www/index-postgresql.xql 5 Jul 2016 17:10:20 -0000 1.5
@@ -56,11 +56,7 @@
and ao.creation_user = p.person_id
and ao.context_id = :package_id
$extra_where_clauses
- and exists (select 1
- from acs_object_party_privilege_map m
- where m.object_id = i.item_id
- and m.party_id = :user_id
- and m.privilege = 'wp_view_presentation')
+ and acs_permission__permission_p(i.item_id, :user_id, 'wp_view_presentation')
Index: openacs-4/packages/lars-blogger/tcl/lars-blogger-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/tcl/lars-blogger-procs-oracle.xql,v
diff -u -N -r1.6 -r1.7
--- openacs-4/packages/lars-blogger/tcl/lars-blogger-procs-oracle.xql 11 Dec 2003 21:40:05 -0000 1.6
+++ openacs-4/packages/lars-blogger/tcl/lars-blogger-procs-oracle.xql 5 Jul 2016 17:19:32 -0000 1.7
@@ -51,4 +51,17 @@
+
+
+
+ select p.package_id
+ from apm_packages p, acs_object_party_privilege_map perm
+ where p.package_key = 'lars-blogger'
+ and p.package_id = perm.object_id
+ and perm.privilege = 'create'
+ and perm.party_id = :user_id
+
+
+
+
Index: openacs-4/packages/lars-blogger/tcl/lars-blogger-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/tcl/lars-blogger-procs-postgresql.xql,v
diff -u -N -r1.7 -r1.8
--- openacs-4/packages/lars-blogger/tcl/lars-blogger-procs-postgresql.xql 11 Dec 2003 21:40:05 -0000 1.7
+++ openacs-4/packages/lars-blogger/tcl/lars-blogger-procs-postgresql.xql 5 Jul 2016 17:19:32 -0000 1.8
@@ -45,4 +45,15 @@
+
+
+
+ select p.package_id
+ from apm_packages p
+ where p.package_key = 'lars-blogger'
+ and acs_permission__permission_p(p.package_id, :user_id, 'create')
+
+
+
+
Index: openacs-4/packages/lars-blogger/tcl/lars-blogger-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/tcl/lars-blogger-procs.xql,v
diff -u -N -r1.10 -r1.11
--- openacs-4/packages/lars-blogger/tcl/lars-blogger-procs.xql 15 Jun 2005 18:41:49 -0000 1.10
+++ openacs-4/packages/lars-blogger/tcl/lars-blogger-procs.xql 5 Jul 2016 17:19:32 -0000 1.11
@@ -65,19 +65,6 @@
-
-
-
- select p.package_id
- from apm_packages p, acs_object_party_privilege_map perm
- where p.package_key = 'lars-blogger'
- and p.package_id = perm.object_id
- and perm.privilege = 'create'
- and perm.party_id = :user_id
-
-
-
-
select count(*)
Index: openacs-4/packages/photo-album/tcl/photo-album-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/photo-album/tcl/photo-album-procs-postgresql.xql,v
diff -u -N -r1.6 -r1.7
--- openacs-4/packages/photo-album/tcl/photo-album-procs-postgresql.xql 8 Aug 2006 21:27:08 -0000 1.6
+++ openacs-4/packages/photo-album/tcl/photo-album-procs-postgresql.xql 5 Jul 2016 17:13:50 -0000 1.7
@@ -196,13 +196,9 @@
where ci.content_type = 'pa_album'
and ci.tree_sortkey between ci2.tree_sortkey and tree_right(ci2.tree_sortkey)
and ci2.item_id = :root_folder_id) ci1
-where ci1.live_revision = cr.revision_id
-and exists (select 1
- from acs_object_party_privilege_map m
- where m.object_id = cr.revision_id
- and m.party_id = :user_id
- and m.privilege = 'read')
- order by cr.title
+ where ci1.live_revision = cr.revision_id
+ and acs_permission__permission_p(cr.revision_id, :user_id, 'read')
+ order by cr.title