I will actually be using both file and database translations. The file based translations are for anything that doesn’t normally change - the template mainly. I think I will stick with the KISS principle
I have a database that I have reworked to be better suited to requirements (it was a dog!) and that includes language based tables, eg. cms_lang. These use a language_id column which I will need to set in Yii::app()->params according to selected language, which is simple enough.
I have to say that Yii is an amazing framework to work with and very easy to adapt. Here is another site I have in development, after only one week of development: http://www.suomedia.com/books It amazes me that something can be devloped from scratch so FAST!!