/**
* displayUsers - Displays the users database table in
* a nicely formatted html table.
*/
function displayUsers(){
global $database;
$q = "SELECT username,userlevel,email,timestamp "
."FROM ".TBL_USERS." ORDER BY userlevel DESC,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 "
\n";
echo "| Username | Level | Email | Last Active |
\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");
$time = mysql_result($result,$i,"timestamp");
echo "| $uname | $ulevel | $email | $time |
\n";
}
echo "
\n";
}
/**
* displayBannedUsers - Displays the banned users
* database table in a nicely formatted html table.
*/
function displayBannedUsers(){
global $database;
$q = "SELECT username,timestamp "
."FROM ".TBL_BANNED_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 "
\n";
echo "| Username | Time Banned |
\n";
for($i=0; $i<$num_rows; $i++){
$uname = mysql_result($result,$i,"username");
$time = mysql_result($result,$i,"timestamp");
echo "| $uname | $time |
\n";
}
echo "
\n";
}
/**
* User not an administrator, redirect to main page
* automatically.
*/
if(!$session->isAdmin()){
header("Location: ../main.php");
}
else{
/**
* Administrator is viewing page, so display all
* forms.
*/
?>
Broadway Equipment Admin Center
Admin Center
::::::::::::::::::::::::::::::::::::::::::::
Logged in as echo $session->username; ?>
Back to [
Main Page]
if($form->num_errors > 0){
echo "
"
."!*** Error with request, please fix";
}
?>
/**
* Display Users Table
*/
?>
Users Table Contents:
displayUsers();
?>
|
/**
* Update User Level
*/
?>
Update User Level
echo $form->error("upduser"); ?>
|
|
/**
* Delete User
*/
?>
Delete User
echo $form->error("deluser"); ?>
|
|
/**
* Delete Inactive Users
*/
?>
Delete Inactive Users
This will delete all users (not administrators), who have not logged in to the site
within a certain time period. You specify the days spent inactive.
|
|
/**
* Ban User
*/
?>
Ban User
echo $form->error("banuser"); ?>
|
|
/**
* Display Banned Users Table
*/
?>
Banned Users Table Contents:
displayBannedUsers();
?>
|
|
/**
* Delete Banned User
*/
?>
Delete Banned User
echo $form->error("delbanuser"); ?>
|