Download Based On Database

[Moya]

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/atmmdownload.php?do=getsong&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 :p thanks a lot.

[manguish]

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

[Floris]

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/atmmdownload.php?do=getsong&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]

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]

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]

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 :p

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]

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 :p

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.

[Blam Forumz]

<a href="http://www.blaminator.co.uk/forum/atmdownloadforvb.php" target="_blank">www.blaminator.co.uk/forum/atmdownloadforvb.php</a>

help

[Moya]

I would love to take a look for you, but where did you put your link.

Download script require id from database?

I have the link example in the script and the first post. It should be something like this

../atmmdownload.php?do=getsong&songnumber=xxx

[lanc3lot]

Can someone please make it as a sound managment hack?

It could be a hell of idea, to have something like that...and so ppl just install the hack and have "mp3 uploads" + listening in the forum!!!

[MindTrix]

Could we have the querys needed for this to work?? Seems like its something everyone wants, but no proper instructions so just have to stumble the way through :)

[Viks]

GREAT hack!!
will install it once i get some time.

[miz]

ok few things

<form method="post" action="$_SERVER[PHP_SELF]?do=upload" enctype="multipart/form-data">
i think you might want to replace it to :

<form method="post" action="$_SERVER[PHP_SELF]" enctype="multipart/form-data">
<input type="hidden" name="do" value="upload">


about the hack itself, i really liked the idea and i think its can be a great addon
to music sites and things like that, you might consider to make a fully hack with upload and other things.

yours MiZ.

[ericgtr]

ok few things

<form method="post" action="$_SERVER[PHP_SELF]?do=upload" enctype="multipart/form-data">
i think you might want to replace it to :

<form method="post" action="$_SERVER[PHP_SELF]" enctype="multipart/form-data">
<input type="hidden" name="do" value="upload">


about the hack itself, i really liked the idea and i think its can be a great addon
to music sites and things like that, you might consider to make a fully hack with upload and other things.

yours MiZ.
I am currently working with him, this could work into a great little system. The way it's been explained to me so far is that after you upload you are then presented with a URL that can be pasted (copied) into the post. What I have done is created a custom BB code that will embed the media player into the post, so once the file is uploaded it can be encased with the new BB code and then posted into the body of the post. Upon hitting submit this will present the uploaded song in the media player at a stopped position.

[Moya]

Hello All,

If you still need the upload script, please come here and get the simpler version

https://vborg.vbsupport.ru/showthread.php?p=574926&posted=1#post574926

[tnguy3n]

As I acknowledge, this is coded based on database + local link download, but the copyright is as
// ************************************************** *************************
// File Copyright ?2004 of Stitch . (http://www.aotrangmongmo.com)
// ************************************************** *************************
Ain't it violating copyright of original author (under GNU GPL) as to alter & releasing the hack without the author's permission?

[Moya]

As I acknowledge, this is coded based on database + local link download, but the copyright is as

Ain't it violating copyright of original author (under GNU GPL) as to alter & releasing the hack without the author's permission?


Uhmm what do you mean?

[Viks]

I would like to instal this hack as well as the this one "multimedia upload"
(coz both work together), Im wondering if anyone here has successfully installed this hack.

is there a demo site to see this thing in action?