From 310c2ce98fc8c0e94559c9ed8587101d92f6e853 Mon Sep 17 00:00:00 2001 From: cookie Date: Sat, 10 Sep 2005 17:25:43 +0000 Subject: add total system git-svn-id: svn://svn.cccv.de/engel-system@1 29ba0400-6e00-0410-a75a-ca02368028f8 --- admin/user.php | 249 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 249 insertions(+) create mode 100755 admin/user.php (limited to 'admin/user.php') diff --git a/admin/user.php b/admin/user.php new file mode 100755 index 00000000..54e31ceb --- /dev/null +++ b/admin/user.php @@ -0,0 +1,249 @@ +Neuen Engel eintragen

\n\n"; + + if( !isset($OrderBy) ) $OrderBy = "Nick"; + $SQL = "SELECT * FROM User ORDER BY ". $OrderBy. " ASC"; + $Erg = mysql_query($SQL, $con); + echo mysql_error($con); + + // anzahl zeilen + $Zeilen = mysql_num_rows($Erg); + + echo "Anzahl Engel: $Zeilen

"; + + ?> + + + + + + + + + + + + + + + \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + $Gekommen += mysql_result($Erg, $n, "Gekommen"); + echo " \n"; + $Active += mysql_result($Erg, $n, "Aktiv"); + echo " \n"; + $Tshirt += mysql_result($Erg, $n, "Tshirt"); + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + } + echo "". + "". + "\n"; + echo "\t
NickNameVornameAlterTelefon @GrößeGATÄnd.Secure
".mysql_result($Erg, $n, "Nick"). "".mysql_result($Erg, $n, "Name")."".mysql_result($Erg, $n, "Vorname")."".mysql_result($Erg, $n, "Alter").""; + if( strlen( mysql_result($Erg, $n, "Telefon"))>0) + echo "Tel: ". mysql_result($Erg, $n, "Telefon"). "
"; + if( strlen( mysql_result($Erg, $n, "Handy"))>0) + echo "Handy: ". mysql_result($Erg, $n, "Handy"). "
"; + if( strlen( mysql_result($Erg, $n, "DECT"))>0) + echo "DECT: ". + mysql_result($Erg, $n, "DECT"). "
"; + $Mail = mysql_result($Erg, $n, "email"); +// if( strlen($Mail) > 15 ) +// $Mail = substr($Mail, 0, 12). "..."; + if( strlen( $Mail)>0) + echo "email: $Mail\n"; + echo "		".mysql_result($Erg, $n, "Size")."".mysql_result($Erg, $n, "Gekommen")."".mysql_result($Erg, $n, "Aktiv")."".mysql_result($Erg, $n, "Tshirt")."Änd."; + //check userCVS=OK + $SQL2 = "SELECT UID FROM UserCVS WHERE (UID=". mysql_result($Erg, $n, "UID"). ")"; + $Erg2 = mysql_query($SQL2, $con); + echo mysql_error($con); + if( mysql_num_rows($Erg2)==0) + { + $SQL3 = "INSERT INTO `UserCVS` ( `UID`) VALUES ( '". mysql_result($Erg, $n, "UID"). "');"; + $Erg3 = mysql_query($SQL3, $con); + if( $Erg3 ) + echo "was create
\n"; + else + echo mysql_error($con); + } + echo "Secure
$Gekommen$Active$Tshirt
\n"; + // Ende Userliste +} +else +{ + // UserID wurde mit uebergeben --> Aendern... + + $SQL = "SELECT * FROM User where UID=$enterUID"; + $Erg = mysql_query($SQL, $con); + + $anzahl = mysql_num_rows($Erg); + + if ($anzahl != 1) + echo "Sorry, der Engel (UID=$enterUID) wurde in der Liste nicht gefunden."; + else + { + echo "Hallo,
". + "hier kannst du den Eintrag ändern. Unter dem Punkt 'Gekommen' ". + "wird der Engel als anwesend markiert, ein Ja bei Aktiv bedeutet, ". + "dass der Engel aktiv war und damit ein Anspruch auf ein T-Shirt hat. ". + "Wenn T-Shirt ein 'Ja' enthält, bedeutet dies, dass der Engel ". + "bereits sein T-Shirt erhalten hat.

\n"; + + echo "
\n"; + echo "\n"; + echo "\n"; + + if( $Type == "Normal" ) + { + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + + // Gekommen? + echo " \n"; + + // Aktiv? + echo " \n"; + + // T-Shirt bekommen? + echo " \n"; + } //IF TYPE + + if( $Type == "Secure" ) + { + // CVS-Rechte + echo " \n"; + + $SQL_CVS = "SELECT * FROM `UserCVS` WHERE UID=$enterUID"; + $Erg_CVS = mysql_query($SQL_CVS, $con); + $CVS_Data = mysql_fetch_array($Erg_CVS); + $CVS_Data_i = 1; + foreach ($CVS_Data as $CVS_Data_Name => $CVS_Data_Value) + { + $CVS_Data_i++; + //nur jeder zweiter sonst wird für jeden text noch die position (Zahl) ausgegeben + if( $CVS_Data_i%2 && $CVS_Data_Name!="UID") + { + echo "\n"; + } //IF + } //Foreach + echo "\n"; + } // IF TYPE + + + // Ende Formular + echo "\n"; + echo "
Nick". + "
lastLogIn". + "
Name". + "
Vorname". + "
Alter". + "
Telefon". + "
Handy". + "
DECT". + "
email". + "
Size". + "
Passwort". + " ". + "neues Kennwort setzen
Gekommen\n"; + echo " No \n"; + echo " Yes \n"; + echo "
Aktiv\n"; + echo " No \n"; + echo " Yes \n"; + echo "
T-Shirt\n"; + echo " No \n"; + echo " Yes \n"; + echo "

Rights of \"". mysql_result($Erg, 0, "Nick"). "\":
$CVS_Data_Name"; + echo "allow \n"; + echo "denied \n"; + echo "
\n"; + echo "\n"; + echo "\n"; + echo "
"; + + if( $Type == "Normal" ) + { + echo "
\n"; + echo "\n"; + echo "\n"; + echo "
"; + } + + } + +} + +include ("./inc/footer.php"); +?> + + -- cgit v1.2.3-70-g09d2