From 0059fd16dd903abc5417e3f4c8c6a9c1fdb3ab26 Mon Sep 17 00:00:00 2001
From: Angelo Cuccato <cuccato@web.de>
Date: Mon, 8 Nov 2010 23:38:31 +0100
Subject: add Statistics

---
 www-ssl/admin/debug.php | 37 +++++++++++++++----------------------
 1 file changed, 15 insertions(+), 22 deletions(-)

(limited to 'www-ssl/admin/debug.php')

diff --git a/www-ssl/admin/debug.php b/www-ssl/admin/debug.php
index afc394eb..af42dd20 100755
--- a/www-ssl/admin/debug.php
+++ b/www-ssl/admin/debug.php
@@ -30,33 +30,26 @@ funktion_db_list("FAQ");
 echo "Deaktiviert";
 */
 
+echo "<br>\n";
+funktion_db_element_list_2row( "Tshirt-Size aller engel",
+				"SELECT `Size`, COUNT(`Size`) FROM `User` GROUP BY `Size`"); 
 
-echo "<h1>Tshirt-Size aller engel</h1>";
-$SQL="SELECT `Size`, COUNT(`Size`) FROM `User` GROUP BY `Size`";
-$Erg = mysql_query($SQL, $con);
-echo mysql_error($con);
-$rowcount = mysql_num_rows($Erg);
+echo "<br>\n";
+funktion_db_element_list_2row( "Tshirt ausgegeben",
+				"SELECT `Size`, COUNT(`Size`) FROM `User` WHERE `Tshirt`='1' GROUP BY `Size`"); 
 
-for ($i=0; $i<$rowcount; $i++)
-	echo mysql_result($Erg, $i, 1). "x '".  mysql_result($Erg, $i, 0). "'<br>\n";
+echo "<br>\n";
+funktion_db_element_list_2row( "Tshirt nicht  ausgegeben (Gekommen=1)", 
+				"SELECT COUNT(`Size`), `Size` FROM `User` WHERE `Gekommen`='1' and `Tshirt`='0' GROUP BY `Size`");
 
-echo "<h1>Tshirt ausgegeben</h1>";
-$SQL="SELECT `Size`, COUNT(`Size`) FROM `User` WHERE `Tshirt`='1' GROUP BY `Size`";
-$Erg = mysql_query($SQL, $con);
-echo mysql_error($con);
-$rowcount = mysql_num_rows($Erg);
+echo "<br>\n";
+funktion_db_element_list_2row( "Hometown", 
+				"SELECT COUNT(`Hometown`), `Hometown` FROM `User` GROUP BY `Hometown`");
 
-for ($i=0; $i<$rowcount; $i++)
-	echo mysql_result($Erg, $i, 1). "x '".  mysql_result($Erg, $i, 0). "'<br>\n";
+echo "<br>\n";
+funktion_db_element_list_2row( "Engeltypen", 
+					"SELECT COUNT(`Art`), `Art` FROM `User` GROUP BY `Art`");
 
-echo "<h1>Tshirt nicht  ausgegeben (Gekommen=1)</h1>";
-$SQL="SELECT `Size`, COUNT(`Size`) FROM `User` WHERE `Gekommen`='1' and `Tshirt`='0' GROUP BY `Size`";
-$Erg = mysql_query($SQL, $con);
-echo mysql_error($con);
-$rowcount = mysql_num_rows($Erg);
-
-for ($i=0; $i<$rowcount; $i++)
-	echo mysql_result($Erg, $i, 1). "x '".  mysql_result($Erg, $i, 0). "'<br>\n";
 
 include ("../../includes/footer.php");
 ?>
-- 
cgit v1.2.3-54-g00ecf