1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
|
<?php
/**
*
* SourceForge Sitewide Statistics
*
* SourceForge: Breaking Down the Barriers to Open Source Development
* Copyright 1999-2001 (c) VA Linux Systems
* http://sourceforge.net
*
* @version $Id: i18n.php 3146 2004-07-23 14:04:08Z tom $
*
*/
require_once('pre.php');
require_once('site_stats_utils.php');
// require you to be a member of the sfstats group
session_require( array('group'=>$sys_stats_group) );
$HTML->header(array($Language->getText('stats_i18n','title',array($GLOBALS['sys_name']))));
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';
$total=db_result(db_query($sql),0,'total');
$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 lang,language_id,name
ORDER BY cnt DESC';
$res=db_query($sql);
$non_english=0;
$i=0;
while ($lang_stat = db_fetch_array($res)) {
if ($lang_stat['cnt'] > 0) {
echo '<tr '.$GLOBALS['HTML']->boxGetAltRowStyle($i++).'><td>'.$lang_stat['lang'].'</td>'.
'<td align="right">'.$lang_stat['cnt'].' </td>'.
'<td align="right">'.sprintf("%.2f",$lang_stat['cnt']*100/$total)." </td></tr>\n";
if ($lang_stat['lang']!='English') $non_english+=$lang_stat['cnt'];
}
}
echo '<tr><td><strong>'.$Language->getText('stats_i18n','total_non_english').'</strong></td>'.
'<td align="right"><strong>'.$non_english.' </strong></td>'.
'<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');
$HTML->footer( array() );
?>
|
