4 * SourceForge Exports: Export front page news in RSS
7 * SourceForge: Breaking Down the Barriers to Open Source Development
8 * Copyright 1999-2001 (c) VA Linux Systems
9 * http://sourceforge.net
13 require_once('../env.inc.php');
14 require_once $gfwww.'include/pre.php';
15 require_once $gfwww.'export/rss_utils.inc';
17 $group_id = getIntFromRequest('group_id');
18 $limit = getIntFromRequest('limit', 10);
19 if ($limit > 100) $limit = 100;
21 header("Content-Type: text/plain");
22 print '<?xml version="1.0" encoding="UTF-8"?>
25 xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
26 xmlns="http://purl.org/rss/1.0/"
27 xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/"
28 xmlns:dc="http://purl.org/dc/elements/1.1/"
29 xmlns:syn="http://purl.org/rss/1.0/modules/syndication/"
30 xmlns:admin="http://webns.net/mvcb/" >';
33 $where = " AND g.group_id='$group_id'";
35 $where = " AND is_approved=1";
37 $sql = "SELECT forum_id,summary,post_date,details,g.group_id,g.group_name,u.realname
38 FROM news_bytes, groups g,users u
39 WHERE news_bytes.group_id=g.group_id
40 AND u.user_id=news_bytes.submitted_by
44 order by post_date desc";
45 $res = db_query($sql, $limit);
47 print "\n <channel rdf:about=".'"'."http://$GLOBALS[sys_default_domain]/export/rss_sfnews.php".'"'.">\n";
48 print " <copyright>Copyright 1999-2000 VA Linux Systems, Inc.</copyright>\n";
49 $grsql = "SELECT group_name from groups where group_id='.$group_id'";
50 $grres = db_query($sql,$limit);
51 $grrow = db_fetch_array($grres);
53 print " <title>".$GLOBALS['sys_name']." Project News</title>\n";
54 print " <link>http://$GLOBALS[sys_default_domain]</link>\n";
55 print " <description>".$GLOBALS['sys_name']." Project News Highlights</description>\n";
59 while ($row = db_fetch_array($res)) {
60 print " <rdf:li rdf:resource=".'"'."http://$GLOBALS[sys_default_domain]/forum/forum.php?forum_id=$row[forum_id]".'"'." />\n";
62 print " </rdf:Seq>\n";
64 print " </channel>\n";
65 $res = db_query($sql, $limit);
66 while ($row = db_fetch_array($res)) {
67 print "\n <item rdf:about=".'"'."http://$GLOBALS[sys_default_domain]/forum/forum.php?forum_id=$row[forum_id]".'"'.">\n";
68 print " <title>".htmlspecialchars($row['summary'])."</title>\n";
69 // if news group, link is main page
70 if ($row['group_id'] != $sys_news_group) {
71 print " <link>http://$GLOBALS[sys_default_domain]/forum/forum.php?forum_id=$row[forum_id]</link>\n";
73 print " <link>http://$GLOBALS[sys_default_domain]/</link>\n";
75 print " <description>".rss_description($row['details'])."</description>\n";
76 print " <dc:subject>".$row['group_name']."</dc:subject>\n";
77 print " <dc:creator>".$row['realname']."</dc:creator>\n";
78 print " <dc:date>".gmdate('D, d M Y g:i:s',$row['post_date'])." GMT</dc:date>\n";