Double opt in problem

I have got the double opt in working pretty much OK, however, I have just noticed that the link provided is missing the email address... I can't figure out why that's not working though. Currently I am testing it by copying and pasting the link, then appending it with my email address which works for the time being, but it needs to be fixed for users of the site.

There's another problem. The user update page isn't registering that the email has been verified. I am still getting a message telling me that I need to verify my email even though it has been. Why would this be happening when I can clearly see in the DB it has change the record status from 0 to 1?

I've followed the tutorial to the best of my knowledge, and the result of it can be seen at registration.php if you want to give it a try, but I suspect you'll need the code which is attached. If there are other pages you need to see, let me know.

I have created a support ticket so we can look into this issue further.

To view and edit your support ticket, please log into your support history:
supporthistory.php

If anyone else is experiencing this same issue, please append to this thread.

I am having a similar issue, not quite the same but when I attempt to resend a verification link from the profile update page the email sends however the link fails to change the DB value from 0 to 1. It does remove the random string from the db though. Any help would be greatly appreciated.

What is the URL for the link you receive in the email?

also, send a copy of the page that the link points to.

Hi Jason, this problem of the email address not being on the end of the emailed link from the userupadte.php page has reared it head again! It was there and verification was working fine, but now it's not! It works fine from the registration page, but not the userupdate page.

I have clicked to see it in the support history, but I can't find the support history. From memory, I recall there needing to be a reference to the recordset from the user update page which is global $row_SecurityAssistusers; which is there, but I don't know why the email is missing again!

Pages are attached... any thoughts?

Thanks.

the name of the recordset on the user update p[age is:
SecurityAssisttblusers

the global variable reference on the email template name needs to reference the recordset name that is created.

change:
global $row_SecurityAssistusers;

to use the correct recordset name. there should also be a global for the recordset object as well as one for the row:
global $SecurityAssisttblusers;
global $row_SecurityAssisttblusers;

No, it didn't work! I don't know why though.

In the end I decided to create a session using the email address data which is populated before page load. I then used the session data in the email link.

At the moment it seems to be working, but it's odd that the email template is able to pull data referring to the random password and the user ID, but not the email address! Just in case, is there anyway that you know of how the session could loose it's content while on the userupdate.php page which then prevents the email link from working again? Is using a session instead of the recordset pretty much bullet proof?

Thanks.

well, in addition to changing the global reference, you also needed to change the code for the email address column:
<?php echo $row_SecurityAssistusers['UserEmail']; ?>

to use the correct recordset name:
<?php echo $row_SecurityAssisttblusers['UserEmail']; ?>


using a session should be fine to. that is what is used for the random String and ID.