Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

LioMandi

Members
  • Content count

    104
  • Joined

  • Last visited

Posts posted by LioMandi


  1. NVM - Got it to work! Here is the solution for anyone else with this problem:

     

    In file attributeManagerConfig.class.php just find line

    CODE

    $this->add('AM_USE_SORT_ORDER'

    - that is around line 59

     

    In 2.5 it reads as

    CODE

    $this->add('AM_USE_SORT_ORDER' , true);

    ,

    and in 2.4 by default it is set to false, so just change it in 2.5 to

    CODE

    $this->add('AM_USE_SORT_ORDER' , false);

     

    and there won't be any errors regarding Unknown column 'products_options_sort_order' in 'order clause'


  2. Does anyone have a solution for this problem? THis error appears after I installed the contrib:

     

    1054 - Unknown column 'products_options_sort_order' in 'order clause'
    
    select * from products_options where language_id='1' order by products_options_sort_order

     

    Please help me sort this out, thanks.


  3. Ok, first time i checked the BUGS section of oscommerce's site and i found my problem ! :D now it works nicely so far!

     

    change the

    if (empty($default) && isset($GLOBALS[$name])) $default = stripslashes($GLOBALS[$name]);

    to

    if ( ($default == '' && $GLOBALS[$name] == $values[$i]['id']) || ($default == $values[$i]['id']) );

     

     

    Thanks!! This worked like a charm!


  4. Hi, I'm having a problem and am getting this error:

     

    Fatal error: Cannot redeclare tep_show_category () (previously declared in ***/includes/categories.php: 13) in ***/includes/boxes/categories.php on LINE 64

     

    Dont know what seems to be wrong with categories.php

    But here is the code for it...

     

    <?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
    
     Copyright (c) 2003 osCommerce
    
     Released under the GNU General Public License
    */  
    
    function tep_show_category($counter) {
    global $tree, $categories_string, $cPath_array;
    
    $categories_string .= '<tr><td height="20" class="categor">';
    
    $otstup = 0;
    for ($i=0; $i<$tree[$counter]['level']; $i++) {
      $categories_string .= tep_draw_separator('pixel_trans.gif', '10', '1');
      $otstup = 1;
    }
    if ($otstup){		$categories_string .= tep_draw_separator('pixel_trans.gif', '10', '1') . '<a class="categor" href="';	
    } else {
    $categories_string .= tep_image(DIR_WS_IMAGES . 'marker100.jpg','','3','5','style="margin:0 8px 0 14px"') . '<a class="categor" 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 .= '<b>';
    }
    
    // display category name
    $categories_string .= $tree[$counter]['name'];
    
    if (isset($cPath_array) && in_array($counter, $cPath_array)) {
      $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 .= '</td></tr>';
    
    $categories_string .= '<tr><td height="2" valign="top">' . tep_image(DIR_WS_IMAGES . 'LineCategot.jpg','','','','style="margin-left:10px"') . '</td></tr>';
    
    if ($tree[$counter]['next_id'] != false) {tep_show_category($tree[$counter]['next_id']);
    }
     }
    ?>
    <!-- categories //-->
    
    <?php
     //$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);
     $info_box_contents[] = array('align' => 'right',
    						   'text'  => '<font size=-2><a  class="categorTop2" href="' . tep_href_link(FILENAME_ALLPRODS, '', 'NONSSL') . '">' .tep_image(DIR_WS_IMAGES . 'pixel_trans.gif','','3','5','style="margin:10px 8px 0 14px"') .  BOX_INFORMATION_ALLPRODS . '</a></font>');
     new infoBox($info_box_contents);
    ?>
    
    <!-- categories_eof //-->

×