banner_box_all add problem

[dvenzo]

i tried refering to the regular banners and see how it was setup and applied it to the 2 banner_box_all modules... but still no luck...

can anyone help me out please?

thank you in advance

[Ajeh]

What setting do you have for:

  $new_banner_search = zen_build_banners_group(SHOW_BANNERS_GROUP_SET_ALL); 

In the tpl_ file?

Did that change to:
SHOW_BANNERS_GROUP_SET_ALL2

And does that have its own settings somewhere?

[dvenzo]

thank you in advance for helping ajeh!

heres what i am looking at.

/www/includes/modules/sideboxes/banner_box_all2.php

<?php
/**
 * banner_box2 sidebox - second box used to display "square" banners in sideboxes
 *
 * @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: banner_box2.php 3133 2006-03-07 23:39:02Z ajeh $
 */

// test if box should display
  $show_banner_box2 = true;
  if (SHOW_BANNERS_GROUP_SET8 == '') {
    $show_banner_box2 = false;
  }

  if ($show_banner_box2 == true) {
    $banner_box[] = TEXT_BANNER_BOX2;
    $banner_box_group= SHOW_BANNERS_GROUP_SET8;

    require($template->get_template_dir('tpl_banner_box2.php',DIR_WS_TEMPLATE, $current_page_base,'sideboxes'). '/tpl_banner_box2.php');

// if no active banner in the specified banner group then the box will not show
// uses banners in the defined group $banner_box_group
    if ($banner->RecordCount() > 0) {

      $title =  BOX_HEADING_BANNER_BOX2;
      $title_link = false;
      require($template->get_template_dir($column_box_default, DIR_WS_TEMPLATE, $current_page_base,'common') . '/' . $column_box_default);
    }
  }
?>

/www/includes/templates/template_default/sideboxes/tpl_banner_box_all2.php

<?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_banner_box_all2.php 2982 2006-02-07 07:56:41Z birdbrain $
 */
    $content = '';
    $content .= '<div id="' . str_replace('_', '-', $box_id . 'Content') . '" class="sideBoxContent centeredContent">';
// select banners_group to be used
  $new_banner_search = zen_build_banners_group(SHOW_BANNERS_GROUP_SET_ALL2);

  // secure pages
  switch ($request_type) {
    case ('SSL'):
      $my_banner_filter=" and banners_on_ssl= " . "1 ";
      break;
    case ('NONSSL'):
      $my_banner_filter='';
      break;
  }

  $sql = "select banners_id from " . TABLE_BANNERS . " where status = 1 " . $new_banner_search . $my_banner_filter . " order by banners_sort_order";
  $banners_all = $db->Execute($sql);



// if no active banner in the specified banner group then the box will not show
  $banner_cnt = 0;
  while (!$banners_all->EOF) {
    $banner_cnt++;
    $banner = zen_banner_exists('dynamic', SHOW_BANNERS_GROUP_SET_ALL2);
    $content .= zen_display_banner('static', $banners_all->fields['banners_id']);
// add spacing between banners
    if ($banner_cnt < $banners_all->RecordCount()) {
      $content .= '<br /><br />';
    }
    $banners_all->MoveNext();
  }
  $content .= '</div>';
?>

Thanks again for your kind help^^

Becky L

[Ajeh]

banner_box2.php or did you mean to post a copy of the clone you made for banner_box_all.php ...

[dvenzo]

hi ajeh~

i wanted a second banner_box_all for my site, so I cloned the original banner_box_all and renamed it and its content in both the template and modules area.

i renamed it banner_box_all2.php

in my admin, the banner_box_all2 shows, but under layout setting in config, the option is not there to rename the banner destination.

[Ajeh]

You need to configure something to indicate the Banner Group(s) used by the new banner_box_all2 ...

[dvenzo]

yeah...

i already designated groups for all of the banner boxes already in configuration>layout settings...

but the banner_box_all2 isnt coming up in layout settings so I cant designate a group for it.

[dvenzo]

banner_box2.php or did you mean to post a copy of the clone you made for banner_box_all.php ...

opps.. yeah the first one was the regular banner_box_all

[Ajeh]

The Banners Box All uses this sql statement to add itself to the Layout Settings:

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) VALUES ('Banner Display Group - Side Box banner_box_all', 'SHOW_BANNERS_GROUP_SET_ALL', 'BannersAll', 'The Banner Display Group may only be from one (1) Banner Group for the Banner All sidebox<br /><br />Default Group is BannersAll<br /><br />What Banner Group do you want to use in the Side Box - banner_box_all?<br />Leave blank for none', '19', '72', '', '', now()); 

You can adapt this INSERT to work with your new configuration_key for the:
SHOW_BANNERS_GROUP_SET_ALL2

This will allow you to configure it in the Layout Settings as well as ensure that it is loaded at the right time to work with your new sidebox ... providing all else is coded correctly ...

[dvenzo]

im really sorry ajeh,

where do i insert the adapted sql statement into?