<cfinclude template="header.cfm">


<div id="content">
  <div id="content-header">
  </div>
  <div class="container-fluid" style="margin-left:200px;">	<cfif parameterexists(Session.email) and (Session.email IS NOT -1) and (#getuser.accesslevel# eq 100)>


<CFSET CurrentDateTime = #CreateODBCDateTime(Now())#>


<cfif parameterexists(url.done)>

<cfquery name="addbook" datasource="#ds#">
update ListingsCoupons
set expire = '#form.expire#',
website = '#form.website#',
desc2019 = '#form.desc2019#',
itemname = '#form.itemname#',
trackingpixel = '#form.trackingpixel#',
storylink = '#form.storylink#',
description = '#form.description#',
longdescription = '#form.longdescription#'

where id = #form.fid#
</cfquery>


<cfif parameterexists(form.photo) and form.photo is not ''>
		<cfset imagepath="/home/home2/cgny/public_html/listingscoupons/">
  <cffile action="upload"
accept="image/jpeg,image/pjpeg"
	      nameconflict="makeunique"
			  filefield="photo"
			  destination="#imagepath#">

<cfif #left(photo,3)# is not 'bmp'>
	<cfset photo = "#File.ServerFile#">
  <cfset photo = replace(photo," ","_","ALL")>


 <cffile
   action = "rename"
   source = "#imagepath#/#File.ServerFile#"
   destination = "#imagepath#/#photo#"
   mode = "644">

</cfif>


<cfquery name="addbook" datasource="#ds#">
update ListingsCoupons
set photo = 'https://www.cityguideny.com/listingscoupons/#photo#'

where id = #form.fid#
</cfquery>


</cfif>


<cfif parameterexists(form.photo2019) and form.photo2019 is not ''>
		<cfset imagepath="/home/home2/cgny/public_html/listingscoupons/">
  <cffile action="upload"
accept="image/jpeg,image/pjpeg"
	      nameconflict="makeunique"
			  filefield="photo2019"
			  destination="#imagepath#">

<cfif #left(photo,3)# is not 'bmp'>
	<cfset photo2019 = "#File.ServerFile#">
  <cfset photo2019 = replace(photo2019," ","_","ALL")>


 <cffile
   action = "rename"
   source = "#imagepath#/#File.ServerFile#"
   destination = "#imagepath#/#photo2019#"
   mode = "644">

</cfif>


<cfquery name="addbook" datasource="#ds#">
update ListingsCoupons
set photo2019 = 'https://www.cityguideny.com/listingscoupons/#photo2019#'

where id = #form.fid#
</cfquery>


</cfif>


<table width=500 cellspacing=2 cellpadding=3>
<tr><td><div align="center">
	<strong><font face=verdana,arial size=+1>Coupon Updated</font></strong>
	<br>
<p>
</td></tr></table>


<cfelse>

<cfFORM action="editcoupon.cfm?done=doner" method=post  name="theform" enctype="multipart/form-data">

<cfquery name="getbookmarks" datasource="#ds#">
select *
from ListingsCoupons
where id = #url.id#
</cfquery>

<table width=500 cellspacing=5 cellpadding=5>
  <tr><Td colspan=2> <cfoutput>
  <input name="fid" type="hidden" value="#url.id#" />
   <strong><font face="verdana" size="+1">Edit Coupon</cfoutput></font></strong>
  <p><cfoutput>

<img src="#getbookmarks.photo#">
<p>
<font SIZE="-1" FACE="verdana"><b>Name:</b></font>
<input name="itemname" value="#getbookmarks.itemname#" size="50">

<p>


<font SIZE="-1" FACE="verdana"><b>Expiration Date:</b></font>
<input name="expire" value="#dateformat(getbookmarks.expire,'yyyy-mm-dd')#" size="50">
<p>
<font SIZE="-1" FACE="verdana"><b>Web Site:</b></font>
<input name="website" value="#getbookmarks.website#" size="50">

<p>
<font SIZE="-1" FACE="verdana"><b>Story Link:</b></font>
<input name="storylink" value="#getbookmarks.storylink#" size="50">


<p>
<font SIZE="-1" FACE="verdana"><b>Short Description:</b></font>
<textarea name="description" cols="50" rows="3">#getbookmarks.description#</textarea>

<p>
<font SIZE="-1" FACE="verdana"><b>Long Description:</b></font>
<textarea name="longdescription" cols="50" rows="10">#getbookmarks.longdescription#</textarea>
<p>
<font SIZE="-1" FACE="verdana"><b>Optional Tracking Pixel:</b></font>
<textarea name="trackingpixel" cols="50" rows="10">#getbookmarks.trackingpixel#</textarea>

<p>
<font SIZE="-1" FACE="verdana"><b>Photo:</b></font>
<br>
<input type=file name="photo">

<p>


  </td>	  </tr>
  
  
  <tr><td>
<p>
<font SIZE="-1" FACE="verdana"><b>Photo 2019 Version:</b></font>
<br>
<input type=file name="photo2019">

<p>

  <p>
<font SIZE="-1" FACE="verdana"><b>Description 2019:</b></font>
<textarea name="desc2019" cols="50" rows="3" maxlength="70">#getbookmarks.desc2019#</textarea>

  </td>	  </tr>
  
  
  



  <tr>
	  
	  
	  <td colspan=2>


<div align="center"><input type="submit" Value="Edit Coupon"></div>
	</td></tr>	</table>
	</cfoutput>
</cfform>



</cfif>


</cfif>