$fields[] = 'products_quantity'; $categories = array(); $categories_count_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " where products_types_id = '1' and parent_id = '0'"); $categories_count = tep_db_fetch_array($categories_count_query); for ($i = 0; $i < $categories_count['total']; $i++) { if (tep_not_null($HTTP_POST_VARS['category_' . $i])) { $categories[] = tep_string_to_int($HTTP_POST_VARS['category_' . $i]); } } $manufacturers = tep_not_null($HTTP_POST_VARS['manufacturer']) ? array_map('tep_db_prepare_input', explode("\n", trim($HTTP_POST_VARS['manufacturer']))) : array(); $specials = array(); $specials_count_query = tep_db_query("select count(*) as total from " . TABLE_SPECIALS_TYPES . " where specials_types_status = '1'"); $specials_count = tep_db_fetch_array($specials_count_query); for ($i = 0; $i < $specials_count['total']; $i++) { if (tep_not_null($HTTP_POST_VARS['special_' . $i])) { $specials[] = tep_string_to_int($HTTP_POST_VARS['special_' . $i]); } } $status = $HTTP_POST_VARS['status']; $products_to_load = array(); $subcategories_products = array(); $manufacturers_products = array(); $specials_products = array(); $products_selected = false; $subcategories_array = array(); $eval_string = ''; if (sizeof($categories) > 0) { reset($categories); while (list(, $category_id) = each($categories)) { $subcategories_array[] = $category_id; tep_get_subcategories($subcategories_array, $category_id);
$categories = array(); $categories_count_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " where parent_id = '0'"); $categories_count = tep_db_fetch_array($categories_count_query); for ($i = 0; $i < $categories_count['total']; $i++) { if (tep_not_null($HTTP_GET_VARS['c_' . $i])) { $categories[] = tep_string_to_int(urldecode($HTTP_GET_VARS['c_' . $i])); } } $manufacturers = tep_not_null($HTTP_GET_VARS['m_0']) ? array_map('tep_db_prepare_input', explode("\n", trim(urldecode($HTTP_GET_VARS['m_0'])))) : array(); $specials = array(); $specials_periods = array(); $specials_count_query = tep_db_query("select count(*) as total from " . TABLE_SPECIALS_TYPES . " where specials_types_status = '1' and specials_types_path <> ''"); $specials_count = tep_db_fetch_array($specials_count_query); for ($i = 0; $i < $specials_count['total']; $i++) { if (tep_not_null($HTTP_GET_VARS['s_' . $i])) { $specials[] = tep_string_to_int(urldecode($HTTP_GET_VARS['s_' . $i])); $specials_period = urldecode($HTTP_GET_VARS['sp_' . $i]); if (!in_array($specials_period, array('w', '2w', 'm', 'h'))) { $specials_period = 'w'; } $specials_periods[] = $specials_period; } } $ff = urldecode($HTTP_GET_VARS['ff']); if ($ff != 'xml' && $ff != 'csv') { $ff = 'xml'; } $status = urldecode($HTTP_GET_VARS['st']); if ($status != 'all' && $status != 'active') { $status = 'active'; }