Index: openacs-4/packages/acs-kernel/acs-kernel.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/acs-kernel.info,v
diff -u -r1.49.2.1 -r1.49.2.2
--- openacs-4/packages/acs-kernel/acs-kernel.info 20 Nov 2003 16:32:31 -0000 1.49.2.1
+++ openacs-4/packages/acs-kernel/acs-kernel.info 20 Nov 2003 21:24:02 -0000 1.49.2.2
@@ -7,13 +7,13 @@
t
t
-
+
Don Baccus
Routines and data models providing the foundation for OpenACS-based Web services.
2003-11-07
OpenACS
-
+
Index: openacs-4/packages/acs-kernel/sql/oracle/acs-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/acs-create.sql,v
diff -u -r1.10 -r1.10.2.1
--- openacs-4/packages/acs-kernel/sql/oracle/acs-create.sql 16 Oct 2003 23:56:01 -0000 1.10
+++ openacs-4/packages/acs-kernel/sql/oracle/acs-create.sql 20 Nov 2003 21:24:02 -0000 1.10.2.1
@@ -175,7 +175,7 @@
-- faster simpler view
-- does not check for registered user/banned etc
-create view all_users
+create or replace view acs_users_all
as
select pa.*, pe.*, u.*
from parties pa, persons pe, users u
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-kernel/sql/oracle/upgrade/updgrade-5.0.0b2-5.0.0b3.sql'.
Fisheye: No comparison available. Pass `N' to diff?
Index: openacs-4/packages/acs-kernel/sql/postgresql/acs-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/acs-create.sql,v
diff -u -r1.22 -r1.22.2.1
--- openacs-4/packages/acs-kernel/sql/postgresql/acs-create.sql 6 Oct 2003 13:16:11 -0000 1.22
+++ openacs-4/packages/acs-kernel/sql/postgresql/acs-create.sql 20 Nov 2003 21:24:03 -0000 1.22.2.1
@@ -159,7 +159,7 @@
-- faster simpler view
-- does not check for registered user/banned etc
-create view all_users
+create or replace view acs_users_all
as
select pa.*, pe.*, u.*
from parties pa, persons pe, users u
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-kernel/sql/postgresql/upgrade/updgrade-5.0.0b2-5.0.0b3.sql'.
Fisheye: No comparison available. Pass `N' to diff?
Index: openacs-4/packages/lars-blogger/www/drafts.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/www/drafts.xql,v
diff -u -r1.3 -r1.3.2.1
--- openacs-4/packages/lars-blogger/www/drafts.xql 16 Oct 2003 23:10:45 -0000 1.3
+++ openacs-4/packages/lars-blogger/www/drafts.xql 20 Nov 2003 21:24:03 -0000 1.3.2.1
@@ -13,7 +13,7 @@
u.last_name
from pinds_blog_entries e,
acs_objects o,
- all_users u
+ acs_users_all u
where e.package_id = :package_id
and e.draft_p = 't'
and e.deleted_p = 'f'
@@ -35,7 +35,7 @@
u.last_name
from pinds_blog_entries e,
acs_objects o,
- all_users u
+ acs_users_all u
where e.package_id = :package_id
and e.draft_p = 't'
and e.deleted_p = 'f'
Index: openacs-4/packages/logger/www/lib/entries-table-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/logger/www/lib/Attic/entries-table-oracle.xql,v
diff -u -r1.3 -r1.3.2.1
--- openacs-4/packages/logger/www/lib/entries-table-oracle.xql 9 Nov 2003 16:40:26 -0000 1.3
+++ openacs-4/packages/logger/www/lib/entries-table-oracle.xql 20 Nov 2003 21:24:03 -0000 1.3.2.1
@@ -19,7 +19,7 @@
from logger_entries le,
logger_projects lp,
acs_objects ao,
- all_users submitter
+ acs_users_all submitter
where le.project_id = lp.project_id
and ao.object_id = le.entry_id
and ao.creation_user = submitter.user_id
Index: openacs-4/packages/logger/www/lib/entries-table-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/logger/www/lib/Attic/entries-table-postgresql.xql,v
diff -u -r1.3 -r1.3.2.1
--- openacs-4/packages/logger/www/lib/entries-table-postgresql.xql 9 Nov 2003 16:40:26 -0000 1.3
+++ openacs-4/packages/logger/www/lib/entries-table-postgresql.xql 20 Nov 2003 21:24:03 -0000 1.3.2.1
@@ -19,7 +19,7 @@
from logger_entries le,
logger_projects lp,
acs_objects ao,
- all_users submitter
+ acs_users_all submitter
where le.project_id = lp.project_id
and ao.object_id = le.entry_id
and ao.creation_user = submitter.user_id
Index: openacs-4/packages/weblogger-portlet/www/weblogger-portlet-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/weblogger-portlet/www/weblogger-portlet-oracle.xql,v
diff -u -r1.3 -r1.3.2.1
--- openacs-4/packages/weblogger-portlet/www/weblogger-portlet-oracle.xql 17 Oct 2003 00:39:55 -0000 1.3
+++ openacs-4/packages/weblogger-portlet/www/weblogger-portlet-oracle.xql 20 Nov 2003 21:24:04 -0000 1.3.2.1
@@ -19,7 +19,7 @@
from apm_packages p,
pinds_blog_entries e,
acs_objects o,
- all_users u
+ acs_users_all u
where p.package_id in ([join $list_of_package_ids ", "])
and e.package_id (+) = p.package_id
and o.object_id (+) = e.entry_id
Index: openacs-4/packages/weblogger-portlet/www/weblogger-portlet-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/weblogger-portlet/www/weblogger-portlet-postgresql.xql,v
diff -u -r1.3 -r1.3.2.1
--- openacs-4/packages/weblogger-portlet/www/weblogger-portlet-postgresql.xql 17 Oct 2003 00:39:56 -0000 1.3
+++ openacs-4/packages/weblogger-portlet/www/weblogger-portlet-postgresql.xql 20 Nov 2003 21:24:04 -0000 1.3.2.1
@@ -19,7 +19,7 @@
from apm_packages p left outer join
pinds_blog_entries e on (e.package_id = p.package_id) join
acs_objects o on (o.object_id = e.entry_id) join
- all_users u on (u.user_id = o.creation_user)
+ acs_users_all u on (u.user_id = o.creation_user)
where p.package_id in ([join $list_of_package_ids ", "])
and e.entry_date > current_timestamp - interval '30 days'
and e.draft_p = 'f'