PageRenderTime 72ms CodeModel.GetById 31ms RepoModel.GetById 0ms app.codeStats 1ms

/application/views/pages/admin/discounts.php

https://bitbucket.org/chadsaun/ifrogz-panel
PHP | 1627 lines | 1506 code | 36 blank | 85 comment | 306 complexity | ea6f168c0ca5b268ebb1e86e894997b0 MD5 | raw file

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

    

  1. <?php
    2. 

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

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

  4. //Business Solutions SL. Any use, reproduction, disclosure or copying of any kind 
    5. 

  5. //without the express and written permission of Internet Business Solutions SL is forbidden.
    6. 

  6. //Author: Vince Reid, vince@virtualred.net
    7. 

  7. if(@$storesessionvalue=="") $storesessionvalue="virtualstore".time();
    8. 

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

  9. $success=TRUE;
    10. 

  10. $sSQL = "";
    11. 

  11. $alreadygotadmin = getadminsettings();
    12. 

  12. if (@$_POST["posted"]=="1") {
    13. 

  13. 	if (@$_POST["act"]=="delete") {
    14. 

  14. 		$sSQL = "DELETE FROM cpnassign WHERE cpaCpnID=" . @$_POST["id"];
    15. 

  15. 		mysql_query($sSQL) or print(mysql_error());
    16. 

  16. 		$sSQL = "DELETE FROM coupons WHERE cpnID=" . @$_POST["id"];
    17. 

  17. 		mysql_query($sSQL) or print(mysql_error());
    18. 

  18. 		print '<meta http-equiv="refresh" content="3; url=/admin/discounts.php">';
    19. 

  19. 	}
    20. 

  20. 	else if (@$_POST["act"]=="deleteGrp") {
    21. 

  21. 		$sql = "DELETE FROM grpCpn WHERE grpCpnID = ". @$_POST["id"];
    22. 

  22. 		mysql_query($sql) or print(mysql_error());
    23. 

  23. 		$sql = "SELECT * FROM coupons WHERE cpnGrpCpnID = '".@$_POST["id"]."'";
    24. 

  24. 		$res = mysql_query($sql) or print(mysql_error());
    25. 

  25. 		$coupons = '';
    26. 

  26. 		if(mysql_num_rows($res) > 0) {
    27. 

  27. 			for($i=0; $row = mysql_fetch_assoc($res); $i++) {
    28. 

  28. 				$coupons .= $row['cpnID'];
    29. 

  29. 				if($i+1!=mysql_num_rows($res)) {
    30. 

  30. 					$coupons .= ",";
    31. 

  31. 				}
    32. 

  32. 			}
    33. 

  33. 		}
    34. 

  34. 		$sql = "DELETE FROM coupons WHERE cpnGrpCpnID = '".@$_POST["id"]."'";
    35. 

  35. 		mysql_query($sql) or print(mysql_error());
    36. 

  36. 		$sql = "DELETE FROM cpnassign WHERE cpaCpnID IN($coupons)";
    37. 

  37. 		mysql_query($sql) or print(mysql_error());
    38. 

  38. 		print '<meta http-equiv="refresh" content="3; url=/admin/discounts.php">';
    39. 

  39. 	}
    40. 

  40. 	else if (@$_POST["act"]=="domodify") {
    41. 

  41. 		// Creates lock
    42. 

  42. 		$lSQL = 'LOCK TABLES coupons WRITE, fsadiscount WRITE;';
    43. 

  43.         mysql_query($lSQL) or print(mysql_error().'<br />'.$lSQL);
    44. 

  44.         // Updates coupon
    45. 

  45. 		$sSQL = "UPDATE coupons SET cpnName='" . mysql_real_escape_string(unstripslashes(@$_POST["cpnName"])) . "'";
    46. 

  46. 			for($index=2; $index <= $adminlanguages+1; $index++){
    47. 

  47. 				if(($adminlangsettings & 1024)==1024) $sSQL .= ",cpnName" . $index . "='" . mysql_real_escape_string(unstripslashes(@$_POST["cpnName" . $index])) . "'";
    48. 

  48. 			}
    49. 

  49. 			if(trim(@$_POST["cpnWorkingName"]) != "")
    50. 

  50. 				$sSQL .= ",cpnWorkingName='" . mysql_real_escape_string(unstripslashes(@$_POST["cpnWorkingName"])) . "'";
    51. 

  51. 			else
    52. 

  52. 				$sSQL .= ",cpnWorkingName='" . mysql_real_escape_string(unstripslashes(@$_POST["cpnName"])) . "'";
    53. 

  53. 			if(@$_POST["cpnIsCoupon"]=="0")
    54. 

  54. 				$sSQL .= ",cpnNumber='',";
    55. 

  55. 			else
    56. 

  56. 				$sSQL .= ",cpnNumber='" . mysql_real_escape_string(unstripslashes(@$_POST["cpnNumber"])) . "',";
    57. 

  57. 			$sSQL .= "cpnType=" . @$_POST["cpnType"] . ",";
    58. 

  58. 			/*$numdays=0;
    59. 

  59. 			if(is_numeric(@$_POST["cpnEndDate"])) $numdays = (int)@$_POST["cpnEndDate"];
    60. 

  60. 			if($numdays > 0)
    61. 

  61. 				$sSQL .= "cpnEndDate='" . date("Y-m-d",(time() + ($numdays*60*60*24))) . "',";
    62. 

  62. 			else
    63. 

  63. 				$sSQL .= "cpnEndDate='3000-01-01',";*/
    64. 

  64. 			if (!empty($_POST["cpnEndDate"])) {
    65. 

  65. 				$sSQL .= "cpnEndDate='" . $_POST["cpnEndDate"] . "',";
    66. 

  66. 			} else {
    67. 

  67. 				$sSQL .= "cpnEndDate='3000-01-01',";
    68. 

  68. 			}
    69. 

  69. 			if (!empty($_POST["cpnBeginDate"])) {
    70. 

  70. 				$sSQL .= "cpnBeginDate='" . $_POST["cpnBeginDate"] . "',";
    71. 

  71. 			} else {
    72. 

  72. 				$sSQL .= "cpnBeginDate='0000-00-00 00:00:00',";
    73. 

  73. 			}
    74. 

  74. 			if(is_numeric(@$_POST["cpnDiscount"]) && @$_POST["cpnType"] != "0")
    75. 

  75. 				$sSQL .= "cpnDiscount=" . @$_POST["cpnDiscount"] . ",";
    76. 

  76. 			else
    77. 

  77. 				$sSQL .= "cpnDiscount=0,";
    78. 

  78. 			if(is_numeric(@$_POST["cpnThreshold"]))
    79. 

  79. 				$sSQL .= "cpnThreshold=" . @$_POST["cpnThreshold"] . ",";
    80. 

  80. 			else
    81. 

  81. 				$sSQL .= "cpnThreshold=0,";
    82. 

  82. 			if(is_numeric(@$_POST["cpnThresholdMax"]))
    83. 

  83. 				$sSQL .= "cpnThresholdMax=" . @$_POST["cpnThresholdMax"] . ",";
    84. 

  84. 			else
    85. 

  85. 				$sSQL .= "cpnThresholdMax=0,";
    86. 

  86. 			if(is_numeric(@$_POST["cpnThresholdRepeat"]))
    87. 

  87. 				$sSQL .= "cpnThresholdRepeat=" . @$_POST["cpnThresholdRepeat"] . ",";
    88. 

  88. 			else
    89. 

  89. 				$sSQL .= "cpnThresholdRepeat=0,";
    90. 

  90. 			if(is_numeric(@$_POST["cpnQuantity"]))
    91. 

  91. 				$sSQL .= "cpnQuantity=" . @$_POST["cpnQuantity"] . ",";
    92. 

  92. 			else
    93. 

  93. 				$sSQL .= "cpnQuantity=0,";
    94. 

  94. 			if(is_numeric(@$_POST["cpnQuantityMax"]))
    95. 

  95. 				$sSQL .= "cpnQuantityMax=" . @$_POST["cpnQuantityMax"] . ",";
    96. 

  96. 			else
    97. 

  97. 				$sSQL .= "cpnQuantityMax=0,";
    98. 

  98. 			if(is_numeric(@$_POST["cpnQuantityRepeat"]))
    99. 

  99. 				$sSQL .= "cpnQuantityRepeat=" . @$_POST["cpnQuantityRepeat"] . ",";
    100. 

  100. 			else
    101. 

  101. 				$sSQL .= "cpnQuantityRepeat=0,";
    102. 

  102. 			if(trim(@$_POST["cpnNumAvail"]) != "" && is_numeric(@$_POST["cpnNumAvail"]))
    103. 

  103. 				$sSQL .= "cpnNumAvail=" . @$_POST["cpnNumAvail"] . ",";
    104. 

  104. 			else
    105. 

  105. 				$sSQL .= "cpnNumAvail=30000000,";
    106. 

  106. 			if(@$_POST["cpnType"]=="0")
    107. 

  107. 				$sSQL .= "cpnCntry=" . @$_POST["cpnCntry"] . ",";
    108. 

  108. 			else
    109. 

  109. 				$sSQL .= "cpnCntry=0,";
    110. 

  110. 			$sSQL .= "cpnIsCoupon=" . @$_POST["cpnIsCoupon"] . ",";
    111. 

  111. 			if(@$_POST["cpnType"]=="0")
    112. 

  112. 				$sSQL .= "cpnSitewide=1,";
    113. 

  113. 			else
    114. 

  114. 				$sSQL .= "cpnSitewide=" . @$_POST["cpnSitewide"]. ",";
    115. 

  115. 			//wholesale only coupon added by Blake 6-6-06
    116. 

  116. 			if(@$_POST["cpnIsWholesale"]=="")
    117. 

  117. 				$sSQL .= "cpnIsWholesale = 0,";
    118. 

  118. 			else
    119. 

  119. 				$sSQL .= "cpnIsWholesale = " . @$_POST["cpnIsWholesale"] . ",";
    120. 

  120. 			//
    121. 

  121. 			if ($_POST["cpnStackable"] == "") {
    122. 

  122. 				$sSQL .= "cpnStackable = 0";
    123. 

  123. 			} else {
    124. 

  124. 				$sSQL .= "cpnStackable = " . $_POST["cpnStackable"];
    125. 

  125. 			}
    126. 

  126. 			$sSQL .= " WHERE cpnID=" . @$_POST["id"];
    127. 

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

  128. 		$cpnID = @$_POST["id"];
    129. 

  129. 

  130. 		if ($_POST['cpnType'] == 0) {
    131. 

  131.     		$sSQL = "SELECT * FROM fsadiscount WHERE cpnID = {$cpnID};";
    132. 

  132.     		
    133. 

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

  134. 

  135.     		$buffer = array();
    136. 

  136.     		while ($record = mysql_fetch_assoc($result)) {
    137. 

  137.     			$buffer[] = $record;
    138. 

  138.     		}
    139. 

  139.     		
    140. 

  140.     		mysql_free_result($result);
    141. 

  141. 

  142. 			if (isset($_POST['pz'])) {
    143. 

  143.             	foreach ($_POST['pz'] as $pz) {
    144. 

  144. 	                $data = explode(',', $pz); // 0 = pzID, 1 = methodID
    145. 

  145. 	                $doInsert = TRUE;
    146. 

  146. 	                foreach ($buffer as &$record) {
    147. 

  147. 	                    if (($data[0] == $record['pzID']) && ($data[1] == $record['methodID'])) { 
    148. 

  148. 							$record = NULL;
    149. 

  149. 	                        $doInsert = FALSE;
    150. 

  150. 	                        break;
    151. 

  151. 	                    }
    152. 

  152. 	                }
    153. 

  153. 					unset($record);
    154. 

  154. 	                if ($doInsert) {
    155. 

  155. 	                    $iSQL = "INSERT INTO fsadiscount (cpnID, pzID, methodID) VALUES ({$cpnID}, {$data[0]}, {$data[1]});";
    156. 

  156. 	                    mysql_query($iSQL) or print(mysql_error().'<br />'.$iSQL);
    157. 

  157. 	                }
    158. 

  158. 	            }
    159. 

  159. 			}
    160. 

  160. 

  161.             foreach ($buffer as $record) {
    162. 

  162.                 if ($record != NULL) {
    163. 

  163. 					$dSQL = "DELETE FROM fsadiscount WHERE ID = {$record['ID']};";
    164. 

  164. 	                mysql_query($dSQL) or print(mysql_error().'<br />'.$dSQL);
    165. 

  165. 				}
    166. 

  166.             }
    167. 

  167.         }
    168. 

  168. 

  169.         $uSQL = 'UNLOCK TABLES;';
    170. 

  170.         mysql_query($uSQL) or print(mysql_error().'<br />'.$uSQL);
    171. 

  171. 

  172. 		print '<meta http-equiv="refresh" content="3; url=/admin/discounts.php">';
    173. 

  173. 	}
    174. 

  174. 	else if (@$_POST["act"]=="doaddnew") {
    175. 

  175. 		if (!empty($_POST['cpnIsGrp'])) {
    176. 

  176. 			/*
    177. 

  177. 			// Creates lock
    178. 

  178. 			$lSQL = 'LOCK TABLES coupons WRITE, fsadiscount WRITE;';
    179. 

  179.             mysql_query($lSQL) or print(mysql_error().'<br />'.$lSQL);
    180. 

  180.             // Inserts new coupon
    181. 

  181. 			*/
    182. 

  182. 			$qty = $_POST['grpQty'];
    183. 

  183. 			
    184. 

  184. 			if ($_POST['linkGrp']!="none") {
    185. 

  185. 				$sql_orig_grp = "SELECT * FROM coupons WHERE cpnGrpCpnID = ".$_POST['linkGrp'];
    186. 

  186. 				$res_orig_grp = mysql_query($sql_orig_grp) or print(mysql_error());
    187. 

  187. 				$qty = mysql_num_rows($res_orig_grp);
    188. 

  188. 			}
    189. 

  189. 			
    190. 

  190. 			$sql = "INSERT INTO grpCpn (grpCpnName, grpCpnQty";
    191. 

  191. 			if ($_POST['linkGrp']!="none") {
    192. 

  192. 				$sql .= ",grpCpnLinkID)";
    193. 

  193. 			}
    194. 

  194. 			else{
    195. 

  195. 				$sql .= ") ";
    196. 

  196. 			}
    197. 

  197. 			$sql .= "VALUES ('".$_POST['grpName']."',".$qty;
    198. 

  198. 			if($_POST['linkGrp']!="none") {
    199. 

  199. 				$sql .= ",".$_POST['linkGrp'].")";
    200. 

  200. 			}
    201. 

  201. 			else{
    202. 

  202. 				$sql .= ")";
    203. 

  203. 			}
    204. 

  204. 			$res = mysql_query($sql) or die(mysql_error());
    205. 

  205. 			$lastID = mysql_insert_id();
    206. 

  206. 						
    207. 

  207. 			for($i=0; $i<$qty; $i++) {
    208. 

  208. 				if($_POST['linkGrp']!="none") {
    209. 

  209. 					$row_orig_grp = mysql_fetch_assoc($res_orig_grp);
    210. 

  210. 					$promoCode = $row_orig_grp['cpnNumber'];
    211. 

  211. 					$cpnEnd = $row_orig_grp['cpnEndDate'];
    212. 

  212. 					$cpnBegin = $row_orig_grp['cpnBeginDate'];	
    213. 

  213. 				}else{
    214. 

  214. 					$promoCode = getPromoCode();
    215. 

  215. 					$cpnEnd = @$_POST["cpnEndDate"];
    216. 

  216. 					$cpnBegin = @$_POST["cpnBeginDate"];
    217. 

  217. 				}
    218. 

  218. 				$sSQL = "INSERT INTO coupons (cpnName";
    219. 

  219. 					for($index=2; $index <= $adminlanguages+1; $index++){
    220. 

  220. 						if(($adminlangsettings & 1024)==1024) $sSQL .= ",cpnName" . $index;
    221. 

  221. 					}
    222. 

  222. 					$sSQL .= ",cpnWorkingName,cpnNumber,cpnType,cpnEndDate,cpnDiscount,cpnThreshold,cpnThresholdMax,cpnThresholdRepeat,cpnQuantity,cpnQuantityMax,cpnQuantityRepeat,cpnNumAvail,cpnCntry,cpnIsCoupon,cpnSitewide,cpnIsWholesale,cpnGrpCpnID,cpnBeginDate, cpnStackable) VALUES (";
    223. 

  223. 					$sSQL .= "'" . mysql_real_escape_string(unstripslashes(@$_POST["cpnName"])) . "',";
    224. 

  224. 					for($index=2; $index <= $adminlanguages+1; $index++){
    225. 

  225. 						if(($adminlangsettings & 1024)==1024) $sSQL .= "'" . mysql_real_escape_string(unstripslashes(@$_POST["cpnName" . $index])) . "',";
    226. 

  226. 					}
    227. 

  227. 					if(trim(@$_POST["cpnWorkingName"]) != "")
    228. 

  228. 						$sSQL .= "'" . mysql_real_escape_string(unstripslashes(@$_POST["cpnWorkingName"])) . "',";
    229. 

  229. 					else
    230. 

  230. 						$sSQL .= "'" . mysql_real_escape_string(unstripslashes(@$_POST["cpnName"])) . "',";
    231. 

  231. 					if(@$_POST["cpnIsCoupon"]=="0")
    232. 

  232. 						$sSQL .= "'',";
    233. 

  233. 					else
    234. 

  234. 						$sSQL .= "'" . mysql_real_escape_string($promoCode) . "',";
    235. 

  235. 					$sSQL .= @$_POST["cpnType"] . ",";
    236. 

  236. 					/*$numdays=0;
    237. 

  237. 					if(is_numeric($cpnEnd) && $_POST['linkGrp']=="none") $numdays = (int)$cpnEnd;
    238. 

  238. 					if($numdays > 0 && $_POST['linkGrp']=="none")
    239. 

  239. 						$sSQL .= "'" . date("Y-m-d",(time() + ($numdays*60*60*24))) . "',";
    240. 

  240. 					elseif($_POST['linkGrp']!="none")
    241. 

  241. 						$sSQL .= "'".$cpnEnd."',";
    242. 

  242. 					else
    243. 

  243. 						$sSQL .= "'3000-01-01',";*/
    244. 

  244. 					if (!empty($cpnEnd)) {
    245. 

  245. 						$sSQL .= "'" . $cpnEnd . "',";
    246. 

  246. 					} else {
    247. 

  247. 						$sSQL .= "'3000-01-01 00:00:00',";
    248. 

  248. 					}
    249. 

  249. 					if(is_numeric(@$_POST["cpnDiscount"]) && @$_POST["cpnType"] != "0")
    250. 

  250. 						$sSQL .= @$_POST["cpnDiscount"] . ",";
    251. 

  251. 					else
    252. 

  252. 						$sSQL .= "0,";
    253. 

  253. 					if(is_numeric(@$_POST["cpnThreshold"]))
    254. 

  254. 						$sSQL .= @$_POST["cpnThreshold"] . ",";
    255. 

  255. 					else
    256. 

  256. 						$sSQL .= "0,";
    257. 

  257. 					if(is_numeric(@$_POST["cpnThresholdMax"]))
    258. 

  258. 						$sSQL .= @$_POST["cpnThresholdMax"] . ",";
    259. 

  259. 					else
    260. 

  260. 						$sSQL .= "0,";
    261. 

  261. 					if(is_numeric(@$_POST["cpnThresholdRepeat"]))
    262. 

  262. 						$sSQL .= @$_POST["cpnThresholdRepeat"] . ",";
    263. 

  263. 					else
    264. 

  264. 						$sSQL .= "0,";
    265. 

  265. 					if(is_numeric(@$_POST["cpnQuantity"]))
    266. 

  266. 						$sSQL .= @$_POST["cpnQuantity"] . ",";
    267. 

  267. 					else
    268. 

  268. 						$sSQL .= "0,";
    269. 

  269. 					if(is_numeric(@$_POST["cpnQuantityMax"]))
    270. 

  270. 						$sSQL .= @$_POST["cpnQuantityMax"] . ",";
    271. 

  271. 					else
    272. 

  272. 						$sSQL .= "0,";
    273. 

  273. 					if(is_numeric(@$_POST["cpnQuantityRepeat"]))
    274. 

  274. 						$sSQL .= @$_POST["cpnQuantityRepeat"] . ",";
    275. 

  275. 					else
    276. 

  276. 						$sSQL .= "0,";
    277. 

  277. 					if(trim(@$_POST["cpnNumAvail"]) != "" && is_numeric(@$_POST["cpnNumAvail"]))
    278. 

  278. 						$sSQL .= @$_POST["cpnNumAvail"] . ",";
    279. 

  279. 					else
    280. 

  280. 						$sSQL .= "30000000,";
    281. 

  281. 					if(@$_POST["cpnType"]=="0")
    282. 

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

  283. 					else
    284. 

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

  285. 					$sSQL .= @$_POST["cpnIsCoupon"] . ",";
    286. 

  286. 					if(@$_POST["cpnType"]=="0")
    287. 

  287. 						$sSQL .= "1,";
    288. 

  288. 					else
    289. 

  289. 						$sSQL .= @$_POST["cpnSitewide"] . ",";
    290. 

  290. 					//wholesale only coupon added by Blake 6-6-06
    291. 

  291. 					if(@$_POST["cpnIsWholesale"]=="")
    292. 

  292. 						$sSQL .= "0,";
    293. 

  293. 					else
    294. 

  294. 						$sSQL .= @$_POST["cpnIsWholesale"] . ",";
    295. 

  295. 					//
    296. 

  296. 					$sSQL .= "'" .$lastID . "',";
    297. 

  297. 					if (!empty($cpnBegin)) {	
    298. 

  298. 						$sSQL .= "'" . $cpnBegin . "',";
    299. 

  299. 					} else {
    300. 

  300. 						$sSQL .= "'0000-00-00 00:00:00',";
    301. 

  301. 					}
    302. 

  302. 					if ($_POST["cpnStackable"] == "") {
    303. 

  303. 						$sSQL .= "0)";
    304. 

  304. 					} else {
    305. 

  305. 						$sSQL .= $_POST["cpnStackable"] . ")";
    306. 

  306. 					}
    307. 

  307. 				mysql_query($sSQL) or print(mysql_error());
    308. 

  308. 				/*
    309. 

  309. 				$cpnID = mysql_insert_id();
    310. 

  310.     			if (($_POST['cpnType'] == 0) && isset($_POST['pz']) && (count($_POST['pz']) > 0)) {
    311. 

  311.                     foreach ($_POST['pz'] as $pz) {
    312. 

  312.                         $data = explode(',', $pz); // 0 = pzID, 1 = methodID
    313. 

  313.                         $iSQL = "INSERT INTO fsadiscount (cpnID, pzID, methodID) VALUES ({$cpnID}, {$data[0]}, {$data[1]});";
    314. 

  314.                         mysql_query($iSQL) or print(mysql_error().'<br />'.$iSQL);
    315. 

  315.                     }
    316. 

  316.                 }
    317. 

  317.                 $uSQL = 'UNLOCK TABLES;';
    318. 

  318.                 mysql_query($uSQL) or print(mysql_error().'<br />'.$uSQL);
    319. 

  319.                 */
    320. 

  320. 			}
    321. 

  321. 		}
    322. 

  322. 		else { // doaddnew: non-group
    323. 

  323. 			// Creates lock
    324. 

  324. 			$lSQL = 'LOCK TABLES coupons WRITE, fsadiscount WRITE;';
    325. 

  325.             mysql_query($lSQL) or print(mysql_error().'<br />'.$lSQL);
    326. 

  326.             // Inserts new coupon
    327. 

  327. 			$sSQL = "INSERT INTO coupons (cpnName";
    328. 

  328. 			for($index=2; $index <= $adminlanguages+1; $index++){
    329. 

  329. 				if(($adminlangsettings & 1024)==1024) $sSQL .= ",cpnName" . $index;
    330. 

  330. 			}
    331. 

  331. 			$sSQL .= ",cpnWorkingName,cpnNumber,cpnType,cpnEndDate,cpnDiscount,cpnThreshold,cpnThresholdMax,cpnThresholdRepeat,cpnQuantity,cpnQuantityMax,cpnQuantityRepeat,cpnNumAvail,cpnCntry,cpnIsCoupon,cpnSitewide,cpnIsWholesale,cpnBeginDate, cpnStackable) VALUES (";
    332. 

  332. 			$sSQL .= "'" . mysql_real_escape_string(unstripslashes(@$_POST["cpnName"])) . "',";
    333. 

  333. 			for($index=2; $index <= $adminlanguages+1; $index++){
    334. 

  334. 				if(($adminlangsettings & 1024)==1024) $sSQL .= "'" . mysql_real_escape_string(unstripslashes(@$_POST["cpnName" . $index])) . "',";
    335. 

  335. 			}
    336. 

  336. 			if(trim(@$_POST["cpnWorkingName"]) != "")
    337. 

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

  338. 			else
    339. 

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

  340. 			if(@$_POST["cpnIsCoupon"]=="0")
    341. 

  341. 				$sSQL .= "'',";
    342. 

  342. 			else
    343. 

  343. 				$sSQL .= "'" . mysql_real_escape_string(unstripslashes(@$_POST["cpnNumber"])) . "',";
    344. 

  344. 			$sSQL .= @$_POST["cpnType"] . ",";
    345. 

  345. 			/*$numdays=0;
    346. 

  346. 			if(is_numeric(@$_POST["cpnEndDate"])) $numdays = (int)@$_POST["cpnEndDate"];
    347. 

  347. 			if($numdays > 0)
    348. 

  348. 				$sSQL .= "'" . date("Y-m-d",(time() + ($numdays*60*60*24))) . "',";
    349. 

  349. 			else
    350. 

  350. 				$sSQL .= "'3000-01-01',";*/
    351. 

  351. 			if (!empty($_POST["cpnEndDate"])) {
    352. 

  352. 				$sSQL .= "'" . $_POST["cpnEndDate"] . "',";
    353. 

  353. 			} else {
    354. 

  354. 				$sSQL .= "'3000-01-01 00:00:00',";
    355. 

  355. 			}
    356. 

  356. 			if(is_numeric(@$_POST["cpnDiscount"]) && @$_POST["cpnType"] != "0")
    357. 

  357. 				$sSQL .= @$_POST["cpnDiscount"] . ",";
    358. 

  358. 			else
    359. 

  359. 				$sSQL .= "0,";
    360. 

  360. 			if(is_numeric(@$_POST["cpnThreshold"]))
    361. 

  361. 				$sSQL .= @$_POST["cpnThreshold"] . ",";
    362. 

  362. 			else
    363. 

  363. 				$sSQL .= "0,";
    364. 

  364. 			if(is_numeric(@$_POST["cpnThresholdMax"]))
    365. 

  365. 				$sSQL .= @$_POST["cpnThresholdMax"] . ",";
    366. 

  366. 			else
    367. 

  367. 				$sSQL .= "0,";
    368. 

  368. 			if(is_numeric(@$_POST["cpnThresholdRepeat"]))
    369. 

  369. 				$sSQL .= @$_POST["cpnThresholdRepeat"] . ",";
    370. 

  370. 			else
    371. 

  371. 				$sSQL .= "0,";
    372. 

  372. 			if(is_numeric(@$_POST["cpnQuantity"]))
    373. 

  373. 				$sSQL .= @$_POST["cpnQuantity"] . ",";
    374. 

  374. 			else
    375. 

  375. 				$sSQL .= "0,";
    376. 

  376. 			if(is_numeric(@$_POST["cpnQuantityMax"]))
    377. 

  377. 				$sSQL .= @$_POST["cpnQuantityMax"] . ",";
    378. 

  378. 			else
    379. 

  379. 				$sSQL .= "0,";
    380. 

  380. 			if(is_numeric(@$_POST["cpnQuantityRepeat"]))
    381. 

  381. 				$sSQL .= @$_POST["cpnQuantityRepeat"] . ",";
    382. 

  382. 			else
    383. 

  383. 				$sSQL .= "0,";
    384. 

  384. 			if(trim(@$_POST["cpnNumAvail"]) != "" && is_numeric(@$_POST["cpnNumAvail"]))
    385. 

  385. 				$sSQL .= @$_POST["cpnNumAvail"] . ",";
    386. 

  386. 			else
    387. 

  387. 				$sSQL .= "30000000,";
    388. 

  388. 			if(@$_POST["cpnType"]=="0")
    389. 

  389. 				$sSQL .= @$_POST["cpnCntry"] . ",";
    390. 

  390. 			else
    391. 

  391. 				$sSQL .= "0,";
    392. 

  392. 			$sSQL .= @$_POST["cpnIsCoupon"] . ",";
    393. 

  393. 			if(@$_POST["cpnType"]=="0")
    394. 

  394. 				$sSQL .= "1,";
    395. 

  395. 			else
    396. 

  396. 				$sSQL .= @$_POST["cpnSitewide"]  . ",";
    397. 

  397. 			//wholesale only coupon added by Blake 6-6-06
    398. 

  398. 			if(@$_POST["cpnIsWholesale"]=="")
    399. 

  399. 				$sSQL .= "0,";
    400. 

  400. 			else
    401. 

  401. 				$sSQL .= @$_POST["cpnIsWholesale"]. ",";
    402. 

  402. 			if (!empty($_POST["cpnBeginDate"])) {
    403. 

  403. 				$sSQL .= "'" . $_POST["cpnBeginDate"] . "',";
    404. 

  404. 			}
    405. 

  405. 			else {
    406. 

  406. 				$sSQL .= "'0000-00-00 00:00:00',";
    407. 

  407. 			}
    408. 

  408. 			if ($_POST["cpnStackable"] == "") {
    409. 

  409. 				$sSQL .= "0)";
    410. 

  410. 			}
    411. 

  411. 			else {
    412. 

  412. 				$sSQL .= $_POST["cpnStackable"] . ")";
    413. 

  413. 			}
    414. 

  414. 			mysql_query($sSQL) or print(mysql_error().'<br />'.$sSQL);
    415. 

  415. 			$cpnID = mysql_insert_id();
    416. 

  416. 			if (($_POST['cpnType'] == 0) && isset($_POST['pz']) && (count($_POST['pz']) > 0)) {
    417. 

  417.                 foreach ($_POST['pz'] as $pz) {
    418. 

  418.                     $data = explode(',', $pz); // 0 = pzID, 1 = methodID
    419. 

  419.                     $iSQL = "INSERT INTO fsadiscount (cpnID, pzID, methodID) VALUES ({$cpnID}, {$data[0]}, {$data[1]});";
    420. 

  420.                     mysql_query($iSQL) or print(mysql_error().'<br />'.$iSQL);
    421. 

  421.                 }
    422. 

  422.             }
    423. 

  423.             $uSQL = 'UNLOCK TABLES;';
    424. 

  424.             mysql_query($uSQL) or print(mysql_error().'<br />'.$uSQL);
    425. 

  425. 		}
    426. 

  426. 		print '<meta http-equiv="refresh" content="3; url=/admin/discounts.php">';
    427. 

  427. 	}
    428. 

  428. }
    429. 

  429. ?>
    430. 

  430. <link rel="stylesheet" type="text/css" media="all" href="http://assets.ifrogz.com/lib/packages/jscalendar/1.0/calendar-blue2.css" title="win2k-cold-1" />
    431. 

  431. 

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

  433. <script language="JavaScript" type="text/javascript" src="http://assets.ifrogz.com/lib/packages/jscalendar/1.0/calendar.js"></script>
    434. 

  434. <script language="JavaScript" type="text/javascript" src="http://assets.ifrogz.com/lib/packages/jscalendar/1.0/lang/calendar-en.js"></script>
    435. 

  435. <script language="JavaScript" type="text/javascript" src="http://assets.ifrogz.com/lib/packages/jscalendar/1.0/calendar-setup.js"></script>
    436. 

  436. <script language="JavaScript" type="text/javascript" src="http://assets.ifrogz.com/lib/packages/jquery/1.4.2/jquery.min.js"></script>
    437. 

  437. <script language="JavaScript" type="text/javascript">
    438. 

  438. <!--
    439. 

  439. jQuery.noConflict();
    440. 

  440. var savebg, savebc, savecol;
    441. 

  441. function formvalidator(theForm)
    442. 

  442. {
    443. 

  443. <?php
    444. 

  444. if($_POST['act']=="addnew") {
    445. 

  445. ?>
    446. 

  446.   if($F('cpnIsGrp')==1 && $F('grpQty') == '' && $F('linkGrp')=='none') {
    447. 

  447.     alert("<?php print $yyPlsEntr?> \"<?php print $yyNumCpn?>\".");
    448. 

  448.     theForm.grpQty.focus();
    449. 

  449.     return (false);
    450. 

  450.   }
    451. 

  451.   if($F('cpnIsGrp')==1 && $F('grpName') == '') {
    452. 

  452.     alert("<?php print $yyPlsEntr?> \"<?php print $yyGrpName?>\".");
    453. 

  453.     theForm.grpName.focus();
    454. 

  454.     return (false);
    455. 

  455.   }
    456. 

  456. <?php
    457. 

  457. }
    458. 

  458. ?>
    459. 

  459.   if(theForm.cpnName.value == "")
    460. 

  460.   {
    461. 

  461.     alert("<?php print $yyPlsEntr?> \"<?php print $yyDisTxt?>\".");
    462. 

  462.     theForm.cpnName.focus();
    463. 

  463.     return (false);
    464. 

  464.   }
    465. 

  465.   if(theForm.cpnName.value.length > 255)
    466. 

  466.   {
    467. 

  467.     alert("<?php print $yyMax255?> \"<?php print $yyDisTxt?>\".");
    468. 

  468.     theForm.cpnName.focus();
    469. 

  469.     return (false);
    470. 

  470.   }
    471. 

  471.   if(theForm.cpnType.selectedIndex!=0){
    472. 

  472. 	if(theForm.cpnDiscount.value == "")
    473. 

  473. 	{
    474. 

  474. 	  alert("<?php print $yyPlsEntr?> \"<?php print $yyDscAmt?>\".");
    475. 

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

  476. 	  return (false);
    477. 

  477. 	}
    478. 

  478. 	if(theForm.cpnType.selectedIndex==2){
    479. 

  479. 	  if(theForm.cpnDiscount.value < 0 || theForm.cpnDiscount.value > 100){
    480. 

  480. 		alert("<?php print $yyNum100?> \"<?php print $yyDscAmt?>\".");
    481. 

  481. 		theForm.cpnDiscount.focus();
    482. 

  482. 		return (false);
    483. 

  483. 	  }
    484. 

  484. 	}
    485. 

  485.   }
    486. 

  486.   if(theForm.cpnIsCoupon.selectedIndex==1){
    487. 

  487. <?php
    488. 

  488. if($_POST['act']=="addnew") {
    489. 

  489. ?>
    490. 

  490.   	if($F('cpnIsGrp')!=1) {
    491. 

  491. <?php
    492. 

  492. }
    493. 

  493. ?>
    494. 

  494. 		if(theForm.cpnNumber.value == "")
    495. 

  495. 		{
    496. 

  496. 		  alert("<?php print $yyPlsEntr?> \"<?php print $yyCpnCod?>\".");
    497. 

  497. 		  theForm.cpnNumber.focus();
    498. 

  498. 		  return (false);
    499. 

  499. 		}
    500. 

  500. 		var checkOK = "0123456789abcdefghijklmnopqrstuvwxyz-_";
    501. 

  501. 		var checkStr = theForm.cpnNumber.value.toLowerCase();
    502. 

  502. 		var allValid = true;
    503. 

  503. 		for (i = 0;  i < checkStr.length;  i++)
    504. 

  504. 		{
    505. 

  505. 			ch = checkStr.charAt(i);
    506. 

  506. 			for (j = 0;  j < checkOK.length;  j++)
    507. 

  507. 				if (ch == checkOK.charAt(j))
    508. 

  508. 					break;
    509. 

  509. 			if (j == checkOK.length){
    510. 

  510. 				allValid = false;
    511. 

  511. 					break;
    512. 

  512. 			}
    513. 

  513. 		}
    514. 

  514. 		if (!allValid)
    515. 

  515. 		{
    516. 

  516. 			alert("<?php print $yyAlpha2?> \"<?php print $yyCpnCod?>\".");
    517. 

  517. 			theForm.cpnNumber.focus();
    518. 

  518. 			return (false);
    519. 

  519. 		}
    520. 

  520. <?php
    521. 

  521. if($_POST['act']=="addnew") {
    522. 

  522. ?>
    523. 

  523. 	}
    524. 

  524. <?php
    525. 

  525. }
    526. 

  526. ?>
    527. 

  527.   }
    528. 

  528.   var checkOK = "0123456789";
    529. 

  529.   var checkStr = theForm.cpnNumAvail.value;
    530. 

  530.   var allValid = true;
    531. 

  531.   for (i = 0;  i < checkStr.length;  i++)
    532. 

  532.   {
    533. 

  533. 	ch = checkStr.charAt(i);
    534. 

  534. 	for (j = 0;  j < checkOK.length;  j++)
    535. 

  535. 		if (ch == checkOK.charAt(j))
    536. 

  536. 			break;
    537. 

  537. 	if (j == checkOK.length){
    538. 

  538. 		allValid = false;
    539. 

  539. 			break;
    540. 

  540. 	}
    541. 

  541.   }
    542. 

  542.   if (!allValid)
    543. 

  543.   {
    544. 

  544. 	alert("<?php print $yyOnlyNum?> \"<?php print $yyNumAvl?>\".");
    545. 

  545. 	theForm.cpnNumAvail.focus();
    546. 

  546. 	return (false);
    547. 

  547.   }
    548. 

  548.   if(theForm.cpnNumAvail.value != "" && theForm.cpnNumAvail.value > 1000000)
    549. 

  549.   {
    550. 

  550.     alert("<?php print $yyNumMil?> \"<?php print $yyNumAvl?>\"<?php print $yyOrBlank?>");
    551. 

  551.     theForm.cpnNumAvail.focus();
    552. 

  552.     return (false);
    553. 

  553.   }
    554. 

  554.   /*
    555. 

  555.   var checkOK = "0123456789";
    556. 

  556.   var checkStr = theForm.cpnEndDate.value;
    557. 

  557.   var allValid = true;
    558. 

  558.   for (i = 0;  i < checkStr.length;  i++)
    559. 

  559.   {
    560. 

  560. 	ch = checkStr.charAt(i);
    561. 

  561. 	for (j = 0;  j < checkOK.length;  j++)
    562. 

  562. 		if (ch == checkOK.charAt(j))
    563. 

  563. 			break;
    564. 

  564. 	if (j == checkOK.length){
    565. 

  565. 		allValid = false;
    566. 

  566. 			break;
    567. 

  567. 	}
    568. 

  568.   }
    569. 

  569.   if (!allValid)
    570. 

  570.   {
    571. 

  571. 	alert("<?php print $yyOnlyNum?> \"<?php print $yyDaysAv?>\".");
    572. 

  572. 	theForm.cpnEndDate.focus();
    573. 

  573. 	return (false);
    574. 

  574.   }*/
    575. 

  575.   var checkOK = "0123456789.";
    576. 

  576.   var checkStr = theForm.cpnThreshold.value;
    577. 

  577.   var allValid = true;
    578. 

  578.   for (i = 0;  i < checkStr.length;  i++)
    579. 

  579.   {
    580. 

  580. 	ch = checkStr.charAt(i);
    581. 

  581. 	for (j = 0;  j < checkOK.length;  j++)
    582. 

  582. 		if (ch == checkOK.charAt(j))
    583. 

  583. 			break;
    584. 

  584. 	if (j == checkOK.length){
    585. 

  585. 		allValid = false;
    586. 

  586. 			break;
    587. 

  587. 	}
    588. 

  588.   }
    589. 

  589.   if (!allValid)
    590. 

  590.   {
    591. 

  591. 	alert("<?php print $yyOnlyDec?> \"<?php print $yyMinPur?>\".");
    592. 

  592. 	theForm.cpnThreshold.focus();
    593. 

  593. 	return (false);
    594. 

  594.   }
    595. 

  595.   var checkOK = "0123456789.";
    596. 

  596.   var checkStr = theForm.cpnThresholdRepeat.value;
    597. 

  597.   var allValid = true;
    598. 

  598.   for (i = 0;  i < checkStr.length;  i++)
    599. 

  599.   {
    600. 

  600. 	ch = checkStr.charAt(i);
    601. 

  601. 	for (j = 0;  j < checkOK.length;  j++)
    602. 

  602. 		if (ch == checkOK.charAt(j))
    603. 

  603. 			break;
    604. 

  604. 	if (j == checkOK.length){
    605. 

  605. 		allValid = false;
    606. 

  606. 			break;
    607. 

  607. 	}
    608. 

  608.   }
    609. 

  609.   if (!allValid)
    610. 

  610.   {
    611. 

  611. 	alert("<?php print $yyOnlyDec?> \"<?php print $yyRepEvy?>\".");
    612. 

  612. 	theForm.cpnThresholdRepeat.focus();
    613. 

  613. 	return (false);
    614. 

  614.   }
    615. 

  615.   var checkOK = "0123456789.";
    616. 

  616.   var checkStr = theForm.cpnThresholdMax.value;
    617. 

  617.   var allValid = true;
    618. 

  618.   for (i = 0;  i < checkStr.length;  i++)
    619. 

  619.   {
    620. 

  620. 	ch = checkStr.charAt(i);
    621. 

  621. 	for (j = 0;  j < checkOK.length;  j++)
    622. 

  622. 		if (ch == checkOK.charAt(j))
    623. 

  623. 			break;
    624. 

  624. 	if (j == checkOK.length){
    625. 

  625. 		allValid = false;
    626. 

  626. 			break;
    627. 

  627. 	}
    628. 

  628.   }
    629. 

  629.   if (!allValid)
    630. 

  630.   {
    631. 

  631. 	alert("<?php print $yyOnlyDec?> \"<?php print $yyMaxPur?>\".");
    632. 

  632. 	theForm.cpnThresholdMax.focus();
    633. 

  633. 	return (false);
    634. 

  634.   }
    635. 

  635.   var checkOK = "0123456789";
    636. 

  636.   var checkStr = theForm.cpnQuantity.value;
    637. 

  637.   var allValid = true;
    638. 

  638.   for (i = 0;  i < checkStr.length;  i++)
    639. 

  639.   {
    640. 

  640. 	ch = checkStr.charAt(i);
    641. 

  641. 	for (j = 0;  j < checkOK.length;  j++)
    642. 

  642. 		if (ch == checkOK.charAt(j))
    643. 

  643. 			break;
    644. 

  644. 	if (j == checkOK.length){
    645. 

  645. 		allValid = false;
    646. 

  646. 			break;
    647. 

  647. 	}
    648. 

  648.   }
    649. 

  649.   if (!allValid)
    650. 

  650.   {
    651. 

  651. 	alert("<?php print $yyOnlyNum?> \"<?php print $yyMinQua?>\".");
    652. 

  652. 	theForm.cpnQuantity.focus();
    653. 

  653. 	return (false);
    654. 

  654.   }
    655. 

  655.   var checkOK = "0123456789";
    656. 

  656.   var checkStr = theForm.cpnQuantityRepeat.value;
    657. 

  657.   var allValid = true;
    658. 

  658.   for (i = 0;  i < checkStr.length;  i++)
    659. 

  659.   {
    660. 

  660. 	ch = checkStr.charAt(i);
    661. 

  661. 	for (j = 0;  j < checkOK.length;  j++)
    662. 

  662. 		if (ch == checkOK.charAt(j))
    663. 

  663. 			break;
    664. 

  664. 	if (j == checkOK.length){
    665. 

  665. 		allValid = false;
    666. 

  666. 			break;
    667. 

  667. 	}
    668. 

  668.   }
    669. 

  669.   if (!allValid)
    670. 

  670.   {
    671. 

  671. 	alert("<?php print $yyOnlyNum?> \"<?php print $yyRepEvy?>\".");
    672. 

  672. 	theForm.cpnQuantityRepeat.focus();
    673. 

  673. 	return (false);
    674. 

  674.   }
    675. 

  675.   var checkOK = "0123456789";
    676. 

  676.   var checkStr = theForm.cpnQuantityMax.value;
    677. 

  677.   var allValid = true;
    678. 

  678.   for (i = 0;  i < checkStr.length;  i++)
    679. 

  679.   {
    680. 

  680. 	ch = checkStr.charAt(i);
    681. 

  681. 	for (j = 0;  j < checkOK.length;  j++)
    682. 

  682. 		if (ch == checkOK.charAt(j))
    683. 

  683. 			break;
    684. 

  684. 	if (j == checkOK.length){
    685. 

  685. 		allValid = false;
    686. 

  686. 			break;
    687. 

  687. 	}
    688. 

  688.   }
    689. 

  689.   if (!allValid)
    690. 

  690.   {
    691. 

  691. 	alert("<?php print $yyOnlyNum?> \"<?php print $yyMaxQua?>\".");
    692. 

  692. 	theForm.cpnQuantityMax.focus();
    693. 

  693. 	return (false);
    694. 

  694.   }
    695. 

  695.   var checkOK = "0123456789.";
    696. 

  696.   var checkStr = theForm.cpnDiscount.value;
    697. 

  697.   var allValid = true;
    698. 

  698.   for (i = 0;  i < checkStr.length;  i++)
    699. 

  699.   {
    700. 

  700. 	ch = checkStr.charAt(i);
    701. 

  701. 	for (j = 0;  j < checkOK.length;  j++)
    702. 

  702. 		if (ch == checkOK.charAt(j))
    703. 

  703. 			break;
    704. 

  704. 	if (j == checkOK.length){
    705. 

  705. 		allValid = false;
    706. 

  706. 			break;
    707. 

  707. 	}
    708. 

  708.   }
    709. 

  709.   if (!allValid)
    710. 

  710.   {
    711. 

  711. 	alert("<?php print $yyOnlyDec?> \"<?php print $yyDscAmt?>\".");
    712. 

  712. 	theForm.cpnDiscount.focus();
    713. 

  713. 	return (false);
    714. 

  714.   }
    715. 

  715.   document.mainform.cpnNumber.disabled=false;
    716. 

  716.   document.mainform.cpnDiscount.disabled=false;
    717. 

  717.   document.mainform.cpnCntry.disabled=false;
    718. 

  718.   document.mainform.cpnSitewide.disabled=false;
    719. 

  719.   document.mainform.cpnThresholdRepeat.disabled=false;
    720. 

  720.   document.mainform.cpnQuantityRepeat.disabled=false;
    721. 

  721.   return (true);
    722. 

  722. }
    723. 

  723. function couponcodeactive(forceactive){
    724. 

  724. 	if(document.mainform.cpnIsCoupon.selectedIndex==0){
    725. 

  725. 		document.mainform.cpnNumber.style.backgroundColor="#DDDDDD";
    726. 

  726. 		document.mainform.cpnNumber.style.borderColor="#aa3300";
    727. 

  727. 		document.mainform.cpnNumber.style.color="#aa3300";
    728. 

  728. 		document.mainform.cpnNumber.disabled=true;
    729. 

  729. 	}
    730. 

  730. 	else if(document.mainform.cpnIsCoupon.selectedIndex==1<?=($_POST['act']=='addnew')?' && $F("cpnIsGrp")==0':''?>){
    731. 

  731. 		document.mainform.cpnNumber.style.backgroundColor=savebg;
    732. 

  732. 		document.mainform.cpnNumber.style.borderColor=savebc;
    733. 

  733. 		document.mainform.cpnNumber.style.color=savecol;
    734. 

  734. 		document.mainform.cpnNumber.disabled=false;
    735. 

  735. 	}
    736. 

  736. }
    737. 

  737. function changecouponeffect(forceactive){
    738. 

  738. 	if(document.mainform.cpnType.selectedIndex==0){
    739. 

  739. 		document.mainform.cpnDiscount.style.backgroundColor="#DDDDDD";
    740. 

  740. 		document.mainform.cpnDiscount.style.borderColor="#aa3300";
    741. 

  741. 		document.mainform.cpnDiscount.style.color="#aa3300";
    742. 

  742. 		document.mainform.cpnDiscount.disabled=true;
    743. 

  743. 

  744. 		document.mainform.cpnCntry.style.backgroundColor=savebg;
    745. 

  745. 		document.mainform.cpnCntry.style.borderColor=savebc;
    746. 

  746. 		document.mainform.cpnCntry.style.color=savecol;
    747. 

  747. 		document.mainform.cpnCntry.disabled=false;
    748. 

  748. 

  749. 		document.mainform.cpnSitewide.style.backgroundColor="#DDDDDD";
    750. 

  750. 		document.mainform.cpnSitewide.style.borderColor="#aa3300";
    751. 

  751. 		document.mainform.cpnSitewide.style.color="#aa3300";
    752. 

  752. 		document.mainform.cpnSitewide.disabled=true;
    753. 

  753. 		jQuery('input.ShippingMethod').each(function() {
    754. 

  754.     		jQuery('input.ShippingMethod').removeAttr('disabled');
    755. 

  755.     	});
    756. 

  756. 	}else{
    757. 

  757. 		document.mainform.cpnDiscount.style.backgroundColor=savebg;
    758. 

  758. 		document.mainform.cpnDiscount.style.borderColor=savebc;
    759. 

  759. 		document.mainform.cpnDiscount.style.color=savecol;
    760. 

  760. 		document.mainform.cpnDiscount.disabled=false;
    761. 

  761. 

  762. 		document.mainform.cpnCntry.style.backgroundColor="#DDDDDD";
    763. 

  763. 		document.mainform.cpnCntry.style.borderColor="#aa3300";
    764. 

  764. 		document.mainform.cpnCntry.style.color="#aa3300";
    765. 

  765. 		document.mainform.cpnCntry.disabled=true;
    766. 

  766. 

  767. 		document.mainform.cpnSitewide.style.backgroundColor=savebg;
    768. 

  768. 		document.mainform.cpnSitewide.style.borderColor=savebc;
    769. 

  769. 		document.mainform.cpnSitewide.style.color=savecol;
    770. 

  770. 		document.mainform.cpnSitewide.disabled=false;
    771. 

  771. 		jQuery('input.ShippingMethod').each(function() {
    772. 

  772.     		jQuery('input.ShippingMethod').attr('disabled', 'disabled');
    773. 

  773.     	});
    774. 

  774. 	}
    775. 

  775. 	if(document.mainform.cpnType.selectedIndex==1){
    776. 

  776. 		document.mainform.cpnThresholdRepeat.style.backgroundColor=savebg;
    777. 

  777. 		document.mainform.cpnThresholdRepeat.style.borderColor=savebc;
    778. 

  778. 		document.mainform.cpnThresholdRepeat.style.color=savecol;
    779. 

  779. 		document.mainform.cpnThresholdRepeat.disabled=false;
    780. 

  780. 

  781. 		document.mainform.cpnQuantityRepeat.style.backgroundColor=savebg;
    782. 

  782. 		document.mainform.cpnQuantityRepeat.style.borderColor=savebc;
    783. 

  783. 		document.mainform.cpnQuantityRepeat.style.color=savecol;
    784. 

  784. 		document.mainform.cpnQuantityRepeat.disabled=false;
    785. 

  785. 	}else{
    786. 

  786. 		document.mainform.cpnThresholdRepeat.style.backgroundColor="#DDDDDD";
    787. 

  787. 		document.mainform.cpnThresholdRepeat.style.borderColor="#aa3300";
    788. 

  788. 		document.mainform.cpnThresholdRepeat.style.color="#aa3300";
    789. 

  789. 		document.mainform.cpnThresholdRepeat.disabled=true;
    790. 

  790. 

  791. 		document.mainform.cpnQuantityRepeat.style.backgroundColor="#DDDDDD";
    792. 

  792. 		document.mainform.cpnQuantityRepeat.style.borderColor="#aa3300";
    793. 

  793. 		document.mainform.cpnQuantityRepeat.style.color="#aa3300";
    794. 

  794. 		document.mainform.cpnQuantityRepeat.disabled=true;
    795. 

  795. 	}
    796. 

  796. }
    797. 

  797. 

  798. function cpnGrp(oSel) {
    799. 

  799. 	var val = $F('cpnIsGrp');
    800. 

  800. 	var aTR = document.getElementsByClassName('trGroup');
    801. 

  801. 	if(val == 1) {
    802. 

  802. 		for(i=0; i<aTR.length; i++) {
    803. 

  803. 			aTR[i].style.display = '';
    804. 

  804. 		}
    805. 

  805. 		$('cpnNumber').disabled=true;
    806. 

  806. 		$('cpnNumber').style.backgroundColor="#DDDDDD";
    807. 

  807. 		$('cpnNumber').style.borderColor="#aa3300";
    808. 

  808. 	}else{
    809. 

  809. 		for(i=0; i<aTR.length; i++) {
    810. 

  810. 			aTR[i].style.display = 'none';
    811. 

  811. 		}
    812. 

  812. 		$('grpQty').value = '';
    813. 

  813. 		$('linkGrp').selectedIndex = 0;
    814. 

  814. 		$('cpnNumber').disabled=false;
    815. 

  815. 		$('cpnNumber').style.backgroundColor="";
    816. 

  816. 		$('cpnNumber').style.borderColor="";
    817. 

  817. 	}
    818. 

  818. }
    819. 

  819. 

  820. function qty() {
    821. 

  821. 	if($F('linkGrp')!='none') {
    822. 

  822. 		$('grpQty').disabled=true;
    823. 

  823. 		$('grpQty').style.backgroundColor="#DDDDDD";
    824. 

  824. 		$('grpQty').style.borderColor="#aa3300";
    825. 

  825. 		
    826. 

  826. 		$('cpnEndDate').disabled=true;
    827. 

  827. 		$('cpnEndDate').style.backgroundColor="#DDDDDD";
    828. 

  828. 		$('cpnEndDate').style.borderColor="#aa3300";
    829. 

  829. 	}else{
    830. 

  830. 		$('grpQty').disabled=false;
    831. 

  831. 		$('grpQty').style.backgroundColor="";
    832. 

  832. 		$('grpQty').style.borderColor="";
    833. 

  833. 		
    834. 

  834. 		$('cpnEndDate').disabled=false;
    835. 

  835. 		$('cpnEndDate').style.backgroundColor="";
    836. 

  836. 		$('cpnEndDate').style.borderColor="";
    837. 

  837. 	}
    838. 

  838. }
    839. 

  839. //-->
    840. 

  840. </script>
    841. 

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

  842. <?php if(@$_POST["posted"]=="1" && (@$_POST["act"]=="modify" || @$_POST["act"]=="addnew")){
    843. 

  843. 		if(@$_POST["act"]=="modify"){
    844. 

  844. 			$sSQL = "SELECT cpnName,cpnName2,cpnName3,cpnWorkingName,cpnNumber,cpnType,cpnEndDate,cpnDiscount,cpnThreshold,cpnThresholdMax,cpnThresholdRepeat,cpnQuantity,cpnQuantityMax,cpnQuantityRepeat,cpnNumAvail,cpnCntry,cpnIsCoupon,cpnSitewide,cpnGrpCpnID,cpnIsWholesale,cpnBeginDate, cpnStackable FROM coupons WHERE cpnID=" . @$_POST["id"];
    845. 

  845. 			$result = mysql_query($sSQL) or print(mysql_error());
    846. 

  846. 			$rs = mysql_fetch_array($result);
    847. 

  847. 			$cpnName = $rs["cpnName"];
    848. 

  848. 			for($index=2; $index <= $adminlanguages+1; $index++) {
    849. 

  849. 				$cpnNames[$index] = $rs["cpnName" . $index];
    850. 

  850. 			}
    851. 

  851. 			$cpnWorkingName = $rs["cpnWorkingName"];
    852. 

  852. 			$cpnNumber = $rs["cpnNumber"];
    853. 

  853. 			$cpnType = $rs["cpnType"];
    854. 

  854. 			$cpnEndDate = $rs["cpnEndDate"];
    855. 

  855. 			$cpnDiscount = $rs["cpnDiscount"];
    856. 

  856. 			$cpnThreshold = $rs["cpnThreshold"];
    857. 

  857. 			$cpnThresholdMax = $rs["cpnThresholdMax"];
    858. 

  858. 			$cpnThresholdRepeat = $rs["cpnThresholdRepeat"];
    859. 

  859. 			$cpnQuantity = $rs["cpnQuantity"];
    860. 

  860. 			$cpnQuantityMax = $rs["cpnQuantityMax"];
    861. 

  861. 			$cpnQuantityRepeat = $rs["cpnQuantityRepeat"];
    862. 

  862. 			$cpnNumAvail = $rs["cpnNumAvail"];
    863. 

  863. 			$cpnCntry = $rs["cpnCntry"];
    864. 

  864. 			$cpnIsCoupon = $rs["cpnIsCoupon"];
    865. 

  865. 			$cpnSitewide = $rs["cpnSitewide"];
    866. 

  866. 			$cpnIsWholesale = $rs["cpnIsWholesale"];
    867. 

  867. 			$cpnIsGrp = $rs["cpnGrpCpnID"];
    868. 

  868. 			$cpnBeginDate = $rs["cpnBeginDate"];
    869. 

  869. 			$cpnStackable = $rs["cpnStackable"];
    870. 

  870. 			mysql_free_result($result);
    871. 

  871. 		}else{
    872. 

  872. 			$cpnName = "";
    873. 

  873. 			for($index=2; $index <= $adminlanguages+1; $index++)
    874. 

  874. 				$cpnNames[$index] = "";
    875. 

  875. 			$cpnWorkingName = "";
    876. 

  876. 			$cpnNumber = "";
    877. 

  877. 			$cpnType = 0;
    878. 

  878. 			$cpnEndDate = '3000-01-01 00:00:00';
    879. 

  879. 			$cpnDiscount = "";
    880. 

  880. 			$cpnThreshold = 0;
    881. 

  881. 			$cpnThresholdMax = 0;
    882. 

  882. 			$cpnThresholdRepeat = 0;
    883. 

  883. 			$cpnQuantity = 0;
    884. 

  884. 			$cpnQuantityMax = 0;
    885. 

  885. 			$cpnQuantityRepeat = 0;
    886. 

  886. 			$cpnNumAvail = 30000000;
    887. 

  887. 			$cpnCntry = 0;
    888. 

  888. 			$cpnIsCoupon = 0;
    889. 

  889. 			$cpnSitewide = 0;
    890. 

  890. 			$cpnIsGrp = 0;
    891. 

  891. 			$cpnBeginDate = '0000-00-00 00:00:00';
    892. 

  892. 			$cpnStackable = 1;
    893. 

  893. 		}
    894. 

  894. ?>
    895. 

  895.         <tr>
    896. 

  896. 		<form name="mainform" method="post" action="/admin/discounts.php" onsubmit="return formvalidator(this)">
    897. 

  897. 		  <td width="100%">
    898. 

  898. 			<input type="hidden" name="posted" value="1" />
    899. 

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

  900. 			<input type="hidden" name="act" value="domodify" />
    901. 

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

  902. 		<?php	}else{ ?>
    903. 

  903. 			<input type="hidden" name="act" value="doaddnew" />
    904. 

  904. 		<?php	} ?>
    905. 

  905.             <table width="100%" border="0" cellspacing="0" cellpadding="3" bgcolor="">
    906. 

  906. 			  <tr> 
    907. 

  907.                 <td width="100%" colspan="2" align="center"><strong><?php print $yyDscNew?></strong><br />&nbsp;</td>
    908. 

  908. 			  </tr>
    909. 

  909. 		<?php
    910. 

  910. 			if(@$_POST["act"]=="addnew"){
    911. 

  911. 		?>
    912. 

  912. 			  <tr>
    913. 

  913. 			  	<td width="40%" align="right"><strong>Create Coupon Group:</strong></td>
    914. 

  914. 				<td width="60%"><select id="cpnIsGrp" name="cpnIsGrp" onchange="cpnGrp(this);">
    915. 

  915. 					<option value="0"<?=((int)$cpnIsGrp!=1)?' selected="selected"':''?>>No</option>
    916. 

  916. 					<option value="1"<?=((int)$cpnIsGrp==1)?' selected="selected"':''?>>Yes</option>
    917. 

  917. 					</select>				</td>
    918. 

  918. 			  </tr>
    919. 

  919. 			  <tr class="trGroup" style="display: none">
    920. 

  920. 			  	<td width="40%" align="right"><strong>Group Name:</strong></td>
    921. 

  921. 				<td width="60%"><input type="text" id="grpName" name="grpName" value="" /></td>
    922. 

  922. 			  </tr>
    923. 

  923. 			  <tr class="trGroup" style="display: none">
    924. 

  924. 			  	<td width="40%" align="right"><strong>Number of Coupons:</strong></td>
    925. 

  925. 				<td width="60%"><input type="text" id="grpQty" name="grpQty" value="" /></td>
    926. 

  926. 			  </tr>
    927. 

  927. 			  <tr class="trGroup" style="display: none">
    928. 

  928. 			  	<td width="40%" align="right"><strong>Link to Group:</strong></td>
    929. 

  929. 				<td width="60%">
    930. 

  930. 					<select id="linkGrp" name="linkGrp" onchange="qty()">
    931. 

  931. 			<?php
    932. 

  932. 				$qry = "SELECT * FROM grpCpn WHERE grpCpnLinkID IS NULL OR grpCpnLinkID = ''";
    933. 

  933. 				$res = mysql_query($qry) or print(mysql_error());
    934. 

  934. 				echo '<option value="none">None</option>'."\n";
    935. 

  935. 				while($row = mysql_fetch_assoc($res)) {
    936. 

  936. 					echo '<option value="'.$row['grpCpnID'].'">'.$row['grpCpnName'].'</option>'."\n";
    937. 

  937. 				}
    938. 

  938. 			?>
    939. 

  939. 					</select>
    940. 

  940. 				</td>
    941. 

  941. 			  </tr>
    942. 

  942. 			  <tr>
    943. 

  943. 			  	<td colspan="2">&nbsp;</td>
    944. 

  944. 			  </tr>
    945. 

  945. 		<?php
    946. 

  946. 			}
    947. 

  947. 		?>
    948. 

  948. 			  <tr>
    949. 

  949. 				<td width="40%" align="right"><strong><?php print $yyCpnDsc?>:</strong></td>
    950. 

  950. 				<td width="60%"><select name="cpnIsCoupon" size="1" onchange="couponcodeactive(false);">
    951. 

  951. 					<option value="0"><?php print $yyDisco?></option>
    952. 

  952. 					<option value="1" <?php if((int)$cpnIsCoupon==1) print "selected" ?>><?php print $yyCoupon?></option>
    953. 

  953. 					</select></td>
    954. 

  954. 			  </tr>
    955. 

  955. 			  <tr>
    956. 

  956. 				<td width="40%" align="right"><strong><?php print $yyDscEff?>:</strong></td>
    957. 

  957. 				<td width="60%"><select name="cpnType" size="1" onchange="changecouponeffect(false);">
    958. 

  958. 					<option value="0"><?php print $yyFrSShp?></option>
    959. 

  959. 					<option value="1" <?php if((int)$cpnType==1) print "selected" ?>><?php print $yyFlatDs?></option>
    960. 

  960. 					<option value="2" <?php if((int)$cpnType==2) print "selected" ?>><?php print $yyPerDis?></option>
    961. 

  961. 					</select></td>
    962. 

  962. 			  </tr>
    963. 

  963. 			  <tr>
    964. 

  964. 				<td width="40%" align="right"><strong><?php print $yyDisTxt?>:</strong></td>
    965. 

  965. 				<td width="60%"><input type="text" name="cpnName" size="30" value="<?php print str_replace('"',"&quot;",$cpnName)?>" /></td>
    966. 

  966. 			  </tr>
    967. 

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

  968. 				if(($adminlangsettings & 1024)==1024){ ?>
    969. 

  969. 			  <tr>
    970. 

  970. 				<td width="40%" align="right"><strong><?php print $yyDisTxt . " " . $index?>:</strong></td>
    971. 

  971. 				<td width="60%"><input type="text" name="cpnName<?php print $index?>" size="30" value="<?php print str_replace('"',"&quot;",$cpnNames[$index])?>" /></td>
    972. 

  972. 			  </tr>
    973. 

  973. <?php			}
    974. 

  974. 			} ?>
    975. 

  975. 			  <tr>
    976. 

  976. 				<td width="40%" align="right"><strong><?php print $yyWrkNam?>:</strong></td>
    977. 

  977. 				<td width="60%"><input type="text" name="cpnWorkingName" size="30" value="<?php print str_replace('"',"&quot;",$cpnWorkingName)?>" /></td>
    978. 

  978. 			  </tr>
    979. 

  979. 			  <tr>
    980. 

  980. 				<td width="40%" align="right"><strong><?php print $yyCpnCod?>:</strong></td>
    981. 

  981. 				<td width="60%"><input type="text" id="cpnNumber" name="cpnNumber" size="30" value="<?php print $cpnNumber?>" /></td>
    982. 

  982. 			  </tr>
    983. 

  983. 			  <tr>
    984. 

  984. 				<td width="40%" align="right"><strong><?php print $yyNumAvl?>:</strong></td>
    985. 

  985. 				<td width="60%"><input type="text" id="cpnNumAvail" name="cpnNumAvail" size="10" value="<?php if((int)$cpnNumAvail != 30000000) print $cpnNumAvail?>" /></td>
    986. 

  986. 			  </tr>
    987. 

  987. 			  <?php /*?><tr>
    988. 

  988. 				<td width="40%" align="right"><strong><?php print $yyDaysAv?>:</strong></td>
    989. 

  989. 				<td width="60%"><input type="text" id="cpnEndDate" name="cpnEndDate" size="10" value="<?php
    990. 

  990. 				if($cpnEndDate != '3000-01-01 00:00:00')
    991. 

  991. 					if(strtotime($cpnEndDate)-time() < 0) print "Expired"; else print floor((strtotime($cpnEndDate)-time())/(60*60*24))+1; ?>"/></td>
    992. 

  992. 			  </tr><?php */?>
    993. 

  993. 			  <tr>
    994. 

  994. 				<td width="40%" align="right"><strong><?php print $yyBeginDate?>:</strong></td>
    995. 

  995. 				<td width="60%"><input type="text" id="cpnBeginDate" name="cpnBeginDate" size="19" value="<?php if ($cpnBeginDate != "0000-00-00 00:00:00") { echo $cpnBeginDate; }?>" /><button type="reset" id="beginDte">...</button>
    996. 

  996.                         <script type="text/javascript">
    997. 

  997.                         Calendar.setup({
    998. 

  998.                             inputField     :    "cpnBeginDate",      // id of the input field
    999. 

  999.                             ifFormat       :    "%Y-%m-%d 00:00:00",       // format of the input field
    1000. 

  1000.                             showsTime      :    false,            // will display a time selector
    1001. 

  1001.                             button         :    "beginDte",   // trigger for the calendar (button ID)
    1002. 

  1002.                             singleClick    :    true,           // double-click mode
    1003. 

  1003.                             step           :    1                // show all years in drop-down boxes (instead of every other year as default)
    1004. 

  1004.                         });
    1005. 

  1005.                         </script></td>
    1006. 

  1006. 			  </tr>
    1007. 

  1007. 			  <tr>
    1008. 

  1008. 				<td width="40%" align="right"><strong><?php print $yyEndDate?>:</strong></td>
    1009. 

  1009. 				<td width="60%"><input type="text" id="cpnEndDate" name="cpnEndDate" size="19" value="<?php 
    1010. 

  1010. 				if($cpnEndDate != '3000-01-01 00:00:00')
    1011. 

  1011. 					if(strtotime($cpnEndDate)-time() < 0) print "Expired"; else print $cpnEndDate; ?>" /><button type="reset" id="endDte">...</button>
    1012. 

  1012.                         <script type="text/javascript">
    1013. 

  1013.                         Calendar.setup({
    1014. 

  1014.                             inputField     :    "cpnEndDate",      // id of the input field
    1015. 

  1015.                             ifFormat       :    "%Y-%m-%d 00:00:00",       // format of the input field
    1016. 

  1016.                             showsTime      :    false,            // will display a time selector
    1017. 

  1017.                             button         :    "endDte",   // trigger for the calendar (button ID)
    1018. 

  1018.                             singleClick    :    true,           // double-click mode
    1019. 

  1019.                             step           :    1                // show all years in drop-down boxes (instead of every other year as default)
    1020. 

  1020.                         });
    1021. 

  1021.                         </script></td>
    1022. 

  1022. 			  </tr>
    1023. 

  1023. 			  <tr>
    1024. 

  1024. 				<td width="40%" align="right"><strong><?php print $yyMinPur?>:</strong></td>
    1025. 

  1025. 				<td width="60%"><input type="text" name="cpnThreshold" size="10" value="<?php if((int)$cpnThreshold>0) print $cpnThreshold?>" /> <strong><?php print $yyRepEvy?>:</strong> <input type="text" name="cpnThresholdRepeat" size="10" value="<?php if((int)$cpnThresholdRepeat > 0) print $cpnThresholdRepeat?>" /></td>
    1026. 

  1026. 			  </tr>
    1027. 

  1027. 			  <tr>
    1028. 

  1028. 				<td width="40%" align="right"><strong><?php print $yyMaxPur?>:</strong></td>
    1029. 

  1029. 				<td width="60%"><input type="text" name="cpnThresholdMax" size="10" value="<?php if((int)$cpnThresholdMax>0) print $cpnThresholdMax?>" /></td>
    1030. 

  1030. 			  </tr>
    1031. 

  1031. 			  <tr>
    1032. 

  1032. 				<td width="40%" align="right"><strong><?php print $yyMinQua?>:</strong></td>
    1033. 

  1033. 				<td width="60%"><input type="text" name="cpnQuantity" size="10" value="<?php if((int)$cpnQuantity>0) print $cpnQuantity?>" /> <strong><?php print $yyRepEvy?>:</strong> <input type="text" name="cpnQuantityRepeat" size="10" value="<?php if((int)$cpnQuantityRepeat > 0) print $cpnQuantityRepeat?>" /></td>
    1034. 

  1034. 			  </tr>
    1035. 

  1035. 			  <tr>
    1036. 

  1036. 				<td width="40%" align="right"><strong><?php print $yyMaxQua?>:</strong></td>
    1037. 

  1037. 				<td width="60%"><input type="text" name="cpnQuantityMax" size="10" value="<?php if((int)$cpnQuantityMax>0) print $cpnQuantityMax?>" /></td>
    1038. 

  1038. 			  </tr>
    1039. 

  1039. 			  <tr>
    1040. 

  1040. 				<td width="40%" align="right"><strong><?php print $yyDscAmt?>:</strong></td>
    1041. 

  1041. 				<td width="60%"><input type="text" name="cpnDiscount" size="10" value="<?php print $cpnDiscount?>" /></td>
    1042. 

  1042. 			  </tr>
    1043. 

  1043. 			  <tr>
    1044. 

  1044. 				<td width="40%" align="right"><strong><?php print $yyScope?>:</strong></td>
    1045. 

  1045. 				<td width="60%"><select name="cpnSitewide" size="1">
    1046. 

  1046. 					<option value="0"><?php print $yyIndCat?></option>
    1047. 

  1047. 					<option value="3" <?php if((int)$cpnSitewide==3) print "selected" ?>><?php print $yyDsCaTo?></option>
    1048. 

  1048. 					<option value="2" <?php if((int)$cpnSitewide==2) print "selected" ?>><?php print $yyGlInPr?></option>
    1049. 

  1049. 					<option value="1" <?php if((int)$cpnSitewide==1) print "selected" ?>><?php print $yyGlPrTo?></option>
    1050. 

  1050. 					</select></td>
    1051. 

  1051. 			  </tr>
    1052. 

  1052. 			  <tr>
    1053. 

  1053. 				<td width="40%" align="right"><strong><?php print $yyRestr?>:</strong></td>
    1054. 

  1054. 				<td width="60%"><select name="cpnCntry" size="1">
    1055. 

  1055. 					<option value="0"><?php print $yyAppAll?></option>
    1056. 

  1056. 					<option value="1" <?php if((int)$cpnCntry==1) print "selected" ?>><?php print $yyYesRes?></option>
    1057. 

  1057. 					</select></td>
    1058. 

  1058. 			  </tr>
    1059. 

  1059. 			  <tr>
    1060. 

  1060. 			  	<td align="right"><strong>Is Stackable:</strong></td>
    1061. 

  1061. 			  	<td><input <?php 
    1062. 

  1062. 			  				if ($cpnStackable != 0) {
    1063. 

  1063. 			  					echo "checked=\"checked\"";
    1064. 

  1064. 			  				} ?>type="checkbox" name="cpnStackable" value="1" /></td>
    1065. 

  1065. 			  </tr>
    1066. 

  1066. 			  <tr>
    1067. 

  1067. 			    <td align="right"><strong><?php print $yyAppliesToWS?>:</strong></td>
    1068. 

  1068. 			    <td><input <?php if (!(strcmp($cpnIsWholesale,'1'))) {echo "checked=\"checked\"";} ?> type="checkbox" name="cpnIsWholesale" value="1" /></td>
    1069. 

  1069. 		      </tr>
    1070. 

  1070. 			  <tr>
    1071. 

  1071.   		        <td style="vertical-align: top; text-align: right;"><strong>Applicable Shipping Methods:</strong></td>
    1072. 

  1072.   		        <td>
    1073. 

  1073.   		            <?php
    1074. 

  1074.   		                $iFrogzConnection = DB_Connection_Pool::instance()->get_connection(new DB_DataSource('default_ifrogz'));
    1075. 

  1075. 

  1076.                         $ResultSet = $iFrogzConnection->query("SELECT * FROM postalzones WHERE pzID <= 100 AND pzName != '';");
    1077. 

  1077.                         $postalzones = $ResultSet->as_array();
    1078. 

  1078.                         $ResultSet->free();
    1079. 

  1079. 

  1080.                         $buffer = '';
    1081. 

  1081. 

  1082.                         foreach ($postalzones as $record) {
    1083. 

  1083.                             $buffer .= $record['pzName'] . '<br />';
    1084. 

  1084.                             for ($i = 1; $i <= 5; $i++) {
    1085. 

  1085.                                 $key = "pzMethodName{$i}";
    1086. 

  1086.                                 if ($record[$key] != '') {
    1087. 

  1087.                                     $isChecked = '';
    1088. 

  1088.                                     if (isset($_POST['id'])) {
    1089. 

  1089.                                         try {
    1090. 

  1090.                                             $ResultSet = $iFrogzConnection->query("SELECT * FROM fsadiscount WHERE cpnID = {$_POST['id']} AND pzID = {$record['pzID']} AND methodID = {$i};");
    1091. 

  1091.                                             $fsadiscount = $ResultSet->as_array();
    1092. 

  1092.                                             if (!empty($fsadiscount)) {
    1093. 

  1093.                                                 $isChecked = 'checked="checked" ';
    1094. 

  1094.                                             }
    1095. 

  1095.                                             $ResultSet->free();
    1096. 

  1096.                                         }
    1097. 

  1097.                                         catch (Exception $ex) { }
    1098. 

  1098.                                     }
    1099. 

  1099.                                     $buffer .= "&nbsp;&nbsp;&nbsp;<input class=\"ShippingMethod\" type=\"checkbox\" name=\"pz[]\" value=\"{$record['pzID']},{$i}\" {$isChecked}/>" . $record[$key] . '<br />';
    1100. 

  1100.                                 }
    1101. 

  1101.                             }
    1102. 

  1102.                         }
    1103. 

  1103.                         
    1104. 

  1104.                         echo $buffer;
    1105. 

  1105. 

  1106.                         $iFrogzConnection->close();
    1107. 

  1107.   		            ?>
    1108. 

  1108.   		        </td>
    1109. 

  1109.   			  </tr>
    1110. 

  1110. 		<?php
    1111. 

  1111. 			if($_POST['act']!="viewGrp") {
    1112. 

  1112. 		?>
    1113. 

  1113. 			  <tr>
    1114. 

  1114.                 <td width="100%" colspan="2" align="center"><br /><input type="submit" value="<?php print $yySubmit?>" /><br />&nbsp;</td>
    1115. 

  1115. 			  </tr>
    1116. 

  1116. 		<?php
    1117. 

  1117. 			}
    1118. 

  1118. 		?>
    1119. 

  1119. 			  <tr> 
    1120. 

  1120.                 <td width="100%" colspan="2" align="center"><br />
    1121. 

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

  1122.                           &nbsp;</td>
    1123. 

  1123. 			  </tr>
    1124. 

  1124.             </table>
    1125. 

  1125. 		  </td>
    1126. 

  1126. 		</form>
    1127. 

  1127. 

  1128.         </tr>
    1129. 

  1129. <script language="JavaScript" type="text/javascript">
    1130. 

  1130. <!--
    1131. 

  1131. savebg=document.mainform.cpnNumber.style.backgroundColor;
    1132. 

  1132. savebc=document.mainform.cpnNumber.style.borderColor;
    1133. 

  1133. savecol=document.mainform.cpnNumber.style.color;
    1134. 

  1134. couponcodeactive(false);
    1135. 

  1135. changecouponeffect(false);
    1136. 

  1136. //-->
    1137. 

  1137. </script>
    1138. 

  1138. <?php 
    1139. 

  1139. 		}elseif(@$_POST["posted"]=="1" && @$_POST["act"]=="viewGrp"){
    1140. 

  1140. 			$sSQL = "SELECT * FROM grpCpn WHERE grpCpnID = " . $_POST['id'];
    1141. 

  1141. 			$res = mysql_query($sSQL) or print(mysql_error());
    1142. 

  1142. 			$row = mysql_fetch_assoc($res);
    1143. 

  1143. 			
    1144. 

  1144. 			$grpCpnID = $row['grpCpnID'];
    1145. 

  1145. 			$grpCpnName = $row['grpCpnName'];
    1146. 

  1146. 			$grpLinkID = $row['grpCpnLinkID'];
    1147. 

  1147. 			$grpCpnQty = $row['grpCpnQty'];
    1148. 

  1148. 			
    1149. 

  1149. 			mysql_free_result($res);
    1150. 

  1150. 			$sSQL = "SELECT * FROM coupons WHERE cpnGrpCpnID = " . $_POST['id'];
    1151. 

  1151. 			$res = mysql_query($sSQL) or print(mysql_error());
    1152. 

  1152. 			$rs = mysql_fetch_assoc($res);
    1153. 

  1153. 			
    1154. 

  1154. 			$cpnName = $rs["cpnName"];
    1155. 

  1155. 			for($index=2; $index <= $adminlanguages+1; $index++)
    1156. 

  1156. 				$cpnNames[$index] = $rs["cpnName" . $index];
    1157. 

  1157. 			$cpnWorkingName = $rs["cpnWorkingName"];
    1158. 

  1158. 			$cpnNumber = $rs["cpnNumber"];
    1159. 

  1159. 			$cpnType = $rs["cpnType"];
    1160. 

  1160. 			$cpnEndDate = $rs["cpnEndDate"];
    1161. 

  1161. 			$cpnDiscount = $rs["cpnDiscount"];
    1162. 

  1162. 			$cpnThreshold = $rs["cpnThreshold"];
    1163. 

  1163. 			$cpnThresholdMax = $rs["cpnThresholdMax"];
    1164. 

  1164. 			$cpnThresholdRepeat = $rs["cpnThresholdRepeat"];
    1165. 

  1165. 			$cpnQuantity = $rs["cpnQuantity"];
    1166. 

  1166. 			$cpnQuantityMax = $rs["cpnQuantityMax"];
    1167. 

  1167. 			$cpnQuantityRepeat = $rs["cpnQuantityRepeat"];
    1168. 

  1168. 			$cpnNumAvail = $rs["cpnNumAvail"];
    1169. 

  1169. 			$cpnCntry = $rs["cpnCntry"];
    1170. 

  1170. 			$cpnIsCoupon = $rs["cpnIsCoupon"];
    1171. 

  1171. 			$cpnSitewide = $rs["cpnSitewide"];
    1172. 

  1172. 			$cpnIsGrp = $rs["cpnGrpCpnID"];
    1173. 

  1173. 			$cpnBeginDate = $rs["cpnBeginDate"];
    1174. 

  1174. 			mysql_free_result($res);
    1175. 

  1175. ?>
    1176. 

  1176.         <tr>
    1177. 

  1177. 		<form name="mainform" method="post" action="/admin/discounts.php" onsubmit="return formvalidator(this)">
    1178. 

  1178. 		  <td width="100%">
    1179. 

  1179. 			<input type="hidden" name="posted" value="1" />
    1180. 

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

  1181. 			<input type="hidden" name="act" value="domodify" />
    1182. 

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

  1183. 		<?php	}else{ ?>
    1184. 

  1184. 			<input type="hidden" name="act" value="doaddnew" />
    1185. 

  1185. 		<?php	} ?>
    1186. 

  1186.             <table width="100%" border="0" cellspacing="0" cellpadding="3" bgcolor="">
    1187. 

  1187. 			  <tr> 
    1188. 

  1188.                 <td width="100%" colspan="2" align="center"><strong><?php print $yyDscNew?></strong><br />&nbsp;</td>
    1189. 

  1189. 			  </tr>
    1190. 

  1190. 			  <tr class="trGroup">
    1191. 

  1191. 			  	<td width="40%" align="right"><strong>Group Name:</strong></td>
    1192. 

  1192. 				<td width="60%"><input type="text" id="grpName" name="grpName" value="<?=$grpCpnName?>" disabled="disabled" style="background-color: #DDD; border-color: #aa3300; color: #A30;" /></td>
    1193. 

  1193. 			  </tr>
    1194. 

  1194. 			  <tr class="trGroup">
    1195. 

  1195. 			  	<td width="40%" align="right"><strong>Number of Coupons:</strong></td>
    1196. 

  1196. 				<td width="60%"><input type="text" id="grpQty" name="grpQty" value="<?=$grpCpnQty?>" /></td>
    1197. 

  1197. 			  </tr>
    1198. 

  1198. 			  <tr class="trGroup">
    1199. 

  1199. 			  	<td width="40%" align="right"><strong>Link to Group:</strong></td>
    1200. 

  1200. 				<td width="60%">
    1201. 

  1201. 					<select id="linkGrp" name="linkGrp" onchange="qty()">
    1202. 

  1202. 			<?php
    1203. 

  1203. 				$qry = "SELECT * FROM grpCpn WHERE grpCpnLinkID IS NULL OR grpCpnLinkID = ''";
    1204. 

  1204. 				$res = mysql_query($qry) or print(mysql_error());
    1205. 

  1205. 				echo '						<option value="none">None</option>'."\n";
    1206. 

  1206. 				while($row = mysql_fetch_assoc($res)) {
    1207. 

  1207. 			?>
    1208. 

  1208. 						<option value="<?=$row['grpCpnID']?>"<?=($row['grpCpnID']==$grpLinkID)?'selected="selected"':''?>><?=$row['grpCpnName']?></option>
    1209. 

  1209. 			<?php
    1210. 

  1210. 				}
    1211. 

  1211. 			?>
    1212. 

  1212. 					</select>
    1213. 

  1213. 				</td>
    1214. 

  1214. 			  </tr>
    1215. 

  1215. 			  <tr>
    1216. 

  1216. 			  	<td colspan="2">&nbsp;</td>
    1217. 

  1217. 			  </tr>
    1218. 

  1218. 			  <tr>
    1219. 

  1219. 				<td width="40%" align="right"><strong><?php print $yyCpnDsc?>:</strong></td>
    1220. 

  1220. 				<td width="60%"><select name="cpnIsCoupon" size="1" onchange="couponcodeactive(false);">
    1221. 

  1221. 					<option value="0"><?php print $yyDisco?></option>
    1222. 

  1222. 					<option value="1" <?php if((int)$cpnIsCoupon==1) print "selected" ?>><?php print $yyCoupon?></option>
    1223. 

  1223. 					</select></td>
    1224. 

  1224. 			  </tr>
    1225. 

  1225. 			  <tr>
    1226. 

  1226. 				<td width="40%" align="right"><strong><?php print $yyDscEff?>:</strong></td>
    1227. 

  1227. 				<td width="60%"><select name="cpnType" size="1" onchange="changecouponeffect(false);">
    1228. 

  1228. 					<option value="0"><?php print $yyFrSShp?></option>
    1229. 

  1229. 					<option value="1" <?php if((int)$cpnType==1) print "selected" ?>><?php print $yyFlatDs?></option>
    1230. 

  1230. 					<option value="2" <?php if((int)$cpnType==2) print "selected" ?>><?php print $yyPerDis?></option>
    1231. 

  1231. 					</select></td>
    1232. 

  1232. 			  </tr>
    1233. 

  1233. 			  <tr>
    1234. 

  1234. 				<td width="40%" align="right"><strong><?php print $yyDisTxt?>:</strong></td>
    1235. 

  1235. 				<td width="60%"><input type="text" name="cpnName" size="30" value="<?php print str_replace('"',"&quot;",$cpnName)?>" /></td>
    1236. 

  1236. 			  </tr>
    1237. 

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

  1238. 				if(($adminlangsettings & 1024)==1024){ ?>
    1239. 

  1239. 			  <tr>
    1240. 

  1240. 				<td width="40%" align="right"><strong><?php print $yyDisTxt . " " . $index?>:</strong></td>
    1241. 

  1241. 				<td width="60%"><input type="text" name="cpnName<?php print $index?>" size="30" value="<?php print str_replace('"',"&quot;",$cpnNames[$index])?>" /></td>
    1242. 

  1242. 			  </tr>
    1243. 

  1243. <?php			}
    1244. 

  1244. 			} ?>
    1245. 

  1245. 			  <tr>
    1246. 

  1246. 				<td width="40%" align="right"><strong><?php print $yyWrkNam?>:</strong></td>
    1247. 

  1247. 				<td width="60%"><input type="text" name="cpnWorkingName" size="30" value="<?php print str_replace('"',"&quot;",$cpnWorkingName)?>" /></td>
    1248. 

  1248. 			  </tr>
    1249. 

  1249. 			  <tr>
    1250. 

  1250. 				<td width="40%" align="right"><strong><?php print $yyCpnCod?>:</strong></td>
    1251. 

  1251. 				<td width="60%"><input type="text" id="cpnNumber" name="cpnNumber" size="30" value="<?php print $cpnNumber?>" /></td>
    1252. 

  1252. 			  </tr>
    1253. 

  1253. 			  <tr>
    1254. 

  1254. 				<td width="40%" align="right"><strong><?php print $yyNumAvl?>:</strong></td>
    1255. 

  1255. 				<td width="60%"><input type="text" id="cpnNumAvail" name="cpnNumAvail" size="10" value="<?php if((int)$cpnNumAvail != 30000000) print $cpnNumAvail?>" /></td>
    1256. 

  1256. 			  </tr>
    1257. 

  1257. 			  <?php /*?><tr>
    1258. 

  1258. 				<td width="40%" align="right"><strong><?php print $yyDaysAv?>:</strong></td>
    1259. 

  1259. 				<td width="60%"><input type="text" id="cpnEndDate" name="cpnEndDate" size="10" value="<?php
    1260. 

  1260. 				if($cpnEndDate != '3000-01-01 00:00:00')
    1261. 

  1261. 					if(strtotime($cpnEndDate)-time() < 0) print "Expired"; else print floor((strtotime($cpnEndDate)-time())/(60*60*24))+1; ?>"/></td>
    1262. 

  1262. 			  </tr><?php */?>
    1263. 

  1263. 			  <tr>
    1264. 

  1264. 				<td width="40%" align="right"><strong><?php print $yyBeginDate?>:</strong></td>
    1265. 

  1265. 				<td width="60%"><input type="text" name="cpnBeginDate" size="19" value="<?…
    1266.

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