Neuen Engel eintragen

\n"; if (!isset ($_GET["OrderBy"])) $_GET["OrderBy"] = "Nick"; $SQL = "SELECT User.*, UserGroups.Name AS 'Group' FROM `User` " . "LEFT JOIN `UserCVS` ON User.UID = UserCVS.UID " . "LEFT JOIN `UserGroups` ON UserGroups.UID = UserCVS.GroupID " . "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=CreateDate">CreateDate	?OrderBy=Name">Name	?OrderBy=Vorname">Vorname	?OrderBy=Alter">Alter	?OrderBy=email">@ \| ?OrderBy=DECT">DECT \| ?OrderBy=Hometown">Hometown \| ?OrderBy=lastLogIn">lastLogIn \| ?OrderBy=Art">Type \| ?OrderBy=ICQ">ICQ \| ?OrderBy=jabber">jabber \| ?OrderBy=Group">Group	?OrderBy=Size">Größe	?OrderBy=Gekommen">G	?OrderBy=Aktiv">A	?OrderBy=Tshirt">T	Änd.	Secure
" . mysql_result($Erg, $n, "Nick") . " (Create: " . mysql_result($Erg, $n, "CreateDate") . ")	" . 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") . " "; if (strlen(mysql_result($Erg, $n, "ICQ")) > 0) echo "\n\t\tICQ: " . mysql_result($Erg, $n, "ICQ") . " "; if (strlen(mysql_result($Erg, $n, "jabber")) > 0) echo "\n\t\tjabber: " . mysql_result($Erg, $n, "jabber") . " "; echo "\n\t\tGroup: " . mysql_result($Erg, $n, "Group") . " "; echo "	" . mysql_result($Erg, $n, "Size") . "	" . mysql_result($Erg, $n, "Gekommen") . "	" . mysql_result($Erg, $n, "Aktiv") . "	" . mysql_result($Erg, $n, "Tshirt") . "	" . funktion_isLinkAllowed_addLink_OrEmpty("admin/userChangeNormal.php?enterUID=" . mysql_result($Erg, $n, "UID") . "&Type=Normal", "Änd.") . "	" . funktion_isLinkAllowed_addLink_OrEmpty("admin/userChangeSecure.php?enterUID=" . mysql_result($Erg, $n, "UID") . "&Type=Secure", "Secure") . "
						$Gekommen	$Active	$Tshirt

\n"; // Ende Userliste echo "

Statistics

"; funktion_db_element_list_2row("Hometown", "SELECT COUNT(`Hometown`), `Hometown` FROM `User` GROUP BY `Hometown`"); echo "
\n"; funktion_db_element_list_2row("Engeltypen", "SELECT COUNT(`Art`), `Art` FROM `User` GROUP BY `Art`"); echo "
\n"; funktion_db_element_list_2row("Used Groups", "SELECT UserGroups.Name AS 'GroupName', COUNT(UserGroups.Name) AS Count FROM `UserCVS` " . "LEFT JOIN `UserGroups` ON UserGroups.UID = UserCVS.GroupID " . "WHERE (UserCVS.GroupID!='NULL') " . "GROUP BY `GroupName` " . ""); } else { echo "error"; } include ("includes/footer.php"); ?>