Jump to content


  • Content count

  • Joined

  • Last visited

Posts posted by gaspower

  1. 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'] . "'");




    // 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 Paypal IPN 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

  3. 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

  4. 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



  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

  6. 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

  7. 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
    HTTP: Apache/2.2.6 (Fedora)
    DB: MySQL 5.0.27
    PHP: 5.1.6 (Zend: 2.1.0)
    Temp Directory:
    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

  8. 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?



    $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> ';


    $lc_text = NON_ONLINE_ITEM;





    Thanks JR

  9. 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>

  10. 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.