Major Additions - Links and Downloads Manager

Version 2.3.0 of LDM is now the official release. This works with both VB3.7 and VB3.8. You can obtain it here

Version 2.2.8 remains available here, with limited support.

04.02.08: patch-cat.xml 'extra' uploaded - see first post for information

27.10.07: Version 2.2.8-post1 uploaded
French translation of product installer uploaded (other language translations are in the main release zip)

Remember to back up your current database tables before upgrading.

What this is and does

LDM is a general-purpose link and file manager, which handles user uploads and downloads in a flexible way. A range of media players is integrated into LDM and others are included as plugin extras. LDM is described below in the first post of this thread, which also contains a brief list of the currently-known bugs.

This release of LDM works correctly with all VB versions 3.6.x and recent versions of vbadvanced.

Documentation, screen shots, etc, are provided as a Wiki at http://www.eirma.org/wikis/index.php...nloads_Manager

Thank you to everyone who has tested, given suggestions, helped with the translations, etc.

[obmob]

Hmm... well, finally installed the new script... how do i enable the filmstrip to show the upcoming download link?

You know, that thing I asked for some months ago? That looks similar as vbgallery

Thanks

[AndrewD]

Originally Posted by obmob

Hmm... well, finally installed the new script... how do i enable the filmstrip to show the upcoming download link?

You know, that thing I asked for some months ago? That looks similar as vbgallery

Thanks

It's provided in the 'extras' directory - have you installed it and read the 'readme' file?

[hydn]

We avg 50,000 downloads per month and the table... local_links_downloads eventually grew to over 700,000 rows. Which cause huge CPU spikes on our MYSQL server.

After truncating the local_links_downloads table. The CPU spike were gone (after 3 month of trying to find this worsening problem).

So my question, is there anyway to set an auto cut off for the stats to stop incrementing?

Or this means every few months we have to manually truncate the table. Can Links and Downloads Manager be set to only keep say the last 30 days of download stats?

Thanks very much for any support you can provide.

[obmob]

Originally Posted by AndrewD

It's provided in the 'extras' directory - have you installed it and read the 'readme' file?

mwahaha! no... thought it was embedded in the templates, so, i was searching all over there.

Will test tonight, thanks Andrew.

[AndrewD]

Originally Posted by hydn

We avg 50,000 downloads per month and the table... local_links_downloads eventually grew to over 700,000 rows. Which cause huge CPU spikes on our MYSQL server.

After truncating the local_links_downloads table. The CPU spike were gone (after 3 month of trying to find this worsening problem).

So my question, is there anyway to set an auto cut off for the stats to stop incrementing?

Or this means every few months we have to manually truncate the table. Can Links and Downloads Manager be set to only keep say the last 30 days of download stats?

Thanks very much for any support you can provide.

Go to LDM/admin/settings and set prune_downloadtable to the number of days you want to keep, e.g. 30. Note that detailed usage statistics are only available for those days where the downloads table is populated, but the overall statistics (total hits on entries) are retained when the table is pruned. Hope this helps.

[Alfa1]

How can I see the number of downloads per month?

[AndrewD]

Originally Posted by Alfa1

How can I see the number of downloads per month?

It does not get tabulated by month, but if you go to ldm/admin/hits you can do an analysis for any range of dates for which you still have information in your downloads table.

[Rouzbeh1]

hi Andrew,
just wanted to thank you and report that BW usage is working fine now

btw. i have read that you are implementing a server load management for mirror sites. is that correct?

[hydn]

Originally Posted by AndrewD

Go to LDM/admin/settings and set prune_downloadtable to the number of days you want to keep, e.g. 30. Note that detailed usage statistics are only available for those days where the downloads table is populated, but the overall statistics (total hits on entries) are retained when the table is pruned. Hope this helps.

THanks. That does help. However, I logged in / clicked administer / then clicked settings / ...

But can't find that prune_downloadtable.

I'm on version 2.1.0

Is this an option I can set with a Mysql query maybe? Or other solution(s)?

Thanks much.

[BuRaCh]

thank you good hack