Major Additions - DownloadsII

There's a vB4 version of this mod available: https://vborg.vbsupport.ru/showthread.php?t=231427

DownloadsII

DownloadsII is a download database that integrates into vBulletin. It allows you to upload files, add images to them, create categories, link to external files - and more. It is very flexible and has many options.

Because a lot of people keep on asking this:
This mod works with any version of vBulletin 3.7.x and 3.8.x!

It's also coded 100% XHTML 1.0 Transitional valid, just like vBulletin itself.



Instructions & Support

You can find an installation manual in the zip package (Readme-Install.txt).

We try to answer most questions asked in this thread. Please don't send any pm's if we don't ask for them, as we said we try to give a high level of support in this thread. Don't forget to click the install link, so you will receive important update notifications.

Screenshots & Live demo

At the bottom of this post, you can find 6 screenshots of the front-end and back-end (AdminCP part) of the DownloadsII software. You can see the newest version in action at the Minatica.be Downloads (Dutch).

Changelog (version 5.1.2)

Jelle

• Backported CSRF security fix from the vB 4 release
• Added permission check for Update Counters
• Fixed PHP warnings when running PHP 5.3
• Removed the imagecreatefrombmp() function. It doesn't exist.
• Added permission check for rating submissions

You can find all the changelogs of this and older versions here.

Help!!! I can't upload large files??

This is probably the second most asked question. Have a look at this post for the solution.

It doesn't work with GARS?!

If you also use the latest version of GARS, you will get the "Fields marked in RED must be filled in!" error when uploading a file. I provided a fix here on the GARS forums.

Addons

We are offering 3 addons for this mod at the moment (have a look at the bottom of this post for them). DownloadsII contains 5 hook locations for the vBulletin plugin systems, so you can add extra functionality without file edits.

Do you want to help expanding DownloadsII (if you are a coder)? Check out this post!

Notes

• ecDownloads Buddy is NOT compatible with this version. If you are using the Buddy, you should UNINSTALL it before installing DownloadsII ver 5.x.x. The Buddy's features are now integrated into DownloadsII.
• DownloadsII is a direct derivative work from Ron1n's ecDownloads.

Addons

• DownloadsII ver 5.0 vbAdvanced Add-On
• DownloadsII PM moderation notification
• DownloadsII Create New Thread Add-On
• DownloadsII Simple RSS Feed Add-On
• DownloadsII[Add-On] - Upload Rules

[bollie]

I get down reported along mail.
I everything have already removed.

Database error in vBulletin 3.6.0:

Invalid SQL:
SELECT * FROM dl_files WHERE `purgatory` = '0' AND `category` = '31' ORDER BY `pin` DESC, `dateline` DESC LIMIT 0,20;

MySQL Error : Unknown column 'dateline' in 'order clause'
Error Number : 1054
Date : Tuesday, August 8th 2006 @ 05:10:20 PM
Script : http://........../forum/downloads.ph...&sort=dateline
Referrer :
IP Address :
Username :
Classname : vB_Database

[HappyPike]

I don't think there is a field called "dateline". Try changing it to sort by "date" instead.

Westpointer, in a future version, think you can make it so when someone edits a file to upload a new version or deletes a file entry, the file gets deleted from the server as well? This way those old obsolete files don't take waste server space.

[novelidea]

Is it possible to make sure users post a certain number of posts on the forums to have access to the downloads? If not, that would be a nice addition.

[HappyPike]

It's posible to do that using vB's user group permissions and promotion system.

I have a question myself: Since anyone can download files on my site, would it be a problem when search bots try to index the downloads section and visit the download links, generating incorrect download count for the file?

EDIT: I added rel="nofollow" to all the download links. Hope this is enough to prevent search bots from visiting those download links.

[RS_Jelle]

Normally rel="nofollow" is enough, but you can't stop all of the bots very easily (those bots are most of the time of dubious search engines who are also providing spyware toolbars, ...)

[project-Buckfas]

Perfect,

Thank You!

Originally Posted by westpointer

I found this occurs when clicking on the on the download link located on the page that lists a summary of the files in the category but not when looking at the detailed listing for one file.

To fix it, in downloads.php around line 300 -

FIND:

PHP Code:

    if ($db->num_rows($result) > 0)
    {
        while ($file = $db->fetch_array($result))
        {
            $date = vbdate($vbulletin->options['dateformat'],$file['date'],true);        
            $downloads = vb_number_format($file['downloads']); 


BELOW that ADD:

PHP Code:

            // added to open links in a new window Aug 1, 06
            if ($file['link'] == 1)
            {
                $target = 'target="_blank"';
            }
            else
            {
                $target = 'target="_self"';
            } 


[Mickie D]

there is still an issue with this version and php5 which needs looking at

https://vborg.vbsupport.ru/showpost....&postcount=240

[Mr.T]

Hello,
I've installed it an now I got a problem by uploading files. I got this SQL-error:

Datenbankfehler in vBulletin 3.5.3:

Invalid SQL:
INSERT INTO dl_files (`name`, `desc`, `author`, `_author`, `uploader`, `uploaderid`, `url`, `date`, `category`, `size`, `pin`, `purgatory`, `link`)
											VALUES('test', 'dgadfg', 'sdf', 'sdf', 'TeamO', '1545', '87292-arpr.zip', 1155487292, '1', 1311486, '0', '0', 0);

MySQL-Fehler : Unknown column 'desc' in 'field list'
Fehler-Nr.   : 1054
Datum        : Sunday, August 13th 2006 @ 06:41:32 PM
Skript       : xxxxxxx
Referrer     : xxxxxxxxx
IP-Adresse   : yyy.yyy.yyy.yyy
Benutzername : test
Klassenname  : vb_database

By changing the table-name description in dl_files to desc it works fine. What should I do, so that the tablename is desciption and all works?


T

[RS_Jelle]

The name of the desc field changed to description. So it seems that your database is up-to-date, so you have imported the product file correctly. But this query is impossible, I checked it again and every query is changed to use description.

So try to reupload and overwrite all the files (you haven't uploaded the newest ones)

[Mr.T]

I have dowloaded the version today, so I think it's up-to-date. But I try it once again.

hmmm. first ther is no change. but after some minutes all works.

T