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 A05ADD1BA21 for ; Fri, 27 Feb 2004 13:14:50 +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 53724-09 for ; Fri, 27 Feb 2004 09:14:50 -0400 (AST) Received: from bramble.mmrd.com (unknown [65.217.53.66]) by svr1.postgresql.org (Postfix) with ESMTP id EF61ED1B9BC for ; Fri, 27 Feb 2004 09:14:46 -0400 (AST) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by bramble.mmrd.com (8.12.8/8.12.8) with ESMTP id i1RCj0cM024225; Fri, 27 Feb 2004 07:45:00 -0500 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [192.168.3.55]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id i1RDEll16382; Fri, 27 Feb 2004 08:14:47 -0500 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72) id FVMA44PY; Fri, 27 Feb 2004 08:14:46 -0500 Subject: Re: Feeds Integration From: Robert Treat To: Chris Ryan Cc: David Costa , pgsql-www@postgresql.org In-Reply-To: <20040226182836.85552.qmail@web40020.mail.yahoo.com> References: <20040226182836.85552.qmail@web40020.mail.yahoo.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Mailer: Ximian Evolution 1.0.8 Date: 27 Feb 2004 08:14:47 -0500 Message-Id: <1077887687.2784.20.camel@camel> Mime-Version: 1.0 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/220 X-Sequence-Number: 3785 Is it just me or did no one else get the attachment? Robert Treat On Thu, 2004-02-26 at 13:28, Chris Ryan wrote: > Dave P., Marc, >=20 > 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. >=20 > 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 /XML/. and making sure > certain pear packages were installed XML_RPC and XML_Util. >=20 > Chris Ryan >=20 >=20 >=20 > --- David Costa 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=20 > > used in the loop. > >=20 > > For my news alpha I am using a regex on the postgresql homepage and > > is=20 > > not really a good idea=A9 > >=20 > > Cheers > > David > >=20 > > On Feb 20, 2004, at 4:48 PM, Chris Ryan wrote: > >=20 > > > > > > --- David Costa 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 > >=20 >=20 >=20 > __________________________________ > Do you Yahoo!? > Get better spam protection with Yahoo! Mail. > http://antispam.yahoo.com/tools >=20 > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org --=20 Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL