phoca download tree: category order

Phoca modules - support for all Phoca modules except Phoca Gallery modules
rnervi
Phoca Newbie
Phoca Newbie
Posts: 5
Joined: 30 Apr 2019, 16:31

phoca download tree: category order

Post by rnervi » 10 May 2019, 08:49

I've settled the PhocaDownload -> control panel -> options -> display -> Categories and Category View -> Category Ordering = Title ascending BUT the module doesn' t care.... categories are showed in "id key" from table.....

rnervi
Phoca Newbie
Phoca Newbie
Posts: 5
Joined: 30 Apr 2019, 16:31

Re: phoca download tree: category order

Post by rnervi » 10 May 2019, 09:12

ach. in the file modules/mod_phocadownload_tree the db select is hard coded, this the ORDER BY is not variable.... :( :

$query = 'SELECT cc.title AS text, cc.id AS id, cc.parent_id as parentid, cc.alias as alias, cc.access as access, cc.accessuserid as accessuserid'
. ' FROM #__phocadownload_categories AS cc'
. ' WHERE cc.published = 1'
//. ' AND cc.approved = 1'
. $hideCatSql
. $hideCatAccessSql
. ' ORDER BY cc.ordering';

so it's enough set the "ordering" field in the table.

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 41483
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: phoca download tree: category order

Post by Jan » 11 May 2019, 10:41

Hi, thank you for the info, I will take a look at it for the next version.

Jan
If you find Phoca extensions useful, please support the project

Post Reply