";
$mgn_result = mysql_query("SELECT m_nummer FROM ".$db_settings['userdata_table']." WHERE m_nummer = '".mysql_escape_string($reg_mgn)."' LIMIT 1", $connid);
if (mysql_num_rows($mgn_result) == 0) $errors[] = $lang['error_mgn_not_available'];
// Überprüfen, ob der Nachname zur Mitgliedernummer passt (dh):
$nn_result = mysql_query("SELECT * FROM ".$db_settings['userdata_table']." WHERE m_nummer = '".mysql_escape_string($reg_mgn)."' LIMIT 1", $connid);
$row = mysql_fetch_array($nn_result);
if (strtolower($row[nachname]) != strtolower($reg_nn)) $errors[] = $lang['error_nn_not_fit'];
// schauen, ob die Mitgliedsnummer schon registriert ist:
$reg_result = mysql_query("SELECT user_pw FROM ".$db_settings['userdata_table']." WHERE m_nummer = '".mysql_escape_string($reg_mgn)."' LIMIT 1", $connid);
if(!$reg_result) die($lang['db_error']);
//$field = mysql_fetch_array($name_result);
$row_reg=mysql_fetch_array($reg_result);
if ($row_reg[user_pw]) $errors[] = $lang['error_reg'];
// name too long?
if (strlen($new_user_name) > $settings['name_maxlength']) $errors[] = $lang['name_marking'] . " " .$lang['error_input_too_long'];
// e-mail address too long?
//if (strlen($new_user_email) > $settings['email_maxlength']) $errors[] = $lang['email_marking'] . " " .$lang['error_input_too_long'];
// word in username too long?
$text_arr = explode(" ",$new_user_name); for ($i=0;$i $settings['name_word_maxlength']) {
$error_nwtl = str_replace("[word]", htmlspecialchars(stripslashes(substr($text_arr[$i],0,$settings['name_word_maxlength'])))."...", $lang['error_name_word_too_long']);
$errors[] = $error_nwtl; } }
// look if name already exists:
$name_result = mysql_query("SELECT user_name FROM ".$db_settings['userdata_table']." WHERE user_name = '".mysql_escape_string($new_user_name)."' LIMIT 1", $connid);
if(!$name_result) die($lang['db_error']);
$field = mysql_fetch_array($name_result);
mysql_free_result($name_result);
if (strtolower($field["user_name"]) == strtolower($new_user_name) && $new_user_name != "")
{
$lang['error_name_reserved'] = str_replace("[name]", htmlspecialchars(stripslashes($new_user_name)), $lang['error_name_reserved']);
$errors[] = $lang['error_name_reserved'];
}
// Guggen ob auch eine Mailadresse vorhanden ist
$email_result = mysql_query("SELECT user_email FROM ".$db_settings['userdata_table']." WHERE m_nummer = '$reg_mgn'");
$email = mysql_result($email_result,0,"user_email");
$posat = strpos($email,'@');
if (!$posat) $errors[] = "Keine gültige eMail-Adresse in der Datenbank hinterlegt!";
// look, if e-mail already exists:
/*
$email_result = mysql_query("SELECT user_email FROM ".$db_settings['userdata_table']." WHERE user_email = '".mysql_escape_string($new_user_email)."'", $connid);
if(!$email_result) die($lang['db_error']);
$field = mysql_fetch_array($email_result);
mysql_free_result($email_result);
if (strtolower($field["user_email"]) == strtolower($new_user_email) && $new_user_email != "")
{
$errors[] = str_replace("[e-mail]", htmlspecialchars(stripslashes($new_user_email)), $lang['error_email_reserved']);
}
*/
// e-mail correct?
//if (!preg_match("/^[^@]+@.+\.\D{2,5}$/", $new_user_email)) $errors[] = $lang['error_email_wrong'];
}
// save user if no errors:
if (empty($errors))
{
$new_user_type = "user";
$encoded_new_user_pw = md5($reg_pw);
$activate_code = md5(uniqid(rand()));
/*original*///@mysql_query("INSERT INTO ".$db_settings['userdata_table']." (user_type, user_name, user_pw, user_email, hide_email, last_login, last_logout, user_ip, registered, user_view, personal_messages, activate_code) VALUES ('".mysql_escape_string($new_user_type)."','".mysql_escape_string($new_user_name)."','".mysql_escape_string($encoded_new_user_pw)."','".mysql_escape_string($new_user_email)."','1',NOW(),NOW(),'".mysql_escape_string($_SERVER["REMOTE_ADDR"])."',NOW(),'".mysql_escape_string($settings['standard'])."','1', '".mysql_escape_string($activate_code)."')", $connid) or die($lang['db_error']);
/*dh*/ mysql_query("UPDATE ".$db_settings[userdata_table]." SET user_type = '".mysql_escape_string($new_user_type)."',
user_name = '".mysql_escape_string($new_user_name)."',
user_pw = '".mysql_escape_string($encoded_new_user_pw)."',
hide_email = '1',
last_login = NOW(),
last_logout = NOW(),
user_ip = '".mysql_escape_string($_SERVER[REMOTE_ADDR])."',
registered = NOW(),
user_view = '".mysql_escape_string($settings[standard])."',
personal_messages = '1',
rules = '1',
activate_code = '".mysql_escape_string($activate_code)."' WHERE m_nummer = '$reg_mgn'") or die ($lang['db_error']);
//$new_user_result = mysql_query("UPDATE $userdata_table SET reg='1', forum_username='$new_forum_username', user_type='$new_user_type', user_pw='$encoded_new_user_pw', hide_email='1', last_login=NOW(), last_logout=NOW(), user_ip='$_SERVER[REMOTE_ADDR]', registered=NOW(), user_view='$settings[standard]', personal_messages='1' WHERE user_name='$new_user_name'");
//UPDATE forum_userdata SET user_name='$reihe[0]' WHERE user_id='$reihe[1]'";
//@mysql_query("UPDATE ".$db_settings['userdata_table']." SET activate_code = '' WHERE user_id=".$user_id, $connid) or die($lang['db_error']);
// get new user ID:
$new_user_id_result = mysql_query("SELECT user_id FROM ".$db_settings['userdata_table']." WHERE user_name = '".mysql_escape_string($new_user_name)."' LIMIT 1", $connid);
if (!$new_user_id_result) die($lang['db_error']);
$field = mysql_fetch_array($new_user_id_result);
$new_user_id = $field['user_id'];
mysql_free_result($new_user_id_result);
// send e-mail with activation key to new user:
/*dh*/$mail_result = mysql_query("SELECT user_email FROM ".$db_settings['userdata_table']." WHERE m_nummer = '".mysql_escape_string($reg_mgn)."' LIMIT 1", $connid);
/*dh*/$row_mail=mysql_fetch_array($mail_result);
$ip = $_SERVER["REMOTE_ADDR"];
$lang['new_user_email_txt'] = str_replace("[name]", $new_user_name, $lang['new_user_email_txt']);
#$lang['new_user_email_txt'] = str_replace("[password]", $new_user_pw, $lang['new_user_email_txt']);
$lang['new_user_email_txt'] = str_replace("[activate_link]", $settings['forum_address']."register.php?id=".$new_user_id."&key=".$activate_code, $lang['new_user_email_txt']);
$lang['new_user_email_txt'] = stripslashes($lang['new_user_email_txt']);
$header = "From: ".$settings['forum_name']." <".$settings['forum_email'].">\n";
$header .= "X-Mailer: Php/" . phpversion(). "\n";
$header .= "X-Sender-ip: $ip\n";
$header .= "Content-Type: text/plain";
//$new_user_mailto = $new_user_name." <".$new_user_email.">";
/*dh*/$new_user_mailto = $new_user_name." <".$row_mail['user_email'].">";
if($settings['mail_parameter']!='')
{
if(@mail($new_user_mailto, $lang['new_user_email_sj'], $lang['new_user_email_txt'], $header, $settings['mail_parameter'])) $sent = true;
}
else
{
if(@mail($new_user_mailto, $lang['new_user_email_sj'], $lang['new_user_email_txt'], $header)) $sent = true;
}
// E-Mail-Benachrichtigung an Admins und Moderatoren:
// E-Mail erstellen:
$lang['new_user_notif_txt'] = str_replace("[name]", $new_user_name, $lang['new_user_notif_txt']);
//$lang['new_user_notif_txt'] = str_replace("[email]", $new_user_email, $lang['new_user_notif_txt']);
/*dh*/$lang['new_user_notif_txt'] = str_replace("[email]", $row_mail['user_email'], $lang['new_user_notif_txt']);
$lang['new_user_notif_txt'] = str_replace("[user_link]", $settings['forum_address']."user.php?id=".$new_user_id, $lang['new_user_notif_txt']);
$lang['new_user_notif_txt'] = stripslashes($lang['new_user_notif_txt']);
$header = "From: ".$settings['forum_name']." <".$settings['forum_email'].">\n";
$header .= "X-Mailer: Php/" . phpversion(). "\n";
$header .= "X-Sender-ip: $ip\n";
$header .= "Content-Type: text/plain";
// Schauen, wer eine E-Mail-Benachrichtigung will:
$admin_result=mysql_query("SELECT user_name, user_email FROM ".$db_settings['userdata_table']." WHERE new_user_notify='1'", $connid);
if(!$admin_result) die($lang['db_error']);
while ($admin_array = mysql_fetch_array($admin_result))
{
$ind_reg_emailbody = str_replace("[admin]", $admin_array['user_name'], $lang['new_user_notif_txt']);
$admin_mailto = $admin_array['user_name']." <".$admin_array['user_email'].">";
if($settings['mail_parameter']!='')
{
if(@mail($admin_mailto, $lang['new_user_notif_sj'], $ind_reg_emailbody, $header, $settings['mail_parameter'])) { $sent = "ok"; }
}
else
{
if(@mail($admin_mailto, $lang['new_user_notif_sj'], $ind_reg_emailbody, $header)) { $sent = "ok"; }
}
}
// Bestätigung anzeigen:
$action = "registered";
}
else
{
//unset($action);
/*dh*/$action = "main";
}
}
}
$wo = $lang['register_hl'];
$topnav = '
'.$lang['register_hl'].'';
parse_template();
echo $header;
if(empty($action)) $action = 'rules';
switch($action)
{
case 'notagree':
?>
| Systemmitteilung |
Da Sie sich entschieden haben, die Nutzungsbedingungen nicht zu akzeptieren,
können Sie die Registrierung nicht fortsetzen.
Gehen Sie auf ProAllrad.com
oder klicken Sie in Ihrem Browser auf 'Zurück', falls Sie die Nutzungsbedingungen
doch akzeptieren möchten.
|
break;
case 'rules':
?>
break;
case 'main':
if($settings['register_by_admin_only'] == 0 || isset($_SESSION[$settings['session_prefix'].'user_type']) && $_SESSION[$settings['session_prefix'].'user_type'] == "admin")
{
?>
'.$lang['contact_linkname'].'', $lang['reg_only_via_admin']);
?>