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.
Onec a day I get the next error (below). How can I fix it?
PHP Code:
Database error in vBulletin 3.8.4:
Invalid SQL:
SELECT dl_files.*, dl_cats.name catname FROM dl_files, dl_cats WHERE (y OR dl_files.author LIKE '%Discrétisations variationnelles de problèmes aux limites elliptiques%' OR dl_files.name LIKE '%Discrétisations variationnelles de problèmes aux limites elliptiques%' OR dl_files.description LIKE '%Discrétisations variationnelles de problèmes aux limites elliptiques%')
AND dl_files.category = dl_cats.id
ORDER BY catname, dl_files.name;
MySQL Error : Unknown column 'y' in 'where clause'
Error Number : 1054
Request Date : Friday, October 30th 2009 @ 03:39:39 AM
Error Date : Friday, October 30th 2009 @ 03:39:39 AM
Script : http://forum.com/downloads.php?do=search
Referrer : http://forum.com/downloads.php?do=search
IP Address : ***
Username : Unregistered
Classname : vB_Database_MySQLi
MySQL Version :
admin, you do not have permission to access this page. This could be due to one of several reasons:
1. Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
2. If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.
Hi Welshy, I am still get a white page once I upload the image, and the image does not show up on the Download sections, but when I check the download folder on my hosting, it shows that the uploaded file is there.
I have checked on the Usergroup Permissions, I have got the option under Downloads II Permission "Can Upload Images" marked as Yes, any other options do I need to enable as well?
Onec a day I get the next error (below). How can I fix it?
PHP Code:
Database error in vBulletin 3.8.4:
Invalid SQL:
SELECT dl_files.*, dl_cats.name catname FROM dl_files, dl_cats WHERE (y OR dl_files.author LIKE '%Discr?tisations variationnelles de probl?mes aux limites elliptiques%' OR dl_files.name LIKE '%Discr?tisations variationnelles de probl?mes aux limites elliptiques%' OR dl_files.description LIKE '%Discr?tisations variationnelles de probl?mes aux limites elliptiques%')
AND dl_files.category = dl_cats.id
ORDER BY catname, dl_files.name;
MySQL Error : Unknown column 'y' in 'where clause'
Error Number : 1054
Request Date : Friday, October 30th 2009 @ 03:39:39 AM
Error Date : Friday, October 30th 2009 @ 03:39:39 AM
Script : http://forum.com/downloads.php?do=search
Referrer : http://forum.com/downloads.php?do=search
IP Address : ***
Username : Unregistered
Classname : vB_Database_MySQLi
MySQL Version :
btw, MySQL database version 5.1.41
That's the search query, but it isn't executed every day. Rather every time someone does a search. There's nowhere an "y" in it, there's even no variable to get something in there.
Can you pm me your site url (and login information for the downloads section)?
admin, you do not have permission to access this page. This could be due to one of several reasons:
1. Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
2. If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.
You need to set your DownloadsII usergroup permissions to have access to the downloads section.
Quote:
Originally Posted by joyceleong
Hi Welshy, I am still get a white page once I upload the image, and the image does not show up on the Download sections, but when I check the download folder on my hosting, it shows that the uploaded file is there.
I have checked on the Usergroup Permissions, I have got the option under Downloads II Permission "Can Upload Images" marked as Yes, any other options do I need to enable as well?
Thanks.
That seems to be a server issue. Can you pm me your site url (and login information for the downloads section)?
Agree too. Hope you make it support 4.0 when its like in RC1 ?
I'm already working on a vB 4 release, which goes pretty smooth. Only, the new style isn't that beautiful/practical to create something like the current vB 3 layout.
DownloadsII Details »»
About Developer
Visit Web Site
DB Changes 
No support by the author.
11-29-2009, 06:00 AM
