[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Gforge-commits] gforge/www/new index.php,1.13,1.14
From: |
tperdue |
Subject: |
[Gforge-commits] gforge/www/new index.php,1.13,1.14 |
Date: |
Wed, 04 Aug 2004 11:18:57 -0500 |
Update of /cvsroot/gforge/gforge/www/new
In directory db.perdue.net:/home/tperdue/share/dev.gforge.org/www/new
Modified Files:
index.php
Log Message:
RBAC, DELETION, AND FORUM EMAIL GATEWAY
Index: index.php
===================================================================
RCS file: /cvsroot/gforge/gforge/www/new/index.php,v
retrieving revision 1.13
retrieving revision 1.14
diff -u -d -r1.13 -r1.14
--- index.php 10 Feb 2004 22:14:40 -0000 1.13
+++ index.php 4 Aug 2004 16:18:40 -0000 1.14
@@ -23,26 +23,27 @@
// For expediancy, list only the filereleases in the past three days.
$start_time = time() - (30 * 86400);
-$query = "SELECT groups.group_name,"
- . "groups.group_id,"
- . "groups.unix_group_name,"
- . "groups.short_description,"
- . "users.user_name,"
- . "users.user_id,"
- . "frs_release.release_id,"
- . "frs_release.name AS release_version,"
- . "frs_release.release_date,"
- . "frs_release.released_by,"
- . "frs_package.name AS module_name, "
- . "frs_dlstats_grouptotal_vw.downloads "
- . "FROM groups,users,frs_package,frs_release,frs_dlstats_grouptotal_vw "
- . "WHERE ( frs_release.release_date > '$start_time' "
- . "AND frs_release.package_id = frs_package.package_id "
- . "AND frs_package.group_id = groups.group_id "
- . "AND frs_release.released_by = users.user_id "
- . "AND frs_package.group_id = frs_dlstats_grouptotal_vw.group_id "
- . "AND frs_release.status_id=1 ) "
- . "ORDER BY frs_release.release_date DESC";
+$query = "SELECT groups.group_name,
+ groups.group_id,
+ groups.unix_group_name,
+ groups.short_description,
+ users.user_name,
+ users.user_id,
+ frs_release.release_id,
+ frs_release.name AS release_version,
+ frs_release.release_date,
+ frs_release.released_by,
+ frs_package.name AS module_name,
+ frs_dlstats_grouptotal_vw.downloads
+ FROM groups,users,frs_package,frs_release,frs_dlstats_grouptotal_vw
+ WHERE ( frs_release.release_date > '$start_time'
+ AND frs_release.package_id = frs_package.package_id
+ AND frs_package.group_id = groups.group_id
+ AND frs_release.released_by = users.user_id
+ AND frs_package.group_id = frs_dlstats_grouptotal_vw.group_id
+ AND frs_release.status_id=1
+ AND frs_package.is_public=1 )
+ ORDER BY frs_release.release_date DESC";
$res_new = db_query($query, 21, $offset, SYS_DB_STATS);
if (!$res_new || db_numrows($res_new) < 1) {
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Gforge-commits] gforge/www/new index.php,1.13,1.14,
tperdue <=