get_results( $sql ) ) {
$sql = "ALTER TABLE `$table` ADD `passcode` VARCHAR(50) NOT NULL DEFAULT '';";
$wpdb->query( $sql );
}
}
/**
* Checks to see if passcode is required for attendees.
*
* @return bool True if a passcode is required, false otherwise.
*/
function rsvp_require_passcode() {
return ( ( get_option( OPTION_RSVP_PASSCODE ) == 'Y' ) || ( get_option( OPTION_RSVP_OPEN_REGISTRATION ) == 'Y' ) || ( get_option( OPTION_RSVP_ONLY_PASSCODE ) == 'Y' ) );
}
/**
* Checks to see if only a passcode is required to RSVP.
*
* @return bool True if only a passcode is needed to RSVP, false otherwise.
*/
function rsvp_require_only_passcode_to_register() {
return ( get_option( OPTION_RSVP_ONLY_PASSCODE ) === 'Y' );
}
/**
* [rsvp_require_unique_passcode description]
*
* @return [type] [description]
*/
function rsvp_require_unique_passcode() {
return rsvp_require_only_passcode_to_register();
}
/**
* [rsvp_is_passcode_unique description]
*
* @param [type] $passcode [description]
* @param [type] $attendee_id [description]
*
* @return [type] [description]
*/
function rsvp_is_passcode_unique( $passcode, $attendee_id ) {
global $wpdb;
$is_unique = false;
$sql = $wpdb->prepare( 'SELECT * FROM ' . ATTENDEES_TABLE . ' WHERE id <> %d AND passcode = %s', $attendee_id, $passcode );
if ( ! $wpdb->get_results( $sql ) ) {
$is_unique = true;
}
return $is_unique;
}
/**
* This generates a random 6 character passcode to be used for guests when the option is enabled.
*/
function rsvp_generate_passcode() {
$length = 6;
$characters = '0123456789abcdefghijklmnopqrstuvwxyz';
$passcode = '';
for ( $p = 0; $p < $length; $p++ ) {
$passcode .= $characters[ mt_rand( 0, strlen( $characters ) ) ];
}
return $passcode;
}
/**
* Gets the file type based on the users uploaded extension.
*
* @param string $file_path The file name that the user uploaded for importing.
*
* @return object Null or the Spout type used for parsing the files.
*/
function rsvp_free_import_get_file_type( $file_path ) {
$ext = strtolower( pathinfo( $file_path, PATHINFO_EXTENSION ) );
if ( 'csv' === $ext ) {
return Type::CSV;
} elseif ( 'xlsx' === $ext ) {
return Type::XLSX;
} elseif ( 'ods' === $ext ) {
return Type::ODS;
}
return null;
}
function rsvp_get_question_with_answer_type_ids() {
global $wpdb;
$ids = array();
$sql = 'SELECT id FROM ' . QUESTION_TYPE_TABLE . "
WHERE questionType IN ('" . QT_MULTI . "', '" . QT_DROP . "', '" . QT_RADIO . "')";
$results = $wpdb->get_results( $sql );
foreach ( $results as $r ) {
$ids[] = (int) $r->id;
}
return $ids;
}
/**
* Populates the custom question types
*
* @since 2.2.8
*/
function rsvp_populate_custom_question_types() {
global $wpdb;
$question_types = array(
array(
'questionType' => 'shortAnswer',
'friendlyName' => 'Short Answer',
),
array(
'questionType' => 'multipleChoice',
'friendlyName' => 'Multiple Choice',
),
array(
'questionType' => 'longAnswer',
'friendlyName' => 'Long Answer',
),
array(
'questionType' => 'dropdown',
'friendlyName' => 'Drop Down',
),
array(
'questionType' => 'radio',
'friendlyName' => 'Radio',
),
);
foreach ( $question_types as $qt ) {
$qType = $wpdb->get_var( $wpdb->prepare( 'SELECT id FROM ' . QUESTION_TYPE_TABLE . ' WHERE questionType = %s ', $qt['questionType'] ) );
if ( $qType == null ) {
$wpdb->insert(
QUESTION_TYPE_TABLE,
array(
'questionType' => $qt['questionType'],
'friendlyName' => $qt['friendlyName'],
),
array( '%s', '%s' )
);
}
}
}
function rsvp_admin_custom_question() {
global $wpdb;
$rsvp_helper = RSVP_Helper::get_instance();
$answerQuestionTypes = rsvp_get_question_with_answer_type_ids();
rsvp_populate_custom_question_types();
if ( ( count( $_POST ) > 0 ) && ! empty( $_POST['question'] ) && is_numeric( $_POST['questionTypeID'] ) ) {
check_admin_referer( 'rsvp_add_custom_question' );
if ( isset( $_POST['questionId'] ) && is_numeric( $_POST['questionId'] ) && ( $_POST['questionId'] > 0 ) ) {
$wpdb->update(
QUESTIONS_TABLE,
array(
'question' => sanitize_text_field( wp_unslash( $_POST['question'] ) ),
'questionTypeID' => absint( $_POST['questionTypeID'] ),
'permissionLevel' => ( ( sanitize_text_field( wp_unslash( $_POST['permissionLevel'] ) ) == 'private' ) ? 'private' : 'public' ),
),
array( 'id' => absint( $_POST['questionId'] ) ),
array( '%s', '%d', '%s' ),
array( '%d' )
);
$questionId = absint( $_POST['questionId'] );
$answers = $wpdb->get_results( $wpdb->prepare( 'SELECT id FROM ' . QUESTION_ANSWERS_TABLE . ' WHERE questionID = %d', absint( $questionId ) ) );
if ( count( $answers ) > 0 ) {
foreach ( $answers as $a ) {
if ( isset( $_POST[ 'deleteAnswer' . $a->id ] ) && ( strToUpper( sanitize_text_field( wp_unslash( $_POST[ 'deleteAnswer' . $a->id ] ) ) ) == 'Y' ) ) {
$wpdb->query( $wpdb->prepare( 'DELETE FROM ' . QUESTION_ANSWERS_TABLE . ' WHERE id = %d', $a->id ) );
} elseif ( isset( $_POST[ 'answer' . $a->id ] ) && ! empty( $_POST[ 'answer' . $a->id ] ) ) {
$wpdb->update(
QUESTION_ANSWERS_TABLE,
array( 'answer' => sanitize_text_field( wp_unslash( $_POST[ 'answer' . $a->id ] ) ) ),
array( 'id' => absint( $a->id ) ),
array( '%s' ),
array( '%d' )
);
}
}
}
} else {
$wpdb->insert(
QUESTIONS_TABLE,
array(
'question' => sanitize_text_field( wp_unslash( ( $_POST['question'] ) ) ),
'questionTypeID' => absint( $_POST['questionTypeID'] ),
'permissionLevel' => ( ( sanitize_text_field( wp_unslash( ( $_POST['permissionLevel'] ) ) == 'private' ) ? 'private' : 'public' ) ),
),
array( '%s', '%d', '%s' )
);
$questionId = $wpdb->insert_id;
}
if ( isset( $_POST['numNewAnswers'] ) && is_numeric( $_POST['numNewAnswers'] ) &&
in_array( absint( $_POST['questionTypeID'] ), $answerQuestionTypes ) ) {
for ( $i = 0; $i < absint( $_POST['numNewAnswers'] ); $i++ ) {
if ( isset( $_POST[ 'newAnswer' . $i ] ) && ! empty( $_POST[ 'newAnswer' . $i ] ) ) {
$wpdb->insert(
QUESTION_ANSWERS_TABLE,
array(
'questionID' => absint( $questionId ),
'answer' => sanitize_text_field( wp_unslash( $_POST[ 'newAnswer' . $i ] ) ),
)
);
}
}
}
if ( strToLower( sanitize_text_field( wp_unslash( $_POST['permissionLevel'] ) ) ) == 'private' ) {
$wpdb->query( $wpdb->prepare( 'DELETE FROM ' . QUESTION_ATTENDEES_TABLE . ' WHERE questionID = %d', absint( $questionId ) ) );
if ( isset( $_POST['attendees'] ) && is_array( $_POST['attendees'] ) ) {
foreach ( array_map( 'sanitize_text_field', array_map( 'wp_unslash', $_POST['attendees'] ) ) as $aid ) {
if ( is_numeric( $aid ) && ( $aid > 0 ) ) {
$wpdb->insert(
QUESTION_ATTENDEES_TABLE,
array(
'attendeeID' => absint( $aid ),
'questionID' => absint( $questionId ),
),
array( '%d', '%d' )
);
}
}
}
}
?>
get_results( $wpdb->prepare( 'SELECT id, question, questionTypeID, permissionLevel FROM ' . QUESTIONS_TABLE . ' WHERE id = %d', absint( $_GET['id'] ) ) );
if ( count( $qRs ) > 0 ) {
$isNew = false;
$questionId = absint( $qRs[0]->id );
$question = stripslashes( $qRs[0]->question );
$permissionLevel = stripslashes( $qRs[0]->permissionLevel );
$questionTypeId = absint( $qRs[0]->questionTypeID );
if ( $permissionLevel == 'private' ) {
$aRs = $wpdb->get_results( $wpdb->prepare( 'SELECT attendeeID FROM ' . QUESTION_ATTENDEES_TABLE . ' WHERE questionID = %d', $questionId ) );
if ( count( $aRs ) > 0 ) {
foreach ( $aRs as $a ) {
$savedAttendees[] = $a->attendeeID;
}
}
}
}
}
$sql = 'SELECT id, questionType, friendlyName FROM ' . QUESTION_TYPE_TABLE;
$questionTypes = $wpdb->get_results( $sql );
?>
wp_create_nonce( 'rsvp_admin_script' ),
'ajaxurl' => admin_url( 'admin-ajax.php' ),
)
);
}
/**
* Function for loading the needed assets for the plugin.
*/
function rsvp_init() {
require_once 'external-libs/wp-simple-nonce/wp-simple-nonce.php';
require_once __DIR__ . '/includes/rsvp_frontend.inc.php';
if ( is_admin() ) {
require_once __DIR__ . '/includes/class-rsvp-review.php';
require_once 'includes/class-rsvp-admin.php';
require_once 'includes/class-rsvp-list-table.php';
require_once 'includes/class-rsvp-events-list-table.php';
require_once 'includes/class-rsvp-attendees-list-table.php';
require_once 'includes/class-rsvp-questions-list-table.php';
require_once 'includes/class-rsvp-helper.php';
require_once 'includes/class-rsvp-upsells.php';
if ( apply_filters( 'rsvp_show_upsells', true ) ) {
RSVP_Upsells::get_instance();
}
}
$result = load_plugin_textdomain( 'rsvp', false, basename( __DIR__ ) . '/languages/' );
}
/**
* Handles converting text encodings for characters like umlauts that might be stored in different encodings
*
* @param string $text The text we wish to handle the encoding against
*
* @return string The converted text
*/
function rsvp_handle_text_encoding( $text ) {
if ( function_exists( 'mb_convert_encoding' ) && function_exists( 'mb_detect_encoding' ) ) {
return mb_convert_encoding( $text, 'UTF-8', mb_detect_encoding( $text, 'UTF-8, ISO-8859-1', true ) );
}
return $text;
}
function rsvp_free_is_addslashes_enabled() {
return get_magic_quotes_gpc();
}
function rsvp_getCurrentPageURL() {
global $wp;
global $wp_rewrite;
$pageURL = home_url( $wp->request );
$pageURL = trailingslashit( $pageURL );
if ( $wp_rewrite->using_index_permalinks() && ( strpos( $pageURL, 'index.php' ) === false ) ) {
$parts = parse_url( $pageURL );
$pageURL = $parts['scheme'] . '://' . $parts['host'];
if ( isset( $parts['port'] ) ) {
$pageURL .= ':' . $parts['port'];
}
$pageURL .= '/index.php' . $parts['path'];
if ( isset( $parts['query'] ) && ( $parts['query'] != '' ) ) {
$pageURL .= '?' . $parts['query'];
}
} elseif ( empty( $wp_rewrite->permalink_structure ) ) {
$pageURL = get_permalink();
}
if ( get_option( OPTION_RSVP_DONT_USE_HASH ) != 'Y' ) {
$pageURL .= '#rsvpArea';
}
return $pageURL;
}
function rsvp_hide_untill_loaded() {
echo '';
}
function rsvp_add_css() {
$css = get_option( RSVP_OPTION_CSS_STYLING );
if ( ! empty( $css ) ) {
echo '
';
}
}
function rsvp_front_scripts() {
wp_register_script( 'jquery_validate', plugins_url( 'assets/js/jquery.validate.min.js', RSVP_PLUGIN_FILE ), array( 'jquery' ) );
wp_register_script( 'rsvp_plugin', plugins_url( 'assets/js/rsvp_plugin.js', RSVP_PLUGIN_FILE ), array( 'jquery' ) );
wp_localize_script(
'rsvp_plugin',
'rsvp_plugin_vars',
array(
'askEmail' => __( 'Please enter an email address that we can use to contact you about the extra guest. We have to keep a pretty close eye on the number of attendees. Thanks!', 'rsvp' ),
'customNote' => __( 'If you are adding additional RSVPs please enter your email address in case we have questions', 'rsvp' ),
'newAttending1LastName' => __( 'Please enter a last name', 'rsvp' ),
'newAttending1FirstName' => __( 'Please enter a first name', 'rsvp' ),
'newAttending2LastName' => __( 'Please enter a last name', 'rsvp' ),
'newAttending2FirstName' => __( 'Please enter a first name', 'rsvp' ),
'newAttending3LastName' => __( 'Please enter a last name', 'rsvp' ),
'newAttending3FirstName' => __( 'Please enter a first name', 'rsvp' ),
'attendeeFirstName' => __( 'Please enter a first name', 'rsvp' ),
'attendeeLastName' => __( 'Please enter a last name', 'rsvp' ),
'firstName' => __( 'Please enter your first name', 'rsvp' ),
'lastName' => __( 'Please enter your last name', 'rsvp' ),
'passcode' => __( 'Please enter your password', 'rsvp' ),
)
);
wp_register_style( 'rsvp_css', plugins_url( 'assets/css/rsvp_plugin.css', RSVP_PLUGIN_FILE ) );
wp_enqueue_script( 'jquery' );
wp_enqueue_script( 'jquery_validate' );
wp_enqueue_script( 'rsvp_plugin' );
wp_enqueue_style( 'rsvp_css' );
}
function rsvp_add_privacy_policy_content() {
if ( ! function_exists( 'wp_add_privacy_policy_content' ) ) {
return;
}
$content = __(
'All information entered either from an attendee or a WordPress admin for the RSVP
plugin is never sent to external sites. The data stays in database tables
on the WordPress instance.',
'rsvp'
);
wp_add_privacy_policy_content(
'RSVP Plugin',
wp_kses_post( wpautop( $content, false ) )
);
}
/**
* Handles the data erasing for a given email address.
*
* @param string $email_address The email address we want to delete from the attendees table.
* @param integer $page The page we are on.
*
* @return array An array containing how many attendees were deleted.
*/
function rsvp_data_eraser_handler( $email_address, $page = 1 ) {
global $wpdb;
$rsvp_helper = RSVP_Helper::get_instance();
$num_deleted = 0;
$sql = 'SELECT id FROM ' . ATTENDEES_TABLE . ' WHERE email = %s';
$attendees = $wpdb->get_results( $wpdb->prepare( $sql, $email_address ) );
foreach ( $attendees as $a ) {
$rsvp_helper->delete_attendee( $a->id );
++$num_deleted;
}
return array(
'items_removed' => $num_deleted,
'items_retained' => false, // We never retain items.
'messages' => array( __( 'RSVP Data Erased Successfully', 'rsvp' ) ),
'done' => true,
);
}
/**
* The data eraser registration that lets the core of WP know
* we can handle erasing of the RSVP Plugin information
* if it is ever requested.
*
* @param array $erasers The array of erasers already registered with this WP instance.
*
* @return array The erasers array now with the RSVP eraser added.
*/
function rsvp_register_data_eraser( $erasers ) {
$erasers['rsvp-plugin'] = array(
'eraser_friendly_name' => __( 'RSVP Plugin', 'rsvp' ),
'callback' => 'rsvp_data_eraser_handler',
);
return $erasers;
}
/**
* Retrieves and packages up the exporter information for the new WordPress compliance functionality
*
* @param string $email_address The email address we need to export the information for.
* @param integer $page The current page.
*
* @return array Containing the information and if everything is done being exported.
*/
function rsvp_data_exporter_handler( $email_address, $page = 1 ) {
global $wpdb;
$export_items = array();
$sql = 'SELECT a.id, a.firstName, a.lastName, a.rsvpDate,
a.rsvpStatus, a.note, a.additionalAttendee, a.kidsMeal,
a.veggieMeal, a.personalGreeting
FROM ' . ATTENDEES_TABLE . ' a
WHERE email = %s';
$attendees = $wpdb->get_results( $wpdb->prepare( $sql, $email_address ) );
foreach ( $attendees as $a ) {
$export_items['firstName'] = stripslashes( $a->firstName );
$export_items['lastName'] = stripslashes( $a->lastName );
$export_items['rsvpDate'] = $a->rsvpDate;
$export_items['rsvpStatus'] = stripslashes( $a->rsvpStatus );
$export_items['note'] = stripslashes( $a->note );
$export_items['additionalAttendee'] = stripslashes( $a->additionalAttendee );
$export_items['personalGreeting'] = stripslashes( $a->personalGreeting );
$export_items['veggieMeal'] = stripslashes( $a->veggieMeal );
$export_items['kidsMeal'] = stripslashes( $a->kidsMeal );
// Print out the custom question information for the main event.
$export_items = rsvp_data_exporter_custom_questions( $a->id, $export_items );
}
return array(
'data' => $export_items,
'done' => true,
);
}
/**
* Retrieves the custom question and answers for export
*
* @param integer $attendee_id The attendee we want to get the answers for.
* @param array $export_items The current exported items that we need to add to.
*
* @return array The export items with the custom questions added for the event passed in.
*/
function rsvp_data_exporter_custom_questions( $attendee_id, $export_items ) {
global $wpdb;
$sql = 'SELECT answer, question FROM ' . ATTENDEE_ANSWERS . ' aa
JOIN ' . QUESTIONS_TABLE . ' q ON q.id = aa.questionID
WHERE aa.attendeeID = %d';
$custom_questions = $wpdb->get_results( $wpdb->prepare( $sql, $attendee_id ) );
foreach ( $custom_questions as $cq ) {
$export_items[ stripslashes( $cq->question ) ] = stripslashes( $cq->answer );
}
return $export_items;
}
/**
* Replace a smart quote with an actual single-quote so that people can
* find themselves when they do a search on the front-end.
*
* @param string $in The string we want to replace smart-quotes with single-quotes.
*
* @return string The string that has had the values replaced.
*/
function rsvp_smart_quote_replace( $in ) {
return str_replace( '’', '\'', $in );
}
/**
* Registers the RSVP data exporter to WP core
*
* @param array $exporters The current array of exporters registered with this WP instance.
*
* @return array The exporters array now with the RSVP exporter added.
*/
function rsvp_register_data_exporter( $exporters ) {
$exporters['rsvp-plugin'] = array(
'exporter_friendly_name' => __( 'RSVP Plugin', 'rsvp' ),
'callback' => 'rsvp_data_exporter_handler',
);
return $exporters;
}
/**
* RSVP shortcode handler
*
* @param array $atts The array of attributes for this shortcode.
*
* @return string The output of the page.
*/
function rsvpshortcode_func( $atts ) {
return rsvp_frontend_handler( 'rsvp-pluginhere ' );
}
add_shortcode( 'rsvp', 'rsvpshortcode_func' );
add_action( 'admin_init', 'rsvp_add_privacy_policy_content' );
add_filter( 'wp_privacy_personal_data_erasers', 'rsvp_register_data_eraser', 10 );
add_filter( 'wp_privacy_personal_data_exporters', 'rsvp_register_data_exporter', 10 );
add_action( 'init', 'rsvp_init' );
add_action( 'wp_head', 'rsvp_hide_untill_loaded' );
add_filter( 'the_content', 'rsvp_frontend_handler' );
register_activation_hook( __FILE__, 'rsvp_database_setup' );