
#---- sets database host name
$db_hostname = "localhost";
#--- sets database username
$db_username = "atsdb";
#---- sets database password
$db_password = "db_nhl009";
#---- sets database name
$db_name = "atsrdbnhl";
#----- connects to mysql database with the specified hostname, username & password
mysql_connect($db_hostname, $db_username, $db_password);
#---- selects the database
mysql_select_db($db_name);
#--- this variable is set to coloe the connection in downformat.inc.php
$dbconnect = "true";
//require "http://www.atsdatabase.com/Templates/db_conn.inc.php";
/*if($pst=="true")
{
}
else
{
require "Templates/atsdb2_header_new.php";
}*/
include "http://www.atsdatabase.com/game_times.php";
#---- create expiry date
?>
| Strength of Schedule :- |
The following Strength of Schedule takes into effect each teams opponents winning percentage and produces a winning percentage. Furthermore, the Power Rating is determined by the SOS and the team's current winning percentage and produces that teams Power Rating. Sometimes a teams winning record can be deceiving, especially when their SOS is below 40% or lower.
|
function formatdate($sqldate)
{
list($yyyy, $mm, $dd) = explode('-',$sqldate);
$date = date('m-d-Y', mktime(0,0,0,$mm,$dd,$yyyy));
return $date;
}
$array=array('CFL','NFL','NHL','NBA','MLB');
for($a=0;$a='08')
$cur_year=date('Y');
else
$cur_year=date('Y')-1;
$next_year=$cur_year+1;
}
else
{
$cur_year=date('Y');
}
if($value=='NFL')
{ $start_month='09' ;$end_month='02';
$end_date=$next_year.'-'.$end_month;
}
elseif($value=='NBA')
{
$start_month='10' ;$end_month='06';
$end_date=$next_year.'-'.$end_month;
}
elseif($value=='NHL')
{
$start_month='09' ;$end_month='06';
$end_date=$next_year.'-'.$end_month;
}
elseif($value=='CFL')
{
$start_month='06' ;$end_month='11';
$end_date=$cur_year.'-'.$end_month;
}
elseif($value=='NCAAF')
{
$start_month='08' ;$end_month='02';
$end_date=$next_year.'-'.$end_month;
}
elseif($value=='NCAAB')
{
$start_month='10' ;$end_month='04';
$end_date=$next_year.'-'.$end_month;
}
$start_date=$cur_year.'-'.$start_month;
$dateclause="( left(date,7) between '$start_date' and '$end_date' )";
//echo "select league_no,league_id,league_name from ats_league1 where league_name='$value' ";
$leagueqry=mysql_query("select league_no,league_id,league_name from ats_league1 where league_name='$value'");
list($lno,$lid,$lname)=mysql_fetch_array($leagueqry);
?>
PR :- Power Rating ,W-L :-Win Loss
| TeamName |
Current Season |
if($value=='CFL' || $value=='NFL')
{
?>
Last 3 Games |
Last 7 Games |
}
else
{
?>
Last 7 Games |
Last 14 Games |
}
?>
| TeamName |
W-L |
Win % |
Loss % |
SOS % |
P R |
W-L |
Win % |
Loss % |
SOS % |
P R |
W-L |
Win % |
Loss % |
SOS % |
P R |
$newwintot='';$newlosstot='';$newwinperval='';
if($value=='CFL')
{
$select11="select * from ats_sos where league_name='$value' and team_name!='OTTAWA' order by team_name";
}
elseif($value=='NHL')
{
$select11="select * from ats_sos where league_name='$value' and team_name!='HARTFORD' order by team_name";
}
else
{
$select11="select * from ats_sos where league_name='$value' order by team_name";
}
$select1=mysql_query($select11);
$num1=mysql_num_rows($select1);
while($srow1=mysql_fetch_array($select1))
{
$team_id=$srow1['team_id'];
$team_name=$srow1['team_name'];
$win=$srow1['win'];
$loss=$srow1['loss'];
$winper=$srow1['winper'];
$lossper=$srow1['lossper'];
$sosper=$srow1['sosper'];
$power_rating=$srow1['power_rating'];
$powerrating=round($power_rating/100,2);
if($powerrating=='0.1' || $powerrating=='0.2' || $powerrating=='0.3' || $powerrating=='0.4' || $powerrating=='0.5' ||$powerrating=='0.6' ||$powerrating=='0.7' || $powerrating=='0.8' ||$powerrating=='0.9' )
{
$powerrating=$powerrating.'0';
}
elseif($powerrating=='0')
{
$powerrating='0.00';
}
else
{
$powerrating=$powerrating;
}
/*********************Last 3 **************************/
$win3_loss3=$srow1['win3_loss3'];
$winloss3=explode("_",$win3_loss3);
$win3=$winloss3[0];
$loss3=$winloss3[1];
$winper3_lossper3 =$srow1['winper3_lossper3'];
$winlossper3=explode("_",$winper3_lossper3);
$winper3=$winlossper3[0];
$lossper3=$winlossper3[1];
$sos_per3 =$srow1['sos_per3'];
$power_rating3=$srow1['power_rating3'];
$powerrating3=round($power_rating3/100,2);
if($powerrating3=='0.1' || $powerrating3=='0.2' || $powerrating3=='0.3' || $powerrating3=='0.4' || $powerrating3=='0.5' ||$powerrating3=='0.6' ||$powerrating3=='0.3' || $powerrating3=='0.8' ||$powerrating3=='0.9' )
{
$powerrating3=$powerrating3.'0';
}
elseif($powerrating3=='0')
{
$powerrating3='0.00';
}
else
{$powerrating3=$powerrating3;
}
/*********************************************************/
/*********************Last 7 **************************/
$win7_loss7=$srow1['win7_loss7'];
$winloss7=explode("_",$win7_loss7);
$win7=$winloss7[0];
$loss7=$winloss7[1];
$winper7_lossper7 =$srow1['winper7_lossper7'];
$winlossper7=explode("_",$winper7_lossper7);
$winper7=$winlossper7[0];
$lossper7=$winlossper7[1];
$sos_per7 =$srow1['sos_per7'];
$power_rating7=$srow1['power_rating7'];
$powerrating7=round($power_rating7/100,2);
if($powerrating7=='0.1' || $powerrating7=='0.2' || $powerrating7=='0.3' || $powerrating7=='0.4' || $powerrating7=='0.5' ||$powerrating7=='0.6' ||$powerrating7=='0.7' || $powerrating7=='0.8' ||$powerrating7=='0.9' )
{
$powerrating7=$powerrating7.'0';
}
elseif($powerrating7=='0')
{
$powerrating7='0.00';
}
else
{$powerrating7=$powerrating7;
}
/*********************************************************/
/*********************Last 14 **************************/
$win14_loss14=$srow1['win14_loss14'];
$winloss14=explode("_",$win14_loss14);
$win14=$winloss14[0];
$loss14=$winloss14[1];
$winper14_lossper14 =$srow1['winper14_lossper14'];
$winlossper14=explode("_",$winper14_lossper14);
$winper14=$winlossper14[0];
$lossper14=$winlossper14[1];
$sos_per14 =$srow1['sos_per14'];
$power_rating14=$srow1['power_rating14'];
$powerrating14=round($power_rating14/100,2);
if($powerrating14=='0.1' || $powerrating14=='0.2' || $powerrating14=='0.3' || $powerrating14=='0.4' || $powerrating14=='0.5' ||$powerrating14=='0.6' ||$powerrating14=='0.7' || $powerrating14=='0.8' ||$powerrating14=='0.9' )
{
$powerrating14=$powerrating14.'0';
}
elseif($powerrating14=='0')
{
$powerrating14='0.00';
}
else
{
$powerrating14=$powerrating14;
}
/*********************************************************/
?>
|
- |
|
|
|
|
- |
|
|
|
|
- |
|
|
|
|
}
else
{
?>
- |
|
|
|
|
- |
|
|
|
|
}?>
}
?>
}
?>
/*if($pst=="true")
{
}
elseif($pstpicks=="true")
{
}
else
{
require "Templates/atsdb2_footer_new.php";
}*/
?>
|
|