$manufacturers_array = array(array('id' => '', 'text' => TEXT_NONE));
$manufacturers_query = smn_db_query("select manufacturers_id, manufacturers_name from " . TABLE_MANUFACTURERS . " order by manufacturers_name");
while ($manufacturers = smn_db_fetch_array($manufacturers_query)) {
$manufacturers_array[] = array('id' => $manufacturers['manufacturers_id'], 'text' => $manufacturers['manufacturers_name']);
}
$tax_class_array = array(array('id' => '0', 'text' => TEXT_NONE));
$tax_class_query = smn_db_query("select tax_class_id, tax_class_title from " . TABLE_TAX_CLASS . " where store_id = '" . $store_id . "' order by tax_class_title");
$languages = smn_get_languages();
if ($store_id != 1) {
$categories_selected = '';
$categories_check_query = smn_db_query("select categories_id from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . (int) $products_id . "' and store_id = '1'");
if (smn_db_num_rows($categories_check_query)) {
$categories_check = smn_db_fetch_array($categories_check_query);
$categories_selected = (int) $categories_check['categories_id'];
}
$categories_array = smn_get_main_categories();
}
while ($tax_class = smn_db_fetch_array($tax_class_query)) {
$tax_class_array[] = array('id' => $tax_class['tax_class_id'], 'text' => $tax_class['tax_class_title']);
}
if (!isset($pInfo->products_status)) {
$pInfo->products_status = '1';
}
switch ($pInfo->products_status) {
case '0':
$in_status = false;
$out_status = true;
break;
case '1':
default:
$in_status = true;
function smn_get_main_categories($categories_array = '', $parent_id = '0', $indent = '')
{
global $languages_id;
if (!is_array($categories_array)) {
$categories_array = array();
}
$categories_query = smn_db_query("select c.categories_id, cd.categories_name from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where parent_id = '" . (int) $parent_id . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int) $languages_id . "' and cd.store_id = '1' and c.store_id = '1' order by sort_order, cd.categories_name");
while ($categories = smn_db_fetch_array($categories_query)) {
if ($categories['categories_id'] != $parent_id && $categories['categories_id'] != '1') {
$categories_array[] = array('id' => $categories['categories_id'], 'text' => $indent . $categories['categories_name']);
$categories_array = smn_get_main_categories($categories_array, $categories['categories_id'], $indent . ' ->');
}
}
return $categories_array;
}
