198 replies to this topic

[kymation]

The Categories Images Box is a box on the main (index) page of your site that shows an image (and optional text) for each of your top-level categories.

The categories can be diplayed in a grid (like the New Products box) or in rows like the Category product list. Images can be different than the images at the top of each category page. Images, the category name, and the text can be separately enabled in the admin.

The box itself can look the same as all other osCommerce boxes (Stock), a plain outline box with no header (Simple), or as plain text/images with no borders at all (Plain).

Screenshots are included in the contribution download for each of the above styles and for the admin functions.

The contribution is here.

Regards
Jim

Edited by kymation, 20 November 2008 - 05:54 AM.

[pantarra]

Very Nice Contrib

can the Catagory main page show the sub images on the bottom  meaning I use the maim image on top and the sub pages ( dresses tops etc on the bottom be the second image in your contribution Ive enclosed screen capture

also can I make the colums 4 instead of 3?

Thank You
[img]http://www.zestfashions.com/images/Ss7.jpg[/img]

[kymation]

If I'm understanding you correctly here, the answer is yes, you can make your index page look like that screenshot. You would need to put your main image in the define for TEXT_MAIN, or modify the page to insert it directly. This contribution will take care of the images for each of the main categories below that.

And yes, you can set the number of columns in the Admin. It's a puzzle to me why this wasn't done throughout osCommerce.

Regards
Jim

[katomy]

Hello,

I've installed the contribution, but since i had a few mods done to the index page i just patch the files, as per instructed, but now i have the following error

Warning: Division by zero in /includes/modules/categories_images.php on line 72

Any ideas ? , i've gone through the files three times and found no error, plus the error is on the file i just uploaded to the /includes/modules/categories_images.php


Thank you and great contribution

[kymation]

Congratulations, you've found a bug. Change Line 72 of that file to:

		  $width = (floor (100 / CATEGORIES_IMAGES_BOX_COLUMNS) );

Sorry for the inconvenience. That's what I get for trying to reuse code and forgetting to change all of the constants.

Regards
Jim

[katomy]

Thank you for the quick response, working fine now


Great contribution

Once again
Thank you

[talbot649]

Hi there,

I've got both Categories Images Box and Header Tags SEO installed on my shop. I've just finished adding the Categories Images Boxes contribution and I think it might be clashing with Header Tags SEO in catalog/admin/categories.php.

When I try to select the catalog option from the left hand side of the admin panel the page just goes blank. Much of the inserted code for this contribution goes either side of the Header Tags SEO contribution, and I need some help!!!!

I've pasted the code for this page below - any help anyone can give would be much appreciated

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' => (int)$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'];
		  
		  /*** Begin Header Tags SEO ***/
		  $categories_htc_title_array = $HTTP_POST_VARS['categories_htc_title_tag'];
		  $categories_htc_desc_array = $HTTP_POST_VARS['categories_htc_desc_tag'];
		  $categories_htc_keywords_array = $HTTP_POST_VARS['categories_htc_keywords_tag'];
		  $categories_htc_description_array = $HTTP_POST_VARS['categories_htc_description'];
		  /*** End Header Tags SEO ***/		  

		  $language_id = $languages[$i]['id'];
		  
	  /*** Begin Header Tags SEO ***/
	  $sql_data_array = array('categories_name' => tep_db_prepare_input($categories_name_array[$language_id]),
		   'categories_htc_title_tag' => (tep_not_null($categories_htc_title_array[$language_id]) ? tep_db_prepare_input($categories_htc_title_array[$language_id]) :  tep_db_prepare_input($categories_name_array[$language_id])),
		   'categories_htc_desc_tag' => (tep_not_null($categories_htc_desc_array[$language_id]) ? tep_db_prepare_input($categories_htc_desc_array[$language_id]) :  tep_db_prepare_input($categories_name_array[$language_id])),
		   'categories_htc_keywords_tag' => (tep_not_null($categories_htc_keywords_array[$language_id]) ? tep_db_prepare_input($categories_htc_keywords_array[$language_id]) :  tep_db_prepare_input($categories_name_array[$language_id])),
		   'categories_htc_description' => tep_db_prepare_input($categories_htc_description_array[$language_id]));
	  /*** End Header Tags SEO ***/
	  
// Start Categories images box
		  $categories_description_front_array = $_POST['categories_description_front'];
		  $sql_data_array = array ('categories_name' => tep_db_prepare_input ($categories_name_array[$language_id] ),
								   'categories_description_front' => tep_db_prepare_input ($categories_description_front_array[$language_id] ) );
// End Categories images box	  

		  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'] . "'");
		  }
		}

		$categories_image = new upload('categories_image');
		$categories_image->set_destination(DIR_FS_CATALOG_IMAGES);

		if ($categories_image->parse() && $categories_image->save()) {
		  tep_db_query("update " . TABLE_CATEGORIES . " set categories_image = '" . tep_db_input($categories_image->filename) . "' where categories_id = '" . (int)$categories_id . "'");
		}

// Start Categories images box
		$categories_image_front = new upload ('categories_image_front');
		$categories_image_front->set_destination (DIR_FS_CATALOG_IMAGES);
		
		if ($categories_image_front->parse() && $categories_image_front->save()) {
		  tep_db_query ("update " . TABLE_CATEGORIES . " set categories_image_front = '" . tep_db_input ($categories_image_front->filename) . "' where categories_id = '" . (int) $categories_id . "'");
		}
// End Categories images box		

		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' => (int)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' => (float)tep_db_prepare_input($HTTP_POST_VARS['products_weight']),
								  'products_status' => tep_db_prepare_input($HTTP_POST_VARS['products_status']),
								  'products_tax_class_id' => tep_db_prepare_input($HTTP_POST_VARS['products_tax_class_id']),
								  'manufacturers_id' => (int)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_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'];

		   /*** Begin Header Tags SEO ***/
			$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]),
									'products_head_title_tag' => ((tep_not_null($HTTP_POST_VARS['products_head_title_tag'][$language_id])) ? tep_db_prepare_input($HTTP_POST_VARS['products_head_title_tag'][$language_id]) : tep_db_prepare_input($HTTP_POST_VARS['products_name'][$language_id])),
									'products_head_desc_tag' => ((tep_not_null($HTTP_POST_VARS['products_head_desc_tag'][$language_id])) ? tep_db_prepare_input($HTTP_POST_VARS['products_head_desc_tag'][$language_id]) : tep_db_prepare_input($HTTP_POST_VARS['products_name'][$language_id])),
									'products_head_keywords_tag' => ((tep_not_null($HTTP_POST_VARS['products_head_keywords_tag'][$language_id])) ? tep_db_prepare_input($HTTP_POST_VARS['products_head_keywords_tag'][$language_id]) : tep_db_prepare_input($HTTP_POST_VARS['products_name'][$language_id])));									 
		   /*** End Header Tags SEO ***/

			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;
	  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') {
			$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 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) 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(), " . (empty($product['products_date_available']) ? "null" : "'" . tep_db_input($product['products_date_available']) . "'") . ", '" . tep_db_input($product['products_weight']) . "', '0', '" . (int)$product['products_tax_class_id'] . "', '" . (int)$product['manufacturers_id'] . "')");
			$dup_products_id = tep_db_insert_id();

		   /*** Begin Header Tags SEO ***/
			$description_query = tep_db_query("select language_id, products_name, products_description, products_head_title_tag, products_head_desc_tag, products_head_keywords_tag, 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_head_title_tag, products_head_desc_tag, products_head_keywords_tag, 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_head_title_tag']) . "', '" . tep_db_input($description['products_head_desc_tag']) . "', '" . tep_db_input($description['products_head_keywords_tag']) . "', '" . tep_db_input($description['products_url']) . "', '0')");
			}	   
		   /*** End Header Tags SEO ***/

			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':
// 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'] : '');
		}
		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>
<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' => '',
						   'products_tax_class_id' => '',
					   'manufacturers_id' => '');

	$pInfo = new objectInfo($parameters);

   /*** Begin Header Tags SEO ***/
   if (isset ($HTTP_GET_VARS['pID']) && (!$HTTP_POST_VARS) ) {
	  $product_query = tep_db_query("select pd.products_name, pd.products_description, pd.products_head_title_tag, pd.products_head_desc_tag, pd.products_head_keywords_tag, 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_tax_class_id, p.manufacturers_id 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 . "'");
	  $product = tep_db_fetch_array($product_query);							
   /*** End Header Tags SEO ***/

	  $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']);
	}

	$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;
	}
?>
<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);
}
//--></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') . '&nbsp;' . tep_draw_radio_field('products_status', '1', $in_status) . '&nbsp;' . TEXT_PRODUCT_AVAILABLE . '&nbsp;' . tep_draw_radio_field('products_status', '0', $out_status) . '&nbsp;' . 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') . '&nbsp;'; ?><script language="javascript">dateAvailable.writeControl(); dateAvailable.dateFormat="yyyy-MM-dd";</script></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_MANUFACTURER; ?></td>
			<td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . '&nbsp;' . tep_draw_pull_down_menu('manufacturers_id', $manufacturers_array, $pInfo->manufacturers_id); ?></td>
		  </tr>
		  <tr>
			<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
		  </tr>
<?php
	for ($i=0, $n=sizeof($languages); $i<$n; $i++) {
?>
		  <tr>
			<td class="main"><?php if ($i == 0) echo TEXT_PRODUCTS_NAME; ?></td>
			<td class="main"><?php echo tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']) . '&nbsp;' . tep_draw_input_field('products_name[' . $languages[$i]['id'] . ']', (isset($products_name[$languages[$i]['id']]) ? stripslashes($products_name[$languages[$i]['id']]) : tep_get_products_name($pInfo->products_id, $languages[$i]['id']))); ?></td>
		  </tr>
<?php
	}
?>
		  <tr>
			<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
		  </tr>
		  <tr bgcolor="#ebebff">
			<td class="main"><?php echo TEXT_PRODUCTS_TAX_CLASS; ?></td>
			<td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . '&nbsp;' . tep_draw_pull_down_menu('products_tax_class_id', $tax_class_array, $pInfo->products_tax_class_id, 'onchange="updateGross()"'); ?></td>
		  </tr>
		  <tr bgcolor="#ebebff">
			<td class="main"><?php echo TEXT_PRODUCTS_PRICE_NET; ?></td>
			<td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . '&nbsp;' . tep_draw_input_field('products_price', $pInfo->products_price, 'onkeyup="updateGross()"'); ?></td>
		  </tr>
		  <tr bgcolor="#ebebff">
			<td class="main"><?php echo TEXT_PRODUCTS_PRICE_GROSS; ?></td>
			<td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . '&nbsp;' . tep_draw_input_field('products_price_gross', $pInfo->products_price, 'onkeyup="updateNet()"'); ?></td>
		  </tr>
		  <tr>
			<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
		  </tr>
<script language="javascript"><!--
updateGross();
//--></script>
<!-- /*** Begin Header Tags SEO ***/ //-->
<?php
	for ($i=0, $n=sizeof($languages); $i<$n; $i++) {
?>
		 <tr>
			<td class="main" valign="top"><?php if ($i == 0) echo TEXT_PRODUCTS_DESCRIPTION; ?></td>
			<td><table border="0" cellspacing="0" cellpadding="0">
			  <tr>
				<td class="main" valign="top"><?php echo tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']); ?>&nbsp;</td>
				<td class="main"><?php echo tep_draw_textarea_field('products_description[' . $languages[$i]['id'] . ']', 'soft', '70', '15', (isset($products_description[$languages[$i]['id']]) ? stripslashes($products_description[$languages[$i]['id']]) : tep_get_products_description($pInfo->products_id, $languages[$i]['id']))); ?></td>
			  </tr>
			</table></td>
		  </tr>
<?php
	}
?>
		  <tr>
			<td colspan="2" class="main"><hr><?php echo TEXT_PRODUCT_METTA_INFO; ?></td>
		  </tr>
		  <tr>
			<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
		  </tr>		  
<?php		 
	for ($i=0, $n=sizeof($languages); $i<$n; $i++) {
?>
		  <tr>
			<td class="main" valign="top"><?php if ($i == 0) echo TEXT_PRODUCTS_PAGE_TITLE; ?></td>
			<td><table border="0" cellspacing="0" cellpadding="0">
			  <tr>
				<td class="main" valign="top"><?php echo tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']); ?>&nbsp;</td>
				<td class="main"><?php echo tep_draw_textarea_field('products_head_title_tag[' . $languages[$i]['id'] . ']', 'soft', '70', '5', (isset($products_head_title_tag[$languages[$i]['id']]) ? stripslashes($products_head_title_tag[$languages[$i]['id']]) : tep_get_products_head_title_tag($pInfo->products_id, $languages[$i]['id']))); ?></td>
			  </tr>
			</table></td>
		  </tr>
<?php
	}
	for ($i=0, $n=sizeof($languages); $i<$n; $i++) {
?>
		  <tr>
			<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
		  </tr>		  
		   <tr>
			<td class="main" valign="top"><?php if ($i == 0) echo TEXT_PRODUCTS_HEADER_DESCRIPTION; ?></td>
			<td><table border="0" cellspacing="0" cellpadding="0">
			  <tr>
				<td class="main" valign="top"><?php echo tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']); ?>&nbsp;</td>
				<td class="main"><?php echo tep_draw_textarea_field('products_head_desc_tag[' . $languages[$i]['id'] . ']', 'soft', '70', '5', (isset($products_head_desc_tag[$languages[$i]['id']]) ? stripslashes($products_head_desc_tag[$languages[$i]['id']]) : tep_get_products_head_desc_tag($pInfo->products_id, $languages[$i]['id']))); ?></td>
			  </tr>
			</table></td>
		  </tr>
<?php
	}
	for ($i=0, $n=sizeof($languages); $i<$n; $i++) {
?>
		  <tr>
			<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
		  </tr>		  
		   <tr>
			<td class="main" valign="top"><?php if ($i == 0) echo TEXT_PRODUCTS_KEYWORDS; ?></td>
			<td><table border="0" cellspacing="0" cellpadding="0">
			  <tr>
				<td class="main" valign="top"><?php echo tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']); ?>&nbsp;</td>
				<td class="main"><?php echo tep_draw_textarea_field('products_head_keywords_tag[' . $languages[$i]['id'] . ']', 'soft', '70', '5', (isset($products_head_keywords_tag[$languages[$i]['id']]) ? stripslashes($products_head_keywords_tag[$languages[$i]['id']]) : tep_get_products_head_keywords_tag($pInfo->products_id, $languages[$i]['id']))); ?></td>
			  </tr>
			</table></td>
		  </tr>
<?php
	}
?>
		  <tr>
			<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
		  </tr>
		  <tr>
			<td colspan="2" class="main"><hr></td>
		  </tr>
<!-- /*** End Header Tags SEO ***/ //-->
		  <tr>
			<td class="main"><?php echo TEXT_PRODUCTS_QUANTITY; ?></td>
			<td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . '&nbsp;' . tep_draw_input_field('products_quantity', $pInfo->products_quantity); ?></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_MODEL; ?></td>
			<td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . '&nbsp;' . tep_draw_input_field('products_model', $pInfo->products_model); ?></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_IMAGE; ?></td>
			<td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . '&nbsp;' . tep_draw_file_field('products_image') . '<br>' . tep_draw_separator('pixel_trans.gif', '24', '15') . '&nbsp;' . $pInfo->products_image . tep_draw_hidden_field('products_previous_image', $pInfo->products_image); ?></td>
		  </tr>
		  <tr>
			<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
		  </tr>
<?php
	for ($i=0, $n=sizeof($languages); $i<$n; $i++) {
?>
		  <tr>
			<td class="main"><?php if ($i == 0) echo TEXT_PRODUCTS_URL . '<br><small>' . TEXT_PRODUCTS_URL_WITHOUT_HTTP . '</small>'; ?></td>
			<td class="main"><?php echo tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']) . '&nbsp;' . tep_draw_input_field('products_url[' . $languages[$i]['id'] . ']', (isset($products_url[$languages[$i]['id']]) ? stripslashes($products_url[$languages[$i]['id']]) : tep_get_products_url($pInfo->products_id, $languages[$i]['id']))); ?></td>
		  </tr>
<?php
	}
?>
		  <tr>
			<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
		  </tr>
		  <tr>
			<td class="main"><?php echo TEXT_PRODUCTS_WEIGHT; ?></td>
			<td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . '&nbsp;' . tep_draw_input_field('products_weight', $pInfo->products_weight); ?></td>
		  </tr>
		</table></td>
	  </tr>
	  <tr>
		<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
	  </tr>
	  <tr>
		<td class="main" align="right"><?php echo tep_draw_hidden_field('products_date_added', (tep_not_null($pInfo->products_date_added) ? $pInfo->products_date_added : date('Y-m-d'))) . tep_image_submit('button_preview.gif', IMAGE_PREVIEW) . '&nbsp;&nbsp;<a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . (isset($HTTP_GET_VARS['pID']) ? '&pID=' . $HTTP_GET_VARS['pID'] : '')) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>'; ?></td>
	  </tr>
	</table></form>
<!-- /*** Begin Header Tags SEO ***/ //-->	 
<?php
  } elseif ($action == 'new_product_preview') {
	if (tep_not_null($HTTP_POST_VARS)) {
	  $pInfo = new objectInfo($HTTP_POST_VARS);
	  $products_name = $HTTP_POST_VARS['products_name'];
	  $products_description = $HTTP_POST_VARS['products_description'];
	  $products_head_title_tag = $HTTP_POST_VARS['products_head_title_tag'];
	  $products_head_desc_tag = $HTTP_POST_VARS['products_head_desc_tag'];
	  $products_head_keywords_tag = $HTTP_POST_VARS['products_head_keywords_tag'];
	  $products_url = $HTTP_POST_VARS['products_url'];
	} else {
	  $product_query = tep_db_query("select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_head_title_tag, pd.products_head_desc_tag, pd.products_head_keywords_tag, pd.products_url, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id  from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "'");
	  $product = tep_db_fetch_array($product_query); 
 /*** End Header Tags SEO ***/

	  $pInfo = new objectInfo($product);
	  $products_image_name = $pInfo->products_image;
	}

	$form_action = (isset($HTTP_GET_VARS['pID'])) ? 'update_product' : 'insert_product';

	echo tep_draw_form($form_action, FILENAME_CATEGORIES, 'cPath=' . $cPath . (isset($HTTP_GET_VARS['pID']) ? '&pID=' . $HTTP_GET_VARS['pID'] : '') . '&action=' . $form_action, 'post', 'enctype="multipart/form-data"');

	/*** Begin Header Tags SEO ***/	   
	$languages = tep_get_languages();
	for ($i=0, $n=sizeof($languages); $i<$n; $i++) {
	  if (isset($HTTP_GET_VARS['read']) && ($HTTP_GET_VARS['read'] == 'only')) {
		$pInfo->products_name = tep_get_products_name($pInfo->products_id, $languages[$i]['id']);
		$pInfo->products_description = tep_get_products_description($pInfo->products_id, $languages[$i]['id']);
		$pInfo->products_head_title_tag = tep_db_prepare_input($products_head_title_tag[$languages[$i]['id']]);
		$pInfo->products_head_desc_tag = tep_db_prepare_input($products_head_desc_tag[$languages[$i]['id']]);
		$pInfo->products_head_keywords_tag = tep_db_prepare_input($products_head_keywords_tag[$languages[$i]['id']]);
		$pInfo->products_url = tep_get_products_url($pInfo->products_id, $languages[$i]['id']);
	  } else {
		$pInfo->products_name = tep_db_prepare_input($products_name[$languages[$i]['id']]);
		$pInfo->products_description = tep_db_prepare_input($products_description[$languages[$i]['id']]);
		$pInfo->products_head_title_tag = tep_db_prepare_input($products_head_title_tag[$languages[$i]['id']]);
		$pInfo->products_head_desc_tag = tep_db_prepare_input($products_head_desc_tag[$languages[$i]['id']]);
		$pInfo->products_head_keywords_tag = tep_db_prepare_input($products_head_keywords_tag[$languages[$i]['id']]);
		$pInfo->products_url = tep_db_prepare_input($products_url[$languages[$i]['id']]);
	  }		 
	/*** End Header Tags SEO ***/
?>
	<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 tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']) . '&nbsp;' . $pInfo->products_name; ?></td>
			<td class="pageHeading" align="right"><?php echo $currencies->format($pInfo->products_price); ?></td>
		  </tr>
		</table></td>
	  </tr>
	  <tr>
		<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
	  </tr>
	  <tr>
		<td class="main"><?php echo tep_image(DIR_WS_CATALOG_IMAGES . $products_image_name, $pInfo->products_name, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'align="right" hspace="5" vspace="5"') . $pInfo->products_description; ?></td>
	  </tr>
<?php
	  if ($pInfo->products_url) {
?>
	  <tr>
		<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
	  </tr>
	  <tr>
		<td class="main"><?php echo sprintf(TEXT_PRODUCT_MORE_INFORMATION, $pInfo->products_url); ?></td>
	  </tr>
<?php
	  }
?>
	  <tr>
		<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
	  </tr>
<?php
	  if ($pInfo->products_date_available > date('Y-m-d')) {
?>
	  <tr>
		<td align="center" class="smallText"><?php echo sprintf(TEXT_PRODUCT_DATE_AVAILABLE, tep_date_long($pInfo->products_date_available)); ?></td>
	  </tr>
<?php
	  } else {
?>
	  <tr>
		<td align="center" class="smallText"><?php echo sprintf(TEXT_PRODUCT_DATE_ADDED, tep_date_long($pInfo->products_date_added)); ?></td>
	  </tr>
<?php
	  }
?>
	  <tr>
		<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
	  </tr>
<?php
	}

	if (isset($HTTP_GET_VARS['read']) && ($HTTP_GET_VARS['read'] == 'only')) {
	  if (isset($HTTP_GET_VARS['origin'])) {
		$pos_params = strpos($HTTP_GET_VARS['origin'], '?', 0);
		if ($pos_params != false) {
		  $back_url = substr($HTTP_GET_VARS['origin'], 0, $pos_params);
		  $back_url_params = substr($HTTP_GET_VARS['origin'], $pos_params + 1);
		} else {
		  $back_url = $HTTP_GET_VARS['origin'];
		  $back_url_params = '';
		}
	  } else {
		$back_url = FILENAME_CATEGORIES;
		$back_url_params = 'cPath=' . $cPath . '&pID=' . $pInfo->products_id;
	  }
?>
	  <tr>
		<td align="right"><?php echo '<a href="' . tep_href_link($back_url, $back_url_params, 'NONSSL') . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a>'; ?></td>
	  </tr>
<?php
	} else {
?>
	  <tr>
		<td align="right" class="smallText">
<?php
/* Re-Post all POST'ed variables */
	  reset($HTTP_POST_VARS);
	  while (list($key, $value) = each($HTTP_POST_VARS)) {
		if (!is_array($HTTP_POST_VARS[$key])) {
		  echo tep_draw_hidden_field($key, htmlspecialchars(stripslashes($value)));
		}
	  }
	  /*** Begin Header Tags SEO ***/
	  $languages = tep_get_languages();
	  for ($i=0, $n=sizeof($languages); $i<$n; $i++) {
		echo tep_draw_hidden_field('products_name[' . $languages[$i]['id'] . ']', htmlspecialchars(stripslashes($products_name[$languages[$i]['id']])));
		echo tep_draw_hidden_field('products_description[' . $languages[$i]['id'] . ']', htmlspecialchars(stripslashes($products_description[$languages[$i]['id']])));
		echo tep_draw_hidden_field('products_head_title_tag[' . $languages[$i]['id'] . ']', htmlspecialchars(stripslashes($products_head_title_tag[$languages[$i]['id']])));
		echo tep_draw_hidden_field('products_head_desc_tag[' . $languages[$i]['id'] . ']', htmlspecialchars(stripslashes($products_head_desc_tag[$languages[$i]['id']])));
		echo tep_draw_hidden_field('products_head_keywords_tag[' . $languages[$i]['id'] . ']', htmlspecialchars(stripslashes($products_head_keywords_tag[$languages[$i]['id']])));
		echo tep_draw_hidden_field('products_url[' . $languages[$i]['id'] . ']', htmlspecialchars(stripslashes($products_url[$languages[$i]['id']])));
	  }	   
	  /*** End Header Tags SEO ***/
	  echo tep_draw_hidden_field('products_image', stripslashes($products_image_name));

	  echo tep_image_submit('button_back.gif', IMAGE_BACK, 'name="edit"') . '&nbsp;&nbsp;';

	  if (isset($HTTP_GET_VARS['pID'])) {
		echo tep_image_submit('button_update.gif', IMAGE_UPDATE);
	  } else {
		echo tep_image_submit('button_insert.gif', IMAGE_INSERT);
	  }
	  echo '&nbsp;&nbsp;<a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . (isset($HTTP_GET_VARS['pID']) ? '&pID=' . $HTTP_GET_VARS['pID'] : '')) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>';
?></td>
	  </tr>
	</table></form>
<?php
	}
  } else {
?>
	<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 HEADING_TITLE; ?></td>
			<td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td>
			<td align="right"><table border="0" width="100%" cellspacing="0" cellpadding="0">
			  <tr>
				<td class="smallText" align="right">
<?php
	echo tep_draw_form('search', FILENAME_CATEGORIES, '', 'get');
	echo HEADING_TITLE_SEARCH . ' ' . tep_draw_input_field('search');
	echo tep_hide_session_id() . '</form>';
?>
				</td>
			  </tr>
			  <tr>
				<td class="smallText" align="right">
<?php
	echo tep_draw_form('goto', FILENAME_CATEGORIES, '', 'get');
	echo HEADING_TITLE_GOTO . ' ' . tep_draw_pull_down_menu('cPath', tep_get_category_tree(), $current_category_id, 'onchange="this.form.submit();"');
	echo tep_hide_session_id() . '</form>';
?>
				</td>
			  </tr>
			</table></td>
		  </tr>
		</table></td>
	  </tr>
	  <tr>
		<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
		  <tr>
			<td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
			  <tr class="dataTableHeadingRow">
				<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CATEGORIES_PRODUCTS; ?></td>
				<td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_STATUS; ?></td>
				<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACTION; ?>&nbsp;</td>
			  </tr>
<?php
	$categories_count = 0;
	$rows = 0;
	if (isset($HTTP_GET_VARS['search'])) {
	  $search = tep_db_prepare_input($HTTP_GET_VARS['search']);
	  
// Categories images box
	  $categories_query = tep_db_query("select c.categories_id, cd.categories_name, cd.categories_description_front, c.categories_image, c.categories_image_front, c.parent_id, c.sort_order, c.date_added, c.last_modified from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' and cd.categories_name like '%" . tep_db_input($search) . "%' order by c.sort_order, cd.categories_name");
	} else {
// Categories images box	  

	/*** Begin Header Tags SEO ***/
	  $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, cd.categories_htc_title_tag, cd.categories_htc_desc_tag, cd.categories_htc_keywords_tag, cd.categories_htc_description from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' and cd.categories_name like '%" . tep_db_input($search) . "%' order by c.sort_order, cd.categories_name");
	} else {
	  $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, cd.categories_htc_title_tag, cd.categories_htc_desc_tag, cd.categories_htc_keywords_tag, cd.categories_htc_description from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$current_category_id . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by c.sort_order, cd.categories_name");
	/*** End Header Tags SEO ***/
	}
	while ($categories = tep_db_fetch_array($categories_query)) {
	  $categories_count++;
	  $rows++;

// Get parent_id for subcategories if search
	  if (isset($HTTP_GET_VARS['search'])) $cPath= $categories['parent_id'];

	  if ((!isset($HTTP_GET_VARS['cID']) && !isset($HTTP_GET_VARS['pID']) || (isset($HTTP_GET_VARS['cID']) && ($HTTP_GET_VARS['cID'] == $categories['categories_id']))) && !isset($cInfo) && (substr($action, 0, 3) != 'new')) {
		$category_childs = array('childs_count' => tep_childs_in_category_count($categories['categories_id']));
		$category_products = array('products_count' => tep_products_in_category_count($categories['categories_id']));

		$cInfo_array = array_merge($categories, $category_childs, $category_products);
		$cInfo = new objectInfo($cInfo_array);
	  }

	  if (isset($cInfo) && is_object($cInfo) && ($categories['categories_id'] == $cInfo->categories_id) ) {
		echo '			  <tr id="defaultSelected" class="dataTableRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link(FILENAME_CATEGORIES, tep_get_path($categories['categories_id'])) . '\'">' . "\n";
	  } else {
		echo '			  <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&cID=' . $categories['categories_id']) . '\'">' . "\n";
	  }
?>
				<td class="dataTableContent"><?php echo '<a href="' . tep_href_link(FILENAME_CATEGORIES, tep_get_path($categories['categories_id'])) . '">' . tep_image(DIR_WS_ICONS . 'folder.gif', ICON_FOLDER) . '</a>&nbsp;<b>' . $categories['categories_name'] . '</b>'; ?></td>
				<td class="dataTableContent" align="center">&nbsp;</td>
				<td class="dataTableContent" align="right"><?php if (isset($cInfo) && is_object($cInfo) && ($categories['categories_id'] == $cInfo->categories_id) ) { echo tep_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', ''); } else { echo '<a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&cID=' . $categories['categories_id']) . '">' . tep_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . '</a>'; } ?>&nbsp;</td>
			  </tr>
<?php
	}

	$products_count = 0;
	if (isset($HTTP_GET_VARS['search'])) {
	  $products_query = tep_db_query("select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p2c.categories_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and pd.products_name like '%" . tep_db_input($search) . "%' order by pd.products_name");
	} else {
	  $products_query = tep_db_query("select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$current_category_id . "' order by pd.products_name");
	}
	while ($products = tep_db_fetch_array($products_query)) {
	  $products_count++;
	  $rows++;

// Get categories_id for product if search
	  if (isset($HTTP_GET_VARS['search'])) $cPath = $products['categories_id'];

	  if ( (!isset($HTTP_GET_VARS['pID']) && !isset($HTTP_GET_VARS['cID']) || (isset($HTTP_GET_VARS['pID']) && ($HTTP_GET_VARS['pID'] == $products['products_id']))) && !isset($pInfo) && !isset($cInfo) && (substr($action, 0, 3) != 'new')) {
// find out the rating average from customer reviews
		$reviews_query = tep_db_query("select (avg(reviews_rating) / 5 * 100) as average_rating from " . TABLE_REVIEWS . " where products_id = '" . (int)$products['products_id'] . "'");
		$reviews = tep_db_fetch_array($reviews_query);
		$pInfo_array = array_merge($products, $reviews);
		$pInfo = new objectInfo($pInfo_array);
	  }

	  if (isset($pInfo) && is_object($pInfo) && ($products['products_id'] == $pInfo->products_id) ) {
		echo '			  <tr id="defaultSelected" class="dataTableRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $products['products_id'] . '&action=new_product_preview&read=only') . '\'">' . "\n";
	  } else {
		echo '			  <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $products['products_id']) . '\'">' . "\n";
	  }
?>
				<td class="dataTableContent"><?php echo '<a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $products['products_id'] . '&action=new_product_preview&read=only') . '">' . tep_image(DIR_WS_ICONS . 'preview.gif', ICON_PREVIEW) . '</a>&nbsp;' . $products['products_name']; ?></td>
				<td class="dataTableContent" align="center">
<?php
	  if ($products['products_status'] == '1') {
		echo tep_image(DIR_WS_IMAGES . 'icon_status_green.gif', IMAGE_ICON_STATUS_GREEN, 10, 10) . '&nbsp;&nbsp;<a href="' . tep_href_link(FILENAME_CATEGORIES, 'action=setflag&flag=0&pID=' . $products['products_id'] . '&cPath=' . $cPath) . '">' . tep_image(DIR_WS_IMAGES . 'icon_status_red_light.gif', IMAGE_ICON_STATUS_RED_LIGHT, 10, 10) . '</a>';
	  } else {
		echo '<a href="' . tep_href_link(FILENAME_CATEGORIES, 'action=setflag&flag=1&pID=' . $products['products_id'] . '&cPath=' . $cPath) . '">' . tep_image(DIR_WS_IMAGES . 'icon_status_green_light.gif', IMAGE_ICON_STATUS_GREEN_LIGHT, 10, 10) . '</a>&nbsp;&nbsp;' . tep_image(DIR_WS_IMAGES . 'icon_status_red.gif', IMAGE_ICON_STATUS_RED, 10, 10);
	  }
?></td>
				<td class="dataTableContent" align="right"><?php if (isset($pInfo) && is_object($pInfo) && ($products['products_id'] == $pInfo->products_id)) { echo tep_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', ''); } else { echo '<a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . '</a>'; } ?>&nbsp;</td>
			  </tr>
<?php
	}

	$cPath_back = '';
	if (sizeof($cPath_array) > 0) {
	  for ($i=0, $n=sizeof($cPath_array)-1; $i<$n; $i++) {
		if (empty($cPath_back)) {
		  $cPath_back .= $cPath_array[$i];
		} else {
		  $cPath_back .= '_' . $cPath_array[$i];
		}
	  }
	}

	$cPath_back = (tep_not_null($cPath_back)) ? 'cPath=' . $cPath_back . '&' : '';
?>
			  <tr>
				<td colspan="3"><table border="0" width="100%" cellspacing="0" cellpadding="2">
				  <tr>
					<td class="smallText"><?php echo TEXT_CATEGORIES . '&nbsp;' . $categories_count . '<br>' . TEXT_PRODUCTS . '&nbsp;' . $products_count; ?></td>
					<td align="right" class="smallText"><?php if (sizeof($cPath_array) > 0) echo '<a href="' . tep_href_link(FILENAME_CATEGORIES, $cPath_back . 'cID=' . $current_category_id) . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a>&nbsp;'; if (!isset($HTTP_GET_VARS['search'])) echo '<a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&action=new_category') . '">' . tep_image_button('button_new_category.gif', IMAGE_NEW_CATEGORY) . '</a>&nbsp;<a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&action=new_product') . '">' . tep_image_button('button_new_product.gif', IMAGE_NEW_PRODUCT) . '</a>'; ?>&nbsp;</td>
				  </tr>
				</table></td>
			  </tr>
			</table></td>
<?php
	$heading = array();
	$contents = array();
	switch ($action) {
	  case 'new_category':
		$heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_NEW_CATEGORY . '</b>');

		$contents = array('form' => tep_draw_form('newcategory', FILENAME_CATEGORIES, 'action=insert_category&cPath=' . $cPath, 'post', 'enctype="multipart/form-data"'));
		$contents[] = array('text' => TEXT_NEW_CATEGORY_INTRO);

		$category_inputs_string = '';
		$languages = tep_get_languages();
		for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {
		  $category_inputs_string .= '<br>' . tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']) . '&nbsp;' . tep_draw_input_field('categories_name[' . $languages[$i]['id'] . ']');
		  /*** Begin Header Tags SEO ***/
		  $category_htc_title_string .= '<br>' . tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']) . '&nbsp;' . tep_draw_input_field('categories_htc_title_tag[' . $languages[$i]['id'] . ']');
		  $category_htc_desc_string .= '<br>' . tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']) . '&nbsp;' . tep_draw_input_field('categories_htc_desc_tag[' . $languages[$i]['id'] . ']');
		  $category_htc_keywords_string .= '<br>' . tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']) . '&nbsp;' . tep_draw_input_field('categories_htc_keywords_tag[' . $languages[$i]['id'] . ']');
		  $category_htc_description_string .= '<br>' . tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']) . '&nbsp;' . tep_draw_textarea_field('categories_htc_description[' . $languages[$i]['id'] . ']', 'hard', 30, 5, '');
		  /*** End Header Tags SEO ***/		  
		}
		
// Start Categories Images box
		for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {
		  $category_description_inputs_string .= '<br>' . tep_image (DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']) . '&nbsp;' . tep_draw_textarea_field ('categories_description_front[' . $languages[$i]['id'] . ']', 30, 30, 3);
		}
// End Categories Images box		

		$contents[] = array('text' => '<br>' . TEXT_CATEGORIES_NAME . $category_inputs_string);
// Categories Images box
		$contents[] = array('text' => '<br>' . TEXT_CATEGORIES_DESCRIPTION . $category_description_inputs_string);
		$contents[] = array('text' => '<br>' . TEXT_CATEGORIES_IMAGE . '<br>' . tep_draw_file_field('categories_image'));
// Categories Images box		
		$contents[] = array('text' => '<br>' . TEXT_CATEGORIES_IMAGE . '<br>' . tep_draw_file_field('categories_image'));
		$contents[] = array('text' => '<br>' . TEXT_SORT_ORDER . '<br>' . tep_draw_input_field('sort_order', '', 'size="2"'));
		/*** Begin Header Tags SEO ***/
		$contents[] = array('text' => '<br>' . 'Header Tags Category Title' . $category_htc_title_string);
		$contents[] = array('text' => '<br>' . 'Header Tags Category Description' . $category_htc_desc_string);
		$contents[] = array('text' => '<br>' . 'Header Tags Category Keywords' . $category_htc_keywords_string);
		$contents[] = array('text' => '<br>' . 'Header Tags Categories Description' . $category_htc_description_string);
		/*** End Header Tags SEO ***/		
		$contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_save.gif', IMAGE_SAVE) . ' <a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');
		break;
	  case 'edit_category':
		$heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_EDIT_CATEGORY . '</b>');

		$contents = array('form' => tep_draw_form('categories', FILENAME_CATEGORIES, 'action=update_category&cPath=' . $cPath, 'post', 'enctype="multipart/form-data"') . tep_draw_hidden_field('categories_id', $cInfo->categories_id));
		$contents[] = array('text' => TEXT_EDIT_INTRO);

		$category_inputs_string = '';
		$languages = tep_get_languages();
		for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {
		  $category_inputs_string .= '<br>' . tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']) . '&nbsp;' . tep_draw_input_field('categories_name[' . $languages[$i]['id'] . ']', tep_get_category_name($cInfo->categories_id, $languages[$i]['id']));
		  /*** Begin Header Tags SEO ***/
		  $category_htc_title_string .= '<br>' . tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']) . '&nbsp;' . tep_draw_input_field('categories_htc_title_tag[' . $languages[$i]['id'] . ']', tep_get_category_htc_title($cInfo->categories_id, $languages[$i]['id']));
		  $category_htc_desc_string .= '<br>' . tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']) . '&nbsp;' . tep_draw_input_field('categories_htc_desc_tag[' . $languages[$i]['id'] . ']', tep_get_category_htc_desc($cInfo->categories_id, $languages[$i]['id']));
		  $category_htc_keywords_string .= '<br>' . tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']) . '&nbsp;' . tep_draw_input_field('categories_htc_keywords_tag[' . $languages[$i]['id'] . ']', tep_get_category_htc_keywords($cInfo->categories_id, $languages[$i]['id']));
		  $category_htc_description_string .= '<br>' . tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']) . '&nbsp;' . tep_draw_textarea_field('categories_htc_description[' . $languages[$i]['id'] . ']', 'hard', 30, 5, tep_get_category_htc_description($cInfo->categories_id, $languages[$i]['id']));
		  /*** End Header Tags SEO ***/		  
		}
		
// Start Categories Images box
		for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {
		  $category_description_inputs_string .= '<br>' . tep_image (DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']) . '&nbsp;' . tep_draw_textarea_field ('categories_description_front[' . $languages[$i]['id'] . ']', 30, 30, 3, tep_get_category_description_front ($cInfo->categories_id, $languages[$i]['id'] ) );
		}
// End Categories Images box		

		$contents[] = array('text' => '<br>' . TEXT_EDIT_CATEGORIES_NAME . $category_inputs_string);
// Categories Images box
		$contents[] = array('text' => '<br>' . TEXT_CATEGORIES_DESCRIPTION . $category_description_inputs_string);
		$contents[] = array('text' => '<br>' . tep_image(DIR_WS_CATALOG_IMAGES . $cInfo->categories_image, $cInfo->categories_name) . '<br>' . DIR_WS_CATALOG_IMAGES . '<br><b>' . $cInfo->categories_image . '</b>');
		$contents[] = array('text' => '<br>' . TEXT_EDIT_CATEGORIES_IMAGE . '<br>' . tep_draw_file_field('categories_image'));
// Categories Images box		
		$contents[] = array('text' => '<br>' . tep_image(DIR_WS_CATALOG_IMAGES . $cInfo->categories_image, $cInfo->categories_name) . '<br>' . DIR_WS_CATALOG_IMAGES . '<br><b>' . $cInfo->categories_image . '</b>');
		$contents[] = array('text' => '<br>' . TEXT_EDIT_CATEGORIES_IMAGE . '<br>' . tep_draw_file_field('categories_image'));
		$contents[] = array('text' => '<br>' . TEXT_EDIT_SORT_ORDER . '<br>' . tep_draw_input_field('sort_order', $cInfo->sort_order, 'size="2"'));
		/*** Begin Header Tags SEO ***/
		$contents[] = array('text' => '<br>' . 'Header Tags Category Title' . $category_htc_title_string);
		$contents[] = array('text' => '<br>' . 'Header Tags Category Description' . $category_htc_desc_string);
		$contents[] = array('text' => '<br>' . 'Header Tags Category Keywords' . $category_htc_keywords_string);
		$contents[] = array('text' => '<br>' . 'Header Tags Categories Description' . $category_htc_description_string);
		/*** End Header Tags SEO ***/		
		$contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_save.gif', IMAGE_SAVE) . ' <a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&cID=' . $cInfo->categories_id) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');
		break;
	  case 'delete_category':
		$heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_DELETE_CATEGORY . '</b>');

		$contents = array('form' => tep_draw_form('categories', FILENAME_CATEGORIES, 'action=delete_category_confirm&cPath=' . $cPath) . tep_draw_hidden_field('categories_id', $cInfo->categories_id));
		$contents[] = array('text' => TEXT_DELETE_CATEGORY_INTRO);
		$contents[] = array('text' => '<br><b>' . $cInfo->categories_name . '</b>');
		if ($cInfo->childs_count > 0) $contents[] = array('text' => '<br>' . sprintf(TEXT_DELETE_WARNING_CHILDS, $cInfo->childs_count));
		if ($cInfo->products_count > 0) $contents[] = array('text' => '<br>' . sprintf(TEXT_DELETE_WARNING_PRODUCTS, $cInfo->products_count));
		$contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_delete.gif', IMAGE_DELETE) . ' <a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&cID=' . $cInfo->categories_id) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');
		break;
	  case 'move_category':
		$heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_MOVE_CATEGORY . '</b>');

		$contents = array('form' => tep_draw_form('categories', FILENAME_CATEGORIES, 'action=move_category_confirm&cPath=' . $cPath) . tep_draw_hidden_field('categories_id', $cInfo->categories_id));
		$contents[] = array('text' => sprintf(TEXT_MOVE_CATEGORIES_INTRO, $cInfo->categories_name));
		$contents[] = array('text' => '<br>' . sprintf(TEXT_MOVE, $cInfo->categories_name) . '<br>' . tep_draw_pull_down_menu('move_to_category_id', tep_get_category_tree(), $current_category_id));
		$contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_move.gif', IMAGE_MOVE) . ' <a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&cID=' . $cInfo->categories_id) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');
		break;
	  case 'delete_product':
		$heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_DELETE_PRODUCT . '</b>');

		$contents = array('form' => tep_draw_form('products', FILENAME_CATEGORIES, 'action=delete_product_confirm&cPath=' . $cPath) . tep_draw_hidden_field('products_id', $pInfo->products_id));
		$contents[] = array('text' => TEXT_DELETE_PRODUCT_INTRO);
		$contents[] = array('text' => '<br><b>' . $pInfo->products_name . '</b>');

		$product_categories_string = '';
		$product_categories = tep_generate_category_path($pInfo->products_id, 'product');
		for ($i = 0, $n = sizeof($product_categories); $i < $n; $i++) {
		  $category_path = '';
		  for ($j = 0, $k = sizeof($product_categories[$i]); $j < $k; $j++) {
			$category_path .= $product_categories[$i][$j]['text'] . '&nbsp;&gt;&nbsp;';
		  }
		  $category_path = substr($category_path, 0, -16);
		  $product_categories_string .= tep_draw_checkbox_field('product_categories[]', $product_categories[$i][sizeof($product_categories[$i])-1]['id'], true) . '&nbsp;' . $category_path . '<br>';
		}
		$product_categories_string = substr($product_categories_string, 0, -4);

		$contents[] = array('text' => '<br>' . $product_categories_string);
		$contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_delete.gif', IMAGE_DELETE) . ' <a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $pInfo->products_id) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');
		break;
	  case 'move_product':
		$heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_MOVE_PRODUCT . '</b>');

		$contents = array('form' => tep_draw_form('products', FILENAME_CATEGORIES, 'action=move_product_confirm&cPath=' . $cPath) . tep_draw_hidden_field('products_id', $pInfo->products_id));
		$contents[] = array('text' => sprintf(TEXT_MOVE_PRODUCTS_INTRO, $pInfo->products_name));
		$contents[] = array('text' => '<br>' . TEXT_INFO_CURRENT_CATEGORIES . '<br><b>' . tep_output_generated_category_path($pInfo->products_id, 'product') . '</b>');
		$contents[] = array('text' => '<br>' . sprintf(TEXT_MOVE, $pInfo->products_name) . '<br>' . tep_draw_pull_down_menu('move_to_category_id', tep_get_category_tree(), $current_category_id));
		$contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_move.gif', IMAGE_MOVE) . ' <a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $pInfo->products_id) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');
		break;
	  case 'copy_to':
		$heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_COPY_TO . '</b>');

		$contents = array('form' => tep_draw_form('copy_to', FILENAME_CATEGORIES, 'action=copy_to_confirm&cPath=' . $cPath) . tep_draw_hidden_field('products_id', $pInfo->products_id));
		$contents[] = array('text' => TEXT_INFO_COPY_TO_INTRO);
		$contents[] = array('text' => '<br>' . TEXT_INFO_CURRENT_CATEGORIES . '<br><b>' . tep_output_generated_category_path($pInfo->products_id, 'product') . '</b>');
		$contents[] = array('text' => '<br>' . TEXT_CATEGORIES . '<br>' . tep_draw_pull_down_menu('categories_id', tep_get_category_tree(), $current_category_id));
		$contents[] = array('text' => '<br>' . TEXT_HOW_TO_COPY . '<br>' . tep_draw_radio_field('copy_as', 'link', true) . ' ' . TEXT_COPY_AS_LINK . '<br>' . tep_draw_radio_field('copy_as', 'duplicate') . ' ' . TEXT_COPY_AS_DUPLICATE);
		$contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_copy.gif', IMAGE_COPY) . ' <a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $pInfo->products_id) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');
		break;
	  default:
		if ($rows > 0) {
		  if (isset($cInfo) && is_object($cInfo)) { // category info box contents
			$category_path_string = '';
			$category_path = tep_generate_category_path($cInfo->categories_id);
			for ($i=(sizeof($category_path[0])-1); $i>0; $i--) {
			  $category_path_string .= $category_path[0][$i]['id'] . '_';
			}
			$category_path_string = substr($category_path_string, 0, -1);

			$heading[] = array('text' => '<b>' . $cInfo->categories_name . '</b>');

			$contents[] = array('align' => 'center', 'text' => '<a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $category_path_string . '&cID=' . $cInfo->categories_id . '&action=edit_category') . '">' . tep_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $category_path_string . '&cID=' . $cInfo->categories_id . '&action=delete_category') . '">' . tep_image_button('button_delete.gif', IMAGE_DELETE) . '</a> <a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $category_path_string . '&cID=' . $cInfo->categories_id . '&action=move_category') . '">' . tep_image_button('button_move.gif', IMAGE_MOVE) . '</a>');
			$contents[] = array('text' => '<br>' . TEXT_DATE_ADDED . ' ' . tep_date_short($cInfo->date_added));
			if (tep_not_null($cInfo->last_modified)) $contents[] = array('text' => TEXT_LAST_MODIFIED . ' ' . tep_date_short($cInfo->last_modified));
			$contents[] = array('text' => '<br>' . tep_info_image($cInfo->categories_image, $cInfo->categories_name, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT) . '<br>' . $cInfo->categories_image);
			$contents[] = array('text' => '<br>' . TEXT_SUBCATEGORIES . ' ' . $cInfo->childs_count . '<br>' . TEXT_PRODUCTS . ' ' . $cInfo->products_count);
		  } elseif (isset($pInfo) && is_object($pInfo)) { // product info box contents
			$heading[] = array('text' => '<b>' . tep_get_products_name($pInfo->products_id, $languages_id) . '</b>');

			$contents[] = array('align' => 'center', 'text' => '<a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $pInfo->products_id . '&action=new_product') . '">' . tep_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $pInfo->products_id . '&action=delete_product') . '">' . tep_image_button('button_delete.gif', IMAGE_DELETE) . '</a> <a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $pInfo->products_id . '&action=move_product') . '">' . tep_image_button('button_move.gif', IMAGE_MOVE) . '</a> <a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $pInfo->products_id . '&action=copy_to') . '">' . tep_image_button('button_copy_to.gif', IMAGE_COPY_TO) . '</a>');
			$contents[] = array('text' => '<br>' . TEXT_DATE_ADDED . ' ' . tep_date_short($pInfo->products_date_added));
			if (tep_not_null($pInfo->products_last_modified)) $contents[] = array('text' => TEXT_LAST_MODIFIED . ' ' . tep_date_short($pInfo->products_last_modified));
			if (date('Y-m-d') < $pInfo->products_date_available) $contents[] = array('text' => TEXT_DATE_AVAILABLE . ' ' . tep_date_short($pInfo->products_date_available));
			$contents[] = array('text' => '<br>' . tep_info_image($pInfo->products_image, $pInfo->products_name, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '<br>' . $pInfo->products_image);
			$contents[] = array('text' => '<br>' . TEXT_PRODUCTS_PRICE_INFO . ' ' . $currencies->format($pInfo->products_price) . '<br>' . TEXT_PRODUCTS_QUANTITY_INFO . ' ' . $pInfo->products_quantity);
			$contents[] = array('text' => '<br>' . TEXT_PRODUCTS_AVERAGE_RATING . ' ' . number_format($pInfo->average_rating, 2) . '%');
		  }
		} else { // create category/product info
		  $heading[] = array('text' => '<b>' . EMPTY_CATEGORY . '</b>');

		  $contents[] = array('text' => TEXT_NO_CHILD_CATEGORIES_OR_PRODUCTS);
		}
		break;
	}

	if ( (tep_not_null($heading)) && (tep_not_null($contents)) ) {
	  echo '			<td width="25%" valign="top">' . "\n";

	  $box = new box;
	  echo $box->infoBox($heading, $contents);

	  echo '			</td>' . "\n";
	}
?>
		  </tr>
		</table></td>
	  </tr>
	</table>
<?php
  }
?>
	</td>
<!-- body_text_eof //-->
  </tr>
</table>
<!-- body_eof //-->

<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
<br>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

Edited by talbot649, 23 November 2008 - 06:34 PM.

[kymation]

And the forum codebox completely fails to work. Again. That's such a mess that I'm having trouble seeing anything at all in it. Winmerge just throws up all over the page.

What I can see is messed-up inserts like this:

/*** Begin Header Tags SEO ***/
$categories_htc_title_array = $HTTP_POST_VARS['categories_htc_title_tag'];
$categories_htc_desc_array = $HTTP_POST_VARS['categories_htc_desc_tag'];
$categories_htc_keywords_array = $HTTP_POST_VARS['categories_htc_keywords_tag'];
$categories_htc_description_array = $HTTP_POST_VARS['categories_htc_description'];
/*** End Header Tags SEO ***/

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

/*** Begin Header Tags SEO ***/
$sql_data_array = array('categories_name' => tep_db_prepare_input($categories_name_array[$language_id]),
'categories_htc_title_tag' => (tep_not_null($categories_htc_title_array[$language_id]) ? tep_db_prepare_input($categories_htc_title_array[$language_id]) : tep_db_prepare_input($categories_name_array[$language_id])),
'categories_htc_desc_tag' => (tep_not_null($categories_htc_desc_array[$language_id]) ? tep_db_prepare_input($categories_htc_desc_array[$language_id]) : tep_db_prepare_input($categories_name_array[$language_id])),
'categories_htc_keywords_tag' => (tep_not_null($categories_htc_keywords_array[$language_id]) ? tep_db_prepare_input($categories_htc_keywords_array[$language_id]) : tep_db_prepare_input($categories_name_array[$language_id])),
'categories_htc_description' => tep_db_prepare_input($categories_htc_description_array[$language_id]));
/*** End Header Tags SEO ***/

// Start Categories images box
$categories_description_front_array = $_POST['categories_description_front'];
$sql_data_array = array ('categories_name' => tep_db_prepare_input ($categories_name_array[$language_id] ),
'categories_description_front' => tep_db_prepare_input ($categories_description_front_array[$language_id] ) );
// End Categories images box

should be this

/*** Begin Header Tags SEO ***/
$categories_htc_title_array = $HTTP_POST_VARS['categories_htc_title_tag'];
$categories_htc_desc_array = $HTTP_POST_VARS['categories_htc_desc_tag'];
$categories_htc_keywords_array = $HTTP_POST_VARS['categories_htc_keywords_tag'];
$categories_htc_description_array = $HTTP_POST_VARS['categories_htc_description'];
/*** End Header Tags SEO ***/
// Categories images box
$categories_description_front_array = $_POST['categories_description_front'];

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

/*** Begin Header Tags SEO ***/
// Start Categories images box
$sql_data_array = array ('categories_name' => tep_db_prepare_input ($categories_name_array[$language_id] ),
'categories_description_front' => tep_db_prepare_input ($categories_description_front_array[$language_id] ) );
// End Categories images box
'categories_htc_title_tag' => (tep_not_null($categories_htc_title_array[$language_id]) ? tep_db_prepare_input($categories_htc_title_array[$language_id]) : tep_db_prepare_input($categories_name_array[$language_id])),
'categories_htc_desc_tag' => (tep_not_null($categories_htc_desc_array[$language_id]) ? tep_db_prepare_input($categories_htc_desc_array[$language_id]) : tep_db_prepare_input($categories_name_array[$language_id])),
'categories_htc_keywords_tag' => (tep_not_null($categories_htc_keywords_array[$language_id]) ? tep_db_prepare_input($categories_htc_keywords_array[$language_id]) : tep_db_prepare_input($categories_name_array[$language_id])),
'categories_htc_description' => tep_db_prepare_input($categories_htc_description_array[$language_id]));
/*** End Header Tags SEO ***/

The blank page is the result of having error messages turned off. You need to turn errors back on so you can see where the problem is. Problems, more than likely, since this is almost certainly not the only one.

Regards
Jim

[talbot649]

Many thanks. I'm a bit of a beginner, so is there any chance you can give me an idea of a process I should be using when inserting your code into the Header Tags SEO - I would have no idea how you decided to include that bit where you did  

[talbot649]

Also, how do I turn on error messages?

[kymation]

Actually, I probably messed up that bit. I did it in a hurry, and the code was messy, so I didn't look at it very carefully. Sorry.

The rules for PHP are a bit odd. Lines of code end with a semicolon or a closing brace (; or }). Nothing else counts.* So, if you see a line ending with a comma, or a period, or just about anything else, it's not really the end of the staement. So if you see something like this

$sql_data_array = array ('categories_name' => tep_db_prepare_input ($categories_name_array[$language_id] ),
'categories_description_front' => tep_db_prepare_input ($categories_description_front_array[$language_id] ),
'categories_htc_title_tag' => (tep_not_null($categories_htc_title_array[$language_id]) ? tep_db_prepare_input($categories_htc_title_array[$language_id]) : tep_db_prepare_input($categories_name_array[$language_id])),
'categories_htc_desc_tag' => (tep_not_null($categories_htc_desc_array[$language_id]) ? tep_db_prepare_input($categories_htc_desc_array[$language_id]) : tep_db_prepare_input($categories_name_array[$language_id])),
'categories_htc_keywords_tag' => (tep_not_null($categories_htc_keywords_array[$language_id]) ? tep_db_prepare_input($categories_htc_keywords_array[$language_id]) : tep_db_prepare_input($categories_name_array[$language_id])),
'categories_htc_description' => tep_db_prepare_input($categories_htc_description_array[$language_id]));

that's all one statement. It defines an array of 6 elements. So you can add an additional element or five to the array (the original version of this contained only one element), but you can't add other statements in the middle of this one.

Yes, I know this is confusing. PHP is not the easiest language to code in, but you'll just have to learn some of it in order to get by. If it helps, I had to do the same thing, under a deadline, and learn osCommerce and mySQL at the same time, just like you're doing. It can be done.

To make it easier, get a good merge/compare tool. I use Winmerge, but you may find something else that you like better. That will show you where the changes need to be made. A good editor will also help a lot. I use EasyEclipse for PHP. It flags most errors for you, so you know there's a problem before you upload to your site. If you install a server (such as XAMPP) you can test everything locally as well.

Error messages are controlled in your php.ini. If you're on a hosted server and don't have access to this, you may be able to override this in your .htaccess. You really need to talk to your hosting service about that; some of them get testy about overriding settings, and some just plain won't allow it. Testing locally will get around most of this.

Regards
Jim

*Like most rules, there are exceptions to this one. The for() statement has semicolons inside it, and the case statement ends with a colon. Bah.

[katomy]

Hello,

Everything is working fine, one thing though, the image for the category does not show on the box, you can take a look if you like, Katomy , if you click on the category, you are redirected and the Logo for the image is shown, also on the properties of the image on the categories box, the path is http://www.katomy.com/images/  that's it, i have a subdirectory on images for the logos, is there the problem?


Thank you
Temo
Katomy.com

[acbatchelor]

Thanks for this contribution, it is exactly what i need except for one thing.  I would like to add this grid to the subcatagories also.  On the top catagories, the grid is there but when you click one of the catagories it takes you to the subcatagories in the regular format.  If you can tell me how to add this contribution to the subcatagories i would be grateful. I know the subcatagories is about the same without this grid but i want it to keep the same look, and it works better with the design of my site.

Thanks!

[acbatchelor]

nevermind......after a few hours of fooling around i finally did it myself.

[llebron]

acbatchelor, on Nov 30 2008, 07:33 PM, said:

nevermind......after a few hours of fooling around i finally did it myself.

I'm interested in the same functionality. How did you get it to work?

thanks,

LUis

[galey1981]

Great contribution - however, when i go into admin to add my category image and description details I add the data in and then click update but it doesnt get put into the database. It doesnt add the fields.

I can go straight into phpmyadmin and add the content manually but when i do it through admin it doesnt work.

Would anyone know where i might be going wrong?

[galey1981]

galey1981, on Feb 6 2009, 03:55 PM, said:

Great contribution - however, when i go into admin to add my category image and description details I add the data in and then click update but it doesnt get put into the database. It doesnt add the fields.

I can go straight into phpmyadmin and add the content manually but when i do it through admin it doesnt work.

Would anyone know where i might be going wrong?

I do have header tags controller... so that may be causing a prob?

[kymation]

You probably missed an edit to catalog/admin/categories.php. Check in the top half of the file. Header tags controller makes changes to this file as well, so check for conflicts between the two. I recommend a good file comparison utility such as Winmerge, Beyond Compare, etc.

Regards
Jim

[turbo1982]

Hi
I have installed this contribution and it looks great but i am having a few teething problems. I have installed all the files correctly i believe and everything works ok apart from creatin a new category. i then realised i had not run the sql code. when i do this i get the error message below. I am using os2.2rca and mysql-front v5.  everything has been working ok up to now.i am new to oscommerce and databases so please take it easy on me if i have left any info out. thanks in advance.

mysql-front error

sql execution error # 1109. response from the database:
unknown table 'categories' in information_schema

[kymation]

turbo1982, on Feb 9 2009, 03:32 PM, said:

<snipped>
mysql-front error

sql execution error # 1109. response from the database:
unknown table 'categories' in information_schema

It sounds like you tried to update the schema instead of the database. This is a new problem for MySQL 5.x.

If you are using phpMyAdmin, check the pulldown menu at the top of the left column. Select the one that has your database name in it, not the one that says information schema.

Regards
Jim