############################################ #----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 ############################################ $link=mysqli_connect('localhost', 'atsdb','db_nhl009','atsrdbnhl'); require "Templates/header.inc.php"; #----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; ?>
| Please Wait !!!!! LOADING................... |
";
#Green Star Image Path
$star1="
";
#Blue Star Image Path
$star2="
";
#Red Star Image Path
$star3="
";
?>
Print |
$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='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';
}
/*----------------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---------------------*/
?>
|
Star System : 35% or lower = 60%-79%= 80%-100%= |
|
You Are Here TEAM TRENDS REPORT |
| Due to the late line release on this game, the system will update this page at 3:00pm EST. |
| Random Team Trends |
| Random Team Trends Not Found |
| 50 Random Team Trends |
| Random League Trends |
| 50 Random League Trends Not Found |
| 50 Random League Trends |
| Random Team Trends |
| Team Trends Not Found |
| 50 Random Team Trends |
| Random League Trends |
| 50 Random League Trends Not Found |
| 50 Random League Trends |