PageRenderTime 64ms CodeModel.GetById 26ms RepoModel.GetById 1ms app.codeStats 0ms

/application/views/pages/admin/prods.php

https://bitbucket.org/chadsaun/ifrogz-panel
PHP | 1883 lines | 1805 code | 21 blank | 57 comment | 271 complexity | fedd94ab2a1a74f934902bc6b9ee3fad MD5 | raw file

Large files files are truncated, but you can click here to view the full file

    

  1. <script language="JavaScript" type="text/javascript" src="http://assets.ifrogz.com/lib/packages/scriptaculous-js/1.8.1/prototype.js"></script>
    2. 

  2. <script language="JavaScript" type="text/javascript" src="http://assets.ifrogz.com/lib/packages/scriptaculous-js/1.8.1/effects.js"></script>
    3. 

  3. <script language="JavaScript" type="text/javascript" src="http://assets.ifrogz.com/lib/packages/scriptaculous-js/1.8.1/controls.js"></script>
    4. 

  4. <script language="JavaScript" type="text/javascript" src="/lib/js/pages/admin/upc.js"></script>
    5. 

  5. <script language="JavaScript" type="text/javascript">
    6. 

  6. function loadOptions(id,i,selected) {
    7. 

  7.     var url = "/admin/prodsoptions.php";
    8. 

  8.     var params = "optGrpID="+id+'&cnt='+i+'&selected='+selected
    9. 

  9.     //alert(params);
    10. 

  10.     var ajax = new Ajax.Updater(
    11. 

  11. 		{success: "div_option_set"+i},
    12. 

  12. 		url,
    13. 

  13. 		{
    14. 

  14. 			method: "post", 
    15. 

  15. 			parameters: params,
    16. 

  16. 			onLoading: function() { Element.show("div_option_set_working"+i); },
    17. 

  17. 			onComplete: function() { Element.hide("div_option_set_working"+i); }
    18. 

  18. 		});
    19. 

  19. }
    20. 

  20. 

  21. function viewImage(images,view){
    22. 

  22. 	if($(view).style.display=='none'){ 
    23. 

  23. 		var outHTML='';
    24. 

  24. 		imagesArr = Array();
    25. 

  25. 		img=$F(images);
    26. 

  26. 		imagesArr=img.split(',');
    27. 

  27. 		 
    28. 

  28. 		
    29. 

  29. 		for(i=0;i<imagesArr.length;i++){
    30. 

  30. 			count=i+1;
    31. 

  31. 			outHTML+='<div style="float:left;padding:4px;">Image '+count+'<br /><img src="http://ifrogz.com'+imagesArr[i]+'" /></div>';
    32. 

  32. 		}
    33. 

  33. 		Element.show(view);
    34. 

  34. 		$(view).innerHTML=outHTML;
    35. 

  35. 	} else {
    36. 

  36. 		Element.hide(view);
    37. 

  37. 	}//alert(outHTML);
    38. 

  38. }
    39. 

  39. 

  40. </script>
    41. 

  41. <style>
    42. 

  42. div#links {text-align: center;}
    43. 

  43. div#links a {display: block; text-align: center;}
    44. 

  44. div#links a span {display: none; text-decoration:none;color:#003366;}
    45. 

  45. div#links a:hover span {
    46. 

  46. 	display: block;
    47. 

  47. 	position: absolute;
    48. 

  48. 	width: 200px;
    49. 

  49. 	z-index: 100;
    50. 

  50. 	text-align: left;
    51. 

  51. 	margin: 20px 0 0 -20px;
    52. 

  52. 	background:#D9DFEF;
    53. 

  53. 	border: 1px solid #003366;
    54. 

  54. 	padding:4px;
    55. 

  55. }
    56. 

  56. .style1 {font-size: 10px}
    57. 

  57. 

  58. .imageView {
    59. 

  59. 	position: absolute;
    60. 

  60. 	left:0px;
    61. 

  61. 	top:0px;
    62. 

  62. 	z-index:100;
    63. 

  63. 	width:800px;
    64. 

  64. 	border:1px solid #003366;
    65. 

  65. 	padding:4px;
    66. 

  66. 	background-color:#FFFFFF;
    67. 

  67. 	font-size:9px;
    68. 

  68. }
    69. 

  69.  div.autocomplete {
    70. 

  70.       position:absolute;      
    71. 

  71.       background-color:white;
    72. 

  72.       border:1px solid #CCC;
    73. 

  73.       margin:0px;
    74. 

  74.       padding:0px;
    75. 

  75. 	  
    76. 

  76.     }
    77. 

  77.     div.autocomplete ul {
    78. 

  78.       list-style-type:none;
    79. 

  79.       margin:0px;
    80. 

  80.       padding:0px;
    81. 

  81. 	  width:432px;
    82. 

  82.     }
    83. 

  83.     div.autocomplete ul li.selected { background-color: #E7EAEF;}
    84. 

  84.     div.autocomplete ul li {
    85. 

  85. 	  list-style-type:none;
    86. 

  86.       display:block;
    87. 

  87.       margin:0;
    88. 

  88.       padding:2px;
    89. 

  89.       height:14px;
    90. 

  90.       cursor:pointer;
    91. 

  91.     }
    92. 

  92. </style>
    93. 

  93. <?php
    94. 

  94. //This code is copyright (c) Internet Business Solutions SL, all rights reserved.
    95. 

  95. //The contents of this file are protect under law as the intellectual property of Internet
    96. 

  96. //Business Solutions SL. Any use, reproduction, disclosure or copying of any kind 
    97. 

  97. //without the express and written permission of Internet Business Solutions SL is forbidden.
    98. 

  98. //Author: Vince Reid, vince@virtualred.net
    99. 

  99. if(@$storesessionvalue=="") $storesessionvalue="virtualstore".time();
    100. 

  100. if($_SESSION["loggedon"] != $storesessionvalue || @$disallowlogin==TRUE) exit();
    101. 

  101. $success=TRUE;
    102. 

  102. $nprodoptions=0;
    103. 

  103. $nprodsections=0;
    104. 

  104. $nalloptions=0;
    105. 

  105. $nallsections=0;
    106. 

  106. $nalldropship=0;
    107. 

  107. $alreadygotadmin = getadminsettings();
    108. 

  108. $simpleOptions = (($adminTweaks & 2)==2);
    109. 

  109. $simpleSections = (($adminTweaks & 4)==4);
    110. 

  110. $dorefresh=FALSE;
    111. 

  111. if(@$maxprodsects=="") $maxprodsects=20;
    112. 

  112. 

  113. if(@$_POST["posted"]=="1"){
    114. 

  114. 	$pExemptions=0;
    115. 

  115. 	if(is_array(@$_POST["pExemptions"])){
    116. 

  116. 		foreach(@$_POST["pExemptions"] as $pExemptObj)
    117. 

  117. 			$pExemptions += $pExemptObj;
    118. 

  118. 	}
    119. 

  119. 	if(@$_POST["act"]=="delete"){
    120. 

  120. 		$sSQL = "DELETE FROM pricebreaks WHERE pbProdID='" . mysql_real_escape_string(@$_POST["id"]) . "'";
    121. 

  121. 		mysql_query($sSQL) or print(mysql_error());
    122. 

  122. 		$sSQL = "DELETE FROM cpnassign WHERE cpaType=2 AND cpaAssignment='" . mysql_real_escape_string(@$_POST["id"]) . "'";
    123. 

  123. 		mysql_query($sSQL) or print(mysql_error());
    124. 

  124. 		$sSQL = "DELETE FROM products WHERE pID='" . mysql_real_escape_string(@$_POST["id"]) . "'";
    125. 

  125. 		mysql_query($sSQL) or print(mysql_error());
    126. 

  126. 		$sSQL = "DELETE FROM prodoptions WHERE poProdID='" . mysql_real_escape_string(@$_POST["id"]) . "'";
    127. 

  127. 		mysql_query($sSQL) or print(mysql_error());
    128. 

  128. 		$sSQL = "DELETE FROM multisections WHERE pID='" . mysql_real_escape_string(@$_POST["id"]) . "'";
    129. 

  129. 		mysql_query($sSQL) or print(mysql_error());
    130. 

  130. 		$dorefresh=TRUE;
    131. 

  131. 	}elseif(@$_POST["act"]=="domodify"){
    132. 

  132. 		if(trim(@$_POST["newid"]) != trim(@$_POST["id"])){
    133. 

  133. 			$sSQL = "SELECT * FROM products WHERE pID='" . trim(@$_POST["newid"]) . "'";
    134. 

  134. 			$result = mysql_query($sSQL) or print(mysql_error());
    135. 

  135. 			$success = (mysql_num_rows($result)==0);
    136. 

  136. 			mysql_free_result($result);
    137. 

  137. 			if($success){
    138. 

  138. 				mysql_query("UPDATE pricebreaks SET pbProdID='" . trim(@$_POST["newid"]) . "' WHERE pbProdID='" . trim(@$_POST["id"]) . "'") or print(mysql_error());
    139. 

  139. 				mysql_query("UPDATE cpnassign SET cpaAssignment='" . trim(@$_POST["newid"]) . "' WHERE cpaType=2 AND cpaAssignment='" . trim(@$_POST["id"]) . "'") or print(mysql_error());
    140. 

  140. 			}
    141. 

  141. 		}
    142. 

  142. 		if($success){
    143. 

  143. 			$sSQL = "UPDATE products SET ";
    144. 

  144. 						$sSQL .= "pID='" . mysql_real_escape_string(trim(unstripslashes(@$_POST["newid"]))) . "', ";
    145. 

  145. 						$sSQL .= "pNUM='" . mysql_real_escape_string(trim(unstripslashes(@$_POST["altprodid"]))) . "', ";
    146. 

  146. 						$sSQL .= "pName='" . mysql_real_escape_string(unstripslashes(trim(@$_POST["pName"]))) . "', ";
    147. 

  147. 						$sSQL .= "pSection=" . trim(@$_POST["pSection"]) . ", ";
    148. 

  148. 						$sSQL .= "pDropship=" . trim(@$_POST["pDropship"]) . ", ";
    149. 

  149. 						$sSQL .= "pExemptions=" . $pExemptions . ", ";
    150. 

  150. 						$sSQL .= "pDescription='" . mysql_real_escape_string(unstripslashes(trim(@$_POST["pDescription"]))) . "', ";
    151. 

  151. 						$sSQL .= "pDescription2='" . mysql_real_escape_string(unstripslashes(trim(@$_POST["pDescription2"]))) . "', ";
    152. 

  152. 						$sSQL .= "pDescription3='" . mysql_real_escape_string(unstripslashes(trim(@$_POST["pDescription3"]))) . "', ";
    153. 

  153. 						$sSQL .= "pImage='" . mysql_real_escape_string(unstripslashes(trim(@$_POST["pImage"]))) . "', ";
    154. 

  154. 						$sSQL .= "pLongDescription='" . mysql_real_escape_string(unstripslashes(trim(@$_POST["pLongDescription"]))) . "', ";
    155. 

  155. 						$sSQL .= "pUPC='" . mysql_real_escape_string(unstripslashes(trim($_POST['pUPC']))) . "', ";
    156. 

  156. 						$sSQL .= "pBin='" . mysql_real_escape_string(unstripslashes(trim($_POST['pBin']))) . "', ";
    157. 

  157. 						for($index=2; $index <= $adminlanguages+1; $index++){
    158. 

  158. 							if(($adminlangsettings & 1)==1) $sSQL .= "pName" . $index . "='" . mysql_real_escape_string(unstripslashes(trim(@$_POST["pName" . $index]))) . "', ";
    159. 

  159. 							if(($adminlangsettings & 2)==2) $sSQL .= "pDescription" . $index . "='" . mysql_real_escape_string(unstripslashes(trim(@$_POST["pDescription" . $index]))) . "', ";
    160. 

  160. 							if(($adminlangsettings & 4)==4) $sSQL .= "pLongDescription" . $index . "='" . mysql_real_escape_string(unstripslashes(trim(@$_POST["pLongDescription" . $index]))) . "', ";
    161. 

  161. 						}
    162. 

  162. 						if($setoptions=='yes') {
    163. 

  163. 							$comma='';
    164. 

  164. 							for($rowcounter=0; $rowcounter < maxprodopts; $rowcounter++){
    165. 

  165. 								if(@$_POST["set_options_list" . $rowcounter] != "" && @$_POST["set_options_list" . $rowcounter] != 0){
    166. 

  166. 									$str_options .= $comma.@$_POST["set_options_list" . $rowcounter];
    167. 

  167. 									$comma=',';
    168. 

  168. 								}
    169. 

  169. 							}
    170. 

  170. 							$sSQL .= "pSetOptions='" . $str_options . "',";
    171. 

  171. 						} else  $sSQL .= "pSetOptions='',";
    172. 

  172. 						$sSQL .= "isSet='" . $completeset . "',";
    173. 

  173. 						$sSQL .= "pLargeImage='" . mysql_real_escape_string(unstripslashes(trim(@$_POST["pLargeImage"]))) . "', ";
    174. 

  174. 						if(trim(@$_POST["pDisplay"]) == "ON")
    175. 

  175. 							$sSQL .= "pDisplay=1,pOrder=" . trim(@$_POST["pOrder"]) . ",";
    176. 

  176. 						else
    177. 

  177. 							$sSQL .= "pDisplay=0,";
    178. 

  178. 						if(trim(@$_POST["pEDisplay"]) == "ON")
    179. 

  179. 							$sSQL .= "pEDisplay=1,";
    180. 

  180. 						else
    181. 

  181. 							$sSQL .= "pEDisplay=0,";
    182. 

  182. 						$sSQL .= "pTabName='".mysql_real_escape_string(unstripslashes(trim($_POST['pTabName']))) . "', ";
    183. 

  183. 						if(@$perproducttaxrate==TRUE)
    184. 

  184. 							$sSQL .= "pTax=" . trim(@$_POST["pTax"]) . ",";
    185. 

  185. 						if($stockManage != 0 && is_numeric(trim(@$_POST["inStock"])))
    186. 

  186. 							$sSQL .= "pInStock=" . trim(@$_POST["inStock"]) . ",";
    187. 

  187. 						if(trim(@$_POST["pSell"]) == "ON") $pSell=1; else $pSell=0;
    188. 

  188. 						if(trim(@$_POST["stockOptions"]) == "1") $pSell += 2;
    189. 

  189. 						if(trim(@$_POST["staticpage"]) == "1") $pSell += 4;
    190. 

  190. 						$sSQL .= "pSell=" . $pSell . ",";
    191. 

  191. 						$sSQL .= "pURL='" . trim($_POST['pURL']) . "',";						
    192. 

  192. 						if(@$productdimensions==TRUE)
    193. 

  193. 							$sSQL .= "pDims='" . trim(@$_POST["plen"]) . "x" . trim(@$_POST["pwid"]) . "x" . trim(@$_POST["phei"]) . "',";
    194. 

  194. 						if(@$digidownloads==TRUE)
    195. 

  195. 							$sSQL .= "pDownload='" . mysql_real_escape_string(unstripslashes(trim(@$_POST["pDownload"]))) . "',";
    196. 

  196. 						if($shipType==1){
    197. 

  197. 							if(! is_numeric(trim(@$_POST["pShipping"])))
    198. 

  198. 								$sSQL .= "pShipping=0,";
    199. 

  199. 							else
    200. 

  200. 								$sSQL .= "pShipping=" . trim(@$_POST["pShipping"]) . ",";
    201. 

  201. 							if(! is_numeric(trim(@$_POST["pShipping2"])))
    202. 

  202. 								$sSQL .= "pShipping2=0,";
    203. 

  203. 							else
    204. 

  204. 								$sSQL .= "pShipping2=" . trim(@$_POST["pShipping2"]) . ",";
    205. 

  205. 						}elseif($shipType==2 || $shipType==3 || $shipType==4 || $shipType==6){
    206. 

  206. 							if(! is_numeric(trim(@$_POST["pShipping"])))
    207. 

  207. 								$sSQL .= "pWeight=0,";
    208. 

  208. 							else
    209. 

  209. 								$sSQL .= "pWeight=" . trim(@$_POST["pShipping"]) . ",";
    210. 

  210. 						}
    211. 

  211. 						if(trim(@$_POST["pWholesalePrice"]) != "")
    212. 

  212. 							$sSQL .= "pWholesalePrice=" . trim(@$_POST["pWholesalePrice"]) . ",";
    213. 

  213. 						else
    214. 

  214. 							$sSQL .= "pWholesalePrice=0,";
    215. 

  215. 						//wholesale pricing group added 6-6-06 By Blake
    216. 

  216. 						$sSQL .= "pPricing_group=" .trim(@$_POST["pPricing_group"]). ",";
    217. 

  217. 						//
    218. 

  218. 						if(trim(@$_POST["pListPrice"]) != "")
    219. 

  219. 							$sSQL .= "pListPrice=" . trim(@$_POST["pListPrice"]) . ",";
    220. 

  220. 						else
    221. 

  221. 							$sSQL .= "pListPrice=0,";
    222. 

  222. 						$sSQL .= "pPrice=" . trim(@$_POST["pPrice"]) . ",";
    223. 

  223. 						if(! is_numeric(trim(@$_POST["pCost"])))
    224. 

  224. 							$sSQL .= "pCost=0,";
    225. 

  225. 						else
    226. 

  226. 							$sSQL .= "pCost=" . trim(@$_POST["pCost"]) . ",";
    227. 

  227. 						if(! is_numeric(trim(@$_POST["pCustomsvalue"])))
    228. 

  228. 							$sSQL .= "pCustomsvalue=0,";
    229. 

  229. 						else
    230. 

  230. 							$sSQL .= "pCustomsvalue=" . trim(@$_POST["pCustomsvalue"]) . ",";
    231. 

  231. 						$sSQL .= "pCatOnDetail='" . trim(@$_POST["pCatOnDetail"]) . "', ";
    232. 

  232. 						$sSQL .= "pTitleTag = '" . trim($_POST['title_tag']) . "', ";
    233. 

  233. 						$sSQL .= "pMetaDescription = '" . trim($_POST['meta_description']) . "' ";
    234. 

  234. 						$sSQL .= "WHERE pID='" . @$_POST["id"] . "'";
    235. 

  235. 			//echo $sSQL;
    236. 

  236. 			//exit();
    237. 

  237. 			mysql_query($sSQL) or print(mysql_error());
    238. 

  238. 			$sSQL = "DELETE FROM prodoptions WHERE poProdID='" . @$_POST["id"] . "'";
    239. 

  239. 			mysql_query($sSQL) or print(mysql_error());
    240. 

  240. 			for($rowcounter=0; $rowcounter < maxprodopts; $rowcounter++){
    241. 

  241. 				if(@$_POST["pOption" . $rowcounter] != "" && @$_POST["pOption" . $rowcounter] != 0){
    242. 

  242. 					$sSQL = "INSERT INTO prodoptions (poProdID,poOptionGroup) VALUES ('" . @$_POST["newid"] . "'," . @$_POST["pOption" . $rowcounter] . ")";
    243. 

  243. 					mysql_query($sSQL) or print(mysql_error());
    244. 

  244. 				}
    245. 

  245. 			}			
    246. 

  246. 			$sSQL = "DELETE FROM multisections WHERE pID='" . @$_POST["id"] . "'";
    247. 

  247. 			mysql_query($sSQL) or print(mysql_error());
    248. 

  248. 			for($rowcounter=0; $rowcounter < $maxprodsects; $rowcounter++){
    249. 

  249. 				if(@$_POST["pSection" . $rowcounter] != "" && @$_POST["pSection" . $rowcounter] != 0 && @$_POST["pSection"] != @$_POST["pSection" . $rowcounter]){
    250. 

  250. 					$sSQL = "INSERT INTO multisections (pID,pSection) VALUES ('" . @$_POST["newid"] . "'," . @$_POST["pSection" . $rowcounter] . ")";
    251. 

  251. 					mysql_query($sSQL) or print(mysql_error());
    252. 

  252. 				}
    253. 

  253. 			}
    254. 

  254. 			$dorefresh=TRUE;
    255. 

  255. 		}else
    256. 

  256. 			$errmsg = $yyPrDup;
    257. 

  257. 	}elseif(@$_POST["act"]=="doaddnew"){
    258. 

  258. 		$sSQL = "SELECT * FROM products WHERE pID='" . trim(@$_POST["newid"]) . "'";
    259. 

  259. 		$result = mysql_query($sSQL) or print(mysql_error());
    260. 

  260. 		$success = (mysql_num_rows($result)==0);
    261. 

  261. 		mysql_free_result($result);
    262. 

  262. 		if($success){
    263. 

  263. 			$sSQL = "INSERT INTO products (pUPC,pBin,pID,pNUM,pName,pSection,pDropship,pExemptions,pDescription,pImage,pLongDescription,pCatOnDetail,";
    264. 

  264. 			for($index=2; $index <= $adminlanguages+1; $index++){
    265. 

  265. 				if(($adminlangsettings & 1)==1) $sSQL .= "pName" . $index . ",";
    266. 

  266. 				if(($adminlangsettings & 2)==2) $sSQL .= "pDescription" . $index . ",";
    267. 

  267. 				if(($adminlangsettings & 4)==4) $sSQL .= "pLongDescription" . $index . ",";
    268. 

  268. 			}
    269. 

  269. 			$sSQL .= "pSetOptions,isSet,pLargeImage,pPrice,pCost,pCustomsvalue,pWholesalePrice,pPricing_group,pListPrice,";
    270. 

  270. 			if($shipType==1) $sSQL .= "pShipping,pShipping2,";
    271. 

  271. 			$sSQL .= "pDisplay,pOrder,pEDisplay,pTabName,";
    272. 

  272. 			if(@$perproducttaxrate==TRUE) $sSQL .= "pTax,";
    273. 

  273. 			if($stockManage != 0 && is_numeric(trim(@$_POST["inStock"]))) $sSQL .= "pInStock,";
    274. 

  274. 			if(@$productdimensions==TRUE) $sSQL .= 'pDims,';
    275. 

  275. 			if(@$digidownloads==TRUE) $sSQL .= 'pDownload,';
    276. 

  276. 			$sSQL .= "pSell,pURL,pWeight,pTitleTag,pMetaDescription) VALUES (";
    277. 

  277. 						$sSQL .= "'" . trim(unstripslashes(@$_POST["pUPC"])) . "',";
    278. 

  278. 						$sSQL .= "'" . trim(unstripslashes(@$_POST["pBin"])) . "',";
    279. 

  279. 						$sSQL .= "'" . trim(unstripslashes(@$_POST["newid"])) . "',";
    280. 

  280. 						$sSQL .= "'" . trim(unstripslashes(@$_POST["altprodid"])) . "',";
    281. 

  281. 						$sSQL .= "'" . mysql_real_escape_string(unstripslashes(@$_POST["pName"])) . "',";
    282. 

  282. 						$sSQL .= @$_POST["pSection"] . ",";
    283. 

  283. 						$sSQL .= @$_POST["pDropship"] . ",";
    284. 

  284. 						$sSQL .= $pExemptions . ",";
    285. 

  285. 						$sSQL .= "'" . mysql_real_escape_string(unstripslashes(@$_POST["pDescription"])) . "',";
    286. 

  286. 						$sSQL .= "'" . mysql_real_escape_string(unstripslashes(@$_POST["pImage"])) . "',";
    287. 

  287. 						$sSQL .= "'" . mysql_real_escape_string(unstripslashes(@$_POST["pLongDescription"])) . "',";
    288. 

  288. 						$sSQL .= "'" . mysql_real_escape_string(unstripslashes(@$_POST["pCatOnDetail"])) . "',";
    289. 

  289. 						for($index=2; $index <= $adminlanguages+1; $index++){
    290. 

  290. 							if(($adminlangsettings & 1)==1) $sSQL .= "'" . mysql_real_escape_string(unstripslashes(@$_POST["pName" . $index])) . "',";
    291. 

  291. 							if(($adminlangsettings & 2)==2) $sSQL .= "'" . mysql_real_escape_string(unstripslashes(@$_POST["pDescription" . $index])) . "',";
    292. 

  292. 							if(($adminlangsettings & 4)==4) $sSQL .= "'" . mysql_real_escape_string(unstripslashes(@$_POST["pLongDescription" . $index])) . "',";
    293. 

  293. 						}
    294. 

  294. 						 if($setoptions=='yes') {
    295. 

  295. 							$comma='';
    296. 

  296. 							for($rowcounter=0; $rowcounter < maxprodopts; $rowcounter++){
    297. 

  297. 								if(@$_POST["set_options_list" . $rowcounter] != "" && @$_POST["set_options_list" . $rowcounter] != 0){
    298. 

  298. 									$str_options .= $comma.@$_POST["set_options_list" . $rowcounter];
    299. 

  299. 									$comma=',';
    300. 

  300. 								}
    301. 

  301. 							}
    302. 

  302. 							$sSQL .= "'" . $str_options . "',";
    303. 

  303. 						} else  $sSQL .= "'',";
    304. 

  304. 						$sSQL .= "'" . $completeset . "',";
    305. 

  305. 						$sSQL .= "'" . mysql_real_escape_string(unstripslashes(@$_POST["pLargeImage"])) . "',";
    306. 

  306. 						$sSQL .= "'".trim(@$_POST["pPrice"]) . "',";
    307. 

  307. 						$sSQL .= "'".trim(@$_POST["pCost"]) . "',";
    308. 

  308. 						$sSQL .= "'".trim(@$_POST["pCustomsvalue"]) . "',";
    309. 

  309. 						if(trim(@$_POST["pWholesalePrice"]) != "")
    310. 

  310. 							$sSQL .= trim(@$_POST["pWholesalePrice"]) . ",";
    311. 

  311. 						else
    312. 

  312. 							$sSQL .= "0,";							
    313. 

  313. 						//wholesale pricing group added 6-6-06 By Blake
    314. 

  314. 						$sSQL .= trim(@$_POST["pPricing_group"]) . ",";
    315. 

  315. 						//
    316. 

  316. 						if(trim(@$_POST["pListPrice"]) != "")
    317. 

  317. 							$sSQL .= trim(@$_POST["pListPrice"]) . ",";
    318. 

  318. 						else
    319. 

  319. 							$sSQL .= "0,";
    320. 

  320. 						if($shipType==1){
    321. 

  321. 							if(! is_numeric(trim(@$_POST["pShipping"])))
    322. 

  322. 								$sSQL .= "0,";
    323. 

  323. 							else
    324. 

  324. 								$sSQL .= trim(@$_POST["pShipping"]) . ",";
    325. 

  325. 							if(! is_numeric(trim(@$_POST["pShipping2"])))
    326. 

  326. 								$sSQL .= "0,";
    327. 

  327. 							else
    328. 

  328. 								$sSQL .= trim(@$_POST["pShipping2"]) . ",";
    329. 

  329. 						}
    330. 

  330. 						if(trim(@$_POST["pDisplay"]) == "ON")
    331. 

  331. 							$sSQL .= "1," . trim(@$_POST["pOrder"]) . ",";
    332. 

  332. 						else
    333. 

  333. 							$sSQL .= "0,0,";
    334. 

  334. 						if(trim(@$_POST["pEDisplay"]) == "ON")
    335. 

  335. 							$sSQL .= "1,";
    336. 

  336. 						else
    337. 

  337. 							$sSQL .= "0,";
    338. 

  338. 						$sSQL .= "'" . mysql_real_escape_string(unstripslashes(@$_POST["pTabName"])) . "',";	
    339. 

  339. 							
    340. 

  340. 						if(@$perproducttaxrate==TRUE) $sSQL .= "'" . @$_POST["pTax"] . "',";
    341. 

  341. 						if($stockManage != 0 && is_numeric(trim(@$_POST["inStock"])))
    342. 

  342. 							$sSQL .= trim(@$_POST["inStock"]) . ",";
    343. 

  343. 						if(@$productdimensions==TRUE)
    344. 

  344. 							$sSQL .= "'" . trim(@$_POST["plen"]) . "x" . trim(@$_POST["pwid"]) . "x" . trim(@$_POST["phei"]) . "',";
    345. 

  345. 						if(@$digidownloads==TRUE)
    346. 

  346. 							$sSQL .= "'" . mysql_real_escape_string(unstripslashes(trim(@$_POST["pDownload"]))) . "',";
    347. 

  347. 						if(trim(@$_POST["pSell"]) == "ON") $pSell=1; else $pSell=0;
    348. 

  348. 						if(trim(@$_POST["stockOptions"]) == "1") $pSell += 2;
    349. 

  349. 						if(trim(@$_POST["staticpage"]) == "1") $pSell += 4;
    350. 

  350. 						$sSQL .= $pSell . ",";
    351. 

  351. 						$sSQL .= "'" . trim($_POST['pURL']) . "',";
    352. 

  352. 						if($shipType <= 1 || ! is_numeric(trim(@$_POST["pShipping"])))
    353. 

  353. 							$sSQL .= "0";
    354. 

  354. 						elseif($shipType==2 || $shipType==3 || $shipType==4 || $shipType==6)
    355. 

  355. 							$sSQL .= trim(@$_POST["pShipping"]) . "";
    356. 

  356. 						else{
    357. 

  357. 							$sSQL .= trim(@$_POST["pShipping"]) . ".";
    358. 

  358. 							if((int)trim(@$_POST["pShipping2"]) < 10) $sSQL .= "0";
    359. 

  359. 							$sSQL .= trim(@$_POST["pShipping2"]);
    360. 

  360. 						}
    361. 

  361. 						$sSQL .= ", ";
    362. 

  362. 						$sSQL .= "'" . trim($_POST['title_tag']) . "',";
    363. 

  363. 						$sSQL .= "'" . trim($_POST['meta_description']) . "'";
    364. 

  364. 						$sSQL .= ")";
    365. 

  365. 			//echo $sSQL;
    366. 

  366. 			
    367. 

  367. 			mysql_query($sSQL) or print(mysql_error() . '<br/>Query: ' . $sSQL);
    368. 

  368. 			//exit();
    369. 

  369. 			for($rowcounter=0; $rowcounter < maxprodopts; $rowcounter++){
    370. 

  370. 				if(@$_POST["pOption" . $rowcounter] != "" && @$_POST["pOption" . $rowcounter] != 0){
    371. 

  371. 					$sSQL = "INSERT INTO prodoptions (poProdID,poOptionGroup) VALUES ('" . @$_POST["newid"] . "'," . @$_POST["pOption" . $rowcounter] . ")";
    372. 

  372. 					mysql_query($sSQL) or print(mysql_error());
    373. 

  373. 				}
    374. 

  374. 			}			
    375. 

  375. 			$sSQL = "DELETE FROM multisections WHERE pID='" . @$_POST["newid"] . "'";
    376. 

  376. 			mysql_query($sSQL) or print(mysql_error());
    377. 

  377. 			for($rowcounter=0; $rowcounter < $maxprodsects; $rowcounter++){
    378. 

  378. 				if(@$_POST["pSection" . $rowcounter] != "" && @$_POST["pSection" . $rowcounter] != 0 && @$_POST["pSection"] != @$_POST["pSection" . $rowcounter]){
    379. 

  379. 					$sSQL = "INSERT INTO multisections (pID,pSection) VALUES ('" . @$_POST["newid"] . "'," . @$_POST["pSection" . $rowcounter] . ")";
    380. 

  380. 					mysql_query($sSQL) or print(mysql_error());
    381. 

  381. 				}
    382. 

  382. 			}
    383. 

  383. 			$dorefresh=TRUE;
    384. 

  384. 		}else
    385. 

  385. 			$errmsg = "Sorry, that product reference is already in use. Please use your browser back button to return and correct the problem.";
    386. 

  386. 	}elseif(@$_POST["act"]=="dodiscounts"){
    387. 

  387. 		$sSQL = "INSERT INTO cpnassign (cpaCpnID,cpaType,cpaAssignment) VALUES (" . @$_POST["assdisc"] . ",2,'" . @$_POST["id"] . "')";
    388. 

  388. 		mysql_query($sSQL) or print(mysql_error());
    389. 

  389. 		$dorefresh=TRUE;
    390. 

  390. 	}elseif(@$_POST["act"]=="deletedisc"){
    391. 

  391. 		$sSQL = "DELETE FROM cpnassign WHERE cpaID=" . @$_POST["id"];
    392. 

  392. 		mysql_query($sSQL) or print(mysql_error());
    393. 

  393. 		$dorefresh=TRUE;
    394. 

  394. 	}
    395. 

  395. 	if(@$_POST["act"]=="modify" || @$_POST["act"]=="clone" || @$_POST["act"]=="addnew"){
    396. 

  396. 		$sSQL = "SELECT optGrpID, optGrpWorkingName FROM optiongroup ORDER BY optGrpWorkingName";
    397. 

  397. 		$nalloptions=0;
    398. 

  398. 		$result = mysql_query($sSQL) or print(mysql_error());
    399. 

  399. 		while($rs = mysql_fetch_row($result))
    400. 

  400. 			$alloptions[$nalloptions++] = $rs;
    401. 

  401. 		mysql_free_result($result);		
    402. 

  402. 		if(@$_POST["act"]=="modify" || @$_POST["act"]=="clone"){
    403. 

  403. 			$sSQL = "SELECT poID, poOptionGroup FROM prodoptions WHERE poProdID='" . trim(@$_POST["id"]) . "' ORDER BY poID";
    404. 

  404. 			$nprodoptions=0;
    405. 

  405. 			$result = mysql_query($sSQL) or print(mysql_error());
    406. 

  406. 			while($rs = mysql_fetch_row($result))
    407. 

  407. 				$prodoptions[$nprodoptions++] = $rs;
    408. 

  408. 			// set Options selected items
    409. 

  409. 			$sSQL = "SELECT pSetOptions FROM products WHERE pID='" . trim(@$_POST["id"]) . "'";
    410. 

  410. 			$setoptions=0;
    411. 

  411. 			$result = mysql_query($sSQL) or print(mysql_error());
    412. 

  412. 			$rs = mysql_fetch_row($result);				
    413. 

  413. 				if(!empty($rs[0])) {
    414. 

  414. 					$setoptions = explode(',',$rs[0]);
    415. 

  415. 					$nsetoptions = count($setoptions);
    416. 

  416. 				} else $nsetoptions = 0;
    417. 

  417. 			//echo '$nsetoptions='.$nsetoptions;			
    418. 

  418. 			$sSQL = "SELECT pSection FROM multisections WHERE pID='" . trim(@$_POST["id"]) . "'";
    419. 

  419. 			$result = mysql_query($sSQL) or print(mysql_error());
    420. 

  420. 			while($rs = mysql_fetch_row($result))
    421. 

  421. 				$prodsections[$nprodsections++] = $rs;
    422. 

  422. 		}
    423. 

  423. 		$sSQL = "SELECT sectionID, sectionWorkingName, sectionDisabled FROM sections ORDER BY sectionWorkingName";
    424. 

  424. 		$result = mysql_query($sSQL) or print(mysql_error());
    425. 

  425. 		while($rs = mysql_fetch_assoc($result))
    426. 

  426. 			$allsections[$nallsections++] = $rs;
    427. 

  427. 		mysql_free_result($result);
    428. 

  428. 		$sSQL = "SELECT dsID,dsName FROM dropshipper ORDER BY dsName";
    429. 

  429. 		$result = mysql_query($sSQL) or print(mysql_error());
    430. 

  430. 		while($rs = mysql_fetch_assoc($result))
    431. 

  431. 			$alldropship[$nalldropship++] = $rs;
    432. 

  432. 		mysql_free_result($result);
    433. 

  433. 	}
    434. 

  434. }
    435. 

  435. if($dorefresh){
    436. 

  436. 	print '<meta http-equiv="refresh" content="2; url=/admin/prods.php';
    437. 

  437. 	if(trim(@$_POST["ts"]) != "")
    438. 

  438. 		print "?ts=" . trim(@$_POST["ts"]);
    439. 

  439. 	elseif(trim(@$_POST["tt"]) != "")
    440. 

  440. 		print "?tt=" . trim(@$_POST["tt"]);
    441. 

  441. 	print '">';
    442. 

  442. }
    443. 

  443. ?>
    444. 

  444. <script language="JavaScript" type="text/javascript">
    445. 

  445. <!--
    446. 

  446. var ie=(document.all != (void 0));
    447. 

  447. var ns6=(document.getElementById&&!document.all);
    448. 

  448. <?php if(@$_POST["act"]=="addnew" || @$_POST["act"]=="modify" || @$_POST["act"]=="clone"){ ?>
    449. 

  449. function checkastring(thestr,validchars){
    450. 

  450.   for (i=0; i < thestr.length; i++){
    451. 

  451.     ch = thestr.charAt(i);
    452. 

  452.     for (j = 0;  j < validchars.length;  j++)
    453. 

  453.       if (ch == validchars.charAt(j))
    454. 

  454.         break;
    455. 

  455.     if (j == validchars.length)
    456. 

  456. 	  return(false);
    457. 

  457.   }
    458. 

  458.   return(true);
    459. 

  459. }
    460. 

  460. function formvalidator(theForm)
    461. 

  461. {
    462. 

  462.   checkUPC('pUPC');  
    463. 

  463.   //alert($('upcOK').value);
    464. 

  464.   if($('upcOK').value=='false') {
    465. 

  465. 	//alert('in');
    466. 

  466. 	return (false);
    467. 

  467.   }
    468. 

  468.   if (theForm.newid.value == ""){
    469. 

  469.     alert("<?php print $yyPlsEntr?> \"<?php print $yyPrRef?>\".");
    470. 

  470.     theForm.newid.focus();
    471. 

  471.     return (false);
    472. 

  472.   }
    473. 

  473.   if (theForm.pSection.options[theForm.pSection.selectedIndex].value == ""){
    474. 

  474.     alert("<?php print $yyPlsSel?> \"<?php print $yySection?>\".");
    475. 

  475.     theForm.pSection.focus();
    476. 

  476.     return (false);
    477. 

  477.   }
    478. 

  478.   if (theForm.pName.value == ""){
    479. 

  479.     alert("<?php print $yyPlsEntr?> \"<?php print $yyPrNam?>\".");
    480. 

  480.     theForm.pName.focus();
    481. 

  481.     return (false);
    482. 

  482.   }
    483. 

  483. <?php	for($index=2; $index <= $adminlanguages+1; $index++){
    484. 

  484. 			if(($adminlangsettings & 1)==1){ ?>
    485. 

  485.   if (theForm.pName<?php print $index?>.value == ""){
    486. 

  486.     alert("<?php print $yyPlsEntr?> \"<?php print $yyPrNam . " " . $index?>\".");
    487. 

  487.     theForm.pName<?php print $index?>.focus();
    488. 

  488.     return (false);
    489. 

  489.   }
    490. 

  490. <?php		}
    491. 

  491. 		} ?>
    492. 

  492.   if (theForm.pPrice.value == ""){
    493. 

  493.     alert("<?php print $yyPlsEntr?> \"<?php print $yyPrPri?>\".");
    494. 

  494.     theForm.pPrice.focus();
    495. 

  495.     return (false);
    496. 

  496.   }
    497. 

  497.   var checkOK = "'\" ";
    498. 

  498.   var checkStr = theForm.newid.value;
    499. 

  499.   var allValid = true;
    500. 

  500.   for (i = 0;  i < checkStr.length;  i++){
    501. 

  501.     ch = checkStr.charAt(i);
    502. 

  502.     for (j = 0;  j < checkOK.length;  j++)
    503. 

  503.       if (ch == checkOK.charAt(j)){
    504. 

  504. 	    allValid = false;
    505. 

  505.         break;
    506. 

  506. 	  }
    507. 

  507.   }
    508. 

  508.   if (!allValid){
    509. 

  509.     alert("<?php print $yyQuoSpa?> \"<?php print $yyPrRef?>\".");
    510. 

  510.     theForm.newid.focus();
    511. 

  511.     return (false);
    512. 

  512.   }
    513. 

  513.   if (!checkastring(theForm.pPrice.value,"0123456789.")){
    514. 

  514.     alert("<?php print $yyOnlyDec?> \"<?php print $yyPrPri?>\".");
    515. 

  515.     theForm.pPrice.focus();
    516. 

  516.     return (false);
    517. 

  517.   }
    518. 

  518.   if (!checkastring(theForm.pWholesalePrice.value,"0123456789.")){
    519. 

  519.     alert("<?php print $yyOnlyDec?> \"<?php print $yyWhoPri?>\".");
    520. 

  520.     theForm.pWholesalePrice.focus();
    521. 

  521.     return (false);
    522. 

  522.   }
    523. 

  523.   if (!checkastring(theForm.pListPrice.value,"0123456789.")){
    524. 

  524.     alert("<?php print $yyOnlyDec?> \"<?php print $yyListPr?>\".");
    525. 

  525.     theForm.pListPrice.focus();
    526. 

  526.     return (false);
    527. 

  527.   }
    528. 

  528. <?php	if(@$productdimensions==TRUE){ ?>
    529. 

  529.   if (theForm.elements['pExemptions[]'].options[2].selected!=true){
    530. 

  530.   if (theForm.plen.value == ""){
    531. 

  531. 	alert("<?php print $yyPlsEntr?> \"<?php print $yyDims?>\".");
    532. 

  532. 	theForm.plen.focus();
    533. 

  533. 	return(false);
    534. 

  534.   }
    535. 

  535.   if (theForm.pwid.value == ""){
    536. 

  536. 	alert("<?php print $yyPlsEntr?> \"<?php print $yyDims?>\".");
    537. 

  537. 	theForm.pwid.focus();
    538. 

  538. 	return(false);
    539. 

  539.   }
    540. 

  540.   if (theForm.phei.value == ""){
    541. 

  541. 	alert("<?php print $yyPlsEntr?> \"<?php print $yyDims?>\".");
    542. 

  542. 	theForm.phei.focus();
    543. 

  543. 	return(false);
    544. 

  544.   }
    545. 

  545.   }
    546. 

  546.   var checkOK = "0123456789.";
    547. 

  547.   if (!checkastring(theForm.plen.value,checkOK)){
    548. 

  548. 	alert("<?php print $yyOnlyDec?> \"<?php print $yyDims?>\".");
    549. 

  549. 	theForm.plen.focus();
    550. 

  550. 	return(false);
    551. 

  551.   }
    552. 

  552.   if (!checkastring(theForm.pwid.value,checkOK)){
    553. 

  553. 	alert("<?php print $yyOnlyDec?> \"<?php print $yyDims?>\".");
    554. 

  554. 	theForm.pwid.focus();
    555. 

  555. 	return(false);
    556. 

  556.   }
    557. 

  557.   if (!checkastring(theForm.phei.value,checkOK)){
    558. 

  558. 	alert("<?php print $yyOnlyDec?> \"<?php print $yyDims?>\".");
    559. 

  559. 	theForm.phei.focus();
    560. 

  560. 	return(false);
    561. 

  561.   }
    562. 

  562. <?php	}
    563. 

  563. 		if(($shipType > 0 && $shipType < 5) || $shipType==6){ ?>
    564. 

  564.   var checkOK = "0123456789.";
    565. 

  565.   if (!checkastring(theForm.pShipping.value,checkOK)){
    566. 

  566. <?php		if($shipType==1){ ?>
    567. 

  567.     alert("<?php print $yyOnlyDec?> \"<?php print $yyShip . ": " . $yyFirShi?>\".");
    568. 

  568. <?php		}else{ ?>
    569. 

  569.     alert("<?php print $yyOnlyDec?> \"<?php print $yyPrWght?>\".");
    570. 

  570. <?php		} ?>
    571. 

  571.     theForm.pShipping.focus();
    572. 

  572.     return (false);
    573. 

  573.   }
    574. 

  574. <?php	} ?>
    575. 

  575. <?php	if($shipType==1){ ?>
    576. 

  576.   if (!checkastring(theForm.pShipping2.value,"0123456789.")){
    577. 

  577.     alert("<?php print $yyOnlyDec?> \"<?php print $yyShip . ": " . $yySubShi?>\".");
    578. 

  578.     theForm.pShipping2.focus();
    579. 

  579.     return (false);
    580. 

  580.   }
    581. 

  581. <?php	} ?>
    582. 

  582. <?php	if($stockManage != 0){ ?>
    583. 

  583.   if (!(theForm.stockOptions.selectedIndex==1) && theForm.inStock.value == ""){
    584. 

  584.     alert("<?php print $yyPlsEntr?> \"<?php print $yyInStk?>\".");
    585. 

  585.     theForm.inStock.focus();
    586. 

  586.     return (false);
    587. 

  587.   }
    588. 

  588.   if (!(theForm.stockOptions.selectedIndex==1) && !checkastring(theForm.inStock.value,"0123456789")){
    589. 

  589.     alert("<?php print $yyOnlyNum?> \"<?php print $yyInStk?>\".");
    590. 

  590.     theForm.inStock.focus();
    591. 

  591.     return (false);
    592. 

  592.   }
    593. 

  593.   if(theForm.stockOptions.selectedIndex==1 && theForm.pNumOptions.selectedIndex==0){
    594. 

  594.     alert("<?php print $yyStkWrn?>");
    595. 

  595.     theForm.stockOptions.focus();
    596. 

  596.     return (false);
    597. 

  597.   }
    598. 

  598. <?php	} ?>
    599. 

  599. <?php	if(@$perproducttaxrate==TRUE){ ?>
    600. 

  600.   if (theForm.pTax.value == ""){
    601. 

  601. 	alert("<?php print $yyPlsEntr?> \"<?php print $yyTax?>\".");
    602. 

  602. 	theForm.pTax.focus();
    603. 

  603. 	return(false);
    604. 

  604.   }
    605. 

  605.   if (!checkastring(theForm.pTax.value,"0123456789.")){
    606. 

  606.     alert("<?php print $yyOnlyDec?> \"<?php print $yyTax?>\".");
    607. 

  607.     theForm.pTax.focus();
    608. 

  608.     return (false);
    609. 

  609.   }
    610. 

  610. <?php	} ?>
    611. 

  611.   return (true);
    612. 

  612. }
    613. 

  613. <?php } ?>
    614. 

  614. var prodOptGrpArr = new Array();
    615. 

  615. var prodSectGrpArr = new Array();
    616. 

  616. var prodOptGrpSet = new Array();
    617. 

  617. <?php
    618. 

  618. $rowcounter=0;
    619. 

  619. for($rowcounter=0;$rowcounter < $nprodoptions;$rowcounter++) 
    620. 

  620. 	print "prodOptGrpArr[" . $rowcounter . "]=" . $prodoptions[$rowcounter][1] . ";\r\n";
    621. 

  621. print "for(ii=" . $rowcounter . ";ii<" . maxprodopts . ";ii++) prodOptGrpArr[ii]=0;\r\n";
    622. 

  622. for($rowcounter=0;$rowcounter < $nsetoptions;$rowcounter++)	
    623. 

  623. 	print "prodOptGrpSet[" . $rowcounter . "]=" . $setoptions[$rowcounter] . ";\r\n";
    624. 

  624. print "for(ii=" . $rowcounter . ";ii<" . maxprodopts . ";ii++) prodOptGrpSet[ii]=0;\r\n";
    625. 

  625. for($rowcounter=0;$rowcounter < $nprodsections;$rowcounter++)
    626. 

  626. 	print "prodSectGrpArr[" . $rowcounter . "]=" . $prodsections[$rowcounter][0] . ";\r\n";
    627. 

  627. print "for(ii=" . $rowcounter . ";ii<" . $maxprodsects . ";ii++) prodSectGrpArr[ii]=0;\r\n";
    628. 

  628. ?>
    629. 

  629. function update_opts(index){
    630. 

  630. 	var thisOption;
    631. 

  631. 	if(ns6)
    632. 

  632. 		thisOption = document.getElementById('pOption'+index);
    633. 

  633. 	else
    634. 

  634. 		thisOption = eval('document.forms.mainform.pOption'+index);
    635. 

  635. 	prodOptGrpArr[index] = thisOption.options[thisOption.selectedIndex].value;
    636. 

  636. }
    637. 

  637. function update_sects(index){
    638. 

  638. 	var thisSection;
    639. 

  639. 	if(ns6)
    640. 

  640. 		thisSection = document.getElementById('pSection'+index);
    641. 

  641. 	else
    642. 

  642. 		thisSection = eval('document.forms.mainform.pSection'+index);
    643. 

  643. 	prodSectGrpArr[index] = thisSection.options[thisSection.selectedIndex].value;
    644. 

  644. }
    645. 

  645. function setprodoptions(){
    646. 

  646. 	var setoptions =$('setoptions').checked;
    647. 

  647. 	var noOpts = document.forms.mainform.pNumOptions.selectedIndex;
    648. 

  648. 	var theElm;
    649. 

  649. 	var theHTMLHead,theHTML="";
    650. 

  650. 	var index=0;
    651. 

  651. 	if(ns6)
    652. 

  652. 		theElm = document.getElementById('prodoptions');
    653. 

  653. 	else
    654. 

  654. 		theElm = document.all.prodoptions;
    655. 

  655. 

  656. 	theHTMLHead = '<table width="100%" border="0" cellspacing="0" cellpadding="3">';
    657. 

  657. 	theHTML = theHTML + '<select size="1" id="pOptionGGREPLACEMExx" name="pOptionGGREPLACEMExx" onChange="update_opts(GGREPLACEMExx);if(setoptions) {loadOptions(this.value,GGREPLACEMExx,0)};"><option value="0"><?php print $yyNone?></option>';
    658. 

  658. 	<?php
    659. 

  659. 		for($rowcounter=0;$rowcounter < $nalloptions;$rowcounter++)
    660. 

  660. 			print "theHTML = theHTML +'<option value=\"" . $alloptions[$rowcounter][0] . "\">" . str_replace("'","\'",$alloptions[$rowcounter][1]) . "</option>';\n";
    661. 

  661. 	?>
    662. 

  662. 	theHTML = theHTML + '</select>';
    663. 

  663. 	if(setoptions) {
    664. 

  664. 		theHTML = theHTML + '<span id="div_option_setGGREPLACEMExx"></span><span id="div_option_set_workingGGREPLACEMExx" style="display: none;"><img src="/lib/images/indicator.gif" width="16" /></span>';
    665. 

  665. 	}
    666. 

  666. 	for (index=0;index<noOpts;index++) {
    667. 

  667. 		if(index % 2 == 0) theHTMLHead = theHTMLHead + '<tr>';
    668. 

  668. 		theHTMLHead = theHTMLHead + '<td width="15%" align="right"><?php print $yyPrdOpt?> '+(index+1)+':</td><td width="35%">'+theHTML.replace(/GGREPLACEMExx/g,index)+'</td>';
    669. 

  669. 		if(index % 2 != 0) theHTMLHead = theHTMLHead + '</tr>';
    670. 

  670. 	}
    671. 

  671. 	if(index % 2 != 0) theHTMLHead = theHTMLHead + '<td width="50%" colspan="2">&nbsp;</td></tr>';
    672. 

  672. 

  673. 	theHTMLHead = theHTMLHead + '</table>';
    674. 

  674. 	theElm.innerHTML=theHTMLHead;
    675. 

  675. 	for (index=0;index<noOpts;index++) {
    676. 

  676. 		var thisOption;
    677. 

  677. 		if(ns6)
    678. 

  678. 			thisOption = document.getElementById('pOption'+index);
    679. 

  679. 		else
    680. 

  680. 			thisOption = eval('document.forms.mainform.pOption'+index);
    681. 

  681. 		for (index2=0;index2<thisOption.length;index2++) {
    682. 

  682. 			if (thisOption[index2].value==prodOptGrpArr[index]) {
    683. 

  683. 				thisOption.selectedIndex=index2;
    684. 

  684. 				thisOption.options[index2].selected = true;				
    685. 

  685. 			}
    686. 

  686. 			else
    687. 

  687. 				thisOption.options[index2].selected = false;
    688. 

  688. 		}
    689. 

  689. 		if(prodOptGrpSet[index]!=0)
    690. 

  690. 		loadOptions(prodOptGrpArr[index],index,prodOptGrpSet[index]);		
    691. 

  691. 	}
    692. 

  692. }
    693. 

  693. function setprodsections(){
    694. 

  694. 	var noSects = document.forms.mainform.pNumSections.selectedIndex;
    695. 

  695. 	var theElm;
    696. 

  696. 	var theHTMLHead,theHTML="";
    697. 

  697. 	var index=0;
    698. 

  698. 	if(ns6)
    699. 

  699. 		theElm = document.getElementById('prodsections');
    700. 

  700. 	else
    701. 

  701. 		theElm = document.all.prodsections;
    702. 

  702. 

  703. 	theHTMLHead = '<table width="100%" border="0" cellspacing="0" cellpadding="3">';
    704. 

  704. 	theHTML = theHTML + '<select size="1" id="pSectionGGREPLACEMExx" name="pSectionGGREPLACEMExx" onChange="update_sects(GGREPLACEMExx);"><option value="0">None</option>';
    705. 

  705. 	<?php
    706. 

  706. 		for($rowcounter=0;$rowcounter < $nallsections;$rowcounter++)
    707. 

  707. 			print "theHTML = theHTML +'<option value=\"" . $allsections[$rowcounter]["sectionID"] . "\">" . str_replace("'","\'",$allsections[$rowcounter]["sectionWorkingName"]) . "</option>';\n";
    708. 

  708. 	?>
    709. 

  709. 	theHTML = theHTML + '</select>';
    710. 

  710. 

  711. 	for (index=0;index<noSects;index++) {
    712. 

  712. 		if(index % 2 == 0) theHTMLHead = theHTMLHead + '<tr>';
    713. 

  713. 		theHTMLHead = theHTMLHead + '<td width="25%" align="right">Prod. Section '+(index+1)+':</td><td width="25%">'+theHTML.replace(/GGREPLACEMExx/g,index)+'</td>';
    714. 

  714. 		if(index % 2 != 0) theHTMLHead = theHTMLHead + '</tr>';
    715. 

  715. 	}
    716. 

  716. 	if(index % 2 != 0) theHTMLHead = theHTMLHead + '<td width="50%" colspan="2">&nbsp;</td></tr>';
    717. 

  717. 

  718. 	theHTMLHead = theHTMLHead + '</table>';
    719. 

  719. 	theElm.innerHTML=theHTMLHead;
    720. 

  720. 	for (index=0;index<noSects;index++) {
    721. 

  721. 		var thisSection;
    722. 

  722. 		if(ns6)
    723. 

  723. 			thisSection = document.getElementById('pSection'+index);
    724. 

  724. 		else
    725. 

  725. 			thisSection = eval('document.forms.mainform.pSection'+index);
    726. 

  726. 		for (index2=0;index2<thisSection.length;index2++) {
    727. 

  727. 			if (thisSection[index2].value==prodSectGrpArr[index]) {
    728. 

  728. 				thisSection.selectedIndex=index2;
    729. 

  729. 				thisSection.options[index2].selected = true;
    730. 

  730. 			}
    731. 

  731. 			else
    732. 

  732. 				thisSection.options[index2].selected = false;
    733. 

  733. 		}
    734. 

  734. 	}
    735. 

  735. }
    736. 

  736. function setstocktype(){
    737. 

  737. var si = document.forms.mainform.stockOptions.selectedIndex;
    738. 

  738. document.forms.mainform.inStock.disabled=(si==1);
    739. 

  739. }
    740. 

  740. //-->
    741. 

  741. </script>
    742. 

  742. <?php
    743. 

  743. function show_info(){
    744. 

  744. 	global $yyPrEx1, $yyPrEx2, $yyDspOrd, $yyDspImg;
    745. 

  745. ?>
    746. 

  746. 		<p><ul><li><strong>Reference:</strong> this is the product ID and must be unique. ( ex. A?? - nano, C?? - video and classic. CC is the same as C but indicates that is must have a shim sent with it. Go to packing slip products to add the trigger product that will ad the shim to the packing slip.)</li>
    747. 

  747.           <li><strong>Product Name:</strong> must be descriptive but short as possible. What the customer sees in the cart.</li>
    748. 

  748.           <li><strong>UPC:</strong> the unique number assigned to this product. Use as the barcode and is all numbers.</li>
    749. 

  749.           <li><strong>Bin:</strong> the location where the product is located.</li>
    750. 

  750.           <li><strong>In Stock/By Options:</strong> In Stock - is used to subtract inventory if the product does not have options. By Options - used when the product has one or more options. When selected the inventory will be subtracted from the options not this product.</li>
    751. 

  751. 		  <li><strong>Display:</strong> <?php print $yyDspOrd?></li>
    752. 

  752.           <li><strong>Display to Etailer:</strong> used to limit which products are displayed to etailers through the API.</li>
    753. 

  753. 		  <li><strong>Image/ Large Image:</strong> You can add more than one image that will display on the prod details page only. The first image url will be what is displayed on all other pages. For more than one image url you must put a comma and hit enter after each url. Small images - 140x140. Large images 350x300.</li>
    754. 

  754.           <li><strong>Download:</strong> if the product is downloaded, this is the download url of the software.</li>
    755. 

  755.           <li><strong>Description:</strong> Viewable on flash page. Short description.</li>
    756. 

  756.           <li><strong>Long Description:</strong> Viewable on the prod detail page. </li>
    757. 

  757.           <li><strong>Has Static Page:</strong> used for SEO. Checking the box and leave the text box blank will result in the URL being productID.php. Check the box and put the URL in the text box if the page has a different name than the productID. </li>
    758. 

  758.           <li><strong>Additional Sections: </strong>select multiple categories where the product will be displayed.</li>
    759. 

  759.           <li><strong>Section:</strong> the main section where the product will be displayed. Under product admin, when searching for products by sections, only products with this main section selected will display under the section.</li>
    760. 

  760.           <li><?php print $yyPrEx2?></li>
    761. 

  761.           <li><?php print $yyPrEx1?></li>
    762. 

  762.           <li><strong>Cost: </strong>actual cost to us for the product. (optional)</li>
    763. 

  763.           <li><strong>Customs Cost: </strong>the stated cost when shipping international for the customs form.
    764. 

  764.           <li><strong>Product Weight:</strong> measured in Kilograms. Must be accurate in order to get the final order weight correct. Used for shipping cost to customer and actual final shipping costs.</li> 
    765. 

  765. 		  <li><strong>Drop Shipper:</strong> used when a manufacturer ships the product instead of us. This will cause the order to split shipping can be tracked from two or more locations.
    766. 

  766.         </ul>
    767. 

  767. 		</p>
    768. 

  768. <?php
    769. 

  769. }
    770. 

  770. if(@$_POST["posted"]=="1" && (@$_POST["act"]=="modify" || @$_POST["act"]=="clone" || @$_POST["act"]=="addnew")){
    771. 

  771. 		if(@$_POST["act"]=="modify" || @$_POST["act"]=="clone"){
    772. 

  772. 			$doaddnew = FALSE;
    773. 

  773. 			$sSQL = "SELECT pId,pNUM,pName,pName2,pName3,pSection,pDescription,pDescription2,pDescription3,pImage,pPrice,pWholesalePrice,pPricing_group,pListPrice,pDisplay,pSell,pShipping,pShipping2,pLargeImage,pWeight,pLongDescription,pLongDescription2,pLongDescription3,pExemptions,pInStock,pDims,pTax,pDropship,pOrder,pSetOptions,isSet,pCatOnDetail,pUPC,pBin,pEDisplay,pTabName,pCost,pCustomsvalue,pURL,pTitleTag,pMetaDescription";
    774. 

  774. 			if(@$digidownloads==TRUE) $sSQL .= ",pDownload";
    775. 

  775. 			$sSQL .= " FROM products WHERE pId='" . mysql_real_escape_string(unstripslashes(@$_POST["id"])) . "'";
    776. 

  776. 			$result = mysql_query($sSQL) or print(mysql_error());
    777. 

  777. 			$alldata = mysql_fetch_assoc($result);
    778. 

  778. 			$pId = $alldata["pId"];
    779. 

  779. 			$pNUM = $alldata['pNUM'];
    780. 

  780. 			$pName = $alldata["pName"];
    781. 

  781. 			for($index=2; $index <= $adminlanguages+1; $index++){
    782. 

  782. 				$pNames[$index] = $alldata["pName" . $index];
    783. 

  783. 				$pDescriptions[$index] = $alldata["pDescription" . $index];
    784. 

  784. 				$pLongDescriptions[$index] = $alldata["pLongDescription" . $index];
    785. 

  785. 			}
    786. 

  786. 			$pSection = $alldata["pSection"];
    787. 

  787. 			$pDescription = $alldata["pDescription"];
    788. 

  788. 			$pDescription2 = $alldata['pDescription2'];
    789. 

  789. 			$pDescription3 = $alldata['pDescription3'];
    790. 

  790. 			$pImage = $alldata["pImage"];
    791. 

  791. 			$pPrice = $alldata["pPrice"];
    792. 

  792. 			$pCost = $alldata["pCost"];
    793. 

  793. 			$pCustomsvalue = $alldata["pCustomsvalue"];
    794. 

  794. 			$pWholesalePrice = $alldata["pWholesalePrice"];
    795. 

  795. 			$pPricing_group = $alldata["pPricing_group"];
    796. 

  796. 			$pListPrice = $alldata["pListPrice"];
    797. 

  797. 			$pDisplay = $alldata["pDisplay"];
    798. 

  798. 			$pEDisplay = $alldata["pEDisplay"];
    799. 

  799. 			$pTabName = $alldata["pTabName"];
    800. 

  800. 			$pSell = $alldata["pSell"];
    801. 

  801. 			$pURL = $alldata["pURL"];
    802. 

  802. 			$pShipping = $alldata["pShipping"];
    803. 

  803. 			$pShipping2 = $alldata["pShipping2"];
    804. 

  804. 			$pLargeImage = $alldata["pLargeImage"];
    805. 

  805. 			$pWeight = $alldata["pWeight"];
    806. 

  806. 			$pLongDescription = $alldata["pLongDescription"];
    807. 

  807. 			$pExemptions = $alldata["pExemptions"];
    808. 

  808. 			$pInStock = $alldata["pInStock"];
    809. 

  809. 			$pDims = $alldata["pDims"];
    810. 

  810. 			$pTax = $alldata["pTax"];
    811. 

  811. 			$pDropship = $alldata["pDropship"];
    812. 

  812. 			$pOrder = $alldata["pOrder"];
    813. 

  813. 			$pSetOptions = $alldata["pSetOptions"];
    814. 

  814. 			$completeSet= $alldata["isSet"];
    815. 

  815. 			$pCatOnDetail=$alldata["pCatOnDetail"];
    816. 

  816. 			$pUPC = $alldata['pUPC'];
    817. 

  817. 			$pBin = $alldata['pBin'];
    818. 

  818. 			$pTitleTag = $alldata['pTitleTag'];
    819. 

  819. 			$pMetaDescription = $alldata['pMetaDescription'];
    820. 

  820. 			if(@$digidownloads==TRUE) $pDownload = $alldata["pDownload"];
    821. 

  821. 		}else{
    822. 

  822. 			$doaddnew = TRUE;
    823. 

  823. 			$pId = "";
    824. 

  824. 			$pName = "";
    825. 

  825. 			for($index=2; $index <= $adminlanguages+1; $index++){
    826. 

  826. 				$pNames[$index] = "";
    827. 

  827. 				$pDescriptions[$index] = "";
    828. 

  828. 				$pLongDescriptions[$index] = "";
    829. 

  829. 			}
    830. 

  830. 			if(trim(@$_POST["ts"]) != "") $pSection=(int)trim(@$_POST["ts"]); else $pSection = 0;
    831. 

  831. 			$pDescription = "";
    832. 

  832. 			$pDescription2 = '';
    833. 

  833. 			$pDescription3 = '';
    834. 

  834. 			$pImage = "prodimages/";
    835. 

  835. 			$pPrice = "";
    836. 

  836. 			$pWholesalePrice = "";
    837. 

  837. 			$pPricing_group = 1;
    838. 

  838. 			$pListPrice = 0;
    839. 

  839. 			$pDisplay = 1;
    840. 

  840. 			$pEDisplay = 1;
    841. 

  841. 			$pTabName="";
    842. 

  842. 			$pSell = 1;
    843. 

  843. 			$pURL="";
    844. 

  844. 			$pShipping = "";
    845. 

  845. 			$pShipping2 = "";
    846. 

  846. 			$pLargeImage = "prodimages/";
    847. 

  847. 			$pWeight = "";
    848. 

  848. 			$pLongDescription = "";
    849. 

  849. 			$pExemptions = 0;
    850. 

  850. 			$pInStock = "";
    851. 

  851. 			$pDims = "";
    852. 

  852. 			$pTax = "";
    853. 

  853. 			$pDropship = 0;
    854. 

  854. 			$pDownload = "";
    855. 

  855. 			$pOrder = 100;
    856. 

  856. 			$pCatOnDetail="";
    857. 

  857. 			$pTitleTag = '';
    858. 

  858. 			$pMetaDescription = '';
    859. 

  859. 		}
    860. 

  860. ?>
    861. 

  861. 	<form name="mainform" method="post" action="/admin/prods.php" onsubmit="return formvalidator(this)">
    862. 

  862.       <table border="0" cellspacing="0" cellpadding="0" width="100%" bgcolor="" align="center">
    863. 

  863. 		<tr>
    864. 

  864. 		  <td width="100%">
    865. 

  865. 			<input type="hidden" name="posted" value="1" />
    866. 

  866. 			<?php if(@$_POST["act"]=="modify"){ ?>
    867. 

  867. 			<input type="hidden" name="act" value="domodify" />
    868. 

  868. 			<input type="hidden" id="id" name="id" value="<?php print str_replace('"',"&quot;",$pId)?>" />
    869. 

  869. 			<?php }else{ ?>
    870. 

  870. 			<input type="hidden" name="act" value="doaddnew" />
    871. 

  871. 			<?php } ?>
    872. 

  872. 			<input type="hidden" name="tt" value="<?php print @$_POST["tt"];?>" />
    873. 

  873. 			<input type="hidden" name="ts" value="<?php print @$_POST["ts"];?>" />
    874. 

  874.             <table width="100%" border="0" cellspacing="0" cellpadding="3" bgcolor="">
    875. 

  875. 			  <tr> 
    876. 

  876.                 <td colspan="4" align="center"><strong><?php
    877. 

  877. 					if(@$_POST["act"]=="modify")
    878. 

  878. 						print $yyYouMod . " &quot;" . $pName . "&quot;";
    879. 

  879. 					elseif(@$_POST["act"]=="addnew")
    880. 

  880. 						print $yyPrUpd;
    881. 

  881. 					else
    882. 

  882. 						print $yyYouCln . " &quot;" . $pName . "&quot;";
    883. 

  883. 				?></strong><br />&nbsp;</td>
    884. 

  884. 			  </tr>
    885. 

  885. 			  <tr>
    886. 

  886. 			    <td width="14%" align="right">
    887. 

  887. 					<font color="#FF0000">*</font><?php print $yyPrRef?>:
    888. 

  888. 				</td>
    889. 

  889. 				<td width="36%">
    890. 

  890. 					<input type="text" name="newid" size="15" value="<?php print str_replace('"',"&quot;",$pId)?>" /> <a href="#info">?</a>
    891. 

  891. 				</td>
    892. 

  892. 			    <td width="5%" align="right">
    893. 

  893. 					<font color="#FF0000">*</font><?php print $yySection?>:
    894. 

  894. 				</td>
    895. 

  895. 				<td width="15%">
    896. 

  896. 					<select size="1" name="pSection">
    897. 

  897. 						<option value=""><?php print $yySelect?></option><?php
    898. 

  898. 						for($index=0;$index<$nallsections;$index++){
    899. 

  899. 							print "<option value='" . $allsections[$index]["sectionID"] . "'";
    900. 

  900. 							if($allsections[$index]["sectionID"]==$pSection) print " selected";
    901. 

  901. 							print ">" . $allsections[$index]["sectionWorkingName"] . "</option>\n";
    902. 

  902. 						} ?>
    903. 

  903. 					</select>
    904. 

  904. 					<a href="#info">?</a>
    905. 

  905. 				</td>
    906. 

  906. 			  </tr>
    907. 

  907. 			  <tr>
    908. 

  908. 			  		<td width="14%" align="right">Alt Prod ID:</td>
    909. 

  909. 					<td width="36%">
    910. 

  910. 						<input type="text" name="altprodid" size="15" value="<?php print str_replace('"',"&quot;",$pNUM)?>" /> <a href="#info">?</a>
    911. 

  911. 					</td>
    912. 

  912. 					<td colspan="2">&nbsp;</td>
    913. 

  913. 			  </tr>
    914. 

  914. 			  <tr>
    915. 

  915. 			    <td align="right"><font color="#FF0000">*</font><?php print $yyPrNam?>:</td>
    916. 

  916. 				<td><input type="text" name="pName" size="25" value="<?php print str_replace('"',"&quot;",$pName)?>" /> <a href="#info">?</a></td>
    917. 

  917. 			    <td align="right"><font color="#FF0000">*</font><?php print $yyPrPri?>:</td>
    918. 

  918. 				<td><input type="text" name="pPrice" id="pPrice" size="15" value="<?php print $pPrice?>" />
    919. 

  919. 			    <a href="#info">?</a></td>
    920. 

  920. 			  </tr>
    921. 

  921. 			  <tr>
    922. 

  922. 			  	<td style="text-align: right;">UPC #:</td>
    923. 

  923. 				<td><input type="text" id="pUPC" name="pUPC" size="15" value="<?=$pUPC?>" onblur="checkUPC('pUPC')"  />
    924. 

  924. 			    <input name="upcOK" type="hidden" id="upcOK" />
    925. 

  925. 			    <a href="#info">?</a></td>
    926. 

  926. 				<td>&nbsp;</td>
    927. 

  927. 				<td>&nbsp;</td>
    928. 

  928. 			  </tr>
    929. 

  929. 			  <tr>
    930. 

  930. 			    <td style="text-align: right;">BIN #:</td>
    931. 

  931. 			    <td><input name="pBin" type="text" id="pBin" value="<?=$pBin?>" size="15" />
    932. 

  932. 		        <a href="#info">?</a></td>
    933. 

  933. 			    <td>&nbsp;</td>
    934. 

  934. 			    <td>&nbsp;</td>
    935. 

  935. 		      </tr>
    936. 

  936. <?php		for($index=2; $index <= $adminlanguages+1; $index++){
    937. 

  937. 				if(($adminlangsettings & 1)==1){
    938. 

  938. 			?><tr>
    939. 

  939. 			    <td align="right"><font color="#FF0000">*</font><?php print $yyPrNam . " " . $index?>:</td><td colspan="3"><input type="text" name="pName<?php print $index?>" size="25" value="<?php print str_replace('"','&quot;',$pNames[$index])?>" />
    940. 

  940. 			      <a href="#info">?</a></td>
    941. 

  941. 			  </tr><?php
    942. 

  942. 				}
    943. 

  943. 			} ?>
    944. 

  944. 			  <tr>
    945. 

  945. 			    <?php if($useStockManagement){ ?>
    946. 

  946. 				<td align="right">
    947. 

  947. 				<input type="hidden" name="pSell" value="<?php if(((int)$pSell & 1)==1) print "ON" ?>" />
    948. 

  948. 				<select name="stockOptions" size="1" onchange="setstocktype();">
    949. 

  949. 				<option value="0">&nbsp;&nbsp;&nbsp;<?php print $yyInStk?>:</option>
    950. 

  950. 				<option value="1"<?php if(((int)$pSell & 2)==2) print "selected" ?>><?php print $yyByOpt?>:</option></select>				</td><td><input type="text" name="inStock" size="10" value="<?php print $pInStock?>" />
    951. 

  951. 				  <a href="#info">?</a></td>
    952. 

  952. 				<?php }else{ ?>
    953. 

  953. 				<input type="hidden" name="stockOptions" value="<?php if(((int)$pSell & 2)==2) print "1" ?>" />
    954. 

  954. 				<td align="right"><?php print $yySellBut?>:</td><td><input type="checkbox" name="pSell" value="ON" <?php if(((int)$pSell & 1)==1) print "checked" ?> /></td>
    955. 

  955. 				<?php } ?>
    956. 

  956. 				<td width="10%" align="right">MSRP<?php //print $yyWhoPri?> <font size="1">(<a href="#info">info</a>)</font>:<br />
    957. 

  957. 			      Pricing Group: </td>
    958. 

  958. 				<td width="20%"><input type="text" name="pWholesalePrice" id="pWholesalePrice" size="10" value="<?php print $pWholesalePrice?>" />
    959. 

  959. 				  <select name="pPricing_group" id="pPricing_group" onchange="if($F('pPricing_group')==0) $('pWholesalePrice').value='<?php print $pPrice?>'; else $('pWholesalePrice').value='<?php print $pWholesalePrice?>';">
    960. 

  960. 				    <option value="0" <?php if ($pPricing_group=="0") {echo "selected=\"selected\"";} ?>>Full Price (0)</option>
    961. 

  961. 					<option value="1" <?php if ($pPricing_group=="1") {echo "selected=\"selected\"";} ?>>Sets (1)</option>
    962. 

  962. 					<option value="2" <?php if ($pPricing_group=="2") {echo "selected=\"selected\"";} ?>>Individual Items (2)</option>
    963. 

  963. 					<option value="3" <?php if ($pPricing_group=="3") {echo "selected=\"selected\"";} ?>>Shieldzone (3)</option>
    964. 

  964. 					<option value="4" <?php if ($pPricing_group=="4") {echo "selected=\"selected\"";} ?>>Skullcandy (4)</option>
    965. 

  965. 			      </select>
    966. 

  966. 				  <a href="#info">?</a></td>
    967. 

  967. 			  </tr>
    968. 

  968. 			  <tr>
    969. 

  969. 			    <td align="right">Display on ifrogz:</td><td><input type="checkbox" name="pDisplay" value="ON" <?php if((int)$pDisplay != 0) print "checked" ?> /> 
    970. 

  970. 			    Display Order: <input name="pOrder" type="text" id="pOrder" value="<?php print $pOrder?>" size="4" />
    971. 

  971. 			    <a href="#info">?</a></td>
    972. 

  972. 				<td align="right"><?php print $yyListPr?> <font size="1">(<a href="#info">info</a>)</font>:</td><td><input type="text" name="pListPrice" size="15" value="<?php if((double)$pListPrice<>0.0) print $pListPrice ?>" /> <a href="#info">?</a></td>
    973. 

  973. 			  </tr>
    974. 

  974. 			  <tr>
    975. 

  975. 			    <td align="right" valign="top">Display to Etailers: </td>
    976. 

  976. 			    <td><input name="pEDisplay" type="checkbox" id="pEDisplay" value="ON" <?php if((int)$pEDisplay != 0) print "checked" ?> />
    977. 

  977. 		        <a href="#info">?</a></td>
    978. 

  978. 			    <td align="right">Cost:</td>
    979. 

  979. 			    <td nowrap="nowrap"><input name="pCost" type="text" id="pCost" size="15" value="<?=$pCost?>" /> <label>
    980. 

  980. 			      <input name="cost_percent" type="text" id="cost_percent" size="2" value="40" />%
    981. 

  981. 			      <input type="button" name="cost_percent_calc" value="go" onclick="$('pCost').value=($F('cost_percent')/100)*$F('pPrice');" />
    982. 

  982. 		        <a href="#info">?</a></label></td>
    983. 

  983. 			    <td colspan="2" align="center" valign="top">&nbsp;</td>
    984. 

  984. 		      </tr>
    985. 

  985. 			  <tr>
    986. 

  986. 			    <td align="right" valign="top">Tab Name: </td>
    987. 

  987. 			    <td><input name="pTabName" type="text" id="pTabName" value="<?=$pTabName?>" />
    988. 

  988. 		        <a href="#info">?</a></td>
    989. 

  989. 			    <td align="right">Customs Cost: </td>
    990. 

  990. 			    <td><input name="pCustomsvalue" type="text" id="pCustomsvalue" size="15" value="<?=$pCustomsvalue?>" />
    991. 

  991. 			      <input name="cost_percent2" type="text" id="cost_percent2" size="2" value="40" />%
    992. 

  992. 					<input type="button" name="cost_percent_calc2" value="go" onclick="$('pCustomsvalue').value=($F('cost_percent2')/100)*$F('pPrice');" />
    993. 

  993. 				  <a href="#info">?</a></td>
    994. 

  994. 			    <td colspan="2" align="center" valign="top">&nbsp;</td>
    995. 

  995. 		      </tr>
    996. 

  996. 			  <tr>
    997. 

  997. 				<td align="right" valign="top"><?php print $yyImage?>:				</td>
    998. 

  998. 				<td><textarea name="pImage" id="pImage" cols="40" rows="4" ><?php print str_replace('"',"&quot;",$pImage)?></textarea>
    999. 

  999. 				<a href="javascript:void(0);" onclick="viewImage('pImage','pImageView');">View</a>
    1000. 

  1000. 			    <div style="position:relative; ">
    1001. 

  1001. 					<div id="pImageView" class="imageView" style="display:none;"></div>
    1002. 

  1002. 				</div>
    1003. 

  1003. 				<div style="font-size:10px; ">* For more than one image see below. <a href="#info">?</a></div></td>
    1004. 

  1004. 				<?php	if(@$productdimensions==TRUE){
    1005. 

  1005. 							$proddims = split("x", $pDims) ?>
    1006. 

  1006. 				<td align="right"><font color="#FF0000">*</font><?php print $yyDims?>:</td>
    1007. 

  1007. 				<td><input type="text" name="plen" size="4" value="<?php print @$proddims[0]?>" /> <strong>X</strong> 
    1008. 

  1008. 				<input type="text" name="pwid" size="4" value="<?php print @$proddims[1]?>" /> <strong>X</strong> 
    1009. 

  1009. 				<input type="text" name="phei" size="4" value="<?php print @$proddims[2]?>" /></td>
    1010. 

  1010. 				<?php	}else{ ?>
    1011. 

  1011. 			    <td colspan="2" align="center" valign="bottom"><strong><?php
    1012. 

  1012. 				if(($shipType > 0 && $shipType < 5) || $shipType==6)
    1013. 

  1013. 					print $yyShpInf;
    1014. 

  1014. 				else
    1015. 

  1015. 					print "&nbsp;"; ?></strong></td>
    1016. 

  1016. 				<?php	} ?>
    1017. 

  1017. 			  </tr>
    1018. 

  1018. 			  <tr>
    1019. 

  1019.                 <td align="right" valign="top"><?php print $yyLgeImg?>:</td>
    1020. 

  1020.                 <td align="left"><textarea name="pLargeImage" id="pLargeImage" cols="40" rows="4"><?php print str_replace('"',"&quot;",$pLargeImage)?></textarea>
    1021. 

  1021. 				<a href="javascript:void(0);" onclick="viewImage('pLargeImage','pLargeImageView');">View</a>
    1022. 

  1022. 			    <div style="position:relative; ">
    1023. 

  1023. 					<div id="pLargeImageView" class="imageView" style="display:none;"></div>
    1024. 

  1024. 				</div>
    1025. 

  1025. 				<div style="font-size:10px; ">* For more than one image see below. <a href="#info">?</a></div></td>
    1026. 

  1026.                 <td align="right" valign="top"><?php
    1027. 

  1027. 				if($shipType==1)
    1028. 

  1028. 					print $yyShip . ":<br />" . $yyFirShi;
    1029. 

  1029. 				elseif($shipType==2 || $shipType==3 || $shipType==4 || $shipType==6)
    1030. 

  1030. 					print $yyPrWght . ":";
    1031. 

  1031. 				else
    1032. 

  1032. 					print "&nbsp;";
    1033. 

  1033. 				  ?></td>
    1034. 

  1034.                 <td align="left" valign="top"><?php
    1035. 

  1035. 				if($shipType==1)
    1036. 

  1036. 					print "<input type=text name='pShipping' size='15' value='" . $pShipping . "' />";
    1037. 

  1037. 				elseif($shipType==2 || $shipType==3 || $shipType==4 || $shipType==6)
    1038. 

  1038. 					print "<input type=text name='pShipping' size='15' value='" . $pWeight . "' />";
    1039. 

  1039. 				else
    1040. 

  1040. 					print "&nbsp;"; ?></td>
    1041. 

  1041. 			  </tr>
    1042. 

  1042. 			  
    1043. 

  1043. 			<tr>
    1044. 

  1044. 				<td align="right" valign="top">Tech Specs:</td>
    1045. 

  1045. 				<td align="left"><textarea name="pDescription2" id="pDescription2" cols="40" rows="4"><?php print str_replace('"',"&quot;",$pDescription2)?></textarea></td>
    1046. 

  1046. 				<td align="right" valign="top">Video:</td>
    1047. 

  1047. 				<td align="left"><textarea name="pDescription3" id="pDescription3" cols="40" rows="4"><?php echo $pDescription3; ?></textarea></td>
    1048. 

  1048. 			</tr>
    1049. 

  1049. 			
    1050. 

  1050. 			  <tr>
    1051. 

  1051. 			<?php	if($simpleOptions){ ?>
    1052. 

  1052. 				<td colspan="2">&nbsp;</td>
    1053. 

  1053. 			<?php	}else{ ?>
    1054. 

  1054.                 <td align="right"><?php print $yyNumOpt?>:</td>
    1055. 

  1055.                 <td>
    1056. 

  1056. 				  <select size="1" name="pNumOptions" onchange="setprodoptions();">
    1057. 

  1057. 					<option value='0'><?php print $yyNone?></option>
    1058. 

  1058. 					<?php	for($rowcounter=1; $rowcounter <= maxprodopts; $rowcounter++)
    1059. 

  1059. 								print "<option value='" . $rowcounter . "'>" . $rowcounter . "</option>"; ?>
    1060. 

  1060. 				  </select> <?php print $yyCompleteSet?> <input name="completeset" type="checkbox" id="completeset" value="yes" <?php if ($completeSet=='yes') {echo "checked";} ?>> 
    1061. 

  1061. 				  <?php print $yySetOptions?> <input <?php if (!empty($pSetOptions)) {echo "checked";} ?> name="setoptions" id="setoptions" type="checkbox" value="yes" onchange="setprodoptions();">
    1062. 

  1062. 				  <a href="#info">?</a> </td>
    1063. 

  1063. 			<?php	} ?>
    1064. 

  1064. 				<td align="right"><?php
    1065. 

  1065. 				if($shipType==1)
    1066. 

  1066. 					print $yyShip . ":<br />" . $yySubShi;
    1067. 

  1067. 				else
    1068. 

  1068. 					print "&nbsp;"; ?></td>
    1069. 

  1069.                 <td align="left"><?php
    1070. 

  1070. 				if($shipType==1)
    1071. 

  1071. 					print "<input type=text name='pShipping2' size='15' value='" . (double)$pShipping2 . "' />";
    1072. 

  1072. 				else
    1073. 

  1073. 					print "&nbsp;"; ?></td>
    1074. 

  1074. 			  </tr>
    1075. 

  1075. <?php	if($simpleOptions){
    1076. 

  1076. 			for($index=0;$index < maxprodopts; $index++){
    1077. 

  1077. 				if(($index …
    1078.

Large files files are truncated, but you can click here to view the full file