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.

[IrPr]

Hi Andrew, im just tryin Hack/Modify LDM
and i've one question
why u seprated the catid and keywordid from _linkslink table into _linksltok and linksltoc instead of a field inside _linkslink table? whats this kind of relationship? is that standard?

im creating my own artist and track tables but donno how to make its relationship into _linkslink table
i can add fields called artistid and trackid into _linkslinks structure, and also can use ur method, creating another tables named _linksltoa and _linksltot

but which one is better? im newbie in MySQL database designin

Special thanks for this AWESOME Mod, LDM, even u dont reply this post

PS: sorry if my grammar sux:P
PS2: sorry misspelling, its 10:36 AM here and im still awake

[AndrewD]

Originally Posted by IrPr

Hi Andrew, im just tryin Hack/Modify LDM
just a Q, why u seprated the catid and keywordid from _linkslink table into _linksltok and linksltoc instead if a field inside _linkslink table? whats this kind of relationship? is that standard?

im creating my own artist and track tables but donno how to make its relationship into _linkslink table
i can add fields called artistid and trackid into _linkslinks structure, and also can use ur method, creating another tables named _linksltoa and _linksltot

but which one is better? im newbie in MySQL database designin

Special thanks for this AWESOME Mode, LDM, even u dont reply this post

PS: sorry if my grammar sux:P

The basic question in designing database tables is whether the relationship between an entry and its data is 'one-to-one' or 'one-to-many'. If it's one-to-one (e.g. a category has only one name and always has one name), then you can keep the category name as a column in the same table as the categoryid. However, if it's one-to-many (an entry can be in one or several categories), you can't. Also, ideally, *everything* in a table row should be logically connected and required - a classic example is that a table of professors should not include the courses they teach, because you would lose the ability to deal with new professors and emerti or to efficiently find courses with no professor assigned. (See http://en.wikipedia.org/wiki/Database_normalization if you want the background )

So in LDM the table structure reflects the fundamental data types - a category, an entry, a keyword, a hit, etc, and the 'XtoY' tables allow you join these together - find all the keywords associated with an entry and vice-versa, all the entries associated with a category, etc.

What you are trying to do is add a feature to LDM that people have suggested for some time (and I haven't had time to deal with), i.e. add extra data to the system. There are pros and cons to doing it in different ways:

- If you add one new column to the 'entries' table (links), then the logic is easy to implement but very inflexible. There are ways of forcing several different data items into the one columns (use the php serialize function, for example), but it becomes a mess.
- If you add a new column for each new datatype, it become a mess very quickly.
- If you handle it in a different table, then the logic is much cleaner, but it can become quite tricky to construct efficient SQL queries.

In LDM, the hairiest piece of code are the routine that build the linkbits (the individual rows which show each entry) [get_linklistbit] and the routine that works out the required SQL query [get_mainsql]. get_mainsql constructs the required 'joins' on tables to pull in the required information. Unfortunately, joins can easily get very expensive, and you can end up killing your server if you are not careful.

For your purposes, I think it would be easiest to create new tables which have this form:

1) artistid, artistname, etc

and 2) linkid, artistid

or

1) trackid, trackname, etc

and 2) linkid

Hope that helps!

[IrPr]

Originally Posted by AndrewD

The basic question in designing database tables is whether the relationship between an entry and its data is 'one-to-one' or 'one-to-many'. If it's one-to-one (e.g. a category has only one name and always has one name), then you can keep the category name as a column in the same table as the categoryid. However, if it's one-to-many (an entry can be in one or several categories), you can't. Also, ideally, *everything* in a table row should be logically connected and required - a classic example is that a table of professors should not include the courses they teach, because you would lose the ability to deal with new professors and emerti or to efficiently find courses with no professor assigned. (See http://en.wikipedia.org/wiki/Database_normalization if you want the background )

So in LDM the table structure reflects the fundamental data types - a category, an entry, a keyword, a hit, etc, and the 'XtoY' tables allow you join these together - find all the keywords associated with an entry and vice-versa, all the entries associated with a category, etc.

What you are trying to do is add a feature to LDM that people have suggested for some time (and I haven't had time to deal with), i.e. add extra data to the system. There are pros and cons to doing it in different ways:

- If you add one new column to the 'entries' table (links), then the logic is easy to implement but very inflexible. There are ways of forcing several different data items into the one columns (use the php serialize function, for example), but it becomes a mess.
- If you add a new column for each new datatype, it become a mess very quickly.
- If you handle it in a different table, then the logic is much cleaner, but it can become quite tricky to construct efficient SQL queries.

In LDM, the hairiest piece of code are the routine that build the linkbits (the individual rows which show each entry) [get_linklistbit] and the routine that works out the required SQL query [get_mainsql]. get_mainsql constructs the required 'joins' on tables to pull in the required information. Unfortunately, joins can easily get very expensive, and you can end up killing your server if you are not careful.

For your purposes, I think it would be easiest to create new tables which have this form:

1) artistid, artistname, etc

and 2) linkid, artistid

or

1) trackid, trackname, etc

and 2) linkid

Hope that helps!

You rock Andrew
Yeah, got ya
Special Thanks to you Andrew,

[itsblack]

Andrew, I have a question about vba_moudule ldm_tot.module.
It seems that the "served" option only display with a integer number. But think about that when we have number end with Gbytes, it will probably not so suitable. I hope it can display the resulat like this: "served 2.xx Gbytes". Is it thinkable?

[AndrewD]

Originally Posted by itsblack

Andrew, I have a question about vba_moudule ldm_tot.module.
It seems that the "served" option only display with a integer number. But think about that when we have number end with Gbytes, it will probably not so suitable. I hope it can display the resulat like this: "served 2.xx Gbytes". Is it thinkable?

Quite thinkable, and even quite do-able, I'm sure. This evening...

[Myra]

I don't know if this question has already been answered and I'm sorry if it is, but can you also set permissions based on user's post count and title/ranks?

[AndrewD]

Originally Posted by Myra

I don't know if this question has already been answered and I'm sorry if it is, but can you also set permissions based on user's post count and title/ranks?

The 'extras' directory in the release zipfile contains plugins that can block user access and/or limit their download rights according to post count, reputation and some other parameters.

[Alfa1]

Originally Posted by AndrewD

I imagine you uploaded the code, but did not rerun the installer. Go to VB/admincp/products and plugins and upload the 2.2.8 LDM product installer.

Thanks, that did it. I edited the init file to correct my DB prefix, while I didn't upload the 2.2.8 product installer again after that.

[obmob]

Originally Posted by AndrewD

Was busy thinking and replacing a busted graphics card.

I'll add a new plugin in the next 2.2.8 upload which does this job.

Thanks!

I'm always complaining.

Installing RC2 and testing, did i say thanks?

[AndrewD]

Originally Posted by itsblack

Andrew, I have a question about vba_moudule ldm_tot.module.
It seems that the "served" option only display with a integer number. But think about that when we have number end with Gbytes, it will probably not so suitable. I hope it can display the resulat like this: "served 2.xx Gbytes". Is it thinkable?

Replace the ldm_tot.php file in your forum/modules directory with the attached and let me know if this is ok. I've tried to make it a bit smarter.