include("admin/classes/initial.php");
include("admin/classes/config.php");
include("admin/classes/functions.php");
$eventid = trim($_REQUEST['eventid']);
if ($eventid=="") {
header("location: list-your-event");
die();
}
if ($_REQUEST['action']=="joinnow") {
$error=0;
$FirstName = trim($_POST['FirstName']);
$LastName = trim($_POST['LastName']);
$Company = trim($_POST['Company']);
$Email = trim($_POST['Email']);
$Mobile = trim($_POST['Mobile']);
$Country = trim($_POST['Country']);
$Linkedin = trim($_POST['Linkedin']);
$Twitter = trim($_POST['Twitter']);
if ($FirstName=="") {
$error_string .= "First name is mandatory
";
$error=1;
}
if ($LastName=="") {
$error_string .= "Last name is mandatory
";
$error=1;
}
if ($Email=="") {
$error_string .= "Enter your email address
";
$error=1;
}
if ($Country=="") {
$error_string .= "Select your country from dropdown
";
$error=1;
}
if ($Mobile=="") {
$error_string .= "Mobile is mandatory
";
$error=1;
}
if (!is_numeric($Mobile)) {
$error_string .= "Enter your valid mobile number
";
$error=1;
}
if ($error==1) {
$error = '{"status":"validation_failed", "message":"'.$error_string.'"}';
die($error);
}else {
$chksql = "select * from eventbookings where EventId='".mysqli_real_escape_string($con,$eventid)."' and Email='".mysqli_real_escape_string($con,$Email)."'";
$chkrsq = mysqli_query($con,$chksql);
if (mysqli_num_rows($chkrsq)==0) {
$sql = "insert into eventbookings set ";
$sql .= "EventId='".mysqli_real_escape_string($con,$eventid)."', ";
$sql .= "MemberId='".$_SESSION['MASTER_ID']."', ";
$sql .= "FirstName='".mysqli_real_escape_string($con,$FirstName)."', ";
$sql .= "LastName='".mysqli_real_escape_string($con,$LastName)."', ";
$sql .= "Company='".mysqli_real_escape_string($con,$Company)."', ";
$sql .= "Email='".mysqli_real_escape_string($con,$Email)."', ";
$sql .= "Mobile='".mysqli_real_escape_string($con,$Mobile)."', ";
$sql .= "Country='".mysqli_real_escape_string($con,$Country)."', ";
$sql .= "Linkedin='".mysqli_real_escape_string($con,$Linkedin)."', ";
$sql .= "Twitter='".mysqli_real_escape_string($con,$Twitter)."', ";
$sql .= "CreatedIP='".$_SERVER['REMOTE_ADDR']."', ";
$sql .= "CreatedOn='".gmdate("Y-m-d H:i:s")."'";
if (!mysqli_query($con,$sql)) {
$error = '{"status":"technical_error", "message":"Sorry, there was a technical problem."}';
die($error);
}else {
$error = '{"status":"success", "message":"Your booking request has been successfully executed."}';
die($error);
}
} else {
$error = '{"status":"technical_error", "message":"You’ve already requested to join this event."}';
die($error);
}
}
}
$sql = "select a.*, b.FirstName, b.LastName, b.Email, b.ProfilePicture, b.Designation, b.MemberCode from events a join members b on a.CreatedBy=b.MemberId and EventId='".mysqli_real_escape_string($con,$eventid)."'";
$rsq = mysqli_query($con,$sql);
if (mysqli_num_rows($rsq)==0) {
header("location: list-your-event");
die();
}
$rs = mysqli_fetch_assoc($rsq);
$crsq = mysqli_query($con,"select * from countries order by nicename asc");
$mrsq = mysqli_query($con,"select FirstName,LastName,Email from members where MemberId='".$_SESSION['MASTER_ID']."'");
$mrs = mysqli_fetch_assoc($mrsq);
?>