query('select products_id, products_quantity, products_price, products_weight, products_weight_class, products_date_added, products_last_modified, date_format(products_date_available, "%Y-%m-%d") as products_date_available, products_status, products_tax_class_id, manufacturers_id from :table_products where products_id = :products_id'); $Qp->bindTable(':table_products', TABLE_PRODUCTS); $Qp->bindInt(':products_id', $_GET['pID']); $Qp->execute(); $Qpd = $osC_Database->query('select products_name, products_description, products_model, products_keyword, products_tags, products_url, language_id from :table_products_description where products_id = :products_id'); $Qpd->bindTable(':table_products_description', TABLE_PRODUCTS_DESCRIPTION); $Qpd->bindInt(':products_id', $_GET['pID']); $Qpd->execute(); $pd_extra = array(); while ($Qpd->next()) { $pd_extra['products_name'][$Qpd->valueInt('language_id')] = $Qpd->value('products_name'); $pd_extra['products_description'][$Qpd->valueInt('language_id')] = $Qpd->value('products_description'); $pd_extra['products_model'][$Qpd->valueInt('language_id')] = $Qpd->value('products_model'); $pd_extra['products_keyword'][$Qpd->valueInt('language_id')] = $Qpd->value('products_keyword'); $pd_extra['products_tags'][$Qpd->valueInt('language_id')] = $Qpd->value('products_tags'); $pd_extra['products_url'][$Qpd->valueInt('language_id')] = $Qpd->value('products_url'); } $pInfo = new objectInfo(array_merge($Qp->toArray(), $pd_extra)); } $Qmanufacturers = $osC_Database->query('select manufacturers_id, manufacturers_name from :table_manufacturers order by manufacturers_name'); $Qmanufacturers->bindTable(':table_manufacturers', TABLE_MANUFACTURERS); $Qmanufacturers->execute(); $manufacturers_array = array(array('id' => '', 'text' => TEXT_NONE)); while ($Qmanufacturers->next()) { $manufacturers_array[] = array('id' => $Qmanufacturers->valueInt('manufacturers_id'), 'text' => $Qmanufacturers->value('manufacturers_name')); } $Qtc = $osC_Database->query('select tax_class_id, tax_class_title from :table_tax_class order by tax_class_title'); $Qtc->bindTable(':table_tax_class', TABLE_TAX_CLASS); $Qtc->execute(); $tax_class_array = array(array('id' => '0', 'text' => TEXT_NONE)); while ($Qtc->next()) { $tax_class_array[] = array('id' => $Qtc->valueInt('tax_class_id'), 'text' => $Qtc->value('tax_class_title')); } $Qwc = $osC_Database->query('select weight_class_id, weight_class_title from :table_weight_class where language_id = :language_id order by weight_class_title'); $Qwc->bindTable(':table_weight_class', TABLE_WEIGHT_CLASS); $Qwc->bindInt(':language_id', $osC_Language->getID()); $Qwc->execute(); $weight_class_array = array(); while ($Qwc->next()) { $weight_class_array[] = array('id' => $Qwc->valueInt('weight_class_id'), 'text' => $Qwc->value('weight_class_title')); } ?>

products_name[$osC_Language->getID()])) ? $pInfo->products_name[$osC_Language->getID()] : TEXT_NEW_PRODUCT; ?>

getAll() as $l) { ?>

products_name) && isset($pInfo->products_name[$l['id']]) ? $pInfo->products_name[$l['id']] : null)); ?>
products_description) && isset($pInfo->products_description[$l['id']]) ? $pInfo->products_description[$l['id']] : null), 70, 15, 'style="width: 100%;"'); ?>
products_model) && isset($pInfo->products_model[$l['id']]) ? $pInfo->products_model[$l['id']] : null)); ?>
products_keyword) && isset($pInfo->products_keyword[$l['id']]) ? $pInfo->products_keyword[$l['id']] : null)); ?>
products_tags) && isset($pInfo->products_tags[$l['id']]) ? $pInfo->products_tags[$l['id']] : null)); ?>
products_url) && isset($pInfo->products_url[$l['id']]) ? $pInfo->products_url[$l['id']] : null)); ?>

Price
products_tax_class_id : null), 'onchange="updateGross(\'products_price\');"'); ?>
products_price : null), 'onkeyup="updateGross(\'products_price\')"'); ?>
products_price : null), 'onkeyup="updateNet(\'products_price\')"'); ?>
Data
manufacturers_id : null)); ?>
products_quantity : null)); ?>
products_weight : null)). ' ' . osc_draw_pull_down_menu('products_weight_class', $weight_class_array, (isset($pInfo) ? $pInfo->products_weight_class : SHIPPING_WEIGHT_UNIT)); ?>
'1', 'text' => TEXT_PRODUCT_AVAILABLE), array('id' => '0', 'text' => TEXT_PRODUCT_NOT_AVAILABLE)), (isset($pInfo) ? $pInfo->products_status : '0'), null, '
'); ?>
Information
products_date_available : null)); ?>(YYYY-MM-DD)

New Image
getModule() . '&action=fileUpload' . (isset($_GET['pID']) ? '&pID=' . $_GET['pID'] : '')) . '\'; document.getElementById(\'showProgress\').style.display=\'inline\';" />'; } ?>
Original Images
Images

' . "\n" . ' ' . "\n" . ' ' . "\n"; $current_attribute_group = $Qattributes->value('products_options_name'); } echo ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n"; } echo '
'; $Qattributes = $osC_Database->query('select po.products_options_id, po.products_options_name, pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from :table_products_attributes pa, :table_products_options po, :table_products_options_values pov where pa.products_id = :products_id and pa.options_id = po.products_options_id and po.language_id = :language_id and pa.options_values_id = pov.products_options_values_id and pov.language_id = :language_id order by po.products_options_name, pov.products_options_values_name'); $Qattributes->bindTable(':table_products_attributes', TABLE_PRODUCTS_ATTRIBUTES); $Qattributes->bindTable(':table_products_options', TABLE_PRODUCTS_OPTIONS); $Qattributes->bindTable(':table_products_options_values', TABLE_PRODUCTS_OPTIONS_VALUES); $Qattributes->bindInt(':products_id', $_GET['pID']); $Qattributes->bindInt(':language_id', $osC_Language->getID()); $Qattributes->bindInt(':language_id', $osC_Language->getID()); $Qattributes->execute(); $current_attribute_group = ''; while ($Qattributes->next()) { if ($Qattributes->value('products_options_name') != $current_attribute_group) { echo '
' . $Qattributes->value('products_options_name') . '
' . $Qattributes->value('products_options_values_name') . '' . osc_draw_pull_down_menu('attribute_prefix[' . $Qattributes->valueInt('products_options_id') . '][' . $Qattributes->valueInt('products_options_values_id') . ']', array(array('id' => '+', 'text' => '+'), array('id' => '-', 'text' => '-')), $Qattributes->value('price_prefix')) . ' ' . osc_draw_input_field('attribute_price[' . $Qattributes->valueInt('products_options_id') . '][' . $Qattributes->valueInt('products_options_values_id') . ']', $Qattributes->value('options_values_price')) . '
'; } ?>

query('select categories_id from :table_products_to_categories where products_id = :products_id'); $Qcategories->bindTable(':table_products_to_categories', TABLE_PRODUCTS_TO_CATEGORIES); $Qcategories->bindInt(':products_id', $_GET['pID']); $Qcategories->execute(); while ($Qcategories->next()) { $product_categories_array[] = $Qcategories->valueInt('categories_id'); } } $assignedCategoryTree = new osC_CategoryTree(); $assignedCategoryTree->setBreadcrumbUsage(false); $assignedCategoryTree->setSpacerString(' ', 5); foreach ($assignedCategoryTree->getTree() as $value) { echo ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n"; } ?>
Categories Selected
' . $value['title'] . '' . osc_draw_checkbox_field('categories[]', $value['id'], in_array($value['id'], $product_categories_array), 'id="categories_' . $value['id'] . '"') . '

getModule() . '&cPath=' . $_GET['cPath'] . '&search=' . $_GET['search'] . (isset($_GET['pID']) ? '&pID=' . $_GET['pID'] : '') . '&action=save') . '\';"> '; ?>