Jump to content
Sign in to follow this  
luigicosta

problems with tables

Recommended Posts

someone can tell me where mistake?

thanks

<?php
/*
 $Id$
 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com
 Copyright (c) 2010 osCommerce
 Released under the GNU General Public License
*/
 class bm_categories {
   var $code = 'bm_categories';
   var $group = 'boxes';
   var $title;
   var $description;
   var $sort_order;
   var $enabled = false;
   function bm_categories() {
  $this->title = MODULE_BOXES_CATEGORIES_TITLE;
  $this->description = MODULE_BOXES_CATEGORIES_DESCRIPTION;
  if ( defined('MODULE_BOXES_CATEGORIES_STATUS') ) {
    $this->sort_order = MODULE_BOXES_CATEGORIES_SORT_ORDER;
    $this->enabled = (MODULE_BOXES_CATEGORIES_STATUS == 'True');
    $this->group = ((MODULE_BOXES_CATEGORIES_CONTENT_PLACEMENT == 'Left Column') ? 'boxes_column_left' : 'boxes_column_right');
  }
   }
   function tep_show_category($counter) {
  global $tree, $categories_string, $cPath_array;
  for ($i=0; $i<$tree[$counter]['level']; $i++) {
    $categories_string .= "  ";
  }
  $categories_string .= '<a href="';
  if ($tree[$counter]['parent'] == 0) {
    $cPath_new = 'cPath=' . $counter;
  } else {
    $cPath_new = 'cPath=' . $tree[$counter]['path'];
  }
  $categories_string .= tep_href_link(FILENAME_DEFAULT, $cPath_new) . '">';
  if (isset($cPath_array) && in_array($counter, $cPath_array)) {
    $categories_string .= '<strong>';
  }
// display category name
  $categories_string .= $tree[$counter]['name'];
  if (isset($cPath_array) && in_array($counter, $cPath_array)) {
    $categories_string .= '</strong>';
  }
  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 /></td></tr></table><table border="0" cellpading="7" cellspacing="7" align="left"><tr><td>'  . tep_image(DIR_WS_IMAGES .  '/freccia.jpg'). '' ;
  if ($tree[$counter]['next_id'] != false) {
    $this->tep_show_category($tree[$counter]['next_id']);
  }
   }
   function getData() {
  global $categories_string, $tree, $languages_id, $cPath, $cPath_array;
  $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;
	  }
    }
  }
  $this->tep_show_category($first_element);

  $data = '<div>' .
		  '<div><h1>' . MODULE_BOXES_CATEGORIES_BOX_TITLE . '</h1></div>' .
		  '<div><h3>' . tep_image(DIR_WS_IMAGES .  '/freccia.jpg') . $categories_string . '</h3></div>' .
		  '<div>' . tep_image(DIR_WS_IMAGES .  '/iconsocial.jpg',"seguici su facebook") . '</div>' .
		  '</div>';
  return $data;
   }
   function execute() {
  global $SID, $oscTemplate;
  if ((USE_CACHE == 'true') && empty($SID)) {
    $output = tep_cache_categories_box();
  } else {
    $output = $this->getData();
  }
  $oscTemplate->addBlock($output, $this->group);
   }
   function isEnabled() {
  return $this->enabled;
   }
   function check() {
  return defined('MODULE_BOXES_CATEGORIES_STATUS');
   }
   function install() {
  tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Enable Categories Module', 'MODULE_BOXES_CATEGORIES_STATUS', 'True', 'Do you want to add the module to your shop?', '6', '1', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())");
  tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Content Placement', 'MODULE_BOXES_CATEGORIES_CONTENT_PLACEMENT', 'Left Column', 'Should the module be loaded in the left or right column?', '6', '1', 'tep_cfg_select_option(array(\'Left Column\', \'Right Column\'), ', now())");
  tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Sort Order', 'MODULE_BOXES_CATEGORIES_SORT_ORDER', '0', 'Sort order of display. Lowest is displayed first.', '6', '0', now())");
   }
   function remove() {
  tep_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key in ('" . implode("', '", $this->keys()) . "')");
   }
   function keys() {
  return array('MODULE_BOXES_CATEGORIES_STATUS', 'MODULE_BOXES_CATEGORIES_CONTENT_PLACEMENT', 'MODULE_BOXES_CATEGORIES_SORT_ORDER');
   }
 }
?>

 

http://www.clubsoccershirt.com/index.php

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×