| 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 : |
<head>
<title>Share Your Predictions! 2014 Academy Awards Poll - RESULTS!</title>
</head>
<cfset ds = 'cityguide'>
<center>
<Table width="680" border="0" style="border:1px;border-style:dashed;border-width:1px;padding:4px;"><tr><Td width="800" bgcolor="#ffffff" valign="top" style="padding:6px;">
<center><img src="http://thoughtgallery.org/wp-content/uploads/2013/10/tg-main-logo-520-100.jpg" align="ThoughtGallery.org"></center><Br><br>
<Font face="verdana" size="-1">
See how your Oscar predictions compare to the rest of the Thoughtlectual community. How closely do they match tonight's final results?
<p>
<Cfif parameterexists(url.email)>
<a href="http://thoughtgallery.org/academy-awards-2014-share.cfm?email=<Cfoutput>#url.email#</Cfoutput>">Share your predictions with your friends</a><p>
<h1>
<cfoutput>Your Predictions</cfoutput></h1>
<cfquery name="Getcats" dataSource="#ds#">
select distinct catname from
oscarspoll
order by catname
</cfquery>
<Cfloop from="1" to="#getcats.recordcount#" index="i">
<Cfoutput>
<b>#getcats.catname[i]#: </b>
</Cfoutput>
<Cfif #i# eq 1>
<cfquery name="get1" dataSource="#ds#">
select answer1
from oscarspollentries
where email = '#url.email#'
</cfquery>
<Cfoutput>#get1.answer1#</Cfoutput><br>
</Cfif>
<Cfif #i# eq 2>
<cfquery name="get2" dataSource="#ds#">
select answer2
from oscarspollentries
where email = '#url.email#'
</cfquery>
<Cfoutput>#get2.answer2#</Cfoutput><br>
</Cfif>
<Cfif #i# eq 3>
<cfquery name="get3" dataSource="#ds#">
select answer3
from oscarspollentries
where email = '#url.email#'
</cfquery>
<Cfoutput>#get3.answer3#</Cfoutput><br>
</Cfif>
<Cfif #i# eq 4>
<cfquery name="get1" dataSource="#ds#">
select answer4
from oscarspollentries
where email = '#url.email#'
</cfquery>
<Cfoutput>#get1.answer4#</Cfoutput><br>
</Cfif>
<Cfif #i# eq 5>
<cfquery name="get1" dataSource="#ds#">
select answer5
from oscarspollentries
where email = '#url.email#'
</cfquery>
<Cfoutput>#get1.answer5#</Cfoutput><br>
</Cfif>
<Cfif #i# eq 6>
<cfquery name="get1" dataSource="#ds#">
select answer6
from oscarspollentries
where email = '#url.email#'
</cfquery>
<Cfoutput>#get1.answer6#</Cfoutput><br>
</Cfif>
<Cfif #i# eq 7>
<cfquery name="get1" dataSource="#ds#">
select answer7
from oscarspollentries
where email = '#url.email#'
</cfquery>
<Cfoutput>#get1.answer7#</Cfoutput><br>
</Cfif>
<Cfif #i# eq 8>
<cfquery name="get1" dataSource="#ds#">
select answer8
from oscarspollentries
where email = '#url.email#'
</cfquery>
<Cfoutput>#get1.answer8#</Cfoutput><br>
</Cfif>
<Cfif #i# eq 9>
<cfquery name="get1" dataSource="#ds#">
select answer9
from oscarspollentries
where email = '#url.email#'
</cfquery>
<Cfoutput>#get1.answer9#</Cfoutput><br>
</Cfif>
<Cfif #i# eq 10>
<cfquery name="get1" dataSource="#ds#">
select answer10
from oscarspollentries
where email = '#url.email#'
</cfquery>
<Cfoutput>#get1.answer10#</Cfoutput><br>
</Cfif>
<Cfif #i# eq 11>
<cfquery name="get1" dataSource="#ds#">
select answer11
from oscarspollentries
where email = '#url.email#'
</cfquery>
<Cfoutput>#get1.answer11#</Cfoutput><br>
</Cfif>
<Cfif #i# eq 12>
<cfquery name="get1" dataSource="#ds#">
select answer12
from oscarspollentries
where email = '#url.email#'
</cfquery>
<Cfoutput>#get1.answer12#</Cfoutput><br>
</Cfif>
</Cfloop><p>
</Cfif>
<cfquery name="Getcats" dataSource="#ds#">
select distinct catname from
oscarspoll
order by catname
</cfquery>
<Cfquery name="gettotal" dataSource="cityguide">
select count(id) as totalans
from oscarspollentries
</cfquery>
<Cfset typer = 'png'>
<Cfoutput query="Getcats">
<h1>#catname#</h1>
<cfquery name="getanswers2" dataSource="cityguide">
SELECT oscarspollentries.Answer#currentrow# as answerme, Count(oscarspollentries.Answer#currentrow#) AS CountOfAnswer, (((count(oscarspollentries.answer#currentrow#)/#Gettotal.totalans#))) as answerperc
FROM oscarspollentries
where oscarspollentries.Answer#currentrow# <> ''
group by answer#currentrow#
order by answerperc desc
</cfquery>
<cfif not parameterexists(url.email)>
<cfchart format="#typer#" chartheight="400" chartwidth="750" showxgridlines="no" showygridlines="no" showborder="yes" fontbold="no" fontitalic="no" show3d="yes" rotated="no" sortxaxis="no" showlegend="yes" showmarkers="no" pieSliceStyle = "solid" labelformat="percent">
<div align="center">
<center>
<cfchartseries type="bar"
query="getanswers2"
seriesColor="red"
itemcolumn="answerme"
valuecolumn="answerperc" />
</cfchart> </cfif>
<table width="680">
<Cfloop from ="1" to="#getanswers2.recordcount#" index="i">
<TR style="background-color:###IIf(i Mod 2, DE('ffffff'), DE('efefef'))#">
<Td width="600"><Font face="Verdana" size="-1">
<b>#getanswers2.answerme[i]#
</Td><Font face="Verdana" size="-1">
<Td width="80">
<Cfset zz = #Round(getanswers2.answerperc[i] * 100)#>
#zz#%
</Td>
</Tr></Cfloop>
</table>
</Cfoutput>
</td></tr></table>