[Gforge-commits] gforge/www/include features_boxes.php,1.19,1.20

[gsmet]

Update of /cvsroot/gforge/gforge/www/include
In directory db.perdue.net:/tmp/cvs-serv23854/www/include

Modified Files:
        features_boxes.php 
Log Message:
Improved newest projects box localization and sql query

Index: features_boxes.php
===================================================================
RCS file: /cvsroot/gforge/gforge/www/include/features_boxes.php,v
retrieving revision 1.19
retrieving revision 1.20
diff -u -d -r1.19 -r1.20
--- features_boxes.php  15 Jan 2004 10:42:54 -0000      1.19
+++ features_boxes.php  13 Feb 2004 11:24:46 -0000      1.20
@@ -118,7 +118,7 @@
 function show_newest_projects() {
        global $Language;
        $sql =  "SELECT group_id,unix_group_name,group_name,register_time FROM 
groups " .
-               "WHERE is_public=1 AND status='A' AND type=1 " .
+               "WHERE is_public=1 AND status='A' AND type=1 AND register_time 
> 0 " .
                "ORDER BY register_time DESC";
        $res_newproj = db_query($sql,10);
 
@@ -128,11 +128,9 @@
                return $Language->getText('home','no_stats_available')." 
".db_error();
        } else {
                while ( $row_newproj = db_fetch_array($res_newproj) ) {
-                       if ( $row_newproj['register_time'] ) {
-                               $return .= "<strong>(" . 
date("m/d",$row_newproj['register_time'])  . ")</strong> "
+                       $return .= "<strong>(" . 
date($Language->getText('home','recently_registered_date_format'),$row_newproj['register_time'])
  . ")</strong> "
                                . "<a 
href=\"/projects/$row_newproj[unix_group_name]/\">"
                                . "$row_newproj[group_name]</a><br />";
-                       }
                }
        }
        /// TODO: Add more link to show all project
@@ -150,7 +148,7 @@
        $res=db_query($sql);
        $rows=db_numrows($res);
        if (!$res || $rows<1) {
-               return  $Language->getText('home','none_found').db_error();
+               return  
$Language->getText('home','no_stats_available').db_error();
        } else {
                $return = '';
                for ($i=0; $i<$rows; $i++) {
@@ -185,4 +183,4 @@
        return $return;
 }
 
-?>
+?>
\ No newline at end of file