Title: Adding Salt
Last modified: May 25, 2019

---

# Adding Salt

 *  Resolved [wburling1](https://wordpress.org/support/users/wburling1/)
 * (@wburling1)
 * [7 years ago](https://wordpress.org/support/topic/adding-salt/)
 * Not sure if this has been discussed before but asking again.
    I have an external
   database where the username and password fields are in normal text. I want to
   use this database with the external login plugin but do not know how to make 
   the password change so the the plugin will allow users log in with their current
   password. I also am not sure where I set a separate salt for each password. Thanks
   for any help on this. Wayne

Viewing 12 replies - 31 through 42 (of 42 total)

[←](https://wordpress.org/support/topic/adding-salt/page/2/?output_format=md) [1](https://wordpress.org/support/topic/adding-salt/?output_format=md)
[2](https://wordpress.org/support/topic/adding-salt/page/2/?output_format=md) 3

 *  Thread Starter [wburling1](https://wordpress.org/support/users/wburling1/)
 * (@wburling1)
 * [6 years, 11 months ago](https://wordpress.org/support/topic/adding-salt/page/3/#post-11730629)
 * Tom,
    In the example you gave me about deleting a user from the external database,
   I am not familiar with the method you used to delete the record. Can you give
   me an idea on what code I should use to update a field in the external database.
   Thanks Wayne
 *  Plugin Author [tbenyon](https://wordpress.org/support/users/tbenyon/)
 * (@tbenyon)
 * [6 years, 11 months ago](https://wordpress.org/support/topic/adding-salt/page/3/#post-11730668)
 * What field are you trying to change in the external database and what are you
   trying to change it to?
 *  Thread Starter [wburling1](https://wordpress.org/support/users/wburling1/)
 * (@wburling1)
 * [6 years, 11 months ago](https://wordpress.org/support/topic/adding-salt/page/3/#post-11730672)
 * The field is “Registered” and when user is authenticated, I want to change it
   to “Yes”.
 *  Thread Starter [wburling1](https://wordpress.org/support/users/wburling1/)
 * (@wburling1)
 * [6 years, 11 months ago](https://wordpress.org/support/topic/adding-salt/page/3/#post-11733299)
 * Tom,
    I have a new question. If a user registers on wordpress, it does not check
   to see if the user is in the external database. Is there a fix that could let
   it do that, my customer does not want people to register in wordpress unless 
   they are the in the external database. Hope you can help. Wayne
 *  Thread Starter [wburling1](https://wordpress.org/support/users/wburling1/)
 * (@wburling1)
 * [6 years, 11 months ago](https://wordpress.org/support/topic/adding-salt/page/3/#post-11733331)
 * Tom,
    Just found another problem, 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 double checked the settings page for the plugin, and this is what I 
   see.
 * Exclude Users (BETA)
    This will allow you to block users based on the value of
   additional fields in the database.
 * Enable Excluding Users
    Tick this box if you want to enable the excluding users
   functionality. [checked]
 * Field Names
    Field Name The field name in the database that stores the data that
   could block users.
 * [Status]
    Field Values A value in the field above that would prevent a user from
   logging in.
 * [Inactive]
 *  Plugin Author [tbenyon](https://wordpress.org/support/users/tbenyon/)
 * (@tbenyon)
 * [6 years, 11 months ago](https://wordpress.org/support/topic/adding-salt/page/3/#post-11734130)
 * Hey [@wburling1](https://wordpress.org/support/users/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](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/](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.
 *  Thread Starter [wburling1](https://wordpress.org/support/users/wburling1/)
 * (@wburling1)
 * [6 years, 11 months ago](https://wordpress.org/support/topic/adding-salt/page/3/#post-11734356)
 * Tom,
    Thank you for the help. I will try the code and let you know if it works.
   Also, thank you for checking the status problem. I know I am making you work 
   for this but I will be giving you a 5 star review when I get this completely 
   working. Wayne
 *  Thread Starter [wburling1](https://wordpress.org/support/users/wburling1/)
 * (@wburling1)
 * [6 years, 11 months ago](https://wordpress.org/support/topic/adding-salt/page/3/#post-11736440)
 * Tom,
    I just tried the above code and it is not updating the file. I added the
   first delete code you sent to the bottom of the functions.php and then replaced
   the delete code with this code. Is there something I am missing? Wayne
 *  Plugin Author [tbenyon](https://wordpress.org/support/users/tbenyon/)
 * (@tbenyon)
 * [6 years, 11 months ago](https://wordpress.org/support/topic/adding-salt/page/3/#post-11737602)
 * Hi Wayne,
 * Without going through logs I wouldn’t be able to tell.
 * You’ll have to pay for a developer to look into this with you.
 * If you have any other issues regarding the plugin functionality please don’t 
   hesitate to get in contact.
 * Thanks,
 * Tom
 *  Thread Starter [wburling1](https://wordpress.org/support/users/wburling1/)
 * (@wburling1)
 * [6 years, 11 months ago](https://wordpress.org/support/topic/adding-salt/page/3/#post-11741105)
 * Tom,
    Thank you so much for your help on this. I got the hook to work updating
   the external database. Still am able to log in with an inactive userid in external
   database.
 * Would you have any suggestions about registering on WP using the external database
   if not there do not let them register. I know this is not currently part of this
   plugin is it something that can be added?
 * Wayne
 *  Thread Starter [wburling1](https://wordpress.org/support/users/wburling1/)
 * (@wburling1)
 * [6 years, 11 months ago](https://wordpress.org/support/topic/adding-salt/page/3/#post-11741120)
 * Tom,
    Also just added a 5 star review as I said I would. Thanks Wayne
 *  Plugin Author [tbenyon](https://wordpress.org/support/users/tbenyon/)
 * (@tbenyon)
 * [6 years, 11 months ago](https://wordpress.org/support/topic/adding-salt/page/3/#post-11749499)
 * Hey [@wburling1](https://wordpress.org/support/users/wburling1/),
 * I’ve just released V1.7.3 that fixes this issue.
 * I really appreciate you taking the time to flag issues and raise questions.
 * Thanks,
 * Tom

Viewing 12 replies - 31 through 42 (of 42 total)

[←](https://wordpress.org/support/topic/adding-salt/page/2/?output_format=md) [1](https://wordpress.org/support/topic/adding-salt/?output_format=md)
[2](https://wordpress.org/support/topic/adding-salt/page/2/?output_format=md) 3

The topic ‘Adding Salt’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/external-login_fbebd6.svg)
 * [External Login](https://wordpress.org/plugins/external-login/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/external-login/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/external-login/)
 * [Active Topics](https://wordpress.org/support/plugin/external-login/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/external-login/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/external-login/reviews/)

 * 42 replies
 * 2 participants
 * Last reply from: [tbenyon](https://wordpress.org/support/users/tbenyon/)
 * Last activity: [6 years, 11 months ago](https://wordpress.org/support/topic/adding-salt/page/3/#post-11749499)
 * Status: resolved