tbenyon

Hey @magikweb,

This update is now deployed – let me know if this works for you.

If it’s looking good your end, I’d be grateful if you could write a review or buy me a beer 🙂

Thanks,

Tom

🙂

Hey @wburling1,

The field is “Registered” and when user is authenticated, I want to change it to “Yes”.

This link should help you:
https://codex.wordpress.org/Class_Reference/wpdb#UPDATE_rows

  // A query of your choice
  $rows = $db_data["db_instance"]->update(
    esc_sql($db_data["dbstructure_table"]),
    array('Registered' => 'Yes'),
    array( esc_sql($db_data["dbstructure_username"]) => esc_sql($exlog_user_data['user_login']) )
  );

  // Checking if the user was deleted
  if ($rows == 0) {
    error_log('User was not found or is already registered.');
  elseif($rows) {
    error_log('User Successfully update from external database');
  } else {
    error_log('Error updating user from external database');
  }

Above is just pseudocode to help you. I have not tested this as this is outside the scope of the plugin and this support. If this does not work for you and you are unable to debug it yourself you should find a developer to pay to support you with this.

my customer does not want people to register in wordpress unless they are the in the external database.

The plugin does not block user registration from systems outside of external login but you should be able to find how to do this by Googling. This was the first link I found:
https://www.competethemes.com/blog/disable-user-registration-wordpress/

when I try to log in with a user that is Inactive in the external database and it allowed that user to log in and created a user in WP

I will spend some time testing this with a local example to see if this feature is broken in anyway but this will take some more time.

At the bottom of the “Hash Type” setting dropdown is the option “None”.

Hey @doublesharp,

I’m presuming you’ve decided to go a different route so I’m going to close this ticket.

If you require more help though please message back in here and I’ll open it back up.

Thanks,

Tom 🙂

Hey @metapost,

Haven’t heard back from you so presume this is resolved and am thus closing the ticket.

If this is not correct, get back in contact and I’ll continue to support you 🙂

Thanks,

Tom

Hey @magikweb,

Really sorry about the long delay. Life’s been busy.

The good news is that I’ve found the problem and I’m going to add a feature in that will handle the work for you.

It’s not an issue with the plugin. Basically external domains are blocked by WordPress by default.

Can you confirm you’re still interested in this feature and I’ll prioritise getting it into the plugin.

Thanks for your patience,

Tom

Hey @wburling1,

I can see the issue!

You simply need to check the box that says ‘Enable External Login’.

This is here so that you don’t lock yourself out of the admin area while you’re making sure the test works.

Ticking this activates the plugin.

Let me know if this works. 🙂

Thanks,

Tom

Hey @ejbrewer,

It doesn’t at the moment but this is possible.

There’s two ways this could be handled and I’m not sure which one is the best approach.

1) Integrate in the admin area

I could have a section where you could choose additional data that you want to fetch from the users table.

I could then just store this as meta data for the user in the WP database where the phone_number field would become exlog_phone_number.

2) I get the entire user row when I query to authenticate the user. I could add this information to the exlog_hook_action_authenticated hook that exists and you could handle storing the data you require yourself.

Option one will take weeks to implement (just because it’s a bigger job that’ll require me to book out some time to do) and option two could be completed this week.

What are your thoughts?

Tom