its Done!
thanks All!:clap:
Printable View
its Done!
thanks All!:clap:
Hi there.. This MOD is just what I have been looking for..
I have followed all the instructions and cut & paste the sql code but when I press the "send" button this is what I get..
33 statements processed.
Error ERROR: Cannot insert configuration_key "PRODUCTS_OPTIONS_TYPE_SELECT" because it already exists
Error ERROR: Cannot insert configuration_key "UPLOAD_PREFIX" because it already exists
Error ERROR: Cannot insert configuration_key "TEXT_PREFIX" because it already exists
Error ERROR: Cannot insert configuration_key "IH_VERSION" because it already exists
Error ERROR: Cannot insert configuration_key "IH_VERSION" because it already exists
Warning Note: 4 statements ignored. See "upgrade_exceptions" table for additional details.
I have change the "your template" files to the name of my template and have uploaded all the files and added the code to my stylesheet.css file.
Now when I try and get the sidebox to show there is nothing? Weird?
Any suggestions would be most gratefully received.
Andy
Hi Clyde, thanks for the very quick reply.
Yes I had activated it and tried to vary where the sidebox should be - no testimonials box is showing at all - and where it should be showing, there are then no other boxes showing after it??
Ideas?
Andy
Make sure you have at least one testimonial approved admin -> tools -> testimonial manager.
make sure you have all the following files installed:
includes/extra_datafiles/testimonials_manager_filenames.php
includes/functions/testimonials.php
includes/languages/english/extra_definitions/YOUR_TEMPLATE/testimonials_manager_defines.php
includes/languages/english/YOUR_TEMPLATE/testimonials_add.php
includes/languages/english/YOUR_TEMPLATE/testimonials_manager.php
includes/languages/english/YOUR_TEMPLATE/testimonials_manager_all_testimonials.php
includes/languages/english/html_includes/define_testimonials_add.php
includes/languages/english/html_includes/YOUR_TEMPLATE/define_testimonials_add.php
includes/modules/pages/testimonials_add
includes/modules/pages/testimonials_manager
includes/modules/pages/testimonials_manager_all_testimonials
includes/modules/sideboxes/YOUR_TEMPLATE/testimonials_manager.php
includes/templates/YOUR_TEMPLATE/sideboxes/tpl_testimonials_manager.php
includes/templates/YOUR_TEMPLATE/templates/tpl_testimonials_add_default.php
includes/templates/YOUR_TEMPLATE/templates/tpl_testimonials_manager_all_testimonials_default.php
includes/templates/YOUR_TEMPLATE/templates/tpl_testimonials_manager_default.php
includes/templates/YOUR_TEMPLATE/css/testimonials_add.css
includes/templates/YOUR_TEMPLATE/css/testimonials_manager.css
includes/templates/YOUR_TEMPLATE/css/testimonials_manager_all_testimonials.css
includes/templates/YOUR_TEMPLATE/buttons/english/button_submit_testimonials.gif
includes/templates/YOUR_TEMPLATE/buttons/english/button_testimonials.gif
includes/templates/YOUR_TEMPLATE/buttons/english/button_view_testimonials.gif
Hi again Clyde
Removed the sql code and then downloaded the MOD from your site - installed it and now it is working fine? How odd.
Thanks once again for both the MOD and the help.
Andy
New Font Color --
Hi - I changed my stylesheet on our site (createadesign.net/store) to get a pinkish color for the testimonials using the code I got from the program "Absolute Color Picker".
testimonial {
color: #FF6058;
padding: 0 5px 5px 5px;
text-align:left;
but the font is still black.
Please tell me where I have gone wrong in life with this;
also how can I change to Italics; or different font
also how can I change the background color?
Thanx in advance
Rufus
Thanx a bunch
Rufusclc
Hi - TM working like charm;
2 quieckie questions:
to get text in bold would "font-style:bold;" work?
also, added on several Testimonials going back couple years anmd now realize all dated today!! any quick way to change to correct date?
Rufus
Styling the testimonials can be done using the appropriate stylesheet(s) supplied with testimonial manager.
Not really no, but there is a admin fix posted somewhere in this thread (I don't remember exactly where) that will allow you to use previous (earlier) dates when adding new testimonials.
I have a big error in email functions...
i didn't receive the corret email admin because i receive a message with EMAIL_TEXT + EMAIL_DISCLAIMER_NEW_CUSTOMER but not the EMAIL_OWNER_TEXT. Besides this the address e-mail is mine but not the receiver email because is the customer name!
The customer doesn't recevier any email!
why??
I try to verify the header_php.php in include/modules/pages/testimonialmanager/ but it is all correct.
why?
Sounds like you haven't uploaded ALL the necessary language files for the mod.
Check and make sure You've uploaded ALL the files listed and that you have changed the YOUR_TEMPLATE to the name of the template you are using on your site.
includes/extra_datafiles/testimonials_manager_filenames.php
includes/functions/testimonials.php
includes/languages/english/extra_definitions/YOUR_TEMPLATE/testimonials_manager_defines.php
includes/languages/english/YOUR_TEMPLATE/testimonials_add.php
includes/languages/english/YOUR_TEMPLATE/testimonials_manager.php
includes/languages/english/YOUR_TEMPLATE/testimonials_manager_all_testimonials.php
includes/languages/english/html_includes/define_testimonials_add.php
includes/languages/english/html_includes/YOUR_TEMPLATE/define_testimonials_add.php
includes/modules/pages/testimonials_add
includes/modules/pages/testimonials_manager
includes/modules/pages/testimonials_manager_all_testimonials
includes/modules/sideboxes/YOUR_TEMPLATE/testimonials_manager.php
includes/templates/YOUR_TEMPLATE/sideboxes/tpl_testimonials_manager.php
includes/templates/YOUR_TEMPLATE/templates/tpl_testimonials_add_default.php
includes/templates/YOUR_TEMPLATE/templates/tpl_testimonials_manager_all_testimonials_default.php
includes/templates/YOUR_TEMPLATE/templates/tpl_testimonials_manager_default.php
includes/templates/YOUR_TEMPLATE/css/testimonials_add.css
includes/templates/YOUR_TEMPLATE/css/testimonials_manager.css
includes/templates/YOUR_TEMPLATE/css/testimonials_manager_all_testimonials.css
includes/templates/YOUR_TEMPLATE/buttons/english/button_submit_testimonials.gif
includes/templates/YOUR_TEMPLATE/buttons/english/button_testimonials.gif
includes/templates/YOUR_TEMPLATE/buttons/english/button_view_testimonials.gif
Hi
Does this work with Zen 1.3.8a or only 1.3.8?
Thanks
These are the language files:the highlighted one contains the definitions for the e-mails
includes/languages/english/extra_definitions/YOUR_TEMPLATE/testimonials_manager_defines.php
includes/languages/english/YOUR_TEMPLATE/testimonials_add.php
includes/languages/english/YOUR_TEMPLATE/testimonials_manager.php
includes/languages/english/YOUR_TEMPLATE/testimonials_manager_all_testimonials.php
includes/languages/english/html_includes/define_testimonials_add.php
includes/languages/english/html_includes/YOUR_TEMPLATE/define_testimonials_add.php
now I have
includes/languages/italian/extra_definitions/cherry_zen/testimonials_manager_defines.php
includes/languages/italian/cherry_zen/testimonials_add.php
includes/languages/italian/cherry_zen/testimonials_manager.php
includes/languages/italian/cherry_zen/testimonials_manager_all_testimonials.php
includes/languages/italian/html_includes/define_testimonials_add.php
includes/languages/italian/html_includes/cherry_zen/define_testimonials_add.php
but still doesn't work!!! :frusty:
If you are receiving the constants EMAIL_TEXT + EMAIL_DISCLAIMER_NEW_CUSTOMER but not the EMAIL_OWNER_TEXT
It generally means that Those particular definitions are missing or the language file containing the definitions is missing.
These are the definitions found in includes/languages/italian/cherry_zen/testimonials_add.php
define('EMAIL_TEXT', 'Your testimonial has been successfully submitted at ' . STORE_NAME . '. It will be added to our other testimonials as soon as we approve it. You will receive an email about the status of your submittal. If you have not received it within the next 48 hours, please contact us before submitting your testimonial again.' . "\n\n");
define('EMAIL_OWNER_TEXT', 'A new testimonial was submitted at ' . STORE_NAME . '. It is not yet approved. Please verify thie testimonial and activate.' . "\n\n");
define('EMAIL_DISCLAIMER_NEW_CUSTOMER', 'This testimonial was submitted to us by you or by one of our users. If you did not submit a testimonial, or feel that you have received this email in error, please send an email to %s ');
do you see any error in my testimonials_add.php?
PHP Code:
<?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.0 1-9-2009 Clyde Jones $
*/
define('NAVBAR_TITLE', 'Inserisci il tuo giudizio');
define('HEADING_ADD_TITLE', '<h1>Inserisci il tuo giudizio</h1>');
define('TESTIMONIAL_SUCCESS', 'Il tuo giudizio è stato inserito con successo e verrà pubblicato al più presto.');
define('TESTIMONIAL_SUBMIT', 'Inserisci il tuo giudizio utilizzando il modulo sottostante.');
//////////////
define('EMAIL_SUBJECT', 'Rilascio feedback a ' . STORE_NAME . '.' . "\n\n");
define('EMAIL_GREET_NONE', 'Caro/a %s' . "\n\n");
define('EMAIL_WELCOME', 'Grazie per aver rilasciato il tuo feedback a <b>' . STORE_NAME . '</b>.' . "\n\n");
define('EMAIL_TEXT', 'Il tuo giudizio è stato inserito con successo e verrà pubblicato al più presto. Riceverai una e-mail che ti confermerà l\'avvenuta pubblicazione. Se non riceverai comunicazioni entro 48 ore, contattaci prima di inserire nuovamente il tuo giudizio.' . "\n\n");
define('EMAIL_CONTACT', 'Per richieste o aiuto contattaci al seguente indirizzo: ' . STORE_OWNER_EMAIL_ADDRESS . '.' . "\n\n");
define('EMAIL_WARNING', '<b>Attenzione:</b> Questa e-mail ci è stata fornita durante l\'inserimento di un feedback. in caso di problemi contattaci al seguente indirizzo: ' . STORE_OWNER_EMAIL_ADDRESS . '.' . "\n");
define('EMAIL_OWNER_SUBJECT', 'Rilascio feedback a ' . STORE_NAME);
define('SEND_EXTRA_TESTIMONIALS_ADD_SUBJECT', '[TESTIMONIAL SUBMISSION]');
define('EMAIL_OWNER_TEXT', 'Un nuovo giudizio è stato rilasciato a ' . STORE_NAME . '. Non è ancora stato approvato. Verifica il giudizio e pubblicalo.' . "\n\n");
define('EMAIL_GV_CLOSURE','Cordiali saluti,' . "\n\n" . STORE_OWNER . "\nStore Owner\n\n". '<a href="' . HTTP_SERVER . DIR_WS_CATALOG . '">'.HTTP_SERVER . DIR_WS_CATALOG ."</a>\n\n");
define('EMAIL_DISCLAIMER_NEW_CUSTOMER', 'Questa e-mail ci è stata fornita da te o da qualche tuo conoscente durante l\'inserimento di un feedback . Se ritieni di non aver mai rilasciato feedback, o hai ricevuto questa e-mail per errore, scrivici una e-mail a %s ');
////////////////
define('TABLE_HEADING_TESTIMONIALS', 'Giudizio del cliente');
define('TESTIMONIAL_CONTACT', 'Informazioni di contatto');
define('TEXT_TESTIMONIALS_TITLE', 'Titolo:');
define('TEXT_TESTIMONIALS_NAME', 'Nome:');
define('TEXT_TESTIMONIALS_MAIL', 'E-mail:');
define('TEXT_TESTIMONIALS_COMPANY', 'Ditta:');
define('TEXT_TESTIMONIALS_CITY', 'Città:');
define('TEXT_TESTIMONIALS_COUNTRY', 'Stato:');
define('TEXT_TESTIMONIALS_HTML_TEXT', 'Giudizio');
define('TEXT_TESTIMONIALS_DESCRIPTION', 'Testo:');
define('TEXT_TESTIMONIALS_DESCRIPTION_INFO', '<li><strong>Il testo deve essere compreso tra ' . ENTRY_TESTIMONIALS_TEXT_MIN_LENGTH . ' & ' . ENTRY_TESTIMONIALS_TEXT_MAX_LENGTH . ' caratteri!</strong></li>');
define('TEXT_CAPTCHA_INFO', '<li><strong>Verification Code is case insensitive</strong></li>');
define('RETURN_REQUIRED_INFORMATION', ' = Dati obbligatori<br />');
define('RETURN_OPTIONAL_INFORMATION', ' = Dati facoltativi');
define('RETURN_OPTIONAL_IMAGE','optional.gif');
define('RETURN_OPTIONAL_IMAGE_ALT', 'optional information');
define('RETURN_OPTIONAL_IMAGE_HEIGHT', '12');
define('RETURN_OPTIONAL_IMAGE_WIDTH', '12');
define('RETURN_REQUIRED_IMAGE', 'star.gif');
define('RETURN_REQUIRED_IMAGE_ALT', 'required information');
define('RETURN_REQUIRED_IMAGE_HEIGHT', '12');
define('RETURN_REQUIRED_IMAGE_WIDTH', '12');
define('RETURN_WARNING_IMAGE', 'exclamation.gif');
define('RETURN_WARNING_IMAGE_ALT', 'warning');
define('RETURN_WARNING_IMAGE_HEIGHT', '16');
define('RETURN_WARNING_IMAGE_WIDTH', '16');
define('TEXT_TESTIMONIAL_LOGIN_PROMPT','Devi registrarti o accedere al tuo account per poter inserire un giudizio.');
define('ERROR_TESTIMONIALS_NAME_REQUIRED', '<span class="alert"><strong>Il nome è obbligatorio!</strong></span>');
define('ERROR_TESTIMONIALS_EMAIL_REQUIRED', '<span class="alert"><strong>Il tuo indirizzo e-mail è obbligatorio!</strong></span>');
define('ERROR_TESTIMONIALS_TITLE_REQUIRED', '<span class="alert"><strong>Il titolo è obbligatorio!</strong></span>');
define('ERROR_TESTIMONIALS_DESCRIPTION_REQUIRED', '<span class="alert"><strong>Il testo è obbligatorio!</strong></span>');
define('ERROR_TESTIMONIALS_TEXT_MAX_LENGTH', '<span class="alert"><strong>Inserisci meno di ' . ENTRY_TESTIMONIALS_TEXT_MAX_LENGTH . ' characters!</strong></span>');
define('ERROR_TESTIMONIALS', 'Ci sono degli errori! Per favore correggi e re-inserisci!');
//EOF
I would like that customers can add surname in the form and don't want that the form is already filled! how?
You will need to modify the following files:
includes/modules/pages/testimonials_add/header_php.php
includes/templates/YOUR_TEMPLATE/templates/tpl_testimonials_add_default.php
You will need to add the specific fields you want to include as well as the error handling for those fields.
I just wanted to send a BIG Thank you out to Clyde Jones for the Testimonial Manager contribution. I downloaded it and installed it on my local WAMP server and FTP'd to my production server without a hitch.
You did an awesome job on this and I really appreciate your contributing this tool.
Thanks - Michael Stein
On version 1.3.8a
:bigups:
Awesome mod.. but I am having an issue with Internet Explorer v7.0 (surprise!! :censored:) Please help! I've searched this thread and the forum, and I haven't seen anyone report a similar issue..
The Quote images superimpose themselves over one another in the upper left hand corner.. I'm pretty sure this is going to require some stupid IE hack.. I am just clieless as to what this might be..
Link: http://clients.overthehillweb.com/ha...l_testimonials
I see you resolved your problem. That's great. It got me thinking so I checked the following browsers and they all look good:
IE6
IE7
IE8
Google Chrome
Firefox
That's some good cross browser code!
Thanks for creating such an excellent mod.
I have the Simple SEO Urls installed on my site and I have a slight glitch. When the back button is clicked on any page the user gets page not found. I know that I can exclude pages from the Simple SEO urls and I've experimented without joy. Help would be appreciated.
You'll have to check the support thread for simple seo.
you might also want to look at the bug fix for the back button posted here: www.zen-cart.com/forum/showpost.php?p=547637&postcount=20
Just wanted to add to this that I've not had this particular issue with this add-on and SEO. I also have done this bug fix change to correct the back button bug that Clyde references.
However Clyde I am having another error/strange behavior with this mod and your Retruns Authorization add-on and Simple SEO. (Both errors are similar)
The problem is this: I have "Only registered customers may submit a testimonial" set to true. So when the user tries to create a testimonial and they are not logged in the user is presented with the login page. (so far so good..) after they enter their login information, instead of being redirected back to the testimonial entry form, they are redirected back to Zen's main page.
What happens with returns is similar in nature.. But I'll post that on the returns support thread..
hi, when i fill in the testimonial blank fields in chinese, it;s show wrong code n can't show my chinese words properly, i have code converter software, but i dun know which files should i change, may i know which files effect the fields coloums? thanks!
I do not see this option under Admin > Tools.Quote:
Admin -> Tools -> Testimonials Manager allows administrators to create & edit testimonials
Everything else installed fine other than receiving these errors:
https://www.zen-cart.com/forum/showp...&postcount=870
The sidebox shows up when turned on (but turned it off for now, since I cannot delete the demo testimonial)
Ideas?
make sure you've uploaded ALL of the following:
admin/testimonials_manager.php
admin/includes/boxes/extra_boxes/testimonials_manager_tools_dhtml.php
admin/includes/extra_datafiles/testimonials_manager.php
admin/includes/functions/extra_functions/testimonials_manager_functions.php
admin/includes/languages/english/testimonials_manager.php
admin/includes/languages/english/extra_definitions/testimonials_manager.php
admin/includes/languages/english/images/buttons/button_new_testimonial.gif
I did. And just in case, I just did it again... I still do not see the option in the Tools menu.
Before uploading everything I ran the files with WinMerge to verify if there were any conflicts. There were no files being overridden. I also modified the stylesheet.css file. I have not modified the meta_tags file yet.
I am running Zen Cart 1.3.8a with all security patches applied.
This contribution is great. Thank you Clyde.
Everything seems to be working fine for me now. Below are further comments and questions.
Tweak: to make this side box similar to the Reviews one, instead of “false”, I set the "title link" to display_all_testimonials in includes/modules/sideboxes/YOUR_Template/testimonials_manager... and turned off the link at the bottom.
1. Minor bug: When adding a testimonial from the admin, if you insert a past date and forget to fill out a required field or if you do not format the date as suggested, after giving you an error it will change the date field to a random date. You cannot modify that date from the admin once you submit the testimonial. To correct that you need to delete and reenter the testimonial.
2. Is there an easy admin fix to change just the “Testimonial submission” email address sent to the store owner? Or should I change that in the code (and where/how)?
3. I would like to have the single testimonial breadcrumbs to be a sub-page of the All Testimonials page, using a tweak similar to this for EZ-Pages:
http://www.zen-cart.com/forum/showpo...40&postcount=7
Any ideas on how to implement that?
4. Is there a way to allow customers to upload their own picture?
5. Is it possible for the side box to rotate only the testimonials that do have pictures?
6. For a future update, the language in the submission email has a minor misspelling :"Please verify thie testimonial and activate."
2. Is there an easy admin fix to change just the “Testimonial submission” email address sent to the store owner? Or should I change that in the code (and where/how)?
The e-mail address used is the one you have set in admin -> configuration -> e-mail options.
If you want to change it to something else then you will have to define the new e-mail address in:
includes/languages/english/YOUR_TEMPLATE/testimonials_add.php
Now you will need to modify the section that sends the admin e-mail in
includes/modules/pages/testimonials_add/header_php.php
4. Is there a way to allow customers to upload their own picture?
Currently, No.
5. Is it possible for the side box to rotate only the testimonials that do have pictures?
Currently, No.
Thank you.
What are the specific lines of code that accomplish that in those files?
I am guessing the code is pulling up the default STORE_OWNER_EMAIL_ADDRESS? Do you think it could be substituted with the Reviews email address that is set within the E-Mail options?
I would like to change this only for the Submission emails sent to the store owner however, not to emails sent to customers. Those should still keep the default store email address...
Thanks.
As I explained you'll need to define the new e-mail address in
includes/languages/english/YOUR_TEMPLATE/testimonials_add.php
define('TESTIMONIAL_EMAIL_ADDRESS', 'mynewemailaddress');
Now you will need to modify the section that sends the admin e-mail in
includes/modules/pages/testimonials_add/header_php.php
look for the following section: lines 119 - 121)
////SEND ADMIN EMAIL
zen_mail($name, STORE_OWNER_EMAIL_ADDRESS, EMAIL_OWNER_SUBJECT, EMAIL_OWNER_TEXT, STORE_NAME, EMAIL_FROM, $html_msg, 'testimonial_add');
You need to substitute STORE_OWNER_EMAIL_ADDRESS with TESTIMONIAL_EMAIL_ADDRESS
Ok, that is starting to make sense. Thank you. :smile:
Instead of defining a new email address (which I am guessing can be picked up by spiders in there), is there a list of available "Send Copy of" email addresses listed in Admin > Configuration > E-Mail Options?
For example, in this case, instead of using STORE_OWNER_EMAIL_ADDRESS I could use the same email address used to get an alert that a review is pending. Where can I find a list that tells me the name of that code. I am guessing it should be something like PENDING_REVIEW_EMAIL_ADDRESS if it exists.
That way I could change the email address in the admin if needed.... I am having no luck with the Developers Tool Kit in finding where those email addresses have been defined already.
I still don't understand the structure of Zen Cart, but I am guessing that all email addresses reside in the database, they are defined in admin (email options) and then they are called in the catalog from the admin... so if STORE_OWNER_EMAIL_ADDRESS calls the main email address for the store, then some other code should be calling the email address for pending reviews...
Where should I start looking?
Right.
In there, this option "Email Address (sent FROM)" refers to this code:
STORE_OWNER_EMAIL_ADDRESS
But how do I figure out what is the code that refers to this option:
"Send Notice of Pending Reviews Emails To"
so that I can substitute it in your mod as you suggested?
If I plug that sentence in the Developers Tool Kit it returns nothing.
This is basically what I have been trying to ask.
Unless I am missing something.
I am just trying to learn. I pointed out 2 bugs and a useful tweak, which was my way to contribute back to the discussion... am I being annoying, or I am not asking the right questions?
Thank you.
Version 1.3.8
I've used your Testimonial manager for another site I created with no problems. Thanks.
I'm attempting to create a new site by copying my previous site, and everything else about the new site is working fine, except for the Testimonial manager. It appears that none of the 'define' variables can be found and the variable names themselves show up on the page, for instance: TESTIMONIALS_MANAGER_DISPLAY_ALL_TESTIMONIALS shows up instead of the words "View all Testimonials".
On my new site, I renamed all of the template folders to a new name, including those related to the testimonial manager. I don't understand why the define pages can not be found. For example, there is a file called tpl_testimonials_manager.php. In it, there is a line that uses a defined constant: TESTIMONIALS_MANAGER_ADD_TESTIMONIALS. This page is located in inlcludes/templates/mytemplate/sideboxes. The defined constant is located in: includes/languages/english/extra_definitions/mytemplate/testimonials_manager_defines.php. It's as if it can't find any of the defined vars. Any ideas? Is there something that could get messed up during my site copy process that would make the testimonial manager scripts lose their defined vars? By the way, I tried uninstalling the entire testimonial add on, then reinstalling it. It still acts the same way. Suggestions? Thanks!!!
hi, i can't will my chinese code in the testimonials,, do u have any latest version to support UTF-8, i have code converter software but i dun know which files to effect this..
oh my god,, so will u issue a latest version to support UTF-8? i looking forward on this,, thanks!:blink:
run this sql patch using the Zen-Cart Sql Patches tool (admin -> tools -> install sql patches)
copy and past this code into the text area and click the send button.
Code: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`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
Hi there again,
I was working on the site locally on my Windows PC (WAMP), when you asked for the URL, so I decided to upload what I had done at this point. What's interesting is that everything works correctly after I uploaded the whole site. The url to the correctly working, copied site is: http://pursebling.com. If you look at the bottom left sidebox, you will see that the testimonial box is displaying correctly. However, on my local machine it looks like this:
http://pursebling.com/test_pic.jpg
So to recap:
It's working in the following conditions:
- Locally for my memoriesinchocolate.com site.
- Production server for memoriesinchocolate.com
- Production server for pursebling.com
It's not working for my local version of pursebling.com (which I copied the entire site up to the production server a few minutes ago).
Any ideas?
It works! Thank you :smile: I wish I had some of your php genius.
In brief, here is the How To:
If you need Testimonial Manager to send Testimonial Submission updates to the same email address used to alert the store admin about Review submissions, follow these instructions:
... with this code: SEND_EXTRA_REVIEW_NOTIFICATION_EMAILS_TO
Hi Clyde,
How can I add a link "Testimonial" in Information Sidebox which will point to all testimonial page.
I do not want to display in seperate side box.
Thanks in advance.
open includes/modules/sideboxes/YOUR_TEMPLATE/informtion.php
add the following where you want the link to appear.
Code:$information[] = '<a href="' . zen_href_link(FILENAME_TESTIMONIALS_MANAGER_ALL) . '">' . TESTIMONIALS_MANAGER_DISPLAY_ALL_TESTIMONIALS . '</a>';
Many Thanks. Worked perfectly.
2 questions:
1. In the downloads section it states the most current version is 1.5. However, in the readme file, the support link goes to the first post which states there is a v1.7 available - a little clarification please. Is 1.7 avail?
2. I received the following error for the sql patch:
Error
SQL query:
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('
);
MySQL said: Documentation
#1062 - Duplicate entry 'IH_VERSION' for key 2
Any ideas on what to do, thanks.
1 - I think it actually says that "Testimonial Manager 1.3.7 is available in the downloads section" (the current version is 1.5
2 - This can be safely ignored. It means that there is already an entry for that information in the data base and that particular statement will be ignored.
Hi Clyde,
This is really just for anyone else who might be having the same issue I did (errors when running the sql patch for new installs.)
Just an FYI, I had to comment out lines 56-59 in the sql file for new installs. I had to go one by one until I finally got a success message from phpmyadmin. I'm assuming its because I do have a number of addons installed on my site.
Hope that helps someone else save some time.
ok i just installed this and where on the stylesheet do I place :
.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;
}
metatags
//TESTIMONIALS:
case 'testimonials_manager_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']);
break;
open includes/templates/YOUR_TEMPLATE/css/stylesheet.css
scroll to the bottom of the page and add the following
.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;
}
the other section is used to add meta tags when vewing your testimonial pages and is not included in the stylesheet.
There are instruction earlier in this support thread on add the meta tag section (I just don't remember where exactly)
I downloaded this mod from the free software section and installed it. I added the below code to /includes/modules/mytemplatename/meta_tags.php
Did this code need to be added to the meta_tags.php file or was that supplied for upgrades?Quote:
//TESTIMONIALS:
case 'testimonials_manager_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']);
break;
After adding it to the file, this string is showing up in the top/title of the browser window bar along with the title of the comment.
META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER
Clyde, first of all, thanks for all your contributions. I wanted to verify whether this was the proper way to add the code to the metatags.php.
When adding:
I get the following on my metatags:PHP Code:
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']);
When deleting "META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER"HTML Code:<title>META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGERGreat</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<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?" />
as inmy meta tags show as they should...PHP Code:
define('META_TAG_TITLE', $page_check->fields['testimonials_title']);
define('META_TAG_DESCRIPTION', zen_trunc_string($page_check->fields['testimonials_html_text'],TESTIMONIALS_MANAGER_DESCRIPTION_LENGTH));
define('META_TAG_KEYWORDS', $page_check->fields['testimonials_title']);
Will doing so will create any problems with other pages? I ask because I assume the original code worked for you and you added it for a reason...HTML Code:<title>Great</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<meta name="keywords" content="Great" />
<meta name="description" content="This is just a test submission to show you how it looks, great, eh?" />
Thanks
Hello,
Firstly thanks Clyde (again!) for a superb add on :smile:
Two questions:
(I have searched this thread but to no avail.)
1: Would it be possible to display the Testimonials sidebox only on the Home page?
2: Can I add the 'index.php?main_page=display_all_testimonials' page to the site map?
Thanks.
To answer question #1 visit this page on the zencart tutorial.
To answer #2 visit this page "How to edit SiteMap links in ZenCart".
Hope that helps...
Thanks for the reply,
I managed to add the relevant link to the sitemap so thanks for that usefull link. However Im still struggling with the sidebox question. Heres my /modules/sideboxes/my_template/testimonials_manager.php file as is:
<?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.0 1-9-2009 Clyde Jones $
*/
// test if box should display
$page_query = $db->Execute("select testimonials_id, testimonials_image, testimonials_title, testimonials_html_text, date_added from " . TABLE_TESTIMONIALS_MANAGER . " where status = 1 and language_id = " . (int)$_SESSION['languages_id'] . " order by rand(), testimonials_title limit " . MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES ."");
if ($page_query->RecordCount()>0) {
$title = BOX_HEADING_TESTIMONIALS_MANAGER;
$box_id = testimonials_manager;
$rows = 0;
while (!$page_query->EOF) {
$rows++;
$page_query_list[$rows]['id'] = $page_query->fields['testimonials_id'];
$page_query_list[$rows]['name'] = $page_query->fields['testimonials_title'];
$page_query_list[$rows]['story'] = $page_query->fields['testimonials_html_text'];
$page_query_list[$rows]['image'] = $page_query->fields['testimonials_image'];
$page_query->MoveNext();
}
$left_corner = false;
$right_corner = false;
$right_arrow = false;
$title_link = false;
require($template->get_template_dir('tpl_testimonials_manager.php',DIR_WS_TEMPLATE, $current_page_base,'sideboxes'). '/tpl_testimonials_manager.php');
require($template->get_template_dir($column_box_default, DIR_WS_TEMPLATE, $current_page_base,'common') . '/' . $column_box_default);
}
//EOF
Im not sure how, what or where to add the relevant code mentioned here: https://www.zen-cart.com/tutorials/i...hp?article=270 :blush:
Any helps much appreciated :smile:
Try this:
PHP Code:
if ($this_is_home_page) {
$page_query = $db->Execute("select testimonials_id, testimonials_image, testimonials_title, testimonials_html_text, date_added from " . TABLE_TESTIMONIALS_MANAGER . " where status = 1 and language_id = " . (int)$_SESSION['languages_id'] . " order by rand(), testimonials_title limit " . MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES ."");
if ($page_query->RecordCount()>0) {
$title = BOX_HEADING_TESTIMONIALS_MANAGER;
$box_id = testimonials_manager;
$rows = 0;
while (!$page_query->EOF) {
$rows++;
$page_query_list[$rows]['id'] = $page_query->fields['testimonials_id'];
$page_query_list[$rows]['name'] = $page_query->fields['testimonials_title'];
$page_query_list[$rows]['story'] = $page_query->fields['testimonials_html_text'];
$page_query_list[$rows]['image'] = $page_query->fields['testimonials_image'];
$page_query->MoveNext();
}
$left_corner = false;
$right_corner = false;
$right_arrow = false;
$title_link = false;
require($template->get_template_dir('tpl_testimonials_manager.php',DIR_WS_TEMPLATE, $current_page_base,'sideboxes'). '/tpl_testimonials_manager.php');
require($template->get_template_dir($column_box_default, DIR_WS_TEMPLATE, $current_page_base,'common') . '/' . $column_box_default);
}
}
Yea that worked perfectly, Thanks Clyde :smile:
I had the testimonials running on my site. I changed templates, and now it's not running correctly anymore. The testimonials are there....
but when I go to turn on the sidebox, I can see it there....
sideboxes/a_pink_boutique/testimonials_manager.php
I clidk on edit, add to the left column, click update, and it takes me back to my main admin page, out of the layout boxes completely.
I reinstalled all the files, from the newest version, ran the upgrade, and again, I can see all the testimonials are there, but I still can't add them to my sidebox.
well, this looks to be something related to something else, because I am having the same problem when I'm adding a link to my ez pages...it just pops straight back to the admin screen
Hi Clyde!
Yes, sorry I didn't get back to this thread to update!
I did the security patch, earlier in the day, and things worked fine for about 3 hours, then all of a sudden this started happening.
Searching more, I found that it was the security patch causing it, and have since reuploaded the htmp_output file back...and it's all working correctly now!
Hi to all, I have zen car 1.3.8 and when I install testimonial manager 1.5.0's sql patch via admin panel I have this error
What I have to do? to fix this?Quote:
33 statements processed.
Error ERROR: Cannot insert configuration_key "PRODUCTS_OPTIONS_TYPE_SELECT" because it already exists
Error ERROR: Cannot insert configuration_key "UPLOAD_PREFIX" because it already exists
Error ERROR: Cannot insert configuration_key "TEXT_PREFIX" because it already exists
Error ERROR: Cannot insert configuration_key "IH_VERSION" because it already exists
Error ERROR: Cannot insert configuration_key "IH_VERSION" because it already exists
Warning Note: 4 statements ignored. See "upgrade_exceptions" table for additional details.
Anyway it seems that testimonial manager work correctly but I don't want that this error make some error in the shop...
thansk
really thanks
Hello,
Installed this mod and everything seems to work fine! Awesome module!
Just wondering, is it possible to get the testimonial sidebox to look like our "Information Burst" sidebox (www.playnippon.com)? We would like to show 10 testimonial but would like to have a scroll bar and a background color.
Thanks
Hello, thank you for this mod, is really working great on both my new websites, but I have a problem trying to install the captcha.
I can't access the fix for the captcha that is referenced in this post http://www.zen-cart.com/forum/showpo...&postcount=807
Would it be possible to post it on the forum so everyone could benefit from it?
Thanks!
as requested:
Attachment 7033
WONDERFUL! Thank you!!!
hiya
ive just installed this to my new shop and i went to install the sql file and got this error
SQL query:
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
)
MySQL said:
#1062 - Duplicate entry 'PRODUCTS_OPTIONS_TYPE_SELECT' for key 2
and at the top of the admin page:
33 statements processed.
ERROR: Cannot insert configuration_key "PRODUCTS_OPTIONS_TYPE_SELECT" because it already exists
ERROR: Cannot insert configuration_key "UPLOAD_PREFIX" because it already exists
ERROR: Cannot insert configuration_key "TEXT_PREFIX" because it already exists
Note: 3 statements ignored. See "upgrade_exceptions" table for additional details.
and how do you turn the email option off? i cant find it anywhere as i really dont require customes to put in their email addy to make a review
any ideas?
thanks
edit to add.... i seem to have it working in the admin but nothing showing up in the shopfront