Adding reCAPTCHA to Contact Us Form

[spid3r1987]

never mind, followed some instructions, and it worked

[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!