My Downloads v1.2 - A Download Manager for VBulletin

Well well.. have I been busy in such a short time.. hehehe.. I listened and i changed... here's a newer version, more integrated it is..

What does this script do ?

This script indexes your download directory of your website and put this information
into records on your database. Now you can track who is downloading your files and you get
information how popular each file is.

version 1.2
- Use of templates in vbulletin
- The download database is integrated into the forumdatabase
- Use of vbulletin stylesheets
- Auto index of subdirectories ( 1 layer ) into download-categories.
- Auto clean up of log database when file is removed from the database
(The Cleanup button has been removed)
- IP address logging added
- Gifs are made transparent
- Non admin auto update option
- Some other small tunes...

version 1.1
not released

version 1.0
Features:
- Auto index of the download directory
- Easy add descriptions to files
- Easy database cleanup of deleted files
- Restrict the usergroups who may download
- Tracking of downloads.
- Display download history of a file by admin group.
- Database cleanup by admingroup

Nice to know:
- Easy to install for not-dummies
- Its just one php script

The package:
- download.php - this is the actual script ( you can rename this )
- mydownloads.sql - database strucure
- mydownloads.template.txt - Vbulletin template
- ./gifs/ - gifs
- install.txt - this file

[Onkel_Tom]

For those people who wants to have formated filesizes:

find:

// Check if the file is OFFLINE
if ($runrootonce){
   if (file_exists($dir . $filename)) {
   $filesize= (filesize($dir . $filename));
   }
   else{
   $filesize='OFFLINE';
   $offline=true;
   }
 }
 else{
   if (file_exists($dir . $catname . '/' . $filename)) {
   $filesize= (filesize($dir . $catname . '/' . $filename));
   }
   else{
   $filesize='OFFLINE';
   $offline=true;

and replace it with:

// Check if the file is OFFLINE
if ($runrootonce){
   if (file_exists($dir . $filename)) {
   $filesiz= (filesize($dir . $filename));
   	if ($filesiz < 1024) {
   			$filesize= $filesiz.' b';
   		}
   elseif ($filesiz < 1048576) {
   		$filesize= vb_number_format($filesiz / 1024 ,0).' kb';
    }
   elseif ($filesiz > 1048576) {
   		$filesize= vb_number_format($filesiz / 1048576 ,2).' mb';
		 }
   }
   else{
   $filesize='OFFLINE';
   $offline=true;
   }
 }
 else{
   if (file_exists($dir . $catname . '/' . $filename)) {
   $filesiz= (filesize($dir . $catname . '/' . $filename));
   if ($filesiz < 1024) {
   			$filesize= $filesiz.' b';
   		}
   elseif ($filesiz < 1048576) {
   		$filesize= vb_number_format($filesiz / 1024 ,0).' kb';
    }
   elseif ($filesiz > 1048576) {
   		$filesize= vb_number_format($filesiz / 1048576 ,2).' mb';
   		}
   }
   else{
   $filesize='OFFLINE';
   $offline=true;

It's only quick and dirty but it works

[Onkel_Tom]

Okay, some more bugfixes:

In Template mydownloads find at the end:

$footer

add after:

</body> 
</html>

Find in file download.php:

eval('$dlnavbar = "' . fetch_template('navbar') . '";');

add before:

$navbits = array(); 
$navbits[$parent] = 'Downloads'; 

$navbits = construct_navbits($navbits);

But my "exploded" tablesize is not gone
horizontal size is toooo long for my display..
I will look for that tomorrow

[ipas2]

It looks a version 1.3 is needed Uncle Tom, I will look at your fixes soon.
I have to familliar myself more with those templates I guess.

I found a bug myself. In the template replace the phrase $error to $errormsg
This are messages when a non-logged-in user tries to download a file.

Grtz,
Ipas

[Onkel_Tom]

I get the following db error on the screen while downloading a file from downloads root directory. But the download will happen ! It's only an error on the screen.

Warning: mysql_result(): Unable to jump to row 0 on MySQL result index 18 in /download.php on line 80

I changes line 80 to the original line of your version ipas2
I think this happen because there is no catid entry for the root download dir in the database...

[ipas2]

You're right. Will be fixed in 1.3
For now:
Replace line 80,81,82

PHP Code:

   $cat="SELECT * FROM mydl_category WHERE catid=$dlcat";
   $catresult=mysql_query($cat);  
   $dldir=mysql_result($catresult,0,"directory"); 


To:

PHP Code:

   if ($dlcat!=0){
   $cat="SELECT * FROM mydl_category WHERE catid=$dlcat";
   $catresult=mysql_query($cat);  
   $dldir=mysql_result($catresult,0,"directory");
   } 


Grtz
Ipas

[ipas2]

[QUOTE=Onkel_Tom]For those people who wants to have formated filesizes:

Thnx Oncle_Tom.. added !

[yoyoyoyo]

excellent hack, but how about adding the ability to count the downloads and display the top 5, 10, 20 (or however many the admin wants) most popular downloads?

[ipas2]

Originally Posted by yoyoyoyo

excellent hack, but how about adding the ability to count the downloads and display the top 5, 10, 20 (or however many the admin wants) most popular downloads?

That should not be a problem. I thought about this myself. Version 1.3 I guess

[yoyoyoyo]

Originally Posted by ipas2

That should not be a problem. I thought about this myself. Version 1.3 I guess

cool. Would a password protected download be a problem? maybe each file could have a password that the admin specifies in the control panel? or only certain user ID #s are allowed to d/l certain files?

[gigaenvy]

Originally Posted by Onkel_Tom

Hi all,
I installed this hack on my testboard. Great Idea !
But there are so many wishes for the new release:

• include in vB database and get the dbname etc. from includes/config.php
• vB Style
• transparent background in images
• phrasen version to translate in other languages
• installation script for phrases from a .xml file
• vbformating for date, filesize etc.
• last download also add the date
• if somebody uses a link like "http://www.yourdomain.tld/forums/download.php?download=18" don't show the content of the download page

I'm waiting for the next release
thanks in advance

along with anti-leeching support such as specifying 1 download for each ip address.