<Cfinclude template="header.cfm">

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

<cfif parameterexists(url.delete)>
<cfquery name="del" dataSource="#ds#">
	delete from directoryarticlesbonus
	where id = #url.delete#
</cfquery>
	<Cflocation url="manage-bonusdirectories.cfm" addToken="no"> 
</cfif>	

<cfif parameterexists(url.add)>
	
<cfquery name=addphoto datasource="#ds#">
INSERT INTO directoryarticlesbonus(title)
VALUES	('')
</cfquery>
<cfquery name="Gettop" datasource="#ds#"> 
select id from directoryarticlesbonus
order by id DESC
limit 0,1
</cfquery>
<Cflocation url="manage-bonusdirectories.cfm?edit=#gettop.id#" addToken="no"> 
</cfif>	

<cfif parameterexists(url.editsave)>
	
<cfquery name="upds" dataSource="#ds#">
	update directoryarticlesbonus
	set region = '#form.region#',
	title = '#form.title#',
	link = '#form.link#',
	displaycatpage = '#form.displaycatpage#'
where id = #url.editsave#
</cfquery>	
	

</cfif>	

<Cfif parameterexists(url.edit)>
	<cfoutput> 
	&nbsp;&nbsp;<a href="manage-bonusdirectories.cfm?delete=#url.edit#" onclick="return confirm('Are you sure?');">Delete Listing</a></cfoutput>
	<p>
		
	
	<Cfquery name="getone" dataSource="#ds#">
		select * from directoryarticlesbonus
		where id = #url.edit#
	</cfquery>
	
	<cfFORM action="manage-bonusdirectories.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">Region:</font></b>
  </td><td style="padding:8px;">
	  <input NAME="region" SIZE="65" value="#region#">
  </td></tr>

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

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

  </td></tr>
  <tr><td style="padding:8px;">
	  <b><font SIZE="-1" FACE="verdana">Display Cat Page:</font></b>
  </td><td style="padding:8px;">
	  <input NAME="displaycatpage" SIZE="65" value="#displaycatpage#">

  </td></tr>

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



	</cfFORM>	
	
	
<cfelse>

<cfquery name="gettodaya" datasource="#ds#">
select * from directoryarticlesbonus
</cfquery>
<font size=+1>
<a href="manage-bonusdirectories.cfm?add=on">Add Bonus Directory</a>
</font>

<TAble class="table color-table primary-table table-bordered table-striped table-hover">
<thead>
<th>EDIT</th>	
<th>REGION</th>	

<th>TITLE</th>	
<th>LINK</th>	
<th>CAT</th>	

</thead>

<Cfoutput query="Gettodaya">
		
<tr>
<td><a href="manage-bonusdirectories.cfm?edit=#id#">edit</a></td>	
<td>#region#</td>	

<td>#title#</td>	
<td>#link#</td>	
<td>#displaycatpage#</td>	

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


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

  </body>
</html>