From e1e5f8967c20669ebe097dc5ea1356f1d67ed308 Mon Sep 17 00:00:00 2001
From: x2000habouzit <x2000habouzit>
Date: Sun, 14 Nov 2004 16:13:25 +0000
Subject: [PATCH] everybody is in the auth_user_md5 ...

---
 htdocs/stats/nb_by_promo.php | 8 ++++++--
 1 file changed, 6 insertions(+), 2 deletions(-)

diff --git a/htdocs/stats/nb_by_promo.php b/htdocs/stats/nb_by_promo.php
index 228715f..025d4ba 100644
--- a/htdocs/stats/nb_by_promo.php
+++ b/htdocs/stats/nb_by_promo.php
@@ -18,13 +18,17 @@
  *  Foundation, Inc.,                                                      *
  *  59 Temple Place, Suite 330, Boston, MA  02111-1307  USA                *
  ***************************************************************************
-        $Id: nb_by_promo.php,v 1.5 2004-08-31 10:03:31 x2000habouzit Exp $
+        $Id: nb_by_promo.php,v 1.6 2004-11-14 16:13:25 x2000habouzit Exp $
  ***************************************************************************/
 
 require("auto.prepend.inc.php");
 new_skinned_page('stats/nb_by_promo.tpl', AUTH_COOKIE);
 
-$result = $globals->db->query("SELECT promo,COUNT(*) FROM auth_user_md5 WHERE promo > 1900 GROUP BY promo ORDER BY promo");
+$result = $globals->db->query("SELECT  promo,COUNT(*)
+                                 FROM  auth_user_md5
+				WHERE  promo > 1900 AND perms IN ('admin','user')
+			     GROUP BY  promo
+			     ORDER BY  promo");
 $max=0; $min=3000;
 while(list($promo,$nb)=mysql_fetch_row($result)) {
     $promo=intval($promo);
-- 
2.1.4