Feeds Integration - Mailing list pgsql-www

From David Costa
Subject Feeds Integration
Date
Msg-id 2945B21A-62F3-11D8-BA87-000A95EB456A@dotgeek.org
Whole thread Raw
Responses Re: Feeds Integration
Re: Feeds Integration
List pgsql-www
Hello All,
I plan to move forward with a gborg and events feed. This as a nice
addition of the existing one (beta version on dotgeek.org).

Problem, for the beta news, I had to do a separate scripts to fetch the
news because I don't have them in a database, then add these locally
and fetch them
for the XML feed.

(how ?

$handle = fopen("http://postgresql.dotgeek.org/", "r");
$file_handler = "";
while (!feof($handle))
    $file_handler .= fgets($handle, 4096);
if (!ereg("<!-- News -->(.+)<!-- Events -->", $file_handler, $news))
    print "error";
$news = str_replace("<tr>\n<td bgcolor=\"#6884A4\">\n<a
name=\"news\">\n<font size=\"+2\"
color=\"#FFFFFF\">News</font></a>\n</td>\n</tr>", "", $news[1]);
$news = ereg_replace("(\n){3,}", "\n", $news);
/*print $news;
print "\n\n\n-------------------------------------------\n\n\n\n";*/
$pattern = "<tr><td><a href=\"(news/[0-9]+\.html)\"
style=\"font-weight: bold; font-size: medium; color: #020169\">";
$pattern .= "([^(</)]+)</a><br>\n<i>Posted on ([0-9]+-[0-9]+-[0-9]+) by
<font color=\"#020169\">([^(</)]+)</font>";
$pattern .= "</i><br>\n([^(</)]+)</td></tr>\n";
$rinfo = array();
$i = 0;
etc etc )

Now, it would be useless to do the same exercise considered that you do
have them in a database. So if I know the db schema, I could possibly
have it to work locally
or upload on my space on your server (thanks Marc !!) something ready
to go.

Ideally (this would work best for me) can someone move on my server
space with you the tables Latest News (gborg) and (events) ? With these
I can do a full test on my box and
upload something ready to go.

For the website integration, I can handle that too but..can I work on
Alexey's beta ? This would allow me to add the feeds links without
having to download
the full site with a CVS checkout and upload something which will have
in any case be modified for Alexey's  new layout.

Of course if you want to implement the news feeds sooner, I could do a
fresh checkout, upload, add the changes and leave it to you.

Thanks again for your time and attention ;)
Cheers
David


pgsql-www by date:

Previous
From: Alexey Borzov
Date:
Subject: Re: PDF docs in CVS broken
Next
From: Alexey Borzov
Date:
Subject: Re: PDF docs in CVS broken