Double opt in registration - rsVerify problem
I have worked through the tutorial several times. Each time, starting afresh.
On the section: configure the confirm page, I create the rsVerify recordset and the required parameter variables.
Moving on to the "create the update verified functionality", I create the required URL variables and then move onto update single record. When I click on the dynamic value field to expand the recordset reverify, the is no recordset listed.
Totally stumped on what the cause could be. I'm including the generated code for the user-confirm.php page.
<?php require_once('Connections/connSAWA.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
?>
<!doctype html>
<html>
<head>
<meta charset="UTF-8">
<title>Untitled Document</title>
</head>
<body>
<p>Thank you for verifying your email address. You may now <a href="login.php">view restricted content</a>.</p>
<p>Your verification link has expired. Visit your <a href="userupdate.php">profile page</a> to send a new link.</p>
</body>
</html>
<?php
mysql_free_result($rsVerify);
?>
Another issue: creating the random string on the registration page. Point 7. Select WebAssist > Cookies > Set Session Value, the eCart dialogue box opens when wanting to perform this creation. Should it do so?
I am Using a Mac Pro, OS X ver 10.8.5. installed extensions: DB 1.1.8, DE 1.1.7 and eCart 5.0.7
Kindly advise. Thank you.