<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;">




<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.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.showhero" default="0">

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

<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>


<cfscript> 
charEncoding="iso-8859-1"
newtitter=CharsetDecode(#form.copyedit#, charEncoding); 
</cfscript> 


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

			<Cfif parameterexists(form.MainSwapbig)>
	MainSwapbig = '#form.MainSwapbig#',
</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.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 parameterexists(form.colid)>
	columnnum = '#form.colid#',
	</CFIF>
	
		<Cfif parameterexists(form.ColumnNum2)>
	ColumnNum2 = #form.ColumnNum2#,
	</CFIF>
		<Cfif parameterexists(form.ColumnNum3)>
	ColumnNum3 = #form.ColumnNum3#,
	</CFIF>
		<Cfif parameterexists(form.ColumnNum4)>
	ColumnNum4 = #form.ColumnNum4#,
	</CFIF>

	copy = '#(newtitter)#',
	region = '#form.region#',
	hottopic = #form.hottopic#,
	showhero = #form.showhero#,

	keywords = '#form.keywords#'
	WHERE ID = #form.id#
</CFQUERY>


<Cfquery name="cleartable" datasource="cityguide">
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="cityguide">
INSERT INTO regionstable (colid,regionsid)
VALUES	(#form.id#,#myArray[listCount]#)
		</cfquery>

        <cfquery name=addphoto datasource="cityguide">
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="cityguide">
INSERT INTO regionstable (colid,regionsid)
VALUES	(#form.id#,#myArray[listCount]#)
		</cfquery>

        <cfquery name=addphoto datasource="cityguide">
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#, '#newtitter#',#currentdatetime#);
</cfquery>

<cfobjectcache action="clear">


<cfif ParameterExists(form.buttarticle)>
<cflocation url="/editcol3335.cfm?id=#form.id#" addtoken="no">
<cfelseif parameterexists(form.buttarticlepreview)>


<cflocation url="https://www.nymetroparents.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>