PDA

View Full Version : Super Downloads



dmm2020
17-06-2010, 04:15
I am stuck on this one.

Can you look at the script and see what has to be edited to make this work with your version of osC.

http://addons.oscommerce.com/info/4868

Only thing stopping us from going live.

Thanks for the good work you did on the rest of the stuff for us.

Greystoke
17-06-2010, 04:17
This is just finished.

dmm2020
19-06-2010, 21:42
Download test is failing....what is the path to enter for the download file?

I am wondering if the Super Downloads mod really fits our needs, because it appears like it's trying to assemble the whole packet in one download, which in our case would be huge and likely lead to server timeouts. I originally thought this mod resulted in a batch listing rather than creating large download packets. Our game packs alone might hit close to 10gb so we want to break them down into smaller packets.

I need to list roughtly 4 downloads for virtually every product.

Greystoke
19-06-2010, 21:53
I just made a test download on your site and it is working fine.

Go into your account and look at this order:
17/06/2010 #100617-523708-6266

dmm2020
20-06-2010, 01:57
Here are the areas of concern I have found so far:

1. MOST IMPORTANT: I can get single downloads to show, but NOT the group downloads which is what Super Downloads is supposed to be the way I read the description. We do not put our downloads in one huge file or we would face server time out, or it would take forever to download a file and our customers would simply lose patience. Therefore, we must break them down into parts.

2. When the attributes max_downloads or time period is set to 0, it should not decrement but does.

3. When I reset the downloads via the orders.php file, it did not take. When I edited the blow block of code to hardcode the group id and numbers, it works.

// BOF: WebMakers.com Added: Downloads Controller
$check_status_query2 = tep_db_query("select customers_name, customers_email_address, orders_status, date_purchased from " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'");
$check_status2 = tep_db_fetch_array($check_status_query2);
//if ( $check_status2['orders_status'] == DOWNLOADS_ORDERS_STATUS_UPDATED_VALUE ) {
if ( $check_status2['orders_status'] == 12 ) {

tep_db_query("update " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " set download_maxdays = '999', download_count = '5' where orders_id = '" . (int)$oID . "'");
}
// EOF: WebMakers.com Added: Downloads Controller


I need to figure out fast how to update prior orders with appropriate downloads and any help would be appreciated.

Greystoke
20-06-2010, 02:32
That part of the code works fine.

You never set the Expiry delay (days) or Maximum number of downloads in the Configuration -> Download section.

You have both of these set to 0.

Greystoke
20-06-2010, 03:47
I looked at your Super Downloads install again.

You had changed your checkout_process.php file again, after I fixed it the last time.
It was missing a lot of the Super Downloads code.

All files are now back to the way they should be.

Also if you go to the last purchase in your account you can see multiple files are there for purchase.

I created test Products Attributes and a test product, you can remove these when you are finished with them.

dmm2020
20-06-2010, 04:11
Thanks, I appreciate it, but...question now is how can I quickly update existing orders so that all the respective download packets appear?

Sorry about the edits, I think we crossed paths. I was trying to reinstall clean files same time you were trying to edit.

Greystoke
20-06-2010, 04:20
You can try doing an order update, like when you chance the order from pending to order reset.

If that doesn't work then the fields in the order tables aren't matching the correct order ids.

The easy way to see what is happening when an order is placed, is to backup the tables to do with orders and then make an order.
Then backup the tables again and compare both of them.

You'll then see what changes you need to make to get the other cart orders to work with this cart.

dmm2020
20-06-2010, 04:35
I got over 2,000 orders to do that to though. WP-Cart uses only one orders table where oscCart it is split into sub and cross-reference tables which sometimes drives me nuts trying to integrate it. I have to make downloads available on all orders because once we release the new version of our software, they are going to want an upgrade. Once I get the logic into my head, I am sure it will become easier, but for now I just haven't figured it out. Confusing matters even further the WP-Cart orders table was originally integrated for phpBB3 user tables. I ended up writing a rather lengthy SQL file to copy the data in the WP-Cart to oscCart.

Isn't there a quick way to do all that en masse?

Accidently inserted visual code to title here sorry.

Greystoke
20-06-2010, 12:47
You will need to send me the WP-Cart database to do with the orders.

dmm2020
20-06-2010, 12:54
All that is in the orders now. The orders show up. The downloads do not.

Specifically, what all has to be populated, what conditions must be met in what table before the download appears?

dmm2020
20-06-2010, 12:59
That part of the code works fine.

You never set the Expiry delay (days) or Maximum number of downloads in the Configuration -> Download section.

You have both of these set to 0.

0 according to the description is supposed to turn them off though, which is what I wanted for expiry date.

dmm2020
20-06-2010, 13:24
Found another issue too, not sure if it's on the orders side or download side of the script:

In the admin panel for order #3517, which is the very first order I ever made, the amount is ridiculously high $398.00 where it should be 19.95. In the front end, the order shows correctly. Users wont see this I know, but really should reflect accurate amount.

dmm2020
20-06-2010, 13:45
Found another issue too, not sure if it's on the orders side or download side of the script:

In the admin panel for order #3517, which is the very first order I ever made, the amount is ridiculously high $398.00 where it should be 19.95. In the front end, the order shows correctly. Users wont see this I know, but really should reflect accurate amount.

Correction: The order for the item shows as $398.00 at front end too.

dmm2020
21-06-2010, 03:53
One small fix:

Download links
1 - Arcadem Pro 2.95 Standard License
Download - 10.12Mb Link expires:
Saturday 18 September, 2010 5 downloads remaining
1 - Arcadem Pro 2.95 Standard License
Download - 490.51Mb Link expires:
Saturday 18 September, 2010 4 downloads remaining


How can I get the above to group the downloads together and put something like this instead:
[Product Name]:<br />
<button>[Download File Description] Size: [Link Expires] [# Downloads Remaining]<br />
<button>[Download File Description] Size: [Link Expires] [# Downloads Remaining]<br />
<button>[Download File Description] Size: [Link Expires] [# Downloads Remaining]<br />

I would like to see the downloads grouped under the product name as above, and existing method does not tell the user what file they are actually downloading. It's showing the same description for each one.

By Download File Description, I am meaning the plain English description we assigned to the download under the "Files in Group" in the admin panel.

Otherwise, excellent work and thanks.

Greystoke
21-06-2010, 19:49
The above wasn't showing correctly as filename description in your database was incorrect.

It looks like this now:


1 - Arcadem Pro 2.95 Standard License - Arcade Script
Download - 10.12Mb Link expires:
Saturday 18 September, 2010 5 downloads remaining
1 - Arcadem Pro 2.95 Standard License - Default Game Pack
Download - 490.51Mb Link expires:
Saturday 18 September, 2010 4 downloads remaining
1 - Arcadem Pro 2.95 Standard License - Thumbnails
Download - 22.77Mb Link expires:
Saturday 18 September, 2010 5 downloads remaining
1 - Arcadem Pro 2.95 Standard License - 500 Game SQL File
Download - 277Bytes Link expires:
Saturday 18 September, 2010 5 downloads remaining

dmm2020
22-06-2010, 00:32
Near perfect....how can I put a <br /> after the product name where the hypen is now?

Greystoke
22-06-2010, 00:39
Edit shop/includes/modules/downloads.php

On line 99:

Change


echo ' <td class="main" align="center">' . $downloads['products_name'] . ' - <a href="' . tep_href_link(FILENAME_DOWNLOAD, 'order=' . $last_order . '&id=' . $downloads['orders_products_download_id']) . '">' . $file_array['download_group_file_description'] . '<br>' . tep_image_button('button_download.gif', 'Download') . '</a> - ' . $file_size . '</td>' . "\n";


To


echo ' <td class="main" align="center">' . $downloads['products_name'] . ' <br /> <a href="' . tep_href_link(FILENAME_DOWNLOAD, 'order=' . $last_order . '&id=' . $downloads['orders_products_download_id']) . '">' . $file_array['download_group_file_description'] . '<br>' . tep_image_button('button_download.gif', 'Download') . '</a> - ' . $file_size . '</td>' . "\n";


That should do it.