vBDownload Area 1.1

vBDownload Area v1.1

1.2 Bug Finders Wanted. PM ME!

Features:

• Restrict Downloading to XX user groups.
• Add/Edit/Delete Categorys.
• Upload/Edit/Delete Files.
• Post/Delete Comments.
• Stats.
• Screen Shot.
• Upload To DB, Folder or Link to file.

A little info:
Categorys & Files can have description.
Will show how many files in the category.
Will Show how many comments & downloads the file has.
File Screen Shots.

Planned for 1.2:

• Restrict Usergroups to Categorys.
• *MAYBE* File Rating.
• User Uploads.
• Moderate User Uploads.
• *MAYBE* Custom Fields.
• If download is a link a note will be shown.
• Report Broken or Infected File.
• *20/80* Paid Downloads.
• *50/50 Chance* Move Multiple Files to diff category.
• Licence Agreement.
• Sponsor Link.
• Hide File.
• Sub Categorys
• Info: Uploader
• Info: Date Added
• Info: Last Download
• Send to friend
• BBCode Comments
• Better Templates

Is There anything else you would like to see in 1.2 ?


1.2 Status:

• User Uploads 0%
• Moderate User Uploads 0%
• Restrict Usergroups to Categorys 0%
• File Licence Agreement 100%
• Sponsor link 100%
• Hide File 100%
• If download is a link a note will be shown 100%
• Report Broken or Infected File 0%
• Sub Categorys 100%
• Info: Uploader 100%
• Info: Date Added 100%
• Info: Last Download 100%
• Send to friend 100%
• *Not till 1.3 maybe* BBCode Comments 0% < If you can get the stupid vB wysiwyg working then help! this thing is making me want to smash my pc!
• Better Templates 100%

Dont get your hopes up on 1.2 anymore, Go thank BrentWilson for that.

NOTE: If you have 1.0 installed you will need to: Delete the dl_x tables and the "candl" colum in "usergroups"

Delete 'candl' query:

ALTER TABLE `usergroup` DROP `candl`

[StevenIsProek]

cant wait for 1.2. I need those sub catergories badly

[Getox]

Originally Posted by StevenIsProek

cant wait for 1.2. I need those sub catergories badly

Well thats the next thing ill do on the TODO list, Just for you.

[MrD]

Hi,
is it possible, that the Area read out directorys?
I mean, i will upload files with any extension (rar,zip,pdf) via ftp to a directory (name of category/Subcategory) and the script shows the files.

Sorry for my bad english

I think, thats save Time by uploading an Editing files/Descriptions.

[winlya]

much support ^_^.
This is great hack.Waiting 1.2,1.3 and more ^_^
Thanks for support man.

[Getox]

Originally Posted by MrD

Hi,
is it possible, that the Area read out directorys?
I mean, i will upload files with any extension (rar,zip,pdf) via ftp to a directory (name of category/Subcategory) and the script shows the files.

Sorry for my bad english

I think, thats save Time by uploading an Editing files/Descriptions.

I could try that for 1.3.
@winlya: No problem

[MrD]

Hi,
fine, i wait for 1.3

But, if you would like tester, i help you

[Kent100]

Database error in vBulletin 3.0.6:

Invalid SQL: DELETE FROM template WHERE title like LCASE('downloads_%')
mysql error: Table 'usr_webxxx_x.template' doesn't exist

mysql error number: 1146

:disappointed: :disappointed:

[Getox]

Originally Posted by Kent100

:disappointed: :disappointed:

In the installer look for that query "DELETE FROM template" and remove it and try that again.

If it dont work ill post a diff installer.

[Ron1n]

PHP Code:

    while ($file = $DB_site->fetch_array($files))
    {
    $countcomments = $DB_site->query("SELECT * FROM " . TABLE_PREFIX . "dl_coms WHERE fileid='" . addslashes($file[id]) . "'");
    $comments = mysql_num_rows($countcomments);
        eval('$filebits .= "' . fetch_template('downloads_filebit') . '";');
    } 


If you have 25 files in a category you will run 50+ queries on this page... this will eat up a TON of cpu.

If you cache download_filebit you can knock out 25 queries, but they arent the important ones. (Note: im not 100% sure that it doesnt cache the template after fetching it once, but I had this problem with a hack I made last year)

The query to select the comments per file will take a long time unless you create an index by the file's id, and even then it will be very poor performance.

You have a lot of performance issues. If you want, I can help you. My download mod has virtually no performance issues except on upload/edit/delete (which occures infrequently that it is not a factor). It actually runs fewer queries than the average vB forum page. My msn it ronin at elitecoders dot org.

[BamaStangGuy]

He didn't copy your hack

Get over yourself