Testimonial Manager Support Thread

[desamothrace]

I apologize. I should have looked at the thread title, but I'm following the link listed in your attachments.

**runs to find the right thread**

Thanks,
Jen

[clydejones]

I apologize. I should have looked at the thread title, but I'm following the link listed in your attachments.

**runs to find the right thread**

Thanks,
Jen

Try here!

[BlessIsaacola]

Clyde,

Is it possible to provide support for "Restrict testimonial submissions to registered customers only" in future release? This is another option to restrict bogus testimonials without using capcha.

Thanks for the great mod.

The testimonial manager from Nicholas (zencartbuilder.com) supports this feature but he's no longer around. I do have a copy of it that we purchased in 2006 if that will help.

[clydejones]

Clyde,

Is it possible to provide support for "Restrict testimonial submissions to registered customers only" in future release? This is another option to restrict bogus testimonials without using capcha.

Thanks for the great mod.

The testimonial manager from Nicholas (zencartbuilder.com) supports this feature but he's no longer around. I do have a copy of it that we purchased in 2006 if that will help.

Already possible (since at least version 1.4.4), check admin -> configuration -> testimonial manager -> Only registered customers may submit a testimonial

[BlessIsaacola]

Already possible (since at least version 1.4.4), check admin -> configuration -> testimonial manager -> Only registered customers may submit a testimonial

Somehow, I am missing that configuration options. Is it safe to run this upgrade SQL again (or is going to wipe out all testimonials already in the database)?

#Testimonials Manager upgrade SQL
# For Zen-Cart 1.3.8
# Last Updated: 3/26/2008
# For best results, run this sql patch using the Zen-Cart Sql Patches tool
# (admin -> tools -> install sql patches)
# Cut-and-paste the code into the query field and press 'Send.
# New configuration options are added to the zen_configuration table.


SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id 
FROM configuration_group
WHERE configuration_group_title= 'Testimonials Manager'
LIMIT 1;

DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration WHERE configuration_key = 'DEFINE_TESTIMONIAL_STATUS';
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id;

INSERT INTO configuration_group VALUES (NULL, 'Testimonials Manager', 'Testimonials Manager Display Settings', '1', '1');
SET @configuration_group_id=last_insert_id();
UPDATE configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id;

INSERT INTO configuration VALUES (NULL, 'Number Of Testimonials to display in Latest Testimonials box', 'MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES', '5', 'Set the number of testimonials to display in the Latest Testimonials box.', @configuration_group_id, 1, NULL, now(), NULL, NULL);

INSERT INTO configuration VALUES (NULL, 'Testimonial Title Minimum Length', 'ENTRY_TESTIMONIALS_TITLE_MIN_LENGTH', '2', 'Minimum length of link title.', @configuration_group_id, 2, NULL, now(), NULL, NULL), (NULL, 'Testimonial Text Minimum Length', 'ENTRY_TESTIMONIALS_TEXT_MIN_LENGTH', '10', 'Minimum length of link description.', @configuration_group_id, 3, NULL, now(), NULL, NULL), (NULL, 'Testimonial Contact Name Minimum Length', 'ENTRY_TESTIMONIALS_CONTACT_NAME_MIN_LENGTH', '2', 'Minimum length of link contact name.', @configuration_group_id, 4, NULL, now(), NULL, NULL);

INSERT INTO configuration VALUES (NULL, 'Display Truncated Testimonials in Sidebox', 'DISPLAY_TESTIMONIALS_MANAGER_TRUNCATED_TEXT', 'true', 'Display truncated text in sidebox', @configuration_group_id, 5, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

INSERT INTO configuration VALUES (NULL, 'Length of truncated testimonials to display', 'TESTIMONIALS_MANAGER_DESCRIPTION_LENGTH', '150', 'If Display Truncated Testimonials in Sidebox is true - set the amount of characters to display from the Testimonials in the Testimonials Manager sidebox.', @configuration_group_id, 6, NULL, now(), NULL, NULL);

INSERT INTO configuration VALUES (NULL, 'Number Of Testimonials to display on all testimonials page', 'MAX_DISPLAY_TESTIMONIALS_MANAGER_ALL_TESTIMONIALS', '5', 'Set the number of testimonials to display on the all testimonials page.', @configuration_group_id, 7, NULL, now(), NULL, NULL);

INSERT INTO configuration VALUES (NULL, 'Display Date Published on Testimonials page', 'DISPLAY_TESTIMONIALS_DATE_PUBLISHED', 'true', 'Display date published on testimonials page', @configuration_group_id, 8, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

INSERT INTO configuration VALUES (NULL, 'Display View All Testimonials Link In Sidebox', 'DISPLAY_ALL_TESTIMONIALS_TESTIMONIALS_MANAGER_LINK', 'true', 'Display View All Testimonials Link In Sidebox', @configuration_group_id, 9, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (NULL, 'Display Add New Testimonial Link In Sidebox', 'DISPLAY_ADD_TESTIMONIAL_LINK', 'true', 'Display Add New Testimonial Link In Sidebox', @configuration_group_id, 10, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (NULL, 'Testimonial Image Width', 'TESTIMONIAL_IMAGE_WIDTH', '80', 'Set the Width of the Testimonial Image', @configuration_group_id, 11, NULL, '2007-08-21 12:04:10', NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Testimonial Image Height', 'TESTIMONIAL_IMAGE_HEIGHT', '80', 'Set the Height of the Testimonial Image', @configuration_group_id, 12, NULL, '2007-08-21 12:04:10', NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Testimonial Image Directory', 'TESTIMONIAL_IMAGE_DIRECTORY', 'testimonials/', 'Set the Directory for the Testimonial Image', @configuration_group_id, 13, NULL, '2007-08-21 12:04:10', NULL, NULL);
 
INSERT INTO `configuration` VALUES (NULL, 'Display Company Name field', 'TESTIMONIALS_COMPANY', 'true', 'Display Company Name field', @configuration_group_id, 14, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (NULL, 'Display City field', 'TESTIMONIALS_CITY', 'true', 'Display City field', @configuration_group_id, 15, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (NULL, 'Display Country field', 'TESTIMONIALS_COUNTRY', 'true', 'Display Country field', @configuration_group_id, 16, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

INSERT INTO configuration VALUES (NULL, 'Only registered customers may submit a testimonial', 'REGISTERED_TESTIMONIAL', 'true', 'Only registered customers may submit a testimonial', @configuration_group_id, 17, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (NULL, 'Define Testimonial', 'DEFINE_TESTIMONIAL_STATUS', '1', 'Enable the Defined Testimonial Link/Text?<br />0= Link ON, Define Text OFF<br />1= Link ON, Define Text ON<br />2= Link OFF, Define Text ON<br />3= Link OFF, Define Text OFF', 25, 999, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1'', ''2'', ''3''),');

INSERT INTO `configuration` VALUES (NULL, 'Product option type Select', 'PRODUCTS_OPTIONS_TYPE_SELECT', '0', 'The number representing the Select type of product option.', 0, NULL, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Upload prefix', 'UPLOAD_PREFIX', 'upload_', 'Prefix used to differentiate between upload options and other options', 0, NULL, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Text prefix', 'TEXT_PREFIX', 'txt_', 'Prefix used to differentiate between text option values and other option values', 0, NULL, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Image Handler Version', 'IH_VERSION', '2.0', 'This is used by image handler to check if the database is up to date with uploaded image handler files.', 0, 100, NULL, now(), NULL, 'zen_cfg_textarea_small(');

ALTER TABLE `testimonials_manager` ADD `language_id` INT( 11 ) NOT NULL DEFAULT '0' AFTER `testimonials_id` ;
UPDATE `testimonials_manager` SET `language_id` = '1' WHERE `language_id` =0 ;

[clydejones]

Somehow, I am missing that configuration options. Is it safe to run this upgrade SQL again (or is going to wipe out all testimonials already in the database)?

#Testimonials Manager upgrade SQL
# For Zen-Cart 1.3.8
# Last Updated: 3/26/2008
# For best results, run this sql patch using the Zen-Cart Sql Patches tool
# (admin -> tools -> install sql patches)
# Cut-and-paste the code into the query field and press 'Send.
# New configuration options are added to the zen_configuration table.


SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id 
FROM configuration_group
WHERE configuration_group_title= 'Testimonials Manager'
LIMIT 1;

DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration WHERE configuration_key = 'DEFINE_TESTIMONIAL_STATUS';
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id;

INSERT INTO configuration_group VALUES (NULL, 'Testimonials Manager', 'Testimonials Manager Display Settings', '1', '1');
SET @configuration_group_id=last_insert_id();
UPDATE configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id;

INSERT INTO configuration VALUES (NULL, 'Number Of Testimonials to display in Latest Testimonials box', 'MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES', '5', 'Set the number of testimonials to display in the Latest Testimonials box.', @configuration_group_id, 1, NULL, now(), NULL, NULL);

INSERT INTO configuration VALUES (NULL, 'Testimonial Title Minimum Length', 'ENTRY_TESTIMONIALS_TITLE_MIN_LENGTH', '2', 'Minimum length of link title.', @configuration_group_id, 2, NULL, now(), NULL, NULL), (NULL, 'Testimonial Text Minimum Length', 'ENTRY_TESTIMONIALS_TEXT_MIN_LENGTH', '10', 'Minimum length of link description.', @configuration_group_id, 3, NULL, now(), NULL, NULL), (NULL, 'Testimonial Contact Name Minimum Length', 'ENTRY_TESTIMONIALS_CONTACT_NAME_MIN_LENGTH', '2', 'Minimum length of link contact name.', @configuration_group_id, 4, NULL, now(), NULL, NULL);

INSERT INTO configuration VALUES (NULL, 'Display Truncated Testimonials in Sidebox', 'DISPLAY_TESTIMONIALS_MANAGER_TRUNCATED_TEXT', 'true', 'Display truncated text in sidebox', @configuration_group_id, 5, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

INSERT INTO configuration VALUES (NULL, 'Length of truncated testimonials to display', 'TESTIMONIALS_MANAGER_DESCRIPTION_LENGTH', '150', 'If Display Truncated Testimonials in Sidebox is true - set the amount of characters to display from the Testimonials in the Testimonials Manager sidebox.', @configuration_group_id, 6, NULL, now(), NULL, NULL);

INSERT INTO configuration VALUES (NULL, 'Number Of Testimonials to display on all testimonials page', 'MAX_DISPLAY_TESTIMONIALS_MANAGER_ALL_TESTIMONIALS', '5', 'Set the number of testimonials to display on the all testimonials page.', @configuration_group_id, 7, NULL, now(), NULL, NULL);

INSERT INTO configuration VALUES (NULL, 'Display Date Published on Testimonials page', 'DISPLAY_TESTIMONIALS_DATE_PUBLISHED', 'true', 'Display date published on testimonials page', @configuration_group_id, 8, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

INSERT INTO configuration VALUES (NULL, 'Display View All Testimonials Link In Sidebox', 'DISPLAY_ALL_TESTIMONIALS_TESTIMONIALS_MANAGER_LINK', 'true', 'Display View All Testimonials Link In Sidebox', @configuration_group_id, 9, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (NULL, 'Display Add New Testimonial Link In Sidebox', 'DISPLAY_ADD_TESTIMONIAL_LINK', 'true', 'Display Add New Testimonial Link In Sidebox', @configuration_group_id, 10, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (NULL, 'Testimonial Image Width', 'TESTIMONIAL_IMAGE_WIDTH', '80', 'Set the Width of the Testimonial Image', @configuration_group_id, 11, NULL, '2007-08-21 12:04:10', NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Testimonial Image Height', 'TESTIMONIAL_IMAGE_HEIGHT', '80', 'Set the Height of the Testimonial Image', @configuration_group_id, 12, NULL, '2007-08-21 12:04:10', NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Testimonial Image Directory', 'TESTIMONIAL_IMAGE_DIRECTORY', 'testimonials/', 'Set the Directory for the Testimonial Image', @configuration_group_id, 13, NULL, '2007-08-21 12:04:10', NULL, NULL);
 
INSERT INTO `configuration` VALUES (NULL, 'Display Company Name field', 'TESTIMONIALS_COMPANY', 'true', 'Display Company Name field', @configuration_group_id, 14, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (NULL, 'Display City field', 'TESTIMONIALS_CITY', 'true', 'Display City field', @configuration_group_id, 15, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (NULL, 'Display Country field', 'TESTIMONIALS_COUNTRY', 'true', 'Display Country field', @configuration_group_id, 16, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

INSERT INTO configuration VALUES (NULL, 'Only registered customers may submit a testimonial', 'REGISTERED_TESTIMONIAL', 'true', 'Only registered customers may submit a testimonial', @configuration_group_id, 17, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (NULL, 'Define Testimonial', 'DEFINE_TESTIMONIAL_STATUS', '1', 'Enable the Defined Testimonial Link/Text?<br />0= Link ON, Define Text OFF<br />1= Link ON, Define Text ON<br />2= Link OFF, Define Text ON<br />3= Link OFF, Define Text OFF', 25, 999, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1'', ''2'', ''3''),');

INSERT INTO `configuration` VALUES (NULL, 'Product option type Select', 'PRODUCTS_OPTIONS_TYPE_SELECT', '0', 'The number representing the Select type of product option.', 0, NULL, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Upload prefix', 'UPLOAD_PREFIX', 'upload_', 'Prefix used to differentiate between upload options and other options', 0, NULL, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Text prefix', 'TEXT_PREFIX', 'txt_', 'Prefix used to differentiate between text option values and other option values', 0, NULL, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Image Handler Version', 'IH_VERSION', '2.0', 'This is used by image handler to check if the database is up to date with uploaded image handler files.', 0, 100, NULL, now(), NULL, 'zen_cfg_textarea_small(');

ALTER TABLE `testimonials_manager` ADD `language_id` INT( 11 ) NOT NULL DEFAULT '0' AFTER `testimonials_id` ;
UPDATE `testimonials_manager` SET `language_id` = '1' WHERE `language_id` =0 ;

no problem with running the upgrade sql.

It only updates the testimonial manager configuration table, it won't delete any of the information already in the database.

[clydejones]

Version 1.5.0 of Testimonial Manager is now available in the downloads section

Updated to provide better accessibility for those who use assistive devices or text-only browsers.

Testimonial Manager admin options:
NEW * Testimonial Text Maximum Length
NEW * Testimonial - Show Store Name and Address

And for those using captcha here's the 1.5 fix.

Please note: this will work only with version 1.5.0 of Testimonial Manager.

Make sure you have the captcha Mod Installed

Upgrade to the 1.5.0 version of Testimonial Manager.

Unzip the file, Rename the YOUR_TEMPLATE folder to match the name of your custom template, upload the entire includes folder to your server.

Attachment 5155

[nagelkruid]

Hello Clyde,
I have just upgraded smoothly, cheers.
Only 2 things i don't get:

- on error, there is no $testimonials_title or $testimonials_html_text in the tpl_testimonials_add_default.php defined so if an error occurs those fields need to be retyped.
Is there a specific reason to choose so? (i found adding those works out just fine?)

- in the testimonials_add.css there are entries to background url *.png but those do not exist. Did i miss something in the primary install or are those entries in error?

Thanks,
Jeroen

[stride-r]

I just downloaded and installed Testimonials Manager today - works like a charm but i found an error in the "install_testimonials_manager.txt" instructional file.

Under the Metatags section, there appears to be a missing line that was generating an error for me. I found the missing line which was in an earlier post in the forum. The above mentioned file was missing this:

    $testimonial_title = 'Testimonial - '; 

Please click here for the correct and complete metatag code.

[clydejones]

Hello Clyde,
I have just upgraded smoothly, cheers.
Only 2 things i don't get:

- on error, there is no $testimonials_title or $testimonials_html_text in the tpl_testimonials_add_default.php defined so if an error occurs those fields need to be retyped.
Is there a specific reason to choose so? (i found adding those works out just fine?)

- in the testimonials_add.css there are entries to background url *.png but those do not exist. Did i miss something in the primary install or are those entries in error?

Thanks,
Jeroen

For version 1.5.0 (the most recent)

1. Here's the section from tpl_testimonials_add_default.php for those two section (lines 94 - 111)

<li>
<label class="inputLabel" for="testimonials_title"><?php echo (($error == true && $entry_title_error == true) ? TEXT_TESTIMONIALS_TITLE . zen_image($template->get_template_dir(RETURN_WARNING_IMAGE, DIR_WS_TEMPLATE, $current_page_base,'images'). '/' . RETURN_WARNING_IMAGE, RETURN_WARNING_IMAGE_ALT, RETURN_WARNING_IMAGE_WIDTH, RETURN_WARNING_IMAGE_HEIGHT) : TEXT_TESTIMONIALS_TITLE . zen_image($template->get_template_dir(RETURN_REQUIRED_IMAGE, DIR_WS_TEMPLATE, $current_page_base,'images'). '/' . RETURN_REQUIRED_IMAGE, RETURN_REQUIRED_IMAGE_ALT, RETURN_REQUIRED_IMAGE_WIDTH, RETURN_REQUIRED_IMAGE_HEIGHT)); ?></label>
<?php echo (($error == true && $entry_title_error == true) ? zen_draw_input_field('testimonials_title', '', 'size="25" id="testimonials_title"') . ERROR_TESTIMONIALS_TITLE_REQUIRED : zen_draw_input_field('testimonials_title', '', 'size="25" id="testimonials_title"')); ?>
</li>
<?php echo TEXT_TESTIMONIALS_DESCRIPTION_INFO ; ?>
<?php if ($error == true && $entry_description_error == true) { ?>
<li>
<label class="inputLabel" for="testimonials_html_text"><?php echo TEXT_TESTIMONIALS_DESCRIPTION . zen_image($template->get_template_dir(RETURN_WARNING_IMAGE, DIR_WS_TEMPLATE, $current_page_base,'images'). '/' . RETURN_WARNING_IMAGE, RETURN_WARNING_IMAGE_ALT, RETURN_WARNING_IMAGE_WIDTH, RETURN_WARNING_IMAGE_HEIGHT); ?></label>
<?php echo zen_draw_textarea_field('testimonials_html_text', '30', '7', '', 'id="testimonials_html_text"') . ERROR_TESTIMONIALS_DESCRIPTION_REQUIRED; ?>
</li>
<?php } else {  ?>
<?php if ($error == true && $entry_description_big_error == true) { ?>
<li>
<label class="inputLabel" for="testimonials_html_text"><?php echo TEXT_TESTIMONIALS_DESCRIPTION . zen_image($template->get_template_dir(RETURN_WARNING_IMAGE, DIR_WS_TEMPLATE, $current_page_base,'images'). '/' . RETURN_WARNING_IMAGE, RETURN_WARNING_IMAGE_ALT, RETURN_WARNING_IMAGE_WIDTH, RETURN_WARNING_IMAGE_HEIGHT); ?></label>
<?php echo zen_draw_textarea_field('testimonials_html_text', '30', '7', '', 'id="testimonials_html_text"') . ERROR_TESTIMONIALS_TEXT_MAX_LENGTH; ?>
</li>
<?php } else {  ?>
<li>
<label class="inputLabel" for="testimonials_html_text"><?php echo TEXT_TESTIMONIALS_DESCRIPTION . zen_image($template->get_template_dir(RETURN_REQUIRED_IMAGE, DIR_WS_TEMPLATE, $current_page_base,'images'). '/' . RETURN_REQUIRED_IMAGE, RETURN_REQUIRED_IMAGE_ALT, RETURN_REQUIRED_IMAGE_WIDTH, RETURN_REQUIRED_IMAGE_HEIGHT); ?></label>
<?php echo zen_draw_textarea_field('testimonials_html_text', '30', '7', '', 'id="testimonials_html_text"'); ?>
</li>
<?php } 
}
?>

2. This is the css for testimonials_add.css see no references to background url *.png's

fieldset {
	padding: 0.5em;
	margin: 0.5em 0;
	display:block;
	border:1px solid #000;
}
fieldset ol {  
padding: .5em .5em 0 .5em;  
list-style: none;
}
fieldset li {  
padding-bottom: .5em;
}
fieldset #personal, fieldset #order, fieldset #write{
	padding:0;
	border:1px solid #000;
	border-width: 1px 0 1px 0;
}
legend {
	padding: 0.3em;
	font-size: 1.1em;
	color: #000;
	font-weight:bold;
}
select {
	margin: 0.1em;
}
textarea {
margin: auto;
padding:0.5em;
display: inline;
width: 40%;
border:1px solid #B6ABD5;
overflow:auto;
}
label.inputLabel {
	width: 11em;
	float: left;
	color: #000;
	}