2015-Stats

Please select from the following options to display statistics from season 1.

[insert_php]
global $vdisps;
global $vdispt;
global $vdispo;
global $vdispc;
global $pageop;
global $teamop;
global $tdisp;
global $sortop;
global $odisp;
global $champ;
global $champcode;

$vdisps = $_GET[‘page’];
$vdispt = $_GET[‘d’];
$vdispo = $_GET[‘sort’];
$vdispc = $_GET[‘c’];

if ($vdispt == “0”) {
$teamop=”&d=0″; $tdisp = “”;
} else if ($vdispt == “1”) {
$teamop=”&d=1″; $tdisp = “WHERE Team=’NYC'”;
} else if ($vdispt == “2”) {
$teamop=”&d=2″; $tdisp = “WHERE Team=’BOS'”;
} else if ($vdispt == “3”) {
$teamop=”&d=3″; $tdisp = “WHERE Team=’WAS'”;
} else if ($vdispt == “4”) {
$teamop=”&d=4″; $tdisp = “WHERE Team=’OTT'”;
} else if ($vdispt == “5”) {
$teamop=”&d=5″; $tdisp = “WHERE Team=’IND'”;
} else if ($vdispt == “6”) {
$teamop=”&d=6″; $tdisp = “WHERE Team=’CLE'”;
} else if ($vdispt == “7”) {
$teamop=”&d=7″; $tdisp = “WHERE Team=’DET'”;
} else if ($vdispt == “8”) {
$teamop=”&d=8″; $tdisp = “WHERE Team=’ROC'”;
}

if ($vdispc == “1”) {
$champ=”&c=1″; $champcode=”ChampS1 “;
} else if ($vdispc == “2”) {
$champ=”&c=2″; $champcode=”CombinedS1 “;
} else {
$champ=”&c=0”; $champcode=”S1 “; $vdispc=”0”;
}

if ($vdispo == “1”) {
$sortop=”&sort=1″; $odisp=” ORDER BY FirstName”;
} else if ($vdispo == “2”) {
$sortop=”&sort=2″; $odisp=” ORDER BY LastName”;
} else if ($vdispo == “3”) {
$sortop=”&sort=3″; $odisp=” ORDER BY Team”;
} else if ($vdispo == “4”) {
$sortop=”&sort=4″; $odisp=” ORDER BY `Total Goals` DESC”;
} else if ($vdispo == “5”) {
$sortop=”&sort=5″; $odisp=” ORDER BY `Total Assists` DESC”;
} else if ($vdispo == “6”) {
$sortop=”&sort=6″; $odisp=” ORDER BY `Total Shots` DESC”;
} else if ($vdispo == “7”) {
$sortop=”&sort=7″; $odisp=” ORDER BY `Total Turnovers` DESC”;
} else if ($vdispo == “8”) {
$sortop=”&sort=8″; $odisp=” ORDER BY `Total Takeaways` DESC”;
} else if ($vdispo == “9”) {
$sortop=”&sort=9″; $odisp=” ORDER BY `Total Blocks` DESC”;
} else if ($vdispo == “10”) {
$sortop=”&sort=10″; $odisp=” ORDER BY Beats DESC”;
} else if ($vdispo == “11”) {
$sortop=”&sort=11″; $odisp=” ORDER BY BeatAttempts DESC”;
} else if ($vdispo == “12”) {
$sortop=”&sort=12″; $odisp=” ORDER BY ABR DESC”;
} else if ($vdispo == “13”) {
$sortop=”&sort=13″; $odisp=” ORDER BY TurnoversForced DESC”;
} else if ($vdispo == “14”) {
$sortop=”&sort=14″; $odisp=” ORDER BY ControlLost DESC”;
} else if ($vdispo == “15”) {
$sortop=”&sort=15″; $odisp=” ORDER BY ControlGained DESC”;
} else if ($vdispo == “16”) {
$sortop=”&sort=16″; $odisp=” ORDER BY NoBludgersForced DESC”;
} else if ($vdispo == “17”) {
$sortop=”&sort=17″; $odisp=” ORDER BY `Total Games` DESC”;
} else if ($vdispo == “18”) {
$sortop=”&sort=18″; $odisp=” ORDER BY `Average Goals` DESC”;
} else if ($vdispo == “19”) {
$sortop=”&sort=19″; $odisp=” ORDER BY `Average Assists` DESC”;
} else if ($vdispo == “20”) {
$sortop=”&sort=20″; $odisp=” ORDER BY `Average Shots` DESC”;
} else if ($vdispo == “21”) {
$sortop=”&sort=21″; $odisp=” ORDER BY `Average Turnovers` DESC”;
} else if ($vdispo == “22”) {
$sortop=”&sort=22″; $odisp=” ORDER BY `Average Takeaways` DESC”;
} else if ($vdispo == “23”) {
$sortop=”&sort=23″; $odisp=” ORDER BY `Average Blocks` DESC”;
} else if ($vdispo == “24”) {
$sortop=”&sort=24″; $odisp=” ORDER BY `Total Games` DESC”;
} else if ($vdispo == “25”) {
$sortop=”&sort=25″; $odisp=” ORDER BY `Average Beats` DESC”;
} else if ($vdispo == “26”) {
$sortop=”&sort=26″; $odisp=” ORDER BY `Average Beat Attempts` DESC”;
} else if ($vdispo == “27”) {
$sortop=”&sort=27″; $odisp=” ORDER BY `Average Turnovers Forced` DESC”;
} else if ($vdispo == “28”) {
$sortop=”&sort=28″; $odisp=” ORDER BY `Average Control Lost` DESC”;
} else if ($vdispo == “29”) {
$sortop=”&sort=29″; $odisp=” ORDER BY `Average Control Gained` DESC”;
} else if ($vdispo == “30”) {
$sortop=”&sort=30″; $odisp=” ORDER BY `Average No-Bludgers Forced` DESC”;
}

[/insert_php]

SELECT TEAM TO DISPLAY

All Teams
NYC
BOS
WAS
OTT
IND
CLE
DET
ROC

SELECT GAMES:

Regular Season Championship Combined

Note: Team stats are not available for championship games.

STATS TO DISPLAY

Team Stats Individual Quaffle Stats Individual Average Quaffle Stats Individual Beater Stats Individual Average Beater Stats

[insert_php]
if ($vdisps == “a1”) {
$connection = mysql_connect(‘remote-mysql3.servage.net’, ‘qdb2’, ‘QDB2admin999’);
mysql_select_db(‘qdb2’);
$query = “SELECT * FROM TotalQuaffleStats”.$champcode.$tdisp.$odisp;
$result = mysql_query($query);
echo ”

2015 MLQ Stats

“;
echo ”

Individual Quaffle Stats“;
echo ‘

‘;
echo ‘

‘; echo ”

First Name Last Name Team Total Goals Total Assists Total Shots Total Turnovers Total Takeaways Total Blocks

“;
$count=0;
while($row = mysql_fetch_array($result)){
$print=””;
if (($count % 2) == 1) { $print=” bgcolor=\”#DDFFFF\””; }
echo “<tr”.$print.”>

” . $row[‘FirstName’] . “” . $row[‘LastName’] . “” . $row[‘Team’] . “” . $row[‘Total Goals’] . “” . $row[‘Total Assists’] . “” . $row[‘Total Shots’] . “” . $row[‘Total Turnovers’] . “” . $row[‘Total Takeaways’] . “” . $row[‘Total Blocks’] . ”

\r\n”;
$count++;
}
echo ”

“;
echo ”

“;
mysql_close();
} else if ($vdisps == “b1”) {
$connection = mysql_connect(‘remote-mysql3.servage.net’, ‘qdb2’, ‘QDB2admin999’);
mysql_select_db(‘qdb2’);
$query = “SELECT * FROM TotalQuaffleStatsPerGame”.$champcode.$tdisp.$odisp;
$result = mysql_query($query);
echo ”

2015 MLQ Stats

“;
echo ”

Quaffle Stats Per Game“;
echo ‘

‘;
echo ‘

‘; // start a table tag in the HTML echo ”

First Name Last Name Team Games Rostered Avg Goals Avg Assists Avg Shots Avg Turnovers Avg Takeaways Avg Blocks

“;
$count=0;
while($row = mysql_fetch_array($result)){
$print=””;
if (($count % 2) == 1) { $print=” bgcolor=\”#DDFFFF\””; }
echo “<tr”.$print.”>

” . $row[‘FirstName’] . “” . $row[‘LastName’] . “” . $row[‘Team’] . “” . $row[‘Total Games’] . “” . $row[‘Average Goals’] . “” . $row[‘Average Assists’] . “” . $row[‘Average Shots’] . “” . $row[‘Average Turnovers’] . “” . $row[‘Average Takeaways’] . “” . $row[‘Average Blocks’] . ”

\r\n”;
$count++;
}
echo ”

“;
echo ”

“;
mysql_close();
} else if ($vdisps == “d1”) {
$connection = mysql_connect(‘remote-mysql3.servage.net’, ‘qdb2’, ‘QDB2admin999’);
mysql_select_db(‘qdb2’);
$query = “SELECT * FROM TotalBeaterStats”.$champcode.$tdisp.$odisp;
$result = mysql_query($query);
echo ”

2015 MLQ Stats

“;
echo ”

Individual Beater Stats“;
echo ‘

‘;
echo ‘

‘; echo ”

First Name Last Name Team Beats BeatAttempts Avg Range Turnovers Forced Control Lost Control Gained No-Bludgers Forced

\r\n”;
$count=0;
while($row = mysql_fetch_array($result)){
$print=””;
if (($count % 2) == 1) { $print=” bgcolor=\”#DDFFFF\””; }
echo “<tr”.$print.”>

” . $row[‘FirstName’] . “” . $row[‘LastName’] . “” . $row[‘Team’] . “” . $row[‘Beats’] . “” . $row[‘BeatAttempts’] . “” . round($row[‘ABR’],3) . “” . $row[‘TurnoversForced’] . “” . $row[‘ControlLost’] . “” . $row[‘ControlGained’] . “” . $row[‘NoBludgersForced’] . ”

\r\n”;
$count++;
}
echo ”

“;
echo ”

“;
mysql_close();
} else if ($vdisps == “c1”) {
$connection = mysql_connect(‘remote-mysql3.servage.net’, ‘qdb2’, ‘QDB2admin999’);
mysql_select_db(‘qdb2’);
$query = “SELECT * FROM TotalBeaterStatsPerGame”.$champcode.$tdisp.$odisp;
$result = mysql_query($query);
echo ”

2015 MLQ Stats

“;
echo ”

Individual Beater Stats“;
echo ‘

‘;
echo ‘

‘; echo ”

First Name Last Name Team Games Rostered Avg Beats Avg Beat Attempts Avg Range Avg Turnovers Forced Avg Control Lost Avg Control Gained Avg No-Bludgers Forced

\r\n”;
$count=0;
while($row = mysql_fetch_array($result)){
$print=””;
if (($count % 2) == 1) { $print=” bgcolor=\”#DDFFFF\””; }
echo “<tr”.$print.”>

” . $row[‘FirstName’] . “” . $row[‘LastName’] . “” . $row[‘Team’] . “” . $row[‘Total Games’] . “” . $row[‘Average Beats’] . “” . $row[‘Average Beat Attempts’] . “” . round($row[‘ABR’],3) . “” . $row[‘Average Turnovers Forced’] . “” . $row[‘Average Control Lost’] . “” . $row[‘Average Control Gained’] . “” . $row[‘Average No-Bludgers Forced’] . ”

\r\n”;
$count++;
}
echo ”

“;
echo ”

“;
mysql_close();
} else if ($vdisps == “team” || $vdisps == “”) {
$connection = mysql_connect(‘remote-mysql3.servage.net’, ‘qdb2’, ‘QDB2admin999’);
mysql_select_db(‘qdb2’);
$query = “SELECT * FROM TotalTeamStatsS1 “.$tdisp;
$result = mysql_query($query);
echo ”

2015 MLQ Stats

“;
echo ”

Overall Team Stats per game“;
echo ‘

‘;
echo ‘

‘; // start a table tag in the HTML echo ”

TeamOpponentGame#Goals ScoredGoals AllowedOffense TimeDefense TimeTotal Offensive DrivesTotal Defensive DrivesPercent OffensePercent Defense

\r\n”;
//echo $result;
while($row = mysql_fetch_array($result)){ //Creates a loop to loop through results
echo ”

” . $row[‘Team’] . “” . $row[‘Opponent’] . “” . $row[‘GameNumber’] . “” . $row[‘GoalsScored’] . “” . $row[‘GoalsAllowed’] . “” . $row[‘TotalOffTime’] . “” . $row[‘TotalDefTime’] . “” . $row[‘TotalOffDrives’] . “” . $row[‘TotalDefDrives’] . “” . $row[‘PercentOffense’] . “” . $row[‘PercentDefense’] . ”

\r\n”;
}
echo ”

“;
echo ”

“;
mysql_close();
}
[/insert_php]