if ($limit > 100) $limit = 100;
if ($group_id) {
- $where = "frs_package.group_id=$group_id AND ";
$res = db_query_params ('SELECT group_name FROM groups WHERE group_id=$1 AND is_public=1',
- array($group_id)) ;
+ array ($group_id)) ;
$row = db_fetch_array($res);
$title = ": ".$row['group_name']." - ";
$link = "/project/showfiles.php?group_id=$group_id";
$description = " of ".$row['group_name'];
- $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";
- $reswm = db_query($querywm,1);
+ $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',
+ array($group_id,
+ 'A'));
if ($rowwm = db_fetch_array($reswm)) {
$webmaster = $rowwm['user_name']."@".$GLOBALS['sys_users_host']." (".$rowwm['realname'].")";
} else {
$webmaster = $GLOBALS['sys_admin_email'];
}
} else {
- $where = "";
- $title = "";
+ $title = "";
$link = "/new/";
$description = "";
$webmaster = $GLOBALS['sys_admin_email'];
print " <lastBuildDate>".rss_date(time())."</lastBuildDate>\n";
print " <docs>http://blogs.law.harvard.edu/tech/rss</docs>\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 "
- . "groups.is_public=1 AND "
- . $where
- . "frs_file.release_id=frs_release.release_id "
- . "ORDER BY frs_file.release_time DESC",($limit * 3));
+$res = db_query_params ('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 groups.is_public=1
+ AND (frs_package.group_id=$1 OR 1!=$2)
+ AND frs_file.release_id=frs_release.release_id
+ORDER BY frs_file.release_time DESC',
+ array ($group_id,
+ $group_id ? 1 : 0),
+ $limit * 3);
// ## item outputs