Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2007
    Posts
    132
    Plugin Contributions
    0

    Default Prevent a main category from showing on "latest/specials" on main page ?

    As the topic says, is there a way I can prevent one of my main categories (and it's subcategories) from showing on the specials and latest products in the main page ?

    Carlos

  2. #2
    Join Date
    Jul 2007
    Posts
    132
    Plugin Contributions
    0

    Default Re: Prevent a main category from showing on "latest/specials" on main page ?

    my knowledge of PHP is poor, but do I assume correctly that is a metter of putting a call here to ignore certain categories ? (modules/specials_index.php)

    PHP Code:
    if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) {
      
    $specials_index_query "select p.products_id, p.products_image, pd.products_name
                               from (" 
    TABLE_PRODUCTS " p
                               left join " 
    TABLE_SPECIALS " s on p.products_id = s.products_id
                               left join " 
    TABLE_PRODUCTS_DESCRIPTION " pd on p.products_id = pd.products_id )
                               where p.products_id = s.products_id and p.products_id = pd.products_id and p.products_status = '1' and s.status = 1 and pd.language_id = '" 
    . (int)$_SESSION['languages_id'] . "'";
    } else {
      
    $specials_index_query "select distinct p.products_id, p.products_image, pd.products_name
                               from (" 
    TABLE_PRODUCTS " p
                               left join " 
    TABLE_SPECIALS " s on p.products_id = s.products_id
                               left join " 
    TABLE_PRODUCTS_DESCRIPTION " pd on p.products_id = pd.products_id ), " .
      
    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_id = s.products_id and p.products_id = pd.products_id and p.products_status = '1' and s.status = '1' and pd.language_id = '" 
    . (int)$_SESSION['languages_id'] . "'";


    or is it here to affect ALL "specials" enties, such as the box on the main page also

    functions/specials.php
    Last edited by NullMind; 21 Sep 2007 at 09:19 PM.

 

 

Similar Threads

  1. Remove "Save 5% off" from main category
    By Ivan Yeo in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 2
    Last Post: 14 Nov 2013, 02:09 AM
  2. "Upcoming Products" not showing up on main page.
    By glorykid in forum General Questions
    Replies: 0
    Last Post: 20 Mar 2011, 08:21 PM
  3. where to change "specials" text on main page
    By bigkev890 in forum Templates, Stylesheets, Page Layout
    Replies: 3
    Last Post: 23 Feb 2011, 02:42 AM
  4. Display the "more" link for specials product on main page?
    By Cindy2010 in forum Templates, Stylesheets, Page Layout
    Replies: 1
    Last Post: 4 Feb 2011, 01:10 AM
  5. "Forum Latest Posts" Sidebox on main page of store
    By Crooked_Halo in forum Basic Configuration
    Replies: 0
    Last Post: 16 Aug 2008, 10:24 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR