reviews do not show in all language

Hi all,

I've installed multi-language for my shop(english and spanish) and I'm using Ez-page to show my products review. however, those review only shown on their specify language(e.g. english reviews only show on english version).

Now, I would like to make all reviews show on both languages, (such as english also show on spanish language) is that possible or any way to do it?

Thanks! :blush:

I've searched the forum and faq for 2 hrs but no related subject found : (

You would need to find the database query that extracts the reviews and disable the line that matches the language to that in the $_SESSION variable.

kuroi:

You would need to find the database query that extracts the reviews and disable the line that matches the language to that in the $_SESSION variable.

is that located phpmyadmin or a file belonged to zen cart?

Thanks

It's somewhere in one of the ZenCart PHP files.

umm..

I guess maybe in this file
reviews.php in /admin/

there are tons of script like

$products_name = $db->Execute("select products_name
from " . TABLE_PRODUCTS_DESCRIPTION . "
where products_id = '" . (int)$reviews->fields['products_id'] . "'
and language_id = '" . (int)$_SESSION['languages_id'] . "'");

how do i disable the language matching?
:hug:

You would have to go through each of the queries related to reviews and remove the limitation to the session language where appropriate.

That particular query though would be an example of where it wouldn't be appropriate, as there may be multiple product_names, one for each language and so removing the condition there would cause the same one to be found for all languages or worse.

Basically this isn't one to attempt unless you have the technical skills to pull it off, and if you have to ask, then it's unlikely that you do.

To go through and do that for you is too big an ask for a forum thread. If you need somebody with those skills, I recommend posting in the commercial help wanted section of this forum.

oh

i thought it was easy, thank you for your advise :D