Downloads page - how organize?

[mef]

Hello, how I can create a download's page by using serendipity?
It is necessary to have a simple list of hyperlinks to files in directory with short files description.
Like this page http://www.s9y.org/12.html.
Is it possible with some plugin or exists other ways?

[garvinhicking]

Hi!

You could try the Downloadmanager plugin, available via Spartacus.

Best regards,
Garvin

[mef]

thank you!

[mef]

unfortunally, this plugin not work with PostgreSQL database...

[garvinhicking]

Hi!

Oh, that might be, because the developer only used MySQL.

Which errors does it create for pgsql? Maybe it's easy to adapt.

Regards,
Garvin

[mef]

two types of troubles:
1. Any creations of tables use a datatypes, wich postgres does not support

CREATE TABLE {$serendipity['dbPrefix']}dma_downloadmanager_categories (
node_id {AUTOINCREMENT} {PRIMARY},
root_id int(10) NOT NULL default '0',

... etc.

It is not a problem - I create this manually.

2. At function GetAdminCats():
Error in sql
...
GROUP BY node1.lft, node1.rgt, node1.node_id, node1.root_id, node1.payload
...

must be

...
GROUP BY node1.lft, node1.rgt, node1.node_id, node1.root_id, node1.payload, node1.hidden
...

and same SQL has construction

((min(node2.rgt)-node1.rgt-(node1.lft>1))/2) > 0 AS lower,

in Postgres (it cannot cast boolean to integer itself) must be

((min(node2.rgt)-node1.rgt-(node1.lft>1)::int)/2) > 0 AS lower,


I cannot change body of php file - have no permissions

[garvinhicking]

Hi!

If you have no write permissions, did you try to use a script like fixperm.php mentioned in the FAQ on www.s9y.org? Files downloaded by spartacus, if not configured, are only writable for PHP - but with this fixperm.php you can make PHP give back the write permissions.

Best regards,
Garvin

[mef]

thank you. I change permissions by php script and downloadmanager work fine now.