Jump to content

christiansees

Members
  • Content count

    136
  • Joined

  • Last visited

Everything posted by christiansees

  1. christiansees

    [CONTRIBUTION] PDF Customer Invoice

    Hello Christian, Thank you for an excellent contribution. I hope you see the amount of traffic here as a sign of how much it was needed. Also I would like to say I have never seen a better supported contribution on all the forums. Congrats. First I would like to say I was having the same problem as others on the order total lines running over. The best solution I saw you post was #87. To others having the same problem please look there and read the forum before posting. Also to maista forget the standard paypal contribution it's junk IMHO. Move on to the paypal IPN it is coded by the creators of Oscommerce and is supported by them, as a bonus I can tell you from experience that it works great with this contribution, no conflicts. I am going to install a gift certificate with account balance contribution. I am wondering if you can advise about having those fields show up on the pdf invoice. Thanks Christian
  2. christiansees

    [contribution] Super Download Store

    Hello, I don't know whether this got answered before or not but here goes. This contribution works perfectly with both authorize.net payment and paypal_ipn Here is the trick. The payment statuses must match! The default payment status for downloads to be available is 12. What you must do is change that to be the payment status for your authorize.net payments from pending to processing. So if authorize.net has Authorized/Pending Capture they can get their downloads instantly on the checkout_success.php page. Thats what we all want right? Instant gratification. The next step is to change the the order status for the paypal_ipn so that they match. This can be done from the admin --> localization --> order status Also check the settings that you have setup on the modules --> payment --> credit/debit via paypal Set Preparing Order Status: Preparing [PayPal IPN] Set PayPal Acknowledged Order Status: Pending Set PayPal Completed Order Status: Processing As I recall there is also a page where the settings for the expected status of 12 is hard coded you have to find this and change it from 12 to 3 or which ever one you choose as your download available status. Sorry I forget which page that it is and which contribution is it paypal_ipn or Super Download Shop Hope that helps
  3. christiansees

    [contribution] Super Download Store

    Hi Kevin, Strikes me like the most difficult part of your application of oscommerce to your situation is the fact that you want to have products that available to only certain customers and hidden from all others. I think that there are contributions that address that situation, but not this one. In fact I don't think that you need this at all if your customers are only downloading a single .pdf. The standard download functionality of oscommerce should have you covered, in that regard. Hope that helps.
  4. christiansees

    [contribution] Super Download Store

    Hello All, Great contribution, excellent instructions. I was able to have it work from the start. Although I did have download controller installed previously. Actually I had to move to this contribution from downloads controller in order to get my shop working again after doing the Oscommerce MS2.2 RC2a update. Downloads controller no longer works with that update. In order to make this contribution code consistent with RC2a update I had to make the following changes. Please excuse this post if it is a repeat. I didn't want to read all 33 pages. In catalog/download.php on line 23 I changed it to $downloads_query = tep_db_query("select date_format(o.last_modified, '%Y-%m-%d') as date_purchased_day, o.orders_status, opd.download_maxdays, opd.download_count, opd.download_maxdays, opd.orders_products_filename from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_PRODUCTS . " op, " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " opd, " . TABLE_ORDERS_STATUS . " os where o.customers_id = '" . $customer_id . "' and o.orders_id = '" . (int)$HTTP_GET_VARS['order'] . "' and o.orders_status >= '" . DOWNLOADS_CONTROLLER_ORDERS_STATUS . "' and o.orders_id = op.orders_id and op.orders_products_id = opd.orders_products_id and opd.orders_products_download_id = '" . (int)$HTTP_GET_VARS['id'] . "' and opd.orders_products_filename != '' and o.orders_status = os.orders_status_id and os.downloads_flag = '1' and os.language_id = '" . (int)$languages_id . "'"); In catalog/includes/modules/downloads.php on line 23 to /*UPv2.2RC2a*/$downloads_query = tep_db_query("select o.orders_status, date_format(o.last_modified, '%Y-%m-%d') as date_purchased_day, 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, " . TABLE_ORDERS_STATUS . " os where o.customers_id = '" . (int)$customer_id . "' and o.orders_status >= '" . DOWNLOADS_CONTROLLER_ORDERS_STATUS . "' and o.orders_id = '" . (int)$last_order . "' and o.orders_id = op.orders_id and op.orders_products_id = opd.orders_products_id and opd.orders_products_filename != '' and o.orders_status = os.orders_status_id and os.downloads_flag = '1' and os.language_id = '" . (int)$languages_id . "'"); Now both the download flag from the RC2a and the downloads controller order status are checked! If you do this be sure to update your table_order_status in your phpmyadmin to have the download flag for the valid order status to be 1 and not 0 All are set to 0 by default with the SQL changes in the RC2a update. Remember to back up your database and code pages first ;) Hope this helps Thanks Christian
  5. christiansees

    Downloads Controller

    Hello All, I checked that the code in all the modified pages match the newest version of Downloads Controller and that all the files on the server are updated. Yet I still can not get the download button to show. Neither in the checkout_success page nor the order_history_info page Any help would be appreciated. Thanks
  6. christiansees

    Downloads Controller

    Hello All, I am working on updating osCommerce 2.2 Milestone 2 Update 060817 to v2.2 RC2a. This is on a php5 system I orginally had a problem with a 1054 tep stop error you can see that thread Here. The problem that I am having now is that the download link is not showing on check out. There is nothing wrong with the configuration of the store as the links would show previous to the update and the configuration has not changed I also checked the download controller to update it to ver. 5.3. Any and all suggestions are appreciated. Thanks
  7. christiansees

    [Contribution] STS v4

    Hello Bill, Thanks so much for your help, and the internet exploder add on link. Turns out that you were right. It was not a STS template error, even though I had modified the template. It was an error in the index.php page. Some times just having some one else say "try looking here" helps when I have been looking at the same code, and staring right at the error and just can't see it. So thanks again.
  8. christiansees

    [Contribution] STS v4

    Hi, I really do need some help with this I have been looking at the code for days and have yet to resolve this dilemma. I am wondering why there have been no replies when I see so many others getting such excellent help. Is there more information that I should post? Was this covered in depth else where? If so please tell me where. I have tried looking through this forum. 192 pages is too much for me to read all of it. Thanks
  9. christiansees

    [Contribution] STS v4

    Hello Everyone, I am writing because I having a problem with how the info boxes column displays when navigating a category with nested sub-categories. For some reason the content drops below the main content rather than displaying along side it. You can see the problem here verses what it should look like here When I check the html the difference that accounts for this first the error case. <!-- start Default Content //--> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading">Our K Catalog</td> </tr> </table></td> </tr> <tr> <td><img src="images/pixel_trans.gif" border="0" alt="" width="100%" height="10"></td> </tr> <tr> <td><!-- new_release //--> Next the code where it displays correctly <!-- start Default Content //--> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td><!-- new_release //--> What is confusing me is I can't see where the </table> is being suppressed. Is it the php call or the STS template. Also the code that creates the error looks right while the code that doesn't does not look right. The only thing I can figure is that the master table that all the others are being nested in is being terminated too soon. Any help or suggestions are much appreciated. Thanks
  10. christiansees

    [Contribution] STS v4

    Hello All, Please excuse if this is a repeat. I tried both the forum search and google but got nonsense results. I have found and error in the file catalog\admin\modules.php on line 136 of the Dec 16 release it says @include(DIR_FS_CATALOG_LANGUAGES it should read include(DIR_FS_CATALOG_LANGUAGES Hope that helps
  11. christiansees

    [Contribution] - USPS Methods

    I don't know if this helps with the Parcel post quotes being higher but I found two errors in the latest uploads of this contribution. Line 95 reads if($shipping_pounds > 35 || $shipping_ounces < 6){ and it should read if($shipping_pounds > 35 || ($shipping_pounds == 0 && $shipping_ounces < 6)){ Line 280 reads default: $usps_server = 'testing.shippingapis.com'; $api_dll = 'ShippingAPITest.dll'; and it should read default: $usps_server = 'stg-production.shippingapis.com'; $api_dll = 'shippingapi.dll'; Ignore me if I'm wrong, but I think that the top line should help as it is part of the "ismachinable" test Thanks for the contribution and the updates to keep the USPS in line. Christian
  12. christiansees

    [CONTRIBUTION] Admin products paging

    Hello All, I am still having problems with this contribution I am wondering if there is anyone still helping with it? The current issue is this error 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'limit 0, 30' at line 1 limit 0, 30 [TEP STOP] on this page http://www.oursite.com/Shop/admin/categories.php? PHP Version 5.2.4 Any help would be appreciated. Thanks
  13. christiansees

    [CONTRIBUTION] Admin products paging

    Hello, I have installed the latest version posted to the contribution page http://www.oscommerce.com/community/contributions,1965 The one posted by Patty. I still have the problem of being redirected to the first page of the category rather than the page with the item selected from the search. For example if I search for heavy and I get a search results page with 13 items. If I select the 11th item and it should be on the 10th page of the "H" category I am sent to the 1st page of the "H" category instead. I know that this bug was posted here before. It seems that there were other bugs that were addressed and this one was lost in the mix. thanks Christian
  14. christiansees

    Modifying checkout_shipping.php

    menriquez thanks for your responce. I wish I could take your suggestion but I don't have PHP on a development box.
  15. christiansees

    Modifying checkout_shipping.php

    Hello All, I am trying to add a warning message to the checkout_shipping.php page and would like a second opinion about my code this maybe useful to anyone wishing to do the same. On the Catalog/checkout_shipping.php between lines 309 and 310 I have added this code if (module=usps && ($order->delivery['country_id'] != STORE_COUNTRY)){ ?> <tr> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td class="main" colspan="3"><?php echo TEXT_ENTER_SHIPPING_WARNING; ?></td> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> </tr> <?php } And on line 29 of Catalog/includes/languages/english/checkout_shipping.php I have added define('TEXT_ENTER_SHIPPING_WARNING', 'We can NOT ship LPs or any vinyl Global Priority Mail choose another method'); What I hope to accomplish is if the customer is shipping internationally and using USPS that this warning message will display. Please let me know if you think my code will work, or what my errors are. This can be used by anyone you would just have to change the conditions of the if statement to suit your needs and the text of the warning message. Thanks Christian
  16. christiansees

    Modifying checkout_shipping.php

    Found another error in my if statement should be if (['module']==usps && ($order->delivery['country_id'] != STORE_COUNTRY)){ Any responce from others would be nice.
  17. christiansees

    Modifying checkout_shipping.php

    Woops change the if statement to if (['module']=usps && ($order->delivery['country_id'] != STORE_COUNTRY)){
  18. christiansees

    [Contribution] - USPS Methods

    I don't get why people are still scratching their heads about this one. 1st the question was answered earlier in the thread. 2nd It says right on it "Flat Rate" that means only one rate, where as parcel is implied to by a variable rate, obviously if the weight gets high enough the variable rate will go higher than the flat rate for the same items.
  19. christiansees

    [Contribution] - USPS Methods

    Hello All, It would be nice to have insurance as an option that the customer chooses or not. But we'll see won't we? My question is that I recently upgraded to the latest version to comply with the changs the postal service made on Jan 8th. Previously I was able to edit Line 58 in cataloge/includes/modules/shipping/usps.php from 'Priority Lg' => 'Global Priority Mail - Flat-rate Envelope (Large)', to 'Priority Lg' => 'Global Priority Mail - Can NOT fit LP records', Now when I try to do the same thing to line 52 (the exact same line) in the new version the option drops off the screen for the customer. It is a trivial change I know but it saves us a lot of headaches from customer trying to cheap out on the shipping. When we can't ship what they ordered that way. Any help is much appreciated. Thanks
  20. christiansees

    Embed Links with SID in Description

    Thanks so much Steve works perfectly now. That's what I get for trying to do more when I'm over tired.
  21. christiansees

    Embed Links with SID in Description

    Ok I tried again and this time the result url was http://www.krecs.com/Shop/%%http://www.kre...ducts_id=1333%% the code was <p>Buy the Album<a href="%%http://www.krecs.com/Shop/product_info.php?products_id=1333%%"> HERE</a></p> It seems that the url from the database isn't being parsed at all by the function. I checked the product_info.php and the changes there were correct. Thanks
  22. christiansees

    Embed Links with SID in Description

    Hello Steve, thanks for the contribution. It is exactly what I need as I would like links to other products within the product description of different products. So I installed it exactly as instructed. But I am getting a 404 error and the following url in the address bar http://www.krecs.com/product_info.php/cPat...d/206?$sid the following code is what has been entered into the description. <p>Buy the Album <a href="%%http://www.krecs.com/Shop/product_info.php?cPath=21_31&products_id=206%%">HERE</a></p> Any help is much apprciated. Thanks Christian
  23. christiansees

    [Contribution] - USPS Methods

    Have you tried adding the flat rate shipping method that comes standard with OScom?
  24. christiansees

    free shipping question

    Hello All, I hope that I can get some help with this problem. I have installed all the download controller files v5.0 including free shipping and free payment except for the files which conflicted my other installed contributions, big images, authorize.net 1.8, and USPS 1.7, which are admin/orders.php, catalog/checkout_process.php I have gotten everything to work except for the download links do not show up in the check out success or the order history instead I get this error 1054 - Unknown column 'DOWNLOAD_AVAILABLE_DATE' in 'field list' SELECT DATE_FORMAT(DOWNLOAD_AVAILABLE_DATE, '%Y-%m-%d') as date_purchased_day, opd.download_maxdays, op.products_name, opd.orders_products_download_id, opd.orders_products_filename, opd.download_count, opd.download_maxdays FROM orders o, orders_products op, orders_products_download opd WHERE customers_id = '2' AND o.orders_status >= DOWNLOADS_AVAILABLE_STATUS AND o.orders_id = '1001' AND op.orders_id = '1001' AND opd.orders_products_id=op.orders_products_id AND opd.orders_products_filename<>'' [TEP STOP] I only installed the file that were new for this contribution because it seems that they were coded from MileStone 1 files and I wasn't going to overwrite the newer versions of the files included with MS2.2 which is what I am using. Your time is much appreciated. Christian
  25. christiansees

    Big Images Contribution Problem

    The problem with the popup image loading the thumb and not the big image was that the popup_image.php file had failed to upload. I still have the problem with the login request being repeated when changing pages in the admin section. christian
×