Testimonial Manager Support Thread

[clydejones]

Thanks for creating and sharing this really useful module. It installed fine, first time.

One thing I can't figure out though ...

How would a person substitute an image for the heading in the Testimonial Manager sidebox ? (TM 1.4.5 on ZC 1.3.8).

I've experimented along the lines of this tutorial ...
http://www.www.zen-cart.com/tutorial...hp?article=135
... to no avail ... and I have visited many of the testimonial_manager phps ... ... just can't figure out what to do and where ...

Thanks if anyone can help.

Follow the instructions in the tutorial but look first in:

includes/languages/english/extra_definitions/YOUR_TEMPLATE/testimonials_manager_defines.php

find:

define('BOX_HEADING_TESTIMONIALS_MANAGER', 'Testimonials');
and follow the instrucitons for changing this to your image.

Now open
includes/modules/sideboxes/YOUR_TEMPLATE/testimonials_manager.php

follow the instructions for changing the

$title = BOX_HEADING_TESTIMONIALS_MANAGER;

If you prefer the last option in the tutorial then

You would follow the instructions for creating an image and then adding the following to your stylesheet.css

#testimonials-managerHeading {
margin: 0em;
background: url(../images/your_background_image.jpg) #ff6699;
padding: 0.5em 0.2em;
}

Hope this helps

[clydejones]

Thanks, this was very helpful.

This is my first MOD install, so I have a bit of anxiety as I have a rather large product database (yes, I did backup).

I have made an over-ride directory (Magic). So, the code:
includes/languages/english/extra_definitions/YOUR_TEMPLATE
includes/languages/english/YOUR_TEMPLATE
includes/languages/english/html_includes/YOUR_TEMPLATE
includes/modules/sideboxes/YOUR_TEMPLATE
includes/templates/YOUR_TEMPLATE


I think I would change to :
includes/languages/english/classic/extra_definitions/magic
includes/languages/english/classic/magic
includes/languages/english/classic/html_includes/magic
includes/modules/sideboxes/classic/magic
includes/templates/classic/magic

??

Or do I need to be AT the same level as "classic"?

These would be your directories

includes/languages/english/extra_definitions/magic
includes/languages/english/magic
includes/languages/english/html_includes/magic
includes/modules/sideboxes/magic
includes/templates/magic

[kevinmc3]

Thanks, I'm getting SQL errors, I think I am going to post for expert help, before I mess things up.
Kevin

[clydejones]

Thanks, I'm getting SQL errors, I think I am going to post for expert help, before I mess things up.
Kevin

What errors are you getting?

Since I wrote the mod I can probably help.

[kevinmc3]

Here is the error:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'includes/languages/english/extra_definitions/magic includes/languages/english/ma' at line 1
in:
[includes/languages/english/extra_definitions/magic includes/languages/english/magic includes/languages/english/html_includes/magic includes/modules/sideboxes/magic includes/templates/magic ;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

[clydejones]

Here is the error:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'includes/languages/english/extra_definitions/magic includes/languages/english/ma' at line 1
in:
[includes/languages/english/extra_definitions/magic includes/languages/english/magic includes/languages/english/html_includes/magic includes/modules/sideboxes/magic includes/templates/magic ;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

What is the sql statement you are entering that is causing this error?

The only sql statement you would enter from admin -> tools -> install sql patches is this one:

#Testimonials Manager v1.4.4 upgrade SQL
# For Zen-Cart 1.3.7
# Last Updated: 10/16/2007
# run this sql patch using the Zen-Cart Sql Patches tool
# (admin -> tools -> install sql patches)
# New configuration options are added to the zen_configuration table.
# For best results, cut-and-paste the code into the query field and press 'Send' instead.



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(');

DROP TABLE IF EXISTS testimonials_manager;
CREATE TABLE testimonials_manager (
  `testimonials_id` int(11) NOT NULL auto_increment,
  `language_id` int(11) NOT NULL default '0',
  `testimonials_title` varchar(64) NOT NULL default '',
  `testimonials_url`  VARCHAR( 255 ) NULL DEFAULT NULL,
  `testimonials_name` text NOT NULL,
  `testimonials_image` varchar(254) NOT NULL default '',
  `testimonials_html_text` text,
  `testimonials_mail` text NOT NULL,
  `testimonials_company` VARCHAR( 255 ) NULL DEFAULT NULL,
  `testimonials_city` VARCHAR( 255 ) NULL DEFAULT NULL,
  `testimonials_country` VARCHAR( 255 ) NULL DEFAULT NULL,
  `testimonials_show_email` char(1) default '0',
  `status` int(1) NOT NULL default '0',
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_update` datetime NULL default NULL,
  PRIMARY KEY  (`testimonials_id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

INSERT INTO `testimonials_manager` VALUES (1, 1, 'Great', '', 'Clyde\'s Test Site', '', 'This is just a test submission to show you how it looks, great, eh?', '[email protected]', NULL, NULL, NULL, 0, 1, now(), NULL);

[kevinmc3]

I was folwoign the install.txt file below:

File Modifications:

Add the following declarations to your stylesheet.css.

.testimonial {
color: #000;
padding: 0 5px 5px 5px;
text-align:left;
}
.testimonial p {
margin: 0; padding: 5px 0;
}
.testimonial span {
float:right;
}

========================================================

Database Modifications:

A new database table needs to be created to store your testimonial items.
New configuration options are added to the zen_configuration table.

========================================================

NEW INSTALLATION:

Unzip the contribution.

Open the New_installation folder

run the included install_testimonials_manager.sql using the Zen-Cart Sql Patches tool
(admin -> tools -> install sql patches)
For best results, cut-and-paste the code into the query field and press 'Send'.

Before uploading change the YOUR_TEMPLATE directories to match the name of your custom directory.
includes/languages/english/extra_definitions/YOUR_TEMPLATE
includes/languages/english/YOUR_TEMPLATE
includes/languages/english/html_includes/YOUR_TEMPLATE
includes/modules/sideboxes/YOUR_TEMPLATE
includes/templates/YOUR_TEMPLATE

The files are arranged in the same structure as Zen Cart so you can FTP the admin and includes directories to your server.

Login in to your admin panel admin -> tools -> layout boxes contoller and activate the new sidebox.


So, instead I add the code you just gave me into the box:
Enter the query
to be executed:

The I was entering into the upload file at the same time:
install_testimonials_manager.sql

[baja123]

Oh yeah, spot on, poifect ! Now all I need to do is add a Testimonial to your zenlike goodness, poise and clarity of explanation ... Thanx heaps Clyde!

[clydejones]

I was folwoign the install.txt file below:

File Modifications:

Add the following declarations to your stylesheet.css.

.testimonial {
color: #000;
padding: 0 5px 5px 5px;
text-align:left;
}
.testimonial p {
margin: 0; padding: 5px 0;
}
.testimonial span {
float:right;
}

========================================================

Database Modifications:

A new database table needs to be created to store your testimonial items.
New configuration options are added to the zen_configuration table.

========================================================

NEW INSTALLATION:

Unzip the contribution.

Open the New_installation folder

run the included install_testimonials_manager.sql using the Zen-Cart Sql Patches tool
(admin -> tools -> install sql patches)
For best results, cut-and-paste the code into the query field and press 'Send'.

Before uploading change the YOUR_TEMPLATE directories to match the name of your custom directory.
includes/languages/english/extra_definitions/YOUR_TEMPLATE
includes/languages/english/YOUR_TEMPLATE
includes/languages/english/html_includes/YOUR_TEMPLATE
includes/modules/sideboxes/YOUR_TEMPLATE
includes/templates/YOUR_TEMPLATE

The files are arranged in the same structure as Zen Cart so you can FTP the admin and includes directories to your server.

Login in to your admin panel admin -> tools -> layout boxes contoller and activate the new sidebox.


So, instead I add the code you just gave me into the box:
Enter the query
to be executed:

The I was entering into the upload file at the same time:
install_testimonials_manager.sql

Before uploading change the YOUR_TEMPLATE directories to match the name of your custom directory.
includes/languages/english/extra_definitions/YOUR_TEMPLATE
includes/languages/english/YOUR_TEMPLATE
includes/languages/english/html_includes/YOUR_TEMPLATE
includes/modules/sideboxes/YOUR_TEMPLATE
includes/templates/YOUR_TEMPLATE

The files are arranged in the same structure as Zen Cart so you can FTP the admin and includes directories to your server.

You would change the YOUR_TEMPLATE directories to magic.

includes/languages/english/classic/extra_definitions/magic
includes/languages/english/classic/magic
includes/languages/english/classic/html_includes/magic
includes/modules/sideboxes/classic/magic
includes/templates/classic/magic

Now you upload/FTP the admin and includes directories to your server.

These DO NOT get included in the sql.

admin -> tools -> install sql patches
does not upload files to your server it only runs sql statements in order to change the database.

[clydejones]

Oh yeah, spot on, poifect ! Now all I need to do is add a Testimonial to your zenlike goodness, poise and clarity of explanation ... Thanx heaps Clyde!

glad to help