Serendipity Forums

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?

Hi!

You could try the Downloadmanager plugin, available via Spartacus.

Best regards,
Garvin

thank you!

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

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

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

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

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