Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/rss-support/www/delete-2-oracle.xql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/rss-support/www/delete-2-postgresql.xql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: openacs-4/packages/rss-support/www/delete-2.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/rss-support/www/delete-2.tcl,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/rss-support/www/delete-2.tcl	12 Dec 2001 02:58:23 -0000	1.1
+++ openacs-4/packages/rss-support/www/delete-2.tcl	17 May 2003 11:23:29 -0000	1.2
@@ -12,10 +12,6 @@
     ns_unlink -nocomplain [rss_gen_report_file -subscr_id $subscr_id]
 }
 
-db_exec_plsql delete_subscr {
-    select rss_gen_subscr__delete (
-        :subscr_id
-    )
-}
+db_exec_plsql delete_subscr {}
 
 ad_returnredirect $return_url
Index: openacs-4/packages/rss-support/www/delete.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/rss-support/www/delete.adp,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/rss-support/www/delete.adp	30 Nov 2002 17:44:39 -0000	1.4
+++ openacs-4/packages/rss-support/www/delete.adp	17 May 2003 11:23:29 -0000	1.5
@@ -8,7 +8,7 @@
 <input type=hidden name=subscr_id value="@subscr_id@">
 <input type=hidden name=return_url value="@return_url@">
 <if @offer_file@ eq 1>
-<input type=checkbox name=delete_file_p>Delete report (<a href="@report_url@">@report_url@</a>)
+<input type=checkbox name=delete_file_p id=delete_file><label for=delete_file>Delete report</label>
 </if>
 <p>
 <input type=submit value="Really delete?">
Index: openacs-4/packages/rss-support/www/delete.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/rss-support/www/delete.tcl,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/rss-support/www/delete.tcl	30 Jan 2003 16:52:12 -0000	1.4
+++ openacs-4/packages/rss-support/www/delete.tcl	17 May 2003 11:23:29 -0000	1.5
@@ -7,13 +7,7 @@
 
 ad_require_permission $subscr_id admin
 
-db_1row subscr_info {
-    select summary_context_id,
-           channel_title,
-           channel_link
-    from rss_gen_subscrs
-    where subscr_id = :subscr_id
-}
+db_1row subscr_info {}
 
 if [string equal $channel_title ""] {
     set channel_title "Summary Context $summary_context_id"
@@ -23,7 +17,7 @@
 
 if [file exists [rss_gen_report_file -subscr_id $subscr_id]] {
     set offer_file 1
-    set report_url [rss_gen_report_file -subscr_id $subscr_id -url]
+    set report_url [rss_gen_report_file -subscr_id $subscr_id]
 } else {
     set offer_file 0
-}
\ No newline at end of file
+}
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/rss-support/www/delete.xql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/rss-support/www/subscr-ae-2-oracle.xql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/rss-support/www/subscr-ae-2-postgresql.xql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: openacs-4/packages/rss-support/www/subscr-ae-2.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/rss-support/www/subscr-ae-2.tcl,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/rss-support/www/subscr-ae-2.tcl	5 Sep 2002 13:23:33 -0000	1.3
+++ openacs-4/packages/rss-support/www/subscr-ae-2.tcl	17 May 2003 11:23:29 -0000	1.4
@@ -23,34 +23,18 @@
 }] {
     # Subscription exists
     ad_require_permission $subscr_id admin
-    db_dml update_subscr {
-	update rss_gen_subscrs
-	set timeout = :timeout
-	where subscr_id = :subscr_id
-    }
+    db_dml update_subscr {}
 } else {
     # Create a new subscription.
     ad_require_permission $summary_context_id admin
 
     set creation_user [ad_conn user_id]
     set creation_ip [ns_conn peeraddr]
-    db_exec_plsql create_subscr {
-	select rss_gen_subscr__new (
-	    :subscr_id,				-- subscr_id
-            :impl_id,				-- impl_id
-            :summary_context_id,		-- summary_context_id
-            :timeout,			        -- timeout
-            null,				-- lastbuild
-            'rss_gen_subscr',		        -- object_type
-            now(),				-- creation_date
-            :creation_user,			-- creation_user
-            :creation_ip,			-- creation_ip
-            :summary_context_id			-- context_id
-	)
-    }
+    set subscr_id [db_exec_plsql create_subscr {}]
 }
 
 
-set context [list]
+set review_url subscr-ae?[export_url_vars subscr_id impl_id summary_context_id return_url meta]
 
-set review_url subscr-ae?[export_url_vars impl_id summary_context_id return_url meta]
\ No newline at end of file
+set context [list [list $review_url "Edit subscription"] "Done"]
+
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/rss-support/www/subscr-ae-2.xql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/rss-support/www/subscr-ae-oracle.xql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/rss-support/www/subscr-ae-postgresql.xql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: openacs-4/packages/rss-support/www/subscr-ae.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/rss-support/www/subscr-ae.adp,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/rss-support/www/subscr-ae.adp	30 Nov 2002 17:44:39 -0000	1.5
+++ openacs-4/packages/rss-support/www/subscr-ae.adp	17 May 2003 11:23:29 -0000	1.6
@@ -5,7 +5,7 @@
 <form action=subscr-ae-2>
 <table cellpadding=2 cellspacing=2 border=0 bgcolor=e0e0e0>
 <tr bgcolor=efefef align=left valign=top><th>Channel:</th>
-<td><if @channel_link@ eq "">@channel_title@</if><else>
+<td><if @channel_link@ nil>@channel_title@</if><else>
 <a href="@channel_link@">@channel_title@</a></else></td></tr>
 <tr bgcolor=efefef align=left valign=top><th>Impl Name:</th>
 <td><code>@impl_name@</code></td></tr>
Index: openacs-4/packages/rss-support/www/subscr-ae.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/rss-support/www/subscr-ae.tcl,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/rss-support/www/subscr-ae.tcl	5 Sep 2002 13:23:33 -0000	1.6
+++ openacs-4/packages/rss-support/www/subscr-ae.tcl	17 May 2003 11:23:29 -0000	1.7
@@ -31,27 +31,14 @@
 }
 
 if { [info exists impl_id] && [info exists summary_context_id] } {
-    db_0or1row subscr_id_from_impl_and_context {
-	select subscr_id
-	from rss_gen_subscrs
-        where impl_id = :impl_id
-          and summary_context_id = :summary_context_id
-    }
+    db_0or1row subscr_id_from_impl_and_context {}
 }
 
 if [info exists subscr_id] {
     set action edit
     set pretty_action Edit
     ad_require_permission $subscr_id admin
-    db_1row subscr_info {
-	select impl_id,
-	       summary_context_id,
-	       timeout,
-               channel_title,
-               channel_link
-	from rss_gen_subscrs
-	where subscr_id = :subscr_id
-    }
+    db_1row subscr_info {}
 } else {
     set action add
     set pretty_action Add
@@ -61,11 +48,7 @@
 }
 
 # Validate the impl_id and get its name
-if ![db_0or1row get_impl_name_and_count {
-    select acs_sc_impl__get_name(impl_id) as impl_name
-    from acs_sc_impls
-    where impl_id = :impl_id
-}] {
+if ![db_0or1row get_impl_name_and_count {}] {
     ad_return_error "No implementation found for this id." "We were unable to
 process your request.  Please contact this site's technical team for
 assistance."
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/rss-support/www/subscr-ae.xql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: openacs-4/packages/rss-support/www/subscr-run.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/rss-support/www/subscr-run.tcl,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/rss-support/www/subscr-run.tcl	30 Nov 2001 05:56:37 -0000	1.1
+++ openacs-4/packages/rss-support/www/subscr-run.tcl	17 May 2003 11:23:29 -0000	1.2
@@ -9,4 +9,4 @@
 
 rss_gen_report $subscr_id
 
-ad_returnredirect $return_url
\ No newline at end of file
+ad_returnredirect $return_url
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/rss-support/www/subscrs-include-oracle.xql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/rss-support/www/subscrs-include-postgresql.xql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: openacs-4/packages/rss-support/www/subscrs-include.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/rss-support/www/subscrs-include.tcl,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/rss-support/www/subscrs-include.tcl	12 Dec 2001 02:58:23 -0000	1.1
+++ openacs-4/packages/rss-support/www/subscrs-include.tcl	17 May 2003 11:23:29 -0000	1.2
@@ -4,19 +4,7 @@
     set maybe_restrict_to_user ""
 }
 
-db_multirow subscrs get_subscrs "
-    select s.subscr_id,
-           s.timeout,
-           person__name(o.creation_user) as creator,
-           coalesce(to_char(s.lastbuild,'YYYY-MM-DD HH24:MI:SS'),'never built') as lastbuild,
-           s.last_ttb,
-           s.channel_title,
-           s.channel_link
-    from rss_gen_subscrs s,
-         acs_objects o
-    where o.object_id = s.subscr_id $maybe_restrict_to_user
-    order by s.last_ttb desc
-" {
+db_multirow subscrs get_subscrs {} {
     if [string equal $channel_title ""] {
 	set channel_title "Subscription #$subscr_id"
     }
Index: openacs-4/packages/schema-browser/schema-browser.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/schema-browser/schema-browser.info,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/schema-browser/schema-browser.info	16 Jan 2003 13:56:12 -0000	1.4
+++ openacs-4/packages/schema-browser/schema-browser.info	17 May 2003 11:24:18 -0000	1.5
@@ -18,7 +18,7 @@
         <release-date>2001-01-24</release-date>
         <vendor url="http://www.arsdigita.com/">ArsDigita Corporation</vendor>
 
-        <requires url="acs-kernel" version="4.0"/>
+        <requires url="acs-kernel" version="4.6.2"/>
 
         <files>
             <file type="package_spec" path="schema-browser.info"/>
Index: openacs-4/packages/schema-browser/www/index.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/schema-browser/www/index.tcl,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/schema-browser/www/index.tcl	10 Sep 2002 22:23:21 -0000	1.2
+++ openacs-4/packages/schema-browser/www/index.tcl	17 May 2003 11:25:11 -0000	1.3
@@ -41,7 +41,7 @@
 "
 
 if { [exists_and_not_null table_name] } {
-    append page_content [util_memoize "sb_get_table_description $table_name"]
+    append page_content [sb_get_table_description $table_name]
 } else {
     set table_name ""
 }
Index: openacs-4/packages/search/search.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/search/search.info,v
diff -u -r1.7 -r1.8
--- openacs-4/packages/search/search.info	30 Nov 2002 17:45:10 -0000	1.7
+++ openacs-4/packages/search/search.info	17 May 2003 11:26:35 -0000	1.8
@@ -18,43 +18,6 @@
 
         <provides url="search" version="4.6"/>
 
-        <files>
-            <file type="package_spec" path="search.info"/>
-            <file type="data_model_create" db_type="oracle" path="sql/oracle/search-create.sql"/>
-            <file type="data_model_drop" db_type="oracle" path="sql/oracle/search-drop.sql"/>
-            <file type="data_model" db_type="oracle" path="sql/oracle/search-packages-create.sql"/>
-            <file type="data_model" db_type="oracle" path="sql/oracle/search-packages-drop.sql"/>
-            <file type="data_model" db_type="oracle" path="sql/oracle/search-sc-create.sql"/>
-            <file type="data_model" db_type="oracle" path="sql/oracle/search-sc-drop.sql"/>
-            <file type="data_model" db_type="oracle" path="sql/oracle/search-tables-create.sql"/>
-            <file type="data_model" db_type="oracle" path="sql/oracle/search-tables-drop.sql"/>
-            <file type="data_model_create" db_type="postgresql" path="sql/postgresql/search-create.sql"/>
-            <file type="data_model_drop" db_type="postgresql" path="sql/postgresql/search-drop.sql"/>
-            <file type="data_model" db_type="postgresql" path="sql/postgresql/search-packages-create.sql"/>
-            <file type="data_model" db_type="postgresql" path="sql/postgresql/search-packages-drop.sql"/>
-            <file type="data_model" db_type="postgresql" path="sql/postgresql/search-sc-create.sql"/>
-            <file type="data_model" db_type="postgresql" path="sql/postgresql/search-sc-drop.sql"/>
-            <file type="data_model" db_type="postgresql" path="sql/postgresql/search-tables-create.sql"/>
-            <file type="data_model" db_type="postgresql" path="sql/postgresql/search-tables-drop.sql"/>
-            <file type="data_model_upgrade" db_type="postgresql" path="sql/postgresql/upgrade/upgrade-4.5-4.5.1.sql"/>
-            <file type="tcl_init" path="tcl/search-init.tcl"/>
-            <file type="query_file" db_type="oracle" path="tcl/search-procs-oracle.xql"/>
-            <file type="query_file" db_type="postgresql" path="tcl/search-procs-postgresql.xql"/>
-            <file type="tcl_procs" path="tcl/search-procs.tcl"/>
-            <file type="query_file" path="tcl/search-procs.xql"/>
-            <file path="www/advanced-search.adp"/>
-            <file type="tcl_util" path="www/advanced-search.tcl"/>
-            <file type="documentation" path="www/doc/guidelines.html"/>
-            <file type="documentation" path="www/doc/index.html"/>
-            <file type="content_page" path="www/help/basics.html"/>
-            <file type="content_page" path="www/index.adp"/>
-            <file type="content_page" path="www/index.tcl"/>
-            <file type="content_page" path="www/search-results-bottom.adp"/>
-            <file type="content_page" path="www/search-results-one.adp"/>
-            <file type="content_page" path="www/search-results-top.adp"/>
-            <file type="content_page" path="www/search.tcl"/>
-            <file type="content_page" path="www/test.adp"/>
-        </files>
         <parameters>
             <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="Symbol2Interval"  default="m3 {3 month ago} m6 {6 month ago} y1 {1 year ago}" description="Translate symbol to date interval."/>
             <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="FtsEngineDriver"  default="openfts-driver" description="Which search engine driver to use? You should enter the name of the related binding (e.g. openfts-driver, swish-driver,...)"/>
Index: openacs-4/packages/search/sql/postgresql/search-packages-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/search/sql/postgresql/search-packages-create.sql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/search/sql/postgresql/search-packages-create.sql	21 Dec 2002 22:27:28 -0000	1.4
+++ openacs-4/packages/search/sql/postgresql/search-packages-create.sql	17 May 2003 11:27:28 -0000	1.5
@@ -21,7 +21,7 @@
 end;' language 'plpgsql';
 
 
-create function search_observer__dequeue(integer,timestamp with time zone,varchar)
+create function search_observer__dequeue(integer,timestamptz,varchar)
 returns integer as '
 declare
     p_object_id                 alias for $1;
Index: openacs-4/packages/search/sql/postgresql/search-packages-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/search/sql/postgresql/search-packages-drop.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/search/sql/postgresql/search-packages-drop.sql	2 Sep 2001 18:11:39 -0000	1.1
+++ openacs-4/packages/search/sql/postgresql/search-packages-drop.sql	17 May 2003 11:27:28 -0000	1.2
@@ -1,2 +1,2 @@
-drop function search_observer__dequeue(integer,timestamp,varchar);
+drop function search_observer__dequeue(integer,timestamptz,varchar);
 drop function search_observer__enqueue(integer,varchar);
Index: openacs-4/packages/search/sql/postgresql/search-tables-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/search/sql/postgresql/search-tables-create.sql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/search/sql/postgresql/search-tables-create.sql	2 Jul 2002 01:52:39 -0000	1.5
+++ openacs-4/packages/search/sql/postgresql/search-tables-create.sql	17 May 2003 11:27:28 -0000	1.6
@@ -1,6 +1,6 @@
 create table search_observer_queue (
     object_id		   integer,
-    event_date		   timestamp default now(),
+    event_date		   timestamptz default current_timestamp,
     event		   varchar(6)
 			   constraint search_observer_queue_event_ck
 			   check (event in ('INSERT','DELETE','UPDATE'))  
Index: openacs-4/packages/search/tcl/search-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/search/tcl/search-procs.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/search/tcl/search-procs.xql	30 Nov 2002 17:46:41 -0000	1.3
+++ openacs-4/packages/search/tcl/search-procs.xql	17 May 2003 11:29:41 -0000	1.4
@@ -18,7 +18,7 @@
         </querytext>
     </fullquery>
 
-    <fullquery name="content_get.get_lob_data">
+    <fullquery name="search_content_get.get_lob_data">
         <querytext>
             select :content as content,
                    'lob' as storage_type
Index: openacs-4/packages/simple-survey/simple-survey.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/simple-survey/simple-survey.info,v
diff -u -r1.9 -r1.10
--- openacs-4/packages/simple-survey/simple-survey.info	16 Jan 2003 13:56:37 -0000	1.9
+++ openacs-4/packages/simple-survey/simple-survey.info	17 May 2003 11:30:38 -0000	1.10
@@ -18,7 +18,7 @@
         <vendor url="http://www.arsdigita.com/">ArsDigita Corporation</vendor>
         <description format="text/html">Simple survey is a survey builder. Surveys can contain questions with different types of answer several types: multiple choice (radio buttons), multiple answer (checkboxes) or free text entry. Multiple choice questions may also be scored on one or more variables.</description>
 
-        <requires url="acs-kernel" version="4.0"/>
+        <requires url="acs-kernel" version="4.6.2"/>
 
         <files>
             <file type="package_spec" path="simple-survey.info"/>
Index: openacs-4/packages/simple-survey/sql/postgresql/simple-survey-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/simple-survey/sql/postgresql/simple-survey-create.sql,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/simple-survey/sql/postgresql/simple-survey-create.sql	23 Feb 2003 18:22:40 -0000	1.6
+++ openacs-4/packages/simple-survey/sql/postgresql/simple-survey-create.sql	17 May 2003 11:31:27 -0000	1.7
@@ -308,7 +308,7 @@
 	clob_answer		text,
 	number_answer		numeric,
 	varchar_answer		text,
-	date_answer		timestamp,
+	date_answer		timestamptz,
 	-- columns useful for attachments, column names
 	-- lifted from file-storage.sql and bboard.sql
 	-- this is where the actual content is stored
Index: openacs-4/packages/site-wide-search/site-wide-search.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/site-wide-search/site-wide-search.info,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/site-wide-search/site-wide-search.info	16 Jan 2003 13:57:16 -0000	1.3
+++ openacs-4/packages/site-wide-search/site-wide-search.info	17 May 2003 11:32:49 -0000	1.4
@@ -19,7 +19,7 @@
         <provides url="site-wide-search" version="4.0.1"/>
         <requires url="acs-content" version="4.0"/>
         <requires url="acs-interface" version="4.0.1"/>
-        <requires url="acs-kernel" version="4.0"/>
+        <requires url="acs-kernel" version="4.6.2"/>
 
         <files>
             <file type="package_spec" path="site-wide-search.info"/>