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.
Invalid SQL:
UPDATE dl_files SET `rating`=9,9 WHERE `id` = 7;
MySQL-Fehler : 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 '9 WHERE `id` = 7' at line 1
Fehler-Nr. : 1064
Fehler-Zeit : Monday, 16.03.2009 @ 13:55:37
Datum : Monday, 16.03.2009 @ 13:55:37
Skript : http://forum.computerbetrug.de/downl...id=7&rating=10
Referrer : http://forum.computerbetrug.de/downl...p?do=file&id=7
IP-Adresse : 77.20.165.139
Benutzername : Heiko
Klassenname : vB_Database_MySQLi
MySQL-Version : 5.0.32-Debian_7etch8-log
What are the names of the tables that get written to the database for this mod?
I see there might be about 8 but I'm not sure.
The ones I think they are are,
1. dl_cats
2. dl_comments
3. dl_downloads
4. dl_files
5. dl_images
6. dl_main
7. dl_stats
8. dl_votes
is there any other tables that are associated with downloadsII That I need to know about? The reason I want to know is for backup purposes.
Strange, as I'm using sql_prepare which should take care of adding quotes to the value.
You're the first having problems with it :erm:
Try this: open downloads.php and find
PHP Code:
$db->query_write("UPDATE " . TABLE_PREFIX . "dl_files SET `rating`=".$db->sql_prepare($voteinfo['total']/$voteinfo['votes'])." WHERE `id` = ".$file['id']);
replace with
PHP Code:
$db->query_write("UPDATE " . TABLE_PREFIX . "dl_files SET `rating`='".$db->escape_string($voteinfo['total']/$voteinfo['votes'])."' WHERE `id` = ".$file['id']);
Quote:
Originally Posted by darknusens
What are the names of the tables that get written to the database for this mod?
I see there might be about 8 but I'm not sure.
The ones I think they are are,
1. dl_cats
2. dl_comments
3. dl_downloads
4. dl_files
5. dl_images
6. dl_main
7. dl_stats
8. dl_votes
is there any other tables that are associated with downloadsII That I need to know about? The reason I want to know is for backup purposes.
That's all
+ some standard modifications to the user and usergroup table
I go the my Download page.... click Add from the Nav bar... fill everything out... open up my browser... select a zipped file... hit Add File and then I get this...
Hello, i´ve installed the mod and i´ve seen an error: 'Categories' and 'Import' options under 'Downloads' menu in admincp doesn´t work properly. When i try to go the main forum page load in the right frame.
I hope you'll help us too. This seems like a great hack that I'd like to get it working on PC101.
Thanks!
Lyte
UPDATE: Okay, I just noticed your update to the Download Details...
"Help!!! I can't upload large files?? This is probably the second most asked question. Have a look at this post for the solution."
I will give that a shot. Thanks!
FWIW this is not an issue that seems fixable by increasing upload limits from a .htaccess or php.ini file. I can increase the limits far past a 30MB test file and can not get a 30MB test file uploaded. For example setting the limits to 100MB does not fix being able to upload a 30MB file. Any other ideas?
DownloadsII Details »»
About Developer
Visit Web Site
DB Changes 
No support by the author.
03-16-2009, 11:58 AM
