What shows in a customer review?

[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!

[Redcinamn]

I found my problem a simple coma thank you though! (post #3 works beautifully)

Renee

[letsmod]

this is what I did.

Edit this file (I used Wordpad)

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

change:

    $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');

    $db->Execute($sql); 

to:

    $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'], 'string');
    $sql = $db->bindVars($sql, ':rating', $rating, 'string');

    $db->Execute($sql); 

[Cookie Juice]

To remove the date on the reviews page and the product_reviews_info pages:

Is the best way to remove : r.date_added from the headers?

 $review_info_query = "SELECT rd.reviews_text, r.reviews_rating, r.reviews_id, r.customers_name,
                              r.date_added, r.reviews_read, p.products_id, p.products_price,
                               p.products_tax_class_id, p.products_image, p.products_model, pd.products_name
                        FROM " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
                        WHERE r.reviews_id = :reviewsID
                        AND r.reviews_id = rd.reviews_id
                        AND rd.languages_id = :languagesID
                        AND r.products_id = p.products_id
                        AND p.products_status = '1'
                        AND p.products_id = pd.products_id
                        AND pd.language_id = :languagesID " . $review_status; 

and remove the Date Added: text in the english files?


Is this safe to do regarding the db?
Or is a bad idea? and is there a better way?

[Cookie Juice]

woops... product_reviews page too.

[dharma]

Simply remove "Date Added: %s" from your english file.

define('TEXT_REVIEW_DATE_ADDED', '');

[Boggled]

Thank you for the last name fix! Worked like a charm.

This may not be possible, but ideally I would like to have the customer's first name and last initial.

Is there a way to do this?

[ccembd]

Thank you for this post. It worked like a charm. Since I am horrilbe at knowing what to remove and still keep things working I did the following changes.

From this:

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

To this:

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

And,
From this:

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

To this:

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

I don't care if the city shows up or not, and it doesn't.

Thanks again

[mylildarlings]

Thanks! This worked for me for just last name. (not concerned about city in my case)

Although, any help changing existing customers would be appreciated :)