4 * SourceForge New Releases Page
6 * SourceForge: Breaking Down the Barriers to Open Source Development
7 * Copyright 1999-2001 (c) VA Linux Systems
8 * http://sourceforge.net
14 require_once('../env.inc.php');
15 require_once('pre.php');
16 require_once('vote_function.php');
18 $HTML->header(array("title"=>$Language->getText('new','title')));
20 $offset = getIntFromRequest('offset');
22 if ( !$offset || $offset < 0 ) {
26 // For expediancy, list only the filereleases in the past three days.
27 $start_time = time() - (30 * 86400);
29 $query = "SELECT groups.group_name,
31 groups.unix_group_name,
32 groups.short_description,
35 frs_release.release_id,
36 frs_release.name AS release_version,
37 frs_release.release_date,
38 frs_release.released_by,
39 frs_package.name AS module_name,
40 frs_dlstats_grouptotal_vw.downloads
41 FROM groups,users,frs_package,frs_release,frs_dlstats_grouptotal_vw
42 WHERE ( frs_release.release_date > '$start_time'
43 AND frs_release.package_id = frs_package.package_id
44 AND frs_package.group_id = groups.group_id
45 AND frs_release.released_by = users.user_id
46 AND frs_package.group_id = frs_dlstats_grouptotal_vw.group_id
47 AND frs_release.status_id=1
48 AND frs_package.is_public=1 )
49 ORDER BY frs_release.release_date DESC";
50 $res_new = db_query($query, 21, $offset, SYS_DB_STATS);
52 if (!$res_new || db_numrows($res_new) < 1) {
53 // echo $query . "<br /><br />";
55 echo "<h1>".$Language->getText('new','no_new_release_found')."</h1>";
58 if ( db_numrows($res_new) > 20 ) {
61 $rows = db_numrows($res_new);
64 echo "<table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\n";
65 for ($i=0; $i<$rows; $i++) {
66 $row_new = db_fetch_array($res_new);
67 // avoid dupulicates of different file types
68 if (!($G_RELEASE["$row_new[group_id]"])) {
69 print "<tr valign=\"top\">";
70 print "<td colspan=\"2\">";
71 print "<a href=\"/projects/$row_new[unix_group_name]/\"><strong>$row_new[group_name]</strong></a>"
72 . "\n</td><td nowrap=\"nowrap\"><em>".$Language->getText('new','released_by')." <a href=\"/users/$row_new[user_name]/\">"
73 . "$row_new[user_name]</a></em></td></tr>\n";
75 print "<tr><td>".$Language->getText('new','module')." "."$row_new[module_name]</td>\n";
76 print "<td>".$Language->getText('new','version')." "."$row_new[release_version]</td>\n";
77 print "<td>" . date("M d, h:iA",$row_new[release_date]) . "</td>\n";
80 print "<tr valign=\"top\">";
81 print "<td colspan=\"2\"> <br />";
82 if ($row_new['short_description']) {
83 print "<em>$row_new[short_description]</em>";
85 print "<em>".$Language->getText('new','this_project_has_not')."</em>";
87 // print "<p>Release rating: ";
88 // print vote_show_thumbs($row_new[filerelease_id],2);
90 print '<td style="text-align:center" nowrap="nowrap">';
91 // print ' <br />Rate this Release!<br />';
92 // print vote_show_release_radios($row_new[filerelease_id],2);
96 print '<tr><td colspan="3">';
97 // link to whole file list for downloads
98 print " <br /><a href=\"/frs/?group_id=$row_new[group_id]&release_id=$row_new[release_id]\">";
99 print $Language->getText('new','download'). "</a> ";
100 print '('.$Language->getText('new','projects_total') .$row_new['downloads'].') | ';
101 // notes for this release
102 print "<a href=\"/frs/shownotes.php?release_id=".$row_new[release_id]."\">";
103 print $Language->getText('new','notes_changes'). "</a>";
104 print "<hr /></td></tr>\n";
106 $G_RELEASE["$row_new[group_id]"] = 1;
110 echo "<tr class=\"content\"><td>";
112 echo "<a href=\"/new/?offset=".($offset-20)."\">" .
113 html_image("t2.png","15","15",array("border"=>"0","align"=>"middle")) .
114 " <strong>".$Language->getText('new','newer_releases')."</strong></a>";
119 echo "</td><td colspan=\"2\" style=\"text-align:right\">";
120 if (db_numrows($res_new)>$rows) {
121 echo "<a href=\"/new/?offset=".($offset+20)."\"><strong>".$Language->getText('new','older_releases')."</strong> " .
122 html_image("t.png","15","15",array("border"=>"0","align"=>"middle")) .
127 echo "</td></tr>\n</table>";
131 $HTML->footer(array());