Jump to content
DunWeb

[Contribution] Super Download Store for Version 2.3.x

Recommended Posts

@@GGOscar

 

How did you manage to get this to work for free products. What ever i do, my test site always shows a shipping cost and i cannot bypass that page. Products price and weight are both set to zero.


REMEMBER BACKUP, BACKUP AND BACKUP

Get the latest Responsive osCommerce CE (community edition) here

It's very easy to over complicate what are simple things in life

Share this post


Link to post
Share on other sites
@@GGOscar How did you manage to get this to work for free products. What ever i do, my test site always shows a shipping cost and i cannot bypass that page. Products price and weight are both set to zero.

 

hi @@14steve14,

Thank you every so much for the help before (and many other times through out this forum!) and sorry for a rather late and poor reply. To be honest Im very new to this and Im not sure how to answer your question in a good way. I'm using the normal "Postage and Service' module with the Free Product Checkout http://addons.oscommerce.com/info/8080 . I'm also using "Shorter Checkout for OSc 2.3X. And I've managed to get it to work with both downloads costing money and for free downloads. I hope this might help. Otherwise if you can be more specific I will try my best to answer your questions.

 

Kindest Regards

Oscar

Share this post


Link to post
Share on other sites

I've been working on and off for weeks trying to get Download and now Super Download to work. I am almost there, but hit this snag. When I go in as a customer to download, this shows on the screen. I can download the file and it seems to be working - but this looks like a mess. This code is in /includes/modules/downloads.php. I thought I followed the instructions properly, but it looks like in the code I've got a misplaced beginning or ending mark. (This code is black in my editor.) I've tried fixing it, but can't seem to get it right. I'll also include the code. Thanks!

 

Download links

Feis Mom - Download File 1

button_download.gif - 11.11Kb Link expires:

Tuesday 31 July, 2012 4 downloads remaining Feis Mom - Download File 1

button_download.gif - 11.11Kb Link expires:

Tuesday 31 July, 2012 5 downloads remaining

// BOF Super Download Store v2.3.x mod // BOF: WebMakers.com Added: Downloads Controller // If there is a download in the order and they cannot get it, tell customer about download rules $downloads_check_query = tep_db_query("select o.orders_id, opd.orders_products_download_id from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " opd where o.orders_id = opd.orders_id and o.orders_id = '" . (int)$last_order . "' and opd.orders_products_filename != ''"); if (tep_db_num_rows($downloads_check_query) > 0 && tep_db_num_rows($downloads_query) < 1) { ?>

NOTE: Downloads are not available until payment has been confirmed

downloads.php

Share this post


Link to post
Share on other sites

@@FeisMom

 

Change it to this:

 

<?php

// BOF Super Download Store v2.3.x mod

// BOF: WebMakers.com Added: Downloads Controller

// If there is a download in the order and they cannot get it, tell customer about download rules

$downloads_check_query = tep_db_query("select o.orders_id, opd.orders_products_download_id from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " opd where o.orders_id = opd.orders_id and o.orders_id = '" . (int)$last_order . "' and opd.orders_products_filename != ''");

 

if (tep_db_num_rows($downloads_check_query) > 0 && tep_db_num_rows($downloads_query) < 1) {

?>

 

You were missing the opening PHP tag.

 

 

 

Chris


:|: Was this post helpful ? Click the LIKE THIS button :|:

 

See my Profile to learn more about add ons, templates, support plans and custom coding (click here)

Share this post


Link to post
Share on other sites

Thank you. But when I do that, I get this:

 

Parse error: syntax error, unexpected $end in C:\xampp\htdocs\oscommerce-2.3.1\Shop\includes\modules\downloads.php on line 141

 

Line 141 is the end of the file. I'm thinking it is something to do with nested opening and closing tags, but couldn't figure it out. I'm really new to all this - old programmer, but new to this.

 

Lori

Share this post


Link to post
Share on other sites

@@FeisMom

 

 

Check your code edits in the downloads.php file to ensure you made them correctly.

 

 

 

Chris


:|: Was this post helpful ? Click the LIKE THIS button :|:

 

See my Profile to learn more about add ons, templates, support plans and custom coding (click here)

Share this post


Link to post
Share on other sites

I had Superdownload working perfectly on my localhost installation, but hit a snag when I tried to put it up on my live site. I am getting this when I try to create a new product that can be downloaded.

File Groups 1146 - Table 'scm_5dkchkjih1.TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD_GROUPS' doesn't exist

 

select download_group_id, download_group_name from TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD_GROUPS where download_group_id != 0 and language_id = 1 order by download_group_id

 

[TEP STOP]

 

I also have two values when I go into the Download configuration. I did run the filegroup db setup twice because the first time it gave an error. Is that what gave me two of each (download controller update status, etc.)?

 

I am not really familiar with using phpMyAdmin, so I suspect I did something wrong there. Any suggestions? Thanks!

Share this post


Link to post
Share on other sites

@@FeisMom

 

1146 - Table 'scm_5dkchkjih1.TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD_GROUPS' doesn't exist

 

Either the table was not created in the database, or the table is not defined in the /includes/database_tables.php file.

 

I also have two values when I go into the Download configuration. I did run the filegroup db setup twice because the first time it gave an error. Is that what gave me two of each (download controller update status, etc.)?

 

It should only have been run once, this will cause a problem.

 

 

 

Chris


:|: Was this post helpful ? Click the LIKE THIS button :|:

 

See my Profile to learn more about add ons, templates, support plans and custom coding (click here)

Share this post


Link to post
Share on other sites

You will now have to manually remove one of the duplicated items using phpmyadmin.


REMEMBER BACKUP, BACKUP AND BACKUP

Get the latest Responsive osCommerce CE (community edition) here

It's very easy to over complicate what are simple things in life

Share this post


Link to post
Share on other sites

Where is it for me to remove? Also, I noticed that the Collation for Products_attributes_Download_groups is set to latin1_swedish_ci but all the other tables are utf8_general_ci. Does that matter? (and how did that happen???)

 

And in phpmyadmin when I open the Products_attributes_Download_groups table and move my cursor over Browse it becomes a red X and won't let me. Thanks for your patience - I am reading a book on phpmyadmin, etc but I find learn more when I just jump in and try it.

Edited by FeisMom

Share this post


Link to post
Share on other sites

Read the sql file you cut and pasted twice, and it will say what new table it entered.


REMEMBER BACKUP, BACKUP AND BACKUP

Get the latest Responsive osCommerce CE (community edition) here

It's very easy to over complicate what are simple things in life

Share this post


Link to post
Share on other sites

I am installing this to my website, but can't find the file: catalog/includes/languages/english/images/buttons/button_download.gif

 

I think I have installed everything correctly and it seems to be working except there is no link for the customer to download the file. Could it be because this image file is missing?

 

Thanks again!

Lori Austin

www.FeisMomEmbroidery.com

Share this post


Link to post
Share on other sites

@@FeisMom

 

If you are missing the download link, then you have made an error installing the contribution OR you don't have the download status above 11.

 

 

 

Chris


:|: Was this post helpful ? Click the LIKE THIS button :|:

 

See my Profile to learn more about add ons, templates, support plans and custom coding (click here)

Share this post


Link to post
Share on other sites

The .gif is missing. I tried following the installation instructions, but that .gif isn't with the other button files (ic_up.gif and ic_down.gif). I just re-downloaded the contribution to see if perhaps I had accidentally deleted it, but it isn't there either. I know I did not follow the installation instructions because I can't find the file to upload. Can I get just this file somewhere?

Share this post


Link to post
Share on other sites

I thought the latest release used the 2.3.1 style css buttons.


REMEMBER BACKUP, BACKUP AND BACKUP

Get the latest Responsive osCommerce CE (community edition) here

It's very easy to over complicate what are simple things in life

Share this post


Link to post
Share on other sites

Check the code from download about timestamp fix and css buttons. Its the second one up from the bottom of the page. I have not tried the latest release, but do have the first two downloads working fine.


REMEMBER BACKUP, BACKUP AND BACKUP

Get the latest Responsive osCommerce CE (community edition) here

It's very easy to over complicate what are simple things in life

Share this post


Link to post
Share on other sites

So, there is an "official" support forum for SuperDownloadStore!

 

After struggling with product_attributes.php a bit, my SuperDownloadStore appears to be working. However, after placing an order for it, when PayPal returns, I got the following message on the screen:

 

// BOF Super Download Store v2.3.x mod // BOF: WebMakers.com Added: Downloads Controller // If there is a download in the order and they cannot get it, tell customer about download rules $downloads_check_query = tep_db_query("select o.orders_id, opd.orders_products_download_id from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " opd where o.orders_id = opd.orders_id and o.orders_id = '" . (int)$last_order . "' and opd.orders_products_filename != ''"); if (tep_db_num_rows($downloads_check_query) > 0 && tep_db_num_rows($downloads_query) < 1) { ?>

 

 

Which modification did I screw-up?

 

Thanks,

Share this post


Link to post
Share on other sites

So, there is an "official" support forum for SuperDownloadStore!

 

After struggling with product_attributes.php a bit, my SuperDownloadStore appears to be working. However, after placing an order for it, when PayPal returns, I got the following message on the screen:

 

// BOF Super Download Store v2.3.x mod // BOF: WebMakers.com Added: Downloads Controller // If there is a download in the order and they cannot get it, tell customer about download rules $downloads_check_query = tep_db_query("select o.orders_id, opd.orders_products_download_id from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " opd where o.orders_id = opd.orders_id and o.orders_id = '" . (int)$last_order . "' and opd.orders_products_filename != ''"); if (tep_db_num_rows($downloads_check_query) > 0 && tep_db_num_rows($downloads_query) < 1) { ?>

 

 

Which modification did I screw-up?

 

Thanks,

 

Looks like it comes from the bottom of downloads.php. I have:

 

<?php

// BOF: WebMakers.com Added: Downloads Controller

// If there is a download in the order and they cannot get it, tell customer about download rules

$downloads_check_query = tep_db_query("select o.orders_id, opd.orders_products_download_id from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " opd where o.orders_id = opd.orders_id and o.orders_id = '" . (int)$last_order . "' and opd.orders_products_filename != ''");

 

if (tep_db_num_rows($downloads_check_query) > 0 && tep_db_num_rows($downloads_query) < 1) {

?>

<tr>

<td colspan="3" align="center" valign="top" class="main" height="30"><FONT FACE="Arial" SIZE=1 COLOR="FF000"><?php echo DOWNLOADS_CONTROLLER_ON_HOLD_MSG ?></FONT></td>

</tr>

<?php

}

// EOF: WebMakers.com Added: Downloads Controller

?>

<!-- downloads_eof //-->

Share this post


Link to post
Share on other sites

I believe the instrution is slightly off. Mod to downloads.php:

 

Find this code around line 118:

 

<?php

}

?>

 

ADD this code BELOW it:

 

=======================

 

Shouldn't it be above that last ?> ....? Here's what I ended with:

 

<?php

}

// BOF Super Download Store v2.3.x mod

// BOF: WebMakers.com Added: Downloads Controller

// If there is a download in the order and they cannot get it, tell customer about download rules

$downloads_check_query = tep_db_query("select o.orders_id, opd.orders_products_download_id from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " opd where o.orders_id = opd.orders_id and o.orders_id = '" . (int)$last_order . "' and opd.orders_products_filename != ''");

 

if (tep_db_num_rows($downloads_check_query) > 0 && tep_db_num_rows($downloads_query) < 1) {

<tr>

<td colspan="3" align="center" valign="top" class="main" height="30"><FONT FACE="Arial" SIZE=1 COLOR="FF000">

<?php echo DOWNLOADS_CONTROLLER_ON_HOLD_MSG?></FONT></td>

</tr>

}

?>

 

<!-- // EOF Super Download Store v2.3.x mod -->

Share this post


Link to post
Share on other sites

@@ecs1749

 

AGAIN, this is not an error. The instructions indicate two possible code variations depending on your version. IT IS NOT an error.

 

 

 

Chris


:|: Was this post helpful ? Click the LIKE THIS button :|:

 

See my Profile to learn more about add ons, templates, support plans and custom coding (click here)

Share this post


Link to post
Share on other sites

I need to build a membership only area where member can view information - rather than download them. SuperDownload store does everything I wanted except the last step. Is that possible already, or do I need to look for other contributions?

 

Thanks,

Share this post


Link to post
Share on other sites

Feis Mom Embroidery Design Link expires:

Thursday 20 September, 2012 5 downloads remaining

 

 

This what I get after I think I have installed the package correctly. It looks right except that there is no button to actually download the file. Any hints? I have tried to find where I have missed something, but can not.

Edited by FeisMom

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×