/** * @package admin * @copyright Copyright 2003-2016 Zen Cart Development Team * @copyright Portions Copyright 2003 osCommerce * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0 * @version $Id: Author: DrByte Sun Oct 18 02:03:48 2015 -0400 Modified in v1.5.5 $ */ if (!defined('IS_ADMIN_FLAG')) { die('Illegal Access'); } $parameters = array('products_name' => '', 'products_description' => '', 'products_url' => '', 'products_id' => '', 'products_quantity' => '', 'products_model' => '', 'products_image' => '', 'products_price' => '', 'products_price_w' => '', 'products_virtual' => DEFAULT_PRODUCT_PRODUCTS_VIRTUAL, 'products_weight' => '', 'products_date_added' => '', 'products_last_modified' => '', 'products_date_available' => '', 'products_status' => '', 'products_tax_class_id' => DEFAULT_PRODUCT_TAX_CLASS_ID, 'manufacturers_id' => '', 'products_quantity_order_min' => '', 'products_quantity_order_units' => '', 'products_priced_by_attribute' => '', 'product_is_free' => '', 'product_is_call' => '', 'products_quantity_mixed' => '', 'product_is_always_free_shipping' => DEFAULT_PRODUCT_PRODUCTS_IS_ALWAYS_FREE_SHIPPING, 'products_qty_box_status' => PRODUCTS_QTY_BOX_STATUS, 'products_quantity_order_max' => '0', 'products_sort_order' => '0', 'products_discount_type' => '0', 'products_discount_type_from' => '0', 'products_price_sorter' => '0', 'master_categories_id' => ''); $pInfo = new objectInfo($parameters); if (isset($_GET['pID']) && empty($_POST)) { $product = $db->Execute("select pd.products_name, pd.products_description, pd.products_url,\n p.products_id, p.products_quantity, p.products_model,\n/* Dual Pricing start */\n p.products_image, p.products_price, p.products_price_w, p.products_virtual, p.products_weight,\n/* Dual Pricing end */\n p.products_date_added, p.products_last_modified,\n date_format(p.products_date_available, '%Y-%m-%d') as\n products_date_available, p.products_status, p.products_tax_class_id,\n p.manufacturers_id,\n p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute,\n p.product_is_free, p.product_is_call, p.products_quantity_mixed,\n p.product_is_always_free_shipping, p.products_qty_box_status, p.products_quantity_order_max,\n p.products_sort_order,\n p.products_discount_type, p.products_discount_type_from,\n p.products_price_sorter, p.master_categories_id\n from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd\n where p.products_id = '" . (int) $_GET['pID'] . "'\n and p.products_id = pd.products_id\n and pd.language_id = '" . (int) $_SESSION['languages_id'] . "'"); $pInfo->updateObjectInfo($product->fields); } elseif (zen_not_null($_POST)) { $pInfo->updateObjectInfo($_POST); $products_name = $_POST['products_name']; $products_description = $_POST['products_description']; $products_url = $_POST['products_url']; } $category_lookup = $db->Execute("select *\n from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd\n where c.categories_id ='" . (int) $current_category_id . "'\n and c.categories_id = cd.categories_id\n and cd.language_id = '" . (int) $_SESSION['languages_id'] . "'"); if (!$category_lookup->EOF) { $cInfo = new objectInfo($category_lookup->fields); } else { $cInfo = new objectInfo(array()); } $manufacturers_array = array(array('id' => '', 'text' => TEXT_NONE)); $manufacturers = $db->Execute("select manufacturers_id, manufacturers_name\n from " . TABLE_MANUFACTURERS . " order by manufacturers_name"); while (!$manufacturers->EOF) {