############################################
#----This displays the 50 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
############################################
exit();
require "Templates/db_conn.inc.php";
#----collecting all variables for link to Number Report
$name22=$name;
$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=mysql_query("select league_no from ats_league1 where league_name='$league'");
list($lno)=mysql_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=mysql_query("select team_id,alias_teamname from mlb_teams where team_name='$hometeam'");
while($hrow=mysql_fetch_array($hqry))
{
$home_team=$hrow['alias_teamname'];
$home_teamid=$hrow['team_id'];
}
$hteam=$home_team;
}
elseif($table=='nfl_teams')
{
$hqry=mysql_query("select team_id,team_name from $table where team_name='$hometeam'");
while($hrow=mysql_fetch_array($hqry))
{
$home_team=$hrow['team_name'];
$home_teamid=$hrow['team_id'];
}
$hteam=$home_team;
}
else
{
$hqry=mysql_query("select team_id,team_name from $table where team_name='$hometeam'");
while($hrow=mysql_fetch_array($hqry))
{
$home_team=$hrow['team_name'];
$home_teamid=$hrow['team_id'];
}
$hteam=$home_team;
}
#-------ROAD TEAM
if($league=='MLB')
{
$rqry=mysql_query("select team_id,alias_teamname from mlb_teams where team_name='$roadteam'");
while($rrow=mysql_fetch_array($rqry))
{
$road_team=$rrow['alias_teamname'];
$road_teamid=$rrow['team_id'];
}
$rteam=$road_team;
}
elseif($table=='nfl_teams')
{
$rqry=mysql_query("select team_id,team_name from $table where team_name='$roadteam'");
while($rrow=mysql_fetch_array($rqry))
{
$road_team=$rrow['team_name'];
$road_teamid=$rrow['team_id'];
}
$rteam=$road_team;
}
else
{
$rqry=mysql_query("select team_id,team_name from $table where team_name='$roadteam'");
while($rrow=mysql_fetch_array($rqry))
{
$road_team=$rrow['team_name'];
$road_teamid=$rrow['team_id'];
}
$rteam=$road_team;
}
/*----------------Collecting The team Name for Numbers Report Link---------------------*/
?>
Team Trends :-
The ATS Database team trends section is based on prior stats reflecting how certain sports teams performed in past handicapping situations against the point spread. In effect, there are two types of sports betting stats and trends on this page: you have Team Trends and System Trends. A team trend is when you have one team in an exact past situation. Example: When the Dallas Cowboys are a Home favorite playing in September. System Trend is when "ANY NFL team" is a Home favorite playing in September. Please note, betting trends can be a double-edge sword at times, as it could help or cloud your judgment when handicapping your games. Nevertheless, they are actual facts about the current game situation and sometimes they can be used to confirm your original thought.
LEAGUE:
$road_side="";
$home_side="";
$over_disp="";
$linetotal_qry=mysql_query("select * from new_asp_schedule where game_date = '$date' and league_no='$lno' and game_no1='$roadgameno' and game_no2='$homegameno'");
while($row=mysql_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 team trends for road team
$random_qry=mysql_query("select * from random_queries where league_no='$lno' and game_date='$date' and game_number='$roadgameno' and (team_a='$roadteamid') and message not like 'When ANY%' limit 20");
$ran_num=mysql_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)
{
?>
Random Team Trends
Random Team Trends Not Found
}
ELSE
{
?>
20 Random Team Trends
20 Random Team Trends
}else{?>
20 Random Team 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=mysql_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);
}
$ran_ats_count1=$random_row1['ats_count'];
$ran_su_count1=$random_row1['su_count'];
$ran_ou_count1=$random_row1['over_under'];
#-----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_sutotal_wlt=$ran_sucountwin+$ran_sucountlost;
#-----------#
$ran_atscounter=explode("-",$ran_ats_count1);
$ran_atscountwin=$ran_atscounter[0];
$ran_atscountlost=$ran_atscounter[1];
$ran_atscounttie=$ran_atscounter[2];
//$ran_atstotal_wlt=$ran_atscountwin+$ran_atscountlost+$ran_atscounttie;
$ran_atstotal_wlt=$ran_atscountwin+$ran_atscountlost;
#-----------#
$ran_oucounter=explode("-",$ran_ou_count1);
$ran_oucountwin=$ran_oucounter[0];
$ran_oucountlost=$ran_oucounter[1];
$ran_oucounttie=$ran_oucounter[2];
//$ran_outotal_wlt=$ran_oucountwin+$ran_oucountlost+$ran_oucounttie;
$ran_outotal_wlt=$ran_oucountwin+$ran_oucountlost;
#-----------#
$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_sutotal_wlt>='10') && ($ran_su_per1>="0.00" && $ran_su_per1<= "35.00"))
{$ran_su_star=$star3; }
elseif(($ran_sutotal_wlt>='10') && ($ran_su_per1>="60.00" && $ran_su_per1<= "79.00"))
{$ran_su_star=$star1; }
elseif(($ran_sutotal_wlt>='10') && ($ran_su_per1>="80.00" && $ran_su_per1<= "100.00") )
{$ran_su_star=$star2; }
else{$ran_su_star="";}
#--ats per/star
if(($ran_atstotal_wlt>='10') && ($ran_ats_per1>= "0.00" && $ran_ats_per1<= "35.00"))
{$ran_ats_star=$star3; }
elseif(($ran_atstotal_wlt>='10') && ($ran_ats_per1>="60.00" && $ran_ats_per1<= "79.00"))
{$ran_ats_star=$star1; }
elseif(($ran_atstotal_wlt>='10') && ($ran_ats_per1>="80.00" && $ran_ats_per1<= "100.00") )
{$ran_ats_star=$star2; }
else{$ran_ats_star=""; }
#--ou per/star
if(($ran_outotal_wlt>='10') && ($ran_ou_per1>= "0.00" && $ran_ou_per1<= "35.00"))
{$ran_ou_star=$star3; }
elseif(($ran_outotal_wlt>='10') && ($ran_ou_per1>="60.00" && $ran_ou_per1<= "79.00"))
{$ran_ou_star=$star1; }
elseif(($ran_outotal_wlt>='10') && ($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($league!='MLB')
{
?>
}#end if($league!='MLB')
?>
}#if($ran_sutotal_wlt >=3)
}#end while
?>
}#end if r_roadnum
?>
#------colllecting team trends for home team
$random_qry=mysql_query("select * from random_queries where league_no='$lno' and game_date='$date' and game_number='$homegameno' and (team_a='$hometeamid') and message not like 'When ANY%' limit 20");
$ran_num=mysql_num_rows($random_qry);
if(!$ran_num)
{
?>
Random Team Trends
Team Trends Not Found
}
ELSE
{
?>
20 Random Team Trends
20 Random Team Trends
}else{?>
20 Random Team 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=mysql_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);
}
$ran_ats_count1=$random_row1['ats_count'];
$ran_su_count1=$random_row1['su_count'];
$ran_ou_count1=$random_row1['over_under'];
#-----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_sutotal_wlt=$ran_sucountwin+$ran_sucountlost;
#-----------#
$ran_atscounter=explode("-",$ran_ats_count1);
$ran_atscountwin=$ran_atscounter[0];
$ran_atscountlost=$ran_atscounter[1];
$ran_atscounttie=$ran_atscounter[2];
//$ran_atstotal_wlt=$ran_atscountwin+$ran_atscountlost+$ran_atscounttie;
$ran_atstotal_wlt=$ran_atscountwin+$ran_atscountlost;
#-----------#
$ran_oucounter=explode("-",$ran_ou_count1);
$ran_oucountwin=$ran_oucounter[0];
$ran_oucountlost=$ran_oucounter[1];
$ran_oucounttie=$ran_oucounter[2];
//$ran_outotal_wlt=$ran_oucountwin+$ran_oucountlost+$ran_oucounttie;
$ran_outotal_wlt=$ran_oucountwin+$ran_oucountlost;
#-----------#
$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_sutotal_wlt>='10') && ($ran_su_per1>="0.00" && $ran_su_per1<= "35.00"))
{$ran_su_star=$star3; }
elseif(($ran_sutotal_wlt>='10') && ($ran_su_per1>="60.00" && $ran_su_per1<= "79.00"))
{$ran_su_star=$star1; }
elseif(($ran_sutotal_wlt>='10') && ($ran_su_per1>="80.00" && $ran_su_per1<= "100.00"))
{$ran_su_star=$star2; }
else{$ran_su_star="";}
#--ats per/star
if(($ran_atstotal_wlt>='10') && ($ran_ats_per1>= "0.00" && $ran_ats_per1<= "35.00"))
{$ran_ats_star=$star3; }
elseif(($ran_atstotal_wlt>='10') && ($ran_ats_per1>="60.00" && $ran_ats_per1<= "79.00"))
{$ran_ats_star=$star1; }
elseif(($ran_atstotal_wlt>='10') && ($ran_ats_per1>="80.00" && $ran_ats_per1<= "100.00"))
{$ran_ats_star=$star2; }
else{$ran_ats_star=""; }
#--ou per/star
if(($ran_outotal_wlt>='10') && ($ran_ou_per1>= "0.00" && $ran_ou_per1<= "35.00"))
{$ran_ou_star=$star3; }
elseif(($ran_outotal_wlt>='10') && ($ran_ou_per1>="60.00" && $ran_ou_per1<= "79.00"))
{$ran_ou_star=$star1; }
elseif(($ran_outotal_wlt>='10') && ($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($league!='MLB')
{
?>