Major Additions - Links and Downloads Manager

What this is and does

LDM is a general-purpose tool for managing libraries of links and files, and handling uploads and downloads in a flexible way, while tracking and control user access. It has a range of integrated media players and a large library of 'plugin' extras.

Installation and Usage Explained in the on-line Wiki, with a brief explanation in the file instructions.txt in the release zip. The recent revision history is given in the first post of this thread.

Please use carefully and always backup your database before upgrading. Post reports of problems and suggestions for enhancements in this thread.

14.06.09 Version 2.3.0 is now the the officially-supported version. Works with 3.7 and vb 3.8. Please post comments in this thread

22.06.08 Version 2.2.9-post1 - This is the previous supported version. Works fine with all versions of vb 3.6 and vb 3.7. All standard features except profile integration and forum prefix selection work fine with vb 3.8.

[Ipuck]

I have bought licences for the new forum + CMs software and am currently trying to get me head around how things work.

They didn't give you a free copy!!! After all your hard work and all the customer that you got for them. I personally bought vB just for your hack and I may be willing to upgrade only if it possible to make LDM work with vB 4.0.

Thanks again for LDM AndrewD and I hope you are feeling better now.

[Alfa1]

I'm getting a lot of these errors:

Database error in vBulletin 3.8.3:

Invalid SQL:

                SELECT
                        link.linkid AS linkid, link.linkname AS linkname, link.linkdoi AS linkdoi,
                        link.linkuserid AS linkuserid, link.linkusername AS linkusername,
                        link.linkurl AS linkurl, link.linkimg AS linkimg,
                        link.linkimgthumb AS linkimgthumb, link.linkimgthumbsize AS linkimgthumbsize,
link.linkforum AS linkforum,
                        link.linkdesc AS linkdesc, link.numrate AS numrate, link.totrate AS totrate,
link.numcomment AS numcomment,
                        link.linkhits AS linkhits, link.linksize AS linksize, link.linkstatus AS linkstatus,
                        link.linkdate AS linkdate, link.linkmoderate AS linkmoderate, link.linkmoddate AS
linkmoddate,
                        link.linkreviewfreq AS linkreviewfreq,
                        ltoc.catid AS linkcatid, ltoc.displayorder AS linkdorder
                        , user.userid AS userid, user.avatarid AS avatarid, user.avatarrevision AS
avatarrevision, avatar.avatarpath AS avatarpath, NOT ISNULL(customavatar.userid)
AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS
avwidth,customavatar.height AS avheight
                        , ltoc2.catid AS linkcatid2
                        
                        , lkeys.keyid AS linkkeyid, lkeys.keyword AS linkkey
                        FROM vb6_linkslink AS link
                        LEFT JOIN vb6_linksltoc AS ltoc ON link.linkid = ltoc.linkid
                        LEFT JOIN vb6_user AS user ON (user.userid = link.linkuserid)
                        LEFT JOIN vb6_avatar AS avatar ON (avatar.avatarid = user.avatarid)
                        LEFT JOIN vb6_customavatar AS customavatar ON (customavatar.userid = user.userid)
        
                        LEFT JOIN vb6_linksltoc AS ltoc2
                        ON link.linkid = ltoc2.linkid
                
                        LEFT JOIN vb6_linksltok AS ltok
                        ON link.linkid = ltok.linkid
                        LEFT JOIN vb6_linkskeys AS lkeys
                        ON ltok.keyid = lkeys.keyid
                 WHERE link.linkforum NOT IN
(0,69,191,127,209,68,57,129,152,368,153,130,164,369,167,154,165,370,168,155,166,371,169,128,156,372,163,171,170,274,180,146,341,54,55,143,304,305,302,83,122)
 AND (link.linkid IN (-1) OR link.linkid IN
(-1,2267,355,417,928,1326,1332,1701,1752,1867,2105,2185,2186,3114,3798,3904,4105,4122,4303,4362,4482,5068,5362,5905,6030,6197,7050,7057,7561)
OR link.linkid IN (-1))  AND link.linkstatus != -3  AND (link.linkmoderate = 0 OR
                                (link.linkmoderate = -2 AND link.linkuserid = 57101))
                          AND ltoc.catid IN
(158%2C58%2C84%2C132%2C55%2C64%2C135%2C26%2C7%2C76%2C80%2C71%2C47%2C53%2C129%2C102%2C93%2C120%2C140%2C114%2C52%2C51%2C23%2C116%2C77%2C5%2C75%2C6%2C96%2C74%2C104%2C25%2C131%2C110%2C240%2C90%2C59%2C94%2C241%2C37%2C73%2C41%2C159%2C27%2C66%2C178%2C117%2C105%2C145%2C113%2C115%2C137%2C50%2C36%2C87%2C99%2C91%2C81%2C119%2C97%2C78%2C54%2C28%2C118%2C20%2C68%2C128%2C139%2C107%2C153%2C82%2C179%2C101%2C29%2C154%2C9%2C32%2C49%2C89%2C155%2C147%2C57%2C108%2C12%2C242%2C95%2C134%2C56%2C31%2C103%2C133%2C4%2C243%2C72%2C79%2C85%2C86%2C60%2C138%2C30%2C11%2C69%2C2%2C35%2C83%2C33%2C92%2C88%2C65%2C18%2C10%2C112%2C109%2C70%2C151%2C177%2C98%2C106%2C3%2C34%2C148%2C130%2C21%2C239%2C8%2C16%2C17%2C22%2C19%2C40%2C15%2C24%2C152%2C38%2C46%2C67%2C1)

                        ORDER BY   linkdate DESC, linkname ASC, linkcatid ASC;

MySQL Error   : Unknown column '2C58' in 'where clause'
Error Number  : 1054
Request Date  : Wednesday, December 2nd 2009 @ 10:27:35 PM
Error Date    : Wednesday, December 2nd 2009 @ 10:27:36 PM
Script        :
http://www.mysite.com/forum/local_links_search.php?s=&action=show&page=1&pp=40&search=academic%2Bscience%2Binternational&literal=2&desc=1&ents=1&keys=1&catlist=158%252C58%252C84%252C132%252C55%252C64%252C135%252C26%252C7%252C76%252C80%252C71%252C47%252C53%252C129%252C102%252C93%252C120%252C140%252C114%252C52%252C51%252C23%252C116%252C77%252C5%252C75%252C6%252C96%252C74%252C104%252C25%252C131%252C110%252C240%252C90%252C59%252C94%252C241%252C37%252C73%252C41%252C159%252C27%252C66%252C178%252C117%252C105%252C145%252C113%252C115%252C137%252C50%252C36%252C87%252C99%252C91%252C81%252C119%252C97%252C78%252C54%252C28%252C118%252C20%252C68%252C128%252C139%252C107%252C153%252C82%252C179%252C101%252C29%252C154%252C9%252C32%252C49%252C89%252C155%252C147%252C57%252C108%252C12%252C242%252C95%252C134%252C56%252C31%252C103%252C133%252C4%252C243%252C72%252C79%252C85%252C86%252C60%252C138%252C30%252C11%252C69%252C2%252C35%252C83%252C33%252C92%252C88%252C65%252C18%252C10%252C112%252C109%252C70%252C151%252C177%252C98%252C106%252C3%252C34%252C148%252C130%252C21%252C239%252C8%252C16%252C17%252C22%252C19%252C40%252C15%252C24%252C152%252C38%252C46%252C67%252C1&childcats=1&beforeafter=1&sort=d
Referrer      : http://www.mysite.com/forum/local_links_search.php
IP Address    : xx.xx.xx.xx
Username      : 
Classname     : vB_Database
MySQL Version :

Do you have any idea what could cause this?

[AndrewD]

Originally Posted by Alfa1

I'm getting a lot of these errors:

Database error in vBulletin 3.8.3:

Invalid SQL:

                SELECT
                        link.linkid AS linkid, link.linkname AS linkname, link.linkdoi AS linkdoi,
                        link.linkuserid AS linkuserid, link.linkusername AS linkusername,
                        link.linkurl AS linkurl, link.linkimg AS linkimg,
                        link.linkimgthumb AS linkimgthumb, link.linkimgthumbsize AS linkimgthumbsize,
link.linkforum AS linkforum,
                        link.linkdesc AS linkdesc, link.numrate AS numrate, link.totrate AS totrate,
link.numcomment AS numcomment,
                        link.linkhits AS linkhits, link.linksize AS linksize, link.linkstatus AS linkstatus,
                        link.linkdate AS linkdate, link.linkmoderate AS linkmoderate, link.linkmoddate AS
linkmoddate,
                        link.linkreviewfreq AS linkreviewfreq,
                        ltoc.catid AS linkcatid, ltoc.displayorder AS linkdorder
                        , user.userid AS userid, user.avatarid AS avatarid, user.avatarrevision AS
avatarrevision, avatar.avatarpath AS avatarpath, NOT ISNULL(customavatar.userid)
AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS
avwidth,customavatar.height AS avheight
                        , ltoc2.catid AS linkcatid2
                        
                        , lkeys.keyid AS linkkeyid, lkeys.keyword AS linkkey
                        FROM vb6_linkslink AS link
                        LEFT JOIN vb6_linksltoc AS ltoc ON link.linkid = ltoc.linkid
                        LEFT JOIN vb6_user AS user ON (user.userid = link.linkuserid)
                        LEFT JOIN vb6_avatar AS avatar ON (avatar.avatarid = user.avatarid)
                        LEFT JOIN vb6_customavatar AS customavatar ON (customavatar.userid = user.userid)
        
                        LEFT JOIN vb6_linksltoc AS ltoc2
                        ON link.linkid = ltoc2.linkid
                
                        LEFT JOIN vb6_linksltok AS ltok
                        ON link.linkid = ltok.linkid
                        LEFT JOIN vb6_linkskeys AS lkeys
                        ON ltok.keyid = lkeys.keyid
                 WHERE link.linkforum NOT IN
(0,69,191,127,209,68,57,129,152,368,153,130,164,369,167,154,165,370,168,155,166,371,169,128,156,372,163,171,170,274,180,146,341,54,55,143,304,305,302,83,122)
 AND (link.linkid IN (-1) OR link.linkid IN
(-1,2267,355,417,928,1326,1332,1701,1752,1867,2105,2185,2186,3114,3798,3904,4105,4122,4303,4362,4482,5068,5362,5905,6030,6197,7050,7057,7561)
OR link.linkid IN (-1))  AND link.linkstatus != -3  AND (link.linkmoderate = 0 OR
                                (link.linkmoderate = -2 AND link.linkuserid = 57101))
                          AND ltoc.catid IN
(158%2C58%2C84%2C132%2C55%2C64%2C135%2C26%2C7%2C76%2C80%2C71%2C47%2C53%2C129%2C102%2C93%2C120%2C140%2C114%2C52%2C51%2C23%2C116%2C77%2C5%2C75%2C6%2C96%2C74%2C104%2C25%2C131%2C110%2C240%2C90%2C59%2C94%2C241%2C37%2C73%2C41%2C159%2C27%2C66%2C178%2C117%2C105%2C145%2C113%2C115%2C137%2C50%2C36%2C87%2C99%2C91%2C81%2C119%2C97%2C78%2C54%2C28%2C118%2C20%2C68%2C128%2C139%2C107%2C153%2C82%2C179%2C101%2C29%2C154%2C9%2C32%2C49%2C89%2C155%2C147%2C57%2C108%2C12%2C242%2C95%2C134%2C56%2C31%2C103%2C133%2C4%2C243%2C72%2C79%2C85%2C86%2C60%2C138%2C30%2C11%2C69%2C2%2C35%2C83%2C33%2C92%2C88%2C65%2C18%2C10%2C112%2C109%2C70%2C151%2C177%2C98%2C106%2C3%2C34%2C148%2C130%2C21%2C239%2C8%2C16%2C17%2C22%2C19%2C40%2C15%2C24%2C152%2C38%2C46%2C67%2C1)

                        ORDER BY   linkdate DESC, linkname ASC, linkcatid ASC;

MySQL Error   : Unknown column '2C58' in 'where clause'
Error Number  : 1054
Request Date  : Wednesday, December 2nd 2009 @ 10:27:35 PM
Error Date    : Wednesday, December 2nd 2009 @ 10:27:36 PM
Script        :
http://www.mysite.com/forum/local_links_search.php?s=&action=show&page=1&pp=40&search=academic%2Bscience%2Binternational&literal=2&desc=1&ents=1&keys=1&catlist=158%252C58%252C84%252C132%252C55%252C64%252C135%252C26%252C7%252C76%252C80%252C71%252C47%252C53%252C129%252C102%252C93%252C120%252C140%252C114%252C52%252C51%252C23%252C116%252C77%252C5%252C75%252C6%252C96%252C74%252C104%252C25%252C131%252C110%252C240%252C90%252C59%252C94%252C241%252C37%252C73%252C41%252C159%252C27%252C66%252C178%252C117%252C105%252C145%252C113%252C115%252C137%252C50%252C36%252C87%252C99%252C91%252C81%252C119%252C97%252C78%252C54%252C28%252C118%252C20%252C68%252C128%252C139%252C107%252C153%252C82%252C179%252C101%252C29%252C154%252C9%252C32%252C49%252C89%252C155%252C147%252C57%252C108%252C12%252C242%252C95%252C134%252C56%252C31%252C103%252C133%252C4%252C243%252C72%252C79%252C85%252C86%252C60%252C138%252C30%252C11%252C69%252C2%252C35%252C83%252C33%252C92%252C88%252C65%252C18%252C10%252C112%252C109%252C70%252C151%252C177%252C98%252C106%252C3%252C34%252C148%252C130%252C21%252C239%252C8%252C16%252C17%252C22%252C19%252C40%252C15%252C24%252C152%252C38%252C46%252C67%252C1&childcats=1&beforeafter=1&sort=d
Referrer      : http://www.mysite.com/forum/local_links_search.php
IP Address    : xx.xx.xx.xx
Username      : 
Classname     : vB_Database
MySQL Version :

Do you have any idea what could cause this?

I can see that there's an obvious problem with the SQL - characters that should be commas are being transferred as %2C, which is the html escape sequence for commas. I've no idea why that should be. It looks like you are doing a search which is restricted to certain categories - I can't reproduce your problem.

Which version of LDM are you using and exactly what is the command which is triggering the error?

[Alfa1]

I'm using 2.3.0

I'm not sure what command is triggering the error. How can I find out?

[AndrewD]

Originally Posted by Alfa1

I'm using 2.3.0

I'm not sure what command is triggering the error. How can I find out?

I've uploaded a new version of LDM - see https://vborg.vbsupport.ru/showpost....&postcount=163

Please let me know if this resolves the problem.

[Alfa1]

I have installed the new version and can not reproduce the bug anymore.

Thank you.

[archaosus]

Originally Posted by AndrewD

The first of these should be possible, but I will have to investigate. LDM uses two different ways of transferring downloads to the user - normally using the so-called cURL library, and alternatively using fread() calls. Although cURL itself will handle speed limits, this is not made available via the php interface, so it will be necessary to go the fread() approach.

The answer to the second question is again, 'yes'. This should be a fairly straightforward piece of coding. I will investigate.

Thanks AndrewD - I have been using the mod now for a while and have finally gotten to grips with making it look and feel the way I want so this sort of speed limitation system will really put the icing on the cake!

[tamiyausa]

I'm getting this error when trying to view local_links.php

Content Encoding Error


The page you are trying to view cannot be shown because it uses an invalid or unsupported form of compression.



* Please contact the website owners to inform them of this problem.

I have uninstalled and reinstalled and reload all files for v 2.3.0

any ideas?

[GearX1]

Awesome Update thanks guys

[chet]

Originally Posted by tamiyausa

I'm getting this error when trying to view local_links.php

Content Encoding Error


The page you are trying to view cannot be shown because it uses an invalid or unsupported form of compression.



* Please contact the website owners to inform them of this problem.

I have uninstalled and reinstalled and reload all files for v 2.3.0

any ideas?

Same here

The page you are trying to view cannot be shown because it uses an invalid or unsupported form of compression.

Any ideas?

Ta

PS I have has this in and working for months, not sure what has changed and where