Index: /trunk/bureau/admin/stats_show_per_month.php
===================================================================
--- /trunk/bureau/admin/stats_show_per_month.php	(revision 1412)
+++ /trunk/bureau/admin/stats_show_per_month.php	(revision 1413)
@@ -91,24 +91,16 @@
 }
 
-if (! ($user_list = $admin->get_list())) {
-	$error = $err->errstr();
-}
-$u = array();
-foreach ($user_list as $user) {
-  $u[$user['uid']] = $user['login'];
-}
-$u[0] = 'inconnu';
-
 // the stats in the last $count months for all accounts
 $db->query("
-SELECT SUM( size ) AS cnt, uid, date_format(
-DAY , '%Y-%m' ) AS `month`
-FROM `stat_http`
+SELECT SUM( s.size ) AS cnt, s.uid, date_format(
+DAY , '%Y-%m' ) AS `month`, m.login
+FROM `stat_http` s, membres m
 WHERE `day` < CONCAT( date_format( DATE_ADD( NOW( ) , INTERVAL 1 
 MONTH ) , '%Y-%m' ) , '-01' )
 AND `day` >= CONCAT( date_format( DATE_SUB( NOW( ) , INTERVAL " . (int) ($count - 1) .
-" MONTH ) , '%Y-%m' ) , '-01' )
+" MONTH ) , '%Y-%m' ) , '-01' ) 
+AND m.uid = s.uid
 GROUP BY `uid` , `month`
-ORDER BY `uid` 
+ORDER BY `login`
 ");
 
@@ -118,5 +110,5 @@
     if (!is_null($current_user)) { // not the first time we enter this block
       $class = ($class== 'lst1' ? 'lst2' : 'lst1');
-      print "<tr class=\"$class\"><td><acronym title=\"$u[$current_user]\">" . $current_user . "</acronym></td>\n";
+      print "<tr class=\"$class\"><td><acronym title=\"$current_user\">".$db->f("login")."</acronym></td>\n";
       foreach ($months as $m) {
         print "<td>" . m_quota::display_val('bw_web', $entries[$m]) . "</td>\n";