function delete_user($user)
{
if (!empty($user->teamid)) {
user_quit_team($user);
}
if ($user->has_profile) {
mysql_query("DELETE FROM profile WHERE userid = {$user->id}");
delete_user_pictures($user->id);
mysql_query("UPDATE user SET has_profile=0 WHERE id={$user->id}");
}
if ($user->total_credit > 0.0) {
error_page("Cannot delete user: User has credit.");
return false;
}
// Don't delete user if they have any outstanding Results
//
$q = "SELECT COUNT(*) AS count FROM result WHERE userid=" . $user->id;
$result = mysql_query($q);
$c = mysql_fetch_object($result);
mysql_free_result($result);
if ($c->count) {
error_page("Cannot delete user: User has {$c->count} results in the database.");
}
// Don't delete user if they have posted to the forums
//
$q = "SELECT COUNT(*) AS count FROM post WHERE user="******"Cannot delete user: User has {$c->count} forum posts.");
}
$q = "DELETE FROM user WHERE id=" . $user->id;
$result = mysql_query($q);
}
function delete_account($user)
{
$x = "deleted_" . time() . "_" . random_string();
$retval = $user->update("email_addr='{$x}', authenticator='{$x}', name='', country='', postal_code='', has_profile=0");
if (!$retval) {
return false;
}
user_quit_team($user);
forum_delete_user($user);
pm_delete_user($user);
anonymize_hosts($user);
delete_profile($user);
return true;
}
function delete_user($user)
{
global $delete_problem;
if (!empty($user->teamid)) {
user_quit_team($user);
#$delete_problem .= "Removed user from team.<br/>";
}
if ($user->has_profile) {
mysql_query("DELETE FROM profile WHERE userid = {$user->id}");
delete_user_pictures($user->id);
mysql_query("UPDATE user SET has_profile=0 WHERE id={$user->id}");
#$delete_problem .= "Deleted profile.<br/>";
}
if ($user->total_credit > 0.0) {
$delete_problem .= "Cannot delete user: User has credit.<br/>";
return false;
}
// Don't delete user if they have any outstanding Results
//
$q = "SELECT COUNT(*) AS count FROM result WHERE userid=" . $user->id;
$result = mysql_query($q);
$c = mysql_fetch_object($result);
mysql_free_result($result);
if ($c->count) {
$delete_problem .= "Cannot delete user: User has " . $c->count . " Results in the database.<br/>";
}
// Don't delete user if they have posted to the forums
//
$q = "SELECT COUNT(*) AS count FROM post WHERE user="******"Cannot delete user: User has " . $c->count . " forum posts.<br/>";
}
if ($delete_problem) {
return false;
}
$q = "DELETE FROM user WHERE id=" . $user->id;
$result = mysql_query($q);
$delete_problem .= "User " . $user->id . " deleted.";
unset($user);
}
function possibly_delete_user($user)
{
if ($user->total_credit > 0.0) {
admin_error_page("Cannot delete user: User has credit.");
}
// Don't delete user if they have any outstanding Results
//
if (BoincResult::count("userid={$user->id}")) {
admin_error_page("Cannot delete user: User has count results in the database.");
}
// Don't delete user if they have posted to the forums
//
if (BoincPost::count("user={$user->id}")) {
admin_error_page("Cannot delete user: User has forum posts.");
}
if ($user->teamid) {
user_quit_team($user);
}
delete_user($user);
}
xml_error(-112, "Invalid project preferences: {$x}");
}
$query .= " project_prefs='{$project_prefs}', ";
}
if ($url) {
$query .= " url='{$url}', ";
}
if ($send_email != null) {
$query .= " send_email='{$send_email}', ";
}
if ($show_hosts != null) {
$query .= " show_hosts='{$show_hosts}', ";
}
if (!is_null($teamid)) {
if ($teamid == 0) {
user_quit_team($user);
} else {
$team = lookup_team($teamid);
if ($team && $team->joinable) {
user_join_team($team, $user);
}
}
}
if ($venue) {
$query .= " venue='{$venue}', ";
}
if ($email_addr && $email_addr != $user->email_addr) {
$old_email_addr = $user->email_addr;
$query .= " email_addr='{$email_addr}', ";
}
if ($password_hash) {
