Forum OpenACS Q&A: Re: Chunks and getting news and forum stuff on the front page.

Talli -- those are great thoughts that do make sence and I can't wait to learn more about RSS tool -- do you have a pointer to some information?

And thanks everyone for all the quick thoughts. I searched for answers on the this acs site
and on google before I posted, however, I only found one thread about it.

That thread was a lot like this one -- someone ask a question and the
various answers didn't help me -- but that's not you're fault that I'm a n00bie knucklehead at this. Anyway, the whole time I'm
learning which is my main goal, moreso then getting my news on my front
pages.

I will post some more information that I found after following the advice
in this thread because maybe it will help someone in the future (ie, it
hasn't really helped me yet and so let me know the ways I'm missing something
big...), and when/if I do find an ez answer I will write a ez solution for
the FAQ. Here's what I got so far.

News on front page: I found files at:

From:
http://dev.openacs.org:8000/cvs/openacs.org-dev/www/templates/

One called homepage-index.adp had the following

<multiple name=news_items>
<!--maxrows doesn't take a variable value, so have to do this-->
<if @news_items.rownum@ le @n_news_items@>
  <b>@news_items.pretty_publish_date@</b>:<br>
  <a
href="/news/item?item_id=@news_items.item_id@">@news_items.publish_title@</a
<blockquote><br>
</blockquote>
  <img src="/templates/images/spacer.gif" alt="" height="8" width="174">
  <br clear="left">
</if>
</multiple>
<if @news_items:rowcount@ gt @n_news_items@>
<br>
<a href="/news">more news...</a><br>
</if>

I also found the file homepage-index.adp and it had the following -- I
edited out the forum parts.

# /www/templates/homepage-news.tcl
ad_page_contract {
    @author Pat Colgan (mailto:pat@museatech.net)
    @creation-date 2001-09-01
    This page is for the OpenACS homepage.  In addition to
    the Edit This Page functions, it has code for pulling
    out featured articles and profiles, news, and bboard
    posts.
} {
} -properties {
    pa:onerow
    news_items:multirow
    n_news_items:onevalue
}

set n_news_items 5
set max_post_age_days 14
set news_limit [expr $n_news_items + 1]
etp::get_page_attributes
set view_clause [db_map view_clause_live]

db_multirow news_items news_items_select "
select item_id,
      publish_title,
      pretty_publish_date
from  news_items_approved
where  package_id = 43787
      and publish_date < current_timestamp
      and (archive_date is null or archive_date > current_timestamp)
order  by publish_date desc, item_id desc
"
                -limit $news_limit \
                      -package_id ???? -result_name news_items \
                      release_date archive_date
#etp::get_content_items -package_id 4053 -limit $feature_limit \
                      -result_name feature_items
etp::get_content_items -package_id 16464 -limit $feature_limit \
                      -result_name feature_items
http://wolfram.org/