-8);
//$pacific_time = time() + ($tz['PST'] * 3600);
$tz = array ( 'EST' => -5);
$pacific_time = time() + ($tz['EST'] * 3600);
$lt = localtime($pacific_time, TRUE);
if ($lt['tm_isdst'])
$pacific_time += 3600;
$pacific_date=gmstrftime('%Y-%m-%d', $pacific_time);
list($y2, $m2, $d2) = split("-", $pacific_date);
$month=gmstrftime('%A', $pacific_time);
$pacific_time=gmstrftime('%T', $pacific_time);
$startdate=$pacific_date;
$enddate=$pacific_date;
$tagval=$val;
#---- create expiry date
$select =$val;
#---collect the league information
$leagueqry=mysql_query("select league_no,league_id,league_name from ats_league1 where league_name='$select' ");
list($lno,$lid,$lname)=mysql_fetch_array($leagueqry);
?>
| Cheatsheet :- |
The ATS Database Sports Betting Cheatsheet produces point spread statistics for sports bettors looking to get a statistical advantage against the point spread. Also, it provides certain records such as how a team does against the spread as a Home Favorite, Home Underdog, Road Favorite, Road Underdog, Over/Under, offense average, defense average, last 10 games and it tracks teams current season logs. Furthermore, it produces an expanded version on team's performances the last 2 and 3 years.
|
| Tip: Click on Team names to see their records at Home, Away, Overall,Home Underdog, Home Favorite, Road Underdog, Road Favorite and the O/U.
|
| LEAGUE : |
LEAGUE : |
| Legend |
Legend |
0)
{
$road_cris=$road_spread;
$home_cris=$game_total;
}
elseif($home_spread<0 && $road_spread>0)
{
$road_cris=$game_total;
$home_cris=$home_spread;
}
elseif($home_spread==0 && $road_spread==0)
{
$road_cris=$road_spread;
$home_cris=$game_total;
}
$home_cris=abs($home_cris);
$road_cris=abs($road_cris);
}
elseif($league=='5' || $league=='7') #--5 is league no for MLB & 7 is for NHL
{
if($home_ML<0 && $road_ML>0)
{
$home_cris=$home_ML;
$road_cris=$game_total;
}
elseif($home_ML>0 && $road_ML<0)
{
$home_cris=$game_total;
$road_cris=$road_ML;
}
elseif(($home_ML<0 && $road_ML<0) && ($home_ML!=$road_ML))
{
if($home_ML<$road_ML)
{
$home_cris=$home_ML;
$road_cris=$game_total;
}
elseif($home_ML>$road_ML)
{
$home_cris=$game_total;
$road_cris=$road_ML;
}
}
elseif(($home_ML<0 && $road_ML<0) && ($home_ML==$road_ML))
{
if($tot_undermoney<0 && $tot_overmoney>0)
{
$home_cris=$home_ML;
$road_cris=$game_total;
}
elseif($tot_undermoney>0 && $tot_overmoney<0)
{
$home_cris=$game_total;
$road_cris=$road_ML;
}
elseif(($tot_undermoney<0 && $tot_overmoney<0) && ($tot_undermoney!=$tot_overmoney))
{
if($tot_undermoney<$tot_overmoney)
{
$home_cris=$home_ML;
$road_cris=$game_total;
}
elseif($tot_undermoney>$tot_overmoney)
{
$home_cris=$game_total;
$road_cris=$road_ML;
}
}
elseif(($tot_undermoney<0 && $tot_overmoney<0) && ($tot_undermoney==$tot_overmoney))
{
if($home_spread<0 && $road_spread>0)
{
$home_cris=$home_ML;
$road_cris=$game_total;
}
elseif($home_spread>0 && $road_spread<0)
{
$home_cris=$game_total;
$road_cris=$road_ML;
}
elseif(($home_spread<0 && $road_spread<0) && ($home_spread!=$road_spread))
{
if($home_spread<$road_spread)
{
$home_cris=$home_ML;
$road_cris=$game_total;
}
elseif($home_spread>$road_spread)
{
$home_cris=$game_total;
$road_cris=$road_ML;
}
}
elseif(($home_spread<0 && $road_spread<0) && ($home_spread==$road_spread))
{
$home_cris='pk';
$road_cris='pk';
}
}#2nd main elseif
}#main elseif
}#end of elseif for league
if(preg_match("/'/",$road_team))
{
$road_team=addslashes($road_team);
}
#chk for mlb
if($table=='ncaaf_teams')
{
$rqry=mysql_query("select team_id,new_teamname,conference from $table where team_name='$road_team' or display_name='$road_team' or new_teamname='$road_team' or score_teamname='$road_team' ") or die("Query" .mysql_error());
}
else
{
$rqry=mysql_query("select team_id,new_teamname,conference from $table where team_name='$road_team' or display_name='$road_team' or new_teamname='$road_team' ") or die("Query" .mysql_error());
}
list($road_teamid,$road_team,$road_conf)=mysql_fetch_array($rqry);
if(preg_match("/'/",$home_team))
{
$home_team=addslashes($home_team);
}
if($table=='ncaaf_teams')
{
$hqry=mysql_query("select team_id,new_teamname,conference from $table where team_name='$home_team' or display_name='$home_team' or new_teamname='$home_team' or score_teamname='$home_team' ") or die("Query" .mysql_error());
}
else
{
$hqry=mysql_query("select team_id,new_teamname,conference from $table where team_name='$home_team' or display_name='$home_team' or new_teamname='$home_team'");
}
list($home_teamid,$home_team,$home_conf)=mysql_fetch_array($hqry);
$roadrpg=mysql_query("select overall_off_avg, overall_def_avg, win_loss_tie,ATSwin_loss_tie, over_under_push, lefties_win_loss_tie ,lefties_over_under_push ,righties_win_loss_tie, righties_over_under_push from ats_averages where league_name='$select' and team_id='$road_teamid'"); list($road_rpg,$road_rag,$road_wlt,$road_ATSwlt,$road_oup,$road_leftwlt,$road_leftoup,$road_rightwlt,$road_rightoup)
=mysql_fetch_array($roadrpg);
$roadwltrecord=explode("_",$road_wlt);
$road_WL=$roadwltrecord[0].'-'.$roadwltrecord[1];
$road_ATSwltrecord=explode("_",$road_ATSwlt);
$road_ATSWL=$road_ATSwltrecord[0].'-'.$road_ATSwltrecord[1];
$roadouprecord=explode("_",$road_oup);
$road_OU=$roadouprecord[0].'-'.$roadouprecord[1];
$road_totalgame=$roadwltrecord[0]+$roadwltrecord[1]+$roadwltrecord[2];
#--ROAD LEFT WLT
$roadleft_wltrecord=explode("_",$road_leftwlt);
$road_leftWL=$roadleft_wltrecord[0].'-'.$roadleft_wltrecord[1];
#--ROAD LEFT OUP
$roadleft_ouprecord=explode("_",$road_leftoup);
$road_leftOU=$roadleft_ouprecord[0].'-'.$roadleft_ouprecord[1];
#--ROAD RIGHT WLT
$roadright_wltrecord=explode("_",$road_rightwlt);
$road_rightWL=$roadright_wltrecord[0].'-'.$roadright_wltrecord[1];
#--ROAD RIGHT OUP
$roadright_ouprecord=explode("_",$road_rightoup);
$road_rightOU=$roadright_ouprecord[0].'-'.$roadright_ouprecord[1];
$roadlast23qry=mysql_query("select L2Y_WLT_OUP, L2Y_avg, L3Y_WLT_OUP, L3Y_avg,last10_WLT,last10_ATSWLT,last10_OUP from ats_fastfacts where league_name='$select' and team_id='$road_teamid'");
list($road_l2wlt_oup,$road_l2avg,$road_l3wlt_oup,$road_l3avg,$road_last10wlt,$road_last10atswlt,$road_last10oup) =mysql_fetch_array($roadlast23qry);
# LAST 2
$road2wltouprecord=explode("~",$road_l2wlt_oup);
$road_last2wlt=$road2wltouprecord[0];
$road_last2oup=$road2wltouprecord[1];
$road_last2wltrecord=explode("-",$road_last2wlt);
$roadlast2_WL=$road_last2wltrecord[0].'-'.$road_last2wltrecord[1];
$road_last2ouprecord=explode("-",$road_last2oup);
$roadlast2_OU=$road_last2ouprecord[0].'-'.$road_last2ouprecord[1];
$road_l2avgrec=explode("~",$road_l2avg);
$road_last2off=$road_l2avgrec[0];
$road_last2def=$road_l2avgrec[1];
# LAST 3
$road3wltouprecord=explode("~",$road_l3wlt_oup);
$road_last3wlt=$road3wltouprecord[0];
$road_last3oup=$road3wltouprecord[1];
$road_last3wltrecord=explode("-",$road_last3wlt);
$roadlast3_WL=$road_last3wltrecord[0].'-'.$road_last3wltrecord[1];
$road_last3ouprecord=explode("-",$road_last3oup);
$roadlast3_OU=$road_last3ouprecord[0].'-'.$road_last3ouprecord[1];
$road_l3avgrec=explode("~",$road_l3avg);
$road_last3off=$road_l3avgrec[0];
$road_last3def=$road_l3avgrec[1];
$road_last10wltrec=explode("-",$road_last10wlt);
$road_last10WL=$road_last10wltrec[0].'-'.$road_last10wltrec[1];
$road_last10atswltrec=explode("-",$road_last10atswlt);
$road_last10ATSWL=$road_last10atswltrec[0].'-'.$road_last10atswltrec[1];
$road_last10ouprec=explode("-",$road_last10oup);
$road_last10OU=$road_last10ouprec[0].'-'.$road_last10ouprec[1];
$homerpg=mysql_query("select overall_off_avg, overall_def_avg, win_loss_tie,ATSwin_loss_tie, over_under_push, lefties_win_loss_tie, righties_win_loss_tie ,lefties_over_under_push , righties_over_under_push from ats_averages where league_name='$select' and team_id='$home_teamid'"); list($home_rpg,$home_rag,$home_wlt,$home_atswlt,$home_oup,$home_leftwlt,$home_rightwlt,$home_leftoup,$home_rightoup)
=mysql_fetch_array($homerpg);
#--HOme WLT
$homewltrecord=explode("_",$home_wlt);
$home_WL=$homewltrecord[0].'-'.$homewltrecord[1];
$homeatswltrecord=explode("_",$home_atswlt);
$home_ATSWL=$homeatswltrecord[0].'-'.$homeatswltrecord[1];
#--HOme OUP
$homeouprecord=explode("_",$home_oup);
$home_OU=$homeouprecord[0].'-'.$homeouprecord[1];
#--HOme total Game for WLT
$home_totalgame=$homewltrecord[0]+$homewltrecord[1]+$homewltrecord[2];
#--HOme LEFT WLT
$homeleft_wltrecord=explode("_",$home_leftwlt);
$home_leftWL=$homeleft_wltrecord[0].'-'.$homeleft_wltrecord[1];
#--HOme LEFT OUP
$homeleft_ouprecord=explode("_",$home_leftoup);
$home_leftOU=$homeleft_ouprecord[0].'-'.$homeleft_ouprecord[1];
#--HOme RIGHT WLT
$homeright_wltrecord=explode("_",$home_rightwlt);
$home_rightWL=$homeright_wltrecord[0].'-'.$homeright_wltrecord[1];
#--HOme RIGHT OUP
$homeright_ouprecord=explode("_",$home_rightoup);
$home_rightOU=$homeright_ouprecord[0].'-'.$homeright_ouprecord[1];
if($select=='MLB')
{
#---Pitchers WL & OU count
$roadpitrpg=mysql_query("select overall_off_avg, overall_def_avg, win_loss_tie, over_under_push from db2_pitchers_averages where pitcher_id='$roadteam_pitid'");
list($roadpit_rpg,$roadpit_rag,$roadpit_wlt,$roadpit_oup)=mysql_fetch_array($roadpitrpg);
if($roadpit_rpg=='')
{
$roadpit_rpg='-';
}
if($roadpit_rag=='')
{
$roadpit_rag='-';
}
$roadpitwltrecord=explode("_",$roadpit_wlt);
$roadpit_WL=$roadpitwltrecord[0].'-'.$roadpitwltrecord[1];
$roadpitouprecord=explode("_",$roadpit_oup);
$roadpit_OU=$roadpitouprecord[0].'-'.$roadpitouprecord[1];
$roadpit_totalgame=$roadpitwltrecord[0]+$roadpitwltrecord[1]+$roadpitwltrecord[2];
$roadpitlast23qry=mysql_query("select L2Y_WLT_OUP, L2Y_avg, L3Y_WLT_OUP, L3Y_avg from db2_mlb_pitchers where pitcher_id='$roadteam_pitid' ");
list($roadpit_l2wlt_oup,$roadpit_l2avg,$roadpit_l3wlt_oup,$roadpit_l3avg)=mysql_fetch_array($roadpitlast23qry);
$roadpit_L2WLTOUP=explode("~",$roadpit_l2wlt_oup);
$roadpit_L2WLT=$roadpit_L2WLTOUP[0];
$roadpit_L2Winloss=explode("-",$roadpit_L2WLT);
$roadpit_L2WL=$roadpit_L2Winloss[0].' - '.$roadpit_L2Winloss[1];
$roadpit_L2OUP=$roadpit_L2WLTOUP[1];
$roadpit_L2Overunder=explode("-",$roadpit_L2OUP);
$roadpit_L2OU=$roadpit_L2Overunder[0].' - '.$roadpit_L2Overunder[1];
$roadpit_L2avg=explode("~",$roadpit_l2avg);
$roadpit_L2offavg=$roadpit_L2avg[0];
$roadpit_L2defavg=$roadpit_L2avg[1];
$roadpit_L3WLTOUP=explode("~",$roadpit_l3wlt_oup);
$roadpit_L3WLT=$roadpit_L3WLTOUP[0];
$roadpit_L3Winloss=explode("-",$roadpit_L3WLT);
$roadpit_L3WL=$roadpit_L3Winloss[0].' - '.$roadpit_L3Winloss[1];
$roadpit_L3OUP=$roadpit_L3WLTOUP[1];
$roadpit_L3Overunder=explode("-",$roadpit_L3OUP);
$roadpit_L3OU=$roadpit_L3Overunder[0].' - '.$roadpit_L3Overunder[1];
$roadpit_L3avg=explode("~",$roadpit_l3avg);
$roadpit_L3offavg=$roadpit_L3avg[0];
$roadpit_L3defavg=$roadpit_L3avg[1];
$homepitrpg=mysql_query("select overall_off_avg, overall_def_avg, win_loss_tie, over_under_push from db2_pitchers_averages where pitcher_id='$hometeam_pitid'");
list($homepit_rpg,$homepit_rag, $homepit_wlt,$homepit_oup) =mysql_fetch_array($homepitrpg);
if($homepit_rpg=='')
{
$homepit_rpg='-';
}
if($homepit_rag=='')
{
$homepit_rag='-';
}
$homepitwltrecord=explode("_",$homepit_wlt);
$homepit_WL=$homepitwltrecord[0].'-'.$homepitwltrecord[1];
$homepit_totalgame=$homepitwltrecord[0]+$homepitwltrecord[1]+$homepitwltrecord[2];
$homepitouprecord=explode("_",$homepit_oup);
$homepit_OU=$homepitouprecord[0].'-'.$homepitouprecord[1];
$homepitlast23qry=mysql_query("select L2Y_WLT_OUP, L2Y_avg, L3Y_WLT_OUP, L3Y_avg from db2_mlb_pitchers where pitcher_id='$hometeam_pitid' ");
list($homepit_l2wlt_oup,$homepit_l2avg,$homepit_l3wlt_oup,$homepit_l3avg)=mysql_fetch_array($homepitlast23qry);
$homepit_L2WLTOUP=explode("~",$homepit_l2wlt_oup);
$homepit_L2WLT=$homepit_L2WLTOUP[0];
$homepit_L2Winloss=explode("-",$homepit_L2WLT);
$homepit_L2WL=$homepit_L2Winloss[0].' - '.$homepit_L2Winloss[1];
$homepit_L2OUP=$homepit_L2WLTOUP[1];
$homepit_L2Overunder=explode("-",$homepit_L2OUP);
$homepit_L2OU=$homepit_L2Overunder[0].' - '.$homepit_L2Overunder[1];
$homepit_L2avg=explode("~",$homepit_l2avg);
$homepit_L2offavg=$homepit_L2avg[0];
$homedpit_L2defavg=$homepit_L2avg[1];
$homepit_L3WLTOUP=explode("~",$homepit_l3wlt_oup);
$homepit_L3WLT=$homepit_L3WLTOUP[0];
$homepit_L3Winloss=explode("-",$homepit_L3WLT);
$homepit_L3WL=$homepit_L3Winloss[0].' - '.$homepit_L3Winloss[1];
$homepit_L3OUP=$homepit_L3WLTOUP[1];
$homepit_L3Overunder=explode("-",$homepit_L3OUP);
$homepit_L3OU=$homepit_L3Overunder[0].' - '.$homepit_L3Overunder[1];
$homepit_L3avg=explode("~",$homepit_l3avg);
$homepit_L3offavg=$homepit_L3avg[0];
$homepit_L3defavg=$homepit_L3avg[1];
if($homepit_L2offavg=='')
{ $homepit_L2offavg='N/A'; }
if($homepit_L2defavg=='')
{ $homepit_L2defavg='N/A'; }
if($homepit_L3offavg=='')
{ $homepit_L3offavg='N/A'; }
if($homepit_L3defavg=='')
{ $homepit_L3defavg='N/A'; }
}
$homelast23qry=mysql_query("select L2Y_WLT_OUP, L2Y_avg, L3Y_WLT_OUP, L3Y_avg, last10_WLT,last10_ATSWLT,last10_OUP from ats_fastfacts where league_name='$select' and team_id='$home_teamid'");list($home_l2wlt_oup,$home_l2avg,$home_l3wlt_oup,$home_l3avg,$home_last10wlt,$home_last10atswlt,$home_last10oup)=mysql_fetch_array($homelast23qry);
$homewlt2ouprecord=explode("~",$home_l2wlt_oup);
$home_last2wlt=$homewlt2ouprecord[0];
$home_last2oup=$homewlt2ouprecord[1];
$home_last2wltrecord=explode("-",$home_last2wlt);
$homelast2_WL=$home_last2wltrecord[0].'-'.$home_last2wltrecord[1];
$home_last2ouprecord=explode("-",$home_last2oup);
$homelast2_OU=$home_last2ouprecord[0].'-'.$home_last2ouprecord[1];
$home_l2avgrec=explode("~",$home_l2avg);
$home_last2off=$home_l2avgrec[0];
$home_last2def=$home_l2avgrec[1];
$homewlt3ouprecord=explode("~",$home_l3wlt_oup);
$home_last3wlt=$homewlt3ouprecord[0];
$home_last3oup=$homewlt3ouprecord[1];
$home_last3wltrecord=explode("-",$home_last3wlt);
$homelast3_WL=$home_last3wltrecord[0].'-'.$home_last3wltrecord[1];
$home_last3ouprecord=explode("-",$home_last3oup);
$homelast3_OU=$home_last3ouprecord[0].'-'.$home_last3ouprecord[1];
$home_l3avgrec=explode("~",$home_l3avg);
$home_last3off=$home_l3avgrec[0];
$home_last3def=$home_l3avgrec[1];
$home_last10wltrec=explode("-",$home_last10wlt);
$home_last10WL=$home_last10wltrec[0].'-'.$home_last10wltrec[1];
$home_last10atswltrec=explode("-",$home_last10atswlt);
$home_last10ATSWL=$home_last10atswltrec[0].'-'.$home_last10atswltrec[1];
$home_last10ouprec=explode("-",$home_last10oup);
$home_last10OU=$home_last10ouprec[0].'-'.$home_last10ouprec[1];
#chk for blank data
if(trim($road_team)!="" && trim($home_team)!="")
{
$road_team=ucwords(strtolower($road_team));
$home_team=ucwords(strtolower($home_team));
if($road_team=='Texas A&m Aggies')
{ $road_team='Texas A&M Aggies';
$road_team11='Texas A^M Aggies';
}
else
{
$road_team11=$road_team;
}
if($home_team=='Texas A&m Aggies')
{
$home_team='Texas A&M Aggies';
$home_team11='Texas A^M Aggies';
}
else
{
$home_team11=$home_team;
}
?>
|
|
| Teams |
Line |
SU-W/L |
ATS-W/L |
O/U |
RPG |
RAG |
GPG |
GAG |
PPG |
PAG |
(Vs. L) W/L |
(Vs. L) O/U |
(Vs. R) W/L |
(Vs. R) O/U |
(L10)SU-W/L |
(L10)ATS-W/L |
(L10)O/U |
Pitchers |
W/L |
O/U |
RPG |
RAG |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
()
()
|
|
|
|
|
|
Expanded L2Y /L3Y Matchups |
Expanded L2Y /L3Y Matchups |
Expanded L2Y /L3Y Matchups |
| No Matches Found For Current Date |
| No Matches Found For Current Date |
| LEAGUE : |
| No Cheatsheet Found |
|
|
