What shows in a customer review?

[sagiordano]

one question about this...can this page be done as an override?

[dharma]

/includes/modules/pages/product_reviews_write/header_php.php

has no override file.

Its ok to change it, just make a note to yourself that you changed it, so that when you upgrade, you can change the new upgraded /includes/modules/pages/product_reviews_write/header_php.php file in the same way.

[princesstimetoys]

HELP! I made the changes to remove the last name, worked beautifully, however, now my review page is showing the wrong title and small thumbnail picture - the same wrong title and picture, on every review entry.

https://dprhensim67.doteasy.com/~adm...en7rnmsea5nkl2

In this view the review is correct. Why is that dang stroller showing up on every page! Grrrrr....
http://www.princesstimetoys.com/zen-...n7rnmsea5nkl2I

Any assistance would be most welcomed.

[princesstimetoys]

I reset the file from the backup so it's working right again, but the last names are back

[exittheapple]

hi guys thanks for the info - my customers will be SO happy if i can make this work!

i deleted the 'customers_lastname' tag from line 42 AND from line 80 and the last names are still showing up in all my reviews... does this not work on existing reviews, only new ones?

is there any way to change the way the existing reviews are displayed?

[athena]

The reviews take the first and last name in the main customer table in your database and put them together in the reviews table in your database. So any reviews already compiled are set. The only way to eliminate the last name in the existing reviews is to physically go into your reviews table in your database and delete the last name in that column, leaving the first name intact.

If you are not used to going into the database or do not have a tool to do that, search the forum here for database editing advice. It is pretty scary, but can be done safely. You can't be reckless about it.

[athena]

I'll try this one too...about including the city and state.

You see, this is info residing in tables in a database that cross over each other using a customer address id.

We'd love to do this also but it would mean matching the customer address id with their info in the address book table in the database.

Has anyone done this? Seems that for a file that is not part of the over-ride system this would be a little dicey to do.

[Redcinamn]

I am not having any luck with this? I have removed customers_lastname from line:

Line 80:
$sql = $db->bindVars($sql, 'roductsID', $_GET['products_id'], 'integer');
$sql = $db->bindVars($sql, ':customersID', $_SESSION['customer_id'], 'integer');
$sql = $db->bindVars($sql, ':customersName', $customer->fields['customers_firstname'] . ' ' . $customer->fields[''], 'string');
$sql = $db->bindVars($sql, ':rating', $rating, 'string');

Line 42

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



I have made three test posts and all show last name can anyone help?


version 1 .3 .7

Site http://www.crystalsoftime.com

thanks in advance!