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

[jamesk]

Before I try this out, can you index files from another server. Say if you have a media host.. Could you link the links off of that..?

I'm curious of this too. Any way that a specified Usergroup Can Upload to the interface as well?

[cinq]

I don't think there is any upload feature.
It merely scans the files in the specified dir.

[alkatraz]

The script does exactly what ipas2's says it does and does a great job at it. Unfortunately it requires so much custimization that it's a huge pain the butt to install. Not only do you have to edit the css inside the document, they aren't titled acurately. "zx, result, chill, updated" ?? What kind of naming system is that. The gifs don't have transparent backgrounds so even if you take the time to customize the css, you still have to create your own icons.

Anyways, thx for releasing this hack and it has a lot of potential but should really be released as a beta until these basic things are taken care of.

[Skyline_GT]

do you have a live demo?

[WPH|EmaX]

I will have one soon on my site.
i like it.
i'll post link wen i get it all installed.

[ipas2]

Indeed..I'm busy with a more updated version. This one scans also one subdirectory layer in the download directory and put this into categories. Have a version online on my website http://www.groningen.it -> Downloadbutton

The css is indeed a bit complex because I copy/pasted it from another script of mine. In this version it's more clear.
I will also try to fix it in templates but due to lack of time I doubt this will succeed.

I thought about the upload feature, but in this case what good is a autoindex feature. !?

Then again.. I'm openminded about sugestions..

Grtz
Ipas

[cinq]

Originally Posted by ipas2

Indeed..I'm busy with a more updated version. This one scans also one subdirectory layer in the download directory and put this into categories.

That would be a nice addition ( i see it is already working nicely on your site )

Originally Posted by ipas2

The css is indeed a bit complex because I copy/pasted it from another script of mine. In this version it's more clear.
I will also try to fix it in templates but due to lack of time I doubt this will succeed.

Why not just use vb css/templates ?

Originally Posted by ipas2

I thought about the upload feature, but in this case what good is a autoindex feature. !?

Perhaps a means to upload files ( even past the 2mb barrier for most php.ini ) to the download directory ( or subfolders in download directory ) for your script to index them later.

Also, an installer would be good.

Keep up the nice work Ipas

[bkbelew]

I had some problems executing the mydownloads.sql script in plesk. Probably because our database versions differ? It was throwing up syntax errors. So I edited the script to get rid of all the dumps, and what not.. it worked.. if anyone else is having this problem.. here you go:

CREATE TABLE files (
  fileid int(11) NOT NULL auto_increment,
  filename varchar(255) NOT NULL default '',
  info longtext NOT NULL,
  PRIMARY KEY  (fileid,fileid)
) TYPE=MyISAM;
CREATE TABLE log (
  logid int(6) unsigned NOT NULL auto_increment,
  filename varchar(255) default NULL,
  dldate date default NULL,
  dltime time default NULL,
  dluser varchar(255) default NULL,
  dlipaddr varchar(15) NOT NULL default '',
  PRIMARY KEY  (logid)
) TYPE=MyISAM;

[bkbelew]

Btw, is there any way to make it auto update, so my members dont have to click update before they can see the downloads?

[ipas2]

I'm busy with a newer version. I will add this option so files will autoindex if selected.