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--