2 // export projects release news in RSS 2.0
3 // Author: Scott Grayban <sgrayban@borgnet.us>
6 include "../env.inc.php";
8 include "rss_utils.inc";
9 header("Content-Type: text/xml");
10 print '<?xml version="1.0" encoding="UTF-8"?>
14 if (!$limit) $limit = 10;
15 if ($limit > 100) $limit = 100;
18 $where = "group_id=$group_id";
19 $query = "SELECT group_name FROM groups WHERE $where";
20 $res = db_query($query,1);
21 $row = db_fetch_array($res);
22 $title = ": ".$row[group_name]." - ";
23 $link = "?group_id=$group_id";
24 $description = " of ".$row[group_name];
25 $querywm = "SELECT users.user_name,users.realname FROM user_group,users WHERE group_id=$group_id AND admin_flags='A' AND users.user_id=user_group.user_id ORDER BY users.add_date";
26 $reswm = db_query($querywm,1);
27 if ($rowwm = db_fetch_array($reswm)) {
28 $webmaster = $rowwm[user_name]."@".$GLOBALS[sys_users_host]." (".$rowwm[realname].")";
30 $webmaster = $GLOBALS[sys_admin_email];
33 $where = "is_approved=1";
37 $webmaster = $GLOBALS[sys_admin_email];
42 print " <title>".$GLOBALS[sys_default_name]." Project$title News</title>\n";
43 print " <link>http://".$GLOBALS[sys_default_domain]."/news/$link</link>\n";
44 print " <description>".$GLOBALS[sys_name]." Project News$description</description>\n";
45 print " <language>en-us</language>\n";
46 print " <copyright>Copyright 2000-".date("Y")." ".$GLOBALS[sys_name]." OSI</copyright>\n";
47 print " <webMaster>$webmaster</webMaster>\n";
48 print " <lastBuildDate>".gmdate('D, d M Y G:i:s',time())." GMT</lastBuildDate>\n";
49 print " <docs>http://blogs.law.harvard.edu/tech/rss</docs>\n";
50 print " <generator>".$GLOBALS[sys_name]." RSS generator</generator>\n";
52 print " <url>http://".$GLOBALS[sys_default_domain]."/images/bflogo-88.png</url>\n";
53 print " <title>".$GLOBALS[sys_name]." Developer</title>\n";
54 print " <link>http://".$GLOBALS[sys_default_domain]."/</link>\n";
55 print " <width>124</width>\n";
56 print " <heigth>32</heigth>\n";
59 $sql = "SELECT forum_id,summary,post_date,details,g.group_id,g.group_name,u.realname,u.user_name
60 FROM news_bytes, groups g,users u
61 WHERE news_bytes.group_id=g.group_id
62 AND u.user_id=news_bytes.submitted_by
66 order by post_date desc";
67 $res = db_query($sql, $limit);
69 $res = db_query($sql, $limit);
72 while ($row = db_fetch_array($res)) {
74 print " <title>".htmlspecialchars($row[summary])."</title>\n";
75 // if news group, link is main page
76 if ($row[group_id] != $sys_news_group) {
77 print " <link>http://".$GLOBALS[sys_default_domain]."/forum/forum.php?forum_id=".$row[forum_id]."</link>\n";
79 print " <link>http://".$GLOBALS[sys_default_domain]."/</link>\n";
81 print " <description>".rss_description($row[details])."</description>\n";
82 print " <author>".$row[user_name]."@".$GLOBALS[sys_users_host]." (".$row[realname].")</author>\n";
83 print " <pubDate>".gmdate('D, d M Y G:i:s',$row[date])." GMT</pubDate>\n";
84 if ($row[group_id] != $sys_news_group) {
85 print " <guid>http://".$GLOBALS[sys_default_domain]."/forum/forum.php?forum_id=".$row[forum_id]."</guid>\n";
87 print " <guid>http://".$GLOBALS[sys_default_domain]."/</guid>\n";
89 // if news group, comment is main page
90 if ($row[group_id] != $sys_news_group) {
91 print " <comment>http://".$GLOBALS[sys_default_domain]."/forum/forum.php?forum_id=".$row[forum_id]."</comment>\n";
93 print " <comment>http://".$GLOBALS[sys_default_domain]."/</comment>\n";
98 print " </channel>\n";