"; #Green Star Image Path $star1="

"; #Blue Star Image Path $star2="

"; #Red Star Image Path $star3="

"; #get the teamname if($league=='MLB') { $mlbqry1=mysqli_query($link,"select team_name from mlb_teams where (alias_teamname='$ateam' or team_name='$ateam') "); list($ateamname)=mysqli_fetch_array($mlbqry1); $mlbqry2=mysqli_query($link,"select team_name from mlb_teams where (alias_teamname='$bteam' or team_name='$bteam' )"); list($bteamname)=mysqli_fetch_array($mlbqry2); } elseif($league=='NFL') { $ateamname=$ateam; $bteamname=$bteam; $nflqry1=mysqli_query($link,"select team_shortname from nfl_teams where team_name='$ateam' "); list($a1teamname)=mysqli_fetch_array($nflqry1); $nflqry2=mysqli_query($link,"select team_shortname from nfl_teams where team_name='$bteam' "); list($b1teamname)=mysqli_fetch_array($nflqry2); } else { $ateamname=$ateam; $bteamname=$bteam; } if($league=='MLB') { $roadpitcher=$name1[7]; $roadpithand=$name1[8]; $homepitcher=$name1[9]; $homepithand=$name1[10]; $roadgameno=$name1[11]; $homegameno=$name1[12]; } else { $roadgameno=$name1[7]; $homegameno=$name1[8]; }#-----Images Path $league1=strtolower($league); $table=$league1.'_teams'; $ateamname1=strtolower($ateamname); $bteamname1=strtolower($bteamname); $folder=strtolower($leaguename); if($league=='CFL') { $baseimgpath='atsdb2/'.$league1.'/'.$league1.'_db3_images/'; $img1=$baseimgpath.$roadteam.'.gif'; $img2=$baseimgpath.$hometeam.'.gif'; } elseif($league=='NFL') { $baseimgpath='atsdb2/'.$league1.'/'.$league1.'_images/'; $img1=$baseimgpath.$roadteam.'.gif'; $img2=$baseimgpath.$hometeam.'.gif'; } else { $baseimgpath='atsdb2/'.$league1.'/'.$league1.'_images/'; //echo "hometeam1=$hometeam1"; $img1=$baseimgpath.$roadteam1.'.gif'; $img2=$baseimgpath.$hometeam1.'.gif'; } $rteam=$roadteam;$hteam=$hometeam; $sel_league=mysqli_query($link,"select league_no from ats_league1 where league_name='$league'"); list($lno)=mysqli_fetch_array($sel_league); $league1=strtolower($league); $table=$league1.'_teams'; $road_side=""; $home_side=""; $over_disp=""; $linetotal_qry=mysqli_query($link,"select * from new_asp_schedule where game_date = '$newdate' and league_no='$lno' and game_no1='$newteam1_gameno' and game_no2='$newteam2_gameno'"); while($row=mysqli_fetch_array($linetotal_qry)) { $team1_spread=$row['team1_spread']; $team2_spread=$row['team2_spread']; $team1_ML=$row['team1_ML']; $team2_ML=$row['team2_ML']; $game_total=$row['game_total']; if($lno=='5' || $lno=='7') { $road_side=$team1_ML; $home_side=$team2_ML; $over_disp=$game_total; } else { $road_side=$team1_spread; $home_side=$team2_spread; $over_disp=$game_total; } } ?>

LEAGUE:
O/U: Pitcher : ()	Vs. Date: Time:	O/U: Pitcher :()

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

You Are Here SMART STATS REPORT

"; $stats_qry1=mysqli_query($link,"select * from ats_smartstats where league_no='$lno' and game_date between '$startdate' and '$enddate' and (team_a='$newteam1_id' and game_number='$newteam1_gameno') order by random_id desc limit 10 "); $snum1=mysqli_num_rows($stats_qry1); if(!$snum1) { ?>

Trends System

Trends Not Found

"; #-------query to retrieve only team trends as road $stats_roadqry=mysqli_query($link,"select * from ats_smartstats where league_no='$lno' and game_date between '$startdate' and '$enddate' and (team_a='$newteam1_id' and game_number='$newteam1_gameno') order by random_id desc limit 10 "); $s_roadnum=mysqli_num_rows($stats_roadqry); if(!$s_roadnum) { ?>

Team Trends

Team Trends Not Found

Team System Trends

0 #--for red star=> 1 #--for green star=> 2 #--for blue star=> 3 switch($ats_stars) { case '0': $ats_star=""; break; case '1': $ats_star=$star3; break; case '2': $ats_star=$star1; break; case '3': $ats_star=$star2; break; } switch($su_stars) { case '0': $su_star=""; break; case '1': $su_star=$star3; break; case '2': $su_star=$star1; break; case '3': $su_star=$star2; break; } switch($ou_stars) { case '0': $ou_star=""; break; case '1': $ou_star=$star3; break; case '2': $ou_star=$star1; break; case '3': $ou_star=$star2; break; } /*------End of new code to chk star----------*/ $count_sum1=$stats_row1['count_sum']; $count_sum1=trim($count_sum1); $csum1=explode("~",$count_sum1); $ats_csum1=$csum1[0]; $su_csum1=$csum1[1]; $ou_csum1=$csum1[2]; #-----Check if the sum of w-l-t records is less than 3 then dont show it on userside if($su_csum1 >=3) { ?> =10) {?> =10) else {?> =10) }#-if($league!='MLB') #-----SUWinner if($su_csum1 >=10) { ?> =10) else { ?> =10) #-----Over/Under if($over_under1=='0-0-0') { ?> =10) { ?> =10) else { ?> =10) } ?> =3) }#end while ?>

Team Trends				Team Trends
	ATS	SU	O/U
Description	Win-Loss-Push	Win-Loss-Push	Over-Under-Push

Trends System

Trends Not Found

Team Trends

Team Trends Not Found

Team System Trends

0 #--for red star=> 1 #--for green star=> 2 #--for blue star=> 3 switch($ats_stars2) { case '0': $ats_star2=""; break; case '1': $ats_star2=$star3; break; case '2': $ats_star2=$star1; break; case '3': $ats_star2=$star2; break; } switch($su_stars2) { case '0': $su_star2=""; break; case '1': $su_star2=$star3; break; case '2': $su_star2=$star1; break; case '3': $su_star2=$star2; break; } switch($ou_stars2) { case '0': $ou_star2=""; break; case '1': $ou_star2=$star3; break; case '2': $ou_star2=$star1; break; case '3': $ou_star2=$star2; break; } /*------End of new code to chk star----------*/ $count_sum2=$stats_row2['count_sum']; $count_sum2=trim($count_sum2); $csum2=explode("~",$count_sum2); $ats_csum2=$csum2[0]; $su_csum2=$csum2[1]; $ou_csum2=$csum2[2]; #-----Check if the sum of w-l-t records is less than 3 then dont show it on userside if($su_csum2 >=3) { ?> =10) { ?> =10) else { ?> =10) }#if($league!='MLB') #-----SUWinner if($su_csum2 >=10) { ?> =10) else { ?> =10) #-----Over/Under if($over_under2=='0-0-0') { ?> =10) { ?> =10) else { ?> =10) } ?> =3) }#end while ?>

Team Trends				Team Trends
	ATS	SU	O/U
Description	Win-Loss-Push	Win-Loss-Push	Over-Under-Push