I figured out the email verification problem.
Where it said this ""You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'l= '-1' AND users.UserRandomString <> '0'' at line 1""
The "l=" was actually a spelling error in the Recordset (reverify). I typed it "emai l=" instead of "email=".
I will work on the rest. Thanks