Neuen Engel eintragen

\n"; echo "\nEdit logout User

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

\n"; ?>\n"; echo "\t\n"; echo "\t\n"; echo "\t\n"; echo "\t\n"; echo "\t\n"; echo "\t\n"; $Gekommen += mysql_result($Erg, $n, "Gekommen"); echo "\t\n"; $Active += mysql_result($Erg, $n, "Aktiv"); echo "\t\n"; $Tshirt += mysql_result($Erg, $n, "Tshirt"); echo "\t\n"; echo "\t\n"; echo "\t\n"; echo "\n"; } echo "". "". "\n"; echo "\t

?OrderBy=Nick">Nick	?OrderBy=Name">Name	?OrderBy=Vorname">Vorname	?OrderBy=Alter">Alter	?OrderBy=email">@ | ?OrderBy=DECT">DECT | ?OrderBy=Hometown">Hometown | ?OrderBy=lastLogIn">lastLogIn | ?OrderBy=Art">Type	?OrderBy=Size">Größe	?OrderBy=Gekommen">G	?OrderBy=Aktiv">A	?OrderBy=Tshirt">T	Ä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 "\n\t\tTel: ". mysql_result($Erg, $n, "Telefon"). " "; if( strlen( mysql_result($Erg, $n, "Handy"))>0) echo "\n\t\tHandy: ". mysql_result($Erg, $n, "Handy"). " "; if( strlen( mysql_result($Erg, $n, "DECT"))>0) echo "\n\t\tDECT: ". mysql_result($Erg, $n, "DECT"). " "; if( strlen( mysql_result($Erg, $n, "email"))>0) echo "\n\t\temail: ". mysql_result($Erg, $n, "email")." "; if( strlen( mysql_result($Erg, $n, "Hometown"))>0) echo "\n\t\tHometown: ". mysql_result($Erg, $n, "Hometown"). " "; if( strlen( mysql_result($Erg, $n, "lastLogIn"))>0) echo "\n\t\tlastLogIn: ". mysql_result($Erg, $n, "lastLogIn"). " "; if( strlen( mysql_result($Erg, $n, "Art"))>0) echo "\n\t\tType: ". mysql_result($Erg, $n, "Art"). " "; 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 = db_query($SQL3, "admin/user.php auto CVS create"); 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... 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( $_GET["Type"] == "Normal" ) { $SQL = "SELECT * FROM User where UID=". $_GET["enterUID"]; $Erg = mysql_query($SQL, $con); if (mysql_num_rows($Erg) != 1) echo ""; else { 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"; // Menu links/rechts echo " \n"; echo " \n"; } //IF TYPE } if( $_GET["Type"] == "Secure" ) { // CVS-Rechte echo " \n"; $SQL_CVS = "SELECT * FROM `UserCVS` WHERE UID=". $_GET["enterUID"]; $Erg_CVS = mysql_query($SQL_CVS, $con); if( mysql_num_rows($Erg_CVS) != 1) echo "Sorry, der Engel (UID=". $_GET["enterUID"]. ") wurde in der Liste nicht gefunden."; else { $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 "

Sorry, der Engel (UID=". $_GET["enterUID"]. ") wurde in der Liste nicht gefunden.
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 "
Menu	\n"; echo " L \n"; echo " R \n"; echo "
Hometown	". "
Rights of \"". UID2Nick($_GET["enterUID"]). "\":
$CVS_Data_Name	"; echo "allow \n"; echo "denied \n"; echo "

\n
\n"; echo "\n"; echo "\n"; echo "

"; if( $_GET["Type"] == "Normal" ) { echo "

\n"; echo "\n"; echo "\n"; echo "

"; } } include ("./inc/footer.php"); ?>