header("Content-Type: text/html; charset=ISO-8859-1");
include_once("library/config.php"); ?>
ini_set('display_errors',1);
/*
error_reporting(E_ALL|E_STRICT);
ini_set('error_log','script_errors.log');
ini_set('log_errors','On');
*/
$celebrant_id=0;
$cel_name="";
$location_name="";
$$calenderMessage=='';
if(isset($_REQUEST['cid']))
{
$celebrant_id=$_REQUEST['cid'];
}
$time_arr=array("Afternoon"=>"a","Morning"=>"m","Evening"=>"e");
$error="";
$where = getSearchWhereCondition();// " AND sts = 'Show' ";
$cr_cel_name="";
$sql="Select
user_name, email, password,first_name , last_name , street_address , subrub , zipcode ,
postal_address, website, phone , mobile , gender , state ,
secret_question , secret_answer , profile_created_date,
search_txt, profile_txt, photo1, photo2, photo3, thumbnail,
pre_post, total_credits
From celebrants
Where celebrant_id='$celebrant_id' $where";
$rs=$db->ExecuteQuery($sql);
$cel_rows = $rs->GetSelectedRows();
list($user_name, $email, $password, $first_name , $last_name , $street_address , $subrub , $zipcode ,
$postal_address, $website, $phone , $mobile , $gender , $state ,
$secret_question , $secret_answer , $profile_created_date,
$search_txt, $profile_txt, $photo1, $photo2, $photo3, $thumbnail,
$payment_pre_post, $celebrant_total_credits)=$rs->FetchAsArray();
// For Advert
$advert_chk_from_session = "1";
//
////get block emails
$sql="Select emails FROM block_emails ";
$rs = $db->ExecuteQuery($sql);
list($block_emails)=$rs->FetchAsArray();
$cr_cel_name = trim(ucwords("$first_name $last_name"));
$cr_cel_email = $email;
$cr_cel_phone = $phone;
$cr_cel_mobile = $mobile;
$cr_cel_website = $website;
if(empty($cr_cel_name))
{
$cr_cel_name = "Celebrant";
}
$cr_cel_email = $email;
$bokmark_title = "$cr_cel_name - celebrante :: helping you find the right celebrant";
$bokmark_link = getCelebranteProfileLink($celebrant_id);
// for disabling pre paid celebrant with 0 credits
if($payment_pre_post == "Pre")
{
if($celebrant_total_credits == 0)// Disable the celebrant packge bcoz it all credits is used
{
$cel_rows = 0;
}
}
//
if(isset($_POST['btn_enquiry']))
{
extract($_POST);
$getblock_emails=@explode(",",$block_emails);
/*
$ename = stripslashes($ename);
$ephone = stripslashes($ephone);
$eemail = stripslashes($eemail);
$ectype = stripslashes($ectype);
$ecomment = stripslashes($ecomment);*/
//// Check Form Validation - Its also works form spam control ////
$validation_error = "";
//if(empty($robotest))
//{
//$validation_error .= "
You are a gutless robot ";
//}
if(empty($ename))
{
$validation_error .= "Your name is required ";
}
if(empty($ephone))
{
$validation_error .= "Your phone number is required ";
}
if(empty($eemail))
{
$validation_error .= "Your email is required ";
}
if(@in_array($eemail,$getblock_emails))
{
$validation_error .= "Enquiry cannot be send ";
}
/*elseif(!getEmailValidate($eemail))
{
$validation_error .= "Please enter correct email address! ";
}*/
// Also check for email vaildation
if(empty($ectype))
{
$validation_error .= "Ceremony type is required ";
}
if(empty($eclocation))
{
$validation_error .= "Location is required ";
}
if(empty($edate))
{
$validation_error .= "Date is required ";
}
if(empty($time))
{
$validation_error .= "Time is required ";
}
///check time availablity for this date///
$date_temp=explode("-",$edate);
$date_tt=strtotime($date_temp[2]."-".$date_temp[1]."-".$date_temp[0]);
$date=date("Y-m-d",$date_tt);
$sql_diary = "SELECT note, available, unavailable
FROM celebrants_diary
WHERE diary_date='$date'
AND celebrant_id='$celebrant_id' ";
$res_diary = $db->ExecuteQuery($sql_diary);
list($note, $available, $unavailable)=$res_diary->FetchAsArray();
$rows_diary = $res_diary->GetSelectedRows();
if(@in_array($time_arr[$time],@unserialize($unavailable)))
{
//$validation_error .= "Sorry, but $cr_cel_name is not available in $time! ";
$validation_error .= "Sorry, but $cr_cel_name is not available in the $time on the day you have selected. ";
}else
{
///go ahead
}
if(empty($ecomment))
{
$validation_error .= "Comments is required ";
}
else
{
$bad_words = getEnquiryBadWords();
$found_bad_word = false;
foreach ($bad_words as $word)
{
if (strpos($ecomment, $word) !== false)
{
$found_bad_word = true;
break;
}
}
if ($found_bad_word)
{
$all_bad_words = "";
foreach ($bad_words as $word)
{
$all_bad_words .= $word.", ";
}
if(!empty($all_bad_words))
{
$all_bad_words = substr($all_bad_words, 0, strlen($all_bad_words)-2);
}
$validation_error .= "Its like spam comment, please just describe your enquiry in short, without html tags ";
}
}
if(isset($_POST['g-recaptcha-response'])){
$captcha = $_POST['g-recaptcha-response'];
$secret = '6Lc1GicTAAAAAKq4OcwAylRcjIBSXhugivMWBwYB';
// print_r("https://www.google.com/recaptcha/api/siteverify?secret=".$secret."&response=".$captcha."&remoteip=".$_SERVER['REMOTE_ADDR']);
$response=json_decode(file_get_contents("https://www.google.com/recaptcha/api/siteverify?secret=".$secret."&response=".$captcha."&remoteip=".$_SERVER['REMOTE_ADDR']), true);
if(!$response['success']){
$validation_error .= "Captcha is required ";
}
}else{
$validation_error .= "Captcha is required Please enable javascript in your browser. ";
}
/*
{
;
}
*/
//// -------------------- ////
/* if(!empty($validation_error))*/ // means, form has an error
if(!empty($validation_error))
{
// print the form valition error!
$validation_error = "";
}
else
{
/* $captcha_security=0;
if($_SESSION['security_code'] == $_POST['scode'])
{
$captcha_security=1;
}
else
{
$error .= "Invalid security code! ";
}
if ($captcha_security) // valid captcha code
{
*/ list($sday, $smonth, $syear) = split('[/.-]', $edate);
$email_smonth = strtoupper($smonth);
$smonth = getMonthNumber($smonth);
$cermony_date_db = $syear."-".$smonth."-".$sday;
$today_date = date("Y-m-d");
$cid = (isset($_REQUEST['cid'])) ? $_REQUEST['cid']: false;
$celebrant_calender_sts = getCelebrantCalenderStatus($cid, $cermony_date_db, $today_date);
$is_ceremony_type = chkEnquiryCeremonyType($celebrant_id, $cermony_date_db, $ectype);
//-->if( (($celebrant_calender_sts == "calender_available") || ($celebrant_calender_sts == "calender_today")) && ($is_ceremony_type=="Available")) // || ($is_ceremony_type=="Available") ready to insert
if($is_ceremony_type=="Available") // || ($is_ceremony_type=="Available") ready to insert
{
// Sending Email to the celebrant
$sql_chk2 = "select celebrant_id from celebrants where email='$eemail'";
$rs_chk2 = $db->ExecuteQuery($sql_chk2);
list($cele_id) = $rs_chk2->FetchAsArray();
//$rcount = $rs_chk->GetSelectedRows();
if(!empty($cele_id))
{
$c_type = getCeremonyTypeName($ectype);
}
else
{
$c_type = getFromName()." Enquiry";
}
//$ecomment = addslashes($ecomment);
/* remove this comment after live
// subtract credits from celbrant table*/
//
///
$sql_total_credits = "SELECT total_credits FROM celebrants WHERE celebrant_id = '$cid' ";
$rs_total_credits = $db->ExecuteQuery($sql_total_credits);
list($celebrant_total_credits)=$rs_total_credits->FetchAsArray();
///
if($payment_pre_post == "Pre")
{
if($celebrant_total_credits == 0)// Disable the celebrant packge bcoz it all credits is used
{
disableCelebrantProfile($cid); // Disable the celebrant packge bcoz it all credits is used
paymentEmailRemainder($cid, "CreditZero"); // Email remainder to celebrant
header("Location: msg.php?action=creditend&cid=$cid");
exit;
}
$is_paid = '1';
}
elseif($payment_pre_post=="Post")
{
/* This feature is temporarly blocked, becuase david is not finalized post paid celebrnats yet!
if(!isLastPaymentClear($cid))
{
disableCelebrantProfile($cid); // Disable the celebrant packge bcoz it all credits is used
header("Location: msg.php?action=issue1&cid=$cid");
exit;
}*/
$is_paid = '0';
}
///
/*
$sql_celebrant_payment = "SELECT payment_id FROM celebrants_packages WHERE celebrant_id='$cid' AND is_active='1' ORDER BY payment_id DESC "; // get last one
$rs_celebrant_payment = $db->ExecuteQuery($sql_celebrant_payment);
list($payment_id)=$rs_celebrant_payment->FetchAsArray();
if(empty($payment_id))
{
$payment_id=0;
}
*/
$payment_id = getCelebrantActivePaymentID($cid);
/* Enquiry Generated */
$is_paid = filter_var($is_paid, FILTER_SANITIZE_MAGIC_QUOTES);
$ename = filter_var($ename, FILTER_SANITIZE_MAGIC_QUOTES);
$ephone = filter_var($ephone, FILTER_SANITIZE_MAGIC_QUOTES);
$eemail = filter_var($eemail, FILTER_SANITIZE_EMAIL);
$ectype = filter_var($ectype, FILTER_SANITIZE_NUMBER_FLOAT);
$eclocation = filter_var($eclocation, FILTER_SANITIZE_MAGIC_QUOTES);
$ecomment = filter_var($ecomment, FILTER_SANITIZE_MAGIC_QUOTES);
$sql_insert = "INSERT INTO celebrant_enquiries
(celebrant_id, payment_id, is_paid, name, phone, email,
ceremony_type, ceremony_location, ceremony_datetime,
comments, enquiry_date,txt_time_of_ceremony)
VALUES ('$cid', '$payment_id', '$is_paid', '$ename', '$ephone', '$eemail',
'$ectype', '$eclocation', '$cermony_date_db',
'$ecomment', now(),'$time')";
$db->ExecuteQuery($sql_insert);
$added_enq_id = mysql_insert_id();
/* End Enquiry Generated */
if(!empty($added_enq_id) && $added_enq_id != 0)
{
/////
if($payment_pre_post == "Pre")
{
if($celebrant_total_credits > 0)
{
//Balance Reduced By One Credit
reduceCreditBalance($cid);
// deduct remaining to -1 in payment table
// -- place query here
//
//If Balance Equals 2, 5 or 10 then Email Reminder
if(($celebrant_total_credits==2) || ($celebrant_total_credits==5) || ($celebrant_total_credits==10))
{
paymentEmailRemainder($cid, "CreditEnding");
}
}
}
elseif($payment_pre_post=="Post")
{
if(isLastPaymentClear($cid))
{
increaseCreditBalance($cid);
}
}
////
/* Enquiry Email */
///////////////// to get ceremony location //////////////////
$ceremony_locations = getLocationName($eclocation);
////////////////// end //////////////////
/////////////// to get ceremony type /////////////
$ceremony_type2=getCeremonyTypeName($ectype);
////////////////// end //////////////////////
// send to celebrant
$template_id = getEmailTemplateID("celebrantEnquiryNotification");
$e_message = getEmailTemplateMessage($template_id);
$cermony_date_email = $sday." ".$email_smonth." ".$syear;
$subject = $c_type;
$ecomment = nl2br($ecomment);
$website_link = getSiteURL();
$email_message = str_replace ( "CELEBRANT_NAME", $cr_cel_name, $e_message);
$email_message = str_replace ( "SENDER_NAME", $ename, $email_message);
$email_message = str_replace ( "PHONE_NO", $ephone, $email_message);
$email_message = str_replace ( "SENDER_EMAIL", $eemail, $email_message);
$email_message = str_replace ( "CEREMONY_DATE", $cermony_date_email, $email_message);
$email_message = str_replace ( "CEREMONY_TIME", $time, $email_message);
$email_message = str_replace ( "CEREMONY_TYPE", $ceremony_type2, $email_message);
$email_message = str_replace ( "CEREMONY_LOCATION", $ceremony_locations, $email_message);
$email_message = str_replace ( "COMMENTS", $ecomment, $email_message);
$email_message = str_replace ( "WEBSITE_URL", $website_link, $email_message);
$email_message = nl2br($email_message);
// send email by using function
//-->testing//$cr_cel_email = "umair.jaffar97@gmail.com";
sendEmail($cr_cel_email, $subject, $email_message);
// send to visitor confirmation
$e_message2 = getEmailTemplateMessage(getEmailTemplateID("visitorEnquiryNotification"));
// Sending Email to the visitor
$email_message = "";
$name2 = trim("$ename");
$subject = $c_type;
$email_message = str_replace ( "CELEBRANT_NAME", $cr_cel_name, $e_message2);
$email_message = str_replace ( "SENDER_NAME", $name2, $email_message);
$email_message = str_replace ( "PHONE_NO", $ephone, $email_message);
$email_message = str_replace ( "SENDER_EMAIL", $eemail, $email_message);
$email_message = str_replace ( "CEREMONY_DATE", $cermony_date_email, $email_message);
$email_message = str_replace ( "CEREMONY_TIME", $time, $email_message);
$email_message = str_replace ( "CEREMONY_TYPE", $ceremony_type2, $email_message);
$email_message = str_replace ( "CEREMONY_LOCATION", $ceremony_locations, $email_message);
$email_message = str_replace ( "COMMENTS", $ecomment, $email_message);
$email_message = str_replace ( "WEBSITE_URL", $website_link, $email_message);
// for celebrant details
$email_message = str_replace ( "CELEBRANT_NAME", $cr_cel_name, $email_message);
$email_message = str_replace ( "CELEBRANT_PHONE", $cr_cel_phone, $email_message);
$email_message = str_replace ( "CELEBRANT_MOBILE", $cr_cel_mobile, $email_message);
$email_message = str_replace ( "CELEBRANT_EMAIL", $cr_cel_email, $email_message);
$email_message = str_replace ( "CELEBRANT_WEBSITE", $cr_cel_website, $email_message);
//
$email_message = nl2br($email_message);
/**/
// send email by using function
//-->testing//$eemail = "umair.jaffar97@gmail.com";
sendEmail($eemail, $subject, $email_message);
header("Location: msg.php?action=enquirysent&cid=$cid");
exit;
/* End Enquiry Email */
}
else
{
$error .= "Sorry, there are some problem in sending an enquiry! ";
}
}
else
{
if($celebrant_calender_sts == "calender_booked")
{
if($is_ceremony_type=="Booked")
{
$calenderMessage='Scheduling Conflict';
$ceremony_type2=getCeremonyTypeName($ectype);
$error .= "Sorry, but $cr_cel_name is not available on $edate! ";
//$error .= "$cr_cel_name is fully booked in $ceremony_type2 at $edate! ";
}else
{
$calenderMessage='Scheduling Conflict';
$error .= "Sorry, but $cr_cel_name is not available on $edate! ";
} }
/*else
{
$available_date = getCelebrantAvailableDate($today_date);
list($ayear, $amonth, $aday) = split('[/.-]', $available_date);
$show_available_date = $aday."/".$amonth."/".$ayear;
$error .= "Please One month and one day before you can get married (".date("d/m/Y")." to ".$show_available_date.")! ";
}*/
}
/* }
else // captcha code is invalid
{
list($sday, $smonth, $syear) = split('[/.-]', $edate);
$smonth = getMonthNumber($smonth);
$cermony_date_db = $syear."-".$smonth."-".$sday;
$today_date = date("Y-m-d");
$celebrant_calender_sts = getCelebrantCalenderStatus($cid, $cermony_date_db, $today_date);
$is_ceremony_type = chkEnquiryCeremonyType($celebrant_id, $cermony_date_db, $ectype, $celebrant_calender_sts);
//echo $is_ceremony_type;
//-->if( (($celebrant_calender_sts == "calender_available") || ($celebrant_calender_sts == "calender_today")) && ($is_ceremony_type=="Available"))
if($is_ceremony_type=="Available")
{
// corret date!
}
elseif($celebrant_calender_sts == "calender_booked")
{
if($is_ceremony_type=="Booked")
{
$ceremony_type2=getCeremonyTypeName($ectype);
//-->$error .= "$cr_cel_name is fully booked in $ceremony_type2 at $edate! ";
$error .= "Sorry, but $cr_cel_name is not available on $edate! ";
}else
$error .= "Sorry, but $cr_cel_name is not available on $edate! ";
}
*/ /*else
{
$available_date = getCelebrantAvailableDate($today_date);
list($ayear, $amonth, $aday) = split('[/.-]', $available_date);
$show_available_date = $aday."/".$amonth."/".$ayear;
$error .= "Please One month and one day before you can get married (".date("d/m/Y")." to ".$show_available_date.")! ";
}*/
# set the error code so that we can display it
/*$captcha_error = $resp->error; */
// }
}
}
?>
$ptitle_cel_name= ucwords(trim("$first_name $last_name"));
if(!empty($ptitle_cel_name)) // it means celebrant is exists
{ if(!empty($ptitle_cel_name))
{
$ptitle_cel_name = $ptitle_cel_name." -";
}
$ptitle_subrub="";
if(!empty($subrub))
{
$ptitle_subrub = $subrub." ";
}
$p_title="$ptitle_cel_name $ptitle_subrub";
}
else
{
$p_title="celebrante :: helping you find the right celebrant";
}
?>
= $p_title;?>
JavaScript seem to be disabled in your browser.
You must have JavaScript enabled in your browser to utilize the functionality of this website.
=$cr_cel_name?>
if($cel_rows > 0) // if celebrant exists, also if eixits but pre paid celebrant with 0 enquiries
{ ?>
// for photo1
$photo = $photo1;
$file = CELEBRANTS_DIR.$photo;
if(file_exists($file) && !empty($photo))
{
$file = base64_encode($file);
$i_widht = base64_encode(CELEBRANT_LIWIDTH);
$i_height = base64_encode(CELEBRANT_LIHEIGHT);
$img_src = SHOW_PIC."?img=".$file."&mw=".$i_widht."&mh=".$i_height;
?>
}
else
{
echo "No Image!";
}
?>
// for photo2
$photo = $photo2;
$file = CELEBRANTS_DIR.$photo;
if(file_exists($file) && !empty($photo))
{
$file = base64_encode($file);
$i_widht = base64_encode(CELEBRANT_LIWIDTH);
$i_height = base64_encode(CELEBRANT_LIHEIGHT);
$img_src = SHOW_PIC."?img=".$file."&mw=".$i_widht."&mh=".$i_height;
?>
}
else
{
echo "No Image!";
}
?>
// for photo3
$photo = $photo3;
$file = CELEBRANTS_DIR.$photo;
if(file_exists($file) && !empty($photo))
{
$file = base64_encode($file);
$i_widht = base64_encode(CELEBRANT_LIWIDTH);
$i_height = base64_encode(CELEBRANT_LIHEIGHT);
$img_src = SHOW_PIC."?img=".$file."&mw=".$i_widht."&mh=".$i_height;
?>
}
else
{
echo "No Image!";
}
?>
// for photo1
$photo = $photo1;
$file = CELEBRANTS_DIR.$photo;
if(file_exists($file) && !empty($photo))
{
$file = base64_encode($file);
$i_widht = base64_encode(CELEBRANT_XSIWIDTH);
$i_height = base64_encode(CELEBRANT_XSIHEIGHT);
$img_src = SHOW_PIC."?img=".$file."&mw=".$i_widht."&mh=".$i_height;
?>
}
else
{
$file = NO_IMAGE;
$file = base64_encode($file);
$i_widht = base64_encode(CELEBRANT_XSIWIDTH);
$i_height = base64_encode(CELEBRANT_XSIHEIGHT);
$img_src = SHOW_PIC."?img=".$file."&mw=".$i_widht."&mh=".$i_height;
?>
}
?>
// for photo2
$photo = $photo2;
$file = CELEBRANTS_DIR.$photo;
if(file_exists($file) && !empty($photo))
{
$file = base64_encode($file);
$i_widht = base64_encode(CELEBRANT_XSIWIDTH);
$i_height = base64_encode(CELEBRANT_XSIHEIGHT);
$img_src = SHOW_PIC."?img=".$file."&mw=".$i_widht."&mh=".$i_height;
?>
}
else
{
$file = NO_IMAGE;
$file = base64_encode($file);
$i_widht = base64_encode(CELEBRANT_XSIWIDTH);
$i_height = base64_encode(CELEBRANT_XSIHEIGHT);
$img_src = SHOW_PIC."?img=".$file."&mw=".$i_widht."&mh=".$i_height;
?>
}
?>
// for photo2
$photo = $photo3;
$file = CELEBRANTS_DIR.$photo;
if(file_exists($file) && !empty($photo))
{
$file = base64_encode($file);
$i_widht = base64_encode(CELEBRANT_XSIWIDTH);
$i_height = base64_encode(CELEBRANT_XSIHEIGHT);
$img_src = SHOW_PIC."?img=".$file."&mw=".$i_widht."&mh=".$i_height;
?>
}
else
{
$file = NO_IMAGE;
$file = base64_encode($file);
$i_widht = base64_encode(CELEBRANT_XSIWIDTH);
$i_height = base64_encode(CELEBRANT_XSIHEIGHT);
$img_src = SHOW_PIC."?img=".$file."&mw=".$i_widht."&mh=".$i_height;
?>
}
?>
if(!empty($profile_txt))
{
?>
$profile_txt_new=html_entity_decode($profile_txt); echo stripslashes($profile_txt_new); ?>
This celebrant's direct contact details will be sent to you once you complete the enquiry form to the right of this celebrant's profile. You will then receive their phone number(s), email address and website details (if supplied). The Celebrant will also be sent an email with your contact details.
} ?>
Share this profile on Facebook
Bookmark this profile
Email this profile to a friend
Print this page
Return to the Search Results
//$start_date = date("Y-m-d");
//$end_date = date("Y-m-d", strtotime("+2 Years"));
$move_cal_end="36"; // maximum current date to 3 years to (12*3 = 36)!
$cm=0;
if(isset($_GET['cm']))
{
$cm=$_GET['cm'];
}
$em = $cm+4;
$curr_mm_yy = date("Y-m")."-01";
for($i=$cm ; $i < $em ; $i++)
{
$calender_date = date("Y-m-d", strtotime($curr_mm_yy." +".$i." month"));
list($cal_year, $cal_month, $cal_day)=split("[-]", $calender_date);
?>
=getMonthName("$cal_month")?> =$cal_year?>
=generate_calendar($celebrant_id, $cal_year, $cal_month, NULL, 1);?>
$i = $i +1;
$calender_date = date("Y-m-d", strtotime($curr_mm_yy." +".$i." month"));
list($cal_year, $cal_month, $cal_day)=split("[-]", $calender_date);
?>
=getMonthName("$cal_month")?> =$cal_year?>
=generate_calendar($celebrant_id, $cal_year, $cal_month, NULL, 1);?>
}
?>
Today's Date
One month notice period before you can get married
Partially Booked
Fully Booked
ExecuteQuery($sql_cel_view);
?>
} else { ?>
This celebrant's profile is currently unavailable. Please search again or contact us via =getAdminEmail()?>
} ?>