when you register, you will be sent an email that contains a link to the user_confirm.php
you need to click the link in the email to access the user_confirm.php page.
the link passes information specific to your registration, this information is used to determine if you are valid user or not.
if your are a vlid user, the email verified column can be updated. if not, the email verified column cannot be updated.