<?php

/*

  $Id: categories.php,v 1.21 2002/07/03 09:48:06 dgw_ Exp $



  osCommerce, Open Source E-Commerce Solutions

  http://www.oscommerce.com



  Copyright (c) 2002 osCommerce



  Released under the GNU General Public License

*/



  function tep_show_category($counter) {

    global $foo, $categories_string, $id;



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

      $categories_string .= "&nbsp;&nbsp;";

    }



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

    }



// display category name

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



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

      $categories_string .= '</b>';

    }



    if (tep_has_category_subcategories($counter)) {

      $categories_string .= '-&gt;';

    }



    $categories_string .= '</a>';



    if (SHOW_COUNTS == 'true') {

      $products_in_category = tep_count_products_in_category($counter);

      if ($products_in_category > 0) {

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

      }

    }



    $categories_string .= '<br>';



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

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

    }

  }

?>

<tr>

<td>

<TABLE cellSpacing=0 cellPadding=0 width="100%">

                    <TBODY>

                    <TR>

                      <TD colSpan=3 width="179"  valign="top" align="left"><IMG alt=Categories

                       src="images/box title/categories.gif"></TD></TR>

                    <TR>

                              <TD width=5

                      background="images/test/itweb_25.gif"><IMG

                        height="1"

                        src="/pixel_trans.gif" width="5"

                        ></TD>

                      <TD vAlign="top" width="171" align="center">

                        <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>

                          <TBODY>

                          <TR>

                            <TD>

                              <TABLE cellSpacing=0

                              cellPadding=0 width="100%" border=0>

                                <TBODY>



                                <TR>



                      <TD>

<?php

  $info_box_contents = array();

  $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>   </TD>

                    </TR>

                                </TBODY></TABLE></TD></TR></TBODY></TABLE></TD>



      <TD

                       width="4" height="1"><IMG

                        height=1

                        src="images/pixel_trans.gif"

                        width=4></TD>

    </TR>

                    </TBODY></TABLE>

       </tr>

<!-- categories_eof //-->