Combine 2 great contributions into 1

dr_lucas · May 29, 2004

Hi,

I have the following categories mod installed on my site (http://www.skpiercing.com). As you can see, this mod create a seperating line, arrows and bullets in the categories box.

I would like to combine it with the second contribution listed below it. This contribution keep the categories tree expanded at all times.

Unfortunately my PHP knowledge is very limited and I couldn't find the correct parts to move and/or combine between the 2 contributions, so I will appreciate any help in creating the correct combined code for a new categories.php and I am sure many will like it as a new contribution.

I truly appreciate any help.

First Mod Code, full categories.php: (seperating line, arrows and bullets in the categories box.)

<?php
/*

$Id: categories.php,v 1.20 2002/06/05 19:18:22 dgw_ Exp $

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

Copyright © 2002 osCommerce

Released under the GNU General Public License

*/

function tep_show_category($counter) {

global $foo, $categories_string, $id, $aa;

for ($a=0; $a<$foo[$counter]['level']; $a++) {

// $categories_string .= "  ";

// $categories_string .= "  ";

}

//kreseczki start

if ($foo[$counter]['level'] == 0)

{

if ($aa == 1)

{

// odchaszowac ?eby dostaז kreseczkך

// $categories_string .= "<hr noshade size=1>";

$categories_string .= '<img src="images/pixel_trans.gif" border="0" alt="" width="100%" height="2"><br><img src="images/pixel_silver.gif" border="0" alt="" width="100%" height="1"><br><img src="images/pixel_trans.gif" border="0" alt="" width="100%" height="2">';

}

else

{$aa=1;}

}

//kreseczki koniec

// display category name

// $categories_string .= $foo[$counter]['name'];

// Eger alt kategorileri veya Asama0 olanalara varsa OK ekler

if (tep_has_category_subcategories($counter) || $foo[$counter]['level'] == 0) {

if ( ($id) && (in_array($counter, $id)) ) {

// display category name

$categories_string .= '<table class="categ"><tr><td class="categ">' . tep_image(DIR_WS_IMAGES . 'categories/arrow_down.gif', '', '9', '9') . " </td>";

} else {

// display category name

$categories_string .= '<table class="categ"><tr><td class="categ">' .tep_image(DIR_WS_IMAGES . 'categories/arrow_right.gif', '', '9', '9') . " </td>";

}

} else {

$categories_string .= '<table class="categ"><tr><td class="categ">  ' .tep_image(DIR_WS_IMAGES . 'categories/arrow_bullet.gif', 'nokta', '9', '9') . "</td>";

}

$categories_string .= '<td class="categ"><a href="';

if ($foo[$counter]['parent'] == 0) {

$cPath_new = 'cPath=' . $counter;

} else {

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

}

$categories_string .= tep_href_link(FILENAME_DEFAULT, $cPath_new);

$categories_string .= '">';

if ( ($id) && (in_array($counter, $id)) ) {

$categories_string .= '<b>';

}

//nazwa kategorii

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

if ( ($id) && (in_array($counter, $id)) ) {

$categories_string .= '</b>';

}

if (tep_has_category_subcategories($counter)) {

$categories_string .= ' ';

}

$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 .= '<br>';

$categories_string .= '</td></tr></table>';

if ($foo[$counter]['next_id']) {

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

}

}

?>



<tr>

<td>

<?php

$info_box_contents = array();

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

'text' => BOX_HEADING_CATEGORIES

);

new infoBoxHeading($info_box_contents, false, false);

$categories_string = '';

$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='" . $languages_id ."' order by sort_order, cd.categories_name");

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

$foo[$categories['categories_id']] = array(

'name' => $categories['categories_name'],

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

'level' => 0,

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

'next_id' => false

);

if (isset($prev_id)) {

$foo[$prev_id]['next_id'] = $categories['categories_id'];

}

$prev_id = $categories['categories_id'];

if (!isset($first_element)) {

$first_element = $categories['categories_id'];

}

}

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

if ($cPath) {

$id = split('_', $cPath);

reset($id);

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

$new_path .= $value;

unset($prev_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 = '" . $value . "' and c.categories_id = cd.categories_id and cd.language_id='" . $languages_id ."' order by sort_order, cd.categories_name");

$category_check = tep_db_num_rows($categories_query);

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

$foo[$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($prev_id)) {

$foo[$prev_id]['next_id'] = $row['categories_id'];

}

$prev_id = $row['categories_id'];

if (!isset($first_id)) {

$first_id = $row['categories_id'];

}

$last_id = $row['categories_id'];

}

if ($category_check != 0) {

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

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

}

$new_path .= '_';

}

}

tep_show_category($first_element);

$info_box_contents = array();

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

'text' => $categories_string

);

new infoBox($info_box_contents);

?>

</td>

</tr>

Second Mod Code, full categories.php: (always expanded categories & subcategories):

<?php
/*

$Id: all_categories.php,v 1.6 2002/04/22 20:34:00 clescuyer Exp $

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com/

Copyright © 2002 Goיlette

Christian Lescuyer <[email protected]>

http://www.goelette.net/

http://oscommerce.goelette.net/

History: 1.1 Creation

1.2 Modified query for compatibility with older databases

1.3 Query in 1.2 was wrong for older databases

1.4 SHOW_COUNTS test corrected

1.5 Added COMPACT_CATEGORIES option to display all sub-categories on one line

1.6 Removed COMPACT_CATEGORIES option

Corrected the cpath generation

Bold categories "path" to selected category, an idea from Peter Frsicht

1.7 Cleaned the way in which the categories are displayed - bold for the path,

">" to indicate the current category, removed link to current category,

only indent subcategories (top level are flush left)

Released under the GNU General Public License

*/

// Keep out parts category

$excluded_parts_category_id = 28;

// Preorder tree traversal

function preorder($cid, $level, $foo, $cpath) {

global $categories_string, $HTTP_GET_VARS;

if ($cid != 0) {

// 1.7 Get the current path info

$category_path = explode('_',$HTTP_GET_VARS['cPath']);

$in_path = in_array($cid, $category_path);

$this_category = array_pop($category_path);

for ($i=0; $i<$level; $i++)

// 1.7 only indent subcategories (top level are flush left)

if ($i>0) {

$categories_string .= ' ';

}

// 1.7 indicate the current category

if ($this_category == $cid) {

$categories_string .= '> ';

}

// 1.7 don't link the current category

if ($this_category != $cid) {

$categories_string .= '<a href="' . tep_href_link(FILENAME_DEFAULT, 'cPath=' . $cpath . $cid) . '">';

}

// 1.6 Are we on the "path" to selected category? If yes, use <b>

if ($in_path) {

$categories_string .= '<b>';

}

$categories_string .= $foo[$cid]['name'];

if ($in_path)

$categories_string .= '</b>';

// 1.7 don't link the current category

if ($this_category != $cid) {

$categories_string .= '</a>';

}

// 1.4 SHOW_COUNTS is 'true' or 'false', not true or false

if (SHOW_COUNTS == 'true') {

$products_in_category = tep_count_products_in_category($cid);

if ($products_in_category > 0) {

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

}

}

$categories_string .= '<br>' ."\n";

}

// Traverse category tree

foreach ($foo as $key => $value) {

if ($foo[$key]['parent'] == $cid) {

// print "$key, $level, $cid, $cpath<br>";

preorder($key, $level+1, $foo, ($level != 0 ? $cpath . $cid . '_' : ''));

}

}

}

?>



<tr>

<td>

<?php

//////////

// Display box heading

//////////

$info_box_contents = array();

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

new infoBoxHeading($info_box_contents, true, false);

//////////

// Get categories list

//////////

// 1.2 Test for presence of status field for compatibility with older versions

$status = tep_db_num_rows(tep_db_query('describe categories status'));

$query = "select c.categories_id, cd.categories_name, c.parent_id

from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd

where c.categories_id = cd.categories_id";

// 1.3 Can't have 'where' in an if statement!

if ($status >0)

$query.= " and c.status = '1'";

$query.= " and cd.language_id='" . $languages_id ."'

order by sort_order, cd.categories_name";

$categories_query = tep_db_query($query);

// Stuff in an array

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

$foo[$categories['categories_id']] = array('name' => $categories['categories_name'], 'parent' => $categories['parent_id']);

}

// Initiate tree traverse

$categories_string = '';

preorder(0, 0, $foo, '');

//////////

// Display box contents

//////////

$info_box_contents = array();

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

new infoBox($info_box_contents);

?>

</td>

</tr>

Combine 2 great contributions into 1

Recommended Posts

dr_lucas

Archived

Browse

Activity