Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

ringo667

Members
  • Content count

    62
  • Joined

  • Last visited

Everything posted by ringo667

  1. Hello, i search for a contrib that sort Products by a List an not by a Dropdown an i find this: http://addons.oscommerce.com/info/8592 Can someone help to make this fitting for 2.3.3.4 BS?
  2. ringo667

    sort by List, not by drop down in index

    <?php // optional Product List Filter if (isset($HTTP_GET_VARS['manufacturers_id'])) { $filterlist_sql = "select distinct c.categories_id as id, cd.categories_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' order by cd.categories_name"; } else { $filterlist_sql= "select distinct m.manufacturers_id as id, m.manufacturers_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$current_category_id . "' order by m.manufacturers_name"; } $filterlist_query = tep_db_query($filterlist_sql); if (tep_db_num_rows($filterlist_query) > 1) { ?> <div class="panel-body text-center"> <? if (isset($HTTP_GET_VARS['manufacturers_id'])) { echo '<div class="panel panel-default" style="width:100%"><div class="panel-heading gradient"><center><h1>' . $catname. '</h1></center></div><br> <div class="">';} else { echo '<div class="panel panel-default" style="width:100%"><div class="panel-heading gradient"><center><h1>' . $catname . '</h1></center></div> <br><div class="">';} if (isset($HTTP_GET_VARS['manufacturers_id'])) { ?> <a class="btn btn-default" href="<?=tep_href_link(FILENAME_DEFAULT, 'manufacturers_id=' . $HTTP_GET_VARS['manufacturers_id'])?>"><?=TEXT_ALL_CATEGORIES?></a> <? } else { ?> <a class="btn btn-default" href="<?=tep_href_link(FILENAME_DEFAULT, 'cPath=' . $cPath)?>"><?=TEXT_ALL_MANUFACTURERS?></a> <? } while ($filterlist = tep_db_fetch_array($filterlist_query)) { if (isset($HTTP_GET_VARS['manufacturers_id'])) { $filter_keys = 'manufacturers_id=' . $HTTP_GET_VARS['manufacturers_id']; } else { $filter_keys = 'cPath=' . $cPath; } $filter_keys .= '&sort=' . $HTTP_GET_VARS['sort']; $filter_keys .= '&filter_id=' . $filterlist['id']; ?> <a class="btn btn-<? if(isset($_GET['filter_id']) && $_GET['filter_id'] == $filterlist['id']) {echo 'gradient';} else { echo 'default';} ?>" href="<?=tep_href_link(FILENAME_DEFAULT, $filter_keys)?>"><span class="filter_name"><?=$filterlist['name']?></span></a> <? } ?> <br> <br> </div></div></div> <?php } ?> So it works for me in the index.php with Buttons... Maybe someone can use this.
  3. ringo667

    shop by price

    Hello, where can I shorten the long description in listing?
  4. ringo667

    shop by price

    thx for this contrib but the Listing do not work Alll links are like this: http://www.++++++++++.de/-p-.html?slave_id=170
  5. I have insalled this adon: http://addons.oscommerce.com/info/9327 It works fine, but i need a litle extension i want to show radmom Image in the subcategory above the Product List. How must i change the Database request? i have try this, but it doesn´t work: $products_query = tep_db_query("SELECT p.products_image FROM products_to_categories cp inner join products p on cp.products_id = p.products_id and p.products_status = 1 and p.products_image is not null WHERE cp.categories_id ='".(int)$catid."' ORDER BY RAND() LIMIT 3"); thx for help
  6. it dont work, there are no changes.
  7. yes http://t1p.de/047f http://t1p.de/tp8h
  8. thx for help application_top.php shopping_cart.php
  9. i tink i have a Session Problem. if i choose a Slave Produkt the modal open. But the Modal dont open with a Normal- or Master Produkt and with the buy now Button in Produkt listing. What ist the Problem?
  10. small note: if some one use Master Products and the Customer choose zero Products, the Modal open with no Products. Solution: i have insert in cm_footer_modal_cart.php at line 85: if ($cart->count_contents() == 0) { $cart_contents_string .= MODULE_CONTENT_FOOTER_MODAL_CART_TEXT_ALERT;} and defined this in the langue file. Maybe this is for some one usefull. B) thx
  11. thx, but i think i have the same problem like the Header serch bar. Wich code i must write in footer.php to get the Modal content <?php echo $oscTemplate->getContent('content_footer'); ?> does not work...
  12. ringo667

    Store Search Bar (BS)

    .... but i have see a little Bug with the german Umlaute äö Whwn i click "View more products on search page.." there are no Products found
  13. ringo667

    Store Search Bar (BS)

    now it works, thx :)
  14. ringo667

    Store Search Bar (BS)

    Great Contrib, thanks. I use an older Version of OSC BS How can i get the Search bar in the "boxes_header" Group? I Use the Group "header" only in index with the Page Carousel Banner Slider Module
  15. ringo667

    Google XML Sitemap SEO

    http://short4u.de/558fb1c4eb42b
  16. ringo667

    Google XML Sitemap SEO

    My categories stie mal generate double entrys, can someone help?
  17. now i cant edit the file, there is no delimiter
  18. the fiel url_redirects_status was not updated, after the upload from the csv file. all other fields are updated...
  19. thanx you. i have insalled the new Version. Now it works. Another question: how can i show the prices with the German Tax Info?
  20. Thanks a Million, now the Box shows the Products. but i have find two Errors. When i switch the price off it happens a Database 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 'from products_description pd, products p ' at line 1 select p.products_id, from products_description pd, products p left join specials s on p.products_id = s.products_id where p.products_id in (1651,1887,54,546,1928,1725) and p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '2' [TEP STOP] The Links on /recently_viewed.php do not working. /-p-.html?slave_id=1928
×