// Create user's account... //
//////////////////////////////
//
- $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_user_data (sex, surname, family, street_nr, %s, zip, city, email, birth_day, birth_month, birth_year, password, max_mails, receive_mails, refid, status, user_hash, REMOTE_ADDR, joined, last_update".$ADD1.")
+ $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_user_data (gender, surname, family, street_nr, %s, zip, city, email, birth_day, birth_month, birth_year, password, max_mails, receive_mails, refid, status, user_hash, REMOTE_ADDR, joined, last_update".$ADD1.")
VALUES ('%s', '%s', '%s', '%s', '%s', %s, '%s', '%s', %s, %s, %s, '%s', %s, %s, %s, 'UNCONFIRMED', '%s', '%s', UNIX_TIMESTAMP(), UNIX_TIMESTAMP()".$ADD2.")",
array(
$countryRow,
- SQL_ESCAPE(substr($_POST['sex'], 0, 1)),
+ SQL_ESCAPE(substr($_POST['gender'], 0, 1)),
SQL_ESCAPE($_POST['surname']),
SQL_ESCAPE($_POST['family_name']),
SQL_ESCAPE($_POST['street_nr']),
}
}
- // Rewrite sex
- $sex = TRANSLATE_SEX($_POST['sex']);
+ // Rewrite gender
+ $gender = TRANSLATE_GENDER($_POST['gender']);
// ... rewrite a zero referral ID to the main title
if ($_POST['refid'] == "0") $_POST['refid'] = MAIN_TITLE;
// Prepare data array for the email template
- // Start with the salutation...
+ // Start with the gender...
$DATA = array(
'hash' => $hash,
'uid' => $userid,
- 'salut' => $sex,
+ 'gender' => $gender,
'surname' => SQL_ESCAPE($_POST['surname']),
'family' => SQL_ESCAPE($_POST['family_name']),
'email' => SQL_ESCAPE($_POST['addy']),