<Cfinclude template="header.cfm">

  <div id="content-header" style="margin-left:225px;">
    <h2>&nbsp;Manage 301 Article Redirects</h2>
  </div>
  <div class="container-fluid" style="margin-left:200px;">

<cfif parameterexists(url.add)>

<cfquery name=addphoto datasource="#ds#">
INSERT INTO bdaycluboffers(clientname,dtentered,clientfineprint)
VALUES	('',#currentdatetime#,'')
</cfquery>
<cfquery name="Gettop" datasource="#ds#">
select id from bdaycluboffers
order by id DESC
limit 0,1
</cfquery>
<Cflocation url="managebday.cfm?edit=#gettop.id#" addToken="no">
</cfif>

<cfif parameterexists(url.editsave)>

<cfquery name="upds" dataSource="#ds#">
	update bdaycluboffers
	set clientname = '#form.clientname#',
	clientoffer = '#form.clientoffer#',
	clientexpire = '#dateformat(form.clientexpire,"yyyy-mm-dd")#',
	clientfineprint = '#form.clientfineprint#',
	clientemail = '#form.clientemail#'
where id = #url.editsave#
</cfquery>



</cfif>

<Cfif parameterexists(url.edit)>


	<Cfquery name="getone" dataSource="#ds#">
		select * from bdaycluboffers
		where id = #url.edit#
	</cfquery>

	<cfFORM action="managebday.cfm?editsave=#url.edit#" method="post" name="MyForm" enctype="multipart/form-data">



  <br>
   <table cellspacing=5 cellpadding=5 border=1>
<cfoutput query="getone">
 <tr><td style="padding:8px;">
	  <b><font SIZE="-1" FACE="verdana">Name:</font></b>
  </td><td style="padding:8px;">
	  <input NAME="clientname" SIZE="65" value="#clientname#">
  </td></tr>

<tr><td style="padding:8px;">
	  <b><font SIZE="-1" FACE="verdana">Offer:</font></b>
  </td><td style="padding:8px;">
	  <textarea name="clientoffer" style="width:400px;height:100px;">#clientoffer#</textarea>
  </td></tr>


  <tr><td style="padding:8px;">
	  <b><font SIZE="-1" FACE="verdana">Fine Print:</font></b>
  </td><td style="padding:8px;">
	  <textarea name="clientfineprint" style="width:400px;height:100px;">#clientfineprint#</textarea>
  </td></tr>

   <tr><td style="padding:8px;">
	  <b><font SIZE="-1" FACE="verdana">Client Email:</font></b>
  </td><td style="padding:8px;">
	  <input NAME="clientemail" SIZE="65" value="#clientemail#">
  </td></tr>

   <tr><td style="padding:8px;">
	  <b><font SIZE="-1" FACE="verdana">Expiration Date (m/d/yyyy):</font></b>
  </td><td style="padding:8px;">
	  <input NAME="clientexpire" SIZE="65" value="#dateformat(clientexpire,'m/d/yyyy')#">
  </td></tr>
     <tr><td style="padding:8px;">

	     	  <b><font SIZE="-1" FACE="verdana">Client Logo:</font></b>

	     	  <cfif #clientart# is not ''>
		     	  <img src="https://www.nymetroparents.com/birthdayoffers/#clientart#" style="float:right;">
	     	  </cfif>

  </td><td style="padding:8px;">
<input type=file name="crop">
  </td></tr>

     </table><br>
<input type="submit" Value="Update Entry">

</cfoutput>



	</cfFORM>




<cfelse>
	<TAble class="table color-table primary-table table-bordered table-striped table-hover">

<thead>
<Th>edit original</Th>
<th>redirect from</th>
<th>redirect to</th>
<!--<Th>edit to</Th>
<th>date updated</th>-->
</thead>

<cfquery name="gettodaya" dataSource="#ds#">
	select columntable.title, columntable.id, lastedit,seo_friendly,redir from columntable
	inner join columntableimages on columntable.id = columntableimages.colid
    where columntableimages.redir <> ''
    order by lastedit desc

</cfquery>
<Cfoutput query="Gettodaya">

<tr>
<td><a href="https://admin.nymetroparents.com/editcol3335.cfm?id=#id#&mag=5&topr=999999">edit</a></td>
<td><a href="https://www.nymetroparents.com/article/#seo_friendly#" target="_blank">#seo_friendly#</a></td>
<td><a href="#redir#" target="_new">
	<Cfset bard = #rereplace(redir,'https://www.nymetroparents.com/article/','')#>
	<Cfset bard = #rereplace(bard,'http://www.nymetroparents.com/article/','')#>
	<Cfset bard = #rereplace(bard,'https://www.nymetroparents.com/queens/article/','')#>
	<Cfset bard = #rereplace(bard,'https://www.nymetroparents.com/manhattan/article/','')#>
	<Cfset bard = #rereplace(bard,'https://www.nymetroparents.com/brooklyn/article/','')#>
	<Cfset bard = #rereplace(bard,'https://www.nymetroparents.com/rockland/article/','')#>
	<Cfset bard = #rereplace(bard,'https://www.nymetroparents.com/bergen/article/','')#>
	<Cfset bard = #rereplace(bard,'https://www.nymetroparents.com/westchester/article/','')#>
	<Cfset bard = #rereplace(bard,'https://www.nymetroparents.com/bronx/article/','')#>

	<Cfset bard = #rereplace(bard,'http://www.nymetroparents.com/queens/article/','')#>
	<Cfset bard = #rereplace(bard,'http://www.nymetroparents.com/manhattan/article/','')#>
	<Cfset bard = #rereplace(bard,'http://www.nymetroparents.com/brooklyn/article/','')#>
	<Cfset bard = #rereplace(bard,'http://www.nymetroparents.com/rockland/article/','')#>
	<Cfset bard = #rereplace(bard,'http://www.nymetroparents.com/bergen/article/','')#>
	<Cfset bard = #rereplace(bard,'http://www.nymetroparents.com/westchester/article/','')#>
	<Cfset bard = #rereplace(bard,'http://www.nymetroparents.com/bronx/article/','')#>



	#bard#
	</td>

<!---	<td>
					select id from columntable where seo_friendly = '#bard#'

		<cfquery name="Geter" dataSource="#ds#">
			select id from columntable where seo_friendly = '#bard#'
		</cfquery>
		<a href="https://admin.nymetroparents.com/editcol3335.cfm?id=#geter.id#&mag=5&topr=999999">edit</a></td>


<td>#dateformat(lastedit,'m/d/yyyy')#</td>
--->

</tr>
</Cfoutput>
</Table>
</Cfif>


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

  </body>
</html>