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 62CB1D1E159
	for <pgsql-www-postgresql.org@localhost.postgresql.org>;
	Thu, 19 Feb 2004 15:49:13 +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 04825-05
	for <pgsql-www-postgresql.org@localhost.postgresql.org>;
	Thu, 19 Feb 2004 11:49:14 -0400 (AST)
Received: from php.gurugeek.org (unknown [213.174.166.198])
	by svr1.postgresql.org (Postfix) with ESMTP id 7E986D1E14E
	for <pgsql-www@postgresql.org>; Thu, 19 Feb 2004 11:49:03 -0400 (AST)
Received: from [127.0.0.1] (localhost [127.0.0.1])
	by php.gurugeek.org (Postfix) with ESMTP id E4B271EE6EB
	for <pgsql-www@postgresql.org>; Thu, 19 Feb 2004 16:49:12 +0100 (CET)
Mime-Version: 1.0 (Apple Message framework v609)
Content-Transfer-Encoding: 7bit
Message-Id: <2945B21A-62F3-11D8-BA87-000A95EB456A@dotgeek.org>
Content-Type: text/plain; charset=US-ASCII; format=flowed
To: PostgreSQL WWW Mailing List <pgsql-www@postgresql.org>
From: David Costa <geeks@dotgeek.org>
Subject: Feeds Integration
Date: Thu, 19 Feb 2004 16:49:11 +0100
X-Mailer: Apple Mail (2.609)
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200402/138
X-Sequence-Number: 3703

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