|
Tammy Hornek
|
September 11, 2014 at 7:42 pm
I am trying to figure out how to give my contractor team access to the guest list of each event. (Minimally, they need to know the number registered) But I would prefer they know the actual names of the registrants so they can check names off the list.
I was thinking I could give them EEMasterAdmin access to my site and they could just login from their cell phones. However, that admin access does not seem to work.
So, then I thought I might create a password protected page and post shortcode data to the page. Is that possible in EE4? I saw some documentation for Registrant shortcode for EE3.
Please advise.
Thank you!
Tammy
|
|
Tony
|
September 12, 2014 at 2:56 am
Hi Tammy,
Currently EE4 does not include a shortcode for this.
However something like this:
add_shortcode('EE_ATTENDEE_LIST', 'ee_attendee_list' );
function ee_attendee_list($atts){
global $wpdb, $post;
$EVT_ID = $atts['eventid'];
$post = get_post( $EVT_ID );
echo '';
$sql = "SELECT ATT_fname, ATT_lname, ATT_email ";
$sql .= "FROM {$wpdb->prefix}esp_attendee_meta ";
$sql .= "INNER JOIN {$wpdb->prefix}esp_registration ";
$sql .= "ON {$wpdb->prefix}esp_attendee_meta.ATT_ID = {$wpdb->prefix}esp_registration.ATT_ID ";
$sql .= "WHERE {$wpdb->prefix}esp_registration.EVT_ID = %d";
$attendees = $wpdb->get_results( $wpdb->prepare( $sql, $post->ID ));
foreach($attendees as $attendee){
$fname = $attendee->ATT_fname;
$lname = $attendee->ATT_lname;
$email = $attendee->ATT_email;
$gravatar = get_avatar( $email, '64', 'identicon' );
$html = '- '. $gravatar .''. $fname .' '. $lname . '
';
echo $html;
}
echo ' ';
return;
}
Within your themes functions.php files or a site specific plugin (recommended) you can then use something like:
[EE_ATTENDEE_LIST eventid=*your event id*]
Within a page to display the attendee list.
|
|
Tammy Hornek
|
September 16, 2014 at 9:07 pm
Any work around on this? I don’t have access to create a site-specific plugin because I don’t have access to the hosting site. (Mr Jason has that) He’s busy and so here I sit… out of luck.
My team need to be informed of the guest list before an event. (This seriously is not saving me time because I’m constantly fielding the question from my team and my party hosts) “How many people are registered?” “Who has registered, so far??
Can you please let me know if there’s a way to send the registration information out in an email?
There HAS to be SOME way to do this!
In fact, I gave my artists access to my website and gave them “EEMasterAdmin” access. Yet, they can see nothing with EE.
Looking forward to a suggestion I can implement ASAP without needing access to the files housed outside of my control.
|
|
Lorenzo Orlando Caum
|
September 17, 2014 at 4:33 am
Hi,
As Tony shared, this is not a current shortcode in Event Espresso 4.
However, the code that he shared will add it to Event Espresso 4.
It can be added to your child theme’s functions.php file or a site specific plugin.
These are the current options that are available.
You won’t be able to use show the registration list in an email as the messages editor currently restricts shortcodes that can be used.
—
Lorenzo
|
