Jump to content
AlexStudio

[contribution] Super Download Store

Recommended Posts

OK, I got that.

 

But when you assign an download to an attribute, I assume the way it works, you should have a scroll list of the files available as previously entered in the FileGroups. Instead of that list, you have only "Group_Files-1" in the box where the name of the file should be. I assume it's trying to call Group_Files-1. There's no choice for a file selection.

 

Works fine if No File Group is the choice.

 

I'll get this. Thanks for you patience.

 

Martin

Share this post


Link to post
Share on other sites

The filenames are listed in the Files in Group area, but not listed in the attributes. I don't think it's a good idea to list all files in the group, in the drop down menu where to select the group to be assigned to an attribute.


Super Download Shop, PayPal Express Checkout IPN, Selling Downloads, Visual Validation (preventing robotic flood), phpBB2 Integration

 

Yes, I'm willing to help, but please ask in the right place. Think twice before trying to PM me, it might be ignored.

Share this post


Link to post
Share on other sites

I think there's a misunderstanding in communication here.

 

I have a product and want to make a download available for that product. I'm at the admin/products_attributes.php page

 

When I edit the product's attribute, the correct group is there, but the filename indicates: Group_Files-1

 

The file that I would like to make available within the group is not there; the filename is NOT retrieved and NOT retained when I try to include a download to a product with a group selected.

 

However, if No File Group is elected, a filenanme can be entered, and is properly recalled when I come back to edit.

 

Martin

Share this post


Link to post
Share on other sites

I think there's a misunderstanding in communication here.

 

I have a product and want to make a download available for that product. I'm at the admin/products_attributes.php page

 

When I edit the product's attribute, the correct group is there, but the filename indicates: Group_Files-1

 

The file that I would like to make available within the group is not there; the filename is NOT retrieved and NOT retained when I try to include a download to a product with a group selected.

 

However, if No File Group is elected, a filenanme can be entered, and is properly recalled when I come back to edit.

 

Martin

Share this post


Link to post
Share on other sites

I think there's a misunderstanding in communication here.

 

I have a product and want to make a download available for that product. I'm at the admin/products_attributes.php page

 

When I edit the product's attribute, the correct group is there, but the filename indicates: Group_Files-1

 

The file that I would like to make available within the group is not there; the filename is NOT retrieved and NOT retained when I try to include a download to a product with a group selected.

 

However, if No File Group is elected, a filenanme can be entered, and is properly recalled when I come back to edit.

 

Martin

Share this post


Link to post
Share on other sites

Screen Shots

 

PA0.jpg

 

Notice Group within filename.

PA1.jpg

 

Notice proper filename without group

PA2.jpg

 

TIA

 

Martin

Share this post


Link to post
Share on other sites

That is exactly how the file group works. You got a blank download page when clicking on the download link probably because you didn't apply the modification in checkout_process.php, for the group to be broken into individual files. Please check the orders_products_download table and see what filenames got logged with the order.

 

Please notice that you are not supposed to pick a file from a group to be assigned to a product attribute. When a file group assigned to an attribute, every file in that group will be listed as downloads in that sigle item.

Edited by AlexStudio

Super Download Shop, PayPal Express Checkout IPN, Selling Downloads, Visual Validation (preventing robotic flood), phpBB2 Integration

 

Yes, I'm willing to help, but please ask in the right place. Think twice before trying to PM me, it might be ignored.

Share this post


Link to post
Share on other sites

Hello. Tks for such a nice contribution. :thumbsup:

 

I'm having a problem trying to install it though: I'm using the Admin Order Sort contribution, which modified file admin/orders.php, making impossible for me to apply the changes for Super Download with just a comparing editor. So could you please give me a hand here by giving me a step-by-step instruction on how to merge the last change in the file? It's after line 359 on the file inside your zip, right after

 

		<td colspan="2" align="right"><?php echo '<a href="' . tep_href_link(FILENAME_ORDERS_INVOICE, 'oID=' . $HTTP_GET_VARS['oID']) . '" TARGET="_blank">' . tep_image_button('button_invoice.gif', IMAGE_ORDERS_INVOICE) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS_PACKINGSLIP, 'oID=' . $HTTP_GET_VARS['oID']) . '" TARGET="_blank">' . tep_image_button('button_packingslip.gif', IMAGE_ORDERS_PACKINGSLIP) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action'))) . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a>'; ?></td>
  </tr>
<?php

 

If it helps, this is how my code looks like for this part:

 

 // Admin Order Sort Mod Applied

  } else {
  if (isset($HTTP_GET_VARS['viewedSortOrder']))
  {
 $viewedSortOrder = $HTTP_GET_VARS['viewedSortOrder'];
 tep_session_register('viewedSortOrder');
  }
  if (isset($HTTP_GET_VARS['page']))
  {
 $page = $HTTP_GET_VARS['page'];
 tep_session_register('page');
  }
  if(!isset($page)) $page = 1;

  switch ($viewedSortOrder) {
   case "customer-asc":
	 $order .= "customers_name";
   break;
   case "customer-desc":
	 $order .= "customers_name DESC";
   break;
   case "date-asc":
	 $order .= "date_purchased";
   break;
   case "date-desc":
	 $order .= "date_purchased DESC";
   break;
   case "status-asc":
	 $order .= "orders_status_id";
   break;
   case "status-desc":
	 $order .= "orders_status_id DESC";
   break;
	default:
	$order .= "orders_id DESC";
  }
  ?>

   <tr>
	 <td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">
	   <tr>
		 <td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
		 <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td>
		 <td align="right"><table border="0" width="100%" cellspacing="0" cellpadding="0">
		   <tr><?php echo tep_draw_form('orders', FILENAME_ORDERS, '', 'get'); ?>
			 <td class="smallText" align="right"><?php echo HEADING_TITLE_SEARCH . ' ' . tep_draw_input_field('oID', '', 'size="12"') . tep_draw_hidden_field('action', 'edit'); ?></td>
		   </form></tr>
		   <tr><?php echo tep_draw_form('status', FILENAME_ORDERS, '', 'get'); ?>
			 <td class="smallText" align="right"><?php echo HEADING_TITLE_STATUS . ' ' . tep_draw_pull_down_menu('status', array_merge(array(array('id' => '', 'text' => TEXT_ALL_ORDERS)), $orders_statuses), '', 'onChange="this.form.submit();"'); ?></td>
		   </form></tr>
		 </table></td>
	   </tr>
	 </table></td>
   </tr>
   <tr>
	 <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
	   <tr>
		 <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
		   <tr class="dataTableHeadingRow">
			 <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CUSTOMERS; ?> <a href="<?php echo "$PHP_SELF?viewedSortOrder=customer-asc"; ?>"><img src="../images/icons/sort_down.gif" border="0" width="18" height="10" alt="Descendente"></a><a href="<?php echo "$PHP_SELF?viewedSortOrder=customer-desc"; ?>"><img src="../images/icons/sort_up.gif" border="0" width="18" height="10" alt="Ascendente"></a></td>
			 <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ORDER_TOTAL; ?></td>
			 <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_DATE_PURCHASED; ?><br><a href="<?php echo "$PHP_SELF?viewedSortOrder=date-asc"; ?>"><img src="../images/icons/sort_down.gif" border="0" width="18" height="10" alt="Descendente"></a><a href="<?php echo "$PHP_SELF?viewedSortOrder=date-desc"; ?>"><img src="../images/icons/sort_up.gif" border="0" width="18" height="10" alt="Ascendente"></a></td>
			 <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_STATUS; ?><br><a href="<?php echo "$PHP_SELF?viewedSortOrder=status-desc"; ?>"><img src="../images/icons/sort_down.gif" border="0" width="18" height="10" alt="Descendente"></a><a href="<?php echo "$PHP_SELF?viewedSortOrder=status-asc"; ?>"><img src="../images/icons/sort_up.gif" border="0" width="18" height="10" alt="Ascendente"></a></td>
			 <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACTION; ?> </td>
		   </tr>
<?php
 if (isset($HTTP_GET_VARS['cID'])) {
   $cID = tep_db_prepare_input($HTTP_GET_VARS['cID']);
   $orders_query_raw = "select o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.customers_id = '" . (int)$cID . "' and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' order by $order";
	 } elseif (isset($HTTP_GET_VARS['status']) && is_numeric($HTTP_GET_VARS['status']) && ($HTTP_GET_VARS['status'] > 0)) {
   $status = tep_db_prepare_input($HTTP_GET_VARS['status']);
   $orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and s.orders_status_id = '" . (int)$status . "' and ot.class = 'ot_total' order by o.orders_id DESC";
 } else {
   $orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' order by $order";
 }
 $orders_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $orders_query_raw, $orders_query_numrows);
 $orders_query = tep_db_query($orders_query_raw);
 while ($orders = tep_db_fetch_array($orders_query)) {
 if ((!isset($HTTP_GET_VARS['oID']) || (isset($HTTP_GET_VARS['oID']) && ($HTTP_GET_VARS['oID'] == $orders['orders_id']))) && !isset($oInfo)) {
	 $oInfo = new objectInfo($orders);

 

How can I merge the changes required by your contribution into this part of the code?

I appreciate any help you could give me. Thank you in advance. :)


Patty

Share this post


Link to post
Share on other sites

Patty, you have 2 options here. The 1st one which I recommended, is to keep your existing sort order contribution and skip the last part in this file came with SDS. The other is to remove that sort order contribution you installed, and so you can apply the modification came with SDS.

 

The sort order part of the code came from the downloads controller v5.3 package, and I didn't remove them because it's kind of handy. Unfortunately it won't work with the Admin Order Sort contribution you have installed. Actually they are doing the same thing in similar methods.


Super Download Shop, PayPal Express Checkout IPN, Selling Downloads, Visual Validation (preventing robotic flood), phpBB2 Integration

 

Yes, I'm willing to help, but please ask in the right place. Think twice before trying to PM me, it might be ignored.

Share this post


Link to post
Share on other sites

Tks for your quick reply, Alex. :)

 

Yeah, I just realized that. This is what I'm gonna do, I'm removing the admin sort order already.

Tks for the hint. And tks for your prompt follow up to your contribution. Really nice of you. :)


Patty

Share this post


Link to post
Share on other sites
I was just wondering if you would know why I might still be getting this error:

 

1136 - Column count doesn't match value count at row 1

 

insert into products_attributes values ('', '266', '8', '10', '', '+')

 

[TEP STOP]

 

It doesn't seem to be the catalog/admin/products_attributes.php file. As it stands now, I can't add product attributes as a single file or a group. It seems to not write some of the information to the database or something. Any insight would be greatly appreciated.

I'm having the same problem:

 

1136 - Column count doesn't match value count at row 1

 

insert into products_attributes values ('', '28', '5', '10', '', '+')

 

[TEP STOP]

 

I checked file catalog/admin/products_attributes.php and it's not it, it matches the one from the contribution.

 

This is my table products_attributes:

 

products_attributes_id

products_id

options_id

options_values_id

options_values_price

price_prefix

options_values_weight

 

Also I'm using the Ajax Attributes Manager contribution, but I don't think it altered any tables.

 

So what's wrong here and how can I fix it?

TIA for your help.


Patty

Share this post


Link to post
Share on other sites

Never mind. It's a leftover from a deleted contribution. Sorry. :(


Patty

Share this post


Link to post
Share on other sites

Ops! Spoke too soon! :blush:

Actually, I do need that column "options_values_weight". So I do need to include it in the products_attributes.php

Could you help me with that? :-"


Patty

Share this post


Link to post
Share on other sites

Fixed. I had to add the Add weight to attribute contribution again.

Sorry about so many useless posts, but the edit function is disabled within minutes.

Edited by Patty

Patty

Share this post


Link to post
Share on other sites

I already installed osCommerce 2.2 Milestone 2 Update 060817 and it running successfully

 

Then I want to install Super Download Shop 1.1 and I import group_file_for_download.sql.

 

When I try to run filegroup_db_setup.php, it shows the following error

 

"

1146 - Table 'shop.table_products_attributes_download_groups' doesn't exist

 

select * from TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD_GROUPS where download_group_id = 0 and language_id = '1'

 

[TEP STOP]

"

 

Please help me to install Download Shop 1.1.

 

Thanks,

Bhaskar

Share this post


Link to post
Share on other sites

HI Alex,

 

After doing the instalation, and double checking everything, I do receive the following error message when trying to enter admin side:

 

1046 - No Database Selected

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

 

Any ideas?

 

BR,

J

Share this post


Link to post
Share on other sites
HI Alex,

 

After doing the instalation, and double checking everything, I do receive the following error message when trying to enter admin side:

 

1046 - No Database Selected

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

 

Any ideas?

 

BR,

J

 

I had the same problem setting up a redundant site. I didn't have my database user accessing the database. Go into your phpAdmin, check that ytour user has access to the DB with all permissions.

 

I just clicked adduser to the db, and all worked fine.

 

Imagixx

Share this post


Link to post
Share on other sites
I had the same problem setting up a redundant site. I didn't have my database user accessing the database. Go into your phpAdmin, check that ytour user has access to the DB with all permissions.

 

I just clicked adduser to the db, and all worked fine.

 

Imagixx

 

HI,

 

Did try that, but didn´t help?

 

Is there an issue since I have 2 db´s under my domain and they both have the same uid and password for accessing the db´s?

 

BR,

J

Share this post


Link to post
Share on other sites
HI,

 

Did try that, but didn´t help?

 

Is there an issue since I have 2 db´s under my domain and they both have the same uid and password for accessing the db´s?

 

BR,

J

 

I'm not the expert here, just getting by.

 

The same uid and password wouldn't make a difference. It seems to me that your user isn't accessing the proper DB. Recheck your config files. Then make siure the designated user has access and permissions to the right DB.

 

Imagixx

Share this post


Link to post
Share on other sites

Essential plugin, thanks Alex.

 

Is there a simple PayPal plugin that automatically sets order status?

Share this post


Link to post
Share on other sites

If there was an Ajax file selector instead of having to type the filename in manually, this plugin would reach the next level.

 

Anyone capable of accomplishing this? Is there another plugin that uses this technique that can be used as a base?

 

 

Either that or make this contrib work with the File Upload plugin.

Edited by b0se

Share this post


Link to post
Share on other sites

Hi,

 

I've installed this contribution ok but am having a few issues getting the download links to work at checkout_success.php. Am wondering if anyone can help? I've read through all the comments here but no luck in working out the issue yet and the contribution looks really great so I don't want to give up on it!

 

I have 2 items in my download group. When I get to checkout_success only the name of my product appears with no link (rather than the correct two files with links as shown in the screenshots in the docs).

 

Cause I couldn't make the groups work, I then tried selecting 'no file group' in product attributes and entering just the single file name. When I got to checkout success it then gave the name of my product with a link however the link is for 'download.php' instead of my file and looks to be a whole heap of gibberish.

 

I've checked the file names are correct for both options.

 

I am using Ultimate SEO URLs v 2.2.1 however even if I turn this off I get the same results. I am also using Paypal IPN. I've applied the suggested fix in the paypal_ipn.php file and this works fine but doesn't help or change the link issue.

 

Any clues? Help would be greatly appreciated!

 

Thanks,

Becdjane

Share this post


Link to post
Share on other sites
The latest Ultimate SEO URLs version is 2.1d, and it works fine with Super Download Shop. The v2.2.1 you're using has been removed from the contribution area, and I believe that it is not as stable as v2.1d.

Super Download Shop, PayPal Express Checkout IPN, Selling Downloads, Visual Validation (preventing robotic flood), phpBB2 Integration

 

Yes, I'm willing to help, but please ask in the right place. Think twice before trying to PM me, it might be ignored.

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

×