$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';
}
