CAPTCHA Anti-Robot Mod

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/showpo...&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:

Quote:

---

Originally Posted by 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:

Code:

---

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.

Quote:

---

Originally Posted by 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

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.

Quote:

---

Originally Posted by gsdcypher

where is the proper place to insert this code

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