Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

2fix4u

Members
  • Content count

    77
  • Joined

  • Last visited


Reputation Activity

  1. Like
    2fix4u reacted to ronrrico in Product Listing Enhancements, Thumbnails & Manufacturer Headings   
    Thank for the reply Sam, I will try to change the javascrip.
    Once agin, thank you for this awsome contrib!
     
    2fix4u (Harry),
    Kudos to you! I have implemented prettyphoto to my listing, NICE!
     
    Thank..........
  2. Like
    2fix4u reacted to spooks in Product Listing Enhancements, Thumbnails & Manufacturer Headings   
    Global titles is refered to in the doc, the setting is called Display Product Name/Price above all other fields
     
    tep_get_att_price is a function I wrote & use on some sites, I have never released it. It does what it implies.
     
    I don't know TaxInfo
  3. Like
    2fix4u reacted to spooks in Product Listing Enhancements, Thumbnails & Manufacturer Headings   
    1. in grid mode the prod display uses the class .infoBoxGrid modify that
     
    2. Sounds like you have global titles on, turn that off
  4. Like
    2fix4u reacted to spooks in Product Listing Enhancements, Thumbnails & Manufacturer Headings   
    SQL query error in new_products module
     
    Sorry, when you make a big update there can always be stuff you miss in packages this size
     
    find the query
     

    if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) { $new_products_query = "select " . $select_column_list . "p.products_id, p.products_image, p.products_tax_class_id, p.products_price, p.products_quantity from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_date_added > '".$date."' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by p.products_date_added desc"; } else { $new_products_query = "select distinct " . $select_column_list . "p.products_id, p.products_image, p.products_tax_class_id, p.products_price, p.products_quantity from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' and p.products_status = '1' and p.products_date_added > '".$date."' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by p.products_date_added desc"; }
     
    replace with:
     

    if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) { $new_products_query = "select " . $select_column_list . "p.products_id, p.products_image, p.products_tax_class_id, p.products_price, p.products_quantity from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on (p.manufacturers_id = m.manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_date_added > '".$date."' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by p.products_date_added desc"; } else { $new_products_query = "select distinct " . $select_column_list . "p.products_id, p.products_image, p.products_tax_class_id, p.products_price, p.products_quantity from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on (p.manufacturers_id = m.manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' and p.products_status = '1' and p.products_date_added > '".$date."' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by p.products_date_added desc"; }
     
    Surprised no-ones spotted the other bug (not in that file)
     
     
     
    An addition to the next update will be thumbnails with rounded corners, I think a few may like that
  5. Like
    2fix4u reacted to Richard Cranium in [Contribution] Scrolling Customer Testimonials   
    Harry,
     
    Thanks. I'll take a look at that and see if there is anything out of whack there. My site is heavily modded, so it's always a challenge to regress and get these contributions working with stock files. I probably won't have time to fix the MailHide func until tomorrow. Thanks for the additional info.
     
    BTW, in reference to the default language problem you had, you may also want to change the default language for new testimonials. If CST cannot figure out what language a user is, it will default flagging your testimonials in the database as this language code. The default to the contribution is English, but you can change it to anything you want. If you wish to change this, first look up your languages table and find the language_id column for your preferred default. Cross reference that with your preferred language. For example, English is “1”. To edit this setting in the SQL file, change one line.
     
     
    For New Installs, modify the value (i.e., ‘1’) in this line:

    `language_id` int(11) NOT NULL DEFAULT '1',
     
    For Upgrade Installs, modify the value (i.e., ‘1’) in this line:

    ALTER TABLE `customer_testimonials` ADD `language_id` INT( 11 ) NOT NULL DEFAULT '1';
     
     
    Regards,
    David
  6. Like
    2fix4u reacted to Richard Cranium in [Contribution] Scrolling Customer Testimonials   
    Here's another bug fix... until I get v1.1 rolled out. One line of code to change to solve problem where if there are zero testimonials available in the customer's language, the "write a testimonial" box is displayed twice.
     
    1. Open includes\boxes\customer_testimonials.php
     
    2. Remove line 52:
     

    new infoBox($info_box_contents);
×