$db_buffer['is_other'] = $is_other; $db_buffer['is_consumable'] = $is_consumable; $db_buffer['item_number'] = $selian_item_number; $db_buffer['partcode'] = $part_code; $db_buffer['item_description'] = $selians_item_description; $db_buffer['item_full_description'] = $items_full_description; $db_buffer['purchasing_class'] = $purchasing_class; $db_buffer['sub_class'] = $item_subclass; $db_buffer['unit_price'] = $selians_item_price; $db_buffer['unit_price_1'] = $selians_item_price_1; $db_buffer['unit_price_2'] = $selians_item_price_2; $db_buffer['unit_price_3'] = $selians_item_price_3; $db_buffer['unit_price_4'] = $selians_item_price_4; $db_buffer['unit_price_5'] = $selians_item_price_5; $db_buffer['unit_price_6'] = $selians_item_price_6; $product_obj->useProductTable(); //------------------------------------------------------------------------------ if ($mode == "insert") { // Check at first that this item is still not available in the database: if ($debug) { echo "current mode is insert!<br>"; } if ($product_obj->item_number_exists($selian_item_number)) { // The item still exists in the database! $ERROR_MSG .= "Sorry, this item with code \"" . $selian_item_number . "\" still exists in the database! <br>\r\n Please check the field Selians item number, you can just update or delete it!<br>"; $ERROR_SELIAN_ITEM_NUMBER = TRUE; $ERROR = TRUE; } else { // This is a new item, store it into the database $product_obj->setDataArray($db_buffer); $product_obj->insertDataFromInternalArray();