<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;">
<cfif parameterexists(Session.email) and (Session.email IS NOT -1)>
<cfif (#getuser.accesslevel# eq 100)>

<table width=100%><tr><td style="padding:5px;" >
<div align="center"><font face=verdana size=+1><strong>Manage Best Bet Categories</strong></font>
 <font face=verdana size=-1><br />
 <a href="addbestbetcategory.cfm?notprint=on">View All</a>
<p>

<p><font face=verdana size="-2">
<strong>Merge Categories: Will Merge One Category's Records into Another, and will delete the empty venue.</strong>
<p>
<FORM action="cleanbest.cfm?cleantype=mergeperson" method="post"  enctype="multipart/form-data">

  <b><font SIZE="-2" FACE="verdana">ID # of Cat to Kill:</font></b><input NAME="oldname" SIZE="6">
    <b><font SIZE="-2" FACE="verdana">ID # of Cat to Merge Into:</font></b><input NAME="newname" SIZE="6"> <input type="submit" Value="Go">
</form>


<FORM action="addbestbetcategory2.cfm" method="post"  enctype="multipart/form-data">

   <table cellspacing=0 cellpadding=5 border=1>
<tr><td style="padding:5px;"  colspan=2>
<font face=verdana size=-1>
<cfquery name="getsites" datasource="#ds#">
select *
from ParentsListingsCatMain
<cfif parameterexists(url.notprint)>

<cfelse>
where catname like '%print%'

</cfif>
order by catname
</cfquery>
</div>

<table width="100%"><tr bgcolor="black">
<td style="padding:5px;" ><font face=verdana size=-1 color=white><b>ID</td>
<td style="padding:5px;" ><font face=verdana size=-1 color=white><b>MASTERCAT</td>

<td style="padding:5px;" ><font face=verdana size=-1 color=white><b>NAME</td>
<td style="padding:5px;" ><font face=verdana size=-1 color=white><b>EDIT</td>
<td style="padding:5px;" ><font face=verdana size=-1 color=white><b>DELETE</td>
<td style="padding:5px;" ><font face=verdana size=-1 color=white><b><center>COUNT</td>
</tr>
<cfoutput query="getsites">
<TR bgcolor="#IIf(CurrentRow Mod 2, DE('ffffff'), DE('ffffcf'))#"><td style="padding:5px;" ><font face=verdana size=-2><b>#id#</b></font></td>

<td style="padding:5px;" ><font face=verdana size=-2><b><Cfquery name="getmaster" datasource="#ds#">select catname from pkmastersource2011 where id = #mastercat2019#</cfquery>#getmaster.catname#</b></font></td>


<td style="padding:5px;" ><font face=verdana size=-2><b>#catname#</a>  <Cfif #hide# eq 1>(<em>hidden</em>)</Cfif></b></td>
<td style="padding:5px;" ><font face=verdana size=-2><a href="editbestbetcategory.cfm?id=#id#">edit</a></td>
<td style="padding:5px;" ><font face=verdana size=-2><a href="deletebestbetcategory.cfm?id=#id#"  onClick="return confirm('Do you really want to delete this category?');">delete</a></td>
<td style="padding:5px;" ><center>
<cfquery name="getcount" datasource="#ds#">
select count(distinct id) as counter
from ParentsListingsCat
where CatID = #id#
</cfquery>
<font face=verdana size=-1><b>#getcount.counter#</td>
</tr>
</cfoutput>
</table>

<p>
</td></tr>
  <tr><td style="padding:5px;" >
	  <b><font SIZE="-1" FACE="verdana">Category Name:</font></b>
  </td><td style="padding:5px;" >
	  <input NAME="Category" SIZE="65">
  </td></tr>


  <tr>
	  <td style="padding:5px;" >
	  <b><font SIZE="-1" FACE="verdana" >Hide:</font></b>
	  </td><td style="padding:5px;" >
<select name="hide">
<option value="0">No</option>
<option value="1">Yes</option>

</select>

  </td></tr>

 </table><br>
<center><input type="submit" Value="Add"><input type="reset" Value="Clear Form"></center>
</form>
</td></tr></table>

</cfif>
</cfif>