What shows in a customer review?

[Musey]

Hey everyone...I hope you had some awesome holidays! My question is that my customer reviews are showing both the first and last name of a customer and I would prefer it only show the first name. Is there a way I can change this so that my customers do not feel that their personal info is being spread around every where?? Thanks in advance for your help :)

Musey

[Musey]

I assume that means there is not a way to go about doing this?

Musey

[Ajeh]

You would need to customize the:
/includes/modules/pages/product_reviews_write/header_php.php

you need to change the line:

    $sql = $db->bindVars($sql, ':customersName', $customer->fields['customers_firstname'] . ' ' . $customer->fields['customers_lastname'], 'string'); 

to what you want stored in the reviews table ...

[Musey]

Thank you Linda!!!

[Musey]

Well shuckey darn! I tried to take that portion of customer lastname out and it is still showing the last name. There isnt anything else I want there..I just dont want it to show the last name is all....what did I do wrong?

Musey

[LittleOleMeDesigns]

Is there any way to make it show First Name and the Customer's City.... or first name and the customer's Forum ID if you have a forum set up from the start??

[Website Rob]

If you don't tell what you did, or what code you are using, it is very hard to provide a decent reply.

Linda gave you the code and instructions to do what you want. What did you do from there?

[LittleOleMeDesigns]

I haven't done anything to it yet, I'm not sure how to proceed.

Linda gave instructions on removing the last name and displaying only the first name.

What I need to do is remove the last name, and display only their first name AND the customer's City.

The part where I'm confused is how to make it display the customer City.

[Musey]

Well this is what I did:

$sql = $db->bindVars($sql, ':customersName', $customer->fields['customers_firstname'] . ' ' . $customer->fields['customers_city'], 'string');
$sql = $db->bindVars($sql, ':rating', $rating, 'string');

it is still showing the last name......before I simply tried to take out the coding section for the last name to remove the field all together but that didnt work. I am new to coding so I am not html adept. I am trying to learn so please be patient with me :)

Thanks!
Musey

PS! Is this only going to work for new reviews or will it use those fields for the old reviews too? (this was the edit) :)

[LittleOleMeDesigns]

Well, the site won't be going live for another day or so, so they're aren't any old reviews to worry about, so only new reviews.

I've been messing with this for days and I can manage is to make the last name go away, but I can't put the city in.

I'm new to coding myself, so I definitely understand what you're going through and I appreciate your help.