sql_query($sql))) { bb_die('Could not obtain user information'); } if ($row = DB()->sql_fetchrow($result)) { if ($row['user_active'] && trim($row['user_actkey']) == '') { bb_die($lang['ALREADY_ACTIVATED']); } elseif ((trim($row['user_actkey']) == trim($_GET['act_key'])) && (trim($row['user_actkey']) != '')) { $sql_update_pass = ($row['user_newpasswd'] != '') ? ", user_password = '" . $user->password_hash($row['user_newpasswd']) . "', user_newpasswd = ''" : ''; $sql = "UPDATE " . BB_USERS . " SET user_active = 1, user_actkey = ''" . $sql_update_pass . " WHERE user_id = " . $row['user_id']; if (!($result = DB()->sql_query($sql))) { bb_die('Could not update users table'); } $message = ($sql_update_pass == '') ? $lang['ACCOUNT_ACTIVE'] : $lang['PASSWORD_ACTIVATED']; bb_die($message); } else { bb_die($lang['WRONG_ACTIVATION']); } } else { bb_die($lang['NO_SUCH_USER']); }