CAPTCHA Anti-Robot Mod

Thank you for the reply.

Can you be a little bit more specific (where the database file is located and how I find the ID for each?) since I am new at editing this from zencart. Thank you.

nycxkkoma:

Thank you for the reply.

Can you be a little bit more specific (where the database file is located and how I find the ID for each?) since I am new at editing this from zencart. Thank you.

The easiest way for you to correct this would be to delete it all from your database.

BACKUP your DATABASE FIRST!!

Edit the UnInstall_CAPTCHA.sql file and remove the LIMIT 1 from this line only. Make sure you leave the ; at the end of the line.

DELETE FROM configuration_group WHERE configuration_group_title = 'CAPTCHA Validation' LIMIT 1;

Check your Admin/Configurartion screen that all of the CAPTCHA entries are gone.

Now re-run the Install_CAPTCHA.sql file and there should only be one entry now.

JTheed:

After looking over that part of the Code, there is quick fix for this if you do not want to use the Split Login Screen.

Look for this in includes/templates/YOUR-TEMPLATES/tpl_modules_create_account.php around line 189:

> Change it to this
> ```
<?php
if (strstr($_SERVER['REQUEST_URI'],'create_account') && CREATE_ACCOUNT_VALIDATION == 'true' || strstr($_SERVER['REQUEST_URI'],'login') && [B]CREATE_ACCOUNT_VALIDATION == 'true')[/B] { 
?>

In the next release, I will make this a toggle as well.

This is an error actually the file to be amended is /includes/modules/create_account.php

There is no such code in tpl_modules_create_account.php

save you some head scratching :P

some useful info here on integrating with FEC

http://www.zen-cart.com/forum/showthread.php?p=950814#post950814

aozhaver:

This is an error actually the file to be amended is /includes/modules/create_account.php

There is no such code in tpl_modules_create_account.php

save you some head scratching :P

Maybe in someone else's version but I am looking at mine and in tpl_modules_create_account.php at line 189 and it is there, not in create_account.php . Also, in my current version create_account.php would be located in modules/YOUR_TEMPLATE/create_account.php

Well then you must have changed it since when I downloaded it (which was only about 2 weeks ago).

My version readme states "Last Updated: 08/11/2010"

I checked both the original CAPTCHA files and the FEC create_account files all the references to that code is in the modules files and yes your fix works even there.

Great simple fix to a great big problem that was driving me mad:P

By the way is there anywhere I can download an alternative image file for the anti-robot challenge images? I find the current format quite confusing even to humans :P

I guess thats a matter of opinion but if you could point me in the right direction I'd like to see all my options.

Cheers!:D

I reinstalled CAPTCHA today on my site to add the 'Contact Us' page functionality. I see the option in my Admin, just not seeing it on the site, until I attempt to send a message then it shows up ?
http://bbmetalfab.com/metalart

robinsonjas:

I reinstalled CAPTCHA today on my site to add the 'Contact Us' page functionality. I see the option in my Admin, just not seeing it on the site, until I attempt to send a message then it shows up ?
http://bbmetalfab.com/metalart

I think it has to do with the Magic SEO URL add-on. When I disable it temporarily the CAPTHCA works on Contact Us page.

Any ideas?

Got it, the code looks for 'contact_us' and the URL translation was 'contact-us'...I changed the underbar to a hyphen and all good now.

zen cart 1.3.9h

hey this is awesome...thanks so much...

my only advice as a newbie to newbies, is break out the pen and paper and take your time, ensure to follow it to the letter...

make a note of every change, and if you haven't read the article about templates and making your own template, don't attempt this mod because you'll make a balls of it..there is a couple of steps that are a little tricky, knowing how you make your own template is a must...

keep the faith...

thanks so much for a great add on...

donal:clap:

I posted my question in the wrong Captcha Thread it seemed,
http://www.zen-cart.com/forum/showpost.php?p=957611&postcount=152 can you read my post there ?

I don't want to risk reprimand for posting it all again here.
In a nutshell:
I made the error of installing the Captcha.sql forgeting to add the prefix.

Uninstalled and reinstalled with prefix , yet it seems my table prefix is being automatically added on the config queries.

should I just add it to the Delete query at the end only as that was the only one to error when first installed?

I've reinstalled the Captcha.sql without adding prefix as the DB prefix 'znc_' as is being self generated somehow . Had No installed errors.
Captcha Validation is showing in Admin>> Configuration as it should.

However on contact page I have this error where the Captcha verfication should be:

1146 Table 'db_name.table_anti_robot_registration' doesn't exist
in:
[DELETE FROM TABLE_ANTI_ROBOT_REGISTRATION WHERE timestamp < '1289554348' OR session_id = 't723jl488tgfc08m1agml8stq5']

I've checked the phpMyAdmin the table:znc_anti_robotreg is there
so was created on istall of patch
It appears that there is a prefix 'table' being added to a table name which is now anti_robot_registration rather than anti_roboterg which was the name of the table created on the Install_captcha.sql

How do I fix this?

:cry:

pippa_oz:

I've reinstalled the Captcha.sql without adding prefix as the DB prefix 'znc_' as is being self generated somehow . Had No installed errors.
Captcha Validation is showing in Admin>> Configuration as it should.

However on contact page I have this error where the Captcha verfication should be:

1146 Table 'db_name.table_anti_robot_registration' doesn't exist
in:
[DELETE FROM TABLE_ANTI_ROBOT_REGISTRATION WHERE timestamp < '1289554348' OR session_id = 't723jl488tgfc08m1agml8stq5']

I've checked the phpMyAdmin the table:znc_anti_robotreg is there
so was created on istall of patch
It appears that there is a prefix 'table' being added to a table name which is now anti_robot_registration rather than anti_roboterg which was the name of the table created on the Install_captcha.sql

How do I fix this?

:cry:

Check to make sure that the file anti_reg_filenames.php is in the /includes/extra_datafiles location as it defines the tables. You will see in this file that is it defined as anti_robotreg: ```
define('TABLE_ANTI_ROBOT_REGISTRATION', DB_PREFIX . 'anti_robotreg');

It adds the prefix as long as it is defined in your configure.php file.

Thanks,
Yes I did upload to includes/ extra_datafiles

Checked the anti_reg_filemanes.php and had seen that
define('TABLE_ANTI_ROBOT_REGISTRATION', DB_PREFIX . 'anti_robotreg');
was defined there.

So I went to PhpMyAdmin and manually dropped the existing znc_anti_robotreg table and recreated it manually and now it works fine.

Goodness knows why it didn't work the first time.

I don't care - It works! :clap:

Thanks for a great addon. and your help

I'm off to buy zencart a coffee!

Hi,

After install magic seo url the validation captcha don't work. I am using 1.39h.
Any idea please?

Cheers!

my captcha was working fine, but now it's not. the input boxes still show up (enter validation code) but the little letters are not there. i've got them in /store/images/validation/ and i've re-uploaded them, but still no love. any ideas? i took the captcha down for now, but can put it back up if it helps someone see what's wrong.

fontaholic:

my captcha was working fine, but now it's not. the input boxes still show up (enter validation code) but the little letters are not there. i've got them in /store/images/validation/ and i've re-uploaded them, but still no love. any ideas? i took the captcha down for now, but can put it back up if it helps someone see what's wrong.

Hi Emily,

Re-check permission from validation folder. Test it.
Do you have new mods installed??

Cheers!

where is the proper place to insert this code

if (TELL_A_FRIEND_VALIDATION == 'true') {
include_once(DIR_WS_FUNCTIONS . 'extra_functions/' . FILENAME_ACCOUNT_VALIDATION);

into the 1.3.9h
\includes\modules\pages\tell_a_friend\header_php.php ?
*there is a lot of additional spam prevention code not included in the supplied file.

thanks.

gsdcypher:

where is the proper place to insert this code

if (TELL_A_FRIEND_VALIDATION == 'true') {
include_once(DIR_WS_FUNCTIONS . 'extra_functions/' . FILENAME_ACCOUNT_VALIDATION);

> 
> into the 1.3.9h 
> \includes\modules\pages\tell_a_friend\header_php.php ?
> *there is a lot of additional spam prevention code not included in the supplied file.
> 
> thanks.

It is meant to REPLACE the original files as the spam prevention is in the file under modules/YOUR_TEMPLATE/tell_a_friend.php.

If you look in that file you will see the same Spam Prevention code in it.

JT