Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Master Products+Wysiwyg 98% done


Guest

Recommended Posts

Ok,, I have been trying for 4 hours to add the two contribs together

 

 

I have everything working except the admin/categories.

 

I have the description part working on all areas of the categories page and the image part works on the slave aspect of adding and editing.

 

Image part shows up when you are editing a master. You can click the box and the popup comes up, you select the image, and click preview and update but the image is not saved to the database.

 

This is only on the Part when you edit a master.

 

The categories file is getting so radically big I cant concentrate anymore when I look at it.

 

if anyone can help it would be greatly appreciated.

 

Here is the categories file

 

<?php
/*
?$Id: categories.php,v 1.146 2003/07/11 14:40:27 hpdl Exp $

?osCommerce, Open Source E-Commerce Solutions
?http://www.oscommerce.com

 Master Products - JOHNSON - 01/11/2003 [email protected]

 Copyright ? 2003 Suomedia - Dynamic Content Management 

?Copyright ? 2003 osCommerce

?Released under the GNU General Public License
*/

require('includes/application_top.php');
?require(DIR_WS_CLASSES . 'currencies.php');
?$currencies = new currencies();

?$action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : '');

?if (tep_not_null($action)) {
? ?switch ($action) {
? ? ?case 'setflag':
? ? ? ?if ( ($HTTP_GET_VARS['flag'] == '0') || ($HTTP_GET_VARS['flag'] == '1') ) {
? ? ? ? ?if (isset($HTTP_GET_VARS['pID'])) {
? ? ? ? ? ?tep_set_product_status($HTTP_GET_VARS['pID'], $HTTP_GET_VARS['flag']);
? ? ? ? ?}

? ? ? ? ?if (USE_CACHE == 'true') {
? ? ? ? ? ?tep_reset_cache_block('categories');
? ? ? ? ? ?tep_reset_cache_block('also_purchased');
? ? ? ? ?}
? ? ? ?}

? ? ? ?tep_redirect(tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $HTTP_GET_VARS['cPath'] . '&pID=' . $HTTP_GET_VARS['pID']));
? ? ? ?break;
? ? ?case 'insert_category':
? ? ?case 'update_category':
? ? ? ?if (isset($HTTP_POST_VARS['categories_id'])) $categories_id = tep_db_prepare_input($HTTP_POST_VARS['categories_id']);
? ? ? ?$sort_order = tep_db_prepare_input($HTTP_POST_VARS['sort_order']);

? ? ? ?$sql_data_array = array('sort_order' => $sort_order);

? ? ? ?if ($action == 'insert_category') {
? ? ? ? ?$insert_sql_data = array('parent_id' => $current_category_id,
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 'date_added' => 'now()');

? ? ? ? ?$sql_data_array = array_merge($sql_data_array, $insert_sql_data);

? ? ? ? ?tep_db_perform(TABLE_CATEGORIES, $sql_data_array);

? ? ? ? ?$categories_id = tep_db_insert_id();
? ? ? ?} elseif ($action == 'update_category') {
? ? ? ? ?$update_sql_data = array('last_modified' => 'now()');

? ? ? ? ?$sql_data_array = array_merge($sql_data_array, $update_sql_data);

? ? ? ? ?tep_db_perform(TABLE_CATEGORIES, $sql_data_array, 'update', "categories_id = '" . (int)$categories_id . "'");
? ? ? ?}

? ? ? ?$languages = tep_get_languages();
? ? ? ?for ($i=0, $n=sizeof($languages); $i<$n; $i++) {
? ? ? ? ?$categories_name_array = $HTTP_POST_VARS['categories_name'];

? ? ? ? ?$language_id = $languages[$i]['id'];

? ? ? ? ?$sql_data_array = array('categories_name' => tep_db_prepare_input($categories_name_array[$language_id]));

? ? ? ? ?if ($action == 'insert_category') {
? ? ? ? ? ?$insert_sql_data = array('categories_id' => $categories_id,
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 'language_id' => $languages[$i]['id']);

? ? ? ? ? ?$sql_data_array = array_merge($sql_data_array, $insert_sql_data);

? ? ? ? ? ?tep_db_perform(TABLE_CATEGORIES_DESCRIPTION, $sql_data_array);
? ? ? ? ?} elseif ($action == 'update_category') {
? ? ? ? ? ?tep_db_perform(TABLE_CATEGORIES_DESCRIPTION, $sql_data_array, 'update', "categories_id = '" . (int)$categories_id . "' and language_id = '" . (int)$languages[$i]['id'] . "'");
? ? ? ? ?}
? ? ? ?}

? ? ? ?if (HTML_AREA_WYSIWYG_DISABLE == 'Disable') {
? ? ? ? ?if ($categories_image = new upload('categories_image', DIR_FS_CATALOG_IMAGES)) {
? ? ? ? ? ?tep_db_query("update " . TABLE_CATEGORIES . " set categories_image = '" . tep_db_input($categories_image->filename) . "' where categories_id = '" . (int)$categories_id . "'");
? ? ? ? ?}
? ? ? ?} else {
? ? ? ? ?if (isset($HTTP_POST_VARS['categories_image']) && tep_not_null($HTTP_POST_VARS['categories_image']) && ($HTTP_POST_VARS['categories_image'] != 'none')) {
? ? ? ? ? ?tep_db_query("update " . TABLE_CATEGORIES . " set categories_image = '" . tep_db_input($HTTP_POST_VARS['categories_image']) . "' where categories_id = '" . (int)$categories_id . "'");
? ? ? ? ?}
? ? ? ?}

? ? ? ?if (USE_CACHE == 'true') {
? ? ? ? ?tep_reset_cache_block('categories');
? ? ? ? ?tep_reset_cache_block('also_purchased');
? ? ? ?}

? ? ? ?tep_redirect(tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&cID=' . $categories_id));
? ? ? ?break;
? ? ?case 'delete_category_confirm':
? ? ? ?if (isset($HTTP_POST_VARS['categories_id'])) {
? ? ? ? ?$categories_id = tep_db_prepare_input($HTTP_POST_VARS['categories_id']);

? ? ? ? ?$categories = tep_get_category_tree($categories_id, '', '0', '', true);
? ? ? ? ?$products = array();
? ? ? ? ?$products_delete = array();

? ? ? ? ?for ($i=0, $n=sizeof($categories); $i<$n; $i++) {
? ? ? ? ? ?$product_ids_query = tep_db_query("select products_id from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id = '" . (int)$categories[$i]['id'] . "'");

? ? ? ? ? ?while ($product_ids = tep_db_fetch_array($product_ids_query)) {
? ? ? ? ? ? ?$products[$product_ids['products_id']]['categories'][] = $categories[$i]['id'];
? ? ? ? ? ?}
? ? ? ? ?}

? ? ? ? ?reset($products);
? ? ? ? ?while (list($key, $value) = each($products)) {
? ? ? ? ? ?$category_ids = '';

? ? ? ? ? ?for ($i=0, $n=sizeof($value['categories']); $i<$n; $i++) {
? ? ? ? ? ? ?$category_ids .= "'" . (int)$value['categories'][$i] . "', ";
? ? ? ? ? ?}
? ? ? ? ? ?$category_ids = substr($category_ids, 0, -2);

? ? ? ? ? ?$check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . (int)$key . "' and categories_id not in (" . $category_ids . ")");
? ? ? ? ? ?$check = tep_db_fetch_array($check_query);
? ? ? ? ? ?if ($check['total'] < '1') {
? ? ? ? ? ? ?$products_delete[$key] = $key;
? ? ? ? ? ?}
? ? ? ? ?}

// removing categories can be a lengthy process
? ? ? ? ?tep_set_time_limit(0);
? ? ? ? ?for ($i=0, $n=sizeof($categories); $i<$n; $i++) {
? ? ? ? ? ?tep_remove_category($categories[$i]['id']);
? ? ? ? ?}

? ? ? ? ?reset($products_delete);
? ? ? ? ?while (list($key) = each($products_delete)) {
? ? ? ? ? ?tep_remove_product($key);
? ? ? ? ?}
? ? ? ?}

? ? ? ?if (USE_CACHE == 'true') {
? ? ? ? ?tep_reset_cache_block('categories');
? ? ? ? ?tep_reset_cache_block('also_purchased');
? ? ? ?}

? ? ? ?tep_redirect(tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath));
? ? ? ?break;
? ? ?case 'delete_product_confirm':
? ? ? ?if (isset($HTTP_POST_VARS['products_id']) && isset($HTTP_POST_VARS['product_categories']) && is_array($HTTP_POST_VARS['product_categories'])) {
? ? ? ? ?$product_id = tep_db_prepare_input($HTTP_POST_VARS['products_id']);
? ? ? ? ?$product_categories = $HTTP_POST_VARS['product_categories'];

? ? ? ? ?for ($i=0, $n=sizeof($product_categories); $i<$n; $i++) {
? ? ? ? ? ?tep_db_query("delete from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . (int)$product_id . "' and categories_id = '" . (int)$product_categories[$i] . "'");
? ? ? ? ?}

? ? ? ? ?$product_categories_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . (int)$product_id . "'");
? ? ? ? ?$product_categories = tep_db_fetch_array($product_categories_query);

? ? ? ? ?if ($product_categories['total'] == '0') {
? ? ? ? ? ?tep_remove_product($product_id);
? ? ? ? ?}
? ? ? ?}

? ? ? ?if (USE_CACHE == 'true') {
? ? ? ? ?tep_reset_cache_block('categories');
? ? ? ? ?tep_reset_cache_block('also_purchased');
? ? ? ?}

? ? ? ?tep_redirect(tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath));
? ? ? ?break;
? ? ?case 'move_category_confirm':
? ? ? ?if (isset($HTTP_POST_VARS['categories_id']) && ($HTTP_POST_VARS['categories_id'] != $HTTP_POST_VARS['move_to_category_id'])) {
? ? ? ? ?$categories_id = tep_db_prepare_input($HTTP_POST_VARS['categories_id']);
? ? ? ? ?$new_parent_id = tep_db_prepare_input($HTTP_POST_VARS['move_to_category_id']);

? ? ? ? ?$path = explode('_', tep_get_generated_category_path_ids($new_parent_id));

? ? ? ? ?if (in_array($categories_id, $path)) {
? ? ? ? ? ?$messageStack->add_session(ERROR_CANNOT_MOVE_CATEGORY_TO_PARENT, 'error');

? ? ? ? ? ?tep_redirect(tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&cID=' . $categories_id));
? ? ? ? ?} else {
? ? ? ? ? ?tep_db_query("update " . TABLE_CATEGORIES . " set parent_id = '" . (int)$new_parent_id . "', last_modified = now() where categories_id = '" . (int)$categories_id . "'");

? ? ? ? ? ?if (USE_CACHE == 'true') {
? ? ? ? ? ? ?tep_reset_cache_block('categories');
? ? ? ? ? ? ?tep_reset_cache_block('also_purchased');
? ? ? ? ? ?}

? ? ? ? ? ?tep_redirect(tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $new_parent_id . '&cID=' . $categories_id));
? ? ? ? ?}
? ? ? ?}

? ? ? ?break;
? ? ?case 'move_product_confirm':
? ? ? ?$products_id = tep_db_prepare_input($HTTP_POST_VARS['products_id']);
? ? ? ?$new_parent_id = tep_db_prepare_input($HTTP_POST_VARS['move_to_category_id']);

? ? ? ?$duplicate_check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . (int)$products_id . "' and categories_id = '" . (int)$new_parent_id . "'");
? ? ? ?$duplicate_check = tep_db_fetch_array($duplicate_check_query);
? ? ? ?if ($duplicate_check['total'] < 1) tep_db_query("update " . TABLE_PRODUCTS_TO_CATEGORIES . " set categories_id = '" . (int)$new_parent_id . "' where products_id = '" . (int)$products_id . "' and categories_id = '" . (int)$current_category_id . "'");

? ? ? ?if (USE_CACHE == 'true') {
? ? ? ? ?tep_reset_cache_block('categories');
? ? ? ? ?tep_reset_cache_block('also_purchased');
? ? ? ?}

? ? ? ?tep_redirect(tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $new_parent_id . '&pID=' . $products_id));
? ? ? ?break;
? ? ?case 'insert_product':
? ? ?case 'update_product':
? ? ? ?if (isset($HTTP_POST_VARS['edit_x']) || isset($HTTP_POST_VARS['edit_y'])) {
? ? ? ? ?$action = 'new_product';
? ? ? ?} else {
? ? ? ? ?if (isset($HTTP_GET_VARS['pID'])) $products_id = tep_db_prepare_input($HTTP_GET_VARS['pID']);
? ? ? ? ?$products_date_available = tep_db_prepare_input($HTTP_POST_VARS['products_date_available']);

? ? ? ? ?$products_date_available = (date('Y-m-d') < $products_date_available) ? $products_date_available : 'null';

? ? ? ? ?$sql_data_array = array('products_quantity' => tep_db_prepare_input($HTTP_POST_VARS['products_quantity']),
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'products_model' => tep_db_prepare_input($HTTP_POST_VARS['products_model']),
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'products_price' => tep_db_prepare_input($HTTP_POST_VARS['products_price']),
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'products_date_available' => $products_date_available,
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'products_weight' => tep_db_prepare_input($HTTP_POST_VARS['products_weight']),
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'products_status' => tep_db_prepare_input($HTTP_POST_VARS['products_status']),
? ? ? ? ? ? ? ? ? ? ?
// Master Products
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'products_listing_status' => tep_db_prepare_input($HTTP_POST_VARS['products_listing_status']),
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'products_master_status' => tep_db_prepare_input($HTTP_POST_VARS['products_master_status']),
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'products_tax_class_id' => tep_db_prepare_input($HTTP_POST_VARS['products_tax_class_id']),
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'manufacturers_id' => tep_db_prepare_input($HTTP_POST_VARS['manufacturers_id']),
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'products_master' => tep_db_prepare_input($HTTP_POST_VARS['products_master']));
// Master Products EOF


? ? ? ? ?if (isset($HTTP_POST_VARS['products_image']) && tep_not_null($HTTP_POST_VARS['products_image']) && ($HTTP_POST_VARS['products_image'] != 'none')) {
? ? ? ? ? ?$sql_data_array['products_image'] = tep_db_prepare_input($HTTP_POST_VARS['products_image']);
? ? ? ? ?}

? ? ? ? ?if ($action == 'insert_product') {
? ? ? ? ? ?$insert_sql_data = array('products_date_added' => 'now()');

? ? ? ? ? ?$sql_data_array = array_merge($sql_data_array, $insert_sql_data);

? ? ? ? ? ?tep_db_perform(TABLE_PRODUCTS, $sql_data_array);
? ? ? ? ? ?$products_id = tep_db_insert_id();

? ? ? ? ? ?tep_db_query("insert into " . TABLE_PRODUCTS_TO_CATEGORIES . " (products_id, categories_id) values ('" . (int)$products_id . "', '" . (int)$current_category_id . "')");
? ? ? ? ?} elseif ($action == 'update_product') {
? ? ? ? ? ?$update_sql_data = array('products_last_modified' => 'now()');

? ? ? ? ? ?$sql_data_array = array_merge($sql_data_array, $update_sql_data);

? ? ? ? ? ?tep_db_perform(TABLE_PRODUCTS, $sql_data_array, 'update', "products_id = '" . (int)$products_id . "'");
? ? ? ? ?}

? ? ? ? ?$languages = tep_get_languages();
? ? ? ? ?for ($i=0, $n=sizeof($languages); $i<$n; $i++) {
? ? ? ? ? ?$language_id = $languages[$i]['id'];

? ? ? ? ? ?$sql_data_array = array('products_name' => tep_db_prepare_input($HTTP_POST_VARS['products_name'][$language_id]),
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'products_description' => tep_db_prepare_input($HTTP_POST_VARS['products_description'][$language_id]),
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'products_url' => tep_db_prepare_input($HTTP_POST_VARS['products_url'][$language_id]));

? ? ? ? ? ?if ($action == 'insert_product') {
? ? ? ? ? ? ?$insert_sql_data = array('products_id' => $products_id,
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 'language_id' => $language_id);

? ? ? ? ? ? ?$sql_data_array = array_merge($sql_data_array, $insert_sql_data);

? ? ? ? ? ? ?tep_db_perform(TABLE_PRODUCTS_DESCRIPTION, $sql_data_array);
? ? ? ? ? ?} elseif ($action == 'update_product') {
? ? ? ? ? ? ?tep_db_perform(TABLE_PRODUCTS_DESCRIPTION, $sql_data_array, 'update', "products_id = '" . (int)$products_id . "' and language_id = '" . (int)$language_id . "'");
? ? ? ? ? ?}
? ? ? ? ?}

? ? ? ? ?if (USE_CACHE == 'true') {
? ? ? ? ? ?tep_reset_cache_block('categories');
? ? ? ? ? ?tep_reset_cache_block('also_purchased');
? ? ? ? ?}

? ? ? ? ?tep_redirect(tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $products_id));
? ? ? ?}
? ? ? ?break;
?//Master Products ? ? ? ?
? ? ? case 'insert_master':
? ? ? case 'update_master':

? ? ? ?if (isset($HTTP_POST_VARS['edit_x']) || isset($HTTP_POST_VARS['edit_y'])) {
? ? ? ? ?$action = 'new_master';
? ? ? ?} else {
? ? ? ? ?if (isset($HTTP_GET_VARS['pID'])) $products_id = tep_db_prepare_input($HTTP_GET_VARS['pID']);
? ? ? ? ?$products_date_available = tep_db_prepare_input($HTTP_POST_VARS['products_date_available']);

? ? ? ? ?$products_date_available = (date('Y-m-d') < $products_date_available) ? $products_date_available : 'null';
? ? ? ? ?$products_master_status = '1';

? ? ? ? ?$sql_data_array = array('products_quantity' => tep_db_prepare_input($HTTP_POST_VARS['products_quantity']),
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'products_model' => tep_db_prepare_input($HTTP_POST_VARS['products_model']),
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'products_price' => tep_db_prepare_input($HTTP_POST_VARS['products_price']),
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'products_date_available' => $products_date_available,
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'products_status' => tep_db_prepare_input($HTTP_POST_VARS['products_status']),
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'products_master_status' => tep_db_prepare_input($HTTP_POST_VARS['products_master_status']),
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'products_tax_class_id' => tep_db_prepare_input($HTTP_POST_VARS['products_tax_class_id']),
? ? ? ? ? ? ? ? ? ? ? ? ? ? 
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'manufacturers_id' => tep_db_prepare_input($HTTP_POST_VARS['manufacturers_id']));
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?

? ? ? ? ?if (isset($HTTP_POST_VARS['products_image']) && tep_not_null($HTTP_POST_VARS['products_image']) && ($HTTP_POST_VARS['products_image'] != 'none')) {
? ? ? ? ? ?$sql_data_array['products_image'] = tep_db_prepare_input($HTTP_POST_VARS['products_image']);
? ? ? ? ?}

? ? ? ? ?if ($action == 'insert_master') {
? ? ? ? ? ?$insert_sql_data = array('products_date_added' => 'now()');

? ? ? ? ? ?$sql_data_array = array_merge($sql_data_array, $insert_sql_data);

? ? ? ? ? ?tep_db_perform(TABLE_PRODUCTS, $sql_data_array);
? ? ? ? ? ?$products_id = tep_db_insert_id();

? ? ? ? ? ?tep_db_query("insert into " . TABLE_PRODUCTS_TO_CATEGORIES . " (products_id, categories_id) values ('" . (int)$products_id . "', '" . (int)$current_category_id . "')");
? ? ? ? ?} elseif ($action == 'update_master') {
? ? ? ? ? ?$update_sql_data = array('products_last_modified' => 'now()');

? ? ? ? ? ?$sql_data_array = array_merge($sql_data_array, $update_sql_data);

? ? ? ? ? ?tep_db_perform(TABLE_PRODUCTS, $sql_data_array, 'update', "products_id = '" . (int)$products_id . "'");
? ? ? ? ?}

? ? ? ? ?$languages = tep_get_languages();
? ? ? ? ?for ($i=0, $n=sizeof($languages); $i<$n; $i++) {
? ? ? ? ? ?$language_id = $languages[$i]['id'];

? ? ? ? ? ?$sql_data_array = array('products_name' => tep_db_prepare_input($HTTP_POST_VARS['products_name'][$language_id]),
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'products_description' => tep_db_prepare_input($HTTP_POST_VARS['products_description'][$language_id]),
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'products_url' => tep_db_prepare_input($HTTP_POST_VARS['products_url'][$language_id]));

? ? ? ? ? ?if ($action == 'insert_master') {
? ? ? ? ? ? ?$insert_sql_data = array('products_id' => $products_id,
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 'language_id' => $language_id);

? ? ? ? ? ? ?$sql_data_array = array_merge($sql_data_array, $insert_sql_data);

? ? ? ? ? ? ?tep_db_perform(TABLE_PRODUCTS_DESCRIPTION, $sql_data_array);
? ? ? ? ? ?} elseif ($action == 'update_master') {
? ? ? ? ? ? ?tep_db_perform(TABLE_PRODUCTS_DESCRIPTION, $sql_data_array, 'update', "products_id = '" . (int)$products_id . "' and language_id = '" . (int)$language_id . "'");
? ? ? ? ? ?}
? ? ? ? ?}

? ? ? ? ?if (USE_CACHE == 'true') {
? ? ? ? ? ?tep_reset_cache_block('categories');
? ? ? ? ? ?tep_reset_cache_block('also_purchased');
? ? ? ? ?}

? ? ? ? ?tep_redirect(tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $products_id));
? ? ? ?}
? ? ? ?break;
// Master Products EOF 
? ? ?case 'copy_to_confirm':
? ? ? ?if (isset($HTTP_POST_VARS['products_id']) && isset($HTTP_POST_VARS['categories_id'])) {
? ? ? ? ?$products_id = tep_db_prepare_input($HTTP_POST_VARS['products_id']);
? ? ? ? ?$categories_id = tep_db_prepare_input($HTTP_POST_VARS['categories_id']);

? ? ? ? ?if ($HTTP_POST_VARS['copy_as'] == 'link') {
? ? ? ? ? ?if ($categories_id != $current_category_id) {
? ? ? ? ? ? ?$check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . (int)$products_id . "' and categories_id = '" . (int)$categories_id . "'");
? ? ? ? ? ? ?$check = tep_db_fetch_array($check_query);
? ? ? ? ? ? ?if ($check['total'] < '1') {
? ? ? ? ? ? ? ?tep_db_query("insert into " . TABLE_PRODUCTS_TO_CATEGORIES . " (products_id, categories_id) values ('" . (int)$products_id . "', '" . (int)$categories_id . "')");
? ? ? ? ? ? ?}
? ? ? ? ? ?} else {
? ? ? ? ? ? ?$messageStack->add_session(ERROR_CANNOT_LINK_TO_SAME_CATEGORY, 'error');
? ? ? ? ? ?}
? ? ? ? ?} elseif ($HTTP_POST_VARS['copy_as'] == 'duplicate') {
? ? ? ? ? // Master Products ? ? ? ? ? ?
? ? ? ? ? ?$product_query = tep_db_query("select products_quantity, products_model, products_image, products_price, products_date_available, products_weight, products_tax_class_id, manufacturers_id, products_master, products_master_status from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'");
? ? ? ? ? ?$product = tep_db_fetch_array($product_query);
? ? ? ? ? ?tep_db_query("insert into " . TABLE_PRODUCTS . " (products_quantity, products_model,products_image, products_price, products_date_added, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id, products_master, products_master_status) values ('" . tep_db_input($product['products_quantity']) . "', '" . tep_db_input($product['products_model']) . "', '" . tep_db_input($product['products_image']) . "', '" . tep_db_input($product['products_price']) . "', ?now(), '" . tep_db_input($product['products_date_available']) . "', '" . tep_db_input($product['products_weight']) . "', '0', '" . (int)$product['products_tax_class_id'] . "', '" . (int)$product['manufacturers_id']. "', '" . $product['products_master']. "', '" .(int)$product['products_master_status'] . "')");
? ? ? ? ? ?$dup_products_id = tep_db_insert_id();
// Master Products EOF 

? ? ? ? ? ?$description_query = tep_db_query("select language_id, products_name, products_description, products_url from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$products_id . "'");
? ? ? ? ? ?while ($description = tep_db_fetch_array($description_query)) {
? ? ? ? ? ? ?tep_db_query("insert into " . TABLE_PRODUCTS_DESCRIPTION . " (products_id, language_id, products_name, products_description, products_url, products_viewed) values ('" . (int)$dup_products_id . "', '" . (int)$description['language_id'] . "', '" . tep_db_input($description['products_name']) . "', '" . tep_db_input($description['products_description']) . "', '" . tep_db_input($description['products_url']) . "', '0')");
? ? ? ? ? ?}

? ? ? ? ? ?tep_db_query("insert into " . TABLE_PRODUCTS_TO_CATEGORIES . " (products_id, categories_id) values ('" . (int)$dup_products_id . "', '" . (int)$categories_id . "')");
? ? ? ? ? ?$products_id = $dup_products_id;
? ? ? ? ?}

? ? ? ? ?if (USE_CACHE == 'true') {
? ? ? ? ? ?tep_reset_cache_block('categories');
? ? ? ? ? ?tep_reset_cache_block('also_purchased');
? ? ? ? ?}
? ? ? ?}

? ? ? ?tep_redirect(tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $categories_id . '&pID=' . $products_id));
? ? ? ?break;
? ? ?case 'new_product_preview':
? ? ? ?if (HTML_AREA_WYSIWYG_DISABLE == 'Disable') {
? ? ? ? ?// copy image only if modified
? ? ? ? ?$products_image = new upload('products_image');
? ? ? ? ?$products_image->set_destination(DIR_FS_CATALOG_IMAGES);
? ? ? ? ?if ($products_image->parse() && $products_image->save()) {
? ? ? ? ? ?$products_image_name = $products_image->filename;
? ? ? ? ?} else {
? ? ? ? ? ?$products_image_name = (isset($HTTP_POST_VARS['products_previous_image']) ? $HTTP_POST_VARS['products_previous_image'] : '');
? ? ? ? ?}
? ? ? ?} else {
? ? ? ? ?if (isset($HTTP_POST_VARS['products_image']) && tep_not_null($HTTP_POST_VARS['products_image']) && ($HTTP_POST_VARS['products_image'] != 'none')) {
? ? ? ? ? ?$products_image_name = $HTTP_POST_VARS['products_image'];
? ? ? ? ?} else {
? ? ? ? ? ?$products_image_name = (isset($HTTP_POST_VARS['products_previous_image']) ? $HTTP_POST_VARS['products_previous_image'] : '');
? ? ? ? ?}
? ? ? ?}
? ? ? ?break;
? ?}
?}

// check if the catalog image directory exists
?if (is_dir(DIR_FS_CATALOG_IMAGES)) {
? ?if (!is_writeable(DIR_FS_CATALOG_IMAGES)) $messageStack->add(ERROR_CATALOG_IMAGE_DIRECTORY_NOT_WRITEABLE, 'error');
?} else {
? ?$messageStack->add(ERROR_CATALOG_IMAGE_DIRECTORY_DOES_NOT_EXIST, 'error');
?}
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<title><?php echo TITLE; ?></title>

? ? ? ?<script language="Javascript1.2"><!-- // load htmlarea
// MaxiDVD Added WYSIWYG HTML Area Box + Admin Function v1.7 - 2.2 MS2 Products Description HTML - Head
? ? ? ?_editor_url = "<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_ADMIN; ?>htmlarea/"; ?// URL to htmlarea files
? ? ? ? ?var win_ie_ver = parseFloat(navigator.appVersion.split("MSIE")[1]);
? ? ? ? ? if (navigator.userAgent.indexOf('Mac') ? ? ? ?>= 0) { win_ie_ver = 0; }
? ? ? ? ? ?if (navigator.userAgent.indexOf('Windows CE') >= 0) { win_ie_ver = 0; }
? ? ? ? ? ? if (navigator.userAgent.indexOf('Opera') ? ? ?>= 0) { win_ie_ver = 0; }
? ? ? ? <?php if (HTML_AREA_WYSIWYG_BASIC_PD == 'Basic'){ ?> ?if (win_ie_ver >= 5.5) {
? ? ? ? document.write('<scr' + 'ipt src="' +_editor_url+ 'editor_basic.js"');
? ? ? ? document.write(' language="Javascript1.2"></scr' + 'ipt>');
? ? ? ? ? ?} else { document.write('<scr'+'ipt>function editor_generate() { return false; }</scr'+'ipt>'); }
? ? ? ? <?php } else{ ?> if (win_ie_ver >= 5.5) {
? ? ? ? document.write('<scr' + 'ipt src="' +_editor_url+ 'editor_advanced.js"');
? ? ? ? document.write(' language="Javascript1.2"></scr' + 'ipt>');
? ? ? ? ? ?} else { document.write('<scr'+'ipt>function editor_generate() { return false; }</scr'+'ipt>'); }
? ? ? ? <?php }?>
// --></script>
?
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
<script language="javascript" src="includes/general.js"></script>
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF" onload="SetFocus();">
<div id="spiffycalendar" class="text"></div>
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" width="100%" cellspacing="2" cellpadding="2">
?<tr>
? ?<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
? ?</table></td>
<!-- body_text //-->
? ?<td width="100%" valign="top">
<?php
?if ($action == 'new_product') {
? ?$parameters = array('products_name' => '',
? ? ? ? ? ? ? ? ? ? ? 'products_description' => '',
? ? ? ? ? ? ? ? ? ? ? 'products_url' => '',
? ? ? ? ? ? ? ? ? ? ? 'products_id' => '',
? ? ? ? ? ? ? ? ? ? ? 'products_quantity' => '',
? ? ? ? ? ? ? ? ? ? ? 'products_model' => '',
? ? ? ? ? ? ? ? ? ? ? 'products_image' => '',
? ? ? ? ? ? ? ? ? ? ? 'products_price' => '',
? ? ? ? ? ? ? ? ? ? ? 'products_weight' => '',
? ? ? ? ? ? ? ? ? ? ? 'products_date_added' => '',
? ? ? ? ? ? ? ? ? ? ? 'products_last_modified' => '',
? ? ? ? ? ? ? ? ? ? ? 'products_date_available' => '',
? ? ? ? ? ? ? ? ? ? ? 'products_status' => '',
? ? ? ? ? ? ? ? ? ? ? ? //Master Products 
? ? ? ? ? ? ? ? ? ? ? 'products_listing_status' => '',
? ? ? ? ? ? ? ? ? ? ? 'products_tax_class_id' => '',
? ? ? ? ? ? ? ? ? ? ? 'manufacturers_id' => '');

? ?$pInfo = new objectInfo($parameters);

? ?if (isset($HTTP_GET_VARS['pID']) && empty($HTTP_POST_VARS)) {
? ? ?$product_query = tep_db_query("select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_listing_status, p.products_price, p.products_tax_class_id, p.manufacturers_id, p.products_master, products_master_status from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'");
//Master Products EOF
? ? ?$product = tep_db_fetch_array($product_query);

? ? ?$pInfo->objectInfo($product);
? ?} elseif (tep_not_null($HTTP_POST_VARS)) {
? ? ?$pInfo->objectInfo($HTTP_POST_VARS);
? ? ?$products_name = $HTTP_POST_VARS['products_name'];
? ? ?$products_description = $HTTP_POST_VARS['products_description'];
? ? ?$products_url = $HTTP_POST_VARS['products_url'];
? ?}

? ?$manufacturers_array = array(array('id' => '', 'text' => TEXT_NONE));
? ?$manufacturers_query = tep_db_query("select manufacturers_id, manufacturers_name from " . TABLE_MANUFACTURERS . " order by manufacturers_name");
? ?while ($manufacturers = tep_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 = tep_db_query("select tax_class_id, tax_class_title from " . TABLE_TAX_CLASS . " order by tax_class_title");
? ?while ($tax_class = tep_db_fetch_array($tax_class_query)) {
? ? ?$tax_class_array[] = array('id' => $tax_class['tax_class_id'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 'text' => $tax_class['tax_class_title']);
? ?}
// Master Products 
? ?$products_master_array = array(array('id' => ' ', 'text' => TEXT_MASTER_SELECT));
? ?$products_master_array[] = array('id' => '', 'text' => TEXT_NONE);

? ?$products_master_query = tep_db_query("select p.products_id, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_master_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by pd.products_name");
? ? ?
? ?while ($products_master = tep_db_fetch_array($products_master_query)) {
? ?$products_master_array[] = array('id' => $products_master['products_id'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 'text' => $products_master['products_name']);
? ?}
// Master Products EOF ? 
? ?$languages = tep_get_languages();

? ?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; $out_status = false;
? ?}

//Master Products ? ?
? ?if (!isset($pInfo->products_listing_status)) $pInfo->products_listing_status = '1';
? ?switch ($pInfo->products_listing_status) {
? ? ?case '0': $in_listing_status = false; $out_listing_status = true; break;
? ? ?case '1':
? ? ?default: $in_listing_status = true; $out_listing_status = false;
? ?} 
? ?
? ?if (!isset($pInfo->products_master_status)) $pInfo->products_master_status = '1';
? ?switch ($pInfo->products_master_status) {
? ? ?case '0': $in_master_status = false; $out_master_status = true; break;
? ? ?case '1':
? ? ?default: $in_master_status = true; $out_master_status = false;
? ?} ? ? 
//Master Products EOF ? ? ? 

?>
<link rel="stylesheet" type="text/css" href="includes/javascript/spiffyCal/spiffyCal_v2_1.css">
<script language="JavaScript" src="includes/javascript/spiffyCal/spiffyCal_v2_1.js"></script>
<script language="javascript"><!--
?var dateAvailable = new ctlSpiffyCalendarBox("dateAvailable", "new_product", "products_date_available","btnDate1","<?php echo $pInfo->products_date_available; ?>",scBTNMODE_CUSTOMBLUE);
//--></script>
<script language="javascript"><!--
var tax_rates = new Array();
<?php
? ?for ($i=0, $n=sizeof($tax_class_array); $i<$n; $i++) {
? ? ?if ($tax_class_array[$i]['id'] > 0) {
? ? ? ?echo 'tax_rates["' . $tax_class_array[$i]['id'] . '"] = ' . tep_get_tax_rate_value($tax_class_array[$i]['id']) . ';' . "\n";
? ? ?}
? ?}
?>

function doRound(x, places) {
?return Math.round(x * Math.pow(10, places)) / Math.pow(10, places);
}

function getTaxRate() {
?var selected_value = document.forms["new_product"].products_tax_class_id.selectedIndex;
?var parameterVal = document.forms["new_product"].products_tax_class_id[selected_value].value;

?if ( (parameterVal > 0) && (tax_rates[parameterVal] > 0) ) {
? ?return tax_rates[parameterVal];
?} else {
? ?return 0;
?}
}

function updateGross() {
?var taxRate = getTaxRate();
?var grossValue = document.forms["new_product"].products_price.value;

?if (taxRate > 0) {
? ?grossValue = grossValue * ((taxRate / 100) + 1);
?}

?document.forms["new_product"].products_price_gross.value = doRound(grossValue, 4);
}

function updateNet() {
?var taxRate = getTaxRate();
?var netValue = document.forms["new_product"].products_price_gross.value;

?if (taxRate > 0) {
? ?netValue = netValue / ((taxRate / 100) + 1);
?}

?document.forms["new_product"].products_price.value = doRound(netValue, 4);
}
// Master Products
function updateProductsMaster() {
?var selected_value = document.forms["new_product"].products_master_select.selectedIndex;
?var masValue = document.forms["new_product"].products_master_select[selected_value].value;
?document.forms["new_product"].products_master.value = masValue;
?document.forms["new_product"].products_master_select.selectedIndex = 0;
}
// Master Products EOF
//--></script>
? ?<?php echo tep_draw_form('new_product', FILENAME_CATEGORIES, 'cPath=' . $cPath . (isset($HTTP_GET_VARS['pID']) ? '&pID=' . $HTTP_GET_VARS['pID'] : '') . '&action=new_product_preview', 'post', 'enctype="multipart/form-data"'); ?>
? ?<table border="0" width="100%" cellspacing="0" cellpadding="2">
? ? ?<tr>
? ? ? ?<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
? ? ? ? ?<tr>
? ? ? ? ? ?<td class="pageHeading"><?php echo sprintf(TEXT_NEW_PRODUCT, tep_output_generated_category_path($current_category_id)); ?></td>
? ? ? ? ? ?<td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>
? ? ? ? ?</tr>
? ? ? ?</table></td>
? ? ?</tr>
? ? ?<tr>
? ? ? ?<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
? ? ?</tr>
? ? ?<tr>
? ? ? ?<td><table border="0" cellspacing="0" cellpadding="2">
? ? ? ? ?<tr>
? ? ? ? ? ?<td class="main"><?php echo TEXT_PRODUCTS_STATUS; ?></td>
? ? ? ? ? ?<td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_radio_field('products_status', '1', $in_status) . ' ' . TEXT_PRODUCT_AVAILABLE . ' ' . tep_draw_radio_field('products_status', '0', $out_status) . ' ' . TEXT_PRODUCT_NOT_AVAILABLE; ?></td>
? ? ? ? ?</tr>
? ? ? ? ?<tr>
? ? ? ? ? ?<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
? ? ? ? ?</tr>
? ? ? ? ?<tr>
? ? ? ? ? ?<td class="main"><?php echo TEXT_PRODUCTS_DATE_AVAILABLE; ?><br><small>(YYYY-MM-DD)</small></td>
? ? ? ? ? ?<td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' '; ?><script language="javascript">dateAvailable.writeControl(); dateAvailable.dateFormat="yyyy-MM-dd";</script>&

Link to comment
Share on other sites

Ok,, I changed line 1014 the section that refers to images to the following

 

<tr>
           <td class="main"><?php echo TEXT_PRODUCTS_IMAGE; ?></td>
       <?php if (HTML_AREA_WYSIWYG_DISABLE == 'Disable') { ?>
           <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_file_field('products_image') . '<br>' . tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . $pInfo->products_image . tep_draw_hidden_field('products_previous_image', $pInfo->products_image); ?></td>
       <?php }else{ ?>
           <td class="main"><?php echo '<table border="0" cellspacing="0" cellpadding="0"><tr><td class="main">' . tep_draw_separator('pixel_trans.gif', '24', '15') . '  </td><td class="main">' . tep_draw_textarea_field('products_image', 'soft', '70', '2', $pInfo->products_image) . tep_draw_hidden_field('products_previous_image', $pInfo->products_image) . '</td></tr></table>'; ?></td>
       <?php } ?>
         </tr>

 

Everything seems to work fine.

I will test it some more and then see about cleaning things up for a contrib

 

Kirk

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...