| 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/tgnew/ |
Upload File : |
<Cfset #ds# = 'cityguide'>
<Cfif parameterexists(form.first)>
<cfquery name="updas" dataSource="#ds#">
update oscarspollentries
set address1 = '#form.address1#'
where email = '#form.email#'
</cfquery>
</Cfif>
<Cfif parameterexists(form.address1)>
<cfquery name="updas" dataSource="#ds#">
update oscarspollentries
set address1 = '#form.address1#'
where email = '#form.email#'
</cfquery>
</Cfif>
<Cfif parameterexists(form.address2)>
<cfquery name="updas" dataSource="#ds#">
update oscarspollentries
set address2 = '#form.address2#'
where email = '#form.email#'
</cfquery>
</Cfif>
<Cfif parameterexists(form.city)>
<cfquery name="updas" dataSource="#ds#">
update oscarspollentries
set city = '#form.city#'
where email = '#form.email#'
</cfquery>
</Cfif>
<Cfif parameterexists(form.state)>
<cfquery name="updas" dataSource="#ds#">
update oscarspollentries
set state = '#form.state#'
where email = '#form.email#'
</cfquery>
</Cfif>
<Cfif parameterexists(form.first)>
<cfquery name="updas" dataSource="#ds#">
update oscarspollentries
set first = '#form.first#'
where email = '#form.email#'
</cfquery>
</Cfif>
<Cfif parameterexists(form.last)>
<cfquery name="updas" dataSource="#ds#">
update oscarspollentries
set last = '#form.last#'
where email = '#form.email#'
</cfquery>
</Cfif>
<Cfif parameterexists(form.zip2)>
<cfquery name="updas" dataSource="#ds#">
update oscarspollentries
set zip2 = '#form.zip2#'
where email = '#form.email#'
</cfquery>
</Cfif>
<cfif parameterexists(form.theirs) and isvalid("email",'#form.theirs#')>
<CFQUERY NAME="InsertOrder" datasource="#ds#">
INSERT INTO emailmaster (Email,tablename)
VALUES ('#Form.theirs#','academypoll-#form.email#')
</CFQUERY>
<CFMAIL
TO="#form.theirs#"
SUBJECT="#form.subject# from: #form.member#"
FROM="NYMP <[email protected]>"
SERVER="Mail.davlermedia.com"
username="Davler\webmail"
password="Webhome22@"
type="html">
From: #form.member#<br>
E-Mail: #form.email#<br>
Link: <a href="#form.goto#">#form.goto#</a>
<p>
#Replace(form.htmlpreviewtextarea, "#chr(13)##chr(10)#", "<p>" , "all")#>
</cfmail>
<cfif parameterexists(form.theirs2) and #form.theirs2# is not ''>
<CFQUERY NAME="InsertOrder" datasource="#ds#">
INSERT INTO emailmaster (Email,tablename)
VALUES ('#Form.theirs2#','academypoll-#form.email#')
</CFQUERY>
<CFMAIL
TO="#form.theirs2#"
FROM="#form.email#"
SUBJECT="From: #form.member# - #form.subject#"
SERVER="Mail.davlermedia.com"
username="Davler\webmail"
password="Webhome22@"
type="html">
From: #form.member#<br>
E-Mail: #form.email#<br>
Link: <a href="#form.goto#">#form.goto#</a>
<p>
#Replace(form.htmlpreviewtextarea, "#chr(13)##chr(10)#", "<p>" , "all")#>
</cfmail>
</cfif>
<cfif parameterexists(form.theirs3) and #form.theirs3# is not ''>
<CFQUERY NAME="InsertOrder" datasource="#ds#">
INSERT INTO emailmaster (Email,tablename)
VALUES ('#Form.theirs3#','academypoll-#form.email#')
</CFQUERY>
<CFMAIL
TO="#form.theirs3#"
FROM="#form.email#"
SUBJECT="From: #form.member# - #form.subject#"
SERVER="Mail.davlermedia.com"
username="Davler\webmail"
password="Webhome22@"
type="html">
From: #form.member#<br>
E-Mail: #form.email#<br>
Link: <a href="#form.goto#">#form.goto#</a>
<p>
#Replace(form.htmlpreviewtextarea, "#chr(13)##chr(10)#", "<p>" , "all")#>
<p>
</cfmail>
</cfif>
<cfif parameterexists(form.theirs4) and #form.theirs4# is not ''>
<CFQUERY NAME="InsertOrder" datasource="#ds#">
INSERT INTO emailmaster (Email,tablename)
VALUES ('#Form.theirs4#','academypoll-#form.email#')
</CFQUERY>
<CFMAIL
TO="#form.theirs4#"
FROM="#form.email#"
SUBJECT="From: #form.member# - #form.subject#"
SERVER="Mail.davlermedia.com"
username="Davler\webmail"
password="Webhome22@"
type="html">
From: #form.member#<br>
E-Mail: #form.email#<br>
Link: <a href="#form.goto#">#form.goto#</a>
<p>
#Replace(form.htmlpreviewtextarea, "#chr(13)##chr(10)#", "<p>" , "all")#>
<p>
</cfmail>
</cfif>
<cfif parameterexists(form.theirs5) and #form.theirs5# is not ''>
<CFQUERY NAME="InsertOrder" datasource="#ds#">
INSERT INTO emailmaster (Email,tablename)
VALUES ('#Form.theirs5#','academypoll-#form.email#')
</CFQUERY>
<CFMAIL
TO="#form.theirs5#"
FROM="#form.email#"
SUBJECT="From: #form.member# - #form.subject#"
SERVER="Mail.davlermedia.com"
username="Davler\webmail"
password="Webhome22@"
type="html">
From: #form.member#<br>
E-Mail: #form.email#<br>
Link: <a href="#form.goto#">#form.goto#</a>
<p>
#Replace(form.htmlpreviewtextarea, "#chr(13)##chr(10)#", "<p>" , "all")#>
</cfmail>
</cfif>
</cfif>
<Center>
<table><Tr><Td>
<font face=verdana size=-1>
<Center>
<p>
<br />
<font face=verdana size=+1>Thank You - Your Message Has Been Sent!
<p>
<p>
<p>
<a href="/">Click Here to Return to the Main Page</a>
</Td></Tr></table> </Center>