- $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET status='CONFIRMED', ref_payout='%s' WHERE user_hash='%s' AND status='UNCONFIRMED' LIMIT 1",
- array($_CONFIG['ref_payout'], $_GET['hash']), __FILE__, __LINE__);
- if (SQL_AFFECTEDROWS() == 1)
- {
- $msg = LOAD_EMAIL_TEMPLATE("confirm-member", "", bigintval($uid));
+ $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET status='CONFIRMED', ref_payout=%s, user_hash=NULL WHERE user_hash='%s' AND status='UNCONFIRMED' LIMIT 1",
+ array($_CONFIG['ref_payout'], $_GET['hash']), __FILE__, __LINE__);
+ if (SQL_AFFECTEDROWS() == 1) {
+ $msg = LOAD_EMAIL_TEMPLATE("confirm-member", array('points' => $_CONFIG['points_register']), bigintval($uid));