felix_at Posted June 21, 2004 Posted June 21, 2004 hi all, I try to install a new language (Italian), while installing a new language the ADMIN copies all the product-descriptions of one existing language to the new one. My problem is, how can I control which product-description is copied, it should be in my case the English one. so the user-interface will be Italian and all the products in English, but it is always in German, which is my default language. If I change the default to English and then install Italian it makes no difference. Can anyone please help me ? Thank you Felix
John Doswell Posted June 21, 2004 Posted June 21, 2004 it dont change once you have filled the database. you would have to delete the new installed language (you dont have to ftp/remove the folders) change your default to english and then install the language new. john
felix_at Posted June 22, 2004 Author Posted June 22, 2004 Hi john, thank you your answer. I did as you told me, but again the product-description in Italian is copied from the German records. I think the solution could be found in admin/languages.php. there are the following statements, defining the source language for creating these records. But I cannot find where $languages_id is set and what is the current value // create additional products_description records $products_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, pd.products_url from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id where pd.language_id = '" . (int)$languages_id . "'"); while ($products = tep_db_fetch_array($products_query)) { tep_db_query("insert into " . TABLE_PRODUCTS_DESCRIPTION . " (products_id, language_id, products_name, products_description, products_url) values ('" . (int)$products['products_id'] . "', '" . (int)$insert_id . "', '" . tep_db_input($products['products_name']) . "', '" . tep_db_input($products['products_description']) . "', '" . tep_db_input($products['products_url']) . "')"); } any idea ??? thank you Felix
241 Posted June 22, 2004 Posted June 22, 2004 you can find the language_id used throughout the database and it will have id values 1=english 2=german 3=spanish then there are default settings for the language_id which is normally set to 1 which again is english, check that yours are set to 1 and not 2 No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes.
felix_at Posted June 22, 2004 Author Posted June 22, 2004 now I found a way getting the result I need: I insert a statement $languages_id ="1"; in the admin/language.php, then I install a new language. Next step, I delete the statement and use the original php again. Not a nice solution, but usable. Thank you !
Recommended Posts
Archived
This topic is now archived and is closed to further replies.