From geeks@dotgeek.org Sat Jun 6 06:14:40 2026 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 ; 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 ; 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 ; 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 ; 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 From: David Costa 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("(.+)", $file_handler, $news)) print "error"; $news = str_replace("\n\n\nNews\n\n", "", $news[1]); $news = ereg_replace("(\n){3,}", "\n", $news); /*print $news; print "\n\n\n-------------------------------------------\n\n\n\n";*/ $pattern = ""; $pattern .= "([^(
\nPosted on ([0-9]+-[0-9]+-[0-9]+) by ([^("; $pattern .= "
\n([^(\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 From xgbe@yahoo.com Sat Jun 6 06:14:40 2026 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 C1988D1B456 for ; Thu, 19 Feb 2004 17:32:41 +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 49527-03 for ; Thu, 19 Feb 2004 13:32:39 -0400 (AST) Received: from web40007.mail.yahoo.com (web40007.mail.yahoo.com [66.218.78.25]) by svr1.postgresql.org (Postfix) with SMTP id 459B4D1E157 for ; Thu, 19 Feb 2004 13:32:38 -0400 (AST) Message-ID: <20040219173236.81876.qmail@web40007.mail.yahoo.com> Received: from [64.83.34.44] by web40007.mail.yahoo.com via HTTP; Thu, 19 Feb 2004 09:32:36 PST Date: Thu, 19 Feb 2004 09:32:36 -0800 (PST) From: Chris Ryan Subject: Re: Feeds Integration To: David Costa , PostgreSQL WWW Mailing List In-Reply-To: <2945B21A-62F3-11D8-BA87-000A95EB456A@dotgeek.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/141 X-Sequence-Number: 3706 David, For GBorg specifically the news items are stored on the database. I forget how it was setup for the main website to access the database however I can provide a query that would give you the information you are looking for so you can write a program. Having an RSS feed on GBorg would be great too. If you have something I can you to generate the files that would be great. Here is a query for getting the 10 latest news items for showing on the main page of GBorg. SELECT project_name, headline, body, submit_date -- date not datetime :( FROM project_news, project WHERE (project_news.project_id=project.project_id) AND (project_news.active=true) AND (project_news.on_homepage=true) ORDER BY submit_date DESC LIMIT 10; I will leave issues of access to the GBorg database up to Marc. Chris Ryan --- David Costa wrote: > 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("(.+)", $file_handler, $news)) > print "error"; > $news = str_replace("\n\n name=\"news\">\n color=\"#FFFFFF\">News\n\n", "", $news[1]); > $news = ereg_replace("(\n){3,}", "\n", $news); > /*print $news; > print "\n\n\n-------------------------------------------\n\n\n\n";*/ > $pattern = " style=\"font-weight: bold; font-size: medium; color: #020169\">"; > $pattern .= "([^(
\nPosted on ([0-9]+-[0-9]+-[0-9]+) > by > ([^("; > $pattern .= "
\n([^(\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 > > > ---------------------------(end of > broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if > your > joining column's datatypes do not match __________________________________ Do you Yahoo!? Yahoo! Mail SpamGuard - Read only the mail you want. http://antispam.yahoo.com/tools From josh@agliodbs.com Sat Jun 6 06:14:40 2026 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 12B28D1DFFE for ; Thu, 19 Feb 2004 17:56:18 +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 58132-01 for ; Thu, 19 Feb 2004 13:56:12 -0400 (AST) Received: from davinci.ethosmedia.com (server228.ethosmedia.com [209.128.84.228]) by svr1.postgresql.org (Postfix) with ESMTP id 39A6FD1E0C7 for ; Thu, 19 Feb 2004 13:56:11 -0400 (AST) Received: from [63.195.55.98] (HELO 192.168.1.29) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 4457290; Thu, 19 Feb 2004 09:57:18 -0800 From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: David Costa , PostgreSQL WWW Mailing List Subject: Re: Feeds Integration Date: Thu, 19 Feb 2004 09:55:17 -0800 User-Agent: KMail/1.5.4 References: <2945B21A-62F3-11D8-BA87-000A95EB456A@dotgeek.org> In-Reply-To: <2945B21A-62F3-11D8-BA87-000A95EB456A@dotgeek.org> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200402190955.17871.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/140 X-Sequence-Number: 3705 David, > 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). If it makes any difference, we are currently discussing the possibility of a gradual migration from GBorg to GForge. More discussion to come on -hackers and this list later. Second, we have a reason to want to *import* and RSS feed. Opensourcexperts.com is ready to do PostgreSQL job listings, and they will publish them to us via RSS. Can you help with this once you're done with our RSS export? -- -Josh Berkus Aglio Database Solutions San Francisco From geeks@dotgeek.org Sat Jun 6 06:14:40 2026 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 D43A1D1E0FF for ; Thu, 19 Feb 2004 18:03:22 +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 60833-02 for ; Thu, 19 Feb 2004 14:03:20 -0400 (AST) Received: from php.gurugeek.org (unknown [213.174.166.198]) by svr1.postgresql.org (Postfix) with ESMTP id 86334D1E0E9 for ; Thu, 19 Feb 2004 14:03:18 -0400 (AST) Received: from [127.0.0.1] (localhost [127.0.0.1]) by php.gurugeek.org (Postfix) with ESMTP id B25561EEE0A; Thu, 19 Feb 2004 19:03:17 +0100 (CET) In-Reply-To: <20040219173236.81876.qmail@web40007.mail.yahoo.com> References: <20040219173236.81876.qmail@web40007.mail.yahoo.com> Mime-Version: 1.0 (Apple Message framework v609) Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: Content-Transfer-Encoding: 7bit Cc: PostgreSQL WWW Mailing List From: David Costa Subject: Re: Feeds Integration Date: Thu, 19 Feb 2004 19:03:16 +0100 To: Chris Ryan X-Mailer: Apple Mail (2.609) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/142 X-Sequence-Number: 3707 On Feb 19, 2004, at 6:32 PM, Chris Ryan wrote: > David, > Hi Chris! ;) > For GBorg specifically the news items are stored on the database. I > forget how it was setup for the main website to access the database > however I can provide a query that would give you the information you > are looking for so you can write a program. Having an RSS feed on GBorg > would be great too. yes I am doing it, and I try to avoid the same str_replace stuff, so db is the way to go. > If you have something I can you to generate the > files that would be great. > well I have it done, will work with any database data in principle. > Here is a query for getting the 10 latest news items for showing on > the main page of GBorg. > > SELECT project_name, > headline, > body, > submit_date -- date not datetime :( > FROM project_news, project > WHERE (project_news.project_id=project.project_id) > AND (project_news.active=true) > AND (project_news.on_homepage=true) > ORDER BY submit_date DESC > LIMIT 10; > > Umh, so what about the link ? is it part of the body ? if that is the case it might be a problem, can solve that, just not the fast way to produce the xml from db data. > I will leave issues of access to the GBorg database up to Marc. I can do it without access to gborg.(In my previous email I was under the impression that you had a separate table for news, but this is obviously not the case) Without db access I can still do the script and add some quick comments to set it up the right way. For now the query is fine, but I need to know where the link is stored, on which row. for example I used something like this for the main news array("title" => $row["title"], "link" => $row["url"], "description" => $row['news'], "author" => $row["author"] , "date" => date("d-M-Y", $row["date"])); see I keep on the beta database the url as a separate entity assigned to the link field in the XML generation. For link I mean the "click here for the full story." thing. Cheers David Costa > > Chris Ryan > > > --- David Costa wrote: >> 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("(.+)", $file_handler, $news)) >> print "error"; >> $news = str_replace("\n\n> name=\"news\">\n> color=\"#FFFFFF\">News\n\n", "", $news[1]); >> $news = ereg_replace("(\n){3,}", "\n", $news); >> /*print $news; >> print "\n\n\n-------------------------------------------\n\n\n\n";*/ >> $pattern = "> style=\"font-weight: bold; font-size: medium; color: #020169\">"; >> $pattern .= "([^(
\nPosted on ([0-9]+-[0-9]+-[0-9]+) >> by >> ([^("; >> $pattern .= "
\n([^(\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 >> >> >> ---------------------------(end of >> broadcast)--------------------------- >> TIP 9: the planner will ignore your desire to choose an index scan if >> your >> joining column's datatypes do not match > > > __________________________________ > Do you Yahoo!? > Yahoo! Mail SpamGuard - Read only the mail you want. > http://antispam.yahoo.com/tools From xgbe@yahoo.com Sat Jun 6 06:14:40 2026 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 8FA51D1B456 for ; Thu, 19 Feb 2004 18:49:48 +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 75156-04 for ; Thu, 19 Feb 2004 14:49:46 -0400 (AST) Received: from web40004.mail.yahoo.com (web40004.mail.yahoo.com [66.218.78.22]) by svr1.postgresql.org (Postfix) with SMTP id CE2D5D1D4E7 for ; Thu, 19 Feb 2004 14:49:44 -0400 (AST) Message-ID: <20040219184944.71602.qmail@web40004.mail.yahoo.com> Received: from [64.83.34.44] by web40004.mail.yahoo.com via HTTP; Thu, 19 Feb 2004 10:49:44 PST Date: Thu, 19 Feb 2004 10:49:44 -0800 (PST) From: Chris Ryan Subject: Re: Feeds Integration To: David Costa Cc: PostgreSQL WWW Mailing List In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/144 X-Sequence-Number: 3709 > > Umh, so what about the link ? is it part of the body ? if that is the > > case it might be a problem, can solve that, just not the fast way to > produce the xml from db data. > Here is an updated query. The URL had slipped my mind as one I build the URLs from knows practices on GBorg and the body is actually the full story. You'll note as well in the query below that I added in for getting the submitter of the news item. SELECT headline AS title, 'http://gborg.postgresql.org/project/'||project_name||'/news/newsfull.php?news_id='||news_id AS link, -- the fully built url to the news item body, -- the full news text you may want to abbreviate here member_name AS author, -- member name on gborg of author submit_date -- date not datetime :( FROM project_news, project, member WHERE (project_news.project_id=project.project_id) AND (project_news.member_id=member.member_id) AND (project_news.active=true) AND (project_news.on_homepage=true) ORDER BY submit_date DESC LIMIT 10; Chris Ryan __________________________________ Do you Yahoo!? Yahoo! Mail SpamGuard - Read only the mail you want. http://antispam.yahoo.com/tools From geeks@dotgeek.org Sat Jun 6 06:14:40 2026 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 B1530D1E163 for ; Thu, 19 Feb 2004 18:53:08 +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 80297-01 for ; Thu, 19 Feb 2004 14:53:03 -0400 (AST) Received: from php.gurugeek.org (unknown [213.174.166.198]) by svr1.postgresql.org (Postfix) with ESMTP id 5EC42D1E0F6 for ; Thu, 19 Feb 2004 14:53:01 -0400 (AST) Received: from [127.0.0.1] (localhost [127.0.0.1]) by php.gurugeek.org (Postfix) with ESMTP id B3BBD1EF0CF; Thu, 19 Feb 2004 19:53:00 +0100 (CET) In-Reply-To: <200402190955.17871.josh@agliodbs.com> References: <2945B21A-62F3-11D8-BA87-000A95EB456A@dotgeek.org> <200402190955.17871.josh@agliodbs.com> Mime-Version: 1.0 (Apple Message framework v609) Content-Type: text/plain; charset=ISO-8859-1; delsp=yes; format=flowed Message-Id: Content-Transfer-Encoding: quoted-printable Cc: PostgreSQL WWW Mailing List From: David Costa Subject: Re: Feeds Integration Date: Thu, 19 Feb 2004 19:52:59 +0100 To: josh@agliodbs.com X-Mailer: Apple Mail (2.609) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/145 X-Sequence-Number: 3710 On Feb 19, 2004, at 6:55 PM, Josh Berkus wrote: > David, > >> 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). > > If it makes any difference, we are currently discussing the=20=20 > possibility of a > gradual migration from GBorg to GForge. More discussion to come on=20= =20 > -hackers > and this list later. Umh no difference to me unless you change the db schema. Even then, I=20=20 will just need to move things around in the query then I am done. > > Second, we have a reason to want to *import* and RSS feed. > Opensourcexperts.com is ready to do PostgreSQL job listings, and they=20= =20 > will > publish them to us via RSS. Looks like a great add on, kudos > Can you help with this once you're done with > our RSS export? > by all means. Parsing an existing XML feed is fairly simple=A9 Amazing how important and useful are XML feeds to open source projects.=20= =20 I suspect that many news sites like slashdot generate a huge amount of traffic from their XML syndication. Perhaps we might even get some of=20= =20 the major sites like O'Reilly to use our feeds. Worth a try;) All the best David Costa P.S. am I right assuming that all our discussions are live online on=20=20 the news list comp.db.postgresql.advocacy ? seems so at http://news.gmane.org/group/gmane.comp.db.postgresql.advocacy/last=3D/=20 force_load=3Dt just curious > --=20 > -Josh Berkus > Aglio Database Solutions > San Francisco > From geeks@dotgeek.org Sat Jun 6 06:14:40 2026 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 94516D1D16D for ; Thu, 19 Feb 2004 20:29:45 +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 08693-07 for ; Thu, 19 Feb 2004 16:29:40 -0400 (AST) Received: from php.gurugeek.org (unknown [213.174.166.198]) by svr1.postgresql.org (Postfix) with ESMTP id 8B70DD1DF05 for ; Thu, 19 Feb 2004 16:29:37 -0400 (AST) Received: from [127.0.0.1] (localhost [127.0.0.1]) by php.gurugeek.org (Postfix) with ESMTP id 2D8CD1EF55A; Thu, 19 Feb 2004 21:29:38 +0100 (CET) In-Reply-To: <20040219184944.71602.qmail@web40004.mail.yahoo.com> References: <20040219184944.71602.qmail@web40004.mail.yahoo.com> Mime-Version: 1.0 (Apple Message framework v609) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <5655F306-631A-11D8-BA87-000A95EB456A@dotgeek.org> Content-Transfer-Encoding: 7bit Cc: PostgreSQL WWW Mailing List From: David Costa Subject: Re: Feeds Integration Date: Thu, 19 Feb 2004 21:29:37 +0100 To: Chris Ryan X-Mailer: Apple Mail (2.609) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/146 X-Sequence-Number: 3711 > > Here is an updated query. The URL had slipped my mind as one I > build the URLs from knows practices on GBorg and the body is actually > the full story. You'll note as well in the query below that I added in > for getting the submitter of the news item. > > SELECT headline AS title, > > 'http://gborg.postgresql.org/project/'||project_name||'/news/ > newsfull.php?news_id='||news_id > AS link, -- the fully built url to the news item > body, -- the full news text you may want to abbreviate here > member_name AS author, -- member name on gborg of author > submit_date -- date not datetime :( > FROM project_news, project, member > WHERE (project_news.project_id=project.project_id) > AND (project_news.member_id=member.member_id) > AND (project_news.active=true) > AND (project_news.on_homepage=true) > ORDER BY submit_date DESC > LIMIT 10; > Okay. I will need a sample db table table if you want me to test it. Else I don't physically have where to run the query :D Or perhaps I do the script, leave it on my webspace and let you/Marc or Dave to try this out. That would work for me, I don't really need any further access. Without the db I can still do the script ready to run but I cannot test if the query returns what we would expect or not. Thanks again for your support, cheers David Costa > > > Chris Ryan > > > __________________________________ > Do you Yahoo!? > Yahoo! Mail SpamGuard - Read only the mail you want. > http://antispam.yahoo.com/tools From xgbe@yahoo.com Sat Jun 6 06:14:40 2026 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 17A30D1B860 for ; Thu, 19 Feb 2004 20:43:33 +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 13721-05 for ; Thu, 19 Feb 2004 16:43:11 -0400 (AST) Received: from web40010.mail.yahoo.com (web40010.mail.yahoo.com [66.218.78.28]) by svr1.postgresql.org (Postfix) with SMTP id 8E9FED1E0D2 for ; Thu, 19 Feb 2004 16:43:09 -0400 (AST) Message-ID: <20040219204310.97623.qmail@web40010.mail.yahoo.com> Received: from [64.83.34.44] by web40010.mail.yahoo.com via HTTP; Thu, 19 Feb 2004 12:43:10 PST Date: Thu, 19 Feb 2004 12:43:10 -0800 (PST) From: Chris Ryan Subject: Re: Feeds Integration To: David Costa Cc: PostgreSQL WWW Mailing List In-Reply-To: <5655F306-631A-11D8-BA87-000A95EB456A@dotgeek.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/147 X-Sequence-Number: 3712 If you provide a script I can work through any specific issues during implementation. Chris Ryan --- David Costa wrote: > > > > Here is an updated query. The URL had slipped my mind as one I > > build the URLs from knows practices on GBorg and the body is > actually > > the full story. You'll note as well in the query below that I added > in > > for getting the submitter of the news item. > > > > SELECT headline AS title, > > > > 'http://gborg.postgresql.org/project/'||project_name||'/news/ > > newsfull.php?news_id='||news_id > > AS link, -- the fully built url to the news item > > body, -- the full news text you may want to abbreviate > here > > member_name AS author, -- member name on gborg of author > > submit_date -- date not datetime :( > > FROM project_news, project, member > > WHERE (project_news.project_id=project.project_id) > > AND (project_news.member_id=member.member_id) > > AND (project_news.active=true) > > AND (project_news.on_homepage=true) > > ORDER BY submit_date DESC > > LIMIT 10; > > > > Okay. I will need a sample db table table if you want me to test it. > > Else I don't physically have where to run the query :D > > Or perhaps I do the script, leave it on my webspace and let you/Marc > or > Dave to try this out. That would work for me, I don't really need any > > further access. Without the db I can > still do the script ready to run but I cannot test if the query > returns > what we would expect or not. > > Thanks again for your support, > cheers > David Costa > > > > > > > Chris Ryan > > > > > > __________________________________ > > Do you Yahoo!? > > Yahoo! Mail SpamGuard - Read only the mail you want. > > http://antispam.yahoo.com/tools > > > ---------------------------(end of > broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster __________________________________ Do you Yahoo!? Yahoo! Mail SpamGuard - Read only the mail you want. http://antispam.yahoo.com/tools From dpage@vale-housing.co.uk Sat Jun 6 06:13:59 2026 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 187FAD1E152 for ; Fri, 20 Feb 2004 08:33:35 +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 77703-07 for ; Fri, 20 Feb 2004 04:33:34 -0400 (AST) Received: from anchor-post-37.mail.demon.net (anchor-post-36.mail.demon.net [194.217.242.86]) by svr1.postgresql.org (Postfix) with ESMTP id 1E4A5D1E0F6 for ; Fri, 20 Feb 2004 04:33:23 -0400 (AST) Received: from mailgate.vale-housing.co.uk ([80.176.1.146] helo=salem.vale-housing.co.uk) by anchor-post-37.mail.demon.net with esmtp (Exim 3.35 #1) id 1Au663-0009Oq-0b; Fri, 20 Feb 2004 08:33:19 +0000 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0 Subject: Re: Feeds Integration Date: Fri, 20 Feb 2004 08:08:34 -0000 Message-ID: <03AF4E498C591348A42FC93DEA9661B889F414@mail.vale-housing.co.uk> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [pgsql-www] Feeds Integration Thread-Index: AcP3EeULnR9jU5zORjSp5px3eeO6LgAdsXvw From: "Dave Page" To: , "David Costa" , "PostgreSQL WWW Mailing List" X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/148 X-Sequence-Number: 3713 =20 > -----Original Message----- > From: Josh Berkus [mailto:josh@agliodbs.com]=20 > Sent: 19 February 2004 17:55 > To: David Costa; PostgreSQL WWW Mailing List > Subject: Re: [pgsql-www] Feeds Integration >=20 > David, >=20 > > I plan to move forward with a gborg and events feed. This as a nice=20 > > addition of the existing one (beta version on dotgeek.org). >=20 > If it makes any difference, we are currently discussing the=20 > possibility of a=20 > gradual migration from GBorg to GForge. More discussion to=20 > come on -hackers=20 > and this list later. I thought we had agreed not to do that in the end? Regards, Dave. From geeks@dotgeek.org Sat Jun 6 06:14:40 2026 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 9012DD1E137 for ; Fri, 20 Feb 2004 14:26:22 +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 91532-04 for ; Fri, 20 Feb 2004 10:26:22 -0400 (AST) Received: from php.gurugeek.org (unknown [213.174.166.198]) by svr1.postgresql.org (Postfix) with ESMTP id 3889BD1E14D for ; Fri, 20 Feb 2004 10:26:02 -0400 (AST) Received: from [127.0.0.1] (localhost [127.0.0.1]) by php.gurugeek.org (Postfix) with ESMTP id 233691F04CE; Fri, 20 Feb 2004 15:26:05 +0100 (CET) In-Reply-To: <20040219204310.97623.qmail@web40010.mail.yahoo.com> References: <20040219204310.97623.qmail@web40010.mail.yahoo.com> Mime-Version: 1.0 (Apple Message framework v609) Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: Content-Transfer-Encoding: 7bit Cc: PostgreSQL WWW Mailing List From: David Costa Subject: Re: Feeds Integration Date: Fri, 20 Feb 2004 15:26:03 +0100 To: Chris Ryan X-Mailer: Apple Mail (2.609) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/149 X-Sequence-Number: 3714 On Feb 19, 2004, at 9:43 PM, Chris Ryan wrote: > If you provide a script I can work through any specific issues > during implementation. > Okay I will email you directly re: implementation :D > Chris Ryan > > --- David Costa wrote: >>> >>> Here is an updated query. The URL had slipped my mind as one I >>> build the URLs from knows practices on GBorg and the body is >> actually >>> the full story. You'll note as well in the query below that I added >> in >>> for getting the submitter of the news item. >>> >>> SELECT headline AS title, >>> >>> 'http://gborg.postgresql.org/project/'||project_name||'/news/ >>> newsfull.php?news_id='||news_id >>> AS link, -- the fully built url to the news item >>> body, -- the full news text you may want to abbreviate >> here >>> member_name AS author, -- member name on gborg of author >>> submit_date -- date not datetime :( >>> FROM project_news, project, member >>> WHERE (project_news.project_id=project.project_id) >>> AND (project_news.member_id=member.member_id) >>> AND (project_news.active=true) >>> AND (project_news.on_homepage=true) >>> ORDER BY submit_date DESC >>> LIMIT 10; >>> >> >> Okay. I will need a sample db table table if you want me to test it. >> >> Else I don't physically have where to run the query :D >> >> Or perhaps I do the script, leave it on my webspace and let you/Marc >> or >> Dave to try this out. That would work for me, I don't really need any >> >> further access. Without the db I can >> still do the script ready to run but I cannot test if the query >> returns >> what we would expect or not. >> >> Thanks again for your support, >> cheers >> David Costa >> >>> >>> >>> Chris Ryan >>> >>> >>> __________________________________ >>> Do you Yahoo!? >>> Yahoo! Mail SpamGuard - Read only the mail you want. >>> http://antispam.yahoo.com/tools >> >> >> ---------------------------(end of >> broadcast)--------------------------- >> TIP 4: Don't 'kill -9' the postmaster > > > __________________________________ > Do you Yahoo!? > Yahoo! Mail SpamGuard - Read only the mail you want. > http://antispam.yahoo.com/tools From geeks@dotgeek.org Sat Jun 6 06:14:40 2026 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 BD321D1E0F1 for ; Fri, 20 Feb 2004 14:41:49 +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 94883-06 for ; Fri, 20 Feb 2004 10:41:49 -0400 (AST) Received: from php.gurugeek.org (unknown [213.174.166.198]) by svr1.postgresql.org (Postfix) with ESMTP id E7FEDD1E14D for ; Fri, 20 Feb 2004 10:41:44 -0400 (AST) Received: from [127.0.0.1] (localhost [127.0.0.1]) by php.gurugeek.org (Postfix) with ESMTP id C16BA1F05B7; Fri, 20 Feb 2004 15:41:48 +0100 (CET) In-Reply-To: <20040219184944.71602.qmail@web40004.mail.yahoo.com> References: <20040219184944.71602.qmail@web40004.mail.yahoo.com> Mime-Version: 1.0 (Apple Message framework v609) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Content-Transfer-Encoding: 7bit Cc: PostgreSQL WWW Mailing List From: David Costa Subject: Re: Feeds Integration Date: Fri, 20 Feb 2004 15:41:47 +0100 To: Chris Ryan X-Mailer: Apple Mail (2.609) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/150 X-Sequence-Number: 3715 Sorry Chris, something missing on the query. You need a title too, like pgin.tcl-2.0.0 released title, link, description, date. Now the link is there, description will be the body, date whatever we have but we need the title too. Bottom line, I need something AS title too. In preparation of our tests (I will send the scripts to you) you need to do this: pear install XML_RPC and then pear list to check if pear DB is there too (just in case). Let me know when you are done ;) Cheers David On Feb 19, 2004, at 7:49 PM, Chris Ryan wrote: > >> >> Umh, so what about the link ? is it part of the body ? if that is the >> >> case it might be a problem, can solve that, just not the fast way to >> produce the xml from db data. >> > > Here is an updated query. The URL had slipped my mind as one I > build the URLs from knows practices on GBorg and the body is actually > the full story. You'll note as well in the query below that I added in > for getting the submitter of the news item. > > SELECT headline AS title, > > 'http://gborg.postgresql.org/project/'||project_name||'/news/ > newsfull.php?news_id='||news_id > AS link, -- the fully built url to the news item > body, -- the full news text you may want to abbreviate here > member_name AS author, -- member name on gborg of author > submit_date -- date not datetime :( > FROM project_news, project, member > WHERE (project_news.project_id=project.project_id) > AND (project_news.member_id=member.member_id) > AND (project_news.active=true) > AND (project_news.on_homepage=true) > ORDER BY submit_date DESC > LIMIT 10; > > > > Chris Ryan > > > __________________________________ > Do you Yahoo!? > Yahoo! Mail SpamGuard - Read only the mail you want. > http://antispam.yahoo.com/tools From xgbe@yahoo.com Sat Jun 6 06:14:40 2026 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 2AF2BD1E0F1 for ; Fri, 20 Feb 2004 14:48:52 +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 98245-06 for ; Fri, 20 Feb 2004 10:48:53 -0400 (AST) Received: from web40009.mail.yahoo.com (web40009.mail.yahoo.com [66.218.78.27]) by svr1.postgresql.org (Postfix) with SMTP id 52394D1B456 for ; Fri, 20 Feb 2004 10:48:49 -0400 (AST) Message-ID: <20040220144853.35877.qmail@web40009.mail.yahoo.com> Received: from [64.83.34.44] by web40009.mail.yahoo.com via HTTP; Fri, 20 Feb 2004 06:48:53 PST Date: Fri, 20 Feb 2004 06:48:53 -0800 (PST) From: Chris Ryan Subject: Re: Feeds Integration To: David Costa Cc: PostgreSQL WWW Mailing List In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/151 X-Sequence-Number: 3716 --- David Costa wrote: > Sorry Chris, > something missing on the query. > You need a title too, like pgin.tcl-2.0.0 released > title, link, description, date. > I am confused. The first line of the query I sent you, as quoted below, has a title in it. > > > > SELECT headline AS title, > > Everything else you mentioned is completed. Chris Ryan __________________________________ Do you Yahoo!? Yahoo! Mail SpamGuard - Read only the mail you want. http://antispam.yahoo.com/tools From xgbe@yahoo.com Sat Jun 6 06:14:39 2026 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 9C4D0D1E15F for ; Fri, 20 Feb 2004 15:49:02 +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 23206-03 for ; Fri, 20 Feb 2004 11:48:58 -0400 (AST) Received: from web40005.mail.yahoo.com (web40005.mail.yahoo.com [66.218.78.23]) by svr1.postgresql.org (Postfix) with SMTP id 8EAF7D1DF93 for ; Fri, 20 Feb 2004 11:48:52 -0400 (AST) Message-ID: <20040220154844.42752.qmail@web40005.mail.yahoo.com> Received: from [64.83.34.44] by web40005.mail.yahoo.com via HTTP; Fri, 20 Feb 2004 07:48:44 PST Date: Fri, 20 Feb 2004 07:48:44 -0800 (PST) From: Chris Ryan Subject: Re: Feeds Integration To: David Costa Cc: pgsql-www@postgresql.org In-Reply-To: <0FD4FCF2-63B7-11D8-BEFA-000A95EB456A@dotgeek.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/152 X-Sequence-Number: 3717 --- 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 From devrim@gunduz.org Sat Jun 6 06:14:39 2026 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 26CDFD1C511 for ; Fri, 20 Feb 2004 16:03:59 +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 29193-03 for ; Fri, 20 Feb 2004 12:03:54 -0400 (AST) Received: from emo.org.tr (emo.org.tr [195.142.105.9]) by svr1.postgresql.org (Postfix) with ESMTP id 00010D1B456 for ; Fri, 20 Feb 2004 12:03:53 -0400 (AST) Received: by emo.org.tr (Postfix, from userid 41643) id DA117EE49A; Fri, 20 Feb 2004 18:03:48 +0200 (EET) Received: from localhost (localhost [127.0.0.1]) by emo.org.tr (Postfix) with ESMTP id CE6A6EE490; Fri, 20 Feb 2004 18:03:48 +0200 (EET) Date: Fri, 20 Feb 2004 18:03:45 +0200 (EET) From: Devrim GUNDUZ X-X-Sender: devrim2@emo.org.tr To: Chris Ryan Cc: PostgreSQL WWW Mailing List Subject: Re: Feeds Integration In-Reply-To: <20040220154844.42752.qmail@web40005.mail.yahoo.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/153 X-Sequence-Number: 3718 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, On Fri, 20 Feb 2004, Chris Ryan wrote: > > 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. I've tested it with Evolution now. It looks really perfect. Thanks guys. Regards, - -- Devrim GUNDUZ devrim@gunduz.org devrim.gunduz@linux.org.tr http://www.TDMSoft.com http://www.gunduz.org -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFANi/ktl86P3SPfQ4RAtAiAJ9V4l/8ugow1tYLV1DeGIkihdRDQQCaA3AE okK64IyRlisYvH863sRQpEU= =00s7 -----END PGP SIGNATURE----- From geeks@dotgeek.org Sat Jun 6 06:14:39 2026 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 925B2D1E14E for ; Fri, 20 Feb 2004 16:05:51 +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 21199-10 for ; Fri, 20 Feb 2004 12:05:41 -0400 (AST) Received: from php.gurugeek.org (unknown [213.174.166.198]) by svr1.postgresql.org (Postfix) with ESMTP id 7DCD2D1DF7F for ; Fri, 20 Feb 2004 12:05:40 -0400 (AST) Received: from [127.0.0.1] (localhost [127.0.0.1]) by php.gurugeek.org (Postfix) with ESMTP id E173E1F08CC; Fri, 20 Feb 2004 17:05:24 +0100 (CET) In-Reply-To: <20040220154844.42752.qmail@web40005.mail.yahoo.com> References: <20040220154844.42752.qmail@web40005.mail.yahoo.com> Mime-Version: 1.0 (Apple Message framework v609) Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: <972E3B5C-63BE-11D8-BEFA-000A95EB456A@dotgeek.org> Content-Transfer-Encoding: 7bit Cc: pgsql-www@postgresql.org From: David Costa Subject: Re: Feeds Integration Date: Fri, 20 Feb 2004 17:05:23 +0100 To: Chris Ryan X-Mailer: Apple Mail (2.609) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/154 X-Sequence-Number: 3719 On Feb 20, 2004, at 4:48 PM, Chris Ryan wrote: > > > 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. > Okay a live parsed feed is at http://php.gurugeek.org/parser.php as you can see there are some little problems The date is not produced by the feed submit_date (see source on http://gborg.postgresql.org/news.rss) The author is not grabbed by this specific parser but is something we can solve. This parser is somehow strict, I have another one if you want me to try with that one, I can have a page up soon or I can email you the source of a "non that strict" parser ? ;) > Good Job Dave. > > Chris Ryan > > > __________________________________ > Do you Yahoo!? > Yahoo! Mail SpamGuard - Read only the mail you want. > http://antispam.yahoo.com/tools From geeks@dotgeek.org Sat Jun 6 06:14:39 2026 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 06BB8D1E14E for ; Fri, 20 Feb 2004 16:09:24 +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 33750-01 for ; Fri, 20 Feb 2004 12:09:11 -0400 (AST) Received: from php.gurugeek.org (unknown [213.174.166.198]) by svr1.postgresql.org (Postfix) with ESMTP id C1E9AD1D4E7 for ; Fri, 20 Feb 2004 12:09:10 -0400 (AST) Received: from [127.0.0.1] (localhost [127.0.0.1]) by php.gurugeek.org (Postfix) with ESMTP id 322581F08F7 for ; Fri, 20 Feb 2004 17:09:10 +0100 (CET) Mime-Version: 1.0 (Apple Message framework v609) In-Reply-To: References: Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: <1CB44DA6-63BF-11D8-BEFA-000A95EB456A@dotgeek.org> Content-Transfer-Encoding: 7bit From: David Costa Subject: Re: Feeds Integration Date: Fri, 20 Feb 2004 17:09:07 +0100 To: PostgreSQL WWW Mailing List X-Mailer: Apple Mail (2.609) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/155 X-Sequence-Number: 3720 On Feb 20, 2004, at 5:03 PM, Devrim GUNDUZ wrote: > > On Fri, 20 Feb 2004, Chris Ryan wrote: > >> >> 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. > > I've tested it with Evolution now. It looks really perfect. Hi Devrim :D umh, does it looks like this http://php.gurugeek.org/parser.php or you can also see the author ? thanks again for your feedback :D David Costa > > Thanks guys. > > Regards, > - -- > Devrim GUNDUZ > devrim@gunduz.org devrim.gunduz@linux.org.tr > http://www.TDMSoft.com > http://www.gunduz.org > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.2.1 (GNU/Linux) > > iD8DBQFANi/ktl86P3SPfQ4RAtAiAJ9V4l/8ugow1tYLV1DeGIkihdRDQQCaA3AE > okK64IyRlisYvH863sRQpEU= > =00s7 > -----END PGP SIGNATURE----- > > > ---------------------------(end of > broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html From devrim@gunduz.org Sat Jun 6 06:14:39 2026 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 B5DD3D1DD5D for ; Fri, 20 Feb 2004 16:17:34 +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 33992-04 for ; Fri, 20 Feb 2004 12:17:25 -0400 (AST) Received: from emo.org.tr (emo.org.tr [195.142.105.9]) by svr1.postgresql.org (Postfix) with ESMTP id 05717D1B456 for ; Fri, 20 Feb 2004 12:17:24 -0400 (AST) Received: by emo.org.tr (Postfix, from userid 41643) id CD2C1EE490; Fri, 20 Feb 2004 18:17:16 +0200 (EET) Received: from localhost (localhost [127.0.0.1]) by emo.org.tr (Postfix) with ESMTP id C7FCDEE438; Fri, 20 Feb 2004 18:17:16 +0200 (EET) Date: Fri, 20 Feb 2004 18:17:11 +0200 (EET) From: Devrim GUNDUZ X-X-Sender: devrim2@emo.org.tr To: David Costa Cc: PostgreSQL WWW Mailing List Subject: Re: Feeds Integration In-Reply-To: <1CB44DA6-63BF-11D8-BEFA-000A95EB456A@dotgeek.org> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/156 X-Sequence-Number: 3721 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, On Fri, 20 Feb 2004, David Costa wrote: > umh, does it looks like this http://php.gurugeek.org/parser.php or you > can also see the author ? Here is a screenshot from Evolution: http://www.gunduz.org/gborg-rss.png Regards, - -- Devrim GUNDUZ devrim@gunduz.org devrim.gunduz@linux.org.tr http://www.TDMSoft.com http://www.gunduz.org -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFANjMMtl86P3SPfQ4RAhJAAKCv0OYaos0Pibt5qsxT0VxPcoTWlwCeOtZn 2sZFxkS/9z5ji3Icjx4AyyY= =lAwe -----END PGP SIGNATURE----- From xgbe@yahoo.com Sat Jun 6 06:14:39 2026 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 8A586D1E157 for ; Fri, 20 Feb 2004 16:20: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 31137-06 for ; Fri, 20 Feb 2004 12:20:46 -0400 (AST) Received: from web40015.mail.yahoo.com (web40015.mail.yahoo.com [66.218.78.55]) by svr1.postgresql.org (Postfix) with SMTP id 2292FD1E0FF for ; Fri, 20 Feb 2004 12:20:45 -0400 (AST) Message-ID: <20040220162043.86577.qmail@web40015.mail.yahoo.com> Received: from [64.83.34.44] by web40015.mail.yahoo.com via HTTP; Fri, 20 Feb 2004 08:20:43 PST Date: Fri, 20 Feb 2004 08:20:43 -0800 (PST) From: Chris Ryan Subject: Re: Feeds Integration To: David Costa Cc: pgsql-www@postgresql.org In-Reply-To: <972E3B5C-63BE-11D8-BEFA-000A95EB456A@dotgeek.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/157 X-Sequence-Number: 3722 I've corrected the date and posted the updated news.rss. Chris Ryan --- David Costa wrote: > > On Feb 20, 2004, at 4:48 PM, Chris Ryan wrote: > > > > > > 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. > > > Okay a live parsed feed is at http://php.gurugeek.org/parser.php > as you can see there are some little problems > The date is not produced by the feed submit_date (see > source on http://gborg.postgresql.org/news.rss) > The author is not grabbed by this specific parser but is something we > > can solve. > > This parser is somehow strict, I have another one if you want me to > try > with that one, I can have a page up soon or I can email you the > source > of a "non that strict" > parser ? ;) > > > > 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!? Yahoo! Mail SpamGuard - Read only the mail you want. http://antispam.yahoo.com/tools From geeks@dotgeek.org Sat Jun 6 06:14:39 2026 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 06064D1E133 for ; Fri, 20 Feb 2004 16:29:46 +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 33750-08 for ; Fri, 20 Feb 2004 12:29:35 -0400 (AST) Received: from php.gurugeek.org (unknown [213.174.166.198]) by svr1.postgresql.org (Postfix) with ESMTP id 1CFB9D1E0FF for ; Fri, 20 Feb 2004 12:29:34 -0400 (AST) Received: from [127.0.0.1] (localhost [127.0.0.1]) by php.gurugeek.org (Postfix) with ESMTP id 024FC1F0A13; Fri, 20 Feb 2004 17:29:33 +0100 (CET) In-Reply-To: <20040220162043.86577.qmail@web40015.mail.yahoo.com> References: <20040220162043.86577.qmail@web40015.mail.yahoo.com> Mime-Version: 1.0 (Apple Message framework v609) Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: Content-Transfer-Encoding: 7bit Cc: pgsql-www@postgresql.org From: David Costa Subject: Re: Feeds Integration Date: Fri, 20 Feb 2004 17:29:33 +0100 To: Chris Ryan X-Mailer: Apple Mail (2.609) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/158 X-Sequence-Number: 3723 On Feb 20, 2004, at 5:20 PM, Chris Ryan wrote: > > I've corrected the date and posted the updated news.rss. > > Chris Ryan Hello Chris, thanks for your prompt fix. looks fine to me. Now there is a caveat ;) Rss 1.0 which I used on this script allows only title, link description therefore some parsers might arbitrarily ignore any other tags or complain. Rss 2.0 has author and data capability but is sort of silly because pretends a formation like author@domain.suffix which for spam purposes is rarely used. Let's see if someone else has a feedback I will test it with some other parsers too just in case. So far so good. thanks to Devrim for trying this out. Regards David Costa > > --- David Costa wrote: >> >> On Feb 20, 2004, at 4:48 PM, Chris Ryan wrote: >>> >>> >>> 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. >>> >> Okay a live parsed feed is at http://php.gurugeek.org/parser.php >> as you can see there are some little problems >> The date is not produced by the feed submit_date (see >> source on http://gborg.postgresql.org/news.rss) >> The author is not grabbed by this specific parser but is something we >> >> can solve. >> >> This parser is somehow strict, I have another one if you want me to >> try >> with that one, I can have a page up soon or I can email you the >> source >> of a "non that strict" >> parser ? ;) >> >> >>> 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!? > Yahoo! Mail SpamGuard - Read only the mail you want. > http://antispam.yahoo.com/tools From josh@agliodbs.com Sat Jun 6 06:13:59 2026 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 D7880D1DD04 for ; Fri, 20 Feb 2004 17:22:58 +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 48205-08 for ; Fri, 20 Feb 2004 13:22:53 -0400 (AST) Received: from davinci.ethosmedia.com (server228.ethosmedia.com [209.128.84.228]) by svr1.postgresql.org (Postfix) with ESMTP id 8F7C9D1DD5D for ; Fri, 20 Feb 2004 13:22:52 -0400 (AST) Received: from [63.195.55.98] (HELO 192.168.1.29) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 4462896; Fri, 20 Feb 2004 09:23:58 -0800 From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: "Dave Page" , "David Costa" , "PostgreSQL WWW Mailing List" Subject: Re: Feeds Integration Date: Fri, 20 Feb 2004 09:22:00 -0800 User-Agent: KMail/1.5.4 References: <03AF4E498C591348A42FC93DEA9661B889F414@mail.vale-housing.co.uk> In-Reply-To: <03AF4E498C591348A42FC93DEA9661B889F414@mail.vale-housing.co.uk> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200402200922.00895.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/159 X-Sequence-Number: 3724 Dave, > I thought we had agreed not to do that in the end? Had we? When? My memory ... and e-mailbox ... was that the discussion had been tabled because of the lack of an administrator for GForge, and the amount of effort required to migrate off GBorg. However, a number of things have come up in the last few months to make the use of a better collaboration tool more compelling -- enough so that I'm willing to put some work behind it. Also, the GForge community is willing to lend us a significant amount of help, something I don't think anyone looked into. Maybe there were other objections voiced, but I can't find them in the archives. -- -Josh Berkus Aglio Database Solutions San Francisco From dpage@vale-housing.co.uk Sat Jun 6 06:13:59 2026 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 D5E48D1E12C for ; Fri, 20 Feb 2004 19:07:11 +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 96935-10 for ; Fri, 20 Feb 2004 15:07:06 -0400 (AST) Received: from anchor-post-35.mail.demon.net (anchor-post-35.mail.demon.net [194.217.242.85]) by svr1.postgresql.org (Postfix) with ESMTP id E1E4CD1E0BB for ; Fri, 20 Feb 2004 15:07:04 -0400 (AST) Received: from mailgate.vale-housing.co.uk ([80.176.1.146] helo=salem.vale-housing.co.uk) by anchor-post-35.mail.demon.net with esmtp (Exim 3.35 #1) id 1AuFzM-000Eh1-0Z; Fri, 20 Feb 2004 19:07:05 +0000 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0 Subject: Re: Feeds Integration Date: Fri, 20 Feb 2004 19:07:04 -0000 Message-ID: <03AF4E498C591348A42FC93DEA9661B889F44A@mail.vale-housing.co.uk> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [pgsql-www] Feeds Integration Thread-Index: AcP31i/ObALwy1a8Qp6kSZPYNfb4CQADcpmA From: "Dave Page" To: , "David Costa" , "PostgreSQL WWW Mailing List" X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/160 X-Sequence-Number: 3725 =20 > -----Original Message----- > From: Josh Berkus [mailto:josh@agliodbs.com]=20 > Sent: 20 February 2004 17:22 > To: Dave Page; David Costa; PostgreSQL WWW Mailing List > Subject: Re: [pgsql-www] Feeds Integration >=20 > Dave, >=20 > > I thought we had agreed not to do that in the end? >=20 > Had we? When?=20=20=20 >=20 > My memory ... and e-mailbox ... was that the discussion had=20 > been tabled because of the lack of an administrator for=20 > GForge, and the amount of effort required to migrate off GBorg. Well I don't remember the administrator thing, but yes, my recollection is that we had shelved the idea due to the difficulty in migrating people from one platform to the other. > However, a number of things have come up in the last few=20 > months to make the use of a better collaboration tool more=20 > compelling -- enough so that I'm=20 > willing to put some work behind it.=20=20 What's come up recently? I don't remember seeing anything. Still, perhaps it would be worth asking the project owners what they would like to do? As admin for a few myself I would vote against a move. At least one of them would require significant work on my part to migrate. Regards, Dave. From josh@agliodbs.com Sat Jun 6 06:13:59 2026 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 A5FAED1D4E7 for ; Fri, 20 Feb 2004 19:25:58 +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 05056-09 for ; Fri, 20 Feb 2004 15:25:50 -0400 (AST) Received: from davinci.ethosmedia.com (server228.ethosmedia.com [209.128.84.228]) by svr1.postgresql.org (Postfix) with ESMTP id 0491ED1D132 for ; Fri, 20 Feb 2004 15:25:48 -0400 (AST) Received: from [63.195.55.98] (HELO 192.168.1.29) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 4463516 for pgsql-www@postgresql.org; Fri, 20 Feb 2004 11:26:53 -0800 From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: "PostgreSQL WWW Mailing List" Subject: Re: GForge WAS: Feeds Integration Date: Fri, 20 Feb 2004 11:24:36 -0800 User-Agent: KMail/1.5.4 References: <03AF4E498C591348A42FC93DEA9661B889F44A@mail.vale-housing.co.uk> In-Reply-To: <03AF4E498C591348A42FC93DEA9661B889F44A@mail.vale-housing.co.uk> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200402201124.36615.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/161 X-Sequence-Number: 3726 Dave, > What's come up recently? I don't remember seeing anything. It wasn't on public lists, mostly. Let's just say that a few people are *very* dissatisfied with GBorg and might like to try something else. Also, we've been discussing having a bug tracking utility for the main project, particularly for the 7.5 release. > Still, perhaps it would be worth asking the project owners what they > would like to do? As admin for a few myself I would vote against a move. > At least one of them would require significant work on my part to > migrate. Yeah, that's why I said "gradually". What we do first is ask for volunteers, and put *new* projects on GForge. HOWEVER, this is all hypothetical. I need to poll this list and Hackers first and get a vote from people, as well as having an organized proposal -- which is going to wait until we have a blank GForge up and running on Hub.org first. So let's postpone the rest of the discussion until that happens, hey? -- -Josh Berkus Aglio Database Solutions San Francisco From geeks@dotgeek.org Sat Jun 6 06:14:39 2026 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 D4A23D1DA69 for ; Wed, 25 Feb 2004 15:43:01 +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 11394-10 for ; Wed, 25 Feb 2004 11:43:01 -0400 (AST) Received: from php.gurugeek.org (unknown [213.174.166.198]) by svr1.postgresql.org (Postfix) with ESMTP id 498F2D1C9BA for ; Wed, 25 Feb 2004 11:42:51 -0400 (AST) Received: from [127.0.0.1] (localhost [127.0.0.1]) by php.gurugeek.org (Postfix) with ESMTP id 77AF1201755; Wed, 25 Feb 2004 16:42:52 +0100 (CET) In-Reply-To: <20040220154844.42752.qmail@web40005.mail.yahoo.com> References: <20040220154844.42752.qmail@web40005.mail.yahoo.com> Mime-Version: 1.0 (Apple Message framework v609) Content-Type: text/plain; charset=ISO-8859-1; format=flowed Message-Id: <45631796-67A9-11D8-AC86-000A95EB456A@dotgeek.org> Content-Transfer-Encoding: quoted-printable Cc: pgsql-www@postgresql.org From: David Costa Subject: Re: Feeds Integration Date: Wed, 25 Feb 2004 16:42:51 +0100 To: Chris Ryan X-Mailer: Apple Mail (2.609) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/176 X-Sequence-Number: 3741 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. For my news alpha I am using a regex on the postgresql homepage and is=20 not really a good idea=A9 Cheers David On Feb 20, 2004, at 4:48 PM, Chris Ryan wrote: > > --- 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 From xgbe@yahoo.com Sat Jun 6 06:14:40 2026 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 70385D1B973 for ; Thu, 26 Feb 2004 02:47:46 +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 45497-06 for ; Wed, 25 Feb 2004 22:47:46 -0400 (AST) Received: from web40001.mail.yahoo.com (web40001.mail.yahoo.com [66.218.78.19]) by svr1.postgresql.org (Postfix) with SMTP id 85128D1B4DE for ; Wed, 25 Feb 2004 22:47:42 -0400 (AST) Message-ID: <20040226024746.22621.qmail@web40001.mail.yahoo.com> Received: from [68.107.152.214] by web40001.mail.yahoo.com via HTTP; Wed, 25 Feb 2004 18:47:46 PST Date: Wed, 25 Feb 2004 18:47:46 -0800 (PST) From: Chris Ryan Subject: Re: Feeds Integration To: David Costa Cc: pgsql-www@postgresql.org In-Reply-To: <45631796-67A9-11D8-AC86-000A95EB456A@dotgeek.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/177 X-Sequence-Number: 3742 David, It's been a long day and I'm somewhat confused with what you want me to do. Could you clarify? Thanks. Chris Ryan --- 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 > 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 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 From xgbe@yahoo.com Sat Jun 6 06:14:40 2026 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 00A9BD1B967 for ; Thu, 26 Feb 2004 18:28:43 +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 30534-10 for ; Thu, 26 Feb 2004 14:28:38 -0400 (AST) Received: from web40020.mail.yahoo.com (web40020.mail.yahoo.com [66.218.78.60]) by svr1.postgresql.org (Postfix) with SMTP id B7731D1B901 for ; Thu, 26 Feb 2004 14:28:36 -0400 (AST) Message-ID: <20040226182836.85552.qmail@web40020.mail.yahoo.com> Received: from [64.83.34.44] by web40020.mail.yahoo.com via HTTP; Thu, 26 Feb 2004 10:28:36 PST Date: Thu, 26 Feb 2004 10:28:36 -0800 (PST) From: Chris Ryan Subject: Re: Feeds Integration To: David Costa Cc: pgsql-www@postgresql.org In-Reply-To: <45631796-67A9-11D8-AC86-000A95EB456A@dotgeek.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/180 X-Sequence-Number: 3745 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 /XML/. and making sure certain pear packages were installed XML_RPC and XML_Util. Chris Ryan --- 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 > 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 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 From xzilla@users.sourceforge.net Sat Jun 6 06:14:40 2026 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 From xgbe@yahoo.com Sat Jun 6 06:14:40 2026 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 14C1FD1DA39 for ; Fri, 27 Feb 2004 13:31:32 +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 52296-10 for ; Fri, 27 Feb 2004 09:31:31 -0400 (AST) Received: from web40011.mail.yahoo.com (web40011.mail.yahoo.com [66.218.78.29]) by svr1.postgresql.org (Postfix) with SMTP id 66A52D1DA2E for ; Fri, 27 Feb 2004 09:31:27 -0400 (AST) Message-ID: <20040227133130.81673.qmail@web40011.mail.yahoo.com> Received: from [64.83.34.44] by web40011.mail.yahoo.com via HTTP; Fri, 27 Feb 2004 05:31:30 PST Date: Fri, 27 Feb 2004 05:31:30 -0800 (PST) From: Chris Ryan Subject: Re: Feeds Integration To: Robert Treat Cc: David Costa , pgsql-www@postgresql.org In-Reply-To: <1077887687.2784.20.camel@camel> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="0-827372360-1077888690=:81121" X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/221 X-Sequence-Number: 3786 --0-827372360-1077888690=:81121 Content-Type: text/plain; charset=us-ascii Content-Id: Content-Disposition: inline In retrospect it was probably me. Attached this time... i swear... i hope :) Chris Ryan --- Robert Treat 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 /XML/. and making sure > > certain pear packages were installed XML_RPC and XML_Util. > > > > Chris Ryan > > > > > > > > --- 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 > > > 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 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 --0-827372360-1077888690=:81121 Content-Type: application/x-tar; name="rssfeed.tar.gz" Content-Transfer-Encoding: base64 Content-Description: rssfeed.tar.gz Content-Disposition: attachment; filename="rssfeed.tar.gz" H4sIAHE4PkAAA+08a1MbSZL+ChHzH2p7FZZkCwkwttcwYGMjz3BrGx/gufV5 CUWpuyT1udUtd7cQ3Nj//TKzqrqrX5Jg8DwuVDFjRD0ys7LyXSUmQ3Ep/Djq hc6gPRlN7n2Htrm1uflkZ+feJrSnT7I/oT16vLV5D6ZsPd15tLO1/QTmP9p+ +vge2/wexOTbNIp5yNg9O7zm/px5i8b/ou3H53DobH2902H/evuGnZ6dsZ+E L0IeByFzAl+wwGfxSLCtJ+y16OO8/jV7y8P4+pRx32E/TcPpUIjPODIOHHfg Ckev2d7ENbhgqGeth+LL1A1FL/BtwepHL1Ho6nu5biClcyZCl3vu/4pQTQEM HfbeEzwSbOB6HnNj5vps5sYjdh1MQzaNROjzsWixyazFnD4Tsb1ecyKf7bP6 ZBh98XY7HT1pd8KjaBaEzgsvsLk3CqK44/RxBFDVnH4wid3Aj2ApD0N+3Viv O6I/HdaZbPsHbLvFOp31+iQIY953PTe+rmP30cve+5PT88OXx2+Ozz/2Dt+8 YU0gfh2Bsv37ML67awe+L+y4gcTBoDtgDex2o24YBiF095tN9uv62vqasEcB q5/FwGoeOuytiCI+FLusztoMpm0cDEWsOhtN6LP+7Vt7etnRy7dnnQ+w4fJ1 OHLsD4KKhUe43/KVNFRYeuXGe+vfcKcF5lmu74CZsRhL+Ue/WK11y3N90Q8F /2ylYwASRuLrifjZBfOUjgy4FwkY4o5zJGzPMgDG4RRHhG+DHPpDy0D14fz1 xj8QYhgE8Ts4ZHMQTN/u6dFrPXwYx6Hbn8YCsMKw3IF1KcII9kRd1mb72ZbV YtbV2POjXVhv7R9YoziegIDNZrP27FE7CIedrWfPnnU2tzvb2xswZyO69mN+ teFHf7eagMsRAz714nM+lAQhYDcWY2ud5KUGS4hC+F9z0R5xEBzPoAt45Mae Wv0ehHgYirP/fMO6ZNUVd5GxOG5QOJFTQSeIUpi43iS8nc5EqpgTTPueYPZI 2J9Jm79MRXjdhga0wbp9OMCz7pvuq3NGLoQdnjGipbWueFuvxiedTqf+9avr fP1ab4/isVdHCEhti2kI0XQ85uE1DvQD57rFkhGEJ5xen8b4NB4FYYI3DnrA qLAh57RY3XE2xuONj9DqTZw/6Dk8FjD99enJW0l9tM7+6+fuaZc1GtyO3UsB fD8//dBtItDDd0eswSeTMLgE45YfEL5D8NjBPnv14fS0++68d3R43m0ymHNy etQ9ZS8/MnQzMc1rKeLXLTrmL/tSrYi9DeRsmUX4ggbBcQV8yup8U6rcbOR6 MBgGM7QxOGkA1m90GswATu919/zVz29Pjrq9k5f/ASemrQvJ2KcLraaGLCGk jQN5nkzJUNItDwkEOLJDl1TdGJQHZckzMfplB8N1wAQciKb9sSt5IndRixKb D1z2xQx9Ui91BA1tWFBQayBNoD4w0Vi2cZB8buDmcKI7aLBk8v4+mQlGDCBj B62RgQDcTVA6RzzmxOQ1IhAPynEjbb+hH9c/P1j/o/34bdtkCGz+rtHf4vgP wj4d/z3a2nkK8yH821nFf79HW8V/q/hvFf/9/4v/3oFV/52iv5HgDh7hjQJA 9Dp/jvAPKblx8JcJ7SQidtQ9e7WK6VYx3V+qZb3s98ExP/7b2XmCn58+3Xm6 ub21/fixjP+2V/Hf79F+fP7+5/c/rHcesEt3vMsiETNxNYFoA2IaBv9HcTDZ 32HRyB3EM9eJR/s7u+xB5wcM9x5u3El7SMC+MiCE/SK9LNtht2xfvwdlr4LJ degORzFr2E0GXv3pxvbm5jY7B7+IVP8UBtPJH0LZ+ciNWATBr00xsWD467T/ P2DIwA8yFbSw7fYmCwbkx5Fez7WFD1FUhrKvMMxjBNCf+o4HDo0i6xgxTLj9 GTwThtsIgzC9OX7VfXfWbVEWAHNywPgldz2OMQQAjUfAoeGIFkPM7TkbIEti YwbJAYwu4tlXZsYRo0nbF3FH7aGz3dvcbsdXcXtJ0fjKjgeYLjDHdZgfxCwU tkCXz5kNx1zCJtogDwWb+rSfODCABf2YA1fceXuEfEQGVZFASIhVQclRphC+ UHuEg2UziMG4z8bATKJaUemOx8Jxwcl61/mNfxc5OyRHH+2ys1hMIAhlZ/Zo DOaA/RjZoyhGijfiIPAipPvgd9MAAgitduwAaRlX1rpkW+2tHchBNx91tjY7 209AcXcf/WN3e4sRzax7NWG1H9bR+D34YZ09wPwxYu+7h6dMYIAGTPdB6MeQ t+AwIMsmqThTpqYFIBjifIjhyOCUbchs4Lwxu475MCoFhfkuzi+Ck5RAQgNa Bx/8gOmwhmPURCm6Agn5BEThDYviq+7p8eGb4//unva6p6cnp713J0nf4fnx yTvIXh5vNTOosnEZddkeJMnSLiTRVMQueegGUzA0EHXZ8RTCMDAMsFMQC9yl E9hTzTSCQiZEgkJZ7gtkkkPGZBZg0UBEu8lkODXNshw8NgiDMXZSYMuAG4Ey dMpuQYhuQwgNoCEvCEAP5SagQfgOukUci9pgNGH+WHA/apFOIVEaJYNEsAqj tH4a5iDwvGAGeSYezJjHxhZAICEA5kn6q3vTVpLJFSfllhiJXveKj8GmELEa UmshgIpcMFFdRywBxB2DTtyA7EVbkPAW4s2AmYaU98/ZSIfAtofu4Iagl+DR TeBBay4k4AaMLOUg1gyW22XJ9oSE0raD8XI7+277OfRJZ9nd7isIh0vua/Gs 4hS0oInWp8a+zIyQFZSGxAlkGKUtiGk6FhdCjcmFQlvlHkoLcP+OLR0DMnCk cooK+yD0rwZWVbEzgIGJZx/eHf+LUWmIJs8BOLcsJwHiFPSg1UAqC2opVbCe /Ogl96bgtmirPhxS6Nrss7jWFGaO9QYVDL1Cle5oJ5WlDHQRBqKP4IlmWNYe QuSHYR6KrwocEkkiV6ecaOruPPczesvrjNS1NWSCvt023LDIOuI4DSokGHJe iXdHv8fZDORWOloiQJ+CB+IeEiQ/gQEx7hCC4raek2WX3CTklQAZtQBrvDrq pmOR8bbjuMhU7oGnBmpcX3pZ6NJgkaykVKshRFMImCB/Qb8Mh92WGRI4+9gE QdtPSQcmaKDAC4hnEuICSPtcJKLIEsgQ2jqXmHE4m5L4SQKEvRQ2gf20ewgJ WzjDjB7QLqaVb1XZNieoxVr7zfAEBMeXdAZh21zzekqUq5RQMczI7ehYXN/2 po4OvXof0kMNW/L4nUAkeozo0nOX++LTOMAt2tzzrknXgEEpIS8gChPDILxG +LJHE1DGwBc6g2Wb7WftLdmnqo5sTjJCaYicTQG5FkMMslW4LAPSnGyKqxhy NJUF/IrRMdoNCpChPWDKxCScx/2R2Jk80JNfcBsVFBTVvYRdJ90QP6sjq/UU wBMJT03pyJ84Lz/DtPRVrWDrtUVNDbTZwCyCwKDCkDXALUkAxmbK8eTdgMZj uoK5eMCYIoxoHpL8HZBCIu+BypBkJRCVj0zMKGMv5mHMXy0txgg4dLICC3m4 kHN5V6VQWFlx7ME4clI5rszxXKGZRUmIGPWA6cSCBkCbuzdwcsn9lulse9rS /VNcZ/x4wjI2g+DMsIgAiapNaCudRQeYx0kocaAgKBmUpF54eI3Ah7N0ByyR Bm0Wm/NQk47ncBNqGsjjLqCWJgIMpUw0o/lkrFFjVgSCx8PDKHePWC0+coGO SRpSScArIPxWu92UprmfWhk8+iildR4HJqGYgEUzaZlvCtQCrarIhuW0RtqM DKL521bhJprPFEMLuYtVaHBx9R6qcr2FIYfyTrTC8PoROULQcgopeBjLaiOw ChQBXKE3Hc/VQyw+WLlOILqu9LOeJVyFtfXIxdjsCu8sgUzsmvAQKUP1w6MB baWPKCkh9yN0+8hNMBIZ3V1khQKbdMQkbYEVwvCPNGZZQ5RHIbH4U8+rMOHT yQTNqhYQlA9dIKFw2nUogJuGLmv8+iISInG8u7v4dEAiPErJazS/zaMwfyWv KJResFnGh0JQaKQOFU1WwljG19+Vjw8qfXs+eyujwoaAltQEHIAjJvEogwJM hBgKDBNg/MgYzoQQegwQbZagwI152rCA+kMArL2/5iCGvxnE6vRrvShzrVqG PTsDUygQrj05o7DbNHhVXXlGMzaZ9j3XTvpB9fgYP49d1CsjKWaqFIFQsUpP 4rrEoSrqB1PfJh7k0j3z3HArTLmgX1PxqmFkvXGAUSQdqu7HJwBu1JOnnaSN TXOpsTwnHj1IU4eQN8rBXFzYYpksVLVvTIC1WAi+HKQJR378VpSdUEBW4bPD 98c6s1j23CKUsPRXBYhpyWI1HfoXYecPiE9cdXHYSM9ibU2BxNc61t6cHaC7 QQeiGQI2PRfnL70nsHbUAKTkYqPZKmRSmsjCPogUxf1GpVQteW4lW6WN+mpT uT19VIVw9GaxzJkhy3JQZOm2LKDLMkp0qV6QZVkx97wxy4zNa6adLWZZuqYm n/7VKIxaxLxPNPsCeUjzU57hjzIDKasjhh28uWFStwL0j1lzKepAPwg8AYch 37XgNqeEpMUmAmyqvBSC7gF3PUjqK3mTqTW18oaryCSMygbJoY74pYCwUwCk ibDpZWdLyYcYw5FHseBOZrHyFuBBLvGGCOIEeSmFL0LN6HFZO6hGXvLPqbQH BeuUQgRpSMB9sgKwGqHrCKUX1kWT3b/P5owz9ZKoQEip9t3WKJOglRrmZdEE C8EXTDe2Ul+QYbHhmXNrM8c8BmdK194vX+XPlE4gq2pWrLLci0We7lNaB74o HLgBZwkSVTZAEROmqWBDgoIxKA2MMhMKsYtl7WXwmIXTfEyflXIq9xYYUM21 lBXFVZJEyY4SRqVLbyB2CTSLCLaKIlV6dHkWtfeLI4cpB1oJplYp2Uakf9Es P+c812VynhVzxXo59BfiPSRIsjZhXA9kD+GWR3BicOIOziBzGph4zk07kdF5 REZ6e5E84ayyD0U9XJRTVu9QZ7wX8ypHaWsXAKRVz4ubQcjtIsvZrPXqT13P YVdj72YMxarlRZGJkBFnk0xztFoLkof0ALJcDfSMEj1IFy+vBwa4nCdSTMrM Xko04BdTLKyt9qbVSjH9uWRAfzQ/ra3RYRtu+m/7KnyTWc5aMS1IJ+/hjG/4 TwpTR5mocNW5AqN7SKqeyGfW+oKtJGFO1yTlkEwozJLQNknu5pUNsCVBbMnL 7XRWiUGvEgudq5cJnuaIWhtyNxLyjb71LjCrrhS6Jy8b2+xDJHKJyu5uGnU3 2cANo7htqWxm0ZusBdZeUbmsIFUnMXjFS1lP7vjOjbSPvviRlknKL2nxhiWS BVz8fsQkxBeJCkJFlpSvk6kkKUmRVD6WH9dykzrL/AxZ6aEZ+Xr1g5z4VaRL KUd/QRIakpKW6Z5lWdRAkFrVYjKVDf9kWlq0zWjjq0OmHAkZ3MVCTy7quSHK E3NZinOZehIfLnMvyawvfvrGA79Eorc1dxHP3qMYHJi/Dqt++hoU1xmCVdby 2pdjk3zZA3p8zocUXVRERlpLYfWyRYVs5lBWWChXmlToa6n0687SAkOyMLHD Wrax0ZVFacm8HGeqBWbNXZuMAoRihS/Vapa3ssmqwvU9foHqF7zsRLrBxuKr KzRWLbygpAdkeDM54lTHw0uzaT+K3RhocxYqvtS6+5Kdd6X59EOWHnJRBN0+ UdXBSq6UrKK+6iujfdNl6wbsFtweMYUHb59qyAAl8aX+Dun7GxAIWXwDJ5cn OTncdPG0Vz6NQqGSsZwHK+SQ5LAVivIIU4lILvH+LZs3wZZlStL40/olDK/Z lsVVFkUaICGk63TWnGDxK4yyNEC9/biAKJECnlTskmrHwWYlY3IEw6ce3gfz YnKg8bQK4KvYU3LLV9KlrEQINIwbipTlylvV5Z2HD6m4o0Lp3EZKrutzCema hrtA3PT0NYkIFEzC1p4Yz6JRbsZIC1OsCZw1fF4VK3yfcBZl5DRkSOSn/KaK 1/4XbVptVrwRCOUG8t98Eiq/+4vmXIwn8bUy/LBX9chV9mauVXHb1K2tXkbQ MqdmZiS1eDwpSSHL1WPpQ1igRHerPLSFu9KYb1JacQf0bR/Ynsz08PHNP8X1 2v4abnlPT8Lt29zHCxr9ptN4hACMwaK9vtIq3IPX5NOh/QoPS6K5Z2gBMg5v No1vMhOE9LCTqfJgiiWY7Osn43TX2Fo+zV9YvCiUiZMHY3MKSwnogupknytd XMiqHPZqPd5LdZw2iAm5PppUc8uhZ95fEXD13qepIaSKWRCKNVNpTKkrDVIX x+PlrRClA81zI+0KMCVx+/yIvQJOaRzPlqvcUCtE9lmuLbA3S3mYjY3cLf/d WJY7syrfUv8nHSsAlv6mXk/rSGSFVeWtUDZaMsu7RY5XOGEgZN706oSwfFH+ BcatDIaKmWWdlA8/mVRcLDQi1dcINwQ0737G+GgcWxJBV2ayLRnbm2zSWaxc PO9FQcVFzE2yWPU1PrCh8kOQfH95zhV5Pokszx+rUz1V7bivkN4+2cNyfRoq jfnQtRN8WbmThbGeuHKjOGokiK1eL/KEmFhlF+A0Bw5NTmkUdDoVpRuEUDUs 1okwdmlneOck8fQueZgQltcaFdfpqlCJrSq7xSrCqrpFQkkf0ZNa+hssICnO 8zvQ23lRckG5ULskxXn1mgcm98qYlPQWPChqar4amB7bEplplQqXPLrTX1qj b0eZX3nVM8wHQXzGXTyk7LdiC1+H1UtNf/FAkZbxEWVeIpnIMw8/02ef+Xmm B5EAVU8rkS95XNzLraQX8xNui8T7JD3LrvwQulZ2JfRUrNTvmG5T5MPjkc9A B67vZl6hJpP1y6EahAseUNL1Y5f0XBfH6AtONETfVxB6HI5RsYzR98yTA6w2 ueor7VWmNuNnmHQ0BbL0n+4praGVxzqZRB1jb+m9Coo/hhTDpW8flhbOauo1 OZ767QOsZXPKXHUBjD6+bS8W+0zKsoGfxawWJQue8FUIItXoovlwu1mkZc49 awp/MbFzwozyywCT7WU1wwzf8xPMWnnC0SRDok1rVSc2qug1Az8/C/rq9cwl RoIhi8co2GRhlDu7TMYshR0k/TXYT2WuSyW+ZXCopZlRfKVgOO7Kex6eoFlM K5N/SK7Ks2RhtFhGvlolgerCy6ffRNVJKZDfQlYo5F/JWUxYpJP9PHJLiqFV TCfTndxCIObfIxH01HnDf88P/ui/GbVqq7Zqq7Zqq7Zqq7Zqq7Zqq7Zqq7Zq q7Zqq7Zqq7Zqq7Zqf+72fxzTOioAeAAA --0-827372360-1077888690=:81121--