Support

November 27, 2013 at 7:19 am

Thank you Dean for such a prompt response.

I’m sorry for my ignorance in php matters, but

1. Where is exactly located the custom_functions.php file? Or should I create it? (and in this case where should I place it)?

2. If a wish to add a new sentence like “This is an automated message. Please do not reply”, is is right to add:

$body .= sprintf __(‘This is an automated message. Please do not reply’, ‘event_espresso’ );
$body .= ‘<br/>’;

Thank you in advance for your help.

B D

November 27, 2013 at 10:56 am

Thank you for the explanation. I’ll add the code in the functions.php file.

However, I would like to ask what is the exact code to add? (that is, from which line to which line of the event-espresso/includes/functions/email.php?)

Thank you again for your kind help.

November 29, 2013 at 4:04 am

Thank you for your reply.

No, I haven’t modified the event_espresso_send_email() function in the email.php. (I have not copied it in the custom_functions.php file either).(If needed, I send you this function’s code so that you can check.)

One point which may be useful: The strings that are translated in the .po/.mo files show the proper French accents/diacritics in the email. It is only the strings that I add directly to this email template in the custom_functions.php file that don’t show up properly.

November 29, 2013 at 6:25 am

Thank you for your patience.

1. I paste hereafter the code I used in custom_functions.php

2. I had already thought about adding the phrases in English and translate them. However, I encounter the following problem: the French translation (the “official” .mo file I downloaded from your server) is not finished and various mistakes are to be corrected. To do so, I created my own .mo/.po files in the wp-content/uploads/espresso/languages file, so that my translations/correction will not be overwritten when updating.

Now, if I add English strings to my email, they will appear in the original .mo/.po file, thus they will not be visible and thus translatable in my customized .mo/.po files in the uploads file. How to import strings from the original .mo file to the modified .mo file? If I’m not mistaken, I cannot do this with Poedit.

And now the code:

<?php

if (!function_exists(‘event_espresso_send_attendee_registration_approval_pending’)) {

function event_espresso_send_attendee_registration_approval_pending($registration_id) {
global $org_options, $wpdb;
do_action(‘action_hook_espresso_log’, __FILE__, __FUNCTION__, ”);
//Get the event information
$events = $wpdb->get_results(“SELECT ed.* FROM ” . EVENTS_DETAIL_TABLE . ” ed
JOIN ” . EVENTS_ATTENDEE_TABLE . ” ea
ON ed.id = ea.event_id
WHERE ea.registration_id='” . $registration_id . “‘”);

foreach ($events as $event) {
$event_id = $event->id;
$event_name = stripslashes_deep($event->event_name);
$event_desc = stripslashes_deep($event->event_desc);
$display_desc = $event->display_desc;
$event_identifier = $event->event_identifier;
$reg_limit = $event->reg_limit;
$active = $event->is_active;
$send_mail = $event->send_mail;
$conf_mail = $event->conf_mail;
$email_id = $event->email_id;
$alt_email = $event->alt_email;
$start_date = event_date_display($event->start_date);
$end_date = $event->end_date;
$virtual_url = $event->virtual_url;
$virtual_phone = $event->virtual_phone;
$event_address = $event->address;
$event_address2 = $event->address2;
$event_city = $event->city;
$event_state = $event->state;
$event_zip = $event->zip;
$event_country = $event->country;
$location = ($event_address != ” ? $event_address : ”) . ($event_address2 != ” ? ‘<br />’ . $event_address2 : ”) . ($event_city != ” ? ‘<br />’ . $event_city : ”) . ($event_state != ” ? ‘, ‘ . $event_state : ”) . ($event_zip != ” ? ‘<br />’ . $event_zip : ”) . ($event_country != ” ? ‘<br />’ . $event_country : ”);
$location_phone = $event->phone;
$require_pre_approval = $event->require_pre_approval;

$google_map_link = espresso_google_map_link(array(‘address’ => $event_address, ‘city’ => $event_city, ‘state’ => $event_state, ‘zip’ => $event_zip, ‘country’ => $event_country));
}

//Build links
$event_url = espresso_reg_url($event_id);
$event_link = ‘< a href="' . $event_url . '">‘ . $event_name . ‘‘;

$sql = “SELECT * FROM ” . EVENTS_ATTENDEE_TABLE;

if ($registration_id != ”) {
$sql .= ” WHERE registration_id = ‘” . $registration_id . “‘ “;
} elseif ($attendee_id != ”) {
$sql .= ” WHERE id = ‘” . $attendee_id . “‘ “;
} else {
_e(‘No ID Supplied’, ‘event_espresso’);
}

$sql .= ” ORDER BY id “;
$sql .= ” LIMIT 0,1 “; //Get the first attendees details

$attendees = $wpdb->get_results($sql);
//global $attendee_id;

foreach ($attendees as $attendee) {
$attendee_id = $attendee->id;
$attendee_email = $attendee->email;
$lname = $attendee->lname;
$fname = $attendee->fname;
$address = $attendee->address;
$address2 = $attendee->address2;
$city = $attendee->city;
$state = $attendee->state;
$zip = $attendee->zip;
$payment_status = $attendee->payment_status;
$txn_type = $attendee->txn_type;
$amount_pd = $attendee->amount_pd;
$event_cost = $attendee->amount_pd;
$payment_date = event_date_display($attendee->payment_date);
$phone = $attendee->phone;
$event_time = event_date_display($attendee->event_time, get_option(‘time_format’));
$end_time = event_date_display($attendee->end_time, get_option(‘time_format’));
$date = event_date_display($attendee->date);
$pre_approve = $attendee->pre_approve;
}
$admin_email = $alt_email == ” ? $org_options[‘contact_email’] : $alt_email . ‘,’ . $org_options[‘contact_email’];
if (!empty($admin_email)) {
$subject = __(‘New attendee registration approval pending’,’event_espresso’);
$body = sprintf( __(‘Event title: %s’, ‘event_espresso’), $event_name );
$body .= ‘<br/>’;
$body .= sprintf( __(‘Attendee name: %1$s %2$s’, ‘event_espresso’), $fname, $lname );
$body .= ‘<br/>’;
$body .= __(‘Thank You.’, ‘event_espresso’);
$email_params = array(
‘send_to’ => $admin_email,
’email_subject’ => __($subject, ‘event_espresso’),
’email_body’ => $body
);
event_espresso_send_email($email_params);
}

if (!empty($attendee_email)) {
$subject = __(‘Event registration pending’,’event_espresso’);
$body .= ‘***Ceci est un message automatique. Veuillez ne pas y répondre***’;
$body = sprintf( __(‘Event title: %s’, ‘event_espresso’), $event_name );
$body .= ‘<br/>’;
$body .= sprintf( __(‘Attendee name: %1$s %2$s’, ‘event_espresso’), $fname, $lname );
$body .= ‘<br/>’;
$body .= __(‘Your registration is pending for approval from event admin. You will receive an email with payment info when admin approves your registration.’, ‘event_espresso’);
$body .= ‘<br/><br/>’;
$body .= ‘Nous vous remercions pour votre intérêt’;
$email_params = array(
‘send_to’ => $attendee_email,
’email_subject’ => __($subject, ‘event_espresso’),
’email_body’ => $body
);
event_espresso_send_email($email_params);
}
}

}

November 29, 2013 at 6:52 am

Thank you.

The result is the same…

I’m wondering if exploring the second point in my above message (how to transfer strings from the original to the customized .mo/.po files) would not offer a simpler solution, insofar as translated strings show properly in French in email.

December 2, 2013 at 3:29 pm

Hi Josh,

I suppose you’re referring to the following lines:

if ( ! in_array( get_option( ‘blog_charset’ ), array( ‘utf8’, ‘utf-8’, ‘UTF8’, ‘UTF-8’ ) ) )
$whitelist_options[‘reading’][] = ‘blog_charset’;

The language of my WP is French.

B D

December 3, 2013 at 1:49 am

The two lines above contain the only occurences of “blog_charset” in my options.php file.

Shall I send a copy of the whole options.php code here?

December 3, 2013 at 2:48 am

Hi Dean

I can only see the options.php as a text file, so I cannot see the right side fields as in your screen copy. How should I open my options.php file so that I can see the value fields?

December 3, 2013 at 3:42 am

Sorry, I went to the options.php file through ftp.

I confirm that the value of blog_charset is UTF-8.

(My WP’s language is French).

December 5, 2013 at 8:26 am

Thank you very much for this clear explanation and for your help.

I have tested and encounter the following problems:

1. I have placed a text line (as $body = __(‘my text’, ‘event_espresso’);) in the email’s body before the event’s name (that’s where I need it), that is, before the php line $body = sprintf( __(‘Event title: %s’, ‘event_espresso’), $event_name ). Although it figures correctly in the .po file and I can see it translated in Poedit, this line does not show at all in the email message.

2. For some reason, the last line of the message only shows up in English in the email message, although it is correctly translated in French and the custom_functions.php line is properly indicated in the .po file.

Thank you again for your kind help.

December 5, 2013 at 9:55 am

Thank you. The second point is solved.

And my last question: you advise to remove the strong tags from the .po and place them around the string within custom_functions. Where should I place exactly the strong tags outside the string (which is the first line of the email message)?

December 6, 2013 at 8:59 am

Thank you Josh. That’s what I did for the time being.

However, I need this string emphasized in the email message. But not being a php coder, I’m wondering where to place the tags around this string.

December 6, 2013 at 9:45 am

Thank you so much Tony for your patient help and clear explanations along this long thread. It’s working fine now.

If EE is to become a global success, translation issues (and multilingual sites issues) will need to be addressed so that to make life easier to non-coders…

Thank you again.

B D