I'm currently searching how to do the following:
A customer has an external SQL database with client info (client number + phone + validity period).
He wants to have guest self register using their client number and phone and then automatic approval based if the client info exists in the database and if the period is still valid.
Once checked, the internal CP database will be used with a generated password and validity based on the external db.
How would I proceed checking the SQL first and then start approval based on this SQL db?
