print " <description>" . $GLOBALS['sys_name'] . " " . $Language->getText('export_index', 'full_proj_listing') . "</description>\n"; print " <link>{$server}</link>\n"; if ($option == "newest") { print " <title>" . $GLOBALS['sys_name'] . " " . $Language->getText('export_rss_sfprojects', 'new_proj') . "</title>\n"; } else { print " <title>" . $GLOBALS['sys_name'] . " " . $Language->getText('export_index', 'full_proj_listing') . "</title>\n"; } print " <webMaster>" . $GLOBALS['sys_email_contact'] . "</webMaster>\n"; print " <language>en-us</language>\n"; // ## item outputs while ($row = db_fetch_array($res)) { print " <item>\n"; print " <title>" . htmlspecialchars($row['group_name']) . "</title>\n"; print " <link>{$server}/project/?group_id={$row['group_id']}</link>\n"; print " <description>"; print ereg_replace(" *\r*\n *", " ", rss_description($row['short_description'])); print "</description>\n"; print " </item>\n"; } // ## end output print " </channel>\n"; print "</rss>\n"; } else { if ($request->get('type') == "csv") { header('Content-Type: text/csv'); if ($option == "newest") { header('Content-Disposition: filename=new_projects.csv'); } else { header('Content-Disposition: filename=all_projects.csv'); } // ## one time output. List of Exported fields
print " <link>{$url}/tracker/?func=detail&atid=" . $arr['ref_id'] . '&aid=' . $arr['subref_id'] . '&group_id=' . $arr['group_id'] . "</link>\n"; print " <comment>{$url}/tracker/?func=detail&atid=" . $arr['ref_id'] . '&aid=' . $arr['subref_id'] . '&group_id=' . $arr['group_id'] . "</comment>\n"; break; case 'frsrelease': print " <title>" . htmlspecialchars('FRS Release [#' . $arr['description'] . ']') . "</title>\n"; print " <link>{$url}/frs/?release_id=" . $arr['subref_id'] . '&group_id=' . $arr['group_id'] . "</link>\n"; print " <comment>{$url}/frs/?release_id=" . $arr['subref_id'] . '&group_id=' . $arr['group_id'] . "</comment>\n"; break; case 'forumpost': print " <title>" . htmlspecialchars('Forum Post [#' . $arr['subref_id'] . '] ' . $arr['description']) . "</title>\n"; print " <link>{$url}/forum/message.php?forum_id=" . $arr['ref_id'] . '&msg_id=' . $arr['subref_id'] . '&group_id=' . $arr['group_id'] . "</link>\n"; print " <comment>{$url}/forum/message.php?forum_id=" . $arr['ref_id'] . '&msg_id=' . $arr['subref_id'] . '&group_id=' . $arr['group_id'] . "</comment>\n"; break; case 'news': print " <title>" . htmlspecialchars('News Post [#' . $arr['subref_id'] . '] ' . $arr['description']) . "</title>\n"; print " <link>{$url}/forum/forum.php?forum_id=" . $arr['subref_id'] . "</link>\n"; print " <comment>{$url}/forum/forum.php?forum_id=" . $arr['subref_id'] . "</comment>\n"; break; } print " <description>" . rss_description($arr['description']) . "</description>\n"; print " <author>" . $arr['user_name'] . "@" . $GLOBALS['sys_users_host'] . " (" . $arr['realname'] . ")</author>\n"; print " <pubDate>" . gmdate('D, d M Y G:i:s', $arr['activity_date']) . " GMT</pubDate>\n"; print " </item>\n"; } // ## end output print " </channel>\n"; print "</rss>\n"; } else { // Print error showing no group was selected echo "<br><span class=\"error\"> Error: No group selected</span>"; }
print " <image>\n"; print " <url>http://" . $GLOBALS[sys_default_host] . "/images/berliOS_small_logo.png</url>\n"; print " <title>BerliOS Developer</title>\n"; print " <link>http://" . $GLOBALS[sys_default_host] . "/</link>\n"; print " <width>124</width>\n"; print " <heigth>32</heigth>\n"; print " </image>\n"; $res = db_query("SELECT groups.group_name AS group_name," . "frs_package.group_id AS group_id," . "groups.unix_group_name AS unix_group_name," . "groups.short_description AS short_description," . "groups.license AS license," . "users.user_name AS user_name," . "users.user_id AS user_id," . "users.realname AS realname," . "frs_package.name AS package_name," . "frs_release.package_id AS filemodule_id," . "frs_release.name AS module_name," . "frs_release.notes AS module_notes," . "frs_release.status_id AS release_status," . "frs_release.release_date AS release_date," . "frs_file.release_time AS release_time," . "frs_file.filename AS filename," . "frs_file.release_id AS filerelease_id " . "FROM users,frs_file,frs_release,frs_package,groups WHERE " . "frs_release.released_by=users.user_id AND " . "frs_release.package_id=frs_package.package_id AND " . "frs_package.group_id=groups.group_id AND " . "frs_release.status_id=1 AND " . $where . "frs_file.release_id=frs_release.release_id " . "ORDER BY frs_file.release_time DESC", $limit * 3); // ## item outputs $outputtotal = 0; while ($row = db_fetch_array($res)) { if (!$G_RELEASE["{$row['filerelease_id']}"]) { print " <item>\n"; print " <title>" . htmlspecialchars($row[package_name]) . " " . htmlspecialchars($row[module_name]) . "</title>\n"; print " <link>http://" . $GLOBALS[sys_default_host] . "/project/showfiles.php?group_id=" . $row[group_id] . "&release_id=" . $row[filerelease_id] . "</link>\n"; print " <description>" . rss_description($row[module_notes]) . "</description>\n"; print " <author>" . $row[user_name] . "@" . $GLOBALS[sys_mail_host] . " (" . $row[realname] . ")</author>\n"; print " <comment>http://" . $GLOBALS[sys_default_host] . "/project/shownotes.php?group_id=" . $row[group_id] . "&release_id=" . $row[filerelease_id] . "</comment>\n"; print " <pubDate>" . gmdate('D, d M Y G:i:s', $row[release_date]) . " GMT</pubDate>\n"; print " <guid>http://" . $GLOBALS[sys_default_host] . "/project/showfiles.php?group_id=" . $row[group_id] . "&release_id=" . $row[filerelease_id] . "</guid>\n"; print " </item>\n"; $outputtotal++; } // ## eliminate dupes, only do $limit of these $G_RELEASE["{$row['filerelease_id']}"] = 1; if ($outputtotal >= $limit) { break; } } // ## end output print " </channel>\n";
if ($limit > 100) { $limit = 100; } $res = db_query('SELECT forum_id,summary,date,details,group_id FROM news_bytes ' . 'WHERE is_approved=1 ORDER BY date DESC', $limit); // ## one time output print " <channel>\n"; print " <copyright>Copyright 1999-2000 VA Linux Systems, Inc.</copyright>\n"; print " <pubDate>" . gmdate('D, d M Y g:i:s', time()) . " GMT</pubDate>\n"; print " <description>{$GLOBALS['sys_default_name']} Project News Highlights</description>\n"; print " <link>http://{$GLOBALS['sys_default_host']}</link>\n"; print " <title>{$GLOBALS['sys_default_name']} Project News</title>\n"; print " <webMaster>admin@{$GLOBALS['sys_default_domain']}</webMaster>\n"; print " <language>en-us</language>\n"; // ## item outputs while ($row = db_fetch_array($res)) { print " <item>\n"; print " <title>" . htmlspecialchars($row[summary]) . "</title>\n"; // if news group, link is main page if ($row[group_id] != $sys_news_group) { print " <link>http://{$GLOBALS['sys_default_host']}/forum/forum.php?forum_id={$row['forum_id']}</link>\n"; } else { print " <link>http://{$GLOBALS['sys_default_host']}/</link>\n"; } print " <description>" . rss_description($row[details]) . "</description>\n"; print " </item>\n"; } // ## end output print " </channel>\n"; ?> </rss>
print " <copyright>" . $Language->getText('export_rss_sfnewreleases', 'copyright', array($GLOBALS['sys_long_org_name'], $GLOBALS['sys_name'], date('Y', time()))) . "</copyright>\n"; print " <pubDate>" . gmdate('D, d M Y g:i:s', time()) . " GMT</pubDate>\n"; print " <description>" . $Language->getText('export_rss_sfnewreleases', 'new_releases', $GLOBALS['sys_name']) . "</description>\n"; print " <link>" . get_server_url() . "</link>\n"; print " <title>" . $Language->getText('export_rss_sfnewreleases', 'new_releases', $GLOBALS['sys_name']) . "</title>\n"; list($host, $port) = explode(':', $GLOBALS['sys_default_domain']); print " <webMaster>webmaster@" . $host . "</webMaster>\n"; print " <language>en-us</language>\n"; // ## item outputs $outputtotal = 0; $frspf = new FRSPackageFactory(); $frsrf = new FRSReleaseFactory(); while ($row = db_fetch_array($res)) { if (!$G_RELEASE["{$row['group_id']}"]) { if ($frspf->userCanRead($row['group_id'], $row['package_id'], 100) && $frsrf->userCanRead($row['group_id'], $row['package_id'], $row_newrel['release_id'], 100)) { print " <item>\n"; print " <title>" . htmlspecialchars($row['group_name'] . " " . $row['release_version']) . "</title>\n"; print " <link>" . get_server_url() . "/file/showfiles.php?group_id={$row['group_id']}</link>\n"; print " <description>" . rss_description($row['short_description']) . "</description>\n"; print " </item>\n"; $outputtotal++; // ## eliminate dupes, only do $limit of these $G_RELEASE[$row['group_id']] = 1; if ($outputtotal >= $limit) { break; } } } } // ## end output print " </channel>\n</rss>";
print " <channel>\n"; print " <copyright>Copyright 1999-2000 VA Linux Systems, Inc.</copyright>\n"; print " <pubDate>" . gmdate('D, d M Y g:i:s', time()) . " GMT</pubDate>\n"; print " <description>" . $GLOBALS['sys_name'] . " New Releases</description>\n"; print " <link>http://{$GLOBALS['sys_default_domain']}</link>\n"; print " <title>" . $GLOBALS['sys_name'] . " New Releases</title>\n"; print " <webMaster>webmaster@{$GLOBALS['sys_default_domain']}</webMaster>\n"; print " <language>en-us</language>\n"; // ## item outputs $outputtotal = 0; $seen = array(); while ($row = db_fetch_array($res)) { if (!isset($seen[$row['group_id']])) { print " <item>\n"; print " <title>" . htmlspecialchars($row['group_name']) . "</title>\n"; print " <link>http://{$GLOBALS['sys_default_domain']}/project/showfiles.php?group_id={$row['group_id']}</link>\n"; print " <description>" . rss_description($row['summary']) . "</description>\n"; print " </item>\n"; $outputtotal++; } // eliminate dupes, only do $limit of these $seen[$row['group_id']] = 1; if ($outputtotal >= $limit) { break; } } // ## end output print " </channel>\n"; ?> </rss>
print " <url>http://" . $GLOBALS[sys_default_host] . "/images/berliOS_small_logo.png</url>\n"; print " <title>BerliOS Developer</title>\n"; print " <link>http://" . $GLOBALS[sys_default_host] . "{$link}</link>\n"; print " <width>124</width>\n"; print " <heigth>32</heigth>\n"; print " </image>\n"; $res = db_query("SELECT groups.group_name AS group_name," . "frs_package.group_id AS group_id," . "groups.unix_group_name AS unix_group_name," . "groups.short_description AS short_description," . "groups.license AS license," . "users.user_name AS user_name," . "users.user_id AS user_id," . "frs_package.name AS package_name," . "frs_release.package_id AS filemodule_id," . "frs_release.name AS module_name," . "frs_release.notes AS module_notes," . "frs_release.status_id AS release_status," . "frs_release.release_date AS release_date," . "frs_file.release_time AS release_time," . "frs_file.filename AS filename," . "frs_file.release_id AS filerelease_id " . "FROM users,frs_file,frs_release,frs_package,groups WHERE " . "frs_release.released_by=users.user_id AND " . "frs_release.package_id=frs_package.package_id AND " . "frs_package.group_id=groups.group_id AND " . "frs_release.status_id=1 AND " . $where . "frs_file.release_id=frs_release.release_id " . "ORDER BY frs_file.release_time DESC", $limit * 3); // ## item outputs $outputtotal = 0; while ($row = db_fetch_array($res)) { if (!$G_RELEASE["{$row['filerelease_id']}"]) { print " <item>\n"; print " <title>" . htmlspecialchars($row[package_name]) . " " . htmlspecialchars($row[module_name]) . "</title>\n"; print " <link>http://" . $GLOBALS[sys_default_host] . "/project/showfiles.php?group_id=" . $row[group_id] . "&release_id=" . $row[filerelease_id] . "</link>\n"; print " <description>"; print rss_description($row[module_notes]); print "</description>\n"; print " </item>\n"; $outputtotal++; } // ## eliminate dupes, only do $limit of these $G_RELEASE["{$row['filerelease_id']}"] = 1; if ($outputtotal >= $limit) { break; } } // ## end output print " </channel>\n"; ?> </rss>