include("admin/classes/initial.php");
include("admin/classes/config.php");
if ($_REQUEST['action']=="createacc") {
$error=0;
$Nationality = trim($_POST['Nationality']);
$FirstName = ucfirst(trim($_POST['FirstName']));
$LastName = ucfirst(trim($_POST['LastName']));
$Email = strtolower(trim($_POST['Email']));
$Password = trim($_POST['Password']);
$CountryCode = trim($_POST['CountryCode']);
$Mobile = trim($_POST['Mobile']);
$Telegram = trim($_POST['Telegram']);
$Designation = trim($_POST['Designation']);
$Gender = trim($_POST['Gender']);
if($_POST['captcha'] != $_SESSION['digit']) {
$error_string .= "Sorry, captcha validation failed
";
$error=1;
}
if ($Designation=="") {
$error_string .= "Enter your current designation
";
$error=1;
}
if ($Nationality=="") {
$error_string .= "Select your nationality
";
$error=1;
}
if ($CountryCode=="") {
$error_string .= "Enter country code
";
$error=1;
}
if ($Mobile=="") {
$error_string .= "Enter your mobile number
";
$error=1;
}
if (!is_numeric($Mobile)) {
$error_string .= "Enter your valid mobile number
";
$error=1;
}
if ($FirstName=="") {
$error_string .= "Enter your first name
";
$error=1;
}
if ($LastName=="") {
$error_string .= "Enter your last name
";
$error=1;
}
if ($Email=="") {
$error_string .= "Enter your valid email address
";
$error=1;
}
if (strlen($Password)<8) {
$error_string .= "Length of password should me minimum 8
";
$error=1;
}
if ($error==1) {
$error = '{"status":"validation_failed", "message":"'.$error_string.'"}';
die($error);
}else {
$chkrsq = mysqli_query($con,"select * from members where Email='".mysqli_real_escape_string($con,$Email)."'");
if (mysqli_num_rows($chkrsq)>0) {
$error = '{"status":"duplicate_email", "message":"Sorry, this email is already registered with us."}';
die($error);
}
$mrsq = mysqli_query($con,"select max(MemberCode) as MemberCode from members");
if (mysqli_num_rows($mrsq)==0) {
$MemberCode = "100001";
}else {
$mrs = mysqli_fetch_assoc($mrsq);
$MemberCode = $mrs['MemberCode']+1;
}
$sql = "insert into members set ";
$sql .= "FirstName='".mysqli_real_escape_string($con,$FirstName)."', ";
$sql .= "LastName='".mysqli_real_escape_string($con,$LastName)."', ";
$sql .= "MemberCode='".mysqli_real_escape_string($con,$MemberCode)."', ";
$sql .= "Nationality='".mysqli_real_escape_string($con,$Nationality)."', ";
$sql .= "Designation='".mysqli_real_escape_string($con,$Designation)."', ";
$sql .= "Gender='".mysqli_real_escape_string($con,$Gender)."', ";
$sql .= "Email='".mysqli_real_escape_string($con,$Email)."', ";
$sql .= "Password='".mysqli_real_escape_string($con,md5($Password))."', ";
$sql .= "Telegram='".mysqli_real_escape_string($con,$Telegram)."', ";
$sql .= "CountryCode='".mysqli_real_escape_string($con,$CountryCode)."', ";
$sql .= "Mobile='".mysqli_real_escape_string($con,$Mobile)."', ";
$sql .= "Status='1', ";
$sql .= "CreatedOn='".gmdate("Y-m-d H:i:s")."',";
$sql .= "UpdatedOn='".gmdate("Y-m-d H:i:s")."',";
$sql .= "CreatedIP='".$_SERVER['REMOTE_ADDR']."'";
if (!mysqli_query($con,$sql)) {
$error = '{"status":"technical_error", "message":"Apologies, a technical issue occurred."}';
die($error);
}else {
$error = '{"status":"success", "message":"Congratulations!,
Your registration was completed successfully."}';
die($error);
}
}
}
$crsq = mysqli_query($con,"select * from countries order by nicename asc");
?>
Create your PROJECT_TITLE Account