Nelp getting product option manager to work

[avyona]

I'm trying to code into cubecart 3 the ability to manage product options on the main product creation page. I noticed that cubecart 4 had this feature and I wanted to do this for my own store which is cc3.

Here is how I have it set up.

1) When adding a new product I have a box that allows input from the administrator to add new options ( from a drop down list which is pulled from the database) and then enter a price difference.

2) If product options were added on the main product options console (which is a separate global page allowing massive product options to be created and assigned to multiple products) then I have those options pertaining to that product already showing up on the product edit screen. So then the existing product options assigned to that product can be edited.

3) I have in adition to an "edit" button, a delete button. So that the product option can be removed from that product.

I used javascript to manage the button click so that to page doesnt reload....it shouldnt reload. ? However, it is still reloading and its not saving my add, edit, and delete activity for the product options.

There are several files involved.

the first is a jslibrary.js file that holds functions called upon by the php files. This jslibrary.js file is referenced in the header of all admin pages in the cart.
Here are the contents of the file that affect the product options:

/* New Options code */
function optionEdit(assign_id, optionData) {
	var data		= optionData.split('|');
	var elements	= $('opt_mid').getElementsByTagName('option');
	for (i=0; i<elements.length; i++) {
		elements[i].removeAttribute('selected');

	if (data[1] == '0') {
		if (elements[i].value == data[0] && elements[i].getAttribute('class') == 'top') {
			elements[i].setAttribute('selected', 'selected');
			elements[i].selected = true;
		}
	} else {
		if (elements[i].value == data[1] && elements[i].getAttribute('class') == 'sub') {
			elements[i].setAttribute('selected', 'selected');
			elements[i].selected = true;
		}
	}
}
$('opt_price').value = data[2];	
$('opt_assign_id').value = assign_id;

optionRemove(assign_id, true);
}

function optionRemoveTemp(element) {
	var object = $(element).parentNode
	$('options_added').removeChild(object);
}

function optionRemove(id, preserve) {
	$('option_'+id).remove();
	if (!preserve) {
		new Insertion.Bottom($('options_added'), '<input type="hidden" name="option_remove[]" value="'+id+'"/>');
	}
}

function optionAdd() {

var assign_id = $('opt_assign_id').value;

var opt_top_title = $('opt_mid').options[$('opt_mid').selectedIndex].parentNode.getAttribute('label');
var opt_mid_title = $('opt_mid').options[$('opt_mid').selectedIndex].innerHTML;

var opt_mid_value	= $('opt_mid').options[$('opt_mid').selectedIndex].value;
var opt_top_value	= $('opt_mid').options[$('opt_mid').selectedIndex].parentNode.id;

var opt_price	= $('opt_price').value;
opt_price		= (!opt_price) ? 0.00 :  opt_price;

if (opt_top_value != '' && opt_mid_value != '') {
	if (assign_id != '0') {
		var method	= 'option_edit['+assign_id+']';
		$('opt_assign_id').value = '0';
	} else {
		var method	= 'option_add[]';
	}
	if (opt_top_title == null) opt_top_title = 'Custom';
	var hidden = '<input type="hidden" name="'+method+'" value="'+opt_top_value+'|'+opt_mid_value+'|'+opt_price+'"/>';
	new Insertion.Bottom('options_added', '<div style="clear: right;">'+hidden+'<span style="float: right;"><a href="#" onclick="optionRemoveTemp(this.parentNode); return false;"><img src="images/icons/delete.png" alt="delete" /></a></span><strong>'+opt_top_title+'</strong>: '+opt_mid_title+' ('+opt_price+')</div>');
	$('opt_price').value = '0.00';
}
}

[avyona]

The second file I have is the actaully admin page for product management functions. Its called index.php. It does two functions...it displays a list of all products complete with pagination at first click..and then clicking on edit or new product takes the user to the product edit screen for a certain product or start a new product entry. I have commented out the sections that I have coded in.

<?php
include("../../includes/ini.inc.php");
include("../../includes/global.inc.php");
require_once("../../classes/db.inc.php");
$db = new db();
include_once("../../includes/functions.inc.php");
$config = fetchDbConfig("config");

include_once("../../language/".$config['defaultLang']."/lang.inc.php");
$enableSSl = 1;
include("../../includes/sslSwitch.inc.php");
include("../includes/auth.inc.php");
include("../includes/rte/fckeditor.php");
include("../../classes/gd.inc.php");
include("../../includes/currencyVars.inc.php");

// worcester wide web multi delete / reorder
echo '<script type="text/javascript">
      function checkedAll (id, checked) {
	var el = document.getElementById(id);
	for (var i = 0; i < el.elements.length; i++) {
	  el.elements[i].checked = checked;
	}
      }


</script>';



if ($_GET['multifunction'] == '1'){

if ($_POST['operation'] == 'delete'){
	$db = new db();
	$delete = $_POST['order'];
	$deletesep = implode(",", $delete);
	$where = "productId IN (".$deletesep.")";
	$delete = $db->delete($glob['dbprefix']."CubeCart_inventory", $where);
	$delete = $db->delete($glob['dbprefix']."CubeCart_cats_idx", $where);
// fix cat count

$maxdepth = 4;
if(isset($_GET['page'])){
	$page = $_GET['page'];
} else {
	$page = 0;
}

$query = "SELECT * FROM ".$glob['dbprefix']."CubeCart_category WHERE 1";
$results = $db->select($query, $catsPerPage, $page);
$numrows = $db->numrows($query);


for ($i=0; $i<count($results); $i++){ 
	$thiscat = $results[$i]['cat_id'];
	$query = "SELECT * FROM ".$glob['dbprefix']."CubeCart_cats_idx WHERE cat_id = '$thiscat'";
	$qtytoadd = $db->numrows($query);
	$quantity[$thiscat] += $qtytoadd;
	$fathercat = $results[$i]['cat_father_id'];

	while($fathercat != 0){
		$query2 = "SELECT cat_father_id FROM ".$glob['dbprefix']."CubeCart_category WHERE cat_id = '$thiscat'";
		$results2 = $db->select($query2);
		$fathercat = $results2[0]['cat_father_id'];
		if($fathercat != 0){
			$quantity[$fathercat] += $qtytoadd;
			}
		$thiscat = $fathercat;
		}
	}

for ($i=0; $i<count($results); $i++){ 

$thiscat = $results[$i]['cat_id'];
$query = "SELECT * FROM ".$glob['dbprefix']."CubeCart_cats_idx WHERE cat_id = '$thiscat'";
$directcount = $db->numrows($query);
$cellColor = "";
$cellColor = cellColor($i);

$record1["noProducts"] = $db->mySQLSafe($quantity[$thiscat]);
$where1 = "cat_id=".$db->mySQLSafe($thiscat);
$update = $db->update($glob['dbprefix']."CubeCart_category", $record1, $where1);
}
//end fix cat count

}elseif ($_POST['operation'] == 'reorder'){
	$db = new db();
	$ordered = $_POST['order'];
	$orderedsep = implode(",", $ordered);
	$cat_id = $_POST['cat_id'];

$where = "productId IN (".$orderedsep.")";
$record = 'cat_id = \''.$cat_id.'\'';
$update = $db->updatespecial($glob['dbprefix']."CubeCart_inventory", $record, $where);
$update = $db->updatespecial($glob['dbprefix']."CubeCart_cats_idx", $record, $where);
// fix cat count

$maxdepth = 30;
if(isset($_GET['page'])){
	$page = $_GET['page'];
} else {
	$page = 0;
}

$query = "SELECT * FROM ".$glob['dbprefix']."CubeCart_category WHERE 1";
$results = $db->select($query, $catsPerPage, $page);
$numrows = $db->numrows($query);


for ($i=0; $i<count($results); $i++){ 
	$thiscat = $results[$i]['cat_id'];
	$query = "SELECT * FROM ".$glob['dbprefix']."CubeCart_cats_idx WHERE cat_id = '$thiscat'";
	$qtytoadd = $db->numrows($query);
	$quantity[$thiscat] += $qtytoadd;
	$fathercat = $results[$i]['cat_father_id'];

	while($fathercat != 0){
		$query2 = "SELECT cat_father_id FROM ".$glob['dbprefix']."CubeCart_category WHERE cat_id = '$thiscat'";
		$results2 = $db->select($query2);
		$fathercat = $results2[0]['cat_father_id'];
		if($fathercat != 0){
			$quantity[$fathercat] += $qtytoadd;
			}
		$thiscat = $fathercat;
		}
	}

for ($i=0; $i<count($results); $i++){ 

$thiscat = $results[$i]['cat_id'];
$query = "SELECT * FROM ".$glob['dbprefix']."CubeCart_cats_idx WHERE cat_id = '$thiscat'";
$directcount = $db->numrows($query);
$cellColor = "";
$cellColor = cellColor($i);

$record1["noProducts"] = $db->mySQLSafe($quantity[$thiscat]);
$where1 = "cat_id=".$db->mySQLSafe($thiscat);
$update = $db->update($glob['dbprefix']."CubeCart_category", $record1, $where1);
}
//end fix cat count

}else{

echo '<script type="text/javascript"> alert("You didnt select an operation, please check the products you wish to change and pick a operation at the bottom before submitting");</script>';
}



}

[avyona]

if(permission("products","read")==FALSE){
	header("Location: ".$GLOBALS['rootRel']."admin/401.php");
	exit;
}
$productsPerPage = 25;
// grishick advanced_file_manager mod START -->
$add_file_mgr_config = fetchDbConfig("advanced_file_manager");
$rootFileFolder = $GLOBALS['rootDir']."/files/uploads";
$fileFolder = "../../files/uploads";
if($ccAdminData[0]['isSuper']==0) {
	$rootFileFolder.="/aff".$ccAdminData[0]['adminId'];
	$fileFolder.="/aff".$ccAdminData[0]['adminId'];
	if(!is_dir($rootFileFolder)) {
		$old = umask(0);
		mkdir($rootFileFolder, 0777);
		umask($old);
	}
} 
// grishick advanced_file_manager mod END -->	

if(isset($_GET['action']) && $_GET['action']=="gbase"){

$db = new db();
$query = "SELECT * FROM ".$glob['dbprefix']."CubeCart_inventory INNER JOIN ".$glob['dbprefix']."CubeCart_category on ".$glob['dbprefix']."CubeCart_inventory.cat_id = ".$glob['dbprefix']."CubeCart_category.cat_id ".$whereClause." ORDER BY name ASC";
$results = $db->select($query);

if($results==TRUE) {

$googleBaseContent = "product_url\tname\tdescription\timage_url\tprice\r\n";

	for($i=0; $i<count($results); $i++){


		$salePrice = salePrice($results[$i]['price'], $results[$i]['sale_price']);

		if($salePrice > 0){

			$price = $salePrice;

		} else {

			$price = $results[$i]['price'];

		}

		$name = str_replace(array("&nbsp;","\t","\r","\n","\0","\x0B","
		"),"",strip_tags($results[$i]['name']));
		$name = str_replace("  ","",$name);
		$desc = str_replace(array("&nbsp;","\t","\r","\n","\0","\x0B","
		"),"",strip_tags($results[$i]['description']));
		$desc = str_replace("  ","",$desc);

// SEO friendly mod
			if($config['sef'] == 0) {
				$googleBaseContent .= $glob['storeURL']."/index.php?act=viewProd&productId=".$results[$i]['productId']."\t".$name."\t".$desc;
			} else {
				include_once("../../includes/sef_urls.inc.php");
				$googleBaseContent .= $glob['storeURL']. "/" . sef_get_base_url(). generateProductUrl($results[$i]['productId'])."\t".$name."\t".$desc;			
			}
// SEO friendly mod		
			if($results[$i]['image']){
				$googleBaseContent .= "\t".$glob['storeURL']."/images/uploads/".$results[$i]['image'];
			} else {
				$googleBaseContent .= "\t".$glob['storeURL']."/skins/".$config['skinDir']."/styleImages/nophoto.gif";
			}

		$googleBaseContent .= "\t".$price."\r\n";

	}


$filename = "GoogleBaseFeed_";
$contentLength = strlen($googleBaseContent);
$content = $googleBaseContent;

$filename .= date("dMy").".txt";
header('Pragma: private');
header('Cache-control: private, must-revalidate');
header("Content-Disposition: attachment; filename=".$filename);
header("Content-type: text/plain");
header("Content-type: application/octet-stream");
header("Content-length: ".$contentLength);
header("Content-Transfer-Encoding: binary");
echo $content;
exit;
}

} elseif(isset($_GET['delete']) && $_GET["delete"]>0){

	// delete product
	$where = "productId=".$db->mySQLSafe($_GET["delete"]);
	$delete = $db->delete($glob['dbprefix']."CubeCart_inventory", $where);

    // delete coresponding product reviews 
    $del_rev = $_GET["delete"] ;
    $delete2 = "DELETE FROM ".($glob['dbprefix']."cubecart_store_comments WHERE product_id=$del_rev");
    $del= mysql_query($delete2);

	// set categories -1
	$cats = $db->select("SELECT cat_id FROM ".$glob['dbprefix']."CubeCart_cats_idx WHERE productId=".$db->mySQLSafe($_GET["delete"]));
	if($cats==TRUE){

		for($i=0;$i<count($cats);$i++){

				$db->categoryNos($cats[$i]['cat_id'], "-");

		}

	}

	// delete category index
	$where = "productId=".$db->mySQLSafe($_GET["delete"]);  
	$deleteIdx = $db->delete($glob['dbprefix']."CubeCart_cats_idx", $where);
	unset($record);

	// delete product options
	$record['product'] = $db->mySQLSafe($_GET["delete"]);
	$where = "product=".$db->mySQLSafe($_GET["delete"]);  
	$deleteOps = $db->delete($glob['dbprefix']."CubeCart_options_bot", $where);
	unset($record);

	if($delete == TRUE){

		$msg = "<p class='infoText'>".$lang['admin']['products']['delete_success']."</p>";

	} else {

		$msg = "<p class='warnText'>".$lang['admin']['products']['delete_fail']."</p>";

	}

} elseif(isset($_POST['productId'])) {

// generate product code
	if(empty($_POST['productCode'])){

	$chars = array("A","B","C","D","E","F","G","H","I","J","K","L","M","N",
			"O","P","Q","R","S","T","U","V","W","X","Y","Z","1","2","3",
			"4","5","6","7","8","9","0");
	$max_chars = count($chars) - 1;
	srand((double)microtime()*1000000);
		for($i = 0; $i < 5; $i++){
			$randChars = ($i == 0) ? $chars[rand(0, $max_chars)] : $randnum . $chars[rand(0, $max_chars)];
		}
	$record["productCode"] = $db->mySQLSafe(strtoupper(substr($_POST['name'],0,3)).$randChars.$_POST['cat_id']);

} else {
	$record["productCode"] = $db->mySQLSafe($_POST['productCode']);	
}

$record["name"] = $db->mySQLSafe($_POST['name']);		
$record["cat_id"] = $db->mySQLSafe($_POST['cat_id']);	
$record["description"] = $db->mySQLSafe($_POST['FCKeditor']);
$record["image"] = $db->mySQLSafe($_POST['imageName']);
$record["price"] = $db->mySQLSafe($_POST['price']);  
$record["sale_price"] = $db->mySQLSafe($_POST['sale_price']);
$record["stock_level"] = $db->mySQLSafe($_POST['stock_level']); 
$record["useStockLevel"] = $db->mySQLSafe($_POST['useStockLevel']);
$record["digital"] = $db->mySQLSafe($_POST['digital']);
// grishick advanced_file_manager mod START -->
if($add_file_mgr_config['status']==1) {
	$record["digitalDir"] = $db->mySQLSafe($rootFileFolder.$_POST['digitalDir']);
} else {
// grishick advanced_file_manager mod END -->
$record["digitalDir"] = $db->mySQLSafe($_POST['digitalDir']);
// grishick advanced_file_manager mod START -->		
}
// grishick advanced_file_manager mod END -->
$record["prodWeight"] = $db->mySQLSafe($_POST['prodWeight']);
$record["taxType"] = $db->mySQLSafe($_POST['taxType']); 
$record["showFavorites"] = $db->mySQLSafe($_POST['showFavorites']);
$record["showFeatured"] = $db->mySQLSafe($_POST['showFeatured']); 
/* <rf> search engine friendly url mod */
if($config['seftags']) {
	$record["prod_metatitle"] = $db->mySQLSafe($_POST['prod_metatitle']); 
	$record["prod_metadesc"] = $db->mySQLSafe($_POST['prod_metadesc']); 
	$record["prod_metakeywords"] = $db->mySQLSafe($_POST['prod_metakeywords']); 
	if($config['sefcustomurl'] == 1) $record["prod_sefurl"] = $db->mySQLSafe($_POST['prod_sefurl']); 		
}
/* <rf> end mod */

// if image is a JPG check thumbnail doesn't exist and if not make one
$imageFormat = strtoupper(ereg_replace(".*\.(.*)$","\\1",$_POST['imageName']));
if($imageFormat == "JPG" || $imageFormat == "JPEG" || $imageFormat == "PNG" || ($imageFormat == "GIF" && $config['gdGifSupport']==1)){

	if(file_exists($GLOBALS['rootDir']."/images/uploads/thumbs/thumb_".$_POST['imageName'])){
		@chmod($GLOBALS['rootDir']."/images/uploads/thumbs/thumb_".$_POST['imageName'], 0775);
		unlink($GLOBALS['rootDir']."/images/uploads/thumbs/thumb_".$_POST['imageName']);
	}

	$thumb=new thumbnail($GLOBALS['rootDir']."/images/uploads/".$_POST['imageName']);
	$thumb->size_auto($config['gdthumbSize']);
	$thumb->jpeg_quality($config['gdquality']);
	$thumb->save($GLOBALS['rootDir']."/images/uploads/thumbs/thumb_".$_POST['imageName']);
}

if(isset($_POST['productId']) && $_POST['productId']>0) {

	$where = "productId=".$db->mySQLSafe($_POST['productId']);
	$update = $db->update($glob['dbprefix']."CubeCart_inventory", $record, $where);
	unset($record, $where);

	// update category count
	if($_POST['oldCatId']!==$_POST['cat_id']){

			// set old category -1 IF IT WAS IN THERE BEFORE
			$numOldCat = $db->numrows("SELECT * FROM ".$glob['dbprefix']."CubeCart_cats_idx WHERE cat_id = ".$db->mySQLSafe($_POST['oldCatId'])." AND productId = ".$db->mySQLSafe($_POST['productId']));

			if($numOldCat>0){
				$db->categoryNos($_POST['oldCatId'], "-");
			}

			// set new category +1 IF IT WAS NOT IN THERE BEFORE
			$numNewCat = $db->numrows("SELECT * FROM ".$glob['dbprefix']."CubeCart_cats_idx WHERE cat_id = ".$db->mySQLSafe($_POST['cat_id'])." AND productId = ".$db->mySQLSafe($_POST['productId']));

			if($numNewCat == 0) {
				$db->categoryNos($_POST['cat_id'], "+");
			}


			// delete old idx
			$where = "productId = ".$db->mySQLSafe($_POST['productId'])." AND cat_id = ".$db->mySQLSafe($_POST['oldCatId']);  
			$deleteIdx = $db->delete($glob['dbprefix']."CubeCart_cats_idx", $where);
			unset($record);

			// delete new index if it was added as an extra before
			$where = "productId = ".$db->mySQLSafe($_POST['productId'])." AND cat_id = ".$db->mySQLSafe($_POST['cat_id']);  
			$deleteIdx = $db->delete($glob['dbprefix']."CubeCart_cats_idx", $where);
			unset($record);

			// add new idx
			$record['productId'] = $db->mySQLSafe($_POST['productId']);
			$record['cat_id'] = $db->mySQLSafe($_POST['cat_id']);  
			$insertIdx = $db->insert($glob['dbprefix']."CubeCart_cats_idx", $record);
			unset($record);

	}

	if($update == TRUE){
		$msg = "<p class='infoText'>'".$_POST['name']."' ".$lang['admin']['products']['update_successful']."</p>";
	} else {
		$msg = "<p class='warnText'>".$lang['admin']['products']['update_fail']."</p>";
	}
	// start mod: Text Input Fields for Products, by Estelle
	$text_input_mod = fetchDbConfig("Text_Input_Mod");
	if ($text_input_mod && $text_input_mod['status']) {
		include("../includes/estelles_mod_store/text_input_mod.admin1.inc.php");
	}
	// end mod: Text Input Fields for Products, by Estelle

[avyona]

} else {

	$insert = $db->insert($glob['dbprefix']."CubeCart_inventory", $record);
	unset($record);

	$record['cat_id'] = $db->mySQLSafe($_POST['cat_id']);
	// Total Clone Product by convict http://cubecart-mods-skins.com -->
	if (!isset($c_tcp)) $c_tcp = fetchDbConfig("Total_Clone_Product");
	$record['productId'] = $newProductId = $db->insertid();  
	// <-- Total Clone Product
	$insertIdx = $db->insert($glob['dbprefix']."CubeCart_cats_idx", $record);
	unset($record);

	// Total Clone Product by convict http://cubecart-mods-skins.com -->
	if(isset($_POST['clone']) && $_POST["clone"]>0 && $c_tcp['status']){
		if ($c_tcp['options']){
			$masterOtptions = $db->select("SELECT * FROM ".$glob['dbprefix']."CubeCart_options_bot WHERE product = ".$db->mySQLSafe($_POST['clone'])." ORDER BY assign_id");
			if ($masterOtptions==true) {
				for ($mcount=0;$mcount<count($masterOtptions);$mcount++) {
					//v1.2 ->
					if (isset($masterOtptions[$mcount]['status'])) {
						$record['status'] = $db->mySQLSafe($masterOtptions[$mcount]['status']);
						//$record['dir'] = $db->mySQLSafe($masterOtptions[$mcount]['dir']); // Uncomment to clone downloadable dir
					} // <-
					$record['product'] = $db->mySQLSafe($newProductId);
					$record['option_id'] = $db->mySQLSafe($masterOtptions[$mcount]['option_id']);
					$record['value_id'] = $db->mySQLSafe($masterOtptions[$mcount]['value_id']);
					$record['option_price'] = $db->mySQLSafe($masterOtptions[$mcount]['option_price']);
					$record['option_symbol'] = $db->mySQLSafe($masterOtptions[$mcount]['option_symbol']);
					$insertOpt = $db->insert($glob['dbprefix']."CubeCart_options_bot", $record);
					unset($record); //v1.2
				}
			}
			//v1.1 ->
			unset($record);
		}
		if ($c_tcp['images']){
			$additionalImages = $db->select("SELECT * FROM ".$glob['dbprefix']."CubeCart_img_idx WHERE productId = ".$db->mySQLSafe($_POST['clone']));
				if ($additionalImages==true) {
				for ($icount=0;$icount<count($additionalImages);$icount++) {
					$record['productId'] = $db->mySQLSafe($newProductId);
					$record['img'] = $db->mySQLSafe($additionalImages[$icount]['img']);
					// If Advanced Image Manager do it -->
					if (isset($additionalImages[$icount]['img_folder'])) {
						$record['img_folder'] = $db->mySQLSafe($additionalImages[$icount]['img_folder']);
					}
					// <--
					$insertAimg = $db->insert($glob['dbprefix']."CubeCart_img_idx", $record);
				}
			}
			unset($record);
			if(isset($_POST['clonei']) && $_POST["clonei"]>0){
				$record['noImages'] = $db->mySQLSafe($_POST['clonei']);
				$where = "productId = ".$db->mySQLSafe($newProductId);
				$update = $db->update($glob['dbprefix']."CubeCart_inventory", $record, $where);
				unset($record);
			}
			// <-
		}
	}		
	// <-- Total Clone Product
	if($insert == TRUE){

		$msg = "<p class='infoText'>'".$_POST['name']."' ".$lang['admin']['products']['add_success']."</p>";

		// notch up amount of products in category
		$db->categoryNos($_POST['cat_id'], "+");

	} else {
		$msg = "<p class='warnText'>".$lang['admin']['products']['add_fail']."</p>";
	}
	// start mod: Text Input Fields for Products, by Estelle
	$text_input_mod = fetchDbConfig("Text_Input_Mod");
	if ($text_input_mod && $text_input_mod['status']) {
		include("../includes/estelles_mod_store/text_input_mod.admin2.inc.php");
	}
	// end mod: Text Input Fields for Products, by Estelle
}



##Product Option Manager
// Adding A New Option Variables
	if (isset($_POST['option_add']) && is_array($_POST['option_add']) && !empty($_POST['option_add'])) {
		foreach ($_POST['option_add'] as $option) {
			$value	= explode('|', $option);
			$data	= array(
				'product'		=> ($product_id) ? $product_id : $_POST['productId'],
				'option_id'		=> is_numeric($value[0]) ? $value[0] : $value[1],
				'value_id'		=> is_numeric($value[0]) ? $value[1] : 0,
				'option_price'	=> preg_replace('#[^0-9\.]#i', '', $value[2]),
				'option_symbol'	=> "'".(($value[2] >= 0) ? '+' : '-')."'",
			);
			$opt_insert = $db->insert($glob['dbprefix'].'CubeCart_options_bot', $data);
		}
		if ($opt_insert) {
			$msg = "<p class='infoText'>'".$_POST['name']."' ".$lang['admin']['products']['add_success']."</p>";
		} else {
			$msg = "<p class='warnText'>".$lang['admin']['products']['add_fail']."</p>";
		}
	}

//Editing Existing Option Variables
	if (isset($_POST['option_edit']) && is_array($_POST['option_edit']) && !empty($_POST['option_edit'])) {
		# Update existing product options
		$product_id = ($product_id) ? $product_id : $_POST['productId'];

	foreach ($_POST['option_edit'] as $assign_id => $option) {
		$value	= explode('|', $option);
		$data	= array(
			'product'		=> $product_id,
			'option_id'		=> is_numeric($value[0]) ? $value[0] : $value[1],
			'value_id'		=> is_numeric($value[0]) ? $value[1] : 0,
			'option_price'	=> preg_replace('#[^0-9\.]#i', '', $value[2]),
			'option_symbol'	=> "'".(($value[2] >= 0) ? '+' : '-')."'",
		);
		$opt_update = $db->update($glob['dbprefix'].'CubeCart_options_bot', $data, array('assign_id' => $assign_id, 'product' => $product_id));
	}
	if ($opt_update) {
		$msg = "<p class='infoText'>'".$_POST['name']."' ".$lang['admin']['products']['add_success']."</p>";
	} else {
		$msg = "<p class='warnText'>".$lang['admin']['products']['add_fail']."</p>";
	}
}

//finally deleting product options which have been assigned in the past	
	if (isset($_POST['option_remove']) && is_array($_POST['option_remove']) && !empty($_POST['option_remove'])) {
		foreach ($_POST['option_remove'] as $option) {
			$opt_delete = $db->delete($glob['dbprefix'].'CubeCart_options_bot', array('assign_id' => $option, 'product' => ($product_id) ? $product_id : $_POST['productId']));
		}
		if ($opt_delete) {
			$msg = "<p class='infoText'>'".$_POST['name']."' ".$lang['admin']['products']['add_success']."</p>";
		} else {
			$msg = "<p class='warnText'>".$lang['admin']['products']['add_fail']."</p>";
		}
	}



}

if(!isset($_GET['mode'])){

// make sql query
// Total Clone Product by convict http://cubecart-mods-skins.com -->
	if (!isset($c_tcp)) $c_tcp = fetchDbConfig("Total_Clone_Product");
	if ($c_tcp['status'] && isset($_GET['edit']) && $_GET['edit']>0 || isset($_GET['clone']) && $_GET['clone']>0) {

			$product = (isset($_GET['edit']) && $_GET['edit']>0) ? $db->mySQLSafe($_GET['edit']) : $db->mySQLSafe($_GET['clone']);

			$query = sprintf("SELECT * FROM ".$glob['dbprefix']."CubeCart_inventory WHERE productId = ".$product); 

	} elseif(isset($_GET['edit']) && $_GET['edit']>0){
	// <-- Total Clone Product

	$query = sprintf("SELECT * FROM ".$glob['dbprefix']."CubeCart_inventory WHERE productId = &#37;s", $db->mySQLSafe($_GET['edit'])); 

} else {

	if(isset($_GET['orderCol']) && isset($_GET['orderDir'])){

		$orderBy =  $glob['dbprefix']."CubeCart_inventory.".$_GET['orderCol']." ".$_GET['orderDir'];

	} else {

		$orderBy = $glob['dbprefix']."CubeCart_inventory.productId ASC";

	}

	$whereClause = "";

	if(isset($_GET['searchStr']) && !empty($_GET['searchStr'])){
		$searchwords = split ( "[ ,]", $_GET['searchStr']);   

	foreach($searchwords as $word){
		$searchArray[]=$word;
	}

	$noKeys = count($searchArray);
	for ($i=0; $i<$noKeys;$i++) {

		$ucSearchTerm = strtoupper($searchArray[$i]);
		if(($ucSearchTerm!=="AND")AND($ucSearchTerm!=="OR")){

			$like .= "(name LIKE '%".$searchArray[$i]."%' OR description LIKE '%".$searchArray[$i]."%' OR  productCode LIKE '%".$searchArray[$i]."%') OR ";

		} else {
			$like = substr($like,0,strlen($like)-3);
			$like .= $ucSearchTerm;
		}  

	}
	$like = substr($like,0,strlen($like)-3);

	$whereClause .= "WHERE ".$like;

}


if(isset($_GET['category']) && $_GET['category']>0){

	if(isset($like)){
		$whereClause .= " AND ";
	} else {
		$whereClause .= " WHERE ";
	}

	$whereClause .= $glob['dbprefix']."CubeCart_inventory.cat_id = ".$_GET['category']; 

}


	$query = "SELECT * FROM ".$glob['dbprefix']."CubeCart_inventory INNER JOIN ".$glob['dbprefix']."CubeCart_category on ".$glob['dbprefix']."CubeCart_inventory.cat_id = ".$glob['dbprefix']."CubeCart_category.cat_id ".$whereClause." ORDER BY ".$orderBy;

} 

// query database
if(isset($_GET['page'])){
	$page = $_GET['page'];
} else {
	$page = 0;
}

$results = $db->select($query, $productsPerPage, $page);
$numrows = $db->numrows($query);
$pagination = $db->paginate($numrows, $productsPerPage, $page, "page");
}
// start mod: Text Input Fields for Products, by Estelle
	$text_input_mod = fetchDbConfig("Text_Input_Mod");
	if ($text_input_mod && $text_input_mod['status']) {
		include("../includes/estelles_mod_store/text_input_mod.admin3.inc.php");
	}
	// end mod: Text Input Fields for Products, by Estelle
	$query = "SELECT cat_id, cat_name, cat_father_id FROM ".$glob['dbprefix']."CubeCart_category WHERE cat_brand='1' ORDER BY cat_id DESC";
	$categoryArray = $db->select($query);
include("../includes/header.inc.php"); 
?>

[avyona]

<table width="100&#37;"  border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td nowrap='nowrap'><p class="pageTitle"><?php echo $lang['admin']['products']['prod_inventory'];?></p></td>
     <?php if(!isset($_GET["mode"])){ ?><td align="right" valign="middle"><a <?php if(permission("products","write")==TRUE){ ?>href="?mode=new" class="txtLink" <?php } else { echo $link401; } ?>><img src="../images/buttons/new.gif" alt="" hspace="4" border="0" title="" /><?php echo $lang['admin']['add_new'];?></a></td><?php } ?>
  </tr>
  <tr align="right">
    <td colspan="2" nowrap='nowrap'>
	<a href="index.php?action=gbase"><img src="../images/googleBase.gif" alt="Download Google Base Product Feed" width="76" height="28" border="0" title="" /></a></td>
  </tr>
</table>

<?php if(isset($msg)){ echo stripslashes($msg); }?>
<?php
// Total Clone Product by convict http://cubecart-mods-skins.com -->	
if (!isset($c_tcp)) $c_tcp = fetchDbConfig("Total_Clone_Product");
//if(!isset($_GET['mode']) && !isset($_GET['edit']) ){
if (!isset($_GET['mode']) && !isset($_GET['edit']) && !isset($_GET['clone'])){
// <-- Total Clone Product

?>
<?php if($results == TRUE){ ?>
<p class="copyText"><?php echo $lang['admin']['products']['current_prods_in_db'];?></p>
<form name="filter" method="get" action="<?php echo $GLOBALS['rootRel'];?>admin/products/index.php">
<p align="right" class="copyText">
  <select name="category" class="textbox">
	<option value="All" <?php if(isset($_GET['category']) && $_GET['category']=="All") echo "selected='selected'"; ?>><?php echo $lang['admin']['products']['all_cats'];?></option>
	<?php for ($i=0; $i<count($categoryArray); $i++){ ?>
	<option value="<?php echo $categoryArray[$i]['cat_id']; ?>" <?php if(isset($_GET['category']) && $categoryArray[$i]['cat_id']==$_GET['category']) echo "selected='selected'"; ?>><?php echo getCatDir($categoryArray[$i]['cat_name'],$categoryArray[$i]['cat_father_id'], $categoryArray[$i]['cat_id']); ?></option>
	<?php } ?>
	</select>
	by 
	<select name="orderCol" class="textbox">
		<option value="name" <?php if(isset($_GET['orderCol']) && $_GET['orderCol']=="name") echo "selected='selected'";?>><?php echo $lang['admin']['products']['prod_name'];?></option>
		<option value="productId" <?php if(isset($_GET['orderCol']) && $_GET['orderCol']=="productId") echo "selected='selected'";?>><?php echo $lang['admin']['products']['prod_id'];?></option>
		<option value="productCode" <?php if(isset($_GET['orderCol']) && $_GET['orderCol']=="productCode") echo "selected='selected'";?>><?php echo $lang['admin']['products']['prod_code'];?></option>
		<option value="cat_id" <?php if(isset($_GET['orderCol']) && $_GET['orderCol']=="cat_id") echo "selected='selected'";?>><?php echo $lang['admin']['products']['master_cat2'];?></option>
		<option value="stock_level" <?php if(isset($_GET['orderCol']) && $_GET['orderCol']=="stock_level") echo "selected='selected'";?>><?php echo $lang['admin']['products']['stock_level'];?></option>
		<option value="price" <?php if(isset($_GET['orderCol']) && $_GET['orderCol']=="price") echo "selected='selected'";?>><?php echo $lang['admin']['products']['normal_price'];?></option>
		<option value="sale_price" <?php if(isset($_GET['orderCol']) && $_GET['orderCol']=="sale_price") echo "selected='selected'";?>><?php echo $lang['admin']['products']['sale_price'];?></option>
	</select> 
	in
    <select name="orderDir" class="textbox">
		<option value="ASC" <?php if(isset($_GET['orderDir']) && $_GET['orderDir']=="ASC") echo "selected='selected'";?>><?php echo $lang['admin']['products']['asc'];?></option>
		<option value="DESC" <?php if(isset($_GET['orderDir']) && $_GET['orderDir']=="DESC") echo "selected='selected'";?>><?php echo $lang['admin']['products']['desc'];?></option>
	</select> 
	<?php echo $lang['admin']['products']['containing_text'];?> 

  <input type="text" name="searchStr" class="textbox" value="<?php if(isset($_GET['searchStr']))echo $_GET['searchStr']; ?>" />
  <input name="submit" type="submit" value="<?php echo $lang['admin']['products']['filter'];?>" class="submit" />
  <input name="Button" type="button" onclick="MM_goToURL('parent','index.php');return document.MM_returnValue" value="<?php echo $lang['admin']['products']['reset'];?>" class="submit" />
</p>
</form>
<?php } ?><a href= "javascript:history.go(-2)" onMouseOver="self.status=document.referrer;return true" class="txtLink" >Return to Previous Product Page</a>
<p class="copyText"><?php echo $pagination; ?></p>
   <!-- // worcester wide web multi delete / reorder -->
<form action="index.php?multifunction=1" method="post" name="multi" id="multi">
   <!-- // worcester wide web multi delete / reorder -->
<table width="100%"  border="0" cellspacing="0" cellpadding="4" class="mainTable">
  <tr>
    <td align="center" class="tdTitle"><?php echo $lang['admin']['products']['id'];?></td>
    <td align="center" class="tdTitle"><?php echo $lang['admin']['products']['type'];?></td>
    <td align="center" class="tdTitle"><?php echo $lang['admin']['products']['prod_code'];?></td>
	<td align="center" class="tdTitle"><?php echo $lang['admin']['products']['name'];?></td>
    <td align="center" class="tdTitle"><?php echo $lang['admin']['products']['master_cat2'];?></td>
	<td align="center" class="tdTitle"><?php echo $lang['admin']['products']['image'];?></td>
	<td align="center" class="tdTitle"><?php echo $lang['admin']['products']['price_sale_price'];?></td>
    <td align="center" class="tdTitle"><?php echo $lang['admin']['products']['in_stock'];?></td>
    <?php // Total Clone Product by convict http://cubecart-mods-skins.com -->
    if ($c_tcp['status']) { ?>
    <td class="tdTitle" colspan="5" align="center" width="20%"><?php echo $lang['admin']['products']['action'];?></td>
  	<?php } else { ?>
    <td class="tdTitle" colspan="3" align="center" width="20%"><?php echo $lang['admin']['products']['action'];?></td>
  	<?php } // <-- Total Clone Product ?> </tr>
  <?php 
  if($results == TRUE){

for ($i=0; $i<count($results); $i++){ 

$cellColor = "";
$cellColor = cellColor($i);
  ?>
  <tr>
    <td align="center" class="<?php echo $cellColor; ?>"><span class="copyText"><?php echo $results[$i]['productId']; ?></span></td>
	<td align="center" class="<?php echo $cellColor; ?>"><img src="../images/productIcon<?php echo $results[$i]['digital'];?>.gif" alt="" width="16" height="16" title="" /></td>
	<td align="left" class="<?php echo $cellColor; ?>"><span class="copyText"><?php echo $results[$i]['productCode']; ?></span></td>
	<td align="left" class="<?php echo $cellColor; ?>"><span class="copyText"><?php echo $results[$i]['name']; ?></span></td>
    <td class="<?php echo $cellColor; ?>"><span class="txtDir"><?php echo getCatDir($results[$i]['cat_name'],$results[$i]['cat_father_id'], $results[$i]['cat_id']);?></span><br />
	  <a href="javascript:;" <?php if(permission("products","edit")==TRUE){ ?>onclick="openPopUp('<?php echo $GLOBALS['rootRel']; ?>admin/products/extraCats.php?productId=<?php echo $results[$i]['productId']; ?>&amp;cat_id=<?php echo $results[$i]['cat_id']; ?>&amp;cat_father_id=<?php echo $results[$i]['cat_father_id']; ?>&amp;cat_name=<?php echo urlencode($results[$i]['cat_name']); ?>&amp;name=<?php echo urlencode($results[$i]['name']); ?>','extraCats',500,450,1);" class="txtLink"<?php } else { echo $link401; } ?>><?php echo $lang['admin']['products']['manage_cats'];?></a></td>
    	

[avyona]

	
	<td align="center" valign="middle"  class="<?php echo $cellColor; ?>">
	<?php
	if(file_exists($GLOBALS['rootDir']."/images/uploads/thumbs/thumb_".$results[$i]['image']) && !empty($results[$i]['image'])){

	$imgSize = getimagesize($GLOBALS['rootDir']."/images/uploads/thumbs/thumb_".$results[$i]['image']);
	$imgFile = "/thumbs/thumb_".$results[$i]['image']; 

} elseif(file_exists($GLOBALS['rootDir']."/images/uploads/".$results[$i]['image']) && !empty($results[$i]['image'])){

	$imgSize = getimagesize($GLOBALS['rootDir']."/images/uploads/".$results[$i]['image']); 
	$imgFile = $results[$i]['image'];

}
?>
<?php if($imgFile == TRUE){ ?>
<img src="<?php echo $GLOBALS['rootRel'];?>images/uploads/<?php echo $imgFile; ?>" alt="<?php echo $results[$i]['name']; ?>" title="" <?php if($imgSize['0']>49){ ?>height="50"<?php } // end if image exists ?> />

<div><a href="javascript:;" <?php if(permission("products","edit")==TRUE){ ?>onclick="openPopUp('<?php echo $GLOBALS['rootRel']; ?>admin/products/extraImgs.php?productId=<?php echo $results[$i]['productId']; ?>&amp;img=<?php echo urlencode($results[$i]['image']); ?>','extraImgs',550,450,1);" class="txtLink"<?php } else { echo $link401; } ?>><?php echo $lang['admin']['products']['manage_images'];?></a></div>
<?php 
unset($imgFile);
} else { echo "&nbsp;"; }// end if image exists ?>
</td>
<td align="center" class="<?php echo $cellColor; ?>">
<span class="copyText"><?php echo priceFormat($results[$i]['price']); ?></span>

<?php 
$salePrice = salePrice($results[$i]['price'], $results[$i]['sale_price']);
if($salePrice==TRUE){?>
<br />
<span class="txtRed">
<?php
echo priceFormat($salePrice);
?>
</span>
<?php } ?>
</td>
<!-- start mod: Stock Levels for Product Options -->
<!-- by Estelle and DanV - http://cubecart.expandingbrain.com -->
    <td align="center" class="<?php echo $cellColor; ?>"><span class="copyText">
    <?php include("../includes/estelles_mod_store/stock_levels.admin1.inc.php"); ?>
    </span></td>
<!-- end mod: Stock Levels for Product Options -->

<!-- start mod: Related Products -->
<td align="center" class="<?php echo $cellColor; ?>"><a href="javascript:;" <?php if(permission("products","edit")==TRUE){ ?>onclick="openPopUp('<?php echo $GLOBALS['rootRel']; ?>admin/products/relatedProds.php?productId=<?php echo $results[$i]['productId']; ?>','relatedProds',550,600,'1,resizable=1');" class="txtLink"<?php } else { echo $link401; } ?>><?php echo $lang['admin']['related_prods']['related_products'];?></a></td>
<!-- end mod: Related Products -->
<td align="center" width="10&#37;" class="<?php echo $cellColor; ?>"><a <?php if(permission("products","edit")==TRUE){ ?>href="?edit=<?php echo $results[$i]['productId']; ?>" class="txtLink"<?php } else { echo $link401; } ?>><?php echo $lang['admin']['edit'];?></a></td>
<td align="center" width="10%" class="<?php echo $cellColor; ?>"><a <?php if(permission("products","delete")==TRUE){ ?>href="javascript:decision('<?php echo $lang['admin']['delete_q'];?>','?delete=<?php echo $results[$i]['productId']; ?>&cat_id=<?php echo $results[$i]['cat_id']; ?>');" class="txtLink"<?php } else { echo $link401; } ?>><?php echo $lang['admin']['delete'];?></a></td>

 <!-- // worcester wide web multi delete / reorder -->
     <td>
       <div align="left">
         <input type="checkbox" name="order[]" id="checkbox" value="<?php echo $results[$i]['productId']; ?>" />
         </div></td>
   <!-- // worcester wide web multi delete / reorder -->
   <?php // Total Clone Product by convict http://cubecart-mods-skins.com -->
    if ($c_tcp['status']) { ?>	<td align="center" width="10%" class="<?php echo $cellColor; ?>"><a <?php if(permission("products","edit")==TRUE){ ?>href="?clone=<?php echo $results[$i]['productId']; ?>" class="txtLink"<?php } else { echo $link401; } ?>><?php echo $lang['admin']['c_tcp']['clone']; ?></a></td>
  	<?php } // <-- Total Clone Product ?>

</tr>
  <?php } // end loop
  } else { ?>
<tr>
    <td colspan="6" class="tdText"><?php echo $lang['admin']['products']['no_products_exist'];?></td>
  </tr>

  <?php } ?>


 <!-- // worcester wide web multi delete / reorder -->
<tr>
  <td colspan="20">
  <select name="operation">
  <option selected="selected" value="">Choose an Operation</option>
  <option  value="delete">Delete Selected</option>
  <option  value="reorder">Move Selected to:</option>
  </select> 
<select name="cat_id" class="textbox">
	<?php for ($i=0; $i<count($categoryArray); $i++){ ?>
	<option value="<?php echo $categoryArray[$i]['cat_id']; ?>" <?php if(isset($results[0]['cat_id']) && $categoryArray[$i]['cat_id']==$results[0]['cat_id']) { echo "selected='selected'"; } ?>><?php echo getCatDir($categoryArray[$i]['cat_name'],$categoryArray[$i]['cat_father_id'], $categoryArray[$i]['cat_id']); ?></option>
	<?php } ?>
	</select> <input type="submit" value="submit" name="submit" />     <a href="javascript:checkedAll('multi', true)">Check All</a> |    <a href="javascript:checkedAll('multi', false)">Uncheck All</a>
  </td>
  </tr>

</table>

</form>
   <!-- // worcester wide web multi delete / reorder -->
<p class="copyText"><?php echo $pagination; ?></p><a href= "javascript:history.go(-2)" onMouseOver="self.status=document.referrer;return true" class="txtLink" >Return Previous Product Page</a>

<?php 
// Total Clone Product by convict http://cubecart-mods-skins.com -->
//} elseif(($_GET["mode"]=="new" && permission("products","write")==TRUE) || ($_GET["edit"]>0 && permission("products","edit")==TRUE)){  

// if(isset($_GET["edit"]) && $_GET["edit"]>0){ $modeTxt = $lang['admin']['edit']; } else { $modeTxt = $lang['admin']['add']; } 
} elseif(($_GET["mode"]=="new" && permission("products","write")==TRUE) || ($_GET["edit"]>0 && permission("products","edit")==TRUE) || ($c_tcp['status'] && $_GET["clone"]>0 && permission("products","write")==TRUE)){

if(isset($_GET["edit"]) && $_GET["edit"]>0){ $modeTxt = $lang['admin']['edit']; } else { $modeTxt = $lang['admin']['add']; }

if ($c_tcp['status'] && isset($_GET["clone"]) && $_GET["clone"]>0) {
	$clonemaster = $results[0]['productId'];
	unset($results[0]['productCode'], $results[0]['productId']);
}
// <-- Total Clone Product
?>
<p class="copyText"><?php echo $lang['admin']['products']['add_prod_desc'];?></p>
<form action="<?php echo $GLOBALS['rootRel'];?>admin/products/index.php" method="post" enctype="multipart/form-data" name="form1" language="javascript">
<table border="0" cellspacing="0" cellpadding="3" class="mainTable">
  <tr>
    <td colspan="2" class="tdTitle"><?php if(isset($_GET["edit"]) && $_GET["edit"]>0){ echo $modeTxt; } else { echo $modeTxt; } echo $lang['admin']['products']['product'];?> </td>
  </tr>
  <tr>
    <td width="25%" class="tdText"><strong><?php echo $lang['admin']['products']['prod_name2'];?></strong></td>
    <td>
      <input name="name" type="text" class="textbox" value="<?php if(isset($results[0]['name'])) echo validHTML($results[0]['name']); ?>" maxlength="255" />
    </td>
  </tr>
  <tr>
    <td width="25%" class="tdText"><strong><?php echo $lang['admin']['products']['prod_stock_no'];?></strong> <br />
<?php echo $lang['admin']['products']['auto_generated'];?>
</td>
    <td><input name="productCode" type="text" class="textbox" value="<?php if(isset($results[0]['productCode'])) echo $results[0]['productCode']; ?>" maxlength="255" /></td>
  </tr>
  <tr>
    <td colspan="2" class="tdRichText"><span class="tdText"><strong><?php echo $lang['admin']['products']['description'];?></strong> <?php echo $lang['admin']['products']['primary_lang'];?></span>
	  </td>
    </tr>
    	

[avyona]

	
  <tr>
    <td colspan="2" class="tdRichText">
<?php
		$oFCKeditor = new FCKeditor('FCKeditor');
		$oFCKeditor->BasePath = $GLOBALS['rootRel'].'admin/includes/rte/' ;

	if(isset($results[0]['description'])){ 
		$oFCKeditor->Value = $results[0]['description'];
	} else {
		$oFCKeditor->Value = "";
	}
	$oFCKeditor->Create();
?>
	</td>
    </tr>

  <tr>
    <td width="25&#37;" class="tdText"><strong><?php echo $lang['admin']['products']['category'];?></strong></td>
    <td>
	<select name="cat_id" class="textbox">
	<?php for ($i=0; $i<count($categoryArray); $i++){ ?>
	<option value="<?php echo $categoryArray[$i]['cat_id']; ?>" <?php if(isset($results[0]['cat_id']) && $categoryArray[$i]['cat_id']==$results[0]['cat_id']) { echo "selected='selected'"; } ?>><?php echo getCatDir($categoryArray[$i]['cat_name'],$categoryArray[$i]['cat_father_id'], $categoryArray[$i]['cat_id']); ?></option>
	<?php } ?>
	</select>
	</td>
  </tr><!-- start mod: Text Input Fields for Products, by Estelle -->
<?php $text_input_mod = fetchDbConfig("Text_Input_Mod");
      if ($text_input_mod && $text_input_mod['status']) { include("../includes/estelles_mod_store/text_input_mod.admin4.inc.php"); }
?>
<!-- end mod: Text Input Fields for Products, by Estelle -->
  <tr>
    <td width="25%" align="left" valign="top" class="tdText"><strong><?php echo $lang['admin']['products']['image2'];?></strong> <br />
	<?php echo $lang['admin']['products']['opt_and_thumbs'];?></td>
    <td valign="top"><div id="selectedImage"><?php if(!empty($results[0]['image'])){ ?><img src="<?php echo $GLOBALS['rootRel']."images/uploads/".$results[0]['image']; ?>" alt="<?php echo $results[0]['image']; ?>" title="" />
	<br/>
	<div  style="padding: 3px;"><input type="button" class="submit" src="../images/remove.gif" name="remove" style="width: 200px;" value="Remove Image" onclick="addImage('','')" /></div>
	<?php } ?></div><div id="imageControls"><table border="0" cellspacing="0" cellpadding="3">
  <tr>
    <td><input name="upload" style="width: 200px;" class="submit" type="button" id="upload" onclick="openPopUp('../filemanager/upload.php?custom=1','filemanager',450,250)" value="<?php echo $lang['admin']['products']['upload_new'];?>" /></td>
  </tr>
  <tr>
    <td><input name="browse" style="width: 200px;" class="submit" type="button" id="browse" onclick="openPopUp('../filemanager/browse.php?custom=1','filemanager',450,500)" value="<?php echo $lang['admin']['products']['browse_existing'];?>" /></td>
  </tr>
</table>
</div><input type="hidden" name="imageName" id="imageName" value="<?php if(isset($results[0]['image'])) echo $results[0]['image']; ?>" /></td>
  </tr>
  <tr>
    <td width="25%" class="tdText"><strong><?php echo $lang['admin']['products']['normal_price2'];?></strong></td>
    <td><input name="price" value="<?php if(isset($results[0]['price'])) echo $results[0]['price']; ?>" type="text" class="textbox" size="10" /></td>
  </tr>
  <tr>
    <td width="25%" class="tdText"><strong><?php echo $lang['admin']['products']['sale_price2'];?></strong><br />
      <?php echo $lang['admin']['products']['sale_mode_desc'];?> </td>
    <td><input name="sale_price" value="<?php if(isset($results[0]['sale_price'])) echo $results[0]['sale_price']; ?>" type="text" class="textbox" size="10" /></td>
  </tr>
  <tr>
    <td class="tdText"><strong><?php echo $lang['admin']['products']['prod_weight'];?></strong></td>
    <td class="tdText"><input name="prodWeight" type="text" class="textbox" size="10" value="<?php if(isset($results[0]['prodWeight'])) echo $results[0]['prodWeight']; ?>" /> <?php echo $config['weightUnit']; ?></td>
  </tr>
  <tr>
    <td class="tdText"><strong><?php echo $lang['admin']['products']['tax_class'];?></strong></td>
    <td class="tdText">
	<select name="taxType">
    <?php
	$taxTypes = $db->select("SELECT * FROM ".$glob['dbprefix']."CubeCart_taxes"); 
	?>
	<?php for($i=0; $i<count($taxTypes);$i++){ ?>
	<option value="<?php echo $taxTypes[$i]['id']; ?>" <?php if(isset($results[0]['taxType']) && $taxTypes[$i]['id'] == $results[0]['taxType']) echo "selected='selected'"; ?>><?php echo $taxTypes[$i]['taxName']; ?> (<?php echo $taxTypes[$i]['percent']; ?>%)</option>
	<?php } ?>
	</select>
	</td>
  </tr>
  <tr>
    <td class="tdText"><strong><?php echo $lang['admin']['products']['stock_level2'];?><br />
      </strong><?php echo $lang['admin']['products']['reduce_stock_level'];?>      </td>
   <!-- start mod: Stock Levels for Product Options -->
<!-- by Estelle and DanV - http://cubecart.expandingbrain.com -->
    <td class="tdText">
    <?php include("../includes/estelles_mod_store/stock_levels.admin2.inc.php"); ?>
    </td>
<!-- end mod: Stock Levels for Product Options -->


  </tr>
  <tr>
    <td class="tdText"><strong><?php echo $lang['admin']['products']['use_stock_q'];?></strong></td>
    <td class="tdText">
	<?php echo $lang['admin']['yes'];?>
      <input name="useStockLevel" type="radio" value="1" <?php if(isset($results[0]['useStockLevel']) && $results[0]['useStockLevel']==1) { echo "checked='checked'"; } elseif(!isset($results[0]['useStockLevel'])) { echo "checked='checked'"; } ?> />
<?php echo $lang['admin']['no'];?>
<input name="useStockLevel" type="radio" value="0" <?php if(isset($results[0]['useStockLevel']) && $results[0]['useStockLevel']==0) echo "checked='checked'"; ?> /></td>
  </tr>
  <tr>
    <td class="tdText" valign="top"><strong><?php echo $lang['admin']['products']['product_type'];?></strong> 
      </td>
    <td class="tdText"><?php echo $lang['admin']['products']['tangible'];?><span class="tdText">
      <input name="digital" onclick="digitalDir.className='hiddenTextbox';digitalDir.value=''" type="radio" value="0" <?php if(isset($results[0]['digital']) && $results[0]['digital']==0) { echo "checked='checked'"; } elseif(!isset($results[0]['digital'])) { echo "checked='checked'"; } ?> />
    </span> <?php echo $lang['admin']['products']['digital'];?><span class="tdText">
    <input name="digital" onclick="digitalDir.className='dirTextbox'" type="radio" value="1" <?php if(isset($results[0]['digital']) && $results[0]['digital']==1) { echo "checked='checked'"; } ?> />
  <!--// grishick advanced_file_manager mod START -->
	   <?php 
	   if($add_file_mgr_config['status']==1) {
	   ?>
	   <select name="digitalDir" id="digitalDir" <?php if(isset($results[0]['digitalDir']) && $results[0]['digital']==1) { echo "class='dirTextbox'"; } else { ?>class="hiddenTextbox" <?php } ?>><option value=""></option>
	   <?php
			$dirArray = walk_dir($rootFileFolder);
			$filesArray = array();
			$i = 0;
			if(is_array($dirArray)){

			foreach($dirArray as $file) {
				// get root rel link
				$fileRoot = "";
				$fileRoot = str_replace($rootFileFolder,"",$file);
				array_push($filesArray,$fileRoot);			
			}
		}
		arsort($filesArray);
			foreach($filesArray as $file) {?>
		<option value="<?php echo $file; ?>" <?php 
			if(isset($results[0]['digitalDir'])) {
				$fileRoot = str_replace($rootFileFolder,"",$results[0]['digitalDir']);
				if($file == $fileRoot) 
					echo " SELECTED";
			}
		?>><?php echo $file; ?></option>
			<?php }	   
   ?>
   </select>
   </td>

   <?php
   } else {
   ?>
   <!-- // grishick advanced_file_manager mod END -->
<input name="digitalDir" type="text" id="digitalDir" value="<?php if(isset($results[0]['digitalDir'])) echo $results[0]['digitalDir']; ?>" maxlength="255" <?php if(isset($results[0]['digitalDir']) && $results[0]['digital']==1) { echo "class='dirTextbox'"; } else { ?>class="hiddenTextbox" <?php } ?> />
<br />
<?php echo $lang['admin']['products']['digi_path'];?></span></td>
 <!-- grishick advanced_file_manager mod START -->
		<?php } ?>
   <!-- grishick advanced_file_manager mod END -->
    </tr>
	<tr>
    <td class="tdText"><strong><?php echo "Include in Favorite Products Slideshow?";?></strong></td>
    <td class="tdText">
	<select name="showFavorites" class="textbox">
        <option value="1" <?php if(isset($results[0]['showFavorites']) && $results[0]['showFavorites']==1) echo "selected='selected'"; ?>><?php echo $lang['admin']['yes'];?></option>
        <option value="0" <?php if(isset($results[0]['showFavorites']) && $results[0]['showFavorites']==0) echo "selected='selected'"; ?>><?php echo $lang['admin']['no'];?></option>
      </select>
	</td>
  </tr>
  <tr>
    <td class="tdText"><strong><?php echo $lang['admin']['products']['show_featured'];?></strong></td>
    <td class="tdText">
	<select name="showFeatured" class="textbox">
        <option value="1" <?php if(isset($results[0]['showFeatured']) && $results[0]['showFeatured']==1) echo "selected='selected'"; ?>><?php echo $lang['admin']['yes'];?></option>
        <option value="0" <?php if(isset($results[0]['showFeatured']) && $results[0]['showFeatured']==0) echo "selected='selected'"; ?>><?php echo $lang['admin']['no'];?></option>
      </select>
	</td>
  </tr>




<tr>
    <td colspan="2" valign="top" class="tdText">

[avyona]

	
//////////////////////////////BEGIN PRODUCT OPTION MANAGER/////////////////////////////////	
	 <?php
$optquery		= sprintf('SELECT * FROM &#37;sCubeCart_options_top WHERE 1', $glob['dbprefix']);
$options_result = $db->select($optquery);

if ($options_result) {

?>

<table border="0" cellspacing="0" cellpadding="4" class="mainTable" width="100%">
	  <tr> 
		<td colspan="2" class="tdTitle"><strong>Product Options</strong></td>
	  </tr>
	  <tr> 
		<td colspan="2" class="tdText">
		  <div id="options_added" style="width: 100%;">
		    <?php
		## Product Options (Current - Select)
		if (!empty($_GET['edit']) && is_numeric($_GET['edit'])) {
			$optionsc_query		= sprintf("SELECT T.option_name, M.value_name, B.* FROM %1\$sCubeCart_options_top AS T, %1\$sCubeCart_options_mid AS M, %1\$sCubeCart_options_bot AS B WHERE B.option_id = T.option_id AND B.value_id = M.value_id AND B.product = %2\$s AND T.option_type = '0' GROUP BY B.value_id ORDER BY T.option_name, M.value_name ASC", $glob['dbprefix'], $results[0]['productId']);
			$optionsc_result	= $db->select($optionsc_query);
			if ($optionsc_result) {
				foreach ($optionsc_result as $option) {
					$option['option_data'] = sprintf('%d|%d|%s', $option['option_id'], $option['value_id'], $option['option_price']);

				?>
	    <div id="option_<?php echo $option['assign_id']; ?>" style="clear: right;">
	      <span style="float: right; text-align: right;">
	        <a href="#" onClick="optionEdit('<?php echo $option['assign_id']; ?>', '<?php echo $option['option_data']; ?>'); return false;"><img src="/test/images/icons/edit.png" alt="edit" border="0"/></a>
	        <a href="#" onClick="optionRemove('<?php echo $option['assign_id']; ?>'); return false;"><img src="/test/images/icons/delete.png" alt="delete" border="0"/></a>				  </span>
	      <strong><?php echo $option['option_name']; ?></strong>: <?php echo $option['value_name']; ?> 
	      <?php if($option['option_price'] > 0) {  ?>
	      (<?php echo $option['option_symbol'].$option['option_price']; ?>)
	      <?php
			  }
			  ?>
	      </div>
	  <?php
			}
		}
	}
	## Product Options (Current - Text)
	$optionsct_query	= sprintf("SELECT B.*, T.* FROM %1\$sCubeCart_options_bot AS B, %1\$sCubeCart_options_top AS T WHERE B.option_id = T.option_id AND B.product = '%2\$d' AND T.option_type != '0' ORDER BY T.option_name ASC", $glob['dbprefix'], $results[0]['productId']);		
	$optionsct_result	= $db->select($optionsct_query);

	if ($optionsct_result) {
		foreach ($optionsct_result as $key => $option) {
			$option['option_data'] = sprintf('%d|%d|%s', $option['option_id'], 0, $option['option_price']);
			?>
	    <div id="option_<?php echo $option['assign_id']; ?>" style="clear: right;">
	      <span style="float: right; text-align: right;">
	        <a href="#" onClick="optionEdit('<?php echo $option['assign_id']; ?>', '<?php echo $option['option_data']; ?>'); return false;"><img src="images/icons/edit.png" alt="edit" border="0" /></a>
	        <a href="#" onClick="optionRemove('<?php echo $option['assign_id']; ?>'); return false;"><img src="images/icons/delete.png" alt="delete" border="0"/></a>			  </span>
	      <strong>Custom</strong>: <?php echo $option['option_name']; ?> (<?php echo $option['option_symbol'].$option['option_price']; ?>)			</div>
	  <?php
		}
	}

	?>
	      </div></td>
	</tr>
  <tr>
  	<td colspan="2">&nbsp;</td>
  </tr>
  <tr> 
	<td width="25%" align="left" valign="top" class="tdText"><strong>&nbsp;</strong></td>
	<td align="left">

	<select id="opt_mid" class="textbox">
	<option value="">Select Option</option>
	<?php
		## Product Options (Additional)
		if ($options_result) {
			foreach ($options_result as $option) {
				if ($option['option_type'] == '0') {
					$valquery = sprintf("SELECT * FROM %sCubeCart_options_mid WHERE father_id = '%d' ORDER BY value_name ASC;", $glob['dbprefix'], $option['option_id']);
					$values_result = $db->select($valquery);

					if ($values_result) {
						echo sprintf('<optgroup id="%d" label="%s">', $option['option_id'], $option['option_name']); 
						foreach ($values_result as $value) {
							echo sprintf('<option value="%d" class="sub">%s</option>', $value['value_id'], $value['value_name']);
						}
						echo '</optgroup>';
					}
				} else {
		## New textbox/textarea options
					echo sprintf('<option value="%d" class="top">%s</option>', $option['option_id'], $option['option_name']);
				}
			}
		}
	?>
	</select>
	<input type="hidden" id="opt_assign_id" value="0" />
	<input type="text" id="opt_price" value="0.00" class="textbox" />
	<input type="submit" value="Add Option" onClick="optionAdd(); return false;" class="submit" />		</td>
  </tr>
</table>
<?php 
} 
?>	</td>
</tr>

////////////////////////////////END PRODUCT OPTION MANAGER/////////////////////////////////////////////////









<!-- <rf> search engine friendly mod -->
<?php if($config['seftags']) { ?>
		<tr><td colspan="2"><p>
                <table width="100%"  border="0" cellspacing="0" cellpadding="4" class="mainTable">
                  <tr> 
                    <td colspan="2" class="tdTitle"><strong>Search Engine Friendly URL Meta Data For Product</strong></td>
                  </tr>
                  <tr> 
                    <td width="30%" class="tdText"><strong><?php echo $lang['admin']['settings']['browser_title']; ?></strong></td>
                    <td align="left"><input name="prod_metatitle" type="text" size="35" class="textbox" value="<?php if(isset($results[0]['prod_metatitle'])) echo $results[0]['prod_metatitle']; ?>" /></td>
                  </tr>
                  <tr> 
                    <td width="30%" align="left" valign="top" class="tdText"><strong><?php echo $lang['admin']['settings']['meta_desc'];?></strong></td>
                    <td align="left"><textarea name="prod_metadesc" cols="35" rows="3" class="textbox"><?php if(isset($results[0]['prod_metadesc'])) echo $results[0]['prod_metadesc']; ?></textarea></td>
                  </tr>
                  <tr> 
                    <td width="30%" align="left" valign="top" class="tdText"><strong><?php echo $lang['admin']['settings']['meta_keywords'];?></strong> <?php echo $lang['admin']['settings']['comma_separated'];?></td>
                    <td align="left"><textarea name="prod_metakeywords" cols="35" rows="3" class="textbox"><?php if(isset($results[0]['prod_metakeywords'])) echo $results[0]['prod_metakeywords']; ?></textarea></td>
                  </tr>
<?php if($config['sefcustomurl'] == 1) { ?>				  

                  <tr> 
                    <td width="30%" align="left" valign="top" class="tdText"><strong><?php echo 'Custom URL:';?></strong></td>
                    <td align="left">http://ccroot/<input name="prod_sefurl" type="text" size="20" class="textbox" value="<?php if(isset($results[0]['prod_sefurl'])) echo $results[0]['prod_sefurl']; ?>" />/p_xx.html</td>
                  </tr>
<?php } ?>				  				  

                </table>
		</p></td></tr>
<?php } ?>
<!-- <rf> end mod -->
  <tr>
    <td width="25%">&nbsp;</td>
    <td><?php // Total Clone Product by convict http://cubecart-mods-skins.com -->
	if ($c_tcp['status']) { ?>
	<input type="hidden" name="clone" value="<?php if (isset($_GET["clone"]) && $_GET["clone"]>0) { echo $clonemaster; unset($results[0]['cat_id']);} ?>" />
	<input type="hidden" name="clonei" value="<?php if (isset($_GET["clone"]) && $_GET["clone"]>0) { echo $results[0]['noImages']; } ?>" />
	<?php } // <-- Total Clone Product ?>
	<input type="hidden" name="oldCatId" value="<?php if(isset($results[0]['cat_id'])) echo $results[0]['cat_id']; ?>" />
	<input type="hidden" name="productId" value="<?php if(isset($results[0]['productId'])) echo $results[0]['productId']; ?>" />
	<input type="submit" name="Submit" class="submit" value="<?php if(isset($_GET["edit"]) && $_GET["edit"]>0){ echo $modeTxt; } else { echo $modeTxt;  } ?> <?php echo $lang['admin']['products']['product'];?>" /></td>
  </tr>
</table>
<br />

<div class="tdText"><em><u><strong><?php echo $lang['admin']['products']['digi_info'];?></strong></u></em> 
<?php echo $lang['admin']['products']['digi_desc'];?>
</div>
</form>
<?php } ?>
<?php include("../includes/footer.inc.php"); ?>

Any help would be apreciated greatly thanks! I've spent about a month on getting this working and no luck.

[avyona]

sorry about multiple posts....my second file would not all fit in one post ....how perturbing 🙁