' .esc_html__( 'LITE vs Premium', 'rsvp' ) . '',
'publish_posts',
'rsvp-upgrade-to-pro',
array( $this, 'rsvp_lite_vs_premium' )
);
add_action( 'admin_print_scripts-' . $page, 'rsvp_admin_scripts' );
}
/**
* Events page
*
* @since 2.7.2
*/
public function rsvp_admin_events() {
if ( get_option( 'rsvp_db_version' ) != RSVP_DB_VERSION ) {
rsvp_database_setup();
}
rsvp_install_passcode_field();
?>
display();
do_action( 'rsvp_events_after_table' );
?>
views();
$views_table->display();
?>
' . esc_html__( 'Add guest', 'rsvp' ) . '
';
if ( ( count( $_POST ) > 0 ) && ! empty( $_POST['firstName'] ) && ! empty( $_POST['lastName'] ) ) {
check_admin_referer( 'rsvp_add_guest' );
$passcode = ( isset( $_POST['passcode'] ) ) ? sanitize_text_field( wp_unslash( $_POST['passcode'] ) ) : '';
if ( isset( $_POST['attendeeId'] ) && is_numeric( $_POST['attendeeId'] ) && ( $_POST['attendeeId'] > 0 ) ) {
$wpdb->update(
ATTENDEES_TABLE,
array(
'firstName' => ( isset( $_POST['firstName'] ) ) ? rsvp_smart_quote_replace( sanitize_text_field( wp_unslash( $_POST['firstName'] ) ) ) : '',
'lastName' => ( isset( $_POST['lastName'] ) ) ? rsvp_smart_quote_replace( sanitize_text_field( wp_unslash( $_POST['lastName'] ) ) ) : '',
'email' => ( isset( $_POST['email'] ) ) ? sanitize_email( wp_unslash( $_POST['email'] ) ) : '',
'personalGreeting' => ( isset( $_POST['personalGreeting'] ) ) ? sanitize_text_field( wp_unslash( $_POST['personalGreeting'] ) ) : '',
'rsvpStatus' => ( isset( $_POST['rsvpStatus'] ) ) ? sanitize_text_field( wp_unslash( $_POST['rsvpStatus'] ) ) : '',
),
array( 'id' => absint( $_POST['attendeeId'] ) ),
array( '%s', '%s', '%s', '%s', '%s' ),
array( '%d' )
);
$attendeeId = absint( $_POST['attendeeId'] );
$wpdb->query( $wpdb->prepare( 'DELETE FROM ' . ASSOCIATED_ATTENDEES_TABLE . ' WHERE attendeeId = %d', $attendeeId ) );
$wpdb->query( $wpdb->prepare( 'DELETE FROM ' . ASSOCIATED_ATTENDEES_TABLE . ' WHERE associatedAttendeeID = %d', $attendeeId ) );
} else {
$wpdb->insert(
ATTENDEES_TABLE,
array(
'firstName' => ( isset( $_POST['firstName'] ) ) ? rsvp_smart_quote_replace( sanitize_text_field( wp_unslash( $_POST['firstName'] ) ) ) : '',
'lastName' => ( isset( $_POST['lastName'] ) ) ? rsvp_smart_quote_replace( sanitize_text_field( wp_unslash( $_POST['lastName'] ) ) ): '',
'email' => ( isset( $_POST['email'] ) ) ? sanitize_email( wp_unslash( $_POST['email'] ) ) : '',
'personalGreeting' => ( isset( $_POST['pesonalGreeting'] ) ) ? sanitize_text_field( wp_unslash( $_POST['personalGreeting'] ) ) : '',
'rsvpStatus' => ( isset( $_POST['rsvpStatus'] ) ) ? sanitize_text_field( wp_unslash( $_POST['rsvpStatus'] ) ) : '',
),
array( '%s', '%s', '%s', '%s', '%s' )
);
$attendeeId = $wpdb->insert_id;
}
if ( isset( $_POST['associatedAttendees'] ) && is_array( $_POST['associatedAttendees'] ) ) {
foreach ( array_map( 'sanitize_text_field', array_map( 'wp_unslash', $_POST['associatedAttendees'] ) ) as $aid ) { //phpcs:ignore
if ( is_numeric( $aid ) && ( $aid > 0 ) ) {
$wpdb->insert(
ASSOCIATED_ATTENDEES_TABLE,
array(
'attendeeID' => absint( $attendeeId ),
'associatedAttendeeID' => absint( $aid ),
),
array( '%d', '%d' )
);
$wpdb->insert(
ASSOCIATED_ATTENDEES_TABLE,
array(
'attendeeID' => absint( $aid ),
'associatedAttendeeID' => absint( $attendeeId ),
),
array( '%d', '%d' )
);
}
}
}
if ( rsvp_require_passcode() ) {
if ( empty( $passcode ) ) {
$passcode = rsvp_generate_passcode();
}
if ( rsvp_require_unique_passcode() && ! rsvp_is_passcode_unique( $passcode, $attendeeId ) ) {
$passcode = rsvp_generate_passcode();
}
$wpdb->update(
ATTENDEES_TABLE,
array( 'passcode' => sanitize_text_field( $passcode ) ),
array( 'id' => $attendeeId ),
array( '%s' ),
array( '%d' )
);
}
?>
get_row( 'SELECT id, firstName, lastName, email, personalGreeting, rsvpStatus, passcode FROM ' . ATTENDEES_TABLE . ' WHERE id = ' . absint( $_GET['id'] ) );
if ( $attendee != null ) {
$attendeeId = $attendee->id;
$firstName = stripslashes( $attendee->firstName );
$lastName = stripslashes( $attendee->lastName );
$email = stripslashes( $attendee->email );
$personalGreeting = stripslashes( $attendee->personalGreeting );
$rsvpStatus = $attendee->rsvpStatus;
$passcode = stripslashes( $attendee->passcode );
// Get the associated attendees and add them to an array
$associations = $wpdb->get_results(
'SELECT associatedAttendeeID FROM ' . ASSOCIATED_ATTENDEES_TABLE . ' WHERE attendeeId = ' . absint( $attendee->id ) .
' UNION ' .
'SELECT attendeeID FROM ' . ASSOCIATED_ATTENDEES_TABLE . ' WHERE associatedAttendeeID = ' . absint( $attendee->id )
);
foreach ( $associations as $aId ) {
$associatedAttendees[] = $aId->associatedAttendeeID;
}
}
}
?>
'; // .wrap class div end
}
/**
* Questions page
*
* @since 2.7.2
*/
public function rsvp_admin_questions() {
global $wpdb;
$rsvp_helper = RSVP_Helper::get_instance();
if ( isset( $_GET['action'] ) && ( 'add' === strtolower( sanitize_text_field( wp_unslash( $_GET['action'] ) ) ) ) ) {
rsvp_admin_custom_question();
return;
}
?>
display();
do_action( 'rsvp_after_question_table' );
?>
'' AND (SELECT COUNT(*) FROM " . ATTENDEES_TABLE . ' WHERE passcode = a.passcode) > 1';
$attendees = $wpdb->get_results( $sql );
foreach ( $attendees as $a ) {
$wpdb->update(
ATTENDEES_TABLE,
array( 'passcode' => rsvp_generate_passcode() ),
array( 'id' => $a->id ),
array( '%s' ),
array( '%d' )
);
}
}
if ( rsvp_require_passcode() ) {
rsvp_install_passcode_field();
$sql = 'SELECT id, passcode FROM ' . ATTENDEES_TABLE . " WHERE passcode = ''";
$attendees = $wpdb->get_results( $sql );
foreach ( $attendees as $a ) {
$wpdb->update(
ATTENDEES_TABLE,
array( 'passcode' => rsvp_generate_passcode() ),
array( 'id' => $a->id ),
array( '%s' ),
array( '%d' )
);
}
}
?>
base, $rsvp_pages, true ) ) {
wp_enqueue_style( 'rsvp-admin-style', plugins_url( 'assets/admin/css/rsvp_admin.css', RSVP_PLUGIN_FILE ) );
}
}
}
RSVP_Admin::get_instance();
}