customer sidebox per page

[Jerry5763837]

hi, everyone,

Does anybody can help me to fix this problem?

I just want to enabe certain sidebox for certain page.
for example: only need best_seller sidebox for contact us page.
firstly, i disabled whole left & right sidebox for contact_us page by adding following code to
includes\templates\my_templates\contact_us\tpl_main_page.php

if ($current_page_base == 'contact_us') {
$flag_disable_right = true;
$flag_disable_left = true;

then, i pasted code from D:\my website\includes\modules\sideboxes\best_sellers.php
to contact_us page through Admin--Tools---Page define editor,

<?php
/**
* Side Box Template
*
* @package templateSystem
* @copyright Copyright 2003-2005 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: tpl_best_sellers.php 2982 2006-02-07 07:56:41Z birdbrain $
* @version $Id: tpl_best_sellers.php 2982 2007-12-15 21:00:00 TRUST IT - www.trustit.ca - [email protected] $
*/

// test if box should display
$show_best_sellers= false;

if (isset($_GET['products_id'])) {
    if (isset($_SESSION['customer_id'])) {
   $check_query = "select count(*) as count
           from " . TABLE_CUSTOMERS_INFO . "
           where customers_info_id = '" . (int)$_SESSION['customer_id'] . "'
           and global_product_notifications = '1'";

   $check = $db->Execute($check_query);

   if ($check->fields['count'] > 0) {
    $show_best_sellers= true;
   }
  }
} else {
  $show_best_sellers= true;
}

if ($show_best_sellers == true) {
  if (isset($current_category_id) && ($current_category_id > 0)) {
   $best_sellers_query = "select distinct p.products_id, p.products_image, pd.products_name, p.products_price, p.products_ordered
              from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, "
                  . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c
              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'] . "'
              and p.products_id = p2c.products_id
              and p2c.categories_id = c.categories_id
              and '" . (int)$current_category_id . "' in (c.categories_id, c.parent_id)
              order by p.products_ordered desc, pd.products_name
              limit " . MAX_DISPLAY_BESTSELLERS;

   $best_sellers = $db->Execute($best_sellers_query);

  } else {
   $best_sellers_query = "select distinct p.products_id, p.products_image, pd.products_name, p.products_price, 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;

   $best_sellers = $db->Execute($best_sellers_query);
  }

  if ($best_sellers->RecordCount() >= MIN_DISPLAY_BESTSELLERS) {
   $title = BOX_HEADING_BESTSELLERS;
   $box_id = bestsellers;
   $rows = 0;
   while (!$best_sellers->EOF) {
    $rows++;
    $bestsellers_list[$rows]['id'] = $best_sellers->fields['products_id'];
    $bestsellers_list[$rows]['name'] = $best_sellers->fields['products_name'];
   $bestsellers_list[$rows]['image'] = $best_sellers->fields['products_image'];
    $bestsellers_list[$rows]['price'] = $best_sellers->fields['products_price'];
    $best_sellers->MoveNext();
   }

   $left_corner = false;
   $right_corner = false;
   $right_arrow = false;
   $title_link = false;
   require($template->get_template_dir('tpl_best_sellers.php',DIR_WS_TEMPLATE, $current_page_base,'sideboxes'). '/tpl_best_sellers.php');
   $title = BOX_HEADING_BESTSELLERS;
   require($template->get_template_dir($column_box_default, DIR_WS_TEMPLATE, $current_page_base,'common') . '/' . $column_box_default);
  }
}
?>

when open contact_us page in browser, error occured:
could you please help to check how to fix it? thanks.
Warning: main(includes/templates/my_templates/contact_us//php) [function.main]: failed to open stream: No such file or directory in includes\languages\english\html_includes\my_templates\define_contact_us.php on line 84

[Jerry5763837]

hi,

i know have to modify the following code:

require($template->get_template_dir('tpl_best_sellers.php',DIR_WS_TEMPLATE, $current_page_base,'sideboxes'). '/tpl_best_sellers.php');
   $title = BOX_HEADING_BESTSELLERS;
   require($template->get_template_dir($column_box_default, DIR_WS_TEMPLATE, $current_page_base,'common') . '/' . $column_box_default);
  }
}
?>

but do not know exactly how to modify.

could you please check? many appreciated.

[Ajeh]

To not show the best sellers sidebox on the contact_us page you can edit the sidebox module for it with this code:

// don't show on contact_us page
if ($current_page_base == 'contact_us') {
    $show_best_sellers= false;
}

Put it above this line:

  if ($show_best_sellers == true) {

[Jerry5763837]

Hi, Ajeh,

anyhow many thanks for your suggestion.
maybe you misunderstand, sorry for my confusion.

I just want to enabe certain sidebox for certain page.
for example: to enable bestseller sidebox only for contact_us page.

and the following is how i enable it:
firstly, i disabled whole left & right sidebox for contact_us page by adding following code to
includes\templates\my_templates\contact_us\tpl_main_page.php

if ($current_page_base == 'contact_us') {
$flag_disable_right = true;
$flag_disable_left = true;

then, i pasted code from \includes\modules\sideboxes\best_sellers.php
to contact_us page through Admin--Tools---Page define editor,

<?php
/**
* Side Box Template
*
* @package templateSystem
* @copyright Copyright 2003-2005 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: tpl_best_sellers.php 2982 2006-02-07 07:56:41Z birdbrain $
* @version $Id: tpl_best_sellers.php 2982 2007-12-15 21:00:00 TRUST IT - www.trustit.ca - [email protected] $
*/

// test if box should display
$show_best_sellers= false;

if (isset($_GET['products_id'])) {
    if (isset($_SESSION['customer_id'])) {
   $check_query = "select count(*) as count
           from " . TABLE_CUSTOMERS_INFO . "
           where customers_info_id = '" . (int)$_SESSION['customer_id'] . "'
           and global_product_notifications = '1'";

   $check = $db->Execute($check_query);

   if ($check->fields['count'] > 0) {
    $show_best_sellers= true;
   }
  }
} else {
  $show_best_sellers= true;
}

if ($show_best_sellers == true) {
  if (isset($current_category_id) && ($current_category_id > 0)) {
   $best_sellers_query = "select distinct p.products_id, p.products_image, pd.products_name, p.products_price, p.products_ordered
              from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, "
                  . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c
              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'] . "'
              and p.products_id = p2c.products_id
              and p2c.categories_id = c.categories_id
              and '" . (int)$current_category_id . "' in (c.categories_id, c.parent_id)
              order by p.products_ordered desc, pd.products_name
              limit " . MAX_DISPLAY_BESTSELLERS;

   $best_sellers = $db->Execute($best_sellers_query);

  } else {
   $best_sellers_query = "select distinct p.products_id, p.products_image, pd.products_name, p.products_price, 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;

   $best_sellers = $db->Execute($best_sellers_query);
  }

  if ($best_sellers->RecordCount() >= MIN_DISPLAY_BESTSELLERS) {
   $title = BOX_HEADING_BESTSELLERS;
   $box_id = bestsellers;
   $rows = 0;
   while (!$best_sellers->EOF) {
    $rows++;
    $bestsellers_list[$rows]['id'] = $best_sellers->fields['products_id'];
    $bestsellers_list[$rows]['name'] = $best_sellers->fields['products_name'];
   $bestsellers_list[$rows]['image'] = $best_sellers->fields['products_image'];
    $bestsellers_list[$rows]['price'] = $best_sellers->fields['products_price'];
    $best_sellers->MoveNext();
   }

   $left_corner = false;
   $right_corner = false;
   $right_arrow = false;
   $title_link = false;
   require($template->get_template_dir('tpl_best_sellers.php',DIR_WS_TEMPLATE, $current_page_base,'sideboxes'). '/tpl_best_sellers.php');
   $title = BOX_HEADING_BESTSELLERS;
   require($template->get_template_dir($column_box_default, DIR_WS_TEMPLATE, $current_page_base,'common') . '/' . $column_box_default);
  }
}
?>

as last, when open contact_us page in browser,
error occured:

Warning: main(includes/templates/my_templates/contact_us//php) [function.main]: failed to open stream: No such file or directory in includes\languages\english\html_includes\my_templates\define_contact_us.php on line 84

any further question??
this errors definitely resulted from the code

require($template->get_template_dir('tpl_best_sellers.php',DIR_WS_TEMPLATE, $current_page_base,'sideboxes'). '/tpl_best_sellers.php');
   $title = BOX_HEADING_BESTSELLERS;
   require($template->get_template_dir($column_box_default, DIR_WS_TEMPLATE, $current_page_base,'common') . '/' . $column_box_default);
  }
}
?>

could you please hele how to modify?

[Ajeh]

You are doing way too much work for this ...

Just work with the sidebox module itself ...

To enable it for only the contact_us page use the code like this:

// don't show on contact_us page
if ($current_page_base == 'contact_us') {
// show it
    $show_best_sellers= true;
} else {
// do not show it
    $show_best_sellers= false;
}
  
  if ($show_best_sellers == true) {

Now it can only show on contact_us ...

[Jerry5763837]

hi, Ajeh,

Great, it works. how genious you are.


Another question about the best_seller sidebox, can you please help for me at www.topalways.com??

on the main page, i disabled right column. then paste the best_seller side box code at the top right of the main page, which uses the mould $column_box_default,

now i want to make the bestseller sidebox wider, but it agree with the width of $column_box_default,

Is it possible to fix this problem? mayn appreciated.

[Jerry5763837]

Anybody there?
Could you please help me to check what is the problem?

Many thanks in advance.

[Jerry5763837]

hi, Ajeh,

are you there? could you please help to check above problem?

appreciated.