make "specials" module and "bestsellers" module always display

[win8win]

how to make "specials" module and "bestsellers" module always display at the left or right side?
when I go to product page,they auto disappear,

[Ajeh]

Specials is designed to turn off when there is a products_id in the URL ...

You can change this with your templates and overrides by copying the:
/includes/modules/sideboxes/specials.php

to your templates and overrides directory:
/includes/modules/sideboxes/your_templates_dir/specials.php

and adding the code in RED:

  if (isset($_GET['products_id'])) {
    $show_specials= false;
  } else {
    $show_specials= true;
  }

// bof: force specials to always show
  $show_specials= true;
// eof: force specials to always show

  if ($show_specials == true) {

For the Best Sellers sidebox you can customize it similarly with the code in RED:

  } else {
    $show_best_sellers= true;
  }

// bof: force best_sellers to always show
    $show_best_sellers= true;
// eof: force best_sellers to always show

  if ($show_best_sellers == true) {

[win8win]

thanks so much for " Ajeh",it works!

[Ajeh]

You are most welcome ... thanks for the update that this worked for you ...

[DivaVocals]

You are most welcome ... thanks for the update that this worked for you ...

This is awesome and is pretty close to what it was I wanted to do. The best sellers sidebox displays on most pages, and it looks like it displays best seller in the product category I am viewing.. (which is very cool) However, if there are no bestsellers in a particular product category, the best sellers sidebox won't display.. In the case where the category being viewed has no best sellers, how would I modify this so that it displays ALL the store best sellers??

[Ajeh]

The top of the IF is being used when there is a category set based on the value of:
$current_category_id

If that isn't set, then the bottom half of the IF is used ...

What you want to do is after the $sql is run the add this IF below it to test if anything was found, and if not, run a copy of the same select that would be run had there been no $current_category_id defined with:

  if ($best_sellers->RecordCount () == 0) {
      $best_sellers_query = "select distinct p.products_id, pd.products_name, p.products_ordered
                             from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
                             where p.products_status = '1'
                             and p.products_ordered > 0
                             and p.products_id = pd.products_id
                             and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
                             order by p.products_ordered desc, pd.products_name
                             limit " . MAX_DISPLAY_BESTSELLERS;
  }

You should be able to add that just above the:

} else {

see if that gets what you are looking for ...