03-10-2013, 05:58 PM
PM User |
Join Date: Sep 2008
Thanked 17 Times in 16 Posts
Originally Posted by Thyrosis
Right, so let me get this clear:
1. User registers
2. Unique activationkey is generated and stored in DB on users account
3. User receives an e-mail with a activation-URL, which doesn't actually include the activationkey?It does, it gets sent in an email with the url http://website.com/verify.php?id=codingforums I just shortened it because the usual code is very long.
4. User then clicks link verify.php?id=codingforums, in which codingforums is that link is sent to the email, which the variable value is different every time since it is generated randomly.
a) the actual ID of the row (this is usually a number, not a word, unfortunately just out of range in your screenshot); or
b) the activationkey it is the row value of activationkey
Because if 4a is the case, then why are you generating unique keys, as they're not being used.
If 4b is happening, then you are searching the DB for an ID which is not being found, as the key is stored in the table.activationkey, not in table.id.
I am searching for a value that is in the database, because if someone types in a random activationcode, it doesnt find it and says that it is either invalid or not found because someone has already activated it and it removed it from the database and set the user as level 1
█ MY MSN: Sith717@Hotmail.com
█ PHP, HTML, and CSS Coding, Logo and Web Design - Professionally done.
█ PM me anytime for HTML, PHP or web design help. I will be glad to help you out.