Gayatriom,
I also have this issue, so I don’t think your formatting is an issue.
I resolved the issue by making the following changes to rsvp_frontend.inc.php:
Replace lines 197-201 with:
$sql = "SELECT id, firstName, lastName FROM ".ATTENDEES_TABLE."
WHERE (
id IN (SELECT attendeeID FROM ".ASSOCIATED_ATTENDEES_TABLE." WHERE associatedAttendeeID = %d)
OR id IN (SELECT associatedAttendeeID FROM ".ASSOCIATED_ATTENDEES_TABLE." WHERE attendeeID = %d)
OR id IN (SELECT associatedAttendeeID FROM ".ASSOCIATED_ATTENDEES_TABLE." WHERE attendeeID IN (SELECT associatedAttendeeID FROM ".ASSOCIATED_ATTENDEES_TABLE." WHERE attendeeID = %d))
)
AND id <> %d
AND rsvpStatus <> 'NoResponse'";
$associations = $wpdb->get_results($wpdb->prepare($sql, $attendeeID, $attendeeID,$attendeeID, $attendeeID ));
and replace lines 212-217 with:
$sql = "SELECT id, firstName, lastName personalGreeting FROM ".ATTENDEES_TABLE."
WHERE (
id IN (SELECT attendeeID FROM ".ASSOCIATED_ATTENDEES_TABLE." WHERE associatedAttendeeID = %d)
OR id IN (SELECT associatedAttendeeID FROM ".ASSOCIATED_ATTENDEES_TABLE." WHERE attendeeID = %d)
OR id IN (SELECT associatedAttendeeID FROM ".ASSOCIATED_ATTENDEES_TABLE." WHERE attendeeID IN (SELECT associatedAttendeeID FROM ".ASSOCIATED_ATTENDEES_TABLE." WHERE attendeeID = %d))
)
AND id <> %d
AND rsvpStatus = 'NoResponse'";
$associations = $wpdb->get_results($wpdb->prepare($sql, $attendeeID, $attendeeID,$attendeeID, $attendeeID ));
oh man we did this manually since the wedding is SO close! thanks though! will use this for another client.
I have a mirror of the project on GitHub that I keep my changes in: https://github.com/fergbrain/mirror-rsvp
@fergbrain,
Thanks for these code snippets!
When I use them, though, it’s doing something funny with the Last name of the Associated Attendees. It’s inserting it below the “Will you be attending?” question, instead of next to their first name.
Take a look, if you wouldn’t mind.
Visit http://www.carrieandkristaps.com/rsvp and enter Suzanne DiFurio as the guest
Any thoughts?
Thanks.
