| Server IP : 172.67.201.108 / Your IP : 216.73.216.11 Web Server : Apache/2.4.68 (Amazon Linux) OpenSSL/3.5.5 System : Linux ip-172-31-69-123.ec2.internal 6.1.176-223.369.amzn2023.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Jul 24 13:34:27 UTC 2026 x86_64 User : ec2-user ( 1000) PHP Version : 8.4.23 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /home/home2/cgny/nympadmin/ |
Upload File : |
<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:220px;">
<cfparam name="url.general" default="off">
<cfparam name="url.topr" default="999999">
<cfparam name="url.mag" default="1">
<CFSET CurrentDateTime = #CreateODBCDateTime(Now())#><cfif session.email eq ''><cfset Session.email = -1></cfif><cfif IsDefined("Cookie.email")><cfset Session.email = Cookie.email></cfif>
<cfif parameterexists(getuser.accesslevel) and parameterexists(getuser.id) and parameterexists(Session.email) and (Session.email IS NOT -1)>
<Cfif not parameterexists(url.id) or not isnumeric(url.id)>
<Cfabort></Cfif>
<cfif DirectoryExists('/home/home2/cgny/public_html/uploads2/#url.id#')>
<cfelse>
<cfdirectory action = "create" directory = "/home/home2/cgny/public_html/uploads2/#url.id#" mode="777" >
</cfif>
<cfquery name = "getcoldata" datasource ="cityguide">
select *
from columntable
where id = #url.id#
</cfquery>
<Cfset #url.mag# = #getcoldata.mag#>
<Cfquery name="getdates" dataSource="#ds#">
select columntableimages.startdate,enddate,redir
from columntableimages where colid = #url.id#
</cfquery>
<Cfif #getdates.recordcount# eq 0>
<cfquery name="in" datasource="#ds#">
insert into columntableimages(colid,imageurl,imageheadline,imagecaption)
values (#url.id#,'','','')
</cfquery>
<Cfquery name="getdates" dataSource="#ds#">
select columntableimages.startdate,enddate,redir
from columntableimages where colid = #url.id#
</cfquery>
</Cfif>
<cfquery name = "getcoldata2" datasource ="cityguide">
select id,authorname
from columnmaster
where id = #getcoldata.columnnum#
order by authorname
</cfquery>
<cfquery name = "getcoldata3" datasource ="cityguide">
select id,authorname
from columnmaster
where mag = 5
order by authorname
</cfquery>
<cfquery name = "getcoldatanum2" datasource ="cityguide">
select id,authorname
from columnmaster
where id = #getcoldata.columnnum2#
order by authorname
</cfquery>
<cfquery name = "getcoldatanum3" datasource ="cityguide">
select id,authorname
from columnmaster
where id = #getcoldata.columnnum3#
order by authorname
</cfquery>
<cfquery name = "getcoldatanum4" datasource ="cityguide">
select id,authorname
from columnmaster
where id = #getcoldata.columnnum4#
order by authorname
</cfquery>
<table border=0 width=100% cellpadding=8 cellspacing=0>
<tr><td style="padding:5px;" valign=top>
<font face=verdana size=-1>
<cfoutput><cfif #url.mag# eq 5>
<cfif #getcoldata.seo_friendly# is not ''>
<a href="https://www.nymetroparents.com/article/#getcoldata.seo_friendly#" target="_new">Preview Column</a>
<cfelse>
<a href="https://www.nymetroparents.com/2011va.cfm?colid=#url.id#" target="_new">Preview Column</a></cfif></cfif>
</font></cfoutput> <!---|
<cfoutput>
<FORM action="duplicatearticle.cfm?id=#url.id#" method="post" style="margin-bottom:0; display: inline;padding:0; border:0; margin:0" ><font face=verdana size=-1>
Duplicate Article <select name="repeat">
<Cfloop from="1" to ="10" index="i">
<option value="#i#">#i#</option>
</Cfloop>
</select>
<input type="submit" value="Dupe">
</FORM>
</cfoutput> --->
<cfoutput><FORM action="editcol23335.cfm?mag=#url.mag#&general=#url.general#&topr=#url.topr#" method=post></cfoutput>
<cfif parameterexists(url.general) and #url.general# eq 'on'>
<input name="general" type="hidden" value="123" />
</cfif>
<Table width=98%><tr><td style="padding:5px;" width=70% valign=top>
<table cellspacing=5 cellpadding=5 border=0 width=95%>
<cfif parameterexists(getuser.accesslevel) and #getuser.accesslevel# eq 100>
<input name="mag" type="hidden" value="5">
<tr>
<td style="padding:5px;" colspan=2>
<b><font SIZE="-1" FACE="verdana">Author:</font></b>
<select NAME="ColID" size="1">
<Cfoutput query="getcoldata2"><option value="#id#">#authorname#</option></CFOUTPUT>
<Cfoutput query="getcoldata3"><option value="#id#">#authorname#</option></CFOUTPUT>
</select><cfoutput>
<br />Posted by #getcoldata.postedby#</cfoutput>
</td>
</tr>
<tr>
<td style="padding:5px;" colspan=2>
<b><font SIZE="-1" FACE="verdana">Author 2:</font></b>
<select NAME="columnnum2" size="1">
<cfif getcoldata.columnnum2 eq 0>
<option value="0" selected>None</option>
</cfif>
<Cfoutput query="getcoldatanum2"><option value="#id#">#authorname#</option></CFOUTPUT>
<Cfoutput query="getcoldata3"><option value="#id#">#authorname#</option></CFOUTPUT>
<option value="0">None</option>
</select>
</td>
</tr>
<tr>
<td style="padding:5px;" colspan=2>
<b><font SIZE="-1" FACE="verdana">Author 3:</font></b>
<select NAME="columnnum3" size="1">
<cfif getcoldata.columnnum3 eq 0>
<option value="0" selected>None</option>
</cfif>
<Cfoutput query="getcoldatanum3"><option value="#id#">#authorname#</option></CFOUTPUT>
<Cfoutput query="getcoldata3"><option value="#id#">#authorname#</option></CFOUTPUT>
<option value="0">None</option>
</select>
</td>
</tr>
<tr>
<td style="padding:5px;" colspan=2>
<b><font SIZE="-1" FACE="verdana">Author 4:</font></b>
<select NAME="columnnum4" size="1">
<cfif getcoldata.columnnum4 eq 0>
<option value="0" selected>None</option>
</cfif>
<Cfoutput query="getcoldatanum4"><option value="#id#">#authorname#</option></CFOUTPUT>
<Cfoutput query="getcoldata3"><option value="#id#">#authorname#</option></CFOUTPUT>
<option value="0">None</option>
</select>
</td>
</tr>
<TR>
<td style="padding:5px;" width=40% valign="top"><font face=verdana size=-1> <b> Optional Region: </TD>
<td style="padding:5px;">
<cfoutput>
<font face=verdana size=-2>
<input name="region" type="checkbox" value="Manhattan" <cfif #getcoldata.region# contains 'Manhattan'>checked</cfif>> Manhattan
<input name="region" type="checkbox" value="Brooklyn"<cfif #getcoldata.region# contains 'Brooklyn'>checked</cfif>> Brooklyn
<input name="region" type="checkbox" value="Queens" <cfif #getcoldata.region# contains 'Queens'>checked</cfif>> Queens
<input name="region" type="checkbox" value="Westchester" <cfif #getcoldata.region# contains 'Westchester'>checked</cfif>> Westchester
<input name="region" type="checkbox" value="Rockland" <cfif #getcoldata.region# contains 'Rockland'>checked</cfif>> Rockland
<input name="region" type="checkbox" value="Bronx" <cfif #getcoldata.region# contains 'Bronx'>checked</cfif>> Bronx
<input name="region" type="checkbox" value="Staten Island" <cfif #getcoldata.region# contains 'Staten Island'>checked</cfif>> Staten Island
<input name="region" type="checkbox" value="Essex" <cfif #getcoldata.region# contains 'Essex'>checked</cfif>> Essex<br />
<input name="region" type="checkbox" value="Nassau" <cfif #getcoldata.region# contains 'Nassau'>checked</cfif>> Nassau
<input name="region" type="checkbox" value="Fairfield" <cfif #getcoldata.region# contains 'Fairfield'>checked</cfif>> Fairfield
<input name="region" type="checkbox" value="Suffolk" <cfif #getcoldata.region# contains 'Suffolk'>checked</cfif>> Suffolk
<input name="region" type="checkbox" value="Bergen" <cfif #getcoldata.region# contains 'Bergen'>checked</cfif>> Bergen
</cfoutput>
</TD></TR>
<TR>
<td style="padding:5px;" width=25% valign="top"><font face=verdana size=-1> <b> Show More by Author: </TD>
<td style="padding:5px;">
<cfoutput>
<select NAME="displaymore" size="1">
<option value="#Getcoldata.displaymore#">#getcoldata.displaymore#</option>
<cfif #getcoldata.displaymore# eq 'Yes'>
<option value="No">No</option>
<cfelse>
<option value="Yes">Yes</option>
</cfif>
</select>
</cfoutput>
</TD></TR>
<TR>
<td style="padding:5px;" width=25% valign="top"><font face=verdana size=-1> <b> Show Newsletter Ad: </TD>
<td style="padding:5px;">
<cfoutput>
<select NAME="showad" size="1">
<cfif #getcoldata.showad# eq 0>
<option value="0">No</option>
<option value="1">Yes</option>
<option value="3">Bottom</option>
<cfelseif #getcoldata.showad# eq 3>
<option value="3">Bottom</option>
<option value="0">No</option>
<option value="1">Yes</option>
<cfelse>
<option value="1">Yes</option>
<option value="0">No</option>
<option value="3">Bottom</option>
</cfif>
</select>
</cfoutput>
</TD></TR>
</cfif>
<TR>
<td style="padding:5px;" width=25% valign="top"><font face=verdana size=-1> <b> Show Hero Image: </TD>
<td style="padding:5px;">
<cfoutput>
<select NAME="showhero" size="1">
<cfif #getcoldata.showhero# eq 0>
<option value="0">Yes</option>
<option value="1">No</option>
<cfelse>
<option value="1">No</option>
<option value="0">Yes</option>
</cfif>
</select>
</cfoutput>
</TD></TR>
<cfoutput query="Getcoldata">
<input NAME="id" value="#getcoldata.id#" type="hidden">
<tr>
<td style="padding:5px;" >
<b><font SIZE="-1" FACE="verdana">Title:</font></b> <small>(#len(getcoldata.title)# Chars)</small>
<cfset TValue = Evaluate("getcoldata.title")>
<cfset TValue = rereplace(TValue, '"','''', "ALL")>
</td><td>
<input NAME="title" SIZE="70" value="#tvalue#">
<input TYPE ="hidden" NAME="Title_required" VALUE="You must enter a title!">
</td>
</tr>
<tr>
<td style="padding:5px;">
<b><font SIZE="-1" FACE="verdana">Page Title:</font></b> <small>(#len(getcoldata.seo_title)# Chars)</small>
<cfset TValue = Evaluate("getcoldata.seo_title")>
<cfset TValue = rereplace(TValue, '"','''', "ALL")>
</td><td>
<input NAME="seo_title" SIZE="70" value="#tvalue#">
</td>
</tr>
<tr>
<td style="padding:5px;">
<b><font SIZE="-1" FACE="verdana">Short <cfif url.mag eq 1 or #url.mag# eq ''>Meta Description<cfelse>Title</cfif>:</font></b> <small>(#len(getcoldata.shorttitle)# Chars)</small>
<cfset TValue = Evaluate("getcoldata.shorttitle")>
<cfset TValue = rereplace(TValue, '"','''', "ALL")>
</td><td>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.3/jquery.min.js"></script>
<textarea id="textarea" name="shorttitle" style="font-family:Verdana, Geneva, sans-serif;font-size:11px;width:560px;height:25px;padding: 5px 5px;" placeholder="Short Headline" maxlength="70">#tvalue#</textarea>
<font face="verdana" size="-2"><div id="textarea_feedback"></div></font>
<script type="text/javascript">
$(document).ready(function() {
var text_max = 70;
$('##textarea_feedback').html(text_max + ' characters remaining');
$('##textarea').keyup(function() {
var text_length = $('##textarea').val().length;
var text_remaining = text_max - text_length;
$('##textarea_feedback').html(text_remaining + ' characters remaining');
});
});
</script>
</td>
</tr>
<tr>
<td style="padding:5px;" >
<b><font SIZE="-1" FACE="verdana">Sharing Title:</font></b> <small>(#len(getcoldata.sharing_title)# Chars)</small>
<cfset TValue = Evaluate("getcoldata.sharing_title")>
<cfset TValue = rereplace(TValue, '"','''', "ALL")>
</td><td>
<input NAME="sharing_title" SIZE="70" value="#tvalue#">
</td>
</tr>
<!---
<tr>
<td style="padding:5px;" ><Cfoutput>
<b><font SIZE="-1" FACE="verdana">Keywords:</font></b></td><td>
<input NAME="Keywords" SIZE="113" value="#keywords#" style="font-size: 10px;"></Cfoutput>
</td>
</tr>
--->
<tr>
<td style="padding:5px;"><Cfoutput>
<b><font SIZE="-1" FACE="verdana">Canonical Link:</font></b></td><td>
<input NAME="canlink" SIZE="70" value="#canlink#"></Cfoutput>
</td>
</tr>
<tr>
<td style="padding:5px;"><Cfoutput>
<b><font SIZE="-1" FACE="verdana">Redirect Link:</font></b></td><td>
<input NAME="redir" SIZE="70" value="#getdates.redir#"></Cfoutput>
</td>
</tr>
<tr>
<td style="padding:5px;" ><Cfoutput>
<b><font SIZE="-1" FACE="verdana">Sub-Title:</font></b></td><td>
<input NAME="shortblurb" SIZE="70" value="#shortblurb#"></Cfoutput>
</td>
</tr>
<tr>
<td style="padding:5px;" colspan=2 align="left" valign="top">
<b><font SIZE="-1" FACE="verdana" ><b>Blurb:</b> Size - #len(blurb)#
</font><br>
<Cfif #url.general# eq 'on'>
<font face=verdana color=red size=-1>Editing a General Page, to Edit Blurb Field use Edit Blurb Link up top. Updates made here will be ignored</font><br />
</Cfif>
<textarea name="blurb" cols="65" rows="3" wrap="VIRTUAL">#getcoldata.blurb#</textarea>
</cfoutput>
<style type="text/css">
a.ca{font-family : verdana;
font-size : 9pt;}
.ca{font-family : verdana;
font-size : 9pt;}
a.ca:hover{font-family : verdana;
font-size : 9pt;}
.regularw{font-family : verdana;
font-size : 8pt;
color : ffffff;
font-weight : bold;
text-decoration : none;}
</style>
<cfquery name="getcol" datasource="#ds#">
SELECT columnmaster.member,columnmaster.showviews,columnmaster.AuthorName,columntable.replies, columnmaster.Title, columntable.id, columntable.MainPage, columntable.DatePosted, columntable.Status, columntable.Title as coltitle, columntable.review,columntable.MainPagewetw, columntable.general,columntable.interview,columntable.photoop,columntable.datesubmitted, columntable.columnnum,lastedit, columnmaster.smallpicture,columntable.offbeat,columntable.concert,columntable.views,columntable.concert,columntable.uconcert
FROM columntable INNER JOIN columnmaster ON columntable.ColumnNum = columnmaster.ID
where columntable.id = #Url.id#
order by columntable.datesubmitted desc
limit 0,50
</cfquery>
<Table width=100% cellspacing=4 cellpadding=2>
<cfset counter=0>
<cfoutput query="getcol">
<cfif #counter# eq 0 or #counter# eq 15 or #counter# eq 30>
<tr bgcolor=black>
<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><center>REP.</TD>
<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<br />APPROVED</TD>
<Cfif #url.mag# eq '5'><td style="padding:5px;"><center><span class="regularw"><B>UPDATED</TD></cfif>
<cfif parameterexists(getuser.accesslevel) and #getuser.accesslevel# eq 100>
<Cfif #url.mag# eq '1'><td style="padding:5px;"><center><span class="regularw"><B>TOP CG</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>TOP</TD></cfif>
<Cfif #url.mag# eq '5'><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'))#">
<cfif #getcol.showviews# eq '0' or #getuser.accesslevel# eq 100>
<td style="padding:5px;"><center>
<cfif parameterexists(getuser.accesslevel) and #getuser.accesslevel# eq 100><a href="/admin/editviews.cfm?id=#getcol.id#" class="ca"></cfif>
<cfif url.mag eq 5>
<cfset zz = #getcol.views# * 1.2>
<cfelse>
<cfset zz = #getcol.views# * 1.0>
</cfif>
#round(zz)#</TD>
</TD>
</cfif>
<td style="padding:5px;"><span class="ca"><center>#getcol.replies#</span></TD>
<td style="padding:5px;"><center>
<cfif parameterexists(getuser.accesslevel) and (#getuser.accesslevel# gte 100 or #getuser.id# eq 1751) and parameterexists(getuser.id)>
<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'>pending</cfif><cfif #status# eq '1'>live</cfif></a></TD>
<td style="padding:5px;"><center>
<cfif parameterexists(getuser.accesslevel) and (#getuser.accesslevel# gte 100 or #getuser.id# eq 1751) and parameterexists(getuser.id)>
<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 parameterexists(getuser.accesslevel) and #getuser.accesslevel# gte 100><a href="changeitem.cfm?id=#id#&siteid=#siteid#&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 parameterexists(getuser.accesslevel) and #getuser.accesslevel# gte 100><a href="changeitem.cfm?id=#id#&siteid=#siteid#&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 parameterexists(getuser.accesslevel) and #getuser.accesslevel# gte 100><a href="changeitem.cfm?id=#id#&siteid=#siteid#&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 parameterexists(getuser.accesslevel) and #getuser.accesslevel# gte 100><a href="changeitem.cfm?id=#id#&siteid=#siteid#&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')#<br>
<strong><cfif dateposted eq ''>pending<cfelse>#DateFormat(dateposted,"m/d/yy")# #TimeFormat(dateposted, 'h:mm')# </cfif></td>
<td style="padding:5px;">
<font face=verdana size=-2><center><A href="editlast.cfm?id=#url.id#">#DateFormat(lastedit,"m/d/yy")#</A>
</td>
<cfif parameterexists(getuser.accesslevel) and #getuser.accesslevel# gte 100>
<Cfif #url.mag# eq '1'>
<td style="padding:5px;"><center><cfif parameterexists(getuser.accesslevel) and #getuser.accesslevel# gte 100><a href="changeitem.cfm?id=#id#&siteid=#siteid#&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 '2'>
<td style="padding:5px;"><center><cfif parameterexists(getuser.accesslevel) and #getuser.accesslevel# gte 100><a href="changeitem.cfm?id=#id#&siteid=#siteid#&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 parameterexists(getuser.accesslevel) and #getuser.accesslevel# gte 100><a href="changeitem.cfm?id=#id#&siteid=#siteid#&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 parameterexists(getuser.accesslevel) and #getuser.accesslevel# gte 100><a href="changeitem.cfm?id=#id#&siteid=#siteid#&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>
<Cfif #url.mag# eq '5'>
<td style="padding:5px;"><center><cfif parameterexists(getuser.accesslevel) and #getuser.accesslevel# gte 100><a href="changeitem.cfm?id=#id#&siteid=#siteid#&catid=15" 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 '15'>
<cfset x=x+1>
</cfif>
</cfloop>
<cfif x eq 1>
Yes
<cfelse>
No</cfif></a></td></cfif>
</cfif>
<cfquery name = "getcoldata" datasource ="cityguide">
select *
from columntable
where id = #url.id#
</cfquery>
<Cfif #url.mag# eq '5'>
<td style="padding:5px;"><center>
<a href="changemainregstatus.cfm?id=#url.id#&mag=5<cfif parameterexists(url.topr)>&topr=#url.topr#</cfif>" class="ca" >
<cfif #getcoldata.MainPageWETW# eq '0' or #getcoldata.MainPageWETW# eq '3'>NO</cfif><cfif #getcoldata.MainPageWETW# eq '1'>YES</cfif></a></TD>
</cfif>
</tr>
</cfoutput>
</TABLE></td></tr></table>
</td>
</tr>
</table>
</td>
<td style="padding:5px;" width=30% valign=top>
<cfoutput>
<font face=verdana size=-1>
<a href="editurl.cfm?id=#url.id#" onClick="return confirm('Really edit article URL');"><b>Change URL</b></a>
|
<a href="deletearticle.cfm?id=#url.id#&mag=#url.mag#" onClick="return confirm('Delete this article?');"><strong>Delete Article</strong></a>
</cfoutput>
<p><Br>
<font face=verdana size=-1> <b> Category Picker:
</b>
<br>
<cfif #url.mag# eq '2'>
<cfset #url.mag# = 1>
</cfif>
<Cfif #url.mag# eq 1 or #url.mag# eq 15>
<Cfquery name="Getregions" datasource="#ds#">
SELECT *
FROM regions
where siteid = #url.mag# and name <> ''
order by name
</CFQUERY>
<cfquery name="Getarticleregions" datasource="#ds#">
select *
from regionstable
where colid = #url.id#
</cfquery>
<select name="regions" multiple size="20">
<Cfoutput query="getregions">
<Cfset ab = 'on'>
<cfloop from="1" to="#Getarticleregions.recordcount#" index="i">
<cfif #Getarticleregions.regionsid[i]# eq #getregions.id#>
<Cfset ab = 'off'>
<option value="#getregions.id#" selected>#getregions.name#</option>
<cfelse>
</cfif>
</cfloop>
<Cfif parameterexists(ab) and #ab# eq 'on'>
<option value="#getregions.id#">#getregions.name#</option>
</CFIF>
</CFOUTPUT>
</select>
<br>
</cfif>
<cfif #Url.mag# eq '5'>
<br>
<Cfquery name="Getregions" datasource="#ds#">
SELECT *
FROM regions
where siteid = #url.mag# and id > 234
order by mastercat,name
</CFQUERY>
<cfquery name="Getarticleregions" datasource="#ds#">
select *
from regionstable
where colid = #url.id#
</cfquery>
<select name="regions2" multiple size="20">
<Cfoutput query="getregions">
<Cfset ab = 'on'>
<cfloop from="1" to="#Getarticleregions.recordcount#" index="i">
<cfif #Getarticleregions.regionsid[i]# eq #getregions.id#>
<Cfset ab = 'off'>
<option value="#getregions.id#" selected>#getregions.mastercat#: #getregions.name#</option>
<cfelse>
</cfif>
</cfloop>
<Cfif parameterexists(ab) and #ab# eq 'on'>
<option value="#getregions.id#">#getregions.mastercat#: #getregions.name#</option>
</CFIF>
</CFOUTPUT>
</select>
<br>
</cfif>
<Cfif parameterexists(getuser.id) and #getuser.id# eq 2>
<cfoutput>
<p>
<font face=verdana size=-1>
<a href="duplicatearticle.cfm?id=#url.id#" onClick="return confirm('Duplicate this article?');"><strong>Duplicate Article</strong></a>
</font></div>
</cfoutput>
</CFIF>
</TD>
</tr></TABLE>
<cfoutput query="Getcoldata">
<table cellspacing=5 cellpadding=5 border=0 width=100%>
<cfif #getcoldata.title# eq 'Top1' or #getcoldata.title# eq 'Top2' or #getcoldata.title# eq 'Top3'>
<input TYPE ="hidden" NAME="newform" VALUE="#getcoldata.blurb#">
<tr><td style="padding:5px;" colspan=2>
<textarea id="editor" name="blurb" style="width:100%;border:1" rows="20" cols="80">
</textarea>
</td></tr>
<cfelse>
<tr><td style="padding-left:1px;" colspan=2>
<cfcookie name = "folderme"
value = "#Now()#"
expires = "NOW">
<cfcookie name = "folderme" value = "/uploads2/#url.id#/">
<Cfparam name="url.beta" default="on">
<Cfset coltext =
#rereplace(getcoldata.copy,'https://www.cityguideny.com/columnpic2/','https://www.nymetroparents.com/columnpic2/')#>
<Cfset coltext =
#rereplace(coltext,'https://www.cityguideny.com/uploads2/','https://www.nymetroparents.com/uploads2/')#>
<script src="ckeditor46z27e/ckeditor.js" charset="utf-8"></script>
<script type="text/javascript" src="ckfinder34/ckfinder.js" charset="utf-8"></script>
<textarea id="myarea12" class="ckeditor" name="copyedit" style="height:600px;">#htmlEditFormat(coltext)#</textarea>
<script type="text/javascript">
CKEDITOR.on( 'dialogDefinition', function( ev ) {
// Take the dialog name and its definition from the event data.
var dialogName = ev.data.name;
var dialogDefinition = ev.data.definition;
// Check if the definition is from the dialog we're interested on (the "Link" dialog).
if ( dialogName == 'link' ){
var targetTab = dialogDefinition.getContents( 'target' );
var targetDropdown = targetTab.get( 'linkTargetType' );
targetDropdown.default = '_blank';
}
} );
CKFinder.setupCKEditor( editor, 'ckfinder34/' ) ;
var editor = CKEDITOR.replace( 'myarea12',{
height: '500px',
extraAllowedContent : 'object(*);param(*);embed(*);p(*);script(*);form(*);input(*);div(*);blockquote(*)'
});
editor.on( 'instanceReady', function() {
console.log( editor.filter.allowedContent );
} );
</script>
</td></tr>
</cfif>
<tr>
<td style="padding:5px;" colspan=2>
<b><font SIZE="-1" FACE="verdana">NYMP Main Page Featured Photo 630x415:</font></b>
<input NAME="mainswapnymp" SIZE="70" value="#rereplace(getcoldata.mainswapnymp,'https://www.cityguideny.com/columnpic2/','https://www.nymetroparents.com/columnpic2/')#"><br>
</td>
</tr>
<tr>
<td style="padding:5px;" colspan=2>
<b><font SIZE="-1" FACE="verdana">NYMP NEW Main Page Featured Photo 1640x564:</font></b>
<input NAME="MainSwapbig" SIZE="70" value="#rereplace(getcoldata.MainSwapbig,'https://www.cityguideny.com/columnpic2/','https://www.nymetroparents.com/columnpic2/')#"><br>
</td>
</tr>
<tr>
<td style="padding:5px;" colspan=2>
<b><font SIZE="-1" FACE="verdana">Check this box to NOT update the
date:</font></b>
<input NAME="skipupdate" type="checkbox"><br>
</td>
</tr>
</table>
<center><b><input type="submit" Value="Update Column and Return to Admin" name="buttadmin"><input type="submit" Value="Update Column and Return to Article" name="buttarticle">
<cfif #url.mag# eq 5><input type="submit" Value="Update Column and View Article" name="buttarticlepreview"></cfif>
</b>
<br>
</form>
</form>
<p><br>
<a name="images">
<table width=600 bgcolor=efefef cellpadding=4 cellspacing=0 border=1 bordercolor=black><tr><td style="padding:5px;">
<font face=verdana size=-1><strong>Images for this Column:</strong>
<p>
Upload image files to use in your column... Set the image width below to 300 to use it in your text, or to 75 if it's to be used on the main page. After uploading, just copy paste the 'image' link below, hit the photo button above and paste in to add it to your story.
<p>
</font><form name="form2" action="editcolpic.cfm?id=#url.id#&mag=#Url.mag#" method=post enctype="multipart/form-data">
<table>
<tr><td style="padding:5px;" valign=top><font face=verdana size=-1><strong>Image to Upload:</strong> </font></td><td style="padding:5px;"><input type=file name=photo><input TYPE="hidden" NAME="photo_required" VALUE="Please press browse to select a photo to upload.">
</td></tr>
<input type=hidden name=checker>
<input type=hidden name=maxsize value="">
<tr><td style="padding:5px;">
<font face=verdana size=-1>
<strong>Desired Image Width:</strong>
</td>
<td style="padding:5px;">
<input name=thumbsize value="150" size="5">
<font face=verdana size=-1>
<strong>Desired Image Height:</strong><input name=height value="0" size="5">
<input type=submit name=submit value="Upload">
</td>
</tr>
<input type=hidden name=prefix value="#url.id#">
</table>
<p>
</form>
<p>
</cfoutput>
<cfquery name="getpics" datasource="cityguide">
select *
from columnpic
where colid = #url.id#
</cfquery>
<table width=100% border=1 cellpadding=4 cellspacing=0 bordercolor=black>
<tr>
<td style="padding:5px;"><font face=verdana size=-1><strong>Size</strong></td>
<td style="padding:5px;"><font face=verdana size=-1><strong>Resized Image</strong></td>
<td style="padding:5px;"><font face=verdana size=-1><strong>Original Image</strong></td>
</tr>
<cfoutput query="getpics">
<tr>
<td style="padding:5px;"><center><font face=verdana size=-1>#size#</center></td>
<td style="padding:5px;">
<FORM action="updatecolpic.cfm?photo=#photo#&colid=#url.id#&mag=#url.mag#" method=post>
<cfif id gt 20469>
<font face=verdana size=-2><a href="https://www.nymetroparents.com/columnpic2/#photo#" target="#id#">https://www.nymetroparents.com/columnpic2/#photo#</a>
<input type="submit" Value="Use 150" name="use150">
</form>
</td>
<td style="padding:5px;">
<FORM action="updatecolpic.cfm?photo=#bigphoto#&colid=#url.id#&mag=#url.mag#" method=post>
<font face=verdana size=-2><a href="https://www.nymetroparents.com/columnpic2/#bigphoto#" target="#id#">https://www.nymetroparents.com/columnpic2/#bigphoto#</a>
<input type="submit" Value="Use 150" name="use150">
</form>
</td>
<cfelse>
<font face=verdana size=-2><a href="https://www.cityguideny.com/columnpic/#photo#" target="#id#">https://www.cityguideny.com/columnpic/#photo#</a>
<input type="submit" Value="Use 150" name="use150">
</form>
</td>
<td style="padding:5px;">
<FORM action="updatecolpic.cfm?photo=#bigphoto#&colid=#url.id#&mag=#url.mag#" method=post>
<font face=verdana size=-2><a href="https://www.cityguideny.com/columnpic/#bigphoto#" target="#id#">https://www.cityguideny.com/columnpic/#bigphoto#</a>
<input type="submit" Value="Use 150" name="use150">
</form>
</td>
</cfif>
</tr>
</cfoutput>
</table>
</td></tr></table>
<Br><Br>
<Cfoutput>
<a href="viewhistory.cfm?id=#url.id#&type=column">View History</a>
</Cfoutput>
</div>
</td></tr></table>
</cfif>