Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Teun van Wely

Pioneers
  • Posts

    26
  • Joined

  • Last visited

  • Days Won

    1

Posts posted by Teun van Wely

  1. v1.0 was developed using only one language. A couple of people have contacted me about multiple products showing up when more than one language is being used.

     

    Although I had included the $language_id variable in the sql, it's apparent that it doesn't work.

     

    Until I have time to fix the language issue for v1.1, a fix for multiple languages can be simply changing $language_id to the actual number used for the desired language (i.e. '1' for english etc.).

    Two occurances of the variable are around lines 31, and 45 of includes/modules/newsletter/newsletter_products.php.

     

    There was also a change neaded around line 112 of includes/modules/newsletter/newsletter_products.php. to prevent the module selecting 2 pictures/texts for each product in my bilingual shop.

    change:

     

    $images_query = tep_db_query("select p.products_id, pd.products_name, p.products_image from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where pd.products_id = p.products_id and p.products_id in(" . $this->products . ")");

    }

     

    to:

     

    $images_query = tep_db_query("select p.products_id, pd.language_id, pd.products_name, p.products_image from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where pd.language_id = '1' and pd.products_id = p.products_id and p.products_id in(" . $this->products . ")");

    }

     

    Where '1' is the number for the desired language. It now works perfectly for me.

  2. I just fixed it using the instructions in the contribution to modify product_info. Actually 2 files have to be modified in the same way: products_reviews_info and products_reviews_write. Dynamic Mopics is a great contribution to my shop, not only because of the possibility of more product pics, but also because I wasn't so happy with the quality of the thumbnails of the default shop.

×
×
  • Create New...