[contribution] Super Download Store

[AlexStudio]

#1060 - Duplicate column name 'products_attributes_filegroup_id'

That means you already have that column added. Please check your database and see if the new tables are there.

[liz217]

thank you for such a fast reply.

 

I think something isn't right in my database though.

 

My old one has these tables.

 

address_book

address_format

banners

banners_history

categories

categories_description

configuration

configuration_group

counter

counter_history

countries

currencies

customers

customers_basket

customers_basket_attributes

customers_info

geo_zones

languages

manufacturers

manufacturers_info

newsletters

orders

orders_products

orders_products_attributes

orders_products_download

orders_status

orders_status_history

orders_total

products

products_attributes

products_attributes_download

products_attributes_download_groups

products_attributes_download_groups_files

products_attributes_download_groups_to_files

products_description

products_notifications

products_options

products_options_values

products_options_values_to_products_options

products_to_categories

reviews

reviews_description

sessions

specials

tax_class

tax_rates

whos_online

zones

zones_to_geo_zones

 

My new one has these

 

address_book

address_format

banners

banners_history

categories

categories_description

configuration

configuration_group

counter

counter_history

countries

currencies

customers

customers_basket

customers_basket_attributes

customers_info

geo_zones

languages

manufacturers

manufacturers_info

newsletters

orders

orders_products

orders_products_attributes

orders_products_download

orders_status

orders_status_history

orders_total

products

products_attributes

products_attributes_download

products_description

products_notifications

products_options

products_options_values

products_options_values_to_products_options

products_to_categories

reviews

reviews_description

sessions

specials

tax_class

tax_rates

whos_online

zones

zones_to_geo_zones

 

 

for some reason I'm missing these from the new one

 

products_attributes_download_groups

products_attributes_download_groups_files

products_attributes_download_groups_to_files

[AlexStudio]

run the rest part of the modified group_file_for_download.sql:

CREATE TABLE `products_attributes_download_groups` (
`download_group_id` INT( 11 ) NOT NULL ,
`download_group_name` VARCHAR( 255 ) NULL ,
`language_id` INT( 11 ) NOT NULL ,
PRIMARY KEY ( `download_group_id` , `language_id` )
);

CREATE TABLE `products_attributes_download_groups_files` (
`download_groups_file_id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`download_group_id` INT( 11 ) NOT NULL ,
`download_group_filename` VARCHAR( 255 ) NOT NULL
);

ALTER TABLE `products_attributes_download_groups_files` DROP PRIMARY KEY ,
ADD PRIMARY KEY ( `download_groups_file_id` , `download_group_id` );

CREATE TABLE `products_attributes_download_groups_to_files` (
`download_groups_file_id` INT( 11 ) NOT NULL ,
`language_id` INT( 11 ) NOT NULL ,
`download_group_file_description` VARCHAR( 255 ) NULL ,
PRIMARY KEY ( `download_groups_file_id` , `language_id` )
);

[liz217]

Thank you, thank you, thank you!

 

I think everything is ok now. I'm going to cook dinner and I'll get started on the rest of the install when I'm done. I'm sure I've already said this, but you are my hero. Hopefully I won't have to bother you again. :thumbsup:

 

Thanks so much!

 

Liz :D

[Guest]

I have some questions regaridng the download program:

 

- Who to you create a file to download??? (is it possible to make the files avalibel, like easypopulate?)

- Is it a good contributions to manget about 80000 MP3 files

 

Hope somebody can explain more about the product.

[c_engine]

Hi Guys

 

I want to be able to let my clients download free musics on my site. Is there a way to do it. i tried free payment modules but it dont work. is there anyway to use paypal ipn process to let users download music if total is 0. or make a if statement on paypal module if the total is 0 skip the payment and change the order status to 11 Download Available.

 

Or other recommendations will be appritiated.

 

Many Many Thanks in Advanced

[cooch]

I have a cart using an older version of PayPal IPN (v 1.1 2005/04/28 05:46:55 srashinkar), and it uses checkout_process.inc.php, not paypal_ipn.php .

Before I attempt to remove it and replace it with a newer version, is there a way to modify it to handle the mods that now go in paypal_ipn.php?

 

I think the lines in question are:

 

if (DOWNLOAD_ENABLED == 'true') {

$attributes_query = "select popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.price_prefix, pad.products_attributes_maxdays, pad.products_attributes_maxcount , pad.products_attributes_filename

from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_OPTIONS_VALUES . " poval, " . TABLE_PRODUCTS_ATTRIBUTES . " pa

left join " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " pad

on pa.products_attributes_id=pad.products_attributes_id

where pa.products_id = '" . $order->products[$i]['id'] . "'

and pa.options_id = '" . $order->products[$i]['attributes'][$j]['option_id'] . "'

and pa.options_id = popt.products_options_id

and pa.options_values_id = '" . $order->products[$i]['attributes'][$j]['value_id'] . "'

and pa.options_values_id = poval.products_options_values_id

and popt.language_id = '" . $languages_id . "'

and poval.language_id = '" . $languages_id . "'";

$attributes = tep_db_query($attributes_query);

} else {

$attributes = tep_db_query("select popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_OPTIONS_VALUES . " poval, " . TABLE_PRODUCTS_ATTRIBUTES . " pa where pa.products_id = '" . $order->products[$i]['id'] . "' and pa.options_id = '" . $order->products[$i]['attributes'][$j]['option_id'] . "' and pa.options_id = popt.products_options_id and pa.options_values_id = '" . $order->products[$i]['attributes'][$j]['value_id'] . "' and pa.options_values_id = poval.products_options_values_id and popt.language_id = '" . $languages_id . "' and poval.language_id = '" . $languages_id . "'");

}

$attributes_values = tep_db_fetch_array($attributes);

 

$sql_data_array = array('orders_id' => (int)$this->orders_id,

'orders_products_id' => $order_products_id,

'products_options_id' => $order->products[$i]['attributes'][$j]['option_id'],

'products_options' => $attributes_values['products_options_name'],

'products_options_values_id' => $order->products[$i]['attributes'][$j]['value_id'],

'products_options_values' => $attributes_values['products_options_values_name'],

'options_values_price' => $attributes_values['options_values_price'],

'price_prefix' => $attributes_values['price_prefix']);

 

tep_db_perform(TABLE_ORDERS_PRODUCTS_ATTRIBUTES, $sql_data_array);

}

}

}

 

Thanks for a great contribution!

 

cooch

[karinha]

Hallo!

 

I am really extermely happy with this contribution and in general everything works just fine. The person for whom I do the webshop wants to be able to put zip files around 140 MB - a whole CD with 12 titles to download. It works fine with the group downloads, but my client doesn't want his clients to be needing to download 12 little files, so I tried to put up the big zip- of 140MB.

I can put them on the server without any problems, but after buying them and downloading them i can't unzip them. I get an error message saying, that the file is invalid. My client tried to zip files, upload them and buy them and it is working on his computer (Mac : I am working on a PC; is there a difference between the zip formats between Mac and PC?). When I try to buy the same zips I get the same error message like above. I don't understand where the problem is... does anyone have an idea what I could do wrong? What I could fix? My gzip compression is enabled and set on 5 (to be honest I don't really know what it is about, but I guess it has to be enabled for using zip files?).

 

I have also tried to upload and buy little zip files, but I can't even download a 12 MB zip file. HELP!!!! How can I fix this problem?

 

Thank in advance,

Karin

 

PS: Sorry that question also ende up on the general contribution support... :blush:

[AlexStudio]

The GZip compression setting has nothing to do with download files. Since you have GZip compression turned on, you need to apply the fix in the 'Known Issues' section of the installation guide.

 

Also make sure you can unzip the packed files in your local PC before uploading them. It could be your PC or the software you're using which caused the problem.

 

This contribution has been tested downloading up to 330Mb file in both PC and MAC, IE6/7, FireFox 2 and Safari.

[karinha]

Thank you for this fast reply! Real dummy question... :blush: what is this gzip compression for then? Can I turn it off and the problem might be solved??? I'll try your fix on your known issues section, too, but I don't know that I need that gzip compression anyways???

[AlexStudio]

Turn it off if you don't need it. The GZip compression setting is to compress your webpages before sending out the dynamic HTML codes, generated by the php files, to visitors' internet browsers.

[karinha]

I just realized that I do have this code added in my application_top.php already. And no usually I don't have any problems downloading and unziping files...that's also why I realy don't understand what is the problem. I even already tried what was suggested in this post: http://www.oscommerce.com/forums/index.php?showtopic=126146. Still doesn't work. My computer is on Windows Vista, also treid it on my Windows XP one...

 

Thanks for helping!!!

 

Karin

[karinha]

We must have replied at the same moment... I'll give it another try with gzip turned off...

[karinha]

:'( Buhu its still not working! Any more suggestions? The files are ok, eveytime I download them directly through the ftp I can unzip them without any problem, but when downloading it from the shop I can't unzip them.

[AlexStudio]

Can you try it on other PC+Vista and see if it happens?

[karinha]

It is not working on the XP nor on the Vista. I tried it on both...

[AlexStudio]

Try firefox and see if it only happens with IE.

[karinha]

I am already working on Firefox. It looks like it's downloading ok...Once on my desktop, when i click on properties, it also gives me the right filesize, but when I want to extract the files I always get the message that the zip file is invalid. ???

Edited August 1, 2007 by karinha

[karinha]

Thank you very much Alex for your effort so far, but do have any more ideas what could be the problem? Anybody else out there? I should really fix that problem in the next days...and I have no idea what else I could do...It might be a little stupid something...

 

Many many thanks in advance!

 

Karin

[AlexStudio]

I'd like to try it myself. Please PM me with access of one user account, and a download link for me to see how it happens.

[debriscreator]

:-"

Super Download Shop v1.0

for osCommerce 2.2 MS2 Update 060817 or later

 

Super Download Shop contribution is an enhancement of the osCommerce download module and download file management, including following features:

• Secure download for pending orders based on DownLoads Controller v5.3 by Linda McGrath which was the best solution to secure downloads. Without similar control, customers could get their downloads before they actually pay.
  
• Group files download per product which enable download shops to offer multiple files in a single product. With this ability, shop owners can:
  • Break a large download file into a group of files, to prevent problems like insufficient resource, time out errors...etc.
    
  • Bundle multiple downloads in one package to increase sells.
    

  [*]Store download files in sub folders under the download directory to improve the file management.

  [*]Built-in superior file management interface in admin panel.

 

 

Hello I have installed the contribution and everythign seems fine until i do a test purchase. As admin, I am able to put the order status to Download Now Available.. but when i go to the download links as a shopper, I get a list of links that are not clickable. Is it possible that since my files are in the download/beginner/*.* folder... that they are not set right? When i added the file names to the file group.. in the location i just added /beginner/*.* and it seemed to add just fine. Do you understand my question? Thanks - Dave

[AlexStudio]

Most likely you missed the modification in checkout_process.php where the 'last_modified' is added to the data in table orders. Edited August 5, 2007 by AlexStudio

[Valdamir]

Alex,

 

First off, thank you soooooooo much for providing this mod, it is perfect for my business needs. However, during my install, I did run into a small problem with it, and I think I found a working solution, and wanted to share it with you in case I'm not the only one with this bug. Here's the details:

 

In the code for "download.php", we have this...

// Now send the file with header() magic
 header("Expires: Mon, 26 Nov 1962 00:00:00 GMT");
 header("Last-Modified: " . gmdate("D,d M Y H:i:s") . " GMT");
 header("Cache-Control: no-cache, must-revalidate");
 header("Pragma: no-cache");
 header("Content-Type: Application/octet-stream");
// BOF Super Download Shop v1.1 mod
 header("Content-disposition: attachment; filename=\"" . $file_name . "\"");
// EOF Super Download Shop v1.1 mod

 

Unfortunately this would frequently result in bad downloads for me. For example, only 2 to 3 MB of a 10 MB PDF would arrive at download completion, which means a corrupt file of course.

 

After browsing the internet for other "header" examples, I stumbled upon this:

 

// Now send the file with header() magic
 header("Pragma: public");
 header("Expires: 0");
 header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
 header("Cache-Control: public", false);
 header("Content-Description: File Transfer");
 header("Content-Type: application/pdf");
 header("Accept-Ranges: bytes");
 header("Content-Disposition: attachment; filename=\"" . $file_name . "\";");
 header("Content-Transfer-Encoding: binary");
 header("Content-Length: " . filesize(DIR_FS_DOWNLOAD . $downloads['orders_products_filename']));

So far it's been working well, and in addition, there's actually some "total size" info now on the browser's download progress-bar. Please consider whether this code-snippet would benefit your mod, I hope it proves useful. :)

[edgy]

Hi Alex,

 

I am trying to build something for my site which I believe would make a great contribution as well. The gist is that people can enter a code they are given so they can access some downloads.

 

I am planning on using this on a site that is already using oscommerce and your super download shop. I would like to take advantage of the file groups function your contribution has.

 

I would like to make another table for the secret codes - which would be linked to your file groups. I would love to hear how you would logically organize this. If you have a second - drop me a line! Thanks.

[Lunara Solutions]

HI Alex,

 

I've been trying to install this mod on another site of mine and I'm running into the error. I can't for the life of me figure out what I've done wrong. It is probably something really simple.

 

1146 - Table 'mciola_osc1.TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD_GROUPS_FILES' doesn't exist

select padg2f.download_group_file_description from TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD_GROUPS_FILES padgf left join TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD_GROUPS_TO_FILES padg2f on padgf.download_groups_file_id = padg2f.download_groups_file_id where padgf.download_group_filename = 'maggie/Sachet.zip' and padg2f.language_id = '1'

[TEP STOP]

 

Thanks so much for your help.