<td colspan=\"9\" align=\"center\">No Members to Display</td>
</tr>\n";
}
echo "</table><br>\n";
}
function list_users() {
$q = "SELECT * FROM ".DBTBLE."";
$result = mysql_query($q);
$num_rows = mysql_numrows($result);
echo "<select name=\"username\">";
for($i=0; $i<$num_rows; $i++){
$name=mysql_result($result,$i,"username");
echo "<option value=\"$name\">$name</option>";
}
echo "</select>";
}
function update_user($POST, $change) {
if(isset($change)) {
$username = $POST['username'];
$level = $POST['level'];
$this->query("UPDATE ".DBTBLE." SET user_level = '$level' WHERE username = '$username'");
return $username."'s User level was changed to ".$level;
}
}
function suspend_user($POST, $suspend) {
if(isset($suspend)) {
$username = $POST['username'];
$status = $POST['level'];
$email = $this->query("SELECT email_address FROM ".DBTBLE." WHERE username = '$username'");
$this->query("UPDATE ".DBTBLE." SET status = '$status' WHERE username = '$username'");
if ($status == "live") {
return $username."'s User Ststus was changed to Live.";
Status_Changed($username, $email, 'Approved');
} else if ($status == "suspended") {
return $username."'s User Ststus was changed to Suspended.";
Status_Changed($username, $email, 'Suspended');
}
}
}
function delete_user($POST, $delete) {
if(isset($delete)) {
$check = $POST['check'];
$id = $POST['id'];
if ($check == "yes") {
$this->query("DELETE FROM ".DBTBLE." WHERE userid = $id");
return "User was deleted.<br /><a href=\"admin_center.php\">Admin Center</a>";
} else if ($check == "no") {
return "User was not deleted.<br /><a href=\"admin_center.php\">Admin Center</a>";
}
} else {
return "Are you sure you want to delete the user?";
}
}
function edit_user($POST, $edit) {
if(isset($edit)) {
$first_name = $POST['first_name'];
$last_name = $POST['last_name'];
$info = $POST['info'];
$email_address = $POST['email_address'];
$username = $POST['username'];
$userid = $POST['userid'];
$this->query("UPDATE ".DBTBLE." SET first_name='$first_name', last_name='$last_name', email_address='$email_address', info='$info', username='$username' WHERE userid='".$userid."'");