Hey John,
The plugin has been designed so that the external database is the central source of information and we’re just allowing access (and updating information) based on the external database. Essentially a one way link from External DB to WordPress.
It would be possible to make two way links but this is not only a big feature for adding now, but I can see it adding a lot of work for additional features that I have in mind. This is not to say I won’t do it because I can see this being useful for users.
I’m mostly writing this so I can think about the work involved for my self but my initial thoughts on the work required to do this would be:
– Update the test button to also do an ‘insert’ query to ensure the db user has permission to do such queries
– Add a tick box in the admin area to allow password resets to modify the External DB from WP
– Hook into the standard WP password reset functionality to attempt to update the external DB at password update time
– Hook into the admin area password change and attempt to update the external DB first
– If the external db update fails block the changes to passwords in WP
– Decide if other details from the admin page should be able to update the External Database – If so, do I need to add a section to the admin area that would allow the user to choose which details can be updated? – Do I then need to block other details from appearing in the WP admin area for change?
I very much welcome any thoughts, opinions or anything I’ve missed above.
I wouldn’t expect to get round to this this month as I have other features in the backlog that I’m also working on. I have added this to the Trello board though and will keep this thread open to update you.
Your second query about being bombarded with e-mails is new to me but I can understand why this is happening. I’m updating the user details every time a user logs in which is what will be causing this. This is definitely a bug on my end rather than a new feature so I will push this up the Trello board as this sounds very annoying. Apologies for missing this but I don’t have e-mail set up on my dev environment so it was missed.
Any questions, feel free to get back to me John ??
Thanks,
Tom