{"id":88,"date":"2016-07-29T14:07:06","date_gmt":"2016-07-29T12:07:06","guid":{"rendered":"http:\/\/wordpress-test.tia-kerpen.de\/?page_id=88"},"modified":"2016-08-03T08:30:23","modified_gmt":"2016-08-03T06:30:23","slug":"registrierung","status":"publish","type":"page","link":"https:\/\/tia-kerpen.de\/en\/registrierung\/","title":{"rendered":"Register"},"content":{"rendered":"

require_once(“logging.php”);
\nrequire_once(“connect.php”);
\n$zz=mysql_query(“SELECT z FROM zaehler WHERE id LIKE ‘1’”);
\nwhile($ID=mysql_fetch_array($zz))
\n{
\n$zzz=”$ID[z]”;
\n}
\n$zzz++;<\/p>\n

$queryz =”UPDATE zaehler SET z = $zzz WHERE id LIKE ‘1’”;<\/p>\n

mysql_query($queryz)
\nor die (”
\nError: Couldn’t increment z.<\/span> – “.mysql_error());
\nrequire_once(“passwortgenerator.php”);\/\/Externe Daten Einbinden<\/p>\n

$i=0;
\n$mail_empfaenger=”info@tselepidis.de”;
\n$mail_absender = $_POST[‘Email’];
\n$betreff=”TIA Kerpen: Registration”;
\n$zwischenspeicherName=””;
\n$zwischenspeicherVorname=””;
\n$zwischenspeicherAnrede=””;
\n$zwischenspeicherEmail=””;
\n$zwischenspeicherPasswort=””;
\n$SR=0;
\n$text=””;
\n$Passwort=generatePW(10);\/\/Variablen Deklaration<\/p>\n

if(empty($_POST[‘Firma’]))
\n{$SR++;}<\/p>\n

if(empty($_POST[‘Anrede’]))
\n{$SR++;}<\/p>\n

if(empty($_POST[‘Vorname’]))
\n{$SR++;}<\/p>\n

if(empty($_POST[‘Name’]))
\n{$SR++;}<\/p>\n

if(empty($_POST[‘Tel’]))
\n{$SR++;}<\/p>\n

if(empty($_POST[‘Email’]))
\n{$SR++;}<\/p>\n

if(isset($_POST[‘Maschinenstillstand’]))
\n{$Maschinenstillstand=$_POST[‘Maschinenstillstand’];}
\nelse
\n{$Maschinenstillstand=””;}
\nif(isset($_POST[‘ServiceProgrammierer’]))
\n{$ServiceProgrammierer=$_POST[‘ServiceProgrammierer’];}
\nelse
\n{$ServiceProgrammierer=””;}
\nif(isset($_POST[‘ErwarteAnruf’]))
\n{$ErwarteAnruf=$_POST[‘ErwarteAnruf’];}
\nelse
\n{$ErwarteAnruf=””;}<\/p>\n

\/\/Werte \u00dcbergabe der Textfelder<\/p>\n

$Name=$_POST[‘Name’];<\/p>\n

$zIP=mysql_query(“SELECT id FROM kunden WHERE name LIKE ‘$Name'”);
\nwhile($ID=mysql_fetch_array($zIP))
\n{
\n$zName=mysql_query(“SELECT name FROM kunden WHERE id LIKE ‘$ID[id]'”);
\nwhile($Name=mysql_fetch_array($zName))
\n{
\n$zwischenspeicherName=”$Name[name]”;
\n}<\/p>\n

$zVorname=mysql_query(“SELECT vorname FROM kunden WHERE id LIKE ‘$ID[id]'”);
\nwhile($Vorname=mysql_fetch_array($zVorname))
\n{
\n$zwischenspeicherVorname=”$Vorname[vorname]”;
\n}<\/p>\n

$zAnrede=mysql_query(“SELECT anrede FROM kunden WHERE id LIKE ‘$ID[id]'”);
\nwhile($Anrede=mysql_fetch_array($zAnrede))
\n{
\n$zwischenspeicherAnrede=”$Anrede[anrede]”;
\n}
\n$zEmail=mysql_query(“SELECT email FROM kunden WHERE id LIKE ‘$ID[id]'”);
\nwhile($Email=mysql_fetch_array($zEmail))
\n{
\n$zwischenspeicherEmail=”$Email[email]”;
\n}
\n$zPasswort=mysql_query(“SELECT password FROM kunden WHERE id LIKE ‘$ID[id]'”);
\nwhile($Passwort=mysql_fetch_array($zPasswort))
\n{
\n$zwischenspeicherPasswort=”$Passwort[password]”;
\n}
\n}\/\/Werte aus DB Auslesen<\/p>\n

if($SR!=0)
\n{
\nif(!empty($_POST[‘Absenden’]))
\n{
\n$Fehler=”
\nYou didn’t enter all required information, please try again.<\/span>“;
\n}
\n}
\nelse
\n{
\nif(!empty($zwischenspeicherAnrede))
\n{$i++;}
\nelse{}<\/p>\n

if(!empty($zwischenspeicherVorname))
\n{$i++;}
\nelse{}<\/p>\n

if(!empty($zwischenspeicherName))
\n{$i++;}
\nelse{}<\/p>\n

\/\/\u00dcberpr\u00fcfen ob felder doppelt belegt sind<\/p>\n

if($i==3)
\n{
\n$Fehler=”
\nYou’re already registered, we’ll send you your password again.<\/span>“;
\nmail($mail_absender, $betreff, $text . “\\n\\nYour password is: $Passwort”, “from:$mail_empfaenger”);
\n}
\nelseif (!filter_var($_POST[‘Email’], FILTER_VALIDATE_EMAIL))
\n{
\n$Fehler=”
\nInvalid Email address.<\/span>“;
\n}
\nelse
\n{
\n$query =
\n“INSERT INTO kunden (firma,anrede,vorname,name,abteilung,position,strasse,plz,ort,tel,fax,email,land,password) values
\n(
\n‘$_POST[Firma]’,
\n‘$_POST[Anrede]’,
\n‘$_POST[Vorname]’,
\n‘$_POST[Name]’,
\n‘$_POST[Abteilung]’,
\n‘$_POST[Position]’,
\n‘$_POST[Strasse]’,
\n‘$_POST[PLZ]’,
\n‘$_POST[Ort]’,
\n‘$_POST[Tel]’,
\n‘$_POST[Fax]’,
\n‘$_POST[Email]’,
\n‘$_POST[Land]’,
\n‘$Passwort’
\n)”;
\nmysql_query($query)
\nor die (”
\nError: Couldn’t add account or Email address is already in use, please try using other data.<\/span>“);
\n$Fehler=”
\nRegistration was sucessful, you’ll receive an Email with your password soon.<\/span>“;\/\/Daten in DB \u00dcbertragen<\/p>\n

$text = “Original message:\\n”;
\n$text .= “> There was a registration from:\\n”;
\n$text .= “> $_POST[Anrede] $_POST[Vorname] $_POST[Name]\\n”;
\n$text .= “> From the company: $_POST[Firma].\\n”;
\n$text .= “> He is $_POST[Position]\\n”;
\n$text .= “> In the division $_POST[Abteilung].\\n”;
\n$text .= “> He lives in $_POST[Strasse]\\n”;
\n$text .= “> At $_POST[PLZ], $_POST[Ort], $_POST[Land].\\n”;
\n$text .= “> He’s available\\n”;
\n$text .= “> Via telephone at: $_POST[Tel],\\n”;
\n$text .= “> Via fax at: $_POST[Fax]\\n”;
\n$text .= “> And via Email at: $_POST[Email].\\n\\n”;
\n$text .= “> Further information:\\n”;
\n$text .= “> $_POST[Bemerkung]\\n”;
\n$text .= “> Expecting immediate call: $ErwarteAnruf\\n”;
\n$text .= “> Needing service programmer: $ServiceProgrammierer\\n”;
\n$text .= “> Having machine downtime: $Maschinenstillstand\\n\\n”;
\nmail($mail_empfaenger, $betreff, $text, “From: $mail_absender”);
\nmail($mail_absender, $betreff, $text . “Your password is: $Passwort”, “From: $mail_empfaenger”);
\n}
\n}
\nmysql_close($verbindung);<\/p>\n

$i=0;
\n$SR=0;
\n?><\/p>\n

 <\/p>\n

<\/p>\n

\n
\n

<\/p>\n

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
*<\/td>\nCompany<\/td>\n<\/td>\n<\/tr>\n
*<\/td>\nTitle<\/td>\n
*<\/td>\nSurname<\/td>\n<\/td>\n<\/tr>\n
*<\/td>\nName<\/td>\n<\/td>\n<\/tr>\n
<\/td>\nDivision<\/td>\n<\/td>\n<\/tr>\n
<\/td>\nPosition<\/td>\n<\/td>\n<\/tr>\n
<\/td>\nStreet<\/td>\n<\/td>\n<\/tr>\n
<\/td>\nZIP code<\/td>\n<\/td>\n<\/tr>\n
<\/td>\nCity<\/td>\n<\/td>\n<\/tr>\n
*<\/td>\nTel<\/td>\n<\/td>\n<\/tr>\n
<\/td>\nFax<\/td>\n<\/td>\n<\/tr>\n
*<\/td>\nEmail<\/td>\n<\/td>\n<\/tr>\n
<\/td>\nCountry<\/td>\n<\/td>\n<\/tr>\n
\u200d<\/td>\n\u200d<\/td>\n<\/tr>\n
<\/td>\nComment:<\/td>\n