5 * Copyright 1999-2001 (c) VA Linux Systems
6 * Copyright (C) 2010 Alain Peyrat - Alcatel-Lucent
7 * http://fusionforge.org/
9 * This file is part of FusionForge.
11 * FusionForge is free software; you can redistribute it and/or modify
12 * it under the terms of the GNU General Public License as published by
13 * the Free Software Foundation; either version 2 of the License, or
14 * (at your option) any later version.
16 * FusionForge is distributed in the hope that it will be useful,
17 * but WITHOUT ANY WARRANTY; without even the implied warranty of
18 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
19 * GNU General Public License for more details.
21 * You should have received a copy of the GNU General Public License
22 * along with FusionForge; if not, write to the Free Software
23 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
26 require_once('../env.inc.php');
27 require_once $gfcommon.'include/pre.php';
28 require_once $gfwww.'include/vote_function.php';
30 $HTML->header(array("title"=>_('New File Releases')));
32 $offset = getIntFromRequest('offset');
34 if ( !$offset || $offset < 0 || !is_numeric($offset) ) {
38 // For expediancy, list only the filereleases in the past three days.
39 $start_time = time() - (30 * 86400);
42 $res_new = db_query_params ('SELECT groups.group_name,
44 groups.unix_group_name,
45 groups.short_description,
48 frs_release.release_id,
49 frs_package.package_id,
50 frs_release.name AS release_version,
51 frs_release.release_date,
52 frs_release.released_by,
53 frs_package.name AS module_name,
54 frs_dlstats_grouptotal_vw.downloads
55 FROM groups,users,frs_package,frs_release,frs_dlstats_grouptotal_vw
56 WHERE ( frs_release.release_date > $1
57 AND frs_release.package_id = frs_package.package_id
58 AND frs_package.group_id = groups.group_id
59 AND frs_release.released_by = users.user_id
60 AND frs_package.group_id = frs_dlstats_grouptotal_vw.group_id
61 AND frs_release.status_id=1
62 AND frs_package.is_public=1 )
63 ORDER BY frs_release.release_date DESC',
68 if (!$res_new || db_numrows($res_new) < 1) {
69 echo '<p class="error">' . _('No new releases found') . db_error().'</p>';
74 while (($i < 20) && ($row_new = db_fetch_array($res_new))) {
75 if (forge_check_perm('frs', $row_new['group_id'], 'read_public')) {
82 <table width="100%" cellpadding="0" cellspacing="0" border="0">';
85 foreach ($rows as $row_new) {
86 // avoid dupulicates of different file types
87 if (!isset($seen[$row_new['group_id']])) {
91 util_make_link_g ($row_new['unix_group_name'],$row_new['group_id'],'<strong>'.$row_new['group_name'].'</strong>').'
93 <td nowrap="nowrap"><em>'._('Released by:').
94 util_make_link_u ($row_new['user_name'],$row_new['user_id'],'<em>'.$row_new['user_name'].'</em>').'
98 <td>'._('Module:').' '.$row_new['module_name'].'
100 <td>'._('Version:').' '.$row_new['release_version'].'
102 <td>'.date("M d, h:iA",$row_new['release_date']).'
106 <td colspan="2"> <br />';
107 if ($row_new['short_description']) {
108 print '<em>'.$row_new['short_description'].'</em>';
110 print '<em>'._('This project has not submitted a description').'</em>';
114 <td style="text-align:center" nowrap="nowrap"> </td>
118 // link to whole file list for downloads
119 print ' <br />'.
120 util_make_link ('/frs/?group_id='.$row_new['group_id'].'&release_id='.$row_new['release_id'],_('Download')).
121 ' ('._('Project Total:') .$row_new['downloads'].') | ';
122 // notes for this release
123 print util_make_link ('/frs/shownotes.php?release_id='.$row_new['release_id'],_('Notes & Changes')).'
127 $seen[$row_new['group_id']] = 1;
135 print '<a href="'.util_make_url ('/new/?offset='.($offset-20)).'">'.
136 html_image("t2.png","15","15").
137 ' <strong>'._('Newer Releases').'</strong></a>';
144 <td colspan="2" style="text-align:right">';
145 if (db_numrows($res_new)>$rows) {
146 print '<a href="'.util_make_url ('/new/?offset='.($offset+20).'"><strong>'._('Older Releases').'</strong> ') .
147 html_image("t.png","15","15") .
160 $HTML->footer(array());