query( $wpdb->prepare( 'UPDATE `'.CPABC_APPOINTMENTS_CONFIG_TABLE_NAME.'` SET conwer=%d,`'.CPABC_TDEAPP_CONFIG_USER.'`=%s WHERE `'.CPABC_TDEAPP_CONFIG_ID.'`=%d', $_GET["owner"], $_GET["name"], $_GET['u'] ) ); $message = "Item updated"; } } else if (isset($_GET['ac']) && $_GET['ac'] == 'st') { if (!wp_verify_nonce( $_REQUEST['_wpnonce'], 'uname_abc' )) $message = "Access verification error. Cannot update settings."; else { update_option( 'CPABC_CAL_TIME_ZONE_MODIFY_SET', $_GET["ict"] ); update_option( 'CPABC_CAL_TIME_SLOT_SIZE_SET', $_GET["ics"] ); update_option( 'CPABC_EXCLUDED_COLUMNS', $_GET["col"] ); update_option( 'CPABC_APPOINTMENTS_LOAD_SCRIPTS', ($_GET["scr"]=="1"?"1":"2") ); update_option( 'CPABC_APPOINTMENTS_DEFAULT_USE_EDITOR', "1" ); if ($_GET["chs"] != '') { $target_charset = esc_sql($_GET["chs"]); $tables = array( $wpdb->prefix.CPABC_APPOINTMENTS_TABLE_NAME_NO_PREFIX, $wpdb->prefix.CPABC_APPOINTMENTS_CALENDARS_TABLE_NAME_NO_PREFIX , $wpdb->prefix.CPABC_APPOINTMENTS_CONFIG_TABLE_NAME_NO_PREFIX, $wpdb->prefix.CPABC_APPOINTMENTS_DISCOUNT_CODES_TABLE_NAME_NO_PREFIX ); foreach ($tables as $tab) { $myrows = $wpdb->get_results( "DESCRIBE {$tab}" ); foreach ($myrows as $item) { $name = $item->Field; $type = $item->Type; if (preg_match("/^varchar\((\d+)\)$/i", $type, $mat) || !strcasecmp($type, "CHAR") || !strcasecmp($type, "TEXT") || !strcasecmp($type, "MEDIUMTEXT")) { $wpdb->query("ALTER TABLE {$tab} CHANGE {$name} {$name} {$type} COLLATE {$target_charset}"); } } } } $message = "Troubleshoot settings updated"; } } $nonce_un = wp_create_nonce( 'uname_abc' ); if ($message) echo "

".$message."

"; ?>

Appointment Booking Calendar

Calendar List / Items List

get_results( "SELECT user_login,ID FROM ".$wpdb->users." ORDER BY ID DESC" ); $myrows = $wpdb->get_results( "SELECT * FROM ".CPABC_APPOINTMENTS_CONFIG_TABLE_NAME ); foreach ($myrows as $item) if (cpabc_appointment_is_administrator() || ($current_user->ID == $item->conwer)) { ?>
IDCalendar NameOwneriCal Link    OptionsShortcode
id; ?> name="calname_id; ?>" id="calname_id; ?>" value="uname); ?>" /> user_login; ?> ">iCal Feed [CPABC_APPOINTMENT_CALENDAR calendar="id; ?>"]

New Calendar / Item

This version supports one calendar. Check the upgrade options.

Form Builder Settings & Troubleshoot Area

Important!: Use this area only if you want to activate the form builder or if you are experiencing conflicts with third party plugins, with the theme scripts or with the character encoding.

Form rendering:

* The Visual Form Builder is available in the commercial versions. To edit the form in this basic version you should manually edit the file 'cpabc_scheduler.inc.php'.

Script load method:

* Change the script load method if the form doesn't appear in the public website.

Character encoding:

* Update the charset if you are getting problems displaying special/non-latin characters. After updated you need to edit the special characters again.

iCal timezone difference vs server time:

* Update this, if needed, to match the desired timezone. The difference is calculated referred to the server time. Current server time is

iCal timeslot size in minutes:
" /> minutes
* Update this, if needed, to have a specific slot time in the exported iCal file.

Exclude columns from CSV exported files:
" />
* Names of the columns to be excluded, comma separated.



Customization Area

Use this area to add custom CSS styles or custom scripts. These styles and scripts will be keep safe even after updating the plugin.

     
[Support] | [Documentation]