Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

The Database Forum


You are currently viewing our The Database Forum as a guest. Please register to participate.
Login



Reply
A query about running a database for digital downloads
Old 08-21-2006, 12:22 PM A query about running a database for digital downloads
Novice Talker

Posts: 11
Trades: 0
I'm not sure if this is the correct part of the forum to post on so feel free to move this if need be.. Onto the question..

My partner and I recently set up a portofilio website for our artwork and digital 3Dcontent. We want to set up a store so visitors to site can purchase or 3D digital content for use in their software. Upon completion of the purchase they will be directed to a page which will give them a download link so that they may download the item they have just purchased. I know that we could already use an established commerce system like OSCommerce etc for this.. but we want to do it so that you do not need to register an account but just rather browse the products and purchase without having to set up an account.

Now we have noticed some pitfalls in this system that, the page with the download link in could be passed on to other people who inturn could download the product without actually purchasing it, and the link to the file will be visible inside the source of the page. So we were thinking, would be possible to have the downloadable content in a database, and have the download link for the product call it from the database using say some form of php script similar to that which loads images into pages calling them from a database and inturn start the download without the actual direct for the file being visible... rather it being called via php which should actually call the file without displaying the exact url..

I know there are draw backs to this as it would still allow for the passing of the link to others unless there was some sort of system like a session time out added to the link, but I think that would still require some form of logging in procedure right?

I hope that made sense anyway, this is all very new to me...

What option do you think would be best .. Use an exsiting commerce system or create our own database?
LillianaS is offline
Reply With Quote
View Public Profile
 
 
Register now for full access!
Old 08-26-2006, 11:18 AM Re: A query about running a database for digital downloads
Junior Talker

Posts: 2
Trades: 0
From what you are describing, it seems like your requirements are pretty straightforward. I would suggest taking advantage of an open source/free package for this project. For a download manager, you can use one of the following:

FMDeluxe - The Official #1 File Management System!
Download Sentinel++
main | FD Script site

For your e-commerce end, you can try:

Associate-O-Matic :: Build a custom Amazon.com Associate Store with 1000's of items in minutes
VirtueMart: Your free e-commerce solution. - Welcome...

There are many more options out there. Check hotscripts.com if you haven't already. Good luck!
skyace888 is offline
Reply With Quote
View Public Profile
 
Old 09-06-2006, 12:00 PM Re: A query about running a database for digital downloads
Skilled Talker

Posts: 90
Location: Savannah, GA
Trades: 0
If you really want to do it yourself I would suggest this...
  • Place all your "download after purchase" content into a secured folder (no one from the web can download the contents)
  • Then prior to the purchase tag the customer with a session ID
  • pass that session ID along to the merchant payment
  • Inside your database you'll have a list of items that session ID is good for
  • when the merchant bank says that the purchase is good you generate some links
  • each link will be to a file like download.php?prod=101&sessionID=1234
  • the download.php file will double check with the database that that session ID is good for that product
  • when everything checks out the download.php file sends the proper header and amends the image.jpg file to it
  • because the download.php file is not redirecting the user to the image but rather amending the file there won't be any difficulty in pulling the file from the secured directory
  • I would however recommend that the users have a login because they may not be able to download the file successfully the first time

but like skyace888 & you said, their are open source packages that will do this for you.

enjoy the challenge
-Mike
__________________
-Mike
-
Please login or register to view this content. Registration is FREE
mgarde is offline
Reply With Quote
View Public Profile Visit mgarde's homepage!
 
Old 09-06-2006, 06:57 PM Re: A query about running a database for digital downloads
Extreme Talker

Posts: 246
Trades: 3
And if you're worried about people passing the links along to others, you can add a date field to the table, something like "LinkExpireDateTime". When the user clicks on the link, before allowing download, the script could compare the system date to the "LinkExpireDateTime" value, and if the system date is earlier than the "LinkExpireDateTime", then you can allow the download. Otherwise, display a message that says the link is expired.
CouponGuy is offline
Reply With Quote
View Public Profile
 
Reply     « Reply to A query about running a database for digital downloads
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.76763 seconds with 12 queries