forked from server/landingpage
57 lines
1.7 KiB
PHP
57 lines
1.7 KiB
PHP
<?php
|
|
date_default_timezone_set('Europe/Berlin');
|
|
ini_set('date.timezone', 'Europe/Berlin');
|
|
?>
|
|
<html>
|
|
<head>
|
|
<title>Mitglieder der Fachschaft <?php echo $fachschaft; ?> </title>
|
|
<meta http-equiv="Content-Type" content="text/html; charset=utf8" />
|
|
<link rel="stylesheet" type="text/css" href="style.css" />
|
|
|
|
</head>
|
|
<body>
|
|
<h1>Mitglieder der Fachschaft <?php echo $fachschaft; ?> - Stand <?php
|
|
echo date(DATE_RFC822);
|
|
?></h1>
|
|
<table>
|
|
<tr><th>Realer Name</th><th>Username</th><th>Email</th><th>Handy</th><th>Festnetz</th><th>ICQ</th><th>Geburtstag</th><th>Amt, Schlüssel</th></tr>
|
|
<?php
|
|
include 'include.php';
|
|
|
|
$abfrage = "SELECT u.username, u.email, u.userTitle, v.userOption45, v.userOption46, v.userOption47, v.userOption28, v.userOption12, v.userOption15, v.userOption53
|
|
FROM wcf1_group AS g
|
|
INNER JOIN wcf1_user_to_groups AS ug ON g.groupID = ug.groupID
|
|
INNER JOIN wcf1_user AS u ON u.userID = ug.userID
|
|
INNER JOIN wcf1_user_option_value AS v ON u.userID = v.userID
|
|
WHERE g.groupName ='$fachschaft'
|
|
ORDER BY v.userOption47";
|
|
$ergebnis = $mysqli->query($abfrage);
|
|
|
|
while($data = $ergebnis->fetch_assoc()){
|
|
$data = array_map('utf8_encode', $data);
|
|
echo "<tr>";
|
|
echo "<td>".$data['userOption47']."</td>";
|
|
echo "<td>".$data['username']."</td>";
|
|
echo "<td>".$data['email']."</td>";
|
|
echo "<td>".$data['userOption46']."</td>";
|
|
echo "<td>".$data['userOption45']."</td>";
|
|
echo "<td>".$data['userOption28']."</td>";
|
|
echo "<td>".$data['userOption12']."</td>";
|
|
echo "<td>".$data['userOption15'];
|
|
if ($data['userOption53'] == "1" || $data['userOption53'] == "Ja") {
|
|
echo ", Schlüsselbesitzer";
|
|
} else {
|
|
echo "";
|
|
}
|
|
echo "</td>";
|
|
echo "</tr>";
|
|
}
|
|
|
|
#$mysqli->free();
|
|
$mysqli->close();
|
|
|
|
?>
|
|
</table>
|
|
</body>
|
|
</html>
|