Index: openacs-4/packages/news-aggregator/todo =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/news-aggregator/Attic/todo,v diff -u -r1.1.2.2 -r1.1.2.3 --- openacs-4/packages/news-aggregator/todo 18 Jan 2006 00:09:17 -0000 1.1.2.2 +++ openacs-4/packages/news-aggregator/todo 18 Jan 2006 15:25:16 -0000 1.1.2.3 @@ -1,18 +1,19 @@ MS: some thoughts for improvements; should also mine bloglines, newsgator and yahoo (et. al) for more ideas -version 0.9.8 - - change sort date to "Today", "Yesterday", "x days ago" (fix grouping bug when only) - - html for aggregator description version 0.9.9 + - html for aggregator description - parameterize the query limit for items (hard coded to 600) - - notifications (convert multiple rss feeds to email. cool?!?) version 1 + - code cleanup and complete tests + - update data model for 5.2 +version 1.1 - add to del.ici.us button? - - pagination for display? or another means of tidying up display page? - - style items (both w and w/o description) entirely via css + - edit subscription title version 1.2 + - notifications (convert multiple rss feeds to email. cool?!?) +version 1.3 - search +version 1.4+ - per subscription keywords -version 1.2+ - - edit subscription title - - separate css with per package param for location + - other display options? + - style items (both w and w/o description) entirely via css (per package param for location) \ No newline at end of file Index: openacs-4/packages/news-aggregator/sql/postgresql/upgrade/upgrade-0.9.7-0.9.8.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/news-aggregator/sql/postgresql/upgrade/Attic/upgrade-0.9.7-0.9.8.sql,v diff -u -r1.1.2.2 -r1.1.2.3 --- openacs-4/packages/news-aggregator/sql/postgresql/upgrade/upgrade-0.9.7-0.9.8.sql 17 Jan 2006 23:07:28 -0000 1.1.2.2 +++ openacs-4/packages/news-aggregator/sql/postgresql/upgrade/upgrade-0.9.7-0.9.8.sql 18 Jan 2006 15:25:17 -0000 1.1.2.3 @@ -58,12 +58,9 @@ -- no real feed owner at this point, with feeds being shared among packages alter table na_sources drop column owner_id; --- this is available in acs_objects beginnning with 5.2 +-- this was not used and is available in acs_objects beginnning with 5.2 in any case alter table na_sources drop column package_id; --- customizing this should be a per user option -alter table na_sources - drop column title; -- add on delete cascade so packages can uninstall cleanly -- doing this for now, may eventually move this data to the user preferences package Index: openacs-4/packages/news-aggregator/tcl/aggregator-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/news-aggregator/tcl/aggregator-procs-postgresql.xql,v diff -u -r1.2.2.2 -r1.2.2.3 --- openacs-4/packages/news-aggregator/tcl/aggregator-procs-postgresql.xql 14 Jan 2006 23:27:59 -0000 1.2.2.2 +++ openacs-4/packages/news-aggregator/tcl/aggregator-procs-postgresql.xql 18 Jan 2006 15:25:17 -0000 1.2.2.3 @@ -20,7 +20,6 @@ su.show_description_p, s.description, s.title, - to_char(i.creation_date, 'YYYY-MM-DD HH24:MI:SS') as last_scanned, s.feed_url, i.item_id, i.title as item_title, Index: openacs-4/packages/news-aggregator/www/index.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/news-aggregator/www/index.adp,v diff -u -r1.12.2.8 -r1.12.2.9 --- openacs-4/packages/news-aggregator/www/index.adp 17 Jan 2006 23:07:28 -0000 1.12.2.8 +++ openacs-4/packages/news-aggregator/www/index.adp 18 Jan 2006 15:25:17 -0000 1.12.2.9 @@ -9,9 +9,9 @@
-

@aggregator_name@

+

@aggregator_name;noquote@

- @aggregator_description@ + @aggregator_description;noquote@ This page lists the most recent items from the feeds you've subscribed to. @@ -52,64 +52,12 @@ #news-aggregator.No_items# - - -
- @items.title;noquote@, from @items.chunk_updated@ -
- - -
- - -
Posted: @items.pub_time@ - - # - -
- @items.content;noquote@ -
- - - Save - - - Unsave - - - - Blog - -
-
- - -
- - @items.item_title;noquote@ - Posted: @items.pub_time@  - - # -   - - - Save - - - Unsave - - - - Blog -
- - - - + + + + + + Index: openacs-4/packages/news-aggregator/www/index.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/news-aggregator/www/index.tcl,v diff -u -r1.9.2.6 -r1.9.2.7 --- openacs-4/packages/news-aggregator/www/index.tcl 14 Jan 2006 23:27:59 -0000 1.9.2.6 +++ openacs-4/packages/news-aggregator/www/index.tcl 18 Jan 2006 15:25:17 -0000 1.9.2.7 @@ -110,7 +110,6 @@ set page_title $aggregator_name set context [list $page_title] -set package_url [ad_conn package_url] set url "$package_url$aggregator_id/" set graphics_url "${package_url}graphics/" set return_url [ad_conn url] @@ -120,6 +119,11 @@ set limit [ad_parameter "number_of_items_shown"] set sql_limit [expr 7*$limit] +set multiple_sources_p [expr [db_string count { + select count(*) + from na_subscriptions + where aggregator_id = :aggregator_id +} -default 0] > 1] set top 0 set bottom 1073741824 @@ -215,7 +219,7 @@ } else { set item_guid_link $item_link } - set multiple_sources [expr [db_string count "select count(*) from na_subscriptions where aggregator_id = :aggregator_id"] > 1] + #set diff [news_aggregator::last_scanned -diff [expr [expr [clock seconds] - [clock scan $last_scanned]] / 60]] set source_url [export_vars -base source {source_id}] set technorati_url "http://www.technorati.com/cosmos/links.html?url=$link&sub=Get+Link+Cosmos" Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/news-aggregator/www/multi-source-chunk.adp'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/news-aggregator/www/single-source-chunk.adp'. Fisheye: No comparison available. Pass `N' to diff?