phoca download tree: category order

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

phoca download tree: category order

Post by rnervi »

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 Member
Phoca Member
Posts: 15
Joined: 30 Apr 2019, 16:31

Re: phoca download tree: category order

Post by rnervi »

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: 47794
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: phoca download tree: category order

Post by Jan »

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
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47794
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: phoca download tree: category order

Post by Jan »

Hi, set in version 3.2.0
viewtopic.php?f=32&t=59880&p=156313#p156294
Jan
If you find Phoca extensions useful, please support the project
Post Reply