Bitte geben Sie einen Code ein!'; }
else {
$test = md5($_POST['formAccount']);
$sql = "SELECT * FROM tableuser WHERE Coding = '$test' AND Accepted IS NULL";
$result = mysql_query($sql);
if(!mysql_num_rows($result))
{
echo '
Bitte überprüfen Sie Ihre Angaben! Kein Eintrag gefunden für Code: '.$_POST['formAccount'].' Möglicherweise ist die Freischaltung schon erfolgt und der Kunde hat sich bereits einmal eingeloggt!';
$test = 'true';}
while($row = mysql_fetch_object($result))
{ $Username = $row->Username;
$Surname = $row->Surname;
$Forename = $row->Forename;
$Email = $row->Email;
$FormOfAddress = $row->FormOfAddress;
$Title = $row->Title;
$Institut = $row->Institut;
$Division = $row->Division;
$Street = $row->Street;
$City = $row->City;
$Postal_Code = $row->Postal_Code;
$Country = $row->Country;
$Phone = $row->Phone;
$Institut_Delivery = $row->Institut_Delivery;
$Division_Delivery = $row->Division_Delivery;
$Street_Delivery = $row->Street_Delivery;
$City_Delivery = $row->City_Delivery;
$Postal_Code_Delivery = $row->Postal_Code_Delivery;
$Country_Delivery = $row->Country_Delivery;
$ID = $row->User_ID; }
if(mysql_num_rows($result)) {
echo '
Folgende Daten sind hinterlegt:
Form of Address
'.$FormOfAddress.'
Title
'.$Title.'
Family name
'.$Surname.'
First name
'.$Forename.'
Email
'.$Email.'
Billing Address
Institution
'.$Institut.'
Division
'.$Division.'
Street/P.O. Box
'.$Street.'
Postal Code
'.$Postal_Code.'
Location/City
'.$City.'
Country
'.$Country.'
Address for delivery (if other than the billing address)
Institution
'.$Institut_Delivery.'
Division
'.$Division_Delivery.'
Street
'.$Street_Delivery.'
Postal Code
'.$Postal_Code_Delivery.'
Location/City
'.$City_Delivery.'
Country
'.$Country_Delivery.'
Asked user name
'.$Username.'
Bitte überprüfe die angegebenen Daten!
Um den Account freizuschalten, aktiviere bitte dieses Kästchen.
Der Aktivierungscode bleibt erhalten, bis der Kunde sich das erste Mal eingeloggt hat. Danach wird er automatisch gelöscht!
Der Kunde erhält bei der Aktivierung eine Email mit einem zufällig generierten Passwort.
We welcome you at the DNA Bank Network. Your account has been successfully opened.
As of now you can order DNA samples using your user name and your password.
Username: ".$Username."
Password: ".$string."
Your data have been saved for processing your order and to customers support only. You can modify your data at any time to change your password. Please note that your account will be deactivated automatically if you don’t use it longer than 24 months.
To order DNA material validly, please search and choose DNA samples of your interest (Search), complete the order form and sign the Material Transfer Agreement (MTA).
The MTA has to be signed every for every order of DNA samples separately.
Don't hesitate to contact the DNA Bank Network if you have further questions.
Kunde ".$Forename." ".$Surname." wurde soeben freigeschaltet.
Der Freischaltcode bleibt so lange erhalten, bis er sich das erste Mal eingeloggt hat.
Username: ".$Username."
";
$from2 = "From: contact@dnabank-network.org\n";
$from2 .= "Content-Type: text/html\n";
//email to the customer "Account activated";
mail($Email, "DNA Bank Network - Account successfully opened", htmlspecialchars_decode($msg), $from1);
//email to the DNA Bank Network "Account for xy activated";
mail("contact@dnabank-network.org", "Account für ".htmlspecialchars_decode($Forename)." ".htmlspecialchars_decode($Surname)." freigeschaltet", htmlspecialchars_decode($msg2), $from2);
echo '
Der Account wurde aktiviert. Eine Email wurde an den Kunden sowie an das DNA Bank Team geschickt.
';
}
if($formSubmitShow and $_SESSION['admin'] == "true")
{
echo '
Suchanfragen
';
if($checkNull == "Yes")
echo '
Suchabfragen, die keinen Treffer ergaben.
';
$tr = "=";
$no = "!=";
$bt = ">=";
$st = "<=";
$parr = $_POST;
array($parr);
foreach ($parr as $var)
{
$i ++;
if(!empty($var))
{
switch (key($parr))
{
case 'checkNull':
$str = "Resultcount ".$tr." '0' AND ";
break;
case 'MonatStart':
$str = "Created_When ".$bt." '2009".$var."' AND ";
break;
case 'MonatEnde':
$str = "Created_When ".$st." '2009".$var."' AND ";
break;
case 'formSubmitShow':
$str = "Created_When ".$no." '' AND ";
break;
}
$where[$i] = $str;
}
next($parr);
}
if(!empty($str)) {
foreach($where AS $a) $string .= $a;
$l=strlen ($string);
$max = $l-4;
$where_str = substr($string, 0, $max);
$wherestr = ' WHERE ' . $where_str;
$sql = "SELECT count(Query) as anzahl, Query, Resultcount, Created_When FROM tablelog " .
$wherestr." GROUP BY Query ORDER BY anzahl DESC LIMIT 50";
$result = mysql_query($sql);
$count = mysql_num_rows($result); }
echo '
Insgesamt wurden '.$count.' verschiedene Suchanfragen gefunden.
