$endtime) { //Then this is the right week //echo "Week with deadline of $endtime is the current week
"; $validtime = 1; $contestyear = $row["Year"]; $contestweek = $row["Week"]; $lastweek = $contestweek -1; $conteststring = $row["DateString"]; break; } } //Begin to generate guts of web page echo ("

CFCC $contestyear Game Breakdown

Week $contestweek, $conteststring

Game:  "); //Gotta find rest of game information $weeknumb = 0 + $contestweek; $weekyear = substr($contestyear,2,2); $picksfile = "CFCCPicks$weeknumb$weekyear"; $gamefile = "CFCCGames$weeknumb$weekyear"; $totalstable = "CFCCTotals$lastweek$weekyear"; $sql = "select * from $gamefile where ID = $ID"; $result = mysql_query($sql); $numb_games = mysql_num_rows($result); $row = mysql_fetch_array($result); $Team1=$row["Team1"]; $Team2=$row["Team2"]; $AtVs=$row["AtVs"]; $ID = $row["ID"]; //Grab Consensus Info //First Find Total Players $sql = "SELECT COUNT(MemberHandle) from $picksfile"; $result2 = mysql_query($sql); $row2 = mysql_fetch_array($result2); $totalplayers = $row2[0]; $Con = "C$ID"; $Win = "W$ID"; $sql2 = "SELECT -1*(SUM($Con)) from $picksfile where $Win = 1"; $result2 = mysql_query($sql2); $sql3 = "SELECT (SUM($Con)) from $picksfile where $Win = 2"; $result3 = mysql_query($sql3); $row2 = mysql_fetch_array($result2); $row3 = mysql_fetch_array($result3); $avg = ($row2[0] + $row3[0])/$totalplayers; $absavg = abs($avg); $roundavg = round($avg,0); $conffullraw = $roundavg; $roundavg2 = round($absavg,0); $conffull = $roundavg2; if ($contestweek != 1) { //Again for Top 25 $sql2 = "SELECT -1*(SUM($picksfile.$Con)) from $picksfile, $totalstable where $totalstable.MemberHandle = $picksfile.MemberHandle and $totalstable.Place < 26 and $picksfile.$Win = 1"; $result2 = mysql_query($sql2); $sql3 = "SELECT SUM($picksfile.$Con) from $picksfile, $totalstable where $totalstable.MemberHandle = $picksfile.MemberHandle and $totalstable.Place < 26 and $picksfile.$Win = 2"; $result3 = mysql_query($sql3); $row2 = mysql_fetch_array($result2); $row3 = mysql_fetch_array($result3); $avg = ($row2[0] + $row3[0])/25; $absavg = abs($avg); $roundavg = round($avg,0); $conffullraw25 = $roundavg; $roundavg2 = round($absavg,0); $conffull25 = $roundavg2; //Again for Top 10 $sql2 = "SELECT -1*(SUM($picksfile.$Con)) from $picksfile, $totalstable where $totalstable.MemberHandle = $picksfile.MemberHandle and $totalstable.Place < 11 and $picksfile.$Win = 1"; $result2 = mysql_query($sql2); $sql3 = "SELECT SUM($picksfile.$Con) from $picksfile, $totalstable where $totalstable.MemberHandle = $picksfile.MemberHandle and $totalstable.Place < 11 and $picksfile.$Win = 2"; $result3 = mysql_query($sql3); $row2 = mysql_fetch_array($result2); $row3 = mysql_fetch_array($result3); $avg = ($row2[0] + $row3[0])/10; $absavg = abs($avg); $roundavg = round($avg,0); $conffullraw10 = $roundavg; $roundavg2 = round($absavg,0); $conffull10 = $roundavg2; } else { $confstring25 = "Even"; $confstring10 = "Even"; } $conf = $conffull; if (($conffullraw > 0)) { $cteam = $Team2; $confstring = "$cteam $conf"; } elseif ($conffullraw < 0) { $cteam = $Team1; $confstring = "$cteam $conf"; } else { $confstring = "Even"; } if ($contestweek != 1) { $conf25 = $conffull25; if (($conffullraw25 > 0)) { $cteam = $Team2; $confstring25 = "$cteam $conf25"; } elseif ($conffullraw25 < 0) { $cteam = $Team1; $confstring25 = "$cteam $conf25"; } else { $confstring25 = "Even"; } $conf10 = $conffull10; if (($conffullraw10 > 0)) { $cteam = $Team2; $confstring10 = "$cteam $conf10"; } elseif ($conffullraw10 < 0) { $cteam = $Team1; $confstring10 = "$cteam $conf10"; } else { $confstring10 = "Even"; } } echo (" $Team1 $AtVs $Team2
Total Players This Week:  $totalplayers

Consensus:  $confstring, Top 25: $confstring25, Top 10: $confstring10

"); //Make rest of queries for breakdown code $sql2 = "SELECT AVG(C$ID) from $picksfile where W$ID = 1"; $sql3 = "SELECT AVG(C$ID) from $picksfile where W$ID = 2"; $sql4 = "SELECT COUNT(MemberHandle) from $picksfile where W$ID = 1"; $sql5 = "SELECT COUNT(MemberHandle) from $picksfile where W$ID = 2"; $result2 = mysql_query($sql2); $result3 = mysql_query($sql3); $result4 = mysql_query($sql4); $result5 = mysql_query($sql5); $row2 = mysql_fetch_array($result2); $row3 = mysql_fetch_array($result3); $row4 = mysql_fetch_array($result4); $row5 = mysql_fetch_array($result5); $avg2 = round($row2[0],0); $avg3 = round($row3[0],0); $avg4 = round($row4[0]/$totalplayers*100,0); $avg5 = round($row5[0]/$totalplayers*100,0); if ($row4[0] > $row5[0]) { $max = $row4[0]; } else { $max = $row5[0]; } $visitoravgconf = $avg2; $homeavgconf = $avg3; $visitornumb = $row4[0]; $visitorpct = $avg4; $homenumb = $row5[0]; $homepct = $avg5; //Write some more web page echo(" "); //Now grab the picks $sql = "select * from $picksfile where W$ID = '1' order by C$ID DESC"; $result = mysql_query($sql); while ($row = mysql_fetch_array($result)) { $visitMemberHandle = $row["MemberHandle"]; $visitcholder = "C$ID"; $visitconf[] = $row["$visitcholder"]; $sql2 = "select ID,MemberName,MemberCityPlay,MemberStatePlay,MemberCountryPlay from Members where MemberHandle = '$visitMemberHandle'"; $result2 = mysql_query($sql2); $row2 = mysql_fetch_array($result2); $visitName[] = $row2["MemberName"]; $visitCity[] = $row2["MemberCityPlay"]; $visitState[] = $row2["MemberStatePlay"]; $visitCountry[] = $row2["MemberCountryPlay"]; $visitPlayerID[] = $row2["ID"]; } $sql = "select * from $picksfile where W$ID = '2' order by C$ID DESC"; $result = mysql_query($sql); while ($row = mysql_fetch_array($result)) { $homeMemberHandle = $row["MemberHandle"]; $homecholder = "C$ID"; $homeconf[] = $row["$homecholder"]; $sql2 = "select ID,MemberName,MemberCityPlay,MemberStatePlay,MemberCountryPlay from Members where MemberHandle = '$homeMemberHandle'"; $result2 = mysql_query($sql2); $row2 = mysql_fetch_array($result2); $homeName[] = $row2["MemberName"]; $homeCity[] = $row2["MemberCityPlay"]; $homeState[] = $row2["MemberStatePlay"]; $homeCountry[] = $row2["MemberCountryPlay"]; $homePlayerID[] = $row2["ID"]; } for ($i=0; $i<$max; $i++) { echo(" "); } echo ("
Players Picking $Team1: $visitornumb ($visitorpct%)
Average Confidence:  $visitoravgconf		 Confidence Players Picking $Team2: $homenumb ($homepct%)
Average Confidence:  $homeavgconf		 Confidence
$visitName[$i] ($visitCity[$i], $visitState[$i], $visitCountry[$i]) $visitconf[$i] $homeName[$i] ($homeCity[$i], $homeState[$i], $homeCountry[$i]) $homeconf[$i]
"); include("includes/footer.inc");