| Server IP : 104.21.21.239 / Your IP : 216.73.217.143 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/2019/wit/ |
Upload File : |
<Cfquery name="getcoupon" datasource="#ds#">
select * from liveeventpackages
where id = #url.id#
</cfquery>
<cfif parameterexists(url.article)>
<Cfset url.id = #getcoupon.id#>
</cfif>
<cfsavecontent variable="headercontent">
<title><cfoutput>#getcoupon.package# - Women in Tourism</cfoutput></title>
<meta property="og:image" content="https://www.cityguideny.com/uploads2/156894/files/Tourism-is-Back.png" />
</cfsavecontent>
<Cfinclude template="/header.cfm">
<cfinclude template="/rossavings.cfm">
<main>
<div class="white_bg" >
<div class="container margin_60" style="max-width: 800px;">
<!--- <div class="main_title">
<h2>Order</span></h2>
</div>
--->
<cfinclude template="css.htm">
<Cfif parameterexists(url.process)>
<Cfquery name="getcoupon" datasource="#ds#">
select * from liveeventpackages
where id = #url.id#
</cfquery>
<CFSET CurrentDateTime = #CreateODBCDateTime(Now())#>
<Cfparam name="form.adultsquantity" default="0">
<cfif #form.adultsquantity# gt 0>
<cfset totalq = form.adultsquantity>
<cfelse>
<cfset totalq = getcoupon.numtickets>
</cfif>
<Cfparam name="form.kidsquantity" default="0">
<Cfparam name="form.seniorquantity" default="0">
<Cfparam name="form.otherquantity" default="0">
<Cfparam name="form.ccnum" default="1234">
<Cfparam name="form.password" default="">
<Cfparam name="form.saver" default="">
<Cfparam name="form.subber" default="">
<cfset totalq = 0>
<cfif #form.adultsquantity# gt 0>
<Cfif #form.adultsquantity# eq 1><Cfset total = 195></cfif>
<Cfif #form.adultsquantity# eq 2><Cfset total = 390></cfif>
<Cfif #form.adultsquantity# eq 3><Cfset total = 585></cfif>
<Cfif #form.adultsquantity# eq 4><Cfset total = 780></cfif>
<Cfif #form.adultsquantity# eq 5><Cfset total = 975></cfif>
<Cfif #form.adultsquantity# eq 6><Cfset total = 1170></cfif>
<Cfif #form.adultsquantity# eq 7><Cfset total = 1365></cfif>
<Cfif #form.adultsquantity# eq 8><Cfset total = 1560></cfif>
<cfelse>
<Cfset total = #getcoupon.price#>
</cfif>
<!--- <cfif parameterexists(form.coupon)>
<cfquery name="upds" dataSource="#ds#">
update cgdirectorycoupons set usedtickets = usedtickets + #totalq#
where couponcode = '#form.coupon#'
</cfquery>
</cfif> --->
<cfif parameterexists(form.coupon)><Cfset codeused = '#form.coupon#'><cfelse><cfset codeused = ''></cfif>
<cfif #total# eq 0>
<Cfset approved = 'on'>
</cfif>
<cfif parameterexists(form.ccnum) and #form.ccnum# eq '1234'>
<Cfset approved = 'on'>
</cfif>
<Cfquery name="checkdupe" dataSource="cityguide">
select email from liveeventwait where email = '#form.email#'
</Cfquery>
<Cfif #checkdupe.recordcount# gt 10000><br><Br>
Error, you've already registered. Please contact [email protected] for help. </div><br><Br></div><Cfabort>
</cfif>
<cfparam name="approved" default="yes">
<Cfif parameterexists(approved)>
<!---
<Cfif #response_array[4]# contains 'Approved' >
---->
<cfset robpic = #createUUID()#>
<cfset robpic = '#right(robpic,8)#'>
<cfparam name="form.sendtype" default="">
<Cfset totalvendor = #total#>
<cfparam name="form.subscribenewsletter" default="">
<cfparam name="form.company" default="">
<cfparam name="form.jobtitle" default="">
<cfif #form.ccnum# eq '1234'>
<cfset total = 0>
<cfset price = 0>
<Cfset paid = 0>
</cfif>
<cfquery name=addphoto datasource="cityguide">
INSERT INTO liveeventwait (datetime,
firstname,
email,
subscribenewsletter,
lastname,
address,
city,
state,
zip,
country,
paid,
couponid,
used,
last4,
Adults,
Kids,
Senior,
Other,
Total,password,saver,subber,mobilephone,sendtype,uid,totalfees,company,jobtitle,codeused
)
VALUES (#currentdatetime#,'#form.firstname#','#form.email#','#form.subscribenewsletter#','#form.lastname#','#form.address#','#form.city#','#form.state#','#form.zip#','',1,0,0,#right(form.ccnum,4)#,#totalq#,#form.kidsquantity#,#form.seniorquantity#,#form.otherquantity#,#total#,'#form.password#','#form.saver#','#form.subber#','#form.mobilephone#','#form.sendtype#','#robpic#',#total#,'#form.company#','#form.jobtitle#','#url.id#')
</cfquery>
<cfquery name="Getorder" dataSource="#ds#">
select id from liveeventwait
order by id desc limit 0,1
</cfquery>
<CFMAIL
TO="#form.email#"
bcc="[email protected]"
SUBJECT="Women in Tourism "
FROM="Women in Tourism <[email protected]>"
SERVER="127.0.0.1"
type="html"
>
#getcoupon.packageconfirmationemail#
<p>
<p>
Please do not reply to this email. If you have any questions, please contact Heather Gambaro, [email protected].
</cfmail>
<Cfoutput>
</Cfoutput>
<p>
<div class="btn-block4"><h3 style="text-align:center"><a href="https://www.addevent.com/event/ME24558974" target="_blank"><span style="color:#fff">Add Event to Your Calendar</span></a> <script src="https://cdn.addevent.com/libs/atc/1.6.1/atc.min.js" async defer></script></h3></div><p>
</p>
Thanks, we will be in touch!
<!---<Cfoutput>
<cfif #form.adultsquantity# gt 0>
<cfset totalq = form.adultsquantity-1>
<cfelse>
<cfset totalq = getcoupon.numtickets>
</cfif>
<Cfif #totalq# lte 1>
#getcoupon.PACKATECONFIRMATIONPAGE#
</Cfif>
<form action="cgconfirm.cfm?id=#1#&order=#getorder.id#&totalq=#totalq#&package=#getcoupon.id#" method="post">
<Cfif #totalq# gt 1>
You're almost done, please fill out your guest's information below. Don't worry, if you don't know your guest's names, you can tell us later.
<Table>
<cfloop from="1" to="#totalq#" index="i">
<Tr><Td>
<input name="guestname#i#" placeholder="Guest Name #i#" style="width:100%;padding:3px;" >
</Td></Tr>
<Tr><Td>
<input name="guestemail#i#" placeholder="Guest Email #i#" style="width:100%;padding:3px;" >
</Td></Tr>
<Tr><Td>
<input name="guestphone#i#" placeholder="Guest Phone #i#" >
</Td></Tr>
</cfloop>
</Table>
<div class="col-lg-12">
<div class="form-group text-center">
<input class="button btn_1" type="submit" value="Confirm">
</div>
</div>
</div>
</form></Cfif>
</form>
</Cfoutput>--->
<Cfelse>
<Font size="+1" color="red">
Your transaction was declined, please <a href = "javascript:history.back()">click here</a> to go back and check your payment information.
<br><br><br>
</Cfif>
<div class="span3 sidebar-left">
<!--- <h4>Payment for <Cfoutput>#getcoupon.eventname# at #getcoupon.venue#</Cfoutput></h4>
<!-- COUPON THUMBNAIL -->
--->
</div>
</div>
<div class="span5">
<Cfelse>
<cfoutput query="getcoupon">
<p style="color:black;">#getcoupon.packagetext#</p>
</ul>
</a>
<p>
As of 5/14/2024 we are at capacity for tickets. Please fill out the reservation form below and if we receive cancellations (as we have in the past), we will let you know.
</cfoutput><br>
</p>
<cfif parameterexists(url.code)>
<Cfset #url.coupon# = '#url.code#'>
</cfif>
<Cfif parameterexists(form.sponsorcode)>
<Cfset #url.coupon# = '#form.sponsorcode#'>
</cfif>
<cfif not parameterexists(url.coupon)>
<div class=link3new>
<Cfelse>
<Cfquery name="checkc" dataSource="#ds#">
select * from cgdirectorycoupons where couponcode = '#url.coupon#'
</Cfquery>
<Cfif #checkc.recordcount# gt 0>
<Cfoutput>Welcome #checkc.companyname#!</Cfoutput>
<Cfif #checkc.usedtickets# gt #checkc.allowedtickets#>
Error, code has been used its maximum number of times. </div></div><Cfabort>
</cfif>
<cfelse>
Not found!
</Cfif>
</cfif>
<cfif currentdatetime lt '2024-02-28' and not parameterexists(url.preview)>
Tickets to this event will go on sale shortly. Thank you!<br><br>
<!-- //////////////////////////////////
//////////////END PAGE CONTENT/////////
////////////////////////////////////-->
</div>
</div>
</div>
</div>
</div>
</main>
<cfinclude template="/footer.cfm">
<Cfabort>
</cfif>
<cfform name="autoSumForm" action="event-wait.cfm?process=on&id=#url.id#" method="post" enctype="multipart/form-data">
<Cfif parameterexists(url.coupon)>
<Cfoutput> <input type="hidden" name="coupon" value="#url.coupon#"></Cfoutput>
</cfif>
<cfif parameterexists(session.id) and parameterexists(session.accesslevel) and parameterexists(session.member)>
<cfquery name="Getdata" dataSource="#ds#">
select * from liveeventwait
where email = '#session.email#'
</cfquery>
<cfelse>
<cfparam name="getdata.firstname" default="">
<cfparam name="getdata.lastname" default="">
<cfparam name="getdata.email" default="">
<cfparam name="getdata.mobilephone" default="">
<cfparam name="getdata.address" default="">
<cfparam name="getdata.address2" default="">
<cfparam name="getdata.city" default="">
<cfparam name="getdata.state" default="">
<cfparam name="getdata.zip" default="">
<cfparam name="getdata.country" default="">
</cfif>
<table>
<tr><Td>
<label>Company</label>
</td><td>
<cfinput NAME="company" class="span5" required="Yes" message="You must provide your 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" >
</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> </table>
<Br>
</table><cfoutput>
</cfoutput>
<br><br>
<div class="gap gap-mini"></div>
<input type="submit" class="btn btn-primary btn-block btn-large span6" style="color:white;background-color:black;" value="Join Wait List "><br><center>
<br><br>
<p> </p>
<h3 style="text-align:center"><span style="color:#000000">Sponsors</span></h3>
<p style="text-align:center"><img alt="" height="100%" src="https://www.cityguideny.com/uploads2/157223/WITFooter3_31_2026.jpg" width="800" /></p>
</cfform>
</div>
</div>
<div class="gap"></div>
</cfif>
</div>
<!-- //////////////////////////////////
//////////////END PAGE CONTENT/////////
////////////////////////////////////-->
</div>
</div>
</div>
</div>
</div>
</main>
<cfinclude template="/footer.cfm">