I've managed to get the user validation system set up successfully with all the backend for amending the new column for user validation.
A couple of problems which I need to resolve, been trying but need help.
1. I need to set up an access rule to show up in the following situation. If a user has successfully completed and submitted the registration page and then tries to log in before the registration is validated I would like to show a message "Your registration has not been validated, if you need any more information please ...... etc."
The current rule "Invalid email or password" is now displayed when the user is not validated (which I need to retain as it is, so that when a validated user does make an error while logging in, this standard message is shown) but I would like the specific validation rule described above to show for the "registered but not validated" situation.
2. I can't get the automatic registration email to send to the user and admin when a user registers. I have included the UE code after the insert record code and I have moved the insert record redirect to the UE redirect.
The site is not yet live and is running on a Xampp local testing server. I have successfully got Xampp to send emails by including my own hosting smtp details in the c:\xampp\php\php.ini file in the section shown below
; For Win32 only.
SMTP = smtp.tiscali.co.uk (this was set at SMTP=localhost but if you put in your own smtp details it works for xampp)
smtp_port = 25
This works perfectly for my contact page and the forgot password page where it actually sends real emails to the designated email addreses. Unfortunately it doesnt work for the registration page (maybe its because the registration page in particular needs to be on a live server!)
I've included the registration page.