<cfinclude template="header.cfm">


<div id="content">
  <div id="content-header">
  </div>
  <div class="container-fluid" style="margin-left:200px;">
<table width=100%><tr><td>

<div align="center"><font face=verdana size=+1><strong>Dupe Calendar Entry</strong></font>
<p>
<br>
<cfif parameterexists(url.dupe) and parameterexists(form.id) and 
isnumeric(form.id)>
<cfquery name="Getrecord" datasource="#ds#">
select *
from ActivityPlanner
where id = #form.id#
</cfquery>

<cfloop list="#form.datestart#" index="i" delimiters = ",">

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



<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,activityname,cg,ml,pk,pkb,pkq,pkw,pkr,nympregion,ages,price,starthours,startminutes,starttt,pkf,pkn,pks,price1,price2,price3,price4,price5,price6,age1,age2,age3,age4,age5,age6,cat3,cat4,catid3,catid4,alist,nympprintcat)

VALUES	('#Getrecord.name#',#Getrecord.catid#,'#datestart#','#dateend#','#Getrecord.address#','#Getrecord.city#','#Getrecord.state#','#Getrecord.description#','#Getrecord.zip#','#Getrecord.phone#','#Getrecord.website#','#Getrecord.address2#','#Getrecord.tablename#',#Getrecord.itemid#,'#Getrecord.contactfirst#','#Getrecord.contactlast#','#Getrecord.contactitle#','#Getrecord.contactphone#','#Getrecord.contactemail#','#Getrecord.hours#','#getrecord.activityname#','#getrecord.cg#','#getrecord.ml#','#getrecord.pk#','#getrecord.pkb#','#getrecord.pkq#','#getrecord.pkw#','#getrecord.pkr#','#getrecord.nympregion#','#getrecord.ages#','#getrecord.price#','#getrecord.starthours#','#getrecord.startminutes#','#getrecord.starttt#','#getrecord.pkf#','#getrecord.pkn#','#getrecord.pks#','#getrecord.price1#','#getrecord.price2#','#getrecord.price3#','#getrecord.price4#','#getrecord.price5#','#getrecord.price6#','#getrecord.age1#','#getrecord.age2#','#getrecord.age3#','#getrecord.age4#','#getrecord.age5#','#getrecord.age6#',#Getrecord.cat3#,#Getrecord.cat4#,#Getrecord.catid3#,#Getrecord.catid4#,#getrecord.alist#,#getrecord.nympprintcat#)
</cfquery>


<cfif not parameterexists(gettop.id)>
<Cfquery name="gettop" datasource="#ds#">
select id
from ActivityPlanner
order by id desc
limit 0,1
</Cfquery>
</cfif>
</cfloop>

<div align="center"><font face=verdana size=+1><strong>Done!</strong></font>
<cflocation url="editcalendar.cfm?id=#gettop.id#" addtoken="no">

<cfelse>
</div></center>
<FORM action="dupecalendar.cfm?dupe=on" method="post">
<cfif not parameterexists(form.id) or not isnumeric(form.id)>
<cfabort></cfif>
<cfoutput>
<input type="hidden" name="id" value="#form.id#">
<input type="hidden" name="dupenum" value="#form.dupenum#">

</cfoutput>

<cfloop from="1" to="#form.dupenum#" index="i">
 <b><font SIZE="-1" FACE="verdana" >Event Date (mm/dd/yyyy):</font></b> <input NAME="datestart" SIZE="15"><br />
  
   </cfloop>
	<p>
	<input type="submit" Value="Dupe Entry">
</FORM>


</cfif>



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

<cfinclude template="../footer.cfm">