sql_query($sql); if ($row = $db->sql_fetchrow($result)) { if ($row['user_active'] && $row['user_actkey'] == '') { meta_refresh(3, "index.$phpEx$SID"); trigger_error($user->lang['Already_activated']); } else if ($row['user_actkey'] == $_GET['k']) { $sql_update_pass = ($row['user_newpasswd'] != '') ? ", user_password = '" . $db->sql_escape($row['user_newpasswd']) . "', user_newpasswd = ''" : ''; $sql = 'UPDATE ' . USERS_TABLE . " SET user_active = 1, user_actkey = ''" . $sql_update_pass . " WHERE user_id = " . $row['user_id']; $result = $db->sql_query($sql); if ($config['require_activation'] == USER_ACTIVATION_ADMIN && $sql_update_pass == '') { $this->include_file('includes/emailer'); $emailer = new emailer($config['smtp_delivery']); $emailer->use_template('admin_welcome_activated', $row['user_lang']); $emailer->to($row['user_email']); $emailer->assign_vars(array( 'SITENAME' => $config['sitename'], 'USERNAME' => $row['username'], 'PASSWORD' => $password_confirm, 'EMAIL_SIG' => str_replace('
', "\n", "-- \n" . $config['board_email_sig'])) ); $emailer->send(); $emailer->reset(); meta_refresh(3, "index.$phpEx$SID"); trigger_error($user->lang['Account_active_admin']); } else { meta_refresh(3, "index.$phpEx$SID"); $message = (!$sql_update_pass) ? $user->lang['ACCOUNT_ACTIVE'] : $user->lang['PASSWORD_ACTIVATED']; trigger_error($message); } set_config('newest_user_id', $row['user_id']); set_config('newest_username', $row['username']); set_config('num_users', $config['num_users'] + 1, TRUE); } else { trigger_error($user->lang['Wrong_activation']); } } else { trigger_error($user->lang['NO_USER']); } $db->sql_freeresult($result); } } ?>