Reviews Customization

[KT Naturals]

I have a couple of questions.

1. A user wants to leave a review but does not want it to show her first AND last name. How do I edit the usernames when someone leaves a review?

2. I want to show the reviews on the product page. Right now, it shows a 'write review' button and clicking on that brings you to the reviews ans write review option (http://www.ktnaturals.com/index.php?...products_id=35)

[bargaindropper]

Hi,
I want to do the same too.
One way to do it is to edit the file \includes\modules\pages\product_reviews_write\header_php

Find the line starting

$customer_query = "SELECT customers_firstname

and change to

$customer_query = "SELECT customers_firstname, customers_email_address
                   FROM " . TABLE_CUSTOMERS . "
                   WHERE customers_id = :customersID";

This will then leave first name on reviews. The only down side is that it will not show you exactly who wrote the review.

Not the ideal work around as it leaves reviews open to abuse.

Sorry I don't know a better way but I am not very good at PHP programming but thought I would share this in case it suited your needs

[bargaindropper]

OK,

BEFORE STARTING BACKUP YOUR FILE. THIS EDITS A CORE FILE

Here is a better solution: This allows the full name to be stored for the site owner but display only a first name on the review screen.

Ignore my previous post and leave that file alone.
The file to revise for displaying one name only is

includes\modules\pages\product_reviews\header_php

Find this section:

$reviewsArray = array();
  while (!$reviews->EOF) {
  	$reviewsArray[] = array('id'=>$reviews->fields['reviews_id'],
  	                        'customersName'=>$reviews->fields['customers_name'],
  	                        'dateAdded'=>$reviews->fields['date_added'],
  	                        'reviewsText'=>$reviews->fields['reviews_text'],
  	                        'reviewsRating'=>$reviews->fields['reviews_rating']);
    $reviews->MoveNext();
  }

change to

  $reviewsArray = array();
  while (!$reviews->EOF) {
	$array=explode(" ",$reviews->fields['customers_name']);
	$array_count=count($array);
	echo $array_count;
	$sentence=$array[0];
  	$reviewsArray[] = array('id'=>$reviews->fields['reviews_id'],
  	                        'customersName'=>$sentence,
  	                        'dateAdded'=>$reviews->fields['date_added'],
  	                        'reviewsText'=>$reviews->fields['reviews_text'],
  	                        'reviewsRating'=>$reviews->fields['reviews_rating']);

    $reviews->MoveNext();
  }

I take no credit for this. I used google to search on how to find a space and just modified it slightly to work. Use at your own risk.

[KT Naturals]

Thank you so much! Worked! :)