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.

[webgeek247]

Another thing I just seen that vbseo also have http://www.vbseo.com/wiki/vBSEO_Comp...k:Downloads_II

Not exactly sure what it does, will have to look into it more. Though I wonder if that rewrite rule format is something to go by to get ldm to work with vbseo

[Rouzbeh1]

Originally Posted by AndrewD

Sorry, I'd missed the capitals and spaces. Here's a modified version of includes/local_links_include.php

this solved the caps and spaces problem. thanks

Originally Posted by AndrewD

If you set seo_friendly to 2, you need a different set of mod_rewrite rules. These are the ones I am using as test. If you also set seo_title, then you need to replace local_links in the first part of each rule by your seo_title:

RewriteRule (.*)local_links/links/c-[^/]+-([0-9]+)$	$1local_links.php?catid=$2 [R,L]
RewriteRule (.*)local_links/links/c-[^/]+-([0-9]+)/([0-9]+)$		$1local_links.php?catid=$2&linkid=$3 [R,L]
RewriteRule (.*)local_links/jump/c-[^/]+-([0-9]+)/([0-9]+)$	$1local_links.php?action=jump&catid=$2&id=$3 [R,L]
RewriteRule (.*)local_links/play/c-[^/]+-([0-9]+)/([0-9]+)$	$1local_links.php?action=play&catid=$2&linkid=$3 [R,L]
RewriteRule (.*)local_links/links/c-[^/]+-([0-9]+)(\?page=[0-9]+)$	$1local_links.php?catid=$2&page=$3	[R,L]
RewriteRule (.*)local_links/play/c-[^/]+-([0-9]+)/([0-9]+)(\?page=[0-9]+)$	$1local_links.php?action=play&catid=$2&linkid=$3&page=$4	[R,L]

i tried it in many different ways but it didn't work

[webgeek247]

Andrew,

I tried to get help on vbseo to get the ldm alphanumeric urls to work with vbseo, but it turns out that even with vbseo turned off they still dont work. You check out that vbseo thread if you like. Im totaly baffled by it now heh

Aye at least the ldm numeric urls works with vbseo. Would be great to get the alphanumeric urls to work properly though

[AndrewD]

Originally Posted by Rouzbeh1

i tried it in many different ways but it didn't work

Are you using the mod_rewrite approach? I had to debug things by turning on logging (log level 2) and then watching what was happening.

I have an English board working fine with the rules I posted.

[GrendelKhan{TSU]

great job as usual andrew

found some bugs (at least on mine)
- 2.2.9 RC
- vb3.7.0 RC1

1)
-- cat_icon_new
-- cat_icon_new
-- subcat_icon
still not showing up. its not reading the "forums/" folder and gets an error (doubles up the forums directory) if you put it in manually eg:

The following settings are invalid:
cat_icon (/forums/linksdownloads/icons/xxxxxxxxx .jpg) Cannot find icon 'htt p://www. xxxxx. com/forums/forums/linksdownloads/icons/music-to-frag-to-Clan-TSU.jpg' - specify relative to forum directory or use full url

- ldm no cat icons

2) template_linkbit (short: title+thumb): TITLE is not appearing.
bug (at least for me): ldm no title

3) also, would be nice to see a bullet or something next to the items in the statistics. (or as an options).

too hard to read individual items otherwise. (don't know where one starts and another ends).

- LDM (right side stats)


still awesome stuff.

[itsblack]

Hi Andrew, I have installed 2.2.9 RC. Thank you.

I got mysql error when I search the multiple words such as "Cambridge Companions" with the option "all words" or "exact phrase". There's no problem with the option "any word".

PHP Code:

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.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
            
            , ltoc2.catid AS linkcatid2
            
            , lkeys.keyword AS linkkey
            FROM local_linkslink AS link
            LEFT JOIN local_linksltoc AS ltoc ON link.linkid = ltoc.linkid
            
            
            
    
            LEFT JOIN local_linksltoc AS ltoc2
            ON link.linkid = ltoc2.linkid
        
            LEFT JOIN local_linksltok AS ltok
            ON link.linkid = ltok.linkid
            LEFT JOIN local_linkskeys AS lkeys
            ON ltok.keyid = lkeys.keyid
         WHERE link.linkforum NOT IN (0)  AND (link.linkid IN () OR link.linkid IN (-1,355,425,427,428,429,430,431,436,439,483,673,723,801,1051,1063,1079,1118,1129,1159,1161,1160,1179,1180,1321,1371,1410,1578,1579,1580,1584,1593,1594,1595,1646,1687,1771) OR link.linkid IN (-1)) 
            ORDER BY   linkdate DESC, linkname ASC, linkcatid ASC;

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 ') OR link.linkid IN (-1,355,425,427,428,429,430,431,436,439,483,673,723,801,1051' at line 28
ERROR       : 1064 


My mysql version is 5.0.45. Now what can I do?

[Rouzbeh1]

Originally Posted by AndrewD

Are you using the mod_rewrite approach? I had to debug things by turning on logging (log level 2) and then watching what was happening.

I have an English board working fine with the rules I posted.

i used both vbseo AND also mod_rewrite
i have also tested it on my test board with only mod_rewrite + ldm internal function
none of them worked

[AndrewD]

Originally Posted by itsblack

Hi Andrew, I have installed 2.2.9 RC. Thank you.

I got mysql error when I search the multiple words such as "Cambridge Companions" with the option "all words" or "exact phrase". There's no problem with the option "any word".

My mysql version is 5.0.45. Now what can I do?

Interesting, that bug has been there for quite some time but has only just been hit. I think this version of local_links_search.php fixes the bug.


I'm now going to have to see how to deal with the 3.6.10/3.7.0RC4 changes.

[edited: attachment removed - now in the release code]

[AndrewD]

Originally Posted by Rouzbeh1

i used both vbseo AND also mod_rewrite
i have also tested it on my test board with only mod_rewrite + ldm internal function
none of them worked

This is the relevant section of my http-vhosts file

<VirtualHost *:80>
	ServerName vb37
	DocumentRoot "r:/websites/vb37"

#	RewriteLog "C:/Program Files/Apache Software Foundation/Apache2.2-ssl/logs/rewrite.log"
#	RewriteLogLevel 2

	RewriteEngine on
#	RewriteEngine off

# - normal mode

#	RewriteRule (.*)local_links/links/([^0-9].+)$						$1$2 													[R,L]
#	RewriteRule (.*)local_links/links/([0-9]+)$							$1local_links.php?catid=$2 								[R,L]
#	RewriteRule (.*)local_links/links/([0-9]+)/([0-9]+)$				$1local_links.php?catid=$2&linkid=$3 					[R,L]
#	RewriteRule (.*)local_links/jump/([0-9]+)/([0-9]+)$					$1local_links.php?action=jump&id=$2&catid=$3 			[R,L]
#	RewriteRule (.*)local_links/play/([0-9]+)/([0-9]+)$					$1local_links.php?action=play&catid=$2&linkid=$3 		[R,L]
#	RewriteRule (.*)local_links/links/([0-9]+)(\?page=[0-9]+)$			$1local_links.php?catid=$2&page=$3	 					[R,L]
#	RewriteRule (.*)local_links/play/([0-9]+)/([0-9]+)(\?page=[0-9]+)$	$1local_links.php?action=play&catid=$2&linkid=$3&page=$4	[R,L]

# -- extended mode

	RewriteRule (.*)local_links/links/c-[^/]+-([0-9]+)$					$1local_links.php?catid=$2 								[R,L]
	RewriteRule (.*)local_links/links/c-[^/]+-([0-9]+)/([0-9]+)$		$1local_links.php?catid=$2&linkid=$3 					[R,L]
	RewriteRule (.*)local_links/jump/c-[^/]+-([0-9]+)/([0-9]+)$			$1local_links.php?action=jump&catid=$2&id=$3 			[R,L]
	RewriteRule (.*)local_links/play/c-[^/]+-([0-9]+)/([0-9]+)$			$1local_links.php?action=play&catid=$2&linkid=$3 		[R,L]
	RewriteRule (.*)local_links/links/c-[^/]+-([0-9]+)(\?page=[0-9]+)$	$1local_links.php?catid=$2&page=$3	 					[R,L]
	RewriteRule (.*)local_links/play/c-[^/]+-([0-9]+)/([0-9]+)(\?page=[0-9]+)$	$1local_links.php?action=play&catid=$2&linkid=$3&page=$4	[R,L]
	Options +ExecCGI
</VirtualHost>

Maybe you can post what you have tried?

[Alfa1]

How can I:
- get rid of the 'my recent LDM hits' box on profile?
- get rid of the mentions of LDM in the 'About me'tab on profile?
- change the phrase of 'My recent LDM entries'?
- add a section on the 'statistics' tab on profile to display: 'total documents', 'total video's' and 'total audio'? Note that video, documents and audio are separate categories in my LDM.

Does the swf uploader use a different url, than local_links.php?action=addlink ? I was just wondering, because I don't get it to work from local_links.php?action=addlink