public static function remove($id)
{
global $db;
$user = new user();
if ($user->get('id', $id) == 'done') {
$result = $db->query('select id from alliances where user="******"');
while ($row = db::fetch($result)) {
alliance::remove($row['id']);
}
$result = $db->query('select id from nodes where user="******"');
while ($row = db::fetch($result)) {
node::remove($row['id']);
}
$ok = 1;
$db->query('delete from activations where user="******"');
$db->query('delete from preferences where user="******"');
$db->query('delete from blocklist where to="' . $id . '" or from="' . $id . '"');
$messagesResult = $db->query('select id from messages where recipient="' . $id . '" or sender="' . $id . '"');
while ($row = db::fetch($messagesResult)) {
$db->query('insert into free_ids (id, type) values ("' . $row['id'] . '", "messages")');
if ($db->affected_rows() == -1) {
$ok = 0;
}
$db->query('delete from messages where id="' . $row['id'] . '"');
if ($db->affected_rows() == -1) {
$ok = 0;
}
}
$db->query('insert into free_ids (id, type) values ("' . $id . '", "users")');
if ($db->affected_rows() == -1) {
$ok = 0;
}
$db->query('delete from users where id="' . $id . '"');
if ($db->affected_rows() == -1) {
$ok = 0;
}
if ($ok) {
$status = 'done';
} else {
$status = 'error';
}
} else {
$status = 'noUser';
}
return $status;
}
$message = $ui['insufficientData'];
}
}
} else {
$message = $ui['noNode'];
}
} else {
$message = $ui['allianceSet'];
}
break;
case 'remove':
if (isset($_GET['go']) && $_GET['go']) {
if ($_SESSION[$shortTitle . 'User']['alliance']) {
if ($status == 'done') {
if ($alliance->data['user'] == $_SESSION[$shortTitle . 'User']['id']) {
$status = alliance::remove($_SESSION[$shortTitle . 'User']['alliance']);
if ($status == 'done') {
$_SESSION[$shortTitle . 'User']['alliance'] = 0;
header('location: alliance.php?action=get');
} else {
$message = $ui[$status];
}
} else {
$message = $ui['accessDenied'];
}
} else {
$message = $ui[$status];
}
} else {
$message = $ui['insufficientData'];
}
