|
National College Sports
Headlines
|
");
//Before we go on we have to query for player info, games for this week and picks
$weeknumb = 0 + $contestweek;
$weekyear = substr($contestyear,2,2);
$picksfile = "CFCCPicks$weeknumb$weekyear";
$gamefile = "CFCCGames$weeknumb$weekyear";
$totalstable = "CFCCTotals$lastweek$weekyear";
$sql = "select MemberHandle,MemberCityPlay,MemberStatePlay,MemberCountryPlay
from Members where MemberName = '$MemberName' and ID = $ID";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$MemberHandle = $row["MemberHandle"];
$MemberCityPlay = $row["MemberCityPlay"];
$MemberStatePlay = $row["MemberStatePlay"];
$MemberCountryPlay = $row["MemberCountryPlay"];
$sql = "select * from $gamefile";
$result = mysql_query($sql);
$numb_games = mysql_num_rows($result);
while ($row = mysql_fetch_array($result)) {
$Team1[]=$row["Team1"];
$Team2[]=$row["Team2"];
}
$sql = "select * from CFCCResults where Year = $contestyear and Week = $weeknumb";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
for ($i = 0; $i<=$numb_games-1; $i++) {
$WinningTeam[] = $row[$i+3];
}
$official = $row["Final"];
$sql = "select * from $picksfile where MemberHandle = '$MemberHandle'";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
//Write more of the web page
echo ("
CFCC
Individual Player Picks
Week $contestweek, $conteststring
Player: $MemberName
Location: $MemberCityPlay, $MemberStatePlay, $MemberCountryPlay
| Winning
Team |
Confidence
Factor |
Result |
");
//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];
for ($i=1; $i<$numb_games+1; ++$i) {
$Con = "C$i";
$Win = "W$i";
$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[$i] = $roundavg;
$roundavg2 = round($absavg,0);
$conffull[$i] = $roundavg2;
if ($contestweek != 1) {
//Again for Top 25
$sql2 = "SELECT -1*(SUM($picksfile.C$i)) from $picksfile, $totalstable
where $totalstable.MemberHandle = $picksfile.MemberHandle
and $totalstable.Place < 26 and $picksfile.W$i = 1";
$result2 = mysql_query($sql2);
$sql3 = "SELECT SUM($picksfile.C$i) from $picksfile, $totalstable
where $totalstable.MemberHandle = $picksfile.MemberHandle
and $totalstable.Place < 26 and $picksfile.W$i = 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[$i] = $roundavg;
$roundavg2 = round($absavg,0);
$conffull25[$i] = $roundavg2;
//Again for Top 10
$sql2 = "SELECT -1*(SUM($picksfile.C$i)) from $picksfile, $totalstable
where $totalstable.MemberHandle = $picksfile.MemberHandle
and $totalstable.Place < 11 and $picksfile.W$i = 1";
$result2 = mysql_query($sql2);
$sql3 = "SELECT SUM($picksfile.C$i) from $picksfile, $totalstable
where $totalstable.MemberHandle = $picksfile.MemberHandle
and $totalstable.Place < 11 and $picksfile.W$i = 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[$i] = $roundavg;
$roundavg2 = round($absavg,0);
$conffull10[$i] = $roundavg2;
} else {
$confstring25 = "Even";
$confstring10 = "Even";
}
}
for ($i = 0; $i<=$numb_games-1; $i++) {
$pos1 = $i*2+2;
$pos2 = $i*2+3;
$Pick = $row[$pos1];
if ($Pick == 1) {
$Winner = $Team1[$i];
} else {
$Winner = $Team2[$i];
}
$Confidence = $row[$pos2];
$conf = $conffull[$i+1];
if (($conffullraw[$i+1] > 0)) {
$cteam = $Team2[$i];
$confstring = "$cteam $conf";
} elseif ($conffullraw[$i+1] < 0) {
$cteam = $Team1[$i];
$confstring = "$cteam $conf";
} else {
$confstring = "Even";
}
if ($contestweek != 1) {
$conf25 = $conffull25[$i+1];
if (($conffullraw25[$i+1] > 0)) {
$cteam = $Team2[$i];
$confstring25 = "$cteam $conf25";
} elseif ($conffullraw25[$i+1] < 0) {
$cteam = $Team1[$i];
$confstring25 = "$cteam $conf25";
} else {
$confstring25 = "Even";
}
$conf10 = $conffull10[$i+1];
if (($conffullraw10[$i+1] > 0)) {
$cteam = $Team2[$i];
$confstring10 = "$cteam $conf10";
} elseif ($conffullraw10[$i+1] < 0) {
$cteam = $Team1[$i];
$confstring10 = "$cteam $conf10";
} else {
$confstring10 = "Even";
}
}
if ($official == 1) {
if ($WinningTeam[$i] != 0) {
if ($Pick == $WinningTeam[$i]) {
$scoring = $Confidence;
$scoringcolor = "#000000";
$wins++;
} else {
$scoring = -1 * $Confidence;
$scoringcolor = "#FF0000";
$losses++;
}
} else {
$scoring = 0;
$scoringcolor = "#000000";
}
$TotalPoints = $TotalPoints + $scoring;
}
$ID = $i+1;
echo ("
| $Winner |
$Confidence |
$scoring |
");
}
//Finish Page
echo ("
");
if ($official == 1) {
echo ("
Week $weeknumb Totals: $TotalPoints points, $wins-$losses
");
}
echo ("
|
Individual
CFCC Picks
Latest
CFCC Standings
|