Reviews - Updated [Support Thread]

This is the support thread for the (just submitted) Reviews - Updated plugin. This plugin provides updates to the standard Zen Cart processing of reviews for your products:
* Reviews can be written by guests, controlled by an admin configuration value.
* For customer privacy, reviews written by logged-in customers include only their first name and the first letter of their last name (e.g. John Smith becomes John S.).
* Upon successful review submission, a message is displayed to the customer indicating that their review has been received.
* If the customer is required to sign in (or register) prior to writing a review, a message indicating as such is displayed on redirect to the login page.

There are core-file overwrites and SQL database changes associated with this plugin.

Hi

Is this for 1.5 ,also is there a link we can use to download it

thanks

Quote:

---

Originally Posted by ATSWorld

Hi

Is this for 1.5 ,also is there a link we can use to download it

thanks

---

I have tested this for v1.5.0 only (although it should work on v1.3.9 as well).

Once it's posted to the Plugins area, it will be available here: http://www.zen-cart.com/downloads.php?do=file&id=1442.

Thanks ..Will just have to wait for it to be released

This is now available in the Plugins area: http://www.zen-cart.com/downloads.php?do=file&id=1442

what a beauty .. Backed up everything 1st and tested & installed, worked fine on my site
Only thing is the name if you submit less than 5 letter it fails

Code:

---

Your Name needs to have at least 5 characters.

---

I've added text in the English

Thanks for a great add-on

There's an admin configuration switch that controls the minimum length of the guest reviewer's name:

Configuration->Minimum Values->Product Review Write - Guest Reviewer Name

The default value is 5.

On another topic, I was informed by swguy that if you run the SQL install patches using your admin's Tools->Install SQL Patches that the tool "takes care of" the database prefix settings in your configuration. In other words, you can use the SQL patches provided in the plugin as-is even if you use a database prefix (DB_PREFIX in your configure.php files is set to something other than ''). I'll update the readme file to reflect this in a subsequent release.

:blush: oops you are correct..never thought of the most simplest of things
thank you again

Could admin reply the review? or once a review posted, send an email to admin?

Your admin could reply to the review by writing a new review on the product and entering Store Owner in the "Your Name" field.

There are configuration values in your admin's Configuration->E-mail Options that will enable sending an email when a review is posted:

Send Notice of Pending Reviews Emails To - Status: Enables (1) or disables (0) the sending of the email to the list specified by ...
Send Notice of Pending Reviews Emails To: A list of email addresses to receive the notice of a pending/posted review

I'm about to try this addon .. but... is there a way to use the 'write a review' from the home page? I want someone to just send a general review from the front page rather than having to drill down to a product..
Yolanda

Nevermind... I am using the Testimonials addon that works good for me.

Best
Yolanda

Quote:

---

Originally Posted by Yolanda

I'm about to try this addon .. but... is there a way to use the 'write a review' from the home page? I want someone to just send a general review from the front page rather than having to drill down to a product..
Yolanda

---

Due to the CSS anti-spam feature addition in Zen-Cart v1.5.1, this module requires an update to be v1.5.1-ready; it's on my (ever-growing) to-do list.

I've uploaded v1.1.0 to the Plugins area to include the CSS anti-spam feature; I'm guessing that it will be available for download over the weekend.

v1.1.0 is now available in the Plugins area ...

hi. can anyone help me remotely to install this "reviews" to my website? just buzzz me on my yahoo id: colgate_21
tnx.

Installed on 1.5.0 Zencart - Enable Product Reviews By Guests is set to 1 but clicking any "Write a review" link still goes to sign in / account creation page. Setting to 0 goes to the same page (but also displays a message saying you have to log in to write a review).

Any idea why guests cant review even with this installed? Copied over files and did sql patch.

Did you change the two YOUR_TEMPLATE directory names to your custom template's name before copying the files over? I just installed this on a test Zen Cart 1.5.0 store and it's working fine ...

I did change the directory names to my template names and also applied the sql patch. Any time I click a write review link I am directed to the create account / login page.

Example page:
http://idosersoftware.com/index.php?...r_of_uploads=0

Are you sure you copied the file /includes/modules/pages/product_reviews_write/header_php.php? If so, the redirect to the login page should be accompanied by a message in the header that reads "You need to sign into your account to write a review.".

Yes, I am sure that the header_php.php is in the includes/modules/pages/product_reviews_write

I do see the warning when Enable Product Reviews By Guests is set to 0 (off). Then it says you must log in. However, when set to 1 to allow, it still redirects to the login/account creation page but does not show the warning. Does not allow gusts to write even though Enable Product Reviews By Guests is set to 1

Would you please post the contents of your /includes/modules/pages/product_reviews_write/header_php.php file?

Could you check in your /includes/modules/pages/product_reviews_write directory and make sure that there's not a file named header_php-original.php or something similar?

If so, rename that file to something like header_php.php.original ... just so it DOESN'T have a .php file extension.

Zen Cart's default handling will load all files in that directory that start with header_php and have a file extension of .php.

Quote:

---

Originally Posted by lat9

Could you check in your /includes/modules/pages/product_reviews_write directory and make sure that there's not a file named header_php-original.php or something similar?

---

This was the problem. I had changed file names to _BACKUP.php but they still had the php extension. Changing them as you suggested fixed this.

Thank you kindly.

Great! I'm glad you got it sorted out.

Getting this on the right hand side of the image was fine on my test site [VSS/80WFSFFPLDBSC]">http://www.rvsolarsystems.co.uk/Free...roller/Reviews

Quote:

---

Originally Posted by discoverytdi

Getting this on the right hand side of the image was fine on my test site [VSS/80WFSFFPLDBSC]">http://www.rvsolarsystems.co.uk/Free...roller/Reviews

---

OK still had Testimonials Manager side box active :blush:

spoke too soon
I'm getting two pages for my reviews if I click on the reviews side box I get this page http://www.rvsolarsystems.co.uk/Free...w?reviews_id=1 which is fine and as it should be
fi I click on the read reviews link on the product page I get http://www.rvsolarsystems.co.uk/Free...roller/Reviews and it's all messed up. Any help appreciated

This plugin only makes modifications to the product_reviews_write page, so what you're seeing on the reviews and product_reviews pages are based on any customizations you've made there. I went to your site, clicked on the sidebox "Reviews" link, clicked on one of the "Products Details" buttons, clicked on the "Read Reviews" button from there, then back to "Product Details" and all looked OK-fine to me.

Perhaps if you'd list a specific sequence of clicks that result in the unwanted behavior I could provide more information, but at this point I don't see what's wrong.

DivaVocals had the solution it was zen lightbox apparently it's a known issue.

Hi
Not sure if this has been mentioned before but while doing SEO using seo doctor on firefox my title tags had 2 H1 tags causing errors .
I eventually found it (with a little help :) ) to be the reviews on every product page

I changed includes/template/your template/ template/tpl_product_reviews_write_default
line 12
<h1 id="reviewsWriteHeading"><?php echo $products_name . $products_model; ?></h1>
and changed the h1 tags to h2 which then fixed my double tag issues.
So not sure if it is an error or just my template or just me..

thanks

ATSWorld, since there's only one <h1> tag in the tpl_product_reviews_write_default.php file that comes with this plugin and since the "standard" Zen Cart behavior is to have this page (product_reviews_write) as a stand-alone page, I'm guessing that it's an issue with your template.

From what you've said, the template seems to be imbedding the contents of the product_reviews_write page into the product_info page.

@lat9. quick question. how does the details of guest reviewers get stored? does it create a dummy account in table cutomers?
I ask because isnt this where the standard reviews module pulls the info from?

if it does create a dummy account does this cause problems if the user trys to create an account later?

Thanks

Phil, the only detail stored for a guest reviewer is the name they entered. All of the reviews information is stored in the reviews table, which is customer-independent and contains its own field for the 'customers_name' (i.e. the name of the reviewer). The only difference for a guest reviewer is that the customer_id value that's stored is 0 (since there's no id associated with them).

Quote:

---

Originally Posted by lat9

Phil, the only detail stored for a guest reviewer is the name they entered. All of the reviews information is stored in the reviews table, which is customer-independent and contains its own field for the 'customers_name' (i.e. the name of the reviewer). The only difference for a guest reviewer is that the customer_id value that's stored is 0 (since there's no id associated with them).

---

Fantastic, thanks for clarifying :o) will install tonight!

@lat9

Works perfect thank you!

just one thing, is it possible to move the notification message:
Your review has been submitted for approval.

so that instead of coming up above the top of the website, have it like the one on the product info page does if you try and add items to cart without selecting required attributes etc?

I want the message to show around the area the form is?

Thanks

do I change this:
$messageStack->add_session('header', REVIEWS_APPROVAL == '1' ? MESSAGE_REVIEW_SUBMITTED_APPROVAL : MESSAGE_REVIEW_SUBMITTED, 'success');

to this:
$messageStack->add_session('review_text', REVIEWS_APPROVAL == '1' ? MESSAGE_REVIEW_SUBMITTED_APPROVAL : MESSAGE_REVIEW_SUBMITTED, 'success');

is that what will make it output by this one:
<h1 id="reviewsWriteHeading"><?php echo $products_name . $products_model; ?></h1>
<?php if ($messageStack->size('review_text') > 0) echo $messageStack->output('review_text'); ?>

??

Quote:

---

Originally Posted by philip937

do I change this:
$messageStack->add_session('header', REVIEWS_APPROVAL == '1' ? MESSAGE_REVIEW_SUBMITTED_APPROVAL : MESSAGE_REVIEW_SUBMITTED, 'success');

to this:
$messageStack->add_session('review_text', REVIEWS_APPROVAL == '1' ? MESSAGE_REVIEW_SUBMITTED_APPROVAL : MESSAGE_REVIEW_SUBMITTED, 'success');

is that what will make it output by this one:
<h1 id="reviewsWriteHeading"><?php echo $products_name . $products_model; ?></h1>
<?php if ($messageStack->size('review_text') > 0) echo $messageStack->output('review_text'); ?>

??

---

It would ... if the message was going to be displayed by the product_reviews_write page. However, upon successful recording of the review, the reviews_write processing causes a redirect to the product_reviews page and there's no messaging used by the as-shipped page template (that's why the message is sent to the header, which is available on all pages).

So, you have two choices:

1. Change /includes/modules/pages/product_reviews_write/header_php.php to change the message stack location and comment-out the redirect to the product_reviews page (on line 138).
2. Change /includes/modules/pages/product_reviews_write/header_php.php to change the message stack location and also edit your template's version of /includes/templates/YOUR_TEMPLATE/templates/tpl_product_reviews_default.php to add the code
   PHP Code:

   ---

   <?php if ($messageStack->size('review_text') > 0) echo $messageStack->output('review_text'); ?>

   ---

   where you want the message displayed.

With ya totally. Didn't notice the redirect. I think I'll just move the header output down to just below the top nav, that should be sufficient :-)

Cheers

Hi, I noticed two bugs of this module.
1.it only accounts for newly written review.
2. In admin review page,customers' name are shown the same as reviews.php in front website page. I want the customer's full name are shown in admin review page.
Can you solve this two bugs?
Thanks!

Quote:

---

Originally Posted by asdfwen

Hi, I noticed two bugs of this module.
1.it only accounts for newly written review.
2. In admin review page,customers' name are shown the same as reviews.php in front website page. I want the customer's full name are shown in admin review page.
Can you solve this two bugs?
Thanks!

---

Don't you think that these are requests, no 'bugs'?

Quote:

---

Originally Posted by picandnix

Don't you think that these are requests, no 'bugs'?

---

As picandnix indicated, the behavior you've identified is how the module was designed to work; it only accounts for newly-written reviews and the reviewer name shows up the same in the admin.

I have a couple of things...
1. message stack/notice is not showing up when customer is not logged in and tries to write a review with Enable product reviews by guests? set to 0.

2. I had previously added reply to reviews functionality to my 1.3.9h store. I am trying to add it to this with some problems. I am hoping that someone notices and can correct my mistake/s and/or omissions.
All I have been getting is a blank page with no right side boxes, and no myDebug out put either...??? :frusty:
here is a list of my mods...

SQL

Code:

---

ALTER TABLE  `reviews_description`
  ADD  `reviews_reply_text` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;

---

modules/pages/product_reviews_info/header_php.php:

Code:

---

// addition of reviews_reply_text below

  $review_info_query = "SELECT rd.reviews_text, r.reviews_rating, r.reviews_id, r.customers_name,  rd.reviews_reply_text,

                              r.date_added, r.reviews_read, p.products_id, p.products_price,

                              p.products_tax_class_id, p.products_image, p.products_model, pd.products_name

                        FROM " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd

                        WHERE r.reviews_id = :reviewsID

                        AND r.reviews_id = rd.reviews_id

                        AND rd.languages_id = :languagesID

                        AND r.products_id = p.products_id

                        AND p.products_status = '1'

                        AND p.products_id = pd.products_id

                        AND pd.language_id = :languagesID " . $review_status;



  $review_info_query = $db->bindVars($review_info_query, ':reviewsID', $_GET['reviews_id'], 'integer');

  $review_info_query = $db->bindVars($review_info_query, ':languagesID', $_SESSION['languages_id'], 'integer');

  $review_info = $db->Execute($review_info_query);



  $products_price = zen_get_products_display_price($review_info->fields['products_id']);



  $products_name = $review_info->fields['products_name'];

//addition of reviews reply
  if ($review_info->fields['reviews_reply_text']) != '') {
                $reviews_reply_text = $review_info->fields['reviews_reply_text'];
                }

  if ($review_info->fields['products_model'] != '') {

    $products_model = '<br /><span class="smallText">[' . $review_info->fields['products_model'] . ']</span>';

  } else {

    $products_model = '';

  }

---

languages/english/YOUR_TEMPLATE/product_reviews_info.php

Code:

---

define('TEXT_OF_5_STARS', '');

define('TEXT_PRODUCT_INFO', 'Take Me to the Details');

define('TEXT_REVIEW_ADDITIONAL', 'Read More Reviews');
//addition of review reply heading
define('TEXT_REVIEW_REPLY_HEADING','<strong>' . STORE_NAME . ''s Reply:</strong>');

---

templates/YOUR_TEMPLATE/templates/tpl_product_reviews_info_default.php

Code:

---

ADDED TO THE BOTTOM, JUST BEFORE THE LAST </div>

<!--bof Reviews Reply -->

<br class="clearBoth"/>

<?php
if ($reviews_reply_text) != ''){
?>
<div id="reviewsInfoDefaultMainContent" class="content"><?php echo TEXT_REVIEW_REPLY_HEADING; ?><br /><?php echo zen_break_string(nl2br(zen_output_string_protected(stripslashes($review_info->fields['reviews_reply_text']))), 60, '-<br />'); ?></div>

<?php } ?>
<!--eof Reviews Reply-->
</div>

---

My hope is to get this working properly, and then add the ability to write your reply on the "edit review" page in the admin. I am currently just writing the reply's through phpMyAdmin and then approving the review there.

The working 1.3.9 version of this is here

Non working 1.5.1 is here - (this store is not yet public!)

Ok, so the reply is working now. Once I get the edit aspect of it working I'll post it!

Quote:

---

Originally Posted by mikestaps

I have a couple of things...
1. message stack/notice is not showing up when customer is not logged in and tries to write a review with Enable product reviews by guests? set to 0.

---

I'm not sure what notice you're expecting, but on a "stock" Zen Cart v1.5.1 install with this plugin installed ... if "Enable product reviews by guests?" is set to 0, the "Write Reviews" button still shows but clicking it takes the customer to the login page with a message that reads "You need to sign into your account before you can write a review."

The message "You need to sign into your account before you can write a review." doesn't show up....
I'll dig into that tomorrow, I was all focused on the reply thing.

Quote:

---

Originally Posted by mikestaps

The message "You need to sign into your account before you can write a review." doesn't show up....
I'll dig into that tomorrow, I was all focused on the reply thing.

---

It's a header-message, so it will depend on where those messages are displayed in your template. For the "Classic" template, the message shows at the very top of the screen.

Does this address the duplicate review content issue? Reviews currently appear on multiple pages, which isn't great from an seo standpoint.

Quote:

---

Originally Posted by pwdan

Does this address the duplicate review content issue? Reviews currently appear on multiple pages, which isn't great from an seo standpoint.

---

Hello, I installed this add on and it isn't working for me. I just created my store recently with the new 1.51 version. I am using the fast and easy checkout, and only using guest checkout, forcing the customer to go to the enter billing information step one page after clicking the go to checkout. my site is http://cardiozonetreadmills.com . I am sure I installed this correct. if I enter in my billing information and go to the next step in the checkout, I am then allowed to write reviews if I go back to a product page and click the write review button. I am sure I have all the configurations set correctly. Everything else is working good. I have done quite alot of customizing to my site and had to learn alot to do it, been spending so much time on it everyday.

Anyone know what might be needed or fixed?

I realized with the shopping cart and free shipping in the header add on that the english file needed to be put in the main english folder, not one step further into my templates folder like the instructions says. I'm not using that add on right now until I get it looking right on my site.

Thanks everyone alot for all the free information and assistance. I've read alot here.

Quote:

---

Originally Posted by tom97zr2

Hello, I installed this add on and it isn't working for me. I just created my store recently with the new 1.51 version. I am using the fast and easy checkout, and only using guest checkout, forcing the customer to go to the enter billing information step one page after clicking the go to checkout. my site is http://cardiozonetreadmills.com . I am sure I installed this correct. if I enter in my billing information and go to the next step in the checkout, I am then allowed to write reviews if I go back to a product page and click the write review button. I am sure I have all the configurations set correctly. Everything else is working good. I have done quite alot of customizing to my site and had to learn alot to do it, been spending so much time on it everyday.

Anyone know what might be needed or fixed?

I realized with the shopping cart and free shipping in the header add on that the english file needed to be put in the main english folder, not one step further into my templates folder like the instructions says. I'm not using that add on right now until I get it looking right on my site.

Thanks everyone alot for all the free information and assistance. I've read alot here.

---

To be honest I'm not 100% sure what your actual question is.
However I'm surmising: if you are using FEC with it set to guest checkout only and only a registered customer can write a review (yes?) then logically you wouldn't be able to write a review until the system knows your information/account details anyway, right? Hence you being able to write a review only *after* submitting your personal details and not beforehand.

Quote:

---

Originally Posted by picandnix

... However I'm surmising: if you are using FEC with it set to guest checkout only and only a registered customer can write a review (yes?) then logically you wouldn't be able to write a review until the system knows your information/account details anyway, right? Hence you being able to write a review only *after* submitting your personal details and not beforehand.

---

This plugin (Reviews Updated) has no knowledge of a guest login, so once a guest-customer has gone partially through the guest "information gathering" the session variable that identifies that a customer is logged in is set. That's why this guest customer can write a review.

Quote:

---

Originally Posted by lat9

This plugin (Reviews Updated) has no knowledge of a guest login, so once a guest-customer has gone partially through the guest "information gathering" the session variable that identifies that a customer is logged in is set. That's why this guest customer can write a review.

---

What she said :wink:
Same answer but written in a less confusing way than mine.

Thanks for the replies. I thought one of the main points of the reviews update was so a guest can write a review, and I figured they could do that without having to enter in all that name and address information, which I'm assuming would be a big deterrent to anyone who clicks on the write review button. I would like it to go straight to the page where they can write the review and just enter their name and select a product from a drop down list perhaps? I could make this happen with some html, like when I made a simple survey page for my old site that didn't use any php.

Did you enable the product reviews by guests? Configuration->Product Info->Enable product reviews by guests? should be set to 1. Do you have any other plugins that modify the product_reviews_write page?

Quote:

---

Originally Posted by lat9

Did you enable the product reviews by guests? Configuration->Product Info->Enable product reviews by guests? should be set to 1. Do you have any other plugins that modify the product_reviews_write page?

---

Yes I did. Went through the install instructions a few times to make sure it was done right. No. Thanks

I'll do a fresh install in the morning and see if I can see anything amiss on a "stock" Zen Cart base. Did FEC make any changes to /includes/templates/YOUR_TEMPLATE/templates/tpl_product_info_display.php? If so, would you post your version?

No file changes in that file from FEC. I made changes to that template, moved some things around and stuff, didn't edit any of the code for the write review. thanks!

As a guest, when I click on write review, the next page says "Whoops! Your session has expired.". Before this I removed the Log in and My account links/code so visitors don't see anything about logging in or signing up for an account, and so when they add a item to the cart and click go to checkout, then they go straight to the checkout page to fill in their billing address, they don't get the option to log in or create an account or ask them if they want to checkout as a guest.

If I add a product to the cart, and fill in the billing information and go to step 2 the payment page, then go back to the product page and click the write review link it will take me to the write review page. I'd like it to send you directly to that page as a visitor, so anyone can write a review of the product regardless if they purchased from my website, so they don't have to log in.

Looks like I would have to remove some sort of code that requires the visitor to log in before they can get to the write review page. hopefully that is possible to do. thanks.

Quote:

---

Originally Posted by tom97zr2

As a guest, when I click on write review, the next page says "Whoops! Your session has expired.". Before this I removed the Log in and My account links/code so visitors don't see anything about logging in or signing up for an account, and so when they add a item to the cart and click go to checkout, then they go straight to the checkout page to fill in their billing address, they don't get the option to log in or create an account or ask them if they want to checkout as a guest.

If I add a product to the cart, and fill in the billing information and go to step 2 the payment page, then go back to the product page and click the write review link it will take me to the write review page. I'd like it to send you directly to that page as a visitor, so anyone can write a review of the product regardless if they purchased from my website, so they don't have to log in.

Looks like I would have to remove some sort of code that requires the visitor to log in before they can get to the write review page. hopefully that is possible to do. thanks.

---

I installed "Reviews Updated" on a just-installed Zen Cart v1.5.1, and was able to write a review as a guest. Is the file /includes/modules/pages/product_reviews_write/header_php.php the one that ships with this plugin? The top-most portion of the file should look like:

Code:

---

// This should be first line of the script:
$zco_notifier->notify('NOTIFY_HEADER_START_PRODUCT_REVIEWS_WRITE');
 
require(DIR_WS_MODULES . zen_get_module_directory('require_languages.php'));

if (REVIEWS_BY_GUESTS != '1' && !$_SESSION['customer_id']) {
  $_SESSION['navigation']->set_snapshot();
  $messageStack->add_session('header', MESSAGE_REVIEW_WRITE_NEEDS_LOGIN, 'caution');
  zen_redirect(zen_href_link(FILENAME_LOGIN, '', 'SSL'));
}

---

I'm not sure why you're being redirected to the time_out page, but I'm also not familiar with the changes that the installation of FEC has introduced to your store.

Yep it has that code. I deleted some code before in the common header file to get rid of the log in link, maybe I deleted too much of that code? I'll have to check after work today. Thanks

If you'll post your version of /includes/modules/pages/product_reviews_write/header_php.php, perhaps I could help ...

Thanks!

Code:

---

<?php
/**
 * reviews Write
 *
 * @package page
 * @copyright Copyright 2003-2012 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 GIT: $Id: Author: DrByte  Sat Jul 21 16:05:31 2012 -0400 Modified in v1.5.1 $
 */
/**
 * Header code file for product reviews "write" page
 */

// This should be first line of the script:
$zco_notifier->notify('NOTIFY_HEADER_START_PRODUCT_REVIEWS_WRITE');
 
require(DIR_WS_MODULES . zen_get_module_directory('require_languages.php'));

if (REVIEWS_BY_GUESTS != '1' && !$_SESSION['customer_id']) {
  $_SESSION['navigation']->set_snapshot();
  $messageStack->add_session('header', MESSAGE_REVIEW_WRITE_NEEDS_LOGIN, 'caution');
  zen_redirect(zen_href_link(FILENAME_LOGIN, '', 'SSL'));
}

$product_info_query = "SELECT p.products_id, p.products_model, p.products_image,
                              p.products_price, p.products_tax_class_id, pd.products_name
                      FROM " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
                      WHERE p.products_id = :productsID
                      AND p.products_status = '1'
                      AND p.products_id = pd.products_id
                      AND pd.language_id = :languagesID";

$product_info_query = $db->bindVars($product_info_query, ':productsID', $_GET['products_id'], 'integer');
$product_info_query = $db->bindVars($product_info_query, ':languagesID', $_SESSION['languages_id'], 'integer');
$product_info = $db->Execute($product_info_query);

if (!$product_info->RecordCount()) {
  zen_redirect(zen_href_link(FILENAME_PRODUCT_REVIEWS, zen_get_all_get_params(array('action'))));
}

if (!$_SESSION['customer_id']) {
  $customer = '';
} else {
  $customer_query = "SELECT customers_firstname, customers_lastname, customers_email_address
                    FROM " . TABLE_CUSTOMERS . "
                    WHERE customers_id = :customersID";


  $customer_query = $db->bindVars($customer_query, ':customersID', $_SESSION['customer_id'], 'integer');
  $customer = $db->Execute($customer_query);
}

$error = false;
if (isset($_GET['action']) && ($_GET['action'] == 'process')) {
  $rating = zen_db_prepare_input($_POST['rating']);
  $review_text = zen_db_prepare_input($_POST['review_text']);
  $antiSpam = isset($_POST['should_be_empty']) ? zen_db_prepare_input($_POST['should_be_empty']) : '';
  $zco_notifier->notify('NOTIFY_REVIEWS_WRITE_CAPTCHA_CHECK');
  $review_name = zen_db_prepare_input($_POST['review_name']);

  if ((strlen($review_name) < REVIEW_NAME_MIN_LENGTH) && (!$_SESSION['customer_id'])) {
    $error = true;
    $messageStack->add('review_text', JS_REVIEW_NAME);
  }
  if (strlen($review_text) < REVIEW_TEXT_MIN_LENGTH) {
    $error = true;
    $messageStack->add('review_text', MESSAGE_REVIEW_TEXT_MIN_LENGTH);
  }

  if (($rating < 1) || ($rating > 5)) {
    $error = true;
    $messageStack->add('review_text', JS_REVIEW_RATING);
  }

  if ($error == false) {
  if ($antiSpam != '') {
    $zco_notifier->notify('NOTIFY_SPAM_DETECTED_DURING_WRITE_REVIEW');
    $messageStack->add_session('header', (defined('ERROR_WRITE_REVIEW_SPAM_DETECTED') ? ERROR_WRITE_REVIEW_SPAM_DETECTED : 'Thank you, your post has been submitted for review.'), 'success');
  } else {

    if (REVIEWS_APPROVAL == '1') {
      $review_status = '0';
    } else {
      $review_status = '1';
    }
 
    $messageStack->add_session('header', REVIEWS_APPROVAL == '1' ? MESSAGE_REVIEW_SUBMITTED_APPROVAL : MESSAGE_REVIEW_SUBMITTED, 'success');

    $sql = "INSERT INTO " . TABLE_REVIEWS . " (products_id, customers_id, customers_name, reviews_rating, date_added, status)
            VALUES (:productsID, :customersID, :customersName, :rating, now(), " . $review_status . ")";


    $sql = $db->bindVars($sql, ':productsID', $_GET['products_id'], 'integer');
   
    if (!$_SESSION['customer_id']) {
      $sql = $db->bindVars($sql, ':customersID', 0, 'integer');
      $sql = $db->bindVars($sql, ':customersName', $review_name, 'string');
     
    } else {
      $sql = $db->bindVars($sql, ':customersID', $_SESSION['customer_id'], 'integer');
      $sql = $db->bindVars($sql, ':customersName', $customer->fields['customers_firstname'] . ' ' . substr( $customer->fields['customers_lastname'], 0, 1) . '.', 'string');
     
    }

    $sql = $db->bindVars($sql, ':rating', $rating, 'string');

    $db->Execute($sql);

    $insert_id = $db->Insert_ID();

    $sql = "INSERT INTO " . TABLE_REVIEWS_DESCRIPTION . " (reviews_id, languages_id, reviews_text)
            VALUES (:insertID, :languagesID, :reviewText)";

    $sql = $db->bindVars($sql, ':insertID', $insert_id, 'integer');
    $sql = $db->bindVars($sql, ':languagesID', $_SESSION['languages_id'], 'integer');
    $sql = $db->bindVars($sql, ':reviewText', $review_text, 'string');

    $db->Execute($sql);
    // send review-notification email to admin
    if (REVIEWS_APPROVAL == '1' && SEND_EXTRA_REVIEW_NOTIFICATION_EMAILS_TO_STATUS == '1' and defined('SEND_EXTRA_REVIEW_NOTIFICATION_EMAILS_TO') and SEND_EXTRA_REVIEW_NOTIFICATION_EMAILS_TO !='') {
      $email_text  = sprintf(EMAIL_PRODUCT_REVIEW_CONTENT_INTRO, $product_info->fields['products_name']) . "\n\n" ;
      $email_text .= sprintf(EMAIL_PRODUCT_REVIEW_CONTENT_DETAILS, $review_text)."\n\n";
      $email_subject = sprintf(EMAIL_REVIEW_PENDING_SUBJECT,$product_info->fields['products_name']);
      $html_msg['EMAIL_SUBJECT'] = sprintf(EMAIL_REVIEW_PENDING_SUBJECT,$product_info->fields['products_name']);
      $html_msg['EMAIL_MESSAGE_HTML'] = str_replace('\n','',sprintf(EMAIL_PRODUCT_REVIEW_CONTENT_INTRO, $product_info->fields['products_name']));
      $html_msg['EMAIL_MESSAGE_HTML'] .= '<br />';
      $html_msg['EMAIL_MESSAGE_HTML'] .= str_replace('\n','',sprintf(EMAIL_PRODUCT_REVIEW_CONTENT_DETAILS, $review_text));
      if ($customer) {
        $extra_info=email_collect_extra_info($name,$email_address, $customer->fields['customers_firstname'] . ' ' . $customer->fields['customers_lastname'] , $customer->fields['customers_email_address'] );
        $html_msg['EXTRA_INFO'] = $extra_info['HTML'];
      }
      zen_mail('', SEND_EXTRA_REVIEW_NOTIFICATION_EMAILS_TO, $email_subject ,
      $email_text . $extra_info['TEXT'], STORE_NAME, EMAIL_FROM, $html_msg, 'reviews_extra');
    }
    // end send email
  }
    zen_redirect(zen_href_link(FILENAME_PRODUCT_REVIEWS, zen_get_all_get_params(array('action'))));

  }
}

$products_price = zen_get_products_display_price($product_info->fields['products_id']);

$products_name = $product_info->fields['products_name'];

if ($product_info->fields['products_model'] != '') {
  $products_model = '<br /><span class="smallText">[' . $product_info->fields['products_model'] . ']</span>';
} else {
  $products_model = '';
}

// set image
//  $products_image = $product_info->fields['products_image'];
if ($product_info->fields['products_image'] == '' and PRODUCTS_IMAGE_NO_IMAGE_STATUS == '1') {
  $products_image = PRODUCTS_IMAGE_NO_IMAGE;
} else {
  $products_image = $product_info->fields['products_image'];
}

$breadcrumb->add(NAVBAR_TITLE);

// This should be last line of the script:
$zco_notifier->notify('NOTIFY_HEADER_END_PRODUCT_REVIEWS_WRITE');

---

I don't think it's in my database, so I think that's why it isn't working, I couldn't remember if I ever uploaded the sql file but when I just tried I got a error "WARNING: An Error occurred, please refresh the page and try again.", the log says "[18-Jan-2014 15:01:05] PHP Fatal error: 1062:Duplicate entry 'REVIEWS_BY_GUESTS' for key 'unq_config_key_zen' :: INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ( "Enable product reviews by guests?", "REVIEWS_BY_GUESTS", "1", "Identifies whether (1) or not (0) your store allows guests to write reviews.", 18, 63, NOW(), NULL, "zen_cfg_select_option(array('1', '0')," ), ( "Product Review Write - Guest Reviewer Name", "REVIEW_NAME_MIN_LENGTH", 5, "Minimum length of a guest reviewer's name", 2, 14, NOW(), NULL, NULL ); in /hsphere/local/home/tom97zr2/cardiozonetreadmills.com/includes/classes/db/mysql/query_factory.php on line 120
" But I don't see any of this in the database for the the configuration title and key, and here is the sql file below. does this file look right? thanks.

INSERT INTO configuration
( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function)
VALUES
( "Enable product reviews by guests?", "REVIEWS_BY_GUESTS", "1", "Identifies whether (1) or not (0) your store allows guests to write reviews.", 18, 63, NOW(), NULL, "zen_cfg_select_option(array('1', '0')," ),
( "Product Review Write - Guest Reviewer Name", "REVIEW_NAME_MIN_LENGTH", 5, "Minimum length of a guest reviewer's name", 2, 14, NOW(), NULL, NULL );

The header_php.php file that you posted is the version that comes with the plugin. When you installed "Reviews by Guests", did you possibly rename the original file to something like header_php_original.php, keeping the .php extension?

For the /includes/modules/pages directory, Zen Cart automatically loads all files that match the template header_php*.php, so it's a good habit to get into to rename these file copies to something like header_php.php.original (so they don't keep the .php extension).

Quote:

---

Originally Posted by tom97zr2

I don't think it's in my database, so I think that's why it isn't working, I couldn't remember if I ever uploaded the sql file but when I just tried I got a error "WARNING: An Error occurred, please refresh the page and try again.", the log says "[18-Jan-2014 15:01:05] PHP Fatal error: 1062:Duplicate entry 'REVIEWS_BY_GUESTS' for key 'unq_config_key_zen' :: INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ( "Enable product reviews by guests?", "REVIEWS_BY_GUESTS", "1", "Identifies whether (1) or not (0) your store allows guests to write reviews.", 18, 63, NOW(), NULL, "zen_cfg_select_option(array('1', '0')," ), ( "Product Review Write - Guest Reviewer Name", "REVIEW_NAME_MIN_LENGTH", 5, "Minimum length of a guest reviewer's name", 2, 14, NOW(), NULL, NULL ); in /hsphere/local/home/tom97zr2/cardiozonetreadmills.com/includes/classes/db/mysql/query_factory.php on line 120
" But I don't see any of this in the database for the the configuration title and key, and here is the sql file below. does this file look right? thanks.

INSERT INTO configuration
( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function)
VALUES
( "Enable product reviews by guests?", "REVIEWS_BY_GUESTS", "1", "Identifies whether (1) or not (0) your store allows guests to write reviews.", 18, 63, NOW(), NULL, "zen_cfg_select_option(array('1', '0')," ),
( "Product Review Write - Guest Reviewer Name", "REVIEW_NAME_MIN_LENGTH", 5, "Minimum length of a guest reviewer's name", 2, 14, NOW(), NULL, NULL );

---

This file is what ships with the plugin; the "Enable product reviews by guests?" shows up in Configuration->Product Info and "Product Review Write - Guest Reviewer Name" shows up in Configuration->Minimum Values.

Yes I did do that! So that's probably the problem, let me fix that and see. Thanks a lot!

Sweet that fixed it, thanks a lot! I've done other renames live that in other folders, should I fix all those names too?

Quote:

---

Originally Posted by tom97zr2

Sweet that fixed it, thanks a lot! I've done other renames live that in other folders, should I fix all those names too?

---

Yes you should.
She's bloody clever that Lat9 isn't she :smile:

I see in earlier comments that the plugin needed some tweaking to be compatible with Zen Cart 1.5.1. I'm just curious if that's been done, yet or if there's a "beta" version for testing? We're obviously looking to potentially provide guests access to leave product reviews. Thank you.

Quote:

---

Originally Posted by sportbiker

I see in earlier comments that the plugin needed some tweaking to be compatible with Zen Cart 1.5.1. I'm just curious if that's been done, yet or if there's a "beta" version for testing? We're obviously looking to potentially provide guests access to leave product reviews. Thank you.

---

v1.1.0 (the current version) of this plugin has been compatible with Zen Cart v1.5.1 since September, 2012.

Thanks for the information. I'm not sure how I didn't see that!

No problem! Your question did cause me to go and verify that the plugin is also compatible with Zen Cart v1.5.2 and v1.5.3 ... and it is!

Can I Make The Review Show Up On The Product Page, like this site?

Code:

---

http://www.jjshouse.com/A-Line-Princess-Sweetheart-Asymmetrical-Tulle-Wedding-Dress-With-Lace-Beading-002011546-g11546#have_reviews

---

Quote:

---

Originally Posted by andis02

Can I Make The Review Show Up On The Product Page, like this site?

Code:

---

http://www.jjshouse.com/A-Line-Princess-Sweetheart-Asymmetrical-Tulle-Wedding-Dress-With-Lace-Beading-002011546-g11546#have_reviews

---

---

Reviews -- Updated affects the review-writing process, not where the reviews are displayed. I'll second the answer given in your other posting: Use Tabbed Products Pro (TPP) -- it can display a tab that contains the product's reviews.

so here I am again asking the "odd" questions.. :) Love this mod.. anyway to replace the default stars graphics with Awesome Font glyphs?

Quote:

---

Originally Posted by DivaVocals

so here I am again asking the "odd" questions.. :) Love this mod.. anyway to replace the default stars graphics with Awesome Font glyphs?

---

Not currently ... let me see what's up. Do you have a sample glyph that you'd like to use?

Quote:

---

Originally Posted by lat9

Not currently ... let me see what's up. Do you have a sample glyph that you'd like to use?

---

I do indeed..

<i>class="fa fa-star"</i>

Question for you. this is so mch like the dgReviews which I love for 1.3.9 but I wasn hoping that there is a way to :

1. make a horizontal rule dividing the reviews below the description of the product. Also not have Featured review, to me it makes it look like one review is favored over another. I would like them all ( at least say up to 6) listed below the image.

2. The button to send to read all reviews...can it we get a write a review button also so the visiting customer can also write one if they wish, not be redirected to read them all.


Attachment 15405

Right now it looks like the review is part of the description.

I'm a little confused; the "Reviews - Updated" plugin makes changes only to the product_reviews_write page. What you're describing are changes made to a product_info type page.

Quote:

---

Originally Posted by lat9

I'm a little confused; the "Reviews - Updated" plugin makes changes only to the product_reviews_write page. What you're describing are changes made to a product_info type page.

---

aha!! so maybe it is like the buy now button or free shipping image area and can be relocated.

But still is there any way to list them all up to a set amount on the product page? Since the DG Reviews is no longer updated it would be great to merge your two mods.

Please do not shoot me but I am back.

1. will look into the tabbed mod for the reviews to show on page but, but,but.......

is there a way to force a write a review button on the left of the page or under the read button?


by the way I just found out the owner is the one that actually hand wrote the featured review into the product page.

You're asking about a product-page (e.g. product_info) display, but this plugin only affects the formatting of the product_reviews_write page. I suggest that you pose your question in your template's support thread.

I will thanks

I've just submitted v1.2.0 to the plugins (https://www.zen-cart.com/downloads.php?do=file&id=1442) for review; the plugin's been updated to use the Zen Cart v1.5.5 file-set as its change-basis.

One thing I noticed while I was merrily merging: The built-in handling of the products_reviews_write page now provides part of this plugin's "mission" -- when a signed-in customer writes a review, their name in the review appears with their last name truncated for privacy, e.g. John Smith => John S.

v1.2.0 is now available for download.

Hi, just updated to 155e and every time I try to leave a review that's the outcome:

Your Name needs to have at least 5 characters.
Add a few more words to your review text. A review needs to have at least 50 characters.
* Please choose a rating for this item.

It is like if the page was left blank. Also, when I submit a pop up notifies that the data will be sent over unsecure connection, despite my site being in SSL.

Any idea? When in 154 it was working fine. Tried to unistall the sql and reinstall, no luck. I am using a different template since the upgrade if this can help.

Many thanks

Quote:

---

Originally Posted by satello

Hi, just updated to 155e and every time I try to leave a review that's the outcome:

Your Name needs to have at least 5 characters.
Add a few more words to your review text. A review needs to have at least 50 characters.
* Please choose a rating for this item.

It is like if the page was left blank. Also, when I submit a pop up notifies that the data will be sent over unsecure connection, despite my site being in SSL.

Any idea? When in 154 it was working fine. Tried to unistall the sql and reinstall, no luck. I am using a different template since the upgrade if this can help.

Many thanks

---

It sounds like either you've not merged the plugin's changes into /includes/modules/pages/product_reviews_write for the messages being displayed.

The plugin doesn't make any modification to the form submittal, so the unsecure-connection warning is most likely a result of that different template.

hi, thanks for the input. i did check and merge the page files, but still not luck. what i noticed the problem may comes from the tpl_product_reviews_write_default.php itself. if i leave the original file, it only shows the error about the name, as of course there is not field where to type it. so i am trying to merge those 2 files but not an easy task so far. so trying to have the option for a text field if the criteria is met into my template file

sorted. I don't really know what why it was giving the errors with your script, but this is what i've done.

file tpl_product_reviews_write_default.php

your version

PHP Code:

---

<?php echo zen_draw_form('product_reviews_write', zen_href_link(FILENAME_PRODUCT_REVIEWS_WRITE, 'action=process&products_id=' . $_GET['products_id'], ($_SESSION['customer_id']) ? 'SSL' : 'NONSSL'), 'post', 'onsubmit="return checkForm(product_reviews_write);"'); ?>

---

my version

PHP Code:

---

    <?php echo zen_draw_form('product_reviews_write', zen_href_link(FILENAME_PRODUCT_REVIEWS_WRITE, 'action=process&products_id=' . $_GET['products_id'], 'SSL'), 'post', 'onsubmit="return checkForm(product_reviews_write);"'); ?>

---

bit down the lines, in my template i've only replaced

PHP Code:

---

<?php echo SUB_TITLE_FROM . '&nbsp;&nbsp;', zen_output_string_protected($customer->fields['customers_firstname'] . ' ' . $customer->fields['customers_lastname']); ?>

---

with

PHP Code:

---

  <div id="reviewerName">
    <label id="textAreaName" for="review_name"><?php echo TEXT_REVIEW_NAME; ?></label>
    <input type="text" name="review_name" size="33" maxlength="62" id="review_name" />
  </div>

---

from your file and it does the job. Of course now logged in customers as well will have to write their names and had to change the language file as well, but no more SSL errors and reviews gets recorded. Hope this helps others. Thanks for your time.

Thanks for the follow-up. I'll make a note to review the plugin's code for use with ZC1.5.5!

Quote:

---

Originally Posted by lat9

Thanks for the follow-up. I'll make a note to review the plugin's code for use with ZC1.5.5!

---

no problems, been a pleasure banging my head for an afternoon. no much knowledge of php here but still good to read code and make some comparison. not really sure if it was the code itself or just my template, the layout was quite different.

maybe somebody using it in the current version with a different template can say. using yourstore from perfectus. great template.

regards

Quote:

---

Originally Posted by satello

no problems, been a pleasure banging my head for an afternoon. no much knowledge of php here but still good to read code and make some comparison. not really sure if it was the code itself or just my template, the layout was quite different.

maybe somebody using it in the current version with a different template can say. using yourstore from perfectus. great template.

regards

---

Ah, that makes a little more sense (to me, anyway) as that YourStore template does have a tendency to carve the :censored: out of the built-in template modules.

Hi Cindy - I have gone through the forum but I may have missed this, and likely misinterpreting the 'guest' thing (so for anyone NOT logged in I call a guest)

- Q how does a guest enter their name in the 'written by' for writing a review? The only way I could get the plugin to work as a guest was to change Configuration->Minimum Values->>Product Review Write - Guest Reviewer Name (default: 5) to 0 - otherwise the review did not submit (and the 'your review has been submitted for approval' message does not appear at top of page).

I am using westminster_new template - screenshot below - there isn't a text box to allow typing of name, a template issue?

I look forward to your reply.

cheers,
Mike
p.s. I hope you escaped the worst of the latest hurricane (Dorian?)

oooops!! forgot to attach screenshot

Attachment 18652

Hello Cindy - my apologies - please IGNORE my posts above - I figured out the issue was to do with my template - jumped the gun too early. This plugin works great.

There is one question though :) - can the date of a review be changed after submission - date cannot be edited in admin/catalog/reviews (only review text which is strange, content can be edited but nothing else).

Because I didn't have the reviews by guests set up properly for a long, long time I have missed out on some who would have otherwise left reviews - they actually sent emails saying how happy they were with the product(s) - I want to copy the content of their positive remarks and submit a review with it but I really want to be able to change the dates otherwise I could have a number of reviews all with the same date which may look suspicious to Mr Google Bot - any ideas?

cheers Mike

Quote:

---

Originally Posted by shags38

Hello Cindy - my apologies - please IGNORE my posts above - I figured out the issue was to do with my template - jumped the gun too early. This plugin works great.

There is one question though :) - can the date of a review be changed after submission - date cannot be edited in admin/catalog/reviews (only review text which is strange, content can be edited but nothing else).

Because I didn't have the reviews by guests set up properly for a long, long time I have missed out on some who would have otherwise left reviews - they actually sent emails saying how happy they were with the product(s) - I want to copy the content of their positive remarks and submit a review with it but I really want to be able to change the dates otherwise I could have a number of reviews all with the same date which may look suspicious to Mr Google Bot - any ideas?

cheers Mike

---

Mike, the plugin affects only the storefront "offering" and acceptance of reviews by guests; it doesn't have any admin-level component. That address-change can be performed in the admin, through a kind of convoluted process, though.

Log into the admin, go to Catalog->Reviews and view the review whose date should be updated. You'll see a link similar to the following:

Code:

---

http://localhost/site/admin/reviews.php?page=1&rID=16&action=edit

---

That rID value identifies the reviews_id associated with that review.

Armed with that information, go to Tools->Install SQL Patches and enter the following to change that review's date-added to a specific date:

Code:

---

UPDATE reviews SET date_added = '2019-09-18 00:00:00' WHERE reviews_id = 16 LIMIT 1;

---

Alternatively, you could set the date_added to today's date:

Code:

---

UPDATE reviews SET date_added = now() WHERE reviews_id = 16 LIMIT 1;

---

Quote:

---

Originally Posted by lat9

Mike, the plugin affects only the storefront "offering" and acceptance of reviews by guests; it doesn't have any admin-level component. That address-change can be performed in the admin, through a kind of convoluted process, though.

Log into the admin, go to Catalog->Reviews and view the review whose date should be updated. You'll see a link similar to the following:

Code:

---

http://localhost/site/admin/reviews.php?page=1&rID=16&action=edit

---

That rID value identifies the reviews_id associated with that review.

Armed with that information, go to Tools->Install SQL Patches and enter the following to change that review's date-added to a specific date:

Code:

---

UPDATE reviews SET date_added = '2019-09-18 00:00:00' WHERE reviews_id = 16 LIMIT 1;

---

Alternatively, you could set the date_added to today's date:

Code:

---

UPDATE reviews SET date_added = now() WHERE reviews_id = 16 LIMIT 1;

---

---

Thank you very much Cindy .... again you have come to the fore or as we would say in Australia "your blood is worth bottling" :)

Very much appreciated.

cheers, Mike

ZC v1.5.6
OPC v2.3.3
Reviews Updated v1.2.0
plus other mods

This mod is perhaps showing its age but there's a slight conflict between it and OPC's guest checkout. It's not major and a rare occurrence:

If a customer starts to checkout as a guest and does not complete, then goes to write a review (as a guest) they are taken to the homepage with the banner 'Access to that page requires a registered account, You can ...'

I think this is because the OPC session's "order_placed_by_guest" element is not cleared until post checkout. Beyond that (to quote Manuel) 'I know nothing' :)

Quote:

---

Originally Posted by simon1066

ZC v1.5.6
OPC v2.3.3
Reviews Updated v1.2.0
plus other mods

This mod is perhaps showing its age but there's a slight conflict between it and OPC's guest checkout. It's not major and a rare occurrence:

If a customer starts to checkout as a guest and does not complete, then goes to write a review (as a guest) they are taken to the homepage with the banner 'Access to that page requires a registered account, You can ...'

I think this is because the OPC session's "order_placed_by_guest" element is not cleared until post checkout. Beyond that (to quote Manuel) 'I know nothing' :)

---

Yes, this plugin needs to be dusted off a bit; thanks for the reminder!

Just wondering if this will work on 1.5.7c on PHP 7.4.21?
Thank you once again :)