| Server IP : 104.21.21.239 / 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 : |
<cfinclude template="header.cfm">
<Cfsetting requesttimeout="600">
<div id="content" style="margin-left:250px;">
<div id="content-header">
<h2> Manage NYMP Contests
</div>
<div class="container-fluid" >
<table width=100%><tr><td>
<div align="center"><font face=verdana size=+1><strong>Manage NYMP Contests</strong></font>
<font face=verdana size=-1>
<a href="addcontest.cfm?viewall=on">View Past Contests</a>
<p>
<Cfif parameterexists(url.edit)>
<FORM action="addcontest2.cfm?edit=on" method="post" enctype="multipart/form-data">
<cfelse>
<FORM action="addcontest2.cfm" method="post" enctype="multipart/form-data">
</cfif>
<table cellspacing=5 cellpadding=5 border=1 width=100%>
<tr><td colspan=2>
<font face=verdana size=-1>
<cfquery name="getsites" datasource="#ds#">
select *
from mastercontestindex
<Cfif not parameterexists(url.viewall)>where year(expiredate) > 2013</cfif>
order by expiredate desc, contestname
</cfquery>
</div>
<table width="800" cellpadding="4" cellspacing="0" border="1"><tr bgcolor="black">
<td><font face=verdana size=-1 color=white><b>CONTEST NAME</td>
<td><font face=verdana size=-1 color=white><b>START / <br />EXPIRATION</td>
<td><font face=verdana size=-1 color=white><b><center>COUNT</td>
<td><font face=verdana size=-1 color=white><b>EDIT</td>
<td><font face=verdana size=-1 color=white><b>TEXT</td>
<td><font face=verdana size=-1 color=white><b>ENTRIES</td>
</tr>
<cfoutput query="getsites">
<tr>
<td><font face=verdana size=-2><b><a href="http://www.nymetroparents.com/contestform.cfm?id=#id#">#contestname#</a> #contestsite# </td>
<td><font face=verdana size=-2>#dateformat(startdate,'m/d/yyyy')#<Br />#dateformat(expiredate,'m/d/yyyy')#</a> </td>
<td><font face=verdana size=-2>
<cfquery name="Getentires" datasource="#ds#">
select count(id) as counter
from mastercontest
where contest = '#getsites.contestname#'
</cfquery>
<cfif #parameterexists(Getentires.counter)#>#Getentires.counter#<cfelse>0</cfif>
</td>
<td>
<font face=verdana size=-2><a href="addcontest.cfm?id=#id#&edit=on">edit contest</a><br /><br />
<font face=verdana size=-2><a href="/addnympcontestphoto.cfm?id=#id#&edit=on">edit pics</a>
</td><td>
<font face=verdana size=-2><a href="http://cityguideny.com/admin/editcol333.cfm?id=#t1#&mag=5&general=on">edit main page</a><br /><br />
<a href="http://cityguideny.com/admin/editcol333.cfm?id=#t2#&mag=5&general=on">edit conf. page</a><br /><br />
<a href="http://cityguideny.com/admin/editcol333.cfm?id=#t3#&mag=5&general=on">edit conf. email</a><br />
</td>
<td><font face=verdana size=-2><a href="viewentries.cfm?id=#id#">view entries</a></font></td>
</tr>
</cfoutput>
</table>
<p>
</td></tr>
<Cfif parameterexists(url.edit)>
<Cfquery name="Getcontest" datasource="#ds#">
select *
from mastercontestindex where id = #url.id#
</Cfquery>
<cfoutput query="Getcontest">
<input name="id" value="#getcontest.id#" type="hidden">
<input name="currentname" value="#getcontest.contestname#" type="hidden">
<tr><td>
<b><font SIZE="-1" FACE="verdana">Contest Name:</font></b>
</td><td>
<input NAME="contestname" SIZE="65" value="#getcontest.contestname#">
</td></tr>
<tr><td>
<b><font SIZE="-1" FACE="verdana">Contest Site:</font></b>
</td><td>
<select name="contestsite">
<option value="#getcontest.contestsite#">#getcontest.contestsite#</option>
<option value="NYMP">NYMP</option>
<option value="CG">CG</option>
<option value="BOTH">BOTH</option>
</select>
</td></tr>
<tr><td>
<b><font SIZE="-1" FACE="verdana">Contest Special Site:</font></b>
</td><td>
<select name="special">
<option value="#getcontest.special#">#getcontest.special#</option>
<option value="Halloween">Halloween</option>
</select>
</td></tr>
<tr><td>
<b><font SIZE="-1" FACE="verdana">Expiration Date (yyyy-mm-dd):</font></b>
</td><td>
<input NAME="expiredate" SIZE="65" value="#dateformat(getcontest.expiredate,'yyyy-mm-dd')#">
</td></tr>
<tr><td>
<b><font SIZE="-1" FACE="verdana">Start Date (yyyy-mm-dd):</font></b>
</td><td>
<input NAME="startdate" SIZE="65" value="#dateformat(getcontest.startdate,'yyyy-mm-dd')#">
</td></tr>
<tr><td>
<b><font SIZE="-1" FACE="verdana">Text Only Blurb for SEO:</font></b>
</td><td>
<textarea name="textonlyseo" cols="60" rows="10">#getcontest.textonlyseo#</textarea>
</td></tr>
<tr><td>
<b><font SIZE="-1" FACE="verdana">Email To (Optional address to receive alerts on new submissions):</font></b>
</td><td>
<input NAME="emailto" SIZE="65" value="#getcontest.emailto#">
</td></tr>
<tr><td>
<b><font SIZE="-1" FACE="verdana">Special Links (Optional 3rd Party Link to Redirect Contests To):</font></b>
</td><td>
<input NAME="speciallink" SIZE="65" value="#getcontest.speciallink#">
</td></tr>
<tr><td>
<b><font SIZE="-1" FACE="verdana">Contest Image:</font></b>
</td><td>
<input NAME="contestimage" SIZE="65" value="#getcontest.contestimage#">
</td></tr>
</cfoutput>
<Cfelse>
<tr><td>
<b><font SIZE="-1" FACE="verdana">Contest Name:</font></b>
</td><td>
<input NAME="contestname" SIZE="65">
</td></tr>
<tr><td>
<b><font SIZE="-1" FACE="verdana">Contest Site:</font></b>
</td><td>
<select name="contestsite">
<option value="NYMP">NYMP
<option value="CG">CG
<option value="BOTH">BOTH
</select>
</td></tr>
<tr><td>
<b><font SIZE="-1" FACE="verdana">Expiration Date (yyyy-mm-dd):</font></b>
</td><td>
<input NAME="expiredate" SIZE="65">
</td></tr> <tr><td>
<b><font SIZE="-1" FACE="verdana">Start Date (yyyy-mm-dd):</font></b>
</td><td>
<input NAME="startdate" SIZE="65">
</td></tr>
<tr><td>
<b><font SIZE="-1" FACE="verdana">Text Only Blurb for SEO:</font></b>
</td><td>
<textarea name="textonlyseo" cols="60" rows="10"></textarea>
</td></tr>
<tr><td>
<b><font SIZE="-1" FACE="verdana">Email To (Optional address to receive alerts on new submissions):</font></b>
</td><td>
<input NAME="emailto" SIZE="65">
</td></tr>
<tr><td>
<b><font SIZE="-1" FACE="verdana">Special Links (Optional 3rd Party Link to Redirect Contests To):</font></b>
</td><td>
<input NAME="speciallink" SIZE="65">
</td></tr>
</Cfif>
</table><br>
<center><input type="submit" Value="Add/Update"></center>
</form>
</td></tr></table>
</div>
<!--Footer-part-->
<br><br><br><br>
<cfinclude template="footer.cfm">