
Originally Posted by
pixelpadre
PHP Warning: sizeof(): Parameter must be an array or an object that implements Countable in /home/scanmyid/public_html/352processserver.com/includes/templates/fluorspar/common/tpl_mega_menu.php on line 110
This warning occurs if you don't have any manufacturers on your database or you don't have a product associated with a manufacturer.
This is a fix, open file :- includes/templates/fluorspar/common/tpl_mega_menu.php
Delete these lines from 59 to 123
Code:
<li class="manufacturers-li"><a class="drop" href="#"><?php echo HEADER_TITLE_MANUFACTURERS; ?></a><!--bof shop by brand -->
<div class="dropdown_1column">
<div class="col_1 firstcolumn">
<ul >
<?php
$show_manufacturers= true;
// for large lists of manufacturers uncomment this section
/*
if (($_GET['main_page']==FILENAME_DEFAULT and ($_GET['cPath'] == '' or $_GET['cPath'] == 0)) or ($request_type == 'SSL')) {
$show_manufacturers= false;
} else {
$show_manufacturers= true;
}
*/
// Set to true to display manufacturers images in place of names
define('DISPLAY_MANUFACTURERS_IMAGES',true);
if ($show_manufacturers) {
// only check products if requested - this may slow down the processing of the manufacturers sidebox
if (PRODUCTS_MANUFACTURERS_STATUS == '1') {
$manufacturer_sidebox_query = "select distinct m.manufacturers_id, m.manufacturers_name, m.manufacturers_image
from " . TABLE_MANUFACTURERS . " m
left join " . TABLE_PRODUCTS . " p on m.manufacturers_id = p.manufacturers_id
where m.manufacturers_id = p.manufacturers_id and p.products_status= 1
order by manufacturers_name";
} else {
$manufacturer_sidebox_query = "select m.manufacturers_id, m.manufacturers_name, m.manufacturers_image
from " . TABLE_MANUFACTURERS . " m
order by manufacturers_name";
}
$manufacturer_sidebox = $db->Execute($manufacturer_sidebox_query);
if ($manufacturer_sidebox->RecordCount()>0) {
$number_of_rows = $manufacturer_sidebox->RecordCount()+1;
// Display a list
$manufacturer_sidebox_array = array();
// kuroi: commented out to avoid starting list with text scrolling list entries such as "reset" and "please select"
// if (!isset($_GET['manufacturers_id']) || $_GET['manufacturers_id'] == '' ) {
// $manufacturer_sidebox_array[] = array('id' => '', 'text' => PULL_DOWN_ALL);
// } else {
// $manufacturer_sidebox_array[] = array('id' => '', 'text' => PULL_DOWN_MANUFACTURERS);
// }
while (!$manufacturer_sidebox->EOF) {
$manufacturer_sidebox_name = ((strlen($manufacturer_sidebox->fields['manufacturers_name']) > MAX_DISPLAY_MANUFACTURER_NAME_LEN) ? substr($manufacturer_sidebox->fields['manufacturers_name'], 0, MAX_DISPLAY_MANUFACTURER_NAME_LEN) . '..' : $manufacturer_sidebox->fields['manufacturers_name']);
$manufacturer_sidebox_image = $manufacturer_sidebox->fields['manufacturers_image'];
$manufacturer_sidebox_array[] =
array('id' => $manufacturer_sidebox->fields['manufacturers_id'],
'text' => DISPLAY_MANUFACTURERS_IMAGES ?
zen_image(DIR_WS_IMAGES . $manufacturer_sidebox_image, $manufacturer_sidebox_name) :
$manufacturer_sidebox_name);
$manufacturer_sidebox->MoveNext();
}
}
} // $show_manufacturers
for ($i=0;$i<sizeof($manufacturer_sidebox_array);$i++) {
$content = '';
$content .= '<li ><a class="hide" href="' . zen_href_link(FILENAME_DEFAULT, 'manufacturers_id=' . $manufacturer_sidebox_array[$i]['id']) . '">';
$content .= $manufacturer_sidebox_array[$i]['text'];
$content .= '</a></li>' . "\n";
echo $content;
}
?>
</ul>
</div>
</div>
</li><!-- eof shop by brand -->
And replace with this code :-
Code:
<?php
$manufacturer_sidebox_query = "select m.manufacturers_id
from " . TABLE_MANUFACTURERS . " m
order by manufacturers_name";
$manufacturer_sidebox = $db->Execute($manufacturer_sidebox_query);
if ($manufacturer_sidebox->RecordCount()>0) {
?>
<li class="manufacturers-li"><a class="drop" href="#"><?php echo HEADER_TITLE_MANUFACTURERS; ?></a><!--bof shop by brand -->
<div class="dropdown_1column">
<div class="col_1 firstcolumn">
<ul >
<?php
$show_manufacturers= true;
// for large lists of manufacturers uncomment this section
/*
if (($_GET['main_page']==FILENAME_DEFAULT and ($_GET['cPath'] == '' or $_GET['cPath'] == 0)) or ($request_type == 'SSL')) {
$show_manufacturers= false;
} else {
$show_manufacturers= true;
}
*/
// Set to true to display manufacturers images in place of names
define('DISPLAY_MANUFACTURERS_IMAGES',true);
if ($show_manufacturers) {
// only check products if requested - this may slow down the processing of the manufacturers sidebox
if (PRODUCTS_MANUFACTURERS_STATUS == '1') {
$manufacturer_sidebox_query = "select distinct m.manufacturers_id, m.manufacturers_name, m.manufacturers_image
from " . TABLE_MANUFACTURERS . " m
left join " . TABLE_PRODUCTS . " p on m.manufacturers_id = p.manufacturers_id
where m.manufacturers_id = p.manufacturers_id and p.products_status= 1
order by manufacturers_name";
} else {
$manufacturer_sidebox_query = "select m.manufacturers_id, m.manufacturers_name, m.manufacturers_image
from " . TABLE_MANUFACTURERS . " m
order by manufacturers_name";
}
$manufacturer_sidebox = $db->Execute($manufacturer_sidebox_query);
if ($manufacturer_sidebox->RecordCount()>0) {
$number_of_rows = $manufacturer_sidebox->RecordCount()+1;
// Display a list
$manufacturer_sidebox_array = array();
// kuroi: commented out to avoid starting list with text scrolling list entries such as "reset" and "please select"
// if (!isset($_GET['manufacturers_id']) || $_GET['manufacturers_id'] == '' ) {
// $manufacturer_sidebox_array[] = array('id' => '', 'text' => PULL_DOWN_ALL);
// } else {
// $manufacturer_sidebox_array[] = array('id' => '', 'text' => PULL_DOWN_MANUFACTURERS);
// }
while (!$manufacturer_sidebox->EOF) {
$manufacturer_sidebox_name = ((strlen($manufacturer_sidebox->fields['manufacturers_name']) > MAX_DISPLAY_MANUFACTURER_NAME_LEN) ? substr($manufacturer_sidebox->fields['manufacturers_name'], 0, MAX_DISPLAY_MANUFACTURER_NAME_LEN) . '..' : $manufacturer_sidebox->fields['manufacturers_name']);
$manufacturer_sidebox_image = $manufacturer_sidebox->fields['manufacturers_image'];
$manufacturer_sidebox_array[] =
array('id' => $manufacturer_sidebox->fields['manufacturers_id'],
'text' => DISPLAY_MANUFACTURERS_IMAGES ?
zen_image(DIR_WS_IMAGES . $manufacturer_sidebox_image, $manufacturer_sidebox_name) :
$manufacturer_sidebox_name);
$manufacturer_sidebox->MoveNext();
}
}
} // $show_manufacturers
if(!empty($manufacturer_sidebox_array)) {
for ($i=0;$i<sizeof($manufacturer_sidebox_array);$i++) {
$content = '';
$content .= '<li ><a class="hide" href="' . zen_href_link(FILENAME_DEFAULT, 'manufacturers_id=' . $manufacturer_sidebox_array[$i]['id']) . '">';
$content .= $manufacturer_sidebox_array[$i]['text'];
$content .= '</a></li>' . "\n";
echo $content;
}
}
?>
</ul>
</div>
</div>
</li><!-- eof shop by brand -->
<?php
}
?>
Regards,
Peejay https://www.zenofobe.com
Bookmarks