[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Gforge-commits] gforge/www/stats i18n.php,1.5,1.6
From: |
tom |
Subject: |
[Gforge-commits] gforge/www/stats i18n.php,1.5,1.6 |
Date: |
Mon, 07 Jun 2004 09:38:51 -0500 |
Update of /cvsroot/gforge/gforge/www/stats
In directory db.perdue.net:/tmp/cvs-serv8591/www/stats
Modified Files:
i18n.php
Log Message:
Fixed bug #807; i18n.php had a typo in the SQL query
Index: i18n.php
===================================================================
RCS file: /cvsroot/gforge/gforge/www/stats/i18n.php,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -d -r1.5 -r1.6
--- a/i18n.php 17 Feb 2003 15:45:38 -0000 1.5
+++ b/i18n.php 7 Jun 2004 14:38:49 -0000 1.6
@@ -10,8 +10,6 @@
* @version $Id$
*
*/
-
-
require_once('pre.php');
require_once('site_stats_utils.php');
@@ -19,26 +17,16 @@
session_require( array('group'=>$sys_stats_group) );
$HTML->header(array($Language->getText('stats_i18n','title',array($GLOBALS['sys_name']))));
-
-//
-// BEGIN PAGE CONTENT CODE
-//
-
echo
$GLOBALS['HTML']->listTableTop(array($Language->getText('stats_i18n','language')."",$Language->getText('stats_i18n','users')."","%"));
echo
"<h1>".$Language->getText('stats_i18n','language_distribution',array($GLOBALS['sys_name']))."
</h1>";
-$sql='
-SELECT count(user_name) AS total
-FROM users
-';
+$sql='SELECT count(user_name) AS total FROM users';
$total=db_result(db_query($sql),0,'total');
-$sql='
-SELECT supported_languages.name AS lang,count(user_name) AS cnt
+$sql='SELECT supported_languages.name AS lang,count(user_name) AS cnt
FROM supported_languages LEFT JOIN users ON language_id=users.language
-GROUP BY language_id,name
-ORDER BY cnt DESC
-';
+GROUP BY lang,language_id,name
+ORDER BY cnt DESC';
$res=db_query($sql);
$non_english=0;
$i=0;
@@ -54,12 +42,7 @@
'<td align="right"><strong>'.sprintf("%.2f",$non_english*100/$total).'
</strong></td></tr>';
echo $GLOBALS['HTML']->listTableBottom();
-
echo "<p>".$Language->getText('stats_i18n','language_text');
-//
-// END PAGE CONTENT CODE
-//
-
$HTML->footer( array() );
?>
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Gforge-commits] gforge/www/stats i18n.php,1.5,1.6,
tom <=