[TYPO3] RealURL in japanese

Sebastian Fuchs sebastian at hexerei.net
Thu Aug 23 02:20:45 CEST 2007


Hi Rego,


Manuel Rego Casasnovas schrieb:
[]
>> something like:
>> host/jp/english_page_title
> 
> This can be a good solution for me. However I don't know how to configure
> this?

i think all you need is an sql statment to set this field in your 
database. the field name i mentioned is tx_realurl_pathsegment and it 
comes with realurl.
the sql could be something like this (without any warranty, i dont know 
if this even works)



UPDATE pages  	
SET tx_realurl_pathsegment = 	( SELECT pages_language_overlay.title
FROM pages_language_overlay
WHERE pages_language_overlay.pid = pages.uid AND 
pages_language_overlay.sys_language_uid=###japonese_sys_language_uid###)
WHERE EXISTS
   ( SELECT pages_language_overlay.title
     FROM pages_language_overlay
     WHERE pages_language_overlay.pid = pages.uid AND 
pages_language_overlay.sys_language_uid=###japonese_sys_language_uid###);


or just set the field manualy in the typo backend.


good luck,
seb


More information about the TYPO3-english mailing list