<CFSET CurrentDateTime = #CreateODBCDateTime(Now())#>
<cfcontent type="text/html;charset=utf-8">
<cfprocessingDirective pageencoding="utf-8">
<cfset setEncoding("Form", "utf-8")>
<cfinclude template="/header.cfm">

<textarea style="width: 300px;height:200px;">
<cfset form.copyedit = rereplacenocase(#form.copyedit#,'invalidtag','iframe','all')>
<cfoutput>#form.copyedit#</cfoutput></textarea>
<cfparam name="form.region" default=" ">
<cfparam name="form.podcast" default="">
<cfparam name="form.media" default="">

<cfparam name="form.newsletter" default="0">

<cfparam name="form.hottopic" default="0">
<cfparam name="form.seo_title" default="0">
<cfparam name="form.sharing_title" default="0">
<cfparam name="form.canlink" default="0">
<cfparam name="form.contestid" default="0">
<cfparam name="form.mainswapnymphero" default="0">
<cfparam name="form.mainswapnymp" default="0">
<cfparam name="form.shortblurb" default="">

<cfparam name="form.imageurlbig" default="">
<cfparam name="form.imageurl" default="">
<cfparam name="form.imageheadline" default="">
<cfparam name="form.imagecaption" default="">

	<Cfquery name="upds" dataSource="#ds#">
		update columntableimages
		set imageurlbig = '#form.imageurlbig#',
		imageurl = '#form.imageurl#',
		imageheadline = '#form.imageheadline#',
		imagecaption = '#form.imagecaption#'
		
		where colid = #form.id#
	</cfquery>



<Cfif parameterexists(form.startdate) and #form.startdate# is not ''>
	<Cfquery name="upds" dataSource="#ds#">
		update columntableimages
		set startdate = '2017-#dateformat(form.startdate,"mm-dd")#'
		where colid = #form.id#
	</cfquery>
</Cfif>
<Cfif parameterexists(form.enddate) and #form.enddate# is not ''>
	<Cfquery name="upds" dataSource="#ds#">
		update columntableimages
		set enddate = '2018-#dateformat(form.enddate,"mm-dd")#'
		where colid = #form.id#
	</cfquery>
</Cfif>

<Cfif parameterexists(form.redir)>
	<Cfquery name="upds" dataSource="#ds#">
		update columntableimages
		set redir = '#form.redir#'
		where colid = #form.id#
	</cfquery>
</Cfif>


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

<cfparam name="form.pagetitle" default="">
<cfparam name="form.keywords" default="">

<CFQUERY datasource="cg22">
	UPDATE columntable
	SET
	title = '#trim(form.title)#',
shorttitle = '#form.shorttitle#',
media = '#form.media#',
seo_title = '#trim(form.seo_title)#',
sharing_title = '#form.sharing_title#',
canlink = '#form.canlink#',
pagetitle = '#form.pagetitle#',
subtitle = '#form.subtitle#',
podcast = '#form.podcast#',
shortblurb = '#htmlEditFormat(form.shortblurb)#',
<Cfif not parameterexists(form.skipupdate)>
lastedit = #CreateODBCDateTime(Now())#,
</Cfif>
editedby = '#session.email#',

		<Cfif parameterexists(url.mainswap)>,
	MainSwap = '#url.MainSwap#',
	<cfelse>
	MainSwap = '#form.MainSwap#',
	</cfif>

			<Cfif parameterexists(url.mainswapnymp)>,
	mainswapnymp = '#url.mainswapnymp#',
	<cfelse>
	mainswapnymp = '#form.mainswapnymp#',
	</cfif>

			<Cfif parameterexists(url.mainswapnymphero)>,
	mainswapnymphero = '#url.mainswapnymphero#',
	<cfelse>
	mainswapnymphero = '#form.mainswapnymphero#',
	</cfif>
		<Cfif parameterexists(form.showwidget)>
		showwidget = #form.showwidget#,
		</cfif>

		<Cfif parameterexists(form.ShowAd)>
		ShowAd = #form.showad#,
		</cfif>
	<Cfif parameterexists(form.showinfolink)>
	ShowInfoLink = #form.showinfolink#,</cfif>
	Keywords = '#form.Keywords#',
newsletter = '#form.newsletter#',
<Cfif #url.general# eq 'off'>
	blurb = '#form.blurb#',
	</Cfif>
	<Cfif isdate(form.repostdate)>
	repostdate = '#dateformat(form.repostdate,'yyyy-mm-dd')#',
	<cfelse>
	repostdate = '2199-01-01',
	</CFIF>
		<Cfif isdate(form.stopdate)>
	stopdate = '#dateformat(form.stopdate,'yyyy-mm-dd')#',
	<cfelse>
	stopdate = '2199-01-01',
	</CFIF>
	<Cfif parameterexists(form.colid)>
	columnnum = '#form.colid#',
	</CFIF>
	copy = '#(form.copyedit)#'<Cfif parameterexists(form.displayfeedback)>,
	displayfeedback = 'Yes',
	region = '#form.region#',
	keywords = '#form.keywords#'</cfif>
	WHERE ID = #form.id#
</CFQUERY>


<Cfquery name="cleartable" datasource="cg22">
delete from
regionstable
where colid = #form.id#
</CFQUERY>

<cfif parameterexists(form.regions)>
<cfset myArray = ArrayNew(1)>
<cfloop from="1" to="#ListLen(form.regions)#"index="listCount">
    <cfset myArray[listCount] =ListGetAt(form.regions,listCount,",")>

<cfquery name=addphoto datasource="cg22">
INSERT INTO regionstable (colid,regionsid)
VALUES	(#form.id#,#myArray[listCount]#)
		</cfquery>

        <cfquery name=addphoto datasource="cg22">
INSERT INTO regionstable2 (colid,regionsid)
VALUES	(#form.id#,#myArray[listCount]#)
		</cfquery>

</cfloop>
</cfif>

<cfif parameterexists(form.regions2)>
<cfset myArray = ArrayNew(1)>
<cfloop from="1" to="#ListLen(form.regions2)#"index="listCount">
    <cfset myArray[listCount] =ListGetAt(form.regions2,listCount,",")>

<cfquery name=addphoto datasource="cg22">
INSERT INTO regionstable (colid,regionsid)
VALUES	(#form.id#,#myArray[listCount]#)
		</cfquery>

        <cfquery name=addphoto datasource="cg22">
INSERT INTO regionstable2 (colid,regionsid)
VALUES	(#form.id#,#myArray[listCount]#)
		</cfquery>

</cfloop>
</cfif>



<cfquery name="addtw" dataSource="#ds#">
insert delayed INTO columntablehistory (colid, copy,datetime) VALUES(#form.id#, '#form.copyedit#',#currentdatetime#);
</cfquery>

<cfobjectcache action="clear">

<cftry>
<CFQUERY datasource="cg22" name="getseo">
	select seo_friendly from columntable
	where id = #form.id#
</cfquery>	

<cfset urlme = 'https://www.cityguideny.com/article/#getseo.seo_friendly#'>
<cfset argue = ' -k -X POST "https://api-gateway.ezoic.com/gateway/cdnservices/clearcache/?developerKey=75eca6ba2e4bb8e212c1a99ebffa3cfa" -H "Content-Type: application/json" --data ''{
	"url":"#urlme#"}'''>
<cfexecute name = "curl" 
arguments = "#argue#" 
outputfile="output.txt" 
timeout = "2"> 
</cfexecute> 
<cfcatch></cfcatch>
</cftry>
<cfif ParameterExists(form.buttarticle)>
<cflocation url="editcol3335.cfm?id=#form.id#" addtoken="no">
<cfelseif parameterexists(form.buttarticlepreview)>


<cflocation url="https://www.cityguideny.com/2011va.cfm?colid=#form.id#" addtoken="no">


<cfelse>
<cfif parameterexists(form.general)>
<cflocation url="generaladmin.cfm?mag=#url.mag#" addtoken="no">
<cfelse>
<cflocation url="columnadmin.cfm?mag=#url.mag#&topr=#url.topr#" addtoken="no">
</cfif>

</cfif>