Adding reCAPTCHA to Contact Us Form

[BadDog1369]

never mind, followed some instructions, and it worked

What did you miss the first time? I've tried installing this twice and still do not see it in configure. It is a pretty simple install, so I'm at a loss as to why it is not working for me. FWIW, I did notice that two files get modified, not just one (the header and tpl files).

[davemehta]

I installed the mod and it didn't run the SQL automatically upon logging into my admin page! I don't get a reCaptcha configuration option under the "Configuration" drop-down. Now I have a custom admin folder (not called admin) and so I renamed the admin folder in the package to my name so it uploaded to the right place. It only edits one file in the admin folder anyway, admin/includes/functions/extra_functions/recaptcha_functions.php.

How can I get this to install?

[davemehta]

So I don't know why it won't "auto-install" when it says it will. I get no option for this! I'm running the latest Zen build (with the security patch).

I see an SQL statement in the admin/includes/functions/extra_functions/recaptcha_functions.php file. Can someone tell me how to get that to work or why this just isn't auto-installing?

[tomarriola]

The sql files aren't installing for me. I did see a lot of extra lines in the files downloaded-- could linefeeds be an issue?
Tom

[davemehta]

The files downloaded look fine -- I think this software is broken, but it's weird because it says it's for v1.3.8? Apparently this has to be the case because the last few people posted they had the same issues. Why won't it auto-install? Is there a way to fix this... anyone? :-)

[BadDog1369]

I think that if I really wanted to install this I'd figure out how to run the SQL statement in the database rather than trying to get it to auto-install.

[davemehta]

I agree, but the SQL statement relies on variables that I don't know so I can't recreate the SQL statement to run it! I don't know why the author didn't just put it in seperate -- would have saved a lot of headaches!

In the file admin/includes/functions/extra_functions/recaptcha_functions.php we have this function:

function install_recaptcha() {
	global $db;
	$db->Execute("INSERT INTO " . TABLE_CONFIGURATION_GROUP . " VALUES ('', 'reCAPTCHA', 'Config options for reCAPTCHA text', '1', '1')");
	$group_id = mysql_insert_id();
	$db->Execute("UPDATE " . TABLE_CONFIGURATION_GROUP . " SET sort_order = " . $group_id . " WHERE configuration_group_id = " . $group_id);
	$db->Execute("INSERT INTO " . TABLE_CONFIGURATION . " VALUES 
		('', 'Enable Contact Form', 'CONTACT_US_RECAPTCHA_STATUS', 'true', 'Disply reCAPTCHA text on contact form (default: true)', " . $group_id . ", '9', NULL, now(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'),
		('', 'reCAPTCHA Public Key', 'CONTACT_US_RECAPTCHA_PUBLIC_KEY', '', 'Public key given from reCAPTCHA website (default: blank).', " . $group_id . ", '0', NULL, now(), NULL, NULL),
		('', 'reCAPTCHA Private Key', 'CONTACT_US_RECAPTCHA_PRIVATE_KEY', '', 'Private key given from reCAPTCHA website (default: blank).', " . $group_id . ", '0', NULL, now(), NULL, NULL),
		('', 'reCAPTCHA Theme', 'CONTACT_US_RECAPTCHA_THEME', 'white', 'Choose a theme option for the widget.', " . $group_id . ", '1', NULL, now(), NULL, 'zen_cfg_select_option(array(\"red\", \"white\", \"blackglass\", \"clean\"),')		
		");
}

So looking at the code I assume TABLE_CONFIGURATION_GROUP is a define for the zen_configuration_group table in the database. Also I would assume that TABLE_CONFIGURATION is the zen_configuration table.
With those assumptions, someone please tell me if this SQL looks right before I screw something up:

INSERT INTO 'zen_configuration_group' VALUES ('', 'reCAPTCHA', 'Config options for reCAPTCHA text', '1', '1');
UPDATE 'zen_configuration_group' SET sort_order = '$group_id' WHERE configuration_group_id = '$group_id';
INSERT INTO 'zen_configuration' VALUES
('', 'Enable Contact Form', 'CONTACT_US_RECAPTCHA_STATUS', 'true', 'Disply reCAPTCHA text on contact form (default: true)', $group_id, '9', NULL, now(), NULL, 'zen_cfg_select_option(array(\"true\", \"false\"),'),
('', 'reCAPTCHA Public Key', 'CONTACT_US_RECAPTCHA_PUBLIC_KEY', '', 'Public key given from reCAPTCHA website (default: blank).', $group_id, '0', NULL, now(), NULL, NULL),
('', 'reCAPTCHA Private Key', 'CONTACT_US_RECAPTCHA_PRIVATE_KEY', '', 'Private key given from reCAPTCHA website (default: blank).', $group_id, '0', NULL, now(), NULL, NULL),
('', 'reCAPTCHA Theme', 'CONTACT_US_RECAPTCHA_THEME', 'white', 'Choose a theme option for the widget.', $group_id, '1', NULL, now(), NULL, 'zen_cfg_select_option(array(\"red\", \"white\", \"blackglass\", \"clean\"),')

Things I must figure out in above code:

1. The $group_id variable is just the next available sort order, which is pulled from the SQL command mysql_insert_id()... how do I represent it in the SQL code properly? It's used in several places and I need to know how to write that properly in SQL.

2. In the last INSERT statement, we have one of the fields as the following: 'zen_cfg_select_option(array(\"red\", \"white\", \"blackglass\", \"clean\"),' -- MY QUESTION: Do I need to use the escape \ there or do I use double-single quotes to make it the right SQL syntax? Also, what about that loan ( before array, do I need to escape that so SQL doesn't think it has to do with my query string (it's just a part of what needs to be written in that field)?

3. In the last INSERT statement, I assume the use of the SQL function now() is indeed correct, right?


Thanks in advance for the help! Hopefully one of you SQL-gurus can let me know what to do to get this all fixed right so I can run it, and hence get this reCaptcha thng to install and work!

[davewest]

Things I must figure out in above code:

1. The $group_id variable is just the next available sort order, which is pulled from the SQL command mysql_insert_id()... how do I represent it in the SQL code properly? It's used in several places and I need to know how to write that properly in SQL.

2. In the last INSERT statement, we have one of the fields as the following: 'zen_cfg_select_option(array(\"red\", \"white\", \"blackglass\", \"clean\"),' -- MY QUESTION: Do I need to use the escape \ there or do I use double-single quotes to make it the right SQL syntax? Also, what about that loan ( before array, do I need to escape that so SQL doesn't think it has to do with my query string (it's just a part of what needs to be written in that field)?

3. In the last INSERT statement, I assume the use of the SQL function now() is indeed correct, right?

Group ID is auto assigned when first created only, then is used for each configuration assigned to that group.

''clean'' is correct for sql.

now() is the sql date/time setting and is correct.

To understand the insert better, configuration database has 11 slots, each one needs something inserted into it.
(configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)

Some of these fields are required and others may or may not be used, but need something, thus NULL.

In sort... sql statements are not to hard to do once you look at the table... But, one slip of a key and you can wipe out your database.... so BACK IT UP before doing anything!!!

The following is what you was asking for, please understand, this may work for you or not! This is not part of a mod, but just answering a question. Use at your own rest!!!

INSERT INTO configuration_group VALUES ('', 'reCAPTCHA', 'Config options for reCAPTCHA text', '1', '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();
SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4 
FROM configuration_group
WHERE configuration_group_title= 'reCAPTCHA';
INSERT INTO configuration VALUES 
('', 'Enable Contact Form', 'CONTACT_US_RECAPTCHA_STATUS', 'true', 'Disply reCAPTCHA text on contact form (default: true)', @t4, '1', now(), now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('', 'reCAPTCHA Public Key', 'CONTACT_US_RECAPTCHA_PUBLIC_KEY', '', 'Public key given from reCAPTCHA website (default: blank).', @t4, '2', now(), now(), NULL, NULL),
('', 'reCAPTCHA Private Key', 'CONTACT_US_RECAPTCHA_PRIVATE_KEY', '', 'Private key given from reCAPTCHA website (default: blank).', @t4, '3', now(), now(), NULL, NULL),
('', 'reCAPTCHA Theme', 'CONTACT_US_RECAPTCHA_THEME', 'white', 'Choose a theme option for the widget.', @t4, '4', now(), now(), NULL, 'zen_cfg_select_option(array(''red'', ''white'', ''blackglass'', ''clean''),');

Seems like allot of work just to have it on your 'contact us' page. You could copy the first line, change it to do other pages as well!! Short Order is the number of entree's so one through total number of lines.

('', 'Enable Ask-a-Question Form', 'ASK_A_QUESTION_RECAPTCHA_STATUS', 'true', 'Disply reCAPTCHA text on Ask-a-Question form (default: true)', @t4, '5', now(), now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),

[davemehta]

Thanks so much Davewest!!! That SQL did the trick :-)

Just a couple of notes for those of you wanting to use this in the future:

1. Run the SQL code provided by Davewest above to get the reCaptcha code to show up in the admin. Note that you must add the prefix "zen_" to the table names "configuration_group" and "configuration" in order for the statement to work properly (if you have that prefix on your tables).

2. The file "tpl_contact_us_default.php" provided in the custom templates folder is actually NOT in the right place... it writes that file to the "includes/templates/YOURTEMPLATE/" folder... when it should really go in the "includes/templates/YOURTEMPLATE/templates" folder. I just cut and paste the appropriate reCaptcha code into my customized contact_us template and was all set.

[kinget]

Sorry, I'm a bit confused by the code. I too tried to install this module and couldn't get it to work. In fact, I couldn't get any of the captcha modules to work. Can a easy to understand, step by step instruction be provided to install this module correctly? It would be a big help.

Thanks always for the wonderful support on this forum.

Thanks so much Davewest!!! That SQL did the trick :-)

Just a couple of notes for those of you wanting to use this in the future:

1. Run the SQL code provided by Davewest above to get the reCaptcha code to show up in the admin. Note that you must add the prefix "zen_" to the table names "configuration_group" and "configuration" in order for the statement to work properly (if you have that prefix on your tables).

2. The file "tpl_contact_us_default.php" provided in the custom templates folder is actually NOT in the right place... it writes that file to the "includes/templates/YOURTEMPLATE/" folder... when it should really go in the "includes/templates/YOURTEMPLATE/templates" folder. I just cut and paste the appropriate reCaptcha code into my customized contact_us template and was all set.