Support

March 4, 2015 at 3:34 am

Hi,

anybody had a chance to look into this?

Many thanks!

March 4, 2015 at 4:11 am

Thanks for the suggestion. Just to confirm, I’m not using Multiple Event Registration.

I still have one question. Because all the events are members-only, I’m also heavily relying on the event_member_rel, where every user_id is assigned to the event where they are registered to. If I simply fill the form with some details, no matter what I put there, the registration will be assigned to the user_id that is on the page at the moment (which in out case would probably be the company account, rather than the single engineer). Is there a way to pass the correct user_id as well to make sure that the correct relationship is then created?

March 5, 2015 at 5:30 am

Hi Tony,

thanks for the tip. I’ve made few changes and I think I’m almost there, but not quite.

Here is how I’ve modified the user_vars.php [the top section]:

global $current_user;
global $user_email;
wp_get_current_user();

$userid = $current_user->ID;

$new_user_id = $_POST[eng_id]; //This value is posted from the registration page

if($new_user_id <> $userid)
{
$userid = $new_user_id;
$user_info = get_userdata($userid);
$um_fname = $user_info->first_name;
$um_lname = $user_info->last_name;
$um_email = $user_info->user_email;
}
else
{
$userid = $userid;
$um_fname = $current_user->first_name;
$um_lname = $current_user->last_name;
$um_email = $user_email;
}

The code above has the following result: the booking is successful and gets assigned to the correct new $userid, but no other information is pulled, meaning that the booking is blank, with no first name, last name and email.

On the registration form I’ve made the following changes:

////// CUSTOM RADIO BOOKING FORM ////////

global $current_user;
get_currentuserinfo();
$eng_id=$current_user->ID;
$account_type = get_user_field(‘account_type’, $eng_id);

if($account_type == ‘company’)

{

echo “<i>(You can only register <b><u>ONE</u></b> engineer for every form. If the list is empty, you need to add engineers in your company <u><b> by clicking HERE</b></u>)</i></br></br>”;

$newcon=mysqli_connect(“localhost”,”username”,”pass”,”db”);
// Check connection
if (mysqli_connect_errno())
{
echo “Failed to connect to MySQL: ” . mysqli_connect_error();
}

$retrieve_eng = mysqli_query($newcon,”SELECT a.display_name, a.id FROM cm_users AS a, company_engineer AS b WHERE a.id=b.engineer_wp_id AND b.company_wp_id=’$eng_id'”);

while($row = mysqli_fetch_array($retrieve_eng))

{
echo “<label style=’font-size:20px’><input type=’radio’ name=’eng_id’ value='” . $row[id] . “‘>  ” . $row[display_name] . “</label>”;
}

}

////////// END OF CUSTOM RADIO BUTTONS //////////

else
{

echo event_espresso_add_question_groups( $question_groups, ”, NULL, FALSE, array( ‘attendee_number’ => 1 ), ‘ee-reg-page-questions’ );

}

The code above checks if the current user is a “company” or a “person”. If it’s a company is replacing the standard form with a list of names as a radio-button list. You pick one and the new $userid is posted as a replacement for the user_vars.php file. If instead the user is a “person”, the regular form is displayed.

The latter point has an additional issue. If now I log in as a regular user to make a reservation, I see the standard form, the reservation is successful but no relationship is created in the ‘events_member_rel’ table, so the user then won’t see the reservation under his account.

Do you have any idea of what I may be missing?

Many thanks for the support!