<cfinclude template="header.cfm">


<div id="content">
  <div id="content-header">
  </div>
  <div class="container-fluid"><cfparam name="form.cg" default="">
<cfparam name="form.ml" default="">
<cfparam name="form.pk" default="">
<cfparam name="form.pkb" default="">
<cfparam name="form.pkq" default="">
<cfparam name="form.pkw" default="">
<cfparam name="form.pkr" default="">

<cfparam name="form.pkn" default="">
<cfparam name="form.pks" default="">

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

<cfparam name="form.catid" default="">
<cfparam name="form.catid2" default="">
<cfparam name="form.catid3" default="">
<cfparam name="form.catid4" default="">

<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.onlineonly" default="">
<cfparam name="form.registrationrequired" default="">
<cfparam name="form.daysofweek" default="">


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

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

a<Cfoutput>#form.onlineonly#</Cfoutput>a
<br>

<cfset datestart=#DateFormat(form.datestart,"yyyy-mm-dd")#>
<cfset dateend=#DateFormat(form.dateend,"yyyy-mm-dd")#>


<cfif parameterexists(form.itemid)>
	




<cfquery name=addphoto datasource="#ds#">
INSERT INTO ActivityPlanner(name,catid,datestart,dateend,address,city,state,description,zip,phone,website,address2,tablename,itemid,contactfirst,contactlast,contactitle,contactphone,contactemail,hours,dtentered,activityname,ages,price,catid2,cg,ml,pk,pkb,pkq,pkw,shortdescription,mainpage,nympregion,pkr,catid3,catid4,alist,age1,age2,age3,age4,age5,age6,price1,price2,price3,price4,price5,price6,addedby,pkf,addedon,pkn,pks,newsletterpickup,nympprintcat,phonex,isweekend,onlineonly,daysofweek,registrationrequired)

VALUES	('#form.name#',#form.catid#,'#datestart#','#dateend#','#form.address#','#form.city#','#form.state#','#form.descriptiona#','#form.zip#','#form.phone#','#form.website#','#form.address2#','#form.tablename#',#form.itemid#,'#form.contactfirst#','#form.contactlast#','#form.contacttitle#','#form.contactphone#','#form.contactemail#','#form.hours#',#currentdatetime#,'#form.activityname#','#form.ages#','#form.price#',#form.catid2#,'#form.cg#','#form.ml#','#form.pk#','#form.pkb#','#form.pkq#','#form.pkw#','#form.shortdescription#',#form.mainpage#,'#form.nympregion#','#form.pkr#',#form.catid3#,#form.catid4#,#form.alist#,'#form.age1#','#form.age2#','#form.age3#','#form.age4#','#form.age5#','#form.age6#','#form.price1#','#form.price2#','#form.price3#','#form.price4#','#form.price5#','#form.price6#','#getuser.member#','#form.pkf#',#currentdatetime#,'#form.pkn#','#form.pks#','#form.newsletterpickup#',#form.nympprintcat#,'#form.phonex#',#form.isweekend#,'#form.onlineonly#','#form.daysofweek#','#form.registrationrequired#')
</cfquery>

<cfelse>



<cfquery name=addphoto datasource="#ds#">
INSERT INTO ActivityPlanner(name,catid,datestart,dateend,address,city,state,description,zip,phone,website,address2,contactfirst,contactlast,contactitle,contactphone,contactemail,hours,dtentered,activityname,ages,price,catid2,cg,ml,pk,pkb,pkq,pkw,shortdescription,mainpage,nympregion,pkr,catid3,catid4,alist,age1,age2,age3,age4,age5,age6,price1,price2,price3,price4,price5,price6,addedby,pkf,addedon,pkn,pks,newsletterpickup,nympprintcat,phonex,isweekend,onlineonly,daysofweek,registrationrequired)

VALUES	('#form.name#',#form.catid#,'#datestart#','#dateend#','#form.address#','#form.city#','#form.state#','#form.descriptiona#','#form.zip#','#form.phone#','#form.website#','#form.address2#','#form.contactfirst#','#form.contactlast#','#form.contacttitle#','#form.contactphone#','#form.contactemail#','#form.hours#',#currentdatetime#,'#form.activityname#','#form.ages#','#form.price#',#form.catid2#,'#form.cg#','#form.ml#','#form.pk#','#form.pkb#','#form.pkq#','#form.pkw#','#form.shortdescription#',#form.mainpage#,'#form.nympregion#','#form.pkr#',#form.catid3#,#form.catid4#,#form.alist#,'#form.age1#','#form.age2#','#form.age3#','#form.age4#','#form.age5#','#form.age6#','#form.price1#','#form.price2#','#form.price3#','#form.price4#','#form.price5#','#form.price6#','#getuser.member#','#form.pkf#',#currentdatetime#,'#form.pkn#','#form.pks#','#form.newsletterpickup#',#form.nympprintcat#,'#form.phonex#',#form.isweekend#,'#form.onlineonly#','#form.daysofweek#','#form.registrationrequired#')
</cfquery>
</cfif>

Added!

<cfquery name="Getcat" datasource="#ds#">
select id
from ActivityPlanner
order by id desc
limit 0,1
</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#',
	usepicprint = #form.usepicprint#

	where id = #getcat.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.nymetroparents.com/columnpic">
	<cfset thumbdir="http://www.nymetroparents.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="777">
</cfcatch>
</cftry>


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


<CF_GraphicsMagick action="ResizeWidth" Infile="/home/home2/domains/parentsknow.com/public_html/newsite2018/2020/eventpic/#photo#" width="600" filter="Catrom" Outfile="/home/home2/domains/parentsknow.com/public_html/newsite2018/2020/eventpic/600#photo#"  quality="100">

<CF_GraphicsMagick action="ResizeWidth" Infile="/home/home2/domains/parentsknow.com/public_html/newsite2018/2020/eventpic/600#photo#" width="200" filter="Catrom" Outfile="/home/home2/domains/parentsknow.com/public_html/newsite2018/2020/eventpic/150#photo#"  quality="100">


<cfset thumbnail = '150#photo#'>

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

	thumbnail = '#thumbnail#'
	where id = #getcat.id#
</cfquery>

</cfif>




<br /><FORM action="dupecalendar.cfm" method="post">
<cfoutput><input type="hidden" name="id" value="#getcat.id#"></cfoutput>
<font face=verdana size=-1>Enter Number of Times to Duplicate Entry <input NAME="dupenum" SIZE="5">
<input type="submit" Value="Dupe">
</FORM>
<p>
<a href="/activityplanneredit.cfm?mag=5">Back to Calendar Admin</a>
<p>
<a href="/addcalendar.cfm">Add Another Event to the Calendar</a>
<p>
<a href="http://nymetroparents.com/2013neweventinfo.cfm?id=<Cfoutput>#Getcat.id#</cfoutput>">See This Event Listing in the Online Calendar</a>
<cfparam name="form.updateall" default="">

<cfoutput>
#form.updateall#
</cfoutput>
<cfif #form.updateall# contains 'on'>
ONON
<Cfquery name="updater" datasource="#ds#">
update ActivityPlanner
set
address = '#form.address#',
city = '#form.city#',
state = '#form.state#',
zip =  '#form.zip#',
phone = '#form.phone#',
website = '#form.website#',
address2 = '#form.address2#',
contactfirst = '#form.contactfirst#',
contactlast = '#form.contactlast#',
contactitle = '#form.contacttitle#',
contactphone = '#form.contactphone#',
contactemail = '#form.contactemail#'
where ActivityPlanner.name = '#form.name#'
</CFQUERY>
 </cfif>


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