<cfsavecontent variable="headercontent">
<cfoutput>
<title>Purchase the NYC Coupon Pak</title>
<meta name="description" content="Save Big Now with NYC CouponPak!">
</cfoutput>
</cfsavecontent>

<cfinclude template="header.cfm">

<table width="900">

<Tr>
<Td width="50%">

<Table width="100%">
<Tr><Td style="background-color:25408d"><centeR>
<font face="verdana" size="+2" color="white">
<Cfif parameterexists(url.process)>
THANK YOU
<cfelse>
BUY NOW<Br>
</cfif>
<Table><Tr><TD></TD></Tr></Table>
<font face="verdana" size="+1" color="yellow">
Save Big Now with NYC CouponPak!<Br><Table><Tr><TD></TD></Tr></Table>

</Td></Tr>
<Tr><Td bgcolor="white" style="padding:10px;">
<Font face="verdana" size="+2" color="49ad53">

<Cfif parameterexists(url.process)>

<Cfif #form.email# is not #form.email2#>
Error, email addresses do not match. <a href = "javascript:history.back()">click here</a> to go back and check your information.
<Cfabort>
</Cfif>
<CFSET CurrentDateTime = #CreateODBCDateTime(Now())#>




<!--- ColdFusion's cfhttp object is specifically designed to create a post,
and retrieve the results.  Those results are accessed in cfhttp.filecontent --->
<!--- By default, this sample code is designed to post to our test server
for developer accounts: https://test.authorize.net/gateway/transact.dll
for real accounts (even in test mode), please make sure that you are\posting to: https://secure.authorize.net/gateway/transact.dll --->
<cfhttp method="Post" url="https://secure.authorize.net/gateway/transact.dll ">
	<!--- the API Login ID and Transaction Key must be replaced with valid values --->
	<cfhttpparam type="Formfield" name="x_login" value="2d7azPPx23">
	<cfhttpparam type="Formfield" name="x_tran_key" value="7a5VkmM372PU3Kh2">

	<cfhttpparam type="Formfield" name="x_delim_data" value="TRUE">
	<cfhttpparam type="Formfield" name="x_delim_char" value="|">
	<cfhttpparam type="Formfield" name="x_relay_response" value="FALSE">
	<cfhttpparam type="Formfield" name="x_test_request" value="FALSE">

	<cfhttpparam type="Formfield" name="x_type" value="AUTH_CAPTURE">
	<cfhttpparam type="Formfield" name="x_method" value="CC">
	<cfhttpparam type="Formfield" name="x_card_num" value="#form.ccnum#">
	<cfhttpparam type="Formfield" name="x_exp_date" value="#form.ccexpire#">

	<cfhttpparam type="Formfield" name="x_amount" value="9.95">
	<cfhttpparam type="Formfield" name="x_description" value="NYC Coupon Pak">

	<cfhttpparam type="Formfield" name="x_first_name" value="#form.firstname#">
	<cfhttpparam type="Formfield" name="x_last_name" value="#form.lastname#">
	<cfhttpparam type="Formfield" name="x_address" value="#form.address#">
	<cfhttpparam type="Formfield" name="x_state" value="#form.state#">
	<cfhttpparam type="Formfield" name="x_zip" value="#form.zip#">
	<!--- Additional fields can be added here as outlined in the AIM integration
	guide at: http://developer.authorize.net --->
	<!--- The following fields show an example of how to include line item details, they are commented out by default.
	<cfhttpparam type="Formfield" name="x_line_item" value="item1<|>golf balls<|><|>2<|>18.95<|>Y">
	<cfhttpparam type="Formfield" name="x_line_item" value="item2<|>golf bag<|>Wilson golf carry bag, red<|>1<|>39.99<|>Y">
	<cfhttpparam type="Formfield" name="x_line_item" value="item3<|>book<|>Golf for Dummies<|>1<|>21.99<|>Y">
	--->
</cfhttp>

<!--- Because coldfusion's ListToArray object ignores empty fields, we must
put a space in all empty fields to make sure that they are not skipped --->
<cfset post_response=Replace(cfhttp.filecontent,"||","| |", "all")>
<!--- the same command is run twice, because the first time it only adjusts
every other empty field --->
<cfset post_response=Replace(post_response,"||","| |", "all")>

<!--- now the ListToArray method can be used without skipping fields --->
<cfset response_array=ListToArray(post_response, "|")>

<!--- the results are output to the screen in the form of an html numbered list. --->
<!--- individual elements of the array could be accessed to read certain
response fields.  For example, response_array[1] would return the Response
Code, response_array[3] would return the Response Reason Code.
For a list of response fields, please review the AIM Implementation Guide --->

<Cfif #response_array[4]#  contains 'Approved'>




<cfset couponlink = 'To Come'>

<Cfset utime = #DateDiff("s", CreateDate(1970,1,1), now())#>
<Cfset dt = '#dateformat(currentdatetime,'mmyyyy')#'>

<cfhttp url="http://www.cityguideny.com/pakcoupons#dt#.pdf" method="get" resolveurl="yes" charset="iso-8859-1" path="/home/home2/domains/couponpak" file="#utime#.pdf" timeout="10">

<Cfset couponlink = 'http://nyccouponpak.com/#utime#.pdf'>

<cfquery name=addphoto datasource="cityguide">

INSERT INTO couponpak(datetime,
firstname,
email,
lastname,
address,
city,
state,
zip,
country,
couponlink,
paid)

VALUES	(#currentdatetime#,'#form.firstname#','#form.email#','#form.lastname#','#form.address#','#form.city#','#form.state#','#form.zip#','#form.country#','#couponlink#',1)

		</cfquery>


<CFMAIL
TO="[email protected],[email protected],[email protected]"
SUBJECT="COUPONPAK Order Processed - #form.firstname# #form.lastname#"
 FROM="NYC CouponPak <[email protected]>"
             SERVER="Mail.davlermedia.com"
username="Davler\webmail"
password="Webhome22@"


>

First Name: #form.firstname#
Last Name: #form.lastname#
Email: #form.email#
Address: #form.address#
City: #form.city#
State: #form.state#
Zip: #form.zip#
Country: #form.country#
Link: #couponlink#

</cfmail>

<cfquery name="Getorder" dataSource="cityguide">
select id  from couponpak
order by id desc
limit 0,1
</cfquery>

<cfoutput>
<img src="https://shareasale.com/sale.cfm?amount=9.95&tracking=#Getorder.id#&transtype=sale&merchantID=50817" width="1" height="1">
</cfoutput>

<!-- Google Code for Sale Conversion Page -->
<script type="text/javascript">
/* <![CDATA[ */
var google_conversion_id = 973992265;
var google_conversion_language = "en";
var google_conversion_format = "3";
var google_conversion_color = "ffffff";
var google_conversion_label = "4jJwCOf09QgQyeK30AM";
var google_conversion_value = 0;
var google_remarketing_only = false;
/* ]]> */
</script>
<script type="text/javascript"
src="//www.googleadservices.com/pagead/conversion.js">
</script>
<noscript>
<div style="display:inline;">
<img height="1" width="1" style="border-style:none;" alt=""
src="//www.googleadservices.com/pagead/conversion/973992265/?value=0&amp;label=4jJwCOf09QgQyeK30AM&amp;guid=ON&amp;script=0"/>
</div>
</noscript>


<CFMAIL
TO="#form.email#"
SUBJECT="NYCCouponPak.com Order Confirmation"
 FROM="NYC CouponPak <[email protected]>"
             SERVER="Mail.davlermedia.com"
username="Davler\webmail"
password="Webhome22@"

type="html"
>
<img src="http://nyccouponpak.com/logo-crop.png">
<p>
Here is your NYC CouponPak confirmation.
<p>
Your credit card is being charged for $9.95.
<p>
Thank you for purchasing the NYC COUPON PAK. To download your coupon pack, click here:
<a href="#couponlink#">#couponlink#</a>
<p>
Print them all, or just the coupons you wish to use! We hope you enjoy using the NYC Coupon Pak and save lots of money while visiting New York.
Please tell your friends about how they can save money with NYC CouponPak.

<p>
Please do not reply to this email. If you have any questions, please contact [email protected].



</cfmail>


<Cfquery name="Getconfirm" dataSource="cityguide">
select copy from columntable
where id = 88374
</cfquery>

<Font face="verdana" size="+1" color="red">
<Cfoutput query="getconfirm">#copy#</Cfoutput>
</Font>


<Cfelse>
<Font face="verdana" size="+1" color="red">
Your transaction was declined, please <a href = "javascript:history.back()">click here</a> to go back and check your payment information.


</Cfif>

<Cfelse>




<cfquery  name="Getstuff" dataSource="cityguide">
select COPY from columntable
where id =87826
</cfquery>

<Cfoutput query="getstuff">
#copy#</Cfoutput>
<font size=-1 color="black"><br>
For customer service and sales info, <a href="customerservice.cfm">click here</a>.</font>
<cfform action="purchase.cfm?process=on" method="post"  enctype="multipart/form-data">
   <table width=100% cellspacing=0 cellpadding=2 border=0>
  <tr><td>
	  <b><font SIZE="-1" FACE="verdana" color="25408d">First Name:</font></b>
  </td><td>
	  <cfinput NAME="firstname" SIZE="25" required="Yes" message="You must provide your first name">
  </td></tr>
    <tr><td>
	  <b><font SIZE="-1" FACE="verdana" color="25408d">Last Name:</font></b>
  </td><td>
  	  <cfinput NAME="lastname" SIZE="25" required="Yes" message="You must provide your last name">
  </td></tr>

      <tr><td>
	  <b><font SIZE="-1" FACE="verdana" color="25408d">Your Email Address:</font></b>
  </td><td>
  	  <cfinput NAME="email" SIZE="25" required="Yes" message="You must provide your email address">
  </td></tr>
      <tr><td>
	  <b><font SIZE="-1" FACE="verdana" color="25408d">Confirm Email Address:</font></b>
  </td><td>
  	  <cfinput NAME="email2" SIZE="25" required="Yes" message="You must confirm your email address">
  </td></tr>

    <tr><td>
	  <b><font SIZE="-1" FACE="verdana" color="25408d">Address:</font></b>
  </td><td>
  	  <cfinput NAME="address" SIZE="25" required="Yes" message="You must enter your address">
  </td></tr>

    <tr><td>
	  <b><font SIZE="-1" FACE="verdana" color="25408d">City:</font></b>
  </td><td>
  	  <cfinput NAME="city" SIZE="25" required="Yes" message="You must enter your city">
  </td></tr>

    <tr><td>
	  <b><font SIZE="-1" FACE="verdana" color="25408d">State:</font></b>
  </td><td>
  	  <cfinput NAME="state" SIZE="3" required="Yes" message="You must enter your state">
  </td></tr>

    <tr><td>
	  <b><font SIZE="-1" FACE="verdana" color="25408d">Zip:</font></b>
  </td><td>
  	  <cfinput NAME="zip" SIZE="25" required="Yes" message="You must enter your zip code">
  </td></tr>

      <tr><td>
	  <b><font SIZE="-1" FACE="verdana" color="25408d">Country:</font></b>
  </td><td>
     <select name="country" SIZE="1">
                <option value="US" >United States
                <option value="AF" >Afghanistan
                <option value="AL" >Albania
                <option value="DZ" >Algeria
                <option value="AS" >American Samoa
                <option value="AD" >Andorra
                <option value="AO" >Angola
                <option value="AI" >Anguilla
                <option value="AQ" >Antarctica
                <option value="AG" >Antigua and Barbuda
                <option value="AR" >Argentina
                <option value="AM" >Armenia
                <option value="AW" >Aruba
                <option value="AU" >Australia
                <option value="AT" >Austria
                <option value="AZ" >Azerbaijan
                <option value="BS" >Bahamas
                <option value="BH" >Bahrain
                <option value="BD" >Bangladesh
                <option value="BB" >Barbados
                <option value="BY" >Belarus
                <option value="BE" >Belgium
                <option value="BZ" >Belize
                <option value="BJ" >Benin
                <option value="BM" >Bermuda
                <option value="BT" >Bhutan
                <option value="BO" >Bolivia
                <option value="BA" >Bosnia and Herzegowina
                <option value="BW" >Botswana
                <option value="BV" >Bouvet Island
                <option value="BR" >Brazil
                <option value="IO" >British Indian Ocean Territory
                <option value="BN" >Brunei Darussalam
                <option value="BG" >Bulgaria
                <option value="BF" >Burkina Faso
                <option value="BI" >Burundi
                <option value="KH" >Cambodia
                <option value="CM" >Cameroon
                <option value="CA" >Canada
                <option value="CV" >Cape Verde
                <option value="KY" >Cayman Islands
                <option value="CF" >Central African Republic
                <option value="TD" >Chad
                <option value="CL" >Chile
                <option value="CN" >China
                <option value="CX" >Christmas Island
                <option value="CC" >Cocos (Keeling) Islands
                <option value="CO" >Colombia
                <option value="KM" >Comoros
                <option value="CG" >Congo
                <option value="CK" >Cook Islands
                <option value="CR" >Costa Rica
                <option value="CI" >Cote D'Ivoire
                <option value="HR" >Croatia (local name: Hrvatska)
                <option value="CU" >Cuba
                <option value="CY" >Cyprus
                <option value="CZ" >Czech Republic
                <option value="DK" >Denmark
                <option value="DJ" >Djibouti
                <option value="DM" >Dominica
                <option value="DO" >Dominican Republic
                <option value="TP" >East Timor
                <option value="EC" >Ecuador
                <option value="EG" >Egypt
                <option value="SV" >El Salvador
                <option value="GQ" >Equatorial Guinea
                <option value="ER" >Eritrea
                <option value="EE" >Estonia
                <option value="ET" >Ethiopia
                <option value="FK" >Falkland Islands (Malvinas)
                <option value="FO" >Faroe Islands
                <option value="FJ" >Fiji
                <option value="FI" >Finland
                <option value="FR" >France
                <option value="FX" >France, Metropolitan
                <option value="GF" >French Guiana
                <option value="PF" >French Polynesia
                <option value="TF" >French Southern Territories
                <option value="GA" >Gabon
                <option value="GM" >Gambia
                <option value="GE" >Georgia
                <option value="DE" >Germany
                <option value="GH" >Ghana
                <option value="GI" >Gibraltar
                <option value="GR" >Greece
                <option value="GL" >Greenland
                <option value="GD" >Grenada
                <option value="GP" >Guadeloupe
                <option value="GU" >Guam
                <option value="GT" >Guatemala
                <option value="GN" >Guinea
                <option value="GW" >Guinea-Bissau
                <option value="GY" >Guyana
                <option value="HT" >Haiti
                <option value="HM" >Heard and Mc Donald Islands
                <option value="HN" >Honduras
                <option value="HK" >Hong Kong
                <option value="HU" >Hungary
                <option value="IS" >Iceland
                <option value="IN" >India
                <option value="ID" >Indonesia
                <option value="IR" >Iran (Islamic Republic of)
                <option value="IQ" >Iraq
                <option value="IE" >Ireland
                <option value="IL" >Israel
                <option value="IT" >Italy
                <option value="JM" >Jamaica
                <option value="JP" >Japan
                <option value="JO" >Jordan
                <option value="KZ" >Kazakhstan
                <option value="KE" >Kenya
                <option value="KI" >Kiribati
                <option value="KP" >Korea, Democratic Republic of
                <option value="KR" >Korea, Republic of
                <option value="KW" >Kuwait
                <option value="KG" >Kyrgyzstan
                <option value="LA" >Lao Fan's Democratic Republic
                <option value="LV" >Latvia
                <option value="LB" >Lebanon
                <option value="LS" >Lesotho
                <option value="LR" >Liberia
                <option value="LY" >Libyan Arab Jamahiriya
                <option value="LI" >Liechtenstein
                <option value="LT" >Lithuania
                <option value="LU" >Luxembourg
                <option value="MO" >Macau
                <option value="MK" >Macedonia
                <option value="MG" >Madagascar
                <option value="MW" >Malawi
                <option value="MY" >Malaysia
                <option value="MV" >Maldives
                <option value="ML" >Mali
                <option value="MT" >Malta
                <option value="MH" >Marshall Islands
                <option value="MQ" >Martinique
                <option value="MR" >Mauritania
                <option value="MU" >Mauritius
                <option value="YT" >Mayotte
                <option value="MX" >Mexico
                <option value="FM" >Micronesia, Federated States of
                <option value="MD" >Moldova, Republic of
                <option value="MC" >Monaco
                <option value="MN" >Mongolia
                <option value="MS" >Montserrat
                <option value="MA" >Morocco
                <option value="MZ" >Mozambique
                <option value="MM" >Myanmar
                <option value="NA" >Namibia
                <option value="NR" >Nauru
                <option value="NP" >Nepal
                <option value="NL" >Netherlands
                <option value="AN" >Netherlands Antilles
                <option value="NC" >New Caledonia
                <option value="NZ" >New Zealand
                <option value="NI" >Nicaragua
                <option value="NE" >Niger
                <option value="NG" >Nigeria
                <option value="NU" >Niue
                <option value="NF" >Norfolk Island
                <option value="MP" >Northern Mariana Islands
                <option value="NO" >Norway
                <option value="OM" >Oman
                <option value="PK" >Pakistan
                <option value="PW" >Palau
                <option value="PA" >Panama
                <option value="PG" >Papua New Guinea
                <option value="PY" >Paraguay
                <option value="PE" >Peru
                <option value="PH" >Philippines
                <option value="PN" >Pitcairn
                <option value="PL" >Poland
                <option value="PT" >Portugal
                <option value="PR" >Puerto Rico
                <option value="QA" >Qatar
                <option value="RE" >Reunion
                <option value="RO" >Romania
                <option value="RU" >Russian Federation
                <option value="RW" >Rwanda
                <option value="KN" >Saint Kitts and Nevis
                <option value="LC" >Saint Lucia
                <option value="VC" >Saint Vincent and the Grenadines
                <option value="WS" >Samoa
                <option value="SM" >San Marino
                <option value="ST" >Sao Tome and Principe
                <option value="SA" >Saudi Arabia
                <option value="SN" >Senegal
                <option value="SC" >Seychelles
                <option value="SL" >Sierra Leone
                <option value="SG" >Singapore
                <option value="SK" >Slovakia (Slovak Republic)
                <option value="SI" >Slovenia
                <option value="SB" >Solomon Islands
                <option value="SO" >Somalia
                <option value="ZA" >South Africa
                <option value="ES" >Spain
                <option value="LK" >Sri Lanka
                <option value="SH" >St. Helena
                <option value="PM" >St. Pierre and Miquelon
                <option value="SD" >Sudan
                <option value="SR" >Suriname
                <option value="SJ" >Svalbard and Jan Mayen Islands
                <option value="SZ" >Swaziland
                <option value="SE" >Sweden
                <option value="CH" >Switzerland
                <option value="SY" >Syrian Arab Republic
                <option value="TW" >Taiwan
                <option value="TJ" >Tajikistan
                <option value="TZ" >Tanzania, United Republic of
                <option value="TH" >Thailand
                <option value="TG" >Togo
                <option value="TK" >Tokelau
                <option value="TO" >Tonga
                <option value="TT" >Trinidad and Tobago
                <option value="TN" >Tunisia
                <option value="TR" >Turkey
                <option value="TM" >Turkmenistan
                <option value="TC" >Turks and Caicos Islands
                <option value="TV" >Tuvalu
                <option value="UG" >Uganda
                <option value="UA" >Ukraine
                <option value="AE" >United Arab Emirates
                <option value="GB" >United Kingdom

                <option value="UY" >Uruguay

                <option value="UZ" >Uzbekistan
                <option value="VU" >Vanuatu
                <option value="VA" >Vatican City State (Holy See)
                <option value="VE" >Venezuela
                <option value="VN" >Vietnam
                <option value="VG" >Virgin Islands (British)
                <option value="VI" >Virgin Islands (U.S.)
                <option value="WF" >Wallis And Futuna Islands
                <option value="EH" >Western Sahara
                <option value="YE" >Yemen
                <option value="YU" >Yugoslavia
                <option value="ZR" >Zaire
                <option value="ZM" >Zambia
                <option value="ZW" >Zimbabwe
              </select>

  </td></tr>
   <tr><td>
	  <b><font SIZE="-1" FACE="verdana" color="25408d">Credit Card Type:</font></b>
  </td><td>
<select name="cctype">
<option value="American Express">American Express</option>
<option value="Mastercard">American Express</option>
<option value="Visa">Visa</option>
<option value="Discover">Discover</option>

  </td></tr>
	      <tr><td>
	  <b><font SIZE="-1" FACE="verdana" color="25408d">Credit Card Number:</font></b>
  </td><td>
	  <cfinput NAME="ccnum" SIZE="25" required="yes" message="You Must Enter Your Credit Card Number">  </td></tr>

      <tr><td>
	  <b><font SIZE="-1" FACE="verdana" color="25408d">Expiration Date (MMYY):</font></b>
  </td><td>
	  <cfinput NAME="ccexpire" SIZE="20" required="yes" message="You Must Enter Your Expiration Date" placeholder="MMYY">
  </td></tr>


 </table>
<center><input type="submit" Value="Purchase Now"></center>
</cfform>

</Cfif>


</Font>

</Td></Tr></table>

</Td>
<Td style="background-image:url('nyc_illustration2.png');vertical-align:bottom">
<Br><Br><br>
<img src="yellowburst.png" width="300">

</Td>

</TAble>

<table width="900" style="background-color:#d5e8ca">
<TR><TD align="center">

<Cfquery name="Getcolin" dataSource="cityguide">
select copy from columntable
where id = 87773
</cfquery>

<cfoutput query="getcolin">
#copy#</cfoutput>


</TD></TR>
</table>
<br>

<cfinclude template="footer.cfm">