double opt in config issues with MySQLi Authenticate

Hi Ray.. Im trying to integrate the double opt in to an Account Setup ( registration ) and Login files. I didn't use the create security pages and have custom built pages I already had. everything is fine up to the point of verification where the email is sent to the user, they click the email link and the database is updated and their email is successfully verified.
But It is failing on Login. I have replicated everything as per tutorial apart from the "Store verified status on logon" section as I am using the MySQLi authenticate user behaviour which is slightly different to what is in the tutorial.

Just can't figure out what is causing login to fail.

I’ve attached all the relevant pages. Not sure if you’re able to figure out any errors from these.
I’ll await to hear from you.

Cheers!

I'd have to go through the process and debug in a phone call. I'd have to keep track of what is happening in the database and on the pages. There are too many places it could be going wrong to spot in the files out of context.

I thought that might be the case. I'm just leaving office, I'll message on skype later when i'm home.
Cheers!