Fisheye: Tag 1.2.24.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-tcl/tcl/00-database-procs-postgresql-postgresql.xql'.
Fisheye: No comparison available. Pass `N' to diff?
Fisheye: Tag 1.43.24.2 refers to a dead (removed) revision in file `openacs-4/packages/acs-tcl/tcl/00-database-procs-postgresql.tcl'.
Fisheye: No comparison available. Pass `N' to diff?
Index: openacs-4/packages/acs-tcl/tcl/acs-permissions-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/acs-permissions-procs.xql,v
diff -u -r1.6 -r1.6.4.1
--- openacs-4/packages/acs-tcl/tcl/acs-permissions-procs.xql 2 Apr 2013 11:05:18 -0000 1.6
+++ openacs-4/packages/acs-tcl/tcl/acs-permissions-procs.xql 2 Jan 2016 11:22:34 -0000 1.6.4.1
@@ -2,14 +2,6 @@
<queryset>
- <fullquery name="ad_permission_p.n_privs">
- <querytext>
- select count(*)
- from acs_privileges
- where privilege = :privilege
- </querytext>
- </fullquery>
-
<fullquery name="permission::inherit_p.select_inherit_p">
<querytext>
select case when security_inherit_p = 't' then 1 else 0 end
Index: openacs-4/packages/acs-tcl/tcl/admin-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/admin-procs.xql,v
diff -u -r1.2 -r1.2.30.1
--- openacs-4/packages/acs-tcl/tcl/admin-procs.xql 26 Apr 2001 05:38:54 -0000 1.2
+++ openacs-4/packages/acs-tcl/tcl/admin-procs.xql 2 Jan 2016 11:22:34 -0000 1.2.30.1
@@ -1,16 +1,6 @@
<?xml version="1.0"?>
<queryset>
-<fullquery name="ad_user_class_query.sql_post_select_for_user_class">
- <querytext>
-
- select sql_post_select
- from user_classes
- where user_class_id = [ns_dbquotevalue $user_class_id]
-
- </querytext>
-</fullquery>
-
<fullquery name="ad_user_class_description.category_id">
<querytext>
select category from categories where category_id = :category_id
Index: openacs-4/packages/acs-tcl/tcl/apm-file-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/apm-file-procs-oracle.xql,v
diff -u -r1.7 -r1.7.30.1
--- openacs-4/packages/acs-tcl/tcl/apm-file-procs-oracle.xql 12 May 2001 05:09:48 -0000 1.7
+++ openacs-4/packages/acs-tcl/tcl/apm-file-procs-oracle.xql 2 Jan 2016 11:22:34 -0000 1.7.30.1
@@ -71,35 +71,4 @@
</querytext>
</fullquery>
-<fullquery name="apm_file_add.apm_file_add">
- <querytext>
-
- begin
- :1 := apm_package_version.add_file(
- file_id => :file_id,
- version_id => :version_id,
- path => :path,
- file_type => :file_type,
- db_type => :db_type
- );
- end;
-
- </querytext>
-</fullquery>
-
-
-<fullquery name="apm_file_remove.apm_file_remove">
- <querytext>
-
- begin
- apm_package_version.remove_file(
- path => :path,
- version_id => :version_id
- );
- end;
-
- </querytext>
-</fullquery>
-
-
</queryset>
Index: openacs-4/packages/acs-tcl/tcl/apm-file-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/apm-file-procs-postgresql.xql,v
diff -u -r1.13 -r1.13.30.1
--- openacs-4/packages/acs-tcl/tcl/apm-file-procs-postgresql.xql 31 Oct 2001 20:42:07 -0000 1.13
+++ openacs-4/packages/acs-tcl/tcl/apm-file-procs-postgresql.xql 2 Jan 2016 11:22:35 -0000 1.13.30.1
@@ -93,31 +93,4 @@
</querytext>
</fullquery>
-<fullquery name="apm_file_add.apm_file_add">
- <querytext>
-
- select apm_package_version__add_file(
- :file_id,
- :version_id,
- :path,
- :file_type,
- :db_type
- )
-
- </querytext>
-</fullquery>
-
-
-<fullquery name="apm_file_remove.apm_file_remove">
- <querytext>
-
- select apm_package_version__remove_file(
- :version_id,
- :path
- )
-
- </querytext>
-</fullquery>
-
-
</queryset>
Index: openacs-4/packages/acs-tcl/tcl/apm-install-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/apm-install-procs-oracle.xql,v
diff -u -r1.20 -r1.20.8.1
--- openacs-4/packages/acs-tcl/tcl/apm-install-procs-oracle.xql 31 Mar 2010 18:08:59 -0000 1.20
+++ openacs-4/packages/acs-tcl/tcl/apm-install-procs-oracle.xql 2 Jan 2016 11:22:35 -0000 1.20.8.1
@@ -248,17 +248,6 @@
</querytext>
</fullquery>
-<fullquery name="apm_package_install.version_exists_p">
- <querytext>
-
- select version_id
- from apm_package_versions
- where package_key = :package_key
- and version_id = apm_package.highest_version(:package_key)
-
- </querytext>
-</fullquery>
-
<fullquery name="apm_copy_param_to_descendents.param_exists">
<querytext>
begin
Index: openacs-4/packages/acs-tcl/tcl/apm-install-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/apm-install-procs-postgresql.xql,v
diff -u -r1.20 -r1.20.8.1
--- openacs-4/packages/acs-tcl/tcl/apm-install-procs-postgresql.xql 31 Mar 2010 18:08:59 -0000 1.20
+++ openacs-4/packages/acs-tcl/tcl/apm-install-procs-postgresql.xql 2 Jan 2016 11:22:35 -0000 1.20.8.1
@@ -189,17 +189,6 @@
</querytext>
</fullquery>
-<fullquery name="apm_package_install.version_exists_p">
- <querytext>
-
- select version_id
- from apm_package_versions
- where package_key = :package_key
- and version_id = apm_package__highest_version(:package_key)
-
- </querytext>
-</fullquery>
-
<fullquery name="apm_copy_param_to_descendents.param_exists">
<querytext>
select apm__parameter_p(:descendent_package_key, :parameter_name);
Index: openacs-4/packages/acs-tcl/tcl/community-core-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/community-core-procs-oracle.xql,v
diff -u -r1.18 -r1.18.2.1
--- openacs-4/packages/acs-tcl/tcl/community-core-procs-oracle.xql 27 Oct 2014 16:40:06 -0000 1.18
+++ openacs-4/packages/acs-tcl/tcl/community-core-procs-oracle.xql 2 Jan 2016 11:22:35 -0000 1.18.2.1
@@ -23,18 +23,6 @@
</querytext>
</fullquery>
-<fullquery name="user_search">
- <querytext>
- select distinct u.first_names || ' ' || u.last_name || ' (' || u.email || ')' as name, u.user_id
- from cc_users u
- where lower(nvl(u.first_names || ' ', '') ||
- nvl(u.last_name || ' ', '') ||
- u.email || ' ' ||
- nvl(u.screen_name, '')) like lower('%'||:value||'%')
- order by name
- </querytext>
-</fullquery>
-
<fullquery name="acs_user::get_from_user_id_not_cached.select_user_info">
<querytext>
Index: openacs-4/packages/acs-tcl/tcl/community-core-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/community-core-procs-postgresql.xql,v
diff -u -r1.19 -r1.19.2.1
--- openacs-4/packages/acs-tcl/tcl/community-core-procs-postgresql.xql 27 Oct 2014 16:40:06 -0000 1.19
+++ openacs-4/packages/acs-tcl/tcl/community-core-procs-postgresql.xql 2 Jan 2016 11:22:35 -0000 1.19.2.1
@@ -17,18 +17,6 @@
</querytext>
</fullquery>
-<fullquery name="user_search">
- <querytext>
- select distinct u.first_names || ' ' || u.last_name || ' (' || u.email || ')' as name, u.user_id
- from cc_users u
- where lower(coalesce(u.first_names || ' ', '') ||
- coalesce(u.last_name || ' ', '') ||
- u.email || ' ' ||
- coalesce(u.screen_name, '')) like lower('%'||:value||'%')
- order by name
- </querytext>
-</fullquery>
-
<fullquery name="acs_user::get_from_user_id_not_cached.select_user_info">
<querytext>
Fisheye: Tag 1.4.12.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-tcl/tcl/defs-procs-oracle.xql'.
Fisheye: No comparison available. Pass `N' to diff?
Fisheye: Tag 1.6.12.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-tcl/tcl/defs-procs-postgresql.xql'.
Fisheye: No comparison available. Pass `N' to diff?
Fisheye: Tag 1.1.30.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-tcl/tcl/deprecated-utilities-procs.xql'.
Fisheye: No comparison available. Pass `N' to diff?
Fisheye: Tag 1.1.30.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-tcl/tcl/request-processor-init.xql'.
Fisheye: No comparison available. Pass `N' to diff?
Fisheye: Tag 1.1.30.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-tcl/tcl/request-processor-procs-oracle.xql'.
Fisheye: No comparison available. Pass `N' to diff?
Fisheye: Tag 1.1.30.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-tcl/tcl/request-processor-procs-postgresql.xql'.
Fisheye: No comparison available. Pass `N' to diff?
Index: openacs-4/packages/acs-tcl/tcl/request-processor-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/Attic/request-processor-procs.xql,v
diff -u -r1.4 -r1.4.24.1
--- openacs-4/packages/acs-tcl/tcl/request-processor-procs.xql 8 Feb 2003 16:25:22 -0000 1.4
+++ openacs-4/packages/acs-tcl/tcl/request-processor-procs.xql 2 Jan 2016 11:22:35 -0000 1.4.24.1
@@ -10,16 +10,6 @@
</querytext>
</fullquery>
-
-<fullquery name="ad_acs_admin_id.acs_admin_id_get">
- <querytext>
-
- select package_id from apm_packages
- where package_key = 'acs-admin'
-
- </querytext>
-</fullquery>
-
<fullquery name="rp_lookup_node_from_host.node_id">
<querytext>
Index: openacs-4/packages/acs-tcl/tcl/security-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/security-procs-oracle.xql,v
diff -u -r1.7 -r1.7.2.1
--- openacs-4/packages/acs-tcl/tcl/security-procs-oracle.xql 30 Jun 2015 21:14:52 -0000 1.7
+++ openacs-4/packages/acs-tcl/tcl/security-procs-oracle.xql 2 Jan 2016 11:22:35 -0000 1.7.2.1
@@ -16,20 +16,6 @@
</fullquery>
-<fullquery name="ad_maybe_redirect_for_registration.sql_test_1">
- <querytext>
- select test_sql('select 1 from dual where 1=[DoubleApos $value]') from dual
- </querytext>
-</fullquery>
-
-
-<fullquery name="ad_maybe_redirect_for_registration.sql_test_2">
- <querytext>
- select test_sql('select 1 from dual where 1=[DoubleApos "'$value'"]') from dual
- </querytext>
-</fullquery>
-
-
<fullquery name="populate_secret_tokens_db.insert_random_token">
<querytext>
Index: openacs-4/packages/acs-tcl/tcl/security-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/security-procs-postgresql.xql,v
diff -u -r1.12 -r1.12.2.1
--- openacs-4/packages/acs-tcl/tcl/security-procs-postgresql.xql 30 Jun 2015 21:14:52 -0000 1.12
+++ openacs-4/packages/acs-tcl/tcl/security-procs-postgresql.xql 2 Jan 2016 11:22:35 -0000 1.12.2.1
@@ -38,20 +38,6 @@
</fullquery>
-<fullquery name="ad_maybe_redirect_for_registration.sql_test_1">
- <querytext>
- select test_sql('select 1 where 1=[DoubleApos $value]')
- </querytext>
-</fullquery>
-
-
-<fullquery name="ad_maybe_redirect_for_registration.sql_test_2">
- <querytext>
- select test_sql('select 1 where 1=[DoubleApos "'$value'"]')
- </querytext>
-</fullquery>
-
-
<fullquery name="populate_secret_tokens_db.insert_random_token">
<querytext>
Index: openacs-4/packages/acs-tcl/tcl/site-nodes-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/site-nodes-procs-oracle.xql,v
diff -u -r1.20 -r1.20.10.1
--- openacs-4/packages/acs-tcl/tcl/site-nodes-procs-oracle.xql 11 Apr 2008 22:37:12 -0000 1.20
+++ openacs-4/packages/acs-tcl/tcl/site-nodes-procs-oracle.xql 2 Jan 2016 11:22:36 -0000 1.20.10.1
@@ -53,13 +53,4 @@
</querytext>
</fullquery>
- <fullquery name="site_node::get_url_from_object_id.select_url_from_object_id">
- <querytext>
- select site_node.url(node_id)
- from site_nodes
- where object_id = :object_id
- order by site_node.url(node_id) desc
- </querytext>
- </fullquery>
-
</queryset>
Index: openacs-4/packages/acs-tcl/tcl/site-nodes-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/site-nodes-procs-postgresql.xql,v
diff -u -r1.20 -r1.20.10.1
--- openacs-4/packages/acs-tcl/tcl/site-nodes-procs-postgresql.xql 11 Apr 2008 22:37:12 -0000 1.20
+++ openacs-4/packages/acs-tcl/tcl/site-nodes-procs-postgresql.xql 2 Jan 2016 11:22:36 -0000 1.20.10.1
@@ -49,13 +49,4 @@
</querytext>
</fullquery>
- <fullquery name="site_node::get_url_from_object_id.select_url_from_object_id">
- <querytext>
- select site_node__url(node_id)
- from site_nodes
- where object_id = :object_id
- order by site_node__url(node_id) desc
- </querytext>
- </fullquery>
-
</queryset>
Index: openacs-4/packages/acs-tcl/tcl/widgets-procs.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/widgets-procs.tcl,v
diff -u -r1.18.2.2 -r1.18.2.3
--- openacs-4/packages/acs-tcl/tcl/widgets-procs.tcl 18 Sep 2015 07:33:49 -0000 1.18.2.2
+++ openacs-4/packages/acs-tcl/tcl/widgets-procs.tcl 2 Jan 2016 11:22:36 -0000 1.18.2.3
@@ -17,7 +17,7 @@
}
db_foreach all_states {
- select state_name, abbrev from us_states order by state_name
+ select state_name, abbrev from states order by state_name
} {
if { $default == $abbrev } {
append widget_value "<option value=\"$abbrev\" selected=\"selected\">$state_name</option>\n"
@@ -47,7 +47,7 @@
}
}
db_foreach all_countries {
- select default_name, iso from countries order by default_name
+ select default_name, iso from countries order by default_name
} {
if { $default == $iso } {
append widget_value "<option value=\"$iso\" selected=\"selected\">$default_name</option>\n"
Fisheye: Tag 1.2.30.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-tcl/tcl/widgets-procs.xql'.
Fisheye: No comparison available. Pass `N' to diff?