Feeds Integration

From: David Costa <geeks(at)dotgeek(dot)org>
To: PostgreSQL WWW Mailing List <pgsql-www(at)postgresql(dot)org>
Subject: Feeds Integration
Date: 2004-02-19 15:49:11
Message-ID: 2945B21A-62F3-11D8-BA87-000A95EB456A@dotgeek.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-www by date

  From Date Subject
Next Message Alexey Borzov 2004-02-19 15:53:14 Re: PDF docs in CVS broken
Previous Message Alexey Borzov 2004-02-19 15:32:37 Re: PDF docs in CVS broken