<cfinclude template="header.cfm">


<div id="content">
  <div id="content-header">
  </div>
  <div class="container-fluid">
<cfquery name="updater" datasource="cityguide">
update ActivityPlanner
set cg = '',
ml = '',
pk = '',
pkb = '',
pkq = '',
pkr = '',
pkf = '',
pkn = '',
pks = '',

pkw = ''
where id = #form.id#

</cfquery>
<Cfparam name="form.newsletterpickup" default="No">
<Cfparam name="form.skipdate1" default="1900-01-01">
<Cfparam name="form.skipdate2" default="1900-01-01">
<Cfparam name="form.skipdate3" default="1900-01-01">
<Cfparam name="form.skipdate4" default="1900-01-01">
<Cfparam name="form.skipdate5" default="1900-01-01">
<Cfparam name="form.skipdate6" default="1900-01-01">
<Cfparam name="form.nympregion" default="">
<Cfparam name="form.ages" default="">

<Cfparam name="form.skipdate7" default="1900-01-01">
<Cfparam name="form.skipdate8" default="1900-01-01">
<Cfparam name="form.skipdate9" default="1900-01-01">
<Cfparam name="form.skipdate10" default="1900-01-01">
<Cfparam name="form.nympprintcat" default="0">
<Cfparam name="form.cgpriority" default="1">

<Cfparam name="form.age1" default="">
<Cfparam name="form.age2" default="">
<Cfparam name="form.age3" default="">
<Cfparam name="form.age4" default="">
<Cfparam name="form.age5" default="">
<Cfparam name="form.age6" default="">
<Cfparam name="form.price1" default="">
<Cfparam name="form.price2" default="">
<Cfparam name="form.price3" default="">
<Cfparam name="form.price4" default="">
<Cfparam name="form.price5" default="">
<Cfparam name="form.price6" default="">
<Cfparam name="form.sponsoredbonusregion" default="">


<cfif #form.skipdate1# eq ''><Cfset #form.skipdate1# = '1900-01-01'></cfif>
<cfif #form.skipdate2# eq ''><Cfset #form.skipdate2# = '1900-01-01'></cfif>
<cfif #form.skipdate3# eq ''><Cfset #form.skipdate3# = '1900-01-01'></cfif>
<cfif #form.skipdate4# eq ''><Cfset #form.skipdate4# = '1900-01-01'></cfif>
<cfif #form.skipdate5# eq ''><Cfset #form.skipdate5# = '1900-01-01'></cfif>
<cfif #form.skipdate6# eq ''><Cfset #form.skipdate6# = '1900-01-01'></cfif>
<cfif #form.skipdate7# eq ''><Cfset #form.skipdate7# = '1900-01-01'></cfif>
<cfif #form.skipdate8# eq ''><Cfset #form.skipdate8# = '1900-01-01'></cfif>
<cfif #form.skipdate9# eq ''><Cfset #form.skipdate9# = '1900-01-01'></cfif>
<cfif #form.skipdate10# eq ''><Cfset #form.skipdate10# = '1900-01-01'></cfif>

<table width=100%><tr><td>

<div align="center"><font face=verdana size=+1><strong>Calendar Event Updates</strong></font>

<br>

<cfset datestart=#DateFormat(form.datestart,"yyyy-mm-dd")#>
<cfset dateend=#DateFormat(form.dateend,"yyyy-mm-dd")#>
<cfset id = #form.id#>
<cfparam name="form.catid2" default="0">
<cfparam name="form.catid3" default="0">
<cfparam name="form.catid4" default="0">
<cfparam name="form.catid" default="0">
<cfparam name="catid" default="0">

<cfparam name="catid2" default="0">
<cfparam name="catid3" default="0">
<cfparam name="catid4" default="0">

<cfparam name="form.pk" default="">
<cfparam name="form.pkq" default="">
<cfparam name="form.pkw" default="">
<cfparam name="form.pkr" default="">
<cfparam name="form.pkb" default="">
<cfparam name="form.pkf" default="">
<cfparam name="form.pkn" default="">
<cfparam name="form.pks" default="">
<cfparam name="form.text" default="">
<cfparam name="form.specialdate" default="">
<cfparam name="form.starthours" default="">
<cfparam name="form.startminutes" default="">
<cfparam name="form.starttt" default="">
<cfparam name="form.hotticketregion" default="">
<cfparam name="form.editorlove" default="">

<cfparam name="form.id" default="#form.id#">

<cfparam name="form.updatedby" default="#getuser.member#">

<cfparam name="form.updatedon" default="#currentdatetime#">
<cfparam name="form.onlineonly" default="">
<cfparam name="form.registrationrequired" default="">
<cfparam name="form.daysofweek" default="">
<cfparam name="form.customtitle" default="">
<cfparam name="form.custommeta" default="">

	
	<Cfquery name="upgsd" dataSource="#ds#">
		update ActivityPlanner
		set 
		DATEEND = '#dateend#', 
		zip = '#form.zip#',
		pkb = '#form.pkb#',
		custommeta = '#form.custommeta#',
		customtitle = '#form.customtitle#',
PK = '#form.pk#',
PKQ = '#form.pkq#',
PKW = '#form.pkw#',
PKR = '#form.pkr#',
SKIPDATE1 = '#form.skipdate1#',
NAME = '#form.name#',
onlineonly = '#form.onlineonly#',
registrationrequired = '#form.registrationrequired#',
daysofweek = '#form.daysofweek#',


SKIPDATE5 = '#form.skipdate5#',
MAINPAGE = #form.mainpage#,
DATESTART = '#datestart#',
WEBSITE = '#form.website#',
ADDRESS = '#form.address#',
sponsoredbonusregion = '#form.sponsoredbonusregion#',

AGES  = '#form.ages#',
CONTACTPHONE = '#form.contactphone#',
SKIPDATE8 = '#form.skipdate8#',
SKIPDATE7 = '#form.skipdate7#',
CONTACTLAST = '#form.contactlast#',
PHONE = '#form.phone#',
SKIPDATE3 = '#form.skipdate3#',
ENHANCEDDESCRIPTION = '#form.enhanceddescription#',
PRICE = '#form.price#',
SKIPDATE4 = '#form.skipdate4#',
HOURS = '#form.hours#',
ACTIVITYNAME = '#form.activityname#',
SKIPDATE9 = '#form.skipdate9#',
SKIPDATE2 = '#form.skipdate2#',
CONTACTEMAIL = '#form.contactemail#',
CITY = '#form.city#',
STATE = '#form.state#',
ADDRESS2 = '#form.address2#',
CONTACTITLE = '#form.contactitle#',
SHORTDESCRIPTION = '#form.SHORTDESCRIPTION#',
SKIPDATE6 = '#form.SKIPDATE6#',
TEXT = '#form.TEXT#',
SKIPDATE10 = '#form.SKIPDATE10#',
CONTACTFIRST = '#form.CONTACTFIRST#',
nympregion = '#form.nympregion#',
CATID3 = #form.CATID3#,
CATID4 = #form.CATID4#,
age1 = '#form.age1#',
age2 = '#form.age2#',
age3 = '#form.age3#',
age4 = '#form.age4#',
age5 = '#form.age5#',
price1 = '#form.price1#',
price2 = '#form.price2#',
price3 = '#form.price3#',
price4 = '#form.price4#',
isweekend = #form.isweekend#,
price5 = '#form.price5#',
price6 = '#form.price6#',
updatedby = '#form.updatedby#',
updatedon = #form.updatedon#,
specialdate = '#form.specialdate#',
starthours = '#form.starthours#',
startminutes = '#form.startminutes#',
starttt = '#form.starttt#',
age6 = '#form.age6#',
PKF = '#form.PKF#',
PKN = '#form.PKN#',
PKS = '#form.PKS#',
newsletterpickup = '#form.newsletterpickup#',
nympprintcat = #form.nympprintcat#,
usepicprint = #form.usepicprint#,
editorlove = '#form.editorlove#',
hotticketregion = '#form.hotticketregion#',
phonex = '#form.phonex#'
		
		where id = #form.id#
	
	</cfquery>	
	
	




<cfif parameterexists(form.usepic) and #form.usepic# is not '' and isnumeric(form.usepic)>

<cfquery name="getrelated" dataSource="#ds#">
	select thumbnail,photo,id from ActivityPlanner
where id = #form.usepic#

</cfquery>

<Cfquery name="upds" dataSource="#ds#">
	update ActivityPlanner
	set photo = '#getrelated.photo#',

	thumbnail = '#getrelated.thumbnail#'	where id = #form.id#
</cfquery>


</cfif>




<cfif parameterexists(form.crop) and #form.crop# is not ''>
<cfset robpic = #createUUID()#>

<cfset ds='cityguide'>
	<cfset imagepath="/home/home2/domains/parentsknow.com/public_html/newsite2018/2020/eventpic">
	<cfset thumbpath="/home/home2/domains/parentsknow.com/public_html/newsite2018/2020/eventpic">
	<cfset imagedir="http://www.cityguideny.com/columnpic">
	<cfset thumbdir="http://www.cityguideny.com/columnpic">


	<cftry>
<cfimage source="#form.crop#" action="write" destination="/home/home2/domains/parentsknow.com/public_html/newsite2018/2020/eventpic/#robpic#.jpg" isBase64="yes" overwrite="true">
<cfset #file.serverfile# = '#robpic#.jpg'>

<cfcatch>
<cffile action="upload"
	        nameconflict="makeunique"
filefield="crop"
accept="image/jpeg,image/pjpeg,image/png"
 destination="/home/home2/domains/parentsknow.com/public_html/newsite2018/2020/eventpic/#robpic#.jpg"
 mode="644">
</cfcatch>
</cftry>

<!---
<cffile action="upload"
	        nameconflict="makeunique"
filefield="photo"
accept="image/jpeg,image/pjpeg,image/png"
 destination="#imagepath#/#robpic#.jpg"
 mode="644">
--->
<cfset #file.serverfile# = '#robpic#.jpg'>
	<cfset photo = "#File.ServerFile#">


<cftry>
<!--- Try to get image info --->
<cfimage action="info" source="/home/home2/domains/parentsknow.com/public_html/newsite2018/2020/eventpic/#photo#" structname="cmyk" />
<cfcatch type="any">

<cffile action="copy"
source="#imagepath#/#robpic#.jpg"
 destination="#imagepath#/original#robpic#.jpg"
 mode="777">

<!--- If it fails convert to RGB and Strip Information with ImageMagick --->
<cfexecute name="/home/home2/domains/parentsknow.com/public_html/newsite2018/2020/eventpic/img_to_rgb.sh"
arguments="/home/home2/domains/parentsknow.com/public_html/newsite2018/2020/eventpic/#photo# /home/home2/domains/parentsknow.com/public_html/newsite2018/2020/eventpic/#photo#"
timeout="30" variable="msg" />
</cfcatch>
</cftry>

<!--- Image can now be read
<cfimage action="info" source="/home/home2/domains/parentsknow.com/public_html/eventpic/#photo#" structname="cmyk" />--->

<cftry>
<Cfimage action="resize" width="600"  height=""    source="/home/home2/domains/parentsknow.com/public_html/newsite2018/2020/eventpic/#photo#"
		 destination="/home/home2/domains/parentsknow.com/public_html/newsite2018/2020/eventpic/600#photo#"  overwrite="true">

<Cfimage action="resize" width="200" height="200"
    source="/home/home2/domains/parentsknow.com/public_html/newsite2018/2020/eventpic/#photo#"
		 destination="/home/home2/domains/parentsknow.com/public_html/newsite2018/2020/eventpic/150#photo#"  overwrite="true">

<cfcatch></cfcatch>

</cftry>
<cfset thumbnail = '150#photo#'>

<Cfquery name="upds" dataSource="#ds#">
	update ActivityPlanner
	set photo = '#photo#',

	thumbnail = '#thumbnail#',

	usepicprint = 2

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

</cfif>
updated!


<cfquery name="getseo" datasource="#ds#">
select id, name,datestart,dateend
from ActivityPlanner
where (seo_friendly is null or seo_friendly = '' )
and name <> ''
and id <> 9939 and id <> 171250 and id <> 174319 and id <> 116527 and name <> ''
and datestart !='0000-00-00'
and dateend !='0000-00-00'

</cfquery>

<cfoutput query="getseo">
	<Cftry>
<cfset seodate = '#dateformat(datestart,"yyyy-mm-dd")#-#dateformat(datestart,"yyyy-mm-dd")#'>
<cfset moveurl = reReplace(name, "([^[:alnum:]|[:blank:]]) ", "", "all")>
<cfset moveurl = #reReplaceNoCase(moveurl, "[^a-z0-9]", "-", "all")#>
<Cfset moveurl = rereplace(moveurl," ","-","ALL")>
<cfset moveurl = rereplace(moveurl,"'","-","ALL")>
<cfset xxx = len(moveurl)>
<cfset xxx2 = xxx -1>
<Cfif #left(moveurl,1)# eq '-'>
<cfset moveurl = '#right(moveurl,xxx2)#'>
</cfif>
<cfset xxx = len(moveurl)>
<cfset xxx2 = xxx -1>
<Cfif #left(moveurl,1)#	eq '-'>
<cfset moveurl = '#right(moveurl,xxx2)#'>
</cfif>

<cfset moveurl = '#moveurl#-#seodate#'>

<Cfquery name="checkmove" datasource="#ds#">
select id from ActivityPlanner where seo_friendly = '#moveurl#'
</cfquery>

<Cfif #checkmove.recordcount# gt 0>
<cfset moveurl = '#moveurl#-#dateformat(currentdatetime,'mmdd')#'>
</cfif>

<Cfquery name="upds" datasource="#ds#">
update ActivityPlanner
set seo_friendly = '#moveurl#'
where id = #id#
</cfquery>
<cfcatch></cfcatch>
</Cftry>
</cfoutput>

<Cfif parameterexists(form.evergreen) and isnumeric(form.evergreen)>
	
	<cfquery name="doesexist" datasource="cityguide">
	delete from ActivityPlanner2 where id = #form.id#
	</cfquery>
	

<CFQUERY NAME="Insert" datasource="#ds#">
  INSERT INTO ActivityPlanner2 (evergreen,id)
  VALUES (#form.evergreen#,#form.id#)
</CFQUERY>	
	
	<cfif #form.evergreen# eq 1>
		
		<cfset namer = '#form.name# #form.activityname#'>
		
		<cfset moveurl = reReplace(namer, "([^[:alnum:]|[:blank:]]) ", "", "all")>
<cfset moveurl = #reReplaceNoCase(moveurl, "[^a-z0-9]", "-", "all")#>
<Cfset moveurl = rereplace(moveurl," ","-","ALL")>
<cfset moveurl = rereplace(moveurl,"'","-","ALL")>
<cfset xxx = len(moveurl)>
<cfset xxx2 = xxx -1>
<Cfif #left(moveurl,1)# eq '-'>
<cfset moveurl = '#right(moveurl,xxx2)#'>
</cfif>
<cfset xxx = len(moveurl)>
<cfset xxx2 = xxx -1>
<Cfif #left(moveurl,1)#	eq '-'>
<cfset moveurl = '#right(moveurl,xxx2)#'>
</cfif>

<cfquery name="checkredirect" dataSource="#ds#">
	select * from ActivityPlannerRedirect where 
	link = '#moveurl#'
</cfquery>

<Cfif #checkredirect.recordcount# eq 0>
	
	
<CFQUERY NAME="Insert" datasource="#ds#">
  INSERT INTO ActivityPlannerRedirect (link,linkto)
  VALUES ('#form.oldlink#','#moveurl#')
</CFQUERY>	
	
	
</Cfif>



<Cfquery name="checkmove" datasource="#ds#">
select id from ActivityPlanner where seo_friendly = '#moveurl#'
and id <> #form.id# 
</cfquery>

<Cfif #checkmove.recordcount# gt 0>
<cfset moveurl = '#moveurl#-#dateformat(currentdatetime,'mmdd')#'>
</cfif>

<Cfquery name="upds" datasource="#ds#">
update ActivityPlanner
set seo_friendly = '#moveurl#'
where id = #id#
</cfquery>
		
		
	</cfif>
	
	
</Cfif>

<cfobjectcache action="clear">

<CFIF
	ParameterExists(Form.entry)>
<cflocation url="editcalendar.cfm?id=#form.id#" addtoken="no">
<cfelseif parameterexists(form.buttlisting)>

<cflocation url="https://www.nymetroparents.com/2015neweventinfo.cfm?id=#form.id#" addtoken="no">


<cfelse>

<cflocation url="/activityplanneredit.cfm?mag=5" addtoken="no">
</CFIF>


</td></tr></table>

   </div>
<!--Footer-part-->
<br><br><br><br>

<cfinclude template="footer.cfm">