<cfcontent type="text/html;charset=iso-8859-1">
<cfprocessingDirective pageencoding="iso-8859-1">
<cfset setEncoding("Form", "ISO-8859-15")>
<cfinclude template="header.cfm">


<!--- clean url --->
<cfquery name="getstuff" datasource="#ds#">
select title,seo_title, id,mag
from columntable
where id > 
105306
and title <> '' and seo_friendly = ''
order by id desc
limit 0,10
</cfquery>


<cfoutput query="getstuff">

<cfif #seo_title# is not ''>
<cfset moveurl = reReplace(seo_title, "([^[:alnum:]|[:blank:]]) ", "", "all")>

<Cfelse>
<cfset moveurl = reReplace(title, "([^[:alnum:]|[:blank:]]) ", "", "all")>
</cfif>
<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 columntable where seo_friendly = '#moveurl#'
and mag = #getstuff.mag#
</cfquery>

<Cfif #checkmove.recordcount# gt 0>
<cfset moveurl = '#moveurl##dateformat(currentdatetime,'yyyymmdd')#'>
</cfif>
#id# - #moveurl#<br>

<cfquery name="updater" datasource="#ds#">
update low_priority columntable
set seo_friendly = '#moveurl#'
where id = #id#
</cfquery>
</cfoutput>
<!--- clean url --->

<div id="content">
  <div id="content-header">
  </div>
  <div class="container-fluid" style="margin-left:200px;">


<cfparam name="url.mag" default="5">
<cfparam name="form.excludecategory" default="0">

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

<Cfif parameterexists(url.author)>
<Cfparam name="form.author" default="#url.author#">
</Cfif>
<Cfif parameterexists(url.category)>
<Cfparam name="form.category" default="#url.category#">
</Cfif>


<cfparam name = "url.mag" default="1">
<cfparam name = "url.topr" default="999999">
<cfif #getuser.accesslevel# lt 100>



<cfquery name="getcol" datasource="#ds#">
SELECT columnmaster.member,columnmaster.showviews,columnmaster.AuthorName,columntable.replies,columntable.lastedit, columntable.homepage,columnmaster.Title, columntable.id, columntable.MainPage,columntable.MainPagewetw, columntable.DatePosted, columntable.Status, columntable.Title as coltitle,columntable.review, columntable.seo_friendly,columntable.emailviews,columntable.interview,columntable.general,columntable.photoop,columntable.datesubmitted, columntable.columnnum, columnmaster.smallpicture,columntable.offbeat,columntable.stopdate,columntable.uconcert, columntable.views,columntable.region
FROM columntable INNER JOIN columnmaster ON columntable.ColumnNum = columnmaster.ID
left join columntableredirect on columntable.seo_friendly = columntableredirect.fromseo
left join columntableimages on columntable.id  = columntableimages.colid

where columnmaster.member = '#getuser.member#' and columntable.siteid = #siteid# <cfif parameterexists(url.topr)>and columntable.id < #url.topr#</cfif> and columntable.id <> 4186 and 1<Cfif parameterexists(form.approved)>and status = #form.approved#</Cfif>

and columnnum <> 527
<Cfif parameterexists(form.homepage)>and homepage = 1 and stopdate > #currentdatetime#</cfif>
<Cfif parameterexists(form.mainpage)>and mainpage = 1 and stopdate > #currentdatetime#</cfif>
<Cfif parameterexists(form.regionalmainpage)>and MainPagewetw = 1</cfif>
and (columntableimages.redir = '' or columntableimages.redir is null)
and (columntableredirect.toseo = '' or columntableredirect.toseo is null)


<Cfif parameterexists(form.author) and #form.author# is not ''>and columntable.columnnum = #form.author#</Cfif>
<Cfif parameterexists(form.author) and #form.author# is not ''>and columntable.columnnum = #form.author#</Cfif>
<Cfif parameterexists(form.postedby) and #form.postedby# is not ''>and columntable.postedby = '#form.postedby#'</Cfif>

<Cfif parameterexists(form.datetime) and #form.datetime# is not ''>and dateposted >= '#form.datetimeyear#-#form.datetime#-01'</Cfif>
<Cfif parameterexists(form.laststatussent) and #form.laststatussent# is not ''> and dateposted <= '#form.laststatussentyear#-#form.laststatussent#-30'
</Cfif>


<Cfif not parameterexists(form.Directories) and not parameterexists(url.directories)>
and (columnnum <> 752 and columnnum <> 818 and columnnum <> 803)
</Cfif>
<Cfif not parameterexists(form.events) and not parameterexists(url.events)>
and (columnnum <> 1226 and columnnum <> 1209)
</Cfif>

and columntable.columnnum <> 1024
and columntable.columnnum <> 589

<Cfif parameterexists(form.sortby) and #form.sortby# eq 'Views'>
order by views desc
<cfelseif parameterexists(url.updated)>
order by lastedit desc 
<cfelse>
order by columntable.datesubmitted desc
</cfif>

<Cfif (parameterexists(form.datetime) and #form.datetime# is not '') or (parameterexists(form.category) and form.category is not '0')>

<cfelse>
limit 0,525

</Cfif>



</cfquery>

<cfelse>

<cfif parameterexists(form.searchterm) and #form.searchterm# is not ''>
<cfquery name="getcol" datasource="#ds#">
SELECT columnmaster.member,columnmaster.showviews,columnmaster.AuthorName,columntable.replies,columntable.lastedit, columnmaster.Title,columntable.homepage, columntable.id, columntable.MainPage, columntable.DatePosted, columntable.Status, columntable.Title as coltitle,columntable.seo_friendly, columntable.review,columntable.MainPagewetw, columntable.interview,columntable.general,columntable.photoop,columntable.datesubmitted, columntable.columnnum, columntable.emailviews,columnmaster.smallpicture,columntable.offbeat,columntable.stopdate,columntable.views,columntable.stopdate,columntable.uconcert,columntable.region
FROM columntable INNER JOIN columnmaster ON columntable.ColumnNum = columnmaster.ID
left join columntableredirect on columntable.seo_friendly = columntableredirect.fromseo
left join columntableimages on columntable.id  = columntableimages.colid

where columntable.siteid = #siteid# <Cfif parameterexists(url.glam)>and columntable.columnnum = 13<cfelse>and columntable.columnnum <> 13</CFIF>  and columntable.Title <> 'Top1' and columntable.Title <> 'Top2' and columntable.Title <> 'Top3' <cfif parameterexists(url.topr)>and columntable.id < #url.topr#</cfif> and ((columntable.Title LIKE '%#Form.searchterm#%') or  (columntable.copy LIKE '%#Form.searchterm#%') or (columnmaster.AuthorName LIKE '%#Form.searchterm#%'))  and columntable.id <> 4186 and (columntable.mag = 1)
<Cfif parameterexists(form.approved)>and status = #form.approved#</Cfif>
<Cfif parameterexists(form.mainpage)>and mainpage = 1 and stopdate > #currentdatetime#</cfif>

and columnnum <> 527

<Cfif parameterexists(form.regionalmainpage)>and MainPagewetw = 1</cfif>

<Cfif parameterexists(form.excluderedirect) and #form.excluderedirect# eq 'on'><cfelse>
and (columntableimages.redir = '' or columntableimages.redir is null)
and (columntableredirect.toseo = '' or columntableredirect.toseo is null)</Cfif>

<Cfif parameterexists(form.homepage)>and homepage = 1 and stopdate > #currentdatetime#</cfif><Cfif parameterexists(form.author) and #form.author# is not ''>and columntable.columnnum = #form.author#</Cfif>
<Cfif not parameterexists(form.Directories) and not parameterexists(url.directories)>
and (columnnum <> 752 and columnnum <> 818 and columnnum <> 803)
</Cfif>
<Cfif not parameterexists(form.events) and not parameterexists(url.events)>
and (columnnum <> 1226 and columnnum <> 1209)
</Cfif>

<Cfif parameterexists(form.postedby) and #form.postedby# is not ''>and columntable.postedby = '#form.postedby#'</Cfif>
and columntable.columnnum <> 589

<Cfif parameterexists(form.datetime) and #form.datetime# is not ''>and dateposted >= '#form.datetimeyear#-#form.datetime#-01'</Cfif>
<Cfif parameterexists(form.laststatussent) and #form.laststatussent# is not ''> and dateposted <= '#form.laststatussentyear#-#form.laststatussent#-30'
</Cfif>


<cfif parameterexists(url.topr)>and columntable.id < #url.topr#</cfif>

and columntable.columnnum <> 1024


<Cfif parameterexists(form.sortby) and #form.sortby# eq 'Views'>
order by views desc
<cfelseif parameterexists(url.updated)>
order by lastedit desc 
<cfelse>
order by columntable.datesubmitted desc
</cfif></cfquery>



<cfelseif parameterexists(form.category) and form.category is not '0'>

<cfquery name="getcol" datasource="#ds#">
SELECT regionstable.colid,columnmaster.member,columnmaster.showviews,columnmaster.AuthorName,columntable.replies,columntable.lastedit,columntable.homepage, columnmaster.Title, columntable.id, columntable.MainPage, columntable.DatePosted, columntable.Status, columntable.Title as coltitle, columntable.review,columntable.MainPagewetw, columntable.seo_friendly,columntable.emailviews,columntable.interview,columntable.general,columntable.photoop,columntable.datesubmitted, columntable.columnnum, columnmaster.smallpicture,columntable.offbeat,columntable.stopdate,columntable.views,columntable.stopdate,columntable.uconcert,columntable.region
FROM columntable INNER JOIN columnmaster ON columntable.ColumnNum = columnmaster.ID  INNER JOIN regionstable ON regionstable.colid = columntable.ID
left join columntableredirect on columntable.seo_friendly = columntableredirect.fromseo
left join columntableimages on columntable.id  = columntableimages.colid

where columntable.siteid = #siteid#
and regionstable.regionsid = #form.category#
<Cfif parameterexists(form.excluderedirect) and #form.excluderedirect# eq 'on'><cfelse>
and (columntableimages.redir = '' or columntableimages.redir is null)
and (columntableredirect.toseo = '' or columntableredirect.toseo is null)</Cfif>
and columnnum <> 527


<Cfif parameterexists(form.postedby) and #form.postedby# is not ''>and columntable.postedby = '#form.postedby#'</Cfif>

<Cfif parameterexists(form.approved)>and status = #form.approved#</Cfif>
<Cfif parameterexists(form.mainpage)>and mainpage = 1 and stopdate > #currentdatetime#</cfif>
<Cfif parameterexists(form.regionalmainpage)>and MainPagewetw = 1 and stopdate > #currentdatetime#</cfif>

<Cfif parameterexists(form.homepage)>and homepage = 1 and stopdate > #currentdatetime#</cfif><Cfif not parameterexists(form.Directories) and not parameterexists(url.directories)>
and (columnnum <> 752 and columnnum <> 818 and columnnum <> 803)
</Cfif>
<Cfif not parameterexists(form.events) and not parameterexists(url.events)>
and (columnnum <> 1226 and columnnum <> 1209)
</Cfif>

<Cfif parameterexists(form.datetime) and #form.datetime# is not ''>and dateposted >= '#form.datetimeyear#-#form.datetime#-01'</Cfif>
<Cfif parameterexists(form.laststatussent) and #form.laststatussent# is not ''> and dateposted <= '#form.laststatussentyear#-#form.laststatussent#-30'
</Cfif>


<cfif parameterexists(url.topr)>and columntable.id < #url.topr#</cfif>

and columntable.columnnum <> 1024
and columntable.columnnum <> 589

<Cfif parameterexists(form.author) and form.author is not '61' and #form.author# is not ''>and columntable.columnnum = #form.author#</Cfif>

<Cfif parameterexists(form.sortby) and #form.sortby# eq 'Views'>
order by views desc
<cfelseif parameterexists(url.updated)>
order by lastedit desc 
<cfelse>
order by columntable.datesubmitted desc
</cfif></cfquery>

<cfelse>
	

	


<cfquery name="getcol" datasource="#ds#">
SELECT columnmaster.member,columnmaster.showviews,columnmaster.AuthorName,columntable.replies,columntable.lastedit, columnmaster.Title,columntable.homepage, columntable.id, columntable.MainPage, columntable.DatePosted, columntable.Status, columntable.Title as coltitle, columntable.review,columntable.MainPagewetw, columntable.emailviews,columntable.general,columntable.interview,columntable.photoop,columntable.datesubmitted, columntable.seo_friendly,columntable.columnnum, columntable.seo_friendly,columnmaster.smallpicture,columntable.offbeat,columntable.stopdate,columntable.views,columntable.stopdate,columntable.uconcert,columntable.region
FROM columntable INNER JOIN columnmaster ON columntable.ColumnNum = columnmaster.ID <Cfif parameterexists(form.mastercat)>inner join columncat on columncat.colid = columntable.id</Cfif>
left join columntableredirect on columntable.seo_friendly = columntableredirect.fromseo

left join columntableimages on columntable.id  = columntableimages.colid

where columntable.siteid = #siteid# <Cfif parameterexists(url.glam)>and columntable.columnnum = 13<cfelse>and columntable.columnnum <> 13</CFIF>  and columntable.Title <> 'Top1' and columntable.Title <> 'Top2' and columntable.Title <> 'Top3' <cfif parameterexists(url.topr)>and columntable.id < #url.topr#</cfif> and columntable.id <> 4186 and (columntable.mag = 1)
<Cfif parameterexists(form.approved)>and status = #form.approved#</Cfif>
<Cfif parameterexists(form.mainpage)>and mainpage = 1 and stopdate > #currentdatetime#</cfif>
<Cfif parameterexists(form.regionalmainpage)>and MainPagewetw = 1 </cfif>
<Cfif parameterexists(form.excluderedirect) and #form.excluderedirect# eq 'on'><cfelse>
and (columntableimages.redir = '' or columntableimages.redir is null)
and (columntableredirect.toseo = '' or columntableredirect.toseo is null)</Cfif>


<Cfif parameterexists(form.postedby) and #form.postedby# is not ''>and columntable.postedby = '#form.postedby#'</Cfif>

<Cfif parameterexists(form.homepage)>and homepage = 1 and stopdate > #currentdatetime#</cfif><Cfif not parameterexists(form.Directories) and not parameterexists(url.directories)>
and (columnnum <> 752 and columnnum <> 818 and columnnum <> 803)
</Cfif>
<Cfif not parameterexists(form.events) and not parameterexists(url.events)>
and (columnnum <> 1226 and columnnum <> 1209)
</Cfif>
and columntable.columnnum <> 1024
and columntable.columnnum <> 589

<cfif parameterexists(url.topr)>and columntable.id < #url.topr#</cfif>

<Cfif parameterexists(form.datetime) and #form.datetime# is not ''>and dateposted >= '#form.datetimeyear#-#form.datetime#-01'</Cfif>
<Cfif parameterexists(form.laststatussent) and #form.laststatussent# is not ''> and dateposted <= '#form.laststatussentyear#-#form.laststatussent#-30'
</Cfif>

and columnnum <> 527

<Cfif parameterexists(form.author) and #form.author# is not '' and #form.author# is not 63 >and columntable.columnnum = #form.author#</Cfif>
<Cfif parameterexists(form.mastercat)>and columncat.catid like '#form.mastercat#'</Cfif>

<Cfif parameterexists(form.sortby) and #form.sortby# eq 'Views'>
order by views desc
<cfelseif parameterexists(url.updated)>
order by lastedit desc 
<cfelse>
order by columntable.datesubmitted desc
</cfif>
<Cfif (parameterexists(form.datetime) and #form.datetime# is not '') or (parameterexists(form.category) and form.category is not '0')>

<cfelse>
limit 0,125

</Cfif>
</cfquery>

</cfif>




</cfif>

<table width="100%"><tr><td style="padding:5px;" >

<cfif #getuser.accesslevel# eq 100>

<table border="1" width="100%"><tr><td style="padding:5px;" >
</cfif>


<div align="center"><font face=verdana size=+1><strong>
<cfif #url.mag# eq 1>CityGuideMagazine.com</cfif> Article Admin</strong></font>
<br><cfif #getcol.recordcount# gte 0><Cfoutput>
<font face=verdana size=-1><a href="postcolumn.cfm?mag=#url.mag#">Post Article</a> </cfoutput><cfif #getuser.accesslevel# eq 100><br /> <a href="addcolumn.cfm">Add Author</a> <br /> <a href="ordercol.cfm">Edit Authors</a> <br /><Cfoutput><a href="addcategory.cfm?id=#url.mag#">Manage Categories</a></Cfoutput>
<p>

</cfif></font>
</cfif>
</div><p>

<cfif #getuser.accesslevel# eq 100>
<Cfquery name="getauthors" datasource="#ds#">
select distinct columntable.columnnum,columnmaster.authorname
from columntable inner join columnmaster on columntable.columnnum = columnmaster.id
where columntable.mag = 1
order by authorname
</Cfquery>

<Cfquery name="getposted" datasource="#ds#">
select distinct columntable.postedby
from columntable
where columntable.mag = 1
order by postedby
</Cfquery>


</td>
<td style="padding:5px;" ><Cfoutput>
<FORM action="columnadmin.cfm?mag=#url.mag#" method="post">
</Cfoutput>

	  <cfoutput>



<Table border="0" width="100%">
<Tr><td style="padding:5px;"  colspan="3">
      <Font face=verdana size=-1><b>
<strong>Search:
</strong>

	  <INPUT size="50" name="searchterm" <cfif parameterexists(form.searchterm)>value="#Form.searchterm#"</cfif>></cfoutput>

</Td></Tr>

<Tr><td style="padding:5px;"  width="33%"><Font face=verdana size=-1><b>Include Dirs</b> <input name="Directories" type="checkbox" value="1" <cfif parameterexists(form.directories) or parameterexists(url.directories)>checked</cfif>><Font face=verdana size=-1> Yes</td>

<td style="padding:5px;"  width="33%"><Font face=verdana size=-1><b>Homepage Stories</b> <input name="Homepage" type="checkbox" value="1" <cfif parameterexists(form.Homepage) or parameterexists(url.Homepage)>checked</cfif>><Font face=verdana size=-1> Yes





<br>
<Font face=verdana size=-1><b>Mainpage Stories</b> <input name="mainpage" type="checkbox" value="1" <cfif parameterexists(form.Mainpage) or parameterexists(url.Mainpage)>checked</cfif>><Font face=verdana size=-1> Yes



<br>
<Font face=verdana size=-1><b>Regional Mainpage</b> <input name="regionalmainpage" type="checkbox" value="1" <cfif parameterexists(form.regionalmainpage) or parameterexists(url.regionalmainpage)>checked</cfif>><Font face=verdana size=-1> Yes

<br>
<Font face=verdana size=-1><b>Exclude Redirected</b> <input name="excluderedirect" type="checkbox" value="1" <cfif parameterexists(form.excluderedirect) or parameterexists(url.excluderedirect)>checked</cfif>><Font face=verdana size=-1> Yes



</td>


<td style="padding:5px;"  width="33%">
	<!---<Font face=verdana size=-1><b>Include Events</b> <input name="events" type="checkbox" value="1" <cfif parameterexists(form.events) or parameterexists(url.events)>checked</cfif>><Font face=verdana size=-1> Yes---></td>
</Tr>

<Tr><td style="padding:5px;"  colspan="3">
	<Font face=verdana size=-1><b>Sort By <input name="sortby" type="radio" value="Date" checked/><Font face=verdana size=-1> Date <input name="sortby" type="radio" value="Views" /><Font face=verdana size=-1> Views

</td></Tr>
<Tr><td style="padding:5px;"  colspan="3"><Font face=verdana size=-1><b>Author
<select name="author">
<option value="">All</option>
<cfoutput query="getauthors">
<option value="#getauthors.columnnum#">#getauthors.authorname#</option>
</cfoutput>
</select>
</td></Tr>



<cfquery name="Getreg" datasource="cg22">
select *
from regions
where siteid = 1
order by mastercat,name
</cfquery>
<Tr><td style="padding:5px;"  colspan="3"><Font face=verdana size=-1><b>Category
<select name="category">
<option value="0">All Categories</option>
<cfoutput query="Getreg">
<option value="#Getreg.id#"><cfif #mastercat# is not '' and #mastercat# is not ' '>#getreg.mastercat# - </cfif>#Getreg.name#</option>
#Getreg.name#</option>
</cfoutput>
</select>
</td></Tr>


<Tr><td style="padding:5px;"  colspan="3"><Font face=verdana size=-1><b>Exclude Category
<select name="excludecategory">
<option value="0">All Categories</option>
<cfoutput query="Getreg">
<option value="#Getreg.id#"><cfif #mastercat# is not '' and #mastercat# is not ' '>#getreg.mastercat# - </cfif>#Getreg.name#</option>
#Getreg.name#</option>
</cfoutput>
</select>
</td></Tr>


<cfif #url.mag# eq 111 or #url.mag# eq 112>
<Tr><td style="padding:5px;" ><Font face=verdana size=-1><b>Master Categories</Td><td style="padding:5px;" ><input name="mastercat" type="radio" value="3" /><Font face=verdana size=-1>To Dine<br /><input name="mastercat" type="radio" value="2" /><Font face=verdana size=-1>To Do
</td><td style="padding:5px;" ><input name="mastercat" type="radio" value="4" /><Font face=verdana size=-1>To Shop<br /><input name="mastercat" type="radio" value="5" /><Font face=verdana size=-1>Real Estate
</td></Tr>
</cfif>

<!---
<tr><td style="padding:5px;"  colspan="2">
<Table width="400" border="0"><Tr><td style="padding:5px;" ></TD></Tr></Table>
<font face="Verdana, Geneva, sans-serif" size=-1>

<Cfoutput>
<strong>Column Search Start:
</strong><select name="datetime">

<Cfif parameterexists(form.datetime) and #form.datetime# is not ''><option value="#form.datetime#">#form.datetime#</option></Cfif>
<Cfif parameterexists(url.datetime) and #url.datetime# is not ''><option value="#url.datetime#">#url.datetime#</option></Cfif>


<option value="">View All Months</option>
<Cfloop from="1" to="12" index="i">
<option value="#i#">#i#</option>
</Cfloop>
</select>
<select name="datetimeyear">

<Cfif parameterexists(form.datetimeyear) and #form.datetimeyear# is not ''><option value="#form.datetimeyear#">#form.datetimeyear#</option></Cfif>
<Cfif parameterexists(url.datetimeyear) and #url.datetimeyear# is not ''><option value="#url.datetimeyear#">#url.datetimeyear#</option></Cfif>


<option value="">View All Years</option>
<option value="2010">2010</option>
<option value="2011">2011</option>
<option value="2012">2012</option>
<option value="2013">2013</option>
<option value="2014">2014</option>
<option value="2015">2015</option>
<option value="2016">2016</option>
<option value="2017">2017</option>
<option value="2018">2018</option>
<option value="2019">2019</option>

</select>

<br />
<strong>Column Search End:
</strong><select name="laststatussent">
<Cfif parameterexists(form.laststatussent) and #form.laststatussent# is not ''><option value="#form.laststatussent#">#form.laststatussent#</option></Cfif>
<Cfif parameterexists(url.laststatussent) and #url.laststatussent# is not ''><option value="#url.laststatussent#">#url.laststatussent#</option></Cfif>


<option value="">View All Months</option>
<Cfloop from="1" to="12" index="i">
<option value="#i#">#i#</option>
</Cfloop>
</select>
<select name="laststatussentyear">
<Cfif parameterexists(form.laststatussentyear) and #form.laststatussentyear# is not ''><option value="#form.laststatussentyear#">#form.laststatussentyear#</option></Cfif>
<Cfif parameterexists(url.laststatussentyear) and #url.laststatussentyear# is not ''><option value="#url.laststatussentyear#">#url.laststatussentyear#</option></Cfif>

<option value="">View All Years</option>
<option value="2010">2010</option>
<option value="2011">2011</option>
<option value="2012">2012</option>
<option value="2013">2013</option>
<option value="2014">2014</option>
<option value="2015">2015</option>
<option value="2016">2016</option>
<option value="2017">2017</option><option value="2018">2018</option>

<option value="2019">2019</option>

</select>

 </Cfoutput>


</td>--->
<td style="padding:5px;" >
<center>
<INPUT type=submit value="Go!"></font>
</center>

</Td>
</tr>

</Table>


</form>
</Td></Tr></Table>


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

<cfif parameterexists(url.message) and #url.message# eq 'thanks'>
<center><font face=verdana size=+2 color=B22023>
<strong>Your Column Has Been Submitted...</strong>
</font></center></cfif>
<p>


<Cfif parameterexists(form.datetime)>
<Cfoutput>
<center><font face=verdana size=+2 color=B22023>
<strong>#getcol.recordcount# Results</strong>
</font></center>
</Cfoutput>
</Cfif>

<Table width=100% cellspacing=4 cellpadding=2>
<cfset counter=0>

<cfoutput query="getcol">
	
	
<cfif #id# is not #id[currentrow-1]#>

<cfquery name="checkcatexclude" dataSource="#ds#">
select * from regionstable where colid = #id# and regionsid = #form.excludecategory#
</cfquery>
<Cfif #checkcatexclude.recordcount# eq 0> 
<cfif #counter# eq 0 or #counter# eq 15 or #counter# eq 30>
<tr bgcolor=black>
<td style="padding:5px;" ></td>
<td style="padding:5px;" ><span class="regularw"><B>TITLE</td>
<td style="padding:5px;" ><span class="regularw"><B>CATS</td>
<Cfif #Url.mag# eq '5'>
<td style="padding:5px;" ><span class="regularw"><B>REGION</td>
</Cfif>
<td style="padding:5px;" ><span class="regularw"><B>AUTHOR</TD>
<cfif #getcol.showviews# eq '0' or #getuser.accesslevel# eq 100><td style="padding:5px;" ><center><span class="regularw"><B><center>VIEWS</TD></cfif>

<td style="padding:5px;" ><center><span class="regularw"><B>STATUS</TD>
<td style="padding:5px;" ><center><span class="regularw"><B>MAIN</TD>
<cfif #url.mag# eq '111' or #url.mag# eq '112'>
<td style="padding:5px;" ><center><span class="regularw"><B>TO DO</TD>
<td style="padding:5px;" ><center><span class="regularw"><B>TO SHOP</TD>
<td style="padding:5px;" ><center><span class="regularw"><B>TO DINE</TD>
<td style="padding:5px;" ><center><span class="regularw"><B>R ESTATE</TD>

</cfif> 




<td style="padding:5px;" ><center><span class="regularw"><B>SUBMITTED</TD>
<td style="padding:5px;" ><center><span class="regularw"><B>UPDATED</TD>

<cfif #getuser.accesslevel# eq 1000>
<Cfif #url.mag# eq '1'><td style="padding:5px;" ><center><span class="regularw"><B>TOP CG</TD></cfif>
<Cfif #url.mag# eq '1'><td style="padding:5px;" ><center><span class="regularw"><B>TOP CG 2</TD></cfif>
<Cfif #url.mag# eq '1'><td style="padding:5px;" ><center><span class="regularw"><B>TOP CG 3</TD></cfif>

<Cfif #url.mag# eq '2'><td style="padding:5px;" ><center><span class="regularw"><B>TOP ML</TD>
<td style="padding:5px;" ><center><span class="regularw"><B>TOP ML 2</TD>
<td style="padding:5px;" ><center><span class="regularw"><B>TOP ML 3</TD></cfif>
<Cfif #url.mag# eq '5'>
<td style="padding:5px;" ><center><span class="regularw"><B>HOME PAGE</TD>
<td style="padding:5px;" ><center><span class="regularw"><B>REG HOME</TD>

</cfif>


</cfif>

</tr>
</cfif>
<cfset counter=#counter# + 1>
<cfquery name="getcoldata" datasource="#ds#">
select *
from columncat
where colid = #getcol.id#
</cfquery>
<TR bgcolor="#IIf(CurrentRow Mod 2, DE('ffffff'), DE('efefef'))#">
<td style="padding:5px;" >
<A name="a#id#">
<strong><a href="editcol3335.cfm?id=#id#&mag=#url.mag#&topr=#url.topr#" class="ca"><i class="ti ti-pencil-alt"></i></a></strong>

</td>
<td style="padding:5px;" >
<a href="https://www.cityguideny.com/article/#seo_friendly#" class="ca">

<font face=verdana size=-1>

#coltitle#</a></font>
</td><td style="padding:5px;" >
<Cfquery name="Getregions" datasource="#ds#">
SELECT distinct regions.name
FROM regions
inner join regionstable on regions.id = regionstable.regionsid
where regionstable.colid = #id#
order by name
</CFQUERY>
<font face=verdana size=-2>
<cfloop from="1" to="#getregions.recordcount#" index="abc">
<cfif #getregions.name[abc]# is not '#getregions.name[abc-1]#'>#getregions.name[abc]# <cfif #abc# is not #getregions.recordcount#>-</cfif></cfif>

</cfloop></td>

<Cfif #url.mag# eq '5'>
<td style="padding:5px;" >
<font face=verdana size=-2>
#rereplace(region,",", ", ","all")#
</td>
</cfif>

<td style="padding:5px;" >
<cfif #getuser.accesslevel# gte 15><a href="editcolumn.cfm?id=#getcol.columnnum#" class="ca"></cfif><small>#getcol.Authorname#</a></span>
</a></font></td>
<cfif #getcol.showviews# eq '0' or #getuser.accesslevel# eq 100>
<td style="padding:5px;" ><center>


<cfset zz = #getcol.views# * .9>
 #round(zz)#</TD>
</cfif>

<td style="padding:5px;" ><center>
<cfif #getuser.accesslevel# gte 100 or #getuser.id# eq 1751 or #getuser.id# eq 41552>
<a href="changestatus.cfm?id=#id#&mag=#url.mag#<cfif parameterexists(url.topr)>&topr=#url.topr#</cfif>" class="ca"  onClick="return confirm('Make this article live/pending?');">
</cfif>
<cfif #status# eq '0' or #status# eq '3'><span class="label label-rouded label-danger">pending
</span></cfif><cfif #status# eq '1'><span class="label label-rouded label-success">live</span></cfif></a></TD>

<td style="padding:5px;" ><center>
<cfif #getuser.accesslevel# gte 100 or #getuser.id# eq 1751>
<a href="changemain.cfm?id=#id#&mag=#url.mag#" class="ca"  onClick="return confirm('Put this article on the main page?');">
</cfif>
<cfif #mainpage# eq '0' or #mainpage# eq '3'>No</cfif><cfif #mainpage# eq '1'>Yes</cfif></a></TD>

<cfif #url.mag# eq '111' or #url.mag# eq '112'>
<td style="padding:5px;" ><center><cfif #getuser.accesslevel# gte 100><a href="changeitem.cfm?id=#id#&siteid=#siteid#&mag=#url.mag#&catid=2" class="ca"  onClick="return confirm('Mark article as To Do?');"></cfif><cfset x=0>
<cfloop index="z" from="1" to="#getcoldata.recordcount#" step="1">
<cfif #getcoldata.catid[z]# eq '2'>
<cfset x=x+1>
</cfif>
</cfloop>
<cfif x eq 1>
Yes
<cfelse>
No</cfif></a></td>
<td style="padding:5px;" ><center><cfif #getuser.accesslevel# gte 100><a href="changeitem.cfm?id=#id#&siteid=#siteid#&mag=#url.mag#&catid=4" class="ca"  onClick="return confirm('Mark Article as To Shop?');"></cfif><cfset x=0>
<cfloop index="z" from="1" to="#getcoldata.recordcount#" step="1">
<cfif #getcoldata.catid[z]# eq '4'>
<cfset x=x+1>
</cfif>
</cfloop>
<cfif x eq 1>
Yes
<cfelse>
No</cfif></a></td>
<td style="padding:5px;" ><center><cfif #getuser.accesslevel# gte 100><a href="changeitem.cfm?id=#id#&siteid=#siteid#&mag=#url.mag#&catid=3" class="ca"  onClick="return confirm('Mark Article as To Dine?');"></cfif><cfset x=0>
<cfloop index="z" from="1" to="#getcoldata.recordcount#" step="1">
<cfif #getcoldata.catid[z]# eq '3'>
<cfset x=x+1>
</cfif>
</cfloop>
<cfif x eq 1>
Yes
<cfelse>
No</cfif></a></td>

<td style="padding:5px;" ><center><cfif #getuser.accesslevel# gte 100><a href="changeitem.cfm?id=#id#&siteid=#siteid#&mag=#url.mag#&catid=5" class="ca"  onClick="return confirm('Mark article as Real Estate?');"></cfif><cfset x=0>
<cfloop index="z" from="1" to="#getcoldata.recordcount#" step="1">
<cfif #getcoldata.catid[z]# eq '5'>
<cfset x=x+1>
</cfif>
</cfloop>
<cfif x eq 1>
Yes
<cfelse>
No</cfif></a></td>

</cfif>




<td style="padding:5px;" ><font face=verdana size=-2><center>#DateFormat(datesubmitted,"m/d/yy")# #TimeFormat(datesubmitted, 'h:mm')#
</td><td style="padding:5px;" ><font face=verdana size=-2>
<strong><cfif dateposted eq ''>pending<cfelse>
	
	<Cfif #lastedit# gt dateposted>
			#DateFormat(lastedit,"m/d/yy")# #TimeFormat(lastedit, 'h:mm')# 

		<cfelse>
	#DateFormat(dateposted,"m/d/yy")# #TimeFormat(dateposted, 'h:mm')# 
	</Cfif>
	</cfif></td>


<!---
<cfif #getuser.accesslevel# gte 100>
 <Cfif #url.mag# eq '1'>
<td style="padding:5px;" ><center><cfif #getuser.accesslevel# gte 100><a href="changeitem.cfm?id=#id#&siteid=#siteid#&mag=#url.mag#&catid=7" class="ca"  onClick="return confirm('Mark Article as Top Story');"></cfif><cfset x=0>
<cfloop index="z" from="1" to="#getcoldata.recordcount#" step="1">
<cfif #getcoldata.catid[z]# eq '7'>
<cfset x=x+1>
</cfif>
</cfloop>
<cfif x eq 1>
Yes
<cfelse>
No</cfif></a></td>
</cfif>

 <Cfif #url.mag# eq '1'>
<td style="padding:5px;" ><center><cfif #getuser.accesslevel# gte 100><a href="changeitem.cfm?id=#id#&siteid=#siteid#&mag=#url.mag#&catid=17" class="ca"  onClick="return confirm('Mark Article as Top Story 2');"></cfif><cfset x=0>
<cfloop index="z" from="1" to="#getcoldata.recordcount#" step="1">
<cfif #getcoldata.catid[z]# eq '17'>
<cfset x=x+1>
</cfif>
</cfloop>
<cfif x eq 1>
Yes
<cfelse>
No</cfif></a></td>
</cfif>

 <Cfif #url.mag# eq '1'>
<td style="padding:5px;" ><center><cfif #getuser.accesslevel# gte 100><a href="changeitem.cfm?id=#id#&siteid=#siteid#&mag=#url.mag#&catid=18" class="ca"  onClick="return confirm('Mark Article as Top Story 3');"></cfif><cfset x=0>
<cfloop index="z" from="1" to="#getcoldata.recordcount#" step="1">
<cfif #getcoldata.catid[z]# eq '18'>
<cfset x=x+1>
</cfif>
</cfloop>
<cfif x eq 1>
Yes
<cfelse>
No</cfif></a></td>
</cfif>



<Cfif #url.mag# eq '2'>
<td style="padding:5px;" ><center><cfif #getuser.accesslevel# gte 100><a href="changeitem.cfm?id=#id#&siteid=#siteid#&mag=#url.mag#&catid=8" class="ca"   onClick="return confirm('Mark Article as Top Story');"></cfif><cfset x=0>
<cfloop index="z" from="1" to="#getcoldata.recordcount#" step="1">
<cfif #getcoldata.catid[z]# eq '8'>
<cfset x=x+1>
</cfif>
</cfloop>
<cfif x eq 1>
Yes
<cfelse>
No</cfif></a></td>


<td style="padding:5px;" ><center><cfif #getuser.accesslevel# gte 100><a href="changeitem.cfm?id=#id#&siteid=#siteid#&mag=#url.mag#&catid=9" class="ca"   onClick="return confirm('Mark Article as Top Story');"></cfif><cfset x=0>
<cfloop index="z" from="1" to="#getcoldata.recordcount#" step="1">
<cfif #getcoldata.catid[z]# eq '9'>
<cfset x=x+1>
</cfif>
</cfloop>
<cfif x eq 1>
Yes
<cfelse>
No</cfif></a></td>


<td style="padding:5px;" ><center><cfif #getuser.accesslevel# gte 100><a href="changeitem.cfm?id=#id#&siteid=#siteid#&mag=#url.mag#&catid=14" class="ca"   onClick="return confirm('Mark Article as Top Story');"></cfif><cfset x=0>
<cfloop index="z" from="1" to="#getcoldata.recordcount#" step="1">
<cfif #getcoldata.catid[z]# eq '14'>
<cfset x=x+1>
</cfif>
</cfloop>
<cfif x eq 1>
Yes
<cfelse>
No</cfif></a></td></cfif>


<td style="padding:5px;" ><center>
<a href="changemainstatus.cfm?id=#id#&mag=#url.mag#<cfif parameterexists(url.topr)>&topr=#url.topr#</cfif>" class="ca" >
<cfif #homepage# eq '0' or #homepage# eq '3'>No</cfif><cfif #homepage# eq '1'>Yes</cfif></a></TD>


<td style="padding:5px;" ><center>
<a href="changemainregstatus.cfm?id=#id#&mag=#url.mag#<cfif parameterexists(url.topr)>&topr=#url.topr#</cfif>" class="ca" >
<cfif #MainPageWETW# eq '0' or #MainPageWETW# eq '3'>No</cfif><cfif #MainPageWETW# eq '1'>Yes</cfif></a></TD>


</cfif>
--->

<td style="padding:5px;" >
<center><Font face=verdana size=-1>
<cfif #url.mag# eq '5'>
<a href="nympemail.cfm?id=#id#">
<Cfelseif #Url.mag# eq '15'>
<a href="nylemail.cfm?id=#id#">

<cfelse>
<a href="cgemail.cfm?id=#id#">
</cfif>
Email Article</a></td>


</tr>
</cfif>
</Cfif>
</cfoutput>
</TABLE></td></tr></table>

<p>
<font face=verdana size=-1>


<cfif #getcol.recordcount# eq 125><cfoutput>
<strong><div align="right"><strong><a href="columnadmin.cfm?topr=#getcol.id[125]#&mag=#url.mag#<Cfif parameterexists(url.directories) or parameterexists(form.directories)>&directories=on</cfif><Cfif parameterexists(form.author)>&author=#form.author#</cfif><Cfif parameterexists(form.category)>&category=#form.category#</cfif>">Next Page...</a></strong></div></strong>
</cfoutput></cfif>
</font>

<cfelse><font face=verdana size=-1>
<br>
<center>
You must be logged in.

</cfif>


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

<cfinclude template="footer.cfm">