diff options
| author | cookie <cookie@29ba0400-6e00-0410-a75a-ca02368028f8> | 2005-12-18 23:18:24 +0000 |
|---|---|---|
| committer | cookie <cookie@29ba0400-6e00-0410-a75a-ca02368028f8> | 2005-12-18 23:18:24 +0000 |
| commit | 31f79eea2704ac65f6f95bb9bd9a3d00cd8f5929 (patch) | |
| tree | 733ac00b314278f3168877b23dbf517c0ff1d450 /www-ssl/admin | |
| parent | b997e995341fe6a16c29ebf69fce8fe02ebc1f65 (diff) | |
add functions in engelliste
bugfix news
git-svn-id: svn://svn.cccv.de/engel-system@103 29ba0400-6e00-0410-a75a-ca02368028f8
Diffstat (limited to 'www-ssl/admin')
| -rwxr-xr-x | www-ssl/admin/debug.php | 13 | ||||
| -rwxr-xr-x | www-ssl/admin/user.php | 14 |
2 files changed, 23 insertions, 4 deletions
diff --git a/www-ssl/admin/debug.php b/www-ssl/admin/debug.php index 917e4a32..aaf1bcb4 100755 --- a/www-ssl/admin/debug.php +++ b/www-ssl/admin/debug.php @@ -5,7 +5,7 @@ $header = "Datenbank-Auszug"; include ("./inc/header.php"); include ("./inc/funktion_db_list.php"); -echo "<h1>Counter</h1> <br>"; +echo "<h1>Web Counter</h1>"; funktion_db_list("Counter"); /* @@ -30,6 +30,17 @@ funktion_db_list("FAQ"); echo "Deaktiviert"; */ + +echo "<h1>Tshirt-Size</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); + +for ($i=0; $i<$rowcount; $i++) + echo mysql_result($Erg, $i, 1). "x '". mysql_result($Erg, $i, 0). "'<br>\n"; + + include ("./inc/footer.php"); ?> diff --git a/www-ssl/admin/user.php b/www-ssl/admin/user.php index 994666d9..265b8288 100755 --- a/www-ssl/admin/user.php +++ b/www-ssl/admin/user.php @@ -15,7 +15,7 @@ if (!IsSet($_GET["enterUID"])) echo "\n<a href=\"./user.php?enterUID=-1&Type=Secure\">Edit logout User</a><br><br>\n"; if( !isset($_GET["OrderBy"]) ) $_GET["OrderBy"] = "Nick"; - $SQL = "SELECT * FROM User ORDER BY ". $_GET["OrderBy"]. " ASC"; + $SQL = "SELECT * FROM User ORDER BY `". $_GET["OrderBy"]. "` ASC"; $Erg = mysql_query($SQL, $con); echo mysql_error($con); @@ -29,8 +29,14 @@ if (!IsSet($_GET["enterUID"])) <td><a href="<?PHP echo $_SERVER["PHP_SELF"]; ?>?OrderBy=Nick">Nick</a></td> <td><a href="<?PHP echo $_SERVER["PHP_SELF"]; ?>?OrderBy=Name">Name</a></td> <td><a href="<?PHP echo $_SERVER["PHP_SELF"]; ?>?OrderBy=Vorname">Vorname</a></td> - <td>Alter</td> - <td>Telefon <a href="<?PHP echo $_SERVER["PHP_SELF"]; ?>?OrderBy=email">@</a></td> + <td><a href="<?PHP echo $_SERVER["PHP_SELF"]; ?>?OrderBy=Alter">Alter</a></td> + <td> + <a href="<?PHP echo $_SERVER["PHP_SELF"]; ?>?OrderBy=email">@</a> | + <a href="<?PHP echo $_SERVER["PHP_SELF"]; ?>?OrderBy=DECT">DECT</a> | + <a href="<?PHP echo $_SERVER["PHP_SELF"]; ?>?OrderBy=Hometown">Hometown</a> | + <a href="<?PHP echo $_SERVER["PHP_SELF"]; ?>?OrderBy=lastLogIn">lastLogIn</a> | + <a href="<?PHP echo $_SERVER["PHP_SELF"]; ?>?OrderBy=Art">Type</a> + </td> <td><a href="<?PHP echo $_SERVER["PHP_SELF"]; ?>?OrderBy=Size">Größe</a></td> <td><a href="<?PHP echo $_SERVER["PHP_SELF"]; ?>?OrderBy=Gekommen">G</a></td> <td><a href="<?PHP echo $_SERVER["PHP_SELF"]; ?>?OrderBy=Aktiv">A</a></td> @@ -66,6 +72,8 @@ if (!IsSet($_GET["enterUID"])) echo "\n\t\tHometown: ". mysql_result($Erg, $n, "Hometown"). "<br>"; if( strlen( mysql_result($Erg, $n, "lastLogIn"))>0) echo "\n\t\tlastLogIn: ". mysql_result($Erg, $n, "lastLogIn"). "<br>"; + if( strlen( mysql_result($Erg, $n, "Art"))>0) + echo "\n\t\tType: ". mysql_result($Erg, $n, "Art"). "<br>"; echo "</td>\n"; echo "\t<td>".mysql_result($Erg, $n, "Size")."</td>\n"; $Gekommen += mysql_result($Erg, $n, "Gekommen"); |