| Server IP : 172.67.201.108 / Your IP : 216.73.216.68 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/public_html/newadmin/ |
Upload File : |
<cfparam name="url.general" default="off">
<cfparam name="url.topr" default="999999">
<cfcontent type="text/html;charset=utf-8">
<cfprocessingDirective pageencoding="utf-8">
<cfset setEncoding("Form", "utf-8")>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<link rel="stylesheet" type="text/css" href="/bwwstyles1.css" media="all">
<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>
<cfinclude template="header.cfm">
<div id="content">
<div id="content-header">
<h2> Edit Article</h2>
</div>
<div class="container-fluid" style="margin-left:220px;">
<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 ="cg22">
select *
from columntable
where id = #url.id#
</cfquery>
<Cfset #url.mag# = #getcoldata.mag#>
<Cfquery name="getdates" dataSource="#ds#">
select columntableimages.startdate,enddate,redir,imageurl,imageheadline,imagecaption,imageurlbig
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,imageurl,imageheadline,imagecaption,imageurlbig
from columntableimages where colid = #url.id#
</cfquery>
</Cfif>
<cfquery name = "getcoldata2" datasource ="cg22">
select id,authorname
from columnmaster
where id = #getcoldata.columnnum#
order by authorname
</cfquery>
<cfquery name = "getcoldata3" datasource ="cg22">
select id,authorname
from columnmaster
order by authorname
</cfquery>
<table border=0 width=100% cellpadding=8 cellspacing=0>
<tr><Td style="padding:5px;" valign=top> <font color=black><Cfif parameterexists(url.new)>EDITING NEW COLUMN</Cfif></span></strong><br>
<cfoutput><table width=100% cellspacing=0 cellpadding=0 bgcolor=#color#><tr><td></td></tr></table>
</cfoutput>
<font face=verdana size=-1>
<cfoutput>
<font face=verdana size=-2>
<FORM action="duplicatearticle.cfm?id=#url.id#" method="post" style="margin-bottom:0; display: inline;padding:0; border:0; margin:0" >
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>
<br>
<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%>
<input name="mag" type="hidden" value="1">
<cfif parameterexists(getuser.accesslevel) and #getuser.accesslevel# eq 100>
<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>
<input name="displayfeedback" type="hidden" value="#Getcoldata.displayfeedback#">
<TR>
<Td style="padding:5px;" width=25% valign="top"><font face=verdana size=-1> <b> Show Email Promo: </TD>
<TD>
<cfoutput>
<select NAME="showad" size="1">
<cfif #getcoldata.showad# eq '1'>
<option value="1">Mid-Article</option>
<option value="0">Bottom</option>
<option value="2">NONE</option>
<cfelseif #getcoldata.showad# eq '2'> <option value="2">NONE</option>
<option value="1">Mid-Article</option>
<option value="0">Bottom</option>
<cfelse>
<option value="0">Bottom</option>
<option value="1">Mid-Article</option>
<option value="2">NONE</option>
</cfif>
</select>
</cfoutput>
</TD></TR>
<TR>
<Td style="padding:5px;" width=25% valign="top"><font face=verdana size=-1> <b> Show Intentions Widget: </TD>
<TD>
<cfoutput>
<select NAME="showwidget" size="1">
<cfif #getcoldata.showwidget# eq '1'>
<option value="1">Yes</option>
<option value="0">No</option>
<cfelse>
<option value="0">No</option>
<option value="1">Yes</option>
</cfif>
</select>
</cfoutput>
</TD></TR>
</cfif>
<cfoutput query="Getcoldata">
<input NAME="id" value="#getcoldata.id#" type="hidden">
<tr>
<Td style="padding:5px;" colspan=2>
<b><font SIZE="-1" FACE="verdana">Column Title:</font></b> (#len(getcoldata.title)# Chars)
<cfset TValue = Evaluate("getcoldata.title")>
<cfset TValue = rereplace(TValue, '"','''', "ALL")>
<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;" colspan=2>
<b><font SIZE="-1" FACE="verdana">SEO Title:</font></b> (#len(getcoldata.seo_title)# Chars)
<cfset TValue = Evaluate("getcoldata.seo_title")>
<cfset TValue = rereplace(TValue, '"','''', "ALL")>
<input NAME="seo_title" SIZE="70" value="#tvalue#">
</td>
</tr>
<tr>
<Td style="padding:5px;" colspan=2>
<b><font SIZE="-1" FACE="verdana">Column Short <cfif url.mag eq 1 or #url.mag# eq ''>Blurb<cfelse>Title</cfif>:</font></b> (#len(getcoldata.shorttitle)# Chars)
<cfset TValue = Evaluate("getcoldata.shorttitle")>
<cfset TValue = rereplace(TValue, '"','''', "ALL")>
<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:20px;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;" colspan=2>
<b><font SIZE="-1" FACE="verdana">Sharing Title:</font></b> (#len(getcoldata.sharing_title)# Chars)
<cfset TValue = Evaluate("getcoldata.sharing_title")>
<cfset TValue = rereplace(TValue, '"','''', "ALL")>
<input NAME="sharing_title" SIZE="70" value="#tvalue#">
</td>
</tr>
<tr>
<Td style="padding:5px;" colspan=2>
<b><font SIZE="-1" FACE="verdana">Page Title:</font></b> (#len(getcoldata.pagetitle)# Chars)
<cfset TValue = Evaluate("getcoldata.pagetitle")>
<cfset TValue = rereplace(TValue, '"','''', "ALL")>
<input NAME="pagetitle" SIZE="70" value="#tvalue#">
</td>
</tr>
<tr>
<Td style="padding:5px;" colspan=2>
<b><font SIZE="-1" FACE="verdana">Sub Title:</font></b> (#len(getcoldata.subtitle)# Chars)
<cfset TValue = Evaluate("getcoldata.subtitle")>
<cfset TValue = rereplace(TValue, '"','''', "ALL")>
<input NAME="subtitle" SIZE="70" value="#tvalue#">
</td>
</tr>
<!-- <tr>
<Td style="padding:5px;" colspan=2><Cfoutput>
<b><font SIZE="-1" FACE="verdana">Column Keywords:</font></b>
<input NAME="Keywords" SIZE="70" value="#keywords#"></Cfoutput>
</td>
</tr> --->
<tr>
<Td style="padding:5px;" colspan=2><Cfoutput>
<b><font SIZE="-1" FACE="verdana">Canonical Link:</font></b>
<input NAME="canlink" SIZE="70" value="#canlink#"></Cfoutput>
</td>
</tr>
<tr>
<Td style="padding:5px;" colspan=2><Cfoutput>
<b><font SIZE="-1" FACE="verdana">Redirect Link:</font></b>
<input NAME="redir" SIZE="70" value="#getdates.redir#"></Cfoutput>
</td>
</tr>
<Cfif #url.mag# eq 5>
<tr>
<Td style="padding:5px;" colspan=2><Cfoutput>
<b><font SIZE="-1" FACE="verdana">Sub-Title:</font></b>
<input NAME="shortblurb" SIZE="70" value="#shortblurb#"></Cfoutput>
</td>
</tr>
</Cfif>
<tr>
<Td style="padding:5px;" colspan=2 align="left" valign="top">
<b><font SIZE="-1" FACE="verdana" ><b>Blurb:</b></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><center><span class="regularw"><B><center>VIEWS</TD></cfif>
<Td><center><span class="regularw"><B><center>REP.</TD>
<Td><center><span class="regularw"><B>STATUS</TD>
<Td><center><span class="regularw"><B>MAIN</TD>
<cfif #url.mag# eq '111' or #url.mag# eq '112'>
<Td><center><span class="regularw"><B>TO DO</TD>
<Td><center><span class="regularw"><B>TO SHOP</TD>
<Td><center><span class="regularw"><B>TO DINE</TD>
<Td><center><span class="regularw"><B>R ESTATE</TD>
</cfif>
<Td><center><span class="regularw"><B>SUBMITTED<br />APPROVED</TD>
<Cfif #url.mag# eq '5'><Td><center><span class="regularw"><B>UPDATED</TD></cfif>
<cfif parameterexists(getuser.accesslevel) and #getuser.accesslevel# eq 100>
<Cfif #url.mag# eq '1'><Td><center><span class="regularw"><B>TOP CG</TD></cfif>
<Cfif #url.mag# eq '2'><Td><center><span class="regularw"><B>TOP ML</TD>
<Td><center><span class="regularw"><B>TOP ML 2</TD>
<Td><center><span class="regularw"><B>TOP ML 3</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><center>
<cfif parameterexists(getuser.accesslevel) and #getuser.accesslevel# eq 100><a href="/admin/editviews.cfm?id=#getcol.id#" class="ca"></cfif>
<cfset zz = #getcol.views# * 1.0>
#round(zz)#</TD>
</TD>
</cfif>
<Td><span class="ca"><center>#getcol.replies#</span></TD>
<Td><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><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>
<td><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>
<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><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 '22'>
<td><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>
</cfif>
</cfif>
<cfquery name = "getcoldata" datasource ="cg22">
select *
from columntable
where id = #url.id#
</cfquery>
<Cfif #url.mag# eq '51'>
<Td><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>
<font face=verdana size=-1>
<cfoutput>
<a href="editurl.cfm?id=#url.id#" onClick="return confirm('Really edit article URL');"><b>Change URL</b></a></cfoutput>
<br><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>
<cfoutput>
<p>
<font face=verdana size=-1>
<a href="deletearticle.cfm?id=#url.id#&mag=#url.mag#" onClick="return confirm('Delete this article?');"><strong>Delete Article</strong></a>
</cfoutput>
<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=95%>
<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:5px;" colspan=2>
<table border=1 cellspacing=0 cellpadding=0><tr><Td>
<cfcookie name = "folderme"
value = "#Now()#"
expires = "NOW">
<cfcookie name = "folderme" value = "/uploads2/#url.id#/">
<Cfparam name="url.beta" default="on">
<script src="ckeditor46z27e/ckeditor.js?asd2" charset="utf-8"></script>
<script type="text/javascript" src="ckfinder3511a/ckfinder.js?as441" charset="utf-8"></script>
<textarea id="myarea12" class="ckeditor" name="copyedit" style="height:600px;">#htmlEditFormat(getcoldata.copy)#</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></table>
</td></tr>
</cfif>
<tr>
<Td style="padding:5px;" colspan=2>
<b><font SIZE="-1" FACE="verdana">Script Embed Code:</font></b><br>
<Textarea name="media" style="width:600px;height:200px;">#getcoldata.media#</Textarea>
</td>
</tr>
<tr>
<Td style="padding:5px;" colspan=2>
<b><font SIZE="-1" FACE="verdana">Column Main Page Photo <cfif #url.mag# eq 5>375x175 <cfelse>150x150</cfif>:</font></b>
<input NAME="MainSwap" SIZE="70" value="#getcoldata.MainSwap#"><br>
<input NAME="podcast" SIZE="70" value="#getcoldata.podcast#" type="hidden">
</td>
</tr>
<tr>
<Td style="padding:5px;" colspan=2>
<b><font SIZE="-1" FACE="verdana"><font color="red">2019 Main Page Vertical Image</font>:</font></b>
<input NAME="imageurlbig" SIZE="70" value="#getdates.imageurlbig#"><br>
</td>
</tr>
<tr>
<Td style="padding:5px;" colspan=2>
<b><font SIZE="-1" FACE="verdana"><font color="red">2019 Main Page Horizontal Image</font>:</font></b>
<input NAME="imageurl" SIZE="70" value="#getdates.imageurl#"><br>
</td>
</tr>
<tr>
<Td style="padding:5px;" colspan=2>
<b><font SIZE="-1" FACE="verdana"><font color="red">2019 Main Page Short Headline</font>:</font></b>
<input NAME="imageheadline" SIZE="70" value="#getdates.imageheadline#"><br>
</td>
</tr>
<tr>
<Td style="padding:5px;" colspan=2>
<b><font SIZE="-1" FACE="verdana"><font color="red">2019 Main Page Short Caption</font>:</font></b>
<input NAME="imagecaption" SIZE="70" value="#getdates.imagecaption#"><br>
</td>
</tr>
<tr>
<Td style="padding:5px;" colspan=2>
<b><font SIZE="-1" FACE="verdana">Optional Date to Post Article (mm/dd/yyyy):</font></b>
<input NAME="repostdate" SIZE="10" value="<cfif #getcoldata.repostdate# eq '2199-01-01'>-<cfelse>#dateformat(getcoldata.repostdate,'mm/dd/yyyy')#</cfif>"><br>
</td>
</tr>
<tr>
<Td style="padding:5px;" colspan=2>
<b><font SIZE="-1" FACE="verdana">Optional Date to Remove Article from Main Page Rotation (mm/dd/yyyy):</font></b>
<input NAME="stopdate" SIZE="10" value="<cfif #getcoldata.stopdate# eq '2199-01-01'>-<cfelse>#dateformat(getcoldata.stopdate,'mm/dd/yyyy')#</cfif>"><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>
<p>
<a name="images">
<table width=600 bgcolor=efefef cellpadding=4 cellspacing=0 border=1 bordercolor=black><tr><td>
<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><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>
<font face=verdana size=-1>
<strong>Desired Image Width:</strong>
</td>
<td>
<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="cg22">
select *
from columnpic
where colid = #url.id#
</cfquery>
<table width=100% border=1 cellpadding=4 cellspacing=0 bordercolor=black>
<tr>
<td><font face=verdana size=-1><strong>Size</strong></td>
<td><font face=verdana size=-1><strong>Resized Image</strong></td>
<td><font face=verdana size=-1><strong>Original Image</strong></td>
</tr>
<cfoutput query="getpics">
<tr>
<td><center><font face=verdana size=-1>#size#</center></td>
<td>
<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.cityguideny.com/columnpic2/#photo#" target="#id#">https://www.cityguideny.com/columnpic2/#photo#</a>
<input type="submit" Value="Use 150" name="use150">
</form>
</td>
<td>
<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/columnpic2/#bigphoto#" target="#id#">https://www.cityguideny.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>
<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>