Hello,
I'm new to Chronoforms, but so far I've been able to figure everything out, except for this one issue. I am using Chronoforms and ChronoConnectivity to create a petition that also shows the signatures submitted on a separate page. I'm also using the Email Verification plugin, but the issue is that the form writes the data to the table and is visible before the user clicks on the vlink in their email. Is there something I'm doing wrong here? I can provide full form details if necessary. I also have this code at the end of the form, and when turned ON, gives an error but the data is still submitted. It is currently turned off. I found this code on the Chronoforms forum. It works without Email Verification, but gives an 'unexpected T_STRING' error on line 258 of chronocontact.php.
I'm new to Chronoforms, but so far I've been able to figure everything out, except for this one issue. I am using Chronoforms and ChronoConnectivity to create a petition that also shows the signatures submitted on a separate page. I'm also using the Email Verification plugin, but the issue is that the form writes the data to the table and is visible before the user clicks on the vlink in their email. Is there something I'm doing wrong here? I can provide full form details if necessary. I also have this code at the end of the form, and when turned ON, gives an error but the data is still submitted. It is currently turned off. I found this code on the Chronoforms forum. It works without Email Verification, but gives an 'unexpected T_STRING' error on line 258 of chronocontact.php.
<?php
$checkmail = JRequest::getString('email', '', 'post');
$db =& JFactory::getDBO();
$query = "
SELECT COUNT(`email`)
FROM `#__chronoforms_petition`
WHERE `email` = '$checkmail' ;
";
$db->setQuery($query);
$count = $db->loadResult();
if ( $count ) {
return 'We're sorry, but you've already signed the petition using that email address. If you believe this is an error, please contact us immediately.';
}
?>