| 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 : |
<cfcontent type="text/html;charset=iso-8859-1">
<cfprocessingDirective pageencoding="iso-8859-1">
<cfset setEncoding("Form", "ISO-8859-15")>
<cfparam name="getsubq.subcatid" default="0">
<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">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.3/jquery.min.js"></script>
<div id="content">
<div id="content-header">
</div>
<div class="container-fluid" style="margin-left:200px;">
<cfif parameterexists(url.edit)>
<cfif parameterexists(form.cats)>
<Cfquery name="cleartable" datasource="cg22">
delete from
cgdirectorycatsmap
where listingid = #url.id#
</CFQUERY>
<cfset myArray = ArrayNew(1)>
<cfloop from="1" to="#ListLen(form.cats)#"index="listCount">
<cfset myArray[listCount] =ListGetAt(form.cats,listCount,",")>
<cfquery name=addphoto datasource="cg22">
INSERT INTO cgdirectorycatsmap (listingid,catid)
VALUES (#url.id#,#myArray[listCount]#)
</cfquery>
</cfloop>
</cfif>
<cfparam name="form.adrankml" default="0">
<cfif #form.adrankml# eq '0'>
<cfset #form.adrankml# = 0>
</cfif>
<cfparam name="form.ccainfo" default="">
<cfparam name="form.ccadesc" default="">
<cfparam name="form.trackingpixel" default="">
<CFQUERY datasource="#ds#">
UPDATE cgdirectory
set firstname = '#form.firstname#',
lastname = '#form.lastname#',
email ='#form.email#',
address = '#form.address#',
city = '#form.city#',
state = '#form.state#',
zip = '#form.zip#',
approved = #form.approved#,
seo_friendly = '#form.seo_friendly#',
company = '#form.company#',
title = '#form.title#',
linkedin = '#form.linkedin#',
twitter = '#form.twitter#',
mobilephone = '#form.mobilephone#'
WHERE ID = #url.id#
</CFQUERY>
done
<br><br>
<a href="/newadmin/cg-directory-names.cfm">back to main</a>
<cfelse>
<cfquery name="Getdata" dataSource="#ds#">
select *
from cgdirectory
where id = #url.id#
</cfquery>
<cfform name="autoSumForm" action="cg-directory-edit.cfm?id=#url.id#&edit=on" method="post" enctype="multipart/form-data">
<table>
<tr><Td> <label>Approved</label></td><Td>
<Select name="approved">
<option value="<Cfoutput>#getdata.approved#</Cfoutput>"><Cfif #getdata.approved# eq 0>No<Cfelse>Yes</Cfif></option>
<option value="0">No</option>
<option value="1">yes</option>
</Select>
</Td></tr>
<tr><Td> <label>Link</label></td><Td>
<cfinput NAME="seo_friendly" class="span5" value="#getdata.seo_friendly#">
</Td></tr>
<tr><Td> <label>Company</label></td><Td>
<cfinput NAME="company" class="span5" required="Yes" message="You must provide your company name" value="#getdata.company#">
</Td></tr>
<tr><Td> <label>Title</label></td><Td>
<cfinput NAME="title" class="span5" required="Yes" message="You must provide your job title" value="#getdata.title#">
</Td></tr>
<tr><Td> <label>First Name</label></td><Td>
<cfinput NAME="firstname" class="span5" required="Yes" message="You must provide your first name" value="#getdata.firstname#">
</Td></tr> <tr><Td>
<label>Last Name</label>
</td><td>
<cfinput NAME="lastname" class="span5" required="Yes" message="You must provide your last name" value="#getdata.lastname#">
</Td></tr> <tr><Td>
<label>Your Email Address:</label></td><td>
<cfinput NAME="email" class="span5" required="Yes" message="You must provide your email address" value="#getdata.email#">
</Td></tr> <tr><Td>
<label>Mobile Phone:</label></td><TD>
<cfinput NAME="mobilephone" class="span5" required="Yes" message="You must enter your phone" value="#getdata.mobilephone#">
</Td></tr> <tr><Td>
<label>Address:</label></td><TD>
<cfinput NAME="address" class="span5" required="Yes" message="You must enter your address" value="#getdata.address#">
</Td></tr> <tr><Td>
<label>City:</label></td><TD>
<cfinput NAME="city" class="span5" required="Yes" message="You must enter your city" value="#getdata.city#">
</Td></tr> <tr><Td>
<label>State:</label>
</td><Td>
<SELECT SIZE="1" NAME="State" style="width:50px;">
<cfoutput><OPTION VALUE="#getdata.state#">#getdata.state#</option></cfoutput>
<OPTION VALUE="AB">AB</option>
<OPTION VALUE="AE">AE</option>
<OPTION VALUE="AK">AK</option>
<OPTION VALUE="AL">AL</option>
<OPTION VALUE="AR">AR</option>
<OPTION VALUE="AS">AS</option>
<OPTION VALUE="AZ">AZ</option>
<OPTION VALUE="BC">BC</option>
<OPTION VALUE="CA">CA</option>
<OPTION VALUE="CO">CO</option>
<OPTION VALUE="CT">CT</option>
<OPTION VALUE="DC">DC</option>
<OPTION VALUE="DE">DE</option>
<OPTION VALUE="FL">FL</option>
<OPTION VALUE="GA">GA</option>
<OPTION VALUE="GU">GU</option>
<OPTION VALUE="HI">HI</option>
<OPTION VALUE="IA">IA</option>
<OPTION VALUE="ID">ID</option>
<OPTION VALUE="IL">IL</option>
<OPTION VALUE="IN">IN</option>
<OPTION VALUE="KS">KS</option>
<OPTION VALUE="KY">KY</option>
<OPTION VALUE="LA">LA</option>
<OPTION VALUE="MA">MA</option>
<OPTION VALUE="MB">MB</option>
<OPTION VALUE="MD">MD</option>
<OPTION VALUE="ME">ME</option>
<OPTION VALUE="MI">MI</option>
<OPTION VALUE="MN">MN</option>
<OPTION VALUE="MO">MO</option>
<OPTION VALUE="MP">MP</option>
<OPTION VALUE="MS">MS</option>
<OPTION VALUE="MT">MT</option>
<OPTION VALUE="NB">NB</option>
<OPTION VALUE="NC">NC</option>
<OPTION VALUE="ND">ND</option>
<OPTION VALUE="NE">NE</option>
<OPTION VALUE="NF">NF</option>
<OPTION VALUE="NH">NH</option>
<OPTION VALUE="NJ">NJ</option>
<OPTION VALUE="NM">NM</option>
<OPTION VALUE="NS">NS</option>
<OPTION VALUE="NT">NT</option>
<OPTION VALUE="NV">NV</option>
<OPTION VALUE="NY">NY</option>
<OPTION VALUE="OH">OH</option>
<OPTION VALUE="OK">OK</option>
<OPTION VALUE="ON">ON</option>
<OPTION VALUE="OR">OR</option>
<OPTION VALUE="PA">PA</option>
<OPTION VALUE="PE">PE</option>
<OPTION VALUE="PQ">PQ</option>
<OPTION VALUE="PR">PR</option>
<OPTION VALUE="PW">PW</option>
<OPTION VALUE="RI">RI</option>
<OPTION VALUE="SC">SC</option>
<OPTION VALUE="SD">SD</option>
<OPTION VALUE="SK">SK</option>
<OPTION VALUE="TN">TN</option>
<OPTION VALUE="TX">TX</option>
<OPTION VALUE="UT">UT</option>
<OPTION VALUE="VA">VA</option>
<OPTION VALUE="VI">VI</option>
<OPTION VALUE="VT">VT</option>
<OPTION VALUE="WA">WA</option>
<OPTION VALUE="WV">WV</option>
<OPTION VALUE="WI">WI</option>
<OPTION VALUE="WY">WY</option>
<OPTION VALUE="YT">YT</option>
</SELECT>
</Td></tr> <tr><Td>
<label>Zip:</label></td><Td>
<cfinput NAME="zip" class="span5" required="Yes" message="You must enter your zip code" value="#getdata.zip#">
</Td></tr>
<tr><Td>
<label>Twitter:</label></td><Td>
<cfinput NAME="twitter" class="span5" required="Yes" value="#getdata.twitter#">
</Td></tr>
<tr><Td>
<label>LinkedIn:</label></td><Td>
<cfinput NAME="linkedin" class="span5" required="Yes" value="#getdata.linkedin#">
</Td></tr>
<tr><Td colspan="2">
<label>Categories:</label><p></p>
<Cfquery name="Getcats" dataSource="#ds#">
select * from cgdirectorycats where catname <> '' order by catname
</Cfquery>
<Cfoutput query="Getcats">
<Cfquery name="check" datasource="#ds#">
select * from cgdirectorycatsmap where listingid = #getdata.id# and catid = #id#
</Cfquery>
<input type="checkbox" name="Cats" value="#id#" <Cfif #check.recordcount# gt 0>checked</cfif>> #catname#<br>
</Cfoutput>
</Td></tr>
</table>
</table>
</table>
</table>
</table>
<br><br><br><input type="submit" value="Save" style="font-size:14pt;">
</cfform></center>
</cfif>
<p>
</div>
</div>
</div>
</div>
<!-- /.row -->
<cfinclude template="footer.cfm">