Jump to content

Spiderpl

Members
  • Content count

    9
  • Joined

  • Last visited

  1. Hi, i'm using Show Sub-categories with onmouse over v2 contribution. My category list look like this: CATEGORY1 ---SUBCATEGORY1 ------SUB_SUBCATEGORY1 ------SUB_SUBCATEGORY2 ---SUBCATEGORY2 and so on... I would love to obtain this effect: When i click on Subcategory1, in Menu will shown SUB_SUBCATEGORY1 and SUB_SUBCATEGORY2. Now the menu show always only categories, and subcategories. When i click on subcategories - menu doesnt change. What should I chage to obtain this effect ?
  2. Spiderpl

    Cieto Featured Products 2.1 - 1054

    I forgot about source: $featured_products_query_raw = "select distinct p.products_id, pd.products_name, p.products_image, p.products_tax_class_id, pd.products_description, s.status as specstat, s.specials_new_products_price, p.products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' left join featured f on p.products_id = f.products_id where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . $featured_products_category_id . "' and p.products_status = '1' and f.status = '1' order by rand() DESC limit " . MAX_DISPLAY_FEATURED_PRODUCTS; // Cambiar featured con TABLE_FEATURED
  3. I've got problem with Cieto Featured Products 2.1. When i'm in mainpage everything is ok. But when i'm in category, there is an error displayed: 1054 - Unknown column 'p.products_id' in 'on clause' select distinct p.products_id, pd.products_name, p.products_image, p.products_tax_class_id, pd.products_description, s.status as specstat, s.specials_new_products_price, p.products_price from products p left join specials s on p.products_id = s.products_id, products_to_categories p2c, categories c left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join featured f on p.products_id = f.products_id where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '556' and p.products_status = '1' and f.status = '1' order by rand() DESC limit 10 [TEP STOP] It's from Cieto Featured Products . I've made all intructions for mysql 5 and php5. But i cant fix it in Cieto Featured Products. I'll aprecieate any help.
  4. Spiderpl

    Custom Computer Creator v9 Support

    Any ideas? It's imprtant to me.
  5. Spiderpl

    Custom Computer Creator v9 Support

    I want, CCC show subtotal netto(without tax) and brutto (with tax). What change I have to do ? I've got CCC 9.3.1. any ideas ?
  6. Spiderpl

    Custom Computer Creator v9 Support

    Hi, i've got one problem with ccc 9.3.1. I set in CCC config " Pictures On By Default" to yes. I ran ccc.php , it appears "Would You Like Pictures To Be Displayed?" (there is yes selected). I want to change from yes to no, but i cant. I change back to yes. The same situation is, when in CCC Config "Pictures On By Default" is to no selected. What to do, to solve this problem ? P.S. I know, my weak english ;)
×