4 * SourceForge Sitewide Statistics
6 * SourceForge: Breaking Down the Barriers to Open Source Development
7 * Copyright 1999-2001 (c) VA Linux Systems
8 * http://sourceforge.net
11 require_once('../env.inc.php');
12 require_once $gfcommon.'include/pre.php';
13 require_once $gfwww.'stats/site_stats_utils.php';
15 session_require_global_perm ('forge_stats', 'read') ;
17 $HTML->header(array('title' => sprintf(_('%1$s I18n Statistics'), forge_get_config ('forge_name'))));
18 echo "<h1>".sprintf(_('Languages Distributions'), forge_get_config ('forge_name'))." </h1>";
19 echo $GLOBALS['HTML']->listTableTop(array(_('Language')."",_('Users')."","%"));
21 $total=db_result(db_query_params('SELECT count(user_name) AS total FROM users', array()),0,'total');
23 $res = db_query_params ('SELECT supported_languages.name AS lang,count(user_name) AS cnt
24 FROM supported_languages LEFT JOIN users ON language_id=users.language
25 GROUP BY lang,language_id,name
30 while ($lang_stat = db_fetch_array($res)) {
31 if ($lang_stat['cnt'] > 0) {
32 echo '<tr '.$GLOBALS['HTML']->boxGetAltRowStyle($i++).'><td>'.$lang_stat['lang'].'</td>'.
33 '<td align="right">'.$lang_stat['cnt'].' </td>'.
34 '<td align="right">'.sprintf("%.2f",$lang_stat['cnt']*100/$total)." </td></tr>\n";
35 if ($lang_stat['lang']!='English') $non_english+=$lang_stat['cnt'];
39 echo '<tr><td><strong>'._('Total Non-English').'</strong></td>'.
40 '<td align="right"><strong>'.$non_english.' </strong></td>'.
41 '<td align="right"><strong>'.sprintf("%.2f",$non_english*100/$total).' </strong></td></tr>';
43 echo $GLOBALS['HTML']->listTableBottom();
44 echo "<p>"._('This is a list of the preferences that users have chosen in their user preferences; it does not include languages which are selected via cookies or browser preferences')."</p>";
46 $HTML->footer( array() );
50 // c-file-style: "bsd"