| 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/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)>
<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 liveeventorder
set firstname = '#form.firstname#',
lastname = '#form.lastname#',
email ='#form.email#',
address = '#form.address#',
total = #form.total#,
codeused = #form.codeused#,
adults = #form.adults#,
city = '#form.city#',
company = '#form.company#',
jobtitle = '#form.jobtitle#',
state = '#form.state#',
zip = '#form.zip#',
mobilephone = '#form.mobilephone#'
WHERE ID = #url.id#
</CFQUERY>
done
<!--- //,
adults = #form.totalq#
---->
<cfquery name="del" datasource="#ds#">
delete from liveeventguests
where orderid = #url.id#
</cfquery>
<Cfloop from="1" to="#form.adults#" index="ThisRow">
<Cftry>
<Cfquery name=addphoto datasource="cg22">
INSERT INTO liveeventguests (orderid,name,email,phone,facebook,instagram
)
VALUES (#url.id#,
'#Evaluate("form.guestname" & ThisRow)#',
'#Evaluate("form.guestemail" & ThisRow)#',
'#Evaluate("form.guestphone" & ThisRow)#','',''
)
</cfquery>
<cfcatch>
<Cfquery name=addphoto datasource="cg22">
INSERT INTO liveeventguests (orderid,name,email,phone,facebook,instagram
)
VALUES (#url.id#,
'',
'',
'','',''
)
</cfquery>
</cfcatch>
</Cftry>
</Cfloop>
<br><br>
<a href="https://www.cityguideny.com/newadmin/cg-liveevent-names.cfm">back to main</a>
<cfelse>
<Cfif parameterexists(url.delete)>
<Cfquery name="del1" dataSource="#ds#">
delete from liveeventguests where orderid = #url.delete#
</Cfquery>
<Cfquery name="del1" dataSource="#ds#">
delete from liveeventorder where id = #url.delete#
</Cfquery>
<cflocation url="https://www.cityguideny.com/newadmin/cg-liveevent-names.cfm?id=1" addtoken="no">
</Cfif>
<cfoutput>
<A href="cg-livevent-customer.cfm?delete=#url.id#" onClick="return confirm('Are you sure? THIS is irreversible');">Delete Customer & Guests</A>
<br><br><br>
<FORM action="cg-livevent-customer.cfm?edit=on&id=#url.id#" method="post" enctype="multipart/form-data"> </cfoutput>
<cfquery name="Getdata" dataSource="#ds#">
select *
from liveeventorder
where id = #url.id#
</cfquery>
<cfform name="autoSumForm" action="/cg-livevent-customer.cfm?id=#url.id#&process=on" method="post" enctype="multipart/form-data">
<table>
<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>Company</label>
</td><td>
<cfinput NAME="Company" class="span5" required="Yes" message="You must provide your Company" value="#getdata.Company#">
</Td></tr>
<tr><Td>
<label>Job Title</label>
</td><td>
<cfinput NAME="jobtitle" class="span5" required="Yes" message="You must provide your job title" value="#getdata.jobtitle#">
</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>Adults:</label></td><Td>
<cfinput NAME="adults" class="span5" required="Yes" value="#getdata.adults#">
</Td></tr>
</table>
</table>
</table>
</table>
</table>
<h1>Guests</h1>
<cfquery name="getguests" dataSource="#ds#">
select * from liveeventguests
where orderid = #url.id#
</cfquery>
<Table>
<cfoutput query="getguests">
<Tr><Td>
<input name="guestname#currentrow#" placeholder="Guest Name #currentrow#" style="width:100%;padding:3px;" value="#getguests.name#">
</Td></Tr>
<Tr><Td>
<input name="guestemail#currentrow#" placeholder="Guest Email #currentrow#" style="width:100%;padding:3px;" value="#getguests.email#">
</Td></Tr>
<Tr><Td>
<input name="guestphone#currentrow#" placeholder="Guest Phone #currentrow#" value="#getguests.phone#">
</Td></Tr>
</cfoutput>
<tr><Td> <label>Total $</label></td><Td>
<cfinput NAME="total" class="span5" required="Yes" message="You must provide your first name" value="#getdata.total#">
</Td></tr>
<tr><Td> <label>Package Code</label></td><Td>
<cfinput NAME="codeused" class="span5" required="Yes" message="You must provide your first name" value="#getdata.codeused#">
</Td></tr>
<tr><Td colspan="2">
<cfquery name="getpack" datasource="#ds#">
select id,package from liveeventpackages
order by id
</cfquery>
<cfoutput query="getpack">
#id# - #package#<br>
</cfoutput>
</Td></tr>
<tr><Td><input type="submit" value="Save" style="color:black;font-size:14pt;"><br><Br>
</Td></tr>
</Table>
</cfform></center>
</cfif>
<p>
</div>
</div>
</div>
</div>
<!-- /.row -->
<cfinclude template="footer.cfm">