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']; }