Re: Feeds Integration - Mailing list pgsql-www
From | Chris Ryan |
---|---|
Subject | Re: Feeds Integration |
Date | |
Msg-id | 20040227133130.81673.qmail@web40011.mail.yahoo.com Whole thread Raw |
In response to | Re: Feeds Integration (Robert Treat <xzilla@users.sourceforge.net>) |
List | pgsql-www |
In retrospect it was probably me. Attached this time... i swear... i hope :) Chris Ryan --- Robert Treat <xzilla@users.sourceforge.net> wrote: > 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, > > > > 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 > > > > ---------------------------(end of > broadcast)--------------------------- > > TIP 1: subscribe and unsubscribe commands go to > majordomo@postgresql.org > > -- > Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL > > > ---------------------------(end of > broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html __________________________________ Do you Yahoo!? Get better spam protection with Yahoo! Mail. http://antispam.yahoo.com/tools