<?php
$kunde = "web0"; # User @ Confixx
$reseller = "res0"; # Reseller @ Confixx
$maxkb = "10240"; # Max KB for the POPAccount
$root_pass = "xxxx"; # Root Password of the Server
if (!empty($_POST['email']) AND !empty($_POST['type']))
{
$email = $_POST['email']."@xxxx.de";
if (eregi("[a-z0-9]+([-_\.]?[a-z0-9])+@[a-z0-9]+([-_\.]?[a-z0-9])+\.[a-z]{2,4}$",$email))
{
$mySQL = mysql_connect("localhost","xxx",$root_pass);
$mySelectDb = mysql_select_db("confixx");
$myQuery = mysql_query("SELECT * FROM pop3 ORDER BY number ASC");
while($data = mysql_fetch_array($myQuery,MYSQL_ASSOC))
{
$pop3 = str_pad (substr($data['account'],5),1,'0',STR_PAD_LEFT);
$uid = $data["uid"];
$number = $data["number"];
}
$uid = "0";
$number = (int)($number+1);
$neu = "1";
$account = $kunde."p".($pop3+1);
$password = crypt($_POST["password"]);
$email = mysql_real_escape_string(trim($_POST["email"]));
$kommentar = "NIX";
$target = mysql_real_escape_string(trim($_POST["target"]));
$domain = "xxx.de"; # E-Mail Domain
$lastchange = time();
$sql = "SELECT
count(*) AS COUNT
FROM
email
WHERE
prefix = '".mysql_real_escape_string(trim($_POST['email']))."'";
$erg = mysql_query($sql) or die (mysql_error());
$row = mysql_fetch_assoc($erg);
if($row['count'] > 0) {
echo 'Mail schon vergeben!';
}
else
{
if ($_POST["type"]=="pop3") {
$mySelectDb = mysql_select_db("rs_mail");
$source = mysql_query("INSERT INTO `accs`
(`mail`,`pwd`,`user`,`begin`,`last`)
VALUES ('".$email."','".$password."','".$account."','".$lastchange."','".$lastchange."')") or die(mysql_error());
$mySelectDb = mysql_select_db("confixx");
$source = mysql_query("INSERT INTO `pop3`
(`account`,`uid`,`longpw`,`kunde`,`anbieter`,`neu`,`number`,`quota`,`maxkb`,`kommentar`,`lastchange`)
VALUES ('".$account."','".$uid."','".$password."','".$kunde."','".$reseller."','".$neu."','".$number."','1','".$maxkb."','".$kommentar."','".$lastchange."')") or die(mysql_error());
$source = mysql_query("INSERT INTO `email`
(`prefix`,`kunde`,`domain`,`anbieter`,`neu`,`lastchange`)
VALUES ('".$email."','".$kunde."','".$domain."','".$reseller."','".$neu."','0')") or die(mysql_error());
$myQuery = mysql_query("SELECT * FROM email ORDER BY ident ASC");
while($data = mysql_fetch_array($myQuery,MYSQL_ASSOC)) {
$ident = $data["ident"];
}
$source = mysql_query("INSERT INTO `email_forward`
(`email_ident`,`pop3`,`kunde`)
VALUES ('".$ident."','".$account."','".$kunde."')") or die(mysql_error());
$source = mysql_query("UPDATE allgemein SET addpop='1', quota=1");
} elseif ($_POST["type"]=="redirect") {
$source = mysql_query("INSERT INTO `email`
(`prefix`,`kunde`,`domain`,`anbieter`,`neu`,`lastchange`)
VALUES ('".$email."','".$kunde."','".$domain."','".$reseller."','".$neu."','0')") or die(mysql_error());
$myQuery = mysql_query("SELECT * FROM email ORDER BY ident ASC");
while($data = mysql_fetch_array($myQuery,MYSQL_ASSOC)) {
$ident = $data["ident"];
}
$source = mysql_query("INSERT INTO `email_forward`
(`email_ident`,`pop3`,`kunde`)
VALUES ('".$ident."','".$target."','".$kunde."')") or die(mysql_error());
$source = mysql_query("UPDATE allgemein SET aliases='1'");
}
echo "Registrierung erfolgreich!";
mysql_close($mySQL);
}
}
else
{
echo "Bitte geben sie eine richtige eMail-Adresse an!";
}
}
else
{
echo "Bitte geben sie alle benötigten Daten an!";
}
?>