Error! Invalid date format!. Calculated min date for today: '.$date.'';
else
echo 'Calculated min date for today: '.$date.'';
}
exit;
}
if (isset( $_GET['cpabc_app'] ) && $_GET['cpabc_app'] == 'cpabc_loadmaxdate' && is_admin() )
{
if ($_GET["code"] == '')
echo '';
else
{
$date = date("Y-m-d H:i",strtotime($_GET["code"]));
if (date("Y",strtotime($_GET["code"])) == '1970')
echo 'Error! Invalid date format!. Calculated max date for today: '.$date.'';
else
{
echo 'Calculated max date for today: '.$date.'';
$date2 = date("Y-m-d H:i",strtotime($_GET["code2"]));
if ($date2 >= $date)
echo '
Error! Max date is smaller than min date, so no days will be available in the calendar.';
}
}
exit;
}
if (isset($_GET["cpabc_c"]) && $_GET['cpabc_c'] == '1')
{
cpabc_process_cancel_go_appointment();
}
if (!defined('CP_CALENDAR_ID') && isset($_POST["cpabc_item"]))
define ('CP_CALENDAR_ID', intval($_POST["cpabc_item"]));
if ( 'POST' == $_SERVER['REQUEST_METHOD'] && isset( $_POST['cpabc_appointments_post_options'] ) && (is_admin() || cpabc_appointments_user_access_to(CP_CALENDAR_ID) ))
{
cpabc_appointments_save_options();
return;
}
if ( 'POST' == $_SERVER['REQUEST_METHOD'] && isset( $_POST['CP_ABC_post_edition'] ) && is_admin() )
{
cpabc_appointments_save_edition();
return;
}
// if this isn't the expected post and isn't the captcha verification then nothing to do
if ( 'POST' != $_SERVER['REQUEST_METHOD'] || ! isset( $_POST['cpabc_appointments_post'] ) )
if ( 'GET' != $_SERVER['REQUEST_METHOD'] || !isset( $_GET['hdcaptcha'] ) )
return;
if (function_exists('session_start')) @session_start();
if (!isset($_GET["hdcaptcha"]) || $_GET['hdcaptcha'] == '') $_GET['hdcaptcha'] = @$_POST['hdcaptcha'];
if (
(!is_admin() && cpabc_get_option('dexcv_enable_captcha', CPABC_TDEAPP_DEFAULT_dexcv_enable_captcha) != 'false') &&
( (strtolower($_GET['hdcaptcha']) != strtolower($_SESSION['rand_code'])) ||
($_SESSION['rand_code'] == '')
)
&&
( (md5(strtolower($_GET['hdcaptcha'])) != ($_COOKIE['rand_code'])) ||
($_COOKIE['rand_code'] == '')
)
)
{
$_SESSION['rand_code'] = '';
setCookie('rand_code', '', time()+36000,"/");
echo 'captchafailed';
exit;
}
// if this isn't the real post (it was the captcha verification) then echo ok and exit
if ( 'POST' != $_SERVER['REQUEST_METHOD'] || ! isset( $_POST['cpabc_appointments_post'] ) )
{
if (!isset($_GET["abcc"]))
return;
echo 'ok';
exit;
}
$_SESSION['rand_code'] = '';
$selectedCalendar = $_POST["cpabc_item"];
if (is_admin() && $_POST["selMonthcal".$selectedCalendar] != '' && $_POST["freq"] != '10')
$_POST["selDaycal".$selectedCalendar] .= $_POST["selMonthcal".$selectedCalendar];
$_POST["dateAndTime"] = explode(";",str_replace(",","-",$_POST["selDaycal".$selectedCalendar]));
array_shift($_POST["dateAndTime"]);
$military_time = cpabc_get_option('calendar_militarytime', CPABC_APPOINTMENTS_DEFAULT_CALENDAR_MILITARYTIME);
if (cpabc_get_option('calendar_militarytime', CPABC_APPOINTMENTS_DEFAULT_CALENDAR_MILITARYTIME) == '0') $format = "g:i A"; else $format = "H:i";
$calendar_dformat = cpabc_get_option('calendar_dateformat', CPABC_APPOINTMENTS_DEFAULT_CALENDAR_DATEFORMAT);
if ($calendar_dformat == '2')
$format = "d.m.Y ".$format;
else if ($calendar_dformat == '1')
$format = "d/m/Y ".$format;
else
$format = "m/d/Y ".$format;
for($n=0;$n $value)
$price[$item] = trim(str_replace(',','', str_replace(CPABC_APPOINTMENTS_DEFAULT_CURRENCY_SYMBOL,'',
str_replace(CPABC_APPOINTMENTS_GBP_CURRENCY_SYMBOL,'',
str_replace(CPABC_APPOINTMENTS_EUR_CURRENCY_SYMBOL_A, '',
str_replace(CPABC_APPOINTMENTS_EUR_CURRENCY_SYMBOL_B,'', $value )))) ));
if (isset($price[count($_POST["dateAndTime"])-1]))
$price = $price[count($_POST["dateAndTime"])-1];
else
$price = $price[0] * count($_POST["dateAndTime"]);
// check discount codes
//-------------------------------------------------
$discount_note = "";
$coupon = false;
$params = array();
$params["UTIMEZONE"] = @$_POST["cpabc_appointments_utime"];
$params["PRICE"] = number_format ($price, 2);
$params["COUPONCODE"] = ($coupon?"\nCoupon code:".$coupon->code.$discount_note."\n":"");
$params["QUANTITY"] = @$_POST["abc_capacity"];
// get form info
//---------------------------
$params["NAME"] = $_POST["name"];
$params["EMAIL"] = $_POST["email"];
$params["PHONE"] = $_POST["phone"];
$params["COMMENTS"] = $_POST["question"];
$buffer_A = $_POST["question"];
$to = "email";
$_SESSION['rand_code'] = '';
setCookie('rand_code', '', time()+36000,"/");
// insert into database
//---------------------------
if (date("Y",strtotime($_POST["dateAndTime"][0])) == "1970") // if this is spam, skip
return;
for ($n=0; $ninsert( CPABC_APPOINTMENTS_TABLE_NAME, array( 'calendar' => $selectedCalendar,
'time' => current_time('mysql'),
'booked_time' => $_POST["Date"][$n],
'booked_time_unformatted' => $_POST["dateAndTime"][$n],
'name' => "".@$_POST["name"],
'email' => "".@$_POST[$to],
'phone' => "".@$_POST["phone"],
'question' => $buffer_A,
'quantity' => (isset($_POST["abc_capacity"])?$_POST["abc_capacity"]:1),
'buffered_date' => serialize($params)
) );
if (!$rows_affected)
{
echo 'Error saving data! Please try again.';
echo '
If the error persists please be sure you are using the latest version and in that case contact support service at https://abc.dwbooster.com/contact-us?debug=db';
exit;
}
// save data here
$item_number[] = $wpdb->insert_id;
}
$item_number = implode(";", $item_number);
if (is_admin())
{
cpabc_process_ready_to_go_appointment($item_number, '');
return;
}
if (cpabc_get_option('paypal_mode','production') == "sandbox")
$ppurl = 'https://www.sandbox.paypal.com/cgi-bin/webscr';
else
$ppurl = 'https://www.paypal.com/cgi-bin/webscr';
?>
Redirecting to Paypal...
get_results( "SELECT * FROM ".CPABC_APPOINTMENTS_CONFIG_TABLE_NAME." where id='".intval($calendar)."' AND conwer<>'' AND conwer='".esc_sql($current_user->ID)."'" );
return count($myrows);
}
function cpabc_appointments_check_IPN_verification() {
global $wpdb;
if ( ! isset( $_GET['cpabc_ipncheck'] ) || $_GET['cpabc_ipncheck'] == '' )
return;
$_GET["itemnumber"] = $_GET['cpabc_ipncheck'];
$item_name = $_POST['item_name'];
$payment_status = $_POST['payment_status'];
$payment_amount = $_POST['mc_gross'];
$payment_currency = $_POST['mc_currency'];
$txn_id = $_POST['txn_id'];
$receiver_email = $_POST['receiver_email'];
$payer_email = $_POST['payer_email'];
$payment_type = $_POST['payment_type'];
$txnid = $_POST['txn_id'];
if (CPABC_TDEAPP_CALENDAR_STEP2_VRFY)
{
if ($payment_status != 'Completed' && $payment_type != 'echeck')
return;
if ($payment_type == 'echeck' && $payment_status == 'Completed')
return;
}
$itemnumber = explode(";",$_GET["itemnumber"]);
$myrows = $wpdb->get_results( "SELECT * FROM ".CPABC_TDEAPP_CALENDAR_DATA_TABLE." WHERE reference='".intval($itemnumber[0])."'" );
if (count($myrows))
{
echo 'OK - Already processed';
exit;
}
$myrows = $wpdb->get_results( "SELECT * FROM ".CPABC_APPOINTMENTS_TABLE_NAME." WHERE id=".intval($itemnumber[0]) );
$params = unserialize($myrows[0]->buffered_date);
$params["txnid"] = $txnid;
$wpdb->query( "UPDATE ".CPABC_APPOINTMENTS_TABLE_NAME." SET buffered_date='".esc_sql(serialize($params))."' WHERE id=".intval($itemnumber[0]) );
cpabc_process_ready_to_go_appointment($_GET["itemnumber"], $payer_email);
echo 'OK';
exit();
}
function cpabc_process_cancel_go_appointment()
{
global $wpdb;
$itemnumber = base64_decode($_GET["i"]);
if (is_numeric($itemnumber))
{
$wpdb->query( "DELETE FROM ".CPABC_TDEAPP_CALENDAR_DATA_TABLE." WHERE id=".$itemnumber );
header("Location: ".CPABC_APPOINTMENTS_DEFAULT_ON_CANCEL_REDIRECT_TO);
exit;
}
}
function cpabc_process_ready_to_go_appointment($itemnumber, $payer_email = "")
{
global $wpdb;
cpabc_appointments_add_field_verify(CPABC_TDEAPP_CALENDAR_DATA_TABLE, 'quantity', "VARCHAR(25) DEFAULT '1' NOT NULL");
cpabc_appointments_add_field_verify(CPABC_TDEAPP_CALENDAR_DATA_TABLE, 'reminder', "VARCHAR(1) DEFAULT '' NOT NULL");
cpabc_appointments_add_field_verify(CPABC_TDEAPP_CALENDAR_DATA_TABLE, 'reference', "VARCHAR(30) DEFAULT '' NOT NULL");
$itemnumber = explode(";",$itemnumber);
$myrows = $wpdb->get_results( "SELECT * FROM ".CPABC_APPOINTMENTS_TABLE_NAME." WHERE id=".intval($itemnumber[0]) );
$mycalendarrows = $wpdb->get_results( 'SELECT * FROM '.CPABC_APPOINTMENTS_CONFIG_TABLE_NAME .' WHERE `'.CPABC_TDEAPP_CONFIG_ID.'`='.$myrows[0]->calendar);
$reminder_timeline = date( "Y-m-d H:i:s", strtotime (date("Y-m-d H:i:s")." +".$mycalendarrows[0]->reminder_hours." hours") );
if (!defined('CP_CALENDAR_ID'))
define ('CP_CALENDAR_ID',$myrows[0]->calendar);
$SYSTEM_EMAIL = cpabc_get_option('notification_from_email', _cpabc_appointments_get_default_from_email() );
$SYSTEM_RCPT_EMAIL = cpabc_get_option('notification_destination_email', _cpabc_appointments_get_default_paypal_email() );
$email_subject1 = cpabc_get_option('email_subject_confirmation_to_user', CPABC_APPOINTMENTS_DEFAULT_SUBJECT_CONFIRMATION_EMAIL);
$email_content1 = cpabc_get_option('email_confirmation_to_user', CPABC_APPOINTMENTS_DEFAULT_CONFIRMATION_EMAIL);
$email_subject2 = cpabc_get_option('email_subject_notification_to_admin', CPABC_APPOINTMENTS_DEFAULT_SUBJECT_NOTIFICATION_EMAIL);
$email_content2 = cpabc_get_option('email_notification_to_admin', CPABC_APPOINTMENTS_DEFAULT_NOTIFICATION_EMAIL);
$email_content1 = str_replace("%CALENDAR%", $mycalendarrows[0]->uname, $email_content1);
$email_content2 = str_replace("%CALENDAR%", $mycalendarrows[0]->uname, $email_content2);
$params = unserialize($myrows[0]->buffered_date);
$attachments = array();
foreach ($params as $item => $value)
{
$email_content1 = str_replace('<%'.$item.'%>',(is_array($value)?(implode(", ",$value)):($value)),$email_content1);
$email_content2 = str_replace('<%'.$item.'%>',(is_array($value)?(implode(", ",$value)):($value)),$email_content2);
$email_content1 = str_replace('%'.$item.'%',(is_array($value)?(implode(", ",$value)):($value)),$email_content1);
$email_content2 = str_replace('%'.$item.'%',(is_array($value)?(implode(", ",$value)):($value)),$email_content2);
if (strpos($item,"_link"))
$attachments[] = $value;
}
$buffered_dates = array();
for ($n=0;$nget_results( "SELECT * FROM ".CPABC_APPOINTMENTS_TABLE_NAME." WHERE id=".intval($itemnumber[$n]) );
$buffered_dates[] = $myrows[0]->booked_time;
$information = $mycalendarrows[0]->uname."\n".
$myrows[0]->booked_time."\n".
($myrows[0]->name?$myrows[0]->name."\n":"").
$myrows[0]->email."\n".
($myrows[0]->phone?$myrows[0]->phone."\n":"").
$myrows[0]->question."\n";
if ($reminder_timeline > date("Y-m-d H:i:s", strtotime($myrows[0]->booked_time_unformatted)))
$reminder = '1';
else
$reminder = '';
$rows_affected = $wpdb->insert( CPABC_TDEAPP_CALENDAR_DATA_TABLE, array( 'appointment_calendar_id' => $myrows[0]->calendar,
'datatime' => date("Y-m-d H:i:s", strtotime($myrows[0]->booked_time_unformatted)),
'title' => $myrows[0]->email,
'reminder' => $reminder,
'quantity' => (isset($myrows[0]->quantity)?$myrows[0]->quantity:1),
'description' => str_replace("\n","
", $information),
'reference' => intval($itemnumber[$n])
) );
// SEND EMAILS START
if ($n == count($itemnumber)-1) // send emails only once
{
$params['itemnumber'] = $wpdb->insert_id;
$information = $mycalendarrows[0]->uname."\n".
implode(" - ",$buffered_dates)."\n".
($myrows[0]->name?$myrows[0]->name."\n":"").
$myrows[0]->email."\n".
($myrows[0]->phone?$myrows[0]->phone."\n":"").
$myrows[0]->question."\n";
$email_content1 = str_replace("%INFORMATION%", $information, $email_content1);
$email_content2 = str_replace("%INFORMATION%", $information, $email_content2);
$itemnumberdb = $wpdb->insert_id;
$cancel_link = cpabc_appointment_get_FULL_site_url().'/?cpabc_c=1&i='.base64_encode($itemnumberdb).'&a=1';
$email_content1 = str_replace("%CANCEL%", $cancel_link, $email_content1);
$email_content2 = str_replace("%CANCEL%", $cancel_link, $email_content2);
if (!strpos($SYSTEM_EMAIL,">"))
$SYSTEM_EMAIL = '"'.$SYSTEM_EMAIL.'" <'.$SYSTEM_EMAIL.'>';
// SEND EMAIL TO USER
$replyto = $myrows[0]->email;
if ('html' == cpabc_get_option('nuser_emailformat', CPABC_APPOINTMENTS_DEFAULT_email_format)) $content_type = "Content-Type: text/html; charset=utf-8\n"; else $content_type = "Content-Type: text/plain; charset=utf-8\n";
if (!is_admin() || isset($_POST["sendemails_admin"]))
{
wp_mail($myrows[0]->email, $email_subject1, $email_content1,
"From: ".$SYSTEM_EMAIL."\r\n".
$content_type.
"X-Mailer: PHP/" . phpversion());
if ($payer_email && strtolower($payer_email) != strtolower($myrows[0]->email))
wp_mail($payer_email , $email_subject1, $email_content1,
"From: ".$SYSTEM_EMAIL."\r\n".
$content_type.
"X-Mailer: PHP/" . phpversion());
// SEND EMAIL TO ADMIN
if ('html' == cpabc_get_option('nadmin_emailformat', CPABC_APPOINTMENTS_DEFAULT_email_format)) $content_type = "Content-Type: text/html; charset=utf-8\n"; else $content_type = "Content-Type: text/plain; charset=utf-8\n";
$to = explode(",",$SYSTEM_RCPT_EMAIL);
foreach ($to as $item)
if (trim($item) != '')
{
wp_mail(trim($item), $email_subject2, $email_content2,
"From: ".$SYSTEM_EMAIL."\r\n".
($replyto!=''?"Reply-To: \"$replyto\" <".$replyto.">\r\n":'').
$content_type.
"X-Mailer: PHP/" . phpversion(), $attachments);
}
}
}
// SEND EMAILS END
}
}
function cpabc_appointments_add_field_verify ($table, $field, $type = "text")
{
global $wpdb;
$results = $wpdb->get_results("SHOW columns FROM `".$table."` where field='".$field."'");
if (!count($results))
{
$sql = "ALTER TABLE `".$table."` ADD `".$field."` ".$type;
$wpdb->query($sql);
}
}
function cpabc_appointments_save_edition()
{
foreach ($_POST as $item => $value)
if (!is_array($value))
$_POST[$item] = stripcslashes($value);
if (substr_count($_POST['editionarea'],"\\\""))
$_POST["editionarea"] = stripcslashes($_POST["editionarea"]);
if ($_POST["cfwpp_edit"] == 'js')
update_option('CP_ABC_JS', base64_encode($_POST["editionarea"]));
else if ($_POST["cfwpp_edit"] == 'css')
update_option('CP_ABC_CSS', base64_encode($_POST["editionarea"]));
}
function cpabc_appointments_save_options()
{
global $wpdb;
if (!defined('CP_CALENDAR_ID'))
define ('CP_CALENDAR_ID', intval($_POST["cpabc_item"]));
if (!wp_verify_nonce( $_REQUEST['_wpnonce'], 'uname_abc' ))
{
echo "Access verification error. Cannot update settings.";
return;
}
if ( ! current_user_can('edit_pages') && !cpabc_appointments_user_access_to(CP_CALENDAR_ID) ) // prevent loading coupons from outside admin area
{
echo 'No enough privilegies to load this content.';
exit;
}
if ($_POST["cpabc_appointments_control_field"] == '\\"')
foreach ($_POST as $item => $value)
if (!is_array($value))
$_POST[$item] = stripcslashes($value);
cpabc_appointments_add_field_verify(CPABC_APPOINTMENTS_CONFIG_TABLE_NAME, 'enable_reminder');
cpabc_appointments_add_field_verify(CPABC_APPOINTMENTS_CONFIG_TABLE_NAME, 'reminder_hours');
cpabc_appointments_add_field_verify(CPABC_APPOINTMENTS_CONFIG_TABLE_NAME, 'reminder_subject');
cpabc_appointments_add_field_verify(CPABC_APPOINTMENTS_CONFIG_TABLE_NAME, 'reminder_content');
cpabc_appointments_add_field_verify(CPABC_TDEAPP_CALENDAR_DATA_TABLE, 'reminder', "VARCHAR(1) DEFAULT '' NOT NULL");
cpabc_appointments_add_field_verify(CPABC_TDEAPP_CALENDAR_DATA_TABLE, 'quantity', "VARCHAR(25) DEFAULT '1' NOT NULL");
cpabc_appointments_add_field_verify(CPABC_APPOINTMENTS_CONFIG_TABLE_NAME, 'min_slots');
cpabc_appointments_add_field_verify(CPABC_APPOINTMENTS_CONFIG_TABLE_NAME, 'max_slots');
cpabc_appointments_add_field_verify(CPABC_APPOINTMENTS_CONFIG_TABLE_NAME, 'close_fpanel');
cpabc_appointments_add_field_verify(CPABC_APPOINTMENTS_CONFIG_TABLE_NAME, 'quantity_field');
cpabc_appointments_add_field_verify(CPABC_APPOINTMENTS_CONFIG_TABLE_NAME, 'calendar_startyear', "VARCHAR(20) DEFAULT '' NOT NULL");
cpabc_appointments_add_field_verify(CPABC_APPOINTMENTS_CONFIG_TABLE_NAME, 'calendar_startmonth', "VARCHAR(20) DEFAULT '' NOT NULL");
cpabc_appointments_add_field_verify(CPABC_APPOINTMENTS_CONFIG_TABLE_NAME, 'calendar_theme');
cpabc_appointments_add_field_verify(CPABC_APPOINTMENTS_CONFIG_TABLE_NAME, 'paypal_mode');
$_POST["request_cost"] = '';
for ($k=1;$k <= intval($_POST["max_slots"]); $k++)
$_POST["request_cost"] .= ($k!=1?";":"").cpabc_clean_price($_POST["request_cost_".$k]);
$data = array(
'calendar_language' => $_POST["calendar_language"],
'calendar_dateformat' => $_POST["calendar_dateformat"],
'calendar_pages' => $_POST["calendar_pages"],
'calendar_militarytime' => $_POST["calendar_militarytime"],
'calendar_weekday' => $_POST["calendar_weekday"],
'calendar_mindate' => $_POST["calendar_mindate"],
'calendar_maxdate' => $_POST["calendar_maxdate"],
'min_slots' => $_POST["min_slots"],
'max_slots' => $_POST["max_slots"],
'close_fpanel' => $_POST["close_fpanel"],
'quantity_field' => $_POST["quantity_field"],
'paypal_mode' => $_POST["paypal_mode"],
'calendar_startyear' => $_POST["calendar_startyear"],
'calendar_startmonth' => $_POST["calendar_startmonth"],
'calendar_theme' => $_POST["calendar_theme"],
'paypal_email' => $_POST["paypal_email"],
'request_cost' => $_POST["request_cost"],
'paypal_product_name' => $_POST["paypal_product_name"],
'currency' => $_POST["currency"],
'url_ok' => $_POST["url_ok"],
'url_cancel' => $_POST["url_cancel"],
'paypal_language' => $_POST["paypal_language"],
'nuser_emailformat' => @$_POST["nuser_emailformat"],
'nadmin_emailformat' => $_POST["nadmin_emailformat"],
'nremind_emailformat' => $_POST["nremind_emailformat"],
'vs_text_is_required' => $_POST['vs_text_is_required'],
'vs_text_is_email' => $_POST['vs_text_is_email'],
'vs_text_datemmddyyyy' => $_POST['vs_text_datemmddyyyy'],
'vs_text_dateddmmyyyy' => $_POST['vs_text_dateddmmyyyy'],
'vs_text_number' => $_POST['vs_text_number'],
'vs_text_digits' => $_POST['vs_text_digits'],
'vs_text_max' => $_POST['vs_text_max'],
'vs_text_min' => $_POST['vs_text_min'],
'vs_text_submitbtn' => $_POST['vs_text_submitbtn'],
'cu_user_email_field' => @$_POST["cu_user_email_field"],
'notification_from_email' => $_POST["notification_from_email"],
'notification_destination_email' => $_POST["notification_destination_email"],
'email_subject_confirmation_to_user' => $_POST["email_subject_confirmation_to_user"],
'email_confirmation_to_user' => $_POST["email_confirmation_to_user"],
'email_subject_notification_to_admin' => $_POST["email_subject_notification_to_admin"],
'email_notification_to_admin' => $_POST["email_notification_to_admin"],
'enable_reminder' => @$_POST["enable_reminder"],
'reminder_hours' => @$_POST["reminder_hours"],
'reminder_subject' => @$_POST["reminder_subject"],
'reminder_content' => @$_POST["reminder_content"],
'dexcv_enable_captcha' => $_POST["dexcv_enable_captcha"],
'dexcv_width' => $_POST["dexcv_width"],
'dexcv_height' => $_POST["dexcv_height"],
'dexcv_chars' => $_POST["dexcv_chars"],
'dexcv_min_font_size' => $_POST["dexcv_min_font_size"],
'dexcv_max_font_size' => $_POST["dexcv_max_font_size"],
'dexcv_noise' => $_POST["dexcv_noise"],
'dexcv_noise_length' => $_POST["dexcv_noise_length"],
'dexcv_background' => str_replace('#','',$_POST['dexcv_background']),
'dexcv_border' => str_replace('#','',$_POST['dexcv_border']),
'dexcv_font' => $_POST["dexcv_font"],
'cv_text_enter_valid_captcha' => $_POST['cv_text_enter_valid_captcha'],
'cp_cal_checkboxes' => @$_POST["cp_cal_checkboxes"]
);
$wpdb->update ( CPABC_APPOINTMENTS_CONFIG_TABLE_NAME, $data, array( 'id' => CP_CALENDAR_ID ));
}
function cpabc_clean_price($price)
{
return preg_replace('/[^0-9.]+/', '', str_replace(',','.',$price));
}
function cpabc_appointments_get_field_name ($fieldid, $form)
{
if (is_array($form))
foreach($form as $item)
if ($item->name == $fieldid)
return $item->title;
return $fieldid;
}
function cpabc_appointments_export_csv ()
{
if (!is_admin())
return;
global $wpdb;
if (!defined('CP_CALENDAR_ID'))
define ('CP_CALENDAR_ID',intval($_GET["cal"]));
$form_data = json_decode(cpabc_appointment_cleanJSON(cpabc_get_option('form_structure', CPABC_APPOINTMENTS_DEFAULT_form_structure)));
$excluded = explode(",",get_option('CPABC_EXCLUDED_COLUMNS',""));
for ($i=0; $iget_results( "SELECT * FROM ".CPABC_TDEAPP_CALENDAR_DATA_TABLE." INNER JOIN ".CPABC_APPOINTMENTS_CONFIG_TABLE_NAME." ON ".CPABC_TDEAPP_CALENDAR_DATA_TABLE.".appointment_calendar_id=".CPABC_APPOINTMENTS_CONFIG_TABLE_NAME.".id LEFT JOIN ".CPABC_APPOINTMENTS_TABLE_NAME." ON ".CPABC_TDEAPP_CALENDAR_DATA_TABLE.".reference=".CPABC_APPOINTMENTS_TABLE_NAME.".id WHERE 1=1 ".$cond );
$fields = array();
if (!in_array("Calendar ID",$excluded)) $fields[] = "Calendar ID";
if (!in_array("Calendar",$excluded)) $fields[] = "Calendar";
if (!in_array("Time",$excluded)) $fields[] = "Time";
$values = array();
foreach ($events as $item)
{
$value = array();
if (!in_array("Calendar ID",$excluded)) $value[] = $item->appointment_calendar_id;
if (!in_array("Calendar",$excluded)) $value[] = $item->uname;
if (!in_array("Time",$excluded)) $value[] = $item->datatime;
$data = array();
$data = unserialize($item->buffered_date);
if (!is_array($data))
{
$data = array(
'title' => $item->title,
'description' => $item->description
);
}
$end = count($fields);
for ($i=3; $i<$end; $i++)
if (isset($data[$fields[$i]]) ){
$value[$i] = $data[$fields[$i]];
unset($data[$fields[$i]]);
}
else $value[$i] = '';
foreach ($data as $k => $d)
if (!in_array($k,$excluded))
{
$fields[] = $k;
$value[] = $d;
}
$values[] = $value;
}
header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename=bookings.csv");
$end = count($fields);
for ($i=0; $i<$end; $i++)
{
$hlabel = cpabc_appointments_iconv("utf-8", "ISO-8859-1//TRANSLIT//IGNORE", cpabc_appointments_get_field_name($fields[$i],@$form_data[0]));
echo '"'.str_replace('"','""', $hlabel).'",';
}
echo "\n";
foreach ($values as $item)
{
for ($i=0; $i<$end; $i++)
{
if (!isset($item[$i]))
$item[$i] = '';
if (is_array($item[$i]))
$item[$i] = implode($item[$i],',');
$item[$i] = cpabc_appointments_iconv("utf-8", "ISO-8859-1//TRANSLIT//IGNORE", $item[$i]);
echo '"'.str_replace('"','""', $item[$i]).'",';
}
echo "\n";
}
exit;
}
function cpabc_appointments_iconv($from, $to, $text)
{
if (function_exists('iconv'))
return iconv($from, $to, $text);
else
return $text;
}
function cpabc_appointments_calendar_load() {
global $wpdb;
if ( ! isset( $_GET['cpabc_calendar_load'] ) || $_GET['cpabc_calendar_load'] != '1' )
return;
@header("Cache-Control: no-store, no-cache, must-revalidate");
@header("Pragma: no-cache");
$calid = str_replace (CPABC_TDEAPP_CAL_PREFIX, "",$_GET["id"]);
$query = "SELECT * FROM ".CPABC_TDEAPP_CONFIG." where ".CPABC_TDEAPP_CONFIG_ID."='".esc_sql($calid)."'";
$row = $wpdb->get_results($query,ARRAY_A);
if ($row[0])
{
// New header to mark init of calendar output
echo '--***--***--***---!';
// START:: new code to clean corrupted data
$working_dates = explode(",",$row[0][CPABC_TDEAPP_CONFIG_WORKINGDATES]);
for($i=0;$iget_results($query,ARRAY_A);
if (isset($_GET["cpabc_action"]) && $_GET["cpabc_action"] == 'mvparse' && is_admin())
{
$ret = array();
$ret['events'] = array();
$ret["issort"] = true;
$ret['error'] = null;
$d1 = cpabc_js2PhpTime($_POST["startdate"]);
$d2 = cpabc_js2PhpTime($_POST["enddate"]);
$d1 = mktime(0, 0, 0, date("m", $d1), date("d", $d1), date("Y", $d1));
$d2 = mktime(0, 0, 0, date("m", $d2), date("d", $d2), date("Y", $d2))+24*60*60-1;
$ret["start"] = cpabc_php2JsTime($d1);
$ret["end"] = cpabc_php2JsTime($d2);
define('CPABC_CAL_TIME_SLOT_SIZE'," +".get_option('CPABC_CAL_TIME_SLOT_SIZE_SET',"30")." minutes");
foreach ($row_array as $row)
{
//if ($ret["start"] == '' || $ret["start"] > strtotime($row[CPABC_TDEAPP_DATA_DATETIME]))
// $ret["start"] = strtotime($row[CPABC_TDEAPP_DATA_DATETIME]);
//if ($ret["end"] == '' || $ret["end"] < strtotime($row[CPABC_TDEAPP_DATA_DATETIME]))
// $ret["end"] = strtotime($row[CPABC_TDEAPP_DATA_DATETIME]);
$ev = array(
$row["id"],
$row[CPABC_TDEAPP_DATA_TITLE],
cpabc_php2JsTime(cpabc_mySql2PhpTime($row[CPABC_TDEAPP_DATA_DATETIME])),
cpabc_php2JsTime(cpabc_mySql2PhpTime( date("Y-m-d H:i",strtotime($row[CPABC_TDEAPP_DATA_DATETIME].CPABC_CAL_TIME_SLOT_SIZE)))),
0, // is all day event?
0, // more than one day event
'',//Recurring event rule,
'#3CF',
0,//editable
'',
'',//$attends
$row[CPABC_TDEAPP_DATA_DESCRIPTION],
'',
1
);
$ret['events'][] = $ev;
}
echo json_encode($ret);
exit;
}
foreach ($row_array as $row)
{
echo $row[CPABC_TDEAPP_DATA_ID]."\n";
$dn = explode(" ", $row[CPABC_TDEAPP_DATA_DATETIME]);
$d1 = explode("-", $dn[0]);
$d2 = explode(":", $dn[1]);
echo intval($d1[0]).",".intval($d1[1]).",".intval($d1[2])."\n";
echo intval($d2[0]).":".($d2[1])."\n";
echo ($row["quantity"]?$row["quantity"]:'1')."\n";
if (is_admin())
{
echo $row[CPABC_TDEAPP_DATA_TITLE]."\n";
echo $row[CPABC_TDEAPP_DATA_DESCRIPTION]."\n*-*\n";
}
else
{
echo "Booked\n";
echo "OK\n*-*\n";
}
}
exit();
}
function cpabc_js2PhpTime($jsdate){
if(preg_match('@(\d+)/(\d+)/(\d+)\s+(\d+):(\d+)((am|pm)*)@', $jsdate, $matches)==1){
if ($matches[6]=="pm")
if ($matches[4]<12)
$matches[4] += 12;
$ret = mktime($matches[4], $matches[5], 0, $matches[1], $matches[2], $matches[3]);
}else if(preg_match('@(\d+)/(\d+)/(\d+)@', $jsdate, $matches)==1){
$ret = mktime(0, 0, 0, $matches[1], $matches[2], $matches[3]);
}
return $ret;
}
function cpabc_php2MySqlTime($phpDate){
return date("Y-m-d H:i:s", $phpDate);
}
function cpabc_php2JsTime($phpDate){
return @date("m/d/Y H:i", $phpDate);
}
function cpabc_mySql2PhpTime($sqlDate){
$a1 = explode (" ",$sqlDate);
$a2 = explode ("-",$a1[0]);
$a3 = explode (":",$a1[1]);
$t = mktime($a3[0],$a3[1],$a3[2],$a2[1],$a2[2],$a2[0]);
return $t;
}
function cpabc_appointments_calendar_update() {
global $wpdb, $user_ID;
if ( ! isset( $_GET['cpabc_calendar_update'] ) || $_GET['cpabc_calendar_update'] != '1' )
return;
$calid = intval(str_replace (CPABC_TDEAPP_CAL_PREFIX, "",$_GET["id"]));
if ( ! current_user_can('edit_pages') && !cpabc_appointments_user_access_to($calid) )
return;
cpabc_appointments_add_field_verify(CPABC_TDEAPP_CONFIG, 'specialDates');
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Pragma: no-cache");
if ( $user_ID )
$wpdb->query("update ".CPABC_TDEAPP_CONFIG." set specialDates='".esc_sql($_POST["specialDates"])."',".CPABC_TDEAPP_CONFIG_WORKINGDATES."='".esc_sql($_POST["workingDates"])."',".CPABC_TDEAPP_CONFIG_RESTRICTEDDATES."='".esc_sql($_POST["restrictedDates"])."',".CPABC_TDEAPP_CONFIG_TIMEWORKINGDATES0."='".esc_sql($_POST["timeWorkingDates0"])."',".CPABC_TDEAPP_CONFIG_TIMEWORKINGDATES1."='".esc_sql($_POST["timeWorkingDates1"])."',".CPABC_TDEAPP_CONFIG_TIMEWORKINGDATES2."='".esc_sql($_POST["timeWorkingDates2"])."',".CPABC_TDEAPP_CONFIG_TIMEWORKINGDATES3."='".esc_sql($_POST["timeWorkingDates3"])."',".CPABC_TDEAPP_CONFIG_TIMEWORKINGDATES4."='".esc_sql($_POST["timeWorkingDates4"])."',".CPABC_TDEAPP_CONFIG_TIMEWORKINGDATES5."='".esc_sql($_POST["timeWorkingDates5"])."',".CPABC_TDEAPP_CONFIG_TIMEWORKINGDATES6."='".esc_sql($_POST["timeWorkingDates6"])."' where ".CPABC_TDEAPP_CONFIG_ID."=".$calid);
exit();
}
function cpabc_appointments_calendar_update2() {
global $wpdb, $user_ID;
if ( ! isset( $_GET['cpabc_calendar_update2'] ) || $_GET['cpabc_calendar_update2'] != '1' )
return;
$calid = intval(str_replace (CPABC_TDEAPP_CAL_PREFIX, "",$_GET["id"]));
if ( ! current_user_can('edit_pages') && !cpabc_appointments_user_access_to($calid) )
return;
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Pragma: no-cache");
if ( $user_ID )
{
if ($_GET["act"]=='del')
$wpdb->query("delete from ".CPABC_TDEAPP_CALENDAR_DATA_TABLE." where ".CPABC_TDEAPP_DATA_IDCALENDAR."=".$calid." and ".CPABC_TDEAPP_DATA_ID."=".intval($_POST["sqlId"]));
else if ($_GET["act"]=='edit')
{
$data = explode("\n", $_POST["appoiments"]);
$d1 = explode(",", $data[0]);
$d2 = explode(":", $data[1]);
$datetime = $d1[0]."-".$d1[1]."-".$d1[2]." ".$d2[0].":".$d2[1];
$capacity = $data[2];
$title = $data[3];
$description = "";
for ($j=4;$jquery("update ".CPABC_TDEAPP_CALENDAR_DATA_TABLE." set ".CPABC_TDEAPP_DATA_DATETIME."='".$datetime."',quantity='".$capacity."',".CPABC_TDEAPP_DATA_TITLE."='".esc_sql($title)."',".CPABC_TDEAPP_DATA_DESCRIPTION."='".esc_sql($description)."' where ".CPABC_TDEAPP_DATA_IDCALENDAR."=".$calid." and ".CPABC_TDEAPP_DATA_ID."=".intval($_POST["sqlId"]));
}
else if ($_GET["act"]=='add')
{
$data = explode("\n", $_POST["appoiments"]);
$d1 = explode(",", $data[0]);
$d2 = explode(":", $data[1]);
$datetime = $d1[0]."-".$d1[1]."-".$d1[2]." ".$d2[0].":".$d2[1];
$capacity = $data[2];
$title = $data[3];
$description = "";
for ($j=4;$jquery("insert into ".CPABC_TDEAPP_CALENDAR_DATA_TABLE."(".CPABC_TDEAPP_DATA_IDCALENDAR.",".CPABC_TDEAPP_DATA_DATETIME.",".CPABC_TDEAPP_DATA_TITLE.",".CPABC_TDEAPP_DATA_DESCRIPTION.",quantity) values(".$calid.",'".$datetime."','".esc_sql($title)."','".esc_sql($description)."','".$capacity."') ");
echo $wpdb->insert_id;
}
}
exit();
}
function cpabc_get_captcha_params()
{
$str = '&inAdmin=1';
$tmp = cpabc_get_option('dexcv_width', CPABC_TDEAPP_DEFAULT_dexcv_width);
if ($tmp != CPABC_TDEAPP_DEFAULT_dexcv_width) $str .='&width='.$tmp;
$tmp = cpabc_get_option('dexcv_height', CPABC_TDEAPP_DEFAULT_dexcv_height);
if ($tmp != CPABC_TDEAPP_DEFAULT_dexcv_height) $str .='&height='.$tmp;
$tmp = cpabc_get_option('dexcv_chars', CPABC_TDEAPP_DEFAULT_dexcv_chars);
if ($tmp != CPABC_TDEAPP_DEFAULT_dexcv_chars) $str .='&letter_count='.$tmp;
$tmp = cpabc_get_option('dexcv_min_font_size', CPABC_TDEAPP_DEFAULT_dexcv_min_font_size);
if ($tmp != CPABC_TDEAPP_DEFAULT_dexcv_min_font_size) $str .='&min_size='.$tmp;
$tmp = cpabc_get_option('dexcv_max_font_size', CPABC_TDEAPP_DEFAULT_dexcv_max_font_size);
if ($tmp != CPABC_TDEAPP_DEFAULT_dexcv_max_font_size) $str .='&max_size='.$tmp;
$tmp = cpabc_get_option('dexcv_noise', CPABC_TDEAPP_DEFAULT_dexcv_noise);
if ($tmp != CPABC_TDEAPP_DEFAULT_dexcv_noise) $str .='&noise='.$tmp;
$tmp = cpabc_get_option('dexcv_noise_length', CPABC_TDEAPP_DEFAULT_dexcv_noise_length);
if ($tmp != CPABC_TDEAPP_DEFAULT_dexcv_noise_length) $str .='&noiselength='.$tmp;
$tmp = cpabc_get_option('dexcv_background', CPABC_TDEAPP_DEFAULT_dexcv_background);
if ($tmp != CPABC_TDEAPP_DEFAULT_dexcv_background) $str .='&bcolor='.$tmp;
$tmp = cpabc_get_option('dexcv_border', CPABC_TDEAPP_DEFAULT_dexcv_border);
if ($tmp != CPABC_TDEAPP_DEFAULT_dexcv_border) $str .='&border='.$tmp;
$tmp = cpabc_get_option('dexcv_font', CPABC_TDEAPP_DEFAULT_dexcv_font);
if ($tmp != CPABC_TDEAPP_DEFAULT_dexcv_font) $str .='&font='.$tmp;
return $str;
}
function cpabc_appointment_cleanJSON($str)
{
$str = str_replace('&qquot;','"',$str);
$str = str_replace(' ',' ',$str);
$str = str_replace("\n",'\n',$str);
$str = str_replace("\r",'',$str);
return $str;
}
function cpabc_auto_language($calendar_language)
{
if ($calendar_language == '-')
{
$calendar_language = substr(strtoupper(get_bloginfo('language')),0,2);
$calendar_language = str_replace ( array('ES','CS','NL','JA','KO','NB','SV',''),
array('SP','CZ','DU','JP','KR','NW','SE',''), $calendar_language);
}
return $calendar_language;
}
function cpabc_data_management_loaded()
{
global $wpdb, $cpabc_postURL;
$action = @$_POST['cpabc_do_action_loaded'];
if (!$action) return; // go out if the call isn't for this one
if ($_POST['cpabc_publish_id']) $item = $_POST['cpabc_publish_id'];
if ($action == "wizard")
{
$shortcode = '[CPABC_APPOINTMENT_CALENDAR calendar="'.$item .'"]';
$cpabc_postURL = cpabc_publish_on(@$_POST["whereto"], @$_POST["publishpage"], @$_POST["publishpost"], @$shortcode, @$_POST["posttitle"]);
return;
}
// ...
echo 'Some unexpected error happened. If you see this error contact the support service at https://bccf.dwbooster.com/contact-us';
exit();
}
function cpabc_publish_on($whereto, $publishpage = '', $publishpost = '', $content = '', $posttitle = 'Booking Form')
{
global $wpdb;
$id = '';
if ($whereto == '0' || $whereto =='1') // new page
{
$my_post = array(
'post_title' => $posttitle,
'post_type' => ($whereto == '0'?'page':'post'),
'post_content' => 'This is a preview page, remember to publish it if needed. You can edit the full form settings into the admin settings page.
'.$content,
'post_status' => 'draft'
);
// Insert the post into the database
$id = wp_insert_post( $my_post );
}
else
{
$id = ($whereto == '2'?$publishpage:$publishpost);
$post = get_post( $id );
$pos = strpos($post->post_content,$content);
if ($pos === false)
{
$my_post = array(
'ID' => $id,
'post_content' => $content.$post->post_content,
);
// Update the post into the database
wp_update_post( $my_post );
}
}
return get_permalink($id);
}
function cpabc_appointment_get_site_url($admin = false)
{
$blog = get_current_blog_id();
if( $admin )
$url = get_admin_url( $blog );
else
$url = get_home_url( $blog );
$url = parse_url($url);
$url = rtrim(@$url["path"],"/");
if (is_ssl())
$url = str_replace('http://', 'https://', $url);
return $url;
}
function cpabc_appointment_get_FULL_site_url($admin = false)
{
$blog = get_current_blog_id();
if( $admin )
$url = get_admin_url( $blog );
else
$url = get_home_url( $blog );
$url = parse_url($url);
$url = rtrim(@$url["path"],"/");
$pos = strpos($url, "://");
if ($pos === false)
$url = 'http://'.$_SERVER["HTTP_HOST"].$url;
if (is_ssl())
$url = str_replace('http://', 'https://', $url);
return $url;
}
// cpabc_cpabc_get_option:
$cpabc_option_buffered_item = false;
$cpabc_option_buffered_id = -1;
function cpabc_get_option ($field, $default_value = '')
{
global $wpdb, $cpabc_option_buffered_item, $cpabc_option_buffered_id;
if (!defined('CP_CALENDAR_ID'))
$id = 0;
else
$id = CP_CALENDAR_ID;
if ($cpabc_option_buffered_id == $id)
$value = @$cpabc_option_buffered_item->$field;
else
{
$myrows = $wpdb->get_results( "SELECT * FROM ".CPABC_APPOINTMENTS_CONFIG_TABLE_NAME." WHERE id=".intval($id) );
$value = @$myrows[0]->$field;
$cpabc_option_buffered_item = @$myrows[0];
$cpabc_option_buffered_id = $id;
}
if ($value == '' && @$cpabc_option_buffered_item->calendar_language == '')
$value = $default_value;
return $value;
}
function cpabc_appointment_is_administrator()
{
return current_user_can('manage_options');
}
$codepeople_promote_banner_plugins[ 'appointment-booking-calendar' ] = array(
'plugin_name' => 'Appointment Booking Calendar',
'plugin_url' => 'https://wordpress.org/support/plugin/appointment-booking-calendar/reviews/?filter=5#new-post'
);
require_once 'banner.php';
?>