joomfish problem with licences

[szablac]

Hi Jan,
I can translate licences with Joomfish component, but it has no use.
When someone downloads a file from my site, the original text of the licence can be read instead of the translated ones because you select it directly from #__phocadownload_licences table.
Is there any solution to show the tranlations in the textbox of lincence?

[szablac]

Ok, i figured out the solution:
The field #__phocadownload_licenses.id must be selected in the function _getDocumentQuery of class PhocaDownloadModelFile in order to joomfish find the translation of the content.

[Jan]

Hi, please let me know where exactly did you do the changes, so I can look at it.

Jan

[szablac]

I changed line 87 in file.php (<site root>\components\com_phocadownload\models\) from this:

$query = ' SELECT c.*, cc.id AS categoryid, cc.title AS categorytitle, cc.alias AS categoryalias, lc.title AS licensetitle, lc.description AS licensetext'

to this:

$query = ' SELECT c.*, cc.id AS categoryid, cc.title AS categorytitle, cc.alias AS categoryalias, lc.title AS licensetitle, lc.description AS licensetext, lc.id AS licenseid'

[Jan]

Thank you, I will change it for the next version.

Jan