-if ((isset($_POST['ok'])) && (!$FAILED))
-{
- // Save the registration
- if (strlen($_POST['day']) == 1) $_POST['day'] = "0".$_POST['day'];
- if (strlen($_POST['month']) == 1) $_POST['month'] = "0".$_POST['month'];
-
- // Hash = MM-DD-YYYY:IP:USER_AGENT:TIMEMARK
- $hash = generateHash($_POST['month']."-".$_POST['day']."-".$_POST['year'].":".getenv('SERVER_NAME').":".getenv('REMOTE_ADDR').":".getenv('HTTP_USER_AGENT').":".time());
-
- // Add design when extension sql_patches is v0.2.7 or greater
- $ADD1 = ""; $ADD2 = "";
- if (GET_EXT_VERSION("sql_patches") >= "0.2.7")
- {
- // Okay, add design here
- $ADD1 = ", curr_theme";
- $ADD2 = ", '".GET_CURR_THEME()."'";
- }
-
- // Check if I shall disable sending mail to newly registered members out about active/begging rallye
- //
- // First comes first: begging rallye
- if (GET_EXT_VERSION("beg") >= "0.1.7")
- {
- // Okay, shall I disable now?
- if ($_CONFIG['beg_new_mem_notify'] == "N")
- {
- $ADD1 .= ", beg_ral_notify, beg_ral_en_notify";
- $ADD2 .= ", UNIX_TIMESTAMP(), UNIX_TIMESTAMP()";
- }
- }
-
- // Second: active rallye
- if (GET_EXT_VERSION("bonus") >= "0.7.7")
- {
- // Okay, shall I disable now?
- if ($_CONFIG['bonus_new_mem_notify'] == "N")
- {
- $ADD1 .= ", bonus_ral_notify, bonus_ral_en_notify";
- $ADD2 .= ", UNIX_TIMESTAMP(), UNIX_TIMESTAMP()";
- }
- }
-
- // Write user data to table
- if (EXT_IS_ACTIVE("country"))
- {
- // Save with new selectable country code
- $countryRow = "country_code";
- $countryData = bigintval($_POST['country_code']);
- }
- else
- {
- // Old way with enterable two-char-code
- $countryRow = "country";
- $countryData = addslashes(substr($_POST['cntry'], 0, 2));
- }
-
- //////////////////////////////
- // 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.")
-VALUES ('%s', '%s', '%s', '%s', '%s', %d, '%s', '%s', %d, %d, %d, '%s', %d, %d, %d, 'UNCONFIRMED', '%s', '%s', UNIX_TIMESTAMP(), UNIX_TIMESTAMP()".$ADD2.")",
-array(
- $countryRow,
- SQL_ESCAPE(substr($_POST['sex'], 0, 1)),
- SQL_ESCAPE($_POST['surname']),
- SQL_ESCAPE($_POST['family_name']),
- SQL_ESCAPE($_POST['street_nr']),
- $countryData,
- bigintval($_POST['zip']),
- SQL_ESCAPE($_POST['city']),
- SQL_ESCAPE($_POST['addy']),
- bigintval($_POST['day']),
- bigintval($_POST['month']),
- bigintval($_POST['year']),
- generateHash($_POST['pass1']),
- bigintval($_POST['max_mails']),
- bigintval($_POST['max_mails']),
- bigintval($_POST['refid']),
- $hash,
- getenv('REMOTE_ADDR'),
-), __FILE__, __LINE__);
-
- // Get his userid
- $result = SQL_QUERY_ESC("SELECT userid FROM "._MYSQL_PREFIX."_user_data WHERE user_hash='%s' LIMIT 1",
- array($hash), __FILE__, __LINE__);
- list($userid) = SQL_FETCHROW($result);