The Arcive of Official vBulletin Modifications Site.

DownloadsII · **Released**: 07-01-2006

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

wolfe · #**1252** 05-06-2007, 11:54 AM

m8 any chance you could tell me what code to put where to have to upload image with file i need urgently i will use until your update comes out m8 :P thx in advance

any is it possible to make a stats box for index.php page like the ones on the side of the downloads page.

MotMann · #**1253** 05-06-2007, 12:22 PM

Quote:

Originally Posted by RS_Jelle

I tested it and it works without errors. You should be replacing it wrong or something like that. Watch out for the brackets.

Anyway, when I tested it, it didn't work correctly like I thought it would.

A new try, tested and it works nice:

Find (in downloads.php)

PHP Code:


			
            while ($image = $db->fetch_array($result))
            {
                if (($permissions['ecdownloadpermissions'] & $vbulletin->bf_ugp['ecdownloadpermissions']['caneditallfiles']) OR
                   (($permissions['ecdownloadpermissions'] & $vbulletin->bf_ugp['ecdownloadpermissions']['caneditownfiles']) AND
                    (($image['uploaderid'] == $vbulletin->userinfo['userid']) AND ($file['uploaderid'] == $vbulletin->userinfo['userid']))))
                    $edit = '[<a href="./downloads.php?do=file&amp;id='.$file['id'].'&amp;act=delimg&amp;img='.$image['id'].'" onclick="return delete_it()">'.$vbphrase['delete'].'</a>]';
                {
                    if (file_exists($dl->url.$image['thumb']))
                    {
                        $dimages .= '<a href="'.$dl->url.$image['name'].'"><img src="'.$dl->url.$image['thumb'].'" alt="'.$file['name'].'" title="'.$file['name'].'" border="0" /></a> by <a href="./member.php?u='.$image['uploaderid'].'">'.$image['uploader'].'</a> on '.vbdate($vbulletin->options['dateformat'], $image['date'], true).' '.$edit.'<br />';
                    }
                    else
                    {
                        $dimages .= '<a href="'.$dl->url.$image['name'].'">'.$image['name'].'</a> by <a href="./member.php?u='.$image['uploaderid'].'">'.$image['uploader'].'</a> on '.vbdate($vbulletin->options['dateformat'], $image['date'], true).' '.$edit.'<br />';
                    }
                }
            }

Replace with

PHP Code:


			
            $dimages .= '<table cellpadding="0" cellspacing="1" border="0"><tr>';
            while ($image = $db->fetch_array($result))
            {
                if (($permissions['ecdownloadpermissions'] & $vbulletin->bf_ugp['ecdownloadpermissions']['caneditallfiles']) OR
                   (($permissions['ecdownloadpermissions'] & $vbulletin->bf_ugp['ecdownloadpermissions']['caneditownfiles']) AND
                    (($image['uploaderid'] == $vbulletin->userinfo['userid']) AND ($file['uploaderid'] == $vbulletin->userinfo['userid']))))
                {
                    $edit = '[<a href="./downloads.php?do=file&amp;id='.$file['id'].'&amp;act=delimg&amp;img='.$image['id'].'" onclick="return delete_it()">'.$vbphrase['delete'].'</a>]';
                }

                if (file_exists($dl->url.$image['thumb']))
                {
                    $dimages .= '<td class="smallfont"><a href="'.$dl->url.$image['name'].'"><img src="'.$dl->url.$image['thumb'].'" alt="'.$file['name'].'" title="'.$file['name'].'" border="0" /></a><br />by <a href="./member.php?u='.$image['uploaderid'].'">'.$image['uploader'].'</a> on '.vbdate($vbulletin->options['dateformat'], $image['date'], true).' '.$edit.'</td>';
                }
                else
                {
                    $dimages .= '<td class="smallfont"><a href="'.$dl->url.$image['name'].'">'.$image['name'].'</a><br />by <a href="./member.php?u='.$image['uploaderid'].'">'.$image['uploader'].'</a> on '.vbdate($vbulletin->options['dateformat'], $image['date'], true).' '.$edit.'</td>';
                }
            }
            $dimages .= '</tr></table>';

Okey.. that works mosly. Problem.. if there a lot of screens, there are all in one row. There ist no break in the line.

• But, where i must change the code, that the Thumbs will be larger? And how must the code looks?

• Why Users can't upload the moviefiles AND Screens at the same time?
• What i must do, that the dl button will be NOT displayed, if user yust upload images, no movies?
• What happened with watermarks?

Wonderfull support here

RS_Jelle · #**1254** 05-06-2007, 01:42 PM

Quote:

Originally Posted by wolfe

is it possible to show the file listings as image say 3 per row and when you mouse over the image a box pops up with info also is it possible to make it require image after its added. ?

I don't see it anywhere, so I think it isn't possible

We also can't code this "in a minute"; it's not a small thing. Add-ons are created for popular requests (like creating a new thread for a new file, the vBa module, ...).

Quote:

Originally Posted by wolfe

m8 any chance you could tell me what code to put where to have to upload image with file i need urgently i will use until your update comes out m8 :P thx in advance

any is it possible to make a stats box for index.php page like the ones on the side of the downloads page.

For the first thing: I'm sorry, but the same answer as above.

The second thing is possible and already available, check out the vBadvanced CMPS module add-on. You need to integrate vBa CMPS first into your index.php to display vBa modules in it, this is explained on vbadvanced.com

If you don't want a seperate vBa column, then you can have a look at the module code. If you have some vBulletin coding knowledge, you can easily mod this for use on other pages.

wolfe · #**1255** 05-06-2007, 03:03 PM

i have made my own forumindex stats box but i would like to know where to code is that updates the dl_main table with the <tr><td> stats for the 3 boxes on the left so i can edit the code to show the category and uploader name / id etc.

what you think so far

Fireproof · #**1256** 05-06-2007, 03:41 PM

Sorry for this question, but is the new version going to be avaiable in a matter of days, or weeks, or likely months?

I'm putting together a new vBulletin board and trying to decide if I should go ahead and install this, or just wait for the new version that is coming soon. Not trying to rush you, I understand it's a LOT of work. Just looking for an estimate on when it *might* be ready.

Thanks,

BozzaJos · #**1257** 05-07-2007, 12:31 PM

Quote:

Originally Posted by CyberRanger

In case you are uncertain, this version works perfectly well on vb 3.6.x too.

Thanks for the quick response. One minute ago I wanted to import the product for vb3.6.5 but got the following database error:

Quote:

Database error in vBulletin 3.6.5:

Invalid SQL:
ALTER TABLE `dl_cats` CHANGE `desc` `description` TEXT NOT NULL;

MySQL Error : Duplicate column name 'description'
Error Number : 1060
Date : Monday, May 7th 2007 @ 03:23:17 PM
Classname : vB_Database

LBmtb · #**1258** 05-07-2007, 03:45 PM

Quote:

Originally Posted by Fireproof

Sorry for this question, but is the new version going to be avaiable in a matter of days, or weeks, or likely months?

I'm putting together a new vBulletin board and trying to decide if I should go ahead and install this, or just wait for the new version that is coming soon. Not trying to rush you, I understand it's a LOT of work. Just looking for an estimate on when it *might* be ready.

Thanks,

Check a few posts up . . . .

Quote:

Originally Posted by LBmtb View Post
Any idea on when the new version will be released? I'm waiting on that till I give this a shot. Unless the update will be nice and clean?

It takes a lot more time than I expected. It's not all very difficult PHP code, but it's much new code (and recoding all the old)

Upgrade will be pretty painless. One thing: you will lose your download ratings, but I don't think many people really use this feature. This because the current system with a lot of possibilities gets replaced by a -vBulletin like- stars system. You also need to redo some settings, for example the extensions setting gets replaced by a whole new extensions management (like the vBulletin attachments).

But I would suggest you to just use the current version as it works great and the upgrade will be easy to do with a documentated upgrade wizard script.

RS_Jelle · #**1259** 05-07-2007, 07:03 PM

Quote:

Originally Posted by wolfe

i have made my own forumindex stats box but i would like to know where to code is that updates the dl_main table with the <tr><td> stats for the 3 boxes on the left so i can edit the code to show the category and uploader name / id etc.

what you think so far

Looks nice

You can change the PHP code inside /includes/class_downloads.php

It's done by the update_x_x() functions.

Quote:

Originally Posted by BozzaJos

Thanks for the quick response. One minute ago I wanted to import the product for vb3.6.5 but got the following database error:

Is it a new, clean install or ... ? It seems that your database is already contains the description field instead of the old desc field, so the update fails. If it's an upgrade: from which to which version? All information is useful

BozzaJos · #**1260** 05-07-2007, 07:25 PM

Well.. I think I might have done something wrong but I need you to tell me how to fix it hahaha.

I've upgraded my forum from 3.5 to 3.6 and imported my old database. There was something wrong with my database and I couldn't upgrade directly. So I had to install a second forum, import the database there and upgrade to vb3.6. I think I've also imported the downloadsII tables. I guess that's all the info I can give you... let me know if you need more! Thanks in advance for helping me...

RS_Jelle · #**1261** 05-07-2007, 07:33 PM

Quote:

Originally Posted by BozzaJos

Well.. I think I might have done something wrong but I need you to tell me how to fix it hahaha.

I've upgraded my forum from 3.5 to 3.6 and imported my old database. There was something wrong with my database and I couldn't upgrade directly. So I had to install a second forum, import the database there and upgrade to vb3.6. I think I've also imported the downloadsII tables. I guess that's all the info I can give you... let me know if you need more! Thanks in advance for helping me...

Normally if it's a forum without DownloadsII, the best way to do this is installing a clean DownloadsII installation. This will add the dl2 tables, settings, usergroups, and much other junk

Then you use phpMyAdmin (that's the most easiest way) and you remove (drop) all the dl2 tables of the clean installation. And finally you import your backup dl2 tables of the original installation. So: all the settings, usergroups, ... things are installed correctly in the database by the new install and all the data imported by the old dl2 tables.

You can't install DownloadsII properly using the product file if the dl2 tables are already present.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.08285 seconds Memory Usage 2,417KB Queries Executed 27 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (2)bbcode_php (11)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (4)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (6)pagenav_pagelinkrel (11)post_thanks_box (1)post_thanks_box_bit (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit (11)post_thanks_postbit_info (10)postbit (8)postbit_attachment (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start fetch_musername post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end post_thanks_function_fetch_thanks_bit_start post_thanks_function_show_thanks_date_start post_thanks_function_show_thanks_date_end post_thanks_function_fetch_thanks_bit_end post_thanks_function_fetch_post_thanks_template_start post_thanks_function_fetch_post_thanks_template_end postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_attachment postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

Благодарность от:
puertoblack2003

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!