"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; */ // } } } ?> <?= $p_title;?>

    0) // if celebrant exists, also if eixits but pre paid celebrant with 0 enquiries { ?>

    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.

    Contact this celebrant

    It's easy to get in touch with this celebrant. Just complete the quick enquiry form below.

    Once you send your enquiry, we'll send you an email with the celebrant's details and the celebrant will be sent an email with your details.

    Then either give them a call, or wait for them to contact you.

    ">

    .

    If you haven't heard from your celebrant within 24 hours, please contact our Helpdesk.

    0"; $rs = $db->ExecuteQuery($sql); $rows = $rs->GetSelectedRows(); if($rows > 0) { ?>

    I can perform these ceremonies:

      FetchAsArray()) { ?>
    0"; $rs = $db->ExecuteQuery($sql); $rows = $rs->GetSelectedRows(); if($rows > 0) { ?>

    My styles of ceremonies include:

      FetchAsArray()) { ?>
    0"; $rs = $db->ExecuteQuery($sql); $rows = $rs->GetSelectedRows(); if($rows > 0) { ?>

    Language:

      FetchAsArray()) { ?>
    0 "; $rs = $db->ExecuteQuery($sql); $rows = $rs->GetSelectedRows(); if($rows > 0) { ?>

    The locations I can work in include:

      FetchAsArray()) { ?>
    0"; $rs = $db->ExecuteQuery($sql); $rows = $rs->GetSelectedRows(); if($rows > 0) { ?>

    The venues that I can work at include:

      FetchAsArray()) { ?>
    Share this profile on Facebook
    . Bookmark this profile
    . Email this profile to a friend
    . Print this page
    . Return to the Search Results
    Move to: = 0) { ?>« Prev= 0) { ?> | = 0) && ($next <= $move_cal_end)) { ?>Next »= 0) { ?>
      Today's Date
      One month notice period before you can get married
      Partially Booked
      Fully Booked
    ExecuteQuery($sql_cel_view); ?>

    This celebrant's profile is currently unavailable. Please search again or contact us via