X-Original-To: pgsql-www-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 00A9BD1B967
	for <pgsql-www-postgresql.org@localhost.postgresql.org>;
	Thu, 26 Feb 2004 18:28:43 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 30534-10
	for <pgsql-www-postgresql.org@localhost.postgresql.org>;
	Thu, 26 Feb 2004 14:28:38 -0400 (AST)
Received: from web40020.mail.yahoo.com (web40020.mail.yahoo.com
 [66.218.78.60])
	by svr1.postgresql.org (Postfix) with SMTP id B7731D1B901
	for <pgsql-www@postgresql.org>; Thu, 26 Feb 2004 14:28:36 -0400 (AST)
Message-ID: <20040226182836.85552.qmail@web40020.mail.yahoo.com>
Received: from [64.83.34.44] by web40020.mail.yahoo.com via HTTP;
	Thu, 26 Feb 2004 10:28:36 PST
Date: Thu, 26 Feb 2004 10:28:36 -0800 (PST)
From: Chris Ryan <xgbe@yahoo.com>
Subject: Re: Feeds Integration
To: David Costa <geeks@dotgeek.org>
Cc: pgsql-www@postgresql.org
In-Reply-To: <45631796-67A9-11D8-AC86-000A95EB456A@dotgeek.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200402/180
X-Sequence-Number: 3745

Dave P., Marc,

    I took what David gave me for the rss feed on gborg and made some
quick changes in the sql to fit with the events and news tables from
the main sites database. I gleaned the information from the pgweb cvs
so it should be good to go but may need some tweaking since I didn't
test the sql against the db.

    Find attached a file that has the two seperate scripts I modified
and a third script that needs to be placed appropriately. David had
sent me the instructions the first time but I seem to have deleted them
so he should be able to provide the needed instructions on setup. In
short it was placing the 3rd file in <PEAR>/XML/. and making sure
certain pear packages were installed XML_RPC and XML_Util.

Chris Ryan



--- David Costa <geeks@dotgeek.org> wrote:
> Chris,
> can you please put up a beta/alpha for the main news feeds
> and events?
> all you need to change is the db query and the name of the php
> objects 
> used in the loop.
> 
> For my news alpha I am using a regex on the postgresql homepage and
> is 
> not really a good ideaŠ
> 
> Cheers
> David
> 
> On Feb 20, 2004, at 4:48 PM, Chris Ryan wrote:
> 
> >
> > --- David Costa <geeks@dotgeek.org> wrote:
> >> Hello!
> >  -- snip --
> >> Then just run the file and if it works let me know.
> >  -- snip --
> >
> >
> >     It worked great. You can find the output that was generated at
> > http://gborg.postgresql.org/news.rss. I don't have any RSS tools to
> > view this with so someone else may want to look at this and verify
> it's
> > generating correctly. Other than that it looks good to me.
> >
> >     Once a few people have looked at it and we all like the way
> it's
> > working I can setup the cron to generate the file on a regular
> basis.
> >
> >     Good Job Dave.
> >
> > Chris Ryan
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > Yahoo! Mail SpamGuard - Read only the mail you want.
> > http://antispam.yahoo.com/tools
> 


__________________________________
Do you Yahoo!?
Get better spam protection with Yahoo! Mail.
http://antispam.yahoo.com/tools