Links and Downloads Manager

LDM extends VBulletin to manage a library of documents, files and links to other web sites. Documents can be stored on your own web site, stored on your server separate from the web site, uploaded by your user community, or held somewhere else altogether. So you can use LDM to provide your user community with access to your own files and allow them to share files with each other.

12/08/06 - Versions that work with vb36 are available and supported in the VB36 thread. Version 2.2.1, which works with VB 3.5 but not with VB 3.6, remains available here.

Thanks to everyone who has helped with all the design, testing, etc.
Translations are provided (thanks dLutt and LeeWicked) into German, (thanks to Allan) into French, and (thanks to Hugo) into Spanish. Harry1951 has handled the Dutch translation.

Screenshots, Instructions and How to Install

Full details and instructions are available as a Wiki at http://www.eirma.org/wikis/index.php...nloads_Manager

LDM installs as a VBulletin product. There are no modifications required to standard VB code.

Basically - upload php files and run the installer through VB's Product installer. No changes needed to VB code. Remember to BACKUP YOUR DATABASE. By default, LDM prefixes its database tables 'local_'. Edit the configuration file, local_links_init.php, if you need/wish to change this.

LDM can handle an essentially unlimited number of categories and nested subcategories, and an unlimited number of entries (hyperlinks or downloadable files). Each entry can be placed in one or several categories. Categories can have styles. Descriptions and titles can optionally include BBcodes, smilies, images and html, giving the possibility to add images, colouring, etc. File types can be flagged using icons and individual entries can also have associated thumbnail images.

Standards templates are provided for libraries of links, files, documents, and photographs.

Users can offer comments and rate the links/downloads. Each user is allowed one rating and many comments per entry, and can freely edit these if they change their mind.

Permission to use specific features is established via the product's admin page, where the administrator specifies which usergroups can add and edit entries, comment and rate these entries, moderate, etc.

By default, all entries are visible to all users. You can restrict visibility/access to links and categories by using the permissions masks from your board's forums.

Moderation of new entries is available but turned off by default.

Users can report bad links to the relevant moderators/administrators.

Each user can flag links as his/her "Favourites".

Modules are provided for VBAdvanced.

Hooks are provided in suitable places in LDM and sample plugins are included in the release (see extras directory), for example to integrate with ID3 tags in mp3 files, for slideshows, to autocreate new threads in your forums, etc.

Plus much more.

[LeeWicKeD]

Seems to work without any issues! Thank you very much...should be added to the FAQ

[M_A_D]

Originally Posted by Tyegurl

andrewd ... not sure what this is... well i know what it is i just don't understand why.... i moved a folder to another category and ever since i get this error...

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT * FROM local_linksdownloads
WHERE linkid='510' AND userid='32' AND usertime>'1144511097'
LIMIT 1;

MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Date : Saturday, April 8th 2006 @ 08:45:45 AM
Script : http://www.teamrespawn.com/vBulletin...d=510&catid=16
Referrer : http://www.teamrespawn.com/vBulletin...N&page=4&pp=10


now the downloaders are telling me they download without a problem....which is what i don't understand. can you possibly shed some light on it?

I am also getting that error message in my mail quite frequently. Seems that it is affecting hit recording.
I checked it out today and after i downloaded 4 files it showed that i made 2 hits. Then i checked my mail and i had two of those error mails with my username...


I'm also having another problem. I have restricted the daily download for registered users to a maximum of 5 files yet i can see people having accessed more than 5 files in the last 24 hrs...
For example there is a user who has had 6 hits in the last 24 hrs. All of those 6 hits happend within a 10 minute time frame.


EDIT:
I just got another mail:

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT * FROM local_linksdownloads
WHERE linkid='221' AND userid='136' AND usertime>'1145133833'
LIMIT 1;

MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Date : Saturday, April 15th 2006 @ 08:58:41 PM
Script : http://world-of-japan.org/forum/loca...d=221&catid=28
Referrer : http://www.world-of-japan.org/forum/...s.php?catid=28
IP Address : 71.139.34.195
Username : edo421
Classname : vb_database

I then checked in the DB and the query above would return nothing because in the table local_linksdownloads there is no entry with linkid=221 and userid=136

[Tyegurl]

Originally Posted by AndrewD

Section 4.6 of the on-line manual explains the Jukebox. As far as I know, it only works with users running Windows (I don't use Linux, etc, myself, so can't tell). It doesn't matter what the web server is running on.

You need to set some admin settings and permissions, and then the little filetype icon to the left of the entry name in the linkbit turns into a 'play me' icon for appropriate filetypes. Click this and a new window is launched, running an embedded Windows Media Player, RealPlayer or QuickTime player.

thanks alot!

[Tyegurl]

Originally Posted by M_A_D

I am also getting that error message in my mail quite frequently. Seems that it is affecting hit recording.
I checked it out today and after i downloaded 4 files it showed that i made 2 hits. Then i checked my mail and i had two of those error mails with my username...

EDIT:
I just got another mail:

I then checked in the DB and the query above would return nothing because in the table local_linksdownloads there is no entry with linkid=221 and userid=136

i am still getting them too....

[Tyegurl]

Originally Posted by M_A_D

I'm also having another problem. I have restricted the daily download for registered users to a maximum of 5 files yet i can see people having accessed more than 5 files in the last 24 hrs...
For example there is a user who has had 6 hits in the last 24 hrs. All of those 6 hits happend within a 10 minute time frame.

what is the file size limit...try to alter that?

[Tyegurl]

btw the jukebox you have works much better than the vJukebox....not as many problems with uploading and playing the files tyvm

[AndrewD]

Originally Posted by M_A_D

I am also getting that error message in my mail quite frequently. Seems that it is affecting hit recording.
I checked it out today and after i downloaded 4 files it showed that i made 2 hits. Then i checked my mail and i had two of those error mails with my username...

EDIT:
I just got another mail:

I then checked in the DB and the query above would return nothing because in the table local_linksdownloads there is no entry with linkid=221 and userid=136

This SQL squery is a check to see if the same user has made a hit on the same entry within the last few seconds. It's made to prevent double counting if, for example, the user 'double clicks' the url. So most of the time it should not return anything. I will need to investigate why it is generating database errors. However, you should be able to disable the message (and check) by setting the admin value timeout_hit_recording to zero.

Originally Posted by M_A_D

I'm also having another problem. I have restricted the daily download for registered users to a maximum of 5 files yet i can see people having accessed more than 5 files in the last 24 hrs...
For example there is a user who has had 6 hits in the last 24 hrs. All of those 6 hits happend within a 10 minute time frame.

Are all your entries 'downloads' (in the sense that LDM uses - i.e. they have filetypes that appear in the VB attachments table) or are there also some entries which have filetypes that are not in the mimetypes table?

Assuming everything is working ok, LDM *only* places daily limits on the first group, not on the second.

There is a second possibility, since you mention that the hits are in quick succession. Each 'hit' is only recorded when it completes, consequently if a user starts multiple downloads in quick succession, then she may be able to bypass the daily limits. If necessary, we might be able to find ways to prevent that occurring.

Please confirm - I will check the code in more detail if necessary.

[AndrewD]

Originally Posted by Tyegurl

i am still getting them too....

Please let me know which versions of php and mysql/mysqli you are using

[M_A_D]

Originally Posted by AndrewD

This SQL squery is a check to see if the same user has made a hit on the same entry within the last few seconds. It's made to prevent double counting if, for example, the user 'double clicks' the url. So most of the time it should not return anything. I will need to investigate why it is generating database errors. However, you should be able to disable the message (and check) by setting the admin value timeout_hit_recording to zero.

Thanks, i will try changing that value.

Originally Posted by AndrewD

Are all your entries 'downloads' (in the sense that LDM uses - i.e. they have filetypes that appear in the VB attachments table) or are there also some entries which have filetypes that are not in the mimetypes table?

Assuming everything is working ok, LDM *only* places daily limits on the first group, not on the second.

There is a second possibility, since you mention that the hits are in quick succession. Each 'hit' is only recorded when it completes, consequently if a user starts multiple downloads in quick succession, then she may be able to bypass the daily limits. If necessary, we might be able to find ways to prevent that occurring.

Please confirm - I will check the code in more detail if necessary.

Yes, all my downloads are .zip files, so it seems the second possibility is correct. But i guess i can live with that.


Oh, and if it helps, i am using php 4.4.2 and mysql 5.0.15

[Tyegurl]

Originally Posted by AndrewD

Please let me know which versions of php and mysql/mysqli you are using

(what vbulletin says i use lol)
PHP 4.3.11
MySQL Version 4.0.24-max-log

and my timeout was set to 0
yet i still get the emails but it downloads the file just fine.