Product Review - Deleating Name

[Lead_Not_Follow]

Is their a way to not have the customer's full name show in the product review section. I've actually been asked by a customer to edit their review so it does not show their full name.

I'd like either something like " by John D." or "by John in Boston, MA"

I've searched and have only found info on how to not show their name at all, I'd still like to have their name, just not show it all.

Thanks in advance!

[kobra]

In includes/modues/pages/product_reviews_info/header_php.php there is:

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

I think this is stored as fname and lname

Then there is the corresponding tpl file for reviews

[athena]

We are also interested in this feature. How would we edit this?

[Lead_Not_Follow]

Well I had a look through the php tonight and found that if you go to includes/modules/pages/product_reviews_write/header_php.php on around line 42 deleted customers_lastname, see below.

$customer_query = "SELECT customers_firstname, customers_lastname, customers_email_address

Now it just shows the customers first name on the reviews. I did have to go in and edit all the older reviews prior, as it will only update new one's; not the old ones.

[athena]

Thanks, so much. Works fine.