Step 2/3)" and (ereg("<", $var) or ereg(">", $var))) { $testhtml = "true"; echo ""; }} $username = $_POST['username']; echo ''; $sql = "SELECT Username FROM tableuser WHERE Username = '$username'"; $result = mysql_query($sql); // if(mysql_num_rows($result) or $test == "true" or $testhtml = true) if(mysql_num_rows($result) or $test == "true" or $testhtml == "true") //Prüfen, ob Benutzername schon existiert { if(mysql_num_rows($result)) { echo ''; } echo ''; } if(!mysql_num_rows($result) and $test != "true" and $testhtml != true) { echo ''; echo ' '; } echo '
Register (Preview) "; } if($formSubmitChange) { echo "

Register

"; } ?>
Incorrect character (<,>). Please change your entry!
'; if(empty($username)) { echo "Please complete user name.
"; $test = "true"; } if(empty($_POST['surname'])) { echo "Please complete family name.
"; $test = "true"; } if(empty($_POST['forename'])) { echo "Please complete first name.
"; $test = "true"; } if(empty($_POST['email'])) { echo "Please complete email address.
"; $test = "true"; } if(empty($_POST['email2'])) { echo "Please enter your email address again.
"; $test = "true"; } if(empty($_POST['institut'])) { echo "Please complete institution.
"; $test = "true"; } if(empty($_POST['street'])) { echo "Please complete street/P.O. Box.
"; $test = "true"; } if(empty($_POST['postalcode'])) { echo "Please complete postal code.
"; $test = "true"; } if(empty($_POST['city'])) { echo "Please complete city.
"; $test = "true"; } if(empty($_POST['country'])) { echo "Please complete country.
"; $test = "true"; } if(!isset($_POST['mta'])) { echo "Please read the instructions and hints for registration and select the checkbox.
"; $test = "true"; } if($_POST['username'] != "" and preg_match('/[^a-zA-Z0-9-_.]/', $_POST['username'])) { echo "User name contains special characters! Only – _ and . can be used.
"; $test = "true";} if($_POST['username'] != "" and strlen($_POST['username']) < 5) { echo "Your username is too short.
"; $test = "true";} if($_POST['email'] != "" and !ereg("@", $_POST['email'])) { echo "No valid email address.
"; $test = "true";} if($_POST['email'] != $_POST['email2']) { echo "Please enter the same email address again.
"; $test = "true";} echo '
Sorry, but this user name already exists. Please choose another one.
Form of AddressTitle
Family name *First name *
Email *
Please enter your email address again *


Billing Address *
Institution *
Division
Street/P.O. Box *
Postal Code *
Location/City *
Country *

Address for delivery (if other than the billing address)
Institution
Division
Street
Postal Code
Location/City
Country

Asked user name *


I read the instructions and hints for registration:



Notes
Please check your data:

Form of Address'.$_POST['FormOfAddress'].'
Title'.$_POST['title'].'
Family name'.$_POST['surname'].'
First name'.$_POST['forename'].'
Email

'.$_POST['email'].'

Billing Address
Institution'.$_POST['institut'].'
Division'.$_POST['division'].'
Street/P.O. Box'.$_POST['street'].'
Postal Code'.$_POST['postalcode'].'
Location/City'.$_POST['city'].'
Country

'.$_POST['country'].'

Address for delivery (if other than the billing address)
Institution'.$_POST['institut2'].'
Division'.$_POST['division2'].'
Street'.$_POST['street2'].'
Postal Code'.$_POST['postalcode2'].'
Location/City'.$_POST['city2'].'
Country

'.$_POST['country2'].'

Asked user name

'.$_POST['username'].'

Notes

'.$_POST['notes'].'

'; } //Korrektur der Eingaben if($formSubmitChange) { echo '
Form of AddressTitle
Family name *,First name *
Email *
Please enter your Email address again *
Billing Address *
Institution *
Division
Street/P.O. Box *
Postal Code *
Location/City *
Country *
Address for delivery (if other than the billing address)
Institution
Division
Street
Postal Code
Location/City
Country
Asked user name *
I read the instructions and hints for registration:
Notes
'; } // Registrierung abschließen if($formSubmitReg2) { $username = $_COOKIE['username']; $surname = addslashes($_COOKIE['surname']); $forename = addslashes($_COOKIE['forename']); $email = $_COOKIE['email']; $formOfAddress = $_COOKIE['FormOfAddress']; $title = addslashes($_COOKIE['title']); $institut = addslashes($_COOKIE['institut']); $division = addslashes($_COOKIE['division']); $street = addslashes($_COOKIE['street']); $city = addslashes($_COOKIE['city']); $postalcode = addslashes($_COOKIE['postalcode']); $country = addslashes($_COOKIE['country']); $institut2 = addslashes($_COOKIE['institut2']); $division2 = addslashes($_COOKIE['division2']); $street2 = addslashes($_COOKIE['street2']); $city2 = addslashes($_COOKIE['city2']); $postalcode2 = addslashes($_COOKIE['postalcode2']); $country2 = addslashes($_COOKIE['country2']); //Generierung des achtstelligen Aktivierungscodes für Holger function RandPass() { $randomPassword = ""; srand((double)microtime()*1000000); for($i=0;$i<8;$i++) { $randnumber = rand(48,120); while (($randnumber >= 58 && $randnumber <= 64) || ($randnumber >= 91 && $randnumber <= 96)) { $randnumber = rand(48,120); } $randomPassword .= chr($randnumber); } return $randomPassword; } $string = RandPass(); $string1 = md5($string); $sql = "INSERT INTO tableuser (Username, Surname, Forename, Email, FormOfAddress, Title, Institut, Division, Street, City, Postal_Code, Country, Institut_Delivery, Division_Delivery, Street_Delivery, City_Delivery, Postal_Code_Delivery, Country_Delivery, Coding) VALUES('$username','$surname','$forename','$email','$formOfAddress','$title','$institut','$division','$street','$city','$postalcode','$country','$institut2','$division2','$street2','$city2','$postalcode2','$country2','$string1')"; $result = mysql_query($sql); if($result) { //Email an Holger mit Bitte um Freischaltung $msg = ""; $msg .= ""; $msg .= "
Folgende Person bittet um Freischaltung ihres Accounts:
Form of Address:".$_COOKIE['FormOfAddress']."
Title:".$_COOKIE['title']."
Family name: ".$_COOKIE['surname']."
First name:".$_COOKIE['forename']."
Email:".$_COOKIE['email']."

Billing Address
Institution:".$_COOKIE['institut']."
Division:".$_COOKIE['division']."
Street/P.O. Box:".$_COOKIE['street']."
Postal Code:".$_COOKIE['postalcode']."
Location/City:".$_COOKIE['city']."
Country:".$_COOKIE['country']."
Address for delivery (if other than the billing address)
Institution:".$_COOKIE['institut2']."
Division:".$_COOKIE['division2']."
Street:".$_COOKIE['street2']."
Postal Code:".$_COOKIE['postalcode2']."
Location/City:".$_COOKIE['city2']."
Country:".$_COOKIE['country2']."
Asked user name:".$_COOKIE['username']."
Notes:".$_COOKIE['notes']."
Bitte geben Sie folgende Zeichenfolge im Admin-Bereich ein, um den Account freizuschalten: ".$string."
"; $from1 = "From: contact@dnabank-network.org\n"; $from1 .= "Content-Type: text/html\n"; //Email an den Kunden, mit Bestätigung über Eingang der Registrierungsanfrage $mesg = ""; $mesg .= ""; $from2 = "From: contact@dnabank-network.org\n"; $from2 .= "Content-Type: text/html\n"; $Email = $_COOKIE['email']; //email to the customer "Registration Request"; mail($Email, "DNA Bank Network Registration", htmlspecialchars_decode($mesg), $from2); //email to the DNA Bank Network "Registration Request"; mail("contact@dnabank-network.org", "DNA Bank Network Registration Request", htmlspecialchars_decode($msg), $from1); echo ""; echo '
Thank you very much for your registration request to open an account at the DNA Bank Network!

Please have a little patience until your account is activated since we will approve your authorisation. Within two working days you will receive an email with your preliminary password and detailed instructions.
We strongly recommend to change the preliminary password once you log in for the first time.

Form of Address:".$_COOKIE['FormOfAddress']."
Title:".$_COOKIE['title']."
Family name: ".$_COOKIE['surname']."
First name:".$_COOKIE['forename']."
Email:".$_COOKIE['email']."

Billing Address
Institution:".$_COOKIE['institut']."
Division:".$_COOKIE['division']."
Street/P.O. Box:".$_COOKIE['street']."
Postal Code:".$_COOKIE['postalcode']."
Location/City:".$_COOKIE['city']."
Country:".$_COOKIE['country']."

Address for delivery (if other than the billing address)
Institution:".$_COOKIE['institut2']."
Division:".$_COOKIE['division2']."
Street:".$_COOKIE['street2']."
Postal Code:".$_COOKIE['postalcode2']."
Location/City:".$_COOKIE['city2']."
Country:".$_COOKIE['country2']."

Asked user name:".$_COOKIE['username']."

Notes:".$_COOKIE['notes']."
Thank you for your registration at the DNA Bank Network!
You will promptly get an email message to your email account.
Your account will be activated as soon as possible.

Form of Address'.$_COOKIE['FormOfAddress'].'
Title'.$_COOKIE['title'].'
Family name'.$_COOKIE['surname'].'
First name'.$_COOKIE['forename'].'
Email

'.$_COOKIE['email'].'

Billing Address
Institution'.$_COOKIE['institut'].'
Division'.$_COOKIE['division'].'
Street/P.O. Box'.$_COOKIE['street'].'
Postal Code'.$_COOKIE['postalcode'].'
Location/City'.$_COOKIE['city'].'
Country

'.$_COOKIE['country'].'

Address for delivery (if other than the billing address)
Institution'.$_COOKIE['institut2'].'
Division'.$_COOKIE['division2'].'
Street'.$_COOKIE['street2'].'
Postal Code'.$_COOKIE['postalcode2'].'
Location/City'.$_COOKIE['city2'].'
Country

'.$_COOKIE['country2'].'

Asked user name

'.$_COOKIE['username'].'

Notes

'.$_COOKIE['notes'].'

'; } } echo' '; include ("TableImpressum.php"); echo ' '; include ("Piwik.js"); echo ' '; ?>