public static function undoDelete($email)
{
// redefine
$email = (string) $email;
// get db
$db = BackendModel::getContainer()->get('database');
// get id
$id = $db->getVar('SELECT id
FROM users AS i
INNER JOIN users_settings AS s ON i.id = s.user_id
WHERE i.email = ? AND i.deleted = ?', array($email, 'Y'));
// no valid users
if ($id === null) {
return false;
} else {
// restore
$db->update('users', array('active' => 'Y', 'deleted' => 'N'), 'id = ?', (int) $id);
// return
return true;
}
}