PageRenderTime 65ms CodeModel.GetById 24ms RepoModel.GetById 1ms app.codeStats 0ms

/application/views/pages/admin/email.php

https://bitbucket.org/chadsaun/ifrogz-panel
PHP | 737 lines | 610 code | 48 blank | 79 comment | 156 complexity | 295567573e6a636d51a4f8c8e5c1fece MD5 | raw file
    

  1. <?php
    2. 

  2. include('init.php');
    3. 

  3. if ( ! defined('KOHANA_EXTERNAL_MODE')) {
    4. 

  4.     define('KOHANA_EXTERNAL_MODE', TRUE);
    5. 

  5. }
    6. 

  6. include_once(DOCROOT.'index.php');
    7. 

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

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

  9. //Business Solutions SL. Any use, reproduction, disclosure or copying of any kind 
    10. 

  10. //without the express and written permission of Internet Business Solutions SL is forbidden.
    11. 

  11. //Author: Vince Reid, vince@virtualred.net
    12. 

  12. //HCS - DRE 03/06/2005 Gift Cert Mod START
    13. 

  13. function bus_days($days_to_add) {
    14. 

  14. 	$start_date = strtotime(date("Y-m-d"));
    15. 

  15. 	$workdays_only = true;
    16. 

  16. 	$skip_holidays = true;
    17. 

  17. 

  18. 	$seconds_in_a_day = 86400;
    19. 

  19. 	$sunday_val = "0";
    20. 

  20.     $saturday_val = "6";
    21. 

  21. 	$holiday_array = array();
    22. 

  22. 	
    23. 

  23.     $ptr_year = intval(date("Y", $start_date));
    24. 

  24. 	$holiday_array[$ptr_year] = get_holidays(date("Y",$start_date));
    25. 

  25. 	//showarray($holiday_array); exit();
    26. 

  26. 	
    27. 

  27. 	$cur_day = $start_date;
    28. 

  28. 	while($days_to_add > 0) {
    29. 

  29. 		$cur_day += $seconds_in_a_day;
    30. 

  30. 		$day_of_week = date("w",$cur_day);
    31. 

  31. 		//echo date("Y-m-d H:i:s",$cur_day).' '.$days_to_add.'<br />';
    32. 

  32. 		if($workdays_only) {
    33. 

  33. 			if(($day_of_week != $sunday_val) && ($day_of_week != $saturday_val)) {
    34. 

  34. 				if($skip_holidays) {
    35. 

  35.                     if(intval(date("Y", $cur_day)) != $ptr_year){
    36. 

  36.                         $ptr_year = intval(date("Y", $cur_day));
    37. 

  37.                         $holiday_array[$ptr_year] = get_holidays(date("Y", $cur_day));
    38. 

  38.                     }
    39. 

  39. 					
    40. 

  40.                     if(!in_array($cur_day, $holiday_array[date("Y", $cur_day)])){
    41. 

  41.                         $days_to_add--;
    42. 

  42.                     }
    43. 

  43. 				}else{
    44. 

  44. 					$days_to_add--;
    45. 

  45. 				}
    46. 

  46. 			}
    47. 

  47. 		}else{
    48. 

  48.             if($skip_holidays){
    49. 

  49.                 if(intval(date("Y", $cur_day))!=$ptr_year){
    50. 

  50.                     $ptr_year = intval(date("Y", $cur_day));
    51. 

  51.                     $holiday_array[$ptr_year] = get_holidays(date("Y", $cur_day));
    52. 

  52.                 }
    53. 

  53.                 if(!in_array($cur_day, $holiday_array[date("Y", $cur_day)])){
    54. 

  54.                     $days_to_add--;
    55. 

  55.                 }
    56. 

  56.             }else{
    57. 

  57.                 $days_to_add--;
    58. 

  58.             }
    59. 

  59. 		}
    60. 

  60. 	}
    61. 

  61. 	
    62. 

  62. 	return $cur_day;
    63. 

  63. }
    64. 

  64. 

  65. /**
    66. 

  66.  * Takes a date in yyyy-mm-dd format and returns a PHP timestamp
    67. 

  67.  *
    68. 

  68.  * @param string $MySqlDate
    69. 

  69.  * @return unknown
    70. 

  70.  */
    71. 

  71. function get_timestamp($MySqlDate){
    72. 

  72. 

  73.     $date_array = explode("-",$MySqlDate); // split the array
    74. 

  74. 

  75.     $var_year = $date_array[0];
    76. 

  76.     $var_month = $date_array[1];
    77. 

  77.     $var_day = $date_array[2];
    78. 

  78. 

  79.     $var_timestamp = mktime(0,0,0,$var_month,$var_day,$var_year);
    80. 

  80.     return($var_timestamp); // return it to the user
    81. 

  81. }
    82. 

  82. 

  83. /**
    84. 

  84.  * Returns the date of the $ord $day of the $month.
    85. 

  85.  * For example ordinal_day(3, 'Sun', 5, 2001) returns the
    86. 

  86.  * date of the 3rd Sunday of May (ie. Mother's Day).
    87. 

  87.  *
    88. 

  88.  * @author  heymeadows@yahoo.com
    89. 

  89.  *
    90. 

  90.  * @param int $ord
    91. 

  91.  * @param string $day (must be 3 char abbrev, per date("D);)
    92. 

  92.  * @param int $month
    93. 

  93.  * @param int $year
    94. 

  94.  * @return unknown
    95. 

  95.  */
    96. 

  96. function ordinal_day($ord, $day, $month, $year) {
    97. 

  97. 

  98.     $firstOfMonth = get_timestamp("$year-$month-01");
    99. 

  99.     $lastOfMonth  = $firstOfMonth + date("t", $firstOfMonth) * 86400;
    100. 

  100.     $dayOccurs = 0;
    101. 

  101. 

  102.     for ($i = $firstOfMonth; $i < $lastOfMonth ; $i += 86400){
    103. 

  103.         if (date("D", $i) == $day){
    104. 

  104.             $dayOccurs++;
    105. 

  105.             if ($dayOccurs == $ord){
    106. 

  106.                 $ordDay = $i;
    107. 

  107.             }
    108. 

  108.         }
    109. 

  109.     }
    110. 

  110.     return $ordDay;
    111. 

  111. }
    112. 

  112. 

  113. function memorial_day($inc_year){
    114. 

  114.     for($date_stepper = intval(date("t", strtotime("$inc_year-05-01"))); $date_stepper >= 1; $date_stepper--){
    115. 

  115.         if(date("l", strtotime("$inc_year-05-$date_stepper"))=="Monday"){
    116. 

  116.             return strtotime("$inc_year-05-$date_stepper");
    117. 

  117.             break;
    118. 

  118.         }
    119. 

  119.     }
    120. 

  120. }
    121. 

  121. 

  122. 

  123. /**
    124. 

  124.  * Looks through a lists of defined holidays and tells you which
    125. 

  125.  * one is coming up next.
    126. 

  126.  *
    127. 

  127.  * @author heymeadows@yahoo.com
    128. 

  128.  *
    129. 

  129.  * @param int $inc_year The year we are looking for holidays in
    130. 

  130.  * @return array
    131. 

  131.  */
    132. 

  132. function get_holidays($inc_year){
    133. 

  133.     //$year = date("Y");
    134. 

  134.     $year = $inc_year;
    135. 

  135. 

  136.     $holidays[] = new Holiday("New Year's Day", get_timestamp("$year-1-1"));
    137. 

  137.     //$holidays[] = new Holiday("Australia Day", get_timestamp("$year-1-26"));
    138. 

  138.     $holidays[] = new Holiday("Labour Day", ordinal_day(1, 'Mon', 3, $year));
    139. 

  139.     //$holidays[] = new Holiday("Anzac Day", get_timestamp("$year-4-25"));
    140. 

  140.     //$holidays[] = new Holiday("St. Patrick's Day", get_timestamp("$year-3-17"));
    141. 

  141.     // TODO: $holidays[] = new Holiday("Good Friday", easter_date($year));
    142. 

  142. 	$holidays[] = new Holiday("Easter", easter_date($year));
    143. 

  143.     // TODO: $holidays[] = new Holiday("Easter Monday", easter_date($year));
    144. 

  144.     //$holidays[] = new Holiday("Foundation Day", ordinal_day(1, 'Mon', 6, $year));
    145. 

  145.     //$holidays[] = new Holiday("Queen's Birthday", ordinal_day(1, 'Mon', 10, $year));
    146. 

  146.     $holidays[] = new Holiday("Memorial Day", memorial_day($year));
    147. 

  147.     //$holidays[] = new Holiday("Mother's Day", ordinal_day(2, 'Sun', 5, $year));
    148. 

  148.     //$holidays[] = new Holiday("Father's Day", ordinal_day(3, 'Sun', 6, $year));
    149. 

  149.     $holidays[] = new Holiday("Independence Day", get_timestamp("$year-7-4"));
    150. 

  150. 	$holidays[] = new Holiday("Pioneer Day", get_timestamp("$year-7-24"));
    151. 

  151.     $holidays[] = new Holiday("Labor Day", ordinal_day(1, 'Mon', 9, $year));
    152. 

  152. 	$holidays[] = new Holiday("Thanksgiving Day", ordinal_day(4, 'Thu', 11, $year));
    153. 

  153. 	$holidays[] = new Holiday("Day after Thanksgiving", ordinal_day(4, 'Fri', 11, $year));
    154. 

  154. 	//$holidays[] = new Holiday("Christmas Eve", get_timestamp("$year-12-24"));
    155. 

  155.     $holidays[] = new Holiday("Christmas", get_timestamp("$year-12-25"));
    156. 

  156.     //$holidays[] = new Holiday("Boxing Day", get_timestamp("$year-12-26"));
    157. 

  157. 	$holidays[] = new Holiday("New Years Eve", get_timestamp("$year-12-31"));
    158. 

  158. 

  159.     $numHolidays = count($holidays);
    160. 

  160.     $out_array = array();
    161. 

  161. 

  162.     for ($i = 0; $i < $numHolidays; $i++){
    163. 

  163.         $out_array[] = $holidays[$i]->date;
    164. 

  164.     }
    165. 

  165.     unset($holidays);
    166. 

  166.     return $out_array;
    167. 

  167. }
    168. 

  168. 

  169. class Holiday{
    170. 

  170.     //var $name;
    171. 

  171.     //var $date;
    172. 

  172.     var $name;
    173. 

  173.     var $date;
    174. 

  174. 

  175.     // Contructor to define the details of each holiday as it is created.
    176. 

  176.     function holiday($name, $date){
    177. 

  177.         $this->name   = $name;   // Official name of holiday
    178. 

  178.         $this->date   = $date;   // UNIX timestamp of date
    179. 

  179.     }
    180. 

  180. }
    181. 

  181. 

  182.  
    183. 

  183. //HCS - DRE 03/06/2005 Gift Cert Mod STOP
    184. 

  184. function vrhmac($key, $text){
    185. 

  185. 	$idatastr = "                                                                ";
    186. 

  186. 	$odatastr = "                                                                ";
    187. 

  187. 	$hkey = (string)$key;
    188. 

  188. 	$idatastr .= $text;
    189. 

  189. 	for($i=0; $i<64; $i++){
    190. 

  190. 		$idata[$i] = $ipad[$i] = 0x36;
    191. 

  191. 		$odata[$i] = $opad[$i] = 0x5C;
    192. 

  192. 	}
    193. 

  193. 	for($i=0; $i< strlen($hkey); $i++){
    194. 

  194. 		$ipad[$i] ^= ord($hkey{$i});
    195. 

  195. 		$opad[$i] ^= ord($hkey{$i});
    196. 

  196. 		$idata[$i] = ($ipad[$i] & 0xFF);
    197. 

  197. 		$odata[$i] = ($opad[$i] & 0xFF);
    198. 

  198. 	}
    199. 

  199. 	for($i=0; $i< strlen($text); $i++){
    200. 

  200. 		$idata[64+$i] = ord($text{$i}) & 0xFF;
    201. 

  201. 	}
    202. 

  202. 	for($i=0; $i< strlen($idatastr); $i++){
    203. 

  203. 		$idatastr{$i} = chr($idata[$i] & 0xFF);
    204. 

  204. 	}
    205. 

  205. 	for($i=0; $i< strlen($odatastr); $i++){
    206. 

  206. 		$odatastr{$i} = chr($odata[$i] & 0xFF);
    207. 

  207. 	}
    208. 

  208. 	$innerhashout = md5($idatastr);
    209. 

  209. 	for($i=0; $i<16; $i++)
    210. 

  210. 		$odatastr .= chr(hexdec(substr($innerhashout,$i*2,2)));
    211. 

  211. 	return md5($odatastr);
    212. 

  212. }
    213. 

  213. function order_success($sorderid,$sEmail,$sendstoreemail){
    214. 

  214. 	do_order_success($sorderid,$sEmail,$sendstoreemail,TRUE,TRUE,TRUE,TRUE);
    215. 

  215. }
    216. 

  216. function do_order_success($sorderid,$sEmail,$sendstoreemail,$doshowhtml,$sendcustemail,$sendaffilemail,$sendmanufemail){
    217. 

  217. 	global $maintablebg,$innertablebg,$maintablewidth,$innertablewidth,$maintablespacing,$innertablespacing,$maintablepadding,$innertablepadding,$thereference,$emlNl,$htmlemails,$extraorderfield1,$extraorderfield2,$shipType,$emailheader,$emailfooter,$emailencoding,$hideoptpricediffs,$xxWtIns,$ordGrandTotal,$ordID,$digidownloads,$dropshipfooter,$dropshipheader,$digidownloademail;
    218. 

  218. 	global $xxHndlg,$xxDscnts,$xxOrdId,$xxCusDet,$xxEmail,$xxPhone,$xxShpDet,$xxShpMet,$xxAddInf,$xxPrId,$xxPrNm,$xxQuant,$xxUnitPr,$xxOrdTot,$xxStaTax,$xxCntTax,$xxShippg,$xxGndTot,$xxOrdStr,$xxTnxOrd,$xxTouSoo,$xxAff1,$xxAff2,$xxAff3,$xxThnks,$xxThkYou,$xxRecEml,$storeurl,$xxHomeURL,$xxCntShp,$success,$ordAuthNumber,$orderText,$ordTotal,$customheaders,$digidownloadsecret,$useaddressline2,$xxTouSooShipping,$xxTouSooDate,$xxTwoOrdIds;
    219. 

  219. 	if(@$htmlemails==TRUE) $emlNl = "<br />"; else $emlNl="\n";
    220. 

  220. 	if(@$customheaders == ""){
    221. 

  221. 		$customheaders = "MIME-Version: 1.0\n";
    222. 

  222. 		$customheaders .= "From: %from% <%from%>\n";
    223. 

  223. 		//$customheaders .= "To: " . $custEmail . " <" . $custEmail . ">\n";
    224. 

  224. 		if(@$htmlemails==TRUE)
    225. 

  225. 			$customheaders .= "Content-type: text/html; charset=".$emailencoding."\n";
    226. 

  226. 		else
    227. 

  227. 			$customheaders .= "Content-type: text/plain; charset=".$emailencoding."\n";
    228. 

  228. 	}
    229. 

  229. 	$affilID = "";
    230. 

  230. 	$saveHeader = "";
    231. 

  231. 	$ordID = $sorderid;
    232. 

  232. 	$hasdownload=FALSE;
    233. 

  233. 	$ndropshippers=0;
    234. 

  234. 	//HCS - DRE 03/07/05 Gift Cert Mod START
    235. 

  235. 	$strsql = "SELECT * FROM orders WHERE ordID =".$ordID." AND ordStatus >= 3";
    236. 

  236. 	$result = mysql_query($strsql);
    237. 

  237. 	if($rs=mysql_fetch_assoc($result)) { 
    238. 

  238. 		$certstr = create_certificate($ordID);
    239. 

  239. 	}else{
    240. 

  240. 		$prodarray = array();
    241. 

  241. 		$certorder = FALSE;
    242. 

  242. 		$strsql = "SELECT pID FROM products WHERE p_iscert > 0";
    243. 

  243. 		$result = mysql_query($strsql);
    244. 

  244. 		while ($rs=mysql_fetch_assoc($result)) {
    245. 

  245. 			$prodarray[] = $rs['pID'];
    246. 

  246. 		}
    247. 

  247. 		$prodarray = "'".implode("','",$prodarray)."'";
    248. 

  248. 		if($prodarray == "") $prodarray = "NOVALIDPRODIDFORTHISQUERY696986";
    249. 

  249. 		$strsql = "SELECT cartProdID FROM cart, orders  WHERE ordID =".$ordID."  AND cartOrderID =".$ordID." AND cartProdID IN (".$prodarray.")";
    250. 

  250. 		$result = mysql_query($strsql);
    251. 

  251. 		if(mysql_num_rows($result) > 0) $certorder = TRUE;
    252. 

  252. 	}
    253. 

  253. 	$strsql2 = "SELECT pend_order_amt, cert_amt, cert_exp_dt, cert_id, cert_code FROM certificates WHERE pend_order_id =".$ordID;
    254. 

  254. 	$result2 = mysql_query($strsql2);
    255. 

  255. 	$pendingamt = 0;
    256. 

  256. 	$remainbal = 0;
    257. 

  257. 	$certexpdt = 0;
    258. 

  258. 	$certid = 0;
    259. 

  259. 	$certcode = 0;
    260. 

  260. 	$certend = "";
    261. 

  261. 	if($rs2=mysql_fetch_assoc($result2)) {
    262. 

  262. 		$pendingamt = $rs2['pend_order_amt'];
    263. 

  263. 		$remainbal = $rs2['cert_amt'] - $rs['pend_order_amt'];
    264. 

  264. 		$certexpdt = $rs2['cert_exp_dt'];
    265. 

  265. 		$certid = $rs2['cert_id'];
    266. 

  266. 		$certcode = $rs2['cert_code'];
    267. 

  267. 		$certend = "#".substr($certcode, strlen($certcode)- 4, 4);
    268. 

  268. 		$strsql = "UPDATE certificates SET cert_amt = cert_amt - pend_order_amt WHERE pend_order_id =".$ordID;
    269. 

  269. 		mysql_query($strsql);
    270. 

  270. 		$strsql = "UPDATE certificates SET pend_order_amt = 0, pend_order_id = 0 WHERE pend_order_id =".$ordID;
    271. 

  271. 		mysql_query($strsql);
    272. 

  272. 	//	$strsql = "DELETE certificates WHERE cert_amt <= 0";
    273. 

  273. 	//	mysql_query($strsql);
    274. 

  274. 		$strsql = "UPDATE orders SET ord_cert_id=".$certid.", ord_cert_amt=".$pendingamt." WHERE ordID =".$ordID;
    275. 

  275. 		mysql_query($strsql);
    276. 

  276. 	
    277. 

  277. 	}
    278. 

  278. 	//HCS - DRE 03/07/05 Gift Cert Mod STOP
    279. 

  279. 	
    280. 

  280. 	// GET DELIVERY DATE
    281. 

  281. 	$delivery = getDeliveryDate($ordID);
    282. 

  282. 	
    283. 

  283. 	$sSQL = "SELECT ordID,ordName,ordAddress,ordAddress2,ordCity,ordState,ordZip,ordCountry,ordEmail,ordPhone,ordShipName,ordShipAddress,ordShipAddress2,ordShipCity,ordShipState,ordShipZip,ordShipCountry,ordPayProvider,ordAuthNumber,ordTotal,ordDate,ordStateTax,ordCountryTax,ordHSTTax,ordHandling,ordShipping,ordAffiliate,ordDiscount,ordDiscountText,ordComLoc,ordExtra1,ordExtra2,ordSessionID,ordAddInfo,ordShipType,payProvID FROM orders LEFT JOIN payprovider ON payprovider.payProvID=orders.ordPayProvider WHERE ordAuthNumber<>'' AND ordID='" . mysql_real_escape_string($sorderid) . "'";
    284. 

  284. 	$result = mysql_query($sSQL) or print(mysql_error());
    285. 

  285. 	if(mysql_num_rows($result) > 0){
    286. 

  286. 		$rs = mysql_fetch_assoc($result);
    287. 

  287. 		$orderText = "";
    288. 

  288. 		$success=TRUE;
    289. 

  289. 		$orderID2 = $rs["ordID"];
    290. 

  290. 		$ordAuthNumber = $rs["ordAuthNumber"];
    291. 

  291. 		$ordSessionID = $rs["ordSessionID"];
    292. 

  292. 		$payprovid = $rs["payProvID"];
    293. 

  293. 		if(@$emailheader != "") $saveHeader .= $emailheader;
    294. 

  294. 		eval('global $emailheader' . $payprovid . ';$emailheader = @$emailheader' . $payprovid . ';');
    295. 

  295. 		if(@$emailheader != "") $saveHeader .= $emailheader;
    296. 

  296. 		if(!empty($_SESSION['neworderID'])) {
    297. 

  297. 			$orderText .= $xxTwoOrdIds . $emlNl;
    298. 

  298. 			$orderText .= $xxOrdId . ": " . $rs["ordID"] .', '.$_SESSION['neworderID']. $emlNl;
    299. 

  299. 		} else $orderText .= $xxOrdId . ": " . $rs["ordID"] . $emlNl;
    300. 

  300. 		if($thereference != "") $orderText .= "Transaction Ref" . ": " . $thereference . $emlNl;
    301. 

  301. 		$orderText .= $xxCusDet . ": " . $emlNl;
    302. 

  302. 		if(trim(@$extraorderfield1)!="") $orderText .= $extraorderfield1 . ": " . $rs["ordExtra1"] . $emlNl;
    303. 

  303. 		$orderText .= $rs["ordName"] . $emlNl;
    304. 

  304. 		$orderText .= $rs["ordAddress"] . $emlNl;
    305. 

  305. 		if(@$useaddressline2==TRUE && trim($rs["ordAddress2"]) != '') $orderText .= $rs["ordAddress2"] . $emlNl;
    306. 

  306. 		$orderText .= $rs["ordCity"] . ", " . $rs["ordState"] . $emlNl;
    307. 

  307. 		$orderText .= $rs["ordZip"] . $emlNl;
    308. 

  308. 		$orderText .= $rs["ordCountry"] . $emlNl;
    309. 

  309. 		$orderText .= $xxEmail . ": " . $rs["ordEmail"] . $emlNl;
    310. 

  310. 		$custEmail = $rs["ordEmail"];
    311. 

  311. 		$orderText .= $xxPhone . ": " . $rs["ordPhone"] . $emlNl;
    312. 

  312. 		if(trim(@$extraorderfield2)!="") $orderText .= $extraorderfield2 . ": " . $rs["ordExtra2"] . $emlNl;
    313. 

  313. 		if(trim($rs["ordShipName"]) != "" || trim($rs["ordShipAddress"]) != ""){
    314. 

  314. 			$orderText .= $xxShpDet . ": " . $emlNl;
    315. 

  315. 			$orderText .= $rs["ordShipName"] . $emlNl;
    316. 

  316. 			$orderText .= $rs["ordShipAddress"] . $emlNl;
    317. 

  317. 			if(@$useaddressline2==TRUE && trim($rs["ordShipAddress2"]) != '') $orderText .= $rs["ordShipAddress2"] . $emlNl;
    318. 

  318. 			$orderText .= $rs["ordShipCity"] . ", " . $rs["ordShipState"] . $emlNl;
    319. 

  319. 			$orderText .= $rs["ordShipZip"] . $emlNl;
    320. 

  320. 			$orderText .= $rs["ordShipCountry"] . $emlNl;
    321. 

  321. 		}
    322. 

  322. 		$ordShipType = $rs["ordShipType"];
    323. 

  323. 		if($ordShipType != ""){
    324. 

  324. 			$orderText .= $emlNl . $xxShpMet . ": " . $ordShipType;
    325. 

  325. 			$orderText .= $emlNl . "Estimated Delivery Date: " . date("M j, Y",$delivery['deliveryDate']);
    326. 

  326. 			if($delivery['extended'] > 0) {
    327. 

  327. 				if($delivery['messageToUse'] == 'custom screen') {
    328. 

  328. 					$orderText .= $emlNl . "Your order contains a custom screen. It should take an additional " . $delivery['extended'] . " business days to produce your custom screen before your order will ship.";
    329. 

  329. 				}elseif($delivery['messageToUse'] == 'stock') {
    330. 

  330. 					$orderText .= $emlNl . "Your order contains a back-ordered item. It should take an additional " . $delivery['extended'] . " business days before your order will ship.";
    331. 

  331. 				}
    332. 

  332. 				$orderText .= $emlNl . "Once your order ships it will ship via " . $delivery['method'] . " and will take " . $delivery['days_to_arrive'] . " business days to arrive.";
    333. 

  333. 			}
    334. 

  334. 			if(($rs["ordComLoc"] & 2)==2) $orderText .= $xxWtIns;
    335. 

  335. 			$orderText .= $emlNl;
    336. 

  336. 		}
    337. 

  337. 		$ordAddInfo = trim($rs["ordAddInfo"]);
    338. 

  338. 		if($ordAddInfo != ""){
    339. 

  339. 			$orderText .= $emlNl . $xxAddInf . ": " . $emlNl;
    340. 

  340. 			$orderText .= $ordAddInfo . $emlNl;
    341. 

  341. 		}
    342. 

  342. 		$ordTotal = $rs["ordTotal"];
    343. 

  343. 		$ordDate = $rs["ordDate"];
    344. 

  344. 		$ordStateTax = $rs["ordStateTax"];
    345. 

  345. 		$ordDiscount = $rs["ordDiscount"];
    346. 

  346. 		$ordDiscountText = $rs["ordDiscountText"];
    347. 

  347. 		$ordCountryTax = $rs["ordCountryTax"];
    348. 

  348. 		$ordHSTTax = $rs["ordHSTTax"];
    349. 

  349. 		$ordShipping = $rs["ordShipping"];
    350. 

  350. 		$ordHandling = $rs["ordHandling"];
    351. 

  351. 		$affilID = trim($rs["ordAffiliate"]);
    352. 

  352. 	}else{
    353. 

  353. 		$orderText = "Cannot find customer details for order id: " . $sorderid . $emlNl;
    354. 

  354. 		$sendstoreemail=FALSE;
    355. 

  355. 		$sendcustemail=FALSE;
    356. 

  356. 		$sendaffilemail=FALSE;
    357. 

  357. 		$sendmanufemail=FALSE;
    358. 

  358. 	}
    359. 

  359. 	mysql_free_result($result);
    360. 

  360. 	
    361. 

  361. 	// DETERMINE WETHER TO SEND AN EMAIL TO THE DROPSHIPPER (Mike) FOR A GIFT CERTIFICATE
    362. 

  362. 	$sql_hc = "SELECT co.coCartOption FROM orders o, cart c, cartoptions co
    363. 

  363. 			   WHERE o.ordID = c.cartOrderID
    364. 

  364. 			   AND c.cartID = co.coCartID
    365. 

  365. 			   AND o.ordID = " . $sorderid;
    366. 

  366. 	$res_hc = mysql_query($sql_hc);
    367. 

  367. 	$ctr_email=0;
    368. 

  368. 	$ctr_card=0;
    369. 

  369. 	while($row_hc=mysql_fetch_assoc($res_hc)) {
    370. 

  370. 		if($row_hc['coCartOption'] == 'Email') {
    371. 

  371. 			$ctr_email++;
    372. 

  372. 		}elseif($row_hc['coCartOption'] == 'Card via Mail') {
    373. 

  373. 			$ctr_card++;
    374. 

  374. 		}
    375. 

  375. 	}
    376. 

  376. 	if($ctr_email > 0) {
    377. 

  377. 		if($ctr_card <= 0) {
    378. 

  378. 			$sendmanufemail=FALSE;
    379. 

  379. 		}
    380. 

  380. 	}
    381. 

  381. 	
    382. 

  382. 	$google_form='';
    383. 

  383. 	$showshipdate=FALSE;
    384. 

  384. 	$saveCustomerDetails=$orderText;
    385. 

  385. 	$orderText = $saveHeader . '%digidownloadplaceholder%' . $orderText;
    386. 

  386. 	$sSQL = "SELECT cartID, cartProdId,cartProdName,cartProdPrice,cartQuantity,cartOrderID,p_iscert,pDropship".(@$digidownloads==TRUE?',pDownload':'')." FROM cart INNER JOIN products ON cart.cartProdId=products.pID WHERE cartOrderID='" . mysql_real_escape_string($sorderid) . "'";
    387. 

  387. 	// Blake 12/21/06
    388. 

  388. 	if(!empty($_SESSION['neworderID'])) $sSQL .= " OR cartOrderID='" . mysql_real_escape_string($_SESSION['neworderID']) . "'";
    389. 

  389. 	$sSQL .= " ORDER BY pDropship";
    390. 

  390. 	//
    391. 

  391. 	//echo $sSQL;
    392. 

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

  393. 	$numProdsCart=mysql_num_rows($result);
    394. 

  394. 	if($numProdsCart > 0){
    395. 

  395. 		$old_orderID='';
    396. 

  396. 		while($rs = mysql_fetch_assoc($result)){			
    397. 

  397. 			if(trim($rs["pDownload"]) == "" && trim($rs["p_iscert"]) == 0) $showshipdate=TRUE;
    398. 

  398. 			$localhasdownload=FALSE;
    399. 

  399. 			if(@$digidownloads==TRUE)
    400. 

  400. 			if(trim($rs["pDownload"]) != "") $localhasdownload=TRUE;			
    401. 

  401. 			$saveCartItems='';
    402. 

  402. 			if(!empty($_SESSION['neworderID']) && $old_orderID!=$rs["cartOrderID"]) $saveCartItems = $emlNl . $rs["cartOrderID"] . $emlNl;
    403. 

  403. 			$saveCartItems .= "--------------------------" . $emlNl;
    404. 

  404. 			$saveCartItems .= $xxPrId . ": " . $rs["cartProdId"] . $emlNl;
    405. 

  405. 			$saveCartItems .= $xxPrNm . ": " . $rs["cartProdName"] . $emlNl;
    406. 

  406. 			$saveCartItems .= $xxQuant . ": " . $rs["cartQuantity"] . $emlNl;
    407. 

  407. 			$orderText .= $saveCartItems;
    408. 

  408. 			//changed by blake 6-13-06
    409. 

  409. 			$down_usr_pass='';
    410. 

  410. 			if($localhasdownload==TRUE) {
    411. 

  411. 				$sql_d="SELECT * FROM digitaldownloads WHERE orderID=".$rs["cartOrderID"]." AND type='".$rs["cartProdId"]."'";
    412. 

  412. 					$result_d=mysql_query($sql_d);	
    413. 

  413. 					$num_rows_d=mysql_num_rows($result_d);
    414. 

  414. 					while($row_d=mysql_fetch_assoc($result_d)){
    415. 

  415. 						$allready_has_download=TRUE;
    416. 

  416. 						$down_usr_pass.=$emlNl.'License ID: '.$row_d['licenseID'].$emlNl;
    417. 

  417. 						$down_usr_pass.='Password: '.$row_d['password'].$emlNl.$emlNl;
    418. 

  418. 					}
    419. 

  419. 					if($num_rows_d==0) $allready_has_download=FALSE; 
    420. 

  420. 				for($i=0;$i<$rs["cartQuantity"];$i++) {				
    421. 

  421. 					if(!$allready_has_download){
    422. 

  422. 						$sql_download="SELECT * FROM digitaldownloads WHERE active=1 AND type='".$rs["cartProdId"]."'";
    423. 

  423. 						$result_download=mysql_query($sql_download);
    424. 

  424. 						$num_rows_download=mysql_num_rows($result_download);
    425. 

  425. 						if($num_rows_download>0){
    426. 

  426. 							$row_download=mysql_fetch_assoc($result_download);
    427. 

  427. 							$down_usr_pass.=$emlNl.'License ID: '.$row_download['licenseID'].$emlNl;
    428. 

  428. 							$down_usr_pass.='Password: '.$row_download['password'].$emlNl.$emlNl;
    429. 

  429. 							$sql_update="UPDATE digitaldownloads SET active=0, orderID=".$sorderid." WHERE id=".$row_download['id'];
    430. 

  430. 							mysql_query($sql_update);
    431. 

  431. 						}
    432. 

  432. 					}
    433. 

  433. 				}
    434. 

  434. 			$orderText .= $down_usr_pass;				
    435. 

  435. 			}
    436. 

  436. 			// end change
    437. 

  437. 			
    438. 

  438. 			$theoptions = "";
    439. 

  439. 			$theoptionspricediff=0;
    440. 

  440. 			$sSQL = "SELECT coOptGroup,coCartOption,coPriceDiff,optRegExp,coExtendShipping FROM cartoptions INNER JOIN options ON cartoptions.coOptID=options.optID WHERE coCartID=" . $rs["cartID"] . " ORDER BY coID";
    441. 

  441. 			$result2 = mysql_query($sSQL) or print(mysql_error());
    442. 

  442. 			while($rs2 = mysql_fetch_assoc($result2)){
    443. 

  443. 				$theoptionspricediff += $rs2["coPriceDiff"];
    444. 

  444. 				$optionline = (@$htmlemails==true?"<span style='margin-left: 15px;'>- ":"- - - ") . $rs2["coOptGroup"] . " : " . str_replace(array("\r\n","\n"),array($emlNl,$emlNl),$rs2["coCartOption"]) . ($htmlemails==true ? '</span>' : '');
    445. 

  445. 				if(!empty($rs2["coExtendShipping"])){
    446. 

  446. 					if($rs2["coExtendShipping"]>19999999) {
    447. 

  447. 						$thisyeart=substr($rs2["coExtendShipping"],0,4);
    448. 

  448. 						$thismontht=substr($rs2["coExtendShipping"],4,2);
    449. 

  449. 						$thisdayt=substr($rs2["coExtendShipping"],6,2);
    450. 

  450. 						$optionline .= " (PRE-ORDER. Order will ship after ".$thismontht.'-'.$thisdayt.'-'.$thisyeart.")";
    451. 

  451. 					} else $optionline .= " (This option will extend your shipping time by ".$rs2["coExtendShipping"]." days)";
    452. 

  452. 				}
    453. 

  453. 				$theoptions .= $optionline;
    454. 

  454. 				$saveCartItems .= $optionline . $emlNl;
    455. 

  455. 				if($rs2["coPriceDiff"]==0 || @$hideoptpricediffs==TRUE)
    456. 

  456. 					$theoptions .= $emlNl;
    457. 

  457. 				else{
    458. 

  458. 					$theoptions .= " (";
    459. 

  459. 					if($rs2["coPriceDiff"] > 0) $theoptions .= "+";
    460. 

  460. 					$theoptions .= FormatEmailEuroCurrency($rs2["coPriceDiff"]) . ")" . $emlNl;
    461. 

  461. 				}
    462. 

  462. 				if($rs2["optRegExp"] == "!!") $localhasdownload=FALSE;
    463. 

  463. 			}
    464. 

  464. 			$orderText .= $xxUnitPr . ": " . (@$hideoptpricediffs==TRUE ? FormatEmailEuroCurrency($rs["cartProdPrice"] + $theoptionspricediff) : FormatEmailEuroCurrency($rs["cartProdPrice"])) . $emlNl;
    465. 

  465. 			
    466. 

  466. 			$orderText .= $theoptions;
    467. 

  467. 			if($rs["pDropship"] != 0){
    468. 

  468. 				$index=0;
    469. 

  469. 				for($index=0; $index<$ndropshippers; $index++){
    470. 

  470. 					if($dropShippers[$index][0]==$rs["pDropship"]) break;
    471. 

  471. 				}
    472. 

  472. 				if($index>=$ndropshippers){
    473. 

  473. 					$ndropshippers=$index+1;
    474. 

  474. 					$dropShippers[$index][1]="";
    475. 

  475. 				}
    476. 

  476. 				$dropShippers[$index][0] = $rs["pDropship"];
    477. 

  477. 				$dropShippers[$index][1] .= $saveCartItems;
    478. 

  478. 			}
    479. 

  479. 			if($localhasdownload==TRUE) $hasdownload=TRUE;
    480. 

  480. 			$old_orderID=$rs["cartOrderID"];
    481. 

  481. 			mysql_free_result($result2);
    482. 

  482. 		}
    483. 

  483. 		$orderText .= "--------------------------" . $emlNl;
    484. 

  484. 

  485. 		//HCS - DRE 03/02/05 Gift Cert Mod START
    486. 

  486. 		if($certstr != "") {
    487. 

  487. 			$certarray = explode("|",$certstr);
    488. 

  488. 			for ($x = 0; $x < count($certarray);$x++) {
    489. 

  489. 				$orderText .= "Gift Certificate Value/Code: ".$certarray[$x].$emlNl;
    490. 

  490. 			}
    491. 

  491. 			$orderText .= "You can enter the certificate code the next time you order or print a personalized gift certificate here. http://ifrogz.com/order_info.php Enter your email and order number to login. Once logged in click on 'Print Gift Certificates'. " . $emlNl;
    492. 

  492. 			$orderText .= "--------------------------" . $emlNl;
    493. 

  493. 		}elseif($certorder) {
    494. 

  494. 			$orderText .= "Certificate Code(s) will be issued when Payment has been confirmed." . $emlNl;
    495. 

  495. 			$orderText .= "--------------------------" . $emlNl;
    496. 

  496. 		}
    497. 

  497. 		//HCS - DRE 03/02/05 Gift Cert Mod STOP
    498. 

  498. 		
    499. 

  499. 		$orderText .= $xxOrdTot . " : " . FormatEmailEuroCurrency($ordTotal) . $emlNl;
    500. 

  500. 		if($shipType != 0) $orderText .= $xxShippg . " : " . FormatEmailEuroCurrency($ordShipping) . $emlNl;
    501. 

  501. 		if((double)$ordHandling!=0.0) $orderText .= $xxHndlg . " : " . FormatEmailEuroCurrency($ordHandling) . $emlNl;
    502. 

  502. 		if((double)$ordDiscount!=0.0) $orderText .= $xxDscnts . " : " . FormatEmailEuroCurrency($ordDiscount) . $emlNl;
    503. 

  503. 		if((double)$ordStateTax!=0.0) $orderText .= $xxStaTax . " : " . FormatEmailEuroCurrency($ordStateTax) . $emlNl;
    504. 

  504. 		if((double)$ordCountryTax!=0.0) $orderText .= $xxCntTax . " : " . FormatEmailEuroCurrency($ordCountryTax) . $emlNl;
    505. 

  505. 		if((double)$ordHSTTax!=0.0) $orderText .= $xxHST . " : " . FormatEmailEuroCurrency($ordHSTTax) . $emlNl;
    506. 

  506. 		$ordGrandTotal = ($ordTotal+$ordStateTax+$ordCountryTax+$ordHSTTax+$ordShipping+$ordHandling)-$ordDiscount;
    507. 

  507. 		
    508. 

  508. 		//HCS - DRE 03/07/05 Gift Cert Mod START
    509. 

  509. 		if($pendingamt > 0) {
    510. 

  510. 			$ordGrandTotal -= $pendingamt;
    511. 

  511. 			if($ordGrandTotal == 0) {
    512. 

  512. 				$strsql = "UPDATE orders SET ordStatus=3 WHERE ordID =".$ordID;
    513. 

  513. 				mysql_query($strsql);
    514. 

  514. 			}
    515. 

  515. 	
    516. 

  516. 			$orderText .= "Gift Certificate Amount Applied to Order: " . FormatEmailEuroCurrency($pendingamt) ." (ending in ".$certend.")". $emlNl;
    517. 

  517. 		}
    518. 

  518. 		//HCS - DRE 03/07/05 Gift Cert Mod STOP
    519. 

  519. 		
    520. 

  520. 		$orderText .= $xxGndTot . " : " . FormatEmailEuroCurrency($ordGrandTotal) . $emlNl;
    521. 

  521. 		
    522. 

  522. 		//HCS - DRE 03/06/05 Gift Cert Mod START
    523. 

  523. 		if($pendingamt > 0) {
    524. 

  524. 			if ($remainbal > 0) {
    525. 

  525. 				$orderText .= $emlNl."--------------------------".$emlNl;
    526. 

  526. 				$orderText .= "Amount Unused on Gift Certificate: " . FormatEmailEuroCurrency($remainbal) ." (ending in ".$certend.")". $emlNl;
    527. 

  527. 				$orderText .= "This Gift Certificate will Expire On: " . date("M j, Y", $certexpdt) . $emlNl;
    528. 

  528. 			}else{
    529. 

  529. 				$orderText .= $emlNl."--------------------------".$emlNl;			
    530. 

  530. 				$orderText .= "You have exhausted all funds on this Gift Certificate " . $emlNl;
    531. 

  531. 			}
    532. 

  532. 		}
    533. 

  533. 		//HCS - DRE 03/06/05 Gift Cert Mod STOP
    534. 

  534. 		
    535. 

  535. 		eval('global $emailfooter' . $payprovid . ';$emailheader = @$emailfooter' . $payprovid . ';');
    536. 

  536. 		if(@$emailheader != "") $orderText .= $emailheader;
    537. 

  537. 		if(@$emailfooter != "") $orderText .= $emailfooter;                                                                                                                                                                                                                                        
    538. 

  538. 	}else{
    539. 

  539. 		$orderText .= "Cannot find order details for order id: " . $sorderid . $emlNl;
    540. 

  540. 	}	
    541. 

  541. 	mysql_free_result($result);
    542. 

  542. 	if($hasdownload==TRUE && @$digidownloademail != ""){
    543. 

  543. 		$fingerprint = vrhmac($digidownloadsecret, $sorderid . $ordAuthNumber . $ordSessionID);
    544. 

  544. 		$fingerprint = substr($fingerprint, 0, 14);
    545. 

  545. 		$digidownloademail = str_replace('%orderid%',$ordID,$digidownloademail);
    546. 

  546. 		$digidownloademail = str_replace('%password%',$fingerprint,$digidownloademail);
    547. 

  547. 		$digidownloademail = str_replace('%nl%',$emlNl,$digidownloademail);
    548. 

  548. 		$orderEmailText = str_replace('%digidownloadplaceholder%',$digidownloademail,$orderText);
    549. 

  549. 	} else {
    550. 

  550. 		$orderEmailText = str_replace('%digidownloadplaceholder%',"",$orderText);
    551. 

  551. 	}
    552. 

  552. 	$orderText = str_replace('%digidownloadplaceholder%',"",$orderText);
    553. 

  553. 	if($sendstoreemail){
    554. 

  554. 		$headers = str_replace('%from%',$sEmail,$customheaders);
    555. 

  555. 		$headers = str_replace('%to%','orders@ifrogz.com',$headers);
    556. 

  556. 		mail('orders@ifrogz.com', $xxOrdStr, $orderEmailText, $headers);
    557. 

  557. 	}
    558. 

  558. 	// And one for the customer
    559. 

  559. 	if($sendcustemail){
    560. 

  560. 		///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
    561. 

  561. 		$headers = str_replace('%from%',$sEmail,$customheaders);
    562. 

  562. 		$headers = str_replace('%to%',$custEmail,$headers);
    563. 

  563. 		$strdaterange='';
    564. 

  564. 		if($showshipdate) {
    565. 

  565. 			$strrange=$xxTouSooShipping[$ordShipType];
    566. 

  566. 			$strdaterange=str_replace("%date_range%",$strrange,$xxTouSooDate);
    567. 

  567. 		}
    568. 

  568. 		$strfinal=str_replace("%dateorno%",$strdaterange,$xxTouSoo);
    569. 

  569. 		///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
    570. 

  570. 

  571.         // Mail services
    572. 

  572.         $mailer = new Mailer('AMAZON_IFROGZ', 'GMAIL', 'SEND_MAIL');
    573. 

  573. 

  574.         // Sender
    575. 

  575.         $mailer->set_sender(new EmailAddress($sEmail));
    576. 

  576.         $mailer->set_reply_to(new EmailAddress('support@ifrogz.com', 'iFrogz Customer Service'));
    577. 

  577. 

  578.         // Recepients
    579. 

  579. 		$mailer->add_recipient(new EmailAddress($custEmail));
    580. 

  580. 

  581. 		// Subject
    582. 

  582. 		$mailer->set_subject($xxTnxOrd);
    583. 

  583.         
    584. 

  584.         // Message
    585. 

  585.         $mailer->set_content_type('text/html');
    586. 

  586.         $mailer->set_message($strfinal . $emlNl . $emlNl . $orderEmailText);
    587. 

  587. 

  588.         // Send
    589. 

  589.         $mailer->send();
    590. 

  590. 	}
    591. 

  591. 	// Drop Shippers
    592. 

  592. 	if($sendmanufemail){
    593. 

  593. 		for($index=0; $index < $ndropshippers; $index++){
    594. 

  594. 			if(@$dropshipsubject=="") $dropshipsubject="We have received the following order";
    595. 

  595. 			$sSQL = "SELECT dsEmail,dsAction FROM dropshipper WHERE dsID=" . $dropShippers[$index][0];
    596. 

  596. 			$result = mysql_query($sSQL) or print(mysql_error());
    597. 

  597. 			if($rs = mysql_fetch_assoc($result)){
    598. 

  598. 				if(($rs["dsAction"] & 1)==1 || $sendmanufemail==2){
    599. 

  599. 					$saveHeader = "";
    600. 

  600. 					$saveFooter = "";
    601. 

  601. 					$saveHeader .= @$dropshipheader;
    602. 

  602. 					eval('global $dropshipheader' . $dropShippers[$index][0] . ';$emailheader = @$dropshipheader' . $dropShippers[$index][0] . ';');
    603. 

  603. 					if($emailheader != "") $saveHeader .= $emailheader;
    604. 

  604. 					eval('global $dropshipfooter' . $dropShippers[$index][0] . ';$saveFooter = @$dropshipfooter' . $dropShippers[$index][0] . ';');
    605. 

  605. 					$saveFooter .= @$dropshipfooter;
    606. 

  606. 					$headers = str_replace('%from%','orders@ifrogz.com',$customheaders);
    607. 

  607. 					$headers = str_replace('%to%','dropship@ifrogz.com',$headers);
    608. 

  608. 					mail('dropship@ifrogz.com', $dropshipsubject, $saveHeader . $saveCustomerDetails . $dropShippers[$index][1] . $saveFooter, $headers);
    609. 

  609. 					//mail('dropship@ifrogz.com', 'A dropship order has been placed on ifrogz', $saveHeader . $saveCustomerDetails . $dropShippers[$index][1] . $saveFooter, $headers);
    610. 

  610. 				}
    611. 

  611. 			}
    612. 

  612. 		}
    613. 

  613. 	}
    614. 

  614. 	if($sendaffilemail){
    615. 

  615. 		if($affilID != ""){
    616. 

  616. 			$sSQL = "SELECT affilEmail,affilInform FROM affiliates WHERE affilID='" . mysql_real_escape_string($affilID) . "'";
    617. 

  617. 			$result = mysql_query($sSQL) or print(mysql_error());
    618. 

  618. 			if($rs = mysql_fetch_assoc($result)){
    619. 

  619. 				if((int)$rs["affilInform"]==1){
    620. 

  620. 					$affiltext = $xxAff1 . " " . FormatEmailEuroCurrency($ordTotal-$ordDiscount) . ".".$emlNl.$emlNl.$xxAff2.$emlNl.$emlNl.$xxThnks.$emlNl;
    621. 

  621. 					$headers = str_replace('%from%',$sEmail,$customheaders);
    622. 

  622. 					$headers = str_replace('%to%',trim($rs["affilEmail"]),$headers);
    623. 

  623. 					mail(trim($rs["affilEmail"]), $xxAff3, $emlNl . $affiltext, $headers);
    624. 

  624. 				}
    625. 

  625. 			}
    626. 

  626. 			mysql_free_result($result);
    627. 

  627. 		}
    628. 

  628. 	}
    629. 

  629. 	if($doshowhtml){
    630. 

  630. ?>
    631. 

  631.      <style type="text/css">
    632. 

  632. 	 <!--
    633. 

  633. 	 
    634. 

  634. 	 -->
    635. 

  635. 	 </style>
    636. 

  636. 	 <div id="cart_nav"><img  src="/lib/images/new_images/subnav_gray_13.gif" alt="View Order" /><img src="/lib/images/new_images/subnav_gray_15.gif" alt="Customer Info" /><img src="/lib/images/new_images/subnav_gray_17.gif" alt="Final Review" /><img src="/lib/images/new_images/subnav_gray_19.gif" alt="Confirmation" /><img src="/lib/images/new_images/subnav_green_21.gif" alt="View Receipt" /></div>
    637. 

  637. 	  <table border="0" cellspacing="<?php print $maintablespacing?>" cellpadding="<?php print $maintablepadding?>" width="<?php print $maintablewidth?>" bgcolor="<?php print $maintablebg?>" align="center">
    638. 

  638.         <tr>
    639. 

  639.           <td width="100%">
    640. 

  640.             <table width="<?php print $innertablewidth?>" border="0" cellspacing="<?php print $innertablespacing?>" cellpadding="<?php print $innertablepadding?>" bgcolor="<?php print $innertablebg?>">
    641. 

  641. 		<?php	//if(@$digidownloads!=TRUE){ ?>
    642. 

  642. 			  <tr> 
    643. 

  643.                 <td width="100%" align="left">
    644. 

  644. 					<h2>Order Placed Successfully</h2>
    645. 

  645. 					<?php	if(@$digidownloads && $hasdownload) echo '<div style="font-size: 16px;color:#9F0000;font-weight:bold;">Please scroll to the bottom of the page to download your software.</div>';?>
    646. 

  646. 

  647. 					<div style="margin-bottom: 10px; padding: 0">
    648. 

  648. 						<p style="font-size: 16px"><span style="font-weight:bold">Thank You for shopping
    649. 

  649. 								at ifrogz!</span> The ordering process is now complete. Please
    650. 

  650. 								read the following information about your order.</p>
    651. 

  651. 					</div>
    652. 

  652. 					<div style="border: 1px solid #888; padding: 0; margin-top: 0">
    653. 

  653. 						<div style="float:left; width: 400px; margin: 20px 0 20px 20px">
    654. 

  654. 							<h2>YOUR ORDER
    655. 

  655. 								HAS BEEN RECEIVED.</h2>
    656. 

  656. 							<p style="margin:0 0 10px 0; padding:0; font-size: 14px">Your order has been
    657. 

  657. 								received and will be processed as soon as payment is verified.</p>
    658. 

  658. 							<? if(!empty($_SESSION['neworderID'])){?> 
    659. 

  659. 							<h2>Your Order Will Be Shipped in Two Shipments.  Order Numbers are</h2>
    660. 

  660. 							<h3><?=$orderID2?>,<?=$_SESSION['neworderID']?></h3>
    661. 

  661. 							<? } else { ?>
    662. 

  662. 							<h2>Your Order Numbers is</h2>
    663. 

  663. 							<h3><?=$orderID2?></h3>
    664. 

  664. 							<? } ?>
    665. 

  665. 							<? if(!empty($_SESSION['neworderID'])){?>
    666. 

  666. 							<p style="margin:0 0 10px 0; padding:0; font-size: 14px">We will send your products in two separate orders because they will be shipped from two of our warehouses. Please make a note
    667. 

  667. 								of these number in the event that you need to contact us about your orders.</p>
    668. 

  668. 							<? } else { ?>
    669. 

  669. 							<p style="margin:0 0 10px 0; padding:0; font-size: 14px">Please make a note
    670. 

  670. 								of this number in the event that you need to contact us about your order.</p>
    671. 

  671. 							<? } ?>
    672. 

  672. 							<h2>Your Delivery Date</h2>
    673. 

  673. 							<h3><!--<span style="color: #000;">-->
    674. 

  674. 								Delivery Date:<!--</span>--> <?=date("M j, Y",$delivery['deliveryDate'])?></h3>
    675. 

  675. 					<?php
    676. 

  676. 					if($delivery['extended'] > 0) {
    677. 

  677. 						if($delivery['messageToUse'] == 'custom screen') {
    678. 

  678. 					?>
    679. 

  679. 							<p style="margin:0 0 10px 0; padding:0; font-size: 14px">Your order contains a custom screen. It will
    680. 

  680. 							take an additional <?=$delivery['extended']?> business days to produce your custom screen before your 
    681. 

  681. 							order will ship.  When it ships, your order will ship via <?=$delivery['method']?> and will take 
    682. 

  682. 							<?=$delivery['days_to_arrive']?> business days to arrive.</p>
    683. 

  683. 					<?php
    684. 

  684. 						}elseif($delivery['messageToUse'] == 'stock') {
    685. 

  685. 					?>
    686. 

  686. 							<p style="margin:0 0 10px 0; padding:0; font-size: 14px">Your order contains a back-ordered item. It will
    687. 

  687. 							take an additional <?=$delivery['extended']?> business days before your order will ship. When it ships, 
    688. 

  688. 							it will ship via <?=$delivery['method']?> and will take <?=$delivery['days_to_arrive']?> to arrive.</p>
    689. 

  689. 					<?php
    690. 

  690. 						}
    691. 

  691. 					}
    692. 

  692. 					?>
    693. 

  693. 							<p style="margin:0 0 10px 0; padding:0; font-size: 14px">You should receive your 
    694. 

  694. 								order in the mail by this date.  You will also receive an e-mail with your tracking 
    695. 

  695. 								number once we get your tracking number.</p>
    696. 

  696. 						</div>
    697. 

  697. 						<div style="float:right; width: 400px; margin: 20px 20px 4px 0">
    698. 

  698. 							<h2>Your Receipt</h2>
    699. 

  699. 							<p style="margin:0 0 10px 0; padding:0; font-size: 14px">You have been sent
    700. 

  700. 								an e-mail to the address you provided containing your order information.
    701. 

  701. 								If you would like an invoice, you can print one from our <a href="http://www.ifrogz.com/order_info.php" style="font-size: 14px">invoice</a> page.</p>
    702. 

  702. 							<h2>Your Order Status</h2>
    703. 

  703. 							<p style="margin:0 0 10px 0; padding:0; font-size: 14px">We keep track of
    704. 

  704. 								your order in realtime! If you would like to know what the status of your
    705. 

  705. 								order is, visit our <a href="http://www.ifrogz.com/order_info.php" style="font-size: 14px">tracking</a> 
    706. 

  706. 								page.</p>
    707. 

  707. 							<h2>We're Here for You</h2>
    708. 

  708. 							<p style="margin:0 0 10px 0; padding:0; font-size: 14px">ifrogz will
    709. 

  709. 								provide you with the best service possible. If you have any questions or
    710. 

  710. 								concerns regarding your order, please contact us at support@ifrogz.com
    711. 

  711. 								or at the phone number below.</p>
    712. 

  712. 							<h2 style="text-align: left; margin:0 0 10px 0;">Your Shopping Cart Has Been
    713. 

  713. 								Emptied</h2>
    714. 

  714. 							<p style="margin:0 0 10px 0; padding:0; font-size: 14px">The items you purchased
    715. 

  715. 								have been removed.</p>
    716. 

  716. 							<!--				<h2 style="text-align: left; margin:0 0 10px 0;">Want Individual Bands?</h2>
    717. 

  717. 							<p style="margin:0 0 10px 0; padding:0; font-size: 14px"><a href="http://bandsonhand.com" title="Bands On Hand">BandsonHand.com</a> carries 100% silicone bracelets in-stock so you don't have to wait. Choose a category and find a band that meets your needs. Order individual bands or groups of bands. All our bands are in-stock and guaranteed to ship the next business day after you order.</p>
    718. 

  718. 			-->
    719. 

  719. 						</div>
    720. 

  720. 						<div style="clear: both"></div>
    721. 

  721. 					</div>
    722. 

  722. 					
    723. 

  723. 					
    724. 

  724.                 </td>
    725. 

  725. 			  </tr>
    726. 

  726. 		<?php	//} ?>
    727. 

  727. 			</table>
    728. 

  728. 		  </td>
    729. 

  729.         </tr>
    730. 

  730.       </table>
    731. 

  731. <?php
    732. 

  732.  	}
    733. 

  733. /* print $google_form; */
    734. 

  734. } 
    735. 

  735. 

  736. 

  737. ?>
    738.