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.

[AndrewD]

How to Install and Use LDM

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

Remember to BACKUP YOUR DATABASE before installing or upgrading.

LDM installs as a VBulletin product and requires no modifications to the standard VB code. On most sites, the installation and upgrading processes are the same:

a) upload files from the /release/forums directories of the zip file,
b) if you wish, upload icons from the /release/icon directory, then
c) run the VB Product installer and install the product-eirma_ldm.xml file contained in the /release directory.

You can ignore the contents of the /development directory in the zip file unless you are curious.

04.02.08: Bug Fix Path

The patch-cat.xml file provided above contains a fix against a bug which can give unauthorised users access to protected files in your LDM database. This is *only* required if you use LDM's *can_access_category* permission to limit access to certain categories. It is not needed if you use this permission to restrict your entire database, by denying this permission at the admin level. Install as a normal VB plugin.

Important Installation Notes

1. By default, LDM database tables are prefixed 'local_'. Edit the configuration file, local_links_init.php, if you need/wish to change this. If you do so, remember to make the same changes each time you upgrade.

2. If your web site runs on Microsoft's IIS web server in cgi mode (you can find this out by looking at the main VB admincp page), a key php environment variable DOCUMENT_ROOT is not defined by default. This causes serious problems with the placement of files on your server. LDM detects this problem and issues a fatal error if necessary. If this occurs, edit includes/local_links_init.php and define the constant LDM_DOCUMENT_ROOT. The code highlights where to make the edit. Alternatively, you can patch your web server to define DOCUMENT_ROOT correctly.

Features

LDM handles a large (32767) number of categories and nested subcategories, and an essentially unlimited number of entries (hyperlinks or downloadable files) in these categories. Each entry can be placed in one or several categories. Categories can have styles. Descriptions and titles can use BBcodes, smilies, images and html, giving the possibility to add images, colouring, etc. File types can be flagged using icons. Entries can have associated thumbnail images. Entries can be added manually by the site admin and/or by the user community, or can be generated automatically by synchonising with directories on your server.

A number of layout templates are provided, suitable for libraries of links, files, documents, and photographs. There are several Jukebox addins which play most types of media files.

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 he/she changes his 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 further restrict visibility/access to some of your entries and categories by using the permissions masks from your board's forums.

Moderation of new entries is available, and entries can be set to expire after a certain period or require re-moderation.

Users can report bad links to the relevant moderators/administrators, and can send messages to their friends to let them know about the contents of LDM.

Each user can flag links as his/her "Favourites", and site administrators can set up "Featured" sites.

A range of modules are provided that integrate with VBAdvanced.

Many hooks are provided throughout the LDM code, and a range of sample plugins is included in the release (see extras directory), for example to read ID3 tags in mp3 files, to create slideshows, to autocreate threads announcing new LDM entries in your forums, etc.

Plus much more.

Version 2.2.8-post1

These are the significant changes in release 2.2.8-post1 compared to 2.2.7:

Administration

admin/categories/mass edit categories and admin/categories/mass edit links include option to mass edit the display orders
admin/import/export includes facility to download Google-type sitemap of your LDM database; imports/exports can be gzipped
admin/hits Tidy hits table (archive/delete) accepts optional list of usernames
New settings variable *perpage_download* controls default hits per page on admin/hits
admin/keywords extended to enabled merging/renaming of keywords
admin/settings and admin/permissions highlight all parameters that can be over-ridden within categories, not just those that have been over-ridden
local_links_init.php (ADMIN_USER_GROUP) extended to allow multiple usergroups to have access to LDM admin
autocreate thread/post code extended and integrated into main product
(NB: users of existing autocreate 'extra', refer to 'extra' directory for info)

Allowances

Allowances apply to all files delivered from the local server and from mirrors

Categories

Add/Edit Category allows same username changes as Add/Edit Entry
autocreate linked forum includes choice whether to display linked forum on forumjump menus

Comments and Ratings

Options to display summary inline within the linkbit or as drop-down
Moderators can create/edit comments by other users and change the submitting user for comments

Entries

Add/Edit Entry form modified to clarify options to replace existing entry with url or upload
*allow_add_multi* setting enables creation of several entries at once
Options added to Edit Entry to delete/replace existing uploaded image

Mirror sites
Mirror sites supported by new admin page. When a download satisfies a mirror test, user is presented
with list of available mirrors and is asked to choose one.

Permissions

Add/Edit Category, Edit Entry, Select Category and Set Display Order permissions made inheritable
*can_search_link* permission allows/denies access to searches
*must_add_keyword* permission requires at least one keyword on add/edit entry
*must_comment_and_rate* disables rating submit button until user selects a rating
*must_rate_download*, *must_rate_play* permissions added to force comment/rating before allowing download/play

Page layout

Category information tidied up
Show Latest Ratings menu item added, displays most recently rated entries
Size displayed for entries with filetype other than htm/html even if not in attachment table
New Modern (top) linkbit added - same as Modern, except everything aligns to the top rather than middle of the row

Ratings

Users who can edit other's comments can also change their ratings
User avatars displayed within ratings bits
Users denied *must_rate_download*/*must_rate_play* permission can still download/play their own submissions without rating

Translations

Arabic language removed - obsolete and very incomplete
French, Chinese, Dutch and Spanish translations brought up to date

vBulletin integration

apply_censor option defines whether to apply vBulletin censorship features
vb's forum password protection implemented within LDM
- when viewing categories associated with a password-protected forum
- when attempting to view/play entries associated with a password-protected forum

VBAdvanced

Tested with vbAdvanced version 3 - NB not version 2. Code works in function-wrap and global modes
Bandwidths displayed by *ldm_tot* module display to 1 or 2 decimal places when appropriate
thumbs module uses cached thumbnail when possible
Keyword tagcloud module added

Extras

systematic revision of extras to use LDM admin settings page to control behaviour
*add-page-information* extra displays arbitrary text withi main displays
*auto_threadcreate* removed and fully integrated into LDM
*block-context-menu* extra now works in player windows
*blockhit-bytime* extra added to allow usergroup d/l blocks by time of day
*external-links-framed* opens external urls in an iframe
*filmstrip* extra provides strip overview of category contents when viewing single entry
*import-radiostations* imports xml data files prepared using Dream's excellent radiostations hack (vb.org thread 152037)
*jukebox-enhancements* extra brought up to date
*JWplayer* provides Jeroen Wijering's generalised mp3/swf/flv media player
*secureurl* extra added to lock play/download urls to entries/times/userid/ip address
*similarthreads* extra patches showthread's 'similar threads' feature to include *similar LDM entries*
*spider-me* extra tidied up ('spider me' text if icon not found)
*tagcloud* extra, as per vbadvanced but displayed within LDM

Hooks

More hooks inserted into code
Internal code around calls to the links_addlink_preinsert hook made consistent throughout LDM

Bug fixes

Fixed My Profile listing of entries placed in multiple categories
Fixed LDM's attempt to redirect user when entry has moved to a different category from that given in a url
Fixed submit bug with Admin/Media Players/edit settings
Fixed miscellaneous bugs in admin/hits analyses
Fixed bug whereby invalild default_forumid locks everyone out
Made Edit Category command visible when current user owns the current category
Fixed Add/Edit Entry handling of timezones with half hour deltas
Improved efficiency of code which emails users about updates to their downloaded entries
Improved error messages for logged in users who lack *can_access_link* permission
Main edit message boxes correctly pick up *formwidth_usercp* style setting
Removed the stray text in the bold linkbit
Corrected problems with handling of vba thumb sizes
LDM 'latest entry' information in forum displays handles assigned forum permissions
autothread - fixed various bugs with cross-posting of comments/ratings; ratings without remarks don't get posted
Who's Online entries brought up-to-date; Downloading gets recorded correctly
Changed autocreate thread to be inactive by default
Fixed broken admin layout when improper settings found in database
Validate entries resets invalid filesizes
Fixed invalid userid setting on edit entry
Fixed invalid userid test on edit category
Fixed bug for players requiring fullurl when playing offsite media files
Fixed allowance reporting bug (links counted as files on main displays)
Allowances apply to downloadable files even when force_redirect set to 1
Fixed Wimpy Button to work via vbAdvanced when not in forum directory
Searches work in utf-8 languages (but still don't highlight correctly)
DOI searches on advanced search work correctly
Fixed bug whereby image-type entries never gained thumbnail if link_imagesize=0 at time of creation
Fixed spurious 'Nothing to show' message when *featured_sites* enabled but none visible in current category
Fixed bug with *sync_username* parameter, leading to wrong associated userid.
Partial content transfers work correctly with IIS webserver
Fixed a spurious *rename* error message if the name of an uploaded file contains characters that are invalid on some operating systems
Trap seriously malformed urls such as http:// with no site

Translations

Spanish - complete for 2.2.8 - thanks ObMob
French - complete for 2.2.8 - thanks Pitchoune
Chinese - complete for 2.2.8 - thanks ItsBlack
Dutch - complete for 2.2.8, thanks Alfa1
German - nearly up to date for 2.2.6 - thanks dLutt

[GTAce]

Cool - I'm doing my own testing of vB 3.6 for my forums and was sad to see the directory not work for 3.6 Beta...I'll check this out later

Thanks for being so quick with it!

[dilbert]

I'm getting excited about 3.6 now.
This mod is significant and I would have waited to upgrade until it was finished.
Thanks.

[GTAce]

*clicks install*

Upgraded to Beta 2 and LDM 2.2.2 last night, and no problems so far - nicely done!

I'll probably be upgrading to Beta 3 tonight also...it's funny how that happens...you upgrade your forums and the next day a new version is released, doh!

[Tyegurl]

Originally Posted by GTAce

*clicks install*

Upgraded to Beta 2 and LDM 2.2.2 last night, and no problems so far - nicely done!

I'll probably be upgrading to Beta 3 tonight also...it's funny how that happens...you upgrade your forums and the next day a new version is released, doh!

lol i had that happen too! within hours of me upgrading to 3.6.0 beta 2....they came out with 3.6.0 beta three!!

not a problem yet with links and downloads

[Tyegurl]

okay i came across this....

Database error in vBulletin 3.6.0 Beta 3:

Invalid SQL:

SELECT linkid, userid, usertime
FROM local_linksdownloads
ORDER BY usertime DESC;

MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Date : Thursday, June 22nd 2006 @ 03:54:03 PM
Script : http://www.teamrespawn.com/vBulletin...d=569&catid=30

[AndrewD]

Originally Posted by Tyegurl

okay i came across this....

Database error in vBulletin 3.6.0 Beta 3:

Invalid SQL:

SELECT linkid, userid, usertime
FROM local_linksdownloads
ORDER BY usertime DESC;

MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Date : Thursday, June 22nd 2006 @ 03:54:03 PM
Script : http://www.teamrespawn.com/vBulletin...d=569&catid=30

Is this reproducible, and is this the only LDM database error? Lost connection errors are usually caused by some sort of problem on your database server.

If it's reproducible, have you used LDM to download anything yet (i.e. is it possible that the downloads table is empty)?

[Tyegurl]

hmmm hmmm and hmmm

this is reproducible....not the only db error....i will get more....

i was downloading a song and was listening about 45 seconds into it...

i would imagine my downloads table isn't empty but i couldn't tell you for sure...what would i look for?

[AndrewD]

Originally Posted by Tyegurl

hmmm hmmm and hmmm

this is reproducible....not the only db error....i will get more....

i was downloading a song and was listening about 45 seconds into it...

i would imagine my downloads table isn't empty but i couldn't tell you for sure...what would i look for?

Interesting - I had one other report of this problem a few months back, also when someone was using the jukebox. The database search is done when LDM has thrown the last bit of the file at the user's browser, and is recording a 'hit'. I'll take another look. MySQL seems to croak sometimes when it's asked to do a search and nothing is found. What version of MySQL/PHP are you running?

You can, in the meantime (I hope), hide the error in one of two ways:
- give all usergroups "can_bypass_hit_recording" on the LDM admin permissions page, or
- set timeout_hit_recording and timeout_hit_allow to 0 on the LDM admin settings page