Edit Reviews

[darkswan]

What files would I need to edit to remove the customer's last name from the Reviews page. Many customers won't leave reviews if their last name is displayed. I'd like to fix this if possible

thanks in advance
Terri

[Ajeh]

Look at the file for writing the reviews where the customer name is inserted into the database table ...
\includes\modules\pages\product_reviews_write\header_php.php

[darkswan]

Look at the file for writing the reviews where the customer name is inserted into the database table ...
\includes\modules\pages\product_reviews_write\head er_php.php

Tried that, it no workie. Tried the tpl files too. I either get no name at all, or the full name.

[Ajeh]

Look in the header_php.php file around lines 74 - 81 and you will see where the INSERT is built from the customer name info.

    $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');
    $sql = $db->bindVars($sql, ':customersID', $_SESSION['customer_id'], 'integer');
    $sql = $db->bindVars($sql, ':customersName', $customer->fields['customers_firstname'] . ' ' . $customer->fields['customers_lastname'], 'string');
    $sql = $db->bindVars($sql, ':rating', $rating, 'string'); 

You can alter the customersName from being first name and last name to being just the firstname ...

[pRS317]

I edited the line to the following and still see the customer's full name...is there something else that needs to be changed?

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


thanks!

[Ajeh]

NOTE: this is going to fix new reviews not existing ones ...

[LissaE]

Look in the header_php.php file around lines 74 - 81 and you will see where the INSERT is built from the customer name info.

    $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');
    $sql = $db->bindVars($sql, ':customersID', $_SESSION['customer_id'], 'integer');
    $sql = $db->bindVars($sql, ':customersName', $customer->fields['customers_firstname'] . ' ' . $customer->fields['customers_lastname'], 'string');
    $sql = $db->bindVars($sql, ':rating', $rating, 'string'); 

You can alter the customersName from being first name and last name to being just the firstname ...

Thanx Ajeh, I implemented this and it works beautifully

[Ajeh]

Thanks for the update that this is working for you ...