Sidebox to show for particular pricing group

[TouranMan]

I've searched all over and cannot find a solution to this so I'm posting in th hope someone can help me!

I've added an extra sidebox using the 'Blank Sidebox' download but I want that to show only to a certain pricing group.

The code for the box is:

if ($show_blank_sidebox == true) {
      require($template->get_template_dir('tpl_blank_sidebox.php',DIR_WS_TEMPLATE, $current_page_base,'sideboxes'). '/tpl_blank_sidebox.php');
      $title =  BOX_HEADING_BLANK_SIDEBOX;
      $title_link = false;
      require($template->get_template_dir($column_box_default, DIR_WS_TEMPLATE, $current_page_base,'common') . '/' . $column_box_default);
 } 

so I altered the first line like:

if ($show_blank_sidebox == true) and ($customers_group = '1') { 

I know it's probably not correct as it's not working but hopefully you can see what I am trying to achieve! Just a simple check to see if the logged in person is a member of a particular pricing group and if it is then display the sidebox.

Any help would be appreciated!

[TouranMan]

OK, managed to figure this one out!

I added a new query to check if the currently logged in customer belongs to a particular pricing group and if so, only displays the sidebox to that pricing group:

$show_blank_sidebox = true;
  $group_query = $db->Execute("select customers_group_pricing from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$_SESSION['customer_id'] . "'");

  if (($show_blank_sidebox == true) && ($group_query->fields['customers_group_pricing'] == '1')) {
      require($template->get_template_dir('tpl_blank_sidebox.php',DIR_WS_TEMPLATE, $current_page_base,'sideboxes'). '/tpl_blank_sidebox.php');
      $title =  BOX_HEADING_BLANK_SIDEBOX;
      $title_link = false;
      require($template->get_template_dir($column_box_default, DIR_WS_TEMPLATE, $current_page_base,'common') . '/' . $column_box_default);
 }