Major Additions - DownloadsII

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.

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



Instructions & Support

Requires vBulletin 4.0.4 or higher. Not fully compatible with lower vB 4 versions.
It works fine with both the new editor in vB 4.1.4 or higher and the old one in previous vB versions.

Read the instructions in the next two posts before installing/upgrading this mod!

You can find an installation/upgrade manual in the zip package (Readme.txt).

I try to answer most questions asked in this thread. Please don't send any pm's if I don't ask for them. 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 some screenshots of the front-end and back-end (AdminCP part) of the DownloadsII software.

You can find a live demo on my own site: Minatica.be Downloads (Dutch).
Though keep in mind that we are running a restyled and modified version of it.

Changelog (version 6.0.9)

Jelle

• Added support for vB 4.1.8 bit processing with 'each' construct (backwards compatible)
• Fixed comma listing for vB 4.1.8 (using "old" method)

Older changelogs are included in the zip package.

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

This is probably the most asked question. It's mostly caused by some default PHP settings: check "PHP Max Post Size" and "PHP Maximum Upload Size" at your AdminCP home.

Then have a look at this post for the solution to up these values.
Also have a look at this post at vB.com (but ignore the MySQL part as DownloadsII is only using the file system).

Add-ons

There are currently no official add-ons. Unofficial add-ons are listed below.

[grahamsmythe]

Great mod, but keep getting a database error.

Uploaded files upload OK, but instead of a confirmation screen, we get a database error.

Any ideas?

Database error in vBulletin 4.0.8:

Invalid SQL:
SELECT downloadsIIforumid FROM dl2_main WHERE 1=1;

MySQL Error : Unknown column 'downloadsIIforumid' in 'field list'
Error Number : 1054
Request Date : Monday, November 8th 2010 @ 07:10:58 AM
Error Date : Monday, November 8th 2010 @ 07:10:58 AM
Script : http://www.ourdomainname.co.uk/downloads.php?do=add
Referrer : http://www.ourdomainname/downloads.php?do=add&cat=17
Username : username
Classname : vB_Database
MySQL Version : 5.1.42

[stationar]

Do you have this mode installed? DownloadsII Create New Thread Add-On [vB4]
Looks like it is trying to create a thread in the forum.

[grahamsmythe]

Originally Posted by stationar

Do you have this mode installed? DownloadsII Create New Thread Add-On [vB4]
Looks like it is trying to create a thread in the forum.

yes, I do have it installed.

I'll check that out.

Thanks for your help.

[stationar]

Just try to re-install it.

[Semlyen IT]

Is this a bug?

Once a user has uploaded a file, they're redirected to the page for that file (downloads.php?do=file&id=xx).

But if the file has to be moderated, the user can't view this page. So they get a "You don't have permissions to view this page" error page. Which is confusing for the users who will assume that the upload hasn't worked.

EDIT: At the risk of seeming a little hack-happy I fixed this by changing line 1645 in download.php from

$vbulletin->url = 'downloads.php?' . $vbulletin->session->vars['sessionurl'] . "do=file&id=$id";

to:

$vbulletin->url = 'downloads.php?' . $vbulletin->session->vars['sessionurl'];

[RS_Jelle]

Originally Posted by Montecristo

RS_Jell, I have found a bug.

I set in the group so that users can not delete your uploaded files and the same appears to them that option.

Any idea?

Good catch, pretty strange I really missed that permission check
This will be fixed in the next release.

Originally Posted by Nadeemjp

hi Jelle
I am running vb4.0.8 the latest version.
I have always uploaded files and never tried to download.
A couple of days ago I tried to download one of my own files and i came accross the following errors:


Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@familybunker.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.


--------------------------------------------------------------------------------

Apache mod_fcgid/2.3.5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 Server at www.familybunker.com Port 80


i tried downloading all the files and every file gives this error.
any particular reason why this is happening?

This is a server specific error. Internal server errors are mostly caused by invalid .htaccess contents.

Originally Posted by Smiler2009

I need to be able to filter the download categories based on additional usergroups, not just primary, is this being worked on for a future update?

Jeff.

I'm already looking into additional usergroups

Originally Posted by Semlyen IT

Is this a bug?

Once a user has uploaded a file, they're redirected to the page for that file (downloads.php?do=file&id=xx).

But if the file has to be moderated, the user can't view this page. So they get a "You don't have permissions to view this page" error page. Which is confusing for the users who will assume that the upload hasn't worked.

EDIT: At the risk of seeming a little hack-happy I fixed this by changing line 1645 in download.php from

$vbulletin->url = 'downloads.php?' . $vbulletin->session->vars['sessionurl'] . "do=file&id=$id";

to:

$vbulletin->url = 'downloads.php?' . $vbulletin->session->vars['sessionurl'];

I see you are running 6.0.5, just upgrade to 6.0.6 as it's fixed in it (in another way)

[Jackie1]

how can i clear database downloads and add another one new ?
i mean i dont know how to update count

[stationar]

To reset the counter, you set downloads field in dl2_main table to 0.
Also clear the dl2_downloads table.
Backup the database before manually tweaking it.

[Greeksgal]

I'm getting a atabase error after upgrading to 4.0.8

Database error in vBulletin 4.0.8:

Invalid SQL:
SELECT * FROM *****dl2_files ORDER BY dateadded DESC LIMIT;

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 '' at line 1
Error Number  : 1064
Request Date  : Thursday, November 11th 2010 @ 05:21:53 PM
Error Date    : Thursday, November 11th 2010 @ 05:21:53 PM
Script        : http://www.*********/forum.php
Referrer      : http://www.*************
IP Address    : *******
Username      : *****
Classname     : vB_Database
MySQL Version : 5.0.91-community

The dl2_files is a Downloads II table. Any idea what I can do to rectify this without uninstalling the plugin? All hooks are disabled via the config yet this error suggests that the plugin is still running?

If I uninstall this mod I will lose all my files, comments, download threads, yes? My forum is not working because of this error and I don't know what to do. I upgraded the files to the 4.0.8 compatiable version.

[RS_Jelle]

Originally Posted by Greeksgal

I'm getting a atabase error after upgrading to 4.0.8

Database error in vBulletin 4.0.8:

Invalid SQL:
SELECT * FROM *****dl2_files ORDER BY dateadded DESC LIMIT;

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 '' at line 1
Error Number  : 1064
Request Date  : Thursday, November 11th 2010 @ 05:21:53 PM
Error Date    : Thursday, November 11th 2010 @ 05:21:53 PM
Script        : http://www.*********/forum.php
Referrer      : http://www.*************
IP Address    : *******
Username      : *****
Classname     : vB_Database
MySQL Version : 5.0.91-community

The dl2_files is a Downloads II table. Any idea what I can do to rectify this without uninstalling the plugin? All hooks are disabled via the config yet this error suggests that the plugin is still running?

If I uninstall this mod I will lose all my files, comments, download threads, yes? My forum is not working because of this error and I don't know what to do. I upgraded the files to the 4.0.8 compatiable version.

That's not caused by DownloadsII itself:

Script        : http://www.*********/forum.php

DownloadsII hasn't got any plugins in the forum index. I guess you are using the unofficial "Forum block - latest files from downloads II" add-on or something like that.

Strange query though, without any limits.