Links and Downloads Manager

[hydn]

Whew. Good thing I didn't hehe.

No queries or no way of exporting then re-importing entries as new so that they create threads?

Thanks

[hydn]

Edit: go permissions fix. Would only like to create thread for old entries. Maybe via some sort of re-import?

[Rvl]

there is too bad download page? this mod has good features but i don't like file's download page.

[Simon Lloyd]

Hi Andrew, i've looked through this thread but i don't recall seeing this question asked, i have couple of mods (post thank you and Helpful posts) that show a count in the users profile in Statistics, i was wondering is it possible to do the same for LDM? i.e My LDM Uploads: xx My LDM Downloads: xx

EDIT: im using 2.30

[AndrewD]

Hi Andrew, i've looked through this thread but i don't recall seeing this question asked, i have couple of mods (post thank you and Helpful posts) that show a count in the users profile in Statistics, i was wondering is it possible to do the same for LDM? i.e My LDM Uploads: xx My LDM Downloads: xx

EDIT: im using 2.30

Simon, there's an option to add statistics to the user profile - LDM / admin/ settings / profile_ldmactivity

Is this what you are looking for.

[Simon Lloyd]

Simon, there's an option to add statistics to the user profile - LDM / admin/ settings / profile_ldmactivity

Is this what you are looking for.Hi, Andrew, that option is turned on and i see the recent uploads downloads as links in ldm blocks (as i have always done), what i'm talking about is when you go to a persons profiel and you have the tabs Visitors. About me, Statistics...etc, click the statistics and you have a series of lightly outlined boxes showing you "counts" from particular locations, this is where i would like to show
LDM Count
My LDM Downloads: xx
My LDM Uploads: xx

Does that make sense?

EDIT: I'm copying this thread to the 3.8.x version of this thread as i realise i made a mistake where posting.

[angeljs]

I've just installed this on my site, and I think it's a fantastic mod. However, no matter how I try I cannot get normal members to see the extra entry attributes than I need them to select when uploading files.

I've trawled through this thread and tried every suggestion I can think of, but only the admin can see/select any of the extra attributes.

It's my first time using this mod, so it's probably something I'm missing...I've tried changing permissions and everything, but it's the only thing now that I can't get to work. :(

Edit:
Oops! my bad...I forgot to select can_edit_entities in the usergroups config!

[AndrewD]

I've just installed this on my site, and I think it's a fantastic mod. However, no matter how I try I cannot get normal members to see the extra entry attributes than I need them to select when uploading files.

I've trawled through this thread and tried every suggestion I can think of, but only the admin can see/select any of the extra attributes.

It's my first time using this mod, so it's probably something I'm missing...I've tried changing permissions and everything, but it's the only thing now that I can't get to work. :(

Edit:
Oops! my bad...I forgot to select can_edit_entities in the usergroups config!

Glad to hear things are working ok. Yes, there are so many permissions and settings and it can be overwhelming. I'll have to take another look at the presentation.

[obmob]

wow, we have been really silent here... well, after all LDM works really well :D

Now that the new 4.0 was announced, I'm really dissapointed with the new prices and ideas behind... seems they haven't made things easy for mods.

Hope LDM still works with 4.0, there will never be such thing in vB developers mind.

Hope you are all doing fine! :)

[chickendippers]

This is a great addon, I love it and have been using it for ages. My site is getting popular and I'm getting a lot of bandwidth usage so I'm looking at the bandwidth limit features.

If I set a download allowance for the Unregistered user group, will that apply to ALL unregistered users. Or will each unregistered user get their own allowance?

For example, if I set a daily limit of 100Mb and one unregistered user downloads a 100Mb file, will the next unregistered user be able to download?

Thanks in advance!

[AndrewD]

This is a great addon, I love it and have been using it for ages. My site is getting popular and I'm getting a lot of bandwidth usage so I'm looking at the bandwidth limit features.

If I set a download allowance for the Unregistered user group, will that apply to ALL unregistered users. Or will each unregistered user get their own allowance?

For example, if I set a daily limit of 100Mb and one unregistered user downloads a 100Mb file, will the next unregistered user be able to download?

Thanks in advance!

If everything is working correctly (which I hope is true ;)), allowances for registered users apply to the username but allowances for unregistered users to the IP address. So, one unregistered user will not affect another unless they happen to be using the same computer/accidently share the same IP address.

A side effect is that unregistered users can get themselves a new allowance by going to a new computer, but we felt this was an acceptable compromise. (The other side effect, which is that registered users can get a new allowance by signing up for multiple accounts, can be partially prevented by selecting the 'Count all accesses from user's IP address against that user's allowances' box on the allowances admin page.)

[chickendippers]

That's great news. Thank you very much for the fast response.

I must say your documentation is incredibly detailed and has answered all my questions apart from this one.

Thanks again!

[obmob]

Those allowances apply 100mb per IP address, not just for one unregistered user.

[exportforce]

Hello,

will you update this mod to work with VB4 ? Please, tell me that you do... *hopes*

[AndrewD]

Hello,

will you update this mod to work with VB4 ? Please, tell me that you do... *hopes*

I *hope* to do so :). I have bought licences for the new forum + CMs software and am currently trying to get me head around how things work. The upgrade will probably not be a very quick process, however - quite important bits of the infrastructure have changed.

[itsblack]

I *hope* to do so :). I have bought licences for the new forum + CMs software and am currently trying to get me head around how things work. The upgrade will probably not be a very quick process, however - quite important bits of the infrastructure have changed.
Good news! Thank you Andrew!

[Leo Brazil]

Good to hear about a 4.0 update too.

[obmob]

OMG! You are the man Andrew! :D
Well, I did download the new beta, this week i'll make first attemp to upgrade locally.

thanks

[archaosus]

Is it possible to add some sort of hard coded limitation on download speed to the downloads perhaps by using fread() - I dont mind modifying a couple of lines of code and slowing things down for all users if I have to however I host massive files and it would be an ideal situation to be able to slow everyone to 300kps tops during peak. I don't know much about coding sadly however my guess is that if the amount for speed is set as a variable X then fread's speed beinf that variable that was set means the speed can be changed on the fly by just either changing a config file or an entry in the relevant download file itself.

Anyway - my question really should be, how do I do this, where do I put it and thanks :)

Edit, bonus question - is there also way to display the last 50 people who downloaded and what it is that they downloaded - then I could have that on the front page of the download system.

[AndrewD]

Is it possible to add some sort of hard coded limitation on download speed to the downloads perhaps by using fread() - I dont mind modifying a couple of lines of code and slowing things down for all users if I have to however I host massive files and it would be an ideal situation to be able to slow everyone to 300kps tops during peak. I don't know much about coding sadly however my guess is that if the amount for speed is set as a variable X then fread's speed beinf that variable that was set means the speed can be changed on the fly by just either changing a config file or an entry in the relevant download file itself.

Anyway - my question really should be, how do I do this, where do I put it and thanks :)

Edit, bonus question - is there also way to display the last 50 people who downloaded and what it is that they downloaded - then I could have that on the front page of the download system.

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.

[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,36 9,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,2 185,2186,3114,3798,3904,4105,4122,4303,4362,4482,5 068,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%2 C241%2C37%2C73%2C41%2C159%2C27%2C66%2C178%2C117%2C 105%2C145%2C113%2C115%2C137%2C50%2C36%2C87%2C99%2C 91%2C81%2C119%2C97%2C78%2C54%2C28%2C118%2C20%2C68% 2C128%2C139%2C107%2C153%2C82%2C179%2C101%2C29%2C15 4%2C9%2C32%2C49%2C89%2C155%2C147%2C57%2C108%2C12%2 C242%2C95%2C134%2C56%2C31%2C103%2C133%2C4%2C243%2C 72%2C79%2C85%2C86%2C60%2C138%2C30%2C11%2C69%2C2%2C 35%2C83%2C33%2C92%2C88%2C65%2C18%2C10%2C112%2C109% 2C70%2C151%2C177%2C98%2C106%2C3%2C34%2C148%2C130%2 C21%2C239%2C8%2C16%2C17%2C22%2C19%2C40%2C15%2C24%2 C152%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%25 2C135%252C26%252C7%252C76%252C80%252C71%252C47%252 C53%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%252C7 3%252C41%252C159%252C27%252C66%252C178%252C117%252 C105%252C145%252C113%252C115%252C137%252C50%252C36 %252C87%252C99%252C91%252C81%252C119%252C97%252C78 %252C54%252C28%252C118%252C20%252C68%252C128%252C1 39%252C107%252C153%252C82%252C179%252C101%252C29%2 52C154%252C9%252C32%252C49%252C89%252C155%252C147% 252C57%252C108%252C12%252C242%252C95%252C134%252C5 6%252C31%252C103%252C133%252C4%252C243%252C72%252C 79%252C85%252C86%252C60%252C138%252C30%252C11%252C 69%252C2%252C35%252C83%252C33%252C92%252C88%252C65 %252C18%252C10%252C112%252C109%252C70%252C151%252C 177%252C98%252C106%252C3%252C34%252C148%252C130%25 2C21%252C239%252C8%252C16%252C17%252C22%252C19%252 C40%252C15%252C24%252C152%252C38%252C46%252C67%252 C1&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]

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,36 9,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,2 185,2186,3114,3798,3904,4105,4122,4303,4362,4482,5 068,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%2 C241%2C37%2C73%2C41%2C159%2C27%2C66%2C178%2C117%2C 105%2C145%2C113%2C115%2C137%2C50%2C36%2C87%2C99%2C 91%2C81%2C119%2C97%2C78%2C54%2C28%2C118%2C20%2C68% 2C128%2C139%2C107%2C153%2C82%2C179%2C101%2C29%2C15 4%2C9%2C32%2C49%2C89%2C155%2C147%2C57%2C108%2C12%2 C242%2C95%2C134%2C56%2C31%2C103%2C133%2C4%2C243%2C 72%2C79%2C85%2C86%2C60%2C138%2C30%2C11%2C69%2C2%2C 35%2C83%2C33%2C92%2C88%2C65%2C18%2C10%2C112%2C109% 2C70%2C151%2C177%2C98%2C106%2C3%2C34%2C148%2C130%2 C21%2C239%2C8%2C16%2C17%2C22%2C19%2C40%2C15%2C24%2 C152%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%25 2C135%252C26%252C7%252C76%252C80%252C71%252C47%252 C53%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%252C7 3%252C41%252C159%252C27%252C66%252C178%252C117%252 C105%252C145%252C113%252C115%252C137%252C50%252C36 %252C87%252C99%252C91%252C81%252C119%252C97%252C78 %252C54%252C28%252C118%252C20%252C68%252C128%252C1 39%252C107%252C153%252C82%252C179%252C101%252C29%2 52C154%252C9%252C32%252C49%252C89%252C155%252C147% 252C57%252C108%252C12%252C242%252C95%252C134%252C5 6%252C31%252C103%252C133%252C4%252C243%252C72%252C 79%252C85%252C86%252C60%252C138%252C30%252C11%252C 69%252C2%252C35%252C83%252C33%252C92%252C88%252C65 %252C18%252C10%252C112%252C109%252C70%252C151%252C 177%252C98%252C106%252C3%252C34%252C148%252C130%25 2C21%252C239%252C8%252C16%252C17%252C22%252C19%252 C40%252C15%252C24%252C152%252C38%252C46%252C67%252 C1&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]

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.php?p=1925165&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]

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:D

[chet]

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

[chet]

Been searching and still can not find the answer, does anybody on this thread know why?

[AndrewD]

Been searching and still can not find the answer, does anybody on this thread know why?

Not sure - never seen this before. Does this only happen with LDM and with all its pages, or with specific pages. Does it happen with all browsers?

Have you tried going to the main vb admincp and unsetting GZIP HTML Output?

[chet]

Its just LDM, I will try your suggestion and see what happens

Cheers

[chet]

Gzip worked but now getting

Warning: uksort() [function.uksort.php]: Array was modified by the user comparison function in [path]\includes\local_links_include.php on line 1227

[AndrewD]

Gzip worked but now getting

Warning: uksort() [function.uksort.php]: Array was modified by the user comparison function in [path]\includes\local_links_include.php on line 1227

This is caused by different error handling in the latest version of php. I've posted a fix here: https://vborg.vbsupport.ru/showpost.php?p=1970268&postcount=238 and will update the releases when I've got reliable internet services again.

I suspect that the content encoding problem may also be related to php version, so will investigate.

[ritunb]

Hi Andrew. Is it possible to get new entries in the LDM and few more stats in the vBAdvanced CMPS box? That way I can show our members the latest downloads available.

Regards,

RB

[AndrewD]

Hi Andrew. Is it possible to get new entries in the LDM and few more stats in the vBAdvanced CMPS box? That way I can show our members the latest downloads available.

Regards,

RB

Have you checked out the LDM vbadvanced modules in the /release/vba_modules directory of the zip file?

[ritunb]

Have you checked out the LDM vbadvanced modules in the /release/vba_modules directory of the zip file?

Hi Andrew, Thanks. It worked. But I'm having another issue. When I enable one of the VBA module (for example New Downloads), it shows in all the forums but one of the restricted access forum is giving HTTP 500 error (The web page is not loading). Is is a common issue? How can I resolve this?

I'm using LDM 2.2.9.

Regards,

[ezak]

hi Andrew,
I have a little problem,
I make some groups to add links and posts in LDM ,
but I don't need to make them can delete them links (poster can delete his link)
i don't find any option to disable (delete box) at all except admins

[Alfa1]

Andrew has passed away on April 22nd after a long illness.
His obituary can be found here:
http://www.eirma.org/activities/Obituary.pdf

It has always been my impression that LDM was a work of art that Andrew devoted a substantial amount of time/years to. He was quite dedicated to the creation and development of LDM.


This version and the 3.8 version of LDM are marked as reusable code. This means that any coder can take up this project and prevent LDM going to waste. It would be a shame that after all the years of work and dedication Andrew has put into it, it could no longer be used.

It remains to be seen how long this version of LDM keeps working, after new vbulletin versions are released.

[MissKalunji]

omg i'm so sorry....R.I.P andrew..

[stuartn]

Anyone have an issue with taptalk on it....constantly getting this error...

Invalid SQL:

SELECT downloads.linkid AS linkid, downloads.userid AS userid, downloads.usertime AS usertime,
links.linkname AS linkname, ltoc.catid AS catid, lcat.catname AS catname
FROM local_linksdownloads AS downloads
LEFT JOIN local_linkslink AS links
ON downloads.linkid = links.linkid
LEFT JOIN local_linksltoc AS ltoc
ON links.linkid = ltoc.linkid
LEFT JOIN local_linkscat AS lcat
ON lcat.catid = ltoc.catid
WHERE userid=
ORDER BY usertime DESC
LIMIT 10;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY usertime DESC
LIMIT 10' at line 11

[moon_spell]

nice is there ayn for 4.1 ?

[Alfa1]

Here: https://vborg.vbsupport.ru/showthread.php?t=231407

[moon_spell]

Here: https://vborg.vbsupport.ru/showthread.php?t=231407
does not works on 4.1.1 after upgrade i am no more able to use this on my page !

[Nam]

OMG, still have lots of PMs between me and him. The best guy I ever met with online, offered me help with customization at no charge. I can't believe I just realized it now that he passed away.

R.I.P

[DNN]

does this mod also resize video automatically?

[chickndipp]

I migrated my data to Downloads II (https://vborg.vbsupport.ru/showthread.php?t=231427) by running the following MySQL query against my vBulletin database:


INSERT INTO dl2_files(title,description,author,_author,uploade r,uploaderid,url,totaldownloads,dateadded,size)
SELECT linkname, linkdesc, linkusername, linkusername, linkuserid, linkurl, linkhits, linkdate, linksize
FROM local_linkslink WHERE ORDER BY linkid ASC

UPDATE `dl2_files` SET `category` = '1' WHERE `category` = '0';

UPDATE `dl2_files` SET `url` = REPLACE(`url`, "/user_uploads", "");


This will assign all files to the default category which DownloadsII created following a fresh installation.

Then in AdminCP -> DownloadsII -> Settings, change the 'Downloads Folder Path' setting to:


./user_uploads


Finally go to /downloads.php?do=manfiles and click "Update Counters".

Now all you have to do is create your categories and edit your files to assign them appropriately. Definitely a time-saver vs. adding everything manually to a new script.

Hope that helps!