Major Additions - [DBTech] vBDownloads v2 (vB4) [AJAX]

vBDownloads: What is it?

DragonByte Technologies is proud to present vBDownloads v1.0, the most professional, innovative and feature-rich downloads mod to date.

vBDownloads aims to help you manage your forum's downloads in a fast and efficient way, presenting you with all the information you and your users need.

Why vBDownloads?
Whilst looking for a new product idea, we felt that there was a need for a fully-supported downloads database in vBulletin. vBDownloads is the result of this. vBDownloads contains many interesting features such as multi-file downloads, password-protected downloads and many more exciting and innovative features!

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

If you like this mod please hit the button to the right ---->

Please remember to click the, button to the right if you installed the mod ---->

What does 'Marking As Installed' do ?

* It helps you to stay on top of updates - members who have installed modifications will be notified by us whenever new updates are available.

* For security issues - vbulletin.org will contact all members who have installed a modification whenever a security issue is brought to their attention.

* Marking a modification as installed also helps us know how many people are using our work, giving us extra incentive to provide more features and new modifications.

We appreciate the support!
-------------------------------------------------------------------------------------------

Differences between Pro and Lite

Priority support & Product Demos available at: http://www.dragonbyte-tech.com/vbdownloads.php

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

Translations available @ Dragonbyte-Tech.com
Support for translations handled by the translator in its respective threads only.

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

Major Features:

Searchable Downloads: Search downloads by title, description, author, or a combination of the above.

Importer: vBDownloads currently supports importing from DownloadsII.

Favourite Downloads: Got a download you like? vBDownloads will allow you to easily add it to your favourites list.

Multiple File Downloads: vBDownloads allows you to upload multiple files within one download stopping the need to create 20 different downloads for one thing.

Moderation: vBDownloads comes with its own moderation control panel. This will allow you to easily moderate new files and reports.

DragonByte SEO Integration: Seamlessly integrates with DragonByte SEO to create Friendly URLs for all your downloads & categories.


Extra Pro Features:
Download All Files: This will allow you to easily download all files in a download at the click of a button. These will be added to a zip and returned to you in seconds.

File Ratings: File ratings will allow users to easily separate the good content from the bad.

Downloads Per Day: This feature will allow you to control the number of files and add a limit to the size of downloads users are allowed to download per day.

Private Downloads: This feature will allow you to control who can access a download on a per user basis and allow you to password-protect downloads.


Complete Feature List
Lite

System Information

• Whether the mod is active
• Total bandwidth usage
• Monthly bandwidth usage
• Number of uploaded files
• Value of php.ini's maximum execution time
• vBDownloads' version number
• Number of MBs of disk space all files use
• Number of MBs of disk space this month's files use
• Value of php.ini's maximum upload size
• Value of php.ini's memory limit

Extensions

• Group extensions together into Extension Groups
• Define extension
• Define MIME Type
• Define maximum file size
• Define Max Width / Max Height (only applies to images)

Categories

• Define Title / Description
• Set display order
• Choose category image
• Choose extension groups valid for this category
• Automatically place new files in moderation queue
• Per-usergroup Can View Category permission
• Per-usergroup Can Download Files permission
• Per-usergroup Can Upload Files permission

Import Utility

• Import from DownloadsII
• Preserves all important data
• Avoids duplicate imports

Settings

• Toggle displaying version number
• Turn vBDownloads on/off
• Reason for turning vBDownloads off
• Welcome Notice for the homescreen
• Storage path for uploads
• Custom name for the main .php file
• Maximum files per download
• Minimum posts to download
• Download description preview length
• Enable/Disable Favourites system
• Enable/Disable Comments system
• Enable/Disable Mirrors system
• File Reporting Reasons
• Comment Reporting Reasons
• Mirror Reporting Reasons

Usergroup Permissions

• Downloads Manager, bypasses certain restrictions
• Can View vBDownloads
• Can Download
• Can Upload
• Can Favourite
• Can Comment
• Download Delay (in seconds)

Home Page

• Display welcome message
• Search downloads by title, description, author or any combination of the above
• Category list in the same style as Forums are listed on Forum Home
• Display number of files and number of downloads per category
• Display latest download per category
• Sub-categories in the same style as sub-forums
• Sidebar block: Total files and total downloads
• Sidebar block: Recent files, changes based on what category you're browsing
• Sidebar block: Top downloads, changes based on what category you're browsing

Uploads

• jQuery-powered upload script
• Works with big files
• No Flash plugins required
• Progress bars on uploads
• Display file sizes in-line
• Quick deletion of files
• Toggle which files are screenshots

Download Page

• Thumbnail
• Edit / delete file
• Send file to moderation queue
• Add to favourites
• Add a comment
• Basic file information: Author, Last Updated, Category and Total Downloads
• File List w/ number of downloads
• Mirror List w/ number of hits
• "More From This User" block with thumbnails of other downloads by this user
• Full description
• Paginated comments list
• Edit/Delete comments
• Password entry page if the download is password protected
• Download delay page when downloading files if applicable

Favourites List

• Paginated display of downloads added to favourites
• Same style as search results

ModCP

• Tabbed interface for Moderation Queue / Reports
• Ability to take no action, approve and deny moderation queue entries
• Ability to take no action, dismiss or delete reported entries

Thumbnail Generation

• Ability to choose which image to use for thumbnail generation
• A physical thumbnail image will be generated when one is requested
• Saves bandwidth / decreases load time vs. using full image resized

Category Aware Search

• Choose to restrict search to currently viewed category
• Only available when browsing a category
• Perfect for searching through a large downloads database for less unique keywords

Pro

Mirror Link Images

• Define replacement domains
• Set what image to show instead of direct link to mirror

Categories

• Allow private downloads
• Allow password protected downloads
• Category Parent
• Choose forum to announce new downloads in

Settings

• Download delay page advertisement
• Path to importable files
• Enable/Disable [DBTech] vBShout integration
• Enable/Disable Rating system
• Enable/Disable ability to download all files as zip
• Zip filename prefix
• Post To Thread: Title
• Post To Thread: Message

Usergroup Permissions

• Maximum downloads per day
• Maximum downloads size per day
• Can Rate Downloads
• Can Create Category
• Can Import Files

Home Page

• Sidebar block: Highest rated, changes based on what category you're browsing

Download Page

• Rate the download +1/-1
• "Download All Files" button
• Display advertisement on downloads delay page

Manage Categories

• Allows users with the necessary permissions to manage categories via front-end
• Download Managers can edit all Category settings
• Non-Managers see their categories added to moderation queue

Import Files

• Allows users with the necessary permissions to import files from the filesystem
• Pre-defined path or custom path
• Imported files aren't copied or moved
• Ability to skip or re-import files
• Per-file category assignment
• Per-file download title

Who's Online Display

• Displays users / guests browsing vBDownloads
• Uses same HTML/CSS as forum home's "What's Going On" box
• Displays full markup username
• Can be turned off via vBulletin Options

vBDownloads Statistics Display

• Displays total number of downloads
• Displays total number of files
• Displays total bandwidth usage
• Displays total storage space usage
• Uses same HTML/CSS as forum home's "Forum Statistics" box
• Can be turned off via vBulletin Options

Per-Usergroup "Minimum Posts" Bypass

• Ability to bypass the "Minimum Posts" setting per-usergroup
• Perfect for donator / VIP usergroups
• Toggled via Usergroup Manager

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

This mod displays a copyright notification in the footer of pages generated by this mod which includes:

• 1 Link to DragonByte Technologies homepage
• 1 Link to Product Description page of this modification

[bzcomputers]

Originally Posted by DragonByte Tech

I guess I'm not seeing the urgency in this? Currently, you can use an image to replace the title area and if you don't use the description area, you can remove it from the template. This would accomplish the same thing.

Dylan

For me at least ...unlike most vB add-ons I use, your Downloads page typically has a lot of empty/unused real estate on it. I am trying in make use of the space in a more visually appealing way. Currently unless a user has at least 15 categories with descriptions there is going to be a significant amount of blank space on the page. Removing the description area would only make this worse.

I know for me personally it would look a lot better with the ability to have images in the description area, so I suggested it. I thought it would be a pretty simple edit.

If it doesn't help others too, then don't waste your time.

[andyv72]

Hello..

i found a big Bug or it is my fault !?!?

if i change a user to other Usergroup the bekom i this error in database:

Datenbankfehler in vBulletin 4.2.0:

Invalid SQL:
UPDATE user SET
### Bitfield: user.adminoptions ###
adminoptions = IF(adminoptions & 1, adminoptions - 1, adminoptions),
adminoptions = IF(adminoptions & 2, adminoptions - 2, adminoptions),
usertitle = 'Neuer Benutzer',
customtitle = 0,
birthday_search = '1990-05-10',
birthday = '05-10-1990',
referrerid = 0,
usergroupid = 9,
joindate = 1327603620,
lastactivity = 1327603920,
lastpost = 0,
membergroupids = '',
displaygroupid = 0,
dbtech_downloads_banned = '0'
WHERE userid = 212;

MySQL-Fehler : Unbekanntes Tabellenfeld 'dbtech_downloads_banned' in field list
Fehler-Nr. : 1054
Fehler-Zeit : Monday, 23.07.2012 @ 15:31:06
Datum : Monday, 23.07.2012 @ 15:31:06
Skript : http://www.**********.de/admincp/user.php?do=update
Referrer : http://www.**********.de/admincp/user.php?do=edit&u=212
IP-Adresse : 91.64.37.210
Benutzername : Andy-V72
Klassenname : vB_Database
MySQL-Version : 5.5.25-1~dotdeb.0

to change a User i must Deaktivite Downloads..

[DragonByte Tech]

Originally Posted by andyv72

Hello..

i found a big Bug or it is my fault !?!?

if i change a user to other Usergroup the bekom i this error in database:



to change a User i must Deaktivite Downloads..

Do you have downloads setup yet or are you still in the process of setting it up? It looks like one of the fields created on install didn't get created. If you don't have downloads in there, are still in the process of setting it up and testing, I would suggest uninstalling and reinstalling.
If you already have it setup and being used I can give you a sql query to run to insert the field.

Dylan

[andyv72]

Originally Posted by DragonByte Tech

Do you have downloads setup yet or are you still in the process of setting it up? It looks like one of the fields created on install didn't get created. If you don't have downloads in there, are still in the process of setting it up and testing, I would suggest uninstalling and reinstalling.
If you already have it setup and being used I can give you a sql query to run to insert the field.

Dylan

Hi Dylan

Have it Deinstall and reinstall ..same Problem.

Here is version 1.3.6 in admincp i see version 1.3.5

[bzcomputers]

Originally Posted by andyv72

Hi Dylan

Have it Deinstall and reinstall ..same Problem.

Here is version 1.3.6 in admincp i see version 1.3.5

Seeing similar issue upgrading to 1.3.6 from 1.3.2.

Adimincp still shows 1.3.2 and I had to manually add the navbar links (main tab showed but blank navbar).

[SimonB]

Is this mod, like DownloadsII, hamstrung by the php limit? Or is there a way to FTP uploads bigger then the limit, and import them?

[iask]

Database error in vBulletin 4.2.0:

Invalid SQL:

INSERT INTO dbtech_downloads_categories (catname, catdesc, extgroupids, permissions)
VALUES (
'Video',
'',
'2',
'a:3:{s:4:\"view\";a:1:{i:0;i:6;}s:8:\"download\"; a:1:{i:0;i:6;}s:6:\"upload\";a:1:{i:0;i:6;}}',
);

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 7
Error Number : 1064
Request Date : Monday, July 30th 2012 @ 10:19:59 AM
Error Date : Monday, July 30th 2012 @ 10:19:59 AM
Script : http://www.xxxxxxxxxxx/admincp/vbdow...step=4&mod=dl2
Referrer : http://www.xxxxxxxxxxx/admincp/vbdow...step=3&mod=dl2
IP Address : 78.23.32.76
Username : Free
Classname : vB_Database
MySQL Version : 5.1.63-log

[DragonByte Tech]

Originally Posted by andyv72

Hi Dylan

Have it Deinstall and reinstall ..same Problem.

Here is version 1.3.6 in admincp i see version 1.3.5

Originally Posted by bzcomputers

Seeing similar issue upgrading to 1.3.6 from 1.3.2.

Adimincp still shows 1.3.2 and I had to manually add the navbar links (main tab showed but blank navbar).

Sorry, I'll try and get this worked out. bzcomputers, are you on 4.2?

Dylan

[DragonByte Tech]

Originally Posted by SimonB

Is this mod, like DownloadsII, hamstrung by the php limit? Or is there a way to FTP uploads bigger then the limit, and import them?

It doesn't have ftp uploads yet so yes, it is restricted by the php limit. Next version I plan on adding a local importer.

Dylan

[DragonByte Tech]

Originally Posted by iask

Database error in vBulletin 4.2.0:

Invalid SQL:

INSERT INTO dbtech_downloads_categories (catname, catdesc, extgroupids, permissions)
VALUES (
'Video',
'',
'2',
'a:3:{s:4:\"view\";a:1:{i:0;i:6;}s:8:\"download\"; a:1:{i:0;i:6;}s:6:\"upload\";a:1:{i:0;i:6;}}',
 

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 7
Error Number : 1064
Request Date : Monday, July 30th 2012 @ 10:19:59 AM
Error Date : Monday, July 30th 2012 @ 10:19:59 AM
Script : http://www.xxxxxxxxxxx/admincp/vbdow...step=4&mod=dl2
Referrer : http://www.xxxxxxxxxxx/admincp/vbdow...step=3&mod=dl2
IP Address : 78.23.32.76
Username : Free
Classname : vB_Database
MySQL Version : 5.1.63-log

Sorry about that. If you open dbtech/downloads/core/class_import.php
On line 165 you'll see

PHP Code:

'" . $this->registry->db->escape_string($default_ugs) . "', 


replace it with

PHP Code:

'" . $this->registry->db->escape_string($default_ugs) . "' 


Dylan