User Verification (Anti-Robot / CAPTCHA)

[jewelrylady]

Thank you works like a Charm!!!! Would love to see this added to the tell a friend nd newsletter mod!!

[mgrunk]

Sorry - double posted

Michelle

[mgrunk]

I'm at a loss - I installed the newest version on a pretty new zen-cart 1.3.7 - I applied the sql patch via phpmyadmin w/ no problems.

I enabled it via the configuration CAPTCHA w/ no problems.

So, I go to create a new account - fill out the details - see no captcha box, hit submit and it says that the you have entered an incorrect or incomplete...

So, I read through this thread - I copied the tpl_modules_create to /includes/templates/my_template/templates/ and no change.

I recopied everything over thinking maybe they ended up in the wrong directories - no change.

Any other suggestions? BTW, I don't have problems w/ the javascript - it gives me a big read error box if I don't fill in one of the required fields, and my form works if I deactivate CAPTCHA.

Thanks - it should be a great mod - my customer will appreciate it.

BTW, where should the verification box show up?

Michelle

[Woodymon]

where should the verification box show up?

The "validation code" box should display at the bottom of create account form

/index.php?main_page=create_account

In admin under Configuration > CAPTCHA Validation, are you certain you have "Activate Validation on Create Account page" set to TRUE ?

Which version of CAPTCHA mod have you installed?

If employing the new Zen cart 1.37 split login option, be aware the CAPTCHA mod does NOT support the "Login" page. but still works on "Create Account" page.

Are you certain you have the below code block near the end of your tpl_modules_create_account.php ????

<?php
if (ACCOUNT_VALIDATION == 'true') {
?>

<?php
if (strstr($_SERVER['REQUEST_URI'],'create_account') && CREATE_ACCOUNT_VALIDATION == 'true' || strstr($_SERVER['REQUEST_URI'],'login') && LOGIN_VALIDATION == 'true') { 
?>

<?php
  if ($is_read_only == false || (strstr($_SERVER['REQUEST_URI'],'create_account')) || (strstr($_SERVER['REQUEST_URI'],'login'))) {
	$sql = "DELETE FROM " . TABLE_ANTI_ROBOT_REGISTRATION . " WHERE timestamp < '" . (time() - 3600) . "' OR session_id = '" . zen_session_id() . "'";
	if( !$result = $db->Execute($sql) ) { die('Could not delete validation key'); }
	$reg_key = generate_captcha_code();
	$sql = "INSERT INTO ". TABLE_ANTI_ROBOT_REGISTRATION . " VALUES ('" . zen_session_id() . "', '" . $reg_key . "', '" . time() . "')";
	if( !$result = $db->Execute($sql) ) { die('Could not check registration information'); }
?>

<fieldset>
<legend><?php echo CATEGORY_ANTIROBOTREG; ?></legend>
<label class="inputLabel" for="antirobotreg"><?php echo ENTRY_ANTIROBOTREG ?></label>

<?php
$validation_images = '';
for($i = 0; $i < ENTRY_VALIDATION_LENGTH; $i++)
    {
    $parse_image = 'validation/validation_' . $reg_key{$i} . '.gif';
    $parse_image_alt = $reg_key{$i};
    $validation_images .= zen_image(DIR_WS_IMAGES . $parse_image, $parse_image_alt);
    }
    echo '<div class="centered">';
    echo $validation_images . '<br />';
    echo '</div>';
?>

<?php echo zen_draw_input_field('antirobotreg','', 'id="antirobotreg"') . (zen_not_null(ENTRY_ANTIROBOTREG) ? '<span class="alert">' . ENTRY_ANTIROBOTREG_TEXT . '</span>': ''); ?>
<br class="clearBoth" />

Does the validation related HTML show up when you view the source for the create_account web page?

Woody

[mgrunk]

mine says - mainpage=login - not create account

I do have activate validation on and activate validation on create account

And, no, I don't see the code on the login page source

So, how have I screwed this up :-) Why am I not seeing a create account page?

Oh, I found the split screen login in Cofiguration/Layout Settings and it' set to false.

Thanks,
Michelle

[Woodymon]

mine says - mainpage=login - not create account
I do have activate validation on and activate validation on create account
And, no, I don't see the code on the login page source
So, how have I screwed this up :-) Why am I not seeing a create account page?
Oh, I found the split screen login in Cofiguration/Layout Settings and it' set to false.

Do you see the validation code in the create_accont page HTML source? If not then the code bock above is likely not in tpl_modules_create_account.php. If that is the case re-upload that file from the mod package (assuming you have not done any customization to your tpl_modules_create_account.php, otherwise merge in relevant code block above).

Woody

[mgrunk]

Could the problem be that it's not going to the create_login page but to the mainpage=login - I don't have the split login turned on, but I'm not getting to a create_account page. I looked at the tp_modules_create_account and the code is there and there is no override file .

I did a standard install - when you come into the store - it says welcome guest would you like to login - if you click there - you get the login / create account info - but it is a vertical split page -

If I put something in the shopping cart and then check out - it does take me to the mainpage=create_account - but once again, I don't see the verification box nor do I see it in the code. But, it won't let me create the account - it errors off saying the code doesn't match.

I just recopied everything over - I can try and download the zip file again and reload.

but, I really don't understand what's happening.

[Boognish]

I just installed on zc 1.3.7 I get this code at the bottom of my registration page:

1146 Table 'hotrod_zc1.TABLE_ANTI_ROBOT_REGISTRATION' doesn't exist
in:
[DELETE FROM TABLE_ANTI_ROBOT_REGISTRATION WHERE timestamp < '1173051830' OR session_id = '6ee1140ffc6f8e53f4de896c83b68f08'] 

I did enter the tables in my sql database. Is the table it's looking for the one I have called zen_anti_robotreg?

Help?

[Boognish]

I have reinstalled sql several times and I'm still getting this at the bottom of the page:

1146 Table 'hotrod_zc1.TABLE_ANTI_ROBOT_REGISTRATION' doesn't exist
in:
[DELETE FROM TABLE_ANTI_ROBOT_REGISTRATION WHERE timestamp < '1173066328' OR session_id = '6ee1140ffc6f8e53f4de896c83b68f08']

Here is my SQL code

# CAPTCHA Verification SQL Install
# For Zen-Cart 1.3.6
# Last Updated: 31/10/2006

SELECT @sortorder:=max(sort_order)
FROM zen_configuration_group;

INSERT INTO `zen_configuration_group` VALUES (NULL, 'CAPTCHA Validation', 'Anti-Robot Registration/Verification', @sortorder+1, 1);

SELECT @captchaid:=max(configuration_group_id)
FROM zen_configuration_group;

INSERT INTO zen_configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function ) VALUES ( 'Activate Validation', 'ACCOUNT_VALIDATION', 'true', 'Enables CAPTCHA Verification Code. This is used to verify that the customer is real and valid, rather than a bot or spider session.', @captchaid, 10, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO zen_configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function ) VALUES ( 'Activate Validation on Create Account page', 'CREATE_ACCOUNT_VALIDATION', 'true', 'Enables verification on Create Account page. (Recommended)', @captchaid, 20, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO zen_configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function ) VALUES ( 'Activate Validation on Login page', 'LOGIN_VALIDATION', 'true', 'Enables verification on Login page. (Optional)', @captchaid, 30, NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),' );

INSERT INTO zen_configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function ) VALUES ( 'Length of Validation Code', 'ENTRY_VALIDATION_LENGTH', '5', 'Default Length = 5, Maximum Length = 32', @captchaid, 50, NULL, NULL );

DROP TABLE IF EXISTS zen_anti_robotreg;

CREATE TABLE zen_anti_robotreg (session_id char(32) DEFAULT '' NOT NULL, reg_key char(32) NOT NULL, timestamp int(11) unsigned NOT NULL, PRIMARY KEY (session_id));

[funkey]

Do you have a URL where we can look at the code to see what is happening?

A couple of other questions:

* Did you upload the images to the images/ directory (i've seen this in the past where people suggest the code is there, but there's no image?)

* If you have a test/demo shop, if you tried uploading the templates to the templates_default directory (as the install is laid out in the download file) instead of into your custom template?

Could the problem be that it's not going to the create_login page but to the mainpage=login - I don't have the split login turned on, but I'm not getting to a create_account page. I looked at the tp_modules_create_account and the code is there and there is no override file .

I did a standard install - when you come into the store - it says welcome guest would you like to login - if you click there - you get the login / create account info - but it is a vertical split page -

If I put something in the shopping cart and then check out - it does take me to the mainpage=create_account - but once again, I don't see the verification box nor do I see it in the code. But, it won't let me create the account - it errors off saying the code doesn't match.

I just recopied everything over - I can try and download the zip file again and reload.

but, I really don't understand what's happening.