<cfcontent type="text/html;charset=iso-8859-1">
<cfprocessingDirective pageencoding="iso-8859-1">
<cfset setEncoding("Form", "ISO-8859-15")>
<cfinclude template="header.cfm">


<div id="content">
  <div id="content-header">
  </div>
  <div class="container-fluid" style="margin-left:200px;">
<cfparam name="url.mag" default="">
<cfparam name="url.issue" default="">
<cfparam name="form.writeupshort" default="">
<cfparam name="form.digitalonly" default="">



<cfparam name="form.urllink" default="">
<cfparam name="form.Facebook" default="">
<cfparam name="form.Instagram" default="">
<cfparam name="form.Youtube" default="">
<cfparam name="form.Premium" default="0">
<cfparam name="form.Words90" default="">

<cfparam name="form.eventtyper" default="">

	<cfset writeup2=reReplace(form.writeup, "[^\x20-\x7E]", "", "ALL")>
	<cfset writeup2short=reReplace(form.writeupshort, "[^\x20-\x7E]", "", "ALL")>

<Cfquery name="deleter" datasource="#ds#">
update
issueguide
set catid = #form.catid#,
header = '#form.header#',
digitalonly = '#form.digitalonly#',
eventtyper = '#form.eventtyper#',
urllink = '#form.urllink#',
facebook = '#form.facebook#',
instagram = '#form.instagram#',
youtube = '#form.youtube#',
words90 = '#form.words90#',
premium = #form.premium#,


<cfif form.premium eq 1 and form.premiumdate eq '2001-01-01'>
	premiumdate = #currentdatetime#,
<cfelse>
premiumdate = '#form.premiumdate#',
</cfif>

writeup = '#form.writeup#',
writeupshort = '#form.writeupshort#',
writeupstatus = 'Edited',
hide = #form.hide#,
editedby = '#getuser.member#',
offer = '#form.offer#',
expirationdate = '#form.expirationdate#'
where id = #form.id#
</Cfquery>

<Cfif parameterexists(form.photo) and (form.photo is not '')>
<cfset imagepath="/home/home2/domains/parentsknow.com/public_html/newsite2018/2020/premium">
<cffile action="upload" 
	        nameconflict="makeunique"
			filefield="photo"
			destination="#imagepath#" mode="777"> 
	
	<cfset head = "#File.ServerFile#">
<cfquery name="upds" datasource="#ds#">
    update
issueguide set logo = '#head#'
where id = #form.id#
</cfquery>

</CFIF>



<cflocation url="addguide.cfm?id=#url.tid#&mag=#url.mag#&issue=#urlencodedformat(url.issue)#&catid=#form.catid#" addtoken="no">