nicht angemeldet
Danke vielmals für euer Engagment.
Ich denke, es ist Zeit den Code hier reinzubrösmeln!
admin.php:
<?
include("../include/session.php");
function displayUsers(){
global $database;
$q = "SELECT username,userlevel,email,timestamp,p_sms, p_sms_group, p_user_own, p_user_allM, p_user_allF "
."FROM ".TBL_USERS." ORDER BY username";
$result = $database->query($q);
/* Error occurred, return given name by default */
$num_rows = mysql_numrows($result);
if(!$result || ($num_rows < 0)){
echo "Error displaying info";
return;
}
if($num_rows == 0){
echo "Database table empty";
return;
}
/* Display table contents */
echo "<table align=\"left\" border=\"1\" cellspacing=\"0\" cellpadding=\"3\">\n";
echo "<tr><td><b>Username</b></td><td><b>Level</b></td><td><b>Email</b></td><td><b>p_sms</b></td><td><b>p_sms_group</b></td><td><b>p_user_allM</b></td><td><b>p_user_allF</b></td><td><b>p_user_own</b></td><td><b>Last Active</b></td></tr>\n";
for($i=0; $i<$num_rows; $i++){
$uname = mysql_result($result,$i,"username");
$ulevel = mysql_result($result,$i,"userlevel");
$email = mysql_result($result,$i,"email");
$p_sms = mysql_result($result,$i,"p_sms");
$p_sms_group = mysql_result($result,$i,"p_sms_group");
$p_user_own = mysql_result($result,$i,"p_user_own");
$p_user_allM = mysql_result($result,$i,"p_user_allM");
$p_user_allF = mysql_result($result,$i,"p_user_allF");
$time = mysql_result($result,$i,"timestamp");
if($p_sms == 1) {$tp_sms = " checked"; } else {$tp_sms = ""; }
if($p_sms_group == 1) {$tp_sms_group = " checked"; } else {$tp_sms_group = ""; }
if($p_user_allM == 1) {$tp_user_allM = " checked"; } else {$tp_user_allM = ""; }
if($p_user_allF == 1) {$tp_user_allF = " checked"; } else {$tp_user_allF = ""; }
if($p_user_own == 1) {$tp_user_own = " checked"; } else {$tp_user_own = ""; }
echo "<tr><td>$uname</td><td>$ulevel</td><td>$email</td><td><input name='".$uname."_p_sms' type='checkbox' value='1'" . $tp_sms . "></td><td><input name='".$uname."_p_sms_group' type='checkbox' value='1'" . $tp_sms_group . "></td><td><input name='".$uname."_p_user_allM' type='checkbox' value='1'" . $tp_user_allM . "></td><td><input name='".$uname."_p_user_allF' type='checkbox' value='1'" . $tp_user_allF . "></td><td><input name='".$uname."_p_user_own' type='checkbox' value='1'" . $tp_user_own . "></td><td>$time</td></tr>\n";
}
echo "</table><br>\n";
}
?>
<html>
<title>Admin</title>
<body>
<h1>Admin Center</h1>
<font size="5" color="#ff0000">
<b>::::::::::::::::::::::::::::::::::::::::::::</b></font>
<font size="4">Logged in as <b><? echo $session->username; ?></b></font><br><br>
Back to [<a href="../main.php">Main Page</a>]<br><br>
<?
if($form->num_errors > 0){
echo "<font size=\"4\" color=\"#ff0000\">"
."!*** Error with request, please fix</font><br><br>";
}
?>
<table align="left" border="0" cellspacing="5" cellpadding="5">
<tr><td>
<?
/**
* Display Users Table
*/
?>
<h3>Users Table Contents:</h3>
<p>
</p>
<table>
<form action="admin.php" method="POST">
<tr>
<td><br>
<?
displayUsers();
?>
</td><tr></tr><td>
<input type="submit" value="Update Access" name="btnPA"> </td>
</tr>
</form>
</table>
<?
if ($_POST['btnPA']){
/* Display table contents */
/* displayUsers(); */
global $database, $session;
$a_pages = array("p_sms", "p_sms_group", "p_user_allM", "p_user_allF", "p_user_own");
$q = "SELECT username "
."FROM ".TBL_USERS." ORDER BY username";
$result = $database->query($q);
/* Error occurred, return given name by default */
$num_rows = mysql_numrows($result);
for($i=0; $i<$num_rows; $i++){
$uname = mysql_result($result,$i,"username");
foreach ($a_pages as $tmp9){
if ($_POST[$uname . "_" . $tmp9] == "1"){
$database->updateUserField($uname, $tmp9, "1");
}else{
$database->updateUserField($uname, $tmp9, "0");
}
}
}
header("Location:admin.php");
}
?>