[TYPO3-dev] EXT-DEV - Translation of Selectbox Items in BE.

[Steffen Kamper]

...

but anyway you are right - the problem is when creating new records, they 
don't have a sys_language_id, so the query fails ...  need this help too.

vg  Steffen

"Steffen Kamper" <steffen at dislabs.de> schrieb im Newsbeitrag 
news:mailman.1.1164014297.2638.typo3-dev at lists.netfielders.de...
> Hi,
>
> "Felix Griesser" <feelx at shinternet.ch> schrieb im Newsbeitrag 
> news:mailman.37373.1163974975.30218.typo3-dev at lists.netfielders.de...
>> Hello List
>>
>> I just begun to (try to..) develop typo3-Extensions :) I struggled on the 
>> problem: Imagine an extension with a "product" and a "category" - Let's 
>> say you have the product "book" and a category "novel" which is chosen 
>> from a seperate table with a 'selector box'. When I translate the 
>> category-items into German it would be "Novelle" - When I want to assign 
>> those categories - i have both entries in the selectbox - the "original" 
>> one and the localized one;
>> [novel Novelle] Of course this MAY be wanted but it's not in every case.
>> After some searching I found an change in tca.php of the extension as 
>> follows:
>>      search for the table "product" as example and look fruther for 
>> category in this case. In the config Array modify the 
>> 'foreign_table_where' as shown:
>> "category" => Array (       ..
>>               ..
>>            "config" => Array (
>>                 ..
>>                "foreign_table" => "user_test_productcategory", 
>> "foreign_table_where" => "AND 
>> user_test_productcategory.pid=###CURRENT_PID### AND
>> sys_language_uid=###REC_FIELD_sys_language_uid### ORDER BY 
>> user_test_productcategory.uid",
>>
>> The important part is "AND 
>> sys_language_uid=###REC_FIELD_sys_language_uid###"  but I have two small 
>> issues with that.
>>
>> 1) When I have two fields where I need to change that I get a 
>> *mysql_assoc Error* in Backend! When I change it to
>>    "AND sys_language_uid=0" it works fine. Is there a solution for this?
>>
>> 2) When I want make the language selection depending of the current users 
>> BE-Language I don't know how...? Something like this, doesn't work:
>>    "foreign_table" => "user_test_productcategory,be_users", 
>> "foreign_table_where" => "AND 
>> user_test_productcategory.pid=###CURRENT_PID### AND 
>> sys_language_uid=###REC_FIELD_be_users.lang### ORDER BY 
>> user_test_productcategory.uid",
>>
>> How can I make the display of the field-items depending on the 
>> BE-language of current user?
>>
> the point is not to change it to the language of the BE-user but to the 
> language of the record.
> If you translate a record to english you want have to displayed only the 
> english categories for the db relation.
>
> I only use
> AND sys_language_uid=###REC_FIELD_sys_language_uid### ORDER BY ...
> and it works as it should
>
> vg  Steffen
>
>> Thank you in advance and
>> best wishes
>> felix
>
>