Hide What's New and Best Sellers Sideboxes

[Ajeh]

I don't know where your code is but this:
mysite.com/mytemplate/includes/modules/sideboxes/mytemplate/

is not a valid path ...

you see the:
/your_secret_admin
/download
/images
/includes

Now go to:
/includes/modules/sideboxes

copy the file:
/includes/modules/sideboxes/whats_new.php

to your templates and overrides directory for modules in:
/includes/modules/sideboxes/your_template_dir/whats_new.php

and then add the customizations ...

follow the same method for the best_sellers.php ...

[AirsoftOutfitter]

I don't know where your code is but this:
mysite.com/mytemplate/includes/modules/sideboxes/mytemplate/

is not a valid path ...

you see the:
/your_secret_admin
/download
/images
/includes

Now go to:
/includes/modules/sideboxes

copy the file:
/includes/modules/sideboxes/whats_new.php

to your templates and overrides directory for modules in:
/includes/modules/sideboxes/your_template_dir/whats_new.php

and then add the customizations ...

follow the same method for the best_sellers.php ...

I do have the "What's New" and "Best Sellers" sideboxes in my template override folder located here:

mysite.com/includes/modules/sideboxes/mytemplate/

The alterations to "Best Sellers" works fine, but the "What's New" is no good...

[Ajeh]

Do you see errors or do you just see the What's New on the Home Page?

[AirsoftOutfitter]

Do you see errors or do you just see the What's New on the Home Page?

Just the what's new on the home page

[Ajeh]

And your file:
/includes/modules/sideboxes/your_template_dir/whats_new.php

looks like:

<?php
/**
 * whats_new sidebox - displays a random "new" product
 *
 * @package templateSystem
 * @copyright Copyright 2003-2010 Zen Cart Development Team
 * @copyright Portions Copyright 2003 osCommerce
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: whats_new.php 15880 2010-04-11 16:24:30Z wilt $
 */


// bof: turn off whats_new on home page
if ($this_is_home_page) {
    $show_whats_new= false;
} else {
    $show_whats_new= true;
}
// eof: turn off whats_new on home page

// display limits
// $display_limit = zen_get_products_new_timelimit();
  $display_limit = zen_get_new_date_range();
  $random_whats_new_sidebox_product_query = "select p.products_id, p.products_image, p.products_tax_class_id, p.products_price, pd.products_name,
                                              p.master_categories_id
                           from (" . TABLE_PRODUCTS . " p
                           left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id )
                           where p.products_id = pd.products_id
                           and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
                           and p.products_status = 1 " . $display_limit;

//  $random_whats_new_sidebox_product = zen_random_select($random_whats_new_sidebox_product_query);
  $random_whats_new_sidebox_product = $db->ExecuteRandomMulti($random_whats_new_sidebox_product_query, MAX_RANDOM_SELECT_NEW);

  if ($show_whats_new && $random_whats_new_sidebox_product->RecordCount() > 0 ) {
    require($template->get_template_dir('tpl_whats_new.php',DIR_WS_TEMPLATE, $current_page_base,'sideboxes'). '/tpl_whats_new.php');
    $title =  BOX_HEADING_WHATS_NEW;
    $title_link = FILENAME_PRODUCTS_NEW;
    require($template->get_template_dir($column_box_default, DIR_WS_TEMPLATE, $current_page_base,'common') . '/' . $column_box_default);
  }

[AirsoftOutfitter]

And your file:
/includes/modules/sideboxes/your_template_dir/whats_new.php

looks like:

<?php
/**
 * whats_new sidebox - displays a random "new" product
 *
 * @package templateSystem
 * @copyright Copyright 2003-2010 Zen Cart Development Team
 * @copyright Portions Copyright 2003 osCommerce
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: whats_new.php 15880 2010-04-11 16:24:30Z wilt $
 */


// bof: turn off whats_new on home page
if ($this_is_home_page) {
    $show_whats_new= false;
} else {
    $show_whats_new= true;
}
// eof: turn off whats_new on home page

// display limits
// $display_limit = zen_get_products_new_timelimit();
  $display_limit = zen_get_new_date_range();
  $random_whats_new_sidebox_product_query = "select p.products_id, p.products_image, p.products_tax_class_id, p.products_price, pd.products_name,
                                              p.master_categories_id
                           from (" . TABLE_PRODUCTS . " p
                           left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id )
                           where p.products_id = pd.products_id
                           and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
                           and p.products_status = 1 " . $display_limit;

//  $random_whats_new_sidebox_product = zen_random_select($random_whats_new_sidebox_product_query);
  $random_whats_new_sidebox_product = $db->ExecuteRandomMulti($random_whats_new_sidebox_product_query, MAX_RANDOM_SELECT_NEW);

  if ($show_whats_new && $random_whats_new_sidebox_product->RecordCount() > 0 ) {
    require($template->get_template_dir('tpl_whats_new.php',DIR_WS_TEMPLATE, $current_page_base,'sideboxes'). '/tpl_whats_new.php');
    $title =  BOX_HEADING_WHATS_NEW;
    $title_link = FILENAME_PRODUCTS_NEW;
    require($template->get_template_dir($column_box_default, DIR_WS_TEMPLATE, $current_page_base,'common') . '/' . $column_box_default);
  }

All the same execpt for the bold section: I have this because I am excluding what's new from the Product ID pages as well.

// $random_whats_new_sidebox_product = zen_random_select($random_whats_new_sidebox_product_query);
$random_whats_new_sidebox_product = $db->ExecuteRandomMulti($random_whats_new_sidebox_product_query, MAX_RANDOM_SELECT_NEW);

if ($show_whats_new && $random_whats_new_sidebox_product->RecordCount() > 0 ) {
}

if (!isset($_GET['products_id']) && $random_whats_new_sidebox_product->RecordCount() > 0 ) {
require($template->get_template_dir('tpl_whats_new.php',DIR_WS_TEMPLATE, $current_page_base,'sideboxes'). '/tpl_whats_new.php');
$title = BOX_HEADING_WHATS_NEW;
$title_link = FILENAME_PRODUCTS_NEW;
require($template->get_template_dir($column_box_default, DIR_WS_TEMPLATE, $current_page_base,'common') . '/' . $column_box_default);
}

[Ajeh]

This code does nothing ...

if ($show_whats_new && $random_whats_new_sidebox_product->RecordCount() > 0 ) {
}

You are trying to do more than first explained ...

First, remove this code:

// bof: turn off whats_new on home page
if ($this_is_home_page) {
    $show_whats_new= false;
} else {
    $show_whats_new= true;
}
// eof: turn off whats_new on home page

Then, change your code in bold to:

if (!this_is_home_page && !isset($_GET['products_id']) && $random_whats_new_sidebox_product->RecordCount() > 0 ) {

[AirsoftOutfitter]

Perfect that worked! I figured that code did nothing, but I couldn't figure out how to properly set up the code to exclude home page and product ID but what you recommended worked perfect. Thanks.

I want to add Promotional Boxes on the right side of the home page, so should I use banner boxes, or just code in GIF images?

[Ajeh]

Depends on what all you want to do ...

You could add conditions to the Banner sidebox to limit its use to the Home page in a similar manner ...

[AirsoftOutfitter]

Depends on what all you want to do ...

You could add conditions to the Banner sidebox to limit its use to the Home page in a similar manner ...

Could you mind providing me the code to do so? I am wanting to have about 3-4 promo boxes. Just things that say free shipping on orders, or to highlight a new product, etc.