<cfcontent type="text/html;charset=iso-8859-1">
<cfprocessingDirective pageencoding="iso-8859-1">
<cfset setEncoding("Form", "ISO-8859-15")>
<cfif DirectoryExists('/home2/cgny/www/listingsupload/#url.id#')>

<cfelse>

   <cfdirectory action = "create" directory = "/home2/cgny/www/listingsupload/#url.id#" mode="777" >
</cfif>

<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) and (#getuser.accesslevel# eq 100)>
<cfquery name="getcolumn" datasource="#ds#">
select *
from ParentsListingsCatMain2011
where id = #url.id#
</cfquery>
<table width=600><tr><td style="padding:5px;" >
<div align="center"><font face=verdana size=+1><strong>Edit Category</strong></font>
<br>
<a href="addbestbetcategory2011.cfm">Back...</a>
<cfoutput> 
<FORM action="editbestbetcategory22011.cfm" method=post enctype="multipart/form-data" >
</cfoutput>
  <br>
<cfoutput query="Getcolumn" maxrows = 1>
	
	<cfif #defaultimage# is not ''>
<img src="#defaultimage#">
	</cfif>
	
	 <input NAME="ID" SIZE="70" value="#getcolumn.id#" type="hidden">

   <table cellspacing=5 cellpadding=5>
	  <tr>
	  <td style="padding:5px;" >
	  <b><font SIZE="-1" FACE="verdana" >Category Name:</font></b>
	  </td><td style="padding:5px;" >
  <input NAME="name" SIZE="70" value="#getcolumn.catname#">
  </td></tr>

  
  	  <tr>
	  <td style="padding:5px;" >
	  <b><font SIZE="-1" FACE="verdana" >Short Category Name:</font></b>
	  </td><td style="padding:5px;" >
  <input NAME="shortname" SIZE="70" value="#getcolumn.shortname#">
  </td></tr>
  
  
  	  <tr>
	  <td style="padding:5px;" >
	  <b><font SIZE="-1" FACE="verdana" >Category Alias:</font></b>
	  </td><td style="padding:5px;" >
  <input NAME="catnamealias" SIZE="70" value="#getcolumn.catnamealias#">
  </td></tr>

	  <tr>
	  <td style="padding:5px;" >
	  <b><font SIZE="-1" FACE="verdana" >Category Description:</font></b>
	  </td><td style="padding:5px;" >
	  <textarea rows="10" cols="60" name="catdescription">#getcolumn.catdescription#</textarea>
  </td></tr>
  	 
	 
	 	  <tr>
	  <td style="padding:5px;" >
	  <b><font SIZE="-1" FACE="verdana" >Regional Description (use REGION to auto-replace):</font></b>
	  </td><td style="padding:5px;" >
	  <textarea rows="10" cols="60" name="regionaldescription">#getcolumn.regionaldescription#</textarea>
  </td></tr>
	 
	 	  <tr>
	  <td style="padding:5px;" >
	  <b><font SIZE="-1" FACE="verdana" >Rockland Description:</font></b>
	  </td><td style="padding:5px;" >
	  <textarea rows="10" cols="60" name="rocklanddescription">#getcolumn.rocklanddescription#</textarea>
  </td></tr>

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

</select>

  </td></tr>


  <tr>
	  <td style="padding:5px;" >
	  <b><font SIZE="-1" FACE="verdana" >Show In All Regions:</font></b>
	  </td><td style="padding:5px;" >
<select name="ignoreregions">
<cfif #getcolumn.ignoreregions# eq 1>
<option value="1">Yes</option>
</cfif>
<option value="0">No</option>
<option value="1">Yes</option>

</select>

  </td></tr>
  </cfoutput>

  <tr>
	  
	  <td style="padding:5px;" >
	  <b><font SIZE="-1" FACE="verdana" >Master Category:</font></b>
	  </td><td style="padding:5px;" >
<select name="mastercat">
<cfif #getcolumn.mastercat# is not 0>
<cfquery name="Getmas" datasource="cityguide">
select catname
from pkmastersource2011
where id = #getcolumn.mastercat#
</cfquery>
<cfoutput>
<option value="#getcolumn.mastercat#">#getmas.catname#</option>
</cfoutput>
</cfif>
<cfquery name="Getmas2" datasource="cityguide">
select catname,id
from pkmastersource2011
order by catname
</cfquery>
<cfoutput query="Getmas2">

<option value="#id#">#catname#</option>
</cfoutput>
</select>

  </td></tr>


   <tr>
	  <td style="padding:5px;" >
	  <b><font SIZE="-1" FACE="verdana" >SubCat (NYMP Only):</font></b>
	  </td><td style="padding:5px;" >
		  
   
  
<select name="newnympsub">
	<cfoutput>
<option value="#getcolumn.newnympsub#">#getcolumn.newnympsub#</option>
 </cfoutput>
  <cfquery name="Getloop" dataSource="#ds#">
	  select distinct newnympsub from regions
	  order by newnympsub
	  </cfquery>
	 	<cfoutput>
 

<cfloop from="1" to="#getloop.recordcount#" index="i">

<option value="#getloop.newnympsub[i]#">#getloop.newnympsub[i]#</option>
</cfloop> </cfoutput>

</select>

	  
  </td></tr>



  <tr>
	  
	  <td style="padding:5px;" >
	  <b><font SIZE="-1" FACE="verdana" >Article Override Category:</font></b>
	  </td><td style="padding:5px;" >
<select name="articlecategory">
<cfif #getcolumn.articlecategory# is not 0>
<cfquery name="Getmas" datasource="cityguide">
select name,id
from regions
where id = #getcolumn.articlecategory#
</cfquery>
<cfoutput>
<option value="#getcolumn.articlecategory#">#getmas.name#</option>
</cfoutput>
<option value="0">None</option>

<Cfelse>
<option value="0">None</option>

</cfif>
<cfquery name="Getmas2" datasource="cityguide">
select name,id
from regions
where siteid = 5

order by name
</cfquery>
<cfoutput query="Getmas2">

<option value="#id#">#name#</option>
</cfoutput>
</select>

  </td></tr>



<tr>
<td style="padding:5px;"  VALIGN=TOP colspan=2><b><font face="Arial" size="-1">Enhanced:</font></b><Br />
<script type="text/javascript" src="/admin/tiny_mce/tiny_mce.js"></script>
<!---  <script type="text/javascript">
tinyMCE_GZ.init({
	themes : 'simple,advanced',
	languages : 'en',
	disk_cache : true,
	debug : false
});
</script> --->
<Cfoutput>
<input name="copyedit" type="hidden" id="copyedit" value="#htmlEditFormat(getcolumn.enhancedlisting)#"/></cfoutput>
<script language="javascript" type="text/javascript">
tinyMCE.init({
		mode : "exact",
		elements: "copyedit",
		theme : "advanced",
		height: "600px",
		width: "700px",
		plugins : "imagemanager,spellchecker,style,layer,table,save,advhr,advimage,advlink,emotions,iespell,insertdatetime,preview,media,searchreplace,print,contextmenu,paste,directionality,fullscreen,noneditable,visualchars,nonbreaking,xhtmlxtras",
		theme_advanced_buttons1_add_before : "save,newdocument,separator",
		theme_advanced_buttons1_add : "fontselect,fontsizeselect",
		theme_advanced_buttons2_add : "separator,insertimage,insertdate,inserttime,preview,separator,forecolor,backcolor",
		theme_advanced_buttons2_add_before: "cut,copy,paste,pastetext,pasteword,separator,search,replace,separator",
		theme_advanced_buttons3_add_before : "tablecontrols,separator",
		theme_advanced_buttons3_add : "emotions,iespell,media,advhr,separator,print,separator,ltr,rtl,separator,fullscreen",
		theme_advanced_buttons4 : "insertlayer,moveforward,movebackward,absolute,|,styleprops,|,spellchecker,cite,abbr,acronym,del,ins,|,visualchars,nonbreaking",
		theme_advanced_toolbar_location : "top",
		theme_advanced_toolbar_align : "left",
		theme_advanced_path_location : "bottom",
		theme_advanced_resize_horizontal : true,
        theme_advanced_resizing : true,
        apply_source_formatting : true,
		content_css : "example_data/example_word.css",
	    plugin_insertdate_dateFormat : "%Y-%m-%d",
	    plugin_insertdate_timeFormat : "%H:%M:%S",
		extended_valid_elements : "hr[class|width|size|noshade],font[face|size|color|style],span[class|align|style]",
		file_browser_callback : "mcFileManager.filebrowserCallBack",
		paste_auto_cleanup_on_paste : true,
		paste_convert_headers_to_strong : true,
		relative_urls : false,
		remove_script_host : false,
		imagemanager_rootpath : "/home2/cgny/www/uploads2/<cfoutput>#url.id#</cfoutput>/"

	});
</script></td>
</tr>

		<tr><td style="padding:5px;"  valign=top><font face=verdana size=-1><strong>Image:</strong> </font></td><td style="padding:5px;" ><input type=file name="photo">

  
</table>
<center><b><input type="submit" Value="Update Category"></b></center>
</center><br>
</form>
</td></tr></table>

<p>
<strong>Listings</strong>
<p>
<cfquery name="getlistingsad" datasource="#ds#">
select distinct ParentsListings.id,ParentsListings.name,ParentsListings.catname,ParentsListings.address,ParentsListings.phone,city,state,ParentsListingsCat2011.catid  as catvar,ParentsListings.advertiser,ParentsListings.website,ParentsListings.region,ParentsListings.description
from ParentsListings
inner join ParentsListingsCat2011 on ParentsListings.id = ParentsListingsCat2011.pkid
where ParentsListingsCat2011.catid = #url.id#
and advertiser > 0
and hide =0 
and delflag = 0 
order by advertiser desc, name
</cfquery>
<cfoutput> 
<FORM action="deletepklistingmulti2011.cfm?catid=#url.id#" method="post">
</cfoutput>
<Table border="1" cellpadding="4" cellspacing="0">
<cfoutput query="Getlistingsad">
<tr onmouseover="style.backgroundColor='FFFF99';"
onmouseout="style.backgroundColor='ffffff'"><td style="padding:5px;" >


<input name="regions" type="checkbox" value="#id#" /><strong>

<font face="Verdana, Geneva, sans-serif" size=-1>
<a target="_new" href="listingseditpk.cfm?id=#id#&table=ParentsListings&cat=Academic%20Enrichment&catid=236">#name#</a></strong><br />#address# #city#<small>#description#</small> </Td><td style="padding:5px;" ><font face="Verdana, Geneva, sans-serif" size=-1> #region# </Td><td style="padding:5px;" >
<font face="Verdana, Geneva, sans-serif" size=-1>
<cfif #advertiser# eq 1>Premium Plus</cfif>
<cfif #advertiser# eq 2>Premium</cfif>
<cfif #advertiser# eq 3>Basic</cfif>
<cfif #advertiser# eq 0>Non Advertiser</cfif>

</a></strong>
</Td></tr>




</cfoutput>

</Table>
<input type="submit" value="Delete Selected"></form>
</FORM>





</cfif>