please help to solve this category problem

sampathkumara · November 5, 2008

Hi,

I have install this category contribution on http://www.25jewelry.com

This is nice contribution and its shows sub categories when click on main category but i need to show sub categories

when muse over on main category.

below is the my code of include/boxes/categoris.php

please anyone can help me to do this.

what section need to be edit on both categories.php and style.css, please help.

Many Thanks

<?php

/*

$Id: categories.php,v 1.25 2003/07/09 01:13:58 hpdl Exp $

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

Released under the GNU General Public License

changed August 2003, by Nils Petersson

contribution "Category Box Enhancement", version 1.1

*/

function tep_show_category($counter) {

// BoF - Contribution Category Box Enhancement 1.1

global $tree, $categories_string, $cPath_array, $cat_name;

for ($i=0; $i<$tree[$counter]['level']; $i++) {

$categories_string .= " ";

}

$cPath_new = 'cPath=' . $tree[$counter]['path'];

if (isset($cPath_array) && in_array($counter, $cPath_array) && $cat_name == $tree[$counter]['name']) { //Link nicht anklickbar, wenn angewählt

$categories_string .= '<a href="';

$categories_string .= tep_href_link(FILENAME_DEFAULT, $cPath_new) . '">'; //Link nicht anklickbar, wenn angewählt

} else { //Link nicht anklickbar, wenn angewählt

$categories_string .= '<a href="';

$categories_string .= tep_href_link(FILENAME_DEFAULT, $cPath_new) . '">';

} //Link nicht anklickbar, wenn angewählt

if (tep_has_category_subcategories($counter)) {

$categories_string .= tep_image(DIR_WS_IMAGES . 'pointer_blue.gif', '');

}

else {

$categories_string .= tep_image(DIR_WS_IMAGES . 'pointer_blue_light.gif', '');

}

if (isset($cPath_array) && in_array($counter, $cPath_array)) {

$categories_string .= '';

}

if ($cat_name == $tree[$counter]['name']) {

$categories_string .= '';

}

// display category name

$categories_string .= $tree[$counter]['name'];

if ($cat_name == $tree[$counter]['name']) {

$categories_string .= '';

}

if (isset($cPath_array) && in_array($counter, $cPath_array)) {

$categories_string .= '';

}

// EoF Category Box Enhancement

$categories_string .= '</a>';

if (SHOW_COUNTS == 'true') {

$products_in_category = tep_count_products_in_category($counter);

if ($products_in_category > 0) {

$categories_string .= ' (' . $products_in_category . ')';

}

$categories_string .= ' ';

if ($tree[$counter]['next_id'] != false) {

tep_show_category($tree[$counter]['next_id']);

}

?>

<tr>

<td>

<?php

// BoF - Contribution Category Box Enhancement 1.1

if (isset($cPath_array)) {

for ($i=0, $n=sizeof($cPath_array); $i<$n; $i++) {

$categories_query = tep_db_query("select categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '" . (int)$cPath_array[$i] . "' and language_id = '" . (int)$languages_id . "'");

if (tep_db_num_rows($categories_query) > 0)

$categories = tep_db_fetch_array($categories_query);

}

$cat_name = $categories['categories_name'];

}

// EoF Category Box Enhancement

// display category name

$info_box_contents = array();

$info_box_contents[] = array('text' => BOX_HEADING_CATEGORIES);

new infoBoxHeading($info_box_contents, true, false);

$categories_string = '';

$tree = array();

$categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='" . (int)$languages_id ."' order by sort_order, cd.categories_name");

while ($categories = tep_db_fetch_array($categories_query)) {

$tree[$categories['categories_id']] = array('name' => $categories['categories_name'],

'parent' => $categories['parent_id'],

'level' => 0,

'path' => $categories['categories_id'],

'next_id' => false);

if (isset($parent_id)) {

$tree[$parent_id]['next_id'] = $categories['categories_id'];

}

$parent_id = $categories['categories_id'];

if (!isset($first_element)) {

$first_element = $categories['categories_id'];

}

//------------------------

if (tep_not_null($cPath)) {

$new_path = '';

reset($cPath_array);

while (list($key, $value) = each($cPath_array)) {

unset($parent_id);

unset($first_id);

$categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$value . "' and c.categories_id = cd.categories_id and cd.language_id='" . (int)$languages_id ."' order by sort_order, cd.categories_name");

if (tep_db_num_rows($categories_query)) {

$new_path .= $value;

while ($row = tep_db_fetch_array($categories_query)) {

$tree[$row['categories_id']] = array('name' => $row['categories_name'],

'parent' => $row['parent_id'],

'level' => $key+1,

'path' => $new_path . '_' . $row['categories_id'],

'next_id' => false);

if (isset($parent_id)) {

$tree[$parent_id]['next_id'] = $row['categories_id'];

}

$parent_id = $row['categories_id'];

if (!isset($first_id)) {

$first_id = $row['categories_id'];

}

$last_id = $row['categories_id'];

}

$tree[$last_id]['next_id'] = $tree[$value]['next_id'];

$tree[$value]['next_id'] = $first_id;

$new_path .= '_';

} else {

break;

}

tep_show_category($first_element);

$info_box_contents = array();

$info_box_contents[] = array('text' => $categories_string);

if ( (basename($PHP_SELF) != FILENAME_SPECIALS)) {

$info_box_contents[] = array('align' => 'left',

'text' => '<a href="' . tep_href_link(FILENAME_SPECIALS, '', 'NONSSL') . '">' . BOX_INFORMATION_SPECIALS . '</a>');

}else{

$info_box_contents[] = array('align' => 'left',

'text' => '<a href="' . tep_href_link(FILENAME_SPECIALS, '', 'NONSSL') . '">' . BOX_INFORMATION_SPECIALS . '</a>');

}

if ( (basename($PHP_SELF) != FILENAME_PRODUCTS_NEW)) {

$info_box_contents[] = array('align' => 'left',

'text' => '<a href="' . tep_href_link(FILENAME_PRODUCTS_NEW, '', 'NONSSL') . '">' . BOX_INFORMATION_PRODUCTS_NEW . '</a>');

}else{

$info_box_contents[] = array('align' => 'left',

'text' => '<a href="' . tep_href_link(FILENAME_PRODUCTS_NEW, '', 'NONSSL') . '">' . BOX_INFORMATION_PRODUCTS_NEW . '</a>');

}

function tep_get_paths($categories_array = '', $parent_id = '0', $indent = '', $path='') {

global $languages_id;

if (!is_array($categories_array)) $categories_array = array();

$categories_query = tep_db_query("select c.categories_id, cd.categories_name from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where parent_id = '" . (int)$parent_id . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name");

while ($categories = tep_db_fetch_array($categories_query)) {

if ($parent_id=='0'){

$categories_array[] = array('id' => $categories['categories_id'],

'text' => $indent . $categories['categories_name']);

}

else{

$categories_array[] = array('id' => $path . $parent_id . '_' .$categories['categories_id'],

'text' => $indent . $categories['categories_name']);

}

if ($categories['categories_id'] != $parent_id) {

$this_path=$path;

if ($parent_id != '0')

$this_path = $path . $parent_id . '_';

$categories_array = tep_get_paths($categories_array, $categories['categories_id'], $indent . ' ', $this_path);

}

return $categories_array;

}

$info_box_contents[] = array('form' => '<form action="' . tep_href_link(FILENAME_DEFAULT) . '" method="get">' . tep_hide_session_id(),

'align' => 'left',

'text' => '' . BOX_DROPDOWN_MENUS . ' ' . tep_draw_pull_down_menu('cPath', tep_get_paths(array(array('id' => '', 'text' => PULL_DOWN_DEFAULT))), $cPath, 'onchange="this.form.submit();" style="width: 100%"')

);

new infoBox($info_box_contents);

?>

</td>

</tr>

please help to solve this category problem

Recommended Posts

sampathkumara

Link to comment

Share on other sites

Archived

Browse

Activity