Download Based On Database

First of all, this is my first hack in php. Please go easy on me

Second, I don't know how to categorize this hack. If this doesn't belong here please move it. Thanks

I have searched thru the v3 for a hack that enable me to let my member download multimedia files without success.

I end up with my own hack.

Here are the desciptions

Multimedia files information such as ilenames, extension, url, etc. are stored in database.

Each file is assigned a unique id

They are output to a link like
http://www.mysite.com/forum/atmmdown...songnumber=xxx

Each time member - who are allow to download files- click on the linked

The request is sent to the included file.

Once the authorization is authenticated. The requested file will then be downloaded

I have tested this one on my own board with IIS6 and win2003

Thanks

[moley]

will install later sounds great i've wanted this hack for a while i was just using a protect folder for download up until now thanks a lot.

[manguish]

Does this : https://vborg.vbsupport.ru/showthread.php?t=60403 not do the same job?

[Floris]

Originally Posted by stitch

First of all, this is my first hack in php. Please go easy on me

Second, I don't know how to categorize this hack. If this doesn't belong here please move it. Thanks

I have searched thru the v3 for a hack that enable me to let my member download multimedia files without success.

I end up with my own hack.

Here are the desciptions

Multimedia files information such as ilenames, extension, url, etc. are stored in database.

Each file is assigned a unique id

They are output to a link like
http://www.mysite.com/forum/atmmdown...songnumber=xxx

Each time member - who are allow to download files- click on the linked

The request is sent to the included file.

Once the authorization is authenticated. The requested file will then be downloaded

I have tested this one on my own board with IIS6 and win2003

Thanks

I totally do not understand what this does?

Allow users to download files? (> attachments?)

[Johnny]

i dont understand this either :/

[Moya]

Uhm Basically, my board has entertainment section that has music shared by my members. Everytime they upload a new song, the new song information is stored on the database.

Then other member can listen to the song and download if they want. Here is the screenshot of a song in playing mode and has download enable to member

[Moya]

Originally Posted by manguish

Does this : https://vborg.vbsupport.ru/showthread.php?t=60403 not do the same job?

I don't know what it does. I didn't use that on my board

[Erwin]

Storing files in the database is generally not a good idea because:
1. It adds load to the database server.
2. It makes for large database tables.

[AnhTuanCool]

Originally Posted by Erwin

Storing files in the database is generally not a good idea because:
1. It adds load to the database server.
2. It makes for large database tables.

No files to store in the database, take a look at his code, but I still don't get it though.

[Erwin]

Originally Posted by AnhTuanCOol

No files to store in the database, take a look at his code, but I still don't get it though.

You're right. I misread his post - it's only the file info stored, not the file.

[Moya]

Okie

Each time a multimedia file like wma, mp3, wmv is uploaded by my users (via a separate upload interface), the song information like titles, file name (file name + extension), file type, are insert as new record into a table like songtable. After this file is uploaded into a designated directory, then the upload interface executes the next code sequence to create streaming type files like wmx, wax, m3u based on the uploaded files, and write this new file to another directory. Lastly the upload interface will update the table with the real location of the uploaded file along with the location of the streaming files

When my board member want to listen to a particular song, my music script will verify that if this member is authorize to listen, and allowed to download the song. If this member is alowed to download the song, the download link will be displayed

Once this member decides to download the song, he/she just clicks on the link. The download script will look into database for the filename of the requested song id. Once it locates the song, the script will read the file and output thru this member computer.

[AnhTuanCool]

Could you release that file upload interface too, cause this file(the one that you posted) is just for clients side, admins have nothing to do with it, and you could think about a whole music managerment system I suggest

[Moya]

..and oy yeah please execuse my spaghetty coding

[moley]

and we upload the file to? while making a template with that info in it?

EDIT

the template code goes into the newthread template but it make it rather large and confussing looking. Is there anyway I can have it so this hack has its on page. I'll try and make a page for it using vBA CMPS

EDIT AGAIN

Ok got it working fine on cmps since its basically just copying the template from above but can you share the code that you use to display results as right now its just uploading with no choice to listen

[Moya]

Originally Posted by moley

and we upload the file to? while making a template with that info in it?

EDIT

the template code goes into the newthread template but it make it rather large and confussing looking. Is there anyway I can have it so this hack has its on page. I'll try and make a page for it using vBA CMPS

EDIT AGAIN

Ok got it working fine on cmps since its basically just copying the template from above but can you share the code that you use to display results as right now its just uploading with no choice to listen

I am still working on that system. I am not sure I will have it released.