PageRenderTime 38ms CodeModel.GetById 18ms RepoModel.GetById 0ms app.codeStats 1ms

/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
    

  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 % 2)==0) print "<tr>";
    1078. 

  1078. 				print '<td align="right">' . $yyPrdOpt . ' ' . ($index+1) . ':</td><td><select size="1" id="pOption' . $index . '" name="pOption' . $index . '"><option value="0">None</option>';
    1079. 

  1079. 				for($rowcounter=0;$rowcounter < $nalloptions;$rowcounter++){
    1080. 

  1080. 					print '<option value="' . $alloptions[$rowcounter][0] . '"';
    1081. 

  1081. 					if($index < $nprodoptions){
    1082. 

  1082. 						if($prodoptions[$index][1]==$alloptions[$rowcounter][0]) print " selected";
    1083. 

  1083. 					}
    1084. 

  1084. 					print ">" . $alloptions[$rowcounter][1] . "</option>";
    1085. 

  1085. 				}
    1086. 

  1086. 				print "</td>";
    1087. 

  1087. 				if(($index % 2) != 0) print "</tr>\n";
    1088. 

  1088. 			}
    1089. 

  1089. 			if(($index % 2)==0)
    1090. 

  1090. 				print "</tr>\n";
    1091. 

  1091. 			else
    1092. 

  1092. 				print "<td colspan=\"2\">&nbsp;</td></tr>\n";
    1093. 

  1093. 		}else{ ?>
    1094. 

  1094. 			</table>
    1095. 

  1095. 			<div name="prodoptions" id="prodoptions">
    1096. 

  1096. 			</div>
    1097. 

  1097. 			<table width="100%" border="0" cellspacing="0" cellpadding="3" bgcolor="">
    1098. 

  1098. <?php	}
    1099. 

  1099. 		if(@$digidownloads==TRUE){ ?>
    1100. 

  1100. 			  <tr>
    1101. 

  1101.                 <td width="14%" align="right"><?php print $yyDownl?>:</td>
    1102. 

  1102.                 <td colspan="4" align="left"><input type="text" size="60" name="pDownload" value="<?php print $pDownload?>" />
    1103. 

  1103.                 <a href="#info">?</a></td>
    1104. 

  1104. 			  </tr>
    1105. 

  1105. <?php	} ?>
    1106. 

  1106. 			  <tr> 
    1107. 

  1107.                 <td align="right"><?php print $yyDesc?>:</td>
    1108. 

  1108.                 <td colspan="2" valign="top"><textarea name="pDescription" cols="30" rows="6" wrap=virtual><?php print $pDescription?></textarea>
    1109. 

  1109.                 <a href="#info">?</a></td>
    1110. 

  1110. 				<td colspan="2" align="center"><?php print $yyDrSppr?>: <select name="pDropship" size="1">
    1111. 

  1111. 				  <option value="0"><?php print $yyNone?></option><?php
    1112. 

  1112. 						for($index=0;$index<$nalldropship;$index++){
    1113. 

  1113. 							print "<option value='" . $alldropship[$index]["dsID"] . "'";
    1114. 

  1114. 							if($alldropship[$index]["dsID"]==$pDropship) print " selected";
    1115. 

  1115. 							print ">" . $alldropship[$index]["dsName"] . "</option>\n";
    1116. 

  1116. 						} ?>
    1117. 

  1117. 				  </select>
    1118. 

  1118. 

  1119. 				  <a href="#info">?</a><br />
    1120. 

  1120. 				  <br />
    1121. 

  1121. 				<?php print $yyExemp?> <font size="1">&lt;Ctrl>+Click</font><br />
    1122. 

  1122. 					<select name="pExemptions[]" size="3" multiple>
    1123. 

  1123. 					<option value="1" <?php if(($pExemptions&1)==1) print "selected"?>><?php print $yyExStat?></option>
    1124. 

  1124. 					<option value="2" <?php if(($pExemptions&2)==2) print "selected"?>><?php print $yyExCoun?></option>
    1125. 

  1125. 					<option value="4" <?php if(($pExemptions&4)==4) print "selected"?>><?php print $yyExShip?></option>
    1126. 

  1126. 					</select>
    1127. 

  1127. 				  <a href="#info">?</a><br />
    1128. 

  1128. 				  <img src="/lib/images/misc/clearpixel.gif" width="20" height="3" alt="" />
    1129. 

  1129. <?php			if(@$perproducttaxrate==TRUE){ ?>
    1130. 

  1130. 					<br /><?php print $yyTax?>: <input type="text" style="text-align:right" size="6" name="pTax" value="<?php print $pTax?>" />%
    1131. 

  1131. <?php			} ?>				</td>
    1132. 

  1132. 			  </tr>
    1133. 

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

  1134. 			if(($adminlangsettings & 2)==2){ ?>
    1135. 

  1135. 			  <tr>
    1136. 

  1136. 				<td align="right"><?php print $yyDesc . " " . $index?>:</td>
    1137. 

  1137.                 <td colspan="2"><textarea name="pDescription<?php print $index?>" cols="30" rows="6" wrap=virtual><?php print $pDescriptions[$index]?></textarea>
    1138. 

  1138.                 <a href="#info">?</a></td>
    1139. 

  1139. 			    <td colspan="2">				  </td>
    1140. 

  1140. 			  </tr>
    1141. 

  1141. <?php		}
    1142. 

  1142. 		}
    1143. 

  1143. ?>
    1144. 

  1144. 			  <tr>
    1145. 

  1145. 			    <td width="14%" rowspan="3" align="right" valign="top"><?php print $yyLnDesc?>:</td>
    1146. 

  1146. 			    <td colspan="2" rowspan="3" align="left" valign="top"><textarea name="pLongDescription" cols="45" rows="6" wrap=virtual><?php print $pLongDescription?></textarea>
    1147. 

  1147. 		        <a href="#info">?</a></td>
    1148. 

  1148. 			    <td colspan="2" align="left">&nbsp;</td>
    1149. 

  1149. 		      </tr>
    1150. 

  1150. 			  <tr>
    1151. 

  1151.                 <td width="20%" align="left">&nbsp;</td>
    1152. 

  1152. 			    <td width="32%" align="left">&nbsp;</td>
    1153. 

  1153. 			  </tr>
    1154. 

  1154. 			  <tr>
    1155. 

  1155. 			    <td colspan="2" rowspan="4" align="left" valign="top">&nbsp;</td>
    1156. 

  1156. 			  </tr>
    1157. 

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

  1158. 			if(($adminlangsettings & 4)==4){ ?>
    1159. 

  1159. 			  <tr>
    1160. 

  1160. 				<td align="right"><?php print $yyLnDesc . " " . $index?>:</td>
    1161. 

  1161.                 <td colspan="2"><textarea name="pLongDescription<?php print $index?>" cols="45" rows="6" wrap=virtual><?php print $pLongDescriptions[$index]?></textarea>
    1162. 

  1162.                 <a href="#info">?</a></td>
    1163. 

  1163. 		      </tr>
    1164. 

  1164. <?php		}
    1165. 

  1165. 		}
    1166. 

  1166. ?>
    1167. 

  1167. 			  <tr>
    1168. 

  1168. 				<td align="right"><?php print $yyStatPg?>:</td>
    1169. 

  1169.                 <td colspan="2"><input type="checkbox" name="staticpage" value="1"<?php if(((int)$pSell & 4)==4) print ' checked' ?>> 
    1170. 

  1170.                 URL: 
    1171. 

  1171.                 <input name="pURL" type="text" id="pURL" value="<?=$pURL?>" />
    1172. 

  1172.                 <a href="#info">?</a> <span class="style1">(optional)</span></td>
    1173. 

  1173. 		      </tr>
    1174. 

  1174. 			<tr>
    1175. 

  1175. 				<td align="right">Title Tag:</td>
    1176. 

  1176. 				<td colspan="4"><input type="text" name="title_tag" id="title_tag" value="<?php echo $pTitleTag ?>" size="60" /></td>
    1177. 

  1177. 			</tr>
    1178. 

  1178. 			<tr>
    1179. 

  1179. 				<td align="right">Meta Description:</td>
    1180. 

  1180. 				<td colspan="4"><input type="text" name="meta_description" id="meta_description" value="<?php echo $pMetaDescription ?>" size="100" /></td>
    1181. 

  1181. 			</tr>
    1182. 

  1182. 			  <tr>
    1183. 

  1183. 				<td width="14%" align="right"><strong><?php print $yyAddSec?>:</strong></td>
    1184. 

  1184.                 <td align="left">
    1185. 

  1185. <?php		if(! $simpleSections){
    1186. 

  1186. 				print '<select size="1" name="pNumSections" onChange="setprodsections();"><option value="0">' . $yyNone . '</option>';
    1187. 

  1187. 				for($rowcounter=1;$rowcounter <= $maxprodsects; $rowcounter++)
    1188. 

  1188. 					print "<option value='" . $rowcounter . "'>" . $rowcounter . "</option>";
    1189. 

  1189. 				print "</select>";
    1190. 

  1190. 			} ?>&nbsp;<a href="#info">?</a></td>
    1191. 

  1191. 			    <td align="left">&nbsp;</td>
    1192. 

  1192. 			    <td align="left">&nbsp;</td>
    1193. 

  1193. 			  </tr>
    1194. 

  1194. <?php	if($simpleSections){
    1195. 

  1195. 			for($index=0;$index < $maxprodsects; $index++){
    1196. 

  1196. 				if(($index % 2)==0) print "<tr>";
    1197. 

  1197. 				print '<td align="right">' . $yyPrdSec . ' ' . ($index+1) . ':</td><td><select size="1" id="pSection' . $index . '" name="pSection' . $index . '"><option value="0">' . $yyNone . '</option>';
    1198. 

  1198. 				for($rowcounter=0;$rowcounter < $nallsections;$rowcounter++){
    1199. 

  1199. 					print '<option value="' . $allsections[$rowcounter]["sectionID"] . '"';
    1200. 

  1200. 					if($index < $nprodsections){
    1201. 

  1201. 						if($prodsections[$index][0]==$allsections[$rowcounter]["sectionID"]) print " selected";
    1202. 

  1202. 					}
    1203. 

  1203. 					print ">" . $allsections[$rowcounter]["sectionWorkingName"] . "</option>";
    1204. 

  1204. 				}
    1205. 

  1205. 				print "</td>";
    1206. 

  1206. 				if(($index % 2) != 0) print "</tr>\n";
    1207. 

  1207. 			}
    1208. 

  1208. 			if(($index % 2)==0)
    1209. 

  1209. 				print "</tr>\n";
    1210. 

  1210. 			else
    1211. 

  1211. 				print "<td colspan=\"2\">&nbsp;</td></tr>\n";
    1212. 

  1212. 		}else{ ?>
    1213. 

  1213. 			</table>
    1214. 

  1214. 			<div name="prodsections" id="prodsections">
    1215. 

  1215. 			</div>
    1216. 

  1216. 			<table width="100%" border="0" cellspacing="0" cellpadding="3" bgcolor="">
    1217. 

  1217. <?php	} ?>
    1218. 

  1218. 			  <tr> 
    1219. 

  1219.                 <td width="100%" colspan="4">
    1220. 

  1220.                   <p align="center"><input type="submit" value="<?php print $yySubmit?>" />&nbsp;&nbsp;<input type="reset" value="<?php print $yyReset?>" /></p>
    1221. 

  1221. <?php	show_info() ?>
    1222. 

  1222.                 </td>
    1223. 

  1223. 			  </tr>
    1224. 

  1224.             </table>
    1225. 

  1225. 		  </td>
    1226. 

  1226.         </tr>
    1227. 

  1227.       </table>
    1228. 

  1228. 	</form>
    1229. 

  1229. <?php	if(! $doaddnew){ ?>
    1230. 

  1230. <script language="JavaScript" type="text/javascript">
    1231. 

  1231. <!--
    1232. 

  1232. 

  1233. <?php	if(! $simpleOptions){ ?>
    1234. 

  1234. document.forms.mainform.pNumOptions.selectedIndex=<?php print $nprodoptions ?>;
    1235. 

  1235. document.forms.mainform.pNumOptions.options[<?php print $nprodoptions ?>].selected = true;
    1236. 

  1236. setprodoptions();
    1237. 

  1237. <?php	}
    1238. 

  1238. 		if(! $simpleSections){ ?>
    1239. 

  1239. document.forms.mainform.pNumSections.selectedIndex=<?php print $nprodsections ?>;
    1240. 

  1240. document.forms.mainform.pNumSections.options[<?php print $nprodsections ?>].selected = true;
    1241. 

  1241. setprodsections();
    1242. 

  1242. <?php	}
    1243. 

  1243. 		if($useStockManagement){ ?>
    1244. 

  1244. setstocktype();
    1245. 

  1245. <?php	} ?>
    1246. 

  1246. //-->
    1247. 

  1247. </script>
    1248. 

  1248. <?php	}
    1249. 

  1249. }elseif(@$_POST["act"]=="discounts"){
    1250. 

  1250. 		$sSQL = "SELECT pName FROM products WHERE pID='" . @$_POST["id"] . "'";
    1251. 

  1251. 		$result = mysql_query($sSQL) or print(mysql_error());
    1252. 

  1252. 		$rs = mysql_fetch_assoc($result);
    1253. 

  1253. 		$thisname=$rs["pName"];
    1254. 

  1254. 		mysql_free_result($result);
    1255. 

  1255. 		$numassigns=0;
    1256. 

  1256. 		$sSQL = "SELECT cpaID,cpaCpnID,cpnWorkingName,cpnSitewide,cpnEndDate,cpnType, cpnBeginDate FROM cpnassign LEFT JOIN coupons ON cpnassign.cpaCpnID=coupons.cpnID WHERE cpaType=2 AND cpaAssignment='" . @$_POST["id"] . "'";
    1257. 

  1257. 		$result = mysql_query($sSQL) or print(mysql_error());
    1258. 

  1258. 		while($rs=mysql_fetch_assoc($result))
    1259. 

  1259. 			$alldata[$numassigns++]=$rs;
    1260. 

  1260. 		mysql_free_result($result);
    1261. 

  1261. 		$numcoupons=0;
    1262. 

  1262. 		$sSQL = "SELECT cpnID,cpnWorkingName,cpnSitewide FROM coupons WHERE cpnSitewide=0 AND cpnEndDate >= '" . date("Y-m-d H:i:s",time()) ."'";
    1263. 

  1263. 		$result = mysql_query($sSQL) or print(mysql_error());
    1264. 

  1264. 		while($rs=mysql_fetch_assoc($result))
    1265. 

  1265. 			$alldata2[$numcoupons++]=$rs;
    1266. 

  1266. 		mysql_free_result($result);
    1267. 

  1267. ?>
    1268. 

  1268. <script language="JavaScript" type="text/javascript">
    1269. 

  1269. <!--
    1270. 

  1270. function delrec(id) {
    1271. 

  1271. cmsg = "<?php print $yyConAss?>\n"
    1272. 

  1272. if (confirm(cmsg)) {
    1273. 

  1273. 	document.mainform.id.value = id;
    1274. 

  1274. 	document.mainform.act.value = "deletedisc";
    1275. 

  1275. 	document.mainform.submit();
    1276. 

  1276. }
    1277. 

  1277. }
    1278. 

  1278. // -->
    1279. 

  1279. </script>
    1280. 

  1280.         <tr>
    1281. 

  1281. 		<form name="mainform" method="post" action="/admin/prods.php">
    1282. 

  1282. 		  <td width="100%">
    1283. 

  1283. 			<input type="hidden" name="posted" value="1" />
    1284. 

  1284. 			<input type="hidden" name="act" value="dodiscounts" />
    1285. 

  1285. 			<input type="hidden" name="id" value="<?php print @$_POST["id"]?>" />
    1286. 

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

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

  1288.             <table width="100%" border="0" cellspacing="0" cellpadding="3" bgcolor="">
    1289. 

  1289. 			  <tr> 
    1290. 

  1290.                 <td width="100%" colspan="4" align="center"><strong><?php print $yyAssPrd?> &quot;<?php print $thisname?>&quot;.</strong><br />&nbsp;</td>
    1291. 

  1291. 			  </tr>
    1292. 

  1292. <?php
    1293. 

  1293. 	$gotone=FALSE;
    1294. 

  1294. 	if($numcoupons>0){
    1295. 

  1295. 		$thestr = '<tr><td colspan="4" align="center">' . $yyAsDsCp . ': <select name="assdisc" size="1">';
    1296. 

  1296. 		for($index=0;$index < $numcoupons;$index++){
    1297. 

  1297. 			$alreadyassign=FALSE;
    1298. 

  1298. 			if($numassigns>0){
    1299. 

  1299. 				for($index2=0;$index2<$numassigns;$index2++){
    1300. 

  1300. 					if($alldata2[$index]["cpnID"]==$alldata[$index2]["cpaCpnID"]) $alreadyassign=TRUE;
    1301. 

  1301. 				}
    1302. 

  1302. 			}
    1303. 

  1303. 			if(! $alreadyassign){
    1304. 

  1304. 				$thestr .= "<option value='" . $alldata2[$index]["cpnID"] . "'>" . $alldata2[$index]["cpnWorkingName"] . "</option>\n";
    1305. 

  1305. 				$gotone=TRUE;
    1306. 

  1306. 			}
    1307. 

  1307. 		}
    1308. 

  1308. 		$thestr .= "</select> <input type='submit' value='Go' /></td></tr>";
    1309. 

  1309. 	}
    1310. 

  1310. 	if($gotone){
    1311. 

  1311. 		print $thestr;
    1312. 

  1312. 	}else{
    1313. 

  1313. ?>
    1314. 

  1314. 			  <tr> 
    1315. 

  1315.                 <td width="100%" colspan="4" align="center"><br /><strong><?php print $yyNoDis?></td>
    1316. 

  1316. 			  </tr>
    1317. 

  1317. <?php
    1318. 

  1318. 	}
    1319. 

  1319. 	if($numassigns>0){
    1320. 

  1320. ?>
    1321. 

  1321. 			  <tr> 
    1322. 

  1322.                 <td width="100%" colspan="4" align="center"><br /><strong><?php print $yyCurDis?> &quot;<?php print $thisname?>&quot;.</strong><br />&nbsp;</td>
    1323. 

  1323. 			  </tr>
    1324. 

  1324. 			  <tr> 
    1325. 

  1325.                 <td><strong><?php print $yyWrkNam?></strong></td>
    1326. 

  1326. 				<td><strong><?php print $yyDisTyp?></strong></td>
    1327. 

  1327. 				<td><strong><?php print $yyBegin?></strong></td>
    1328. 

  1328. 				<td><strong><?php print $yyExpire?></strong></td>
    1329. 

  1329. 				<td align="center"><strong><?php print $yyDelete?></strong></td>
    1330. 

  1330. 			  </tr>
    1331. 

  1331. <?php
    1332. 

  1332. 		for($index=0;$index<$numassigns;$index++){
    1333. 

  1333. 			$prefont = "";
    1334. 

  1334. 			$postfont = "";
    1335. 

  1335. 			if((int)$alldata[$index]["cpnSitewide"]==1 || ($alldata[$index]["cpnEndDate"] != '3000-01-01 00:00:00' && strtotime($alldata[$index]["cpnEndDate"])-time() < 0)){
    1336. 

  1336. 				$prefont = '<font color="#FF0000">';
    1337. 

  1337. 				$postfont = "</font>";
    1338. 

  1338. 			}
    1339. 

  1339. ?>
    1340. 

  1340. 			  <tr> 
    1341. 

  1341.                 <td><?php	print $prefont . $alldata[$index]["cpnWorkingName"] . $postfont ?></td>
    1342. 

  1342. 				<td><?php	if($alldata[$index]["cpnType"]==0)
    1343. 

  1343. 								print $prefont . $yyFrSShp . $postfont;
    1344. 

  1344. 							elseif($alldata[$index]["cpnType"]==1)
    1345. 

  1345. 								print $prefont . $yyFlatDs . $postfont;
    1346. 

  1346. 							elseif($alldata[$index]["cpnType"]==2)
    1347. 

  1347. 								print $prefont . $yyPerDis . $postfont; ?></td>
    1348. 

  1348. 				<td><?php
    1349. 

  1349. 					if ($alldata[$index]["cpnBeginDate"] != '0000-00-00 00:00:00') {
    1350. 

  1350. 						echo $prefont . $alldata[$index]["cpnBeginDate"] . $postfont;
    1351. 

  1351. 					} else {
    1352. 

  1352. 						echo $prefont . "&nbsp;" . $postfont;
    1353. 

  1353. 					}
    1354. 

  1354. 				?></td>
    1355. 

  1355. 				<td><?php	if($alldata[$index]["cpnEndDate"] == '3000-01-01 00:00:00')
    1356. 

  1356. 								print $yyNever;
    1357. 

  1357. 							elseif(strtotime($alldata[$index]["cpnEndDate"])-time() < 0)
    1358. 

  1358. 								print '<font color="#FF0000">' . $yyExpird . '</font>';
    1359. 

  1359. 							else
    1360. 

  1360. 								print $prefont . date("Y-m-d H:i:s",strtotime($alldata[$index]["cpnEndDate"])) . $postfont?></td>
    1361. 

  1361. 				<td align="center"><input type="button" name="discount" value="Delete Assignment" onclick="delrec('<?php print $alldata[$index]["cpaID"]?>')" /></td>
    1362. 

  1362. 			  </tr>
    1363. 

  1363. <?php
    1364. 

  1364. 		}
    1365. 

  1365. 	}else{
    1366. 

  1366. ?>
    1367. 

  1367. 			  <tr> 
    1368. 

  1368.                 <td width="100%" colspan="4" align="center"><br /><strong><?php print $yyNoAss?></td>
    1369. 

  1369. 			  </tr>
    1370. 

  1370. <?php
    1371. 

  1371. 	}
    1372. 

  1372. ?>
    1373. 

  1373. 			  <tr>
    1374. 

  1374.                 <td width="100%" colspan="4" align="center"><br />&nbsp;</td>
    1375. 

  1375. 			  </tr>
    1376. 

  1376. 			  <tr> 
    1377. 

  1377.                 <td width="100%" colspan="4" align="center"><br />
    1378. 

  1378.                           <a href="/admin/index.php"><strong><?php print $yyAdmHom?></strong></a><br />
    1379. 

  1379.                           &nbsp;</td>
    1380. 

  1380. 			  </tr>
    1381. 

  1381.             </table></td>
    1382. 

  1382. 		  </form>
    1383. 

  1383.         </tr>
    1384. 

  1384. <?php
    1385. 

  1385. }elseif(@$_POST["posted"]=="1" && $success){ ?>
    1386. 

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

  1387.         <tr>
    1388. 

  1388.           <td width="100%">
    1389. 

  1389. 			<table width="100%" border="0" cellspacing="0" cellpadding="3" bgcolor="">
    1390. 

  1390. 			  <tr> 
    1391. 

  1391.                 <td width="100%" colspan="2" align="center"><br /><strong><?php print $yyUpdSuc?></strong><br /><br /><?php print $yyNowFrd?><br /><br />
    1392. 

  1392.                         <?php print $yyNoAuto?> <a href="/admin/prods.php<?php
    1393. 

  1393. 							if(trim(@$_POST["ts"]) != "")
    1394. 

  1394. 								print "?ts=" . trim(@$_POST["ts"]);
    1395. 

  1395. 							elseif(trim(@$_POST["tt"]) != "")
    1396. 

  1396. 								print "?tt=" . trim(@$_POST["tt"]);
    1397. 

  1397. 							?>"><strong>click here</strong></a>.<br />
    1398. 

  1398.                         <br />
    1399. 

  1399. 				<img src="/lib/images/misc/clearpixel.gif" width="300" height="3" alt="" />
    1400. 

  1400.                 </td>
    1401. 

  1401. 			  </tr>
    1402. 

  1402. 			</table>
    1403. 

  1403. 		  </td>
    1404. 

  1404.         </tr>
    1405. 

  1405.       </table>
    1406. 

  1406. <?php
    1407. 

  1407. }elseif(@$_POST["posted"]=="1"){ ?>
    1408. 

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

  1409.         <tr>
    1410. 

  1410.           <td width="100%">
    1411. 

  1411. 			<table width="100%" border="0" cellspacing="0" cellpadding="3" bgcolor="">
    1412. 

  1412. 			  <tr> 
    1413. 

  1413.                 <td width="100%" colspan="2" align="center"><br /><font color="#FF0000"><strong><?php print $yyOpFai?></strong></font><br /><br /><?php print $errmsg?><br /><br />
    1414. 

  1414. 				<a href="javascript:history.go(-1)"><strong><?php print $yyClkBac?></strong></a></td>
    1415. 

  1415. 			  </tr>
    1416. 

  1416. 			</table>
    1417. 

  1417. 		  </td>
    1418. 

  1418.         </tr>
    1419. 

  1419.       </table>
    1420. 

  1420. <?php
    1421. 

  1421. }elseif(@$_GET["tt"] != "" || @$_GET["ts"] != ""){ ?>
    1422. 

  1422. <script language="JavaScript" type="text/javascript">
    1423. 

  1423. <!--
    1424. 

  1424. function modrec(id,evt) {
    1425. 

  1425. 	document.mainform.id.value = id;
    1426. 

  1426. 	<?php if(strstr(@$HTTP_SERVER_VARS["HTTP_USER_AGENT"], "Gecko")){ ?>
    1427. 

  1427. 	if(evt.ctrlKey || evt.altKey)
    1428. 

  1428. 	<?php }else{ ?>
    1429. 

  1429. 	theevnt=window.event;
    1430. 

  1430. 	if(theevnt.ctrlKey)
    1431. 

  1431. 	<?php } ?>
    1432. 

  1432. 		document.mainform.act.value = "clone";
    1433. 

  1433. 	else
    1434. 

  1434. 		document.mainform.act.value = "modify";
    1435. 

  1435. 	document.mainform.submit();
    1436. 

  1436. }
    1437. 

  1437. function newrec(id) {
    1438. 

  1438. 	document.mainform.id.value = id;
    1439. 

  1439. 	document.mainform.act.value = "addnew";
    1440. 

  1440. 	document.mainform.submit();
    1441. 

  1441. }
    1442. 

  1442. function discounts(id) {
    1443. 

  1443. 	document.mainform.id.value = id;
    1444. 

  1444. 	document.mainform.act.value = "discounts";
    1445. 

  1445. 	document.mainform.submit();
    1446. 

  1446. }
    1447. 

  1447. function delrec(id) {
    1448. 

  1448. cmsg = "<?php print $yyConDel?>\n"
    1449. 

  1449. if (confirm(cmsg)) {
    1450. 

  1450. 	document.mainform.id.value = id;
    1451. 

  1451. 	document.mainform.act.value = "delete";
    1452. 

  1452. 	document.mainform.submit();
    1453. 

  1453. }
    1454. 

  1454. }
    1455. 

  1455. var arrProdToRelate=new Array();
    1456. 

  1456. var strProdToRelate='';
    1457. 

  1457. var arrRelatedProds=new Array();
    1458. 

  1458. var strRelatedProds='';
    1459. 

  1459. var count=0;
    1460. 

  1460. function loadRelatedProds(prod,type,relprod){
    1461. 

  1461. 	//alert(prod+','+type+','+relprod);
    1462. 

  1462. 	var url = "/admin/relatedaj.php";
    1463. 

  1463. 	var params = "prod="+prod+'&type='+type+'&relprod='+relprod;
    1464. 

  1464. 	//alert(params);
    1465. 

  1465. 	var ajax = new Ajax.Updater(
    1466. 

  1466. 		{success: "toadd_"+prod},
    1467. 

  1467. 		url,
    1468. 

  1468. 		{
    1469. 

  1469. 			method: "post", 
    1470. 

  1470. 			parameters: params,
    1471. 

  1471. 			//onLoading: function() { Element.show("holder_working"+prod); },
    1472. 

  1472. 			//onComplete: function() { Element.hide("holder_working"+prod); },
    1473. 

  1473. 			evalScripts: true
    1474. 

  1474. 		});
    1475. 

  1475. }
    1476. 

  1476. function setProdToRelate(prod,type){	
    1477. 

  1477. 	loadRelatedProds(prod,'','');
    1478. 

  1478. 	//Element.toggle('counthref'+prod);
    1479. 

  1479. 	//Element.toggle('count'+prod);
    1480. 

  1480. 	//$('count'+prod).onClick='';
    1481. 

  1481. 	Element.toggle('related'+prod);	
    1482. 

  1482. 	arrlen=arrProdToRelate.length;
    1483. 

  1483. 	if(type=='Add'){
    1484. 

  1484. 		arrProdToRelate.push(prod);
    1485. 

  1485. 		$('prodstorelate'+prod).value=prod;
    1486. 

  1486. 		count++;
    1487. 

  1487. 	} else if (type=='Delete'){
    1488. 

  1488. 		for(i=0;i<arrlen;i++){
    1489. 

  1489. 			if(arrProdToRelate[i]==prod) arrProdToRelate.splice(i,1);
    1490. 

  1490. 		}
    1491. 

  1491. 		$('prodstorelate'+prod).value='';
    1492. 

  1492. 		count--;
    1493. 

  1493. 	}
    1494. 

  1494. 	if(count==0) resetAll();
    1495. 

  1495. 	else addRelatedProds(prod,'');	
    1496. 

  1496. }
    1497. 

  1497. function setRelatedProds(reprod,ele){
    1498. 

  1498. 	//alert(ele);
    1499. 

  1499. 	/*if(type==1){
    1500. 

  1500. 		if($('relatedprods'+reprod).value==''){		
    1501. 

  1501. 			if(count>0) {
    1502. 

  1502. 				arrRelatedProds.push(reprod);
    1503. 

  1503. 				if(type==''){
    1504. 

  1504. 					$('relatedprods'+reprod).value=reprod;
    1505. 

  1505. 					$('row_'+reprod).style.background='#BFC9E0';
    1506. 

  1506. 				}
    1507. 

  1507. 				addRelatedProds(reprod,'Add');
    1508. 

  1508. 			} else alert('There is no product for this to be related to!');
    1509. 

  1509. 		} else {		
    1510. 

  1510. 			for(i=0;i<arrRelatedProds.length;i++){
    1511. 

  1511. 				if(arrRelatedProds[i]==reprod) arrRelatedProds.splice(i,1);
    1512. 

  1512. 			}
    1513. 

  1513. 			resetRelatedProd(reprod);
    1514. 

  1514. 			addRelatedProds(reprod,'Delete');
    1515. 

  1515. 		}
    1516. 

  1516. 	}else{*/
    1517. 

  1517. 		if(count>0) {
    1518. 

  1518. 			arrRelatedProds.push(reprod);
    1519. 

  1519. 			addRelatedProds(reprod,'Add');
    1520. 

  1520. 			
    1521. 

  1521. 		}
    1522. 

  1522. 		$('autocomplete'+ele).value='';
    1523. 

  1523. 	//}
    1524. 

  1524. }
    1525. 

  1525. function resetRelatedProd(prod){
    1526. 

  1526. 	$('relatedprods'+prod).value='';		
    1527. 

  1527. 	$('row_'+prod).style.background='';	
    1528. 

  1528. }
    1529. 

  1529. function addRelatedProds(prod,type){
    1530. 

  1530. 	for(i=0;i<arrProdToRelate.length;i++){		
    1531. 

  1531. 		loadRelatedProds(arrProdToRelate[i],type,prod);
    1532. 

  1532. 	}
    1533. 

  1533. }
    1534. 

  1534. function resetAll(){
    1535. 

  1535. 	allprods=document.getElementsByClassName('relatedprods');
    1536. 

  1536. 	cnt=allprods.length;
    1537. 

  1537. 	for(i=0;i<cnt;i++){
    1538. 

  1538. 		if(allprods[i].value!='')resetRelatedProd(allprods[i].value);
    1539. 

  1539. 	}
    1540. 

  1540. }
    1541. 

  1541. // -->
    1542. 

  1542. </script>
    1543. 

  1543. <style type="text/css">
    1544. 

  1544. <!--
    1545. 

  1545. tr.prodRow:hover {background-color: #FFFFCC; color: #000;}
    1546. 

  1546. -->
    1547. 

  1547. </style>
    1548. 

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

  1549.         <tr>
    1550. 

  1550. 		<form name="mainform" method="post" action="/admin/prods.php">
    1551. 

  1551. 		  <td width="100%">
    1552. 

  1552. 			<input type="hidden" name="posted" value="1" />
    1553. 

  1553. 			<input type="hidden" name="act" value="xxxxx" />
    1554. 

  1554. 			<input type="hidden" name="id" value="xxxxx" />
    1555. 

  1555. 			<input type="hidden" name="tt" value="<?php print @$_GET["tt"];?>" />
    1556. 

  1556. 			<input type="hidden" name="ts" value="<?php print @$_GET["ts"];?>" />
    1557. 

  1557.             <table width="100%" border="0" cellspacing="0" cellpadding="1" bgcolor="">
    1558. 

  1558. 			  <tr> 
    1559. 

  1559.                 <td width="100%" colspan="8" align="center"><strong><?php print $yyPrUpd?></strong>&nbsp;&nbsp;<input type="button" value="<?php print $yyNewPr?>" onclick="newrec()" /><br />&nbsp;</td>
    1560. 

  1560. 			  </tr>
    1561. 

  1561. 			  <tr>
    1562. 

  1562. 				<td><strong><?php print $yyPrId?></strong></td>
    1563. 

  1563. 				<td><strong>Display Order</strong></td>
    1564. 

  1564. 				<td><strong><?php print $yyPrName?></strong></td>
    1565. 

  1565. 				<td><strong>Price</strong></td>
    1566. 

  1566. 				<td><strong>Show to Etailers</strong></td>
    1567. 

  1567. 				<td><div align="center"><strong>Related</strong></div></td>
    1568. 

  1568. 				<td width="5%" align="center"><font size="1"><strong><?php print $yyDiscnt?></strong></font></td>
    1569. 

  1569. 				<td width="5%" align="center"><font size="1"><strong><?php print $yyModify?></strong></font></td>
    1570. 

  1570. 				<td width="5%" align="center"><font size="1"><strong><?php print $yyDelete?></strong></font></td>
    1571. 

  1571. 			  </tr>
    1572. 

  1572. <?php
    1573. 

  1573. 	$allcoupon="";
    1574. 

  1574. 	$numcoupons=0;
    1575. 

  1575. 	$sSQL = "SELECT DISTINCT cpaAssignment FROM cpnassign WHERE cpaType=2";
    1576. 

  1576. 	$result = mysql_query($sSQL) or print(mysql_error());
    1577. 

  1577. 	while($rs=mysql_fetch_array($result))
    1578. 

  1578. 		$allcoupon[$numcoupons++]=$rs;
    1579. 

  1579. 	mysql_free_result($result);
    1580. 

  1580. 	if($stockManage != 0)
    1581. 

  1581. 		$sSQL = "SELECT pID,pName,pDisplay,pInStock,rootSection,pSell,pOrder,pEDisplay,pPrice,topSection FROM products LEFT OUTER JOIN sections ON products.pSection=sections.sectionID ";
    1582. 

  1582. 	else
    1583. 

  1583. 		$sSQL = "SELECT pID,pName,pDisplay,pSell,rootSection,pOrder,pPrice,topSection FROM products LEFT OUTER JOIN sections ON products.pSection=sections.sectionID ";
    1584. 

  1584. 	if(@$_GET["tt"]=="ALL")
    1585. 

  1585. 		; // Nothing
    1586. 

  1586. 	else
    1587. 

  1587. 		$sSQL .= "WHERE pSection=" . $_GET["ts"];
    1588. 

  1588. 	if(@$adminsortorder!="") $sSQL .= " ORDER BY " . $adminsortorder; else $sSQL .= " ORDER BY pOrder,pName";
    1589. 

  1589. 	$result = mysql_query($sSQL) or print(mysql_error());
    1590. 

  1590. 	$haveerrprods=FALSE;
    1591. 

  1591. 	$bgcolor="#FFFFFF";
    1592. 

  1592. 	if(mysql_num_rows($result) > 0){
    1593. 

  1593. 		while($alldata = mysql_fetch_row($result)){
    1594. 

  1594. 

  1595. 			// Check to see if parent section exists
    1596. 

  1596. 			$parent_exists = FALSE;
    1597. 

  1597. 			$sql = "SELECT * FROM sections WHERE sectionID = " . $alldata[9];
    1598. 

  1598. 			$res = mysql_query($sql) or die('Problem querying parent section.');
    1599. 

  1599. 			if (mysql_num_rows($res) > 0) {
    1600. 

  1600. 				$parent_exists = TRUE;
    1601. 

  1601. 			}
    1602. 

  1602. 

  1603. 			if($bgcolor=="#E7EAEF") $bgcolor="#FFFFFF"; else $bgcolor="#E7EAEF"; ?>
    1604. 

  1604. 			  <tr class="prodRow" bgcolor="<?php print $bgcolor?>" id="row_<?=$alldata[0]?>">
    1605. 

  1605. 				<td><strong><a href="javascript:void(0);" onclick="setRelatedProds('<?=$alldata[0]?>')"><?php print $alldata[0]?></a></strong></td>
    1606. 

  1606. 				<td><strong><?php print $alldata[6]?></strong></td>
    1607. 

  1607. 				<td><strong><?php
    1608. 

  1608. 					if( ! $parent_exists){
    1609. 

  1609. 						print "<font color='#FF0000'>*</font> ";
    1610. 

  1610. 						$haveerrprods=TRUE;
    1611. 

  1611. 					}
    1612. 

  1612. 					$stockbyoptions=false;
    1613. 

  1613. 					if($stockManage != 0)
    1614. 

  1614. 						if(($alldata[5] & 2) == 2) $stockbyoptions=true;
    1615. 

  1615. 					if(((int)$alldata[3] <= 0 || (int)$alldata[2] == 0) && ! $stockbyoptions) print "<font color='#FF0000'>";
    1616. 

  1616. 					if((int)$alldata[2] == 0) print "<strike>";
    1617. 

  1617. 					print str_replace(" ", "&nbsp;", $alldata[1]);
    1618. 

  1618. 					if((int)$alldata[2] == 0) print "</strike>";
    1619. 

  1619. 					if(((int)$alldata[3] <= 0 || (int)$alldata[2] == 0) && ! $stockbyoptions) print "</font>";
    1620. 

  1620. 					?></strong><?php if($stockManage>0) print "&nbsp;(" . ($stockbyoptions?"-":$alldata[3]) . ")"?>				
    1621. 

  1621. 				</td>
    1622. 

  1622. 				<td><?=sprintf("$%.2f", $alldata[8])?></td>
    1623. 

  1623. 				<td>
    1624. 

  1624. 				<? 
    1625. 

  1625. 				if((int)$alldata[7]==1) print 'yes';
    1626. 

  1626. 				else print "<font color='#FF0000'>no</font>";
    1627. 

  1627. 				?>				</td>
    1628. 

  1628. 				<td align="center">
    1629. 

  1629. 				<?  $sql_cross="SELECT * FROM crosssale WHERE prodID='".$alldata[0]."' ORDER BY prodID";
    1630. 

  1630. 					$result_cross=mysql_query($sql_cross);
    1631. 

  1631. 					$cnt_cross=0;
    1632. 

  1632. 					$str_cross='';
    1633. 

  1633. 					while($row_cross=mysql_fetch_assoc($result_cross)) {
    1634. 

  1634. 						$str_cross.= ($cnt_cross+1).'. '.$row_cross['related'].'<br />';
    1635. 

  1635. 						$cnt_cross++;
    1636. 

  1636. 					}
    1637. 

  1637. 					//if($cnt_cross>0){
    1638. 

  1638. 				?>						
    1639. 

  1639. <!--					<div id="count<?=$alldata[0]?>" style="display:none"><?=$cnt_cross?></div>
    1640. 

  1640. -->					<div id="count<?=$alldata[0]?>"><a href="javascript:void(0);" onclick="setProdToRelate('<?=$alldata[0]?>','Add')"><?=$cnt_cross?></a></div>
    1641. 

  1641. 				<? //} else {?>					
    1642. 

  1642. <!--					<div id="count<?=$alldata[0]?>" style="display:none">Add</div>
    1643. 

  1643. 					<div id="counthref<?=$alldata[0]?>"><a href="javascript:void(0)" onclick="setProdToRelate('<?=$alldata[0]?>','Add')">Add</a></div>
    1644. 

  1644. -->				<? //} ?>
    1645. 

  1645. 				<input name="relatedprods<?=$alldata[0]?>" type="hidden" id="relatedprods<?=$alldata[0]?>"  class="relatedprods" />
    1646. 

  1646. 			      <input name="prodstorelate<?=$alldata[0]?>" type="hidden" id="prodstorelate<?=$alldata[0]?>" class="prodstorelate" />
    1647. 

  1647. 				<div style="position:relative;">
    1648. 

  1648. 					<div id="related<?=$alldata[0]?>" style="display:none; position:absolute; left:-490px; top:-16px; background-color:#E7EAEF; border: 1px solid #003366; width:500px; min-height:100px; text-align:left;">
    1649. 

  1649. 						<div style="background-color:#BFC9E0; padding:2px; z-index:100;">
    1650. 

  1650. 							<div style="float:right;"><a href="javascript:void(0);" style="color:#FFFFFF;" onclick="setProdToRelate('<?=$alldata[0]?>','Delete')"><img src="/lib/images/collapse.gif" border="0" /></a></div>
    1651. 

  1651. 							<div style="font-weight:bold;"><?=$alldata[0]?></div>
    1652. 

  1652. 						</div>					    						
    1653. 

  1653. 						<div id="toadd_<?=$alldata[0]?>" style="padding:6px;"></div>
    1654. 

  1654. 						<div style="padding:2px; ">
    1655. 

  1655. 							<input type="text" id="autocomplete<?=$alldata[0]?>" name="pID" style="font-size:14px;width:430px;"/> <input name="addrel" type="button" onclick="setRelatedProds($('autocomplete<?=$alldata[0]?>').value,'<?=$alldata[0]?>')" value="add" />
    1656. 

  1656. 						  <span id="indicator<?=$alldata[0]?>" style="display: none;"><img src="/lib/images/indicator.gif" alt="Working..." width="16" height="16" /></span>						
    1657. 

  1657. 						</div>
    1658. 

  1658. 						<div id="autocomplete_choices<?=$alldata[0]?>" class="autocomplete"></div>
    1659. 

  1659. 						
    1660. 

  1660. 						<script language="JavaScript" type="text/javascript">
    1661. 

  1661. 						new Ajax.Autocompleter("autocomplete<?=$alldata[0]?>", "autocomplete_choices<?=$alldata[0]?>", "/admin/relatedautocomplete.php", {indicator: 'indicator<?=$alldata[0]?>'});
    1662. 

  1662. 						
    1663. 

  1663. /*						function getSelectionId(text, li) {
    1664. 

  1664.     						$('autocomplete<?=$alldata[0]?>').value='';
    1665. 

  1665. 						}
    1666. 

  1666. */						
    1667. 

  1667. 						</script>						
    1668. 

  1668. 					</div>				
    1669. 

  1669. 				</div>
    1670. 

  1670. 				
    1671. 

  1671. 								</td>
    1672. 

  1672. 				<td align="center"><input <?php
    1673. 

  1673. 					for($index=0;$index<$numcoupons;$index++){
    1674. 

  1674. 						if($allcoupon[$index][0]==$alldata[0]){
    1675. 

  1675. 							print 'style="color: #FF0000"';
    1676. 

  1676. 							break;
    1677. 

  1677. 						}
    1678. 

  1678. 					}
    1679. 

  1679. 				?> type="button" value="<?php print $yyAssign?>" onclick="discounts('<?php print str_replace(array("\\","'"),array("\\\\","\'"),$alldata[0])?>')" /></td>
    1680. 

  1680. 				<td><input type=button value="<?php print $yyModify?>" onclick="modrec('<?php print str_replace(array("\\","'"),array("\\\\","\'"),$alldata[0])?>',event)" /></td>
    1681. 

  1681. 				<td><input type=button value="<?php print $yyDelete?>" onclick="delrec('<?php print str_replace(array("\\","'"),array("\\\\","\'"),$alldata[0])?>')" /></td>
    1682. 

  1682. 			  </tr>
    1683. 

  1683. <?php
    1684. 

  1684. 		}
    1685. 

  1685. 		if($haveerrprods){
    1686. 

  1686. ?>
    1687. 

  1687. 			  <tr> 
    1688. 

  1688.                 <td width="100%" colspan="8"><br />
    1689. 

  1689.                 <strong><font color='#FF0000'>* </font></strong><?php print $yySeePr?></td>
    1690. 

  1690. 			  </tr>
    1691. 

  1691. <?php
    1692. 

  1692. 		}
    1693. 

  1693. 	}else{
    1694. 

  1694. ?>
    1695. 

  1695. 			  <tr> 
    1696. 

  1696.                 <td width="100%" colspan="6" align="center"><br /><?php print $yyPrNone?><br />&nbsp;</td>
    1697. 

  1697. 			  </tr>
    1698. 

  1698. <?php
    1699. 

  1699. 	}
    1700. 

  1700. ?>
    1701. 

  1701. 			  <tr> 
    1702. 

  1702.                 <td width="100%" colspan="6" align="center"><br /><strong><?php print $yyANewPr?></strong>&nbsp;&nbsp;<input type="button" value="<?php print $yyNewPr?>" onclick="newrec()" /><br />&nbsp;</td>
    1703. 

  1703. 			  </tr>
    1704. 

  1704. 			  <tr> 
    1705. 

  1705.                 <td width="100%" colspan="6" align="center"><br />
    1706. 

  1706.                           <a href="/admin/index.php"><strong><?php print $yyAdmHom?></strong></a><br />
    1707. 

  1707. 				<img src="/lib/images/misc/clearpixel.gif" width="300" height="3" alt="" /></td>
    1708. 

  1708. 			  </tr>
    1709. 

  1709.             </table></td>
    1710. 

  1710. 		  </form>
    1711. 

  1711.         </tr>
    1712. 

  1712.       </table>
    1713. 

  1713. <?php
    1714. 

  1714. }else{ ?>
    1715. 

  1715. <script language="JavaScript" type="text/javascript">
    1716. 

  1716. <!--
    1717. 

  1717. function modrec(id) {
    1718. 

  1718. 	document.mainform.action="/admin/prods.php";
    1719. 

  1719. 	document.mainform.id.value = id;
    1720. 

  1720. 	document.mainform.act.value = "modify";
    1721. 

  1721. 	document.mainform.submit();
    1722. 

  1722. }
    1723. 

  1723. function newrec(id) {
    1724. 

  1724. 	document.mainform.action="/admin/prods.php";
    1725. 

  1725. 	document.mainform.id.value = id;
    1726. 

  1726. 	document.mainform.act.value = "addnew";
    1727. 

  1727. 	document.mainform.submit();
    1728. 

  1728. }
    1729. 

  1729. function dumpinventory(){
    1730. 

  1730. 	document.mainform.action="/admin/dumporders.php";
    1731. 

  1731. 	document.mainform.act.value = "dumpinventory";
    1732. 

  1732. 	document.mainform.submit();
    1733. 

  1733. }
    1734. 

  1734. function dump2COinventory(){
    1735. 

  1735. 	document.mainform.action="/admin/dumporders.php";
    1736. 

  1736. 	document.mainform.act.value = "dump2COinventory";
    1737. 

  1737. 	document.mainform.submit();
    1738. 

  1738. }
    1739. 

  1739. function delrec(id) {
    1740. 

  1740. cmsg = "<?php print $yyConDel?>\n"
    1741. 

  1741. if (confirm(cmsg)) {
    1742. 

  1742. 	document.mainform.action="/admin/prods.php";
    1743. 

  1743. 	document.mainform.id.value = id;
    1744. 

  1744. 	document.mainform.act.value = "delete";
    1745. 

  1745. 	document.mainform.submit();
    1746. 

  1746. }
    1747. 

  1747. }
    1748. 

  1748. 

  1749. function displaySection(section, num) {
    1750. 

  1750. 	// Change sign in the button
    1751. 

  1751. 	var button = $('show'+num);
    1752. 

  1752. 	if (button.value == '+') {
    1753. 

  1753. 		button.value = '-';
    1754. 

  1754. 	} else {
    1755. 

  1755. 		button.value = '+';
    1756. 

  1756. 	}
    1757. 

  1757. 	
    1758. 

  1758. 	// Toggle visibility for the section
    1759. 

  1759. 	var aRows = $$('tr.sectionprod'+section);
    1760. 

  1760. 	console.log(section);
    1761. 

  1761. 	for (i=0; i<aRows.length; i++) {
    1762. 

  1762. 		aRows[i].toggle();
    1763. 

  1763. 	}
    1764. 

  1764. }
    1765. 

  1765. // -->
    1766. 

  1766. </script>
    1767. 

  1767. <style type="text/css">
    1768. 

  1768. <!--
    1769. 

  1769. .section {
    1770. 

  1770. 	font-weight: bold;
    1771. 

  1771. }
    1772. 

  1772. 

  1773. tr.sectionprod td {
    1774. 

  1774. 	padding-left: 50px;
    1775. 

  1775. }
    1776. 

  1776. -->
    1777. 

  1777. </style>
    1778. 

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

  1779.         <tr>
    1780. 

  1780. 		<form name="mainform" method="post" action="/admin/prods.php">
    1781. 

  1781. 		  <td width="100%">
    1782. 

  1782. 			<input type="hidden" name="posted" value="1" />
    1783. 

  1783. 			<input type="hidden" name="act" value="xxxxx" />
    1784. 

  1784. 			<input type="hidden" name="id" value="xxxxx" />
    1785. 

  1785.             <table width="100%" border="0" cellspacing="0" cellpadding="1" bgcolor="">
    1786. 

  1786. 			  <tr> 
    1787. 

  1787.                 <td width="100%" colspan="4" align="center"><br /><strong><?php print $yyPrClk?></strong><br />&nbsp;</td>
    1788. 

  1788. 			  </tr>
    1789. 

  1789. 			  <tr>
    1790. 

  1790. 				<td colspan='4'><input type="button" value="<?php print $yyNewPr?>" onclick="newrec()" />&nbsp;&nbsp;<strong><a href="/admin/prods.php?tt=ALL"><?php print $yyPrAll?></a></strong></td>
    1791. 

  1791. 			  </tr>
    1792. 

  1792. <?php
    1793. 

  1793. 	//$sSQL = "SELECT sectionID,sectionWorkingName FROM sections WHERE rootSection=1 ORDER BY sectionWorkingName";
    1794. 

  1794. 	$sSQL = "SELECT s.sectionID, s.sectionWorkingName, p.pID, p.pName
    1795. 

  1795. 			FROM products p
    1796. 

  1796. 			LEFT OUTER JOIN sections s ON p.pSection=s.sectionID
    1797. 

  1797. 			WHERE p.pSection IS NOT NULL
    1798. 

  1798. 			AND p.pID != ''
    1799. 

  1799. 			AND s.sectionID IS NOT NULL
    1800. 

  1800. 			ORDER BY s.sectionWorkingName, p.pID";
    1801. 

  1801. 	$result = mysql_query($sSQL) or print(mysql_error());
    1802. 

  1802. 	if(mysql_num_rows($result) > 0){
    1803. 

  1803. 		$success=TRUE;
    1804. 

  1804. 		$lastSection = -1;
    1805. 

  1805. 		$i = 0;
    1806. 

  1806. 		while($alldata = mysql_fetch_assoc($result)){
    1807. 

  1807. 			if ($lastSection != $alldata['sectionID']) {
    1808. 

  1808. 				print "<tr class='section'><td><input type='button' id='show".$i."' onclick='displaySection(\"".$alldata['sectionID']."\", ".$i.")' value='+' />&nbsp;<a href='/admin/prods.php?ts=" . $alldata['sectionID'] . "'>".$alldata['sectionWorkingName']."</a></td></tr>";
    1809. 

  1809. 			}
    1810. 

  1810. 			print "<tr class='sectionprod".$alldata['sectionID']." sectionprod' style='display: none;'><td>".$alldata['pID']."&nbsp;-&nbsp;".$alldata['pName']."</td></tr>";
    1811. 

  1811. 			$lastSection = $alldata['sectionID'];
    1812. 

  1812. 			$i++;
    1813. 

  1813. 		}
    1814. 

  1814. 	}else
    1815. 

  1815. 		$success=FALSE;
    1816. 

  1816. 	mysql_free_result($result);
    1817. 

  1817. 	$sSQL = "SELECT payProvEnabled,payProvData1 FROM payprovider WHERE payProvID=2";
    1818. 

  1818. 	$result = mysql_query($sSQL) or print(mysql_error());
    1819. 

  1819. 	$rs = mysql_fetch_assoc($result);
    1820. 

  1820. 	if($rs["payProvEnabled"]==1 AND trim($rs["payProvData1"]) != ""){
    1821. 

  1821. ?>
    1822. 

  1822. 			  <tr> 
    1823. 

  1823.                 <td width="100%" colspan="4" align="center"><input type="button" value="2Checkout Inventory" onclick="dump2COinventory()" /></td>
    1824. 

  1824. 			  </tr>
    1825. 

  1825. <?php
    1826. 

  1826. 	}
    1827. 

  1827. 	$alldata="";
    1828. 

  1828. 	if($stockManage != 0){
    1829. 

  1829. 		$sSQL = "SELECT pID,pName,pDisplay,pInStock,pSell FROM products WHERE pInStock<=0";
    1830. 

  1830. 		if(@$adminsortorder!="") $sSQL .= " ORDER BY " . $adminsortorder; else $sSQL .= " ORDER BY pName";
    1831. 

  1831. 		$sSQL .= " LIMIT 1000";
    1832. 

  1832. 		//echo $sSQL;
    1833. 

  1833. 		$result = mysql_query($sSQL) or print(mysql_error());
    1834. 

  1834. ?>
    1835. 

  1835. 			  <tr> 
    1836. 

  1836.                 <td width="100%" colspan="4" align="center"><br /><strong><?php print $yyPrOOS?></strong><br />&nbsp;</td>
    1837. 

  1837. 			  </tr>
    1838. 

  1838. 			  <tr> 
    1839. 

  1839.                 <td width="100%" colspan="4" align="center"><input type="button" value="<?php print $yyDmpInv?>" onclick="dumpinventory()" /></td>
    1840. 

  1840. 			  </tr>
    1841. 

  1841. <?php
    1842. 

  1842. 		if(mysql_num_rows($result) > 0){
    1843. 

  1843. 			while($alldata = mysql_fetch_row($result)){
    1844. 

  1844. 				if(($alldata[4] & 2) != 2 && $alldata[2] != 0){ ?>
    1845. 

  1845. 			  <tr>
    1846. 

  1846. 				<td><strong><?php print $alldata[0]?></strong></td>
    1847. 

  1847. 				<td><strong><?php
    1848. 

  1848. 					if((int)$alldata[3] <= 0 || (int)$alldata[2] == 0) print "<font color='#FF0000'>";
    1849. 

  1849. 					if((int)$alldata[2] == 0) print "<strike>";
    1850. 

  1850. 					print $alldata[1];
    1851. 

  1851. 					if((int)$alldata[2] == 0) print "</strike>";
    1852. 

  1852. 					if((int)$alldata[3] <= 0 || (int)$alldata[2] == 0) print "</font>";
    1853. 

  1853. 					?></strong></td>
    1854. 

  1854. 				<td><input type=button value="<?php print $yyModify?>" onclick="modrec('<?php print str_replace(array("\\","'"),array("\\\\","\'"),$alldata[0])?>')" /></td>
    1855. 

  1855. 				<td><input type=button value="<?php print $yyDelete?>" onclick="delrec('<?php print str_replace(array("\\","'"),array("\\\\","\'"),$alldata[0])?>')" /></td>
    1856. 

  1856. 			  </tr>
    1857. 

  1857. <?php			}
    1858. 

  1858. 			}
    1859. 

  1859. 		}else{
    1860. 

  1860. ?>
    1861. 

  1861. 			  <tr> 
    1862. 

  1862.                 <td width="100%" colspan="4" align="center"><br /><strong><?php print $yyPrNoOS?></strong><br />&nbsp;</td>
    1863. 

  1863. 			  </tr>
    1864. 

  1864. <?php
    1865. 

  1865. 		}
    1866. 

  1866. 	}
    1867. 

  1867. ?>
    1868. 

  1868. 			  <tr> 
    1869. 

  1869.                 <td width="100%" colspan="4" align="center"><br /><strong><?php print $yyANewPr?></strong>&nbsp;&nbsp;<input type="button" value="<?php print $yyNewPr?>" onclick="newrec()" /><br />&nbsp;</td>
    1870. 

  1870. 			  </tr>
    1871. 

  1871. 			  <tr> 
    1872. 

  1872.                 <td width="100%" colspan="4" align="center"><br />
    1873. 

  1873.                           <a href="/admin/index.php"><strong><?php print $yyAdmHom?></strong></a><br />
    1874. 

  1874. 				<img src="/lib/images/misc/clearpixel.gif" width="300" height="3" alt="" /></td>
    1875. 

  1875. 			  </tr>
    1876. 

  1876.             </table></td>
    1877. 

  1877. 		  </form>
    1878. 

  1878.         </tr>
    1879. 

  1879.       </table>
    1880. 

  1880. <?php
    1881. 

  1881. }
    1882. 

  1882. ?>
    1883. 

  1883. 

  1884.