Jump to content

gaspower

Members
  • Content count

    453
  • Joined

  • Last visited

Everything posted by gaspower

  1. gaspower

    Seperate Pricing Per Customer v3.5

    Hello, Installing the contribution Hide Products From SPPC. In the file catalog/includes/application_top.php it says to replace, $model_query = tep_db_query("select products_model from " . TABLE_PRODUCTS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'"); with // BOF SPPC Hide products and categories from groups $model_query = tep_db_query("select p.products_model from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c using(products_id) left join " . TABLE_CATEGORIES . " c using(categories_id) where p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and find_in_set('".$customer_group_id."', products_hide_from_groups) = 0 and find_in_set('" . $customer_group_id . "', categories_hide_from_groups) = 0"); // EOF SPPC Hide products and categories from groups But, I do not have the original $model_query in the breadcrumb trail? Mu breadcrumb trail is, // add the products name to the breadcrumb trail if (isset($HTTP_GET_VARS['products_id'])) { $name_query = tep_db_query("select products_name, products_description from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] ."' and language_id = '" . (int)$languages_id . "'"); if (tep_db_num_rows($name_query)) { $name = tep_db_fetch_array($name_query); $breadcrumb->add($name['products_name'], tep_href_link(FILENAME_PRODUCT_INFO, 'cPath=' . $cPath . '&products_id=' . $HTTP_GET_VARS['products_id'])); $keywordtag .= $keywordsep . $name['products_name']; $titletag .= $seperator; $titletag .= substr(preg_replace('[^a-zA-Z0-9]',' ',(strip_tags($name['products_name']))),0,100); $description = substr(preg_replace('[^a-zA-Z0-9]',' ',(strip_tags($name['products_description']))),0,300); Thanks JR
  2. Hello, I am using version 3.2. All works fine except that it does not matter is I type upper or lower case, it sends the contact page through? It does not seem to see the upper or lower case letters. Thanks JR
  3. gaspower

    Official PayPal IPN Support Thread

    Hello, I am using Paypal IPN 2.3.4.7 on RC2A. All works fine except for the confirmation email sent to the sites admin. I get a copy of all other orders processed by Authorize.net etc. Is there a fix to get a confirmation emails from Paypal IPN? Thanks JR
  4. gaspower

    Seperate Pricing Per Customer v3.5

    Sorry, Quick question, am I changing that "Null" in the corresponding code ( $customer_group_id . "' and customers_group_price != null");) or in the database? Thanks JR
  5. gaspower

    Seperate Pricing Per Customer v3.5

    Thank you, Will give that a try. JR
  6. gaspower

    Seperate Pricing Per Customer v3.5

    Hello, I narrowed it down a little. For some reason the system is not ready (.$customer_group_id."' and customers_group_price != null");) correctly. Having an issue with "null"? When I revert back to original, site works fine? Any ideas? Thanks JR
  7. gaspower

    Seperate Pricing Per Customer v3.5

    Hello, Just noticed an issue, and I am using SPPC 4.2.2 and SPPC Price Break on RC2A. I have gone through the code and just can not point out where the issue may lie. On product_lising, if I do not have any quantity discounts set in the admin, and I am logged in as a dealer with discount rate, it only shows retail and not dealer pricing. As soon as I add quantity for discounting, it will show "As Low As" and correct pricing. Why is it not showing dealer pricing without quantities? Also not getting dealer pricing showing in specials and new products. Product_info works fine. Thanks JR
  8. gaspower

    Seperate Pricing Per Customer v3.5

    Hey Jan, Thanks so much. The includes/languages/english/product_listing.php was corrupt, replaced it and so far all seems to be working fine. Very nice contribution. One question, actually a thought for the QPBPP for the Product Listing page. Currently if a search is done and the product is listed, under price it says "from" whatever price. And, if you proceed with Buy It Now, you are taken to the shopping cart, with no information on the discount structure, so the customer does not see the quantity pricing schedule. As a thought, I think it would be nice if a product in Product Lising has a quantity discount associated to it, the Buy It Now button takes you to the Product Info page so customer can see the discount structure, or in shopping cart for that particular product it shows the discount table shown in Product info. Thanks again for a great contribution JR
  9. gaspower

    Seperate Pricing Per Customer v3.5

    Hello Jan, Need some help please with QPBPP. All seems to be going well until product_listings.php. As soon as I add, require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PRODUCT_LISTING); (before) $listing_split = new splitPageResults($listing_sql, MAX_DISPLAY_SEARCH_RESULTS, 'p.products_id'); The site breaks? Thanks JR
  10. Hello, I was just wondering what the latest version of DCC is for MS2.2 RC2A? I see version 3.34, but says for version 2.31. Also does the latest version support SPPC ( Separate Pricing Per Customer). Thanks JR
  11. gaspower

    Seperate Pricing Per Customer v3.5

    Hello, Strange issue happening. For some reason, in admin customers, when I choose a customer group, I can not get option subscribe to take effect. After saving, option subscribe defaults back to unsubscribe. For some reason, it is not writing option to database? Thanks JR
  12. gaspower

    [Contribution] - USPS Methods

    Hello, Issue solved and my overlook. I am using Special Pricing Per Customer, and in the config for that contribution, USPS was turned off. USPS Methods 4.3.2 works great. Thanks JR
  13. gaspower

    [Contribution] - USPS Methods

    Hello, I am using OSC MS2.2 and just installed 4.3.2, and for some reason it is not showing in checkout? I am getting no errors? I have read through the install a few times, but sure I am missing something simple. Any help would be great. I also tried some of the Alpha's, but still no luck? I also noticed, that when I installed the alpha's, I no longer get the setup in the admin, like insurance configuration and check boxes for shipping methods? Are they all default in the code now in Alpha? Thanks JR
  14. Sorry, Meant to say in last post, thanks again for all the help. JR
  15. Hello, I am using version 2.76i, and all works fine except for one thing. When I import, the model numbers always import in lowercase. I can change upper or lower case in any other field and it imports correctly. What would be the cause of this one field always importing to lowercase? Thanks JR EP vers: 2.76i-MS2 osCommerce Online Merchant v2.2 RC2a OS: Linux 2.6.22.14-72.fc6 HTTP: Apache/2.2.6 (Fedora) DB: MySQL 5.0.27 PHP: 5.1.6 (Zend: 2.1.0) Temp Directory: /home/virtual/ofnawarehouse.com/var/www/html/temp/ Temp Dir is Writable Magic Quotes is: off register_globals is: on Split files on: 300 records Model Num Size: 12 Price with tax: false Calc Precision: 2 Replace quotes: false Field seperator: tab Excel safe output: false Preserve tab/cr/lf: false Category depth: 4 Enable attributes: false SEF Froogle URLS: false Other Support: MVS Support: false Additional Images: false More Pics: false UltraPics Pics: false HTC: false SPPC: true Extra Fields: false PDF Upload: false
  16. gaspower

    Seperate Pricing Per Customer v3.5

    Hello, Need a little help wit modules/product_listing.php. Trying to use the below code to remove the buy it now button if inventory is zero. I know I am missing something simple, but with the below code get NON_ONLINE_ITEM on all listings in product_listings, not just the items with zero inventory? case 'PRODUCT_LIST_BUY_NOW': $lc_align = 'center'; if ( $listing[$x]['products_quantity'] > 0 ){ $lc_text = '<a href="' . tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $listing[$x]['products_id']) . '">' . tep_image_button('button_buy_now.gif', IMAGE_BUTTON_BUY_NOW) . '</a> '; }else{ $lc_text = NON_ONLINE_ITEM; } break; Thanks JR
  17. Hello, I am using Tinymce within OSC. I am seeing that Tinymce when used in the admin/categories, that when finished it is and a page is created, it is inserting another html start and finish?? Below is a actual past of the view source where OSC inserted the text by Tinymce. Is there away so it does not insert, head, title, and body, it is basically a html inside another html? Thanks JR <p><?xml version="1.0" encoding="utf-8"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en"> <head> <title>Untitled document</title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> </head> <body> <font face="arial,helvetica,sans-serif" size="2" color="#000000">This is a pack of four metal shielded bearings.</font> </body> </html></p>
  18. gaspower

    Seperate Pricing Per Customer v3.5

    Hello Jan, Thanks as always for a great contribution. We are upgrading all our sites to the new rc2a versions. I just wanted to make sure before copying files over, that you upload from from July 20, 2008, version 4.2.2 is compatible for file copy over, or do I need to do a file comparison? Thanks JR
  19. Hello, Was wondering if there is a contribution for specials in admin to allow for a site wide discount? Right now it seems that specials is done by a one by one case. I would like to mark down entire site say at a 20% discount. Thanks JR
  20. Thank you for the pointers. JR
  21. gaspower

    Seperate Pricing Per Customer v3.5

    Hello Jan, Thank you as always. Been great help from the beginning. Will give it a shot. JR
  22. gaspower

    Seperate Pricing Per Customer v3.5

    Hello Jon, Been using SPPC for many years and it has worked flawlessly since first installed, thank you. I have a site we need to add the MSRP contribution, and was wondering if SPPC works with MSRP? We have both retail and wholesale sales. Thanks JR
  23. Hello, I have a site using MS2.2 and have had Authorize running on it for ever, version Nov 19, 2008. All of a sudden in both test and live mode I am getting this message? Also it gives no error. Looked at the code, and no association of error and code message? Did something change at Authorize? Thanks JR (TESTMODE) This transaction cannot be accepted. - Your credit card could not be authorized for this reason. Please correct any information and try again or contact us for further assistance.
  24. gaspower

    [Contribution] TinyMCE Anywhere

    Hello, Can someone tell me how to turn off in admin/categories.php the debug development kit drop down box? Thanks Jr
  25. Thank you for the answer. JR
×