User Verification (Anti-Robot / CAPTCHA)

[funkey]

Hi Everyone,

To start with, i'd really appreciate it if some people familiar with the ZC 1.3.x codebase could have a look at this and let me know if i've got everything right -- this is my first attempt at porting anything of significance to 1.3.x, so bear with me -- please.

So, this is basically a straight port of the echazen Anti-Robot Registration System to ZC 1.3.x -- it's been improved a bit to use the message stack system for errors (so people not using Javascript can see that they need to enter the validation code), but is otherwise pretty straight forward.

I've only ported the bits for the 'create_account' page over, if I get time and there's any interest (and I get pointers on how to cosmetically fix it up to look snazzy) -- i'll do the 'login' pages and post an update.

With this code, I can make a new account -- so i'd like the think what i've done works so far.

There's a README in the archive that explains how to install it.

Cheers,

Paul

[Typhoon]

Very nice, I have been searching for something like this for some time now. I will try it and see if I can get this to work... Thanx,

/Typhoon

[TheOracle]

Glad to know it's done.

[Typhoon]

I seem to have some problem to install it... I did everything like written in the Read_me-file but...

It seems to be something wrong with the sql-file. the db don't accept all file, seems to stop in the middle. I tried to upload it throu the admin interface and it shows only like the first 2 rows...

When I go to the registration screen, nothing is shown here from CAPTCHA, it looks just the same as usual.

I found in admin under Configuration the Anti-Reg 2.0-menu but it's all blank, no options here. Are there suppose to be ? Is there somewhere else that I should change something ? Nothing under Customer Details also...

What am I doing wrong ?

Regards,

/Typhoon

[Typhoon]

Tried again on a clean sql:

The second INSERT INTO from CAPTCHA.sql:

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Activate Anti-Reg V2.0 Registration', 'ACCOUNT_VALIDATION', 'true', 'Enables Anti-Reg V2.0 Verification Code . This is used to verify that the customer is an actual HUMAN. No more "ROBOTS!".', 35, 10, '2006-08-07 17:00:00', '2006-08-07 17:00:00', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');

gives the message:
Out of range value adjusted for column 'configuration_id' at row 1.

Same for the rest where it starts with INSERT INTO configuration...

My tables are called configuration, not zen_configuration...

Need help...

/Typhoon

[DrByte]

VALUES ('',

should be

VALUES (NULL,

in order to be compatible with MySQL5

[X@vier]

Hello,

The Captcha is a real added value to the Zen Cart.

I'm new to this forum and I'm trying to make a new shop with Zen Cart (www.mindex.be/anatest). Until now it works fine.
I'm a software newby so I must rely on the experience of the people in this forum. If it's permitted?

With phpMyadmin I uploaded the captcha.sql file with no problems.
On the website there the following error message:

1146 Table 'anamorf_zc1.zen_anti_robotreg' doesn't exist
in:
[DELETE FROM zen_anti_robotreg WHERE timestamp < '1162555155' OR session_id = 'bd01349c14acb00239260c2f5ae5f147']

How can that be repaired?

Thank you for your help,

Xavier

[X@vier]

Hello,

In the archives of this forum I found a contribution about this issue and it helped me.

The solution I found was add zen_ to the table names.
Then I created a new .sql file with only the instructions to create the new anti_robotreg table. This file was copied to the "SQL Query Executor" and send.
Now it works for the login page.

it's really a great thing!!!

Next step is to add the Captcha to the other applications such as tell-a-friend and contact us.

Anyone any experience or ideas how that should be done?

Thanks,

Xavier

[funkey]

Hi Xavier,

The CAPTCHA code SQL file comes without a table prefix because that's the default for new Zen-Cart 1.3.x installs. If you have a Zen-Cart setup with a table prefix (such as yours) you'll need to make that change manually before installing the SQL code.

I've added a small note to the new 1.3.6 release clarfiying that for new users, so they can benefit from your experience.

Cheers,

Paul

Hello,

In the archives of this forum I found a contribution about this issue and it helped me.

The solution I found was add zen_ to the table names.
Then I created a new .sql file with only the instructions to create the new anti_robotreg table. This file was copied to the "SQL Query Executor" and send.
Now it works for the login page.

it's really a great thing!!!

Next step is to add the Captcha to the other applications such as tell-a-friend and contact us.

Anyone any experience or ideas how that should be done?

Thanks,

Xavier

[funkey]

Just to let everyone know, an updated copy of the CAPTCHA modification that works out-of-the-box with 1.3.6 has just been uploaded to the contributions area.

Existing users of the code don't need to do anything with the .SQL file, just drop-in the PHP files as required and you're good to go.

Aside from the code changes, the SQL file itself has been altered quite a bit to work around broken PHP installations -- which should mean it is a lot easier for new users to install first time around.

Cheers,

Paul