2 // export projects release news in RSS 2.0
3 // Author: Scott Grayban <sgrayban@borgnet.us>
6 require_once '../env.inc.php';
7 require_once $gfwww.'include/pre.php';
8 require_once $gfwww.'export/rss_utils.inc';
10 header("Content-Type: text/xml; charset=utf-8");
11 print '<?xml version="1.0" encoding="UTF-8"?>
14 $group_id = getIntFromRequest('group_id');
15 $limit = getIntFromRequest('limit', 10);
16 if ($limit > 100) $limit = 100;
19 $res = db_query_params ('SELECT group_name FROM groups WHERE group_id=$1 AND is_public=1',
22 $row = db_fetch_array($res);
23 $title = ": ".$row['group_name']." - ";
24 $link = "?group_id=$group_id";
25 $description = " of ".$row['group_name'];
27 $reswm = db_query_params ('SELECT users.user_name,users.realname FROM user_group,users WHERE group_id=$1 AND admin_flags=$2 AND users.user_id=user_group.user_id ORDER BY users.add_date',
31 if ($rowwm = db_fetch_array($reswm)) {
32 $webmaster = $rowwm['user_name']."@".$GLOBALS['sys_users_host']." (".$rowwm['realname'].")";
34 $webmaster = $GLOBALS['sys_admin_email'];
40 $webmaster = $GLOBALS['sys_admin_email'];
43 $rssTitle = $GLOBALS['sys_name']." Project$title News";
44 $rssLink = "http://".$GLOBALS['sys_default_domain']."/news/$link";
48 print " <title>".$rssTitle."</title>\n";
49 print " <link>".$rssLink."</link>\n";
50 print " <description>".$GLOBALS['sys_name']." Project News$description</description>\n";
51 print " <language>en-us</language>\n";
52 print " <copyright>Copyright ".date("Y")." ".$GLOBALS['sys_name']."</copyright>\n";
53 print " <webMaster>$webmaster</webMaster>\n";
54 print " <lastBuildDate>".rss_date(time())."</lastBuildDate>\n";
55 print " <docs>http://blogs.law.harvard.edu/tech/rss</docs>\n";
56 print " <generator>".$GLOBALS['sys_name']." RSS generator</generator>\n";
58 $res = db_query_params ('SELECT forum_id,summary,post_date,details,g.group_id,g.group_name,u.realname,u.user_name
59 FROM news_bytes, groups g,users u
60 WHERE news_bytes.group_id=g.group_id
61 AND u.user_id=news_bytes.submitted_by
64 AND news_bytes.is_approved <> 4
65 AND (g.group_id=$group_id OR 1 != $3)
66 AND (is_approved=1 OR 1 != $4)
67 ORDER BY post_date DESC',
75 while ($row = db_fetch_array($res)) {
77 print " <title>".htmlspecialchars($row['summary'])."</title>\n";
78 // if news group, link is main page
79 if ($row['group_id'] != $sys_news_group) {
80 print " <link>http://".$GLOBALS['sys_default_domain']."/forum/forum.php?forum_id=".$row['forum_id']."</link>\n";
82 print " <link>http://".$GLOBALS['sys_default_domain']."/</link>\n";
84 print " <description>".rss_description($row['details'])."</description>\n";
85 print " <author>".$row['user_name']."@".$GLOBALS['sys_users_host']." (".$row['realname'].")</author>\n";
86 print " <pubDate>".rss_date($row['post_date'])."</pubDate>\n";
87 if ($row['group_id'] != $sys_news_group) {
88 print " <guid>http://".$GLOBALS['sys_default_domain']."/forum/forum.php?forum_id=".$row['forum_id']."</guid>\n";
90 print " <guid>http://".$GLOBALS['sys_default_domain']."/</guid>\n";
92 // if news group, comment is main page
93 if ($row['group_id'] != $sys_news_group) {
94 print " <comments>http://".$GLOBALS['sys_default_domain']."/forum/forum.php?forum_id=".$row['forum_id']."</comments>\n";
96 print " <comments>http://".$GLOBALS['sys_default_domain']."/</comments>\n";
101 print " </channel>\n";