| 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/public_html/newadmin/ |
Upload File : |
<cfinclude template="header.cfm">
<div id="content">
<div id="content-header">
</div>
<div class="container-fluid" style="margin-left:200px;"><cfif parameterexists(Session.email) and (Session.email IS NOT -1)>
<cfif (#getuser.accesslevel# eq 100)>
<cfif #url.id# eq 2>
<Cfset #url.id# = 1>
</cfif>
<table width=100%><tr><Td style="padding:5px;" >
<div align="center"><font face=verdana size=+1><strong>Manage Categories</strong></font>
<br><font face=verdana size=-1>
<p>
<br>
<FORM action="addcalendarcategory2.cfm" method="post" enctype="multipart/form-data">
<br>
<table cellspacing=5 cellpadding=5 border=1>
<tr><Td style="padding:5px;" colspan=2>
<font face=verdana size=-1>
<cfquery name="getsites" datasource="#ds#">
select *
from CatActivityPlanner
where mag = #url.id#
and cat <> ''
<Cfif #url.id# eq 1>
and CatActivityPlanner.hide = 0
and catid> 150
</Cfif>
order by mastercat,cat
</cfquery>
</div>
<ul>
<table width="100%"><tr bgcolor="black">
<Td style="padding:5px;" ><font face=verdana size=-1 color=white><b>ID</td>
<Td style="padding:5px;" ><font face=verdana size=-1 color=white><b>MASTER CAT</td>
<Td style="padding:5px;" ><font face=verdana size=-1 color=white><b>NAME</td>
<Td style="padding:5px;" ><font face=verdana size=-1 color=white><b>EDIT</td>
<Td style="padding:5px;" ><font face=verdana size=-1 color=white><b>DELETE</td>
<Td style="padding:5px;" ><font face=verdana size=-1 color=white><b><center>COUNT</td>
<Cfif #url.id# eq 1>
<Td style="padding:5px;" ><font face=verdana size=-1 color=white><b><center>CONCIERGE<Br>ORDER</td>
</Cfif>
</tr>
<cfoutput query="getsites">
<tr>
<Td style="padding:5px;" ><font face=verdana size=-1>#catid# </td>
<Td style="padding:5px;" ><font face=verdana size=-1><b>#mastercat#</a></b></td>
<Td style="padding:5px;" ><font face=verdana size=-1><b>#cat#</a></b> <Cfif #hide# eq 1>(<em>hidden</em>)</Cfif></td>
<Td style="padding:5px;" ><font face=verdana size=-1><a href="editcalendarcategory.cfm?id=#catid#&magazine=#url.id#">edit</a></td>
<Td style="padding:5px;" ><font face=verdana size=-1><a href="deletecalendarcategory.cfm?id=#catid#&magazine=#url.id#" onClick="return confirm('Do you really want to delete this category?');">delete</a></td>
<Td style="padding:5px;" ><center>
<cfquery name="getcount" datasource="#ds#">
select count(distinct id) as counter
from ActivityPlanner
where CatID = #catid#
and dateend > '#dateformat(currentdatetime,'yyyy-mm-dd')#'
</cfquery>
<font face=verdana size=-1><b>#getcount.counter#</td>
<Cfif #url.id# eq 1>
<Td style="padding:5px;" ><center><font face=verdana size=-1><b>#conciergeorder#</td>
</Cfif>
</tr>
</cfoutput>
</table>
<p>
</td></tr>
<tr><Td style="padding:5px;" >
<b><font SIZE="-1" FACE="verdana">Category Name:</font></b>
</td><Td style="padding:5px;" >
<input NAME="Category" SIZE="65">
</td></tr>
<tr><Td style="padding:5px;" >
<b><font SIZE="-1" FACE="verdana">Master Category:</font></b>
</td><Td style="padding:5px;" >
<select name="mastercat">
<option value="">Other</option>
</select>
</td></tr>
<tr><Td style="padding:5px;" >
<b><font SIZE="-1" FACE="verdana">Site:</font></b>
</td><Td style="padding:5px;" >
<select name="site">
<option value="1">CITYGUIDE</option>
</select>
</td></tr>
</table><br>
<center><input type="submit" Value="Add"></center>
</form>
</td></tr></table>
</cfif>
</cfif>