Final Score Tracker :-

Now you can track how much a team wins or loses by with our new Final Score Tracker! Have you ever noticed how a certain team will win or lose by xx amount of points at home or on the road; now you will be able to keep track of their record! Parity has made the games much closer and the line should help you decided on how close a game should be decided by and the Final Score Tracker can help you make an educated decision. *Note: The NFL, CFL and CFB have 3 years of data recorded and displayed. Plus, any stat that has a 56% or higher percentage will be “highlighted” in a yellow background.

Final Score Tracker For

To see Final Score Tracker: Click Here

CFL |

NFL |

MLB |

NBA |

NHL |

CFB |

='08') $curr_y=date('Y'); else $curr_y=date('Y')-1; $prev_y=$curr_y-3; $next_year=$curr_y+1; //echo "curr_y+$curr_y ***next_year=$next_year
"; if($league=='NFL') { $start_month='09' ;$end_month='02'; $end_date=$next_year.'-'.$end_month; } elseif($league=='CFL') { $start_month='06' ;$end_month='11'; $end_date=$curr_y.'-'.$end_month; } elseif($league=='NCAAF') { $start_month='08' ;$end_month='02'; $end_date=$next_year.'-'.$end_month; } $start_date=$prev_y.'-'.$start_month; //$end_date=$curr_y.'-'.$end_month; $today_date=date('Y-m-d'); $dateclause="(( left(date,7) between '$start_date' and '$end_date') and date<'$today_date' )"; //echo "dateclause=$dateclause
"; } $data_table=strtolower($league).'_data1'; if($league!='MLB') { $clause="(home_id='$teamid' or road_id='$teamid')"; } else { $clause="(home='$teamid' or road='$teamid')"; } $i='0';$totalgoals='0';$onegoal='0';$twogoal='0';$threegoal='0';$fourgoal='0';$totgoalval='0'; $onegoal_won='0';$twogoal_won='0';$threegoal_won='0';$fourgoal_won='0'; $onegoal_lost='0';$twogoal_lost='0';$threegoal_lost='0';$fourgoal_lost='0'; $road_1goal='0';$road_2goal='0';$road_3goal='0';$road_4goal='0'; $onegoal_roadavg='0';$twogoal_roadavg='0';$threegoal_roadavg='0';$fourgoal_roadavg='0'; $roadwon_1goal='0';$roadlost_1goal='0';$roadwon_2goal='0';$roadlost_2goal='0';$roadwon_3goal='0'; $roadlost_3goal='0';$roadwon_4goal='0';$roadlost_4goal='0';$totroad_goalval='0'; $home_1goal='0';$home_2goal='0';$home_3goal='0';$home_4goal='0'; $onegoal_homeavg='0';$twogoal_homeavg='0';$threegoal_homeavg='0';$fourgoal_homeavg='0'; $homewon_1goal='0';$homelost_1goal='0';$homewon_2goal='0';$homelost_2goal='0'; $homewon_3goal='0';$homelost_3goal='0';$homewon_4goal='0';$homelost_4goal='0';$tothome_goalval='0'; //echo "select * from $data_table where $dateclause and $clause
"; $select=mysql_query("select * from $data_table where $dateclause and $clause "); while($row=mysql_fetch_array($select)) { $i++; $date=$row['date']; if($league=='MLB') { $home_id=$row['home']; $road_id=$row['road']; $SUwinner_id=$row['SUwinner']; }else { $home=$row['home']; $home_id=$row['home_id']; $road=$row['road']; $road_id=$row['road_id']; $SUwinner=$row['SUwinner']; $SUwinner_id=$row['SUwinner_id']; } $homescore=$row['homescore']; $roadscore=$row['roadscore']; $tot_goals=$homescore+$roadscore; $totalgoals=$totalgoals+$tot_goals; //echo "home_id=$home_id * teamid=$teamid
"; if($home_id==$teamid) { //$teamname=$home; $diff=$homescore - $roadscore; $diff1=abs($diff); if($league=='NFL' || $league=='CFL' || $league=='NCAAF' || $league=='NBA') {//0 to 3.0 3.5 to 6.5 7.0 to 9.5 if($diff1>='0' && $diff1<='3.0') { $home_1goal++; if($SUwinner_id==$home_id) { $homewon_1goal++; } else { $homelost_1goal++; } } elseif($diff1>='3.5' && $diff1<='6.5') { $home_2goal++; if($SUwinner_id==$home_id) { $homewon_2goal++; } else { $homelost_2goal++; } } elseif($diff1>='7.0' && $diff1<='9.5') { $home_3goal++; if($SUwinner_id==$home_id) { $homewon_3goal++; } else { $homelost_3goal++; } } elseif($diff1>='10') { $home_4goal++; if($SUwinner_id==$home_id) { $homewon_4goal++; } else { $homelost_4goal++; } } } else { if($diff1=='1') { $home_1goal++; if($SUwinner_id==$home_id) { $homewon_1goal++; } else { $homelost_1goal++; } } elseif($diff1=='2') { $home_2goal++; if($SUwinner_id==$home_id) { $homewon_2goal++; } else { $homelost_2goal++; } } elseif($diff1=='3') { $home_3goal++; if($SUwinner_id==$home_id) { $homewon_3goal++; } else { $homelost_3goal++; } } elseif($diff1>='4') { $home_4goal++; if($SUwinner_id==$home_id) { $homewon_4goal++; } else { $homelost_4goal++; } } } } else { $diff= $roadscore - $homescore; $diff1=abs($diff); if($league=='NFL' || $league=='CFL' || $league=='NCAAF' || $league=='NBA') {//0 to 3.0 3.5 to 6.5 7.0 to 9.5 if($diff1>='0' && $diff1<='3.0') { $road_1goal++; if($SUwinner_id==$road_id) { $roadwon_1goal++; } else { $roadlost_1goal++; } } elseif($diff1>='3.5' && $diff1<='6.5') { $road_2goal++; if($SUwinner_id==$road_id) { $roadwon_2goal++; } else { $roadlost_2goal++; } } elseif($diff1>='7.0' && $diff1<='9.5') { $road_3goal++; if($SUwinner_id==$road_id) { $roadwon_3goal++; } else { $roadlost_3goal++; } } elseif($diff1>='10') { $road_4goal++; if($SUwinner_id==$road_id) { $roadwon_4goal++; } else { $roadlost_4goal++; } } } else { if($diff1=='1') { $road_1goal++; if($SUwinner_id==$road_id) { $roadwon_1goal++; } else { $roadlost_1goal++; } } elseif($diff1=='2') { $road_2goal++; if($SUwinner_id==$road_id) { $roadwon_2goal++; } else { $roadlost_2goal++; } } elseif($diff1=='3') { $road_3goal++; if($SUwinner_id==$road_id) { $roadwon_3goal++; } else { $roadlost_3goal++; } } elseif($diff1>='4') { $road_4goal++; if($SUwinner_id==$road_id) { $roadwon_4goal++; } else { $roadlost_4goal++; } } }#else if($league=='NFL' || $league=='CFL' || $league=='NCAAF') }#else }#while ##HOME $tothome_wongoal=$homewon_1goal+$homewon_2goal+$homewon_3goal+$homewon_4goal; $tothome_lostgoal=$homelost_1goal+$homelost_2goal+$homelost_3goal+$homelost_4goal; $tothome_goalval=$home_1goal+$home_2goal+$home_3goal+$home_4goal; ##ROAD $totroad_wongoal=$roadwon_1goal+$roadwon_2goal+$roadwon_3goal+$roadwon_4goal; $totroad_lostgoal=$roadlost_1goal+$roadlost_2goal+$roadlost_3goal+$roadlost_4goal; $totroad_goalval=$road_1goal+$road_2goal+$road_3goal+$road_4goal; $tot_goalval=$tothome_goalval+$totroad_goalval; $totwon_1goal=$homewon_1goal+$roadwon_1goal; $totwon_2goal=$homewon_2goal+$roadwon_2goal; $totwon_3goal=$homewon_3goal+$roadwon_3goal; $totwon_4goal=$homewon_4goal+$roadwon_4goal; $totlost_1goal=$homelost_1goal+$roadlost_1goal; $totlost_2goal=$homelost_2goal+$roadlost_2goal; $totlost_3goal=$homelost_3goal+$roadlost_3goal; $totlost_4goal=$homelost_4goal+$roadlost_4goal; ##TOTAL $total_1goal=$home_1goal+$road_1goal; //echo "total_1goal=$total_1goal
"; $total_2goal=$home_2goal+$road_2goal; $total_3goal=$home_3goal+$road_3goal; $total_4goal=$home_4goal+$road_4goal; $totgoalval=$total_1goal+$total_2goal+$total_3goal+$total_4goal; //echo "totgoalval=$totgoalval ** $i
"; if($i!='0') { $totgoal_avg=$totalgoals/$i; } else { $totgoal_avg='0'; } //echo "totgoal_avg=$totgoal_avg
"; if($totgoalval!='0') { //echo "total_1goal=$total_1goal ** totgoalval=$totgoalval total_2goal=$total_2goal total_3goal=$total_3goal total_4goal=$total_4goal
"; $onegoal_avg=round(($total_1goal/$totgoalval)*100,2); $twogoal_avg=round(($total_2goal/$totgoalval)*100,2); $threegoal_avg=round(($total_3goal/$totgoalval)*100,2); $fourgoal_avg=round(($total_4goal/$totgoalval)*100,2); } else { $onegoal_avg='0'; $twogoal_avg='0'; $threegoal_avg='0'; $fourgoal_avg='0'; } if($tothome_goalval!='0') {//echo "tothome_goalval $onegoal_homeavg=round(($home_1goal/$tothome_goalval)*100,2); $twogoal_homeavg=round(($home_2goal/$tothome_goalval)*100,2); $threegoal_homeavg=round(($home_3goal/$tothome_goalval)*100,2); $fourgoal_homeavg=round(($home_4goal/$tothome_goalval)*100,2); } else { $onegoal_homeavg='0'; $twogoal_homeavg='0'; $threegoal_homeavg='0'; $fourgoal_homeavg='0'; } if($totroad_goalval!='0') { $onegoal_roadavg=round(($road_1goal/$totroad_goalval)*100,2); $twogoal_roadavg=round(($road_2goal/$totroad_goalval)*100,2); $threegoal_roadavg=round(($road_3goal/$totroad_goalval)*100,2); $fourgoal_roadavg=round(($road_4goal/$totroad_goalval)*100,2); } else { $onegoal_roadavg='0'; $twogoal_roadavg='0'; $threegoal_roadavg='0'; $fourgoal_roadavg='0'; } $returnval=$total_1goal.'~'.$onegoal_avg.'~'.$totwon_1goal.'~'.$totlost_1goal.'~'.$total_2goal.'~'.$twogoal_avg.'~'.$totwon_2goal.'~'.$totlost_2goal.'~'.$total_3goal.'~'. $threegoal_avg .'~'.$totwon_3goal.'~'.$totlost_3goal.'~'.$total_4goal .'~'. $fourgoal_avg.'~'. $totwon_4goal.'~'.$totlost_4goal.'~'. $totgoalval.'~'.$home_1goal.'~'. $onegoal_homeavg.'~'. $homewon_1goal.'~'.$homelost_1goal.'~'. $home_2goal.'~'.$twogoal_homeavg.'~'. $homewon_2goal.'~'. $homelost_2goal.'~'.$home_3goal.'~'.$threegoal_homeavg.'~'.$homewon_3goal.'~'.$homelost_3goal.'~'.$home_4goal.'~'.$fourgoal_homeavg .'~'.$homewon_4goal .'~'.$homelost_4goal .'~'.$tothome_goalval .'~'.$road_1goal .'~'.$onegoal_roadavg.'~'.$roadwon_1goal.'~'.$roadlost_1goal.'~'.$road_2goal.'~'.$twogoal_roadavg.'~'.$roadwon_2goal.'~'.$roadlost_2goal.'~'.$road_3goal.'~'.$threegoal_roadavg.'~'.$roadwon_3goal.'~'.$roadlost_3goal.'~'.$road_4goal.'~'.$fourgoal_roadavg.'~'.$roadwon_4goal.'~'.$roadlost_4goal.'~'.$totroad_goalval; //echo "returnval=$returnval
"; return $returnval; } $teamtable=strtolower($league).'_teams'; $select =mysql_query("select team_name from $teamtable order by team_name "); $selnum=mysql_num_rows($select); ?>

Search Team :- ----Select----

='08') $cur_year=date('Y'); else $cur_year=date('Y')-1; $next_year=$cur_year+1; } else { $cur_year=date('Y'); } if($league=='NFL') { $start_month='09' ;$end_month='02'; $end_date=$next_year.'-'.$end_month; } elseif($league=='NBA') { $start_month='10' ;$end_month='06'; $end_date=$next_year.'-'.$end_month; } elseif($league=='MLB') { $start_month='03' ;$end_month='10'; $end_date=$cur_year.'-'.$end_month; } elseif($league=='NHL') { $start_month='09' ;$end_month='06'; $end_date=$next_year.'-'.$end_month; } elseif($league=='CFL') { $start_month='06' ;$end_month='11'; $end_date=$cur_year.'-'.$end_month; } elseif($league=='NCAAF') { $start_month='08' ;$end_month='02'; $end_date=$next_year.'-'.$end_month; } elseif($league=='NCAAB') { $start_month='10' ;$end_month='04'; $end_date=$next_year.'-'.$end_month; } $start_date=$cur_year.'-'.$start_month; $dateclause="( left(date,7) between '$start_date' and '$end_date' )"; switch($league) { case 'NHL': $j='32'; $runval='goal'; break; case 'MLB': $j='31'; $runval='run'; break; case 'NBA': $j='31'; $runval='points'; break; case 'CFL': $j='9'; $runval='points'; break; case 'NFL': $j='33'; $runval='points'; break; case 'NCAAF': $j='121'; $runval='points'; break; } if($league=='NFL' || $league=='CFL' || $league=='NCAAF' || $league=='NBA') { $oneval='0 to 3.0'; $twoval='3.5 to 6.5'; $threeval='7.0 to 9.5'; $fourval='10 or more'; }else { $oneval='1'; $twoval='2'; $threeval='3'; $fourval='4 or more'; } for ($i='1';$i<$j;$i++) { if($league=='NHL') { if($i=='6') { $i++; } } if($league=='CFL') { if($i=='2') { $i++; } } echo "

Top Of The Page

"; $getteamname=mysql_query("select team_name from $teamtable where team_id='$i'"); list($teamname)=mysql_fetch_array($getteamname); $returnvar=getgoalval($league,$i,$dateclause); $retunarray=explode("~",trim($returnvar)); $total_1goal=$retunarray[0]; $onegoal_avg=$retunarray[1]; $totwon_1goal=$retunarray[2]; $totlost_1goal=$retunarray[3]; $total_2goal=$retunarray[4]; $twogoal_avg=$retunarray[5]; $totwon_2goal=$retunarray[6]; $totlost_2goal=$retunarray[7]; $total_3goal=$retunarray[8]; $threegoal_avg=$retunarray[9]; $totwon_3goal=$retunarray[10]; $totlost_3goal=$retunarray[11]; $total_4goal=$retunarray[12]; $fourgoal_avg=$retunarray[13]; $totwon_4goal=$retunarray[14]; $totlost_4goal=$retunarray[15]; $totgoalval=$retunarray[16]; $home_1goal=$retunarray[17]; $onegoal_homeavg=$retunarray[18]; $homewon_1goal=$retunarray[19]; $homelost_1goal=$retunarray[20]; $home_2goal=$retunarray[21]; $twogoal_homeavg=$retunarray[22]; $homewon_2goal=$retunarray[23]; $homelost_2goal=$retunarray[24]; $home_3goal=$retunarray[25]; $threegoal_homeavg=$retunarray[26]; $homewon_3goal=$retunarray[27]; $homelost_3goal=$retunarray[28]; $home_4goal=$retunarray[29]; $fourgoal_homeavg=$retunarray[30]; $homewon_4goal=$retunarray[31]; $homelost_4goal=$retunarray[32]; $tothome_goalval=$retunarray[33]; $road_1goal=$retunarray[34]; $onegoal_roadavg=$retunarray[35]; $roadwon_1goal=$retunarray[36]; $roadlost_1goal=$retunarray[37]; $road_2goal=$retunarray[38]; $twogoal_roadavg=$retunarray[39]; $roadwon_2goal=$retunarray[40]; $roadlost_2goal=$retunarray[41]; $road_3goal=$retunarray[42]; $threegoal_roadavg=$retunarray[43]; $roadwon_3goal=$retunarray[44]; $roadlost_3goal=$retunarray[45]; $road_4goal=$retunarray[46]; $fourgoal_roadavg=$retunarray[47]; $roadwon_4goal=$retunarray[48]; $roadlost_4goal=$retunarray[49]; $totroad_goalval=$retunarray[50]; //echo "onegoal_avg=$onegoal_avg
"; if($onegoal_avg >="56.00") {$bgval1="bgcolor='#FFFF33'";}else{$bgval1="bgcolor='#FFFFFF'";} if($twogoal_avg >="56.00") {$bgval4="bgcolor='#FFFF33'";}else{$bgval4="bgcolor='#FFFFFF'";} if($threegoal_avg >="56.00") {$bgval7="bgcolor='#FFFF33'";}else{$bgval7="bgcolor='#FFFFFF'";} if($fourgoal_avg >="56.00") {$bgval10="bgcolor='#FFFF33'";}else{$bgval10="bgcolor='#FFFFFF'";} if($onegoal_homeavg >="56.00") {$bgval2="bgcolor='#FFFF33'";}else{$bgval2="bgcolor='#e0e0e0'";} if($twogoal_homeavg >="56.00" ) {$bgval5="bgcolor='#FFFF33'";}else{$bgval5="bgcolor='#e0e0e0'";} if($threegoal_homeavg >="56.00") {$bgval8="bgcolor='#FFFF33'";}else{$bgval8="bgcolor='#e0e0e0'";} if($fourgoal_homeavg >="56.00") {$bgval11="bgcolor='#FFFF33'";}else{$bgval11="bgcolor='#e0e0e0'";} if($onegoal_roadavg >="56.00" ) {$bgval3="bgcolor='#FFFF33'";}else{$bgval3="bgcolor='#FFFFFF'";} if($twogoal_roadavg >="56.00" ) {$bgval6="bgcolor='#FFFF33'";}else{$bgval6="bgcolor='#FFFFFF'";} if( $threegoal_roadavg >="56.00") {$bgval9="bgcolor='#FFFF33'";}else{$bgval9="bgcolor='#FFFFFF'";} if($fourgoal_roadavg >="56.00") {$bgval12="bgcolor='#FFFF33'";}else{$bgval12="bgcolor='#FFFFFF'";} $msg="

Final Score Tracker For $teamname

Situations

Teams Home/Road Games

Teams Home Games

Teams Road Games

Situations

No of Games

%

Won

Lost

No of Games

%

Won

Lost

No of Games

%

Won

Lost

$oneval $runval games

$total_1goal

$onegoal_avg%

$totwon_1goal

$totlost_1goal

$home_1goal

$onegoal_homeavg%

$homewon_1goal

$homelost_1goal

$road_1goal

$onegoal_roadavg%

$roadwon_1goal

$roadlost_1goal

$twoval $runval games

$total_2goal

$twogoal_avg%

$totwon_2goal

$totlost_2goal

$home_2goal

$twogoal_homeavg%

$homewon_2goal

$homelost_2goal

$road_2goal

$twogoal_roadavg%

$roadwon_2goal

$roadlost_2goal

$threeval $runval games

$total_3goal

$threegoal_avg%

$totwon_3goal

$totlost_3goal

$home_3goal

$threegoal_homeavg%

$homewon_3goal

$homelost_3goal

$road_3goal

$threegoal_roadavg%

$roadwon_3goal

$roadlost_3goal

$fourval $runval games

$total_4goal

$fourgoal_avg%

$totwon_4goal

$totlost_4goal

$home_4goal

$fourgoal_homeavg%

$homewon_4goal

$homelost_4goal

$road_4goal

$fourgoal_roadavg%

$roadwon_4goal

$roadlost_4goal

$totgoalval

$tothome_goalval

$totroad_goalval

"; echo "$msg
"; }?>