[TYPO3-shop] Search for translated products

[Marcus Schwemer]

Hallo Franz,

Franz Holzinger schrieb:

> This has already been implemented. I have rechecked it with the most
> current tt_products-2.7.1.13 from today.

Me too ... ;-)

Here is the where statement I found in
"view/class.tx_ttproducts_list_view.php" in line 558:

FROM:
tt_products products,tt_products_language productslang

WHERE:
products.pid IN (31,32,33,34,35,36,37,38)
AND 1=1
AND(products.title LIKE '%birdman%' OR products.subtitle LIKE
'%birdman%' OR products.note LIKE '%birdman%')
AND productslang.sys_language_uid=7
AND products.deleted=0
AND products.hidden=0
AND (products.starttime<=1248857052)
AND (products.endtime=0 OR products.endtime>1248857052)
AND products.fe_group IN (' ',0,-1)

"birdman" is my english searchterm. This can only be found in the table
"productslang", but there is no reference in the where statement to it.
If I search for "vogelmann" (the german product title), I get the
translated results ...

Mit freundlichen Grüßen / Best regards,
Marcus Schwemer

-- 
Marcus Schwemer Netzwerkberatung
IT-Consultant || TYPO3-Development || Webhosting
eMail: schwemer at netzwerkberatung.de
Internet: http://www.netzwerkberatung.de
Blog: http://blog.typo3worx.de