<cfinclude template="/header.cfm">


<div id="content">
  <div id="content-header">
   <h2>&nbsp;Edit Article URL</h2>
  </div>
  <div class="container-fluid" style="margin-left:220px;">

<cfif parameterexists(Session.email) and (Session.email IS NOT -1) and (#getuser.accesslevel# eq 100)>

<Cfif parameterexists(url.updater)>
    
    <Cfquery name="checkconflict" dataSource="#ds#">
        select id from columntable 
        where seo_friendly = '#form.seo_friendly#' and mag = 5
    </Cfquery>
    
    <Cfif #checkconflict.recordcount# gt 0>
        	Error, this URL already exists.
	<a href="javascript:history.back()" id="dark">Back...</a>

        
    <cfinclude template="footer.cfm">
        <cfabort>
    </Cfif>
    
    <cfset newseo  = rereplace(form.seo_friendly,' ','-','all')>
<cfquery name="updater" datasource="#ds#">
update columntable
set seo_friendly = '#newseo#'
where id = #url.id#
</cfquery>

<cfquery name="ins" dataSource="#ds#">
	
insert into columntableredirect(fromseo,toseo)
values ('#form.fromseo#','#newseo#')

</cfquery>	

<strong>DONE!</strong>
<p>

<Cfoutput><font size="+1">
<a href="/editcol3335.cfm?id=#url.id#">Back to Article Edit</a>
</font></Cfoutput>
<p>


</Cfif>

<cfquery name="getcolumn" datasource="#ds#">
select id, seo_friendly
from columntable
where id = #url.id#
</cfquery>
<table width=100%><tr><td>
<cfoutput query="Getcolumn" maxrows = 1>

<FORM action="editurl.cfm?updater=on&id=#url.id#" method=post  >
  <br>
  <input type="hidden" value="#getcolumn.seo_friendly#" name="fromseo">
  <input NAME="seo_friendly" SIZE="150" value="#getcolumn.seo_friendly#" style="width:100%;">
    </cfoutput>
<br><br>
<center><b><input type="submit" Value="Update Link" class="btn"></b></center>
</center><br>
</form>
</td></tr></table>
</cfif>

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

<cfinclude template="footer.cfm">