Jump to content
Latest News: (loading..)

Yepi

Members
  • Content count

    40
  • Joined

  • Last visited

Profile Information

  • Real Name
    Peter
  • Gender
    Male

Recent Profile Visitors

7,995 profile views
  1. Hello Reiner, that's exactly what it's about. I looked at the file and this function already exists. I can not say how the additional costs can be paid with points so that the bill is at 0.00 if ( tep_not_null(MODULE_HEADER_TAGS_POINTS_REWARDS_POINTS_RESTRICTION_PATH) && !tep_not_null(MODULE_HEADER_TAGS_POINTS_REWARDS_POINTS_RESTRICTION_PID) ) { $path_points = 0; for ($i=0; $i<sizeof($order->products); $i++) { $cat_ids = explode("[,]", MODULE_HEADER_TAGS_POINTS_REWARDS_POINTS_RESTRICTION_PATH); $sub_cat_ids = explode("[_]", tep_get_product_path($order->products[$i]['id'])); for ($iii = 0; $iii < count($sub_cat_ids); $iii++) { for ($ii = 0; $ii < count($cat_ids); $ii++) { if ($sub_cat_ids[$iii] == $cat_ids[$ii]) { $path_points = ($order->products[$i]['price']*$order->products[$i]['qty'])+($order->info['shipping_cost']+$order->info['tax']); $max_points = $path_points/MODULE_HEADER_TAGS_POINTS_REWARDS_POINTS_REDEEM_POINT_VALUE; } } } } }
  2. Unfortunately does not work. could it be that the module is loaded directly from the order_total directory?
  3. in contrast, I want that the island surcharge is also paid with points
  4. Ok, thanks Reiner that makes sense, too. This module is for island surcharges. That is, should this surcharge be calculated because the customer lives in a certain place where an extra flat rate is calculated so this flat rate will not be charged with points but remains on the bill as a cash payment
  5. Hello, what can it be, if the customer has selected to pay with points but wants later to use cash. The module can no longer switch to cash. you have to log out first and log in again so that the payment method can be changed Here I still have a module for delivery surcharge but in spite of payment with points is not included and is to be paid at the end total. did temand have a tip for me? <?php /* $Id: ot_inselzuschlag.php,v 2.07 2008/02/19 19:24:11 dabri Exp $ erstellt von: dabri - Daniel Brinkmann Forum: http://forums.oscommerce.de/index.php?showtopic=18397 osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ class ot_inselzuschlag { var $title, $output; function ot_inselzuschlag() { $this->code = 'ot_inselzuschlag'; $this->title = MODULE_ORDER_TOTAL_INSELZUSCHLAG_TITLE; $this->description = MODULE_ORDER_TOTAL_INSELZUSCHLAG_DESCRIPTION; $this->enabled = ((MODULE_ORDER_TOTAL_INSELZUSCHLAG_STATUS == 'true') ? true : false); $this->sort_order = MODULE_ORDER_TOTAL_INSELZUSCHLAG_SORT_ORDER; $this->output = array(); } function process() { global $order, $currencies, $cart; switch (MODULE_ORDER_TOTAL_INSELZUSCHLAG_DESTINATION) { case 'national': if ($order->delivery['country_id'] == STORE_COUNTRY) $pass = true; break; case 'international': if ($order->delivery['country_id'] != STORE_COUNTRY) $pass = true; break; case 'both': $pass = true; break; default: $pass = false; break; } // Variable f?r die Postleitzahl (PLZ) $qResult = tep_db_query("select insel_plz, insel_name, insel_country, insel_fee, insel_step from " . TABLE_INSELPLZ . " WHERE '" . $order->delivery['postcode'] . "' BETWEEN insel_plz AND insel_plz_end AND insel_country = '" . $order->delivery['country_id'] . "'"); $rec = tep_db_fetch_array($qResult); // get the first row of the result $plz_id = $rec['insel_plz']; /* if ( $plz_id == '' ){ $pass = false; } */ if (( $plz_id == '' ) || ($GLOBALS['shipping']['id'] == 'pickup_pickup')) { $pass = false; } if ( $pass == true ) { // Preis fuer Gewicht ermitteln $insel_cost = preg_split("/[:,]/" , $rec['insel_fee']); if ($cart->show_weight() > $insel_cost[count ($insel_cost)-2]) { $inselfee = ($cart->show_weight()-$insel_cost[count ($insel_cost)-2])* $rec['insel_step'] +$insel_cost[count ($insel_cost)-1]; } for ($i = 0; $i < count($insel_cost); $i+=2) { if ($cart->show_weight() <= $insel_cost[$i]) { $inselfee = $insel_cost[$i+1]; break; } } $tax = tep_get_tax_rate(MODULE_ORDER_TOTAL_INSELZUSCHLAG_TAX_CLASS, $order->delivery['country']['id'], $order->delivery['zone_id']); $tax_description = tep_get_tax_description(MODULE_ORDER_TOTAL_INSELZUSCHLAG_TAX_CLASS, $order->delivery['country']['id'], $order->delivery['zone_id']); $order->info['tax'] += tep_calculate_tax($inselfee, $tax); $order->info['tax_groups']["$tax_description"] += tep_calculate_tax($inselfee, $tax); $order->info['total'] += $inselfee + tep_calculate_tax($inselfee, $tax); $this->output[] = array('title' => $this->title . ':', 'text' => $currencies->format(tep_add_tax($inselfee, $tax), true, $order->info['currency'], $order->info['currency_value']), 'value' => tep_add_tax($inselfee, $tax)); } } function check() { if (!isset($this->_check)) { $check_query = tep_db_query("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_ORDER_TOTAL_INSELZUSCHLAG_STATUS'"); $this->_check = tep_db_num_rows($check_query); } return $this->_check; } function keys() { return array('MODULE_ORDER_TOTAL_INSELZUSCHLAG_STATUS', 'MODULE_ORDER_TOTAL_INSELZUSCHLAG_SORT_ORDER', 'MODULE_ORDER_TOTAL_INSELZUSCHLAG_DESTINATION', 'MODULE_ORDER_TOTAL_INSELZUSCHLAG_TAX_CLASS'); } 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 ('Inselzuschlag anzeigen', 'MODULE_ORDER_TOTAL_INSELZUSCHLAG_STATUS', 'true', 'Wollen Sie den Inselzuschlag anzeigen lassen?', '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, date_added) values ('Reihenfolge', 'MODULE_ORDER_TOTAL_INSELZUSCHLAG_SORT_ORDER', '4', 'Reihenfolge bei den Order-Total Modulen.', '6', '2', 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 ('Inselzuschlag f?r Bestellungen aus folgenden Regionen', 'MODULE_ORDER_TOTAL_INSELZUSCHLAG_DESTINATION', 'both', 'Berechnung des Inselzuschlages bei folgenden Gebieten.', '6', '6', 'tep_cfg_select_option(array(\'national\', \'international\', \'both\'), ', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) values ('Steuerklasse', 'MODULE_ORDER_TOTAL_INSELZUSCHLAG_TAX_CLASS', '0', 'Folgende Steuerklasse fuer Inselzuschlag verwenden.', '6', '7', 'tep_get_tax_class_title', 'tep_cfg_pull_down_tax_classes(', now())"); } function remove() { tep_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key in ('" . implode("', '", $this->keys()) . "')"); } } ?>
  6. Hello John, I'm sorry. With the German was my mistake. Thank you for the help. I managed it.
  7. After the update, the buttons for editing and deleting as well as the statistics on the right will not be displayed at all. what could that be?
  8. [Addon] Store Times BS

    Hi @burt, give me more information about the module. I already have interest.
  9. [Addon] Store Times BS

    Too bad but thanks anyway is a great contrib
  10. [Addon] Store Times BS

    Hello everyone is there a possibility to enter the opening times in two stages? Monday 12:00 - 14:00 / 17:00 - 23:00
  11. X-Sell

    Thank you very much. That helps me a lot
  12. X-Sell

    Thanks Tsimi, I have changed the bug but it still does not work. Again and again directed to the index.php ********************************************** functions/cache.php // Cache the also Xell module function tep_cache_xsell_products($auto_expire = false, $refresh = false) { global $_GET, $language, $languages_id; $cache_output = ''; if (isset($_GET['products_id']) && is_numeric($_GET['products_id'])) { if (($refresh == true) || !read_cache($cache_output, 'xsell_products-' . $language . '.cache' . $_GET['products_id'], $auto_expire)) { ob_start(); include('includes/modules/xsell_products.php'); $cache_output = ob_get_contents(); ob_end_clean(); write_cache($cache_output, 'xsell_products-' . $language . '.cache' . $_GET['products_id']); } } return $cache_output; } includes/application_top.php if (DISPLAY_CART == 'true') { $goto = 'shopping_cart.php'; $parameters = array('action', 'cPath', 'products_id', 'pid'); } else { $goto = basename($PHP_SELF); if ($_GET['action'] == 'buy_now') { // BOE: XSell if (isset($_GET['product_to_buy_id'])) { $parameters = array('action', 'pid', 'products_to_buy_id'); } else { $parameters = array('action', 'pid', 'products_id'); } // EOE: XSell } else { $parameters = array('action', 'pid'); } } includes/modules/xsell_products.php if ((STOCK_CHECK == 'true') && (STOCK_ALLOW_CHECKOUT != 'true')) { $qty = (isset($xsell['products_quantity']) ? $xsell['products_quantity'] : 'x'); if (($xsell['products_bundle'] == 'yes') || ($qty == 'x')) $qty = tep_get_products_stock($xsell['products_id']); } if ((STOCK_CHECK == 'true') && (STOCK_ALLOW_CHECKOUT != 'true') && ($qty < 1)) { } else { if (SHOW_BUTTON_BUY_NOW == 'true') { $lc_text = '<br><div class="col-xs-12 text-right">' . tep_draw_button(SMALL_IMAGE_BUTTON_VIEW, 'fa fa-eye', tep_href_link('product_info.php', 'products_id=' . $xsell['products_id']), 'btn-success btn-sm') .'&nbsp;'. tep_draw_button(IMAGE_BUTTON_BUY_NOW, 'fa fa-shopping-cart', tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action', 'products_id')) . 'action=buy_now&products_id=' . $xsell['products_id']), NULL, NULL, 'btn btn-success') . '</div>'; }else{ $lc_text = '<br><div class="col-xs-12 text-center">' . tep_draw_button(SMALL_IMAGE_BUTTON_VIEW, 'fa fa-eye', tep_href_link('product_info.php', 'products_id=' . $xsell['products_id']), 'btn-success btn-sm') . '</div>'; }} $products_xsell_content .= $lc_text; }
  13. X-Sell

    Hi Burt, thanks and sorry. Yes i have responsive 2.3.4.1BS Edge X_Sell_For_2.3.4_V3.2
  14. How to Deactivate a Category from AdminCP

    Hide Categories & Products For OScommerce2.2 rc1 I searched for a solution for this, solutions I found were either over complex, or poorly done, so this is my solution. I believe in keeping things as simple as possible & not re-inventing the wheel. OSC already has functions to hide any product, so I use that for products. This adds a new entry in the category table (categories_status) so all thats needed on the client side is to add a filter added to sql queries ( and categories_status = 1 ). This does not allow for per-customer filtering, although I reckon it wouldent be too difficult to add. Most changes occur in admin/categories.php. These allow you to change the status of any category & the status of all products within a category. My site is heavily modified, so you may need to alter this contribution to fit your site. Added Missing Entry From 1.0 pointed out by stanec. INSTALLATION BACKUP - BACKUP - BACKUP First apply the following SQL queries with phpMyAdmin ALTER TABLE `categories` ADD `categories_status` INT( 1 ) NOT NULL DEFAULT '1'; ALTER TABLE `categories` CHANGE `categories_status` `categories_status` INT( 1 ) NOT NULL DEFAULT '0' ; Add images to catalog/adim/images ******************************************** In catalog/admin/categories.php Near Line 42 Find: case 'insert_category': case 'update_category': Add Before case 'setcats': if ( ($HTTP_GET_VARS['flag'] == '0') || ($HTTP_GET_VARS['flag'] == '1') ) { if (isset($HTTP_GET_VARS['cID'])) { tep_set_category_status($HTTP_GET_VARS['cID'], $HTTP_GET_VARS['flag']); } if (USE_CACHE == 'true') { tep_reset_cache_block('categories'); tep_reset_cache_block('also_purchased'); } } tep_redirect(tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $HTTP_GET_VARS['cPath'] . '&cID=' . $HTTP_GET_VARS['cID'])); break; Near Line 77 Find: tep_db_perform(TABLE_CATEGORIES, $sql_data_array, 'update', "categories_id = '" . (int)$categories_id . "'"); } Add After: // BOF Cx Prod Status $cxstat = (($HTTP_POST_VARS['cxstat'] <> 9) ? $HTTP_POST_VARS['cxstat'] : ''); $products_query = tep_db_query("select p.products_id, cd.categories_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$categories_id . "' and cd.categories_id = p2c.categories_id");$cnt=0; if ($cxstat <> '') { while ($products = tep_db_fetch_array($products_query)) { $cnt++;$categories_name = $products['categories_name']; tep_set_product_status($products['products_id'], $cxstat); } $message = ($cxstat ? IMAGE_ICON_STATUS_GREEN : IMAGE_ICON_STATUS_RED); $messageStack->add_session('', 'none'); $messageStack->add_session('Set ' . $cnt . ' Products In ' . $categories_name . ' To ' . $message, 'success'); if (USE_CACHE == 'true') { tep_reset_cache_block('categories'); tep_reset_cache_block('also_purchased'); } } // EOF Cx Prod Status Near 777 find: $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' and cd.categories_name like '%" . tep_db_input($search) . "%' order by c.sort_order, cd.categories_name"); } else { $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$current_category_id . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by c.sort_order, cd.categories_name"); } Replace With: $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, c.categories_status from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' and cd.categories_name like '%" . tep_db_input($search) . "%' order by c.sort_order, cd.categories_name"); } else { $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, c.categories_status from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$current_category_id . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by c.sort_order, cd.categories_name"); } Near Line 820 Find: <td class="dataTableContent" align="center">&nbsp;</td> Replace With <td class="dataTableContent" align="center" ><?php // CATEGORY STATUS if ($categories['categories_status'] == '1') { echo tep_image(DIR_WS_IMAGES . 'icon_status_greenl.gif', IMAGE_ICON_STATUS_GREEN, 12, 12) . '&nbsp;&nbsp;<a href="' . tep_href_link(FILENAME_CATEGORIES, 'action=setcats&flag=0&cID=' . $categories['categories_id'] . (isset($HTTP_GET_VARS['cPath']) ? '&cPath=' . $HTTP_GET_VARS['cPath'] : '') ) . '">' . tep_image(DIR_WS_IMAGES . 'icon_status_red_lightl.gif', IMAGE_ICON_STATUS_RED_LIGHT, 12, 12) . '</a>'; } else { echo '<a href="' . tep_href_link(FILENAME_CATEGORIES, 'action=setcats&flag=1&cID=' . $categories['categories_id'] . (isset($HTTP_GET_VARS['cPath']) ? '&cPath=' . $HTTP_GET_VARS['cPath'] : '') ) . '">' . tep_image(DIR_WS_IMAGES . 'icon_status_green_lightl.gif', IMAGE_ICON_STATUS_GREEN_LIGHT, 12, 12) . '</a>' . '&nbsp;&nbsp;' . tep_image(DIR_WS_IMAGES . 'icon_status_redl.gif', IMAGE_ICON_STATUS_RED, 12, 12); } ?></td> Near Line 950 Find: $contents[] = array('text' => '<br>' . TEXT_EDIT_CATEGORIES_NAME . $category_inputs_string); Replace With: $select_array[] = array('id' => 9, 'text' => 'No Change'); $select_array[] = array('id' => 0, 'text' => 'Set All Inactive'); $select_array[] = array('id' => 1, 'text' => 'Set All Active'); $contents[] = array('text' => '<br>' . TEXT_EDIT_CATEGORIES_NAME . $category_inputs_string); $contents[] = array('text' => '<br>' . TABLE_HEADING_STATUS . ': <b>' . ($cInfo->categories_status ? IMAGE_ICON_STATUS_GREEN : IMAGE_ICON_STATUS_RED) . '</b>'); Near Line 960 Find: $contents[] = array('text' => '<br>' . TEXT_EDIT_SORT_ORDER . '<br>' . tep_draw_input_field('sort_order', $cInfo->sort_order, 'size="2"')); Replace With: $contents[] = array('text' => '<br>' . TEXT_EDIT_SORT_ORDER . '<br>' . tep_draw_input_field('sort_order', $cInfo->sort_order, 'size="2"')); $contents[] = array('text' => '<br>' . TEXT_CHANGE_PRODUCTS_STATUS . $cInfo->categories_name . '<br>' ); $contents[] = array('align' => 'center', 'text' => tep_draw_pull_down_menu('cxstat', $select_array, 9)); Near Line 990 Find: if (tep_not_null($cInfo->last_modified)) $contents[] = array('text' => TEXT_LAST_MODIFIED . ' ' . tep_date_short($cInfo->last_modified)); Add After: $contents[] = array('text' => '<br>' . TABLE_HEADING_STATUS . ': <b>' . ($cInfo->categories_status ? IMAGE_ICON_STATUS_GREEN : IMAGE_ICON_STATUS_RED) . '</b>'); ************************************************************ In catalog/admin/includes/functions/general Near 740 Find: //// // Sets the status of a product on special Add Before: //// // Sets the status of a category function tep_set_category_status($categories_id, $status) { if ($status == '1') { return tep_db_query("update " . TABLE_CATEGORIES . " set categories_status = '1', last_modified = now() where categories_id = '" . (int)$categories_id . "'"); } elseif ($status == '0') { return tep_db_query("update " . TABLE_CATEGORIES . " set categories_status = '0', last_modified = now() where categories_id = '" . (int)$categories_id . "'"); } else { return -1; } } ************************************************************ In catalog/admin/includes/languages/english/categories.php Near 72 After define('TEXT_PRODUCTS_STATUS', 'Products Status:'); Add: define('TEXT_CHANGE_PRODUCTS_STATUS', 'Change Status Of All Products In '); ************************************************************ In catalog/index.php Near 89 Find: $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$category_links[$i] . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name"); Replace With: $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$category_links[$i] . "' and c.categories_status = 1 and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name"); Near 94 Find: $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$current_category_id . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name"); Replace With: $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$current_category_id . "' and c.categories_status = 1 and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name"); ************************************************************ In catalog/includes/boxes/categories.php Near 73 Find: $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"); Replace With: $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 c.categories_status = 1 and cd.language_id='" . (int)$languages_id ."' order by sort_order, cd.categories_name"); Near 99 Find: $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"); Replace With: $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 c.categories_status = 1 and cd.language_id='" . (int)$languages_id ."' order by sort_order, cd.categories_name"); ************************************************************ If you have it, In catalog/includes/boxes/dm_categories.php Near 236 Find: $result = tep_db_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 and cd.language_id="' . (int)$languages_id .'" '.$parent_query.'order by sort_order, cd.categories_name'); Replace With: $result = tep_db_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 and c.categories_status = 1 and cd.language_id="' . (int)$languages_id .'" '.$parent_query.'order by sort_order, cd.categories_name'); ************************************************************ There may other instances I have missed, the genereral Rule is: If there is a general tep_db_query including TABLE_CATEGORIES add the filter: and categories_status = 1 If you applied the sql correctly all your existing categories should default to 'active'.
×