exit();
############################################
#----This displays the 10 Random trends on the user side
#----Dispalys records if sum of count is greater than 3
#----Dispalys stars if sum of count is greater than 10
############################################
$link=mysqli_connect('localhost', 'atsdb','db_nhl009','atsrdbnhl');
#----collecting all variables for link to Number Report
$name2=preg_replace('/,/','~',$name);
#----collecting all variables
$name1=explode(",",$name);
$date=$name1[0];
$time=$name1[1];
$roadteamid=$name1[2];
$roadteam=$name1[3];
$roadteam1=strtolower($roadteam);
$hometeamid=$name1[4];
$hometeam=$name1[5];
$hometeam1=strtolower($hometeam);
$league=$name1[6];
$val=$league;
if($league=='NCAAF')
{
if($roadteam=='Texas A^M')
{
$roadteam='Texas A&M';
}
else
{$roadteam=$roadteam;
}
$roadteam1=strtolower($roadteam);
if($hometeam=='Texas A^M')
{
$hometeam='Texas A&M';
}
else
{$hometeam=$hometeam;
}
$hometeam1=strtolower($hometeam);
}
$tagroadteam=$roadteam;
$taghometeam=$hometeam;
$tagdate=$date;
$tagval=$league;
if($pst=="true")
{
}
else
{
require "Templates/header.inc.php";
}
?>
Please Wait !!!!! LOADING...................
#red down arrow path
$arrow="";
#Green Star Image Path
$star1="";
#Blue Star Image Path
$star2="";
#Red Star Image Path
$star3="";
?>
$league_qry=mysqli_query($link,"select league_no from ats_league1 where league_name='$league'");
list($lno)=mysqli_fetch_array($league_qry);
#--taking current date
include "game_times.php";
#taking pitchers name if MLB
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];
}
$league1=strtolower($league);
$table=$league1.'_teams';
if($league=='CFL')
{
$baseimgpath='http://www.atsdatabase.com/atsdb2/'.$league1.'/'.$league1.'_db3_images/';
$img1=$baseimgpath.$roadteam.'.gif';
$img2=$baseimgpath.$hometeam.'.gif';
}
elseif($league=='NFL')
{
$baseimgpath='http://www.atsdatabase.com/atsdb2/'.$league1.'/'.$league1.'_images/';
$img1=$baseimgpath.$roadteam.'.gif';
$img2=$baseimgpath.$hometeam.'.gif';
}
else
{
$baseimgpath='http://www.atsdatabase.com/atsdb2/'.$league1.'/'.$league1.'_images/';
//echo "hometeam1=$hometeam1";
$img1=$baseimgpath.$roadteam1.'.gif';
$img2=$baseimgpath.$hometeam1.'.gif';
}
/*----------------Collecting The team Name for Numbers Report Link---------------------*/
#------HOME TEAM
if($league=='MLB')
{
$hqry=mysqli_query($link,"select team_id,alias_teamname from mlb_teams where team_name='$hometeam'");
while($hrow=mysqli_fetch_array($hqry))
{
$home_team=$hrow['alias_teamname'];
$home_teamid=$hrow['team_id'];
}
$hteam=$home_team;
}
elseif($table=='nfl_teams')
{
$hqry=mysqli_query($link,"select team_id,team_name from $table where team_name='$hometeam'");
while($hrow=mysqli_fetch_array($hqry))
{
$home_team=$hrow['team_name'];
$home_teamid=$hrow['team_id'];
}
$hteam=$home_team;
}
else
{
$hqry=mysqli_query($link,"select team_id,team_name from $table where team_name='$hometeam'");
while($hrow=mysqli_fetch_array($hqry))
{
$home_team=$hrow['team_name'];
$home_teamid=$hrow['team_id'];
}
$hteam=$home_team;
}
#-------ROAD TEAM
if($league=='MLB')
{
$rqry=mysqli_query($link,"select team_id,alias_teamname from mlb_teams where team_name='$roadteam'");
while($rrow=mysqli_fetch_array($rqry))
{
$road_team=$rrow['alias_teamname'];
$road_teamid=$rrow['team_id'];
}
$rteam=$road_team;
}
elseif($table=='nfl_teams')
{
$rqry=mysqli_query($link,"select team_id,team_name from $table where team_name='$roadteam'");
while($rrow=mysqli_fetch_array($rqry))
{
$road_team=$rrow['team_name'];
$road_teamid=$rrow['team_id'];
}
$rteam=$road_team;
}
else
{
$rqry=mysqli_query($link,"select team_id,team_name from $table where team_name='$roadteam'");
while($rrow=mysqli_fetch_array($rqry))
{
$road_team=$rrow['team_name'];
$road_teamid=$rrow['team_id'];
}
$rteam=$road_team;
}
/*----------------Collecting The team Name for Numbers Report Link---------------------*/
?>
Super System :-
The Super Stats systems section is based on ATS betting Matchups using system trends which have an 80% or higher winning percentage from past situations. There are hundreds of different situations regarding a NFL football game and the ATS Super Stats database takes into consideration each facts about every teams past handicapping situations and performs special type queries to produce an 80% or higher statistical pick for bettors who are betting online or in Las Vegas.
LEAGUE:
$road_side="";
$home_side="";
$over_disp="";
$linetotal_qry=mysqli_query($link,"select * from new_asp_schedule where game_date = '$date' and league_no='$lno' and game_no1='$roadgameno' and game_no2='$homegameno'");
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;
}
}
?>
#-----collecting league trends for road team
$random_qry=mysqli_query($link,"select * from super_stats_queries where league_no='$lno' and game_date='$date' and game_number='$roadgameno' and (team_a='$roadteamid') and message like 'When ANY%' limit 10");
$ran_num=mysqli_num_rows($random_qry);
if($pacific_time>='05:45:00' and (!$ran_num))
{
?>
Due to the late line release on this game, the system will update this page at 3:00pm EST.
}
if(!$ran_num)
{
?>
Super League Trends
10 Super League Trends Not Found
}
ELSE
{
?>
10 Super League Trends
10 Super League Trends
}else{?>
10 Super League Trends
}?>
ATS
}?>
SU
O/U
Description
Win-Loss-Push
}?>
Win-Loss-Push
Over-Under-Push
Click on description to see Predictions on next game
Click on records
}?>
Click on records
Click on records
while($random_row1=mysqli_fetch_array($random_qry))
{
$ran_statsid1=$random_row1['random_id'];
$ran_message1=$random_row1['message'];
if(preg_match('/~/',$ran_message1))
{
$ran_message1=preg_replace('/~/','-',$ran_message1);
}
if(preg_match('/TEAM team/',$ran_message1))
{
$ran_message1=preg_replace('/TEAM team/','TEAM',$ran_message1);
}
$ran_ats_count1=$random_row1['ats_count'];
$ran_su_count1=$random_row1['su_count'];
#-----Check if the sum of w-l-t records is less than 3 then show it on userside
$ran_sucounter=explode("-",$ran_su_count1);
$ran_sucountwin=$ran_sucounter[0];
$ran_sucountlost=$ran_sucounter[1];
$ran_sucounttie=$ran_sucounter[2];
$ran_sutotal_wlt=$ran_sucountwin+$ran_sucountlost+$ran_sucounttie;
#-----------#
$ran_over_under1=$random_row1['over_under'];
$ran_su_per1=$random_row1['su_percentage'];
$ran_su_per1=trim($ran_su_per1);
$ran_ats_per1=$random_row1['ats_percentage'];
$ran_ats_per1=trim($ran_ats_per1);
$ran_ou_per1=$random_row1['ou_percentage'];
$ran_ou_per1=trim($ran_ou_per1);
#--su per/star
if($ran_su_per1>="0.00" && $ran_su_per1<= "35.00")
{$ran_su_star=$star3; }
elseif($ran_su_per1>="60.00" && $ran_su_per1<= "79.00")
{$ran_su_star=$star1; }
elseif($ran_su_per1>="80.00" && $ran_su_per1<= "100.00")
{$ran_su_star=$star2; }
else{$ran_su_star="";}
#--ats per/star
if($ran_ats_per1>= "0.00" && $ran_ats_per1<= "35.00")
{$ran_ats_star=$star3; }
elseif($ran_ats_per1>="60.00" && $ran_ats_per1<= "79.00")
{$ran_ats_star=$star1; }
elseif($ran_ats_per1>="80.00" && $ran_ats_per1<= "100.00")
{$ran_ats_star=$star2; }
else{$ran_ats_star=""; }
#--ou per/star
if($ran_ou_per1>= "0.00" && $ran_ou_per1<= "35.00")
{$ran_ou_star=$star3; }
elseif($ran_ou_per1>="60.00" && $ran_ou_per1<= "79.00")
{$ran_ou_star=$star1; }
elseif($ran_ou_per1>="80.00" && $ran_ou_per1<= "100.00")
{$ran_ou_star=$star2; }
else{$ran_ou_star=""; }
#-----Check if the sum of w-l-t records is less than 3 then dont show it on userside
if($ran_sutotal_wlt >=3)
{
?>
#-----Check if the sum of w-l-t records is less than 10 then dont show stars on userside
if($ran_sutotal_wlt >=10)
{
if($league!='MLB')
{
?>
}#end else for if($ran_sutotal_wlt >=10)
}#if($ran_sutotal_wlt >=3)
}#end while
?>
}#end if r_roadnum
?>
#-------collecting league trends for home team
$random_qry=mysqli_query($link,"select * from super_stats_queries where league_no='$lno' and game_date='$date' and game_number='$homegameno' and (team_a='$hometeamid') and message like 'When ANY%' limit 10");
$ran_num=mysqli_num_rows($random_qry);
if(!$ran_num)
{
?>
Super League Trends
10 Super League Trends Not Found
}
ELSE
{
?>
10 Super League Trends
10 Super League Trends
}else{?>
10 Super League Trends
}?>
ATS
}?>
SU
O/U
Description
Win-Loss-Push
}?>
Win-Loss-Push
Over-Under-Push
Click on description to see Predictions on next game
Click on records
}?>
Click on records
Click on records
while($random_row1=mysqli_fetch_array($random_qry))
{
$ran_statsid1=$random_row1['random_id'];
$ran_message1=$random_row1['message'];
if(preg_match('/~/',$ran_message1))
{
$ran_message1=preg_replace('/~/','-',$ran_message1);
}
if(preg_match('/TEAM team/',$ran_message1))
{
$ran_message1=preg_replace('/TEAM team/','TEAM',$ran_message1);
}
$ran_ats_count1=$random_row1['ats_count'];
$ran_su_count1=$random_row1['su_count'];
#-----Check if the sum of w-l-t records is less than 3 then show it on userside
$ran_sucounter=explode("-",$ran_su_count1);
$ran_sucountwin=$ran_sucounter[0];
$ran_sucountlost=$ran_sucounter[1];
$ran_sucounttie=$ran_sucounter[2];
$ran_sutotal_wlt=$ran_sucountwin+$ran_sucountlost+$ran_sucounttie;
#-----------#
$ran_over_under1=$random_row1['over_under'];
$ran_su_per1=$random_row1['su_percentage'];
$ran_su_per1=trim($ran_su_per1);
$ran_ats_per1=$random_row1['ats_percentage'];
$ran_ats_per1=trim($ran_ats_per1);
$ran_ou_per1=$random_row1['ou_percentage'];
$ran_ou_per1=trim($ran_ou_per1);
#--su per/star
if($ran_su_per1>="0.00" && $ran_su_per1<= "35.00")
{$ran_su_star=$star3; }
elseif($ran_su_per1>="60.00" && $ran_su_per1<= "79.00")
{$ran_su_star=$star1; }
elseif($ran_su_per1>="80.00" && $ran_su_per1<= "100.00")
{$ran_su_star=$star2; }
else{$ran_su_star="";}
#--ats per/star
if($ran_ats_per1>= "0.00" && $ran_ats_per1<= "35.00")
{$ran_ats_star=$star3; }
elseif($ran_ats_per1>="60.00" && $ran_ats_per1<= "79.00")
{$ran_ats_star=$star1; }
elseif($ran_ats_per1>="80.00" && $ran_ats_per1<= "100.00")
{$ran_ats_star=$star2; }
else{$ran_ats_star=""; }
#--ou per/star
if($ran_ou_per1>= "0.00" && $ran_ou_per1<= "35.00")
{$ran_ou_star=$star3; }
elseif($ran_ou_per1>="60.00" && $ran_ou_per1<= "79.00")
{$ran_ou_star=$star1; }
elseif($ran_ou_per1>="80.00" && $ran_ou_per1<= "100.00")
{$ran_ou_star=$star2; }
else{$ran_ou_star=""; }
#-----Check if the sum of w-l-t records is less than 3 then dont show it on userside
if($ran_sutotal_wlt >=3)
{
?>
#-----Check if the sum of w-l-t records is less than 10 then dont show stars on userside
if($ran_sutotal_wlt >=10)
{
if($league!='MLB')
{
?>