Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

problems with tables


luigicosta

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

Link to comment
Share on other sites

  • 2 weeks later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...