Please Wait !!!!! LOADING...................

"; #Green Star Image Path $star1="

"; #Blue Star Image Path $star2="

"; #Red Star Image Path $star3="

"; ?>

Print

ATS Matchups :-

The following stars summary report is based on the 4 ATS DATABASE main stats matchups section and we've accumulated and produced each section final report. Basically, every star rated stats is now calculated and produced on one summary sheet.

LEAGUE:

O/U:

Pitcher : ()

Vs.

Date:
Time:

O/U:

Pitcher :()

Star System : 35% or lower = 60%-79%= 80%-100%=

Navigation : Head To Head | Quick Stats | Smart Stats | SOS | Stars Report

You Are Here STARS REPORT

Jump to Game

='10') { $h2hstar1_sideval=$h2hstar1_sideval.'~'.$team1_star1_arr[0]; } if($su_csum1>='10') { $h2hstar1_sideval=$h2hstar1_sideval.'~'.$team1_star1_arr[1]; } if($ou_csum1>='10') { if($team1_over_per>$team1_under_per) { if($team1_star1_arr[2]=='1') { $team1_h2h_Rovercount++; } elseif($team1_star1_arr[2]=='2') { $team1_h2h_Govercount++; } elseif($team1_star1_arr[2]=='3') { $team1_h2h_Bovercount++; } $h2hstar1_totval=$h2hstar1_totval.'~'.$team1_star1_arr[2]; } if($team1_over_per<$team1_under_per) { $h2hstar1_totval=$h2hstar1_totval.'~'.$team1_star1_arr[2]; if($team1_star1_arr[2]=='1') { $team1_h2h_Rundercount++; } elseif($team1_star1_arr[2]=='2') { $team1_h2h_Gundercount++; } elseif($team1_star1_arr[2]=='3') { $team1_h2h_Bundercount++; } } if($team1_over_per==$team1_under_per) { $h2hstar1_totval=$h2hstar1_totval.'~'.$team1_star1_arr[2]; if($team1_star1_arr[2]=='1') { $team1_h2h_Rovercount++; } elseif($team1_star1_arr[2]=='2') { $team1_h2h_Govercount++; } elseif($team1_star1_arr[2]=='3') { $team1_h2h_Bovercount++; } } } } $redstar1_h2h_sidecount=substr_count($h2hstar1_sideval, "1"); $greenstar1_h2h_sidecount=substr_count($h2hstar1_sideval, "2"); $bluestar1_h2h_sidecount=substr_count($h2hstar1_sideval,"3"); $redstar1_h2h_totcount=substr_count($h2hstar1_totval, "1"); $greenstar1_h2h_totcount=substr_count($h2hstar1_totval, "2"); $bluestar1_h2h_totcount=substr_count($h2hstar1_totval,"3"); #----------------------------------------------------------------------# #HOME TEAM H2H $h2hstar2_sideval='';$h2hstar2_totval=''; $team2_h2h_Rovercount='0';$team2_h2h_Govercount='0';$team2_h2h_Bovercount='0'; $team2_h2h_Rundercount='0';$team2_h2h_Gundercount='0';$team2_h2h_Bundercount='0'; $team2_h2hcount=mysqli_query($link,"select star_system,ats_count,su_count,over_under from h2hrandom_queries where league_no='$lno' and game_date between '$startdate' and '$enddate' and game_number='$homegameno' order by random_id desc limit 10 "); while($team2h2h=mysqli_fetch_array($team2_h2hcount)) { $team2_starsys=$team2h2h['star_system']; $team2_star2_arr=explode("~",$team2_starsys); $team2_ats_count=$team2h2h['ats_count']; $team2_su_count=$team2h2h['su_count']; $team2_over_under=$team2h2h['over_under']; $ats_sum2=explode("-",$team2_ats_count); $su_sum2=explode("-",$team2_su_count); $ou_sum2=explode("-",$team2_over_under); $ats_csum2=$ats_sum2[0]+$ats_sum2[1]; $su_csum2=$su_sum2[0]+$su_sum2[1]; $ou_csum2=$ou_sum2[0]+$ou_sum2[1]; if($ou_csum2!=0) { $team2_over_per=round(($ou_sum2[0]/$ou_csum2)*100,2); $team2_under_per=round(($ou_sum2[1]/$ou_csum2)*100,2); } if($ats_csum2>='10') { $h2hstar2_sideval=$h2hstar2_sideval.'~'.$team2_star2_arr[0]; } if($su_csum2>='10') { $h2hstar2_sideval=$h2hstar2_sideval.'~'.$team2_star2_arr[1]; } if($ou_csum2>='10') { if($team2_over_per>$team2_under_per) { $h2hstar2_totval=$h2hstar2_totval.'~'.$team2_star2_arr[2]; if($team2_star2_arr[2]=='1') { $team2_h2h_Rovercount++; } elseif($team2_star2_arr[2]=='2') { $team2_h2h_Govercount++; } elseif($team2_star2_arr[2]=='3') { $team2_h2h_Bovercount++; } } if($team2_over_per<$team2_under_per) { $h2hstar2_totval=$h2hstar2_totval.'~'.$team2_star2_arr[2]; if($team2_star2_arr[2]=='1') { $team2_h2h_Rundercount++; } elseif($team2_star2_arr[2]=='2') { $team2_h2h_Gundercount++; } elseif($team2_star2_arr[2]=='3') { $team2_h2h_Bundercount++; } } if($team2_over_per==$team2_under_per) { $h2hstar2_totval=$h2hstar2_totval.'~'.$team2_star2_arr[2]; if($team2_star2_arr[2]=='1') { $team2_h2h_Rovercount++; } elseif($team2_star2_arr[2]=='2') { $team2_h2h_Govercount++; } elseif($team2_star2_arr[2]=='3') { $team2_h2h_Bovercount++; } } } } $redstar2_h2h_sidecount=substr_count($h2hstar2_sideval, "1"); $greenstar2_h2h_sidecount=substr_count($h2hstar2_sideval, "2"); $bluestar2_h2h_sidecount=substr_count($h2hstar2_sideval,"3"); $redstar2_h2h_totcount=substr_count($h2hstar2_totval, "1"); $greenstar2_h2h_totcount=substr_count($h2hstar2_totval, "2"); $bluestar2_h2h_totcount=substr_count($h2hstar2_totval,"3"); #----------------------------------------------------------------------# ######################## V4 STATS CODE ############################# #----------------------------------------------------------------------# #ROAD TEAM v4 $v4_sidestar1val='';$v4star1_totval1=''; $v4star1_sideval2='';$v4star1_totval2=''; $team1_v4_Rovercount1='0';$team1_v4_Govercount1='0';$team1_v4_Bovercount1='0'; $team1_v4_Rundercount1='0';$team1_v4_Gundercount1='0';$team1_v4_Bundercount1='0'; $team1_v4_Rovercount2='0';$team1_v4_Govercount2='0';$team1_v4_Bovercount2='0'; $team1_v4_Rundercount2='0';$team1_v4_Gundercount2='0';$team1_v4_Bundercount2='0'; $team1_v4_sidecount=mysqli_query($link,"select random_id,star_system,ats_count,su_count,over_under from random_queries where league_no='$lno' and game_date between '$startdate' and '$enddate' and (game_number='$roadgameno') and message not like 'When ANY%' limit 50"); while($team1v4=mysqli_fetch_array($team1_v4_sidecount)) { $random_id1=$team1v4['random_id']; $team1_starsys=$team1v4['star_system']; $team1_star1_arr1=explode("~",$team1_starsys); $v4_side_count_atssum1=$team1v4['ats_count']; $v4_side_count_susum1=$team1v4['su_count']; $v4_side_count_ousum1=$team1v4['over_under']; $ats_sum1=explode("-",$v4_side_count_atssum1); $su_sum1=explode("-",$v4_side_count_susum1); $ou_sum1=explode("-",$v4_side_count_ousum1); $ats_csum1=$ats_sum1[0]+$ats_sum1[1]; $su_csum1=$su_sum1[0]+$su_sum1[1]; $ou_csum1=$ou_sum1[0]+$ou_sum1[1]; if($ou_csum1!=0) { $team1_over_per=round(($ou_sum1[0]/$ou_csum1)*100,2); $team1_under_per=round(($ou_sum1[1]/$ou_csum1)*100,2); } if($ats_csum1>='10') { $v4star1_sideval1=$v4star1_sideval1.'~'.$team1_star1_arr1[0]; } if($su_csum1>='10') { $v4star1_sideval1=$v4star1_sideval1.'~'.$team1_star1_arr1[1]; } if($ou_csum1>=10) { if($team1_over_per>$team1_under_per) { $v4star1_totval1=$v4star1_totval1.'~'.$team1_star1_arr1[2]; if($team1_star1_arr1[2]=='1') { $team1_v4_Rovercount1++; } elseif($team1_star1_arr1[2]=='2') { $team1_v4_Govercount1++; } elseif($team1_star1_arr1[2]=='3') { $team1_v4_Bovercount1++; } } if($team1_over_per<$team1_under_per) { $v4star1_totval1=$v4star1_totval1.'~'.$team1_star1_arr1[2]; if($team1_star1_arr1[2]=='1') { $team1_v4_Rundercount1++; } elseif($team1_star1_arr1[2]=='2') { $team1_v4_Gundercount1++; } elseif($team1_star1_arr1[2]=='3') { $team1_v4_Bundercount1++; } } if($team1_over_per==$team1_under_per) { $v4star1_totval1=$v4star1_totval1.'~'.$team1_star1_arr1[2]; if($team1_star1_arr1[2]=='1') { $team1_v4_Rovercount1++; } elseif($team1_star1_arr1[2]=='2') { $team1_v4_Govercount1++; } elseif($team1_star1_arr1[2]=='3') { $team1_v4_Bovercount1++; } } } } $redstar1_v4_sidecount1=substr_count($v4star1_sideval1, "1"); $greenstar1_v4_sidecount1=substr_count($v4star1_sideval1, "2"); $bluestar1_v4_sidecount1=substr_count($v4star1_sideval1,"3"); $redstar1_v4_totcount1=substr_count($v4star1_totval1, "1"); $greenstar1_v4_totcount1=substr_count($v4star1_totval1, "2"); $bluestar1_v4_totcount1=substr_count($v4star1_totval1,"3"); //echo "select star_system,ats_count,su_count,over_under from random_queries where league_no='$lno' and game_date between '$startdate' and '$enddate' and (game_number='$roadgameno') and message like 'When ANY%' limit 50
"; $team1_v4_sidecount1=mysqli_query($link,"select star_system,ats_count,su_count,over_under from random_queries where league_no='$lno' and game_date between '$startdate' and '$enddate' and (game_number='$roadgameno') and message like 'When ANY%' limit 50"); while($team1v41=mysqli_fetch_array($team1_v4_sidecount1)) { $team1_starsys1=$team1v41['star_system']; $team1_star1_arr2=explode("~",$team1_starsys1); $v4_side1_count_atssum1=$team1v41['ats_count']; $v4_side1_count_susum1=$team1v41['su_count']; $v4_side1_count_ousum1=$team1v41['over_under']; $ats_sum11=explode("-",$v4_side1_count_atssum1); $su_sum11=explode("-",$v4_side1_count_susum1); $ou_sum11=explode("-",$v4_side1_count_ousum1); $ats_csum11=$ats_sum11[0]+$ats_sum11[1]; $su_csum11=$su_sum11[0]+$su_sum11[1]; $ou_csum11=$ou_sum11[0]+$ou_sum11[1]; //echo "ou_csum11=$ou_csum11 ** ou_sum11[1]=$ou_sum11[1]
"; if($ou_csum11!='0') { $team1_over_per1=round(($ou_sum11[0]/$ou_csum11)*100,2); $team1_under_per1=round(($ou_sum11[1]/$ou_csum11)*100,2); } if($ats_csum11>='10') { $v4star1_sideval2=$v4star1_sideval2.'~'.$team1_star1_arr2[0]; } if($su_csum11>='10') { $v4star1_sideval2=$v4star1_sideval2.'~'.$team1_star1_arr2[1]; } if($ou_csum11>='10') { if($team1_over_per1>$team1_under_per1) { $v4star1_totval2=$v4star1_totval2.'~'.$team1_star1_arr2[2]; if($team1_star1_arr2[2]=='1') { $team1_v4_Rovercount2++; } elseif($team1_star1_arr2[2]=='2') { $team1_v4_Govercount2++; } elseif($team1_star1_arr2[2]=='3') { $team1_v4_Bovercount2++; } } if($team1_over_per1<$team1_under_per1) { $v4star1_totval2=$v4star1_totval2.'~'.$team1_star1_arr2[2]; if($team1_star1_arr2[2]=='1') { $team1_v4_Rundercount2++; } elseif($team1_star1_arr2[2]=='2') { $team1_v4_Gundercount2++; } elseif($team1_star1_arr2[2]=='3') { $team1_v4_Bundercount2++; } } if($team1_over_per1==$team1_under_per1) { $v4star1_totval2=$v4star1_totval2.'~'.$team1_star1_arr2[2]; if($team1_star1_arr2[2]=='1') { $team1_v4_Rovercount2++; } elseif($team1_star1_arr2[2]=='2') { $team1_v4_Govercount2++; } elseif($team1_star1_arr2[2]=='3') { $team1_v4_Bovercount2++; } } } } $redstar1_v4_sidecount2=substr_count($v4star1_sideval2, "1"); $greenstar1_v4_sidecount2=substr_count($v4star1_sideval2, "2"); $bluestar1_v4_sidecount2=substr_count($v4star1_sideval2,"3"); $redstar1_v4_totcount2=substr_count($v4star1_totval2, "1"); $greenstar1_v4_totcount2=substr_count($v4star1_totval2, "2"); $bluestar1_v4_totcount2=substr_count($v4star1_totval2,"3"); $redstar1_v4_sidecount=$redstar1_v4_sidecount1+$redstar1_v4_sidecount2; $greenstar1_v4_sidecount=$greenstar1_v4_sidecount1+$greenstar1_v4_sidecount2; $bluestar1_v4_sidecount=$bluestar1_v4_sidecount1+$bluestar1_v4_sidecount2; $team1_v4_Rovercount=$team1_v4_Rovercount1+$team1_v4_Rovercount2; $team1_v4_Govercount=$team1_v4_Govercount1+$team1_v4_Govercount2; $team1_v4_Bovercount=$team1_v4_Bovercount1+$team1_v4_Bovercount2; $team1_v4_Rundercount=$team1_v4_Rundercount1+$team1_v4_Rundercount2; $team1_v4_Gundercount=$team1_v4_Gundercount1+$team1_v4_Gundercount2; $team1_v4_Bundercount=$team1_v4_Bundercount1+$team1_v4_Bundercount2; #HOME V4 $v4_sidestar2val='';$v4star2_totval1=''; $v4star2_sideval2='';$v4star2_totval2=''; $team2_v4_Rovercount1='0';$team2_v4_Govercount1='0';$team2_v4_Bovercount1='0'; $team2_v4_Rundercount1='0';$team2_v4_Gundercount1='0';$team2_v4_Bundercount1='0'; $team2_v4_Rovercount2='0';$team2_v4_Govercount2='0';$team2_v4_Bovercount2='0'; $team2_v4_Rundercount2='0';$team2_v4_Gundercount2='0';$team2_v4_Bundercount2='0'; $team2_v4_sidecount=mysqli_query($link,"select star_system,ats_count,su_count,over_under from random_queries where league_no='$lno' and game_date between '$startdate' and '$enddate' and (game_number='$homegameno') and message not like 'When ANY%' limit 50"); while($team2v4=mysqli_fetch_array($team2_v4_sidecount)) { $team2_starsys=$team2v4['star_system']; $team2_star2_arr1=explode("~",$team2_starsys); $v4_side_count_atssum2=$team2v4['ats_count']; $v4_side_count_susum2=$team2v4['su_count']; $v4_side_count_ousum2=$team2v4['over_under']; $ats_sum2=explode("-",$v4_side_count_atssum2); $su_sum2=explode("-",$v4_side_count_susum2); $ou_sum2=explode("-",$v4_side_count_ousum2); $ats_csum2=$ats_sum2[0]+$ats_sum2[1]; $su_csum2=$su_sum2[0]+$su_sum2[1]; $ou_csum2=$ou_sum2[0]+$ou_sum2[1]; if($ou_csum2!='0') { $team2_over_per=round(($ou_sum2[0]/$ou_csum2)*100,2); $team2_under_per=round(($ou_sum2[1]/$ou_csum2)*100,2); } if($ats_csum2>='10') { $v4star2_sideval1=$v4star2_sideval1.'~'.$team2_star2_arr1[0]; } if($su_csum2>='10') { $v4star2_sideval1=$v4star2_sideval1.'~'.$team2_star2_arr1[1]; } if($ou_csum2>='10') { if($team2_over_per>$team2_under_per) { $v4star2_totval1=$v4star2_totval1.'~'.$team2_star2_arr1[2]; if($team2_star2_arr1[2]=='1') { $team2_v4_Rovercount1++; } elseif($team2_star2_arr1[2]=='2') { $team2_v4_Govercount1++; } elseif($team2_star2_arr1[2]=='3') { $team2_v4_Bovercount1++; } } if($team2_over_per<$team2_under_per) { $v4star2_totval1=$v4star2_totval1.'~'.$team2_star2_arr1[2]; if($team2_star2_arr1[2]=='1') { $team2_v4_Rundercount1++; } elseif($team2_star2_arr1[2]=='2') { $team2_v4_Gundercount1++; } elseif($team2_star2_arr1[2]=='3') { $team2_v4_Bundercount1++; } } if($team2_over_per==$team2_under_per) { $v4star2_totval1=$v4star2_totval1.'~'.$team2_star2_arr1[2]; if($team2_star2_arr1[2]=='1') { $team2_v4_Rovercount1++; } elseif($team2_star2_arr1[2]=='2') { $team2_v4_Govercount1++; } elseif($team2_star2_arr1[2]=='3') { $team2_v4_Bovercount1++; } } } } $redstar2_v4_sidecount1=substr_count($v4star2_sideval1, "1"); $greenstar2_v4_sidecount1=substr_count($v4star2_sideval1, "2"); $bluestar2_v4_sidecount1=substr_count($v4star2_sideval1,"3"); $redstar2_v4_totcount1=substr_count($v4star2_totval1, "1"); $greenstar2_v4_totcount1=substr_count($v4star2_totval1, "2"); $bluestar2_v4_totcount1=substr_count($v4star2_totval1,"3"); $team2_v4_sidecount1=mysqli_query($link,"select star_system,ats_count,su_count,over_under from random_queries where league_no='$lno' and game_date between '$startdate' and '$enddate' and (game_number='$homegameno') and message like 'When ANY%' limit 50"); while($team2v41=mysqli_fetch_array($team2_v4_sidecount1)) { $team2_starsys1=$team2v41['star_system']; $team2_star2_arr2=explode("~",$team2_starsys1); $v4_side1_count_atssum2=$team2v41['ats_count']; $v4_side1_count_susum2=$team2v41['su_count']; $v4_side1_count_ousum2=$team2v41['over_under']; $ats_sum21=explode("-",$v4_side1_count_atssum2); $su_sum21=explode("-",$v4_side1_count_susum2); $ou_sum21=explode("-",$v4_side1_count_ousum2); $ats_csum21=$ats_sum21[0]+$ats_sum21[1]; $su_csum21=$su_sum21[0]+$su_sum21[1]; $ou_csum21=$ou_sum21[0]+$ou_sum21[1]; if($ou_csum21!='0') { $team2_over_per2=round(($ou_sum21[0]/$ou_csum21)*100,2); $team2_under_per2=round(($ou_sum21[1]/$ou_csum21)*100,2); } if($ats_csum21>='10') { $v4star2_sideval2=$v4star2_sideval2.'~'.$team2_star2_arr2[0]; } if($su_csum21>='10') { $v4star2_sideval2=$v4star2_sideval2.'~'.$team2_star2_arr2[1]; } if($ou_csum21>='10') { if($team2_over_per2>$team2_under_per2) { $v4star2_totval2=$v4star2_totval2.'~'.$team2_star2_arr2[2]; if($team2_star2_arr2[2]=='1') { $team2_v4_Rovercount2++; } elseif($team2_star2_arr2[2]=='2') { $team2_v4_Govercount2++; } elseif($team2_star2_arr2[2]=='3') { $team2_v4_Bovercount2++; } } if($team2_over_per2<$team2_under_per2) { $v4star2_totval2=$v4star2_totval2.'~'.$team2_star2_arr2[2]; if($team2_star2_arr2[2]=='1') { $team2_v4_Rundercount2++; } elseif($team2_star2_arr2[2]=='2') { $team2_v4_Gundercount2++; } elseif($team2_star2_arr2[2]=='3') { $team2_v4_Bundercount2++; } } if($team2_over_per2==$team2_under_per2) { $v4star2_totval2=$v4star2_totval2.'~'.$team2_star2_arr2[2]; if($team2_star2_arr2[2]=='1') { $team2_v4_Rovercount2++; } elseif($team2_star2_arr2[2]=='2') { $team2_v4_Govercount2++; } elseif($team2_star2_arr2[2]=='3') { $team2_v4_Bovercount2++; } } } } $redstar2_v4_sidecount2=substr_count($v4star2_sideval2, "1"); $greenstar2_v4_sidecount2=substr_count($v4star2_sideval2, "2"); $bluestar2_v4_sidecount2=substr_count($v4star2_sideval2,"3"); $redstar2_v4_totcount2=substr_count($v4star2_totval2, "1"); $greenstar2_v4_totcount2=substr_count($v4star2_totval2, "2"); $bluestar2_v4_totcount2=substr_count($v4star2_totval2,"3"); $redstar2_v4_sidecount=$redstar2_v4_sidecount1+$redstar2_v4_sidecount2; $greenstar2_v4_sidecount=$greenstar2_v4_sidecount1+$greenstar2_v4_sidecount2; $bluestar2_v4_sidecount=$bluestar2_v4_sidecount1+$bluestar2_v4_sidecount2; $team2_v4_Rovercount=$team2_v4_Rovercount1+$team2_v4_Rovercount2; $team2_v4_Govercount=$team2_v4_Govercount1+$team2_v4_Govercount2; $team2_v4_Bovercount=$team2_v4_Bovercount1+$team2_v4_Bovercount2; $team2_v4_Rundercount=$team2_v4_Rundercount1+$team2_v4_Rundercount2; $team2_v4_Gundercount=$team2_v4_Gundercount1+$team2_v4_Gundercount2; $team2_v4_Bundercount=$team2_v4_Bundercount1+$team2_v4_Bundercount2; #----------------------------------------------------------------------# ######################## V5 STATS CODE ############################# #----------------------------------------------------------------------# #ROAD TEAM v5 $v5_sidestar1val='';$v5star1_totval1=''; $v5star1_sideval2='';$v5star1_totval2=''; $team1_v5_Rovercount1='0';$team1_v5_Govercount1='0';$team1_v5_Bovercount1='0'; $team1_v5_Rundercount1='0';$team1_v5_Gundercount1='0';$team1_v5_Bundercount1='0'; $team1_v5_Rovercount2='0';$team1_v5_Govercount2='0';$team1_v5_Bovercount2='0'; $team1_v5_Rundercount2='0';$team1_v5_Gundercount2='0';$team1_v5_Bundercount2='0'; $team1_v5_sidecount=mysqli_query($link,"select star_system,ats_count,su_count,over_under from v5random_queries where league_no='$lno' and game_date between '$startdate' and '$enddate' and (game_number='$roadgameno') and message not like 'When ANY%' "); while($team1v5=mysqli_fetch_array($team1_v5_sidecount)) { $team1_starsys=$team1v5['star_system']; //echo "team1_starsys=$team1_starsys
"; $team1_star1_arr1=explode("~",$team1_starsys); $v5_side_count_atssum1=$team1v5['ats_count']; $v5_side_count_susum1=$team1v5['su_count']; $v5_side_count_ousum1=$team1v5['over_under']; $ats_sum1=explode("-",$v5_side_count_atssum1); $su_sum1=explode("-",$v5_side_count_susum1); $ou_sum1=explode("-",$v5_side_count_ousum1); $ats_csum1=$ats_sum1[0]+$ats_sum1[1]; $su_csum1=$su_sum1[0]+$su_sum1[1]; $ou_csum1=$ou_sum1[0]+$ou_sum1[1]; if($ou_csum1!=0) { $team1_over_per=round(($ou_sum1[0]/$ou_csum1)*100,2); $team1_under_per=round(($ou_sum1[1]/$ou_csum1)*100,2); } if($ats_csum1>='10') { $v5star1_sideval1=$v5star1_sideval1.'~'.$team1_star1_arr1[0]; } if($su_csum1>='10') { $v5star1_sideval1=$v5star1_sideval1.'~'.$team1_star1_arr1[1]; } if($ou_csum1>='10') { if($team1_over_per>$team1_under_per) { $v5star1_totval1=$v5star1_totval1.'~'.$team1_star1_arr1[2]; if($team1_star1_arr1[2]=='1') { $team1_v5_Rovercount1++; } elseif($team1_star1_arr1[2]=='2') { $team1_v5_Govercount1++; } elseif($team1_star1_arr1[2]=='3') { $team1_v5_Bovercount1++; } } if($team1_over_per<$team1_under_per) { $v5star1_totval1=$v5star1_totval1.'~'.$team1_star1_arr1[2]; if($team1_star1_arr1[2]=='1') { $team1_v5_Rundercount1++; } elseif($team1_star1_arr1[2]=='2') { $team1_v5_Gundercount1++; } elseif($team1_star1_arr1[2]=='3') { $team1_v5_Bundercount1++; } } if($team1_over_per==$team1_under_per) { $v5star1_totval1=$v5star1_totval1.'~'.$team1_star1_arr1[2]; if($team1_star1_arr1[2]=='1') { $team1_v5_Rovercount1++; } elseif($team1_star1_arr1[2]=='2') { $team1_v5_Govercount1++; } elseif($team1_star1_arr1[2]=='3') { $team1_v5_Bovercount1++; } } } } $redstar1_v5_sidecount1=substr_count($v5star1_sideval1, "1"); $greenstar1_v5_sidecount1=substr_count($v5star1_sideval1, "2"); $bluestar1_v5_sidecount1=substr_count($v5star1_sideval1,"3"); $redstar1_v5_totcount1=substr_count($v5star1_totval1, "1"); $greenstar1_v5_totcount1=substr_count($v5star1_totval1, "2"); $bluestar1_v5_totcount1=substr_count($v5star1_totval1,"3"); $team1_v5_sidecount1=mysqli_query($link,"select star_system,ats_count,su_count,over_under from v5random_queries where league_no='$lno' and game_date between '$startdate' and '$enddate' and (game_number='$roadgameno') and message like 'When ANY%' "); while($team1v51=mysqli_fetch_array($team1_v5_sidecount1)) { $team1_starsys1=$team1v51['star_system']; $team1_star1_arr2=explode("~",$team1_starsys1); $v5_side1_count_atssum1=$team1v51['ats_count']; $v5_side1_count_susum1=$team1v51['su_count']; $v5_side1_count_ousum1=$team1v51['over_under']; $ats_sum11=explode("-",$v5_side1_count_atssum1); $su_sum11=explode("-",$v5_side1_count_susum1); $ou_sum11=explode("-",$v5_side1_count_ousum1); $ats_csum11=$ats_sum11[0]+$ats_sum11[1]; $su_csum11=$su_sum11[0]+$su_sum11[1]; $ou_csum11=$ou_sum11[0]+$ou_sum11[1]; if($ou_csum1!=0) { $team1_over_per1=round(($ou_sum11[0]/$ou_csum11)*100,2); $team1_under_per1=round(($ou_sum11[1]/$ou_csum11)*100,2); } if($ats_csum11>='10') { $v5star1_sideval2=$v5star1_sideval2.'~'.$team1_star1_arr2[0]; } if($su_csum11>='10') { $v5star1_sideval2=$v5star1_sideval2.'~'.$team1_star1_arr2[1]; } if($ou_csum11>='10') { if($team1_over_per1>$team1_under_per1) { $v5star1_totval2=$v5star1_totval2.'~'.$team1_star1_arr2[2]; if($team1_star1_arr2[2]=='1') { $team1_v5_Rovercount2++; } elseif($team1_star1_arr2[2]=='2') { $team1_v5_Govercount2++; } elseif($team1_star1_arr2[2]=='3') { $team1_v5_Bovercount2++; } } if($team1_over_per1<$team1_under_per1) { $v5star1_totval2=$v5star1_totval2.'~'.$team1_star1_arr2[2]; if($team1_star1_arr2[2]=='1') { $team1_v5_Rundercount2++; } elseif($team1_star1_arr2[2]=='2') { $team1_v5_Gundercount2++; } elseif($team1_star1_arr2[2]=='3') { $team1_v5_Bundercount2++; } } if($team1_over_per1==$team1_under_per1) { $v5star1_totval2=$v5star1_totval2.'~'.$team1_star1_arr2[2]; if($team1_star1_arr2[2]=='1') { $team1_v5_Rovercount2++; } elseif($team1_star1_arr2[2]=='2') { $team1_v5_Govercount2++; } elseif($team1_star1_arr2[2]=='3') { $team1_v5_Bovercount2++; } } } } $redstar1_v5_sidecount2=substr_count($v5star1_sideval2, "1"); $greenstar1_v5_sidecount2=substr_count($v5star1_sideval2, "2"); $bluestar1_v5_sidecount2=substr_count($v5star1_sideval2,"3"); $redstar1_v5_totcount2=substr_count($v5star1_totval2, "1"); $greenstar1_v5_totcount2=substr_count($v5star1_totval2, "2"); $bluestar1_v5_totcount2=substr_count($v5star1_totval2,"3"); $redstar1_v5_sidecount=$redstar1_v5_sidecount1+$redstar1_v5_sidecount2; $greenstar1_v5_sidecount=$greenstar1_v5_sidecount1+$greenstar1_v5_sidecount2; $bluestar1_v5_sidecount=$bluestar1_v5_sidecount1+$bluestar1_v5_sidecount2; $team1_v5_Rovercount=$team1_v5_Rovercount1+$team1_v5_Rovercount2; $team1_v5_Govercount=$team1_v5_Govercount1+$team1_v5_Govercount2; $team1_v5_Bovercount=$team1_v5_Bovercount1+$team1_v5_Bovercount2; $team1_v5_Rundercount=$team1_v5_Rundercount1+$team1_v5_Rundercount2; $team1_v5_Gundercount=$team1_v5_Gundercount1+$team1_v5_Gundercount2; $team1_v5_Bundercount=$team1_v5_Bundercount1+$team1_v5_Bundercount2; #HOME v5 $v5_sidestar2val='';$v5star2_totval1=''; $v5star2_sideval2='';$v5star2_totval2=''; $team2_v5_Rovercount1='0';$team2_v5_Govercount1='0';$team2_v5_Bovercount1='0'; $team2_v5_Rundercount1='0';$team2_v5_Gundercount1='0';$team2_v5_Bundercount1='0'; $team2_v5_Rovercount2='0';$team2_v5_Govercount2='0';$team2_v5_Bovercount2='0'; $team2_v5_Rundercount2='0';$team2_v5_Gundercount2='0';$team2_v5_Bundercount2='0'; $team2_v5_sidecount=mysqli_query($link,"select star_system,ats_count,su_count,over_under from v5random_queries where league_no='$lno' and game_date between '$startdate' and '$enddate' and (game_number='$homegameno') and message not like 'When ANY%' "); while($team2v5=mysqli_fetch_array($team2_v5_sidecount)) { $team2_starsys=$team2v5['star_system']; $team2_star2_arr1=explode("~",$team2_starsys); $v5_side_count_atssum2=$team2v5['ats_count']; $v5_side_count_susum2=$team2v5['su_count']; $v5_side_count_ousum2=$team2v5['over_under']; $ats_sum2=explode("-",$v5_side_count_atssum2); $su_sum2=explode("-",$v5_side_count_susum2); $ou_sum2=explode("-",$v5_side_count_ousum2); $ats_csum2=$ats_sum2[0]+$ats_sum2[1]; $su_csum2=$su_sum2[0]+$su_sum2[1]; $ou_csum2=$ou_sum2[0]+$ou_sum2[1]; if($ou_csum2!=0) { $team2_over_per=round(($ou_sum2[0]/$ou_csum2)*100,2); $team2_under_per=round(($ou_sum2[1]/$ou_csum2)*100,2); } if($ats_csum2>='10') { $v5star2_sideval1=$v5star2_sideval1.'~'.$team2_star2_arr1[0]; } if($su_csum2>='10') { $v5star2_sideval1=$v5star2_sideval1.'~'.$team2_star2_arr1[1]; } if($ou_csum2>=10) { if($team2_over_per>$team2_under_per) { $v5star2_totval1=$v5star2_totval1.'~'.$team2_star2_arr1[2]; if($team2_star2_arr1[2]=='1') { $team2_v5_Rovercount1++; } elseif($team2_star2_arr1[2]=='2') { $team2_v5_Govercount1++; } elseif($team2_star2_arr1[2]=='3') { $team2_v5_Bovercount1++; } } if($team2_over_per<$team2_under_per) { $v5star2_totval1=$v5star2_totval1.'~'.$team2_star2_arr1[2]; if($team2_star2_arr1[2]=='1') { $team2_v5_Rundercount1++; } elseif($team2_star2_arr1[2]=='2') { $team2_v5_Gundercount1++; } elseif($team2_star2_arr1[2]=='3') { $team2_v5_Bundercount1++; } } if($team2_over_per==$team2_under_per) { $v5star2_totval1=$v5star2_totval1.'~'.$team2_star2_arr1[2]; if($team2_star2_arr1[2]=='1') { $team2_v5_Rovercount1++; } elseif($team2_star2_arr1[2]=='2') { $team2_v5_Govercount1++; } elseif($team2_star2_arr1[2]=='3') { $team2_v5_Bovercount1++; } } } } $redstar2_v5_sidecount1=substr_count($v5star2_sideval1, "1"); $greenstar2_v5_sidecount1=substr_count($v5star2_sideval1, "2"); $bluestar2_v5_sidecount1=substr_count($v5star2_sideval1,"3"); $redstar2_v5_totcount1=substr_count($v5star2_totval1, "1"); $greenstar2_v5_totcount1=substr_count($v5star2_totval1, "2"); $bluestar2_v5_totcount1=substr_count($v5star2_totval1,"3"); $team2_v5_sidecount1=mysqli_query($link,"select star_system,ats_count,su_count,over_under from v5random_queries where league_no='$lno' and game_date between '$startdate' and '$enddate' and (game_number='$homegameno') and message like 'When ANY%' "); while($team2v51=mysqli_fetch_array($team2_v5_sidecount1)) { $team2_starsys1=$team2v51['star_system']; $team2_star2_arr2=explode("~",$team2_starsys1); $v5_side1_count_atssum2=$team2v51['ats_count']; $v5_side1_count_susum2=$team2v51['su_count']; $v5_side1_count_ousum2=$team2v51['over_under']; $ats_sum21=explode("-",$v5_side1_count_atssum2); $su_sum21=explode("-",$v5_side1_count_susum2); $ou_sum21=explode("-",$v5_side1_count_ousum2); $ats_csum21=$ats_sum21[0]+$ats_sum21[1]; $su_csum21=$su_sum21[0]+$su_sum21[1]; $ou_csum21=$ou_sum21[0]+$ou_sum21[1]; if($ou_csum2!=0) { $team2_over_per2=round(($ou_sum21[0]/$ou_csum21)*100,2); $team2_under_per2=round(($ou_sum21[1]/$ou_csum21)*100,2); } if($ats_csum21>='10') { $v5star2_sideval2=$v5star2_sideval2.'~'.$team2_star2_arr2[0]; } if($su_csum21>='10') { $v5star2_sideval2=$v5star2_sideval2.'~'.$team2_star2_arr2[1]; } if($ou_csum21>='10') { if($team2_over_per2>$team2_under_per2) { $v5star2_totval2=$v5star2_totval2.'~'.$team2_star2_arr2[2]; if($team2_star2_arr2[2]=='1') { $team2_v5_Rovercount2++; } elseif($team2_star2_arr2[2]=='2') { $team2_v5_Govercount2++; } elseif($team2_star2_arr2[2]=='3') { $team2_v5_Bovercount2++; } } if($team2_over_per2<$team2_under_per2) { $v5star2_totval2=$v5star2_totval2.'~'.$team2_star2_arr2[2]; if($team2_star2_arr2[2]=='1') { $team2_v5_Rundercount2++; } elseif($team2_star2_arr2[2]=='2') { $team2_v5_Gundercount2++; } elseif($team2_star2_arr2[2]=='3') { $team2_v5_Bundercount2++; } } if($team2_over_per2==$team2_under_per2) { $v5star2_totval2=$v5star2_totval2.'~'.$team2_star2_arr2[2]; if($team2_star2_arr2[2]=='1') { $team2_v5_Rovercount2++; } elseif($team2_star2_arr2[2]=='2') { $team2_v5_Govercount2++; } elseif($team2_star2_arr2[2]=='3') { $team2_v5_Bovercount2++; } } } } $redstar2_v5_sidecount2=substr_count($v5star2_sideval2, "1"); $greenstar2_v5_sidecount2=substr_count($v5star2_sideval2, "2"); $bluestar2_v5_sidecount2=substr_count($v5star2_sideval2,"3"); $redstar2_v5_totcount2=substr_count($v5star2_totval2, "1"); $greenstar2_v5_totcount2=substr_count($v5star2_totval2, "2"); $bluestar2_v5_totcount2=substr_count($v5star2_totval2,"3"); $redstar2_v5_sidecount=$redstar2_v5_sidecount1+$redstar2_v5_sidecount2; $greenstar2_v5_sidecount=$greenstar2_v5_sidecount1+$greenstar2_v5_sidecount2; $bluestar2_v5_sidecount=$bluestar2_v5_sidecount1+$bluestar2_v5_sidecount2; $redstar2_v5_sidecount=$redstar2_v5_sidecount1+$redstar2_v5_sidecount2; $greenstar2_v5_sidecount=$greenstar2_v5_sidecount1+$greenstar2_v5_sidecount2; $bluestar2_v5_sidecount=$bluestar2_v5_sidecount1+$bluestar2_v5_sidecount2; $team2_v5_Rovercount=$team2_v5_Rovercount1+$team2_v5_Rovercount2; $team2_v5_Govercount=$team2_v5_Govercount1+$team2_v5_Govercount2; $team2_v5_Bovercount=$team2_v5_Bovercount1+$team2_v5_Bovercount2; $team2_v5_Rundercount=$team2_v5_Rundercount1+$team2_v5_Rundercount2; $team2_v5_Gundercount=$team2_v5_Gundercount1+$team2_v5_Gundercount2; $team2_v5_Bundercount=$team2_v5_Bundercount1+$team2_v5_Bundercount2; #----------------------------------------------------------------------# ######################## SUPER STATS CODE ############################# #----------------------------------------------------------------------# #ROAD TEAM super $superstar1_sideval='';$superstar1_totval=''; $team1_super_Rovercount='0';$team1_super_Govercount='0';$team1_super_Bovercount='0'; $team1_super_Rundercount='0';$team1_super_Gundercount='0';$team1_super_Bundercount='0'; $team1_supercount=mysqli_query($link,"select star_system,ats_count,su_count,over_under from super_stats_queries where league_no='$lno' and game_date between '$startdate' and '$enddate' and game_number='$roadgameno' order by random_id desc limit 10 "); while($team1super=mysqli_fetch_array($team1_supercount)) { $team1_starsys=$team1super['star_system']; $team1_star1_arr=explode("~",$team1_starsys); $team1_ats_count=$team1super['ats_count']; $team1_su_count=$team1super['su_count']; $team1_over_under=$team1super['over_under']; $ats_sum1=explode("-",$team1_ats_count); $su_sum1=explode("-",$team1_su_count); $ou_sum1=explode("-",$team1_over_under); $ats_csum1=$ats_sum1[0]+$ats_sum1[1]; $su_csum1=$su_sum1[0]+$su_sum1[1]; $ou_csum1=$ou_sum1[0]+$ou_sum1[1]; if($ou_csum1!=0) { $team1_over_per=round(($ou_sum1[0]/$ou_csum1)*100,2); $team1_under_per=round(($ou_sum1[1]/$ou_csum1)*100,2); } if($ats_csum1>='10') { $superstar1_sideval=$superstar1_sideval.'~'.$team1_star1_arr[0]; } if($su_csum1>='10') { $superstar1_sideval=$superstar1_sideval.'~'.$team1_star1_arr[1]; } if($ou_csum1>=10) { if($team1_over_per>$team1_under_per) { $superstar1_totval=$superstar1_totval.'~'.$team1_star1_arr[2]; if($team1_star1_arr[2]=='1') { $team1_super_Rovercount++; } elseif($team1_star1_arr[2]=='2') { $team1_super_Govercount++; } elseif($team1_star1_arr[2]=='3') { $team1_super_Bovercount++; } } if($team1_over_per<$team1_under_per) { $superstar1_totval=$superstar1_totval.'~'.$team1_star1_arr[2]; if($team1_star1_arr[2]=='1') { $team1_super_Rundercount++; } elseif($team1_star1_arr[2]=='2') { $team1_super_Gundercount++; } elseif($team1_star1_arr[2]=='3') { $team1_super_Bundercount++; } } if($team1_over_per==$team1_under_per) { $superstar1_totval=$superstar1_totval.'~'.$team1_star1_arr[2]; if($team1_star1_arr[2]=='1') { $team1_super_Rovercount++; } elseif($team1_star1_arr[2]=='2') { $team1_super_Govercount++; } elseif($team1_star1_arr[2]=='3') { $team1_super_Bovercount++; } } } } $redstar1_super_sidecount=substr_count($superstar1_sideval, "1"); $greenstar1_super_sidecount=substr_count($superstar1_sideval, "2"); $bluestar1_super_sidecount=substr_count($superstar1_sideval,"3"); $redstar1_super_totcount=substr_count($superstar1_totval, "1"); $greenstar1_super_totcount=substr_count($superstar1_totval, "2"); $bluestar1_super_totcount=substr_count($superstar1_totval,"3"); #----------------------------------------------------------------------# #HOME TEAM super $superstar2_sideval='';$superstar2_totval=''; $team2_super_Rovercount='0';$team2_super_Govercount='0';$team2_super_Bovercount='0'; $team2_super_Rundercount='0';$team2_super_Gundercount='0';$team2_super_Bundercount='0'; $team2_supercount=mysqli_query($link,"select star_system,ats_count,su_count,over_under from super_stats_queries where league_no='$lno' and game_date between '$startdate' and '$enddate' and game_number='$homegameno' order by random_id desc limit 10 "); while($team2super=mysqli_fetch_array($team2_supercount)) { $team2_starsys=$team2super['star_system']; $team2_star2_arr=explode("~",$team2_starsys); $team2_ats_count=$team2super['ats_count']; $team2_su_count=$team2super['su_count']; $team2_over_under=$team2super['over_under']; $ats_sum2=explode("-",$team2_ats_count); $su_sum2=explode("-",$team2_su_count); $ou_sum2=explode("-",$team2_over_under); $ats_csum2=$ats_sum2[0]+$ats_sum2[1]; $su_csum2=$su_sum2[0]+$su_sum2[1]; $ou_csum2=$ou_sum2[0]+$ou_sum2[1]; if($ou_csum1!=0) { $team2_over_per=round(($ou_sum2[0]/$ou_csum2)*100,2); $team2_under_per=round(($ou_sum2[1]/$ou_csum2)*100,2); } if($ats_csum2>='10') { $superstar2_sideval=$superstar2_sideval.'~'.$team2_star2_arr[0]; } if($su_csum2>='10') { $superstar2_sideval=$superstar2_sideval.'~'.$team2_star2_arr[1]; } if($ou_csum2>=10) { if($team2_over_per>$team2_under_per) { $superstar2_totval=$superstar2_totval.'~'.$team2_star2_arr[2]; if($team2_star2_arr[2]=='1') { $team2_super_Rovercount++; } elseif($team2_star2_arr[2]=='2') { $team2_super_Govercount++; } elseif($team2_star2_arr[2]=='3') { $team2_super_Bovercount++; } } if($team2_over_per<$team2_under_per) { $superstar2_totval=$superstar2_totval.'~'.$team2_star2_arr[2]; if($team2_star2_arr[2]=='1') { $team2_super_Rundercount++; } elseif($team2_star2_arr[2]=='2') { $team2_super_Gundercount++; } elseif($team2_star2_arr[2]=='3') { $team2_super_Bundercount++; } } if($team2_over_per==$team2_under_per) { $superstar2_totval=$superstar2_totval.'~'.$team2_star2_arr[2]; if($team2_star2_arr[2]=='1') { $team2_super_Rovercount++; } elseif($team2_star2_arr[2]=='2') { $team2_super_Govercount++; } elseif($team2_star2_arr[2]=='3') { $team2_super_Bovercount++; } } } } $redstar2_super_sidecount=substr_count($superstar2_sideval, "1"); $greenstar2_super_sidecount=substr_count($superstar2_sideval, "2"); $bluestar2_super_sidecount=substr_count($superstar2_sideval,"3"); $redstar2_super_totcount=substr_count($superstar2_totval, "1"); $greenstar2_super_totcount=substr_count($superstar2_totval, "2"); $bluestar2_super_totcount=substr_count($superstar2_totval,"3"); #----------------------------------------------------------------------# $team1_side_redtotal=$redstar1_h2h_sidecount+$redstar1_v5_sidecount+$redstar1_v4_sidecount+ $redstar1_super_sidecount; $team1_side_greentotal=$greenstar1_h2h_sidecount+$greenstar1_v5_sidecount+$greenstar1_v4_sidecount+ $greenstar1_super_sidecount; $team1_side_bluetotal=$bluestar1_h2h_sidecount+$bluestar1_v5_sidecount+$bluestar1_v4_sidecount+ $bluestar1_super_sidecount; #----------------------------------------------------------------------# #--------------------------------------------------------------------------------------------# $team2_side_redtotal=$redstar2_h2h_sidecount+$redstar2_v5_sidecount+$redstar2_v4_sidecount+ $redstar2_super_sidecount; $team2_side_greentotal=$greenstar2_h2h_sidecount+$greenstar2_v5_sidecount+$greenstar2_v4_sidecount+ $greenstar2_super_sidecount; $team2_side_bluetotal=$bluestar2_h2h_sidecount+$bluestar2_v5_sidecount+$bluestar2_v4_sidecount+ $bluestar2_super_sidecount; #----------------------------------------------------------------------# #--------------------------------------------------------------------------------------------# ?>

Stars Summary

Sides

Section	RED	GREEN	BLUE
Head To Head
ATS Matchups
Team Trends
Super Stats
Total

Overs/Unders

Section	Head To Head	ATS Matchups	Team Trends	Super Stats
OVER(Red)
UNDER(Red)
OVER(Green)
UNDER(Green)
OVER(Blue)
UNDER(Blue)

Stars Summary

Sides

Section	RED	GREEN	BLUE
Head To Head
ATS Matchups
Team Trends
Super Stats
Total

Overs/Unders

Section	Head To Head	ATS Matchups	Team Trends	Super Stats
OVER(Red)
UNDER(Red)
OVER(Green)
UNDER(Green)
OVER(Blue)
UNDER(Blue)