<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;">
					<table border="0" cellpadding="8" cellspacing="0" width="100%">
					<tr>
					<td valign="top">



<Cfparam name="form.contactname" default="">
<Cfparam name="form.advertiser" default="0">
<Cfparam name="form.region" default="">
<Cfparam name="form.fax" default="">
<Cfparam name="form.description" default="">
<Cfparam name="form.fulldescription" default="">
<Cfparam name="form.contactitle" default="">
<Cfparam name="form.contactemail" default="">
<Cfparam name="form.contactphone" default="">
<Cfparam name="form.hide" default="0">
<cfparam name="form.AdRankML" default="0">

	<cfset writeup2=reReplace(form.description, "[^\x20-\x7E]", "", "ALL")>
	<cfset writeup3=reReplace(form.fulldescription, "[^\x20-\x7E]", "", "ALL")>


<CFQUERY name="addl" datasource="#ds#">
INSERT INTO ParentsListings(name,address,city,state,zip,contactname,phone,advertiser,fax,email,website,lastupdated,description,fulldescription,catname,contactfirst,contactlist,contacttitle,contactemail,contactphone,dateadded,region,hide,AdRankML,sortby)

values ('#form.name#','#form.Address#','#form.city#','#form.state#','#form.zip#','#form.contactname#','#form.phone#',#form.Advertiser#,'#form.fax#','#form.email#','#form.website#',#currentdatetime#,'#writeup2#','#writeup3#','#form.catname#','#form.contactfirst#','#form.contactlast#','#form.contactitle#','#form.contactemail#','#form.contactphone#',#currentdatetime#,'#form.region#',#form.hide#,#form.AdRankML#,'#form.name#')

</CFQUERY>

<Cfquery name="getnewid" datasource="#ds#">
select id
from ParentsListings
order by id desc
limit 0,1
</Cfquery>

<Cfquery name="getcatname" datasource="#ds#">
select id
from ParentsListingsCatMain
where catname = '#form.catname#'
limit 0,1
</Cfquery>
<cfif #getcatname.recordcount# gt 0>
<cfquery name=addphoto datasource="cityguide">
INSERT INTO ParentsListingsCat (pkid,catid)
VALUES	(#getnewid.id#,#getcatname.id#)
		</cfquery>
</cfif>

<Cfif parameterexists(form.catname2)>
<Cfquery name="getcatname" datasource="#ds#">
select id
from ParentsListingsCatMain
where catname = '#form.catname2#'
limit 0,1
</Cfquery>

<cfquery name=addphoto datasource="cityguide">
INSERT INTO ParentsListingsCat (pkid,catid)
VALUES	(#getnewid.id#,#getcatname.id#)
		</cfquery>

</Cfif>


<cfquery name="getstuff" datasource="#ds#">
select name, id
from ParentsListings
order by id desc
limit 0,1
</cfquery>


<cfoutput query="getstuff">
<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>


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

<Cfif #checkmove.recordcount# gt 0>
<cfset moveurl = '#moveurl#-#id#'>
</cfif>
#id# - #moveurl#<br>

<cfquery name="updater" datasource="#ds#">
update ParentsListings
set seo_friendly = '#moveurl#'
where id = #id#
</cfquery>
</cfoutput>


<span class="header">Done!</span></strong><br>
<cfoutput><table width=100% cellspacing=0 cellpadding=0 bgcolor=#color#><tr><td></td></tr></table></cfoutput>

<p>
<font face=verdana size=+1>Listing Added</font>
<p>
<cfif parameterexists(url.hide)>

<CFMAIL
TO="[email protected],[email protected]"
SUBJECT="New NYMP Listing Submitted - #form.name#"
        FROM="NYMP <[email protected]>"
SERVER="us-smtp-outbound-1.mimecast.com"
type="html">
<p>
A new listing has been submitted, <a href="https://admin.nymetroparents.com/listingseditpk.cfm?id=#getstuff.id#&table=ParentsListings&cat=Advocacy & Social Services&catid=88">click here</a> to edit and UNHIDE if you'd like to approve it.
<p>

</cfmail>

<cfelse>
<A href="https://admin.nymetroparents.com/listallpk.cfm">Go to Listings Edit Page</A>
</cfif>

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


<cfinclude template="/footer.cfm">