User Verification (Anti-Robot / CAPTCHA)

[funkey]

I think I see the problem:

You seem to have modified the SQL to change your configuration prefix to zen_ -- but your database actually is looking for hotrod_zc1. (requires the dot)

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));

[Boognish]

hotrod_zc1. is the name of the database that it is looking for which is correct. I started to reinstall the mod one page at a time and checking to see what file made a change. After reinstalling anti_reg_filenames.php it worked. Thanks for the cool mod!

p.s. Compaired to other messageboards I have posted on, I don't think I've ever received such quick responses from people willing to help as I get on this one.

Thanks!

[babygekko]

I just took a quick look at the code and PLEASE correct me if I'm wrong but I believe that a spam bot can still break this captcha thing. A true captcha doesn't really display the img src code....

The bot can break the validation by parsing the HTML content:
images/validation/validation_x.gif
images/validation/validation_y.gif
...
and so on.

Take a look at this - you can view the code in your own create account page (view source): index.php?main_page=login

<div class="centered"><img src="images/validation/validation_x.gif" alt="x" title=" x " width="30" height="30" /><img src="images/validation/validation_y.gif" alt="y" title=" y " width="30" height="30" /><img src="images/validation/validation_f.gif" alt="f" title=" f " width="30" height="30" /><img src="images/validation/validation_s.gif" alt="s" title=" s " width="30" height="30" /><img src="images/validation/validation_e.gif" alt="e" title=" e " width="30" height="30" /><br /></div>
<input type="text" name="antirobotreg" id="antirobotreg" /><span class="alert">* (case insensitive)</span><br class="clearBoth" />

[Woodymon]

I just took a quick look at the code and PLEASE correct me if I'm wrong but I believe that a spam bot can still break this captcha thing.

Yes, this is an OLD captcha mod from zencartskins.com. Robots can now easily break it. I'm not dissing this mod. It served it's purpose but newer captcha technology is required.

So check out Andrew's new CAPTCHA mod for Zen Cart at http://www.zen-cart.com/forum/showthread.php?t=59539

Note: I have his new script working fine on PHP 4.4.4. But I'm currently having an issue running it on PHP 5.1.6. I'm fairly convinced it is a webhost server config issue and nothing to do with the script.

Woody

[gretzlertech]

I'm getting the following error:

Email Error: Could not instantiate mail function.

AND if I enter the information incorrectly (I receive the error and) it still creates the account. I have applied the patch in the correct manner and put all files into appropriate folders (including override directories). Whadd I do wrong?

[ImNew2this]

Hello,

I am loving this cart its generally pretty easy to set up and as i am new to it all (including programming) I am having a lot of fun. But now i have hit a brick wall. I have uploaded the User verification (anti-robot / CAPTCHA) and the SQL bit seemed to go fine No errors (even though i do have zen_ prefix - i was not sure what i needed to change so just gave it a try as is) All the admin bit seems to be showing and working ok. But my issue is that i do not get anything showing up on my create account for the user to put the letters in and then when i hit submit to create an account it will not let me as it says that the CAPTCHA is not valid. I have changed my defalut template and wonder if that could be why it is not showing. Any help would be great.

Please help

Thanks

[ImNew2this]

The Remove file for the SQL was really helpfull but in my meddling with trying to add zen_ to the fields in the SQL i have manages to create a zen_CAPTCHA Verification in my Configuration tab any ideas how to remove that listing there?

[Evildad]

HI, I tried to include the CAPTCHA.sql File but get the following error.
Anyone knows where's the Problem?

1136 Column count doesn't match value count at row 1
in:
[INSERT INTO configuration_group VALUES (NULL, 'CAPTCHA Validation', 'Anti-Robot Registration/Verification', @sortorder+1, 1);]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

[dedj]

I'm getting the following error:


AND if I enter the information incorrectly (I receive the error and) it still creates the account. I have applied the patch in the correct manner and put all files into appropriate folders (including override directories). Whadd I do wrong?

Hi. Seems for some reason that you have misstyped an emailadress it sends when registering. I had the same problem under "contact us" but it was that i forgot the "<" ">" signs before and after the emailadress :)

hope it solved your problem.

[dedj]

Hi.

Need to doublecheck, "Activate Validation on Login page", this is that users that already has an account still need to validate when they log in to a existing account on your zencart webshop right? If yes, please read below if no, please explain the purpose of this option

I cant seem to get the "Activate Validation on Login page" thing to work. Its set to true. I've tried to turn off and on the "split login page" under configuration/layout settings/ in zencart.

I installed the http://www.zen-cart.com/index.php?ma...25&update_id=4
and have 1.3.7 version.

The validation for account creation works like a charm, but not for the login.

Let me know what I can look for that I might have missed.

by the way, I read something about contact us, I'd like to have validation for the contact us aswell. Any tips and ideas of what to do?


Thanks