Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

greree

Archived
  • Posts

    315
  • Joined

  • Last visited

Everything posted by greree

  1. Trusten, It is the box that you helped make. I fixed that problem. In your instructions to add code to column_right.php, add this line: AND opd.download_count > '0', so that it looks like this: if (tep_session_is_registered('customer_id')){ $downloads_query_raw1 = "SELECT DATE_FORMAT(date_purchased, '%Y-%m-%d') as date_purchased_day, o.orders_id, opd.download_maxdays, op.products_name, opd.orders_products_download_id, opd.orders_products_filename, opd.download_count, opd.download_maxdays FROM " . TABLE_ORDERS . " o, " . TABLE_ORDERS_PRODUCTS . " op, " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " opd WHERE customers_id = '" . $customer_id . "' AND o.orders_id = op.orders_id AND o.orders_status >= '2' AND o.orders_status != 99999 AND opd.download_count > '0' AND opd.archived != 'yes' AND opd.orders_products_id=op.orders_products_id AND opd.orders_products_filename<>'' ORDER BY opd.orders_products_download_id DESC LIMIT 999"; $download1 = tep_db_query($downloads_query_raw1); $download = tep_db_fetch_array($download1); if ($download > 0) { include(DIR_WS_BOXES . 'download_files.php'); } } That'll take care of the problem. The box goes away when it's supposed to.
  2. This is from a post the author made last September. You can change button_to_download.gif to button_download.gif in the code so you won't have to make that button. That's a standard osC button. Also, go to http://www.elbavarowebdesign.de/osc/catalo...ogue_button.htm. He's got a standard design button set that includes Archive. Look near the bottom. Oh, and do me a favor. When you test it out let me know how it works. I had to do a bit of tweaking to get it to work for me.
  3. Then I either installed it wrong or it doesn't work quite right on a more recent snapshot. In my installation when max downloads is reached the link inside the box goes away, but the box itself stays. Inside the box is the text "Your Downloads". No link or button. I'll check it again.
  4. I installed a contribution called "Download Page For Pending Downloads" that puts a box on the default page indicating pending downloads. Clicking a button in the box takes you to the downloads page. That way customers don't have to navigate through My Account, etc. The only problem is when the downloads are finished the box stays on the page. The reason it stays is because it looks for a value in a field called "order_status" in the "orders" table in the database. When someone buys a downloadable product and pays with a check, the order status is set to 1, and the download isn't enabled, and the box doesn't appear on the default page. When I get the check, I set the order status to 2 to indicate processing. That tells the customer that I received the check and I'm waiting for it to clear the bank. When it clears I set the order status to 3, which tells the customer the download is available, downloads are enabled, and the box appears on the default page. When the customer clicks on the button in the box on the default page and downloads his product, the box stays. That's because the order_status field doesn't reset to 0. I can reset it manually, but that would be a pain. Anyone have any ideas on how to reset this value to 0 after the customer downloads the product or the time expires? Thanks for the help.
  5. I sent an email to the guy who wrote the contribution. He said he's working on a fix for the problem and he'll post it to the contributions section when it's finished. In the meantime I just took the list and manually entered it into a scrolling box. It doesn't dynamically change, but I don't suppose that's critical. In fact I may leave it like that. I might want to push certain products by calling them best sellers.
  6. I downloaded and installed Best Sellers scroll, which has a major flaw. If I have ten best sellers, it'll divide the box into ten little windows and each bestseller will scroll in it's own section. You can see an example of the problem at http://www.puresoap.com/. The code that does this is $info_box_contents = array(); $info_box_contents[] = array('align' => 'left', 'text' => BOX_HEADING_BESTSELLERS ); new infoBoxHeading($info_box_contents, false, false); $rows = 0; $info_box_contents = array(); while ($best_sellers = tep_db_fetch_array($best_sellers_query)) { $rows++; $info_box_contents[] = array('align' => 'left', 'text' => '<center><marquee direction="up" scrollAmount="1" style="width:118;height:65">' . '. <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $best_sellers['products_id'], 'NONSSL') . '">' . $best_sellers['products_name'] . '</a></marquee>'); } new infoBox($info_box_contents); I want something that will generate a list and then scroll the whole thing. Any ideas?
  7. It wasn't Pollbooth 1.2 that was causing the problem. Sorry for troubling you, Ian. Bill Gates was causing the problem. I had done some rearranging of the boxes and added some new buttons as well as installing Pollbooth 1.2. One of the buttons I replaced was the small button beside the blank in the Search box. I replaced it with a much larger button. Apparently Netscape automatically wraps the graphic if it would extend past the defined width of the column. MSIE doesn't. MSIE extends the width of the column. When I looked at my page for the first time with Pollbooth installed, all the boxes were too wide, so I assumed it was Pollbooth that was causing the problem, since that was the only new box. To fix it, I added a <br> in the line of code in /catalog/includes/boxes/search.php between the part that draws the fill-in-the-blank and the part that places the graphic.
  8. OK, this is a more accurate description of the problem. I typed 12345 as many times as would fit, with spaces in between each group of five numbers, like 12345 12345 12345. In both the title and the question Netscape wrapped the line of numbers after every three groups, which is fine. MSIE wrapped the line after every five groups, which is too long. That's the best I can describe it, and since it's not online you can't see it. Any ideas? Thanks.
  9. I don't know. They're about the same length. Let me change something. I'll be back.
  10. The text isn't wrapping in MSIE. The poll box stretches halfway across the page. It does wrap in Netacape in both Windows and Linux. Any ideas?
  11. This contribution is in the Features section. When the proper conditions are met the page "download_files.php" is loaded. It has some information and other things on it. It also has the product name and file name listed (i.e. Unreal Tournament and unreal.zip). These names are links. The URL for unreal.zip is http://localhost/catalog/download.php?order=4&id=4. Clicking on it downloads the file. The URL for "Unreal Tournament" is http://localhost/catalog/product_info.php?products_id= , which is incorrect. That link should end with "products_id=22", and clicking on it should bring me to the info page for "Unreal Tournament". The code that I think controls this is in the file download_files.php: echo ' <td><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $downloads_values['products_id'], 'NONSSL') . '">' . $downloads_values['products_name'] . '</a></td>' . "n"; I don't know what's wrong. In the right column in the "Order History" and "Bestsellers" boxes the name "Unreal Tournament" appears as a link, and in both cases it works fine. The URL in both cases ends in "products_id=22". I compared the codes that work with the code that doesn't, but I couldn't figure it out. Could someone take a look at this contribution and tell me what's going wrong? It isn't a complicated contrib. Oh, I'm using the current snapshot. Thanks.
  12. What osCommerce snapshot are you using? I tried to install Account Signup Management but I ran into so many problems with it I had to give up and write my own. The problem is that Account Signup Management 1.1 was written July of last year, and there's been a lot of changes made to osCommerce since then. I would recommend not installing Account Signup Management. Your best bet is to read through it and try to adapt the code to the current snapshot.
  13. I wrote a contribution called "United States Format" to configure the Create Account like I wanted. You may be able to modify it to do what you want. It's in the Features section in Contributions. The last time I looked through it I noticed a few minor errors, but I haven't had time to write out and upload a correction. So be careful.
  14. If that's the simple version then I'm in trouble, because I didn't understand it at all. If I have a product called "The Book", I can set the attribute as print, cd, or download. I can also set the weight of "The Book" at 2 lbs. But I can't assign different attributes with different weights. I can't see how your instructions solves this problem. I can create three different products, "The Book Print", "The Book CD", and "The Book Download", and assign different weights to each, but I don't want to do this. If someone is browsing products, and sees "The Book" as a cd, but wants it as a download, he would have to back out of the product info page for the cd and find the page for the download. That's too much trouble. I would lose sales that way. Take a look at the demo store. If you pick Unreal Tournament, it gives you a description of the product, plus a choice of Box or Download from a drop down list. That's how I want it, except Download should charge no shipping. For some reason osCommerce charges shipping for downloads. If I knew PHP I could do it myself. The problem is I don't know it at all. I'm smart enough to take existing code from osCommerce and apply it to other areas, but I'm not smart enough to create code from scratch.
  15. How about a "weight" attribute that adjusts shipping charges? Say, if I ordered a large widget, I get charged $20.00 shipping because it weighs a lot. A medium widget would be charged $15.00, and a small widget would be charged $10.00. What I'm looking for is a way to sell financial manuals online. The same book will be available printed, on a cd, or downloaded. All three have different shipping charges, with the shipping charge for the download being zero. The customer should be able to click on an icon to go to a description page, where he can read about the product, then click on a drop down menu to select printed, cd, or download. If your contribution will do anything close to that please let me know.
  16. United States format v1.0. This was developed using snapshot 20021211. This changes the My Account Information page to conform with United States Postal Service standards, such as Zip Code at the bottom. It also changes a few fields so as to make them less offensive to people who suffer from Political Correctness. No files to replace, just a long text file of changes. It's divided into three parts. All three are independent of each other. Thanks to Noerd and Mattice for help on understanding parts of the code.
  17. I'm trying to configure my store to display and accept Gender input, but not require it. I've looked at Account Signup Management Version 1.1 in the Features contribution section, but it doesn't work with the current snapshot, and I think it would have some of the same problems I'm having even if it did work. Emails to the person who wrote this contribution have gone unanswered. The problem I'm having is that the program assumes that the Gender is "Female" if 'Male" isn't selected. So if no gender is selected, the program sees it as "Male isn't selected", and fills in a female gender. I've managed to stop the program from doing this in every place except one: If a customer fills out My Account Information, then goes back to edit the information, it appears again. I can't get rid of it. If anyone has any ideas please let me know. Thanks.
  18. Installed Account Signup Management 1.1 (contrib) on tep_snapshot-20021124. I got the following error: Fatal error: Call to undefined function: tep_get_zone_list() in /var/www/html/catalog/includes/modules/account_details.php on line 499. This is the section with the error: <tr> <td class="main"> <?php echo ENTRY_STATE; ?></td> <td class="main"> <?php if ($is_read_only) { echo tep_get_zone_name($account['entry_country_id'], $account['entry_zone_id'], $account['entry_state']); } elseif ($processed) { echo tep_get_zone_name($HTTP_POST_VARS['country'], $HTTP_POST_VARS['zone_id'], $HTTP_POST_VARS['state']) . tep_draw_hidden_field('zone_id') . tep_draw_hidden_field('state'); } elseif (ACCOUNT_REQUIRED_STATE == 'false') { echo tep_get_zone_list('zone_id', $account['entry_country_id'], $account['entry_zone_id'], 'onChange="resetStateText(this.form);"'); } else { echo tep_get_zone_list('zone_id', $account['entry_country_id'], $account['entry_zone_id'], 'onChange="resetStateText(this.form);"'); echo ' ' . ENTRY_STATE_TEXT; } ?></td> </tr> Any ideas? I think it may be that it's asking for a drop down menu for "States/Province", which is no longer used. In current builds of osCommerce "States/Province" is fill in the blank. I don't know PHP, so I have no idea how to fix it. Thanks for any help.
×
×
  • Create New...