Testimonial Manager Support Thread (for ZC v1.5.x)

you notify them by making the necessary changes, and submit an updated version

Quote:

---

Originally Posted by grantopt

So I assume this all can be deleted as it is not supposed to be here?

Code:

---

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

---

I went back to the plugins section and downloaded a fresh copy of the v1.5.4. Checking the uninstall.sql, the same 4 inserts were present. I then figured I would check other uploaded versions. I downloaded the latest v1.5.5 and 2 other older versions v1.5.3d and v 1.5.2. To my surprise, ALL of them have these same 4 inserts.

To help others who may do a uninstall how do I notify the zencart team that the uploaded uninstall.sql needs to be changed?

---

Quote:

---

Originally Posted by grantopt

So I assume this all can be deleted as it is not supposed to be here?

Code:

---

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

---

I went back to the plugins section and downloaded a fresh copy of the v1.5.4. Checking the uninstall.sql, the same 4 inserts were present. I then figured I would check other uploaded versions. I downloaded the latest v1.5.5 and 2 other older versions v1.5.3d and v 1.5.2. To my surprise, ALL of them have these same 4 inserts.

To help others who may do a uninstall how do I notify the zencart team that the uploaded uninstall.sql needs to be changed?

---

The extra inserts resolve a potential problem of running the uninstall as it currently is programmmed. If on uninstall the 'Testimonials Manager' group is not found, then the configuration_id will be set to zero. Then when the delete is run, those values will be removed. (IH4 also installs at that location.) Ideally the deletions would include a statement in the WHERE clause that the configuration_id (or if I used the wrong spelling.) !=0

This is something that has been reported as a potential issue. Again though the fix was to restore the four known items that could get deleted, rather than prevent the deletion in the first place.

In regards to "letting the ZC Team" know about an update, well, easy to do. Make the changes, then upload the change to the forum, explain in the documentation why the change was made, how to install it, what file(s) changed, etc... And the ZC staff will be notified to activate the change, which will happen after a review.

Well how about this.. those extra inserts are the WRONG SOLUTION to the problem.. the RIGHT SOLUTION is to FIX the uninstall SQL..

Quote:

---

Originally Posted by mc12345678

The extra inserts resolve a potential problem of running the uninstall as it currently is programmmed. If on uninstall the 'Testimonials Manager' group is not found, then the configuration_id will be set to zero. Then when the delete is run, those values will be removed. (IH4 also installs at that location.) Ideally the deletions would include a statement in the WHERE clause that the configuration_id (or if I used the wrong spelling.) !=0

This is something that has been reported as a potential issue. Again though the fix was to restore the four known items that could get deleted, rather than prevent the deletion in the first place.

In regards to "letting the ZC Team" know about an update, well, easy to do. Make the changes, then upload the change to the forum, explain in the documentation why the change was made, how to install it, what file(s) changed, etc... And the ZC staff will be notified to activate the change, which will happen after a review.

---

You do not want to remove these configuration_keys:
PRODUCTS_OPTIONS_TYPE_SELECT
UPLOAD_PREFIX
TEXT_PREFIX

Those are important to leave in your configuration table as they are used by Zen Cart, regardless of your add-ons ...

Quote:

---

Originally Posted by DivaVocals

Well how about this.. those extra inserts are the WRONG SOLUTION to the problem.. the RIGHT SOLUTION is to FIX the uninstall SQL..

---

Quote:

---

Originally Posted by Ajeh

You do not want to remove these configuration_keys:
PRODUCTS_OPTIONS_TYPE_SELECT
UPLOAD_PREFIX
TEXT_PREFIX

Those are important to leave in your configuration table as they are used by Zen Cart, regardless of your add-ons ...

---

*nodding in agreement* correctly repairing the uninstall.sql so that only data specifically associated with the install is deleted/modified, which means not to remove the three ZC default values and the one that is added by another plugin.

Just deleting the four inserts will not fully resolve the situation.

Quote:

---

Originally Posted by mc12345678

*nodding in agreement* correctly repairing the uninstall.sql so that only data specifically associated with the install is deleted/modified, which means not to remove the three ZC default values and the one that is added by another plugin.

Just deleting the four inserts will not fully resolve the situation.

---

and the actual solution is SOOOOOO simple.. Remove the 4 extra insert statements (it was NEVER the right solution..) then just remove this line:

Code:

---

SET @configuration_group_id=0;

---

and you are left with the RIGHT uninstall script..

Code:

---

#Testimonials Manager SQL Uninstall

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_group WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration WHERE configuration_key = 'DEFINE_TESTIMONIAL_STATUS';

DROP TABLE IF EXISTS `testimonials_manager`;

DELETE FROM admin_pages WHERE page_key = 'configTestimonialsManager' LIMIT 1;
DELETE FROM admin_pages WHERE page_key = 'TestimonialsManager' LIMIT 1;

---

Now if anyone wants to "notify the admin" by updating the package and submitting an update.. feel free..:smile:

Quote:

---

Originally Posted by DivaVocals

and the actual solution is SOOOOOO simple.. Remove the 4 extra insert statements (it was NEVER the right solution..) then just remove this line:

Code:

---

SET @configuration_group_id=0;

---

and you are left with the RIGHT uninstall script..

Code:

---

#Testimonials Manager SQL Uninstall

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 AND @configuration_group_id != 0;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id AND @configuration_group_id != 0;
DELETE FROM configuration WHERE configuration_key = 'DEFINE_TESTIMONIAL_STATUS';

DROP TABLE IF EXISTS `testimonials_manager`;

DELETE FROM admin_pages WHERE page_key = 'configTestimonialsManager' LIMIT 1;
DELETE FROM admin_pages WHERE page_key = 'TestimonialsManager' LIMIT 1;

---

Now if anyone wants to "notify the admin" by updating the package and submitting an update.. feel free..:smile:

---

Just a couple of minor updates, shown in red above.

Quote:

---

Originally Posted by lat9

Just a couple of minor updates, shown in red above.

---

HA! Good catch!!

Quote:

---

Originally Posted by DivaVocals

HA! Good catch!!

---

Yup.

Just a little explanation for those that may like to understand more:
That additional code will categorically prevent the need for the four inserts that were a part of the previous uninstall.sql and will prevent the deletion of the three values pointed out by ajeh.

As previously written if the @configuration_group_id wasn't present for the searched title, then it was possible that the return value would be 0, and the subsequent delete's would delete items having a value of 0 (at least the three identified by ajeh, and as well one value from the IH4 install and any other modified code that chose to use a configuration_group_id of 0) which would end up causing problems for the store if the first three were deleted.

I have this installed and i got a Install Success but it is not showing in the Layout Box Controller so I cant turn it on so it is not showing up on my site...any help would be welcome.

Installed on ZC 1.5.3. Uploaded all files and admin does not load then removed file from admin/include/auto_loaders and admin load.
See Testimonial Manager below Tools and Configuration but TM below Configuration does not have any fields or options to edit it load blank page?
Side box is appearing in layout controller and is on but on live site it shows "WARNING: An Error occurred, please refresh the page and try again." instead of testimonials and also footer does not appear. When I delete /includes/modules/sideboxes/template/testimonials_manager.php footer does appear.
Can you please assist how I can fix both of these issues?

Thank you!

Quote:

---

Originally Posted by jsarwar

Installed on ZC 1.5.3. Uploaded all files and admin does not load then removed file from admin/include/auto_loaders and admin load.
See Testimonial Manager below Tools and Configuration but TM below Configuration does not have any fields or options to edit it load blank page?
Side box is appearing in layout controller and is on but on live site it shows "WARNING: An Error occurred, please refresh the page and try again." instead of testimonials and also footer does not appear. When I delete /includes/modules/sideboxes/template/testimonials_manager.php footer does appear.
Can you please assist how I can fix both of these issues?

Thank you!

---

When you see "Warning: An Error occurred...", there's a myDEBUG*.log file present in your store's /logs directory that will have details of the error. You could post the contents of that log (making sure to xxx-out the name of your admin folder's name!).

Note also that the error is resulting in the remainder of the page not rendering; that's why you dno't see a footer.

Quote:

---

Originally Posted by lat9

When you see "Warning: An Error occurred...", there's a myDEBUG*.log file present in your store's /logs directory that will have details of the error. You could post the contents of that log (making sure to xxx-out the name of your admin folder's name!).

Note also that the error is resulting in the remainder of the page not rendering; that's why you dno't see a footer.

---

I was upgrading from 1.3.9 to 1.5.3 and 1.3 had older version of this module so probably that was reason but I just tried to install this module on fresh ZC 1.5.3 and as soon as I upload config.tm.php to admin//includes/auto_loaders admin page does not load and give error.

and when I turn on testimonial side box "WARNING: An Error occurred, please refresh the page and try again." still appear with no site footer.

How I can fix this and get modules installed?



Log error shows
[08-Jul-2014 12:26:40] PHP Fatal error: 1136:Column count doesn't match value count at row 1 :: INSERT INTO zen_configuration VALUES (NULL, 'Number Of Testimonials to display in Testimonials Sidebox', 'MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES', '5', 'Set the number of testimonials to display in the Latest Testimonials box.', '34', 1, NULL, now(), NULL, NULL) ==> (as called by) /home/suppgeek/public_html/dem/zcadmin/includes/init_includes/init_tm_config.php on line 82 <== in /home/suppgeek/public_html/dem/includes/classes/db/mysql/query_factory.php on line 155



I am using all files from module with out any change.
Thank you

Quote:

---

Originally Posted by jsarwar

I was upgrading from 1.3.9 to 1.5.3 and 1.3 had older version of this module so probably that was reason but I just tried to install this module on fresh ZC 1.5.3 and as soon as I upload config.tm.php to admin//includes/auto_loaders admin page does not load and give error.

and when I turn on testimonial side box "WARNING: An Error occurred, please refresh the page and try again." still appear with no site footer.

How I can fix this and get modules installed?



Log error shows
[08-Jul-2014 12:26:40] PHP Fatal error: 1136:Column count doesn't match value count at row 1 :: INSERT INTO zen_configuration VALUES (NULL, 'Number Of Testimonials to display in Testimonials Sidebox', 'MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES', '5', 'Set the number of testimonials to display in the Latest Testimonials box.', '34', 1, NULL, now(), NULL, NULL) ==>


I am using all files from module with out any change.
Thank you

---

Any one who can assist me with this?

Log error shows
[08-Jul-2014 12:26:40] PHP Fatal error: 1136:Column count doesn't match value count at row 1 :: INSERT INTO zen_configuration VALUES (NULL, 'Number Of Testimonials to display in Testimonials Sidebox', 'MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES', '5', 'Set the number of testimonials to display in the Latest Testimonials box.', '34', 1, NULL, now(), NULL, NULL) ==>

Thank you.

Quote:

---

Originally Posted by jsarwar

Any one who can assist me with this?

Log error shows
[08-Jul-2014 12:26:40] PHP Fatal error: 1136:Column count doesn't match value count at row 1 :: INSERT INTO zen_configuration VALUES (NULL, 'Number Of Testimonials to display in Testimonials Sidebox', 'MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES', '5', 'Set the number of testimonials to display in the Latest Testimonials box.', '34', 1, NULL, now(), NULL, NULL) ==>

Thank you.

---

You MAY have to wait for the plugins you want to be made compatible with 1.5.3. This is always the tricky part and the reason why I don't always recommend the sites I work on to move to the newest ones IF the mods they need are not compatible yet.

I did not want to upgrade yet but there are many nice modules now which are only compatible with 1.5 so trying to keep as much as possible of old modules as my customers are used to them and adding new to improve store. I am not sql expert and beginner to learn so if you have any knowledge of it please spend sometime to adjust this module files as there are some other modules which gives same error so I think if 1 get fixed, other should be quick. I am also talking with other folks and they are looking into this. You may download module from

http://www.zen-cart.com/downloads.php?do=file&id=299


Thank you.

Quote:

---

Originally Posted by jsarwar

I did not want to upgrade yet but there are many nice modules now which are only compatible with 1.5 so trying to keep as much as possible of old modules as my customers are used to them and adding new to improve store. I am not sql expert and beginner to learn so if you have any knowledge of it please spend sometime to adjust this module files as there are some other modules which gives same error so I think if 1 get fixed, other should be quick. I am also talking with other folks and they are looking into this. You may download module from

http://www.zen-cart.com/downloads.php?do=file&id=299


Thank you.

---

Having worked with jsarwar earlier today, a solution was found for the described problem at least as far as installing on ZC 1.5.0 because the error experienced appears to be SQL server related not so much ZC version; however, have not heard back if the same problem was occurring on ZC 1.5.3. Regardless a modified install and uninstall scripts are being uploaded as a patch to this plugin. Also looking through the forum to find any identified bugs that need to be incorporated.

Quote:

---

Originally Posted by jsarwar

Any one who can assist me with this?

Log error shows
[08-Jul-2014 12:26:40] PHP Fatal error: 1136:Column count doesn't match value count at row 1 :: INSERT INTO zen_configuration VALUES (NULL, 'Number Of Testimonials to display in Testimonials Sidebox', 'MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES', '5', 'Set the number of testimonials to display in the Latest Testimonials box.', '34', 1, NULL, now(), NULL, NULL) ==>

Thank you.

---

Not related to v1.5.3 AT ALL..

The issue is you have a Numinix module installed which adds an additional column to the configuration table. The Testimonials module uses a shortcut in the install SQL and does not explicitly name the table column names because it assumes the table structure has not changed.. hence the "missing column" error..

Quote:

---

Originally Posted by DivaVocals

Not related to v1.5.3 AT ALL..

The issue is you have a Numinix module installed which adds an additional column to the configuration table. The Testimonials module uses a shortcut in the install SQL and does not explicitly name the table column names because it assumes the table structure has not changed.. hence the "missing column" error..

---

Thank you so what need to be added to sql? Becuase if numinix module is installed that also goes under configuration and that's where Testimonial Manager goes. What is the column name numinix add?

Quote:

---

Originally Posted by jsarwar

Thank you so what need to be added to sql? Becuase if numinix module is installed that also goes under configuration and that's where Testimonial Manager goes.

---

Please re-read my post.. I state what's missing..

Quote:

---

Originally Posted by DivaVocals

Please re-read my post.. I state what's missing..

---

I read that but I am not good on sql so if you don't mind can you tell me what I need to type/put in for numinix column in sql to make it go through on my site?

Quote:

---

Originally Posted by jsarwar

I read that but I am not good on sql so if you don't mind can you tell me what I need to type/put in for numinix column in sql to make it go through on my site?

---

so... basically, you have more or less columns in the configuration table then data you are trying to fit in. Should only be 11 for the standard ZC Config table. I for one have no idea what you have in there... or why anyone would change it. makes upgrading ZC very hard to do. So, look at the table with phpmyadmin and see what the structure is and fill in the blank... this is the standard 11 column table..

(`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`)

You will have to fill in the blank at the same location it shows with in your config structure.. hopefully at the end... so 'set_function', NULL) you would have to figure out what goes there... NULL is just a common guess, a coma would get you there too.

What ever mod you install that adds to the configuration table may have the same issues so keep notes and be aware of it.

Quote:

---

Originally Posted by davewest

so... basically, you have more or less columns in the configuration table then data you are trying to fit in. Should only be 11 for the standard ZC Config table. I for one have no idea what you have in there... or why anyone would change it. makes upgrading ZC very hard to do. So, look at the table with phpmyadmin and see what the structure is and fill in the blank... this is the standard 11 column table..

(`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`)

You will have to fill in the blank at the same location it shows with in your config structure.. hopefully at the end... so 'set_function', NULL) you would have to figure out what goes there... NULL is just a common guess, a coma would get you there too.

What ever mod you install that adds to the configuration table may have the same issues so keep notes and be aware of it.

---

I will bet MONEY it's a Numinix module.. they are the ONLY mod devs that added a column to the configuration table to support their custom tabbed view of the configuration settings for their modules. The change makes an overall change to the look/feel of ALL the configuration menus not just their own.. However, only the Numinix modules explicitly use this tabbed view.. The Numinix mods aren't having issues at all.. only those module (like this one which use the shortcut SQL which omits the column names from the SQL script)

And before the question gets asked in response to your post "how do I add the columns back", Chad already posted a few threads back that he submitted an update..

Quote:

---

Originally Posted by DivaVocals

I will bet MONEY it's a Numinix module.. they are the ONLY mod devs that added a column to the configuration table to support their custom tabbed view of the configuration settings for their modules. The change makes an overall change to the look/feel of ALL the configuration menus not just their own.. However, only the Numinix modules explicitly use this tabbed view.. The Numinix mods aren't having issues at all.. only those module (like this one which use the shortcut SQL which omits the column names from the SQL script)

And before the question gets asked in response to your post "how do I add the columns back", Chad already posted a few threads back that he submitted an update..

---

The update is considered available for download. Like davewest suggested, the additional field(s) added to. The table are not addressed per se in the update, ie. If the other plugin(s) expect a value in that row, install of this plugin will assign whatever default value is expected and it is up to that other plugin(s) to correct/handle that default value.

Jsarwar has indicated that at least one numinix module was installed, but review of the provided sql (which does not include sql embedded in the code) did not show indication of modifying the table(s) that were preventing the installation. The change made removes the reliance on the number of columns and also allows certain fields to populate with default information. (Configuration_id for example) rather than guessing at the data type necessary (NULL or 0) to populate the field. It is therefore up to the table altering code to handle the new data that did not assign anything to the new field(s). This action would be expected of any plugin that modified core table fields in this way.

This is why numinix posted that sql updates to the databse should not be done blindly and should include the column names.

Quote:

---

Originally Posted by yaritai

This is why numinix posted that sql updates to the databse should not be done blindly and should include the column names.

---

Agreed:yes:; you never know when an additional field will be added to a table, whether by plugin or by Zen Cart upgrade.

Good day folks.

I tried to display testimonials at the footer, I've done this at the past but now I can't figure it out.

I guess I'm too old for this coding stuff already :D

Please kindly give me a hint how to do that

Thanks!!

How do I make the Testimonial Title field optional and delete it totally?

Quote:

---

Originally Posted by robbie269

How do I make the Testimonial Title field optional and delete it totally?

---

I believe the file to edit is:
/includes/modules/pages/testimonials_add/header_php.php

Quote:

---

Originally Posted by countrycharm

I believe the file to edit is:
/includes/modules/pages/testimonials_add/header_php.php

---

Thanks that did the trick.

Quote:

---

Originally Posted by robbie269

Thanks that did the trick.

---

No problem, glad to help.

I got a questionabout install 1.5.3d in zen-cart 1.54 .I'm a little confused as to what I may have done wrong about install

I was running 1.3.8a before with this module, no problems

I then upgraded my store to 1.5.4.only thing that was carried over from the old installation was the old testimonial database tables.......all php files are the new versions for 1.5.

I get the following security message:

"WARNING: An Error occurred, please refresh the page and try again."
When I remove all the files of TM, that error goes away but the module is not auto-installed.

Any idea what I could do in order to fix this problem?

I got the Debug log here:

[03-Feb-2015 03:44:51 America/New_York] PHP Fatal error: 1062: Duplicate entry 'DEFINE_TESTIMONIAL_STATUS' for key 'unq_config_key_zen' :: INSERT INTO zen_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Define Testimonial Status', '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', '42', 20, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1'', ''2'', ''3''),') ==> (as called by) /home/playscom/public_html/demo/admin/includes/init_includes/init_tm_config.php on line 121 <== in /home/playscom/public_html/demo/includes/classes/db/mysql/query_factory.php on line 155


Thank you

Quote:

---

Originally Posted by paranoia

I got a questionabout install 1.5.3d in zen-cart 1.54 .I'm a little confused as to what I may have done wrong about install

I was running 1.3.8a before with this module, no problems

I then upgraded my store to 1.5.4.only thing that was carried over from the old installation was the old testimonial database tables.......all php files are the new versions for 1.5.

I get the following security message:

"WARNING: An Error occurred, please refresh the page and try again."
When I remove all the files of TM, that error goes away but the module is not auto-installed.

Any idea what I could do in order to fix this problem?

I got the Debug log here:

[03-Feb-2015 03:44:51 America/New_York] PHP Fatal error: 1062: Duplicate entry 'DEFINE_TESTIMONIAL_STATUS' for key 'unq_config_key_zen' :: INSERT INTO zen_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Define Testimonial Status', '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', '42', 20, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1'', ''2'', ''3''),') ==> (as called by) /home/playscom/public_html/demo/admin/includes/init_includes/init_tm_config.php on line 121 <== in /home/playscom/public_html/demo/includes/classes/db/mysql/query_factory.php on line 155


Thank you

---

Try replacing the ALL the code in YOUR_ADMIN/includes/init_includes with the following..

Code:

---

<?php
/**
 * Testimonial Manager
 *
 * @copyright Copyright 2003-2005 Zen Cart Development Team
 * @copyright Portions Copyright 2003 osCommerce
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: init_tm_config.php 2.3.3b 7/12/2014 mc12345678 $
 */

//$messageStack->add('Testimonials Manager v1.5.4 install started','success');

$sql = "CREATE TABLE IF NOT EXISTS ".DB_PREFIX."testimonials_manager (
  testimonials_id int(11) NOT NULL auto_increment,
  language_id int(11) NOT NULL default '1',
  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)
)";
    $db->Execute($sql);

//check if sample testimonial exists and if it does not exist, then add it
    $tm_sample_name = 'Clyde Designs';
    $sql ="SELECT * FROM ".DB_PREFIX."testimonials_manager WHERE testimonials_name = '".$tm_sample_name."'";
    $result = $db->Execute($sql);
    if(!$result->RecordCount())
    {
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."testimonials_manager (language_id, testimonials_title, testimonials_url, testimonials_name, testimonials_image, testimonials_html_text, testimonials_mail, testimonials_company, testimonials_city, testimonials_country, testimonials_show_email, status, date_added, last_update) VALUES (1, 'Great', '', 'Clyde Designs', '', 'This is just a test submission to show you how it looks, great, eh?', '[email protected]', NULL, NULL, NULL, 0, 1, now(), NULL)";
    $db->Execute($sql);
    }

    $tm_menu_title = 'Testimonials Manager';
    $tm_menu_text = 'Testimonials Manager Display Settings';

    /* find if Testimonial Manager Configuration Group Exists */
    $sql = "SELECT * FROM ".TABLE_CONFIGURATION_GROUP." WHERE configuration_group_title = '".$tm_menu_title."'";
    $original_config = $db->Execute($sql);

    if($original_config->RecordCount())
    {
        // if exists updating the existing Testimonial Manager configuration group entry
        $sql = "UPDATE ".TABLE_CONFIGURATION_GROUP." SET
                configuration_group_description = '".$tm_menu_text."'
                WHERE configuration_group_title = '".tm_menu_title."'";
        $db->Execute($sql);
        $sort = $original_config->fields['sort_order'];

    }else{
        /* Find max sort order in the configuation group table -- add 2 to this value to create the Testimonial Manager configuration group ID */
        $sql = "SELECT (MAX(sort_order)+2) as sort FROM ".TABLE_CONFIGURATION_GROUP;
        $result = $db->Execute($sql);
        $sort = $result->fields['sort'];

        /* Create Testimonial Manager configuration group */
        $sql = "INSERT IGNORE INTO ".TABLE_CONFIGURATION_GROUP." (configuration_group_title, configuration_group_description, sort_order, visible) VALUES ('".$tm_menu_title."', '".$tm_menu_text."', ".$sort.", '1')";
        $db->Execute($sql);
  }

    /* Find configuation group ID of Testimonial Manager */
    $sql = "SELECT configuration_group_id FROM ".TABLE_CONFIGURATION_GROUP." WHERE configuration_group_title='".$tm_menu_title."' LIMIT 1";
    $result = $db->Execute($sql);
        $tm_configuration_id = $result->fields['configuration_group_id'];

    /* Remove Testimonial Manager items from the configuration table */
    $sql = "DELETE FROM ".DB_PREFIX."configuration WHERE configuration_group_id ='".$tm_configuration_id."'";
        $db->Execute($sql);

//-- ADD VALUES TO TESTIMONIAL MANAGER CONFIGURATION GROUP (Admin > Configuration > Testimonial Manager) --
    $sql = " ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Number Of Testimonials to display in Testimonials Sidebox', 'MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES', '5', 'Set the number of testimonials to display in the Latest Testimonials box.', '".$tm_configuration_id."', 1, NULL, now(), NULL, NULL)";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Testimonial Title Minimum Length', 'ENTRY_TESTIMONIALS_TITLE_MIN_LENGTH', '2', 'Minimum length of link title.', '".$tm_configuration_id."', 2, NULL, now(), NULL, NULL)";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Testimonial Text Minimum Length', 'ENTRY_TESTIMONIALS_TEXT_MIN_LENGTH', '10', 'Minimum length of Testimonial description.', '".$tm_configuration_id."', 3, NULL, now(), NULL, NULL)";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Testimonial Text Maximum Length', 'ENTRY_TESTIMONIALS_TEXT_MAX_LENGTH', '1000', 'Maximum length of Testimonial description.', '".$tm_configuration_id."', 3, NULL, now(), NULL, NULL)";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Testimonial Contact Name Minimum Length', 'ENTRY_TESTIMONIALS_CONTACT_NAME_MIN_LENGTH', '2', 'Minimum length of link contact name.', '".$tm_configuration_id."', 4, NULL, now(), NULL, NULL)";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Display Truncated Testimonials in Sidebox', 'DISPLAY_TESTIMONIALS_MANAGER_TRUNCATED_TEXT', 'true', 'Display truncated text in sidebox', '".$tm_configuration_id."', 5, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),')";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('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.', '".$tm_configuration_id."', 6, NULL, now(), NULL, NULL)";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('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.', '".$tm_configuration_id."', 7, NULL, now(), NULL, NULL)";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Display Date Published on Testimonials page', 'DISPLAY_TESTIMONIALS_DATE_PUBLISHED', 'true', 'Display date published on testimonials page', '".$tm_configuration_id."', 8, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),')";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Display View All Testimonials Link In Sidebox', 'DISPLAY_ALL_TESTIMONIALS_TESTIMONIALS_MANAGER_LINK', 'true', 'Display View All Testimonials Link In Sidebox', '".$tm_configuration_id."', 9, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),')";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Display Add New Testimonial Link In Sidebox', 'DISPLAY_ADD_TESTIMONIAL_LINK', 'true', 'Display Add New Testimonial Link In Sidebox', '".$tm_configuration_id."', 10, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),')";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Testimonial Image Width', 'TESTIMONIAL_IMAGE_WIDTH', '80', 'Set the Width of the Testimonial Image', '".$tm_configuration_id."', 11, NULL, '2007-08-21 12:04:10', NULL, NULL)";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Testimonial Image Height', 'TESTIMONIAL_IMAGE_HEIGHT', '80', 'Set the Height of the Testimonial Image', '".$tm_configuration_id."', 12, NULL, '2007-08-21 12:04:10', NULL, NULL)";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Testimonial Image Directory', 'TESTIMONIAL_IMAGE_DIRECTORY', 'testimonials/', 'Set the Directory for the Testimonial Image', '".$tm_configuration_id."', 13, NULL, '2007-08-21 12:04:10', NULL, NULL)";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Display Company Name field', 'TESTIMONIALS_COMPANY', 'true', 'Display Company Name field', '".$tm_configuration_id."', 14, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),')";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Display City field', 'TESTIMONIALS_CITY', 'true', 'Display City field', '".$tm_configuration_id."', 15, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),')";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Display Country field', 'TESTIMONIALS_COUNTRY', 'true', 'Display Country field', '".$tm_configuration_id."', 16, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),')";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Only registered customers may submit a testimonial', 'REGISTERED_TESTIMONIAL', 'true', 'Only registered customers may submit a testimonial', '".$tm_configuration_id."', 17, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),')";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Display All Languages', 'TESTIMONIALS_DISPLAY_ALL_LANGUAGES', 'true', 'Display All Languages', '".$tm_configuration_id."', 18, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),')";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Testimonial - Show Store Name and Address', 'TESTIMONIAL_STORE_NAME_ADDRESS', 'true', 'Include Store Name and Address', '".$tm_configuration_id."', 19, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),')";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Define Testimonial Status', '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', '".$tm_configuration_id."', 20, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1'', ''2'', ''3''),')";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Testimonial Manager Version', 'TM_VERSION', '1.5.4', 'Testimonial Manager version', '".$tm_configuration_id."', 21, NULL, now(), NULL, NULL)";
    $db->Execute($sql);

  if(file_exists(DIR_FS_ADMIN . DIR_WS_INCLUDES . 'auto_loaders/config.tm.php'))
    {
        if(!unlink(DIR_FS_ADMIN . DIR_WS_INCLUDES . 'auto_loaders/config.tm.php'))
    {
        $messageStack->add('The auto-loader file '.DIR_FS_ADMIN.'includes/auto_loaders/config.tm.php has not been deleted. For this module to work you must delete the '.DIR_FS_ADMIN.'includes/auto_loaders/config.tm.php file manually.  Before you post on the Zen Cart forum to ask, YES you are REALLY supposed to follow these instructions and delete the '.DIR_FS_ADMIN.'includes/auto_loaders/config.tm.php file.','error');
    };
    }

      $messageStack->add('Testimonials Manager v1.5.4 install completed!','success');

    // find next sort order in admin_pages table
    $sql = "SELECT (MAX(sort_order)+2) as sort FROM ".TABLE_ADMIN_PAGES;
    $result = $db->Execute($sql);
    $admin_page_sort = $result->fields['sort'];

    // now register the admin pages
    // Admin Menu for Testimonial Manager Configuration Menu
    zen_deregister_admin_pages('configTestimonialsManager');
    zen_register_admin_page('configTestimonialsManager',
        'BOX_CONFIGURATION_TESTIMONIALS_MANAGER', 'FILENAME_CONFIGURATION',
        'gID=' . $tm_configuration_id, 'configuration', 'Y',
        $admin_page_sort);

    //-- Admin Menu for Testimonial Manager Tools Menu
    zen_deregister_admin_pages('TestimonialsManager');
    zen_deregister_admin_pages('toolsTestimonialsManager');
    zen_register_admin_page('toolsTestimonialsManager',
        'BOX_TOOLS_TESTIMONIALS_MANAGER', 'FILENAME_TESTIMONIALS_MANAGER',
        '', 'tools', 'Y',
        $admin_page_sort);

---

Sorry for the delay reply,when I use this code ,still have error message: WARNING: An Error occurred, please refresh the page and try again.

But this time Debugs log different.:frusty:



[04-Feb-2015 10:43:54 America/New_York] PHP Fatal 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 'zen_configuration (configuration_title, configuration_key, configuration_value, ' at line 1 :: zen_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Number Of Testimonials to display in Testimonials Sidebox', 'MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES', '5', 'Set the number of testimonials to display in the Latest Testimonials box.', '42', 1, NULL, now(), NULL, NULL) ==> (as called by) /home/playscom/public_html/demo/admin/includes/init_includes/init_tm_config.php on line 81 <== in /home/playscom/public_html/demo/includes/classes/db/mysql/query_factory.php on line 155

Quote:

---

Originally Posted by paranoia

Sorry for the delay reply,when I use this code ,still have error message: WARNING: An Error occurred, please refresh the page and try again.

But this time Debugs log different.:frusty:



[04-Feb-2015 10:43:54 America/New_York] PHP Fatal 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 'zen_configuration (configuration_title, configuration_key, configuration_value, ' at line 1 :: zen_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Number Of Testimonials to display in Testimonials Sidebox', 'MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES', '5', 'Set the number of testimonials to display in the Latest Testimonials box.', '42', 1, NULL, now(), NULL, NULL) ==> (as called by) /home/playscom/public_html/demo/admin/includes/init_includes/init_tm_config.php on line 81 <== in /home/playscom/public_html/demo/includes/classes/db/mysql/query_factory.php on line 155

---

Modify this:

Code:

---

//-- ADD VALUES TO TESTIMONIAL MANAGER CONFIGURATION GROUP (Admin > Configuration > Testimonial Manager) --   
 $sql = " ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Number Of Testimonials to display in Testimonials Sidebox', 'MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES', '5', 'Set the number of testimonials to display in the Latest Testimonials box.', '".$tm_configuration_id."', 1, NULL, now(), NULL, NULL)";

---

to this:

Code:

---

//-- ADD VALUES TO TESTIMONIAL MANAGER CONFIGURATION GROUP (Admin > Configuration > Testimonial Manager) -- 
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Number Of Testimonials to display in Testimonials Sidebox', 'MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES', '5', 'Set the number of testimonials to display in the Latest Testimonials box.', '".$tm_configuration_id."', 1, NULL, now(), NULL, NULL)";

---

Also going forward, it helps if you use the forum codes to enclose error logs.. so they are readable and not going to be parsed and "mis-interpreted" by the form software..

wow !!　It's works like a charm!!!!!!

awesome!!!
Thank for your fantastic help!!

Quote:

---

Originally Posted by paranoia

wow !!　It's works like a charm!!!!!!

awesome!!!
Thank for your fantastic help!!

---

Thanks for confirming that this worked for you!! (I hadn't had a chance to test it..)

So I have gone through most of the 14 pages here. I've been using the Testimonials Manager on my 1.3.9h site for years. Quite thrilled with the addon.
If I follow all the install instructions for the new version to add this mod to my brand new 1.5.4 site, are there any changes I need to make (assuming, of course, that I follow the instructions and do it correctly...)???

To answer my own question - as long as I do the two most recent mods, it works great. Thanks again!

Hi there :)

I'm hoping someone might be able to help me with an issue I just noticed. I'm using ZC version 1.5.4. The quotes on my testimonials are HUGE! So big that they cover part of the testimonial text. Any way to either make these smaller or remove them all together?

Thanks :)

Quote:

---

Originally Posted by jcrewe

Hi there :)

I'm hoping someone might be able to help me with an issue I just noticed. I'm using ZC version 1.5.4. The quotes on my testimonials are HUGE! So big that they cover part of the testimonial text. Any way to either make these smaller or remove them all together?

Thanks :)

---

The quotes are image files. Replace them with smaller images.

Quote:

---

Originally Posted by jcrewe

Hi there :)

I'm hoping someone might be able to help me with an issue I just noticed. I'm using ZC version 1.5.4. The quotes on my testimonials are HUGE! So big that they cover part of the testimonial text. Any way to either make these smaller or remove them all together?

Thanks :)

---

Try this download includes/templates/YOUR_TEMPLATE/templates/tpl_display_all_testimonials_default.php
Go down to line 49 and replace:

PHP Code:

---

<div class="testimonial"> 


---

with

PHP Code:

---

<div id="testimonial"> 


---

See if that will solve your problem.

Quote:

---

Originally Posted by countrycharm

Try this download includes/templates/YOUR_TEMPLATE/templates/tpl_display_all_testimonials_default.php
Go down to line 49 and replace:

PHP Code:

---

<div class="testimonial"> 


---

with

PHP Code:

---

<div id="testimonial"> 


---

See if that will solve your problem.

---

Thanks, Countrycharm! While the quotes are still on the large size, at least they are no longer impeding on the actual testimonial so now it's all legible :)

Quote:

---

Originally Posted by jeking

The quotes are image files. Replace them with smaller images.

---

IMHO, this is the BEST solution.. One of these days I gonna look into an option to replace the images with an Awesome Font glyph.. or even a Google Fonts quote..

Quote:

---

Originally Posted by countrycharm

Try this download includes/templates/YOUR_TEMPLATE/templates/tpl_display_all_testimonials_default.php
Go down to line 49 and replace:

PHP Code:

---

<div class="testimonial"> 


---

with

PHP Code:

---

<div id="testimonial"> 


---

See if that will solve your problem.

---

Or.. one could adjust the CSS for the class to reflect whatever the CSS for the ID is..

Hi Everyone.

I've been using this plugin for years & love it. I've found a weird problem with mine though. Googlebot & bingbot amongst others cannot see the sidebox on my homepage. Fine on every other page of my website but the homepage shows all sideboxes with the exception of Testimonials Manager. You can see this if you look at my homepage www.koolbadges.co.uk in googles cache. I can't for the life of me figure out why it doesn't display on the homepage but is fine on every other page. Your input would be much appreciated.

If you fetch as bingbot or googlebot in webmater tools you will see it simply doesn't render.

Thanks in advance

I am getting spam testimonials even though I have set 'Only registered customers may submit a testimonial', when I look at the customer submitting it I can't find it in my customer database, how is this happening, I tried to submit a testimonial the system tells me you need to be registered.

Any idea why how to fix this issue, I have google captcha but it's not set up for testimonials.

Any suggestions?

Not sure why I didn't see this before, but I just finished updating my form layout and did a test. Got an error to pop-up even through all worked as expected.

Server OS: Linux
Database: MySQL 5.6.23
PHP Version: 5.4.45

error log states at line 13, PHP Warning: mysql_insert_id(): Access denied for user

in /includes/modules/pages/testimonials_add/header_php.php look for the following three lines

Code:

---

13  require(DIR_WS_FUNCTIONS . 'testimonials.php');

29  $testimonials_id = zen_db_prepare_input($_POST['testimonials_id']);

93  $testimonials_id = zen_db_insert_id();

---

you can comment them out or delete all three lines, no need for them. If for some reason you want to keep the id, use

Code:

---

$db->Insert_ID()
instead of
zen_db_insert_id()

---

you can Remove the file /functions/testimonials.php it's not needed and calls to mysql_insert_id() which creates the error. This may not be an issue with older PHP versions.

You don't say which version of Zen Cart you're using, but having that direct mysql_ function call isn't going to "play nice" with Zen Cart v1.5.2 or later (since those later versions use mysqli_ function calls).

Quote:

---

Originally Posted by lat9

You don't say which version of Zen Cart you're using, but having that direct mysql_ function call isn't going to "play nice" with Zen Cart v1.5.2 or later (since those later versions use mysqli_ function calls).

---

Zen Cart 1.5.4

Missed adding that bit... the id is not used at all in the way the code is asking, so removing it completely wouldn't heart anything even for later versions.

Quote:

---

Originally Posted by davewest

Zen Cart 1.5.4

Missed adding that bit... the id is not used at all in the way the code is asking, so removing it completely wouldn't heart anything even for later versions.

---

FWIW, that's what I've been doing on installations that require this plugin.

Does anyone know if this has been updated for 1.5.5 yet?
Thanks

Hi, I've got this excellent plugin installed on our site. I have v1.5.5 of Zen Cart installed.

English language version of site - https://www.welsh-lovespoons.co.uk/testimonials
Welsh language version of site - https://www.llwyaucaru.com/gairda

I was just wondering how the meta tags for the individual testimonial pages should work? Currently the meta tag title, description and keywords for all of my testimonials are exactly the same, no content is taken from the text added (title or body) in the testimonial themselves. Is this how it should work? Thanks for any advice.

Here is an example of one of the testimonial pages - https://www.welsh-lovespoons.co.uk/i...monials_id=522

The meta tags are as follows. This is exactly the same for each and every testimonial which isn't great for google.

Code:

---

<title>Testimonial : Welsh Love Spoons, Hand Carved Lovespoons from Wales</title>
<meta name="keywords" content="welsh love spoons, lovespoons, love spoons, love spoon, lovespoon, welsh lovespoons, celtic lovespoon, celtic love spoon, cadwyn Testimonial" />
<meta name="description" content="Welsh Love Spoons : Testimonial - welsh love spoons, lovespoons, love spoons, love spoon, lovespoon, welsh lovespoons, celtic lovespoon, celtic love spoon, cadwyn" />

---

Thanks for any advice.

Quote:

---

Originally Posted by bonheddwr

Hi, I've got this excellent plugin installed on our site. I have v1.5.5 of Zen Cart installed.

English language version of site - https://www.welsh-lovespoons.co.uk/testimonials
Welsh language version of site - https://www.llwyaucaru.com/gairda

I was just wondering how the meta tags for the individual testimonial pages should work? Currently the meta tag title, description and keywords for all of my testimonials are exactly the same, no content is taken from the text added (title or body) in the testimonial themselves. Is this how it should work? Thanks for any advice.

---

Sounds like the plugin hasn't been written to consider metatags.

To do that it would need to:
- figure out which testimonial is currently displayed
- generate relevant metatags for that
- update the default metatags to the ones for the displayed testimonial

The default logic for calculating metatags is in /includes/modules/meta_tags.php
Since v1.5.5 there's support built in to allow writing of Observer classes which avoid having to edit the actual metatags module file itself. But if you don't mind merging your customizations done to the original file when you upgrade next, you can just edit it directly with the requisite logic.

does this allow for guests to make a testimonial without having to login?

cheers, Mike

Quote:

---

Originally Posted by shags38

does this allow for guests to make a testimonial without having to login?

cheers, Mike

---

No, they need an account.

There is a admin switch that turns off/on registered only! so yes none account holders can do testimonials...

Quote:

---

Originally Posted by davewest

There is a admin switch that turns off/on registered only! so yes none account holders can do testimonials...

---

I stand corrected.

Only registered customers may submit a testimonial is a true/false option.

Regarding Meta Tags:

I have Testimonials Manager running on 1.5.5e

There is some code in the instructions which needs to be applied into meta_tags.php

This is what it says in the read me

9) This section is entirely optional.
To implement metatags for your testimonials;
open includes/modules/meta_tags.php.
locate the following line of code (around line 336)
// NO "break" here. Allow defaults if not overridden at the per-page level
Immediately above this line copy and paste the code below.
(save the edited file to includes/modules/YOUR_TEMPLATE/meta_tags.php and upload to your server.

break;
//TESTIMONIALS:
case 'display_all_testimonials':

$sql = "select * from " . TABLE_TESTIMONIALS_MANAGER . " where status = 1 and language_id = '" . (int)$_SESSION['languages_id'] . "' order by date_added DESC, testimonials_title";
$testimonials = $db->Execute($sql);
while (!$testimonials->EOF) {
$testimonial_string_metatags .= zen_clean_html($testimonials->fields['testimonials_title']) . METATAGS_DIVIDER;

$testimonials->MoveNext();

} //EOF
define('META_TAG_TITLE', META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER_ALL_TESTIMONIALS . $testimonial_string_metatags);
define('META_TAG_DESCRIPTION', META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER_ALL_TESTIMONIALS . $testimonial_string_metatags);
define('META_TAG_KEYWORDS', META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER_ALL_TESTIMONIALS . $testimonial_string_metatags);
break;

case 'testimonials_manager':
define('META_TAG_TITLE', META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER . $page_check->fields['testimonials_title']);
define('META_TAG_DESCRIPTION', META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER . zen_trunc_string($page_check->fields['testimonials_html_text'],TESTIMONIALS_MANAGER_DESCRIPTION_LENGTH));
define('META_TAG_KEYWORDS', META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER . $page_check->fields['testimonials_title']);


---------------------------------------------------------

Trouble is, when I add this code I get this output:


<title>META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGERGreat</title>
<meta name="keywords" content="META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGERGreat" />
<meta name="description" content="META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGERThis is just a test submission to show you how it looks, great, eh?" />

Any ideas why it would put META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER, META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER, and META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER before the actual tag content ?

I think I have an idea but not sure.

Quote:

---

Originally Posted by Nick1973

Regarding Meta Tags:

I have Testimonials Manager running on 1.5.5e

There is some code in the instructions which needs to be applied into meta_tags.php

I think I have an idea but not sure.

---

your most likely thinking you need to add something to languages

Code:

---

// Testimonial manager meta tags
define('META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER_ALL_TESTIMONIALS', 'SOME WORDS  ');
define('META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER', 'SOME WORDS  ');

---

I did to includes/languages/english/YOUR_TEMPLATE/meta_tags.php

Or none, depending on what common wording you want to have for each post... I use my site name.

Quote:

---

Originally Posted by davewest

your most likely thinking you need to add something to languages

Code:

---

// Testimonial manager meta tags
define('META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER_ALL_TESTIMONIALS', 'SOME WORDS  ');
define('META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER', 'SOME WORDS  ');

---

I did to includes/languages/english/YOUR_TEMPLATE/meta_tags.php

Or none, depending on what common wording you want to have for each post... I use my site name.

---

Thanks Dave, I didn't really have time to go through it earlier. Should have guessed that really. Long day lol

Hi, I like this plugin. And I installed it. Everything works excepting adding Testimonial.
When I click" add a testimonial", it redirects to "/index.php?main_page=testimonials_add" page. But this page is blank. I checked my logs file. It reads:
PHP Parse error: syntax error, unexpected '=' in /home8/simonhai/public_html/includes/functions/testimonials.php on line 14

Below is the testimonial file

PHP Code:

---

[PHP]<?php
/**
 * Testimonials Manager
 *
 * @package Template System
 * @copyright 2007 Clyde Jones
  * @copyright Portions Copyright 2003-2007 Zen Cart Development Team
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: Testimonials_Manager.php v1.5.5e
 */

  function zen_db_insert_id() {
    global $db;
    return = $db->Insert_ID();
  }
//EOF

---

[/PHP]

my site is www.thedancinghair.com

Quote:

---

Originally Posted by kevin_remy

Hi, I like this plugin. And I installed it. Everything works excepting adding Testimonial.
When I click" add a testimonial", it redirects to "/index.php?main_page=testimonials_add" page. But this page is blank. I checked my logs file. It reads:
PHP Parse error: syntax error, unexpected '=' in /home8/simonhai/public_html/includes/functions/testimonials.php on line 14

Below is the testimonial file

PHP Code:

---

[PHP]<?php
/**
 * Testimonials Manager
 *
 * @package Template System
 * @copyright 2007 Clyde Jones
  * @copyright Portions Copyright 2003-2007 Zen Cart Development Team
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: Testimonials_Manager.php v1.5.5e
 */

  function zen_db_insert_id() {
    global $db;
    return = $db->Insert_ID();
  }
//EOF

---

[/PHP]

my site is www.thedancinghair.com

---

Yeah, would remove the = from the line:

Code:

---

return = $db->Insert_ID();

---

So that it reads:

Code:

---

return $db->Insert_ID();

---

The file /includes/functions/testimonials.php was changed in the most recent version of this plugin. Previous versions did not have this problem.

Quote:

---

Originally Posted by mc12345678

Yeah, would remove the = from the line:

Code:

---

return = $db->Insert_ID();

---

So that it reads:

Code:

---

return $db->Insert_ID();

---

---

It works. Thank you so much!

That was a little mistake from me trying to update it to take out all of the mysql_xx functions, I have resubmitted an updated package to correct it

Quote:

---

Originally Posted by lankeeyankee

That was a little mistake from me trying to update it to take out all of the mysql_xx functions, I have resubmitted an updated package to correct it

---

No good deed goes unpunished. :smile:

Quote:

---

Originally Posted by lankeeyankee

That was a little mistake from me trying to update it to take out all of the mysql_xx functions, I have resubmitted an updated package to correct it

---

Quote:

---

Originally Posted by jeking

No good deed goes unpunished. :smile:

---

Oops. And I had a part in that too. Sorry. lankeeyankee's update has been published and is available for download

That was one line that never made sense to me!

In the $_POST line 39

Code:

---

$testimonials_id = zen_db_prepare_input($_POST['testimonials_id']);

---

I could not find it in the template form anywhere!

Then in line 93

Code:

---

$testimonials_id = zen_db_insert_id();

---

I can understand why we would get it from the database, just not sure why now! The function is not used anywhere else!

I've commented it out and did away with the function without any issues for some years now..

Just wondering why its in the POSTing side of the form. The Function exists in Admin and works there... Also thinking maybe there was some mixing of the admin code with the catalog side!

Hey, I still need your help. In all testimonials page, CSS does not work. Check below pic:

Attachment 17115

I added below codes to my template stylesheet.css

PHP Code:

---

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


---

Also, I added metatags code correctly. I think there is something wrong, too. You may check below pic.

Attachment 17116

Quote:

---

Originally Posted by kevin_remy

Hey, I still need your help. In all testimonials page, CSS does not work. Check below pic:

Attachment 17115

I added below codes to my template stylesheet.css

PHP Code:

---

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


---

---

I fixed this problem. Need not reply.

Quote:

---

Originally Posted by kevin_remy

I fixed this problem. Need not reply.

---

Okay, fixed it, but to help others that may experience the same thing, how was it fixed?

Quote:

---

Originally Posted by mc12345678

Okay, fixed it, but to help others that may experience the same thing, how was it fixed?

---

It will work if I did not add these codes to my stylesheet.css

Quote:

---

Originally Posted by mc12345678

Okay, fixed it, but to help others that may experience the same thing, how was it fixed?

---

Can you help me with my metatags problem?

Quote:

---

Originally Posted by kevin_remy

Can you help me with my metatags problem?

---

Same as post 159, was answered in post 160..

Quote:

---

Originally Posted by davewest

That was one line that never made sense to me!

In the $_POST line 39

Code:

---

$testimonials_id = zen_db_prepare_input($_POST['testimonials_id']);

---

I could not find it in the template form anywhere!

Then in line 93

Code:

---

$testimonials_id = zen_db_insert_id();

---

I can understand why we would get it from the database, just not sure why now! The function is not used anywhere else!

I've commented it out and did away with the function without any issues for some years now..

Just wondering why its in the POSTing side of the form. The Function exists in Admin and works there... Also thinking maybe there was some mixing of the admin code with the catalog side!

---

While not entirely sure of to where you are referring with this, but found "similar" code in the admin file. The way it is used there is to allow putting a testimonial id in the uri by using the bID parameter. When that gets used, data is posted into the form to then when submitted is available for further use/updating. The second, well, ideally such a database insert collection should be performed as close to after the insert as possible to prevent some other database insertion "losing" the record. This is more of an "issue" in newer ZC versions with software that has adopted the use of logging an action because that logging inserts a record though it is not "obvious" by the line of code to do so. :)

So, if you don't use something like ?bID=24 in the uri, the testimonials_id won't be "hidden" on the form and the $_POSTed data won't be fed back to the code.


That clarify things a little?

Quote:

---

Originally Posted by mc12345678

So, if you don't use something like ?bID=24 in the uri, the testimonials_id won't be "hidden" on the form and the $_POSTed data won't be fed back to the code.

---

In Admin, it's correct and I do understand its use there, just not from the user input side where the ID is auto generated after the posting of the form data.

So how would one post the id before its auto generated is the question for line 29?

Picking up the ID after its created again, makes sense, but its not in use on the success page as a link nor used in the email sent out, which again would make sense.

Quote:

---

Originally Posted by davewest

In Admin, it's correct and I do understand its use there, just not from the user input side where the ID is auto generated after the posting of the form data.

So how would one post the id before its auto generated is the question for line 29?

Picking up the ID after its created again, makes sense, but its not in use on the success page as a link nor used in the email sent out, which again would make sense.

---

Regarding posting of the testimonials_id "before" it is autogenerated: Here is how I understand the situation, but I think that we are possibly thinking down two different paths.

What seems to be the intended use: Admin knows the testimonials_id that they wish to edit/update, they type in their uri:
/admin/testimonials_manager.php?bID=24.

This takes them to the testimonial that has the id of 24. In so doing this, the action is identified as an update action, a field is populated on the page that contains the testimonials_id (which when the form is submitted will be POSTed) and the other fields to edit are provided. The admin edits the fields, submits the form, this then submits the testimonials_id to support capturing the update. That is where line 29 is involved. It collects the posted data. Then as it continues to process there is a fork in the road of either to insert or update and because this action is considered an update, the existing (POSTed) testimonials_id is used. But, as you may see/notice, the case 'insert' and case 'update' seem to follow the same path. Well, generally speaking an insert and an update both share common actions pretty much up until the end... But... an insert can not (as you have pointed out) already know what the testimonials_id is before it has been "committed". That is why an insert action goes through a collection/autogeneration step. Sure, one could use a web browser to edit the html on the page then submit the page with a testimonials_id and feed that through, but... Towards the end of the "process" because that would be considered an insert (unless that portion of the page was edited also to be an update) a new testimonials_id would be expected and is also controlled that way.

Now, could the code be modified/switched around a little so that there isn't a check to see if it is posted or not? Yeah I can see something like that, but it would/could change the way(s) others have worked with the code. Ie.:

This

Code:

---

      case 'insert':
      case 'update':
        if (isset($_POST['testimonials_id'])) $testimonials_id = zen_db_prepare_input($_POST['testimonials_id']);
        $testimonials_title = zen_db_prepare_input($_POST['testimonials_title']);

---

could be changed to:

Code:

---

      case 'update':
                  $testimonials_id = zen_db_prepare_input($_POST['testimonials_id']);
      case 'insert':
        $testimonials_title = zen_db_prepare_input($_POST['testimonials_title']);

---

But then could also ask, why make the change? What problem is solved? Might it prevent similar confusion? Sure, but also how much rework by others is expected to be done? (Helps to know things like that if/when such a thing is done that there be some form of "notification" of doing something from either/both sides. Notice that the overall ZC project does this type of thing by making the new version(s) available for a period of time before committing it for the community to use.

Sorry, I digress I think.. Anyways, hope that explanation helps/helped.

Quote:

---

Originally Posted by mc12345678

Regarding posting of the testimonials_id "before" it is autogenerated: Here is how I understand the situation, but I think that we are possibly thinking down two different paths.

---

We are on two different paths for sure, admin is not the problem at all...

The issue was with the catalog side where the testimonial is created by the user! includes/modules/pages/testimonial_add/header_php.php line 29 is posting from the sent form. However, its not getting inserted and no id getting sent from the form, so it would be blink all the time anyway.

Its just an open door that for me was closed without any problems.

Getting following error:

PHP Fatal error: 1327:Undeclared variable: MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES

This is located in includes/modules/sideboxes/testimonals_manager.php

Quote:

---

Originally Posted by tmccaff

Getting following error:

PHP Fatal error: 1327:Undeclared variable: MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES

This is located in includes/modules/sideboxes/testimonals_manager.php

---

It would appear that the portion of the installation to set the configuration menu option has not been performed. Please see the instructions for installation or search this thread for the sql query to add that to the store.

v1.5.5f PHP7.1

I am confused (I am easily confused these days) about the intention of the Meta_Tags optional code shown in the README Install - even after reading posts #152-154 and #159-161. I am getting the same ' symptom' as the poster in post #159 ... browser for testimonials page shows META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER ... followed by testimonial title

So in post #153 DrByte said it appeared the plugin wasn't set up to accommodate meta_tags so I can only assume the add in code in the rREADME negates that comment? Y/N?

If so is the code supposed to automatically extract the title of the testimonial and make it the meta_title of that testimonial (and so on for description) or is it such that the meta data is to be manually inputted into (? file) and is such that it applies to the page (or pages) that the testimonials are on in the site? i.e. the title, description and keywords apply to the testimonial page, not to the testimonials?

The README states (save the edited file to includes/modules/YOUR_TEMPLATE/meta_tags.php and upload to your server.) - it didn't suggest that the modified file be re-loaded into where it cane from, includes/modules/meta_tags.php ......... is that assumed? should it also be re-loaded back into that folder?

Post #160 mentions modifications to includes/languages/english/YOUR_TEMPLATE/meta_tags.php

So I am wondering exactly how the meta_tags works

cheers,
Mike

p.s. I reckon this is a great add on - not sure why it has taken me so long to apply it

Quote:

---

Originally Posted by shags38

Post #160 mentions modifications to includes/languages/english/YOUR_TEMPLATE/meta_tags.php

---

Working on a massive update to this mod and figured out your question too..

the meta tag language needs to be defined in includes/languages/english/YOUR_TEMPLATE/meta_tags.php
the two line to add to the bottom of that file are..

Code:

---

// Testimonial manager meta tags change to your 
define('META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER_ALL_TESTIMONIALS', 'Testimonials at ' . STORE_NAME . ' ');
define('META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER', 'Testimonials at ' . STORE_NAME . ' ');

---

This makes use of what you defined as your store name.. the meta tag file is in the default folder, just copy to your template folder and edit if you did not do that already..

Code:

---

So I am wondering exactly how the meta_tags works

---

This is some good info, in the eyes of Google...
https://www.wordstream.com/meta-tags

Hi all;

Thanks for your great addons. I was wondering about, are customers allowed to upload an image when they post a testimonials? if so, I should be blind :cool::blink: because i couldnt find the option to enable it.
where can I enable it if there is a upload image feature for this Addons?

my system as below :

Zencart 1.5.5f fresh installation
server PHP version 7.1
Testimonial plugin version 1.5.4

Thanks

Quote:

---

Originally Posted by probtc

Hi all;

Thanks for your great addons. I was wondering about, are customers allowed to upload an image when they post a testimonials? if so, I should be blind :cool::blink: because i couldnt find the option to enable it.
where can I enable it if there is a upload image feature for this Addons?

my system as below :

Zencart 1.5.5f fresh installation
server PHP version 7.1
Testimonial plugin version 1.5.4

Thanks

---

Currently.. no abilities to upload an image.... There was some crossing with this one and link manager somewhere... currently, working on a replacement and considering doing the image upload.

Quote:

---

Originally Posted by davewest

Working on a massive update to this mod and figured out your question too..

the meta tag language needs to be defined in includes/languages/english/YOUR_TEMPLATE/meta_tags.php
the two line to add to the bottom of that file are..

Code:

---

// Testimonial manager meta tags change to your 
define('META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER_ALL_TESTIMONIALS', 'Testimonials at ' . STORE_NAME . ' ');
define('META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER', 'Testimonials at ' . STORE_NAME . ' ');

---

This makes use of what you defined as your store name.. the meta tag file is in the default folder, just copy to your template folder and edit if you did not do that already..

Code:

---

So I am wondering exactly how the meta_tags works

---

This is some good info, in the eyes of Google...
https://www.wordstream.com/meta-tags

---

Thanks for that Dave, much appreciated. So tell me, does Google take any notice of Testimonials? if so are they treated in the same way as they do with Product Reviews? .... or are Testimonials simply a marketing tool?

Looking forward to your updated version.

cheers, Mike

Quote:

---

Originally Posted by shags38

Thanks for that Dave, much appreciated. So tell me, does Google take any notice of Testimonials? if so are they treated in the same way as they do with Product Reviews? .... or are Testimonials simply a marketing tool?

Looking forward to your updated version.

cheers, Mike

---

Its been debated on the net like so many other things... I've been tracking hits form search bots pulling both product reviews and testimonials so good content always helps... If you google a product name review and that product review is on the first page of the search... I would say it helps..

I have a working version on my site and was about to push up to github, but found some more wording issues to fix and started adding more to it.....

Quote:

---

Originally Posted by davewest

I have a working version on my site and was about to push up to github, but found some more wording issues to fix and started adding more to it.....

---

If your interested I pushed.. https://github.com/davesaddle/Testimonial-Manager

What is the desire on image uploads.. Avatars or products??

I know on some sites products are displayed by users. Basically to add with the product reviews..

After going around and about with html5/jQuery and coming up with some really cool upload scripts, I decide to skip uploads and use a avatar picker... Was not an issue with uploading, but a desire to sale vs blogging...

Still working on some things..

Quote:

---

Originally Posted by davewest

If your interested I pushed.. https://github.com/davesaddle/Testimonial-Manager

What is the desire on image uploads.. Avatars or products??

I know on some sites products are displayed by users. Basically to add with the product reviews..

After going around and about with html5/jQuery and coming up with some really cool upload scripts, I decide to skip uploads and use a avatar picker... Was not an issue with uploading, but a desire to sale vs blogging...

Still working on some things..

---

Hi Dave, good job - if you are still looking for input I would think product images would be more appropriate to an eCommerce site - IMHO avatars are more suited to forums and blogs :smile:
I assume the site owner can add the image of the product to the customers testimonial, right?

cheers,
Mike

Quote:

---

Originally Posted by shags38

Hi Dave, good job - if you are still looking for input I would think product images would be more appropriate to an eCommerce site - IMHO avatars are more suited to forums and blogs :smile:
I assume the site owner can add the image of the product to the customers testimonial, right?

cheers,
Mike

---

Avatars can be eye catching.. many big box eCommerce sites use them and give the ability of account holders to add there own, like amaz0n. which wouldn't be that hard to do.

I don't think site owners should have to do anything with image uploads was the path I was headed! With code, images can be sized, stripped and file typed before uploading securely..

updated and pushed up to gethub... the EXIF Metadata Information is stripped out of jpg's, sized, renamed during upload.. all the image work is done in the user browser before sending to the server..

Still have some testing to do... so far tested with ZC 155f, 156, 160, php7.2 and 7.1 only using HTML5 browsers both android and ios..

Davewest, I've started updating your beta on GitHub, if you've got more to add I'll wait, if not we will test and publish the next release to the forum shortly for 1.55f compatibility.

For those using the current Beta Testimonials Manager version 2.1 on GitHub...

Bug - This lookup has been shorted from the original (Assumed Testimonials Manager for 1.55e) and will not install correctly out of the box as a result in 1.55f.

includes/modules/pages/testimonials_add/header_php.php
replace line 242
$sql = "SELECT customers_id, customers_firstname, customers_email_address, customers_telephone, FROM " . TABLE_CUSTOMERS . " WHERE c.customers_id = :customersID ";


with this:
$sql = "SELECT customers_id, customers_firstname, customers_email_address, customers_telephone FROM " . TABLE_CUSTOMERS . " c WHERE c.customers_id = :customersID ";

Quote:

---

Originally Posted by twitchtoo

Davewest, I've started updating your beta on GitHub, if you've got more to add I'll wait, if not we will test and publish the next release to the forum shortly for 1.55f compatibility.

For those using the current Beta Testimonials Manager version 2.1 on GitHub...

Bug - This lookup has been shorted from the original (Assumed Testimonials Manager for 1.55e) and will not install correctly out of the box as a result in 1.55f.

includes/modules/pages/testimonials_add/header_php.php
replace line 242
$sql = "SELECT customers_id, customers_firstname, customers_email_address, customers_telephone, FROM " . TABLE_CUSTOMERS . " WHERE c.customers_id = :customersID ";


with this:
$sql = "SELECT customers_id, customers_firstname, customers_email_address, customers_telephone FROM " . TABLE_CUSTOMERS . " c WHERE c.customers_id = :customersID ";

---

The c. is not needed at all and came from another mod that I was working on more then likely.. That line should read..

Code:

---

  $sql = "SELECT customers_id, customers_firstname, customers_email_address, customers_telephone, FROM " . TABLE_CUSTOMERS . " WHERE customers_id = :customersID ";
 
  $sql = $db->bindVars($sql, ':customersID', $_SESSION['customer_id'], 'integer');
  $check_customer = $db->Execute($sql);

---

The entire mod was re-work for ZC156 release and php7.3 just not had time to finish testing and push it up...

I take it you don't get the gethub process of cooperation or bata testing than!!

Quote:

---

Originally Posted by davewest

The c. is not needed at all and came from another mod that I was working on more then likely.. That line should read..

Code:

---

  $sql = "SELECT customers_id, customers_firstname, customers_email_address, customers_telephone, FROM " . TABLE_CUSTOMERS . " WHERE customers_id = :customersID ";
 
  $sql = $db->bindVars($sql, ':customersID', $_SESSION['customer_id'], 'integer');
  $check_customer = $db->Execute($sql);

---

The entire mod was re-work for ZC156 release and php7.3 just not had time to finish testing and push it up...

I take it you don't get the gethub process of cooperation or bata testing than!!

---

Davewest, I'm interested in publishing a working 1.55f version for the Zen Cart Forum within a short period of time so that clients have a working copy for 1.55f.

Considering that the current forum version is not functioning out of the box on 1.55f nor does the recommended GitHub version you have provided that thankfully cleans up a lot of the files... but also does not work out of the GitHub box - I updated both the Zen Cart Forum and GitHub so that anyone using the beta has access to the fix... with the intent to further support using the now working 1.55f beta.

Your fix above ^ implies the lookup won't have other things to look for in the future, mine declares the first group (c) in case another group is worth looking through - same result it just depends on your needs moving forward.

I simply have a client that needs a stable 1.55f version for their shop and I intend to share one with the group in the process.

There is no need for me to interfere with anything ZC 1.56 related at this time - so those files and anything you'd like to add will not be affected.

'Tic Toc I'm On The Clock!'
:cheers:

We are still on version 1.5.2 and ZC 1.50, lately I am getting spam testimonials from registered customers, I think these are paid people that create account and put spam testimonials, I am having a hard time finding the customer that wrote the testimonials so that I could block him/her from logging in to the account.

I think it would great if there was a way to hide the email address box/field when I require testimonials be written for registered customers, this would help me great deal finding the spam customer by email address. Currently, the Spam Customers fills in a bogus email address in the field which makes it difficult finding him without going into the database or doing searches by name etc.

see attached image.

Attachment 18342

Can someone help me change the code?

Thanx

Quote:

---

Originally Posted by Coins2012

We are still on version 1.5.2 and ZC 1.50, lately I am getting spam testimonials from registered customers, I think these are paid people that create account and put spam testimonials, I am having a hard time finding the customer that wrote the testimonials so that I could block him/her from logging in to the account.

I think it would great if there was a way to hide the email address box/field when I require testimonials be written for registered customers, this would help me great deal finding the spam customer by email address. Currently, the Spam Customers fills in a bogus email address in the field which makes it difficult finding him without going into the database or doing searches by name etc.

see attached image.

Attachment 18342

Can someone help me change the code?

Thanx

---

You can try adding read only to the input field... if the user is not logged in, they would not have an email address or option to add one.. if the spam is from bots, there is no code on the back end to stop them..

Code:

---

<?php echo (($error == true && $entry_email_error == true) ? zen_draw_input_field('testimonials_mail', $testimonials_mail, 'size="25" id="testimonials_mail" readonly') . ERROR_TESTIMONIALS_EMAIL_REQUIRED : zen_draw_input_field('testimonials_mail', $testimonials_mail, 'size="25" id="testimonials_mail" readonly')); ?>

---

I would say, let them enter what they want to enter and when the header_php.php file processes the request that if the user is logged in to attach the email or whatever desired information is to be kept to track the individual (customer id, email address, name, whatever) with the information being saved. This way they can try to provide some sort of information that they may prefer, but could also capture the known information.

The check for logged in could be if (!empty($_SESSION['customer_id']))

Just a thought because then real people could put in something that may want instead of their on file information and those that are putting in false information could be identified and there wouldn't be an impact on legitimate entries just those entries that may be fictitious.

Quote:

---

Originally Posted by mc12345678

I would say, let them enter what they want to enter and when the header_php.php file processes the request that if the user is logged in to attach the email or whatever desired information is to be kept to track the individual (customer id, email address, name, whatever) with the information being saved. This way they can try to provide some sort of information that they may prefer, but could also capture the known information.

The check for logged in could be if (!empty($_SESSION['customer_id']))

Just a thought because then real people could put in something that may want instead of their on file information and those that are putting in false information could be identified and there wouldn't be an impact on legitimate entries just those entries that may be fictitious.

---

Customer info gathering for account holders is just a nice part of having an account... The read only is just a band-aid on a very old version of TM and changing email addresses could be their attempt not to post identifiable info to prevent there address from receiving spam!

But..

Quote:

---

spam testimonials from registered customers, I think these are paid people that create account and put spam testimonials, I am having a hard time finding the customer that wrote the testimonials

---

We could add an extra hidden field to admin with the true account email or user ID into the database maybe. Currently the user ID is not added, but we also offer same use to none account holders! Well have to play with this idea some more....

Also thinking back I should have some help info tags here so they know email address is not publicly posted....

Thing I was getting at is that anything that is $_POSTed is editable prior to the page being sent.

Quote:

---

Originally Posted by mc12345678

Thing I was getting at is that anything that is $_POSTed is editable prior to the page being sent.

---

True... which is why I started working on a filter for the address field.